Zaključano

[POMOC] MySQL ili sasvim nesto trece?

Započeo xFORCERx
pre 12 godina
273
pregleda
3
postova
Ova tema je zaključana. Samo moderatori i administratori mogu odgovarati.
sime30
Enforcer
pre 12 godina
Mod koji koristim: Svoj
Detaljan opis problema: Funkcija "SpajanjeNaServer" treba zapoceti provjeru je li igrac registriran itd. Međutim, server se crasha kad dođe do tog dijela.

Testirano na KUCNOM SERVERU

Lokalni MySQL upaljen, sve tablice imam!

Dio moda:


forward SpajanjeNaServer(playerid);
public SpajanjeNaServer(playerid)
{
    new rand = random(sizeof(LoginKamere));
TogglePlayerControllable(playerid, 0);
SetPlayerPos_X(playerid, LoginKamere, LoginKamere, LoginKamere-50);
SetPlayerCameraPos(playerid, LoginKamere, LoginKamere, LoginKamere);
SetPlayerCameraLookAt(playerid, LoginKamere, LoginKamere, LoginKamere);
    if(strfind(GetName(playerid), "_", true) != -1)
{
new ip, upit;
GetPlayerIp(playerid, ip, 24);
format(upit, sizeof(upit), "SELECT * FROM `IP Banovi` WHERE `IP` = '%s'", ip);
mysql_query(upit, MYSQL_IPPROVJERA, playerid);
}
else
{
new string;
format(string, sizeof(string), "{FF0000}Vase ime nije u dopustenome formatu!\n\n{FFFF00}\
Kako se ovo ne bi u buducnosti dogadjalo, procitajte kako Vase ime treba izgledati:\n\n\
  - Vase ime mora biti u formatu {FFFFFF}Ime_Prezime {FFFF00}i obavezno mora sadrzavati donju crtu.\n\
  - Ime ne mora biti Vase pravo ime, ali ne smije biti niti ime neke javne osobe.\n\
  - Ime ne smije sadrzavati ime nekog poznatog brenda i ne smije nikoga vrijedjati.\n\
Primjer dobrog imena: {FFFFFF}Mateo_Dukmenic, Petar_Papic");
SPD(playerid, 9999, DIALOG_STYLE_MSGBOX, "Nedopusteno ime!", string, "U redu", "");
KickEx(playerid);
return 1;
}
return 1;
}



Također mi ne promijeni kameru kao sto je napravljeno da promijeni.
sime30
Enforcer
pre 12 godina

13:10:15] Incoming connection: 192.168.1.5:51504
[13:10:16] Test_Test has joined the server (0:192.168.1.5)
[13:10:16] Server crashed while executing MBO.amx
[13:10:16] AMX backtrace:
[13:10:16] #0 native fwrite () from samp-server.exe
[13:10:16] #1 00052e70 in public OnQueryError (0x0000041e, 0x0013d4b4, 0x00000002, 0x00000000, 0x0013d47c, 0x0013d390, 0x00000001) from MBO.amx
[13:10:16] Native backtrace:
[13:10:16] #0 779c77a2 in ?? () from C:\Windows\SYSTEM32\ntdll.dll
[13:10:16] #1 00492980 in ?? () from C:\Users\xForcer\Desktop\Rad\Modern Balkan - Origin\samp-server.exe
[13:10:16] #2 0040531e in ?? () from C:\Users\xForcer\Desktop\Rad\Modern Balkan - Origin\samp-server.exe


Debug

[13:10:16] >> mysql_query( Connection handle: 1 )

[13:10:16] CMySQLHandler::Query(resultID) - Threaded query with id 1 started. (Extra ID: 0)

[13:10:16] CMySQLHandler::ProcessQueryThread(SELECT * FROM `IP Banovi` WHERE `IP` = '192.168.1.5') - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)

[13:10:16] OnQueryFinish(1,"SELECT * FROM `IP Banovi` WHERE `IP` = '192.168.1.5'") - Called.

[13:10:16] >> mysql_store_result( Connection handle: 1 )

[13:10:16] CMySQLHandler::StoreResult() - Result was stored.

[13:10:16] >> mysql_num_rows( Connection handle: 1 )

[13:10:16] CMySQLHandler::NumRows() - Returned 0 row(s)

[13:10:16] >> mysql_free_result( Connection handle: 1 )

[13:10:16] CMySQLHandler::FreeResult() - Result was successfully free'd.

[13:10:16] >> mysql_query( Connection handle: 1 )

[13:10:16] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0)

[13:10:16] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

[13:10:16] OnQueryError() - Called.
sime30
Enforcer
pre 12 godina
Rijesio sam.
Rjesenje: Krivo sam napisao "Korisnici" u MySQL.

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava