You last visited: Today at 12:10
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?
11/17/2010, 21:16
#394
elite*gold: 0
Join Date: Nov 2009
Posts: 1,516
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
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
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,516
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,516
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
[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 +2. The time now is 12:10 .
(
