[FilterScript] sbAdmin - Advanced MySQL Administration System
#1



sbAdmin - Advanced MySQL Administration System
Script Version: 1.1 | MySQL Version: R39-4

Information
Hello all guys, today I am proud to announce you that sbAdmin is released. After months of its development I managed to make the first version. I wanted to keep this script for myself to use it on my upcoming gamemodes, but I decided to release it. This filterscript is similar with GAdmin since we both are using updated functions and includes also I copied some of his functions that helped me on implementing more features easier (I got his permission to release them AGAIN). This script is based on MySQL (BlueG plugin) and with ThePhenix's include that saved me a lot of time with simplifying the queries. Thi filterscript designed for Newbies so everyone can edit it, its tables and make it working without complex steps, the only thing you have to do is to set up your MySQL's host info which you one you can find on your host's provider. Gamemode is fully configurable.



Downloads
sbAdmin - Full PackageMediafire
sbAdmin - View OnlyPastebin
sscanf2https://sampforum.blast.hk/showthread.php?tid=570927
easy-mysql.inchttps://sampforum.blast.hk/showthread.php?tid=590310
izcmd.inchttps://sampforum.blast.hk/showthread.php?tid=576114
timestamptodate.inchttps://sampforum.blast.hk/showthread.php?tid=347605
streamerhttps://sampforum.blast.hk/showthread.php?tid=102865
Features
This list won't be updated with upcoming versions features check changelog for updates!
  • 5 levels of admins (Configurable)
  • 3 levels of VIPs (Configurable)
  • Helper system with 1 level (Not configurable)
  • Saving logs (Configurable)
  • Ability to read the commands (Configurable)
  • Ability to force register/login dialogs
  • Ability to change tables name
  • Tables will be auto created with your configurable info
  • Ability to change each admin's level name
  • Ability to change each vip's level name
  • Ability to set MAX admin levels
  • Ability to set MAX vip levels
  • Ability to set MAX warnings where the player can get before get kicked
  • Ability to set MAX attempts where the player can have before get kicked (On login/register)
  • Jail, mute, cmd mute and warns are saving the database so player will never avoid his/her punishments
  • Custom saving player's online time (Gammix)
  • Advanced BAN system with Offline ban, Temp Ban and IP ban
  • Advanced jail system with custom interior
  • Mute system
  • Command mute system
  • SHA256 passwords hashing
  • Saving account's ID
  • Saving registered date
  • Saving Last date where player was online
  • Wanteds system, if a player will kill another killer will gain 1 wanted and victim will loose all of his wanteds
  • Custom function that you can use anywhere in your script
  • Anti Advertising system (Configurable)
  • And much more to discover in script




Changelog
Code:
  • Version 1.1 (13/11/2015) - Fixed /unjail command - Fixed a bug on /admins command - Fixed a bug on /vips command - Fixed a bug on /helpers command

Functions
  • SendClientMessageToAdmins(color, message[])
    Usage: SendClientMessage only for admins

  • IsPlayerHelper(playeid)
    Usage: Checks if player is a helper

  • GetLevel(playerid)
    Usage: Gets player's admins level

  • IsPlayerAdminEx(playerid)
    Usage: Check if player is admin (According to my functions)

  • GetPlayerWarns(playerid)
    Usage: Gets player's warns

  • GetVipLevel(playerid)
    Usage: Gets player's VIP level

  • IsPlayerVip(playerid)
    Usage: Checks if player is VIP

  • IsPlayerMuted(playerid)
    Usage: Checks if player is muted

  • IsPlayerCMDMuted(playerid)
    Usage: Checks if player is command muted

  • IsPlayerJailed(playerid)
    Usage: Checks if player is jailed

  • JailPlayer(playerid)
    Usage: Place a player to jail

  • UnJailPlayer(playerid)
    Usage: Remove a player from jail

  • LoadObjects(playerid)
    Usage: Load player's objects




Commands

Admin Commands
Level 1 Commands
/acmds /spec /specoff /weapons /spawn /goto /(ann)ounce /warn /remwarns
/jailed /muted /cmdmuted /explode /disarm /freeze /unfreeze /slap /mute
/unmute /respawncars /ip /car /fix /asay /kick
Level 2 Commands
/akill /jail /unjail /bring /cmdmute /uncmdmute /cleardwindows /ban /cc
/aheal /aarmour /setinterior /setworld /jetpack
Level 3 Commands
/fakedeath /giveweapon /sethealth /setarmour /healall /armourall
/givecash /givescore /unban /teleplayer
Level 4 Commands
/oban /setcash /setscore /setwanteds /setkills /setdeaths /giveallscore
/giveallcash /giveallweapon /setalltime /setallweather
Level 5 Commands
/fakecmd /fakechat /removeacc /setlevel /sethelper /setvip /gmx
Player Commands
/report /stats /ostats /changename /changepass /admins /vips /helpers
Helper and VIP commands are under development



Bugs
This version is a beta version and not a stable one, more features and updates will be added soon. I have double checked all functions and command inside the script and everything is working properly in case where you face any bug please let me know with a reply.




Suggestions
Since I will keep working on this project you can leave your suggestions and I will may add them on next versions.




Installation
Script is designed to be used from everyone since it uses simple and understandable functions, tables will be auto created when you boot your server (If they don't exist)


Code:
1. Download sbAdmin.rar package
2. Open sbAdmin.pwn file with your pawno editor
3. Edit MySQL and normal configuration to your own
4. Compile the script
5. Run your server, if you need help on how to load plugins etc. you can check server.cfg file I am providing in package


Questions
You have any question or you are facing any problem with my script? Leave a reply bellow and I will answer you when I will be able to




Questions
You have any question or you are facing any problem with my script? Leave a reply bellow and I will answer you when I will be able to




License
Since I am providing the source code you are free to whatever you want with the script except from releasing my script and just don't giving me credits, I am not here to get reputations or something I just want to help some people because we all know how hard is it to make an administration system from scratch




Special thanks to
Code:
ThePhenix for his easy-mysql include that made the code more readable
Gammix for spectate system and some other functions I got from him (Got the permission)
Emmet_ for his includes and plugins
Incognito for streamer plugin
SAMP Team for a_samp include
Jochemd for timestamptodate
Yashas for IZCMD command processor
Reply


Messages In This Thread
sbAdmin - Advanced MySQL Administration System - by SecretBoss - 04.11.2015, 15:58
Re: sbAdmin - Advanced MySQL Administration System - by Ghazal - 04.11.2015, 16:00
Re: sbAdmin - Advanced MySQL Administration System - by SecretBoss - 04.11.2015, 16:06
Re: sbAdmin - Advanced MySQL Administration System - by Ritzy2K - 04.11.2015, 16:12
Re: sbAdmin - Advanced MySQL Administration System - by SecretBoss - 04.11.2015, 16:14
Re: sbAdmin - Advanced MySQL Administration System - by Max_Andolini - 04.11.2015, 21:15
Re: sbAdmin - Advanced MySQL Administration System - by iKarim - 05.11.2015, 05:08
Re: sbAdmin - Advanced MySQL Administration System - by Karan007 - 05.11.2015, 11:50
Re: sbAdmin - Advanced MySQL Administration System - by SecretBoss - 05.11.2015, 11:51
Re: sbAdmin - Advanced MySQL Administration System - by Bolex_ - 05.11.2015, 11:56
Re: sbAdmin - Advanced MySQL Administration System - by SecretBoss - 05.11.2015, 12:13
Re: sbAdmin - Advanced MySQL Administration System - by HydraHumza - 05.11.2015, 12:33
Re: sbAdmin - Advanced MySQL Administration System - by SecretBoss - 05.11.2015, 12:39
Re: sbAdmin - Advanced MySQL Administration System - by Dice_ - 06.11.2015, 08:00
Re: sbAdmin - Advanced MySQL Administration System - by Gammix - 06.11.2015, 08:04
Re: sbAdmin - Advanced MySQL Administration System - by SecretBoss - 06.11.2015, 11:21
Re: sbAdmin - Advanced MySQL Administration System - by Shady - 07.11.2015, 17:40
Re: sbAdmin - Advanced MySQL Administration System - by SecretBoss - 07.11.2015, 19:56
Re: sbAdmin - Advanced MySQL Administration System - by xTURBOx - 10.11.2015, 13:35
Re: sbAdmin - Advanced MySQL Administration System - by SecretBoss - 10.11.2015, 13:45
Re: sbAdmin - Advanced MySQL Administration System - by gurmani11 - 11.11.2015, 17:09
Re: sbAdmin - Advanced MySQL Administration System - by SecretBoss - 11.11.2015, 18:37
Re: sbAdmin - Advanced MySQL Administration System - by gurmani11 - 12.11.2015, 12:28
Re: sbAdmin - Advanced MySQL Administration System - by SecretBoss - 12.11.2015, 12:33
Re: sbAdmin - Advanced MySQL Administration System - by gurmani11 - 12.11.2015, 15:57
Re: sbAdmin - Advanced MySQL Administration System - by Vin Diesel - 12.11.2015, 17:36
Re: sbAdmin - Advanced MySQL Administration System - by SecretBoss - 12.11.2015, 17:47
Re: sbAdmin - Advanced MySQL Administration System - by SecretBoss - 13.11.2015, 14:53
Re: sbAdmin - Advanced MySQL Administration System - by Max_Andolini - 13.11.2015, 15:33
Re: sbAdmin - Advanced MySQL Administration System - by iKarim - 13.11.2015, 15:35
Re: sbAdmin - Advanced MySQL Administration System - by SecretBoss - 14.11.2015, 06:29
Re: sbAdmin - Advanced MySQL Administration System - by ognyanov - 15.11.2015, 22:07
Re: sbAdmin - Advanced MySQL Administration System - by SecretBoss - 15.11.2015, 22:10
Re: sbAdmin - Advanced MySQL Administration System - by KnowNN - 17.11.2015, 19:01
Re: sbAdmin - Advanced MySQL Administration System - by SecretBoss - 17.11.2015, 19:38
Re: sbAdmin - Advanced MySQL Administration System - by Scripter18 - 18.11.2015, 13:08
Re: sbAdmin - Advanced MySQL Administration System - by SecretBoss - 18.11.2015, 13:39
Re: sbAdmin - Advanced MySQL Administration System - by Shady - 07.02.2016, 14:21
Re: sbAdmin - Advanced MySQL Administration System - by SecretBoss - 07.02.2016, 15:55
Re: sbAdmin - Advanced MySQL Administration System - by TwiiKzz - 07.02.2016, 17:17
Re: sbAdmin - Advanced MySQL Administration System - by SecretBoss - 08.02.2016, 15:19
Re: sbAdmin - Advanced MySQL Administration System - by Fantje - 26.05.2016, 20:01
Re: sbAdmin - Advanced MySQL Administration System - by SecretBoss - 29.05.2016, 16:01

Forum Jump:


Users browsing this thread: 35 Guest(s)