PHP код:
stock CreateAccount(playerid, pass[])
{
if(IsTextInvalid(pass)) return SendClientMessage(playerid,-1,"В пароле должны быть только буквы и цифры"),Kick(playerid);
new ip[16],data[16];
format(data, 16, "%s",date("%dd.%mm.%yyyy",gettime()));
GetPlayerIp(playerid, ip, 16);
format(query, 512, "INSERT INTO "TABLE_ACCOUNT" (name, password, ip, datareg, sex, model, news, mail, referal) VALUES ('%s', '%s', '%s', '%s', %d , %d, %d, '%s', '%s')"
, PlayerInfo[playerid][pSendername], pass, ip, data,PlayerInfo[playerid][pSex], PlayerInfo[playerid][pModel], 1, PlayerInfo[playerid][pMail], PlayerInfo[playerid][pReferal]);
mysql_query(query);
LoadAccount(playerid);
return 1;
}
PHP код:
stock LoadAccount(playerid)
{
new string[64];
new playername[32];
GetPlayerName(playerid,playername,32);
format(query,256, "SELECT * FROM "TABLE_ACCOUNT" WHERE name = '%s' LIMIT 1",playername);
mysql_query(query);
mysql_store_result();
if(mysql_fetch_row(query) == 1)
{
sscanf(query, "p<|>is[32]s[32]s[16]is[32]s[64]iiiis[16]iiiiiiis[16]s[40]s[160]iiiiis[16]s[20]iiiis[32]s[32]fiiiiis[32]s[32]iiiiiiiiiiiiiiiiiiiiiiifiiiiiiiiiiiiiiiiiiis[128]iiiiiis[32]",
PlayerInfo[playerid][pID],
PlayerInfo[playerid][pSendername],
PlayerInfo[playerid][pPassword],
PlayerInfo[playerid][pIP],
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pIpPassword],
PlayerInfo[playerid][pMail],
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pCash],
PlayerInfo[playerid][pBank],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pRegData],
PlayerInfo[playerid][pLeader],
PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pRank],
PlayerInfo[playerid][pWarn],
PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pModel],
PlayerInfo[playerid][pChar],
PlayerInfo[playerid][pLics],
PlayerInfo[playerid][pGuns],
PlayerInfo[playerid][pAmmos],
PlayerInfo[playerid][pGunSkill][6],
PlayerInfo[playerid][pMuted],
PlayerInfo[playerid][pPick],
PlayerInfo[playerid][pCheckTime],
PlayerInfo[playerid][pNews],
PlayerInfo[playerid][pPhones],
PlayerInfo[playerid][pTexts],
PlayerInfo[playerid][pJail],
PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pWanted],
PlayerInfo[playerid][pWantedTime],
PlayerInfo[playerid][pWantedWho],
PlayerInfo[playerid][pWantedReason],
PlayerInfo[playerid][pHeal],
PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pMats],
PlayerInfo[playerid][pCrimes],
PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pMarried],
PlayerInfo[playerid][pWhoMarried],
PlayerInfo[playerid][pReferal],
PlayerInfo[playerid][pRefMoney],
PlayerInfo[playerid][pPayCheck],
PlayerInfo[playerid][pFish],
PlayerInfo[playerid][pLottery],
PlayerInfo[playerid][pVIP],
PlayerInfo[playerid][pTime],
PlayerInfo[playerid][pFightStyle],
PlayerInfo[playerid][pCredits],
PlayerInfo[playerid][pTotalCredits],
PlayerInfo[playerid][pSkin1],
PlayerInfo[playerid][pSkin2],
PlayerInfo[playerid][pSkin3],
PlayerInfo[playerid][pSpawnChange],
PlayerInfo[playerid][pGunSkill][0],
PlayerInfo[playerid][pGunSkill][1],
PlayerInfo[playerid][pGunSkill][2],
PlayerInfo[playerid][pGunSkill][3],
PlayerInfo[playerid][pGunSkill][4],
PlayerInfo[playerid][pGunSkill][5],
PlayerInfo[playerid][pRPR],
PlayerInfo[playerid][pGlasses],
PlayerInfo[playerid][pSatiety],
PlayerInfo[playerid][pRPRGive],
PlayerInfo[playerid][pHealthS],
PlayerInfo[playerid][pSportEXP],
PlayerInfo[playerid][pOnline],
PlayerInfo[playerid][pZakon],
PlayerInfo[playerid][pBolezn],
PlayerInfo[playerid][ProverkaIP],
PlayerInfo[playerid][pHospital],
PlayerInfo[playerid][pWatch],
PlayerInfo[playerid][pCiggare],
PlayerInfo[playerid][pSprunk],
PlayerInfo[playerid][pMask],
PlayerInfo[playerid][pPhoneBalance],
PlayerInfo[playerid][pTruckSkill],
PlayerInfo[playerid][cModel],
PlayerInfo[playerid][cClass],
PlayerInfo[playerid][cFuel],
PlayerInfo[playerid][cColor][0],
PlayerInfo[playerid][cColor][1],
PlayerInfo[playerid][cLock],
PlayerInfo[playerid][cCost],
PlayerInfo[playerid][cVehcom],
PlayerInfo[playerid][cPaintjob],
PlayerInfo[playerid][pProc],
PlayerInfo[playerid][pZavisimost],
PlayerInfo[playerid][pArestov],
PlayerInfo[playerid][pWantedKills],
PlayerInfo[playerid][pTotalWarns],
PlayerInfo[playerid][pLastIP]);
mysql_free_result();
sscanf(PlayerInfo[playerid][cVehcom], "p<,>a<i>[14]",PlayerInfo[playerid][cVehcoms]);
LoadMyCar(playerid);
PlayerLogged[playerid] = true;
TimeLogged[playerid] = -1;
sscanf(PlayerInfo[playerid][pTexts], "p<,>a<i>[3]", PlayerInfo[playerid][pText]);
sscanf(PlayerInfo[playerid][pPhones], "p<,>a<i>[3]", PlayerInfo[playerid][pPhone]);
sscanf(PlayerInfo[playerid][pLics], "p<,>a<i>[5]",PlayerInfo[playerid][pLic]);
if(PlayerInfo[playerid][pVIP] > 1) SendClientMessage(playerid, 0xFEBC41AA, "Здравствуйте VIP игрок!");
if(PlayerInfo[playerid][pAdmin] > 0) AdminLogged[playerid] = true, SendMes(playerid, COLOR_REDD,"Вы вошли как модератор %d уровня",PlayerInfo[playerid][pAdmin]);
format(string, 64, "~w~Welcome ~n~~b~ %s", PlayerInfo[playerid][pSendername]);
GameTextForPlayer(playerid, string, 3500, 1);
if (PlayerInfo[playerid][pText][0] == 1)
{
SendClientMessage(playerid, COLOR_YELLOW, "Ваш дом был продан гос-ву за неуплату квартплаты");
SendClientMessage(playerid, COLOR_YELLOW, "Ваши деньги за дом были перечислены на ваш счет");
PlayerInfo[playerid][pText][0] = 0;
format(PlayerInfo[playerid][pTexts], 20, "%i, %i, %i", PlayerInfo[playerid][pText][0], PlayerInfo[playerid][pText][1], PlayerInfo[playerid][pText][2]);
format(query, 256, "UPDATE "TABLE_ACCOUNT" SET text = '%s' WHERE name = '%s'", PlayerInfo[playerid][pTexts], PlayerInfo[playerid][pSendername]);
mysql_query(query);
}
if(PlayerInfo[playerid][pText][1] == 1)
{
SendClientMessage(playerid, COLOR_YELLOW,"Ваш бизнес был продан гос-ву за неуплату налогов");
SendClientMessage(playerid, COLOR_YELLOW,"Ваши деньги за бизнес были перечислены на ваш счет");
PlayerInfo[playerid][pText][1] = 0;
format(PlayerInfo[playerid][pTexts], 20, "%i, %i, %i", PlayerInfo[playerid][pText][0], PlayerInfo[playerid][pText][1], PlayerInfo[playerid][pText][2]);
format(query, 256, "UPDATE "TABLE_ACCOUNT" SET text = '%s' WHERE name = '%s'", PlayerInfo[playerid][pTexts], PlayerInfo[playerid][pSendername]);
mysql_query(query);
}
if(PlayerInfo[playerid][pText][2] == 1)
{
new p = PlayerInfo[playerid][pRefMoney] / 100000;
for(new i = 1; i <= p; i++)
{
GiveMoney(playerid, 100000);
PlayerInfo[playerid][pRefMoney] -= 100000;
}
PlayerInfo[playerid][pText][2] = 0;
format(PlayerInfo[playerid][pTexts], 20, "%i, %i, %i", PlayerInfo[playerid][pText][0], PlayerInfo[playerid][pText][1], PlayerInfo[playerid][pText][2]);
format(query, 256, "UPDATE "TABLE_ACCOUNT" SET text = '%s', refmoney WHERE name = '%s'", PlayerInfo[playerid][pTexts], PlayerInfo[playerid][pRefMoney], PlayerInfo[playerid][pSendername]);
mysql_query(query);
}
if(PlayerInfo[playerid][pGunSkill][6] >= NORM_SKILLS_PLAYER) VehRe[playerid] = true;
SetSpawnInfo(playerid, 255, PlayerInfo[playerid][pModel], 0, 0, 0, 1.0, -1, -1, -1, -1, -1, -1);
SpawnPlayer(playerid);
new str123[12];
GetPlayerIp(playerid,str123,12);
format(string, 64, "%s зашел в аккаунт с ip: %s",PlayerInfo[playerid][pSendername],str123);
Log("LogInfo",string);
DeletePVar(playerid,"Acc");
SetPlayerInt(PlayerInfo[playerid][pSendername], "online", 1);
}
return 1;
}
