[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

AW: HidMin - Crappy MySQL admin system - [DR]Reaper[GEARS] - 06.03.2011

verry nice Hiddos

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

Suggestion: Spect command with textdraws

EDIT: My bad, its alredy there.

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

Quote:

Originally Posted by Markx

Suggestion: Spect command with textdraws

EDIT: My bad, its alredy there.

What do you mean by \'with textdraws?

Also, I just got the bestest idea ever: Add a property and/or a housing system. Because MySQL is awesome, it can easily switch data between tables.

Re: HidMin - Crappy MySQL admin system - Rzzr - 11.03.2011

Heheheehe this made me laugh :P

Quote:

gamer323213243242354

Love your writing style Hiddos xD

But ontopic:

MySQL, ZCMD, Sscanf2, Whirlpool, Yay! Great script!

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

I\'m thinking of adding a housing system to the script as well to gain some more experience on using MySQL, but first I\'d like to know if anyone would actually be interested. Is anyone?

Re: HidMin - Crappy MySQL admin system - [NoV]LaZ - 19.03.2011

It\'s really nice, but it\'s not necessary to use the Ban function. Insert the data into the table, kick the player, and check if the player is banned upon connection.

Re: HidMin - Crappy MySQL admin system - ricardo178 - 19.03.2011

nice

Re: HidMin - Crappy MySQL admin system - linuxthefish - 16.04.2011

Awesome, just tried it out! Few changed needed to make it linuxthefish compatible, but good. :P

Re: HidMin - Crappy MySQL admin system - KingHual - 16.04.2011

Quote:

Originally Posted by Hiddos

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 ^^

And "Crappy" was the slogan u could think of?

U r mad, cow lover. Anyways now I see what you\'ve been working on so much time :P Epic

Re: HidMin - Crappy MySQL admin system - mariomako - 02.05.2011

In who format are codding passwords ?

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

Quote:

Originally Posted by mariomako

In who format are codding passwords ?

It\'s encrypted using the Whirlpool plugin made by Y_Less.

Note: As I\'m on holiday in Singapore right now, I\'m unsure when I\'ll be able to finish the housing system (Do you think \'Hid-a-House\' is a good name?)

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

Quote:

Originally Posted by Hiddos

Do you think \'Hid-a-House\' is a good name?

Yeah unique and funny (like all of your scripts

)

Re: HidMin - Crappy MySQL admin system - mariomako - 11.05.2011

how to make commands register and login dialog based?

Re: HidMin - Crappy MySQL admin system - ylleron - 11.05.2011

Hiddos as ever best quality

Re: HidMin - Crappy MySQL admin system - Montis123 - 11.05.2011

Very good like.

Re: HidMin - Crappy MySQL admin system - mariomako - 12.05.2011

how to make register and login commands dialog based ?

Re: HidMin - Crappy MySQL admin system - BizzyD - 12.05.2011

Very nice

Respuesta: HidMin - Crappy MySQL admin system - admantis - 12.05.2011

Good job <3

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

Are people still posting here? Wtf.

Quote:

Originally Posted by mariomako

how to make register and login commands dialog based ?

Well, after a while, I thought you could create an input dialog at OnPlayerConnect OR OnPlayerRequestSpawn, then at OnDialogResponse you could link it to the register/login command.

Re: HidMin - Crappy MySQL admin system - lpiob - 13.05.2011

If you\'re planning to use this implementation, or are already using it, consider following tips:

Tables don\'t have any indexes. It\'s a mistake. To (somewhat) fix it alter their structure, by executing this code:

Code:

ALTER TABLE accounts ADD PRIMARY KEY (Name);
ALTER TABLE bans ADD INDEX (Player), ADD INDEX (IP);

Although additional INTEGER column with PRIMARY KEY would be much, much faster.

Don\'t forget to periodically purge LOGS table, or it will turn into a performance hogging blackhole. Consider using ARCHIVE engine for performance boost.