[FilterScript] HidMin - Crappy MySQL admin system

[FilterScript] HidMin - Crappy MySQL admin system - 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] HidMin - Crappy MySQL admin system (/showthread.php?tid=235573)

Pages: 1 2 3

HidMin - Crappy MySQL admin system - Hiddos - 05.03.2011

As I'm typing this I'm tired and dizzy, and I'd really like to get some sleep so don't expect a too enthusiastic or detailed thread, I'll try to re-write it tomorrow. Or maybe the day after tomorrow.

What
After releasing some Cowly scripts I thought I should release something less useful for a break, so here it is: HidMin. HidMin is currently the only project I'm developing (I'm moving away from SA:MP a bit), in my holy quest to learning more about MySQL (Which I might extend to PHP as well). It's a rather basic admin system, but IMO it still provides the most commands/features you need. Should you really need all those uber-super-duper features which you'll never use and are only annoying, I recommend you to wait for GarAdmin (Sorry Garsino, I had to post that

).

Features
This system hasn't really got any 'cool' features, I just wanted to learn more about MySQL ^^. Anyways, here's a small list:

MySQL account system & logging
Whirlpool hashing
sscanf2 for unformatting strings
ZCMD as command processor
Auto log-in

Note that there's also a 'bans' table in the database, which right now hasn't got any purpose at all. Ban-related functions will be made at a later date.

Administration
The administration system features 4 levels of commands (I was planning on making a 'lite' version as well (3 levels), but that was canceled). I'm planning on creating more in the future. Here's a list of the current commands:

Level 1:
* /getinfo /ip /text /spec(off) /slap
* /(un)freeze /(un)mute (/voice) /warn /kick

Level 2:
* /get(here) /goto /explode /an(nounce) /ban

Level 3:
* /veh /giveweapon /unbanip

Level 4:
* /makeadmin /gmx

There's also a small list of public commands, like /report and /login:

Public:
* /login /register /stats /admins /report /acmds

Teak yourself - Important!
When opening the script, you might wish to tweak those settings (At the top):

pawn Код:

#define SQL_HOST "localhost"
#define SQL_USER "root"
#define SQL_DB "sa-mp"
#define SQL_PASS ""

Download
For all files on apart downloads:
Source: http://pastebin.com/zFS3wwvt
MySQL dump: http://pastebin.com/XRQgm7q2
MySQL plugin: https://sampforum.blast.hk/showthread.php?tid=56564
sscanf2 plugin: https://sampforum.blast.hk/showthread.php?tid=120356
Whirlpool plugin: https://sampforum.blast.hk/showthread.php?tid=65290

For a Windows .rar pack:
http://solidfiles.com/d/f354/

For a Linux .rar pack:
http://solidfiles.com/d/0959/

Mirror provided by linuxthefish
Windows Pack
Linux pack

I'll do a small tutorial on setting up MySQL later, till now the 'installation process' at this topic might help: https://sampforum.blast.hk/showthread.php?tid=178387

Bugs N' Suggestions
Bugs and suggestions may be posted here. Please do note that I will try to fix most bugs I encounter, and that I read all suggestions.

Credits
Those people deserve credit and thanks for their help, in whatever way it helped me:

Realcop228 - Clean MySQL gamemode
Calgon - Helping me setting up MySQL on a Linux server, as well as some other issues.
Sergei - Calgon is on the list, so for some reason Sergei automatically is too.
G-sTyLeZzZ - MySQL plugin
[HiC]TheKiller - MySQL tutorial
Zeex - ZCMD
****** - Whirlpool/sscanf2
Anyone I forgot? Please let me know!

Beta testers: shadowdog, gamer323213243242354, Imago, vital2k/[LeS]GR. Along with some other guys which I can't remember

.

Once again, don't be afraid to post criticism.

Re: HidMin - Crappy MySQL admin system - int3s0 - 06.03.2011

Awesome.

YOU DID IT!

Re: HidMin - Crappy MySQL admin system - justsomeguy - 06.03.2011

if i log in with rcon can i use all those commands?

ps.:
dude this is nice!

Re: HidMin - Crappy MySQL admin system - HyperZ - 06.03.2011

Good Job Hiddos, I'll test it

Re: HidMin - Crappy MySQL admin system - Markx - 06.03.2011

Nice!

Re: HidMin - Crappy MySQL admin system - Calgon - 06.03.2011

My only objection is that you haven't used unix timestamps, other than that, it looks brilliant for generic usage.

Re: HidMin - Crappy MySQL admin system - Hiddos - 06.03.2011

Quote:

Originally Posted by justsomeguy

if i log in with rcon can i use all those commands?

ps.:
dude this is nice!

Yerp, all commands are available by either having the required admin level or being a RCON admin.

Quote:

Originally Posted by Calg00ne

My only objection is that you haven't used unix timestamps, other than that, it looks brilliant for generic usage.

Would you mind if you could explain that to me on MSN ^^?

To the other posts, thanks!

Re: HidMin - Crappy MySQL admin system - iMonk3y - 06.03.2011

This is great! I can learn MySQL from here

BTW I freakin detest solidfiles links, because when I click them, my PC halts for 30+ seconds, which leads to irrational outbreak..

Re: HidMin - Crappy MySQL admin system - Hiddos - 06.03.2011

Quote:

Originally Posted by iMonk3y

This is great! I can learn MySQL from here

BTW I freakin detest solidfiles links, because when I click them, my PC halts for 30+ seconds, which leads to irrational outbreak..

Added as an attachment, check main post.

Re: HidMin - Crappy MySQL admin system - gamer931215 - 06.03.2011

pretty nice, only you are using a /giveweapon command, but there is no /disarm command :P (could be usefull to disarm hackers, or other admins maybe)

Re: HidMin - Crappy MySQL admin system - Gforcez - 06.03.2011

Nice hiddos!

First time that you use MySQL?

Re: HidMin - Crappy MySQL admin system - Hiddos - 06.03.2011

Quote:

Originally Posted by gamer931215

pretty nice, only you are using a /giveweapon command, but there is no /disarm command :P (could be usefull to disarm hackers, or other admins maybe)

I might add a few other commands later. Sometimes I\'m also thinking about making specific additions like house or vehicle systems.

Quote:

Originally Posted by Gforcez

Nice hiddos!

First time that you use MySQL?

Yerp, so I focused on using MySQL in this script, not on functions.

Re: HidMin - Crappy MySQL admin system - xir - 06.03.2011

Why Crappy Admin system ? I think it rocks

Re: HidMin - Crappy MySQL admin system - Calgon - 06.03.2011

It\'s already 3000* better than all of the flatfile based systems, purely because of the implementation of MySQL!

Re: HidMin - Crappy MySQL admin system - Cypress - 06.03.2011

I will use this for my gamemode! Thanks, i will learn a lot from this.

Re: HidMin - Crappy MySQL admin system - BASITJALIL - 06.03.2011

Nice like it but very less commands

Re: HidMin - Crappy MySQL admin system - vital2k - 06.03.2011

Quote:

Originally Posted by BASITJALIL

Nice like it but very less commands

As Hiddos already stated, he focused more on the MySQL aspect as it was mainly the purpose of this project therefore the amount of commands available is limited.

Good job on this Hiddos. It\'s simple but that\'s all something like this needs to be.

Re: HidMin - Crappy MySQL admin system - Mean - 06.03.2011

It\'s not crappy, when it doesn\'t have much lines it doesn\'t mean it\'s crappy.

Re: HidMin - Crappy MySQL admin system - Hiddos - 06.03.2011

Crappy or not, I had to have a good and appealing slogan for it, and this was the best I came up with. Like I said, suggestions are welcome

.

Also, as it hasn\'t really got much commands and features, it doesn\'t mean they aren\'t possible! Go out there and add your own ideas to the script ^^

Re: HidMin - Crappy MySQL admin system - sherlock - 06.03.2011

very good i like!