MYSQL R7

[Sharkoff]

Не работает сохранение аккаунта в БД, также не создается аккаунт в БД при регистрации.

stock PlayerSaver(a) {
	new query[512],str7[32],str2[32],str3[32],str4[64],name[24],exit_query[2048];
	if(!strlen(PlayerInfo[a][BanReason])) sscanf("none","s[64]",PlayerInfo[a][BanReason]);
	if(!strlen(PlayerInfo[a][RealCity])) sscanf("none","s[32]",PlayerInfo[a][RealCity]);
	if(!strlen(AdminPassword[a])) sscanf("os","s[32]",AdminPassword[a]);
	mysql_real_escape_string(AdminPassword[a],str7);
	mysql_real_escape_string(PlayerInfo[a][pKey],str2);
	mysql_real_escape_string(PlayerName[a],name);
	mysql_real_escape_string(PlayerIP[a],str3);
	mysql_real_escape_string(PlayerInfo[a][BanReason],str4);
	format(query,sizeof(query),"UPDATE `Users` SET `Password` = '%s', `LastIP` = '%s', `AdminPass` = '%s', `BanReason` = '%s'",
	                                                                                    	str2,str3,str7,str4);
	strcat(exit_query,query);

	format(query,sizeof(query),", `AdminLevel` = '%d', `Leader` = '%d', `Member` = '%d', `House` = '%d',`HouseKey` = '%d', `Level` = '%d',`Donate` = '%d'",
			PlayerInfo[a][pAdmin],PlayerInfo[a][pLeader],PlayerInfo[a][pMember],PlayerInfo[a][pHouse],PlayerInfo[a][pHouseKey],PlayerInfo[a][pLevel],PlayerInfo[a][pDonateRank]);
    strcat(exit_query,query);

	format(query,sizeof(query),", `Warns` = '%d', `Banned` = '%d', `Helper` = '%d', `Exp` = '%d', `Cash` = '%d', `Bank` = '%d', `FamMember` = '%d', `RaceMember` = '%d', `RaceLeader` = '%d'",
	        PlayerInfo[a][pWarns],PlayerInfo[a][pBanned],PlayerInfo[a][pHelper],PlayerInfo[a][pExp],GetPlayerMoney(a),PlayerInfo[a][pAccount],PlayerInfo[a][pFMember],PlayerInfo[a][RaceMember],PlayerInfo[a][RaceLeader]);
    strcat(exit_query,query);

	format(query,sizeof(query),", `CarLic` = '%d', `FlyLic` = '%d', `GunLic` = '%d', `BoatLic` = '%d', `FishLic` = '%d', `Mats` = '%d', `Drugs` = '%d', `WarehouseMats` = '%d'",
	        PlayerInfo[a][pCarLic],PlayerInfo[a][pFlyLic],PlayerInfo[a][pGunLic],PlayerInfo[a][pBoatLic],PlayerInfo[a][pFishLic],PlayerInfo[a][pMats],PlayerInfo[a][pDrugs],PlayerInfo[a][ptMats]);
    strcat(exit_query,query);

	format(query,sizeof(query),", `Wanted` = '%d', `JailTime` = '%d', `Jailed` = '%d',`DetSkill` = '%d', `SexSkill` = '%d', \
								 `BoxSkill` = '%d',`LawSkill` = '%d',`MechSkill` = '%d',`JackSkill` = '%d',`CarSkill` = '%d',`NewsSkill` = '%d', \
								`DrugsSkill` = '%d',`CookSkill` = '%d',`FishSkill` = '%d',`ArmsSkill` = '%d'",
            PlayerInfo[a][pWanted],PlayerInfo[a][pJailTime],PlayerInfo[a][pJailed],PlayerInfo[a][pDetSkill],PlayerInfo[a][pSexSkill],PlayerInfo[a][pBoxSkill],PlayerInfo[a][pLawSkill],PlayerInfo[a][pMechSkill],PlayerInfo[a][pJackSkill],PlayerInfo[a][pCarSkill],
            PlayerInfo[a][pNewsSkill],PlayerInfo[a][pDrugsSkill],PlayerInfo[a][pCookSkill],PlayerInfo[a][pFishSkill],PlayerInfo[a][pArmsSkill]);
    strcat(exit_query,query);

	format(query,sizeof(query),", `Skin` = '%d', `Tutorial` = '%d',`City` = '%d',`Sex` = '%d',`Rank` = '%d',`Job` = '%d',`Phone` = '%d', `HeadValue` = '%d', `PayCheck` = '%d', `PhoneBook` = '%d'",
	        GetPlayerSkin(a),PlayerInfo[a][pTut],PlayerInfo[a][pOrigin],PlayerInfo[a][pSex],PlayerInfo[a][pRank],PlayerInfo[a][pJob],PlayerInfo[a][pPnumber],PlayerInfo[a][pHeadValue],PlayerInfo[a][pPayCheck],PlayerInfo[a][pPhoneBook]);
    strcat(exit_query,query);

    format(query,sizeof(query),", `ContractTime` = '%d', `BizKey` = '%d',`PayDay` = '%d',`MutedTime` = '%d',`Muted` = '%d',`LastConnect` = '%s' WHERE `ID` = '%d' AND `Name` = '%s'",
            PlayerInfo[a][pContractTime],PlayerInfo[a][BizKey],PlayerInfo[a][pPayDay],PlayerInfo[a][pMutedTime],PlayerInfo[a][pMuted],LastConnect[a],PlayerID[a],name);
    strcat(exit_query,query);
    mysql_query(exit_query,-1,-1,mysqlid);
    format(exit_query,sizeof(exit_query),"UPDATE `Users` SET `TakeReason1`='%s',`TakeReason2`='%s',`TakeReason3`='%s',`TakeDays1`='%d',`TakeDays2`='%d',`TakeDays3`='%d',`TicketMoney`='%d',`FreeInDay`='%d' WHERE `ID` = '%d' AND `Name` = '%s'",
    PlayerInfo[a][TakeReason1],PlayerInfo[a][TakeReason2],PlayerInfo[a][TakeReason3],
	PlayerInfo[a][TakeDays1],PlayerInfo[a][TakeDays2],PlayerInfo[a][TakeDays3],TicketMoney[a],FreeInDay[a],PlayerID[a],name);
    mysql_query(exit_query,-1,-1,mysqlid);
    printf("Account %s saved.",PlayerName[a]);
	return 1;
}

Просите еще скидывать что требуется.