[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.
[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.
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.
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 ? =)
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.
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
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.
[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