New Excelent Registration Script

[renan7899]

Hello, I created a new registration script for Perfect World... it's an excelent registration script.

Features:

• Check in real time if E-mail and Username is already in use;
• Check if the fields are correct;
• Anti sql injection;
• You can choose if the user must confirm registration in e-mail or not;
• You can choose if the user will receive cubi-golds in registration and determine an amount;
• The registration have a very cool visual;
• Very strong CAPTCHA;
• E-mail validator.

Update V1.1 11-06-2011:

• Fixed some translation errors;
• Added PIN (security code) wich can be used in change password scripts (the PIN will be saved in the "qq" field of the "users" table) PS: you must use the pendente_registro.sql again, otherwise, the e-mail confirmation won't work;
• Security and bug fix: removed sql_regcase and added CASELESS on preg_replace in anti sql injection (filtrar());

Update V1.2 12/04/2012 (dd/mm/YY):

• Changed CAPTCHA's visual;
• Changed submit button's visual;
• Fixed password format;
• Fixed cubi-gold in registration;
• Fixed possible errors at registration with e-mail confirmation;
• Download link back online.
  

How to use:
There's a README.txt file in the .rar ... read it! xP

Download:

You must be registered to see links

Screenshot:

You must be registered to see links

PS: Only the texts, alerts, informations was translated... the source code not.

If you have any questions, bugs, suggestions, please report to me here on the forum.

Important!

The password will be saved in the byte format. If you want to compare passwords in web apps, your must use the function fn_varbintohexsubstring of you PW's MySQL.

Check this: Password Reversal

Credits:
------------------------------
renan7899 by the script
Goodlookinguy by the help with Ajax and jQuery

 

[DaMadBoy]

Does this script happen to record the IPs of those registering the accounts? I have to say it looks brilliant.

 

[renan7899]

Does this script happen to record the IPs of those registering the accounts? I have to say it looks brilliant.

Thanks =) ... and yes, it does.

 

[khangvn10]

The CAPTCHA won't show up. Could you please take a look of it?

Fatal error: Call to undefined function: imagecreate() in W:\www\register\captcha\securimage.php on line 675

 

[renan7899]

The CAPTCHA won't show up. Could you please take a look of it?

imagecreate is a PHP function, if it's undefined, your php version is too low, or it doesn't support the function.

It's working 100% in my Windows machine.

Try to download and install PHP 5 or 6.

 

[argonaut]

Hi and thank you for script.
I implemented this on my ubuntu machine but it comes up with..

Deprecated: Function sql_regcase() is deprecated in /opt/lampp/htdocs/register/filtrar.funcao.php on line 8

The script does work very well (tested) but the error is unsightly.

Any idea how to fix?

 

[matheusben]

here also works 100%

 

[argonaut]

Looking up this i found removing sql_regcase did fix the problem.
Apparently:- This function has been DEPRECATED as of PHP 5.3.0. Relying on this feature is highly discouraged.

Changing script to:-
$campo = preg_replace ( ("/(from|select|insert|delete|where|drop table|show tables|#|\*|--|\\\\)/"),"", $campo);

Made it lose errors for me...like i said it works but...
Anyway problem fixed for me, hope this helps somebody.
Example

You must be registered to see links

 

[renan7899]

I have PHP 6, and it doesn't have this error...

Anyway, preg_replace is enough.

$campo = preg_replace("/(from|select|insert|delete|where|drop table|show tables|#|\*|--|\\\\)/"), "", $campo);

 

[argonaut]

ty renan7899 for your quick response, also i have tried the "register with cubi" option but it didnt seem to work for me, i did wait the 10 minutes also. Rest of the script works great and ty for sharing this nice script.

 

[88supra86]

ill check this script out and give some feedback. also will find alternative with making it work with php 5 versions as i noticed some are having troubles.

runnning ubuntu and centos version.

;;;;;UPDATE;;;;;

the script works REALLY well have created a script to work with it on password recovery with calling for secret answer and pin 5/5 man good work.

 

[dietchse]

Thanks for your great release for reg form,permission to use your source code

 

[hrace009]

renan,

hope you can add some code from this script for security with PIN email Old password and New Password

credits
343 for PHP pear function and reset pass
Romulan for registration page
hrace009 for adding new line for PIN as primary security code

pass:

You must be registered to see links

 

[renan7899]

Thanks for your great release for reg form,permission to use your source code

Feel free to use it. Just don't put credits for you =P

Okay people hmm, about the cubi-golds... I don't know exactly what the 'sn' is for... the BatGM programm always reduce the sn by one... every insertion in the usecashnow table have a different sn, and it works.

I'll try to use the usecash procedure and see if it will have a good result...

And try to create a MySQL trigger to add cubis when register (that's more reliable).

Hey hrace, the zip file is protected by password.

 

[Pilad]

renan,

hope you can add some code from this script for security with PIN email Old password and New Password

credits
343 for PHP pear function and reset pass
Romulan for registration page
hrace009 for adding new line for PIN as primary security code

pass please

 

[tbnanubis]

imagecreate is part of the php gd package which is available seperately on debian installations

 apt-get install php5-gd

 

[renan7899]

imagecreate is part of the php gd package which is available seperately on debian installations

 apt-get install php5-gd

Yah, I searched and found this answer, but I already had answered, so... nevermind xD

 

[hrace009]

Feel free to use it. Just don't put credits for you =P

Okay people hmm, about the cubi-golds... I don't know exactly what the 'sn' is for... the BatGM programm always reduce the sn by one... every insertion in the usecashnow table have a different sn, and it works.

I'll try to use the usecash procedure and see if it will have a good result...

And try to create a MySQL trigger to add cubis when register (that's more reliable).

Hey hrace, the zip file is protected by password.

oh yeah.. password is

You must be registered to see links

i forgot that onett1:

 

[tbnanubis]

Yah, I searched and found this answer, but I already had answered, so... nevermind xD

just posted for the sake of completeness as this library is not delivered by default. Just in case anyone has similar problems and no idea where it comes from.

 

[renan7899]

renan,

hope you can add some code from this script for security with PIN email Old password and New Password

credits
343 for PHP pear function and reset pass
Romulan for registration page
hrace009 for adding new line for PIN as primary security code

You mean: to change password, the user must type the PIN??