.db

Started by Humzasajjad, Sep 19, 2018, 08:01 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

Humzasajjad

.db
Sep 19, 2018, 08:01 PM
Can anyone give me admin.db..or where admins data will be saved....
Admin data saved in database.db?

Mahmoud Tornado

#1
Sep 19, 2018, 11:34 PM
Saved in database.db like levels.
Code Select
QuerySQL(db, "create table if not exists Database ( Name TEXT, LowerName TEXT, Password VARCHAR(255), Level NUMERIC DEFAULT 1, IP VARCHAR(255) ");

Or you can make another one with all things like an new account system.

class PlayerClass - Stats[player.ID].Level
Code Select
Level = 0;

onScriptLoad() - New database to make admin levels.
Code Select
Admindb <- ConnectSQL("AdminsDataBase.db");
 QuerySQL(Admindb, "create table if not exists Admins ( Name TEXT, LowerName TEXT, Level NUMERIC DEFAULT 0 ) ");
 Stats <- array(GetMaxPlayers(), null);

onPlayerJoin( player ) - Getting admin stats.
Code Select
IfAdmin(player);
Stats[ player.ID ] = PlayerClass();

If Admin Function.
Code Select
function IfAdmin(player)
{
 local q = QuerySQL(Admindb, "SELECT * FROM Admins WHERE Name = '" + escapeSQLString(player.Name) + "'");
 if (q)
 {
  Stats[ player.ID ].Level = GetSQLColumnData(q, 1);
 }
}

Setlevel Command.
Code Select
if ( cmd == "setlevel" )
{
if ( !text ) MessagePlayer( "/"+cmd+" <Nick/id> <Level>", player );
   else
   {
      local
         plr = GetPlayer( GetTok( text, " ", 1 ) ),
         lvl = GetTok( text, " ", 2),
      if ( !plr ) MessagePlayer( "Unknown Player..", player );
     else if ( !lvl ) MessagePlayer("You must put a level.", player);
      else if ( !IsNum( lvl ) ) MessagePlayer("Level must be in numbers.", player);
      else
      {
  local q = QuerySQL(Admindb, "SELECT * FROM Admins WHERE Name = '" + escapeSQLString(plr.Name) + "'");
if (!q)   QuerySQL( DataBase, "INSERT INTO Accounts ( Name, LowerName, Level ) VALUES ( '" + escapeSQLString(plr.Name) + "','" + escapeSQLString(plr.Name) + "','" + 0 + "')" );
else
{
         Stats[ plr.ID ].Level = lvl.tointeger();
QuerySQL( Admindb, "UPDATE Admins SET Level='"+lvl+"' WHERE Name LIKE '" + plr.Name + "'" );
         Message("Administration Command: Admin "+player.Name+" Has Set "+plr.Name+" As an admin level: "+lvl+".");
      }
    }
   }
}

doxuanhien2002

#2
Sep 20, 2018, 04:41 AM
Quote from: Humzasajjad on Sep 19, 2018, 08:01 PMCan anyone give me admin.db..or where admins data will be saved....
Admin data saved in database.db?
https://forum.vc-mp.org/?topic=3364.0
Code Select
Flooding the board with separate requests for many disparate items is not allowed.
If you need a whole set of things for your server, you should list them all in one thread rather than spamming this board with fifteen threads about each of the things you want your server to do.

Humzasajjad

#3
Sep 20, 2018, 11:49 AM
 QuerySQL(db, "create table if not exists Database ( Name TEXT, LowerName TEXT, Password VARCHAR(255), Level NUMERIC DEFAULT 1, IP VARCHAR(255) ");
if ( cmd == "setlevel" )
{
if ( !text ) MessagePlayer( "/"+cmd+" <Nick/id> <Level>", player );
   else
   {
      local
         plr = GetPlayer( GetTok( text, " ", 1 ) ),
         lvl = GetTok( text, " ", 2),
      if ( !plr ) MessagePlayer( "Unknown Player..", player );
     else if ( !lvl ) MessagePlayer("You must put a level.", player);
      else if ( !IsNum( lvl ) ) MessagePlayer("Level must be in numbers.", player);
      else
      {
   local q = QuerySQL(Admindb, "SELECT * FROM Admins WHERE Name = '" + escapeSQLString(plr.Name) + "'");
  if (!q)   QuerySQL( DataBase, "INSERT INTO Accounts ( Name, LowerName, Level ) VALUES ( '" + escapeSQLString(plr.Name) + "','" + escapeSQLString(plr.Name) + "','" + 0 + "')" );
  else
 {
         Stats[ plr.ID ].Level = lvl.tointeger();
  QuerySQL( Admindb, "UPDATE Admins SET Level='"+lvl+"' WHERE Name LIKE '" + plr.Name + "'" );
         Message("Administration Command: Admin "+player.Name+" Has Set "+plr.Name+" As an admin level: "+lvl+".");
      }
    }
   }
}
bro when i add this there was on script load error comes

Mahmoud Tornado

#4
Sep 20, 2018, 01:03 PM
Quote from: Humzasajjad on Sep 20, 2018, 11:49 AMQuerySQL(db, "create table if not exists Database ( Name TEXT, LowerName TEXT, Password VARCHAR(255), Level NUMERIC DEFAULT 1, IP VARCHAR(255) ");
if ( cmd == "setlevel" )
{
if ( !text ) MessagePlayer( "/"+cmd+" <Nick/id> <Level>", player );
   else
   {
      local
         plr = GetPlayer( GetTok( text, " ", 1 ) ),
         lvl = GetTok( text, " ", 2),
      if ( !plr ) MessagePlayer( "Unknown Player..", player );
     else if ( !lvl ) MessagePlayer("You must put a level.", player);
      else if ( !IsNum( lvl ) ) MessagePlayer("Level must be in numbers.", player);
      else
      {
   local q = QuerySQL(Admindb, "SELECT * FROM Admins WHERE Name = '" + escapeSQLString(plr.Name) + "'");
  if (!q)   QuerySQL( DataBase, "INSERT INTO Accounts ( Name, LowerName, Level ) VALUES ( '" + escapeSQLString(plr.Name) + "','" + escapeSQLString(plr.Name) + "','" + 0 + "')" );
  else
 {
         Stats[ plr.ID ].Level = lvl.tointeger();
  QuerySQL( Admindb, "UPDATE Admins SET Level='"+lvl+"' WHERE Name LIKE '" + plr.Name + "'" );
         Message("Administration Command: Admin "+player.Name+" Has Set "+plr.Name+" As an admin level: "+lvl+".");
      }
    }
   }
}
bro when i add this there was on script load error comes
This /setlevel command, for the second system not the first.
For the first will being like that,
Code Select
else if ( cmd == "setlevel" )
{
   if ( !text ) MessagePlayer( "/"+cmd+" <Nick/id> <Level>", player );
   else
   {
      local
         plr = GetPlayer( GetTok( text, " ", 1 ) ),
         lvl = GetTok( text, " ", 2);
      if ( !plr ) MessagePlayer( "Unknown Player..", player );
     else if ( !lvl ) MessagePlayer("You must put a level.", player);
      else if ( !IsNum( lvl ) ) MessagePlayer("Level must be in numbers.", player);
      else
      {
         Stats[ plr.ID ].Level = lvl.tointeger();
         QuerySQL( db,"UPDATE Database SET Level='"+lvl+"' WHERE lower(Name) LIKE '"+plr.Name+"'");
         Message("Administration Command: Admin "+player.Name+" Has Set level of "+plr.Name+" to: "+lvl+".");
      }
   }
}

Humzasajjad

#5
Sep 20, 2018, 07:21 PM
Quote from: Mahmoud Tornado on Sep 20, 2018, 01:03 PM
Quote from: Humzasajjad on Sep 20, 2018, 11:49 AMQuerySQL(db, "create table if not exists Database ( Name TEXT, LowerName TEXT, Password VARCHAR(255), Level NUMERIC DEFAULT 1, IP VARCHAR(255) ");
if ( cmd == "setlevel" )
{
if ( !text ) MessagePlayer( "/"+cmd+" <Nick/id> <Level>", player );
   else
   {
      local
         plr = GetPlayer( GetTok( text, " ", 1 ) ),
         lvl = GetTok( text, " ", 2),
      if ( !plr ) MessagePlayer( "Unknown Player..", player );
     else if ( !lvl ) MessagePlayer("You must put a level.", player);
      else if ( !IsNum( lvl ) ) MessagePlayer("Level must be in numbers.", player);
      else
      {
   local q = QuerySQL(Admindb, "SELECT * FROM Admins WHERE Name = '" + escapeSQLString(plr.Name) + "'");
  if (!q)   QuerySQL( DataBase, "INSERT INTO Accounts ( Name, LowerName, Level ) VALUES ( '" + escapeSQLString(plr.Name) + "','" + escapeSQLString(plr.Name) + "','" + 0 + "')" );
  else
 {
         Stats[ plr.ID ].Level = lvl.tointeger();
  QuerySQL( Admindb, "UPDATE Admins SET Level='"+lvl+"' WHERE Name LIKE '" + plr.Name + "'" );
         Message("Administration Command: Admin "+player.Name+" Has Set "+plr.Name+" As an admin level: "+lvl+".");
      }
    }
   }
}
bro when i add this there was on script load error comes
This /setlevel command, for the second system not the first.
For the first will being like that,
Code Select
else if ( cmd == "setlevel" )
{
   if ( !text ) MessagePlayer( "/"+cmd+" <Nick/id> <Level>", player );
   else
   {
      local
         plr = GetPlayer( GetTok( text, " ", 1 ) ),
         lvl = GetTok( text, " ", 2);
      if ( !plr ) MessagePlayer( "Unknown Player..", player );
     else if ( !lvl ) MessagePlayer("You must put a level.", player);
      else if ( !IsNum( lvl ) ) MessagePlayer("Level must be in numbers.", player);
      else
      {
         Stats[ plr.ID ].Level = lvl.tointeger();
         QuerySQL( db,"UPDATE Database SET Level='"+lvl+"' WHERE lower(Name) LIKE '"+plr.Name+"'");
         Message("Administration Command: Admin "+player.Name+" Has Set level of "+plr.Name+" to: "+lvl+".");
      }
   }
}
it works but when i type /setlevel <myname> <lvl>there was no message and change...what to do?

=RK=MarineForce

#6
Sep 20, 2018, 10:02 PM
i made this only :( :'( ...

Mahmoud Teach me on discord :P

Code Select
class PlayerStats
{
Level = 1;
}

function onScriptLoad()
{
QuerySQL(level, "create table if not exists Level ( Name Text, Password VARCHAR(255), Level NUMERIC, IP VARCHAR(255) ");
Ldb <- ConnectSQL("LevelDatabase.db");
}

Function OnScriptUnload()
{
DisconnectSQL("level" )
}

function onPlayerJoin( player )
{
Stats[ player.ID ] = PlayerStats();
}


else if ( cmd == "setlevel" )
{
if(!text) MessagePlayer(" /" + cmd + " <Nick> <Level> ",player);
else{
local plr = FindPlayer(text);
if(!plr) MessagePlayer(" [#ff0000] Error " + text + " is not online ",player);
else{
Stats[ plr.ID ].Level = text.tointeger();
}
}
}

Mahmoud Tornado

#7
Sep 22, 2018, 12:53 AM
@Humzasajjad, If you use the first on in your account system use this one.
Code Select
else if ( cmd == "setlevel" )
{
   if ( !text ) MessagePlayer( "/"+cmd+" <Nick/id> <Level>", player );
   else
   {
      local
         plr = GetPlayer( GetTok( text, " ", 1 ) ),
         lvl = GetTok( text, " ", 2);
      if ( !plr ) MessagePlayer( "Unknown Player..", player );
     else if ( !lvl ) MessagePlayer("You must put a level.", player);
      else if ( !IsNum( lvl ) ) MessagePlayer("Level must be in numbers.", player);
      else
      {
         Stats[ plr.ID ].Level = lvl.tointeger();
         QuerySQL( db,"UPDATE Database SET Level='"+lvl+"' WHERE lower(Name) LIKE '"+plr.Name+"'");
         Message("Administration Command: Admin "+player.Name+" Has Set level of "+plr.Name+" to: "+lvl+".");
      }
   }
}

If you using the second one use this,
Code Select
if ( cmd == "setlevel" )
{
if ( !text ) MessagePlayer( "/"+cmd+" <Nick/id> <Level>", player );
   else
   {
      local
         plr = GetPlayer( GetTok( text, " ", 1 ) ),
         lvl = GetTok( text, " ", 2),
      if ( !plr ) MessagePlayer( "Unknown Player..", player );
     else if ( !lvl ) MessagePlayer("You must put a level.", player);
      else if ( !IsNum( lvl ) ) MessagePlayer("Level must be in numbers.", player);
      else
      {
   local q = QuerySQL(Admindb, "SELECT * FROM Admins WHERE Name = '" + escapeSQLString(plr.Name) + "'");
  if (!q)   QuerySQL( DataBase, "INSERT INTO Accounts ( Name, LowerName, Level ) VALUES ( '" + escapeSQLString(plr.Name) + "','" + escapeSQLString(plr.Name) + "','" + 0 + "')" );
  else
 {
         Stats[ plr.ID ].Level = lvl.tointeger();
  QuerySQL( Admindb, "UPDATE Admins SET Level='"+lvl+"' WHERE Name LIKE '" + plr.Name + "'" );
         Message("Administration Command: Admin "+player.Name+" Has Set "+plr.Name+" As an admin level: "+lvl+".");
      }
    }
   }
}

It's not doing thing, as you are using the two systems together, and you can't make two level stats for the player.

Quote from: Humzasajjad on Sep 20, 2018, 11:49 AMQuerySQL(db, "create table if not exists Database ( Name TEXT, LowerName TEXT, Password VARCHAR(255), Level NUMERIC DEFAULT 1, IP VARCHAR(255) ");
This is the first system, this is a addition to accounts system.

But the command which you used is for the admins db.
Quote from: Humzasajjad on Sep 20, 2018, 11:49 AMif ( cmd == "setlevel" )
{
if ( !text ) MessagePlayer( "/"+cmd+" <Nick/id> <Level>", player );
   else
   {
      local
         plr = GetPlayer( GetTok( text, " ", 1 ) ),
         lvl = GetTok( text, " ", 2),
      if ( !plr ) MessagePlayer( "Unknown Player..", player );
     else if ( !lvl ) MessagePlayer("You must put a level.", player);
      else if ( !IsNum( lvl ) ) MessagePlayer("Level must be in numbers.", player);
      else
      {
   local q = QuerySQL(Admindb, "SELECT * FROM Admins WHERE Name = '" + escapeSQLString(plr.Name) + "'");
  if (!q)   QuerySQL( DataBase, "INSERT INTO Accounts ( Name, LowerName, Level ) VALUES ( '" + escapeSQLString(plr.Name) + "','" + escapeSQLString(plr.Name) + "','" + 0 + "')" );
  else
 {
         Stats[ plr.ID ].Level = lvl.tointeger();
  QuerySQL( Admindb, "UPDATE Admins SET Level='"+lvl+"' WHERE Name LIKE '" + plr.Name + "'" );
         Message("Administration Command: Admin "+player.Name+" Has Set "+plr.Name+" As an admin level: "+lvl+".");
      }
    }
   }
}
So it must get error.

=RK=MarineForce

#8
May 18, 2019, 02:23 AM Last Edit: May 18, 2019, 02:25 AM by =RK=MarineForce
Code Select
class PlayerStats
{
Level = 0;
Cash = 1;
Kills = 1;
Deaths = 1;
}

function OnScriptLoad()
{
Yesdb <- ConnectSQL("YesDatabase.db");
QuerySQL(Yesdb, "CREATE TABLE IF NOT EXISTS Admins ( Name TEXT, LowerName TEXT, Level NUMERIC DEFAULT 0 ) ");
QuerySQL(Yesdb, "CREATE TABLE IF NOT EXISTS Kills ( Name TEXT, LowerName TEXT, Kills NUMERIC DEFAULT 1 ) ");
QuerySQL(Yesdb, "CREATE TABLE IF NOT EXISTS Deaths ( Name TEXT, LowerName TEXT,Deaths NUMERIC DEFAULT 1 ) ");
QuerySQL(Yesdb, "CREATETABLE IF NOT EXISTS Cash ( Name TEXT, LowerName TEXT, Cash NUMERIC DEFAULT 1 ) ");
Stats <- array(GetMaxPlayers(), null);
}
function onPlayerJoin( player )
{
Stats[ player.ID ] = PlayerStats();
}
i made some thing like this but i don't know how can i save kills deaths etc. help..

KrOoB_

#10
May 18, 2019, 03:59 AM Last Edit: May 18, 2019, 04:01 AM by KrooB
Quote from: =RK=MarineForce on May 18, 2019, 02:23 AM
Code Select
class PlayerStats
{
Level = 0;
Cash = 1;
Kills = 1;
Deaths = 1;
}

function OnScriptLoad()
{
Yesdb <- ConnectSQL("YesDatabase.db");
QuerySQL(Yesdb, "CREATE TABLE IF NOT EXISTS Admins ( Name TEXT, LowerName TEXT, Level NUMERIC DEFAULT 0 ) ");
QuerySQL(Yesdb, "CREATE TABLE IF NOT EXISTS Kills ( Name TEXT, LowerName TEXT, Kills NUMERIC DEFAULT 1 ) ");
QuerySQL(Yesdb, "CREATE TABLE IF NOT EXISTS Deaths ( Name TEXT, LowerName TEXT,Deaths NUMERIC DEFAULT 1 ) ");
QuerySQL(Yesdb, "CREATETABLE IF NOT EXISTS Cash ( Name TEXT, LowerName TEXT, Cash NUMERIC DEFAULT 1 ) ");
Stats <- array(GetMaxPlayers(), null);
}
function onPlayerJoin( player )
{
Stats[ player.ID ] = PlayerStats();
}
i made some thing like this but i don't know how can i save kills deaths etc. help..


why did u split them ?

Code Select

class PlayerSystem
{
 Level = 0; // For Admin system
 Kills = 0;
 Deaths = 0;
 Cash = 0;
 Bank = 0;
...
...
...
}
QuerySQL(System, "create table if not exists Accounts ( Name TEXT, LowerName TEXT,  Level NUMERIC DEFAULT 1, Kills NUMERIC DEFAULT 0, Deaths NUMERIC DEFAULT 0, Cash NUMERIC DEFAULT 0, Bank NUMERIC DEFAULT 0 ) ");

...

=RK=MarineForce

#11
May 18, 2019, 04:08 AM
Thanks Bro:

but how can i add kill system when players kill a player a die.

KrOoB_

#12
May 18, 2019, 04:12 AM Last Edit: May 18, 2019, 04:17 AM by KrooB
if u're using 7. Muhammed's Account System


and for onPlayerKill
Code Select
stats[ killer.ID ].Kills ++;
stats[ player.ID ].Deaths ++;

KrOoB_

#13
May 18, 2019, 04:15 AM
@Mohamed already add this in his script so u don't have to do this just download it and try to understand
Print
Go Up Pages1
User actions