Question

Освоившийся

При запуске мода на 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;
}

 

 

Share this post


Link to post
Share on other sites

8 answers to this question

  • 0
DEST
Maintainer

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

Спойлер

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;
}

 

 

Share this post


Link to post
Share on other sites
  • 0
Великий Гуру

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

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

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

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

 

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

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

 

Share this post


Link to post
Share on other sites
  • 0
DEST
Maintainer
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. 

Share this post


Link to post
Share on other sites
  • 0
Освоившийся

@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;
}

 

 

Share this post


Link to post
Share on other sites
  • 0
Освоившийся

@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;
}

 

 

Share this post


Link to post
Share on other sites
  • 0
Освоившийся

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

Share this post


Link to post
Share on other sites
  • 0
Cawfee
Великий Гуру

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

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

Share this post


Link to post
Share on other sites
This topic is now closed to further replies.
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By DonK/Key
      Всем привет, помогите кто разбирается, так как я можно сказать начинающий сделать свой КРМП, буду благодарен. Напишите либо тут либо @evreI_sigma (Мой Telegram)