Адель Нурутдинов
Новичок
Сделал сохранение водительских прав и сохранение и выдачу лицензии на оружие,сделал все аналогично друг другу,но вод.права он сохраняет,а лиц.на оружие нет,помогите,вот код сохранения:
Вот выдача:
И загрузка вот:
Таблицы обе созданы в БД
PHP:
public OnSave(i)
{
if(GetPVarInt(i,"OnSave") == 1 || !User[i][Login]) return true;
SetPVarInt(i,"OnSave",1);
for(new idx = 1; idx < 11; idx++) GetPlayerWeaponData(i,idx,User[i][Weapon][idx-1],User[i][Ammo][idx-1]);
format(User[i][pWeapons],32,"%i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i",User[i][Weapon][0], User[i][Weapon][1], User[i][Weapon][2], User[i][Weapon][3],
User[i][Weapon][4], User[i][Weapon][5], User[i][Weapon][6], User[i][Weapon][7], User[i][Weapon][8], User[i][Weapon][9], User[i][Weapon][10]);
format(User[i][Ammos],32,"%i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i",User[i][Ammo][0], User[i][Ammo][1], User[i][Ammo][2], User[i][Ammo][3],
User[i][Ammo][4], User[i][Ammo][5], User[i][Ammo][6], User[i][Ammo][7], User[i][Ammo][8], User[i][Ammo][9], User[i][Ammo][10]);
format(User[i][CarLics],7,"%i",User[i][CarLic]);
format(User[i][GunLic1],7,"%i",User[i][GunLic]);
format(User[i][Warns],7,"%i, %i",User[i][Warn][0],User[i][Warn][1]);
format(User[i][Drugs],19,"%i, %i, %i, %i, %i",User[i][Drug][0],User[i][Drug][1],User[i][Drug][2],User[i][Drug][3],User[i][Drug][4]);
format(User[i][Phones],36,"%i, %i",User[i][Phone][0],User[i][Phone][1]);
format(User[i][UTexts],16,"%i, %i, %i",User[i][Text][0],User[i][Text][1],User[i][Text][2]);
format(User[i][Upgrades],15,"%i, %i, %i",User[i][Upgrade][0],User[i][Upgrade][1],User[i][Upgrade][2]);
format(User[i][GunSkills1],30,"%i",User[i][GunSkill][0]);
format(User[i][GunSkills2],30,"%i",User[i][GunSkill][1]);
format(User[i][GunSkills3],30,"%i",User[i][GunSkill][2]);
format(User[i][GunSkills4],30,"%i",User[i][GunSkill][3]);
format(User[i][GunSkills5],30,"%i",User[i][GunSkill][4]);
format(User[i][GunSkills6],30,"%i",User[i][GunSkill][5]);
format(User[i][Quests],7,"%i, %i",User[i][Quest][0],User[i][Quest][1]);
new sp;
if(SpawnChange[i]) sp = 1;
else sp = 0;
new name[32];
GetPlayerName(i,name,sizeof(name));
mysql_format(DATABASE, QUERY, sizeof(QUERY), "UPDATE `accounts` SET `Skin` = '%i',`Sex` = '%i', `Mail` = '%s', `Cash` = '%i', `Level` = '%i', `PayDay` = '%i', `Exp` = '%i', `Bank` = '%i', `Leader` = '%i', `Member` = '%i', `Model` = '%i',`Rank` = '%i'",User[i][Skin],User[i][Sex],User[i][Mail],User[i][Cash],User[i][Level],User[i][PayDay],User[i][Exp],User[i][Bank],User[i][Leader],User[i][Member],User[i][Model],User[i][Rank]);
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s ,`Kills` = '%i',`Deaths` = '%i',`Wanted` = '%i',`DataReg` = '%s',`IpReg` = '%s',`Vhod` = '%s',`KeyIp` = '%s', `CheckIp` = '%i',`IpVhod` = '%s',`Crimes` = '%i', `JailTime` = '%i', `Arrested` = '%i', `MestoJail` = '%i'", QUERY, User[i][Kills],User[i][Deaths],User[i][Wanted],User[i][DataReg],User[i][IpReg],User[i][Vhod],User[i][KeyIp],User[i][CheckIp],User[i][IpVhod],User[i][Crimes],User[i][JailTime],User[i][Arested],User[i][MestoJail]);
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s ,`Mute` = '%i', `CarLics` = '%i', `GunLic1` = '%i', `Phones` = '%s', `Lottery` = '%i', `Health` = '%f', `Locked` = '%i', `Warns` = '%s', `Drugs` = '%s', `Upgrades` = '%s'",QUERY, User[i][Mute],User[i][CarLic],User[i][GunLic],User[i][Phones],User[i][Lottery],User[i][Health],User[i][Locked],User[i][Warns],User[i][Drugs],User[i][Upgrades]);
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s ,`GunSkills1` = '%i', `GunSkills2` = '%i', `GunSkills3` = '%i', `GunSkills4` = '%i', `GunSkills5` = '%i', `GunSkills6` = '%i', `PayDayCash` = '%i', `Texts` = '%s'",QUERY,User[i][GunSkill][0],User[i][GunSkill][1],User[i][GunSkill][2],User[i][GunSkill][3],User[i][GunSkill][4],User[i][GunSkill][5],User[i][PayDayCash],User[i][UTexts]);
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s ,`Addiction` = '%i', `Addiction2` = '%i', `WantedDeaths` = '%i', `Mats` = '%i', `Debt` = '%i', `Debt2` = '%i', `Job` = '%i', `Obedience` = '%i', `Referal` = '%s', `Station` = '%i', `TaxiSkill` = '%i', `TaxiSkill2` = '%i'",QUERY,User[i][Addiction][0],User[i][Addiction][1],User[i][WantedDeaths], User[i][Mats],User[i][Debt][0],User[i][Debt][1],User[i][Job],User[i][Obedience],User[i][Referal],User[i][Station],User[i][TaxiSkill][0],User[i][TaxiSkill][1]);
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s ,`Weapons` = '%s', `Ammos` = '%s', `Satiety` = '%i', `Married` = '%s', `MemGroup` = '%i', `Quests` = '%s', `SP` = '%d',`EKeys` = '%i',`EForm` = '%i',`Walk` = '%i'",QUERY,User[i][pWeapons],User[i][Ammos], User[i][Satiety], User[i][Married], User[i][MemGroup], User[i][Quests], sp,User[i][EKeys],User[i][EForm],User[i][Walk]);
mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s WHERE `Name` = '%e'", QUERY, name);
mysql_function_query(DATABASE, QUERY, false, "", "");
return DeletePVar(i,"OnSave");
}
PHP:
case D_LIC:
{
if(!response) return DeletePVar(playerid, "LicName");
new text[52];
switch(listitem)
{
case 0: text = "Водительские права (Базовый уровень)",User[GetPVarInt(playerid, "LicName")][CarLic] = 1;
case 1: text = "Водительские права (Профф. уровень)",User[GetPVarInt(playerid, "LicName")][CarLic] = 2;
case 2: text = "Разрешение на ношение оружия",User[GetPVarInt(playerid, "LicName")][GunLic] = 1;
case 3:
{
if(GetPlayerBizz(GetPVarInt(playerid, "LicName")) == 0) return SendClientMessage(playerid,COLOR_WHITE,"Игрок не владеет бизнесом!");
new i = GetPVarInt(GetPVarInt(playerid, "LicName"),"PlayerBizz");
text = "Лицензию на бизнес",BizzInfo[i][bLic] = 1;
}
}
SendMes(playerid, COLOR_BLUE, "Вы выдали %s %s", text, User[GetPVarInt(playerid, "LicName")][Name]);
SendMes(GetPVarInt(playerid, "LicName"), COLOR_BLUE, "%s %s выдал вам %s", GetRankName(playerid), User[playerid][Name], text);
DeletePVar(playerid, "LicName");
}
PHP:
cache_get_field_content(0, "CarLics",User[i][CarLics],DATABASE,6);
cache_get_field_content(0, "GunLic1",User[i][GunLic1],DATABASE,6);