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

Threaded Mode
SQLlite
ratxrat
Big Clucker
***
Posts: 98
Threads: 27
Joined: Jun 2015
Reputation: 0
#1

16.02.2016, 07:48
I want create data use SQLlite this for enum
PHP Code:
enum pDat
{
    pFaction,
    pFacrank,
    pFacleader,
    pmentah,
    pkemas,
    pjadi,
    pskin,
    fduty,
    pmobil,
    Float:vx,
    Float:vy,
    Float:vz,
    pgaji,
    pjob,
    pmaterial,
    pbank,
    vmod1,
    vmod2,
    vmod3,
    vmod4,
    vmod5,
    vmod6,
    vmod7,
    vmod8,
    vmod9,
    vmod10,
    vmod11,
    vmod12,
    vmod13,
    vmod14
}
new PlayerData[MAX_PLAYERS][pDat]; 
how to save, load and update use SQLlite??
i want update data every 5 minute to query
Find
Reply
FreAkeD
Gangsta
****
Posts: 630
Threads: 23
Joined: May 2012
Reputation: 0
#2

16.02.2016, 07:59
You should learn SQLite. By doing that, you'll basically able to do it yourself.

https://sampwiki.blast.hk/wiki/SQLite

A good tutorial on this: https://sampforum.blast.hk/showthread.php?tid=449536
Find
Reply
ratxrat
Big Clucker
***
Posts: 98
Threads: 27
Joined: Jun 2015
Reputation: 0
#3

16.02.2016, 09:17
^^ im download gm SQLlite basic for learn. im isert new colloum to database but not save data to database

insert enum for new data , and stock for save and load data but still cannot sace to database
Find
Reply
ratxrat
Big Clucker
***
Posts: 98
Threads: 27
Joined: Jun 2015
Reputation: 0
#4

16.02.2016, 09:24
enum
PHP Code:
enum pInfo
{
    // Stored Variables
    pID,
    pUsername[MAX_PLAYER_NAME],
    pAge,
    pGender,
    pRegistered,
    pMember,
    pRank,
    pLeader,
    pIP[16],
    pBanned,
    pBanReason[64],
    pBanExpiry,
    pJailTime,
    pJailReason[64],
    pNMute,
    pRMute,
    pAdminLevel,
    pSecondaryTask,
    pMoney,
    Float:pPositionX,
    Float:pPositionY,
    Float:pPositionZ,
    Float:pFacingAngle,
    pInterior,
    pVirtualWorld,
    pSkin,
    Float:pHealth,
    Float:pArmour,
// this new data ↓
     pFaction,
    pFacrank,
    pFacleader,
    pmentah,
    pkemas,
    pjadi,
    pskin,
    fduty,
    pmobil,
    Float:vx,
    Float:vy,
    Float:vz,
    pjob,
    pmaterial,
    pbank,
    pgaji,
    plevel,
    ppoin,
//======================
    // Unstored Variables
    pReport[128],
    pTogNewbie,
    pLastUpdate,
    PlayerAnimLibsPreloaded,
    gPlayerUsingLoopingAnim,
    CurrentDialog,
}
new PlayerInfo[MAX_PLAYERS][pInfo]; 
stock load
PHP Code:
if(IsPlayerLogged(playerid))
    {
        new DBResult:dbresult, szQuery[256];
        format(szQuery, sizeof(szQuery), "SELECT * FROM Accounts WHERE Username = '%s'", DB_Escape(PlayerInfo[playerid][pUsername]));
        dbresult = db_query(Database, szQuery);
        if(db_num_rows(dbresult) > 0)
        {
            new szValue[64];
            db_get_field_assoc(dbresult, "Age", szValue, sizeof(szValue));
            PlayerInfo[playerid][pAge] = strval(szValue);
            db_get_field_assoc(dbresult, "Gender", szValue, sizeof(szValue));
            PlayerInfo[playerid][pGender] = strval(szValue);
            db_get_field_assoc(dbresult, "Registered", szValue, sizeof(szValue));
            PlayerInfo[playerid][pRegistered] = strval(szValue);
            db_get_field_assoc(dbresult, "Member", szValue, sizeof(szValue));
            PlayerInfo[playerid][pMember] = strval(szValue);
            db_get_field_assoc(dbresult, "Rank", szValue, sizeof(szValue));
            PlayerInfo[playerid][pRank] = strval(szValue);
            db_get_field_assoc(dbresult, "Leader", szValue, sizeof(szValue));
            PlayerInfo[playerid][pLeader] = strval(szValue);
            db_get_field_assoc(dbresult, "Banned", szValue, sizeof(szValue));
            PlayerInfo[playerid][pBanned] = strval(szValue);
            db_get_field_assoc(dbresult, "BanReason", PlayerInfo[playerid][pBanReason], 64);
            db_get_field_assoc(dbresult, "JailTime", szValue, sizeof(szValue));
            PlayerInfo[playerid][pJailTime] = strval(szValue);
            db_get_field_assoc(dbresult, "JailReason", PlayerInfo[playerid][pJailReason], 64);
            db_get_field_assoc(dbresult, "BanExpiry", szValue, sizeof(szValue));
            PlayerInfo[playerid][pBanExpiry] = strval(szValue);
            db_get_field_assoc(dbresult, "NMute", szValue, sizeof(szValue));
            PlayerInfo[playerid][pNMute] = strval(szValue);
            db_get_field_assoc(dbresult, "RMute", szValue, sizeof(szValue));
            PlayerInfo[playerid][pRMute] = strval(szValue);
            db_get_field_assoc(dbresult, "AdminLevel", szValue, sizeof(szValue));
            PlayerInfo[playerid][pAdminLevel] = strval(szValue);
            db_get_field_assoc(dbresult, "SecondaryTask", szValue, sizeof(szValue));
            PlayerInfo[playerid][pSecondaryTask] = strval(szValue);
            db_get_field_assoc(dbresult, "Money", szValue, sizeof(szValue));
            PlayerInfo[playerid][pMoney] = strval(szValue);
            db_get_field_assoc(dbresult, "PositionX", szValue, sizeof(szValue));
            PlayerInfo[playerid][pPositionX] = floatstr(szValue);
            db_get_field_assoc(dbresult, "PositionY", szValue, sizeof(szValue));
            PlayerInfo[playerid][pPositionY] = floatstr(szValue);
            db_get_field_assoc(dbresult, "PositionZ", szValue, sizeof(szValue));
            PlayerInfo[playerid][pPositionZ] = floatstr(szValue);
            db_get_field_assoc(dbresult, "FacingAngle", szValue, sizeof(szValue));
            PlayerInfo[playerid][pFacingAngle] = floatstr(szValue);
            db_get_field_assoc(dbresult, "Interior", szValue, sizeof(szValue));
            PlayerInfo[playerid][pInterior] = strval(szValue);
            db_get_field_assoc(dbresult, "VirtualWorld", szValue, sizeof(szValue));
            PlayerInfo[playerid][pVirtualWorld] = strval(szValue);
            db_get_field_assoc(dbresult, "Skin", szValue, sizeof(szValue));
            PlayerInfo[playerid][pSkin] = strval(szValue);
            db_get_field_assoc(dbresult, "Health", szValue, sizeof(szValue));
            PlayerInfo[playerid][pHealth] = floatstr(szValue);
            db_get_field_assoc(dbresult, "Armour", szValue, sizeof(szValue));
            PlayerInfo[playerid][pArmour] = floatstr(szValue);
                       //====================new data ↓
            db_get_field_assoc(dbresult, "Faction", szValue, sizeof(szValue));
            PlayerInfo[playerid][pFaction] = strval(szValue);
            db_get_field_assoc(dbresult, "Facrank", szValue, sizeof(szValue));
            PlayerInfo[playerid][pFacrank] = strval(szValue);
            db_get_field_assoc(dbresult, "Facleafer", szValue, sizeof(szValue));
            PlayerInfo[playerid][pFacleader] = strval(szValue);
            db_get_field_assoc(dbresult, "mentah", szValue, sizeof(szValue));
            PlayerInfo[playerid][pmentah] = strval(szValue);
            db_get_field_assoc(dbresult, "kemas", szValue, sizeof(szValue));
            PlayerInfo[playerid][pkemas] = strval(szValue);
               db_get_field_assoc(dbresult, "jadi", szValue, sizeof(szValue));
            PlayerInfo[playerid][pjadi] = strval(szValue);
               db_get_field_assoc(dbresult, "facduty", szValue, sizeof(szValue));
            PlayerInfo[playerid][fduty] = strval(szValue);
            db_get_field_assoc(dbresult, "mobil", szValue, sizeof(szValue));
            PlayerInfo[playerid][pmobil] = strval(szValue);
            db_get_field_assoc(dbresult, "mobilx", szValue, sizeof(szValue));
            PlayerInfo[playerid][vx] = floatstr(szValue);
            db_get_field_assoc(dbresult, "mobily", szValue, sizeof(szValue));
            PlayerInfo[playerid][vy] = floatstr(szValue);
            db_get_field_assoc(dbresult, "mobilz", szValue, sizeof(szValue));
            PlayerInfo[playerid][vz] = floatstr(szValue);
            db_get_field_assoc(dbresult, "job", szValue, sizeof(szValue));
            PlayerInfo[playerid][pjob] = strval(szValue);
            db_get_field_assoc(dbresult, "material", szValue, sizeof(szValue));
            PlayerInfo[playerid][pmaterial] = strval(szValue);
            db_get_field_assoc(dbresult, "bank", szValue, sizeof(szValue));
            PlayerInfo[playerid][pbank] = strval(szValue);
                        db_get_field_assoc(dbresult, "gaji", szValue, sizeof(szValue));
            PlayerInfo[playerid][pgaji] = strval(szValue);
            db_get_field_assoc(dbresult, "level", szValue, sizeof(szValue));
            PlayerInfo[playerid][plevel] = strval(szValue);
            db_get_field_assoc(dbresult, "poin", szValue, sizeof(szValue));
            PlayerInfo[playerid][ppoin] = strval(szValue);
               //============= ↑=========
            
        }
        db_free_result(dbresult);
        return 1;
    }
    return 0;
} 
stock save
PHP Code:
stock SavePlayerAccount(playerid)
{
    if(IsPlayerLogged(playerid))
    {
        new szQuery[256];
        GetPlayerIp(playerid, PlayerInfo[playerid][pIP], 16);
        GetPlayerPos(playerid, PlayerInfo[playerid][pPositionX], PlayerInfo[playerid][pPositionY], PlayerInfo[playerid][pPositionZ]);
        GetPlayerFacingAngle(playerid, PlayerInfo[playerid][pFacingAngle]);
         PlayerInfo[playerid][pInterior] = GetPlayerInterior(playerid);
         PlayerInfo[playerid][pVirtualWorld] = GetPlayerVirtualWorld(playerid);
        PlayerInfo[playerid][pSkin] = GetPlayerSkin(playerid);
        GetPlayerHealth(playerid, PlayerInfo[playerid][pHealth]);
        GetPlayerArmour(playerid, PlayerInfo[playerid][pArmour]);
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET Age='%i' WHERE Username='%s'", PlayerInfo[playerid][pAge], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET Gender='%i' WHERE Username='%s'", PlayerInfo[playerid][pGender], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET Registered='%i' WHERE Username='%s'", PlayerInfo[playerid][pRegistered], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET Member='%i' WHERE Username='%s'", PlayerInfo[playerid][pMember], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET Rank='%i' WHERE Username='%s'", PlayerInfo[playerid][pRank], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET Leader='%i' WHERE Username='%s'", PlayerInfo[playerid][pLeader], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET IP='%s' WHERE Username='%s'", PlayerInfo[playerid][pIP], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET Banned='%i' WHERE Username='%s'", PlayerInfo[playerid][pBanned], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET BanReason='%s' WHERE Username='%s'", PlayerInfo[playerid][pBanReason], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET BanExpiry='%i' WHERE Username='%s'", PlayerInfo[playerid][pBanExpiry], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET JailTime='%i' WHERE Username='%s'", PlayerInfo[playerid][pBanned], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET JailReason='%s' WHERE Username='%s'", PlayerInfo[playerid][pJailReason], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET NMute='%i' WHERE Username='%s'", PlayerInfo[playerid][pNMute], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET RMute='%i' WHERE Username='%s'", PlayerInfo[playerid][pRMute], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET AdminLevel='%i' WHERE Username='%s'", PlayerInfo[playerid][pAdminLevel], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET SecondaryTask='%i' WHERE Username='%s'", PlayerInfo[playerid][pSecondaryTask], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET Money='%i' WHERE Username='%s'", PlayerInfo[playerid][pMoney], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET PositionX='%f' WHERE Username='%s'", PlayerInfo[playerid][pPositionX], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET PositionY='%f' WHERE Username='%s'", PlayerInfo[playerid][pPositionY], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET PositionZ='%f' WHERE Username='%s'", PlayerInfo[playerid][pPositionZ], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET FacingAngle='%f' WHERE Username='%s'", PlayerInfo[playerid][pFacingAngle], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET Interior='%i' WHERE Username='%s'", PlayerInfo[playerid][pInterior], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET VirtualWorld='%i' WHERE Username='%s'", PlayerInfo[playerid][pVirtualWorld], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET Skin='%i' WHERE Username='%s'", PlayerInfo[playerid][pSkin], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET Health='%f' WHERE Username='%s'", PlayerInfo[playerid][pHealth], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET Armour='%f' WHERE Username='%s'", PlayerInfo[playerid][pArmour], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
               // new data ↓
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET Faction='%f' WHERE Username='%s'", PlayerInfo[playerid][pFaction], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET Facrank='%f' WHERE Username='%s'", PlayerInfo[playerid][pFacrank], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET Facleader='%f' WHERE Username='%s'", PlayerInfo[playerid][pFacleader], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET mentah='%f' WHERE Username='%s'", PlayerInfo[playerid][pmentah], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
          format(szQuery, sizeof(szQuery), "UPDATE Accounts SET kemas='%f' WHERE Username='%s'", PlayerInfo[playerid][pkemas], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
          format(szQuery, sizeof(szQuery), "UPDATE Accounts SET jadi='%f' WHERE Username='%s'", PlayerInfo[playerid][pjadi], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET facduty='%f' WHERE Username='%s'", PlayerInfo[playerid][fduty], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET mobil='%f' WHERE Username='%s'", PlayerInfo[playerid][pmobil], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET mobilx='%f' WHERE Username='%s'", PlayerInfo[playerid][vx], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET mobily='%f' WHERE Username='%s'", PlayerInfo[playerid][vy], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
          format(szQuery, sizeof(szQuery), "UPDATE Accounts SET mobilz='%f' WHERE Username='%s'", PlayerInfo[playerid][vz], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET job='%f' WHERE Username='%s'", PlayerInfo[playerid][pjob], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET material='%f' WHERE Username='%s'", PlayerInfo[playerid][pmaterial], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET bank='%f' WHERE Username='%s'", PlayerInfo[playerid][pbank], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET gaji='%f' WHERE Username='%s'", PlayerInfo[playerid][pgaji], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET level='%f' WHERE Username='%s'", PlayerInfo[playerid][plevel], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
        format(szQuery, sizeof(szQuery), "UPDATE Accounts SET poin='%f' WHERE Username='%s'", PlayerInfo[playerid][ppoin], DB_Escape(PlayerInfo[playerid][pUsername]));
        db_free_result(db_query(Database, szQuery));
                // ↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑
        return 1;
    }
    return 0;
} 
Find
Reply
Sew_Sumi
Banned
Posts: 6,242
Threads: 8
Joined: Jun 2008
#5

16.02.2016, 10:07
Have you made a timer to invoke SavePlayerAccount?
Find
Reply
ratxrat
Big Clucker
***
Posts: 98
Threads: 27
Joined: Jun 2015
Reputation: 0
#6

16.02.2016, 10:14
Quote:

Have you made a timer to invoke SavePlayerAccount?
i dont have timer for saveplayeraccount
Find
Reply
Sew_Sumi
Banned
Posts: 6,242
Threads: 8
Joined: Jun 2008
#7

16.02.2016, 10:30
You'll be needing that timer.

Code:
new ServerMinute;
forward MinuteTick();
forward SaveAllAccounts;
 
public OnGameModeInit()
{
    SetTimer("MinuteTick", 60000, false); // 
}
 
public MinuteTick()
{
    ServerMinute++
    if(ServerMinute>5){ServerMinute==0;SaveAllAccounts;}
}

public SaveAllAccounts()
{
   // In here you will need to use foreach, or a for loop to go through each player and SavePlayerAccount(i);
}
You will however need to do something to go through each player on the server and save each of their accounts, and switch out the final SavePlayerAccount in the code above
Find
Reply
ratxrat
Big Clucker
***
Posts: 98
Threads: 27
Joined: Jun 2015
Reputation: 0
#8

16.02.2016, 11:40
-----
Find
Reply
ratxrat
Big Clucker
***
Posts: 98
Threads: 27
Joined: Jun 2015
Reputation: 0
#9

16.02.2016, 11:42
Quote:
Originally Posted by Sew_Sumi
View Post
Have you made a timer to invoke SavePlayerAccount?
Quote:
Originally Posted by Sew_Sumi
View Post
You'll be needing that timer.

Code:
new ServerMinute;
forward MinuteTick();
forward SaveAllAccounts;
 
public OnGameModeInit()
{
    SetTimer("MinuteTick", 60000, false); // 
}
 
public MinuteTick()
{
    ServerMinute++
    if(ServerMinute>5){ServerMinute==0;SaveAllAccounts;}
}

public SaveAllAccounts()
{
   // In here you will need to use foreach, or a for loop to go through each player and SavePlayerAccount(i);
}
You will however need to do something to go through each player on the server and save each of their accounts, and switch out the final SavePlayerAccount in the code above
i get this error
Quote:

D:\server\SQLite\gamemodes\tes.pwn(232) : error 001: expected token: "(", but found ";"
D:\server\SQLite\gamemodes\tes.pwn(233) : error 001: expected token: ")", but found "forward"
D:\server\SQLite\gamemodes\tes.pwn(233) : error 001: expected token: ";", but found "forward"
D:\server\SQLite\gamemodes\tes.pwn(111 : error 001: expected token: ";", but found "if"
D:\server\SQLite\gamemodes\tes.pwn(111 : warning 215: expression has no effect
D:\server\SQLite\gamemodes\tes.pwn(111 : error 076: syntax error in the expression, or invalid function call
Find
Reply
ratxrat
Big Clucker
***
Posts: 98
Threads: 27
Joined: Jun 2015
Reputation: 0
#10

16.02.2016, 11:59
im fix error but still cannot save to database
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