|
You last visited: Today at 00:36
Advertisement
Help Creating Accounts on my Hamachi server
Discussion on Help Creating Accounts on my Hamachi server within the Dekaron Private Server forum part of the Dekaron category.
03/20/2009, 05:39
|
#1
|
elite*gold: 0
Join Date: Nov 2008
Posts: 9
Received Thanks: 2
|
Help Creating Accounts on my Hamachi server
How would i go about making accounts for people on my Hamachi Server any help would be appreacited.
|
|
|
03/20/2009, 11:54
|
#2
|
elite*gold: 0
Join Date: May 2008
Posts: 215
Received Thanks: 39
|
Istall apache btw xampp with Apache and write a little register page.
the users can use than the hamachi ip to register , example :
Code:
<?php
$mssql = array(
'host' => "127.0.0.1",
'user' => "sa",
'pass' => "currentPassword"
);
echo "<center>";
if($_POST['activ'] == '1') {
$con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']) or die("Verbinndung zum MSSQL Server fehlgeschlagen,bitte zu einem späteren zeitpunkt erneut probieren.");
$result1 = mssql_query("SELECT * FROM account.dbo.USER_PROFILE WHERE user_id = '".$_POST['accname']."'",$con);
$result2 = mssql_query("SELECT * FROM account.dbo.Tbl_user WHERE user_id = '".$_POST['accname']."'",$con);
$result3 = mssql_query("SELECT * FROM account.dbo.Tbl_user WHERE user_mail = '".$_POST['accmail']."'",$con);
$row1 = mssql_num_rows($result1);
$row2 = mssql_num_rows($result2);
$row3 = mssql_num_rows($result3);
if(empty($_POST['accname']) || empty($_POST['accpass1']) || empty($_POST['accpass2']) || empty($_POST['accquest']) || empty($_POST['accname']) || empty($_POST['accansw']) || empty($_POST['accmail']) || empty($_POST['result1'])) {
echo "Du hast nicht alle felder ausgefüllt. Bitte gehe zurück und hol dieses nach.";
} elseif($row1 > '0' || $row2 > '0') {
echo "Der von dir gewünschte Accountname existiert bereits.";
} elseif($row3 > '0') {
echo "Die angegebene E-Mail Adresse wurde bereits schon verwendet.";
} elseif($_POST['accpass1'] != $_POST['accpass2']) {
echo "Die von dir angegebenen Passwörter sind nicht Identisch.";
} elseif($_POST['accpass1'] == $_POST['accname']) {
echo "Der Accountname und das Passwort dürfen nicht das gleiche sein.";
} elseif(!preg_match("/^[0-9a-zA-Z]{6,12}$/i", $_POST['accname'])) {
echo "In deinem Accountnamen sind nicht erlaubte sonderzeichen erhalten.";
} elseif(!preg_match("/^[0-9a-zA-Z]{6,12}$/i", $_POST['accpass1'])) {
echo "Dein Passwort enthält sonderzeichen welche nicht erlaubt sind im Passwort.";
} elseif(!preg_match("/^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$/i",$_POST['accmail'])) {
echo "Du hast keine gültige E-Mail addresse angegeben.";
} elseif(strlen($_POST['accname']) < 6 || strlen($_POST['accname']) > 12) {
echo "Dein Accountname muss mindestens 6 Zeichen lang sein und darf maximal 12 zeichen lang sein.";
} elseif(strlen($_POST['accpass1']) < 6 || strlen($_POST['accpass1']) > 12) {
echo "Dein Passwort muss mindestens 6 Zeichen lang sein und darf maximal 12 zeichen lang sein.";
} elseif(strlen($_POST['accquest']) < 10 || strlen($_POST['accquest']) > 20) {
echo "Die Geheim Frage muss mindestens 10 zeichen lang sein und darf dabei nicht länger als 20 zeichen sein.";
} elseif(strlen($_POST['accansw']) < 10 || strlen($_POST['accansw']) > 20) {
echo "Die Geheim Antwort muss mindestens 10 zeichen lang sein und darf dabei nicht länger als 20 zeichen sein.";
} elseif($_POST['result1'] != $_POST['result2']) {
echo "Die Sicherheits Rechnung ist falsch.";
} else {
$accpass = md5($_POST['accpass1']);
$date = date("m/d/Y H:i:s",time());
$result = mssql_query("SELECT user_no FROM account.dbo.USER_PROFILE ORDER BY user_no DESC",$con);
$row = mssql_fetch_row($result);
$row[0] = $row[0]+1;
mssql_query("INSERT INTO account.dbo.USER_PROFILE (user_no,user_id,user_pwd,resident_no,user_type,login_flag,login_tag,ipt_time,login_time,logout_time,user_ip_addr,server_id) VALUES ('".$row[0]."','".$_POST['accname']."','".$accpass."','801011000000','1','0','Y','".$date."',null,null,null,'000')",$con);
mssql_query("INSERT INTO account.dbo.Tbl_user (user_no,user_id,user_pwd,user_mail,user_answer,user_question) VALUES ('".$row[0]."','".$_POST['accname']."','".$_POST['accpass1']."','".$_POST['accmail']."','".$_POST['accquest']."','".$_POST['accansw']."')",$con);
echo "Der Account wurde erfolgreich erstellt. Viel Spass auf dem Server.";
}
} else {
$count1 = rand(1,49);
$count2 = rand(1,49);
$result2 = $count1+$count2;
echo "<form action='".$_SEVER['PHP_SELF']."' method='POST'>";
echo "<center><table>";
echo "<tr><td colspan='2' align='center'><b><u>Deine gewünschten Game Account Daten</u></b></td></tr>";
echo "<tr><td>Game Name :</td><td><input type='text' name='accname' maxlength='12' class='input'></td></tr>";
echo "<tr><td>Game Passwort :</td><td><input type='password' name='accpass1' maxlength='12' class='input'></td></tr>";
echo "<tr><td>wiederh. Passwort :</td><td><input type='password' name='accpass2' maxlength='12' class='input'></td></tr>";
echo "<tr><td> </td><td> </td></tr>";
echo "<tr><td colspan='2' align='center'><b><u>Sonder Account Daten</u></b></td></tr>";
echo "<tr><td>E-Mail :</td><td><input type='text' name='accmail' maxlength='50' class='input'></td></tr>";
echo "<tr><td>geheim Frage :</td><td><input type='text' name='accquest' maxlength='20' class='input'></td></tr>";
echo "<tr><td>geheim Antwort :</td><td><input type='text' name='accansw' maxlength='20' class='input'></td></tr>";
echo "<tr><td> </td><td> </td></tr>";
echo "<tr><td colspan='2' align='center'><b><u>Sicherheits Rechnung</u></b></td></tr>";
echo "<td align='center'><font color='#FF0000'><b>".$count1."</b></font> + <font color='#FF0000'><b>".$count2."</b></font> =</td>";
echo "<td><input type='text' name='result1' maxlength='2' class='input'></td>";
echo "<tr><td> </td><td> </td></tr>";
echo "<tr><td colspan='2' align='center'>
<input type='hidden' name='result2' value='".$result2."'>
<input type='hidden' name='activ' value='1'>
<input type='submit' value='Account erstellen' class='input'></td></tr>";
echo "</table></center>";
echo "</form>";
}
echo "</center>";
?>
|
|
|
|
Similar Threads
|
SOS on Creating Own Server
12/05/2010 - Ragnarok Online PServer Hosting - 4 Replies
HELP~~~~
Do anyone know how to Create a RO Private Server??
I'm using window 7, can i do it?
don't know why i can't connect to mysql server, maybe is the port forward setting.
Please help.:handsdown::handsdown::handsdown:
|
Creating Accounts
05/05/2010 - Shaiya - 4 Replies
Hi, i have problem with creating account. I dont know whats happend but after done my prov server i created 3 accounts + 2 accounts was at start.
now all accounts which i create are OK but in DB, game dont see them, still error "account doesnt exist" or "invalid ID and password"
How can i fix it?
PS: I created accounts in dbo.GameAccountTBL.
Thanks
|
[Search] Coder that likes to help creating a Hamachi Co 5017 server
10/14/2009 - CO2 Private Server - 0 Replies
Hey guys i don't know if this is the right section.
But I'm searching for someone woh can hlep me or teach me some simple coding for my private server that i jsut set up.
I'm new with it and i jsut got 1 erson helping so far also not a coder.
Prefer europe people couse of the day time we wil lbe more often on together ;)
thnx and srry if i place it in the wrong section ^^
|
Need good TuT for creating accounts.
01/10/2009 - Dekaron Private Server - 0 Replies
Hi
i need a good TuT/VideoTUT for creating accounts direct in Enterprise Manager.
I download a Video but whats it show doesnt work. He alwas say Incorrect ID.
|
Creating New Accounts. Hang?
11/24/2008 - Dekaron - 2 Replies
Hey people i was wondering if any of you have created any accounts recently? Because when i try to create a new account, it just hangs at the screen after i press register and it stays there. Anyone knows how to fix this problem?
|
All times are GMT +2. The time now is 00:36.
|
|