SA-MP Forums Archive
mysql + /login = crash. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: mysql + /login = crash. (/showthread.php?tid=92711)


mysql + /login = crash. - kLx - 21.08.2009

Hello !
Why this /login command crash my server? :
Quote:

dcmd_prisijungti(playerid, params[])
{

if(!strlen(params)) return SendClientMessage(playerid, 0xFF8040FF,"Naudojimas: /prisijungti [slaptaюodis]"); // jei neivestas slaptazodis, parodom sia zinute

if(PLAYERLIST_authed[playerid] == 1) return SendClientMessage(playerid, 0xFF8040FF, "Jыs jau prisijungжs"); // parodom sia zinute

format(query,sizeof(query),"SELECT * FROM nariai WHERE vardas = '%s'",PlayerName(playerid)); // uzklausa su kuria tikrinsime ar zaidejas yra registruotas
samp_mysql_query(query);
samp_mysql_store_result();

if(samp_mysql_num_rows() == 0) return SendClientMessage(playerid,0xFF8040FF,"* Рis slapyvardis nлra registruotas ! Naudokite /registruotis [slaptaюodis]"); // parodome sia zinute

samp_mysql_fetch_row(line);
samp_mysql_get_field("hash", sql);

if(!strcmp(params,sql,false)) return SendClientMessage(playerid,0xFF8040FF,"* Neteisingas slaptaюodis !"); // parasome sia zinute

else if(strcmp(params,sql,true)) {

PLAYERLIST_authed[playerid] = true;
samp_mysql_get_field("pinigai", sql);
pInfo[playerid][Pinigai] = strval(sql);
samp_mysql_get_field("darbas", sql);
pInfo[playerid][Darbas] = strval(sql); // irasome mirtis i kintamaji
samp_mysql_get_field("rankas", sql); // gauname jo pinigu skaiciu
pInfo[playerid][Rankas] = strval(sql); // irasome pinigus i kintamaji
samp_mysql_get_field("miestas", sql); // gauname jo pinigu skaiciu
pInfo[playerid][Miestas] = strval(sql); // irasome pinigus i kintamaji
samp_mysql_get_field("adminas", sql); // gauname jo pinigu skaiciu
pInfo[playerid][Adminas] = strval(sql); // irasome pinigus i kintamaji
samp_mysql_get_field("bankas", sql); // gauname jo pinigu skaiciu
pInfo[playerid][Bankas] = strval(sql); // irasome pinigus i kintamaji
samp_mysql_get_field("vairavimol", sql); // gauname jo pinigu skaiciu
pInfo[playerid][VairavimoL] = strval(sql); // irasome pinigus i kintamaji
samp_mysql_get_field("ginklul", sql); // gauname jo pinigu skaiciu
pInfo[playerid][GinkluL] = strval(sql); // irasome pinigus i kintamaji
samp_mysql_get_field("telnr", sql); // gauname jo pinigu skaiciu
pInfo[playerid][TelNR] = strval(sql); // irasome pinigus i kintamaji
samp_mysql_get_field("bombos", sql); // gauname jo pinigu skaiciu
pInfo[playerid][Bombos] = strval(sql); // irasome pinigus i kintamaji
samp_mysql_get_field("id", sql); // gauname jo pinigu skaiciu
pInfo[playerid][qid] = strval(sql); // irasome pinigus i kintamaji
GivePlayerMoney(playerid, pInfo[playerid][Pinigai]); // duodame zaidejui tiek pinigu kiek turejo pries atsijungdamas is serverio
SendClientMessage(playerid, 0xFF8040FF,"** Sekmingai prisijungete!");

}
return 1;
}
forward Save(playerid);
public Save(playerid)
{
format(query,sizeof(query),"UPDATE nariai SET darbas = %d, rankas = %d, miestas = %d, pinigai = %d, adminas = %d, bankas = %d, vairavimol = %d, ginklul = %d, bombos = %d WHERE id = %d",pInfo[playerid][Darbas],pInfo[playerid][Rankas],pInfo[playerid][Miestas],GetPlayerMoney(playerid), pInfo[playerid][Adminas], pInfo[playerid][Bankas], pInfo[playerid][VairavimoL], pInfo[playerid][GinkluL], pInfo[playerid][qid]); // uzklausa kuri papildys informacija duomenu bazeje, butent tam vartotojui kuris nurodytas.
samp_mysql_query(query); // vykdom uzklausa
return 1;
}
even if i only type /login , it crash the server. What the heck is wrong?