Ajutor MySQL Save player

AsSsASIN · February 16, 2011

Am o mica problema la MySQL save player, imi puteti da un ex de saveplayerdata si database cu totul din PlayerInfo si altele? va rog mult... nu mi se salveaza datele..

TheGuardianAngel · February 17, 2011

ti se conecteaza la baza de date? poate ai gresit datele de conectare :)

AsSsASIN · February 17, 2011

Da este conectat, dar probabil se deconecteaza... nu stiu :|

...

TheGuardianAngel · February 17, 2011

pai daca se deconecteaza inseamna ca e ceva in neregula , adica nu e ca semnalul la telefon ba ai semnal ba nu ai semnal , nu are cum sa se conecteze si pe urma sa se deconecteze , conectare in sensul de , s-a conectat cu succes la baza de date (datele sunt corecte si baza de date este functionala) sau nu s-a conectat (datele sunt gresite sau baza de date nu este functionala)

LaZ · February 17, 2011

Sau ai gresit sintaxa.

AsSsASIN · February 17, 2011

LaZ" post="55206" timestamp="1297965121"]
Sau ai gresit sintaxa.

Laz, e posibil, ca nu cred ca sa deconectat... imi dai de ex: o sintaxa buna?

LaZ · February 18, 2011

Sau ai putea sa o postezi tu, sa o corectam daca ii gresita.

AsSsASIN · February 18, 2011

public SavePlayerData(playerid)
{
	if(IsPlayerConnected(playerid))
	{
		if(gPlayerLogged[playerid])
		{
            printf("MySQL: Ping: %i",mysql_ping());
			new string[MAX_STRING];
			format(string, MAX_STRING, "UPDATE players SET ");
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE players SET password=%d, Level=%d, AdminLevel=%d, DonateRank=%s WHERE id=%d", PlayerInfo[playerid][pKey], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pDonateRank], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
			PlayerInfo[playerid][pCash] = GetPlayerMoney(playerid);
		    format(string, MAX_STRING, "UPDATE players SET PointsUpgrade=%d, ConnectedTime=%d, Reg=%d, Sex=%d, Age=%d, Origin=%d', CK=%d WHERE id=%d", PlayerInfo[playerid][gPupgrade], PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pReg], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pAge], PlayerInfo[playerid][pOrigin], PlayerInfo[playerid][pCK], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
		    format(string, MAX_STRING, "UPDATE `players` SET `Muted` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pMuted], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Exp` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pExp], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Cash` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pCash], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `AccountBank` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pAccount], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `CrimesComited` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pCrimes], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Kills` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pKills], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Deaths` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pDeaths], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Arrested` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pArrested], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `WantedDeaths` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pWantedDeaths], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Phonebook` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pPhoneBook], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `LottoNr` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pLottoNr], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Fishes` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pFishes], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `BiggestFish` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pBiggestFish], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Job` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pJob], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `PayCheck` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pPayCheck], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `HeadValue` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pHeadValue], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Jailed` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `JailTime` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Mats` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pMats], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Drugs` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pDrugs], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Leader` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Member` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pMember], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `FMember` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pFMember], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Rank` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pRank], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Char` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pChar], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `ContractTime` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pContractTime], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `DetSkill` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pDetSkill], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `SexSkill` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pSexSkill], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `BoxSkill` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pBoxSkill], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `LawSkill` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pPhoneBook], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `MechSkill` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pMechSkill], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `JackSkill` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pJackSkill], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `CarSkill` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pCarSkill], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `NewsSkill` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pNewsSkill], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `DrugsSkill` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pDrugsSkill], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `CookSkill` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pCookSkill], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `FishSkill` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pFishSkill], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `pHealth` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pHealth], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `pSHealth` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pSHealth], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Int` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pInt], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Local` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pLocal], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Team` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pTeam], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Model` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pModel], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Pnumber` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pPnumber], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Phousekey` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pPhousekey], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Pbiskey` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pPbiskey], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
			if ((PlayerInfo[playerid][pPos_x]==0.0 && PlayerInfo[playerid][pPos_y]==0.0 && PlayerInfo[playerid][pPos_z]==0.0)) {
				PlayerInfo[playerid][pPos_x] = 1684.9;
				PlayerInfo[playerid][pPos_y] = -2244.5;
				PlayerInfo[playerid][pPos_z] = 13.5;
			}
            format(string, MAX_STRING, "UPDATE `players` SET `Pos_x` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pPos_x], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Pos_y` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pPos_y], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Pos_z` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pPos_z], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `CarLic` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pCarLic], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `FlyLic` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pFlyLic], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `BoatLic` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pBoatLic], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `FishLic` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pFishLic], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `GunLic` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pGunLic], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Gun1` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pGun1], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Gun2` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pGun2], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Gun3` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pGun3], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Gun4` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pGun4], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Ammo1` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pAmmo1], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Ammo2` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pAmmo2], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Ammo3` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pAmmo3], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Ammo4` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pAmmo4], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `CarTime` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pCarTime], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `PayDay` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `PayDayHad` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pPayDayHad], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `CDPlayer` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pCDPlayer], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Wins` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pWins], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Loses` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pLoses], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `AlcoholPerk` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pAlcoholPerk], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `DrugPerk` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pDrugPerk], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `MiserPerk` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pMiserPerk], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `PainPerk` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pPainPerk], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `TraderPerk` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pTraderPerk], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Tut` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pTut], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `MissionNr` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pMissionNr], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Warns` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pWarns], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Adjustable` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pAdjustable], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Fuel` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pFuel], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `Married` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pMarried], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
            format(string, MAX_STRING, "UPDATE `players` SET `MarriedTo` = '%s' WHERE `id` = '%d'", PlayerInfo[playerid][pMarriedTo], PlayerInfo[playerid][pSQLID]);
            mysql_query(string);
		}
	}
	return 1;
}

la database nu am default un cifru.

farse e nesimtit, credeam ca o sa ma ajute el )

AsSsASIN · February 18, 2011

Bun, am schimbat syntaxa, am facuto ca pe moderntopia, database e bun, mysql este conectat, nu inteleg, ce ar putea avea :|?

LaZ · February 18, 2011

Adauga mysql_debug( 1 ); la OnGameModeInit.

La inceput ai mysql_query( "UPDATE players` SET " ); nu-i completa sintaxa.

Si ca sa salvezi cateva randuri, poti face si asa:

UPDATE `players` SET `coloana` = 1, `coloana2` = 2, coloana3` = 3, `coloanan` = 4 WHERE `rand` = 'nume';"

%d se foloseste pentru numere intregi, iar pentru numere reale se foloseste %f.

AsSsASIN · February 19, 2011

De exemplu, asta este bun?

UPDATE `players` SET `Level`, `AdminLevel`, Sex`, `Age` WHERE `id` = '%s'

1. Diferenta intre %d si %f ?

2. Trebuie toate intr-o syntaxa, sau 5.6 in una?

LaZ · February 19, 2011

De exemplu, asta este bun?
UPDATE `players` SET `Level`, `AdminLevel`, Sex`, `Age` WHERE `id` = '%s' 
1. Diferenta intre %d si %f ?
2. Trebuie toate intr-o syntaxa, sau 5.6 in una?

Daca daca folosesti %d pentru numere reale atunci va imprima alte valori decat cele dorite de tine.

In legatura cu sintaxa, am uitat sa atribui unei coloane valorile, mi-am modificat mesajul initial.

La cate ai, nu cred ca poti sa le pui pe toate intr-un singur query, pentru ca format are o limita.

AsSsASIN · February 19, 2011

adica zici sa folosesc %f nu?

amaru · February 19, 2011

%s e pentru string

%d e pentru litere si numere. Eu il folosesc sa arate numerele la masina.

%f arata float-uri.

AsSsASIN · February 19, 2011

%s e pentru string
%d e pentru litere si numere. Eu il folosesc sa arate numerele la masina.
%f arata float-uri.

laz zice ca este pentru numere reale..

amaru · February 19, 2011

Care din ele?

Eu am la /mdc

telefon: %d, PlayerInfo[giveplayerid][pPhone]

si merge si la numerele la masina de forma LS-01-AMR

numar: %d, CarInfo[carid][cPlate]

Deci merge si pentru litere si pentru numere.

AsSsASIN · February 19, 2011

Daca ai mysql , da-mi te rog o parte din save player, sa vad ca exemplu, ca sa vad inainte sa ma apuc sa fac, ca dupa sa nu vad ca nu merge..

amaru · February 19, 2011

Nu am mysql.

AsSsASIN · February 20, 2011

Auzi, trebuie sa mergem pe username sau SQLID ?

AsSsASIN · February 20, 2011

Noua Syntaxa este buna ?

format(query, MAX_STRING, "UPDATE `players` SET `Level` = %d, `AdminLevel` = %d, `DonateRank` = %d, `PointsUpgrade` = %d WHERE `username` = %d", PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pDonateRank], PlayerInfo[playerid][gPupgrade], PlayerInfo[playerid][pSQLID]);

February 20, 2011

username este string,deci este %s.

format(query, MAX_STRING, "UPDATE `players` SET `Level` = %d, `AdminLevel` = %d, `DonateRank` = %d, `PointsUpgrade` = %d WHERE `username` = %s", PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pDonateRank], PlayerInfo[playerid][gPupgrade],pName(playerid));

Dar,deschide phpmyadmin ,mergi la db,dai edit pe una dintre inregistrari(daca nu ai ,dai la insert si pune si tu niste date la intamplare) si pune la fiecare %d sau %s(%s unde ai varchar) si o sa iti genereze el codul bun:)

Uite cum am eu facut(la un gm mai vechi...)

	format(str,600,"UPDATE `users` SET `IP` = '%s',\
	`Email` = '%s',\
	`RegisterDate` = '%s',\
	`LastOn` = '%s',\
	`Language` = '%d',\
	`ALevel` = '%d',\
	`FavColor` = '%d',\
	`Round_Win` = '%d',\
	`VIP` = '%d',",IPp[playerid],Pi[a_Email],Pi[RegisterDate],Pi[LastOn],Pi[Language],Pi[Level],Pi[FavColor],Pi[RoundWin],Pi[VIP]);
	format(str,600,"%s\
	`UPLOADER` = '%d',\
	`RANK` = '%d',\
	`NoJoin` = '%d',\
	`DAYS` = '%d',\
	`HOURS` = '%d',\
	`MINUTES` = '%d',\
	`SECONDS` = '%d',\
	 WHERE `name` ='%s'",str,Pi[UPLOADER],Pi[Rank],Pi[NoJoin],Pi[Days],Pi[Hours],Pi[MINUTES],Pi[SECONDS],ReturnName(playerid));
	mysql_query(str);

Si merge :D

AsSsASIN · February 20, 2011

Imi dai te rog public ReturnName?

Acum inteleg de ce nu mergea... cum am zis eu, id sau username...

February 20, 2011

e ca pname....

ReturnName(playerid)

{

new n_me[24];

GetPlayerName(playerid,n_me,24);

return n_me;

}

Eu nu ti'am zis sa il incerci pe ala,ti'am zis sa te uiti cum e facut..

AsSsASIN · February 20, 2011


public SavePlayerData(playerid)
{
	if(IsPlayerConnected(playerid))
	{
		if(gPlayerLogged[playerid])
		{
			new query[MAX_STRING];
			format(query, MAX_STRING, "UPDATE players SET ");
            mysql_query(query);
			PlayerInfo[playerid][pCash] = GetPlayerMoney(playerid);
			if ((PlayerInfo[playerid][pPos_x]==0.0 && PlayerInfo[playerid][pPos_y]==0.0 && PlayerInfo[playerid][pPos_z]==0.0)) {
				PlayerInfo[playerid][pPos_x] = 1684.9;
				PlayerInfo[playerid][pPos_y] = -2244.5;
				PlayerInfo[playerid][pPos_z] = 13.5;
			}
            format(query, MAX_STRING, "UPDATE `players` SET `Level` = `%d`,\
		    `AdminLevel` = `%d`,\
		    `DonateRank` = `%d`,\
			`PointsUpgrade` = `%d`,\
			`ConnectTime` = `%d`,\
			`Reg` = `%d`,\
			`Sex` = `%d`\
			WHERE `username` = `%s`", PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pDonateRank], PlayerInfo[playerid][gPupgrade], ReturnName(playerid));
            mysql_query(query);
		}
	}
	return 1;
}

ce tot are, ce am gresit iara :|?

AsSsASIN · February 21, 2011

Fix in capat e topicul meu, hai sus... laz, hai te roaga tata ca pe vremurile trecute de cand jucam pe ro zone, uitete, ca chiar nu imi dau seama :-s

LaZ · February 21, 2011

public SavePlayerData(playerid)
{
	if(gPlayerLogged[playerid])
	{
		new query[MAX_STRING];
		PlayerInfo[playerid][pCash] = GetPlayerMoney(playerid);
		if ((PlayerInfo[playerid][pPos_x]==0.0 && PlayerInfo[playerid][pPos_y]==0.0 && PlayerInfo[playerid][pPos_z]==0.0))
		{
			PlayerInfo[playerid][pPos_x] = 1684.9;
			PlayerInfo[playerid][pPos_y] = -2244.5;
			PlayerInfo[playerid][pPos_z] = 13.5;
		}
  		format(query, MAX_STRING, "UPDATE `players` SET `Level` = '%d', `AdminLevel` = '%d', `DonateRank` = '%d', `PointsUpgrade` = '%d', `ConnectTime` = '%d', `Reg` = '%d', `Sex` = '%d' WHERE `username` = '%s';", PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pDonateRank], PlayerInfo[playerid][gPupgrade], ReturnName(playerid));
    	        mysql_query(query);
	}
	return 1;
}

Sign In

Ajutor MySQL Save player

Question

Link to comment

Share on other sites

37 answers to this question

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest farse

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest farse

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Similar Content

Recently Browsing 0 members

Important Information