bstats and wstats

//============================ Wstats And Bstats Fucntions ==============================================//
function SetPlayerBodyPart( player, bodypart, amount )
{
        QuerySQL( db, format( "UPDATE Bstats SET %s=%i WHERE Name='" + player.Name + "'", BStats( bodypart ), amount ) );
}

function GetPlayerBodyPart( player, bodypart )
{
        local BP = GetSQLColumnData( QuerySQL( db, format( "SELECT %s FROM Bstats WHERE Name='" + player.Name + "'", BStats( bodypart ) ) ), 0 );
	if ( BP ) return BP;
        else return 0;
}

function IncPlayerBodyPart( player, bodypart, amount )
{
        QuerySQL( db, format( "UPDATE Bstats SET %s=%i WHERE Name='" + player.Name + "'", BStats( bodypart ), ( GetPlayerBodyPart( player, bodypart ) + amount ) ) );
}

function DecPlayerBodyPart( player, bodypart, amount )
{
        QuerySQL( db, format( "UPDATE Bstats SET %s=%i WHERE Name='" + player.Name + "'", BStats( bodypart ), ( GetPlayerBodyPart( player, bodypart ) - amount ) ) );
}

function GetPlayerBStats( player )
{
        local bps = null;
        for ( local b = 0; b <= 6; b++ )
        {
 		if ( GetPlayerBodyPart( player, b ) > 0  )
 		{
 			if ( bps ) bps = bps + " " + BStats( b ) + ": [ " + GetPlayerBodyPart( player, b ) + " ]";
 			else bps = "" + BStats( b ) + ": [ " + GetPlayerBodyPart( player, b ) + " ]";
 		}
        }
        if ( bps ) return bps;
        else return "Empty (Need Stats)";
}

//====================== Functions Of Wstats =============================//

function SetPlayerWep( player, wepid, amount )
{
        QuerySQL( db, format( "UPDATE Wstats SET %s=%i WHERE Name='" + player.Name + "'", WStats( wepid ), amount ) );
}

function GetPlayerWep( player, wepid )
{
        local WP = GetSQLColumnData( QuerySQL( db, format( "SELECT %s FROM Wstats WHERE Name='" + player.Name + "'", WStats( wepid ) ) ), 0 );
	if ( WP ) return WP;
        else return 0;
}

function IncPlayerWep( player, wepid, amount )
{
        QuerySQL( db, format( "UPDATE Wstats SET %s=%i WHERE Name='" + player.Name + "'", WStats( wepid ), ( GetPlayerWep( player, wepid ) + amount ) ) );
}

function DecPlayerWep( player, wepid, amount )
{
        QuerySQL( db, format( "UPDATE Wstats SET %s=%i WHERE Name='" + player.Name + "'", WStats( wepid ), ( GetPlayerWep( player, wepid ) - amount ) ) );
}

function GetPlayerWStats( player )
{
        local wps = null;
        for ( local w = 0; w <= 32; w++ )
        {
 		if ( GetPlayerWep( player, w ) > 0  )
 		{
 			if ( wps ) wps = wps + "  " + WStats( w ) + ": [ " + GetPlayerWep( player, w ) + " ] ";
 			else wps = " " + WStats( w ) + ": [ " + GetPlayerWep( player, w ) + " ] ";
 		}
        }
        if ( wps ) return wps;
        else return "Empty (Need Stats)";
}

function BStats( bodypart )
{
        local bp = "Not found";
	if ( bodypart.tointeger() == 0 ) bp = "Body";
	if ( bodypart.tointeger() == 1 ) bp = "Torso";
	if ( bodypart.tointeger() == 2 ) bp = "LeftArm";
	if ( bodypart.tointeger() == 3 ) bp = "RightArm";
	if ( bodypart.tointeger() == 4 ) bp = "LeftLeg";
	if ( bodypart.tointeger() == 5 ) bp = "RightLeg";
	if ( bodypart.tointeger() == 6 ) bp = "Head";
        return bp;
}

function WStats( wep )
{
        local id = "Not found";
	if ( wep.tointeger() == 0 ) id = "Fist";
	if ( wep.tointeger() == 1 ) id = "BrassKnuckle";
	if ( wep.tointeger() == 2 ) id = "ScrewDriver";
	if ( wep.tointeger() == 3 ) id = "GolfClub";
	if ( wep.tointeger() == 4 ) id = "NightStick";
	if ( wep.tointeger() == 5 ) id = "Knife";
	if ( wep.tointeger() == 6 ) id = "BaseballBat";
	if ( wep.tointeger() == 7 ) id = "Hammer";
	if ( wep.tointeger() == 8 ) id = "Cleaver";
	if ( wep.tointeger() == 9 ) id = "Machete";
	if ( wep.tointeger() == 10 ) id = "Katana";
	if ( wep.tointeger() == 11 ) id = "Chainsaw";
	if ( wep.tointeger() == 12 ) id = "Grenade";
	if ( wep.tointeger() == 13 ) id = "RemoteGrenade";
	if ( wep.tointeger() == 14 ) id = "TearGas";
	if ( wep.tointeger() == 15 ) id = "Molotov";
	if ( wep.tointeger() == 16 ) id = "Missile";
	if ( wep.tointeger() == 17 ) id = "Colt45";
	if ( wep.tointeger() == 18 ) id = "Python";
	if ( wep.tointeger() == 19 ) id = "Shotgun";
	if ( wep.tointeger() == 20 ) id = "Spaz";
	if ( wep.tointeger() == 21 ) id = "Stubby";
	if ( wep.tointeger() == 22 ) id = "Tec9";
	if ( wep.tointeger() == 23 ) id = "Uzi";
	if ( wep.tointeger() == 24 ) id = "Ingrams";
	if ( wep.tointeger() == 25 ) id = "MP5";
	if ( wep.tointeger() == 26 ) id = "M4";
	if ( wep.tointeger() == 27 ) id = "Ruger";
	if ( wep.tointeger() == 28 ) id = "SniperRifle";
	if ( wep.tointeger() == 29 ) id = "LaserScope";
	if ( wep.tointeger() == 30 ) id = "RocketLauncher";
	if ( wep.tointeger() == 31 ) id = "FlameThrower";
	if ( wep.tointeger() == 32 ) id = "M60";
        return id;
}
function GetBPName( bodypart )
{
        local bpd;
        if ( bodypart == 0 ) bpd = "Body";
        if ( bodypart == 1 ) bpd = "Torso";
        if ( bodypart == 2 ) bpd = "Left Arm";
        if ( bodypart == 3 ) bpd = "Right Arm";
        if ( bodypart == 4 ) bpd = "Left Leg";
        if ( bodypart == 5 ) bpd = "Right Leg";
        if ( bodypart == 6 ) bpd = "Head";
        return bpd;
}

//========================== End of Wstats And Bstats Functions =========================================//

// ========================= Wstats and Bstats commands =====================
else if ( cmd == "bstats" )
	{
		if ( !text ) SendMessage( "Your BodyStats: [ " + GetPlayerBStats( player ) + " ]", player );
		else if ( text )
		{
		local plr = GetPlayer( text );
		if ( !plr ) ErrorMessage( "[Error] - Unknown Player..", player );
        else SendMessage( plr.Name +"'s Body Stats: [ " + GetPlayerBStats( plr ) + " ]", player );
		}
    }
	else if ( cmd == "wstats" )
	{
	    if ( !text ) SendMessage( "Your Weapon Stats: [ " + GetPlayerWStats( player ) + " ]", player);
		else if ( text)
		{
	    local plr = GetPlayer( text );
		if ( !plr ) ErrorMessage( "[Error] - Unknown Player..", player );
        else SendMessage( plr.Name +"'s Wstats: [ " + GetPlayerWStats( plr ) + " ]", player);
		}

	}

// ======================== OnPlayerKill function =======================
if ( bodypart <= 7 ) IncPlayerBodyPart( killer, bodypart, 1 );

// ============= Tables ======================
QuerySQL( db, "CREATE TABLE IF NOT EXISTS Bstats ( Name TEXT, User TEXT, Body NUMERIC, Torso NUMERIC, LeftArm NUMERIC, RightArm NUMERIC, LeftLeg NUMERIC, RightLeg NUMERIC, Head NUMERIC )" );
    QuerySQL( db, "CREATE TABLE IF NOT EXISTS Wstats ( Name TEXT, User TEXT, Fist NUMERIC, BrassKnuckle NUMERIC, ScrewDriver NUMERIC, GolfClub NUMERIC, NightStick NUMERIC, Knife NUMERIC, BaseballBat NUMERIC, Hammer NUMERIC, Cleaver NUMERIC, Machete NUMERIC, Katana NUMERIC, Chainsaw NUMERIC, Grenade NUMERIC, RemoteGrenade NUMERIC, TearGas NUMERIC, Molotov NUMERIC, Missile NUMERIC, Colt45 NUMERIC, Python NUMERIC, Shotgun NUMERIC, Spaz NUMERIC, Stubby NUMERIC, Tec9 NUMERIC, Uzi NUMERIC, Ingrams NUMERIC, MP5 NUMERIC, M4 NUMERIC, Ruger NUMERIC, SniperRifle NUMERIC, LaserScope NUMERIC, RocketLauncher NUMERIC, FlameThrower NUMERIC, M60 NUMERIC )" );

// ================ Player Info functions ===========================
QuerySQL( db, "INSERT INTO Bstats ( Name, User, Body, Torso, LeftArm, RightArm, LeftLeg, RightLeg, Head ) VALUES ( '" + player.Name + "', '" + player.Name + "', 0, 0, 0, 0, 0, 0, 0 )" );
    QuerySQL( db, "INSERT INTO Wstats ( Name, User, Fist, BrassKnuckle, ScrewDriver, GolfClub, NightStick, Knife, BaseballBat, Hammer, Cleaver, Machete, Katana, Chainsaw, Grenade, RemoteGrenade, TearGas, Molotov, Missile, Colt45, Python, Shotgun, Spaz , Stubby, Tec9, Uzi, Ingrams, MP5, M4, Ruger, SniperRifle, LaserScope, RocketLauncher, FlameThrower, M60 ) VALUES ( '" + player.Name + "', '" + player.Name + "', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )" );