[FilterScript] [FS] wAdmin - Alternate between MYSQL & DINI
#1

By Wazza
[!] Credits
I'm going to start with credit's, as I deem them the most important part of this topic.
-Me, Warren Bickley: All of the code except for the bits stated below.
-Adam Chaprnka: Helped me out a lot with learning pawn and has assisted me with learning MYSQL for this and also persuading me just how good zcmd is.
-G-Stylezzz: Creaor of the MYSQL plugin used in this, great plugin.
-Dracoblue: Creator of DINI used in this, a great ini file proccessor.
-ZeeX: His amazing ZCMD Command Proccessor, truly love it.
Y_Less: Sscanf function.
-Sandra: Used her "Flying Camera" and turned it in to an admin version(Minor changes) because I was too lazy to create my own.
-ERG: Helped me out with a MYSQL query a while back and it really got me back on the pawn road.
-Others who have been documented in the script but not here for things like vehicle names etc.

[!] Information

Quick highlight of features:
Quote:

-Ability to switch between DINI and MYSQL with the simple change of a variable.
-Enough admin commands to keep one occupied.
-Fun player features (Some can be toggled with a variable) such as horn ramp and the ability to change your nitrous speed.
-Easily Customizable with several changable defines to suit your preference.
-Server side money with a sweet textdraw to show it, stop hackers in their tracks.

Uses ZCMD as the command proccessor, extremely fast and easy to use. This script is great if your looking for zcmd examples.

Currently there are around 30-35 admin only commands, here is a list of them with a description and required level.

Level 1 (Moderator)
/Kick - Kick a player from the server
/Freeze - Prevent a player from moving or interacting with vehicles etc.
/Thaw - Un freeze a player so they can continue gameplay.
/Mute - Mute a player so they can no longer talk.
/Unmute - Allow a player to talk again.
/Mark - Mark a position on the map.
/Gotomark - Go to the position you marked, this saves while your offline.
/Kill - Kill a player.
/Slap - Sets a players health to 5 and removes their weapons.
/Goto - Teleport to another players location.

Level 2 (Administrator)
/Ban - Ban a player so that he can no longer join the server.
/Nuke - Create a massive explosion at a chosen players location.
/ACinfo - Admin Camera Info, this explains how to use the admin camera mode.
/Get - Bring a player to your location.
/Fixveh - Fix the vehicle your in.
/Sendtomark - Send a player to your marked location.
/Weather - Change the weather using the ID, if no ID is typed in a dialog box will open with options.
/Getweapon - Give yourself a weapon using ID or model.
/Resetweapons - Reset a players weapons
/Setvw - Set a players virtual world.
/Setint - Set a players interior.

Level 3 (Head Administrator)
/Setcash - Set a players money to a chosen amount.
/SetArmour - Set a players armour to a chosen amount.
/Sethealth - Set a players health to your chosen amount.
/Makevip - Give a player VIP priviliges.
/Removevip - Remove a players VIP privilige.
/Destroyveh - Remove a vehicle from the current game.
/Crash - Crash a chosen players client.Removed due to new 0.3 safety measures,
/Giveweapon - Give a player a weapon using name or ID.

Level 4 (Owner)
/Supermode - Jump really high, invincibility, run extremely fast and create explosions by punching.
/Veh - Spawn a vehicle using either the ID or name.
/Makeadmin - Give a player an admin level (Can also be used in RCON).
/Giveveh - Give a player a vehicle.

Regular Player Commands
/hr - Enables "HornRamp", press your horn to create a ramp in front of you, this saves in your file/mysql table.
/ns - Changes the speed of your nitrous, super speed is VIP only and security measures have been put in place so people can not continue tapping it to gain extra speed.
/help - A small amount of text with a list of commands etc
/credits - Credits given in the script


[!] Conditions
Do NOT claim this as your own work, by all means edit it and have fun but keep the proper credits in place. Also, don't try and sell this to anybody or anywhere, I created it and would like to share it with everyone freely.

[!] Download
v1- Discontinued.
v1.1


[!] Installation
1] Copy "wadmin.pwn" and "wadmin.amx" to your filterscripts directory.
2]Copy the includes from the download to your includes directory.
3] Open "wadmin.pwn" and edit line 7 depending on whether you want MYSQL or DINI.
4] Edit line 22 to what you would like your accounts folder name to be. Hit compile.
5]Copy the plugins from the plugins folder to your plugins directory(Create a folder called "Plugins" if one does not exist)
6]Open your server.cfg file with notepad.
7] Add "wadmin" to your filterscripts line and add "mysql"(If the plugins line doesnt exist add this line to your server.cfg "plugins mysql")
7] Save the file and run your server.
8] Log in to RCON and type /makeadmin <YourID>
[color=orange][b][u]
Thanks to anyone who downloads and constructive critisicm is always welcomed, I hope to continue the development with this and I am open to suggestions.


Wazza
Reply
#2

Great Job Wazaa
Reply
#3

Quote:
Originally Posted by Compton's Eazy E
Great Job Wazaa
Thank you
Reply
#4

its look great fs
but when i add it to the server(home)
its some thing like error come up
and inside that wirte
___________
this application has failed to start because LIBMYSQL.dll was not found Re-installing the appliction may fix this problom
__________
so what the problom ??
Reply
#5

Quote:
Originally Posted by rong13
its look great fs
but when i add it to the server(home)
its some thing like error come up
and inside that wirte
___________
this application has failed to start because LIBMYSQL.dll was not found Re-installing the appliction may fix this problom
__________
so what the problom ??
Download the file on this page http://www.dll-files.com/dllindex/dl...shtml?libmysql then copy and paste it in to your system32 directory.
Reply
#6

Good work!
Reply
#7

Great job
Reply
#8

This looks very nice and useful, good work.
Reply
#9

Thanks alot!

I'm also open to suggestions with this :P.
Reply
#10

is it made on 0.3 ?
Reply
#11

Quote:
Originally Posted by RemulisLTU
is it made on 0.3 ?
Yes, will not work in previous versions.
Reply
#12

/crash won't work.
Y_Less didn't get any credits, you use his sscanf code.
Reply
#13

Quote:
Originally Posted by MenaceX^
/crash won't work.
Y_Less didn't get any credits, you use his sscanf code.
My bad, adding them now.

Crash removed, wasn't aware of 0.3's new security measures with invalid objects.
Reply
#14

Nice. I'll be testing this
Reply
#15

Nice to see people using zcmd + sscanf combination instead of old methods.

By the way, wouldn't it be better if you make 'USE_MYSQL' define instead of variable, since it's constant anyway.
pawn Code:
#define USE_MYSQL 0
Reply
#16

Quote:
Originally Posted by $ЂЯĢ
Nice to see people using zcmd + sscanf combination instead of old methods.

By the way, wouldn't it be better if you make 'USE_MYSQL' define instead of variable, since it's constant anyway.
pawn Code:
#define USE_MYSQL 0
That threw out an error when I oringinally did it, also i'm thinking this way in a future release I can make dini/mysql interchangable in game.

Everyone should use zcmd+sscanf, not only is it easy to learn but it is so simple to create a command with multiple parameters.
Reply
#17

when i try to compile wadmin.pwn i get this:
Quote:

C:\samp03asvr_R3_win32\filterscripts\wadmin.pwn(2) : fatal error 100: cannot read from file: "a_mysql"

Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase


1 Error.

how to fix this?
p.s. i have copied a_mysql.inc to Include folder
Reply
#18

Quote:
Originally Posted by akiims
when i try to compile wadmin.pwn i get this:
Quote:

C:\samp03asvr_R3_win32\filterscripts\wadmin.pwn(2) : fatal error 100: cannot read from file: "a_mysql"

Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase


1 Error.

how to fix this?
p.s. i have copied a_mysql.inc to Include folder
There are two include folders now, one inside the pawno folder and one inside the root, try putting it into both.
Reply
#19

Thx, i wasnt copied a_mysql.inc to Pawno Include folder

DINI works fine but when i try to use mysql server crashes :/
Reply
#20

Quote:
Originally Posted by akiims
Thx, i wasnt copied a_mysql.inc to Pawno Include folder

DINI works fine but when i try to use mysql server crashes :/
With MYSQL you have to own a MYSQL server, alternatively you can use WAMP, gogle it and download.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)