SA-MP Forums Archive
(error #1062) Duplicate entry 'The_Nerka' for key 'Fullname' - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: (error #1062) Duplicate entry 'The_Nerka' for key 'Fullname' (/showthread.php?tid=539676)



(error #1062) Duplicate entry 'The_Nerka' for key 'Fullname' - TheNerka - 29.09.2014

Код:
forward SavePlayerData(playerid);
public SavePlayerData(playerid)
{
    AntiDeAMX();
    if(gIsPlayerLoggedIn[playerid] == 1)
	{
	    if(gIsPlayerDead[playerid] == 1) { PlayerData[playerid][Dead] = 1; }
   		GetPlayerWeaponData(playerid, 1, PlayerData[playerid][Weapon1], PlayerData[playerid][Weapon1a]);
   		GetPlayerWeaponData(playerid, 2, PlayerData[playerid][Weapon2], PlayerData[playerid][Weapon2a]);
        GetPlayerWeaponData(playerid, 3, PlayerData[playerid][Weapon3], PlayerData[playerid][Weapon3a]);
        GetPlayerWeaponData(playerid, 4, PlayerData[playerid][Weapon4], PlayerData[playerid][Weapon4a]);
        GetPlayerWeaponData(playerid, 5, PlayerData[playerid][Weapon5], PlayerData[playerid][Weapon5a]);
        GetPlayerWeaponData(playerid, 6, PlayerData[playerid][Weapon6], PlayerData[playerid][Weapon6a]);
        GetPlayerWeaponData(playerid, 7, PlayerData[playerid][Weapon7], PlayerData[playerid][Weapon7a]);
        GetPlayerWeaponData(playerid, 8, PlayerData[playerid][Weapon8], PlayerData[playerid][Weapon8a]);
        GetPlayerWeaponData(playerid, 9, PlayerData[playerid][Weapon9], PlayerData[playerid][Weapon9a]);
        GetPlayerWeaponData(playerid, 10, PlayerData[playerid][Weapon10], PlayerData[playerid][Weapon10a]);
        GetPlayerWeaponData(playerid, 11, PlayerData[playerid][Weapon11], PlayerData[playerid][Weapon11a]);
        GetPlayerWeaponData(playerid, 12, PlayerData[playerid][Weapon12], PlayerData[playerid][Weapon12a]);
        //GetPlayerSkin(playerid);
		new Float:X, Float:Z, Float:Y, Float:A, Float:H, Float:Ar;
		GetPlayerPos(playerid, X,Y,Z);
		GetPlayerFacingAngle(playerid,A);
		GetPlayerHealth(playerid, H);
		GetPlayerArmour(playerid, Ar);
		mysql_format(Mysql_users, query, sizeof(query), "UPDATE `"ZAIDEJU_LENTELE"` SET Fullname='%e', Password='%e', PositionX='%f', PositionY='%f', PositionZ='%f', PositionA='%f', Health='%f', Armour='%f', Interior='%d', VirtualWorld='%d', AdminLevel='%d', AdminKey='%d', AdminTime='%d', Banned='%d', BannedBy='%e', BanReason='%e'",\
		PlayerData[playerid][Fullname],
        PlayerData[playerid][Password],
		X,
		Y,
		Z,
	 	A,
	 	H,
	 	Ar,
	 	GetPlayerInterior(playerid),
	 	GetPlayerVirtualWorld(playerid),
	 	PlayerData[playerid][AdminLevel],
	 	PlayerData[playerid][AdminKey],
	 	PlayerData[playerid][AdminTime],
	 	PlayerData[playerid][Banned],
	 	PlayerData[playerid][BannedBy],
	 	PlayerData[playerid][BanReason]);

	 	mysql_format(Mysql_users, query, sizeof(query), "%s, Warnings='%d', Warning1Reason='%e', Warning2Reason='%e', Warning3Reason='%e', WarnedBy1='%e', WarnedBy2='%e', WarnedBy3='%e', Dead='%d', HospitalTime='%d', Telefonas='%d', Tinklas='%d', Numeris='%d', tBaterija='%d', tBaterijosBukle='%d', tBukle='%d', tPakrovejas='%d'",\
		query,
		PlayerData[playerid][Warnings],
	 	PlayerData[playerid][Warning1Reason],
	 	PlayerData[playerid][Warning2Reason],
	 	PlayerData[playerid][Warning3Reason],
	 	PlayerData[playerid][WarnedBy1],
	 	PlayerData[playerid][WarnedBy2],
	 	PlayerData[playerid][WarnedBy3],
	 	PlayerData[playerid][Dead],
	 	PlayerData[playerid][HospitalTime],
	 	PlayerData[playerid][Telefonas],
		PlayerData[playerid][Tinklas],
		PlayerData[playerid][Numeris],
		PlayerData[playerid][tBaterija],
	 	PlayerData[playerid][tBaterijosBukle],
		PlayerData[playerid][tBukle],
		PlayerData[playerid][tPakrovejas]);

	 	mysql_format(Mysql_users, query, sizeof(query), "%s, Helper='%d', Money='%d', MoneyBank='%d', Score='%d', Skin='%d', Hour='%d', Min='%d', Sec='%d', Kills='%d', Deaths='%d', Kreditai='%d', Taskai='%d', nLicenzija='%d', Navigacija='%d', Radijas='%d',VipLevel='%d',VipKey='%d',VipTime='%d', Premium='%d', PremiumTime='%d'",\
	 	query,
	 	PlayerData[playerid][Helper],
		GetPlayerMoney(playerid),
		PlayerData[playerid][MoneyBank],
	 	GetPlayerScore(playerid),
        PlayerData[playerid][Skin],
	 	PlayerData[playerid][Hour],
	 	PlayerData[playerid][Min],
	 	PlayerData[playerid][Sec],
	 	PlayerData[playerid][Kills],
	 	PlayerData[playerid][Deaths],
	 	PlayerData[playerid][Kreditai],
	 	PlayerData[playerid][Taskai],
	 	PlayerData[playerid][nLicenzija],
	 	PlayerData[playerid][Navigacija],
	 	PlayerData[playerid][Radijas],
	 	PlayerData[playerid][VipLevel],
	 	PlayerData[playerid][VipKey],
	 	PlayerData[playerid][VipTime],
	 	PlayerData[playerid][Premium],
	 	PlayerData[playerid][PremiumTime]);

	 	mysql_format(Mysql_users, query, sizeof(query), "%s, Weapon1='%d', Weapon1a='%d', Weapon2='%d', Weapon2a='%d', Weapon3='%d', Weapon3a='%d', Weapon4='%d', Weapon4a='%d', Weapon5='%d', Weapon5a='%d', Weapon6='%d', Weapon6a='%d', Wanted='%d', Muted='%d', MutedTime='%d', Job='%d', JobSkin='%d', Alga='%d', Picos='%d'",\
	 	query,
	 	PlayerData[playerid][Weapon1],
		PlayerData[playerid][Weapon1a],
		PlayerData[playerid][Weapon2],
		PlayerData[playerid][Weapon2a],
		PlayerData[playerid][Weapon3],
		PlayerData[playerid][Weapon3a],
		PlayerData[playerid][Weapon4],
		PlayerData[playerid][Weapon4a],
		PlayerData[playerid][Weapon5],
		PlayerData[playerid][Weapon5a],
		PlayerData[playerid][Weapon6],
		PlayerData[playerid][Weapon6a],
		GetPlayerWantedLevel(playerid),
		PlayerData[playerid][Muted],
		PlayerData[playerid][MutedTime],
		PlayerData[playerid][Job],
		PlayerData[playerid][JobSkin],
		PlayerData[playerid][Alga],
		JobInventorData[playerid][Picos]);

	 	mysql_format(Mysql_users, query, sizeof(query), "%s, Weapon7='%d', Weapon7a='%d', Weapon8='%d', Weapon8a='%d', Weapon9='%d', Weapon9a='%d', Weapon10='%d', Weapon10a='%d', Weapon11='%d', Weapon11a='%d', Weapon12='%d', Weapon12a='%d', Gender='%d', UseJobSkin='%d', HouseID='%d', BusinessID='%d', tSaskaitoje='%d'",\
	 	query,
	 	PlayerData[playerid][Weapon7],
		PlayerData[playerid][Weapon7a],
		PlayerData[playerid][Weapon8],
		PlayerData[playerid][Weapon8a],
		PlayerData[playerid][Weapon9],
		PlayerData[playerid][Weapon9a],
		PlayerData[playerid][Weapon10],
		PlayerData[playerid][Weapon10a],
		PlayerData[playerid][Weapon11],
		PlayerData[playerid][Weapon11a],
		PlayerData[playerid][Weapon12],
		PlayerData[playerid][Weapon12a],
		PlayerData[playerid][Gender],
		PlayerData[playerid][UseJobSkin],
        PlayerData[playerid][pHouseID],
        PlayerData[playerid][pBusinessID],
        PlayerData[playerid][tSaskaitoje]);
        mysql_tquery(Mysql_users, query, "", "");

        mysql_format(Mysql_users, query, sizeof(query), "%s, Misija1='%d', Misija2='%d', Misija3='%d', Misija4='%d', Misija5='%d', Misija6='%d', Misija7='%d', Misija8='%d', Misija9='%d', Misija10='%d', Misija11='%d', Misija12='%d', Misija13='%d', Misija14='%d', Misija15='%d', Misija16='%d', Misija17='%d', tPapildymas='%d'",\
        query,
        MissionData[playerid][Misija1],
        MissionData[playerid][Misija2],
        MissionData[playerid][Misija3],
        MissionData[playerid][Misija4],
        MissionData[playerid][Misija5],
        MissionData[playerid][Misija6],
        MissionData[playerid][Misija7],
        MissionData[playerid][Misija8],
        MissionData[playerid][Misija9],
        MissionData[playerid][Misija10],
        MissionData[playerid][Misija11],
        MissionData[playerid][Misija12],
        MissionData[playerid][Misija13],
        MissionData[playerid][Misija14],
        MissionData[playerid][Misija15],
        MissionData[playerid][Misija16],
        MissionData[playerid][Misija17],
        PlayerData[playerid][tPapildymas]);
        mysql_tquery(Mysql_users, query, "", "");

        mysql_format(Mysql_users, query, sizeof(query), "%s, Misija18='%d', Misija19='%d', Misija20='%d', Misija21='%d', Misija22='%d', Misija23='%d', Misija24='%d', Misija25='%d', Misija26='%d', Misija27='%d', Misija28='%d', Misija29='%d', Misija30='%d', EventGold='%d', EventSilver='%d', EventBronze='%d' WHERE Fullname='%e'",\
        query,
        MissionData[playerid][Misija18],
        MissionData[playerid][Misija19],
        MissionData[playerid][Misija20],
        MissionData[playerid][Misija21],
        MissionData[playerid][Misija22],
        MissionData[playerid][Misija23],
        MissionData[playerid][Misija24],
        MissionData[playerid][Misija25],
        MissionData[playerid][Misija26],
        MissionData[playerid][Misija27],
        MissionData[playerid][Misija28],
        MissionData[playerid][Misija29],
        MissionData[playerid][Misija30],
        PlayerData[playerid][EventGold],
        PlayerData[playerid][EventSilver],
        PlayerData[playerid][EventBronze],
        GetPlayersName(playerid));
        mysql_tquery(Mysql_users, query, "", "");
	}
}