Mysql Save
#1

PHP код:
SavePlayer(playerid)
{
if(
PlayerInfo[playerid][LoggedIn] == 1)
{
       
dUserSetINT(PlayerName2(playerid)).("money",GetPlayerMoney(playerid));
       
dUserSetINT(PlayerName2(playerid)).("kills",PlayerInfo[playerid][Kills]);
       
dUserSetINT(PlayerName2(playerid)).("Navy",PlayerInfo[playerid][Navy]);
       
dUserSetINT(PlayerName2(playerid)).("deaths",PlayerInfo[playerid][Deaths]);
       
dUserSetINT(PlayerName2(playerid)).("Score",GetPlayerScore(playerid));
       
dUserSetINT(PlayerName2(playerid)).("Help Moderator",PlayerInfo[playerid][Helper]);
       
dUserSetINT(PlayerName2(playerid)).("tag",PlayerInfo[playerid][Tag]);
       
dUserSetINT(PlayerName2(playerid)).("Donor",PlayerInfo[playerid][dRank]);
       
dUserSetINT(PlayerName2(playerid)).("clanskin",PlayerInfo[playerid][ClanSkin]);
       
dUserSetINT(PlayerName2(playerid)).("vip",PlayerInfo[playerid][Vip]);
       
dUserSetINT(PlayerName2(playerid)).("level",PlayerInfo[playerid][Level]);
       
dUserSetINT(PlayerName2(playerid)).("gift",PlayerInfo[playerid][Gift]);
    new 
hms;
    
TotalGameTime(playeridhms);
    
    
dUserSetINT(PlayerName2(playerid)).("hours"h);
    
dUserSetINT(PlayerName2(playerid)).("minutes"m);
    
dUserSetINT(PlayerName2(playerid)).("seconds"s);
       new 
Float:x,Float:y,Float:zinterior;
       
GetPlayerPos(playerid,x,y,z);    interior GetPlayerInterior(playerid);
    
dUserSetINT(PlayerName2(playerid)).("x1",floatround(x));
    
dUserSetINT(PlayerName2(playerid)).("y1",floatround(y));
    
dUserSetINT(PlayerName2(playerid)).("z1",floatround(z));
    
dUserSetINT(PlayerName2(playerid)).("interior1",interior);
    new 
weap1ammo1weap2ammo2weap3ammo3weap4ammo4weap5ammo5weap6ammo6;
    
GetPlayerWeaponData(playerid,2,weap1,ammo1);// hand gun
    
GetPlayerWeaponData(playerid,3,weap2,ammo2);//shotgun
    
GetPlayerWeaponData(playerid,4,weap3,ammo3);// SMG
    
GetPlayerWeaponData(playerid,5,weap4,ammo4);// AK47 / M4
    
GetPlayerWeaponData(playerid,6,weap5,ammo5);// rifle
    
GetPlayerWeaponData(playerid,7,weap6,ammo6);// rocket launcher
       
dUserSetINT(PlayerName2(playerid)).("weap1",weap1); dUserSetINT(PlayerName2(playerid)).("weap1ammo",ammo1);
      
dUserSetINT(PlayerName2(playerid)).("weap2",weap2);    dUserSetINT(PlayerName2(playerid)).("weap2ammo",ammo2);
      
dUserSetINT(PlayerName2(playerid)).("weap3",weap3);    dUserSetINT(PlayerName2(playerid)).("weap3ammo",ammo3);
    
dUserSetINT(PlayerName2(playerid)).("weap4",weap4); dUserSetINT(PlayerName2(playerid)).("weap4ammo",ammo4);
      
dUserSetINT(PlayerName2(playerid)).("weap5",weap5);    dUserSetINT(PlayerName2(playerid)).("weap5ammo",ammo5);
    
dUserSetINT(PlayerName2(playerid)).("weap6",weap6); dUserSetINT(PlayerName2(playerid)).("weap6ammo",ammo6);
    new    
Float:health;    GetPlayerHealth(playeridFloat:health);
    new    
Float:armour;    GetPlayerArmour(playeridFloat:armour);
    new 
year,month,day;    getdate(yearmonthday);
    new 
strdate[20];    format(strdatesizeof(strdate), "%d.%d.%d",day,month,year);
    new 
file[256];         format(file,sizeof(file),"/ladmin/users/%s.sav",udb_encode(PlayerName2(playerid)) );
    
dUserSetINT(PlayerName2(playerid)).("health",floatround(health));
    
dUserSetINT(PlayerName2(playerid)).("armour",floatround(armour));
    
dini_Set(file,"LastOn",strdate);
    
dUserSetINT(PlayerName2(playerid)).("loggedin",0);
    
dUserSetINT(PlayerName2(playerid)).("TimesOnServer",(dUserINT(PlayerName2(playerid)).("TimesOnServer"))+1);
    }

Its save in INI how save it to mysql

Database Name Clan
Tablename PlayerInfo

Please give me code
Reply
#2

Anyone reply ?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)