29.05.2012, 08:40
Hi all,
Today in my coding OnPlayerLogin, I have a problem ..
When I login with my account, no data is loaded and I start the tutorial every time ..
Here's the code:
For all that I help, I thank their advance.
Sorry for the mistakes, I'm french
Sincerely, TomyZ.
Today in my coding OnPlayerLogin, I have a problem ..
When I login with my account, no data is loaded and I start the tutorial every time ..
Here's the code:
pawn Код:
public OnPlayerLogin(playerid,password[])
{
printf("Prinft 4");
MySQLCheckConnection();
printf("Prinft 5");
new tmp2[256],playername2[MAX_PLAYER_NAME],playerip[20];
printf("Prinft 6");
GetPlayerName(playerid,playername2,sizeof(playername2));
printf("Prinft 7");
MySQLFetchAcctSingle(PlayerInfo[playerid][pSQLID], "password", PlayerInfo[playerid][pKey]);
printf("Prinft 8");
if(strlen(password) > 1 && strcmp(PlayerInfo[playerid][pKey],password, false ) == 0 )
{
new Data[2048],Field[65],query[64];
format(query, sizeof(query), "SELECT * FROM players_accounts WHERE id = %d LIMIT 1", PlayerInfo[playerid][pSQLID]);
mysql_query(query);
printf("Prinft 9");
mysql_store_result();
printf("Prinft 10");
if(mysql_fetch_row(Data))
{
printf("Prinft 11");
mysql_get_field("niveau",Field); PlayerInfo[playerid][pNiveau] = strval(Field);
printf("Prinft 12");
mysql_get_field("adminlevel",Field); PlayerInfo[playerid][pAdministrateur] = strval(Field);
printf("Prinft 13");
mysql_get_field("autoriser",Field); PlayerInfo[playerid][pAutoriser] = strval(Field);
printf("Prinft 14");
mysql_get_field("donaterank",Field); PlayerInfo[playerid][pDonateRank] = strval(Field);
printf("Prinft 15");
mysql_get_field("donateur",Field); PlayerInfo[playerid][pDonateur] = strval(Field);
printf("Prinft 16");
mysql_get_field("upgradepoints",Field); PlayerInfo[playerid][gPupgrade] = strval(Field);
printf("Prinft 17");
mysql_get_field("connectedtime",Field); PlayerInfo[playerid][pConnectTime] = strval(Field);
mysql_get_field("registered",Field); PlayerInfo[playerid][pReg] = strval(Field);
mysql_get_field("sex",Field); PlayerInfo[playerid][pSex] = strval(Field);
mysql_get_field("age",Field); PlayerInfo[playerid][pAge] = strval(Field);
mysql_get_field("poids",Field); PlayerInfo[playerid][pPoids] = strval(Field);
mysql_get_field("taillea",Field); PlayerInfo[playerid][pTailleA] = strval(Field);
mysql_get_field("tailleb",Field); PlayerInfo[playerid][pTailleB] = strval(Field);
mysql_get_field("origin",Field); PlayerInfo[playerid][pOrigin] = strval(Field);
mysql_get_field("ck",Field); PlayerInfo[playerid][pBiere] = strval(Field);
mysql_get_field("muted",Field); PlayerInfo[playerid][pMuted] = strval(Field);
mysql_get_field("mutedtemps",Field); PlayerInfo[playerid][pMutedTemps] = strval(Field);
mysql_get_field("mutedcmd",Field); PlayerInfo[playerid][pMutedCmd] = strval(Field);
mysql_get_field("mutedcmdtemps",Field); PlayerInfo[playerid][pMutedCmdTemps] = strval(Field);
mysql_get_field("respect",Field); PlayerInfo[playerid][pExp] = strval(Field);
mysql_get_field("money",Field); PlayerInfo[playerid][pCash] = strval(Field);
mysql_get_field("banks",Field); PlayerInfo[playerid][pAccount] = strval(Field);
mysql_get_field("crimes",Field); PlayerInfo[playerid][pCrimes] = strval(Field);
mysql_get_field("kills",Field); PlayerInfo[playerid][pKills] = strval(Field);
mysql_get_field("deaths",Field); PlayerInfo[playerid][pDeaths] = strval(Field);
mysql_get_field("arrested",Field); PlayerInfo[playerid][pArrested] = strval(Field);
mysql_get_field("wanteddeaths",Field); PlayerInfo[playerid][pWantedDeaths] = strval(Field);
mysql_get_field("phonebook",Field); PlayerInfo[playerid][pPhoneBook] = strval(Field);
mysql_get_field("lottonr",Field); PlayerInfo[playerid][pLottoNr] = strval(Field);
mysql_get_field("fishes",Field); PlayerInfo[playerid][pFishes] = strval(Field);
mysql_get_field("biggestfish",Field); PlayerInfo[playerid][pBiggestFish] = strval(Field);
mysql_get_field("job",Field); PlayerInfo[playerid][pJob] = strval(Field);
mysql_get_field("paycheck",Field); PlayerInfo[playerid][pPayCheck] = strval(Field);
mysql_get_field("headvalue",Field); PlayerInfo[playerid][pHeadValue] = strval(Field);
mysql_get_field("jailed",Field); PlayerInfo[playerid][pJailed] = strval(Field);
mysql_get_field("jailtime",Field); PlayerInfo[playerid][pJailTime] = strval(Field);
mysql_get_field("materials",Field); PlayerInfo[playerid][pMats] = strval(Field);
mysql_get_field("drugs",Field); PlayerInfo[playerid][pDrugs] = strval(Field);
mysql_get_field("leader",Field); PlayerInfo[playerid][pChefFaction] = strval(Field);
mysql_get_field("member",Field); PlayerInfo[playerid][pMembreFaction] = strval(Field);
mysql_get_field("fmember",Field); PlayerInfo[playerid][pFMember] = strval(Field);
mysql_get_field("rank",Field); PlayerInfo[playerid][pRank] = strval(Field);
mysql_get_field("chara",Field); PlayerInfo[playerid][pChar] = strval(Field);
mysql_get_field("skin",Field); PlayerInfo[playerid][pSkin] = strval(Field);
mysql_get_field("contracttime",Field); PlayerInfo[playerid][pContractTime] = strval(Field);
mysql_get_field("wantedniveau",Field); PlayerInfo[playerid][pWantedPoint] = strval(Field);
mysql_get_field("detskill",Field); PlayerInfo[playerid][pDetSkill] = strval(Field);
mysql_get_field("sexskill",Field); PlayerInfo[playerid][pSexSkill] = strval(Field);
mysql_get_field("boxskill",Field); PlayerInfo[playerid][pBoxSkill] = strval(Field);
mysql_get_field("lawskill",Field); PlayerInfo[playerid][pLawSkill] = strval(Field);
mysql_get_field("mechskill",Field); PlayerInfo[playerid][pMechSkill] = strval(Field);
mysql_get_field("jackskill",Field); PlayerInfo[playerid][pJackSkill] = strval(Field); // On s'arrкte ici grigo
mysql_get_field("carskill",Field); PlayerInfo[playerid][pCarSkill] = strval(Field);
mysql_get_field("newsskill",Field); PlayerInfo[playerid][pNewsSkill] = strval(Field);
mysql_get_field("drugsskill",Field); PlayerInfo[playerid][pDrugsSkill] = strval(Field);
mysql_get_field("cookskill",Field); PlayerInfo[playerid][pCookSkill] = strval(Field);
mysql_get_field("fishskill",Field); PlayerInfo[playerid][pFishSkill] = strval(Field);
mysql_get_field("pshealth",Field); PlayerInfo[playerid][pSHealth] = strval(Field);
mysql_get_field("phealth",Field); PlayerInfo[playerid][pHealth] = strval(Field);
mysql_get_field("inta",Field); PlayerInfo[playerid][pInt] = strval(Field);
mysql_get_field("local",Field); PlayerInfo[playerid][pLocal] = strval(Field);
mysql_get_field("team",Field); PlayerInfo[playerid][pTeam] = strval(Field);
mysql_get_field("model",Field); PlayerInfo[playerid][pModel] = strval(Field);
mysql_get_field("phonenr",Field); PlayerInfo[playerid][pPnumber] = strval(Field);
mysql_get_field("car",Field); PlayerInfo[playerid][pPcarkey] = strval(Field);
mysql_get_field("changepass",Field); PlayerInfo[playerid][pChangePass] = strval(Field);
mysql_get_field("plaque",Field); PlayerInfo[playerid][pPlaque] = strval(Field);
mysql_get_field("house",Field); PlayerInfo[playerid][pPhousekey] = strval(Field);
mysql_get_field("bizz",Field); PlayerInfo[playerid][pPbiskey] = strval(Field);
mysql_get_field("pos_x",Field); PlayerInfo[playerid][pPos_x] = strval(Field);
mysql_get_field("pos_y",Field); PlayerInfo[playerid][pPos_y] = strval(Field);
mysql_get_field("pos_z",Field); PlayerInfo[playerid][pPos_z] = strval(Field);
mysql_get_field("carlic",Field); PlayerInfo[playerid][pVoitureLic] = strval(Field);
mysql_get_field("flylic",Field); PlayerInfo[playerid][pFlyLic] = strval(Field);
mysql_get_field("boatlic",Field); PlayerInfo[playerid][pBoatLic] = strval(Field);
mysql_get_field("fishlic",Field); PlayerInfo[playerid][pFishLic] = strval(Field);
mysql_get_field("gunlic",Field); PlayerInfo[playerid][pGunLic] = strval(Field);
mysql_get_field("gun1",Field); PlayerInfo[playerid][pGun1] = strval(Field);
mysql_get_field("gun2",Field); PlayerInfo[playerid][pGun2] = strval(Field);
mysql_get_field("gun3",Field); PlayerInfo[playerid][pGun3] = strval(Field);
mysql_get_field("gun4",Field); PlayerInfo[playerid][pGun4] = strval(Field);
mysql_get_field("ammo1",Field); PlayerInfo[playerid][pAmmo1] = strval(Field);
mysql_get_field("ammo2",Field); PlayerInfo[playerid][pAmmo2] = strval(Field);
mysql_get_field("ammo3",Field); PlayerInfo[playerid][pAmmo3] = strval(Field);
mysql_get_field("ammo4",Field); PlayerInfo[playerid][pAmmo4] = strval(Field);
mysql_get_field("cartime",Field); PlayerInfo[playerid][pCarTime] = strval(Field);
mysql_get_field("payday",Field); PlayerInfo[playerid][pPayDay] = strval(Field);
mysql_get_field("paydayhad",Field); PlayerInfo[playerid][pPayDayHad] = strval(Field);
mysql_get_field("cdplayer",Field); PlayerInfo[playerid][pCDPlayer] = strval(Field);
mysql_get_field("wins",Field); PlayerInfo[playerid][pWins] = strval(Field);
mysql_get_field("loses",Field); PlayerInfo[playerid][pLoses] = strval(Field);
mysql_get_field("alcoholperk",Field); PlayerInfo[playerid][pAlcoholPerk] = strval(Field);
mysql_get_field("drugperk",Field); PlayerInfo[playerid][pDrugPerk] = strval(Field);
mysql_get_field("miserperk",Field); PlayerInfo[playerid][pMiserPerk] = strval(Field);
mysql_get_field("painperk",Field); PlayerInfo[playerid][pPainPerk] = strval(Field);
mysql_get_field("radio",Field); PlayerInfo[playerid][pRadio] = strval(Field);
mysql_get_field("posx",Field); PlayerInfo[playerid][pPosX] = strval(Field);
mysql_get_field("posy",Field); PlayerInfo[playerid][pPosY] = strval(Field);
mysql_get_field("posz",Field); PlayerInfo[playerid][pPosZ] = strval(Field);
mysql_get_field("argent",Field); PlayerInfo[playerid][pArgent] = strval(Field);
mysql_get_field("monde",Field); PlayerInfo[playerid][pMonde] = strval(Field);
mysql_get_field("tarderperk",Field); PlayerInfo[playerid][pTraderPerk] = strval(Field);
mysql_get_field("tutorial",Field); PlayerInfo[playerid][pTut] = strval(Field);
mysql_get_field("mission",Field); PlayerInfo[playerid][pMissionNr] = strval(Field);
mysql_get_field("warnings",Field); PlayerInfo[playerid][pWarns] = strval(Field);
mysql_get_field("adjustable",Field); PlayerInfo[playerid][pAdjustable] = strval(Field);
mysql_get_field("fuel",Field); PlayerInfo[playerid][pFuel] = strval(Field);
mysql_get_field("married",Field); PlayerInfo[playerid][pMarried] = strval(Field);
mysql_get_field("marriedto",Field); strmid(PlayerInfo[playerid][pMarriedTo], Field, 0, strlen(Field), 255);
mysql_get_field("pointamelioration",Field); PlayerInfo[playerid][pPointAmelioration] = strval(Field);
mysql_get_field("pointcourse",Field); PlayerInfo[playerid][pPointCourse] = strval(Field);
mysql_get_field("pass",Field); strmid(PlayerInfo[playerid][pPass], Field, 0, strlen(Field), 255);
mysql_get_field("cigarre",Field); PlayerInfo[playerid][pCigarre] = strval(Field);
mysql_get_field("teteaprix",Field); PlayerInfo[playerid][pTeteAPrix] = strval(Field);
mysql_get_field("bateaukey",Field); PlayerInfo[playerid][pBateauKey] = strval(Field);
mysql_get_field("titrefamille",Field); strmid(PlayerInfo[playerid][pTitre], Field, 0, strlen(Field), 255);
mysql_get_field("banmotif",Field); strmid(PlayerInfo[playerid][pBMotif], Field, 0, strlen(Field), 255);
mysql_get_field("timestamp",Field); PlayerInfo[playerid][pTimeStamp] = strval(Field);
mysql_get_field("motifjail",Field); strmid(PlayerInfo[playerid][pJMotif], Field, 0, strlen(Field), 255);
mysql_get_field("reduchopital",Field); PlayerInfo[playerid][pHExpir] = strval(Field);
}
gPlayerLogged[playerid] = 1;
}
Sorry for the mistakes, I'm french
Sincerely, TomyZ.