|
You last visited: Today at 02:21
Advertisement
MySQL registration page? Anyone?
Discussion on MySQL registration page? Anyone? within the Dekaron Private Server forum part of the Dekaron category.
06/24/2016, 11:04
|
#1
|
elite*gold: 0
Join Date: Jan 2016
Posts: 10
Received Thanks: 0
|
MySQL registration page? Anyone?
Hey guys, so we junked MSSQL and migrated everything over to MySQL 2012... and now we don't have a working account registration page lol, does anyone have a working page for MySQL? Thanks in advance!
|
|
|
06/24/2016, 11:54
|
#2
|
elite*gold: 22
Join Date: Sep 2015
Posts: 951
Received Thanks: 81
|
Register pages doenst matter mssql version at all, and it isnt mysql 
There is alot of releases, even Ultimo posted here some websites and some work of Janvier and you can take from there
|
|
|
06/24/2016, 16:18
|
#3
|
elite*gold: 0
Join Date: Jun 2011
Posts: 415
Received Thanks: 139
|
Ummmm..... the game server database is MSSQL. If you want players to create game accounts then you must use MSSQL.
|
|
|
06/24/2016, 16:49
|
#4
|
elite*gold: 0
Join Date: Jul 2015
Posts: 876
Received Thanks: 258
|
or Oracle SQL (atm i move all data base to Oracle SQL)
|
|
|
06/25/2016, 02:59
|
#5
|
elite*gold: 0
Join Date: Jan 2016
Posts: 10
Received Thanks: 0
|
I upgraded from MSSQL to MYSQL, MSSQL is so vulnerable to attack its junk. We're now using MYSQL 2012 server. Game is running just fine so far, we just don't have a registration page that works with talking to the MYSQL server, my old registration page was for when we were running MSSQL.
|
|
|
06/25/2016, 05:03
|
#6
|
elite*gold: 22
Join Date: Sep 2015
Posts: 951
Received Thanks: 81
|
Good luck with mysql for real
|
|
|
06/25/2016, 17:36
|
#7
|
elite*gold: 0
Join Date: May 2014
Posts: 138
Received Thanks: 92
|
is this what you want? take it if it can help you ^^
I 've done it but I 'm not sure it will work    
anyway, good luck with your job!
You need design user_no column to auto fill
Mysql.php
<?php
$db_host = "localhost";
$db_name = 'account';
$db_username = 'root';
$db_password = '123456';
@  _connect("{$db_host}", "{$db_username}", "{$db_password}") or die("Cant connect database"); @  _select_db("{$db_name}") or die("cant select database");
?>
Register.php
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Register Dekaron</title>
<?php
require_once("mysql.php");
//Check Email
function check_email($email) {
if (strlen($email) == 0) return false;
if (eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$", $email)) return true;
return false;
}
if ( $_GET['act'] == "do" )
{
$username = addslashes( $_POST['username'] );
$password = md5( addslashes( $_POST['password'] ) );
$email = addslashes( $_POST['email'] );
if ( ! $username || ! $_POST['password'] || ! $email)
{
print "Please enter complete information. <a href='javascript:history.go(-1)'>Go back</a>";
exit;
}
// check username
if ( mysql_num_rows(mysql_query("SELECT username FROM user_profile WHERE username='$username'"))>0)
{
print "This username is already taken. <a href='javascript:history.go(-1)'>Go back</a>";
exit;
}
// check email
if (!check_email($email))
{
print "This email is invalid. <a href='javascript:history.go(-1)'>Go back</a>";
exit;
}
// check email
if ( mysql_num_rows(mysql_query("SELECT user_mail FROM user_profile WHERE user_mail='$email'"))>0)
{
print "This email is already taken. <a href='javascript:history.go(-1)'>Go back</a>";
exit;
}
// Start making accounts
@$a=mysql_query("INSERT INTO user_profile (user_id, user_pwd, user_mail) VALUES ('{$username}', '{$password}', '{$email}')");
@$a1=mysql_query("INSERT INTO Tbl_user (user_id, user_pwd, user_mail) VALUES ('{$username}', '{$_POST['password']}', '{$email}')");
// Notifications complete account creation
if ($a)
print "account {$username} has been created. <a href='javascript:history.go(-1)'>Go back</a>";
else
print "There is an error in the application process , please contact with us";
}
else
{
// Form
print <<<EOF
<form action="register.php?act=do" method="post">
<table border="1" width="400" cellspacing="1" style="border-collapse: collapse" bordercolor="#C0C0C0">
<tr>
<td>Account:</td>
<td><input type="text" name="username" value=""></td>
</tr>
<tr>
<td>Password:</td>
<td><input type="password" name="password" value=""></td>
</tr>
<tr>
<td>E-mail:</td>
<td><input type="text" name="email" value=""></td>
</tr>
<tr>
<td><input type="submit" name="submit" value="Create Account"></td>
</tr>
</table>
</form>
EOF;
}
?>
|
|
|
06/26/2016, 03:40
|
#8
|
elite*gold: 0
Join Date: Jun 2011
Posts: 415
Received Thanks: 139
|
Quote:
Originally Posted by Ataxian
I upgraded from MSSQL to MYSQL, MSSQL is so vulnerable to attack its junk. We're now using MYSQL 2012 server. Game is running just fine so far, we just don't have a registration page that works with talking to the MYSQL server, my old registration page was for when we were running MSSQL.
|
Obviously you have no idea how to run, administer and secure MSSQL. MSSQL is 1000% more secure, faster and better than MYSQL. There are millions of hacks for MYSQL. I've been using MSSQL for 15 years. I invite you to do your worst and hack my database! I took down a MYSQL database server in minutes. Hint... the admin username for the database is root!!!
|
|
|
06/26/2016, 04:26
|
#9
|
elite*gold: 0
Join Date: May 2009
Posts: 59
Received Thanks: 22
|
Just to add to the flame, what do you mean MySQL 2012?? haha
Are you talking about you upgraded your mssql 2000 database to 2012?
That's a whole different question and in that case, post the php error you're getting and we can help.
- Zander
|
|
|
06/26/2016, 07:42
|
#10
|
elite*gold: 0
Join Date: Jul 2015
Posts: 876
Received Thanks: 258
|
Quote:
Originally Posted by freez00
Obviously you have no idea how to run, administer and secure MSSQL. MSSQL is 1000% more secure, faster and better than MYSQL. There are millions of hacks for MYSQL. I've been using MSSQL for 15 years. I invite you to do your worst and hack my database! I took down a MYSQL database server in minutes. Hint... the admin username for the database is root!!!
|
every one know the root can be changed to some other name  LoL
|
|
|
 |
Similar Threads
|
[MySQL] Registration page
09/28/2014 - Battle of the Immortals - 0 Replies
Here is simple registration with captcha coded by me, css is not my middle name so sorry for being that ugly i made best i could.
Check: inc/config.php
To setup registration page work as it should.
Preview:
http://i.imgur.com/WMaCcOa.jpg
Download:
|
Hello i need help with a registration for mysql database
11/20/2010 - General Gaming Discussion - 0 Replies
just what the title says i have this new server and i wanna make a site for it for easeir registration
|
Registration Page
08/13/2009 - CO2 Private Server - 0 Replies
I have a php script for a registration page, but it seems it's just missing just a few things in it. Could someone PM me or add me on msn and help me? That way we don't have to have the private conversation in the thread.
|
[HELP] about my registration page
07/12/2009 - CO2 Private Server - 3 Replies
ok i poned port 80 with my computer ip which is sumthing like 192.168.*** and i use my external ip to acces my reg page it works fine on my computer but it doesnt show up to others.. can anyone please tell me whats wrng? and what i have to do.
|
How to fix the registration page?
12/30/2008 - Dekaron Private Server - 3 Replies
nvm. Already fixed it.
|
All times are GMT +1. The time now is 02:21.
|
|