[FilterScript] [+Website]Professional Server Controller v1[MySQL Needed] - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+--- Thread: [FilterScript] [+Website]Professional Server Controller v1[MySQL Needed] (/showthread.php?tid=326673)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+--- Thread: [FilterScript] [+Website]Professional Server Controller v1[MySQL Needed] (/showthread.php?tid=326673)
Pages:
1
2
[+Website]Professional Server Controller v1[MySQL Needed] - Shabi RoxX - 18.03.2012
Hi, this is simple FS+website codded by me(Shabi RoxX).. Both FS and Website are connected to same database and there are two table in database , one for saving online player and other for action... This means you can see online player in our server any where from website and can also do any action like sending player a PM, slap player and much more listed below....
This means you can control your from mobile now :
Features:
Код:
╝List of online players with name , score , ip and action to do ╝Send Private message to any player whose online ╝Slap Player ╝Kick player with reason ╝Ban player with reason ╝SendMessageToAll
Код:
╝Restart Server ╝ShutDown Server ╝Change Host Name ╝Change GameMode Text ╝Change MapName ╝Change Website ╝Change Weather ╝Change gravity ╝Ban Ip ╝UnBan Ip
Its a simple Script with two timer using y_timers(******) , one for updating online players in database and other for getting action sended by website....
Bug:
No known bug, I also added LOADFS,RELOADFS,UNLOADFS but some how it cause server to shut down so I commented it.
Credits:
pawn Код:
/*===================================================
#
# Professional Server Controler V 1.0
# By Shabi RoxX
#
# Credits:
# ****** For sscanf plugin 2.5
# ****** For YSI
# BlueG For MySQL Plugin R6-2
#
#
# Copyright © 2012 sa-mp.com
#
#====================================================
Open /scriptfiles and open mysql.cfg and change as:
Код:
[Configrations] Host = 127.0.0.1 User = root Password = None Database = samp
Note:Use password = none if you are not using any password :
Codes:
pawn Код:
/*=============================================================================
# #
# Professional Server Controler V 1.0 #
# By Shabi RoxX #
# #
# Credits: #
# ****** For sscanf plugin 2.5 #
# ****** For YSI #
# BlueG For MySQL Plugin R6-2 #
# #
# #
# Copyright © 2012 sa-mp.com #
# #
#==============================================================================
*/
//=============================================================================
//# IncludeS #
//=============================================================================
#include <a_samp>
#include <sscanf2>
#include <YSI\y_ini>
#include <YSI\y_timers>
#include <a_mysql>
//=============================================================================
//# DefineS #
//=============================================================================
//============================================
// Colors #
//============================================
#define C_SKYBLUE 0x0BE3F4FF
#define C_YELLOW 0xFCF85FFF
#define C_LIME 0x00FF13FF
#define C_GREEN 0x5CA35FFF
#define C_ORANGE 0xFF8000FF
#define C_WHITE 0xFFFFFFFF
#define C_OFFWHITE 0xFFFCC6FF
#define C_RED 0xC40000FF
#define C_PINK 0xFF80C0FF
#define C_GREY 0x8F8F8FFF
#define C_GRAD 0xCFCFCFFF
//============================================
// Other #
//============================================
#define MAX_HOST_NAME 20
#define MAX_PASSWORD 16
#define MAX_USER_NAME 20
#define MAX_DB 10
//=============================================================================
//# New'S #
//=============================================================================
//============================================
// EnumS #
//============================================
enum mysql_info
{
Host[MAX_HOST_NAME],
User[MAX_USER_NAME],
Password[MAX_PASSWORD],
Database[MAX_DB]
}
new MySQL[mysql_info];
enum task_info
{
ID,
Action,
Target,
Comment[128]
}
new Task[task_info];
//=============================================================================
//# OnFilterScriptInit() #
//=============================================================================
public OnFilterScriptInit()
{
print("\n=============================================");
print("\n# #");
print("\n# Professional Server Controller v1.0 #");
print("\n# #");
print("\n# By Shabi RoxX #");
print("\n# #");
print("==============================================\n");
//============================================
// Loading Files #
//============================================
INI_Load("mysql.INI");
//============================================
// MySQL Part #
//============================================
new mysql_connected;
mysql_debug(1);
if(strcmp(MySQL[Password],"none",true) == 0) format(MySQL[Password],MAX_PASSWORD,"");//checking if pass is none set it to empty
mysql_connected = mysql_connect(MySQL[Host], MySQL[User], MySQL[Database],MySQL[Password]);//connetion to mysql databse
if(mysql_connected) printf("[MySQL] DataBase Connection Succeed.\n");
mysql_query("CREATE TABLE IF NOT EXISTS prosc(ID INT(2), ACTION INT(3), TARGET INT(4), COMMENT VARCHAR(128))");
mysql_query("CREATE TABLE IF NOT EXISTS playersconnected(ID INT(4), NAME VARCHAR(24), SCORE INT(6), IP VARCHAR(16))");
return 1;
}
//=============================================================================
//# OnFilterScriptExit() #
//=============================================================================
public OnFilterScriptExit()
{
new String[64];
for(new p = 0;p < MAX_PLAYERS;p++)
{
format(String, sizeof(String), "DELETE FROM `playersconnected` WHERE `ID` = '%d'",p);
mysql_query(String);
}
return 1;
}
INI:mysql[Configrations](name[], value[])
{
INI_String("Host", MySQL[Host],MAX_HOST_NAME);
INI_String("User", MySQL[User],MAX_USER_NAME);
INI_String("Password",MySQL[Password],MAX_PASSWORD);
INI_String("Database", MySQL[Database],MAX_DB);
return 1;
}
//=============================================================================
//# Timers/Tasks #
//=============================================================================
task PlayerUpdater[10000]()//checking every 10 seconds for player update :)
{
new pname[MAX_PLAYER_NAME],String[128],ip[16];
for(new p = 0;p < MAX_PLAYERS;p++)
{
format(String, sizeof(String), "DELETE FROM `playersconnected` WHERE `ID` = '%d'",p);
mysql_query(String);
if(IsPlayerConnected(p))
{
GetPlayerName(p,pname,MAX_PLAYER_NAME);
GetPlayerIp(p,ip,sizeof(ip));
format(String, sizeof(String), "INSERT INTO `samp`.`playersconnected` (`ID` ,`NAME` ,`SCORE` ,`IP`)VALUES ('%d', '%s', '%d', '%s')",p,pname,GetPlayerScore(p),ip);
mysql_query(String);
}
}
}
//By shabi RoxX
task ActionUpdater[2000]()//checking every 5 seconds for any action :)
{
new String[128],pname[MAX_PLAYER_NAME],qrun;
format(String, sizeof(String), "SELECT * FROM `prosc` WHERE `ID` = 1");
qrun = mysql_query(String);
mysql_store_result();
if(!mysql_num_rows(qrun))
{
mysql_query("INSERT INTO `prosc`(`ID`, `ACTION`, `TARGET`, `COMMENT`) VALUES ('1','0','0','none')");
}
while(mysql_fetch_row_format(String,"|"))
{
sscanf(String, "p<|>e<ddds[128]>",Task);
}
mysql_free_result();
GetPlayerName(Task[Target],pname,MAX_PLAYER_NAME);
switch(Task[Action])
{
case 1://SendClientMsgToAll
{
format(String,sizeof(String),"[PSC]{FFFFFF} Admin: %s.",Task[Comment]);
SendClientMessageToAll(C_LIME,String);
}
case 2://SendClientMsg
{
format(String,sizeof(String),"[PSC]{FCF85F} Admin PM: %s .",Task[Comment]);
SendClientMessage(Task[Target],C_LIME,String);
}
case 3://Slap Player
{
if(IsPlayerConnected(Task[Target]))
{
new Float:Pos[3];
GetPlayerPos(Task[Target],Pos[0],Pos[1],Pos[2]);
SetPlayerPos(Task[Target],Pos[0],Pos[1],Pos[2]+5);
}
}
case 4://Kick Player
{
if(IsPlayerConnected(Task[Target]))
{
format(String,sizeof(String),"AdminCMD: %s have been kicked from server by PSC, Reason: %s.",pname,Task[Comment]);
SendClientMessageToAll(C_RED,String);
Kick(Task[Target]);
}
}
case 5://ban Player
{
if(IsPlayerConnected(Task[Target]))
{
format(String,sizeof(String),"AdminCMD: %s have been banned from server by PSC, Reason: %s.",pname,Task[Comment]);
SendClientMessageToAll(C_RED,String);
BanEx(Task[Target],Task[Comment]);
}
}
case 6://restart server
{
format(String,sizeof(String),"[PSC]{FFFFFF} Server Restarting.");
SendClientMessageToAll(C_LIME,String);
SendRconCommand("gmx");
}
case 7://shut down server
{
format(String,sizeof(String),"[PSC]{FFFFFF} Server Shutting down.");
SendClientMessageToAll(C_LIME,String);
SendRconCommand("exit");
}
case 8://change host name
{
format(String,sizeof(String),"hostname %s",Task[Comment]);
SendRconCommand(String);
}
case 9://change gamemodetext
{
format(String,sizeof(String),"gamemodetext %s",Task[Comment]);
SendRconCommand(String);
}
case 10://change map name
{
format(String,sizeof(String),"mapname %s",Task[Comment]);
SendRconCommand(String);
}
case 11://change WebSite
{
format(String,sizeof(String),"weburl %s",Task[Comment]);
SendRconCommand(String);
}
//Cause Server restart some how :(
/*case 12://reloadfs
{
format(String,sizeof(String),"reloadfs %s",Task[Comment]);
SendRconCommand(String);
}
case 13://loadfs
{
format(String,sizeof(String),"loadfs %s",Task[Comment]);
SendRconCommand(String);
}
case 14://loadfs
{
format(String,sizeof(String),"unloadfs %s",Task[Comment]);
SendRconCommand(String);
}
*/
case 15://weather
{
format(String,sizeof(String),"weather %s",Task[Comment]);
SendRconCommand(String);
}
case 16://gravity
{
format(String,sizeof(String),"gravity %s",Task[Comment]);
SendRconCommand(String);
}
case 17://weather
{
format(String,sizeof(String),"banip %s",Task[Comment]);
SendRconCommand(String);
}
case 18://gravity
{
format(String,sizeof(String),"unbanip %s",Task[Comment]);
SendRconCommand(String);
}
}
format(String, sizeof(String), "UPDATE `samp`.`prosc` SET `ID` = '1', `ACTION` = '0',`TARGET` = '0',`COMMENT` = 'None' WHERE `prosc`.`ID` =1");
mysql_query(String);
}
public OnPlayerConnect(playerid)
{
SendClientMessage(playerid,C_WHITE,"This Server is using Professional Server Controller by Shabi RoxX.");
return 1;
}
It's a simple website consists of 5 pages.... On each action you have to enter adminpass that can be change in adminpass.php
PHP код:
<?php
$adminpass = "admin";// just change it and save
?>
Open connection.php in notepad and change the following
PHP код:
$mysql_host = 'localhost';//host name
$mysql_user = 'root';//user name
$mysql_pass = '';//password
$mysql_db = 'samp';//database
-----------------
----------------------
Installation:
╙Open /Server/scriptfiles/mysql.cfg and change you mysql setting.....
╙Open /webiste/connect.php in notepad and change you mysql setting....
Note:Mysql settings/connection for both FS and Website must be same
╙Open /webiste/adminpass.php in notepad to change your admin pass
Download:
V1:
By Mediafire.com
website:Download
FS:Downlaod
Full FS+website:Download
Re: [+Website]Professional Server Controller v1[MySQL Needed] - [BP]Tony - 18.03.2012
Have something more to do sorry
6/10
Re: [+Website]Professional Server Controller v1[MySQL Needed] - Shabi RoxX - 18.03.2012
Quote:
|
Originally Posted by [BP]Tony
 Have something more to do sorry
6/10 |
Re: [+Website]Professional Server Controller v1[MySQL Needed] - iRana - 18.03.2012
wow nice idea, I tested it in localhost works perfect
rep+
Re: [+Website]Professional Server Controller v1[MySQL Needed] - Shabi RoxX - 18.03.2012
Quote:
|
Originally Posted by iRana
wow nice idea, I tested it in localhost works perfect
rep+ |
Re: [+Website]Professional Server Controller v1[MySQL Needed] - iRana - 25.03.2012
its really fun slaping and sending pm to a freind when i am offline . Lol he thoughs it was a random thing. Can you please add freeze,unfreeze and givemoney features
Re: [+Website]Professional Server Controller v1[MySQL Needed] - Shabi RoxX - 25.03.2012
Quote:
|
Originally Posted by iRana
its really fun slaping and sending pm to a freind when i am offline . Lol he thoughs it was a random thing. Can you please add freeze,unfreeze and givemoney features
|
Re: [+Website]Professional Server Controller v1[MySQL Needed] - Niko_boy - 25.03.2012
Nice one !
could be improved alot
Re: [+Website]Professional Server Controller v1[MySQL Needed] - Shabi RoxX - 26.03.2012
Quote:
|
Originally Posted by Niko_boy
Nice one !
could be improved alot |
, Punjab de sheera :P
Re: [+Website]Professional Server Controller v1[MySQL Needed] - royal_king - 26.03.2012
Quote:
|
Originally Posted by Shabi RoxX
[CENTER]
About Website: It's a simple website consists of 5 pages.... On each action you have to enter adminpass that can be change in adminpass.php PHP код:
|
Re: [+Website]Professional Server Controller v1[MySQL Needed] - Awankz - 26.03.2012
Nice One Man
Re: [+Website]Professional Server Controller v1[MySQL Needed] - Bect - 26.03.2012
with mysql is more better than with normaly functions ?
Re: [+Website]Professional Server Controller v1[MySQL Needed] - DRIFT_HUNTER - 26.03.2012
Why just dont create rcon commands and execute them with Westie Rcon Api
Re: [+Website]Professional Server Controller v1[MySQL Needed] - SpardaHD - 26.03.2012
Wow Awesome Script!! Keep It Up !!
Re: [+Website]Professional Server Controller v1[MySQL Needed] - BabyMan - 26.03.2012
I did everything and I can not run it
How to connect?
Re: [+Website]Professional Server Controller v1[MySQL Needed] - Shabi RoxX - 29.03.2012
Quote:
|
Originally Posted by BabyMan
I did everything and I can not run it
How to connect? |
Re: [+Website]Professional Server Controller v1[MySQL Needed] - Xtreme Brotherz - 29.03.2012
can you make it for .ini files?? bcoz mine is not sql based
Re: [+Website]Professional Server Controller v1[MySQL Needed] - [DOG]irinel1996 - 29.03.2012
Not bad, good job,
I don't like the way that you check the server stats, you know, gravity, etc.
You made a basic design, and yeah, good commands. Of course, the design can be improved.
And the mysql.cfg in scriptfiles is a waste of time, you could define the configuration into the FS, anyway, it looks more organized as you made it.4/5. Good job.
Re: [+Website]Professional Server Controller v1[MySQL Needed] - Shabi RoxX - 30.03.2012
Quote:
|
Originally Posted by Xtreme Brotherz
can you make it for .ini files?? bcoz mine is not sql based
|
Re: [+Website]Professional Server Controller v1[MySQL Needed] - XFlawless - 30.03.2012
This panel is too vulnerable to injections and attack (XSS and CSRF <3). Please learn PHP properly before you develop something which is directly put into production by novice server owners. Also your code is mess learn some indentation styles...
Quote:
|
Originally Posted by Shabi RoxX
.ini file ? But i don't known that if PHP supports data from .ini .
|
Quote:
|
Originally Posted by DRIFT_HUNTER
Why just dont create rcon commands and execute them with Westie Rcon Api
|