Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server > Shaiya PServer Guides & Releases
You last visited: Today at 10:00

  • Please register to post and access all features, it's quick, easy and FREE!

 

[RELEASE] Secure PHP Web Registration Script (MSSQL ODBC)

Reply
 
Old   #31
 
elite*gold: 0
Join Date: Mar 2014
Posts: 128
Received Thanks: 573
Delete your dbo.User_Master table and then open a new query and paste what is below. I use Abrasives registration script and this is what I did to make it work. (Been discussed and solved many times on EPVP so nothing special here...) Just delete, paste, exicute and it should work. (Also no need to delete Row ID at all. RowID is not even truly needed.)

I do suggest next time maybe doing a bit more searching on this because I found the fix here at EPVP a while back when I first started a server.

Enjoy.

(Open Spoiler to see script.)




Baserk is offline  
Thanks
4 Users
Old   #32
 
elite*gold: 0
Join Date: Feb 2014
Posts: 109
Received Thanks: 11
Ty a lot Baserk Works fine.


white95260 is offline  
Old   #33
 
elite*gold: 16
Join Date: May 2015
Posts: 4
Received Thanks: 0
Good modernized version
-spAik- is offline  
Old   #34
 
elite*gold: 0
Join Date: Nov 2014
Posts: 4
Received Thanks: 0
hello everyone!
i have a problem.. when i use this php i click on Create Account and i receive White page.. of register.php.. no error.. no new account.. nothing.. T.T
help


nicjoker is offline  
Old   #35
 
elite*gold: 0
Join Date: Apr 2009
Posts: 9
Received Thanks: 0
I could really use some help. I've been battling registration scripts for a week or more. I can't get any of them to work. Any help would be wonderful.

Thank you.


**EDIT** I keep receiving the "Database Connection Error!"

Even though all of my server info is correct in the db.config

$dbHost = '127.0.0.0.0';
$dbUser = '***';
$dbPass = 'XXX098';

Using that format.
shakey2k is offline  
Old   #36
 
elite*gold: 0
Join Date: Sep 2011
Posts: 317
Received Thanks: 182
Quote:
Originally Posted by shakey2k View Post

$dbHost = '127.0.0.0.0';
127.0.0.1
SnickQ is offline  
Old   #37
 
elite*gold: 0
Join Date: Jul 2009
Posts: 330
Received Thanks: 77
yes SinckQ is correct you have rong ip for the database try 127.0.0.1 because '127.0.0.0.0' is where u went rong
Big_ is offline  
Old   #38
 
elite*gold: 0
Join Date: Apr 2009
Posts: 9
Received Thanks: 0
I know that, I just threw that out there as a false ip so I wouldn't post my true server ip.
shakey2k is offline  
Old   #39
 
elite*gold: 0
Join Date: Aug 2015
Posts: 35
Received Thanks: 30
If you have the register script outside the host you wont connect into the DB unless you have a port open for outcoming connections, if you have it on xampp from your server just use simple local IP and your DB info...
[Dev]K is offline  
Old   #40
 
elite*gold: 0
Join Date: Jan 2013
Posts: 15
Received Thanks: 0
reCaptcha

Hi Leute,
die recaptcha URL's haben sich ja mittlerweile ein wenig verändert.
Bei mir möchte das Script momentan nicht korrekt arbeiten und zeigt mir deshalb des reCaptcha nicht an und somit auch nicht den "Create Account" Button.
Also muss dann wohl hier:
PHP Code:
<?php echo recaptcha_get_html($recaptcha_public_key); ?>
das Problem liegen. Oder vielleicht doch an dieser "g-recaptcha-response"-POST-Abfrage?
Jedenfalls habe ich den public key und private key gemäß an den Websiteschlüssel und Geheimen Schlüssel angepasst bzw. einen neuen angefordert.

Vielen Dank schon mal im Voraus für das Lesen und die mögliche künftige Hilfe

MfG
Fm20

English here:
Fordmondeo20 is offline  
Old   #41
 
elite*gold: 0
Join Date: Jan 2011
Posts: 9
Received Thanks: 0
Is there anyone still able to help with that? or a different mssql php registration ?
NarakuSS is offline  
Old   #42
 
elite*gold: 0
Join Date: Nov 2016
Posts: 33
Received Thanks: 1
Quote:
Originally Posted by abrasive View Post
This is a modernized version of .

It uses a safer method of querying the database that does not rely on escaping input to prevent SQL injection.

The only files that are different from my old registration script are:
db.config.php
register.php
changepass.php

That means if you made changes to the views for the old registration page, you can reuse those same style changes with this registration page just by replacing the view files
You will need to put your database credentials into this db.config.php.

You will need to set the RowID column on the Users_Master table to be an auto-increment column.

When using this script treat register.php as the index page. Or rename register.php to index.php if you wish.

how can i use this? how to put this code in my website. i try making website in *********. because ive see one server using this web hosting and it is talking to his database how? sorry for my english thanks in advance
balongskie123 is offline  
Old   #43
 
elite*gold: 0
Join Date: Nov 2016
Posts: 33
Received Thanks: 1
when i go to localhost/register.php it shows nothing only blank white page
balongskie123 is offline  
Old   #44
 
elite*gold: 0
Join Date: Jul 2016
Posts: 29
Received Thanks: 16
Well I was looking at this script and saw that has many questioning because of the RowID / UserUID. But some people here who do not stick their hands in the dough to try to leave it the way you want it and sometimes you wait for the "others" and that is annoying. So I made a slight modification in it that allows the null in the RowID / UserUID is just you edit in register.php. Of course if you want, but I left my RowID and the original UserUID.
Abrasive thank you for share this script.
Sorry my English guys
Attached Files
File Type: rar abrasive_registration_odbc.rar (8.5 KB, 13 views)
sanguto is offline  
Old   #45
 
elite*gold: 0
Join Date: Aug 2016
Posts: 44
Received Thanks: 5
Quote:
Originally Posted by abrasive View Post
This is a modernized version of .

It uses a safer method of querying the database that does not rely on escaping input to prevent SQL injection.

The only files that are different from my old registration script are:
db.config.php
register.php
changepass.php

That means if you made changes to the views for the old registration page, you can reuse those same style changes with this registration page just by replacing the view files
You will need to put your database credentials into this db.config.php.

You will need to set the RowID column on the Users_Master table to be an auto-increment column.

When using this script treat register.php as the index page. Or rename register.php to index.php if you wish.
Hi nice work . Its not working for me it show me this Notice: Undefined variable: errors in C:\xampp\htdocs\reg\register.view.php on line 12
idk where is the problem i change the config to my host and only the error not working . please help me


DEEPDARKP is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
[Release] PVP Rankings (MSSQL ODBC)
First of all please don't ask how to use these files in this thread. There are plenty of sites on the internet which explain how to set up a...
57 Replies - Shaiya PServer Guides & Releases
[RELEASE] Secure PHP Web Registration Script
This is technically obsolete now, and I'd recommend using my newer script instead. This is a secure registration script meant for Shaiya private...
206 Replies - Shaiya PServer Guides & Releases
Secure PHP Web Registration Script
Original Thread Link - http://www.elitepvpers.com/forum/shaiya-pserver-development/886028-release-secure-php-web-registration-script.html Does...
2 Replies - Shaiya Private Server
[RELEASE]Web Pack ( MSSQL / ODBC )
Hello guys. Here my little Web Script Pack as MSSQL and ODBC version. I hope , i have found now all bugs and errors and its work. In the...
8 Replies - Dekaron Private Server



All times are GMT +2. The time now is 10:00.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.