[FilterScript] HidMin - Crappy MySQL admin system
#1

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.
Reply
#2

Awesome.

YOU DID IT!

Reply
#3

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

ps.:
dude this is nice!
Reply
#4

Good Job Hiddos, I'll test it
Reply
#5

Nice!
Reply
#6

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

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!
Reply
#8

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..
Reply
#9

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.
Reply
#10

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)
Reply
#11

Nice hiddos!

First time that you use MySQL?
Reply
#12

Quote:
Originally Posted by gamer931215
View Post
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
View Post
Nice hiddos!


First time that you use MySQL?
Yerp, so I focused on using MySQL in this script, not on functions.
Reply
#13

Why Crappy Admin system ? I think it rocks
Reply
#14

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

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

Nice like it but very less commands
Reply
#17

Quote:
Originally Posted by BASITJALIL
View Post
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.
Reply
#18

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

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 ^^
Reply
#20

very good i like!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)