In Game addclass via cmd with Database
Credits: EnForcer
Commands: /addclass <Team ID> <R> <G> <B> <Skin ID>
Extra Note: If you encounter any bug, inform me here or on discord my ID : iNForSir#7490
Paste it in onscriptload
db <- ConnectSQL( "Classes.db" );
QuerySQL(db, "CREATE TABLE IF NOT EXISTS Creation ( Team NUMERIC, Skin NUMERIC, X NUMERIC, Y NUMERIC, Z NUMERIC, R NUMERIC, G NUMERIC, B NUMERIC, Angle NUMERIC)" );
LoadClass();
Function to Loadclass
function LoadClass()
{
local q = QuerySQL( db, "SELECT * FROM Creation" ), i = 0;
while( GetSQLColumnData( q, 0 ) )
{
local
Team= GetSQLColumnData( q, 0 ),
Skin= GetSQLColumnData( q, 1 ),
X= GetSQLColumnData( q, 2 ),
Y= GetSQLColumnData( q, 3 ),
Z= GetSQLColumnData( q, 4 ),
R= GetSQLColumnData( q, 5 ),
G= GetSQLColumnData( q, 6 ),
B= GetSQLColumnData( q, 7 ),
Angle= GetSQLColumnData( q, 8 );
AddClass( Team, RGB( R,G,B ), Skin, Vector( X,Y,Z ), Angle, 21, 999 ,1, 1, 25, 255 );
GetSQLNextRow( q );
i++;
}
print("Class Count ("+i+")");
return 0;
}
Paste it in onplayercommand
else if (cmd=="addclass")
{
if ( !player.IsSpawned ) MessagePlayer( "[#ff0000][Error] - [#ffffff]You need be spawned to use this command.", player );
else if( !text ) MessagePlayer( "[#ff0000][Error] - [#ffffff]Use /"+cmd+" <Team ID> <R> <G> <B> <Skin ID>.", player);
else {
local TeamID = GetTok( text, " ", 1 );
local R = GetTok( text, " ", 2 );
local G = GetTok( text, " ", 3 );
local B = GetTok( text, " ", 4 );
local SkinID = GetTok( text, " ", 5 );
if (!IsNum(TeamID)) MessagePlayer( "[#ff0000][Error] - [#ffffff]Use /"+cmd+" <Team ID> <R> <G> <B> <Skin ID>.", player);
else if ( !IsNum(R)) MessagePlayer( "[#ff0000][Error] - [#ffffff]Use /"+cmd+" <Team ID> <R> <G> <B> <Skin ID>.", player);
else if ( !IsNum(G)) MessagePlayer( "[#ff0000][Error] - [#ffffff]Use /"+cmd+" <Team ID> <R> <G> <B> <Skin ID>.", player);
else if ( !IsNum(B)) MessagePlayer( "[#ff0000][Error] - [#ffffff]Use /"+cmd+" <Team ID> <R> <G> <B> <Skin ID>.", player);
else if ( !IsNum(SkinID)) MessagePlayer( "[#ff0000][Error] - [#ffffff]Use /"+cmd+" <Team ID> <R> <G> <B> <Skin ID>.", player);
else if ( ( !TeamID ) || ( !R ) || (!G ) || ( !B ) || ( !SkinID ) ) MessagePlayer( "[#ff0000][Error] - [#ffffff]Use /"+cmd+" <Veh/ID> <Col1/ID> <Col2/ID> <World> <Price>.", player);
else {
QuerySQL( db, "INSERT INTO Creation ( Team, Skin, R, G, B, X, Y, Z, Angle ) VALUES ( '"+TeamID+"', '"+SkinID+"', '"+R+"', '"+G+"', '"+B+"', '"+player.Pos.x+"', '"+player.Pos.y+"', '"+player.Pos.z+"', '"+player.Angle+"' )" );
AddClass( TeamID.tointeger(), RGB( R.tointeger(), G.tointeger(), B.tointeger() ) ,SkinID.tointeger(), player.Pos, player.Angle, 22, 999 ,17, 100, 21, 245 );
Message( "[#FFFFFF]Admin [#FF0000]"+player.Name+" [#FFFFFF]Has added a new Class." );
}
}
return 0;
}
else if ( cmd == "removeclass" )
{
if ( !text ) MessagePlayer( "[#ff0000][Error] - [#ffffff]Use /"+cmd+" <Skin ID>.", player);
else if (!IsNum(text)) MessagePlayer( "[#ff0000][Error] - [#ffffff]Skin ID must be in numbers.", player);
else {
local q = QuerySQL( db, "SELECT * FROM Creation WHERE Skin='"+text+"'" );
if ( !q ) MessagePlayer( "[#ff0000][Error] - [#ffffff]Skin ID "+text+" not found in class.", player );
else {
QuerySQL( db, "DELETE FROM Creation WHERE Skin='"+text+"'" );
Message( "[#FFFFFF]Admin [#FF0000]"+player.Name+" [#FFFFFF]Has removed Class." );
}
}
return 0;
}