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;
}

Ajutor MySQL Save player

Question

37 answers to this question

Recommended Posts

Guest farse

Guest farse

Similar Content

Recently Browsing 0 members

Important Information