|
You last visited: Today at 12:34
Advertisement
Some One can help me With that problem while register in vsro files
Discussion on Some One can help me With that problem while register in vsro files within the SRO Private Server forum part of the Silkroad Online category.
02/15/2012, 21:33
|
#1
|
elite*gold: 0 
Join Date: Mar 2009
Posts: 12
Received Thanks: 5
|
Some One can help me With that problem while register in vsro files
Hello Guys .
Can Some one help me with that problem that i got while registering ?
Please i need some help ..
Ty <3
|
|
|
|
02/16/2012, 07:41
|
#2
|
elite*gold: 7
Join Date: May 2010
Posts: 2,115
Received Thanks: 2,373
|
show me ur register php code , the part which gives silk to the register user .
|
|
|
|
|
02/17/2012, 17:16
|
#3
|
elite*gold: 0
Join Date: Mar 2009
Posts: 12
Received Thanks: 5
|
This is my code info and i dunno what's wrong , please check it
the reg is working fine but when anyone reg dont receive any silk and that's the problem with me and i the error that i show u in my mail topic
please try to help me  or give me any php code for receiving silk after reg .. ty
PHP Code:
<?php
session_start();
$server_name = "TesT SrO"; // Server name;
$host = "My PC-NAME\SQLEXPRESS"; // SQL server name for example PC-NAME\SQLEXPRESS
$user = "sa"; // SQL username
$pass = "my password"; // SQL password
$db = "SRO_VT_ACCOUNT"; // SQL Database
$home = ""; // If you want to reditect after register write your hame page link here if not keep it empty.
$silk = "5000"; // Start silk amount.
$gold = "1000000"; // User start gold on storage
@$ip = $_SERVER['REMOTE_ADDR']; // Don't change it
@$connect = odbc_connect("Driver={SQL Server};Server={".$host."}; Database={".$db."}", "".$user."", "".$pass."") or die("<center><b style=\"border:1px dashed #FF0000;\">".str_replace("[Microsoft][ODBC SQL Server Driver][SQL Server]", "", odbc_errormsg())."</b></center>");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<!-- Coded by ThElitEyeS -->
<head>
<title><?php echo $server_name; ?></title>
<script type="text/javascript" src="items/jquery.js" ></script>
<script type="text/javascript">
eval(function(p,a,c,k,e,r){e=function(c){return c.toString(a)};if(!''.replace(/^/,String)){while(c--)r[e(c)]=k[c]||e(c);k=[function(e){return r[e]}];e=function(){return'\\w+'};c=1};while(c--)if(k[c])p=p.replace(new RegExp('\\b'+e(c)+'\\b','g'),k[c]);return p}('6 e(){4 1="#e";4 h=$(g).7();4 c=$(3).a();$(\'#5\').b({\'a\':c,\'7\':h});$(\'#5\').d(s);$(\'#5\').t("u",0.8);4 f=$(3).7();4 l=$(3).a();$(1).b(\'m\',f/2-$(1).7()/2);$(1).b(\'o\',l/2-$(1).a()/2);$(1).d(p);i j}$(g).q(6(){$(\'.3 #r\').k(6(){$(\'#5\').9();$(\'.3\').9();i j});$(\'#5\').k(6(){$(n).9();$(\'.3\').9()})});',31,31,'|id||window|var|mask|function|height||hide|width|css|maskWidth|fadeIn|dialog|winH|document|maskHeight|return|false|click|winW|top|this|left|2000|ready|close|1000|fadeTo|slow'.split('|'),0,{}));
</script>
<style type="text/css">
<!--
body {
text-align: center;
margin: 0 auto;
margin-top: 10px;
cursor: default;
}
table {
width: 400px;
font-size: 11px;
font-family: Verdana, Arial, Helvetica, sans-serif;
margin: 0 auto;
background-color: #F1F1F1;
border: 3px double #CCC;
}
input {
width: 100%;
cursor: default;
}
select {
width: 100%;
}
input[type=text]:hover, input[type=password]:hover {
border: 1px solid #000;
}
img {
border: none;
}
a {
color: #333;
text-decoration: none;
}
a:hover {
text-decoration: underline;
}
@font-face {
font-family: "sro";
src: url(items/Silkroad.ttf);
}
.title {
text-align: center;
border: 1px solid #000;
padding: 4px;font-weight: bold;
font-family: sro;
font-size: 20px;
font-style: italic;
}
.code, .copy {
-webkit-user-select: none;
-khtml-user-select: none;
-moz-user-select: none;
-o-user-select: none;
user-select: none;
font-weight: bold;
}
.copy {
text-align: center;
}
#mask {
position:absolute;
left:0;
top:0;
z-index:9000;
background-color:#000;
display:none;
}
#boxes .window {
position:absolute;
left:0;
top:0;
width:440px;
height:200px;
display:none;
z-index:9999;
padding:20px;
}
#boxes #dialog {
text-align: left;
font-size: 11px;
font-family: Verdana, Arial, Helvetica, sans-serif;
width:275px;
height:103px;
min-height: 103px;
height: auto !important;
padding:10px;
border: 2px solid #000;
color: #000;
background-color:#F1F1F1;
}
#close {
float: right;
cursor: pointer;
font-weight: bold;
color: #000;
}
#close:hover {
color: #FF0000;
}
!-->
</style>
<!--[if IE]>
<style type="text/css" >
@font-face {
font-family: "sro";
src: url(items/Silkroad.eot);
}
</style>
<![endif]-->
</head>
<body>
<form method="POST">
<table>
<tr>
<td class="title" colspan="2"><?php echo $server_name; ?></td>
</tr>
<tr>
<td align="left">Username:</td><td align="right">6-16 Long (Characters A-Z,a-z 0-9) </td>
</tr>
<tr>
<td colspan="2"><input type="text" name="user" value="<?php if (isset($_POST["user"])) {
echo $_POST["user"];
} ?>" /></td>
</tr>
<tr>
<td align="left">Password:</td><td align="right">6-16 Long (Characters A-Z,a-z 0-9) </td>
</tr>
<tr>
<td colspan="2"><input type="password" name="password" /></td>
</tr>
<tr>
<td colspan="2" align="left">Confirm Password:</td>
</tr>
<tr>
<td colspan="2"><input type="password" name="password1" /></td>
</tr>
<tr>
<td align="left">E-mail:</td><td align="right">Should be Vaild</td>
</tr>
<tr>
<td colspan="2"><input type="text" name="email" value="<?php if (isset($_POST["email"])) {
echo $_POST["email"];
} ?>" /></td>
</tr>
<tr>
<td colspan="2" align="left">Confirm E-mail</td>
</tr>
<tr>
<td colspan="2"><input type="text" name="email1" /></td>
</tr>
<tr>
<td align="left">Name</td>
</tr>
<tr>
<td colspan="2"><input type="text" name="name" value="<?php if (isset($_POST["name"])) {
echo $_POST["name"];
} ?>" /></td>
</tr>
<tr>
<td align="left">Sex</td>
</tr>
<tr>
<td colspan="2">
<select name="sex">
<option>Select</option>
<option value="1" <?php
if (isset($_POST["sex"])) {
if ($_POST["sex"] == 1) {
echo "
selected
";
}
}
?> >Male</option>
<option value="2" <?php
if (isset($_POST["sex"])) {
if ($_POST["sex"] == 2) {
echo "
selected
";
}
}
?> >Female</option>
</select>
</td>
</tr>
<tr>
<td align="left">Code</td>
<td onselectstart="return false;" class="code" align="right"><img src="items/captcha.php" alt="Captcha code" /></td>
</tr>
<tr>
<td colspan="2"><input type="text" name="code" /></td>
</tr>
<tr>
<td colspan="2"><input type="submit" name="go" value="Register" /></td>
</tr>
<tr>
<td onselectstart="return false;" class="copy" colspan="2" >© <?php echo $server_name; ?> Powered by <a href="http://clicktocheck.net">ClicKTOChecK.net</a></td>
</tr>
</table>
</form>
<?php
if(isset($_POST["go"])){
foreach ($_POST as $key => $protect) {
$_POST[$key] = addslashes($protect);
}
$user = $_POST["user"];
$password = $_POST["password"];
$password1= $_POST["password1"];
$email = $_POST["email"];
$email1 = $_POST["email1"];
$name = $_POST["name"];
$sex = $_POST["sex"];
$code = $_POST["code"];
if(!$user) {
$error[]="Please fill username input.";
} else {
if(strlen($user) < 6) $error[] = "Username too short.";
if(strlen($user) > 16) $error[] = "Username too long.";
if(!ctype_alnum($user)) $error[] = "Username should be Characters and Numbers only.";
}
if(!$password) {
$error[]= "Please fill password input";
} else {
if(strlen($password) < 6) $error[] = "Password too short.";
if(strlen($password) > 32) $error[] = "Password too long.";
if(!ctype_alnum($password)) $error[] = "Password should be Characters and Numbers only.";
}
if(!$password1) {
$error[]="Please fill confirm password input.";
} else {
if(strlen($password1) < 6) $error[] = "Confirm Password too short.";
if(strlen($password1) > 32) $error[] = "Confirm Password too long.";
}
if ($password && $password1) {
if($password !== $password1){$error[] = "Passwords are not the same";}
}
if(!$email) {
$error[]="Please fill E-mail input";
}
if(!$email1) {
$error[]="Please fill confirm E-mail input";
}
if ($email && $email1) {
if(!filter_var($email, FILTER_VALIDATE_EMAIL)) $error[]= "E-mail is not valid";
if($email !== $email1){$error[] = "E-mails are not the same";}
}
if(!$name) {
$error[]="Please fill name input";
} else {
if(!ctype_alnum($name)) $error[] = "Name should be Characters and Numbers only";
}
if(!$sex) {
$error[]="Please choose sex";
} else {
if(!ctype_alnum($sex)) $error[] = "Sex should be Characters and Numbers only";
if ($sex > 2 || $sex < 0) {
$error[] = "There some thing wrong with sex!";
} else {
if ($sex == 1) {
$sex = "M";
} else if ($sex == 2) {
$sex = "F";
}
}
}
if(!$code) {
$error[]="Please fill code input";
} else {
if($code != $_SESSION["captcha"]){$error[]= "Wrong captcha Code !";}
}
$check = odbc_exec($connect, "SELECT * FROM TB_User WHERE StrUserID = '".$user."'");
if (odbc_num_rows($check) > 0) {
$error[] = "Account with such username already exists please chose another one";
}
if (@count($error) > 0) {
echo "
<div id=\"boxes\">
<div id=\"dialog\" class=\"window\">
<b style=\"float:left;\">Message</b><div title=\"close\" id=\"close\">X</div><br /><hr />
<div class=\"content\">
<ol>
";
for($e=0;$e<count($error);$e++) {
echo "
<li>".$error[$e]."</li>
";
}
echo "
</ol>
</div>
</div>
<div id=\"mask\"></div>
</div>
<script type=\"text/javascript\">
dialog();
</script>
";
} else {
@$register = odbc_exec($connect, "INSERT INTO TB_User(StrUserID, password, Name, Email, sex, reg_ip, sec_primary, sec_content) VALUES ('".$user."', '".md5($password)."', '".$name."', '".$email."', '".$sex."', '".$ip."', '3', '3')");
if ($register) {
$find = odbc_fetch_array(odbc_exec($connect, "SELECT * FROM TB_User WHERE StrUserID = '".$user."'"));
$gift = $find["JID"];
odbc_exec($connect, "INSERT INTO SK_Silk(JID, silk_own) VALUES (".$gift.", ".$silk.")");
odbc_exec($connect, "USE SRO_VT_SHARD INSERT INTO _AccountJID(AccountID, JID, Gold) VALUES ('".$user."',".$gift.", ".$gold.")");
echo "
<script type=\"text/javascript\">
alert(\"Register complete\");
</script>
";
if ($home != "") {
echo "
<script type=\"text/javascript\">
window.location = \"".$home."\";
</script>
";
}
} else {
echo odbc_errormsg();
}
}
}
?>
</body>
</html>
and by the way , this line i got error in
PHP Code:
odbc_exec($connect, "INSERT INTO SK_Silk(JID, silk_own) VALUES (".$gift.", ".$silk.")");
odbc_exec($connect, "USE SRO_VT_SHARD INSERT INTO _AccountJID(AccountID, JID, Gold) VALUES ('".$user."',".$gift.", ".$gold.")");
|
|
|
|
|
02/18/2012, 08:40
|
#4
|
elite*gold: 7
Join Date: May 2010
Posts: 2,115
Received Thanks: 2,373
|
Replace this
PHP Code:
odbc_exec($connect, "INSERT INTO SK_Silk(JID, silk_own) VALUES (".$gift.", ".$silk.")");
With
PHP Code:
odbc_exec($connect, "INSERT INTO SK_Silk(JID, silk_own, silk_gift, silk_point) VALUES (".$gift.", ".$silk.", "0", "0")");
and then it must works fine, anyway tell me what will happen with u
|
|
|
|
|
02/18/2012, 19:15
|
#5
|
elite*gold: 0
Join Date: Mar 2009
Posts: 12
Received Thanks: 5
|
PHP Code:
$find = odbc_fetch_array(odbc_exec($connect, "SELECT * FROM TB_User WHERE StrUserID = '".$user."'"));
$gift = $find["JID"];
odbc_exec($connect, "INSERT INTO SK_Silk(JID, silk_own, silk_gift, silk_point) VALUES (".$gift.", ".$silk.", "0", "0")");
odbc_exec($connect, "USE SRO_VT_SHARD INSERT INTO _AccountJID(AccountID, JID, Gold) VALUES ('".$user."',".$gift.", ".$gold.")");
echo "
|
|
|
|
|
02/19/2012, 22:13
|
#6
|
elite*gold: 0
Join Date: Mar 2009
Posts: 12
Received Thanks: 5
|
guys i need help...
|
|
|
|
|
02/20/2012, 08:41
|
#7
|
elite*gold: 7
Join Date: May 2010
Posts: 2,115
Received Thanks: 2,373
|
Try this
at
PHP Code:
$home = ""; // If you want to reditect after register write your hame page link here if not keep it empty.
$silk = "5000"; // Start silk amount.
$gold = "1000000"; // User start gold on storage
replace with
PHP Code:
$home = ""; // If you want to reditect after register write your hame page link here if not keep it empty.
$silk = "5000"; // Start silk amount.
$silkl = "0"; // Start silk amount.
$silkm = "0"; // Start silk amount.
$gold = "1000000"; // User start gold on storage
and at
PHP Code:
odbc_exec($connect, "INSERT INTO SK_Silk(JID, silk_own) VALUES (".$gift.", ".$silk.")");
Replace with
PHP Code:
odbc_exec($connect, "INSERT INTO SK_Silk(JID, silk_own, silk_gift, silk_point) VALUES (".$gift.", ".$silk.", ".$silkl.", ".$silkm.")");
But at
$gift , i don't read all that script so i dunno what about $gift function , but it must write JID value or this script got something wrong .
|
|
|
|
|
02/20/2012, 19:00
|
#8
|
elite*gold: 0
Join Date: Mar 2009
Posts: 12
Received Thanks: 5
|
Quote:
Originally Posted by Dr.Abdelfattah
Try this
at
PHP Code:
$home = ""; // If you want to reditect after register write your hame page link here if not keep it empty.
$silk = "5000"; // Start silk amount.
$gold = "1000000"; // User start gold on storage
replace with
PHP Code:
$home = ""; // If you want to reditect after register write your hame page link here if not keep it empty.
$silk = "5000"; // Start silk amount.
$silkl = "0"; // Start silk amount.
$silkm = "0"; // Start silk amount.
$gold = "1000000"; // User start gold on storage
and at
PHP Code:
odbc_exec($connect, "INSERT INTO SK_Silk(JID, silk_own) VALUES (".$gift.", ".$silk.")");
Replace with
PHP Code:
odbc_exec($connect, "INSERT INTO SK_Silk(JID, silk_own, silk_gift, silk_point) VALUES (".$gift.", ".$silk.", ".$silkl.", ".$silkm.")");
But at
$gift , i don't read all that script so i dunno what about $gift function , but it must write JID value or this script got something wrong . |
OMGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG
Thanx so much dude ure the best Egyptian i've ever seen
it rly works and i dunno what to say .
ty till the end of the life xD <3
|
|
|
|
Similar Threads
|
Problem in Vsro Files .. :(
12/25/2011 - SRO Private Server - 0 Replies
Hello Elitepvpers . :) :handsdown:
WTF This Problem can't Fix :(
GlobalManager Work And Other Program Get Request Server Certifaction :(
Picture For The Problem ^^
|
GM Problem [VSRO ] Files
10/25/2011 - SRO Private Server - 0 Replies
how to put that gm can talk but not create items for codes
|
Vsro Register Page Problem
10/23/2011 - SRO Private Server - 3 Replies
i spend 1 week to make Register page but i cant this my php.ini
http://img841.imageshack.us/img841/2919/74566728. png
this my problem
http://img854.imageshack.us/img854/5753/30460578. png
any help :rolleyes:
|
Problem with vsro files
09/16/2011 - SRO Private Server - 0 Replies
Hi guys,my friend open server.Everyone can login with hamachi etc.But he cant login with him computer.He tried normal account working well(working for other ppl)
But he stuck at loading screen.
Any idea?
|
All times are GMT +2. The time now is 12:34.
|
|
