Wysłany: 2016-10-18, 19:54
Szymon9910911
Wiek: 25 Na forum: 4138 dni Posty: 251
Nick w MP: Tetral [you]
Piwa : 9
Witam ma problem poniewa? mysql nie wykonuje tych polece?. TZn nie tworzy tabel
a po wykonaniu tego dialogu nie pokazuje si? nast?pny dialog z Regulaminem za pomoc piwko
Pawn if( dialogid == GUI_EMAIL )
{
if( response == 1 )
{
if( strlen ( inputtext ))
{
//new escpass[100];
//mysql_real_escape_string(inputtext, escpass);
new Query [ 300 ];
mysql_real_escape_string ( pInfo [ playerid ][ Nick ], pInfo [ playerid ][ Nick ]);
format ( Query , sizeof ( Query ), "INSERT INTO `zabezpieczenia` (`nick`, `email`, `ip`) VALUES('%s', '%d', '%s')" , pInfo [ playerid ][ Nick ], inputtext , pInfo [ playerid ][ IP ]);
mysql_query ( Query );
ShowPlayerDialog ( playerid , GUI_REGULAMIN , DIALOG_STYLE_MSGBOX , "Regulamin" , Regulamin (), "Akceptuj?" , "Odrzucam" );
}
else
{
ShowPlayerDialog ( playerid , GUI_EMAIL , DIALOG_STYLE_INPUT , "Enail" , "Wprowadz e-mail ,kt?ry b?dziesz m?g? u?y? aby przywr?ci? has?o." , "Akceptuj?" , "Odrzucam" );
}
}
else
{
new DeletePlayer [ 46 ], DeletePlayer2 [ 46 ];
format ( DeletePlayer , sizeof ( DeletePlayer ), "DELETE FROM `Gracze` WHERE `nick` = '%s'" , NazwaGracza ( playerid ));
mysql_free_result ();
mysql_query ( DeletePlayer );
format ( DeletePlayer2 , sizeof ( DeletePlayer2 ), "DELETE FROM `zabezpieczenia` WHERE `nick` = '%s'" , NazwaGracza ( playerid ));
mysql_free_result ();
mysql_query ( DeletePlayer2 );
}
}
Wysłany: 2016-10-18, 22:46
Combacior
Wiek: 29 Na forum: 5796 dni Posty: 1516
Piwa : 2161
Poka? logi z MySQL oraz funkcj? Regulamin. Lepiej jakby? tam wpisa? normalny tekst zamiast odwo?ywa? si? do funkcji.
Wysłany: 2016-10-18, 23:01
Szymon9910911
Wiek: 25 Na forum: 4138 dni Posty: 251
Nick w MP: Tetral [you]
Piwa : 9
Funkcja to nic innego jak stock regulamin a w nim strcat (buffer, tekst); return buffer
[ Dodano : 2016-10-18, 23:02 ]
A co do log?w mysql to w?a?nie w konsoli nic si? nie wy?wietla
Wysłany: 2016-10-19, 09:40
NitroFuN
El Barto
Wiek: 25 Na forum: 4127 dni Posty: 532
Piwa : 1195
Nie masz mysql_log.txt? Jakiego pluginu mysql u?ywasz?
Podpis
GG: 61963221 - Discord: NitroFuN#2819
Gracz SA:MP - 2010-2019
Support Team - 26.11.2017 - 16.01.2018
Wysłany: 2016-10-19, 14:47
Szymon9910911
Wiek: 25 Na forum: 4138 dni Posty: 251
Nick w MP: Tetral [you]
Piwa : 9
By strickid
[ Dodano : 2016-10-19, 15:03 ]
jednak sa logi w konsoli
Kod: [19:50] [MySQL] Error (0): Failed to exeute query. MySQL server has gone away.
[19:50] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. MySQL server has gone away.
[19:50] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. MySQL server has gone away.
[19:50] [MySQL] Error (0): Failed to exeute query. MySQL server has gone away.
[19:50] [MySQL] Error (0): Failed to exeute query. MySQL server has gone away.
[19:50] [MySQL] Error (0): Failed to exeute query. MySQL server has gone away.
w mysqlog Kod: [Wed Oct 19 14:54:31 2016] -------------------------
[Wed Oct 19 14:54:31 2016] Logging Started
[Wed Oct 19 14:54:31 2016] -------------------------
[Wed Oct 19 14:54:32 2016] Function: mysql_init executed with result: "0".
[Wed Oct 19 14:54:32 2016] Connected (0) to via TCP/IP.
[Wed Oct 19 14:54:32 2016] MySQL Server Version 5.5.5-10.1.17-MariaDB-1~wheezy.
[Wed Oct 19 14:54:32 2016] Function: mysql_stat executed with result: "Uptime: 3113869 Threads: 179 Questions: 240900059 Slow queries: 0 Opens: 1179176 Flush tables: 2 Open tables: 1000 Queries per second avg: 77.363".
[Wed Oct 19 14:59:29 2016] Function: mysql_real_esacpe_string executed: ***** with result: *****
[Wed Oct 19 14:59:29 2016] Function: mysql_query executed: "SELECT `nick` FROM `playerdata` WHERE `nick` COLLATE latin1_general_cs = '****' LIMIT 1" with result: "1".
[Wed Oct 19 14:59:29 2016] Error (0): Failed to exeute query. Table '580598_Gracze.playerdata' doesn't exist.
[Wed Oct 19 14:59:29 2016] Error (0): Function: mysql_store_result called when no prior successful query executed. Table '580598_Gracze.playerdata' doesn't exist.
[Wed Oct 19 14:59:29 2016] Error (0): Function: mysql_num_rows called when no result stored. Table '580598_Gracze.playerdata' doesn't exist.
[Wed Oct 19 14:59:29 2016] Function: mysql_free_result executed.
[Wed Oct 19 14:59:38 2016] Function: mysql_real_esacpe_string executed: "*****" with result: "*****".
[Wed Oct 19 14:59:38 2016] Function: mysql_real_esacpe_string executed: "*****" with result: "*****".
[Wed Oct 19 14:59:38 2016] Function: mysql_real_esacpe_string executed: "*****" with result: "*****".
[Wed Oct 19 14:59:38 2016] Function: mysql_query executed: "INSERT INTO `Gracze` (`nick`, `password`, `ip`) VALUES('*****', '*****', '*****')" with result: "0".
[Wed Oct 19 14:59:45 2016] Function: mysql_real_esacpe_string executed: "*****" with result: "*****".
[Wed Oct 19 14:59:45 2016] Function: mysql_query executed: "INSERT INTO `zabezpieczenia` (`nick`, `email`, `ip`) VALUES('*****', '*****', '*****')" with result: "0".
[Wed Oct 19 14:59:51 2016] Function: mysql_real_esacpe_string executed: "*****" with result: "*****".
[Wed Oct 19 14:59:51 2016] Function: mysql_query executed: "UPDATE `zabezpieczenia` SET `Pytanie Zabezpieczajace` = '*****' WHERE `nick` = '*****'" with result: "0".
[ Dodano : 2016-10-19, 15:43 ]
regulamin naprawi?em ju? dzia?a ale co? nadal z zapisem
[ Dodano : 2016-10-19, 16:00 ]
i pytanie dlaczego zamiast stringu w mysql mi daje jakie? liczby ?
[ Dodano : 2016-10-19, 16:28 ]
np wpisuej e-mail [email protected] a w mysql pokazuje 115 ? pr?bowa?em mysql_real_escape_string ale te? nic
[ Dodano : 2016-10-19, 19:53 ]
znalaz?em b??d do zamkni?cia
[ Dodano : 2016-10-19, 20:16 ]
ale za to mam nast?pne pytanie
jak zrobi? ca?? ekipe ? czyli osoby kt?e maj? admina wiem , ?e p?tla maxplayers i tam da? zapytanie do mysql zeby wzielo osoby z ranga admina. Lecz nie wiem jak zrobi? takie zapytanie
[ Dodano : 2016-10-19, 20:41 ]
Kod: select Nick from Gracze where Uprawnienia >= 1
takie co? by by?o dobre?
[ Dodano : 2016-10-21, 16:57 ]
przepraszam, czy mo?ecie mi pom?c z tym erorem ? Kod: [Fri Oct 21 16:54:00 2016] Error (0): Failed to exeute query. MySQL server has gone away.
Tagi: mysql
Anonymous
Na forum: 245 dni
Posty: 1
Anonymous Koniecznie zajrzyj na: