MySQL не сохраняются аккаунты в localhost
#1

Здравствуйте обитатели форума.
И так у меня проблема не сохраняются аккаунты в localhost таблица, к бд подключается успешно в чем проблема?
Reply
#2

Quote:

localhost таблица

Reply
#3

Таблица в локалхост импортирована скажем так.
Не записываются акки туда.
Reply
#4

Что делать? вопрос не решен.
Reply
#5

Я, например, не понял, что вообще случилось.
Reply
#6

Вопрос поставлен через жопу, без знания матчасти, ответить на такой вопрос мы не можем.
Reply
#7

В общем перезадам.
Перевел мод основа 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;
}
Reply
#8

Дебаг включите и выложите сюда, что пишет.

P.S. Странно, что этот код вообще компилируется.
Reply
#9

Зачем вы таким идиотизмом мучаете сервер?
Reply
#10

Почему у Вас рега через UPDATE идет? INSERT как бы строки добавляет
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)