[Pomoc] MySQL...

Započeo System32

•13. Avg. 2011.

1,097

pregleda

postova

System32

Godfather

Novi Član

240 / 250 XP

🌱Početnik(0)

1,504

Postovi:

Teme:

Pridružio se:Sep. 2010

13. Avg. 2011.

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

Quote

[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:😛rocessQueryThread() - 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

Quote

[08:35:30] CMySQLHandler:😛rocessQueryThread() - 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

Made Man

Novi Član

90 / 100 XP

🌱Početnik(0)

397

Postovi:

Teme:

Pridružio se:Okt. 2009

13. Avg. 2011.

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

System32

Godfather

Novi Član

240 / 250 XP

🌱Početnik(0)

1,504

Postovi:

Teme:

Pridružio se:Sep. 2010

13. Avg. 2011.

ma ebes sqlite, ostajem na ovom

Obrisan korisnik

13. Avg. 2011.

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 😉

System32

Godfather

Novi Član

240 / 250 XP

🌱Početnik(0)

1,504

Postovi:

Teme:

Pridružio se:Sep. 2010

13. Avg. 2011.

heh hvala gagi
evo ovo dobijem u konzoli

Obrisan korisnik

13. Avg. 2011.

Evo kao sto je jedan rekao

Quote

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

Made Man

Novi Član

90 / 100 XP

🌱Početnik(0)

397

Postovi:

Teme:

Pridružio se:Okt. 2009

13. Avg. 2011.

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

Obrisan korisnik

13. Avg. 2011.

EM|Rick Dunn aka NaNx wrote on August 13, 2011, 7:19 am:

Vidi sta sam mu ja napisao gore 😛. To isto 😛

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava