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 09:42

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

Advertisement



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

Discussion on [RELEASE] Secure PHP Web Registration Script (MSSQL ODBC) within the Shaiya PServer Guides & Releases forum part of the Shaiya Private Server category.

Reply
 
Old   #1
 
abrasive's Avatar
 
elite*gold: 0
Join Date: Oct 2009
Posts: 262
Received Thanks: 809
[RELEASE] Secure PHP Web Registration Script (MSSQL ODBC)

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.
Attached Files
File Type: rar abrasive_registration_odbc.rar (8.4 KB, 5218 views)
abrasive is offline  
Thanks
58 Users
Old 07/09/2012, 02:17   #2
 
JohnHeatz's Avatar
 
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,976
#Added to the Index
JohnHeatz is offline  
Thanks
1 User
Old 07/09/2012, 03:32   #3
 
abrasive's Avatar
 
elite*gold: 0
Join Date: Oct 2009
Posts: 262
Received Thanks: 809
Quote:
Originally Posted by JohnHeatz View Post
#Added to the Index
Thanks, you could probably replace the link to my old registration page in the index with this one. The only reason to use the old one is if you want to use the php_mssql driver instead of the odbc driver. The php_mssql driver is horribly out of date, so it may be better to steer people to use odbc.
abrasive is offline  
Thanks
2 Users
Old 07/12/2012, 23:09   #4
 
.Nexus''s Avatar
 
elite*gold: LOCKED
Join Date: Jan 2012
Posts: 807
Received Thanks: 245
Hello , I got this error
"Warning: odbc_execute() [function.odbc-execute]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'RowID', table 'PS_UserData.dbo.Users_Master'; column does not allow nulls. INSERT fails., SQL state 23000 in SQLExecute in C:\xampp\htdocs\Registration\register.php on line 60"
when i press "Create Account"
can someone help me please ? =)
.Nexus' is offline  
Old 07/12/2012, 23:35   #5
 
elite*gold: 50
Join Date: Sep 2011
Posts: 408
Received Thanks: 1,262
Quote:
Originally Posted by EpicG4m3r View Post
"Cannot insert the value NULL into column 'RowID', table 'PS_UserData.dbo.Users_Master'; column does not allow nulls. INSERT fails."
B]
I Think your problem is here o,o make it allow nulls
JuuF is offline  
Thanks
1 User
Old 07/13/2012, 06:00   #6
 
abrasive's Avatar
 
elite*gold: 0
Join Date: Oct 2009
Posts: 262
Received Thanks: 809
Quote:
Originally Posted by JuuF View Post
I Think your problem is here o,o make it allow nulls
Actually no, you want to set the RowID column to be auto-increment. This way each row has a unique identifier.
abrasive is offline  
Thanks
3 Users
Old 07/31/2012, 18:34   #7
 
erickreq's Avatar
 
elite*gold: 0
Join Date: Feb 2010
Posts: 97
Received Thanks: 100
Thumbs up

thanks friend thank you very much hopefully everyone were like you who share
1000 tnk
erickreq is offline  
Old 09/15/2012, 16:57   #8
 
patoringa's Avatar
 
elite*gold: 0
Join Date: Aug 2010
Posts: 103
Received Thanks: 26
Question

Quote:
Originally Posted by abrasive View Post
You will need to set the RowID column on the Users_Master table to be an auto-increment column.

Hello all! After 1 year, I'm back ;-)
Help, plz. I can not change the autoincrement in RowlD.
There is any sql for this? Manually doesn't work.
I get this message: "Saving change is not permited ......... tables to be dropped and re-created."
But I'm have content in the table.

Thank you all.
patoringa is offline  
Old 09/15/2012, 18:03   #9
 
JohnHeatz's Avatar
 
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,976
Try logging into your SQL with the sa user and password and doing the change, normally that happens due to permissions
JohnHeatz is offline  
Thanks
2 Users
Old 09/17/2012, 17:55   #10
 
elite*gold: 0
Join Date: Aug 2010
Posts: 98
Received Thanks: 6
Quote:
Originally Posted by patoringa View Post
Hello all! After 1 year, I'm back ;-)
Help, plz. I can not change the autoincrement in RowlD.
There is any sql for this? Manually doesn't work.
I get this message: "Saving change is not permited ......... tables to be dropped and re-created."
But I'm have content in the table.

Thank you all.


Fala aew meu querido *-* resolveo volta ao ramo de shaiya rs.
Se quiser akida, estamos aew. um abraço
venon321 is offline  
Old 09/18/2012, 12:21   #11
 
patoringa's Avatar
 
elite*gold: 0
Join Date: Aug 2010
Posts: 103
Received Thanks: 26
Quote:
Originally Posted by venon321 View Post
Fala aew meu querido *-* resolveo volta ao ramo de shaiya rs.
Se quiser akida, estamos aew. um abraço
Obrigado. Retornando com força total!
patoringa is offline  
Old 09/19/2012, 11:10   #12
 
elite*gold: 0
Join Date: Feb 2012
Posts: 267
Received Thanks: 50
How do i set Auto incement ?

Its a noob question i know, but i dont know how to set it in RowID.

Greetings.
cypherxxl is offline  
Old 09/20/2012, 00:23   #13
 
JohnHeatz's Avatar
 
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,976


Do that, I don't think much explanation besides it will be needed
JohnHeatz is offline  
Thanks
3 Users
Old 09/20/2012, 09:30   #14
 
elite*gold: 0
Join Date: Feb 2012
Posts: 267
Received Thanks: 50
Dont work, i dont know why, i cant get it to work...

Code:
'Users_Master' table
- Unable to modify table.  
Cannot insert the value NULL into column 'UserUID', table 'PS_UserData.dbo.Tmp_Users_Master'; column does not allow nulls. INSERT fails.
The statement has been terminated.
cypherxxl is offline  
Old 09/20/2012, 14:09   #15
 
patoringa's Avatar
 
elite*gold: 0
Join Date: Aug 2010
Posts: 103
Received Thanks: 26
Quote:
Originally Posted by JohnHeatz View Post


Do that, I don't think much explanation besides it will be needed
I try it with sa user, but don't work for me too.
patoringa is offline  
Reply


Similar Threads Similar Threads
[RELEASE] Secure PHP Web Registration Script
10/08/2019 - Shaiya PServer Guides & Releases - 208 Replies
This is technically obsolete now, and I'd recommend using my newer script instead. This is a secure registration script meant for Shaiya private servers. I noticed a lot of private servers were using sandolkakos's registration script, which is very dangerous since it is vulnerable to SQL injection. Ideally your UserUID column in the table PS_UserData.dbo.Users_Master should be set to auto-increment. If this is not the case, you will need to adjust this script, or ideally fix your...
[Release] PVP Rankings (MSSQL ODBC)
07/16/2017 - Shaiya PServer Guides & Releases - 57 Replies
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 WAMP/XAMPP/IIS server on a Windows OS based computer. All you need to run this is an MSSQL database, and a web server which can process PHP files, such as Apache (the A in the WAMP/XAMPP acronyms), or IIS7+. This is a PHP based rankings script for use with the MSSQL ODBC database connector. Features Tool-tip showing recent killed/killed by...
Secure PHP Web Registration Script
07/21/2011 - Shaiya Private Server - 2 Replies
Original Thread Link - http://www.elitepvpers.com/forum/shaiya-pserver-de velopment/886028-release-secure-php-web-registrati on-script.html Does anybody know if there is a video tutorial for this out there, and if there isn't then can somebody please post one and send me link via messaging through this website. Or post reply on this thread, i genuinely have no idea how to configure my SQL to suit the required files you need to do this. Then when you do finish it, how does it go from SQL to...
[RELEASE]Web Pack ( MSSQL / ODBC )
05/01/2009 - Dekaron Private Server - 8 Replies
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 Packs are the follow scripts : register.php <--- Register Accounts ranking.php <--- List characters , order by Level and Exp , list only non GMs guild.php <--- List all guilds . order by members count and list all guild members



All times are GMT +1. The time now is 09:42.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.