Just RP problem
#3

Код:
public SaveStats(playerid)
{

	SaveLocation(playerid);
	SaveWeapons(playerid);
	if(!strlen(CharacterInfo[playerid][active_character[playerid]][cRadioAuth])) { format(CharacterInfo[playerid][active_character[playerid]][cRadioAuth],16,"none"); }
	new str[1024];
	new Float:hp, Float:armor;
	new rankname[128];
	new radioauth[128];
	new crank[32];
	new cname[128];
	new cleanaccent[16];
	mysql_real_escape_string(CharacterInfo[playerid][active_character[playerid]][cName],cname);
	mysql_real_escape_string(CharacterInfo[playerid][active_character[playerid]][cCompanyRank],crank);
	mysql_real_escape_string(CharacterInfo[playerid][active_character[playerid]][cRankName],rankname);
	mysql_real_escape_string(CharacterInfo[playerid][active_character[playerid]][cRadioAuth],radioauth);
	mysql_real_escape_string(accent[playerid],cleanaccent);
	GetPlayerHealth(playerid,hp);
 	if(!duty[playerid]) { GetPlayerArmour(playerid,armor); } else { armor = CharacterInfo[playerid][active_character[playerid]][cArmor]; }
	if(hp < 10.0) { hp = 10.0; }
	format(str,sizeof(str),"UPDATE rp_characters SET name = '%s', money = '%d', spawn_x = '%f', spawn_y = '%f', spawn_z = '%f', spawn_r = '%f', spawn_i = '%d', skin = '%d', renting = '%d', faction = '%d', phone_number = '%d', weapons = '%s', bank = '%d', payday = '%d', faction_perm = '%d', rank_name = '%s', jail_time = '%d', car_lic = '%d', wep_lic = '%d', pay_time = '%d', level = '%d', exp = '%d',melee = '%d', wep1 = '%d', wep2 = '%d', ammo1 = '%d', ammo2 = '%d', spawn_world = '%d'",
	CharacterInfo[playerid][active_character[playerid]][cName],
	CharacterInfo[playerid][active_character[playerid]][cMoney],
	CharacterInfo[playerid][active_character[playerid]][cSpawnX],
	CharacterInfo[playerid][active_character[playerid]][cSpawnY],
	CharacterInfo[playerid][active_character[playerid]][cSpawnZ],
	CharacterInfo[playerid][active_character[playerid]][cSpawnR],
	CharacterInfo[playerid][active_character[playerid]][cSpawnI],
	CharacterInfo[playerid][active_character[playerid]][cSkin],
	CharacterInfo[playerid][active_character[playerid]][cRenting],
	CharacterInfo[playerid][active_character[playerid]][cFaction],
	CharacterInfo[playerid][active_character[playerid]][cPhone],
	CharacterInfo[playerid][active_character[playerid]][cWeapons],
	CharacterInfo[playerid][active_character[playerid]][cBank],
	CharacterInfo[playerid][active_character[playerid]][cPayday],
	CharacterInfo[playerid][active_character[playerid]][cFactionPermissions],
	rankname,
	CharacterInfo[playerid][active_character[playerid]][cJailTime],
	CharacterInfo[playerid][active_character[playerid]][cCarLic],
	CharacterInfo[playerid][active_character[playerid]][cWepLic],
	CharacterInfo[playerid][active_character[playerid]][cPayTime],
	CharacterInfo[playerid][active_character[playerid]][cLevel],
	CharacterInfo[playerid][active_character[playerid]][cExp],
	CharacterInfo[playerid][active_character[playerid]][cMeleeWep],
	GetPrimaryWeapon(playerid),
	GetSecondaryWeapon(playerid),
	GetWeaponAmmo(playerid, CharacterInfo[playerid][active_character[playerid]][cPerm1]),
	GetWeaponAmmo(playerid, CharacterInfo[playerid][active_character[playerid]][cPerm2]),
	CharacterInfo[playerid][active_character[playerid]][cSpawnWorld]);
	new str2[1024];
	format(str2,sizeof(str2),", rc = '%d', radio_auth = '%s', job = '%d', jcool = '%d', addict = '%d', alvl = '%d', savings = '%d', fly_lic = '%d', health = '%f', armor = '%f', duplicate = '%d', employed = '%d', hotel = '%d', lic_warns = '%d', badge = '%d', ccool = '%d', deaths = '%d', hins = '%d', fstyle = '%d', comp = '%d', comp_perms = '%d', comp_rank = '%s', acc = '%s', lang = '%d', skill = '%d', skill_lvl = '%d', pmodel = '%d', bail = '%d' WHERE id = '%d' LIMIT 1",
	CharacterInfo[playerid][active_character[playerid]][cRadioChannel],
	radioauth,
	CharacterInfo[playerid][active_character[playerid]][cJob],
	CharacterInfo[playerid][active_character[playerid]][cJobCooldown],
	CharacterInfo[playerid][active_character[playerid]][cAddiction],
	CharacterInfo[playerid][active_character[playerid]][cAddictionLevel],
	CharacterInfo[playerid][active_character[playerid]][cSavings],
	CharacterInfo[playerid][active_character[playerid]][cFlyLic],
	hp,
	armor,
	CharacterInfo[playerid][active_character[playerid]][cDuplicate],
	CharacterInfo[playerid][active_character[playerid]][cEmployed],
	CharacterInfo[playerid][active_character[playerid]][cHotel],
	CharacterInfo[playerid][active_character[playerid]][cCarLicWarnings],
	CharacterInfo[playerid][active_character[playerid]][cBadge],
	CharacterInfo[playerid][active_character[playerid]][cChopCooldown],
	CharacterInfo[playerid][active_character[playerid]][cDeaths],
	CharacterInfo[playerid][active_character[playerid]][cHealthInsurance],
	CharacterInfo[playerid][active_character[playerid]][cFstyle],
	CharacterInfo[playerid][active_character[playerid]][cCompany],
	CharacterInfo[playerid][active_character[playerid]][cCompanyPerms],
	crank,
	cleanaccent,
	CharacterInfo[playerid][active_character[playerid]][cLanguage],
	CharacterInfo[playerid][active_character[playerid]][cSkill],
	CharacterInfo[playerid][active_character[playerid]][cSkillLevel],
	CharacterInfo[playerid][active_character[playerid]][cPhoneModel],
	CharacterInfo[playerid][active_character[playerid]][cBail],
	CharacterInfo[playerid][active_character[playerid]][cID]);
	strcat(str,str2);
	mysql_query(str,player_save_threads[playerid],QUERY_SAVE_PLAYER);
	new str3[256];
	format(str3, sizeof(str3), "UPDATE rp_characters SET cFishing = '%d', cDelivery = '%d', cPizza = '%d', cTrucker = '%d', cGarbage = '%d' WHERE ID = '%d' LIMIT 1",
	CharacterInfo[playerid][active_character[playerid]][cFish],
	CharacterInfo[playerid][active_character[playerid]][cDelivery],
	CharacterInfo[playerid][active_character[playerid]][cPizza],
	CharacterInfo[playerid][active_character[playerid]][cTrucker],
	CharacterInfo[playerid][active_character[playerid]][cGarbage],
	CharacterInfo[playerid][active_character[playerid]][cID]);
	mysql_query(str3,player_save_threads[playerid],QUERY_SAVE_PLAYER);
	format(str,sizeof(str),"UPDATE rp_users SET admin = '%d', jail_time = '%d', tutorial = '%d', assistant = '%d', last_online = NOW(), bikeperm = '%d' WHERE id = '%d'",
	AccountInfo[playerid][aAdmin],
	AccountInfo[playerid][aJailTime],
	AccountInfo[playerid][aTutorial],
	AccountInfo[playerid][aAssistant],
	AccountInfo[playerid][aBikePerm],
	AccountInfo[playerid][aID]);
	mysql_query(str,player_threads_alt[playerid]);


}
I have SaveStats at onplayerdisconnect..

I have /refresh , /saveplayer or /savestuff for backup but don't work..
I give In Game 100k, i have 100k and in database at my account i have 5k..money from register...
Reply


Messages In This Thread
Just RP problem - by DonBonanno - 08.02.2015, 14:52
Re: Just RP problem - by Sascha - 08.02.2015, 14:55
Re: Just RP problem - by DonBonanno - 08.02.2015, 15:01
Re: Just RP problem - by Sascha - 08.02.2015, 15:04
Re: Just RP problem - by DonBonanno - 08.02.2015, 15:17
Re: Just RP problem - by Sascha - 08.02.2015, 15:21
Re: Just RP problem - by DonBonanno - 08.02.2015, 15:35
Re: Just RP problem - by Sascha - 08.02.2015, 15:48

Forum Jump:


Users browsing this thread: 1 Guest(s)