|
You last visited: Today at 22:57
Advertisement
The Arcane Troubleshooting Thread
Discussion on The Arcane Troubleshooting Thread within the SRO Coding Corner forum part of the Silkroad Online category.
11/17/2010, 00:54
|
#391
|
elite*gold: 0 
Join Date: Feb 2009
Posts: 118
Received Thanks: 62
|
I'm having some problems with my register page. I tried recoding it myself a bit, but I had the same problem with those codes too.
Index.php
Code:
<?php include("Register.php"); ?>
<style type="text/css">
<!--
body,td,th {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #FFFFFF;
}
body {
background-color: #000000;
}
-->
</style>
<html>
<form action='Register.php' method='POST'>
<center>
<table width="500">
<tr>
<td bgcolor="#333333">Username:</td>
<td bgcolor="#333333">
<input type='text' name='accname' maxlength='12'>
</td>
</tr>
<tr>
<td bgcolor="#666666">Password:</td>
<td bgcolor="#666666">
<input type='password' name='accpass1' maxlength='12'>
</td>
</tr>
<tr>
<td bgcolor="#333333">Restate Password:</td>
<td bgcolor="#333333">
<input type='password' name='accpass2' maxlength='12'>
</td>
</tr>
<tr>
<td align='center' bgcolor="#666666">
</td>
<td align='left' bgcolor="#666666">
<input type='hidden' name='activ' value='1' />
<input name="submit" type='submit' value='Register' />
</td>
</tr>
</table>
</center>
</form>
</html>
<?php
}
?>
Register.php
Code:
<?php include("Index.php"); ?>
<style type="text/css">
<!--
body,td,th {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #FFFFFF;
}
body {
background-color: #000000;
}
-->
</style>
<?php
$mssql = array(
'host' = "Censored"
'user' = "Censored"
'pass' = "Censored"
);
function anti_injection($sql) {
$sql = preg_replace(sql_regcase("/(from|select|insert|delete|where|drop table|show tables|#|\*|--|\\\\)/"),"",$sql);
$sql = trim($sql);
$sql = strip_tags($sql);
$sql = addslashes($sql);
return $sql;
}
if($_POST['activ'] == '1') {
$accname = anti_injection($_POST['accname']);
$accpass1 = anti_injection($_POST['accpass1']);
$accpass2 = anti_injection($_POST['accpass2']);
$con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
$result1 = mssql_query("SELECT * FROM Censored.dbo.users WHERE id = '".$accname."'",$con);
$row1 = mssql_num_rows($result1);
if(empty($accname)||empty($accpass1)||empty($accpass2){
echo "Please fill out all the fields!";
}
else {
$accpass = md5($accpass1);
$con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
mssql_query("INSERT INTO Censored.dbo.users (
id,
password,
online,
unknown,
unknown2,
silk,
gold
)
VALUES (
'".$accname."',
'".$accpass."',
'0',
'0',
'0',
'0',
'0'
)",$con);
}
}
else {
$con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
$result1 = mssql_query("SELECT * FROM Censored.dbo.users",$con);
$row1 = mssql_num_rows($result1);
?>
Echoes don't work, and it doesn't register.
|
|
|
|
11/17/2010, 16:03
|
#392
|
elite*gold: 0
Join Date: Jun 2009
Posts: 498
Received Thanks: 86
|
Hot To make Server Work witho out Hamachi?~!
|
|
|
|
|
11/17/2010, 18:42
|
#393
|
elite*gold: 0
Join Date: Feb 2009
Posts: 6
Received Thanks: 0
|
im having truble with the reg page, i have error in line 9, i have done lots of guides,someone can help me via team viewer?
thx
|
|
|
|
|
11/17/2010, 21:16
|
#394
|
elite*gold: 0
Join Date: Nov 2009
Posts: 1,515
Received Thanks: 891
|
Quote:
Originally Posted by rofman2008
Hot To make Server Work witho out Hamachi?~!
|
ftp server (recommended)
or port in yr router
|
|
|
|
|
11/18/2010, 08:11
|
#395
|
elite*gold: 0
Join Date: Aug 2009
Posts: 52
Received Thanks: 5
|
Need Help  (
|
|
|
|
|
11/18/2010, 11:57
|
#396
|
elite*gold: 0
Join Date: Feb 2008
Posts: 3,777
Received Thanks: 1,455
|
Quote:
Originally Posted by deli50
Need Help (
|
U should put same password that you put in sa user
not in 1 , 1234 and another 1 , 123456
|
|
|
|
|
11/18/2010, 14:02
|
#397
|
elite*gold: 0
Join Date: May 2007
Posts: 68
Received Thanks: 6
|
where download the loader for the game???? i have all on i dont have the loader what loader use? where download the loader?
|
|
|
|
|
11/18/2010, 14:18
|
#398
|
elite*gold: 0
Join Date: Jun 2009
Posts: 498
Received Thanks: 86
|
Well...
That happened when I Chrated an Eu Char In Rev93
|
|
|
|
|
11/18/2010, 15:08
|
#399
|
elite*gold: 0
Join Date: May 2007
Posts: 68
Received Thanks: 6
|
i always get C5 error when i try to connect= Solution= With out look ur "user" table i can tell u ur password is not md5
so change it to 21232F297A57A5A743894A0E4A801FC3 its mean "admin"
but how this is done and where exactly? is a mess ... taking encuenta there are people who is 33 and has no idea of sql, please help!
|
|
|
|
|
11/18/2010, 15:16
|
#400
|
elite*gold: 0
Join Date: Feb 2008
Posts: 3,777
Received Thanks: 1,455
|
Quote:
Originally Posted by tjmarine
i always get C5 error when i try to connect= Solution= With out look ur "user" table i can tell u ur password is not md5
so change it to 21232F297A57A5A743894A0E4A801FC3 its mean "admin"
but how this is done and where exactly? is a mess ... taking encuenta there are people who is 33 and has no idea of sql, please help!
|
this is dbo.users table
you do open table
then Id: test
Pw : 21232F297A57A5A743894A0E4A801FC3
|
|
|
|
|
11/18/2010, 15:37
|
#401
|
elite*gold: 0
Join Date: Nov 2009
Posts: 1,515
Received Thanks: 891
|
Quote:
Originally Posted by rofman2008
Well...
That happened when I Chrated an Eu Char In Rev93
|
+1 i have the same problem 
and chinees
BS i can't login ?!
|
|
|
|
|
11/18/2010, 15:53
|
#402
|
elite*gold: 0
Join Date: May 2007
Posts: 68
Received Thanks: 6
|
ok, error c5 fix ... but now give me error c9, to login in game!!
|
|
|
|
|
11/18/2010, 15:58
|
#403
|
elite*gold: 0
Join Date: Feb 2008
Posts: 3,777
Received Thanks: 1,455
|
Quote:
Originally Posted by tjmarine
ok, error c5 fix ... but now give me error c9, to login in game!!
|
C9 mean game is off
try to port forward your router
|
|
|
|
|
11/18/2010, 16:13
|
#404
|
elite*gold: 0
Join Date: May 2007
Posts: 68
Received Thanks: 6
|
ok c9 error is fix in the table db.server the port is 15780.. i login and stay in the game playing now, but.. i have lag in my server! and give me dc... this can be fixed? There is no way to update or improve in some way or rather the server database? thank you very much!
|
|
|
|
|
11/18/2010, 16:25
|
#405
|
elite*gold: 0
Join Date: Nov 2009
Posts: 1,515
Received Thanks: 891
|
Quote:
Originally Posted by tjmarine
ok c9 error is fix in the table db.server the port is 15780.. i login and stay in the game playing now, but.. i have lag in my server! and give me dc... this can be fixed? There is no way to update or improve in some way or rather the server database? thank you very much!
|
just use yr local ip it will be more faster
127.0.0.1 port 15779
in the server table ip 15780
|
|
|
|
Similar Threads
|
[C#]The Arcane Development Thread
10/25/2011 - SRO Coding Corner - 250 Replies
TALK HERE IF YOU CAN NOT PROGRAM!:
http://www.elitepvpers.com/forum/sro-coding-corner /807716-arcane-troubleshooting-thread.html
______________________________
First of all thanks: Thanks to chea77er for leaking it and to Miki_Maus for contributing the related client.
So....
Why did I open that thread?
|
All times are GMT +1. The time now is 22:58.
|
|
