Vsro files reg page free silk fo a new acc

schertz · 11/16/2011, 03:28

I would be happy if the people who have to register or vote on my page to get free silk ..

one knows what I must do?

ich möchte gerne das wenn die leute sich auf meiner seite regestrieren oder voten free silk bekommen..

weiss einer was ich da machen muss ?

Thx

push ... need help

_P_auf_K_ · 11/16/2011, 20:40

Probier das mal:

DB öffnen
SRO_SHARD_DB -> Programmability -> Stored Procedures -> [dbo].[_AddNewChar
Rechtsklick -> Modify
Dann einfach einen neuen Code einfügen
z.B

Quote:

Update SRO_ACCOUNT_DB.dbo.SK_Silk SET silk_own = '50000' where UserJID = @UserJID

Dann auf "Execute" klicken.

Oder Probier den PhP-Script von eLo21

Quote:

Originally Posted by ✗EpicSoul✗

Try this..

PHP Code:

<?php require_once('_inc/security.class.php'); require_once('_inc/config.php'); if(!isset($_POST['submit'])) { echo "<table border='1'> <form method='post'> <td>Username</td><td><input type='text' name='username' maxlength='16'></td><tr/> <td>Password[1]</td><td><input type='password' name='pw1' maxlength='32'></td><tr/> <td>Password[2]</td><td><input type='password' name='pw2' maxlength='32'></td><tr/> <td></td><td><input type='submit' name='submit' value='Register'></td> </form> </table>"; } else { if(strlen($_POST['username']) < 3) $msg[] = "Username too short"; if(strlen($_POST['username']) > 16)$msg[] = "Username too long"; if(strlen($_POST['pw1']) < 6) $msg[] = "Password [1] too short"; if(strlen($_POST['pw1']) > 32)$msg[] = "Password [1] too long"; if(strlen($_POST['pw2']) < 6) $msg[] = "Password [2] too short"; if(strlen($_POST['pw']) > 32) $msg[] = "Password [2] too long"; if($_POST['pw1'] != $_POST['pw2']) $msg[] = "Passwords are not the same"; $sec = new security(); if($sec->is_secure($_POST['username']) == false) $msg[] = "Username contains forbidden symbols"; if($sec->is_secure($_POST['pw1']) == false) $msg[] = "Password [1] contains forbidden symbols"; if($sec->is_secure($_POST['pw2']) == false) $msg[] = "Password [2] contains forbidden symbols"; if(count($msg) > 0) { for($i = 0; $i < count($msg); $i++) { echo $msg[$i]."<br/>"; } return; } else { //checking damn mssql stuff $accountExists = mssql_num_rows(mssql_query("select StrUserID from TB_User where StrUserID='$_POST[username]'")); if($accountExists > 0) echo "Account with such username already exists<br/>"; else { $pwd = md5($_POST['pw1']); mssql_query("insert into TB_User(StrUserID,password,sec_primary,sec_seconda ry) values('$_POST[username]','$pwd','3','3')"); echo "Account successfully created<br/>"; $sql = mssql_query("SELECT * FROM TB_User WHERE StrUserId='$_POST[username]'"); $row = mssql_fetch_array($sql); $silk = mssql_query("INSERT INTO SK_Silk(JID,silk_own,silk_gift,silk_point) VALUES ('$row[JID]','SILK VALUE HERE','4000','0'); } } } ?>

In der letzten Zeile einfach die "4000" mit dem gewünschten Silkbetrag ändern.

Wenn du noch Fragen haben solltest schreib mich mal an =D

CyCu90 · 11/19/2011, 11:08

<?php
include("config.php");
$connect = odbc_connect("Driver={SQL Server};Server={$host}; Database={$dbname}", $user, $pass) or die("Can't connect the MSSQL server.");

?>
<html>
<head>
<title>Silkroad Registration</title>
<link rel="stylesheet" href="css/style2.css" type="text/css" media="screen" />
<link rel="stylesheet" href="css/stylesheet.css" type="text/css" media="screen" />
</head>
<body>
<div align="center" style="position:absolute; top:10px; z-index:0;">
<img src="images/bg6.png" border='0'>

</div>
<div class="reg" style="position:relative; top:222px; left:300px;">
<div style="position:relative; top:-28px; left:11px;">
<center><table width='350'>
<form action='reg.php?act=regis' method='POST'>
<tr>
<td><b><font size="5" color="white">SROFactory Rej.</font></b></td><br><br>
</tr>
<tr>
</tr>
<tr>
<td width='50px'><font color=red><input value='Nazwa uzytkownika*' type='text' name='username'></td></font>
</tr>
<tr>
<td width='50px'><input value='Hasło*' type='password' name='password'></td>
</tr>
<tr>
<td width='50px'><input value='Nick w grze*' type='text' name='playername'></td>
</tr>
<tr>
<td width='50px'><input value='E-Mail*' type='text' name='email'></td>
</tr>
<tr>
<td width='50px'><input type='submit' value='Akceptuje'></td>
</tr>
</table>
</center>
<div style="position:relative; top:-30px; left:135px;">
<a href="recover.php">Zapomniales ID/Haslo?</a>
</div>
</div>
</div>
<center>
<?php
$ip = ($_SERVER['REMOTE_ADDR']);

if (isset($_GET['act']) AND $_GET['act'] == "regis")
{
$regdate = date("Y-m-d H:i:s");

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;
}
$username=anti_injection($_POST['username']);
$password=md5($_POST['password']);
$password2=anti_injection($_POST['password']);
$playername=anti_injection($_POST['playername']);
$email=anti_injection($_POST['email']);
if (!$_POST['username'] )
{
echo "<script>alert('Username is empty');location.href='reg.php';</script>";
die();
}
else
if (!$_POST['password'] )
{
echo "<script>alert('Password is empty');location.href='reg.php';</script>";
die();
}
else
if (!$_POST['playername'] )
{
echo "<script>alert('player name is empty');location.href='reg.php';</script>";
die();
}
else
if (!$_POST['email'] )
{
echo "<script>alert('E-Mail is empty');location.href='reg.php';</script>";
die();
}

$query = odbc_exec($connect, "SELECT StrUserID FROM TB_User WHERE StrUserID = '$username'");

$existing_users = odbc_num_rows($query);
if($existing_users != 0) {

echo "<script>alert('Username already taken!');location.href='reg.php';</script>";
die();
} else

odbc_exec($connect, "INSERT INTO TB_User (StrUserID, password, Name, Email, sec_primary, sec_content, AccPlayTime, LatestUpdateTime_ToPlayTime) VALUES

('$username', '$password', '$playername', '$email', '3', '3', '0', '0')");

echo "<script>alert('Account Registration Successful! \\nUsername: $username \\nPassword: $password2');location.href='$index';</script>";

}

?>
<br/>
</center>
</body>
<table bgcolor="black">
<tr>
<td>
Created by Aznkidd235
</td>
</tr>
</table>
</html>

And where i must add you code ?