Рекомендованные сообщения



9 posts in this topic

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

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

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

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

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

 

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

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

 

Share this post


Link to post
Share on other sites
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

@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
32 минуты назад, Данила сказал:

OnPlayerSaveAccount(playerid);

это кинь

Share this post


Link to post
Share on other sites

@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

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

Спойлер

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

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

Share this post


Link to post
Share on other sites

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

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

Share this post


Link to post
Share on other sites
Guest
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

    • glvde.
      By glvde.
      Хранение данных (версия MySQL): R41-4.
      Командный процессор: Pawn.CMD.
      Количество строк в моде (без маппинга): 44006.
      Анти-чит: Nexius-AC.
      Автор данного мода: -.

      Скриншоты: 
       
       
       
       
       

      На данный момент, мод продаётся за 3699₽ на соседнем борде Pawno-Info (не реклама, скрины взял из темы с продажей).

      Не исключаю того, что в моде имеются баги.
      По поводу дальнейшей доработки узнать можно будет в моей группе - vk.com/way_dev
      Так же есть доработанная версия данного мода, за покупкой обращаться в ВК - vk.com/way.developer
    • glvde.
      By glvde.
      Smart RolePlay | Новый слив с продажи
      Просмотр файла Хранение данных (версия MySQL): R41-4.
      Командный процессор: Pawn.CMD.
      Количество строк в моде (без маппинга): 44006.
      Анти-чит: Nexius-AC.
      Автор данного мода: -.

      Скриншоты: 
       
       
       
       
       

      На данный момент, мод продаётся за 3699₽ на соседнем борде Pawno-Info (не реклама, скрины взял из темы с продажей).

      Не исключаю того, что в моде имеются баги.
      По поводу дальнейшей доработки узнать можно будет в моей группе - vk.com/way_dev
      Так же есть доработанная версия данного мода, за покупкой обращаться в ВК - vk.com/way.developer
      Добавил glvde. Добавлено 21.01.2021 Категория Моды Автор -  
    • Radmiz
      By Radmiz
          if(pickupid == sadpick){         if(GetPVarInt(playerid,"Sadov") == 0) {             SetPVarInt(playerid,"Sadov", 1);             SetPlayerSkin(playerid, 73);             SetPlayerCheckpoint(playerid,2157.0464,-1707.6362,15.0859,3.0);               SendClientMessage(playerid,0x00ff39,"Âû óñòðîèëèñü íà ðàáîòó ñàäîâíèêà");               SendClientMessage(playerid,0xfeff00,"Çà 1 ïîñàæàíûé êóñò âàì áóäóò ïëàòèòü ïî 345$");         }         else {             PI[playerid][pCash] += GetPVarInt(playerid,"SadovM")*345;             SetPlayerSkin(playerid,PI[playerid][pSkin]);             ClearAnimations(playerid);             DeletePVar(playerid,"Sadov");             DeletePVar(playerid,"SadovM");             DeletePVar(playerid,"SadovW");             SendClientMessage(playerid,0xff0000,"Âû óâîëèëèñü ñ ðàáîòû ñàäîâíèêà");             DisablePlayerCheckpoint(playerid);  
      я хз что за иероглифы