21.08.2009, 18:24
Hello !
Why this /login command crash my server? :
even if i only type /login , it crash the server. What the heck is wrong?
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; } |