DennyShow
Новичок
PHP:
stock CreateNewAccount(playerid, key[])
{
new query_string[66+MAX_PLAYER_NAME-4+30];
format(query_string, sizeof(query_string), "INSERT INTO `accounts` (`name`, `key`) VALUES ('%s', '%s')", PlayerInfo[playerid][pName], key);
mysql_function_query(mysql_connect_ID, query_string, true, "UploadPlayerAccountNumber", "i", playerid);
format(query_string, sizeof(query_string), "Àêêàóíò %s óñïåøíî çàðåãèñòðèðîâàí. Àäìèíèñòðàöèÿ æåëàåò Âàì ïðèÿòíîé èãðû!", PlayerInfo[playerid][pName]);
SendClientMessage(playerid, 0xFFFFFF00, query_string);
player_is_authorized{playerid} = 1;
SpawnPlayer(playerid);
return 1;
}
public UploadPlayerAccount(playerid)
{
PlayerInfo[playerid][pID] = cache_get_field_content_int(0, "id", mysql_connect_ID);
printf("%i", PlayerInfo[playerid][pID]);
cache_get_field_content(0, "mail", PlayerInfo[playerid][pMail], mysql_connect_ID, 32);
PlayerInfo[playerid][pLevel] = cache_get_field_content_int(0, "level", mysql_connect_ID);
PlayerInfo[playerid][pMoney] = cache_get_field_content_int(0, "Money", mysql_connect_ID);
PlayerInfo[playerid][pExp] = cache_get_field_content_int(0, "exp", mysql_connect_ID);
PlayerInfo[playerid][pWarn] = cache_get_field_content_int(0, "warn", mysql_connect_ID);
PlayerInfo[playerid][pNumber] = cache_get_field_content_int(0, "number", mysql_connect_ID);
PlayerInfo[playerid][pCashNumber] = cache_get_field_content_int(0, "cashnumber", mysql_connect_ID);
PlayerInfo[playerid][pZakon] = cache_get_field_content_int(0, "zakon", mysql_connect_ID);
PlayerInfo[playerid][pZvezda] = cache_get_field_content_int(0, "zvezda", mysql_connect_ID);
PlayerInfo[playerid][pNarko] = cache_get_field_content_int(0, "narko", mysql_connect_ID);
PlayerInfo[playerid][pZavNarko] = cache_get_field_content_int(0, "zavnarko", mysql_connect_ID);
PlayerInfo[playerid][pAmmo] = cache_get_field_content_int(0, "ammo", mysql_connect_ID);
PlayerInfo[playerid][pSex] = cache_get_field_content_int(0, "sex", mysql_connect_ID);
PlayerInfo[playerid][pAge] = cache_get_field_content_int(0, "age", mysql_connect_ID);
PlayerInfo[playerid][pMember] = cache_get_field_content_int(0, "member", mysql_connect_ID);
PlayerInfo[playerid][pRank] = cache_get_field_content_int(0, "rank", mysql_connect_ID);
PlayerInfo[playerid][pHouse] = cache_get_field_content_int(0, "house", mysql_connect_ID);
PlayerInfo[playerid][pBiz] = cache_get_field_content_int(0, "biz", mysql_connect_ID);
PlayerInfo[playerid][pHotel] = cache_get_field_content_int(0, "hotel", mysql_connect_ID);
PlayerInfo[playerid][pRabota] = cache_get_field_content_int(0, "rabota", mysql_connect_ID);
PlayerInfo[playerid][pAdmin] = cache_get_field_content_int(0, "admin", mysql_connect_ID);
PlayerInfo[playerid][pDostup] = cache_get_field_content_int(0, "dostup", mysql_connect_ID);
PlayerInfo[playerid][pHealth] = cache_get_field_content_float(0, "Health", mysql_connect_ID);
PlayerInfo[playerid][pBronya] = cache_get_field_content_float(0, "Bronya", mysql_connect_ID);
PlayerInfo[playerid][pSkin] = cache_get_field_content_int(0, "Skin", mysql_connect_ID);
PlayerInfo[playerid][pLicAvto] = cache_get_field_content_int(0, "LicAvto", mysql_connect_ID);
PlayerInfo[playerid][pLicGun] = cache_get_field_content_int(0, "LicGun", mysql_connect_ID);
PlayerInfo[playerid][pLicBiz] = cache_get_field_content_int(0, "LicBiz", mysql_connect_ID);
PlayerInfo[playerid][pLicLodka] = cache_get_field_content_int(0, "LicLodka", mysql_connect_ID);
PlayerInfo[playerid][pLicVert] = cache_get_field_content_int(0, "LicVert", mysql_connect_ID);
PlayerInfo[playerid][pWeapon] = cache_get_field_content_int(0, "Weapon", mysql_connect_ID);
PlayerInfo[playerid][pMats] = cache_get_field_content_int(0, "Mats", mysql_connect_ID);
PlayerInfo[playerid][pCard] = cache_get_field_content_int(0, "Card", mysql_connect_ID);
PlayerInfo[playerid][pPassCard] = cache_get_field_content_int(0, "PassCard", mysql_connect_ID);
PlayerInfo[playerid][pNalCar] = cache_get_field_content_int(0, "NalCar", mysql_connect_ID);
PlayerInfo[playerid][pCar] = cache_get_field_content_int(0, "Car", mysql_connect_ID);
PlayerInfo[playerid][pDonat] = cache_get_field_content_int(0, "Donat", mysql_connect_ID);
PlayerInfo[playerid][pMuteTime] = cache_get_field_content_int(0, "MuteTime", mysql_connect_ID);
PlayerInfo[playerid][pBan] = cache_get_field_content_int(0, "Ban", mysql_connect_ID);
cache_get_field_content(0, "RegIp", PlayerInfo[playerid][pRegIp], mysql_connect_ID, 32);
cache_get_field_content(0, "LastIp", PlayerInfo[playerid][pLastIp], mysql_connect_ID, 32);
PlayerInfo[playerid][pSkinOrg] = cache_get_field_content_int(0, "SkinOrg", mysql_connect_ID);
PlayerInfo[playerid][pKod] = cache_get_field_content_int(0, "Kod", mysql_connect_ID);
cache_get_field_content(0, "Ref", PlayerInfo[playerid][pRef], mysql_connect_ID, 24);
cache_get_field_content(0, "Nacia", PlayerInfo[playerid][pNacia], mysql_connect_ID, 16);
PlayerInfo[playerid][pLeader] = cache_get_field_content_int(0, "Leader", mysql_connect_ID);
PlayerInfo[playerid][pZamLeader] = cache_get_field_content_int(0, "ZamLeader", mysql_connect_ID);
cache_get_field_content(0, "Prichina", PlayerInfo[playerid][pPrichina], mysql_connect_ID, 20);
TextDrawShowForPlayer(playerid, Textdraw0);
TextDrawShowForPlayer(playerid, Textdraw1);
TextDrawShowForPlayer(playerid, Textdraw2);
TextDrawShowForPlayer(playerid, Textdraw3);
TextDrawShowForPlayer(playerid, Textdraw4);
TextDrawShowForPlayer(playerid, Textdraw5);
TextDrawShowForPlayer(playerid, Textdraw6);
SendClientMessage(playerid, COLOR_GREEN, "Âû óñïåøíî àâòîðèçîâàëèñü. Ïðèÿòíîé èãðû!");
player_is_authorized{playerid} = 1;
SpawnPlayer(playerid);
return 1;
}
stock SaveAccount(playerid)
{
new string[1000];
format(string, sizeof(string), "UPDATE `accounts` SET");
format(string, sizeof(string), "%s `name` = '%s',", string, PlayerInfo[playerid][pName]);
format(string, sizeof(string), "%s `key` = '%s',", string, PlayerInfo[playerid][pKey]);
format(string, sizeof(string), "%s `mail` = '%s',", string, PlayerInfo[playerid][pMail]);
format(string, sizeof(string), "%s `level` = '%i',", string, PlayerInfo[playerid][pLevel]);
format(string, sizeof(string), "%s `Money` = '%i',", string, PlayerInfo[playerid][pMoney]);
format(string, sizeof(string), "%s `exp` = '%i',", string, PlayerInfo[playerid][pExp]);
format(string, sizeof(string), "%s `warn` = '%i',", string, PlayerInfo[playerid][pWarn]);
format(string, sizeof(string), "%s `number` = '%i',", string, PlayerInfo[playerid][pNumber]);
format(string, sizeof(string), "%s `cashnumber` = '%i',", string, PlayerInfo[playerid][pCashNumber]);
format(string, sizeof(string), "%s `zakon` = '%i',", string, PlayerInfo[playerid][pZakon]);
format(string, sizeof(string), "%s `zvezda` = '%i',", string, PlayerInfo[playerid][pZvezda]);
format(string, sizeof(string), "%s `narko` = '%i',", string, PlayerInfo[playerid][pNarko]);
format(string, sizeof(string), "%s `zavnarko` = '%i',", string, PlayerInfo[playerid][pZavNarko]);
format(string, sizeof(string), "%s `ammo` = '%i',", string, PlayerInfo[playerid][pAmmo]);
format(string, sizeof(string), "%s `sex` = '%i',", string, PlayerInfo[playerid][pSex]);
format(string, sizeof(string), "%s `age` = '%i',", string, PlayerInfo[playerid][pAge]);
format(string, sizeof(string), "%s `member` = '%i',", string, PlayerInfo[playerid][pMember]);
format(string, sizeof(string), "%s `rank` = '%i',", string, PlayerInfo[playerid][pRank]);
format(string, sizeof(string), "%s `house` = '%i',", string, PlayerInfo[playerid][pHouse]);
format(string, sizeof(string), "%s `biz` = '%i',", string, PlayerInfo[playerid][pBiz]);
format(string, sizeof(string), "%s `hotel` = '%i',", string, PlayerInfo[playerid][pHotel]);
format(string, sizeof(string), "%s `rabota` = '%i',", string, PlayerInfo[playerid][pRabota]);
format(string, sizeof(string), "%s `admin` = '%i',", string, PlayerInfo[playerid][pAdmin]);
format(string, sizeof(string), "%s `dostup` = '%i',", string, PlayerInfo[playerid][pDostup]);
format(string, sizeof(string), "%s `Health` = '%f',", string, PlayerInfo[playerid][pHealth]);
format(string, sizeof(string), "%s `Bronya` = '%f',", string, PlayerInfo[playerid][pBronya]);
format(string, sizeof(string), "%s `Skin` = '%i',", string, PlayerInfo[playerid][pSkin]);
format(string, sizeof(string), "%s `LicAvto` = '%i',", string, PlayerInfo[playerid][pLicAvto]);
format(string, sizeof(string), "%s `LicGun` = '%i',", string, PlayerInfo[playerid][pLicGun]);
format(string, sizeof(string), "%s `LicBiz` = '%i',", string, PlayerInfo[playerid][pLicBiz]);
format(string, sizeof(string), "%s `LicLodka` = '%i',", string, PlayerInfo[playerid][pLicLodka]);
format(string, sizeof(string), "%s `LicVert` = '%i',", string, PlayerInfo[playerid][pLicVert]);
format(string, sizeof(string), "%s `Weapon` = '%i',", string, PlayerInfo[playerid][pWeapon]);
format(string, sizeof(string), "%s `Mats` = '%i',", string, PlayerInfo[playerid][pMats]);
format(string, sizeof(string), "%s `Card` = '%i',", string, PlayerInfo[playerid][pCard]);
format(string, sizeof(string), "%s `PassCard` = '%i',", string, PlayerInfo[playerid][pPassCard]);
format(string, sizeof(string), "%s `NalCar` = '%i',", string, PlayerInfo[playerid][pNalCar]);
format(string, sizeof(string), "%s `Car` = '%i',", string, PlayerInfo[playerid][pCar]);
format(string, sizeof(string), "%s `Donat` = '%i',", string, PlayerInfo[playerid][pDonat]);
format(string, sizeof(string), "%s `MuteTime` = '%i',", string, PlayerInfo[playerid][pMuteTime]);
format(string, sizeof(string), "%s `Ban` = '%i',", string, PlayerInfo[playerid][pBan]);
format(string, sizeof(string), "%s `RegIp` = '%s',", string, PlayerInfo[playerid][pRegIp]);
format(string, sizeof(string), "%s `LastIp` = '%s',", string, PlayerInfo[playerid][pLastIp]);
format(string, sizeof(string), "%s `SkinOrg` = '%i',", string, PlayerInfo[playerid][pSkinOrg]);
format(string, sizeof(string), "%s `Kod` = '%i',", string, PlayerInfo[playerid][pKod]);
format(string, sizeof(string), "%s `Ref` = '%s',", string, PlayerInfo[playerid][pRef]);
format(string, sizeof(string), "%s `Nacia` = '%s',", string, PlayerInfo[playerid][pNacia]);
format(string, sizeof(string), "%s `Leader` = '%i',", string, PlayerInfo[playerid][pLeader]);
format(string, sizeof(string), "%s `ZamLeader` = '%i',", string, PlayerInfo[playerid][pZamLeader]);
format(string, sizeof(string), "%s `Prichina` = '%s'", string, PlayerInfo[playerid][pPrichina]);
format(string, sizeof(string), "%s WHERE `id` = '%i'", string, PlayerInfo[playerid][pID]);
PlayerInfo[playerid][pPickOrg] = 0;
mysql_function_query(mysql_connect_ID, string, true, "", "", playerid);
print(string);
return 1;
}