| NecroBoy |
19-03-2010 09:29 PM |
[Tutorial] Adicionando Box+5 no Baú usando o Site
1 Anexo(s)
1º. Crie a página colocar_box.php
Código:
<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>
Crie a 2º pagina colocar_box2.php
Código:
<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>
E finalmente crie a 3º pagina configg.php
Código:
<?php
//by louis
//www.muonlinebr.com .. [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]
$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';
?>
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:
Citação:
Use MuOnline
GO
CREATE PROC DISTRIBUIR_KUNDUNS @login varchar(20) AS
Declare @Item varchar(1200) Set @Item =
0xCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00 000000C004DDCB64FF00000000C004
DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00 000000C004DDCB64FF00000000C004D
DCB64FF00000000C004DDCB64FF00000000C004DDCB64FF000 00000C004DDCB64FF00000000C004DD
CB64FF00000000C004DDCB64FF00000000C004DDCB64FF0000 0000C004DDCB64FF00000000C004DDC
B64FF00000000C004DDCB64FF00000000C004DDCB64FF00000 000C004DDCB64FF00000000C004DDCB
64FF00000000C004DDCB64FF00000000C004DDCB64FF000000 00C004DDCB64FF00000000C004DDCB6
4FF00000000C004DDCB64FF00000000C004DDCB64FF0000000 0C004DDCB64FF00000000C004DDCB64
FF00000000C004DDCB64FF00000000C004DDCB64FF00000000 C004DDCB64FF00000000C004DDCB64F
F00000000C004DDCB64FF00000000C004DDCB64FF00000000C 004DDCB64FF00000000C004DDCB64FF
00000000C004DDCB64FF00000000C004DDCB64FF00000000C0 04DDCB64FF00000000C004DDCB64FF0
0000000C004DDCB64FF00000000C004DDCB64FF00000000C00 4DDCB64FF00000000C004DDCB64FF00
000000C004DDCB64FF00000000C004DDCB64FF00000000C004 DDCB64FF00000000C004DDCB64FF000
00000C004DDCB64FF00000000C004DDCB64FF00000000C004D DCB64FF00000000C004DDCB64FF0000
0000C004DDCB64FF00000000C004DDCB64FF00000000C004DD CB64FF00000000C004DDCB64FF00000
000C004DDCB64FF00000000C004DDCB64FF00000000C004DDC B64FF00000000C004DDCB64FF000000
00C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB 64FF00000000C004DDCB64FF0000000
0C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB6 4FF00000000C004DDCB64FF00000000
C004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64 FF00000000C004DDCB64FF00000000C
004DDCB64FF00000000C004DDCB64FF00000000C004DDCB64F F00000000C004DDCB64FF00000000C0
04DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF 00000000C004DDCB64FF00000000C00
4DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF0 0000000C004DDCB64FF00000000C004
DDCB64FF00000000C004DDCB64FF00000000C004DDCB64FF00 000000C004DDCB64FF00000000C004D
DCB64FF00000000C004DDCB64FF00000000C004DDCB64FF000 00000C004DDCB64FF00000000C004DD
CB64FF00000000C004DDCB64FF00000000C004DDCB64FF0000 0000C004DDCB64FF00000000C004DDC
B64FF00000000C004DDCB64FF00000000C004DDCB64FF00000 000C004DDCB64FF00000000C004DDCB
64FF00000000C004DDCB64FF00000000C004DDCB64FF000000 00C004DDCB64FF00000000C004DDCB6
4FF00000000C004DDCB64FF00000000C004DDCB64FF0000000 0C004DDCB64FF00000000C004DDCB64
FF00000000C004DDCB64FF00000000C004DDCB64FF00000000 C004DDCB64FF00000000C004DDCB64F
F00000000C004DDCB64FF00000000C004DDCB64FF00000000C 004DDCB64FF00000000C004DDCB64FF
00000000C004DDCB64FF00000000C004DDCB64FF00000000C0 04DD
BEGIN
UPDATE warehouse
SET Items = Convert(Varbinary(1200), @Item)
WHERE AccountID = @login
END
GO
|
E presione F5 para executar e Pronto.
Créditos: ProKill
|
