how can i make Auto Silk to new user
Printable View
how can i make Auto Silk to new user
Quote:
Originally Posted by Oventiful
PHP Code:<?php
session_start();
$server_name = "registro"; // Server name;
$host = "YOUPC-PC\SQLEXPRESS"; // SQL server name for example PC-NAME\SQLEXPRESS
$user = "sa"; // SQL username
$pass = "PW"; // 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 = "10000"; // Start silk amount.
$gold = "100000000"; // 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>
<!--[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"><font size=9><font color="red"><p>Silkroad</p></td>
</tr>
<tr>
<td align="left"><font color="white">Username:</td><td align="right"><font color="white">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"><font color="white">Password:</td><td align="right"><font color="white">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"><font color="white">Confirm Password:</td>
</tr>
<tr>
<td colspan="2"><input type="password" name="password1" /></td>
</tr>
<tr>
<td align="left"><font color="white">E-mail:</td><td align="right"><font color="white">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"><font color="white">Confirm E-mail</td>
</tr>
<tr>
<td colspan="2"><input type="text" name="email1" /></td>
</tr>
<tr>
<td align="left"><font color="white">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"><font color="white">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"><font color="white">Codigo</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" ><font color="white">© Sro <font color="white"> by <a href="index.php"></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();
}
}
}
?>