SA-MP Forums Archive
[FilterScript] r_Register MySQL BASED Registration FS - 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] r_Register MySQL BASED Registration FS (/showthread.php?tid=251057)

Pages: 1 2 3


r_Register MySQL BASED Registration FS v0.2.2 - Raimis_R - 25.04.2011

This is the registration system filterscript for users who are not able to create system like this one.
All information is stored in MySQL database, when player registers his data is saving in table.

News: You must enter security code to register your account, the code is placed on the left side of your screen in TextDraw mode. With this you will know that human is registering and u will be protected from bots and other illeagal things.

IP Connections
Registered people receives a password which they will use for log in when they will connect from other ip adress.
Security is guaranteed!


Quote:

ChangeLog

0.2 - Fixed some bugs with load data. Added 0.3c colors. Security code now supported with numbers and letters. Changed textdraw.


0.2.1.
Added Ban System and ban kick commands.

Now you can manage how much player can register users per ip, using 1line. - Suggestion By Gh0st_


pawn Code:
#define MAX_ACCOUNTS_PER_IP 4 // MAX ACCOUNTS PER 1IP
0.2.2

Optimized script. SQL syntaxes now formating with mysql_format function.
Now script using OnQueryFinish callback for better query threading

All Commands.

Quote:
BAN - /ban [Nick/ID] [Reason]
KICK - /kick [Nick/ID] [Reason]
FREEZE - /freeze [Nick/ID] MODE: 0 - time in seconds 1 - time in minutes.
SLAP - /slap [Nick/ID] [Height] [Reason]

Pictures:









v 0.2.1







Not found.

New Version 0.2.2: http://solidfiles.com/d/6be7/
Old version 0.2.1: http://solidfiles.com/d/8d0d1/



1. Sscanf plugin:
https://sampforum.blast.hk/showthread.php?tid=120356
2. MySQL plugin: https://sampforum.blast.hk/showthread.php?tid=56564


-Raimis.

Comments?


Re: r_Register MySQL BASED Registration FS - ellyx - 25.04.2011

Nice work 10/10


Re: r_Register MySQL BASED Registration FS - Raimis_R - 25.04.2011

Thanks.


Re: r_Register MySQL BASED Registration FS - BASITJALIL - 25.04.2011

Nice work dude


Re: r_Register MySQL BASED Registration FS - Raimis_R - 25.04.2011

Thanks.

If you have any ideas pm me or write here.

Maybe more comments


Re: r_Register MySQL BASED Registration FS - Montis123 - 25.04.2011

Nice man keep it up.


Re: r_Register MySQL BASED Registration FS - sant - 25.04.2011

Just what i needed. Thanks!


Re: r_Register MySQL BASED Registration FS - Raimis_R - 25.04.2011

Thanks and no problem.


Re: r_Register MySQL BASED Registration FS - Respekt - 26.04.2011

Great work ! maybe i will use it in future


Re: r_Register MySQL BASED Registration FS - Crystyan12 - 26.04.2011

Very, nice. ThankS


Re: r_Register MySQL BASED Registration FS - juraska - 26.04.2011

Good work brother 10/10


Re: r_Register MySQL BASED Registration FS - Raimis_R - 26.04.2011

Thanks all.


Re: r_Register MySQL BASED Registration FS - Medal Of Honor team - 26.04.2011

really nice work! I may use it in future


Re: r_Register MySQL BASED Registration FS - Dainyzxz - 21.05.2011

than i press start my samp-server.exe the cmd didn\'t shows for me with that FS, without whis FS it works fine.


Re: r_Register MySQL BASED Registration FS - Raimis_R - 24.07.2011

Hello.


I forgot about this fs.. So now i updated it.

Quote:

0.2 - Fixed some bugs with load data. Added 0.3c colors. Security code now supported with numbers and letters. Changed textdraw.

Pictures:










New Download link http://solidfiles.com/d/54ac/


Re: r_Register MySQL BASED Registration FS - Libra_PL - 24.07.2011

I like the idea with image, nice work


Re: r_Register MySQL BASED Registration FS - TheBluec0de - 24.07.2011

how come when I open the dos I immediately close the server? instead of the mysql logs...

Code:
[17:37:31]  

[17:37:31] ---------------------------

[17:37:31] MySQL Debugging activated (07/24/11)

[17:37:31] ---------------------------

[17:37:31]  

[17:37:31] >> mysql_connect( )

[17:37:31] CMySQLHandler::CMySQLHandler() - constructor called.

[17:37:31] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sa-mp" | Username: "root" ...

[17:37:32] CMySQLHandler::Connect() - Can\'t connect to MySQL server on \'localhost\' (10061) (Error ID: 2003)

[17:37:32] >> mysql_ping( Connection handle: 1 )

[17:37:32] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)

[17:37:32] >> mysql_close( Connection handle: 1 )

[17:37:32] CMySQLHandler::~CMySQLHandler() - deconstructor called.

[17:37:32] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[17:37:32] CMySQLHandler::Disconnect() - You cannot call this function now. (Reason: Connection is dead)



Re: r_Register MySQL BASED Registration FS - Raimis_R - 24.07.2011

FilterScript cant connect to mysql. Maybe you dont have mysql server on computer?


Re: r_Register MySQL BASED Registration FS - TheBluec0de - 24.07.2011

I downloaded and put only the plugins etc.


Re: r_Register MySQL BASED Registration FS - Raimis_R - 24.07.2011

You need mysql and apache to run it on pc.