Ajutor baza de date!

[Colenelu]

Nick:Colonelul

Problema:Intai vr sa zic Buna ziua!Deci cand dau /sethelper sau cand primesc playeri de inceput lvl 3 nu i se salveaza in baza de date!

Erori / warnings:-

Lini/script:Daca imi spuneti unde sa caut va arat!

Ai incercat sa rezolvi singur ?:Da!

[Iulian]

Ne-ai putea arata cateva linii (unde ii seteaza levelul si la OnPlayerDisconect)

[Colenelu]

{
        case 0: format(string2,sizeof string2,"%s a parasit serverul. (Crash)",wakaname);
        case 1: format(string2,sizeof string2,"%s a parasit serverul. (/q)",wakaname);
        case 2: format(string2,sizeof string2,"%s a parasit serverul. (Kick/Ban)",wakaname);
    }
	ProxDetector(30.0, playerid, string2, COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE);
	//new query[MAX_STRING];
	//format(query, sizeof(query), "AdmCmd: %s a iesit din joc %d/%d/%d ora %d:%d",PlayerData[playerid][pNume],day,month,year,hour,minute,second);
	//ConnectLog(query); // la iesire nu le mai pune ca asta buguieste..
//	new query[MAX_STRING];
//	format(query, sizeof(query), "INSERT INTO ConnectLog (Nume, Ziua, Luna, Anul, Ora, Minutul, Tip) VALUES ('%s', '%d', '%d', '%d', '%d', '%d', 'Iesire')", PlayerData[playerid][pNume], day,month,year,hour,minute);
//	mysql_query(query);

[Colenelu]

//mysql_free_result();
		PlayerData[playerid][pAdjustable] = 0;
		ConsumingMoney[playerid] = 1;
		if(PlayerData[playerid][pReg] == 0)
		{
			PlayerData[playerid][pLevel] = 3;
			PlayerData[playerid][pSHealth] = 0.0;
			PlayerData[playerid][pHealth] = 50.0;
			PlayerData[playerid][pArmour] = 0.0;
			PlayerData[playerid][pPos_x] = 2246.6;
			PlayerData[playerid][pPos_y] = -1161.9;
			PlayerData[playerid][pPos_z] = 1029.7;
			PlayerData[playerid][pInt] = 15;
			PlayerData[playerid][pLocal] = 255;
			PlayerData[playerid][pTeam] = 3;
			PlayerData[playerid][pModel] = 264;
			new randphone = 1000 + random(8999);//minimum 1000  max 9999 //giving one at the start
			PlayerData[playerid][pPnumber] = randphone;
			PlayerData[playerid][pPhousekey] = 255;
			PlayerData[playerid][pPbiskey] = 255;
			PlayerData[playerid][pPcarkey] = 999;
			PlayerData[playerid][pPcarkey2] = 999;
			PlayerData[playerid][pPcarkey3] = 999;
			PlayerData[playerid][pPcarkey4] = 999;
			PlayerData[playerid][pPcarkey5] = 999;
			PlayerData[playerid][pAccount] = 5000;
			PlayerData[playerid][pReg] = 1;
			PlayerData[playerid][pLocked] = 0;
			GivePlayerCash(playerid, 1000000);
			format(string, sizeof(string), "UPDATE players SET Registered='%d' WHERE id=%d", PlayerData[playerid][pReg], PlayerData[playerid][pSQLID]);
			mysql_query(string);
			format(string, sizeof(string), "UPDATE players SET PhoneNr='%d' WHERE id=%d", PlayerData[playerid][pPnumber], PlayerData[playerid][pSQLID]);
			mysql_query(string);
			format(string, sizeof(string), "UPDATE players SET House='%d' WHERE id=%d", PlayerData[playerid][pPhousekey], PlayerData[playerid][pSQLID]);
			mysql_query(string);
			format(string, sizeof(string), "UPDATE players SET Car='%d' WHERE id=%d", PlayerData[playerid][pPcarkey], PlayerData[playerid][pSQLID]);
			mysql_query(string);
			format(string, sizeof(string), "UPDATE players SET Car2='%d' WHERE id=%d", PlayerData[playerid][pPcarkey2], PlayerData[playerid][pSQLID]);
			mysql_query(string);
			format(string, sizeof(string), "UPDATE players SET Car3='%d' WHERE id=%d", PlayerData[playerid][pPcarkey3], PlayerData[playerid][pSQLID]);
			mysql_query(string);
			format(string, sizeof(string), "UPDATE players SET Car4='%d' WHERE id=%d", PlayerData[playerid][pPcarkey4], PlayerData[playerid][pSQLID]);
			mysql_query(string);
			format(string, sizeof(string), "UPDATE players SET Car5='%d' WHERE id=%d", PlayerData[playerid][pPcarkey5], PlayerData[playerid][pSQLID]);
			mysql_query(string);
			format(string, sizeof(string), "UPDATE players SET Bank='%d' WHERE id=%d", PlayerData[playerid][pAccount], PlayerData[playerid][pSQLID]);
			mysql_query(string);
			format(string, sizeof(string), "UPDATE players SET Locked='%d' WHERE id=%d", PlayerData[playerid][pLocked], PlayerData[playerid][pSQLID]);
			mysql_query(string);
		}
		printf(" %s has logged in.", PlayerData[playerid][pNume]);
		new playersip[182];
		getdate(year, month, day);
  		gettime(hour,minute,second);
		GetPlayerIp(playerid,playersip,sizeof(playersip));
		//format(string, sizeof(string), "AdmCmd: %s s-a logat astazi %d/%d/%d ora %d:%d, de pe ip %s",PlayerData[playerid][pNume],month,day,year,hour,minute,playersip);
		//ConnectLog(string);
		format(string, sizeof(string), "INSERT INTO ConnectLog (Nume, Data, IP, Tip) VALUES ('%s', '%s', '%s', 'Logare')", PlayerData[playerid][pNume], PlayerData[playerid][pUltLog], playersip);
		mysql_query(string);
		PlayerData[playerid][pStatus] = 1;
	 	format(string, sizeof(string), "UPDATE players SET Status='%d' WHERE id=%d", PlayerData[playerid][pStatus], PlayerData[playerid][pSQLID]);
		mysql_query(string);
		if(PlayerData[playerid][pAllowed] == 0)
		{
			for(new i=1; i<=maxim;i++)
			{
				if(strfind(playersip, BanData[i][xIp], true) != -1)
				{
					    SendClientMessage(playerid, COLOR_WHITE, "Server: {FF0000}Ai primit ban pe aceasta clasa de ip.");
					    SendClientMessage(playerid, COLOR_LIGHTRED, "Pentru unban viziteaza http://powergame.ro/forum/");
					    Kick(playerid);
					    return 1;
				}
			}
		}

Pote te ajuta si asta!

[Джо]

Salut,degeaba ai tu alea daca nu ai salvare la level,admin,etc.Cand il deschizi de pe localhost,si intrii pe el,iti dai adminul dupa dai relog face la fel?

[Colenelu]

pai la admin nu face doar la level si helper atat!

[HaHaProDucT]

In acele linii nu se aduce vorba deloc de vreun PlayerData[playerid][pAdmin] sau PlayerData[playerid][pHelper]. Posteaza tot ceea ce are legatura cu sql. Daca nu stiu pune tot de la OnPlayerConnect si OnPlayerDisconnect. In legatura cu inregistrarea, nu vad nici un "INSERT INTO players (Name, Password) VALUES ('Nume', 'Parola')" .