Skripta koju koristim: iStunt
Detaljan opis problema: ma radio ja po onom tut za mySQL onaj vrag i sad je to paradox preuredivao, prebacivao to u PlayerInfo i tako to i kad izadem iz samp-server.exe statsi se restaju, sve je na 0 a u bazi je sve isto :O sta da radim
Dio skripte: uhh ima puno toga, sto treba recite, evo i ovo iz debuga
Citat[08:35:11] ---------------------------
[08:35:11] MySQL Debugging activated (08/13/11)
[08:35:11] ---------------------------
[08:35:11]
[08:35:11] >> mysql_connect( )
[08:35:11] CMySQLHandler::CMySQLHandler() - constructor called.
[08:35:11] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sa-mp" | Username: "root" ...
[08:35:11] CMySQLHandler::Connect() - Connection was successful.
[08:35:11] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[08:35:30] >> mysql_query_callback( Connection handle: 1 )
[08:35:30] CMySQLHandler::Query("sOnQueryFinish") - Custom callback query with index 102 started (ExtraID: 0)
[08:35:30] >> mysql_real_escape_string( Connection handle: 1 )
[08:35:30] CMySQLHandler::EscapeString(System32); - Escaped 8 characters to System32.
[08:35:30] >> mysql_query( Connection handle: 1 )
[08:35:30] CMySQLHandler::Query(SELECT `Korisnik` FROM `playerinfo` WHERE `Korisnik` = 'System32' LIMIT 1) - Successfully executed.
[08:35:30] >> mysql_store_result( Connection handle: 1 )
[08:35:30] CMySQLHandler::StoreResult() - Result was stored.
[08:35:30] >> mysql_num_rows( Connection handle: 1 )
[08:35:30] CMySQLHandler::NumRows() - Returned 1 row(s)
[08:35:30] >> mysql_free_result( Connection handle: 1 )
[08:35:30] CMySQLHandler::FreeResult() - Result was successfully free'd.
[08:35:30] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[08:35:33] >> mysql_real_escape_string( Connection handle: 1 )
[08:35:33] CMySQLHandler::EscapeString(System32); - Escaped 8 characters to System32.
[08:35:33] >> mysql_query( Connection handle: 1 )
[08:35:33] CMySQLHandler::Query(SELECT * FROM `playerinfo` WHERE `Korisnik` = 'System32' AND `Lozinka` = 'pass' LIMIT 1) - Successfully executed.
[08:35:33] >> mysql_store_result( Connection handle: 1 )
[08:35:33] CMySQLHandler::StoreResult() - Result was stored.
[08:35:33] >> mysql_num_rows( Connection handle: 1 )
[08:35:33] CMySQLHandler::NumRows() - Returned 1 row(s)
[08:35:33] >> mysql_fetch_row_format( Connection handle: 1 )
[08:35:33] CMySQLHandler::FetchRow() - Return: System32|pass|890|51|3|0|0|3|0|0|0|192.168.1.233
[08:35:33] >> mysql_free_result( Connection handle: 1 )
[08:35:33] CMySQLHandler::FreeResult() - Result was successfully free'd.
mislim da je ovo problem
Citat[08:35:30] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
ps. ovo mi je bilo u OnGameModeExitu
mysql_close();
makao sam to i opet isto
Neke slike/video za lakse dobivanje pomoci(neobavezno):
Jednako se nama desavalo
Pacino je nekak to popravio
Al onda je MYSQL zbog druge stvari zaje******
toplo ti preporucam sqlite
ma ebes sqlite, ostajem na ovom
Na oficijalnom samp forumu sam nasao ovu temu isto taj error mu izlazio evo pogledaj malo:
http://forum.sa-mp.com/showthread.php?t=186095
Citaj od onog posta gde spominje ovo:
public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle) {
printf("EID: %d | Error: %s | Query: %s", errorid, error, query);
return 1;
}
Pa ces videti sta cete izbaciti o kakvom se erroru radi.
Nisam strucnjak za MySQL pa se i nerazumem u njega. Tek ga ucim ;)
heh hvala gagi
evo ovo dobijem u konzoli
(http://zaslike.com/files/276h89lckzkywi45g.png)
Evo kao sto je jedan rekao
Citatit clearly says that Accounts table doesnt exist.
Znaci nemas kreirano bans valjda sta vec ti radis sa njim ne ja :D
Print the data that is sent to the query error callback. Use/add this code:
pawn Code:
public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle) {
printf("EID: %d | Error: %s | Query: %s", errorid, error, query);
return 1;
}
And see what it shows in the console/log.
tako kaze jedan lik ... pokusaj
Citat: EM|Rick Dunn aka NaNx poslato Avgust 13, 2011, 09:19:17 PRE PODNE
Print the data that is sent to the query error callback. Use/add this code:
pawn Code:
public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle) {
printf("EID: %d | Error: %s | Query: %s", errorid, error, query);
return 1;
}
And see what it shows in the console/log.
tako kaze jedan lik ... pokusaj
Vidi sta sam mu ja napisao gore :P. To isto :P