1º. Crie a página colocar_box.php
Código: [pre]<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<div style="background-color:#CDDDF6; filter:alpha(Opacity=90); width: 200px; height: 35px; border: 2 solid black; padding:3px">
<?PHP include("configg.php"); ?>
<form name="form1" method="post" action="colocar_box2.php">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="10">
Login:
</td>
<td colspan="2">
<input name="login" type="text" id="login" maxlength="10" />
</td>
</tr>
<tr>
<td height="10">
Senha:
</td>
<td colspan="2">
<input name="oldpwd" type="password" id="oldpwd" maxlength="10" />
</td>
</tr>
<tr>
<td colspan="2">
<input type="submit" name="Submit" value="Enviar" />
</td>
</tr>
</table>
</form>
</div>
</body>
</html>[/pre] Crie a 2º pagina colocar_box2.php
Código: [pre]<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<div align="center">
<center>
<?
include("configg.php");
if (!$char)
{
$login = stripslashes($_POST['login']);
$oldpwd = stripslashes($_POST['oldpwd']);
$sql_username_check = mssql_query("SELECT memb___id FROM MEMB_INFO WHERE memb___id='$login'");
$username_check = mssql_num_rows($sql_username_check);
$sql_pw_check = mssql_query("SELECT memb__pwd FROM MEMB_INFO WHERE memb__pwd='$oldpwd' and memb___id='$login'");
$pw_check = mssql_num_rows($sql_pw_check);
$sql_char_check = mssql_query("SELECT Name FROM Character WHERE AccountID = '$login' and ctlcode>7");
$char_check = mssql_num_rows($sql_char_check);
if ($username_check <= 0)
{
echo "<font color=#006699>Seu login não existe em nosso banco de dados.<br>";
}
elseif ($pw_check <= 0)
{
echo "<font color=#006699>Senha incorreta.<br>";
}
elseif ($char_check <= 0)
{
echo "<br><br><font color=red>Você não é GM.";
}
else
{
setcookie("login3", "$login", time()+7257600);
setcookie("oldpwd3", "$oldpwd", time()+7257600);
?>
<br><b>Colocar Box no bau?</b>
<form name='form1' method='post' action='?char=char&add=ok'>
<table border='0' width='366'>
<tr>
<td colspan='2'>
<input type='submit' name='Submit' value='Colocar'>
</td>
</tr>
</table>
<br><font color=red>IMPORTANTE: <font color=black>Tudo o que estiver no baú será trocado pelas kunduns. Tirem o que vocês acharem necessário!! depois não venham reclamar!!!<br>
<?php
}
elseif ($char)
{
if ($char && $add == 'ok')
{
if ((!isset($_COOKIE["login3"])) || (!isset($_COOKIE["oldpwd3"])))
{
die("<center><font color=#006699><br><BR>ACESSO NEGADO");
}
if ((isset($_COOKIE["login3"])) && (isset($_COOKIE["oldpwd3"])))
{
$login2 = $_COOKIE["login3"];
$oldpwd2 = $_COOKIE["oldpwd3"];
$sql_char_check = mssql_query("SELECT Name FROM Character WHERE AccountID = '$login2' and ctlcode>7");
$char_check = mssql_num_rows($sql_char_check);
$VIP = "Select ConnectStat FROM MEMB_STAT WHERE memb___id='$login2'";
$VIP2 = mssql_query( $VIP );
$VIP3 = mssql_fetch_row($VIP2);
$sql_pw_check = mssql_query("SELECT memb__pwd FROM MEMB_INFO WHERE memb__pwd='$oldpwd2' and memb___id='$login2'"); $pw_check = mssql_num_rows($sql_pw_check);
$sql_username_check = mssql_query("SELECT memb___id FROM MEMB_INFO WHERE memb___id='$login2'");
$username_check = mssql_num_rows($sql_username_check);
if ($username_check <= 0)
{
echo "<bR><center><font color='red'>Seu login nao existem em nosso banco de dados.<br>";
}
elseif ($char_check <= 0)
{
echo "<br><br><br><font color=red>Você não é GM.";
}
elseif ($pw_check <= 0)
{
echo "<center><font color=#006699>Senha incorreta.<br>";
}
elseif ($VIP3[0] == 1)
{
echo "<bR><center><font color='#325784'>Você está online. Saia do jogo e tente novamente.<br>";
}
else
{
$result= mssql_query("DISTRIBUIR_KUNDUNS ".$login2."");
echo "<br><br><b>AS Kunduns Estão no seu baú, <br><br>Mais não é pra ir jogando na cidade igual um condenado ein!^^<br><BR><BR>";
}
}
}
}
?>
</div>
</body>
</html>[/pre] E finalmente crie a 3º pagina configg.php
Código: [pre]<?php
//by louis
//www.muonlinebr.com ..
$ip_user = getenv('REMOTE_ADDR');
$badwords = array(";", "'", "=", "\"", "+", "*", "union", "del", "DEL", "insert", "update", "drop", "sele", "$", "UPDATE", "Set", "SET");
foreach($_POST as $value)
foreach($badwords as $word)
if(substr_count($value, $word) > 0) die("Segurança Ativada!<br />Simbolos utilizandos invalidos! Seu ip é ->" .$ip_user);
// Coloque o IP da DB
$dbhost = "127.0.0.1";
// Usuario da DB
$dbuser = "sa";
// Senha
$dbpasswd = "sua senha do sql";
//Login ADM
$alogin = "Leostyles";
//Senha ADM
$apass = "sua senha do sql";
//Nome do Banco de Dados
$db = 'MuOnline';
//IP para usar remotamente
$host = '127.0.0.1';
$ip = "127.0.0.1";
$regsubmit = "regform.submit()";
$msconnect=mssql_connect("$host", "$alogin", "$apass");
$msdb=mssql_select_db("$db", $msconnect);
$port = "55901";
$ip = "127.0.0.1:8090";
$alogin = $dbuser;
$apass = $dbpasswd;
$db = 'MuOnline';
?>[/pre] Agora para usar, basta por no seu site como todas as outras paginas e crie uma Porcedure, abra o Query Analyzer copie e cole esse código nele:
Código: [pre]Use MuOnline
GO
CREATE PROC DISTRIBUIR_KUNDUNS @login varchar(20) AS
Declare @Item varchar(1200) Set @Item =
0xCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004
DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004D
DCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DD
CB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDC
B64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB
64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB6
4FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64
FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64F
F00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF
00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF0
0000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00
000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF000
00000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF0000
0000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000
000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF000000
00C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF0000000
0C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000
C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C
004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C0
04DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C00
4DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004
DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004D
DCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DD
CB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDC
B64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB
64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB6
4FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64
FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64F
F00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF
00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DD
BEGIN
UPDATE warehouse
SET Items = Convert(Varbinary(1200), @Item)
WHERE AccountID = @login
END
GO[/pre] E presione F5 para executar e Pronto.
Créditos: ProKill
Código: [pre]<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<div style="background-color:#CDDDF6; filter:alpha(Opacity=90); width: 200px; height: 35px; border: 2 solid black; padding:3px">
<?PHP include("configg.php"); ?>
<form name="form1" method="post" action="colocar_box2.php">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="10">
Login:
</td>
<td colspan="2">
<input name="login" type="text" id="login" maxlength="10" />
</td>
</tr>
<tr>
<td height="10">
Senha:
</td>
<td colspan="2">
<input name="oldpwd" type="password" id="oldpwd" maxlength="10" />
</td>
</tr>
<tr>
<td colspan="2">
<input type="submit" name="Submit" value="Enviar" />
</td>
</tr>
</table>
</form>
</div>
</body>
</html>[/pre] Crie a 2º pagina colocar_box2.php
Código: [pre]<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<div align="center">
<center>
<?
include("configg.php");
if (!$char)
{
$login = stripslashes($_POST['login']);
$oldpwd = stripslashes($_POST['oldpwd']);
$sql_username_check = mssql_query("SELECT memb___id FROM MEMB_INFO WHERE memb___id='$login'");
$username_check = mssql_num_rows($sql_username_check);
$sql_pw_check = mssql_query("SELECT memb__pwd FROM MEMB_INFO WHERE memb__pwd='$oldpwd' and memb___id='$login'");
$pw_check = mssql_num_rows($sql_pw_check);
$sql_char_check = mssql_query("SELECT Name FROM Character WHERE AccountID = '$login' and ctlcode>7");
$char_check = mssql_num_rows($sql_char_check);
if ($username_check <= 0)
{
echo "<font color=#006699>Seu login não existe em nosso banco de dados.<br>";
}
elseif ($pw_check <= 0)
{
echo "<font color=#006699>Senha incorreta.<br>";
}
elseif ($char_check <= 0)
{
echo "<br><br><font color=red>Você não é GM.";
}
else
{
setcookie("login3", "$login", time()+7257600);
setcookie("oldpwd3", "$oldpwd", time()+7257600);
?>
<br><b>Colocar Box no bau?</b>
<form name='form1' method='post' action='?char=char&add=ok'>
<table border='0' width='366'>
<tr>
<td colspan='2'>
<input type='submit' name='Submit' value='Colocar'>
</td>
</tr>
</table>
<br><font color=red>IMPORTANTE: <font color=black>Tudo o que estiver no baú será trocado pelas kunduns. Tirem o que vocês acharem necessário!! depois não venham reclamar!!!<br>
<?php
}
elseif ($char)
{
if ($char && $add == 'ok')
{
if ((!isset($_COOKIE["login3"])) || (!isset($_COOKIE["oldpwd3"])))
{
die("<center><font color=#006699><br><BR>ACESSO NEGADO");
}
if ((isset($_COOKIE["login3"])) && (isset($_COOKIE["oldpwd3"])))
{
$login2 = $_COOKIE["login3"];
$oldpwd2 = $_COOKIE["oldpwd3"];
$sql_char_check = mssql_query("SELECT Name FROM Character WHERE AccountID = '$login2' and ctlcode>7");
$char_check = mssql_num_rows($sql_char_check);
$VIP = "Select ConnectStat FROM MEMB_STAT WHERE memb___id='$login2'";
$VIP2 = mssql_query( $VIP );
$VIP3 = mssql_fetch_row($VIP2);
$sql_pw_check = mssql_query("SELECT memb__pwd FROM MEMB_INFO WHERE memb__pwd='$oldpwd2' and memb___id='$login2'"); $pw_check = mssql_num_rows($sql_pw_check);
$sql_username_check = mssql_query("SELECT memb___id FROM MEMB_INFO WHERE memb___id='$login2'");
$username_check = mssql_num_rows($sql_username_check);
if ($username_check <= 0)
{
echo "<bR><center><font color='red'>Seu login nao existem em nosso banco de dados.<br>";
}
elseif ($char_check <= 0)
{
echo "<br><br><br><font color=red>Você não é GM.";
}
elseif ($pw_check <= 0)
{
echo "<center><font color=#006699>Senha incorreta.<br>";
}
elseif ($VIP3[0] == 1)
{
echo "<bR><center><font color='#325784'>Você está online. Saia do jogo e tente novamente.<br>";
}
else
{
$result= mssql_query("DISTRIBUIR_KUNDUNS ".$login2."");
echo "<br><br><b>AS Kunduns Estão no seu baú, <br><br>Mais não é pra ir jogando na cidade igual um condenado ein!^^<br><BR><BR>";
}
}
}
}
?>
</div>
</body>
</html>[/pre] E finalmente crie a 3º pagina configg.php
Código: [pre]<?php
//by louis
//www.muonlinebr.com ..
$ip_user = getenv('REMOTE_ADDR');
$badwords = array(";", "'", "=", "\"", "+", "*", "union", "del", "DEL", "insert", "update", "drop", "sele", "$", "UPDATE", "Set", "SET");
foreach($_POST as $value)
foreach($badwords as $word)
if(substr_count($value, $word) > 0) die("Segurança Ativada!<br />Simbolos utilizandos invalidos! Seu ip é ->" .$ip_user);
// Coloque o IP da DB
$dbhost = "127.0.0.1";
// Usuario da DB
$dbuser = "sa";
// Senha
$dbpasswd = "sua senha do sql";
//Login ADM
$alogin = "Leostyles";
//Senha ADM
$apass = "sua senha do sql";
//Nome do Banco de Dados
$db = 'MuOnline';
//IP para usar remotamente
$host = '127.0.0.1';
$ip = "127.0.0.1";
$regsubmit = "regform.submit()";
$msconnect=mssql_connect("$host", "$alogin", "$apass");
$msdb=mssql_select_db("$db", $msconnect);
$port = "55901";
$ip = "127.0.0.1:8090";
$alogin = $dbuser;
$apass = $dbpasswd;
$db = 'MuOnline';
?>[/pre] Agora para usar, basta por no seu site como todas as outras paginas e crie uma Porcedure, abra o Query Analyzer copie e cole esse código nele:
Código: [pre]Use MuOnline
GO
CREATE PROC DISTRIBUIR_KUNDUNS @login varchar(20) AS
Declare @Item varchar(1200) Set @Item =
0xCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004
DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004D
DCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DD
CB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDC
B64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB
64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB6
4FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64
FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64F
F00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF
00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF0
0000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00
000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF000
00000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF0000
0000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000
000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF000000
00C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF0000000
0C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000
C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C
004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C0
04DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C00
4DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004
DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004D
DCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DD
CB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDC
B64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB
64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB6
4FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64
FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64F
F00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF
00000000C004DDCB64FF00000000C004DDCB64FF00000000C004DD
BEGIN
UPDATE warehouse
SET Items = Convert(Varbinary(1200), @Item)
WHERE AccountID = @login
END
GO[/pre] E presione F5 para executar e Pronto.
Créditos: ProKill