21.02.2013, 14:10
В общем перезадам.
Перевел мод основа RLS на MySQL, сделал таблицу, импортировал, после чего запустил мод, к БД подключился успешно. Зарегестрировался на сервере, потом зашел в localhost/phpmyadmin через Denwer, зашел в базу, а аккаунта попросту там нет. Вот код реги:
Перевел мод основа RLS на MySQL, сделал таблицу, импортировал, после чего запустил мод, к БД подключился успешно. Зарегестрировался на сервере, потом зашел в localhost/phpmyadmin через Denwer, зашел в базу, а аккаунта попросту там нет. Вот код реги:
Код:
stock OnPlayerRegister(playerid) { new string[128]; new query[512]; new name[MAX_PLAYER_NAME]; GetPlayerName(playerid, name, sizeof(name)); if(IsPlayerConnected(playerid)) { query = "UPDATE "TABLE_ACCOUNT" SET "; acc_int_strcat(query, sizeof(query), "Level",PlayerInfo[playerid][pLevel]); acc_int_strcat(query, sizeof(query), "House",PlayerInfo[playerid][pPHousekey]); acc_int_strcat(query, sizeof(query), "Bussines",PlayerInfo[playerid][pPBiskey]); acc_int_strcat(query, sizeof(query), "AdminLevel",PlayerInfo[playerid][pAdmin]); acc_float_strcat(query, sizeof(query), "Fuelcar",PlayerInfo[playerid][pFuelCar]); acc_int_strcat(query, sizeof(query), "Text",PlayerInfo[playerid][pText]); acc_int_strcat(query, sizeof(query), "Health",PlayerInfo[playerid][pHP]); acc_int_strcat(query, sizeof(query), "Satiety",PlayerInfo[playerid][pSatiety]); acc_int_strcat(query, sizeof(query), "Keyip",PlayerInfo[playerid][pKeyip]); acc_int_strcat(query, sizeof(query), "CheckIp",PlayerInfo[playerid][pCheckip]); acc_int_strcat(query, sizeof(query), "DataReg",PlayerInfo[playerid][pDataReg]); acc_int_strcat(query, sizeof(query), "PhoneBook",PlayerInfo[playerid][pPhoneBook]); acc_int_strcat(query, sizeof(query), "Car",PlayerInfo[playerid][pCar]); acc_int_strcat(query, sizeof(query), "DonateAccount",PlayerInfo[playerid][pDonateAccount]); acc_int_strcat(query, sizeof(query), "DonateMoney",PlayerInfo[playerid][pDonateMoney]); acc_int_strcat(query, sizeof(query), "DonateRank",PlayerInfo[playerid][pDonateRank]); acc_int_strcat(query, sizeof(query), "Registered",PlayerInfo[playerid][pReg]); acc_int_strcat(query, sizeof(query), "Sex",PlayerInfo[playerid][pSex]); acc_int_strcat(query, sizeof(query), "Arrested",PlayerInfo[playerid][pArrested]); acc_int_strcat(query, sizeof(query), "Muted",PlayerInfo[playerid][pMuted]); acc_int_strcat(query, sizeof(query), "Crimes",PlayerInfo[playerid][pCrimes]); acc_int_strcat(query, sizeof(query), "Respect",PlayerInfo[playerid][pExp]); acc_int_strcat(query, sizeof(query), "Money",PlayerInfo[playerid][pCash]); acc_int_strcat(query, sizeof(query), "Kills",PlayerInfo[playerid][pKills]); acc_int_strcat(query, sizeof(query), "Deaths",PlayerInfo[playerid][pDeaths]); acc_int_strcat(query, sizeof(query), "PayCheck",PlayerInfo[playerid][pPayCheck]); acc_int_strcat(query, sizeof(query), "Jailed",PlayerInfo[playerid][pJailed]); acc_int_strcat(query, sizeof(query), "JailTime",PlayerInfo[playerid][pJailTime]); acc_int_strcat(query, sizeof(query), "Materials",PlayerInfo[playerid][pMaterials]); acc_int_strcat(query, sizeof(query), "Drugs",PlayerInfo[playerid][pDrugs]); acc_int_strcat(query, sizeof(query), "Leader",PlayerInfo[playerid][pLeader]); acc_int_strcat(query, sizeof(query), "Member",PlayerInfo[playerid][pMember]); acc_int_strcat(query, sizeof(query), "Rank",PlayerInfo[playerid][pRank]); acc_int_strcat(query, sizeof(query), "Job",PlayerInfo[playerid][pJob]); acc_int_strcat(query, sizeof(query), "CarLic",PlayerInfo[playerid][pCarLic]); acc_int_strcat(query, sizeof(query), "BizLic",PlayerInfo[playerid][pBisLic]); acc_int_strcat(query, sizeof(query), "FlyLic",PlayerInfo[playerid][pFlyLic]); acc_int_strcat(query, sizeof(query), "BoatLic",PlayerInfo[playerid][pBoatLic]); acc_int_strcat(query, sizeof(query), "FishLic",PlayerInfo[playerid][pFishLic]); acc_int_strcat(query, sizeof(query), "GunLic",PlayerInfo[playerid][pGunLic]); acc_int_strcat(query, sizeof(query), "CarSkill",PlayerInfo[playerid][pCarSkill]); acc_int_strcat(query, sizeof(query), "DLevel",PlayerInfo[playerid][pDLevel]); acc_int_strcat(query, sizeof(query), "DExp",PlayerInfo[playerid][pDExp]); acc_int_strcat(query, sizeof(query), "DMgruz",PlayerInfo[playerid][pDMgruz]); acc_int_strcat(query, sizeof(query), "Dgruz",PlayerInfo[playerid][pDgruz]); acc_int_strcat(query, sizeof(query), "Char",PlayerInfo[playerid][pChar]); acc_int_strcat(query, sizeof(query), "Int",PlayerInfo[playerid][pInt]); acc_int_strcat(query, sizeof(query), "Model",PlayerInfo[playerid][pModel]); acc_int_strcat(query, sizeof(query), "PhoneNr",PlayerInfo[playerid][pPnumber]); acc_int_strcat(query, sizeof(query), "PayDay",PlayerInfo[playerid][pPayDay]); acc_int_strcat(query, sizeof(query), "PayDayHad",PlayerInfo[playerid][pPayDayHad]); acc_int_strcat(query, sizeof(query), "ChosingSkin",PlayerInfo[playerid][pChosingSkin]); acc_int_strcat(query, sizeof(query), "Warnings",PlayerInfo[playerid][pWarns]); acc_int_strcat(query, sizeof(query), "unWarns",PlayerInfo[playerid][punWarns]); acc_int_strcat(query, sizeof(query), "unWarnstime",PlayerInfo[playerid][punWarnstime]); acc_int_strcat(query, sizeof(query), "Fuel",PlayerInfo[playerid][pFuel]); acc_int_strcat(query, sizeof(query), "Married",PlayerInfo[playerid][pMarried]); acc_int_strcat(query, sizeof(query), "Drug",PlayerInfo[playerid][pDrug]); acc_int_strcat(query, sizeof(query), "FriendMoney",PlayerInfo[playerid][pFriendMoney]); acc_int_strcat(query, sizeof(query), "Mushrooms",PlayerInfo[playerid][pMushrooms]); acc_int_strcat(query, sizeof(query), "MuteTime",PlayerInfo[playerid][pMuteTime]); acc_int_strcat(query, sizeof(query), "Mobile",PlayerInfo[playerid][pMobile]); acc_int_strcat(query, sizeof(query), "Bank",PlayerInfo[playerid][pBank]); acc_int_strcat(query, sizeof(query), "Debt",PlayerInfo[playerid][pDebt]); acc_int_strcat(query, sizeof(query), "MafiaRoof",PlayerInfo[playerid][pMafiaRoof]); acc_int_strcat(query, sizeof(query), "UseMafiaRoof",PlayerInfo[playerid][pUseMafiaRoof]); acc_int_strcat(query, sizeof(query), "BoxSkill",PlayerInfo[playerid][pBoxSkill]); acc_int_strcat(query, sizeof(query), "KongfuSkill",PlayerInfo[playerid][pKongfuSkill]); acc_int_strcat(query, sizeof(query), "KickboxSkill",PlayerInfo[playerid][pKickboxSkill]); acc_int_strcat(query, sizeof(query), "AdminKey",PlayerInfo[playerid][pDostup]); acc_int_strcat(query, sizeof(query), "Labiding",PlayerInfo[playerid][pLabiding]); acc_int_strcat(query, sizeof(query), "Addiction",PlayerInfo[playerid][pAddiction]); acc_int_strcat(query, sizeof(query), "Procents",PlayerInfo[playerid][pProcents]); acc_int_strcat(query, sizeof(query), "Wheels",PlayerInfo[playerid][pWheels]); acc_int_strcat(query, sizeof(query), "PaintJob",PlayerInfo[playerid][pPaintJob]); acc_int_strcat(query, sizeof(query), "Spoiler",PlayerInfo[playerid][pSpoiler]); acc_int_strcat(query, sizeof(query), "FrontBumper",PlayerInfo[playerid][pBumper1]); acc_int_strcat(query, sizeof(query), "RearBumper",PlayerInfo[playerid][pBumper2]); acc_int_strcat(query, sizeof(query), "Color",PlayerInfo[playerid][pColor]); acc_int_strcat(query, sizeof(query), "Nitro",PlayerInfo[playerid][pNitro]); acc_int_strcat(query, sizeof(query), "Hydravlic",PlayerInfo[playerid][pHydrawlic]); acc_int_strcat(query, sizeof(query), "AutoMast",PlayerInfo[playerid][pAutoMast]); acc_int_strcat(query, sizeof(query), "PlaceJail",PlayerInfo[playerid][pPlaceJail]); acc_int_strcat(query, sizeof(query), "Housecash",PlayerInfo[playerid][pHousecash]); acc_int_strcat(query, sizeof(query), "WantedLevel",PlayerInfo[playerid][pWantedLevel]); strdel(query, strlen(query)-1, strlen(query)); format(string, sizeof(string), " WHERE `Name` = '%s'", name); strcat(query, string); mysql_query(query); } return true; }