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

Threaded Mode
Sqlite BUD
Ryan_Obeles
Big Clucker
***
Posts: 175
Threads: 34
Joined: Jan 2012
Reputation: 0
#1

20.04.2013, 08:46
SAVE

PHP код:
if(IsPlayerLoggedIn[playerid] == 1)
    {
        new Money = GetPlayerMoney(playerid);
        new Skin = GetPlayerSkin(playerid);
        new Level = GetPlayerScore(playerid);
        new Float:PHealth, Float:PArmour;
        new VWorld = GetPlayerVirtualWorld(playerid);
           new Interior = GetPlayerInterior(playerid);
        GetPlayerHealth(playerid, PHealth);
        GetPlayerArmour(playerid, PArmour);
        for (new i = 0; i < 13; i++)
        {
            GetPlayerWeaponData(playerid, i, PlayerData[playerid][pWeapon][i], PlayerData[playerid][pWeaponAmmo][i]);
        }
        new File = BUD::GetNameUID(GetName(playerid));
        BUD::MultiSet(File, "iiiii", "Age", PlayerData[playerid][pAge], "Vip", PlayerData[playerid][pVip], "Admin", PlayerData[playerid][pAdmin], "Money", Money, "Level", Level);
        BUD::MultiSet(File, "iiiii", "Gender", PlayerData[playerid][pGender], "Accent", PlayerData[playerid][pAccent], "Skin", Skin, "Carlic", PlayerData[playerid][pCarLic], "BoatLic", PlayerData[playerid][pBoatLic]);
        BUD::MultiSet(File, "iffff", "FlyLic", PlayerData[playerid][pFlyLic], "PosX", PlayerData[playerid][pPosX], "PosY", PlayerData[playerid][pPosY], "PosZ", PlayerData[playerid][pPosZ], "PosAngle", PlayerData[playerid][pPosAngle]);
        BUD::MultiSet(File, "iiiii", "Payday", PlayerData[playerid][pPayday], "HadPayDay", PlayerData[playerid][pHadPayDay], "Family", PlayerData[playerid][pFamily], "Faction", PlayerData[playerid][pFaction], "Tutorial", PlayerData[playerid][pTutorial]);
        BUD::MultiSet(File, "iiffi", "FactionRank", PlayerData[playerid][pFactionRank], "Injured", PlayerData[playerid][pInjured], "Health", PHealth, "Armour", PArmour, "VW", VWorld);
        BUD::MultiSet(File, "iiiii", "Interior", Interior, "Job", PlayerData[playerid][pJob], "BankBalance", PlayerData[playerid][pBankBalance], "Weapon1", PlayerData[playerid][pWeapon][0], "Weapon1Ammo", PlayerData[playerid][pWeaponAmmo][0]);
        BUD::MultiSet(File, "iiiii", "Weapon2", PlayerData[playerid][pWeapon][1], "Weapon2Ammo", PlayerData[playerid][pWeaponAmmo][1], "Weapon3", PlayerData[playerid][pWeapon][2], "Weapon3Ammo", PlayerData[playerid][pWeaponAmmo][2], "Weapon4", PlayerData[playerid][pWeapon][3]);
        BUD::MultiSet(File, "iiiii", "Weapon4Ammo", PlayerData[playerid][pWeaponAmmo][3], "Weapon5", PlayerData[playerid][pWeapon][4], "Weapon5Ammo", PlayerData[playerid][pWeaponAmmo][4], "Weapon6", PlayerData[playerid][pWeapon][5], "Weapon6Ammo", PlayerData[playerid][pWeaponAmmo][5]);
        BUD::MultiSet(File, "iiiii", "Weapon7", PlayerData[playerid][pWeapon][6], "Weapon7Ammo", PlayerData[playerid][pWeaponAmmo][6], "Weapon8", PlayerData[playerid][pWeapon][7], "Weapon8Ammo", PlayerData[playerid][pWeaponAmmo][7], "Weapon9", PlayerData[playerid][pWeapon][8]);
        BUD::MultiSet(File, "iiiii", "Weapon9Ammo", PlayerData[playerid][pWeaponAmmo][8], "Weapon10", PlayerData[playerid][pWeapon][9], "Weapon10Ammo", PlayerData[playerid][pWeaponAmmo][9], "Weapon11", PlayerData[playerid][pWeapon][10], "Weapon11Ammo", PlayerData[playerid][pWeaponAmmo][10]);
        BUD::MultiSet(File, "iiiii", "Weapon12", PlayerData[playerid][pWeapon][11], "Weapon12Ammo", PlayerData[playerid][pWeaponAmmo][11], "Weapon13", PlayerData[playerid][pWeapon][12], "Weapon13Ammo", PlayerData[playerid][pWeapon][12], "PRadio", PlayerData[playerid][pPRadio]);
        BUD::MultiSet(File, "iiiii", "PRadioFreq", PlayerData[playerid][pPRadioFreq], "Password", PlayerData[playerid][pPassword]);
    } 
LOAD DATA

PHP код:
if(IsPlayerLoggedIn[playerid] == 1)
    {
        new Char[100], File = BUD::GetNameUID(GetName(playerid));
        BUD::MultiGet(File, "iiiii", "Age", Char[0], "Vip", Char[1], "Admin", Char[2], "Money", Char[3], "Level", Char[4]);
        BUD::MultiGet(File, "iiiii", "Gender", Char[5], "Accent", Char[6], "Skin", Char[7], "Carlic", Char[8], "BoatLic", Char[9]);
        BUD::MultiGet(File, "iffff", "FlyLic", Char[10], "PosX", Char[11], "PosY", Char[12], "PosZ", Char[13], "PosAngle", Char[14]);
        BUD::MultiGet(File, "iiiii", "Payday", Char[15], "HadPayDay", Char[16], "Family", Char[17], "Faction", Char[18], "Tutorial", Char[19]);
        BUD::MultiGet(File, "iiffi", "FactionRank", Char[20], "Injured", Char[21], "Health", Char[22], "Armour", Char[23], "VW", Char[24]);
        BUD::MultiGet(File, "iiiii", "Interior", Char[25], "Job", Char[26], "BankBalance", Char[27], "Weapon1", Char[28], "Weapon1Ammo", Char[29]);
        BUD::MultiGet(File, "iiiii", "Weapon2", Char[30], "Weapon2Ammo", Char[31], "Weapon3", Char[32], "Weapon3Ammo", Char[33], "Weapon4", Char[34]);
        BUD::MultiGet(File, "iiiii", "Weapon4Ammo", Char[35], "Weapon5", Char[36], "Weapon5Ammo", Char[37], "Weapon6", Char[38], "Weapon6Ammo", Char[39]);
        BUD::MultiGet(File, "iiiii", "Weapon7", Char[40], "Weapon7Ammo", Char[41], "Weapon8", Char[42], "Weapon8Ammo", Char[43], "Weapon9", Char[44]);
        BUD::MultiGet(File, "iiiii", "Weapon9Ammo", Char[45], "Weapon10", Char[46], "Weapon10Ammo", Char[47], "Weapon11", Char[48], "Weapon11Ammo", Char[49]);
        BUD::MultiGet(File, "iiiii", "Weapon12", Char[50], "Weapon12Ammo", Char[51], "Weapon13", Char[52], "Weapon13Ammo", Char[53], "PRadio", Char[54]);
        BUD::MultiGet(File, "iiiii", "PRadioFreq", Char[55], "Password", Char[56]);
        PlayerData[playerid][pAge] = Char[0];
        PlayerData[playerid][pVip] = Char[1];
        PlayerData[playerid][pAdmin] = Char[2];
        PlayerData[playerid][pMoney] = Char[3];
        PlayerData[playerid][pLevel] = Char[4];
        PlayerData[playerid][pGender] = Char[5];
        PlayerData[playerid][pAccent] = Char[6];
        PlayerData[playerid][pSkin] = Char[7];
        PlayerData[playerid][pCarLic] = Char[8];
        PlayerData[playerid][pBoatLic] = Char[9];
        PlayerData[playerid][pFlyLic] = Char[10];
        PlayerData[playerid][pPosX] = Char[11];
        PlayerData[playerid][pPosY] = Char[12];
        PlayerData[playerid][pPosZ] = Char[13];
        PlayerData[playerid][pPosAngle] = Char[14];
        PlayerData[playerid][pPayday] = Char[15];
        PlayerData[playerid][pHadPayDay] = Char[16];
        PlayerData[playerid][pFamily] = Char[17];
        PlayerData[playerid][pFaction] = Char[18];
        PlayerData[playerid][pTutorial] = Char[19];
        PlayerData[playerid][pFactionRank] = Char[20];
        PlayerData[playerid][pInjured] = Char[21];
        PlayerData[playerid][pHealth] = Char[22];
        PlayerData[playerid][pArmour] = Char[23];
        PlayerData[playerid][pVW] = Char[24];
        PlayerData[playerid][pInterior] = Char[25];
        PlayerData[playerid][pJob] = Char[26];
        PlayerData[playerid][pBankBalance] = Char[27];
           PlayerData[playerid][pWeapon][0] = Char[28];
        PlayerData[playerid][pWeaponAmmo][0] = Char[29];
        PlayerData[playerid][pWeapon][1] = Char[30];
        PlayerData[playerid][pWeaponAmmo][1] = Char[31];
        PlayerData[playerid][pWeapon][2] = Char[32];
        PlayerData[playerid][pWeaponAmmo][2] = Char[33];
        PlayerData[playerid][pWeapon][3] = Char[34];
        PlayerData[playerid][pWeaponAmmo][3] = Char[35];
        PlayerData[playerid][pWeapon][4] = Char[36];
        PlayerData[playerid][pWeaponAmmo][4] = Char[37];
        PlayerData[playerid][pWeapon][5] = Char[38];
        PlayerData[playerid][pWeaponAmmo][5] = Char[39];
        PlayerData[playerid][pWeapon][6] = Char[40];
        PlayerData[playerid][pWeaponAmmo][6] = Char[41];
        PlayerData[playerid][pWeapon][7] = Char[42];
        PlayerData[playerid][pWeaponAmmo][7] = Char[43];
        PlayerData[playerid][pWeapon][8] = Char[44];
        PlayerData[playerid][pWeaponAmmo][8] = Char[45];
        PlayerData[playerid][pWeapon][9] = Char[46];
        PlayerData[playerid][pWeaponAmmo][9] = Char[47];
        PlayerData[playerid][pWeapon][10] = Char[48];
        PlayerData[playerid][pWeaponAmmo][10] = Char[49];
        PlayerData[playerid][pWeapon][11] = Char[50];
        PlayerData[playerid][pWeaponAmmo][11] = Char[51];
        PlayerData[playerid][pWeapon][12] = Char[52];
        PlayerData[playerid][pWeaponAmmo][12] = Char[53];
        PlayerData[playerid][pPRadio] = Char[54];
        PlayerData[playerid][pPRadioFreq] = Char[55];
         PlayerData[playerid][pPassword] = Char[56];
      } 
The Part Of OnGamemodeInit
PHP код:
    BUD::Setting(opt.Database, "PGRP.db");
    BUD::Setting(opt.Asynchronous, true);
    BUD::Setting(opt.KeepAliveTime, 3000);
    BUD::Setting(opt.CheckForUpdates, false);
    BUD::Initialize();
    BUD::VerifyColumn("Password", BUD::TYPE_STRING);
    BUD::VerifyColumn("Admin", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Vip", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Age", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Money", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Level", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Gender", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Accent", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Skin", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("CarLic", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("BoatLic", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("FlyLic", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("PosX", BUD::TYPE_FLOAT);
    BUD::VerifyColumn("PosY", BUD::TYPE_FLOAT);
    BUD::VerifyColumn("PosZ", BUD::TYPE_FLOAT);
    BUD::VerifyColumn("PosAngle", BUD::TYPE_FLOAT);
    BUD::VerifyColumn("PayDay", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("HadPayDay", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Family", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Faction", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Tutorial", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("FactionRank", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Injured", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Health", BUD::TYPE_FLOAT);
    BUD::VerifyColumn("Armour", BUD::TYPE_FLOAT);
    BUD::VerifyColumn("VWorld", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Interior", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Job", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("BankBalance", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon1", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon1Ammo", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon2", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon2Ammo", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon3", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon3Ammo", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon4", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon4Ammo", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon5", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon5Ammo", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon6", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon6Ammo", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon7", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon7Ammo", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon8", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon8Ammo", BUD::TYPE_NUMBER);
     BUD::VerifyColumn("Weapon9", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon9Ammo", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon10", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon10Ammo", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon11", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon11Ammo", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon12", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("Weapon12Ammo", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("PRadio", BUD::TYPE_NUMBER);
    BUD::VerifyColumn("PRadioFreq", BUD::TYPE_NUMBER); 
i Don't know why there does not even load anything or save

Note: The System Creates And Puts A Name In The DB But Does Not Save Or Load + All Commands That Is Part Of The Admin System Is Not Working

HELP PLEASE Thanks in advance
Find
Reply
Ciandlah
Huge Clucker
***
Posts: 248
Threads: 23
Joined: Mar 2013
Reputation: 0
#2

20.04.2013, 08:50
Have you set your Databases up properly?
Find
Reply
Ryan_Obeles
Big Clucker
***
Posts: 175
Threads: 34
Joined: Jan 2012
Reputation: 0
#3

20.04.2013, 08:53
Yep its created and adding accounts but after register dialog nothing goes but it is suppose to go to the Age And Gender of the Player
Find
Reply
Ciandlah
Huge Clucker
***
Posts: 248
Threads: 23
Joined: Mar 2013
Reputation: 0
#4

20.04.2013, 09:12
Have you called a public with the saving process inside?
Find
Reply
Ryan_Obeles
Big Clucker
***
Posts: 175
Threads: 34
Joined: Jan 2012
Reputation: 0
#5

20.04.2013, 09:15
ofc that was in Kush's Yini tut i just converted it to sqlite

EDIT EDIT EDIT EDIT EDIT EDIT

btw i tried to create another 1 but this time on a blank gamemode with the same vars....
i kept on getting lots of these which gave my server ultra lag

Код:
[17:50:08] BUD - Error: The number of type definitions doesn't match the number of entries passed to BUD::MultiSet; typedefs: 5, entries: 2.
[17:50:08] BUD - Error: The number of type definitions doesn't match the number of entries passed to BUD::MultiSet; typedefs: 5, entries: 2.
[17:50:08] BUD - Error: The number of type definitions doesn't match the number of entries passed to BUD::MultiSet; typedefs: 5, entries: 2.
[17:50:08] BUD - Error: The number of type definitions doesn't match the number of entries passed to BUD::MultiSet; typedefs: 5, entries: 2.
[17:50:08] BUD - Error: The number of type definitions doesn't match the number of entries passed to BUD::MultiSet; typedefs: 5, entries: 2.
[17:50:08] BUD - Error: The number of type definitions doesn't match the number of entries passed to BUD::MultiSet; typedefs: 5, entries: 2.
[17:50:08] BUD - Error: The number of type definitions doesn't match the number of entries passed to BUD::MultiSet; typedefs: 5, entries: 2.
[17:50:09] BUD - Error: The number of type definitions doesn't match the number of entries passed to BUD::MultiSet; typedefs: 5, entries: 2.
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