[Pomoc] MySQL...

[System32]

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

[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

[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):

[Rick Dunn aka NaNx]

Jednako se nama desavalo
Pacino je nekak to popravio
Al onda je MYSQL zbog druge stvari zaje******
toplo ti preporucam sqlite

[System32]

ma ebes sqlite, ostajem na ovom

[dragan12]

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:

Kod [Izaberi] Proširi

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

[System32]

heh hvala gagi
evo ovo dobijem u konzoli

[dragan12]

Evo kao sto je jedan rekao

it clearly says that Accounts table doesnt exist.

Znaci nemas kreirano bans valjda sta vec ti radis sa njim ne ja

[Rick Dunn aka NaNx]

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

[dragan12]

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 . To isto