Ошибка при запуске

June 8, 2018

При запуске мода на localhost ошибка логах

Спойлер


----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[19:33:31] filterscripts = ""  (string)
[19:33:31] 
[19:33:31] Server Plugins
[19:33:31] --------------
[19:33:31]  Loading plugin: crashdetect
[19:33:31]   CrashDetect v4.18.1 is OK.
[19:33:31]   Loaded.
[19:33:31]  Loading plugin: pawnraknet
[19:33:31] Pawn.RakNet plugin v1.0.2 by urShadow loaded
[19:33:31]   Loaded.
[19:33:31]  Loading plugin: pawncmd
[19:33:31] Pawn.CMD plugin v3.1.3 by urShadow loaded
[19:33:31]   Loaded.
[19:33:31]  Loading plugin: streamer
[19:33:31] 

*** Streamer Plugin v2.8.2 by Incognito loaded ***

[19:33:31]   Loaded.
[19:33:31]  Loading plugin: sscanf
[19:33:31] 

[19:33:31]  ===============================

[19:33:31]       sscanf plugin loaded.     

[19:33:31]          Version:  2.8.1        

[19:33:31]    (c) 2012 Alex "Y_Less" Cole  

[19:33:31]  ===============================

[19:33:31]   Loaded.
[19:33:31]  Loading plugin: mysql
[19:33:31]  >> plugin.mysql: R39-6 successfully loaded.
[19:33:31]   Loaded.
[19:33:31]  Loading plugin: profiler
[19:33:31]   Profiler v2.14.1 is OK.
[19:33:31]   Loaded.
[19:33:31]  Loaded 7 plugins.

[19:33:32] 
[19:33:32] Filterscripts
[19:33:32] ---------------
[19:33:32]   Loaded 0 filterscripts.

[19:33:32] [!] Подключение к базе успешно [!]
[19:33:32] -> Экономика успешно загружена 0 ms
[19:33:32] -> Загружено 31 баннеров | 3 ms
[19:33:32] -> Семьи не загружены
[19:33:32] -> Склад мафий загружен
[19:33:32] -> Фракционные склады загружены (29 шт)
[19:33:32] -> Загружено <20> заправочных станций!
[19:33:32] -> Business | Загружено: 60 | Time: 22 (ms)
[19:33:33] -> LoadProperty | Загружено 1266 | Time: 504 (ms)
[19:33:33] -> GZLogoInfo | Загружено: 38 | Time: 2 (ms)
[19:33:33] -> LoadFractions | Загружено 27 | Время: 4 (ms)
[19:33:33] -> LoadGangZone | Загружено: 104 | Time: 36 (ms)
[19:33:33] -> Мебель загружена <4938 шт>
[19:33:33] -> Автоярмарка загружена <24 шт авто.>
[19:33:33] -> Выборы не загружены
[19:33:33] -> Запреты загружены успешно
[19:33:33] -> Донат статистика не загружена
[19:33:33] [profiler] Attached profiler to gamemodes/ind
[19:33:33] [profiler] Started profiling gamemodes/ind
[19:33:33] Number of vehicle models: 93
[19:33:57] [connection] incoming connection: 127.0.0.1:53634 id: 0
[19:33:57] [join] Kenny_Lokonte has joined the server (0:127.0.0.1)
[19:34:23] [part] Kenny_Lokonte has left the server (0:2)
[19:34:23] [mysql] 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 ' `aPrefix` = 'None' WHERE `id` = ''' at line 1, , UPDATE `accounts` SET `pCash` = '15000000',`pChar` = '212' WHERE `id` = '0', `aPrefix` = 'None' WHERE `id` = '', 1

Спойлер


RegistrationPlayer(playerid,skin_id,bool:type)
{
    new year,month,day,hour,minuite,second;
	if(!type)
	{
		if(!PlayerInfo[playerid][pLogin]) return KickEx(playerid);
		new date_reg[50],playersip[16],drug_name[24],email_reg[16];
		GetPVarString(playerid, #reg_drug, drug_name, sizeof(drug_name));
		GetPVarString(playerid, #reg_email, email_reg, sizeof(email_reg));
		GetPlayerIp(playerid,playersip,sizeof(playersip));
		getdate(year, month, day); gettime(hour,minuite,second);
		format(date_reg,sizeof(date_reg),"%d/%d/%d %d:%d",day,month,year,hour,minuite);
		strmid(PlayerInfo[playerid][pIpReg], playersip, 0, strlen(playersip), 255);
		strmid(PlayerInfo[playerid][pLoadNames], PlayerInfo[playerid][pNames], 0, 24, 255);
		PlayerInfo[playerid][pLevel] = 15;
		PlayerInfo[playerid][pCash] = 15000000;
		PlayerInfo[playerid][pDonate] = 5000;
		PlayerInfo[playerid][pHouse] = -1;
		PlayerInfo[playerid][pBusiness] = -1;
		PlayerInfo[playerid][pArendaHouse] = -1;
		PlayerInfo[playerid][pFilling] = -1;
		strmid(PlayerInfo[playerid][aPrefix], "None", 0, 32, 255);
		PlayerInfo[playerid][pCardMoney] = 0, PlayerInfo[playerid][pCardDate] = 0, PlayerInfo[playerid][pBankCard] = 0;
		PlayerInfo[playerid][pPnumber] = RandomEx(100000,999999);
		mysql_format(1,string,sizeof(string), "INSERT INTO `accounts` (`Name`,`pKey`,`pLevel`,`pPnumber`,`pBank`,`pCash`,`pChar`,`pDataReg`,`pIpReg`,`pRank`,`pEmail`,`pDrug`,`pSex`,`nationaly`,`age,`aPrefix`)\
		VALUES ('%e', '%e', '15', '%d', '0', '15000000', '%d', '%e', '%e', '1', '%e', '%e', '%d', '%d', '%d','None')", PlayerInfo[playerid][pNames],
		PlayerInfo[playerid][pKey],PlayerInfo[playerid][pPnumber],skin_id,date_reg,playersip,email_reg,drug_name,GetPVarInt(playerid, #reg_pol),PlayerInfo[playerid][pNationaly],GetPVarInt(playerid, #reg_age));
		mysql_query(1, string, false);
		SetPVarInt(playerid, "reg_check", 1);
		string = "";
		mysql_format(1, string, 128,"SELECT * FROM `accounts` WHERE `Name` = '%e'", PlayerInfo[playerid][pNames]);
		mysql_tquery(1, string, "LoginCallback", "d", playerid);
		DeletePVar(playerid, #reg_drug), DeletePVar(playerid, #reg_age), DeletePVar(playerid, #reg_pol), DeletePVar(playerid, #reg_email);
		return 1;
	}
	new date_reg[32],playersip[16];
	getdate(year, month, day); gettime(hour,minuite,second);
	format(date_reg,sizeof(date_reg),"%d/%d/%d %d:%d",day,month,year,hour,minuite);
	GetPlayerIp(playerid, playersip, 16);
	strmid(PlayerInfo[playerid][pIpReg], playersip, 0, strlen(playersip), 255);
	string = "";
	format(string, BIG_SIZE+15, ""WHITE"Имя Фамилия:\t"SERVER"%s"WHITE"\nПароль:\t\t{c3ef15}%s"WHITE"\nE-mail:\t\t\t{c3ef15}%s"WHITE"\nПол:\t\t\t{c3ef15}%s"WHITE"\nIP:\t\t\t"SERVER"%s"WHITE"\nДата и время регистрации: "SERVER"%s"WHITE"\n\n\tДобро пожаловать на наш игровой сервер!\n\tМы желаем Вам приятной игры!\n\tПожалуйста! Не нарушайте правила игры на сервере",
	PlayerInfo[playerid][pNames], PlayerInfo[playerid][pKey], PlayerInfo[playerid][pEmail], (PlayerInfo[playerid][pSex] == 1 ? ( "Мужской" ) : ( "Женский" )), playersip, date_reg);
	ShowPlayerDialog(playerid, 0000, DIALOG_STYLE_MSGBOX, ""SERVER"Информация об аккаунте", string, "Закрыть", "");
    DeletePVar(playerid, "reg_check");
	return 1;
}

1,033 · June 8, 2018

@Данила замени свою функцию этой:

Спойлер


OnPlayerSaveAccount(playerid)
{
	if(PlayerInfo[playerid][pLogin] != true) return 1;
	string = "";
	mysql_format(1,string,300,"UPDATE `accounts` SET `pCash` = '%d',`pChar` = '%d',`aPrefix` = '%s' WHERE `id` = '%i'",PlayerInfo[playerid][pCash],PlayerInfo[playerid][pChar],PlayerInfo[playerid][aPrefix],PlayerInfo[playerid][pID]);
	mysql_tquery(1, string);
	return 1;
}

June 8, 2018

АВТОМАТИЧЕСКИ СФОРМИРОВАННОЕ СООБЩЕНИЕ:

Данная тема была перемещена модерацией или администрацией портала PAWNO-RUS.RU!

Перемещена из: "Скриптинг PAWN > Вопросы / проблемы по скриптингу"

Перемещена в: "Скриптинг PAWN > Запуск серверов"

С уважением, ваш Бот!

Если вы НЕ согласны с переносом данной темы в раздел "Скриптинг PAWN > Запуск серверов", пожалуйтесь на это сообщение в жалобе указав причины вашего недовольства. Спасибо.

1,033 · June 8, 2018

4 минуты назад, Данила сказал:

[19:34:23] [part] Kenny_Lokonte has left the server (0:2) [19:34:23] [mysql] 1064, You have an error in your SQL syntax;

это вызывается явно после отключения игрока от сервера.

Скидывай функцию сохранения игрока. Если не знаешь где она, то скидывай OnPlayerDisconnect.

June 8, 2018

@DEST

Спойлер


public OnPlayerDisconnect(playerid, reason)
{
	if(PlayerInfo[playerid][pLogin])
	{
	   	if( MyBed[ playerid ] != 255 )
		{
			new p_Bed = MyBed[ playerid ];
			string = "";
			KillTimer( PlayerTimerBolk[ playerid ] );
			BedInfo[ p_Bed ][ Busy ] = false;
			ClearAnimations( playerid );
			MyBed[ playerid ] = 255;
			TogglePlayerControllable(playerid, 1);
			SetPlayerDrunkLevel( playerid, 0 );
			SetPlayerPos( playerid, BedInfo[ p_Bed ][ b_X ], BedInfo[ p_Bed ][ b_Y ], BedInfo[ p_Bed ][ b_Z ] );
			format( string, 128, "{FFFFFF}Койка №%d\n{33AA33}Свободна\n\n{AFAFAF}Используйте /heal чтобы занять её", p_Bed+1);
			Update3DTextLabelText( Bed3D[ p_Bed ], 0xFFFFFF20, string );
		}
		mysql_format(1,string, 128, "UPDATE `admin` SET `online_%s`='%d' WHERE Name='%e'", getDay(), pTemp[playerid][admPlayOnline], PlayerInfo[playerid][pNames]);
		mysql_tquery(1, string);
		if(gPlayerProdText[playerid][0] != Text3D:-1) DestroyDynamic3DTextLabel(gPlayerProdText[playerid][0]);
	    if(gPlayerProdText[playerid][1] != Text3D:-1) DestroyDynamic3DTextLabel(gPlayerProdText[playerid][1]);
	    if(gPlayerProdCP[playerid] != -1) DestroyDynamicCP(gPlayerProdCP[playerid]);
   		if(GetPVarInt(playerid, "BLOCK_STAY"))
		{
			Delete3DTextLabel(blocktext[playerid]);
			DestroyDynamicObject(GetPVarInt(playerid, "BLOCK_OBJECT"));
			DeletePVar(playerid, "BLOCK_OBJECT");
			DeletePVar(playerid, "BLOCK_STAY");
		}
		if(GetPVarInt(playerid, "VehicleRent"))
		{
			SetVehicleToRespawn(GetPVarInt(playerid, "VehicleRent"));
			DeletePVar(playerid, "VehicleRent");
		}
	    RaceExit(playerid, 2);
	    for(new i; i < MAX_PLAYER_ATTACHED_OBJECTS; i ++)
		{
			if(IsPlayerAttachedObjectSlotUsed(playerid, i))
			{
				RemovePlayerAttachedObject(playerid, i);
			}
		}
		if(GetPVarInt(playerid, "UpdateRacing")) KillTimer(GetPVarInt(playerid, "UpdateRacing")), DeletePVar(playerid, "UpdateRacing");
		if(GetPVarInt(playerid, "StartFilling")) KillTimer(GetPVarInt(playerid, "StartFilling")), DeletePVar(playerid, "StartFilling");
		if(GetPVarInt(playerid, "StartWanted")) KillTimer(GetPVarInt(playerid, "StartWanted")), DeletePVar(playerid, "StartWanted");
	    if(GetPVarInt(playerid, "StartSleep")) KillTimer(GetPVarInt(playerid, "SleepTimer")), DeletePVar(playerid, "SleepTimer"), DeletePVar(playerid, "StartSleep");
	    if(GetPVarInt(playerid, "RobBankTimer")) KillTimer(GetPVarInt(playerid, "RobBankTimer")), DeletePVar(playerid, "RobBankTimer"), BankRob_Status = false;
		if(GetPVarInt(playerid,"walk_goto_me_player"))
		{
		    walk_goto_me[GetPVarInt(playerid,"walk_goto_me_player") - 1] = 0;
			DeletePVar(playerid,"walk_goto_me_player");
		}
		if(PlayerInfo[playerid][pLogin] && ContractInfo[playerid][cHitman] != INVALID_PLAYER_ID)
		{
			if(IsPlayerConnected(ContractInfo[playerid][cHitman]))
			{
				SCMF(ContractInfo[playerid][cHitman],COLOR_SERVER,"~~~ Жертва %s[%d] вышла из игры ~~~", PlayerInfo[playerid][pNames],playerid);
				ContractInfo[ContractInfo[playerid][cHitman]][cZakaz] = INVALID_PLAYER_ID;
			}
		}
		if(TimeGrab > unix && BikeGrab && TotalUser < 1 && (GetPVarInt(playerid, #grab_check) || !GetPVarInt(playerid, #grab_check)))
		{
			foreach(Player, i)
			{
				if(PlayerInfo[i][pMember] == 23) SendClientMessage(i, COLOR_REDD, "На месте ограбления никого не осталось, ограбление отменено! Следующее ограбление будет доступно через 1 час!"),PlayerTextDrawHide(i, GrabText[i]);
			}
			Filling[fuelID][sStartGrab] = false, TotalFuel[playerid] = 0, TotalUser = 0, BikeGrab = false, StartGrab = 1, fuelID = -1;
		}
		for(new i; i < 13; i ++)
		{
			TextDrawHideForPlayer(playerid, CounterSText[i]);
			if(i<3) TextDrawHideForPlayer(playerid, WebTextDraw[i]);
		}
		if(GetPVarInt(playerid, "breaked"))
		{
			DestroyDynamicObject(GetPVarInt(playerid, "break_object"));
			DeletePVar(playerid, "breaked");
			DeletePVar(playerid, "break_object");
			DestroyDynamic3DTextLabel(Text3D:breakText[playerid]);
		}
		if(GetPlayerSpecialAction(playerid) == SPECIAL_ACTION_CUFFED && PlayerInfo[playerid][pWanted] > 0)
		{
			UpdatePlayerData(playerid,"pJailTime",PlayerInfo[playerid][pWanted]*600);
			UpdatePlayerData(playerid,"pMestoJail",1);
			PlayerInfo[playerid][pMestoJail] = 1;
			format(string, 100, "Игрок %s покинул игру во время арреста, при входе в игру +%d секунд КПЗ", PlayerInfo[playerid][pNames], PlayerInfo[playerid][pWanted]*600);
			SendClientMessageToAll(COLOR_LIGHTRED, string);
		}
		if(player_family_3dtext[playerid] != Text3D:-1 )
		{
			DestroyDynamic3DTextLabel(player_family_3dtext[playerid]);
			player_family_3dtext[playerid] = Text3D:-1;
		}
		if(player_prison_text[playerid] != Text3D:-1)
		{
			DestroyDynamic3DTextLabel(player_prison_text[playerid]);
			player_prison_text[playerid] = Text3D:-1;
		}
		if(GetPVarType(playerid, "PlacedBB"))
		{
			DestroyDynamicObject(GetPVarInt(playerid, "PlacedBB"));
			DestroyDynamic3DTextLabel(Text3D:GetPVarInt(playerid, "BBLabel"));
			if(GetPVarType(playerid, "BBArea"))
			{
			    Iter_Remove(boxPlayer,playerid);
				foreach(Player, i)
				{
					if(IsPlayerInDynamicArea(i, GetPVarInt(playerid, "BBArea")))
					{
						StopAudioStreamForPlayer(i);
						SendClientMessage(i, COLOR_LIGHTBLUE, "Игрок вышел из игры, магнитофон выключен");
					}
				}
			}
		}
		if(GetPVarInt(playerid,"called"))
		{
			new callid =GetPVarInt(playerid,"called")-1;
			DeletePVar(callid,"called");
			DeletePVar(callid,"talkcall");
			SendClientMessage(callid,CGRAY,"Абонент отключился, связь прекращена.");
	   		SetPlayerSpecialAction(callid,SPECIAL_ACTION_STOPUSECELLPHONE);
	  		RemovePlayerAttachedObject(callid,2);
		}
		if(pTemp[playerid][pExamCandidate] != INVALID_PLAYER_ID)
		{
			new actplayerid = pTemp[playerid][pExamCandidate];
			if(IsPlayerConnected(actplayerid) && pTemp[actplayerid][pOnExam])
			{
				SendClientMessage(actplayerid,CGRAY,"Ваш инструктор вышел из игры, экзамен прерван");
				RemovePlayerFromVehicle(actplayerid);
				pTemp[actplayerid][pOnExam] = false;
			}
		}
		if(GetPVarInt(playerid,"id_pvp")>0)
		{
			new pp=GetPVarInt(playerid,"id_pvp")-1;
			SendClientMessage(pp,COLOR_GREY,"Дуэль не состоиться, игрок вышел из игры");
			if(GetPVarInt(pp,"id_gun")>0) DeletePVar(pp, "id_gun");
			if(GetPVarInt(pp,"money_pvp")>0) DeletePVar(pp, "money_pvp");
			if(GetPVarInt(pp,"duel_nachalsya")) DeletePVar(pp,"duel_nachalsya");

			for(new d = 0; d < MAX_DUELS; d++)
			{
				if(duel_pvp[d][duel_id]==playerid || duel_pvp[d][duel_to_id]==playerid)
				{
					new weapons[13][2];
					for(new S = 0; S<13; S++) GetPlayerWeaponData(pp, S, weapons[S][0], weapons[S][1]) ;
					ResetPlayerWeapons ( pp ) ;
					for(new S = 0; S<13 ; S++) if(weapons[S][0] != duel_pvp[d][duel_gun] && weapons[S][0] != 0) GivePlayerWeapon (pp,weapons[S][0],weapons[S][1]);

					duel_pvp[d][duel_id] = -1;
					duel_pvp[d][duel_to_id] = -1;
					duel_pvp[d][duel_last_vw] = 0;
					duel_pvp[d][duel_gun] = 0;
					if(duel_pvp[d][duel_timer] != -1)
					{
						KillTimer(duel_pvp[d][duel_timer]);
						duel_pvp[d][duel_timer] = -1;
					}
					duel_pvp[d][duel_time]=0;
					duel_pvp[d][duel_health_id] = 100.0;
					duel_pvp[d][duel_health_to_id] = 100.0;
					duel_pvp[d][duel_money]=0;
					duel_t--;
					break;
				}
			}
		}
		if(GetPVarInt(playerid, "arenda_took"))
		{
			DestroyVehicle(GetPVarInt(playerid, "arenda_took"));
			DeletePVar(playerid, "arenda_took");
			DeletePVar(playerid, "check_arenda_moped");
		}
		if(player_family [ playerid ]) family_info [ player_family [ playerid ]] [ f_online ]--;
	 	Deleted(playerid);
	 	DestroyPlayerMapDraws(playerid);
		if(AlhambraDJ == true && AlhambraDJID == playerid) AlhambraDJ = false, AlhambraDJID = INVALID_PLAYER_ID;
		if(PlayerInfo[playerid][pJob] == 1)
		{
			if(GetPVarInt(playerid, "ContractMechanic"))
			{
				Delete3DTextLabel(Meh3d[VehicleEnters[playerid]]);
				DeletePVar(playerid, "ContractMechanic");
			}
		}
		if(PlayerInfo[playerid][pHouse] != -1 || PlayerInfo[playerid][pArendaHouse] != -1)
		{
			if(caridhouse[playerid][0] != 0) DestroyVehicle(caridhouse[playerid][0]), caridhouse[playerid][0] = 0;
			if(caridhouse[playerid][1] != 0) DestroyVehicle(caridhouse[playerid][1]), caridhouse[playerid][1] = 0;
			if(caridhouse[playerid][2] != 0) DestroyVehicle(caridhouse[playerid][2]), caridhouse[playerid][2] = 0;
		}
		if(GetPVarInt(playerid, "is_boat") - 1 != 0) DestroyVehicle(GetPVarInt(playerid, "is_boat") - 1);
		if(PlayerInfo[playerid][pAvia] != -1 && caridhouse[playerid][3] != 0) DestroyVehicle(caridhouse[playerid][3]), caridhouse[playerid][3] = 0;
		if(PlayerInfo[playerid][pCar][0] == 508 && caridhouse[playerid][0] != 0)
		{
			new Float:XX, Float:YY, Float:ZZ,Float:CC;
			GetVehiclePos(caridhouse[playerid][0], XX, YY, ZZ);
			GetVehicleZAngle(caridhouse[playerid][0], CC);
			mysql_format(1,string,200,"UPDATE `accounts` SET CarX='%f',CarY='%f',CarZ='%f',CarC='%f' WHERE `Name` = '%e'",
			XX,YY,ZZ,CC,PlayerInfo[playerid][pNames]);
			mysql_tquery(1, string);
			foreach(Player, i)
			{
				if(GetPVarInt(i, "Intropic" ) == caridhouse[playerid][0])
				{
					new Float:X, Float:Y, Float:Z;
					GetVehiclePos(GetPVarInt( i, "Intropic" ), X, Y, Z);
					SetPlayerPos(i, X, Y, Z);
					SetPlayerVirtualWorld(i,0);
					SetPlayerInterior(i, 0);
					DeletePVar(i, "Intropic");
				}
			}
			DestroyVehicle(caridhouse[playerid][0]);
			caridhouse[playerid][0] = 0;
		}
	 	if(GetPVarInt(playerid,"adchecking_fix"))
	    {
	    	gAdvert[GetPVarInt(playerid,"adchecking_fix")-1][adCheking]=false;
	    	DeletePVar(playerid,"adchecking_fix");
		}
		SetPlayerSkills(playerid);
		if(GetPVarInt(playerid, "dostup"))
		{
			string = "";
	 		mysql_format(1,string,220,"UPDATE `admin` SET `kick` = '%d', `ban` = '%d', `mute` = '%d', `pm` = '%d', `warn` = '%d', `jail` = '%d' WHERE `Name` = '%e' LIMIT 1",gAdmin[playerid][0],gAdmin[playerid][1],gAdmin[playerid][2],gAdmin[playerid][3],gAdmin[playerid][4],gAdmin[playerid][5],PlayerInfo[playerid][pNames]);
	        mysql_tquery(1, string);

	 		format(string, 128, "[A] %s покинул игру [IP: %s]",PlayerInfo[playerid][pNames],PlayerInfo[playerid][pIP]);
			ABroadCast(0xEAC700FF,string,1);
			DeletePVar(playerid,"dostup");
		}
		new gun_string[56], ammo_string[56];
		if(PlayerInfo[playerid][pDMZ] == 0)
		{
			for(new i; i < 13; i++)
			{
			    new ids,ams;
				GetPlayerWeaponDataAC(playerid, i, ids, ams);
				if(i > 0) format(gun_string,56,"%s,%d", gun_string, ids);
				else valstr(gun_string,ids);
				if(i > 0) format(ammo_string,56,"%s,%d", ammo_string, ams);
				else valstr(ammo_string,ams);
			}
		}
		mysql_format(1, string, 256, "UPDATE `accounts` SET  `p_guns` = '%e',`p_ammo` = '%e' WHERE `id` = '%i' LIMIT 1", gun_string, ammo_string, PlayerInfo[playerid][pID]);
		mysql_tquery(1, string);
		OnPlayerSaveAccount(playerid);
		CancelSelectTextDraw(playerid), DisablePlayerCheckpoint(playerid);
	}
	PlayerInfo[playerid][bAdmin] = 0;
	return 1;
}

1,033 · June 8, 2018

32 минуты назад, Данила сказал:

OnPlayerSaveAccount(playerid);

это кинь

June 8, 2018

@DEST

Спойлер


OnPlayerSaveAccount(playerid)
{
	if(PlayerInfo[playerid][pLogin] != true) return 1;
	string = "";
	mysql_format(1,string,300,"UPDATE `accounts` SET `pCash` = '%d',`pChar` = '%d' WHERE `id` = '%i', `aPrefix` = '%s' WHERE `id` = '%i'",PlayerInfo[playerid][pCash],PlayerInfo[playerid][pChar],PlayerInfo[playerid][aPrefix],PlayerInfo[playerid][pID]);
	mysql_tquery(1, string);
	return 1;
}

June 8, 2018

@DEST Спасибо большое, а в чем собственно проблема была?

June 8, 2018

@Данила, в SQL запросе. После WHERE находилось присвоение, что не есть правильно.

P.s. вместо "спасибо большое" лучше бы поставили плюсик тому, кто помог. И не забудьте закрыть тему путем нажатия кнопки "Вопрос решен" (галочка справа от аватарки пользователя, сообщение которого Вам помогло).

Sign In

Ошибка при запуске

Question

Данила Освоившийся 1

Share this post

Link to post

Share on other sites

8 answers to this question

DEST Maintainer 1,033

Share this post

Link to post

Share on other sites

Бот Великий Гуру 19

Share this post

Link to post

Share on other sites

DEST Maintainer 1,033

Share this post

Link to post

Share on other sites

Данила Освоившийся 1

Share this post

Link to post

Share on other sites

DEST Maintainer 1,033

Share this post

Link to post

Share on other sites

Данила Освоившийся 1

Share this post

Link to post

Share on other sites

Данила Освоившийся 1

Share this post

Link to post

Share on other sites

Cawfee Великий Гуру 558

Share this post

Link to post

Share on other sites

Recently Browsing 0 members

Similar Content

Shop