FreeHardSkill
Умник
PHP:
AccountCreate(playerid, password[])
{
new str[500];
format(query_mysql, sizeof(query_mysql),"INSERT INTO `accounts` ( ");
scf(query_mysql, str,"`Name`,`password`,`level`,`Exp`,`admin`,`sex`,`Char`,`Reg`,`money`,");
scf(query_mysql, str,"`AdminParol`,`AdmLog`,`Helper`,`HelperLeader`,`MoneyBank`,`Team`,`Tut`,");
scf(query_mysql, str,"`Muted`,`MutedTime`,`BanTime`,`BanData`,`ban`,`Jailed`,`JailTime`,");
scf(query_mysql, str,"`Bolnicad`,`BolnicaTime`,`TieWarn`,`warn`,`WarnsBan`,`Knopka`,`ChelZombi`,");
scf(query_mysql, str,"`Profi`,`CarKey`,`HouseKey`,`BizKey`,`Aptechka`,`Vzlom`,`Upgrade`,");
scf(query_mysql, str,"`Udacha`,`Vzlomup`,`HPup`,`Fish`,`SpawnChange`,`member`,`Leader`,");
scf(query_mysql, str,"`rank`,`LicDravingb`,`LicDravingc`,`LicFishing`,`LicFlying`,`LicSailing`,`LicWeapon`,");
scf(query_mysql, str,"`LicBusiness`,`Wanted`,`Jobs`,`GruzSkill`,`ShahtSkill`,`DalnoboySkill`,`RazvProdsSkill`,");
scf(query_mysql, str,"`FermerSkill`,`GruzSkillOchki`,`ShahtSkillOchki`,`DalnoboySkillOchki`,`RazvProdsSkillOchki`,`FermerSkillOchki`,`DrugsSkill`,");
scf(query_mysql, str,"`DrugsSkillOchki`,`MatsSkill`,`MatsSkillOchki`,`OtkatJobs`,`Obnovi`,`CopVigovor`,`RobOtkat`,");
scf(query_mysql, str,"`GrabOtkat`,`Drugs`,`Mats`,`InvWeapon1`,`InvWeapon2`,`InvWeapon3`,`InvWeapon4`,");
scf(query_mysql, str,"`InvWeapon5`,`InvWeaponAmmo1`,`InvWeaponAmmo2`,`InvWeaponAmmo3`,`InvWeaponAmmo4`,`InvWeaponAmmo5`,`InvAmmo1`,");
scf(query_mysql, str,"`InvAmmo2`,`InvAmmo3`,`InvAmmo4`,`InvAmmo5`,`InvAptechka`,`InvDrugs`,`InvMats`,");
scf(query_mysql, str,"`InvVzlom`,`Logout`,`InvAmmo4`,`InvAmmo5`,`InvAptechka`,`InvDrugs`,`InvMats`,`id`) VALUES ( ");
scf(query_mysql, str,"'%s',",PlayerInfo[playerid][pName]);
scf(query_mysql, str,"'%s',",password);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pLevel]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pExp]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pAdmin]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pSex]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pChar]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pReg]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pMoney]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pAdminParol]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pAdmLog]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pHelper]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pHelperLeader]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pMoneyBank]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pTeam]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pTut]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pMuted]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pMutedTime]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pBanTime]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pBanData]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pBan]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pJailed]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pJailTime]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pBolnicad]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pBolnicaTime]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pTieWarn]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pWarns]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pWarnsBan]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pKnopka]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pChelZombi]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pProfi]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pCarKey]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pHouseKey]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pBiznesKey]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pAptechka]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pVzlom]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pUpgrade]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pUdacha]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pVzlomup]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pHPup]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pFish]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pSpawnChange]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pMember]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pLeader]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pRang]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pLicDravingb]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pLicDravingc]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pLicFishing]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pLicFlying]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pLicSailing]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pLicWeapon]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pLicBusiness]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pWanted]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pJobs]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pGruzSkill]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pShahtSkill]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pDalnoboySkill]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pRazvProdsSkill]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pFermerSkill]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pGruzSkillOchki]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pShahtSkillOchki]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pDalnoboySkillOchki]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pRazvProdsSkillOchki]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pFermerSkillOchki]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pDrugsSkill]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pDrugsSkillOchki]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pMatsSkill]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pMatsSkillOchki]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pOtkatJobs]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pObnovi]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pCopVigovor]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pRobOtkat]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pGrabOtkat]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pDrugs]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pMats]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pInvWeapon1]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pInvWeapon2]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pInvWeapon3]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pInvWeapon4]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pInvWeapon5]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pInvWeaponAmmo1]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pInvWeaponAmmo2]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pInvWeaponAmmo3]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pInvWeaponAmmo4]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pInvWeaponAmmo5]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pInvAmmo1]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pInvAmmo2]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pInvAmmo3]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pInvAmmo4]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pInvAmmo5]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pInvAptechka]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pInvDrugs]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pInvMats]);
scf(query_mysql, str,"'%d',",PlayerInfo[playerid][pInvVzlom]);
scf(query_mysql, str,"'%d','0')",PlayerInfo[playerid][pLogout]);
mysql_function_query(connects, query_mysql, false, "", "");
return 1;
}
PHP:
[23:21:20] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `accounts` ( `Name`,`password`,`level`,`Exp`,`admin`", callback: "(null)", format: "(null)"
[23:21:20] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[23:21:20] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[23:21:20] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
Последнее редактирование: