This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
function Richie(player, amount)
{
local q = QuerySQL(db, "SELECT Name,Amount FROM Rich WHERE Name LIKE '"+player.Name+"'");
local cash = GetSQLColumnData( q, 1 ).tostring();
local add = cash + amount;
if (GetSQLColumnData(q,0) == null)
{
QuerySQL(db, "INSERT INTO Rich (Name, Amount) VALUES ('"+player.Name+"', '"+amount.tointeger()+"')");
}
if (GetSQLColumnData(q,0) == player.Name );
{
QuerySQL(db, "UPDATE Rich SET Amount='"+ add+ "' WHERE Name LIKE '" + player.Name + "'");
}
FreeSQLQuery( q );
}function LastActive(player)
{
local now = date();
local q = QuerySQL(db, "SELECT Name,LADate FROM LastActive WHERE Name='"+player.Name+"'");
if (GetSQLColumnData(q,0) == null)
{
QuerySQL(db, "INSERT INTO LastActive (Name, LADate) VALUES ('"+player.Name+"', '"+ now.day + "/" + now.month + "/" + now.year + " " + now.hour + ":" + now.min + ":" + now.sec +"')");
}
if (GetSQLColumnData(q,0) == player.Name)
{
QuerySQL(db, "UPDATE LastActive SET LADate='"+ now.day + "/" + now.month + "/" + now.year + " " + now.hour + ":" + now.min + ":" + now.sec + "' WHERE Name='" + player.Name + "'");
}
FreeSQLQuery( q );
}[/spoiler]
else if ( cmd == "disablefpv" )
{
SetWeaponDataValue(26, 12, 0x200 );
SetWeaponDataValue(27, 12, 0x200 );
SetWeaponDataValue(32, 12, 0x200 );
Message("Admin Disabled FPV!");
}
[/spoiler]
function Banned( player )
{
local query = QuerySQL( database, "SELECT * FROM Banned WHERE ban_nick='" + player.Name + "' COLLATE NOCASE" ), Ip = player.IP.tostring();
if( GetSQLColumnData( query, 0 ) )
{
if( ( time() - GetSQLColumnData( query, 2 ).tointeger() ) >= GetSQLColumnData( query, 3 ).tointeger() )
{
local query2 = QuerySQL( database, "DELETE FROM Banned WHERE ban_nick='" + player.Name.tostring() + "'" );
FreeSQLQuery( query2 );
MessagePlayer(GREEN+"[RBAN] Your ban has been expired.", player );
MessagePlayer(ORANGE+"[RBAN] Stick to the rules or you will get permanently banned.", player );
}
else
{
local Time_Left = TimeRem( GetSQLColumnData( query, 2 ).tointeger(), GetSQLColumnData( query, 4 ) );
//local splitban = split( GetSQLColumnData( query, 4 ), ":" ), Calc = splitban[ 0 ] + " Day(s), " + splitban[ 1 ] + " Hour(s), " + splitban[ 2 ] + " Minute(s).";
MessagePlayer(RED+"[RBAN] Your ban has not expired.", player );
MessagePlayer(ORANGE+"[RBAN] Your ban is set to expire in " + Time_Left, player );
Message(RED+" Enforcing prior ban on:["+player.Name+"] Reason:["+GetSQLColumnData( query, 6 )+"]Time left:["+Time_Left+"]")
EchoMessage(ICOL_RED+" Enforcing prior ban on:["+player.Name+"] Reason:["+GetSQLColumnData( query, 6 )+"]Time left:["+Time_Left+"]")
KickPlayer( player );
}
}
else if( GetSQLColumnData( QuerySQL( database, "SELECT * FROM Banned WHERE ban_ip='" + Ip + "'" ), 0 ) )
{
local query = QuerySQL( database, "SELECT * FROM Banned WHERE ban_ip='" + Ip + "'" );
if( ( time() - GetSQLColumnData( query, 2 ).tointeger() ) >= GetSQLColumnData( query, 3 ).tointeger() )
{
local query2 = QuerySQL( database, "DELETE FROM Banned WHERE ban_ip='" + player.IP.tostring() + "'" );
FreeSQLQuery( query2 );
MessagePlayer(RED+"[RBAN] Your ban has been expired.", player );
MessagePlayer(ORANGE+"[RBAN] Stick to the rules or you will get permanently banned.", player );
}
else
{
local Time_Left = TimeRem( GetSQLColumnData( query, 2 ).tointeger(), GetSQLColumnData( query, 4 ).tostring() );
//local splitban = split( GetSQLColumnData( query, 4 ), ":" ), Calc = splitban[ 0 ] + " Day(s), " + splitban[ 1 ] + " Hour(s), " + splitban[ 2 ] + " Minute(s).";
MessagePlayer("[RBAN] Your ban has not expired.", player );
MessagePlayer(ORANGE+"[RBAN] Your ban is set to expire in. " + Time_Left , player );
Message(RED+" Enforcing prior ban on:["+player.Name+"] Reason:["+GetSQLColumnData( query, 6 )+"]Time left:["+Time_Left+"]")
EchoMessage(ICOL_RED+" Enforcing prior ban on:["+player.Name+"] Reason:["+GetSQLColumnData( query, 6 )+"]Time left:["+Time_Left+"]")
KickPlayer( player );
}
}
FreeSQLQuery( query );
}
function TimeRem( bantime, banratio )
{
local ban_current = time()-bantime, sp = split(banratio,":"), ban_Days = 0, ban_Hours = 0, ban_Minutes = 0,
ban_Day = sp[ 0 ].tointeger(),
ban_Hour = sp[ 1 ].tointeger(),
ban_Minute = sp[ 2 ].tointeger();
bantime = ban_Day + ban_Hour + ban_Minute;
ban_Days = ban_current/86400;
ban_current = ban_current%86400;
ban_Hours = ban_current/3600;
ban_current = ban_current%3600;
ban_Minutes = ban_current/60;
ban_current = ban_current%60;
ban_Day -= ban_Days;
ban_Hour -= ban_Hours;
ban_Minute -= ban_Minutes;
return ban_Day + " Day(s), " + ban_Hour + " Hour(s), " + ban_Minute + " Minutes.";
}
function SaveStats( player )
{
try{
local id = player.ID;
if ( (status[ id ].IsReg == true) && (status[ id ].IsLogged == true) )
{
QuerySQL( db, "UPDATE Account SET Kills='" + status[ id ].Kills + "', Killeds='" + status[ id ].Killeds + "', Deaths='" + status[ player.ID ].Deaths + "', Cash='" + status[ id ].Cash + "', Bank='" + status[ id ].Bank + "', Joins='" + status[id].Joins + "' WHERE Name='" + player.Name.tolower() + "'" );
print( "Saved Stats of Player " + player.Name + "[" + player.ID + "]" );
status[ id ] = null;
}
}
catch(e) print( "Save Stats Error: " + e );
}
function onPlayerPart( player, reason )
{
local Text = "Unknown";
switch ( reason )
{
case PARTREASON_QUIT:
Text = "Quit";
break;
case PARTREASON_DISCONNECTED:
Text = "Leaving";
break;
case PARTREASON_TIMEOUT:
Text = "Timeout";
break;
case PARTREASON_KICKED:
Text = "Kicked";
break;
case PARTREASON_BANNED:
Text = "Banned";
break;
case PARTREASON_CRASHED:
Text = "Game-Crashed";
break;
}
EchoMessage(ICOL_RED+ICOL_BOLD+"** >> ID:[ "+player.ID+" ] "+player.Name+" Has Left The Server.("+Text+")");
Message(RED+"** >> ID:[ "+GetTeamToRGB(player.Team)+""+player.ID+""+RED+" ] "+GetTeamToRGB(player.Team)+""+player.Name+" "+ORANGE+"Has Left The Server."+ORANGE+"("+Text+")");
print("** ID:[ "+player.ID+" ] "+player.Name+" Has Left The Server.("+Text+")");
if ( status[ player.ID ].PHidden == true ) status[ player.ID ].PHidden = false;
if ( status[ player.ID ].chat == 1 ) status[ player.ID ].chat = 0;
{
EndKillingSpree(player,255);
SetPlayerSpree(player);
menuRageQuit( player );
SaveStats( player );
savespawnwep(player.Name,player.ID);
}
for (local i = g_FPS.len()-1; i >= 0; i--)
{if (g_FPS[i].Player.ID == player.ID)
{if (g_FPS[i].Text != null) g_FPS[i].Text.Delete();
g_FPS.remove(i);
break;}
}
for (local i = g_DIS.len()-1; i >= 0; i--)
{if (g_DIS[i].Player.ID == player.ID)
{if (g_DIS[i].Dist != null) g_DIS[i].Dist.Delete();
g_DIS.remove(i);
break;}
}
for (local i = g_ST.len()-1; i >= 0; i--)
{if (g_ST[i].Player.ID == player.ID)
{if (g_ST[i].ST != null) g_ST[i].ST.Delete();
g_ST.remove(i);
break;}
}
for (local i = g_DM.len()-1; i >= 0; i--)
{if (g_DM[i].Player.ID == player.ID)
{if (g_DM[i].DM != null) g_DM[i].DM.Delete();
g_DM.remove(i);
break;}
}
if ( GetPlayers()-1 == 0 )
{
speedometer.Paused = true;
timer_status = false;
}
if ( GetPlayers()-1 == 0 )
{
secretgate.Paused = true;
sec_status = false;
}
if ( GetPlayers()-1 == 0 )
{
armygate.Paused = true;
army_status = false;
}
if(player.World==1){
if(Max[player.ID]==true){
WorldCounter[1]-=1;
if(WorldCounter[1]==-1){WorldCounter[1]=0;}}
}
if(player.World==2){
if(Max[player.ID]==true){
WorldCounter[2]-=1;
if(WorldCounter[2]==-1){WorldCounter[2]=0;}}
}
if(SpawnKill[player.ID]==true){SpawnKill[ player.ID ]=false;}
}
[/spoiler]
