Доступ к архиву

Переход в группу "Пользователь"

300.00 ₽
Одноразовый платёж
Быстрый переход в группу "Пользователи", без надобности написания постов и ожидания.

Покупка дает возможность:
Быть полноправным участником форума
Нормальное копирование кода
Создавать темы
Скачивать файлы
Доступ к архиву Pawno-Info

Не проходит сохранение акк mysql

Статус
В этой теме нельзя размещать новые ответы.

FreeHardSkill

Умник
вот лог
[19:15:46] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `level` = '25',`Exp` = '0',`admin` = '7',`", callback: "(null)", format: "(null)"
[19:15:50] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 70.611 milliseconds
[19:15:50] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[19:15:50] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:15:50] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.366 milliseconds
[19:15:50] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
сам запрос делает вид будто бы ему не хватает переменной
а вот код
PHP:
stock OnPlayerSave(playerid)
{
    new big_query[3000];
	static str[500];
	if(gPlayerLogged[playerid] != 1 && !IsPlayerConnected(playerid)) return 1;
	format(big_query, sizeof(big_query),"UPDATE `accounts` SET ");
	scf(big_query, str,"`level` = '%d',",PlayerInfo[playerid][pLevel]);
	scf(big_query, str,"`Exp` = '%d',",PlayerInfo[playerid][pExp]);
	scf(big_query, str,"`admin` = '%d',",PlayerInfo[playerid][pAdmin]);
	scf(big_query, str,"`sex` = '%d',",PlayerInfo[playerid][pSex]);
	scf(big_query, str,"`Char` = '%d',",PlayerInfo[playerid][pChar]);
	scf(big_query, str,"`Reg` = '%d',",PlayerInfo[playerid][pReg]);
	scf(big_query, str,"`money` = '%d',",PlayerInfo[playerid][pMoney]);
	scf(big_query, str,"`AdminParol` = '%d',",PlayerInfo[playerid][pAdminParol]);
	scf(big_query, str,"`AdmLog` = '%d',",PlayerInfo[playerid][pAdmLog]);
	scf(big_query, str,"`Helper` = '%d',",PlayerInfo[playerid][pHelper]);
	scf(big_query, str,"`HelperLeader` = '%d',",PlayerInfo[playerid][pHelperLeader]);
	scf(big_query, str,"`MoneyBank` = '%d',",PlayerInfo[playerid][pMoneyBank]);
	scf(big_query, str,"`Team` = '%d',",PlayerInfo[playerid][pTeam]);
	scf(big_query, str,"`Tut` = '%d',",PlayerInfo[playerid][pTut]);
	scf(big_query, str,"`Muted` = '%d',",PlayerInfo[playerid][pMuted]);
	scf(big_query, str,"`MutedTime` = '%d',",PlayerInfo[playerid][pMutedTime]);
	scf(big_query, str,"`BanTime` = '%d',",PlayerInfo[playerid][pBanTime]);
	scf(big_query, str,"`BanData` = '%d',",PlayerInfo[playerid][pBanData]);
	scf(big_query, str,"`ban` = '%d',",PlayerInfo[playerid][pBan]);
	scf(big_query, str,"`Jailed` = '%d',",PlayerInfo[playerid][pJailed]);
	scf(big_query, str,"`JailTime` = '%d',",PlayerInfo[playerid][pJailTime]);
	scf(big_query, str,"`Bolnicad` = '%d',",PlayerInfo[playerid][pBolnicad]);
	scf(big_query, str,"`BolnicaTime` = '%d',",PlayerInfo[playerid][pBolnicaTime]);
	scf(big_query, str,"`TieWarn` = '%d',",PlayerInfo[playerid][pTieWarn]);
	scf(big_query, str,"`warn` = '%d',",PlayerInfo[playerid][pWarns]);
	scf(big_query, str,"`WarnsBan` = '%d',",PlayerInfo[playerid][pWarnsBan]);
	scf(big_query, str,"`Knopka` = '%d',",PlayerInfo[playerid][pKnopka]);
	scf(big_query, str,"`ChelZombi` = '%d',",PlayerInfo[playerid][pChelZombi]);
	scf(big_query, str,"`Profi` = '%d',",PlayerInfo[playerid][pProfi]);
	scf(big_query, str,"`CarKey` = '%d',",PlayerInfo[playerid][pCarKey]);
	scf(big_query, str,"`HouseKey` = '%d',",PlayerInfo[playerid][pHouseKey]);
	scf(big_query, str,"`BizKey` = '%d',",PlayerInfo[playerid][pBiznesKey]);
	scf(big_query, str,"`Aptechka` = '%d',",PlayerInfo[playerid][pAptechka]);
	scf(big_query, str,"`Vzlom` = '%d',",PlayerInfo[playerid][pVzlom]);
	scf(big_query, str,"`Upgrade` = '%d',",PlayerInfo[playerid][pUpgrade]);
	scf(big_query, str,"`Udacha` = '%d',",PlayerInfo[playerid][pUdacha]);
	scf(big_query, str,"`Vzlomup` = '%d',",PlayerInfo[playerid][pVzlomup]);
	scf(big_query, str,"`HPup` = '%d',",PlayerInfo[playerid][pHPup]);
	scf(big_query, str,"`Fish` = '%d',",PlayerInfo[playerid][pFish]);
	scf(big_query, str,"`SpawnChange` = '%d',",PlayerInfo[playerid][pSpawnChange]);
	scf(big_query, str,"`member` = '%d',",PlayerInfo[playerid][pMember]);
	scf(big_query, str,"`Leader` = '%d',",PlayerInfo[playerid][pLeader]);
	scf(big_query, str,"`rank` = '%d',",PlayerInfo[playerid][pRang]);
	scf(big_query, str,"`LicDravingb` = '%d',",PlayerInfo[playerid][pLicDravingb]);
	scf(big_query, str,"`LicDravingc` = '%d',",PlayerInfo[playerid][pLicDravingc]);
	scf(big_query, str,"`LicFishing` = '%d',",PlayerInfo[playerid][pLicFishing]);
	scf(big_query, str,"`LicFlying` = '%d',",PlayerInfo[playerid][pLicFlying]);
	scf(big_query, str,"`LicSailing` = '%d',",PlayerInfo[playerid][pLicSailing]);
	scf(big_query, str,"`LicWeapon` = '%d',",PlayerInfo[playerid][pLicWeapon]);
	scf(big_query, str,"`LicBusiness` = '%d',",PlayerInfo[playerid][pLicBusiness]);
	scf(big_query, str,"`Wanted` = '%d',",PlayerInfo[playerid][pWanted]);
	scf(big_query, str,"`Jobs` = '%d',",PlayerInfo[playerid][pJobs]);
	scf(big_query, str,"`GruzSkill` = '%d',",PlayerInfo[playerid][pGruzSkill]);
	scf(big_query, str,"`ShahtSkill` = '%d',",PlayerInfo[playerid][pShahtSkill]);
	scf(big_query, str,"`DalnoboySkill` = '%d',",PlayerInfo[playerid][pDalnoboySkill]);
	scf(big_query, str,"`RazvProdsSkill` = '%d',",PlayerInfo[playerid][pRazvProdsSkill]);
	scf(big_query, str,"`FermerSkill` = '%d',",PlayerInfo[playerid][pFermerSkill]);
	scf(big_query, str,"`GruzSkillOchki` = '%d',",PlayerInfo[playerid][pGruzSkillOchki]);
	scf(big_query, str,"`ShahtSkillOchki` = '%d',",PlayerInfo[playerid][pShahtSkillOchki]);
	scf(big_query, str,"`DalnoboySkillOchki` = '%d',",PlayerInfo[playerid][pDalnoboySkillOchki]);
	scf(big_query, str,"`RazvProdsSkillOchki` = '%d',",PlayerInfo[playerid][pRazvProdsSkillOchki]);
	scf(big_query, str,"`FermerSkillOchki` = '%d',",PlayerInfo[playerid][pFermerSkillOchki]);
	scf(big_query, str,"`DrugsSkill` = '%d',",PlayerInfo[playerid][pDrugsSkill]);
	scf(big_query, str,"`DrugsSkillOchki` = '%d',",PlayerInfo[playerid][pDrugsSkillOchki]);
	scf(big_query, str,"`MatsSkill` = '%d',",PlayerInfo[playerid][pMatsSkill]);
	scf(big_query, str,"`MatsSkillOchki` = '%d',",PlayerInfo[playerid][pMatsSkillOchki]);
	scf(big_query, str,"`OtkatJobs` = '%d',",PlayerInfo[playerid][pOtkatJobs]);
	scf(big_query, str,"`Obnovi` = '%d',",PlayerInfo[playerid][pObnovi]);
	scf(big_query, str,"`CopVigovor` = '%d',",PlayerInfo[playerid][pCopVigovor]);
	scf(big_query, str,"`RobOtkat` = '%d',",PlayerInfo[playerid][pRobOtkat]);
	scf(big_query, str,"`GrabOtkat` = '%d',",PlayerInfo[playerid][pGrabOtkat]);
	scf(big_query, str,"`Drugs` = '%d',",PlayerInfo[playerid][pDrugs]);
	scf(big_query, str,"`Mats` = '%d',",PlayerInfo[playerid][pMats]);
	scf(big_query, str,"`InvWeapon1` = '%d',",PlayerInfo[playerid][pInvWeapon1]);
	scf(big_query, str,"`InvWeapon2` = '%d',",PlayerInfo[playerid][pInvWeapon2]);
	scf(big_query, str,"`InvWeapon3` = '%d',",PlayerInfo[playerid][pInvWeapon3]);
	scf(big_query, str,"`InvWeapon4` = '%d',",PlayerInfo[playerid][pInvWeapon4]);
	scf(big_query, str,"`InvWeapon5` = '%d',",PlayerInfo[playerid][pInvWeapon5]);
	scf(big_query, str,"`InvWeaponAmmo1` = '%d',",PlayerInfo[playerid][pInvWeaponAmmo1]);
	scf(big_query, str,"`InvWeaponAmmo2` = '%d',",PlayerInfo[playerid][pInvWeaponAmmo2]);
	scf(big_query, str,"`InvWeaponAmmo3` = '%d',",PlayerInfo[playerid][pInvWeaponAmmo3]);
	scf(big_query, str,"`InvWeaponAmmo4` = '%d',",PlayerInfo[playerid][pInvWeaponAmmo4]);
	scf(big_query, str,"`InvWeaponAmmo5` = '%d',",PlayerInfo[playerid][pInvWeaponAmmo5]);
	scf(big_query, str,"`InvAmmo1` = '%d',",PlayerInfo[playerid][pInvAmmo1]);
	scf(big_query, str,"`InvAmmo2` = '%d',",PlayerInfo[playerid][pInvAmmo2]);
	scf(big_query, str,"`InvAmmo3` = '%d',",PlayerInfo[playerid][pInvAmmo3]);
	scf(big_query, str,"`InvAmmo4` = '%d',",PlayerInfo[playerid][pInvAmmo4]);
	scf(big_query, str,"`InvAmmo5` = '%d',",PlayerInfo[playerid][pInvAmmo5]);
	scf(big_query, str,"`InvAptechka` = '%d',",PlayerInfo[playerid][pInvAptechka]);
	scf(big_query, str,"`InvDrugs` = '%d',",PlayerInfo[playerid][pInvDrugs]);
	scf(big_query, str,"`InvMats` = '%d',",PlayerInfo[playerid][pInvMats]);
	scf(big_query, str,"`InvVzlom` = '%d',",PlayerInfo[playerid][pInvVzlom]);
	scf(big_query, str,"`Logout` = '%d'",PlayerInfo[playerid][pLogout]);
	scf(big_query, str," WHERE `Name` = '%s'",PlayerInfo[playerid][pName]);
	mysql_function_query(connects, big_query, false, "", "");
	return 1;
}
 
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу