1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Mysql, CJ SKIN
sscarface
Gangsta
****
Posts: 525
Threads: 158
Joined: Apr 2012
Reputation: 0
#1

08.06.2015, 02:52
PHP код:
forward OnStatsSave(playerid);
public OnStatsSave(playerid)
{
    pData[playerid][IDD] = 0;
    format(pData[playerid][Name], 24, "");
    format(pData[playerid][IP], 16, "");
    pData[playerid][Level] = 0;
    pData[playerid][Colour] = -1;
    pData[playerid][RegTime] = 0;
    pData[playerid][OnlineTime] = 0;
    pData[playerid][Score] = 0;
    pData[playerid][Money] = 0;
    pData[playerid][Skin] = 0; 
PHP код:
pData[playerid][Skin] = 0; 
^^, THis spawns me as Cj skin. How to fix it.
Find
Reply
sscarface
Gangsta
****
Posts: 525
Threads: 158
Joined: Apr 2012
Reputation: 0
#2

08.06.2015, 03:46
Someone help me? how to fix it? I don't think the code is wrong but is there any idea to avoid this cj skin bug or fix it?
Find
Reply
SoFahim
Gangsta
*****
Posts: 879
Threads: 63
Joined: May 2015
Reputation: 0
#3

08.06.2015, 04:04
Can you show us Saving skin code? This is only format
Find
Reply
sscarface
Gangsta
****
Posts: 525
Threads: 158
Joined: Apr 2012
Reputation: 0
#4

08.06.2015, 04:19
PHP код:
enum pdata //players' data
{
    IDD,
    Name[24],
        Money,
    Skin,
} 
PHP код:
stock SaveStats(playerid)
{
    if(LoggedIn[playerid] == 1)
    {
        new SessionTime = gettime() - Connected[playerid]; //calculate their current session length
        
        pData[playerid][Money] = GetPlayerMoney(playerid);
         pData[playerid][Score] = GetPlayerScore(playerid);
         mysql_format(ch, query, sizeof(query),
          "UPDATE `players` SET ip='%s', level=%d, colour=%d, onlinetime=%d, score=%d, money=%d WHERE id=%d",
            pData[playerid][IP], pData[playerid][Level], pData[playerid][Colour], pData[playerid][OnlineTime] + SessionTime,
             pData[playerid][Score], pData[playerid][Money], pData[playerid][IDD]);
        switch(Disconnecting[playerid])
        {
            case 0: mysql_pquery(ch, query);
            case 1: mysql_pquery(ch, query, "OnStatsSave", "i", playerid);
            default: mysql_pquery(ch, query);
        }
    }
    return 1;
} 

PHP код:
forward OnStatsSave(playerid);
public OnStatsSave(playerid)
{
    pData[playerid][IDD] = 0;
    format(pData[playerid][Name], 24, "");
    format(pData[playerid][IP], 16, "");
    pData[playerid][Level] = 0;
    pData[playerid][Money] = 0;
       pData[playerid][Skin] = 0; 
Find
Reply
sscarface
Gangsta
****
Posts: 525
Threads: 158
Joined: Apr 2012
Reputation: 0
#5

08.06.2015, 05:17
?
Find
Reply
SoFahim
Gangsta
*****
Posts: 879
Threads: 63
Joined: May 2015
Reputation: 0
#6

08.06.2015, 05:32
PHP код:
stock SaveStats(playerid)
{
    if(LoggedIn[playerid] == 1)
    {
        new SessionTime = gettime() - Connected[playerid]; //calculate their current session length
        
        pData[playerid][Money] = GetPlayerMoney(playerid);
         pData[playerid][Score] = GetPlayerScore(playerid);
         mysql_format(ch, query, sizeof(query),
          "UPDATE `players` SET ip='%s', level=%d, colour=%d, onlinetime=%d, score=%d, money=%d WHERE id=%d",
            pData[playerid][IP], pData[playerid][Level], pData[playerid][Colour], pData[playerid][Skin], pData[playerid][OnlineTime] + SessionTime,
             pData[playerid][Score], pData[playerid][Money], pData[playerid][IDD]);
        switch(Disconnecting[playerid])
        {
            case 0: mysql_pquery(ch, query);
            case 1: mysql_pquery(ch, query, "OnStatsSave", "i", playerid);
            default: mysql_pquery(ch, query);
        }
    }
    return 1;
} 
Try with this.
Find
Reply
sscarface
Gangsta
****
Posts: 525
Threads: 158
Joined: Apr 2012
Reputation: 0
#7

08.06.2015, 11:34
didnt work. anyone help?
Find
Reply
JaydenJason
Gangsta
****
Posts: 687
Threads: 35
Joined: Oct 2014
Reputation: 0
#8

08.06.2015, 12:08
Код:
forward OnStatsSave(playerid);
public OnStatsSave(playerid)
{
	pData[playerid][IDD] = 0;
	format(pData[playerid][Name], 24, "");
	format(pData[playerid][IP], 16, "");
	pData[playerid][Level] = 0;
	pData[playerid][Money] = 0;
       pData[playerid][Skin] = GetPlayerSkin(playerid);
Find
Reply
sscarface
Gangsta
****
Posts: 525
Threads: 158
Joined: Apr 2012
Reputation: 0
#9

09.06.2015, 01:06
PHP код:
enum pdata //players' data
{
    IDD,
    Name[24],
    IP[16],
    Level,
    Colour,
    RegTime,
    OnlineTime,
    Score,
    Money,
    Skin
} 
PHP код:
stock SaveStats(playerid)
{
    if(LoggedIn[playerid] == 1)
    {
        new SessionTime = gettime() - Connected[playerid]; //calculate their current session length
        
        pData[playerid][Money] = GetPlayerCash(playerid);
         pData[playerid][Score] = GetPlayerScore(playerid);
         pData[playerid][Skin] = GetPlayerSkin(playerid);
         mysql_format(ch, query, sizeof(query),
          "UPDATE `players` SET ip='%s', level=%d, colour=%d, onlinetime=%d, score=%d, money=%d, skin=%d WHERE id=%d",
            pData[playerid][IP], pData[playerid][Level], pData[playerid][Colour], pData[playerid][OnlineTime] + SessionTime,
             pData[playerid][Score], pData[playerid][Money], pData[playerid][Skin], pData[playerid][IDD]);
        switch(Disconnecting[playerid])
        {
            case 0: mysql_pquery(ch, query);
            case 1: mysql_pquery(ch, query, "OnStatsSave", "i", playerid);
            default: mysql_pquery(ch, query);
        }
    }
    return 1;
}
forward OnStatsSave(playerid);
public OnStatsSave(playerid)
{
    pData[playerid][IDD] = 0;
    format(pData[playerid][Name], 24, "");
    format(pData[playerid][IP], 16, "");
    pData[playerid][Level] = 0;
    pData[playerid][Colour] = -1;
    pData[playerid][RegTime] = 0;
    pData[playerid][OnlineTime] = 0;
    pData[playerid][Score] = 0;
    pData[playerid][Money] = 0;
    pData[playerid][Skin] = 0;
    Connected[playerid] = -1;
    LoggedIn[playerid] = 0;
    PasswordAttempts[playerid] = 0;
    Disconnecting[playerid] = -1;
    return 1;
} 
PHP код:
stock LogPlayerIn(playerid)
{
    cache_get_row(0, 0, strr); pData[playerid][IDD] = strval(strr); //Load player's stats from the database
    cache_get_row(0, 4, strr); pData[playerid][Level] = strval(strr);
    cache_get_row(0, 5, strr); pData[playerid][Colour] = strval(strr);
    cache_get_row(0, 6, strr); pData[playerid][RegTime] = strval(strr);
    cache_get_row(0, 7, strr); pData[playerid][OnlineTime] = strval(strr);
    cache_get_row(0, 8, strr); pData[playerid][Score] = strval(strr);
    cache_get_row(0, 9, strr); pData[playerid][Money] = strval(strr);
    cache_get_row(0, 10, strr); pData[playerid][Skin] = strval(strr); 
PHP код:
public OnPlayerSpawn(playerid)
{
    if(LoggedIn[playerid] == 0) return 0;
    if(LoggedIn[playerid] == 1)
    {
    SetPlayerCash(playerid, pData[playerid][Money]);
    SetPlayerScore(playerid, pData[playerid][Score]);
    SetPlayerSkin(playerid, pData[playerid][Skin];
    }
return 1;
} 
Whenever i add "SetPlayerSkin(playerid, pData[playerid][Skin];" so it spawns with CJ SKIN.
Find
Reply
sscarface
Gangsta
****
Posts: 525
Threads: 158
Joined: Apr 2012
Reputation: 0
#10

09.06.2015, 01:18
UPDATED:
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help