Fiesta Register Script

[Rutgertje]

Fiesta Register Script v1.1! [updated 15-06-2011]

Update notes:

• Converted script to normal PHP, just follow "How to use".
• Fixed some issues

-------------------------------------------------------------------------------------
Credits to the one who made the "XPT Account Manager" in the PristonTale section!
-----------------------------------
I simply took the account manager and edited it into this fiesta register script.
-------------------------------------------------------------------------------------



Picture:

What does it do?
It registers your account, checks if username isnt already taken else it'll give the error "{USERNAME} is already taken" and it'll check for bad characters "`~!@#$%^&*()+-_=[]{};\'\\:"|,/<>? " in the name and password.

How to use:
1) Download the .rar from attachements
2) Open and extract at your webhost (I suggest xampp)
3) Open config.php and change "XXXX\SQLEXPRESS" to your computers mssql server ex. "THIS_PC\SQLEXPRESS"
4) Change the password in the config.php to your MSSQL password
5) You can change the copyright text to whatever you want, right now its "Copyright © Rutgertje 2011".
6) Enjoy

Questions
If you have any questions please post them below and i'll answer them

 

[echaxxx]

thanks a lot sir...this is what i need...

 

[MrTay]

Wow nice one, will it work on other games?

 

[echaxxx]

when i try to create it says...

Access forbidden!
You don't have permission to access the requested object. It is either read-protected or not readable by the server.

If you think this is a server error, please contact the webmaster.

Error 403

edit: sori for being noob...its working now ^_^ just forgot to check on xammp on apache server

 

[Canic]

äh wie geht das ganz genau? komme net ganz klar

 

[Canic123]

Hi everyone

I have a big problem :O

can anyone help me ? xD

Problem text:

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection., SQL state 28000 in SQLConnect in C:\xampp\htdocs\Register\index.php on line 104

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\Register\index.php on line 111

Warning: odbc_do() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\Register\index.php on line 113

Warning: odbc_fetch_row() expects parameter 1 to be resource, null given in C:\xampp\htdocs\Register\index.php on line 115

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\Register\index.php on line 122

TY

 

[kimijjs]

link dead, upload again please!

 

[tompika]

upload please, we need it.

 

[g2server]

files are missing - -

upload again

 

[Canic123]

Here the reupload

To view the content, you need to sign in or register

 

[kimijjs]

ty, works perfect

 

[g2server]

Here the reupload

To view the content, you need to sign in or register

thank. :

 

[kimsae85]

Can you please show a tutorial of this? thanks.

 

[xdario]

if you can't run this, then I doubt you can host a private server.

 

[Rutgertje]

Hi everyone

I have a big problem :O

can anyone help me ? xD

Problem text:

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection., SQL state 28000 in SQLConnect in C:\xampp\htdocs\Register\index.php on line 104

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\Register\index.php on line 111

Warning: odbc_do() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\Register\index.php on line 113

Warning: odbc_fetch_row() expects parameter 1 to be resource, null given in C:\xampp\htdocs\Register\index.php on line 115

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\Register\index.php on line 122

TY

Did you edit ur config.php ? Like xxx\SQLEXPRESS to what ur sqlexpress is and the your mssql password?

files are missing

Like what? Did you turn on short open tags?

Can you please show a tutorial of this? thanks.

Sorry but learn to read:

How to use:
1) Download the .rar
2) Open and extract at your webhost ( I suggest xampp )
3) Open config.php and change "XXXX\SQLEXPRESS" to your computer mssql server ex. "THIS_PC\SQLEXPRESS"
4) Change the password to your MSSQL password
5) You can change the copyright, right now its "Copyright © Rutgertje 2010" just change it to whatever you like.
6) (If not already) Turn php short open tags on! Open xampp's php.in located in xampp\php and search (ctrl+F) for: "short_open_tag = Off" if it cant find anything just start apache and register yourself if it does find something change it to "short_open_tag = On" and sav


---------------------
Please post pictures of your errors.

 

[ReDoc]

oh nice release

 

[shawtieexbby]

Hey, i did this and it says theres a error:

Fatal error: Call to undefined function odbc_connect() in /fiesta/index.php on line 104

any ideas? D: i changed the pw and user ithink the problem is in index.php ?

 

[Canic]

i have sis problem

$_POST[username], "Password"=>$_POST[password], ); for($i=0;$iis_valid_string($_POST[username]) && !$func->is_valid_string($_POST[password])) { $usernameP=$_POST[username]; $query = "SELECT * FROM [Account].[dbo].[tUser] WHERE [sUserID]='$usernameP'"; $q = odbc_exec($connection, $query); $qt = odbc_do($connection, $query); $i = 0; while(odbc_fetch_row($qt)) $i++; if($i>0) echo"$_POST[username], is already taken!"; else { $query = "INSERT INTO [Account].[dbo].[tUser] ([sUserID],[sUserPW],[sUsername]) VALUES('$_POST[username]','$_POST[password]','$_POST[username]')"; $q = odbc_exec($connection, $query); if($q) echo"Username, $_POST[username] has been registered!"; } } else echo"Please re-enter username and password, remove all special characters!"; } echo "

 

[Langenscheidt]

nice! thx for post

 

[p1rat3]

i did everything exactly as said and i get these two errors

Any ideas on how to fix this