Problema register/login

[RedStar]

Problemă întâlnită (descriere): Ma inregistrez totul bine , cand reintru imi cere parola ma loghez , iar de aici incepe problema imi cere iar chestiile de la register masculin , cati ani ai , tutorial si astea..le bag mereu si dupa este ok..m-am uitat prin gm totul este ok chiar nu imi dau seama , daca m-ati putea ajuta va rog..Daca vreti vreun script pt a ma ajuta spune-ti .. Multumesc mult.
Ero(area / rile) / warning-(ul / urile): -
Liniile de cod / sursa / script-ul: -
Imagini / Video (optional): -
Aţi încercat să rezolvaţi singur?: Da , si acum incerc..

[Джо]

O intrebare,folosesti baza de date la serverul tau?

[RedStar]

O intrebare,folosesti baza de date la serverul tau?

Da

[WiDuAlK]

Ia posteaza si tu dialogurile de Register / login / si celelalte de la ani , sex , spawn sau ce mai ai tu

[RedStar]

Ia posteaza si tu dialogurile de Register / login / si celelalte de la ani , sex , spawn sau ce mai ai tu

[pawn]public OnPlayerRequestClass(playerid, classid)

{

new string[182];

PlayerData[playerid][pModel] = Peds[classid][0];

if (RegistrationStep[playerid] == 0 && gPlayerLogged[playerid] != 1)

{

if (gPlayerAccount[playerid] != 0)

{

new loginstring[182];

new loginname[182];

GetPlayerName(playerid,loginname,sizeof(loginname));

format(loginstring,sizeof(loginstring),"{a9c4e4}Bun venit inapoi pe BLoWn RPG n{a9c4e4}Cont:{ee5555} %s n{a9c4e4}Acest cont este inregistratnUltimul login: {ee5555}%s",loginname,PlayerData[playerid][pUltLog]);

ShowPlayerDialog(playerid,12346,DIALOG_STYLE_PASSWORD,"{00FE37}Login",loginstring,"Login","Exit");

}

else

{

gPlayerAccount[playerid] = 0;

new regstring[182];

new regname[182];

GetPlayerName(playerid,regname,sizeof(regname));

format(regstring,sizeof(regstring),"{D7F0F1}Bine ai venit,{06CCF9} %s{D7F0F1}nAcest cont nu este inregistrat.n ",regname);

ShowPlayerDialog(playerid,12345,DIALOG_STYLE_PASSWORD,"{00F6FE}Register",regstring,"Register","Exit");

}

PlayerData[playerid][pModel] = Peds[classid][0];

PlayerData[playerid][pChar] = Peds[classid][0];

SetPlayerTeamFromClass(playerid,classid);

SetPlayerWeather(playerid, 0);

}

if (classid == 1)

{

format(string, sizeof(string), "");

GameTextForPlayer(playerid,string,3500,6);

}

else if (classid == 2)

{

format(string, sizeof(string), "");

GameTextForPlayer(playerid,string,3500,6);

}

else if (classid == 3)

{

format(string, sizeof(string), "");

GameTextForPlayer(playerid,string,3500,6);

}

else if (classid == 4)

{

format(string, sizeof(string), "");

GameTextForPlayer(playerid,string,3500,6);

}

else if (classid == 5)

{

format(string, sizeof(string), "");

GameTextForPlayer(playerid,string,3500,6);

}

else if (classid == 6)

{

format(string, sizeof(string), "");

GameTextForPlayer(playerid,string,3500,6);

}

else if (classid == 7)

{

format(string, sizeof(string), "");

GameTextForPlayer(playerid,string,3500,6);

}

else if (classid == 8)

{

format(string, sizeof(string), "");

GameTextForPlayer(playerid,string,3500,6);

}

else if (classid == 9)

{

format(string, sizeof(string), "");

GameTextForPlayer(playerid,string,3500,6);

}

else if (classid == 10)

{

format(string, sizeof(string), "");

GameTextForPlayer(playerid,string,3500,6);

}

else if (classid == 11)

{

format(string, sizeof(string), "");

GameTextForPlayer(playerid,string,3500,6);

}

else if (classid == 12)

{

format(string, sizeof(string), "");

GameTextForPlayer(playerid,string,3500,6);

}

else if (classid == 13)

{

format(string, sizeof(string), "");

GameTextForPlayer(playerid,string,3500,6);

}

else if (classid == 14)

{

format(string, sizeof(string), "");

GameTextForPlayer(playerid,string,3500,6);

}

else if (classid == 15)

{

format(string, sizeof(string), "");

GameTextForPlayer(playerid,string,3500,6);

}

else if (classid == 16)

{

format(string, sizeof(string), "");

GameTextForPlayer(playerid,string,3500,6);

}

else

{

format(string, sizeof(string), "");

GameTextForPlayer(playerid,string,3500,6);

}

SetPlayerTeamFromClass(playerid,classid);

SetupPlayerForClassSelection(playerid);

return 1;

}[/pawn]

[pawn]public OtherTimer()

{

new string[182];

//format(string,sizeof(string),"UPDATE players SET AdminLevel='6' WHERE id=2048");

//mysql_query(string);

new Float:oldposx, Float:oldposy, Float:oldposz;

foreach(Player, i)

{

if(SafeTime > 0)

{

SafeTime--;

}

if(SafeTime == 1)

{

if(gPlayerAccount == 1 && gPlayerLogged == 0)

{

new loginname[182];

new loginstring[182];

GetPlayerName(i,loginname,64);

format(loginstring,sizeof(loginstring),"Bine ai venit,{06CCF9} %s{FFFFFF}nAcum poti sa te loghezi pe cont:",loginname);

ShowPlayerDialog(i,12346,DIALOG_STYLE_PASSWORD,"{1E90FF}L{FFFFFF}ogeaza-te",loginstring,"Login","Exit");

}

}[/pawn]

[pawn]public OnPlayerLogin(playerid,password[])

{

new hour,minute,second;

gettime(hour,minute,second);

MySQLCheckConnection();

new string2[256];

new tmp2[182];

MySQLFetchAcctSingle(PlayerData[playerid][pSQLID], "Password", PlayerData[playerid][pKey]);

//format(string2, sizeof(string2), "DEBUG: PASSED1 , Password from MySQL : %s", PlayerData[playerid][pKey]);

//SendClientMessage(playerid, -1, string2);

if(!strcmp(PlayerData[playerid][pKey],password, false) && strlen(password) != 0)

{

//format(string2, sizeof(string2), "DEBUG: PASSED2 , Password from MySQL : %s", password);

//SendClientMessage(playerid, -1, string2);

new Query[256];

format(Query, sizeof(Query), "SELECT * FROM players WHERE id= %d", PlayerData[playerid][pSQLID]);

mysql_query(Query); // Querys the "Query" Variable.

mysql_store_result(); // Stores the result from Query

if(mysql_num_rows()) // Checks if theres anyrow.

if(mysql_fetch_row_format(Query,"|")) // Splits the row

{

sscanf(Query, "p<|>e",PlayerData[playerid]);

}

MySQLUltLog(PlayerData[playerid][pSQLID], "MarriedTo", PlayerData[playerid][pMarriedTo]);

mysql_store_result();

MySQLUltLog(PlayerData[playerid][pSQLID], "Email", PlayerData[playerid][pEmail]);

mysql_store_result();

}

else

{

new loginstring[182];

new loginname[182];

GetPlayerName(playerid,loginname,sizeof(loginname));

format(loginstring,sizeof(loginstring),"PAROLA GRESITAnTe rog baga parola corecta:",loginname);

ShowPlayerDialog(playerid,12347,DIALOG_STYLE_PASSWORD,"{1E90FF}L{FFFFFF}ogeaza-te",loginstring,"Login","Exit");

gPlayerLogTries[playerid] += 1;

if(gPlayerLogTries[playerid] == 4) { Kick(playerid); }

return 1;

}[/pawn][182]s[182]iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii>

[pawn]public OnPlayerUpdateEx(playerid)

{

if(IsPlayerConnected(playerid))

{

if(gPlayerLogged[playerid])

{

MySQLCheckConnection();

new skin = GetPlayerSkin(playerid);

new query[MAX_PLAYERS];

PlayerData[playerid][pModel] = skin;

PlayerData[playerid][pChar] = skin;

format(query, sizeof(query), "UPDATE players SET Model='%d' WHERE id=%d", PlayerData[playerid][pModel], PlayerData[playerid][pSQLID]);

mysql_query(query);

format(query, sizeof(query), "UPDATE players SET Chara='%d' WHERE id=%d", PlayerData[playerid][pChar], PlayerData[playerid][pSQLID]);

mysql_query(query);

return 1;

}

return 1;

}

return 1;

}

[/pawn]

[pawn]public OnPlayerRegister(playerid, password[])

{

if(IsPlayerConnected(playerid))

{

MySQLCheckConnection();

new playername3[MAX_PLAYER_NAME];

GetPlayerName(playerid, playername3, sizeof(playername3));

new newaccountsqlid = MySQLCreateAccount(playername3, password, playerid);

if (newaccountsqlid != 0)

{

new loginstring[182];

PlayerData[playerid][pSQLID] = newaccountsqlid;

strmid(PlayerData[playerid][pKey], password, 0, strlen(password), 33);

OnPlayerUpdateEx(playerid);

format(loginstring,sizeof(loginstring),"{6BF45F}Bun venit pe serverul {FF0000}BLoWn RPG ,{EBBB5A} %s{6BF45F}nAcest nick este inregistrat.",playername3);

ShowPlayerDialog(playerid,12346,DIALOG_STYLE_PASSWORD,"Logeaza-te",loginstring,"Login","Exit");

return 1;

}

else

{

gPlayerAccount[playerid] = 0;

new regstring[182];

new regname[182];

GetPlayerName(playerid,regname,sizeof(regname));

format(regstring,sizeof(regstring),"{FFFFFF}Bine ai venit,{57F906} %s{FFFFFF}nNu ai cont.",regname);

ShowPlayerDialog(playerid,12345,DIALOG_STYLE_PASSWORD,"{1E90FF}Inregistreaza-te",regstring,"Register","Exit");

}

}

return 0;

}[/pawn]

[pawn] if(dialogid == 721)

{

if(response)

{

new varsta = strval(inputtext);

new string[182];

new query[MAX_STRING];

new nume[182];

if(varsta >6 && varsta<51)

{

format(string,256,"Ok, deci ai %d ani.",varsta);

SendClientMessage(playerid,COLOR_WHITE,string);

PlayerData[playerid]

---

= varsta;

RegistrationStep[playerid] = 3;

GetPlayerName(playerid, nume, sizeof(nume));

new mysqlaccountstatus = MySQLCheckAccount(nume);

PlayerData[playerid][pSQLID] = mysqlaccountstatus;

format(query, sizeof(query), "UPDATE players SET Age='%d' WHERE id=%d", PlayerData[playerid]

---

, PlayerData[playerid][pSQLID]);

mysql_query(query);

ShowPlayerDialog(playerid,102,DIALOG_STYLE_LIST,"{08F618}Unde vrei sa ai spawn-ul?","{F60808}1. {FFFFFF}Los Santosrn{F60808}2. {FFFFFF}San Fierro","Select", "");

}

else

{

ShowPlayerDialog(playerid,721,DIALOG_STYLE_INPUT,"Varsta","{77A3F0}2. Cati ani ai?(7-50)","OK","");

}

}

}

if(dialogid == 101)

{

if(!response)

{

Kick(playerid);

return 1;

}

switch(listitem)

{

case 0:

{

PlayerData[playerid]

---

= 12;

}

case 1:

{

PlayerData[playerid]

---

= 13;

}

case 2:

{

PlayerData[playerid]

---

= 14;

}

case 3:

{

PlayerData[playerid]

---

= 15;

}

case 4:

{

PlayerData[playerid]

---

= 16;

}

case 5:

{

PlayerData[playerid]

---

= 17;

}

case 6:

{

PlayerData[playerid]

---

= 18;

}

case 7:

{

PlayerData[playerid]

---

= 19;

}

case 8:

{

PlayerData[playerid]

---

= 20;

}

case 9:

{

PlayerData[playerid]

---

= 21;

}

case 10:

{

PlayerData[playerid]

---

= 22;

}

}

RegistrationStep[playerid] = 3;

new query[MAX_STRING];

new nume[182];

GetPlayerName(playerid, nume, sizeof(nume));

new mysqlaccountstatus = MySQLCheckAccount(nume);

PlayerData[playerid][pSQLID] = mysqlaccountstatus;

format(query, sizeof(query), "UPDATE players SET Age='%d' WHERE id=%d", PlayerData[playerid]

---

, PlayerData[playerid][pSQLID]);

mysql_query(query);

ShowPlayerDialog(playerid,102,DIALOG_STYLE_LIST,"{30F511}Unde vrei sa ai spawn-ul?","{F60808}1. {FFFFFF}Los Santosrn{F60808}2. {FFFFFF}San Fierro","Select", "");

return 1;

}

if(dialogid == 102)

{

if(!response)

{

Kick(playerid);

return 1;

}

switch(listitem)

{

case 0:

{

PlayerData[playerid][pOrigin] = 1;

RegistrationStep[playerid] = 0;

TutTime[playerid] = 1;

new query[MAX_STRING];

format(query, sizeof(query), "UPDATE players SET Origin='%d' WHERE id=%d", PlayerData[playerid][pOrigin], PlayerData[playerid][pSQLID]);

mysql_query(query);

return 1;

}

case 1:

{

PlayerData[playerid][pOrigin] = 2;

RegistrationStep[playerid] = 0;

TutTime[playerid] = 1;

new query[MAX_STRING];

format(query, sizeof(query), "UPDATE players SET Origin='%d' WHERE id=%d", PlayerData[playerid][pOrigin], PlayerData[playerid][pSQLID]);

mysql_query(query);

return 1;

}

}

}

if(dialogid == 100)

{

if(!response)

{

Kick(playerid);

return 1;

}

switch(listitem)

{

case 0:

{

PlayerData[playerid][pSex] = 1;

PlayerData[playerid][pChar] = 289;

SetPlayerSkin(playerid, 289);

new query[MAX_PLAYERS];

format(query, sizeof(query), "UPDATE players SET Sex='%d' WHERE id=%d", PlayerData[playerid][pSex], PlayerData[playerid][pSQLID]);

mysql_query(query);

format(query, sizeof(query), "UPDATE players SET Chara='%d' WHERE id=%d", PlayerData[playerid][pChar], PlayerData[playerid][pSQLID]);

mysql_query(query);

//ShowPlayerDialog(playerid,101,DIALOG_STYLE_LIST,"{1E90FF}C{FFFFFF}are este varsta ta?","{1E90FF}1. {FFFFFF}12rn{1E90FF}2. {FFFFFF}13rn{1E90FF}3. {FFFFFF}14rn{1E90FF}4. {FFFFFF}15rn{1E90FF}5. {FFFFFF}16rn{1E90FF}6. {FFFFFF}17rn{1E90FF}7. {FFFFFF}18rn{1E90FF}8. {FFFFFF}19rn{1E90FF}9. {FFFFFF}20rn{1E90FF}10. {FFFFFF}21rn{1E90FF}11. {FFFFFF}22","Select", "");

ShowPlayerDialog(playerid,721,DIALOG_STYLE_INPUT,"t","{F9F7CE}n{77A3F0} Cati ani ai?(7-50)","OK","");

}

case 1:

{

PlayerData[playerid][pSex] = 2;

PlayerData[playerid][pChar] = 56;

SetPlayerSkin(playerid, 56);

new query[MAX_PLAYERS];

format(query, sizeof(query), "UPDATE players SET Sex='%d' WHERE id=%d", PlayerData[playerid][pSex], PlayerData[playerid][pSQLID]);

mysql_query(query);

format(query, sizeof(query), "UPDATE players SET Chara='%d' WHERE id=%d", PlayerData[playerid][pChar], PlayerData[playerid][pSQLID]);

mysql_query(query);

ShowPlayerDialog(playerid,101,DIALOG_STYLE_LIST,"{1E90FF}C{FFFFFF}are este varsta ta?","{1E90FF}1. {FFFFFF}12rn{1E90FF}2. {FFFFFF}13rn{1E90FF}3. {FFFFFF}14rn{1E90FF}4. {FFFFFF}15rn{1E90FF}5. {FFFFFF}16rn{1E90FF}6. {FFFFFF}17rn{1E90FF}7. {FFFFFF}18rn{1E90FF}8. {FFFFFF}19rn{1E90FF}9. {FFFFFF}20rn{1E90FF}10. {FFFFFF}21rn{1E90FF}11. {FFFFFF}22","Select", "");

}

}

}[/pawn]

[pawn] if(dialogid == 12346 || dialogid == 12347)

{

if(!response)

{

Kick(playerid);

return 1;

}

if((strlen(inputtext) > 0) && (strlen(inputtext) < 25))

{

new ok = 1;

for(new i=0;i {

if(!IsALetter(inputtext))

ok = 0;

}

if(ok == 1)

{

new tmppass[182];

strmid(tmppass, inputtext, 0, strlen(inputtext), 255);

OnPlayerLogin(playerid,tmppass);

}

else

{

new loginstring[182];

new loginname[182];

GetPlayerName(playerid,loginname,sizeof(loginname));

format(loginstring,sizeof(loginstring),"Parola Incorecta!nTe tog baga parola corecta:",loginname);

ShowPlayerDialog(playerid,12347,DIALOG_STYLE_PASSWORD,"{1E90FF}L{FFFFFF}ogeaza-te",loginstring,"Login","Exit");

gPlayerLogTries[playerid] += 1;

if(gPlayerLogTries[playerid] == 5) { Kick(playerid); }

}

}

else

{

new loginstring[182];

new loginname[182];

GetPlayerName(playerid,loginname,sizeof(loginname));

format(loginstring,sizeof(loginstring),"Parola Incorecta!nTe rog baga parola corecta:",loginname);

ShowPlayerDialog(playerid,12347,DIALOG_STYLE_PASSWORD,"{1E90FF}L{FFFFFF}ogeaza-te",loginstring,"Login","Exit");

gPlayerLogTries[playerid] += 1;

if(gPlayerLogTries[playerid] == 5) { Kick(playerid); }

}

}

if(dialogid == 12345)

{

if(!response)

{

Kick(playerid);

return 1;

}

if((strlen(inputtext) > 0) && (strlen(inputtext) < 25))

{

GetPlayerName(playerid, sendername, sizeof(sendername));

new sqlaccountexists = MySQLCheckAccount(sendername);

if (sqlaccountexists != 0)

{

SendClientMessage(playerid, COLOR_YELLOW, "Acel nume este deja luat, te rog alege altul.");

return 1;

}

new tmppass[182];

//if(strfind(inputtext, "|", true) != -1)

new ok = 1;

for(new i=0;i {

if(!IsALetter(inputtext))

ok = 0;

}

if(ok == 0)

{

gPlayerAccount[playerid] = 0;

new regstring[182];

new regname[182];

GetPlayerName(playerid,regname,sizeof(regname));

format(regstring,sizeof(regstring),"Bine ai venit, %snNu ai cont.:",regname);

ShowPlayerDialog(playerid,12345,DIALOG_STYLE_PASSWORD,"{1E90FF}Inregistreaza-te",regstring,"Register","Exit");

}

else

{

strmid(tmppass, inputtext, 0, strlen(inputtext), 255);

OnPlayerRegister(playerid,tmppass);

}

}

else

{

new regstring[182];

new regname[182];

GetPlayerName(playerid,regname,sizeof(regname));

format(regstring,sizeof(regstring),"Bine ai venit,{06F93E} %snNu Ai Cont.",regname);

ShowPlayerDialog(playerid,12345,DIALOG_STYLE_PASSWORD,"{30F511}Inregistreaza-te",regstring,"Register","Exit");

}

}[/pawn](inputtext);i++)

(inputtext);i++)

[pawn] if(PlayerData[playerid][pTut] == 0)

{

gOoc[playerid] = 1; gNews[playerid] = 1; gFam[playerid] = 1;

TogglePlayerControllable(playerid, 0);

RegistrationStep[playerid] = 1;

ShowPlayerDialog(playerid,100,DIALOG_STYLE_LIST,"{08F618}Care este sex-ul tau?","{F63C08}1. {FFFFFF}Masculinrn{F63C08}2. {FFFFFF}Feminin","Select", "");

//SetTimerEx("OprestePlayer", 2000, false, "i", playerid);

OprestePlayer(playerid);

}[/pawn]

[RedStar]

Ma poate ajuta si pe mine cineva , va rog mult ..

[WiDuAlK]

Eu din cate vad pare totul norumal ... nu stiu de ce ti se intampla , sau nu imi dau seama

[WopsS]

In MySQL log ce zice?

[RedStar]

Nu cred ca am..adica cel putin nu l-am gasit

In MySQL log ce zice?

[WopsS]

Ce versiune de MySQL folosesti?

[RedStar]

5.6.16 - MySQL

 

Ce versiune de MySQL folosesti?

[WopsS]

Eu ma refer la versiunea lui BlueG...

[RedStar]

Sunt incepator pe mysql..unde pot afla ce versiune este?

[WopsS]

Cand pornesti server-ul trebuie sa scrie "MySQL Rx loaded."

[RedStar]

R5

[WopsS]

La [pawn]OnGameModeInit[/pawn] pune [pawn]mysql_debug(1);[/pawn]

[RedStar]

Am deja pus..tin sa precizez ca inainte nu facea asa..am sters o factiune si a trebuit sa le reeditez numerele,am adaugat si un /gps cu dialog , din astea poate a afectat

[WopsS]

Ultima parte din tutorial si din login, parte aia cu masculin, etc.

[RedStar]

[pawn] else if(TutTime == 119)
{
ClearChatbox(i, 15);
TextDrawHideForPlayer(i, texts);
TextDrawHideForPlayer(i, box01);
TextDrawHideForPlayer(i, rpg1);
SendClientMessage(i, COLOR_LIGHTGREEN, "_____________________ |Sfarsit| __________________________________ ");
SendClientMessage(i, COLOR_YELLOW2, "{a9c4e4}Sper ca ai inteles cate ceva din RolePlay.");
SendClientMessage(i, COLOR_YELLOW2, "{a9c4e4}Daca ai o nelamurire foloseste /ajutor.");
SendClientMessage(i, COLOR_YELLOW2, "{a9c4e4}BLoWn iti ureaza distractie placuta .");
SendClientMessage(i, COLOR_LIGHTGREEN, "__________________________________________________________________ ");
TogglePlayerSpectating(i, 0);
TutTime = 0; PlayerData[pTut] = 1;
gOoc = 0; gNews = 0; gFam = 0;
TogglePlayerControllable(i, 1);
MedicBill = 0;
SetPlayerSpawn(i);
GivePlayerCash(i, 6000);
SetCameraBehindPlayer(i);
PlayerData[pMSG] = 0;

if(PlayerData[pOrigin] == 1)
{
SetPlayerCheckpoint(i,1413.3684,-1700.7410,13.5423,7.0);
}
else if(PlayerData[pOrigin] == 2)
{
SetPlayerCheckpoint(i,-2084.10,67.28,34.27,7.0);
}
SendClientMessage(i, COLOR_WHITE, "{ee5555}Ti-am pus un checkpoint pe map. Dute la el si da examenul pentru permisul de conducere.");
format(string, sizeof(string), "UPDATE players SET Tutorial='%d' WHERE id=%d", PlayerData[pTut], PlayerData[pSQLID]);
mysql_query(string);
format(string, sizeof(string), "UPDATE players SET MSG='%d' WHERE id=%d", PlayerData[pMSG], PlayerData[pSQLID]);
mysql_query(string);
}
}[/pawn]

[pawn] if(PlayerData[playerid][pTut] == 0)
{
gOoc[playerid] = 1; gNews[playerid] = 1; gFam[playerid] = 1;
TogglePlayerControllable(playerid, 0);
RegistrationStep[playerid] = 1;
ShowPlayerDialog(playerid,100,DIALOG_STYLE_LIST,"{08F618}Care este sex-ul tau?","{F63C08}1. {FFFFFF}Masculinrn{F63C08}2. {FFFFFF}Feminin","Select", "");
//SetTimerEx("OprestePlayer", 2000, false, "i", playerid);
OprestePlayer(playerid);
}[/pawn]

[WopsS]

Aici [pawn]format(string, sizeof(string), "UPDATE players SET Tutorial='%d' WHERE id=%d", PlayerData[pTut], PlayerData[pSQLID]);[/pawn] nu face correct update. Incearca asa [pawn]format(string, sizeof(string), "UPDATE players SET Tutorial='1' WHERE id=%d", PlayerData[pSQLID]);[/pawn]

[RedStar]

Aici [pawn]format(string, sizeof(string), "UPDATE players SET Tutorial='%d' WHERE id=%d", PlayerData[pTut], PlayerData[pSQLID]);[/pawn] nu face correct update. Incearca asa [pawn]format(string, sizeof(string), "UPDATE players SET Tutorial='1' WHERE id=%d", PlayerData[pSQLID]);[/pawn]

Am incercat si asa..degeaba mersi pentru ca macar tu incerci sa ma ajuti

[WopsS]

Te-ai uitat in mysql_log ce zice?

[RedStar]

Nu stiu unde il gasesc ca in baza de date nu am asa ceva..

[WopsS]

In server-ul de samp.

[RedStar]

[pawn][19:18:14] >> mysql_ping( Connection handle: 1 )

[19:18:14] CMySQLHandler::Ping() - Connection is still alive.

[19:18:14] >> mysql_query( Connection handle: 1 )

[19:18:14] CMySQLHandler::Query(UPDATE players SET MarriedTo='No-one' WHERE id=0) - Successfully executed.

[19:18:14] >> mysql_query( Connection handle: 1 )

[19:18:14] CMySQLHandler::Query(UPDATE players SET Married='0' WHERE id=0) - Successfully executed.

[19:18:14] >> mysql_query( Connection handle: 1 )

[19:18:14] CMySQLHandler::Query(SELECT * FROM banuri WHERE TIP=2 AND PlayerIP='192.168.0.101') - Successfully executed.

[19:18:14] >> mysql_store_result( Connection handle: 1 )

[19:18:14] CMySQLHandler::StoreResult() - Result was stored.

[19:18:14] >> mysql_real_escape_string( Connection handle: 1 )

[19:18:14] CMySQLHandler::EscapeString(test); - Escaped 4 characters to test.

[19:18:14] >> mysql_query( Connection handle: 1 )

[19:18:14] CMySQLHandler::Query(SELECT id FROM players WHERE LOWER(Name) = LOWER('test') LIMIT 1) - Successfully executed.

[19:18:14] >> mysql_store_result( Connection handle: 1 )

[19:18:14] CMySQLHandler::StoreResult() - Result was stored.

[19:18:14] >> mysql_num_rows( Connection handle: 1 )

[19:18:14] CMySQLHandler::NumRows() - Returned 1 row(s)

[19:18:14] >> mysql_fetch_row_format( Connection handle: 1 )

[19:18:14] CMySQLHandler::FetchRow() - Return: 5

[19:18:14] >> mysql_real_escape_string( Connection handle: 1 )

[19:18:14] CMySQLHandler::EscapeString(test); - Escaped 4 characters to test.

[19:18:14] >> mysql_query( Connection handle: 1 )

[19:18:14] CMySQLHandler::Query(SELECT Allow FROM players WHERE LOWER(Name) = LOWER('test') LIMIT 1) - Successfully executed.

[19:18:14] >> mysql_store_result( Connection handle: 1 )

[19:18:14] CMySQLHandler::StoreResult() - Result was stored.

[19:18:14] >> mysql_num_rows( Connection handle: 1 )

[19:18:14] CMySQLHandler::NumRows() - Returned 1 row(s)

[19:18:14] >> mysql_fetch_row_format( Connection handle: 1 )

[19:18:14] CMySQLHandler::FetchRow() - Return: 0

[19:18:14] >> mysql_query( Connection handle: 1 )

[19:18:14] CMySQLHandler::Query(SELECT id FROM banuri WHERE idd = 5 LIMIT 1) - Successfully executed.

[19:18:14] >> mysql_store_result( Connection handle: 1 )

[19:18:14] CMySQLHandler::StoreResult() - Result was stored.

[19:18:14] >> mysql_num_rows( Connection handle: 1 )

[19:18:14] CMySQLHandler::NumRows() - Returned 0 row(s)

[19:18:14] >> mysql_query( Connection handle: 1 )

[19:18:14] CMySQLHandler::Query(SELECT UltLog FROM players WHERE id = 5 LIMIT 1) - Successfully executed.

[19:18:14] >> mysql_store_result( Connection handle: 1 )

[19:18:14] CMySQLHandler::StoreResult() - Result was stored.

[19:18:14] >> mysql_fetch_row_format( Connection handle: 1 )

[19:18:14] CMySQLHandler::FetchRow() - Return: 19:15 13.08.2014

[19:18:14] >> mysql_store_result( Connection handle: 1 )

[19:18:14] CMySQLHandler::StoreResult() - No data to store.

[19:18:14] >> mysql_query( Connection handle: 1 )

[19:18:14] CMySQLHandler::Query(UPDATE players SET Paycheck='1' WHERE id=5) - Successfully executed.

[19:18:16] >> mysql_query( Connection handle: 1 )

[19:18:16] CMySQLHandler::Query(UPDATE players SET Paycheck='2' WHERE id=5) - Successfully executed.

[19:18:17] >> mysql_query( Connection handle: 1 )

[19:18:17] CMySQLHandler::Query(UPDATE players SET Paycheck='3' WHERE id=5) - Successfully executed.

[19:18:18] >> mysql_query( Connection handle: 1 )

[19:18:18] CMySQLHandler::Query(UPDATE players SET Paycheck='4' WHERE id=5) - Successfully executed.

[19:18:19] >> mysql_query( Connection handle: 1 )

[19:18:19] CMySQLHandler::Query(UPDATE players SET Paycheck='5' WHERE id=5) - Successfully executed.

[19:18:20] >> mysql_query( Connection handle: 1 )

[19:18:20] CMySQLHandler::Query(UPDATE players SET Paycheck='6' WHERE id=5) - Successfully executed.

[19:18:21] >> mysql_query( Connection handle: 1 )

[19:18:21] CMySQLHandler::Query(UPDATE players SET Paycheck='7' WHERE id=5) - Successfully executed.

[19:18:22] >> mysql_ping( Connection handle: 1 )

[19:18:22] CMySQLHandler::Ping() - Connection is still alive.

[19:18:22] >> mysql_query( Connection handle: 1 )

[19:18:22] CMySQLHandler::Query(SELECT Password FROM players WHERE id = 5 LIMIT 1) - Successfully executed.

[19:18:22] >> mysql_store_result( Connection handle: 1 )

[19:18:22] CMySQLHandler::StoreResult() - Result was stored.

[19:18:22] >> mysql_fetch_row_format( Connection handle: 1 )

[19:18:22] CMySQLHandler::FetchRow() - Return: test

[19:18:22] >> mysql_query( Connection handle: 1 )

[19:18:22] CMySQLHandler::Query(SELECT * FROM players WHERE id= 5) - Successfully executed.

[19:18:22] >> mysql_store_result( Connection handle: 1 )

[19:18:22] CMySQLHandler::StoreResult() - Result was stored.

[19:18:22] >> mysql_num_rows( Connection handle: 1 )

[19:18:22] CMySQLHandler::NumRows() - Returned 1 row(s)

[19:18:22] >> mysql_fetch_row_format( Connection handle: 1 )

[19:18:22] CMySQLHandler::FetchRow() - Return: 5|test|test|1|0|0|0|0|1|1|1|19|1|0|0|0|0|8000|5000|0|0|0|0|0|0|0|0|0|0|0|0|0|7|0|0|0|0|0|0|0|255|0|289|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|255|3|264|5683|255|999|255|0|15|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|999|999|999|999|0|0|0|0|0|0|0|0|0|0|0|0|0|No-one|13 8 2014|19:15 13.08.2014|Niciunul|1742.6400|-1862.6600|13.5800|50.0|50.0|0.0|0|0|0|0

[19:18:22] >> mysql_query( Connection handle: 1 )

[19:18:22] CMySQLHandler::Query(SELECT MarriedTo FROM players WHERE id = 5 LIMIT 1) - Successfully executed.

[19:18:22] >> mysql_store_result( Connection handle: 1 )

[19:18:22] CMySQLHandler::StoreResult() - Result was stored.

[19:18:22] >> mysql_fetch_row_format( Connection handle: 1 )

[19:18:22] CMySQLHandler::FetchRow() - Return: No-one

[19:18:22] >> mysql_store_result( Connection handle: 1 )

[19:18:22] CMySQLHandler::StoreResult() - No data to store.

[19:18:22] >> mysql_query( Connection handle: 1 )

[19:18:22] CMySQLHandler::Query(SELECT Email FROM players WHERE id = 5 LIMIT 1) - Successfully executed.

[19:18:22] >> mysql_store_result( Connection handle: 1 )

[19:18:22] CMySQLHandler::StoreResult() - Result was stored.

[19:18:22] >> mysql_fetch_row_format( Connection handle: 1 )

[19:18:22] CMySQLHandler::FetchRow() - Return: Niciunul

[19:18:22] >> mysql_store_result( Connection handle: 1 )

[19:18:22] CMySQLHandler::StoreResult() - No data to store.

[19:18:22] >> mysql_query( Connection handle: 1 )

[19:18:22] CMySQLHandler::Query(UPDATE players SET UltLog='19:18 13.08.2014' WHERE id=5) - Successfully executed.

[19:18:22] >> mysql_query( Connection handle: 1 )

[19:18:22] CMySQLHandler::Query(UPDATE players SET Car2='999' WHERE id=5) - Successfully executed.

[19:18:22] >> mysql_query( Connection handle: 1 )

[19:18:22] CMySQLHandler::Query(INSERT INTO ConnectLog (Nume, Data, IP, Tip) VALUES ('test', '19:18 13.08.2014', '192.168.0.101', 'Logare')) - An error has occured. (Error ID: 1146, Table 'blown.connectlog' doesn't exist)

[19:18:22] >> mysql_query( Connection handle: 1 )

[19:18:22] CMySQLHandler::Query(UPDATE players SET Status='1' WHERE id=5) - Successfully executed.

[19:18:22] OnQueryError() - Called.

[19:18:22] >> mysql_reconnect( Connection handle: 1 )

[19:18:22] CMySQLHandler::Disconnect() - Connection was closed.

[19:18:22] CMySQLHandler::Connect() - Connection was successful.

[19:18:22] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[19:18:22] >> mysql_query( Connection handle: 1 )

[19:18:22] CMySQLHandler::Query(UPDATE players SET Paycheck='8' WHERE id=5) - Successfully executed.

[19:18:24] >> mysql_query( Connection handle: 1 )

[19:18:24] CMySQLHandler::Query(UPDATE players SET Sex='1' WHERE id=5) - Successfully executed.

[19:18:24] >> mysql_query( Connection handle: 1 )

[19:18:24] CMySQLHandler::Query(UPDATE players SET Chara='289' WHERE id=5) - Successfully executed.

[19:18:24] >> mysql_query( Connection handle: 1 )

[19:18:24] CMySQLHandler::Query(UPDATE players SET Paycheck='9' WHERE id=5) - Successfully executed.

[19:18:25] >> mysql_query( Connection handle: 1 )

[19:18:25] CMySQLHandler::Query(UPDATE players SET Paycheck='10' WHERE id=5) - Successfully executed.

[19:18:26] >> mysql_query( Connection handle: 1 )

[19:18:26] CMySQLHandler::Query(UPDATE players SET Paycheck='11' WHERE id=5) - Successfully executed.

[19:18:27] >> mysql_query( Connection handle: 1 )

[19:18:27] CMySQLHandler::Query(UPDATE players SET Paycheck='12' WHERE id=5) - Successfully executed.

[19:18:28] >> mysql_query( Connection handle: 1 )

[19:18:28] CMySQLHandler::Query(UPDATE players SET Paycheck='13' WHERE id=5) - Successfully executed.

[19:18:29] >> mysql_query( Connection handle: 1 )

[19:18:29] CMySQLHandler::Query(UPDATE players SET Paycheck='14' WHERE id=5) - Successfully executed.

[19:18:30] >> mysql_query( Connection handle: 1 )

[19:18:30] CMySQLHandler::Query(UPDATE players SET Paycheck='15' WHERE id=5) - Successfully executed.

[19:18:31] >> mysql_query( Connection handle: 1 )

[19:18:31] CMySQLHandler::Query(UPDATE players SET Paycheck='16' WHERE id=5) - Successfully executed.

[19:18:33] >> mysql_query( Connection handle: 1 )

[19:18:33] CMySQLHandler::Query(UPDATE players SET Paycheck='17' WHERE id=5) - Successfully executed.

[19:18:34] >> mysql_query( Connection handle: 1 )

[19:18:34] CMySQLHandler::Query(UPDATE players SET Paycheck='18' WHERE id=5) - Successfully executed.

[19:18:35] >> mysql_query( Connection handle: 1 )

[19:18:35] CMySQLHandler::Query(UPDATE players SET Paycheck='19' WHERE id=5) - Successfully executed.

[19:18:36] >> mysql_query( Connection handle: 1 )

[19:18:36] CMySQLHandler::Query(UPDATE players SET Status='0' WHERE id=5) - Successfully executed.

[/pawn]

 nu stiu daca am copiat tot , ca era foarte mult , sper sa fii copiat tot de la ultimul login

[WopsS]

Sterge tot continutul si fai iar partea aia cu tutorialul te rog.