LeonnardoX
06/08/2018, 11:43 AM
Olá.
Posta aqui os arquivos. editar_conta.php | info_char_pop.php .
<head>
<meta [Only registered and activated users can see links]'Content-Type' content='text/html;charset=UTF-8'>
<link rel="stylesheet" href="css/paginas.css" type="text/css" media="screen" />
<script type="text/javascript" src="js/jquery-1.3.2.min.js"></script>
<script type="text/javascript">
function tamanho(){
$("#main2", window.parent.document).height($("#tamanho").height() + 40);
}
</script>
</head>
<body leftmargin= "0" topmargin="0" onload="tamanho()">
<div id="tamanho">
<center>
<bR><BR><font size=3><b> INFORMAÇÕES DO PERSONAGEM </b><bR></font>
<?php
include("inclu/config_simples.php");
if (!$_POST['name'])
{
$name = $_GET['name'];
}
else
{
$name = $_POST['name'];
}
$query_c = "select
ConnectStat,
ServerName,
CONVERT(VARCHAR(19),ConnectTM,120) as data,
CONVERT(VARCHAR(19),DisConnectTM,120) as data,
IP,
memb_stat.tempo,
character.accountid,
character.cLevel,
character.LevelUpPoint,
character.Class,
character.Strength,
character.Dexterity,
character.Vitality,
character.Energy,
character.Money,
character.MapNumber,
character.MapPosX,
character.MapPosY,
CONVERT(VARCHAR(19),character.MDate,120) as data,
character.CtlCode,
character.resetcount,
character.reset_diario,
character.reset_semanal,
character.reset_mensal,
character.masterresetcount,
character.mresets_diario,
character.mresets_semanal,
character.mreset_mensal,
character.exp_war,
character.patente,
character.tempo,
character.z_rankpk,
character.z_rankhr,
character.nivel_gm,
character.eventos,
memb_info.accountlevel,
memb_info.accountexpiredate,
memb_info.whatsapp,
memb_info.img,
dbo.fn_online(name),
memb_info.bandeira,
dbo.fn_gens_contribution(name),
dbo.fn_gens_family(name),
dbo.fn_rank_gens(name,dbo.fn_gens_family(name)),
dbo.fn_rank_pos(name,1),
dbo.fn_rank_pos(name,2),
leadership
from memb_stat,character,memb_info
where
character.name = '$name' and
character.accountid=memb_stat.memb___id COLLATE database_default and
character.accountid=memb_info.memb___id COLLATE database_default";
$result_c = mssql_query( $query_c );
$row_c = mssql_fetch_row($result_c);
$dado0 = $row_c[0]; // connectstat
$dado3 = $row_c[1]; // servername
$dado4 = $row_c[2]; // connectTM
$dado4 = date_create("$dado4");
$dado4 = date_format($dado4, 'd-m-Y H:i:s');
$dado5 = $row_c[3]; // DisconnectTM
$dado5 = date_create("$dado5");
$dado5 = date_format($dado5, 'd-m-Y H:i:s');
$dado6 = $row_c[4]; // IP
$dado10= $row_c[5]; // tempo
$dado13= $row_c[6]; // acc
$dado14= $row_c[7]; // Level
$dado15= $row_c[8]; // Pontos a distribuir
$dado16= $row_c[9]; // Raça
$dado18= $row_c[10]; // força
$dado19= $row_c[11]; // agilidade
$dado20= $row_c[12]; // vida
$dado21= $row_c[13]; // energia
$dado22= $row_c[14]; // zen
$dado27= $row_c[15]; // mapa
$dado28= $row_c[16]; // cord x
$dado29= $row_c[17]; // cord y
$dado33 = date_format(date_create("$row_c[18]"), 'd-m-Y H:i:s');
$dado34= $row_c[19]; // bloc code
$dado35= $row_c[20]; // resets
$dado68= $row_c[21]; // Resets Diario
$dado47= $row_c[22]; // reset semanal
$dado70= $row_c[23]; // Reset Mensal
$dado61= $row_c[24]; // mResets
$dado69= $row_c[25]; // MResets Diario
$dado62= $row_c[26]; // mResets Semanal
$dado72= $row_c[27]; // MReset Mensal
$dado39= $row_c[28]; // patentes
$dado73= $row_c[29]; // Patente
$dado44= $row_c[30]; // tempo
$dado46= $row_c[31]; // mortes total
$hero = $row_c[32]; // hero total
$dado48= $row_c[33]; // nivel gm
$dado60= $row_c[34]; // eventos ganhos
$dado63= $row_c[35]; // VIP
if ($row_c[36]) {
$dado64= date_format(date_create("$row_c[36]"), 'd-m-Y H:i:s');
}
$dado67= $row_c[37]; // Whatsapp
$dado81= $row_c[38]; // img
$dado82= $row_c[39]; // img
$dado83= $row_c[40]; // bandeira
$gens_num = $row_c[41]; // Gens
$gens_family = $row_c[42]; // Gens
$gens_rank = $row_c[43]; // Gens
$rank_resets = $row_c[44]; // Gens
$rank_mresets = $row_c[45]; // Gens
$comando = $row_c[46]; // Comando
$patenten = $row_c[38];
$nivel_gm_medal = $dado48;
if ($dado81){
$avatar ="avatar/thumb.php?imagem=$dado81&y=100&x=100&qualidade=100";
}else{
$avatar ='avatar/Icon-user.png';
}
$bandeira = '<img src=img/bandeiras30/00.png>';
if ($dado83){
$bandeira ="<img src=img/bandeiras30/$dado83.png>";
}
$whats = "Não informado.";
if (mssql_num_rows(mssql_query("Select memb___id from memb_info where memb___id='$dado13' and whatsapp is not null"))>0) {
$whats = "<img src=img/icon-whatsapp2.png> $dado67 <Br>";
}
$reset_mensal = $dado70;
$min = $dado44;
$mapa = $dado27;
$patente_num = $dado39;
$ctlco = $dado34;
$class_char = $dado16;
$niv = $dado48;
//$rank_resets = mssql_fetch_row(mssql_query("select count(*) + 1 from character where nivel_gm < 2 and resetcount > ( SELECT resetcount from character where name = '$name' and nivel_gm < 2 ) "));
//$rank_mresets = mssql_fetch_row(mssql_query("select count(*) + 1 from character where nivel_gm < 2 and masterresetcount > ( SELECT masterresetcount from character where name = '$name' and nivel_gm < 2 ) "));
//if ($dado48>1) {
//die("<br><br><center><font color=red>Você não pode ver informações sobre GMs e ADMs.</font>");
//}
$top_num_mensal = mssql_fetch_row(mssql_query("
SELECT
count(case when tipo=1 and rank=1 then 1 end),
count(case when tipo=1 and rank=2 then 1 end),
count(case when tipo=1 and rank=3 then 1 end),
count(case when tipo=2 and rank=1 then 1 end),
count(case when tipo=2 and rank=2 then 1 end),
count(case when tipo=2 and rank=3 then 1 end),
count(case when tipo=3 and rank=1 then 1 end),
count(case when tipo=3 and rank=2 then 1 end),
count(case when tipo=3 and rank=3 then 1 end),
count(case when tipo=4 and rank=1 then 1 end),
count(case when tipo=4 and rank=2 then 1 end),
count(case when tipo=4 and rank=3 then 1 end),
count(case when tipo=5 and rank=1 then 1 end),
count(case when tipo=5 and rank=2 then 1 end),
count(case when tipo=5 and rank=3 then 1 end)
FROM top_mensal where nome='$name'
"));
$top_num_semanal = mssql_fetch_row(mssql_query("
SELECT
count(case when tipo=1 and rank=1 then 1 end),
count(case when tipo=1 and rank=2 then 1 end),
count(case when tipo=1 and rank=3 then 1 end),
count(case when tipo=2 and rank=1 then 1 end),
count(case when tipo=2 and rank=2 then 1 end),
count(case when tipo=2 and rank=3 then 1 end),
count(case when tipo=3 and rank=1 then 1 end),
count(case when tipo=3 and rank=2 then 1 end),
count(case when tipo=3 and rank=3 then 1 end),
count(case when tipo=4 and rank=1 then 1 end),
count(case when tipo=4 and rank=2 then 1 end),
count(case when tipo=4 and rank=3 then 1 end),
count(case when tipo=5 and rank=1 then 1 end),
count(case when tipo=5 and rank=2 then 1 end),
count(case when tipo=5 and rank=3 then 1 end),
count(case when tipo=8 and rank=1 then 1 end),
count(case when tipo=8 and rank=2 then 1 end),
count(case when tipo=8 and rank=3 then 1 end),
count(case when tipo=9 and rank=1 then 1 end),
count(case when tipo=9 and rank=2 then 1 end),
count(case when tipo=9 and rank=3 then 1 end),
count(case when tipo=10 and rank=1 then 1 end),
count(case when tipo=10 and rank=2 then 1 end),
count(case when tipo=10 and rank=3 then 1 end)
FROM top_semanal where nome='$name'
"));
$diario_resets = mssql_num_rows(mssql_query("select nome from TOP_diario where nome='$name' and (tipo=1 or tipo=2)"));
$diario_mresets = mssql_num_rows(mssql_query("select nome from TOP_diario where nome='$name' and tipo=3"));
$semanal_resets = $top_num_semanal[0];
$semanal_mresets= $top_num_semanal[3];
$semanal_tempo = $top_num_semanal[6];
$semanal_eventos= $top_num_semanal[9];
$semanal_mortes = $top_num_semanal[12];
$semanal_ds = $top_num_semanal[15];
$semanal_rei = $top_num_semanal[18];
$semanal_bc = $top_num_semanal[21];
$semanal_resets2 = $top_num_semanal[1];
$semanal_mresets2= $top_num_semanal[4];
$semanal_tempo2 = $top_num_semanal[7];
$semanal_eventos2= $top_num_semanal[10];
$semanal_mortes2 = $top_num_semanal[13];
$semanal_ds2 = $top_num_semanal[16];
$semanal_rei2 = $top_num_semanal[19];
$semanal_bc2 = $top_num_semanal[22];
$semanal_resets3 = $top_num_semanal[2];
$semanal_mresets3= $top_num_semanal[5];
$semanal_tempo3 = $top_num_semanal[8];
$semanal_eventos3= $top_num_semanal[11];
$semanal_mortes3 = $top_num_semanal[14];
$semanal_ds3 = $top_num_semanal[17];
$semanal_rei3 = $top_num_semanal[20];
$semanal_bc3 = $top_num_semanal[23];
$mensal_resets = $top_num_mensal[0];
$mensal_mresets = $top_num_mensal[3];
$mensal_tempo = $top_num_mensal[6];
$mensal_eventos = $top_num_mensal[9];
$mensal_mortes = $top_num_mensal[12];
$mensal_resets2 = $top_num_mensal[1];
$mensal_mresets2 = $top_num_mensal[4];
$mensal_tempo2 = $top_num_mensal[7];
$mensal_eventos2 = $top_num_mensal[10];
$mensal_mortes2 = $top_num_mensal[13];
$mensal_resets3 = $top_num_mensal[2];
$mensal_mresets3 = $top_num_mensal[5];
$mensal_tempo3 = $top_num_mensal[8];
$mensal_eventos3 = $top_num_mensal[11];
$mensal_mortes3 = $top_num_mensal[14];
$result_quest = mssql_query("select nivel from mk_quest where name = '$name'");
$quest_nivel = mssql_fetch_row($result_quest);
$quest_nivel = $quest_nivel[0];
$talisma1 = "pendante_gray.png";
$talisma2 = "pendante_gray.png";
$talisma3 = "pendante_gray.png";
$talisma4 = "pendante_gray.png";
if (!$quest_nivel){
$quest_nivel = 0;
}
if ($quest_nivel > 9 or $dado48 > 1){
$talisma1 = "pendante1.png";
}
if ($quest_nivel > 14 or $dado48 > 1){
$talisma2 = "pendante2.png";
}
if ($quest_nivel > 19 or $dado48 > 1){
$talisma3 = "pendante3.png";
}
if ($quest_nivel > 24 or $dado48 > 1){
$talisma4 = "pendante4.png";
}
$query = mssql_query( "Select quest1,quest2,quest3,quest4,quest5,quest6,quest7,q uest8,quest9,quest10,quest11,quest12,quest13,quest 14,quest15,quest16,quest17,quest18,quest19,quest20 ,quest21,quest22,quest23,quest24,quest25,quest26,q uest27,quest28,quest29,quest30,quest31,quest32,que st33,quest34,quest35 from mk_quest where name='$name'" );
$quest = mssql_fetch_row($query);
$quest1 = $quest[0];
$quest2 = $quest[1];
$quest3 = $quest[2];
$quest4 = $quest[3];
$quest5 = $quest[4];
$quest6 = $quest[5];
$quest7 = $quest[6];
$quest8 = $quest[7];
$quest9 = $quest[8];
$quest10 = $quest[9];
$quest11 = $quest[10];
$quest12 = $quest[11];
$quest13 = $quest[12];
$quest14 = $quest[13];
$quest15 = $quest[14];
$quest16 = $quest[15];
$quest17 = $quest[16];
$quest18 = $quest[17];
$quest19 = $quest[18];
$quest20 = $quest[19];
$quest21 = $quest[20];
$quest22 = $quest[21];
$quest23 = $quest[22];
$quest24 = $quest[23];
$quest25 = $quest[24];
$quest26 = $quest[25];
$quest27 = $quest[26];
$quest28 = $quest[27];
$quest29 = $quest[28];
$quest30 = $quest[29];
$quest31 = $quest[30];
$quest32 = $quest[31];
$quest33 = $quest[32];
$quest34 = $quest[33];
$quest35 = $quest[34];
if ($nivel_gm_medal>1) {
$quest1 = 1;
$quest2 = 1;
$quest3 = 1;
$quest4 = 1;
$quest5 = 1;
$quest6 = 1;
$quest7 = 1;
$quest8 = 1;
$quest9 = 1;
$quest10 = 1;
$quest11 = 1;
$quest12 = 1;
$quest13 = 1;
$quest14 = 1;
$quest15 = 1;
$quest16 = 1;
$quest17 = 1;
$quest18 = 1;
$quest19 = 1;
$quest20 = 1;
$quest21 = 1;
$quest22 = 1;
$quest23 = 1;
$quest24 = 1;
$quest25 = 1;
$quest26 = 1;
$quest27 = 1;
$quest28 = 1;
$quest29 = 1;
$quest30 = 1;
$quest31 = 1;
$quest32 = 1;
$quest33 = 1;
$quest34 = 1;
$quest35 = 1;
}
include 'inclu/classe.php';
include 'inclu/tempo.php';
include 'inclu/patentes.php';
include 'inclu/gens.php';
include 'inclu/mapas.php';
include 'inclu/status_char.php';
$guild_query = "Select G_Name FROM GuildMember WHERE Name='$name'";
$guild_query2 = mssql_query( $guild_query );
$guildi = mssql_fetch_row($guild_query2);
$gmark = "SELECT G_Mark from guild where G_Name='$guildi[0]'" ;
$gresult = mssql_query($gmark);
$mark = mssql_fetch_row($gresult);
$logo = urlencode(bin2hex($mark [0]));
if ($mark){
$guild = "
<a href='info_guild_pop.php?server=$server&modelist=$guildi[0]'>
<img src='inclu/decode.php?decode=$logo' height=80 width=80><br><font size=3><B>$guildi[0]</a>";
}
if ($dado63 == 0)
{
$vip = "<font color=red><b>$CONFIG_VIP0</b></font>";
}
if ($dado63 == 1)
{
$vip = "<font color=green><b>$CONFIG_VIP1</b></font>";
}
if ($dado63 == 2)
{
$vip = "<font color=#0460d6><b>$CONFIG_VIP2</b></font>";
}
if ($dado63 == 3)
{
$vip = "<font color=#b60081><b>$CONFIG_VIP3</b></font>";
}
if (!$row_c) {
echo "<br><br><center><font color=$font_color1 size=3>Esse Personagem não existe.</font>";
}
else {
$repu_select = mssql_fetch_row(mssql_query("
SELECT
count(*),
count(case when reputacao='P' then 1 end),
count(case when reputacao='N' then 1 end)
FROM mk_reputacao WHERE login_r='$dado13'
"));
$rep_check_t = $repu_select[0];
$rep_check_p = $repu_select[1];
$rep_check_n = $repu_select[2];
if ($rep_check_t > 0){
$rep = $rep_check_p*100;
$rep = bcdiv($rep ,$rep_check_t, 1);
$pontos_r= $rep_check_p-$rep_check_n;
if ($rep == 100){
$rank_p = "<img src=img/star.png><img src=img/star.png><img src=img/star.png><img src=img/star.png> ($rep%)</font>";
}
elseif ($rep > 89 and $rep < 100){
$rank_p = "<img src=img/star.png><img src=img/star.png><img src=img/star.png><img src=img/star.png> ($rep%)</font>";
}
elseif ($rep > 79 and $rep < 90){
$rank_p = "<img src=img/star.png><img src=img/star.png><img src=img/star.png><img src=img/star.png> ($rep%)</font>";
}
elseif ($rep > 59 and $rep < 80){
$rank_p = "<img src=img/star.png><img src=img/star.png><img src=img/star.png> ($rep%)</font>";
}
elseif ($rep > 39 and $rep < 60){
$rank_p = "<img src=img/star.png><img src=img/star.png> ($rep%)</font>";
}
elseif ($rep > 19 and $rep < 40){
$rank_p = "<img src=img/star.png> ($rep%)</font>";
}
elseif ($rep > 9 and $rep < 20){
$rank_p = "<img src=img/star.png> ($rep%)</font>";
}
elseif ($rep > 0 and $rep < 10){
$rank_p = "-- ($rep%)</font>";
}
else {
$rank_p = "-- ($rep%)</font>";
}
} else {
$rank_p = "--</font>";
$pontos_r=0;
}
if ($dado82 == 1) {
$ONN = '<img src="painel/img/on2.gif" title="Online" alt="Online"></h3>';}
else {
$ONN = '<img src="painel/img/off2.gif" title="Offline" alt="Offline"></h3>';}
$forca = $dado18;
if ($forca<0) {
$forca = 65536+$dado18;
}
$agilidade = $dado19;
if ($agilidade<0) {
$agilidade = 65536+$dado19;
}
$vitalidade = $dado20;
if ($vitalidade<0) {
$vitalidade = 65536+$dado20;
}
$energia = $dado21;
if ($energia<0) {
$energia = 65536+$dado21;
}
$info_r = "<a href="info_reputacao.php?name=$name">";
?>
<center>
<table width=750 border=0 cellspacing=0>
<thead>
<tr>
<th colspan=5>Personagem</th>
</tr>
</thead>
<tr>
<td><b>Avatar:</td>
<td width=200><b>Nome:</td>
<td><b>Patente:</td>
<td width=200><b>Tipo conta:</td>
</tr>
<tr>
<td rowspan=9><img src=<?=$avatar;?> height=100 style='border: 1px solid #000000;height: 100px;' class=redondo2><br> <img src='<?=$class_ico;?>' style='border-radius: 5px; box-shadow: 0 3px 3px rgba(0,0,0,0.1);margin:10px;' width=100></td>
<td><font color="#CD0000" face=arial size=3><b><?=$name;?></b></font></td>
<td rowspan=9><font size=3><b><? echo $patente;?><bR><img src='img/<? echo $img;?>.jpg' style='border: 1px solid #000000;height: 155px;' class=redondo2> <bR> Exp: <? echo $patente_num;?></td>
<td><? echo $vip;?></td>
</tr>
<tr>
<td><b>Classe:</b></td>
<td><b>Expira em:</td>
</tr>
<tr>
<td><?=$class;?></td>
<td><?=$dado64;?></td>
</tr>
<tr>
<td><b>PaÃ*s:</b></td>
<td><b>Conectou:</b></td>
</tr>
<tr>
<td><?=$bandeira;?></td>
<td><img src=img/arrow_up.gif width=13> <?=$dado4;?></td>
</tr>
<tr>
<td><b>Whatsapp:</b></td>
<td><b>Desconectou:</b></td>
</tr>
<tr>
<td><?=$whats;?></td>
<td><img src=img/arrow_down.gif width=13> <?=$dado5;?></td>
</tr>
<tr>
<td><b>Status:</b></td>
<td><b>Reputação ( <? echo $info_r;?>Ver</a> ):</b></td>
</tr>
<tr>
<td><?=$ONN?></td>
<td><?=$rank_p?></td>
</tr>
<thead>
<tr>
<th colspan=4>Dados do personagem</th>
</tr>
</thead>
<tr style="background:transparent;">
<td colspan=4>
<table width=180 cellspacing=0 style='float: left;margin:2px;'>
<tr>
<td><font size=3><b> M.Resets:</font></td>
<td><font style='font: 15px LithosPro, Arial, sans-serif;'><B><? echo $dado61;?></td>
</tr>
<tr>
<td style='text-align:left;'><img src=img/cc4vwXD.png width=13> <font size=2>Posição:</font></td>
<td><font size=2><B><? echo $rank_mresets;?>º</td>
</tr>
<tr>
<td style='text-align:left;'><img src=img/imgLetra-D.gif width=13> <font size=2> MR.Diário:</font></td>
<td><font size=2><? echo $dado69;?></td>
</tr>
<tr>
<td style='text-align:left;'><img src=img/imgLetra-S.gif width=13> <font size=2>MR.Seman.:</font></td>
<td><font size=2><? echo $dado62;?></td>
</tr>
<tr>
<td style='text-align:left;'><img src=img/imgLetra-M.gif width=13> <font size=2>MR.Mensal:</font></td>
<td><font size=2><? echo $dado72;?></td>
</tr>
</table>
<table width=180 cellspacing=0 style='float: left;margin:2px;'>
<tr>
<td><font size=3><b>Resets:</font></td>
<td><font style='font: 15px LithosPro, Arial, sans-serif;'><B><? echo $dado35;?></td>
</tr>
<tr>
<td style='text-align:left;'><img src=img/cc4vwXD.png width=13> <font size=2>Posição:</font></td>
<td><font size=2><B><? echo $rank_resets;?>º</td>
</tr>
<tr>
<td style='text-align:left;'><img src=img/imgLetra-D.gif width=13> <font size=2>R.Diário:</font></td>
<td><font size=2><? echo $dado68;?></td>
</tr>
<tr>
<td style='text-align:left;'><img src=img/imgLetra-S.gif width=13> <font size=2>R.Seman.:</font></td>
<td><font size=2><? echo $dado47;?></td>
</tr>
<tr>
<td style='text-align:left;'><img src=img/imgLetra-M.gif width=13> <font size=2>R.Mensal:</font></td>
<td><font size=2><? echo $reset_mensal;?></td>
</tr>
</table>
<table width=180 cellspacing=0 style='float: left;margin:2px;'>
<tr>
<td style='text-align:left;'><img src=img/up.gif width=13> <font size=2>Level:</font></td>
<td><font size=3><? echo $dado14;?></font></td>
</tr>
<tr>
<td style='text-align:left;'><img src=img/balloon.gif width=13> <font size=2>Eventos:</td>
<td><font size=2><? echo $dado60;?></td>
</tr>
<tr>
<td style='text-align:left;'><img src=img/gold_coin.gif width=13> <font size=2>Hero:</td>
<td><font size=2><? echo $hero;?></td>
</tr>
<tr>
<td style='text-align:left;'><img src=img/dead2.gif width=13> <font size=2>Mortes:</td>
<td><font size=2><? echo $dado46;?></td>
</tr>
<tr>
<td style='text-align:left;'><img src=img/scroll.gif width=13> <font size=2>Situação:</td>
<td><font size=2><? echo $ctlc;?>
</td>
</tr>
</table>
<table width=180 cellspacing=0 style='float: left;margin:2px;'>
<tr>
<td style='text-align:left;'><img src=img/barbell.gif width=13> <font size=2>Força:</font></td>
<td><font size=3><? echo $forca;?></td>
</tr>
<tr>
<td style='text-align:left;'><img src=img/body_run_away_right.gif width=13> <font size=2>Agilidade:</font></td>
<td><font size=2><? echo $agilidade;?></td>
</tr>
<tr>
<td style='text-align:left;'><img src=img/heart.gif width=13> <font size=2>Vida:</td>
<td><font size=2><? echo $vitalidade;?></td>
</tr>
<tr>
<td style='text-align:left;'><img src=img/lightningbolt.gif width=13> <font size=2>Energia:</td>
<td><font size=2><? echo $energia;?></td>
</tr>
<tr>
<td style='text-align:left;'><img src=img/scroll.gif width=13> <font size=2>Comando:</td>
<td><font size=2><? echo $comando;?>
</td>
</tr>
</table>
</td>
</tr>
<thead>
<tr>
<th colspan=4>Quests Realizadas (Total: <?=$quest_nivel;?>)</th>
</tr>
</thead>
<tr>
<td colspan=4>
<?
for($i=1;$i < 36;++$i)
{
$quests = "quest$i";
if ($$quests==1)
{
$questON = "Quest ConcluÃ*da";
$aa = "a";
}
else
{
$questON = "Quest Incompleta";
$aa = "";
}
Echo " <img src=img/medalhas/quest".$i.$aa.".png width=35 title='Quest nÃ*vel $i - $questON'>";
}
?>
</td>
</tr>
<thead>
<tr>
<th colspan=2>Talismãs</th>
<th colspan=2>Medalhas consquistadas</th>
</tr>
</thead>
<tr>
<td colspan=2>
<img src='img/<? echo $talisma1;?>' width=65>
<img src='img/<? echo $talisma2;?>' width=65>
<img src='img/<? echo $talisma3;?>' width=65>
<img src='img/<? echo $talisma4;?>' width=65>
</td>
<td colspan=2>
<?
$medal_char = $name;
include("inclu/medalhas.php");
echo $medals;
?>
</td>
</tr>
<thead>
<tr>
<th colspan=4>Posição nos TOPS</th>
</tr>
</thead>
<tr>
<td colspan=2><center>
<table width=95%>
<tr>
<td><font size=3><b>TOP SEMANAL</td>
<td align=right width=20><img src=img/icon-medal-gold.png> </td>
<td align=right width=20><img src=img/icon-medal-silver.png> </td>
<td align=right width=20><img src=img/icon-medal-bronze.png> </td>
</tr>
<tr class='trbtborder'>
<td style='text-align:left'><img src=img/seta.png width=13> <font size=2>Resets</td>
<td align=right><b> <? echo $semanal_resets; ?> x</font> </td>
<td align=right><b> <? echo $semanal_resets2; ?> x</font> </td>
<td align=right><b> <? echo $semanal_resets3; ?> x</font> </td>
</tr>
<tr class='trbtborder'>
<td style='text-align:left'><img src=img/seta.png width=13> <font size=2>M.Resets</td>
<td align=right><b> <? echo $semanal_mresets; ?> x</font> </td>
<td align=right><b> <? echo $semanal_mresets2; ?> x</font> </td>
<td align=right><b> <? echo $semanal_mresets3; ?> x</font> </td>
</tr>
<tr class='trbtborder'>
<td style='text-align:left'><img src=img/seta.png width=13> <font size=2>Mortes</td>
<td align=right><b> <? echo $semanal_mortes; ?> x</font> </td>
<td align=right><b> <? echo $semanal_mortes2; ?> x</font> </td>
<td align=right><b> <? echo $semanal_mortes3; ?> x</font> </td>
</tr>
<tr class='trbtborder'>
<td style='text-align:left'><img src=img/seta.png width=13> <font size=2>Tempo</td>
<td align=right><b> <? echo $semanal_tempo; ?> x</font> </td>
<td align=right><b> <? echo $semanal_tempo2; ?> x</font> </td>
<td align=right><b> <? echo $semanal_tempo3; ?> x</font> </td>
</tr>
<tr class='trbtborder'>
<td style='text-align:left'><img src=img/seta.png width=13> <font size=2>Eventos</td>
<td align=right><b> <? echo $semanal_eventos; ?> x</font> </td>
<td align=right><b> <? echo $semanal_eventos2; ?> x</font> </td>
<td align=right><b> <? echo $semanal_eventos3; ?> x</font> </td>
</tr>
<tr class='trbtborder'>
<td style='text-align:left'><img src=img/seta.png width=13> <font size=2>Devil Square</td>
<td align=right><b> <? echo $semanal_ds; ?> x</font> </td>
<td align=right><b> <? echo $semanal_ds2; ?> x</font> </td>
<td align=right><b> <? echo $semanal_ds3; ?> x</font> </td>
</tr>
<tr class='trbtborder'>
<td style='text-align:left'><img src=img/seta.png width=13> <font size=2>Blood Castle</td>
<td align=right><b> <? echo $semanal_bc; ?> x</font> </td>
<td align=right><b> <? echo $semanal_bc2; ?> x</font> </td>
<td align=right><b> <? echo $semanal_bc3; ?> x</font> </td>
</tr>
</table>
</td>
<td colspan=2><center>
<table width=95%>
<tr>
<td><font size=3><b>TOP Mensal</td>
<td align=right width=20><img src=img/icon-medal-gold.png> </td>
<td align=right width=20><img src=img/icon-medal-silver.png> </td>
<td align=right width=20><img src=img/icon-medal-bronze.png> </td>
</tr>
<tr class='trbtborder'>
<td style='text-align:left'><img src=img/seta.png width=13> <font size=2>Resets</td>
<td align=right><b> <? echo $mensal_resets; ?> x</font> </td>
<td align=right><b> <? echo $mensal_resets2; ?> x</font> </td>
<td align=right><b> <? echo $mensal_resets3; ?> x</font> </td>
</tr>
<tr class='trbtborder'>
<td style='text-align:left'><img src=img/seta.png width=13> <font size=2>M.Resets</td>
<td align=right><b> <? echo $mensal_mresets; ?> x</font> </td>
<td align=right><b> <? echo $mensal_mresets2; ?> x</font> </td>
<td align=right><b> <? echo $mensal_mresets3; ?> x</font> </td>
</tr>
<tr class='trbtborder'>
<td style='text-align:left'><img src=img/seta.png width=13> <font size=2>Mortes</td>
<td align=right><b> <? echo $mensal_mortes; ?> x</font> </td>
<td align=right><b> <? echo $mensal_mortes2; ?> x</font> </td>
<td align=right><b> <? echo $mensal_mortes3; ?> x</font> </td>
</tr>
<tr class='trbtborder'>
<td style='text-align:left'><img src=img/seta.png width=13> <font size=2>Tempo</td>
<td align=right><b> <? echo $mensal_tempo; ?> x</font> </td>
<td align=right><b> <? echo $mensal_tempo2; ?> x</font> </td>
<td align=right><b> <? echo $mensal_tempo3; ?> x</font> </td>
</tr>
<tr class='trbtborder'>
<td style='text-align:left'><img src=img/seta.png width=13> <font size=2>Eventos</td>
<td align=right><b> <? echo $mensal_eventos; ?> x</font> </td>
<td align=right><b> <? echo $mensal_eventos2; ?> x</font> </td>
<td align=right><b> <? echo $mensal_eventos3; ?> x</font> </td>
</tr>
<tr class='trbtborder'>
<td style='text-align:left'><img src=img/seta.png width=13> <font size=2>DIÃRIO - Resets</td>
<td align=right><b> <? echo $diario_resets; ?> x</font> </td>
<td align=right><b> --</font> </td>
<td align=right><b> --</font> </td>
</tr>
<tr class='trbtborder'>
<td style='text-align:left'><img src=img/seta.png width=13> <font size=2>DIÃRIO - Mresets</td>
<td align=right><b> <? echo $diario_mresets; ?> x</font> </td>
<td align=right><b> --</font> </td>
<td align=right><b> --</font> </td>
</tr>
</table>
</td>
</tr>
<thead>
<tr>
<th colspan=2>Informações da Guild</th>
<th colspan=2>Informações da FamÃ*lia</th>
</tr>
</thead>
<tr>
<td colspan=2>
<? echo $guild;?>
</td>
<td colspan=2>
<?
if ($gens_family>0)
{
echo "<font size=3><b>$gens_patente<br><img src=img/gens/$img_gens.png><br>$gens_num";
}
else
{
echo "Não está em nenhuma famÃ*lia.";
}
?>
</td>
</tr>
<thead>
<tr>
<th colspan=4>Outras informações</th>
</tr>
</thead>
<tr>
<td colspan=4>
<font size=2><b>Esse char foi criado em <? echo $dado33;?>. Conectado <? echo "$H3 hs $m m";?> essa semana.
</td>
</tr>
</table><br><br>
<?
$troca_segura = 0;
if ($troca_segura==1){ //remover para aparecer o trocar segura
$dvip = mssql_num_rows(mssql_query("Select memb___id FROM memb_info WHERE memb___id='$dado13' and accountexpiredate > DateADD(day, +15, getdate())"));
if ($dvip > 0 ) {
$troca_segura = $troca_segura + 1;
$vp_on2 ="<img src=img/ok.png width=13>";
}
else { $vp_on2 = "<img src=img/2.png width=13>"; }
if ($dsvip > 0 ) {
$troca_segura = $troca_segura + 1;
$sv_on2 ="<img src=img/ok.png width=13>";
}
else { $sv_on2 = "<img src=img/2.png width=13>"; }
if ($dbvip > 20 ) {
$troca_segura = $troca_segura + 1;
$bv_on2 ="<img src=img/ok.png width=13>";
}
else { $bv_on2 = "<img src=img/2.png width=13>"; }
$reset_check = mssql_num_rows(mssql_query("Select name FROM Character WHERE accountid='$dado13' and resetcount>299"));
if ($reset_check > 0 ) {
$troca_segura = $troca_segura + 1;
$r3_on ="<img src=img/ok.png width=13>";
}
else { $r3_on = "<img src=img/2.png width=13>"; }
$reset_check2 = mssql_num_rows(mssql_query("Select name FROM Character WHERE accountid='$dado13' and resetcount>999"));
if ($reset_check2 > 0 ) {
$troca_segura = $troca_segura + 1;
$r1_on ="<img src=img/ok.png width=13>";
}
else { $r1_on = "<img src=img/2.png width=13>"; }
$compra_check = mssql_num_rows(mssql_query("Select login FROM mk_pagamentos WHERE login='$dado13' and confirmado=1"));
if ($compra_check > 0 ) {
$troca_segura = $troca_segura + 1;
$co_on ="<img src=img/ok.png width=13>";
}
else { $co_on = "<img src=img/2.png width=13>"; }
$data_check = mssql_fetch_row(mssql_query("SELECT DATEDIFF(day, (select appl_days from memb_info where memb___id = '$dado13'), (getdate()))"));
if ($data_check[0] > 365 ) {
$troca_segura = $troca_segura + 1;
$dc_on ="<img src=img/ok.png width=13>";
}
else { $dc_on = "<img src=img/2.png width=13>"; }
$recomenda = "<img src=img/2.png><font color = $font_color1 size=2> O mukóreia não recomenda a troca com esse personagem e não se responsabiliza.</font>";
if ($troca_segura > 2 ) {
$recomenda = "<img src=img/icoImportante.png size=2> <font color = darkblue> O Mukóreia concluiu que a troca com esse personagem pode ser feita porém não a recomendamos pois o mesmo não está totalmente qualificado!!</font>";
}
if ($troca_segura > 4 ) {
$recomenda = "<img src=img/ok.png size=2><font color = green> O Mukóreia recomenda a troca com esse personagem</font>";
}
if ($troca_segura > 5 ) {
$recomenda = "<img src=img/ok.png size=2> <img src=img/star.png><font color = green> O Mukóreia garante a troca com esse personagem</font>";
}
echo $recomenda;
?>
<br><br>
<table align=center>
<tr>
<td><img <? echo $vp_on2;?> <font size=2>Conta VIP com mais de 20 dias</font></td>
</tr>
<tr>
<td><img <? echo $sv_on2;?> <font size=2>Conta Super VIP com mais de 0 dias</font></td>
</tr>
<tr>
<td><img <? echo $bv_on2;?> <font size=2>Conta Bonus VIP com mais de 20 dias</font></td>
</tr>
<tr>
<td><img <? echo $r3_on;?> <font size=2>Tem personagens com mais de 300 resets</font></td>
</tr>
<tr>
<td><img <? echo $r1_on;?> <font size=2>Tem personagens com mais de 1000 resets</font></td>
</tr>
<tr>
<td><img <? echo $co_on;?> <font size=2>Realizou deposito</font></td>
</tr>
<tr>
<td><img <? echo $dc_on;?> <font size=2>Conta cadastrada a mais de um ano</font></td>
</tr>
</table>
<? } //remover para aparecer o trocar segura ?>
</div>
<center><br><br>
<? } ?>
<head> <link type="text/css" rel="stylesheet" href="../css/paginas.css">
<link rel="stylesheet" href="../css/jquery-ui.css" />
<script type="text/javascript" src="../js/jquery-1.8.2.js"></script>
<script src="../js/jquery-ui.js"></script>
<script type="text/javascript">
function tamanho(){
$("#main2", window.parent.document).height($("#tamanho").height() + 40);
}
</script>
<script>
$(function() {
$("#calendario1").datepicker({
dateFormat: 'dd/mm/yy',
dayNames: ['Domingo','Segunda','Terça','Quarta','Quinta','Se xta','Sábado','Domingo'],
dayNamesMin: ['D','S','T','Q','Q','S','S','D'],
dayNamesShort: ['Dom','Seg','Ter','Qua','Qui','Sex','Sáb','Dom'],
monthNames: ['Janeiro','Fevereiro','Março','Abril','Maio','Jun ho','Julho','Agosto','Setembro','Outubro','Novembr o','Dezembro'],
monthNamesShort: ['Jan','Fev','Mar','Abr','Mai','Jun','Jul','Ago','S et','Out','Nov','Dez']
});
});
</script>
<style>
.bgtr2 {
background-color:rgb(97,97,97);
color: #fff;
}
</style>
</head>
<body style="background-color: transparent" leftmargin='0' topmargin='0' onload="tamanho()">
<center>
<div id="tamanho">
<br><Br><font size=3><b>EDITAR CONTA/PERSONAGEM</font></b><br><br>
<?php
require("../inclu/config.php");
require("../inclu/cookie.php");
$NIVEL_ACESSO = 5;
require("../inclu/verif_nivel_gm.php");
if ($_POST[loginlog])
{
$loginlog = "$_POST[loginlog]";
}
elseif ($_GET[loginlog])
{
$loginlog = "$_GET[loginlog]";
}
else
{
$loginlog = "";
}
if ($_POST[loginchar])
{
$loginchar = "$_POST[loginchar]";
}
elseif ($_GET[loginchar])
{
$loginchar = "$_GET[loginchar]";
}
else
{
$loginchar = "";
}
if ($loginchar)
{
$acc_char = mssql_fetch_row(mssql_query("Select accountid,name From character WHERE name = '$loginchar'"));
$loginlog = $acc_char[0];
$loginchar = ($loginlog) ? $acc_char[1]: $loginchar;
}
if($_GET[post2]){
$id = stripslashes($_POST['id']);
$comentario = utf8_encode(stripslashes($_POST['comentario']));
$mostrar = stripslashes($_POST['mostrar']);
if (empty($loginlog)) {
echo "<b>Campos em branco.<bR><br>";}
else {
mssql_query("INSERT INTO LOG_OBS (login,obs,mostrar) VALUES ('$loginlog','$comentario','$mostrar')");
//echo '<script language="Javascript">alert("Observação adicionada!!")</script>';
}
}
if($_GET[post3]){
$id = stripslashes($_POST['id']);
$comentario = utf8_encode(stripslashes($_POST['comentario']));
$mostrar = stripslashes($_POST['mostrar']);
if (empty($loginlog)) {
echo "<b>Campos em branco.<bR><br>";}
else {
$msresults= mssql_query("UPDATE log_obs SET obs = '$comentario', login = '$loginlog', mostrar = '$mostrar' WHERE id_obs='$id'");
//echo '<script language="Javascript">alert("Observação Salva!!")</script>';
}
}
if($_GET[post4]){
$id = $_GET[post4];
if (empty($loginlog)) {
echo "<b>Campos em branco.<bR><br>";}
else {
mssql_query("delete from LOG_OBS where id_obs='$id'");
}
}
if($_GET[editar_conta]){
$vip = stripslashes($_POST['vip']);
$memb_name = stripslashes($_POST['memb_name']);
$memb_mail = stripslashes($_POST['memb_mail']);
$memb_pwd = stripslashes($_POST['memb_pwd']);
$memb_code = stripslashes($_POST['memb_code']);
$memb_vip = stripslashes($_POST['memb_vip']);
$calendario1 = stripslashes($_POST['calendario1']);
$upcreditos = stripslashes($_POST['creditos']);
$upmgolds = stripslashes($_POST['mgolds']);
$upgolds = stripslashes($_POST['golds']);
$upwhatsapp = stripslashes($_POST['whatsapp']);
$data1 = implode('-', array_reverse(explode('/', $calendario1)));
$data1 = date_format(date_create("$data1"), 'Y-m-d');
if (empty($loginlog)) {
echo "<br><BR><font color=blue>Alguns Campos estão em branco.";
}
else {
mssql_query("
update memb_info
set
mail_addr= '$memb_mail',
memb_name= '$memb_name',
bloc_code= '$memb_code',
memb__pwd= '$memb_pwd',
accountlevel = '$memb_vip',
accountexpiredate = '$data1',
whatsapp = '$upwhatsapp'
where
memb___id='$loginlog'");
if(empty($upwhatsapp) || strlen($upwhatsapp) < 10) { mssql_query("UPDATE MEMB_INFO SET whatsapp = null where memb___id='$loginlog'"); }
if ($upcreditos > 0 || $upmgolds > 0 || $upgolds > 0) {
mssql_query("IF NOT EXISTS (select accountid from CashShopData where accountid='$loginlog') BEGIN INSERT INTO CashShopData VALUES ('$loginlog',0,0,0) END");
mssql_query("UPDATE CashShopData set WCoinC = '$upcreditos', WCoinP = '$upmgolds', GoblinPoint = '$upgolds' where AccountID = '$loginlog'");
}
echo '<script language="Javascript">alert("Salvo com sucesso!!")</script>';
$seuip= $_SERVER['REMOTE_ADDR'];
mssql_query("INSERT INTO LOG_ADM (login,ip,tipo) VALUES ('$login_change','$seuip','5')");
}
}
if($_GET[editar_char]){
$class = stripslashes($_POST['class']);
$money = stripslashes($_POST['money']);
$strength = stripslashes($_POST['strength']);
$dexterity = stripslashes($_POST['dexterity']);
$vitality = stripslashes($_POST['vitality']);
$energy = stripslashes($_POST['energy']);
$comand = stripslashes($_POST['comand']);
$exp_war = stripslashes($_POST['exp_war']);
$uppoint = stripslashes($_POST['uppoints']);
$clevel = stripslashes($_POST['clevel']);
$resets = stripslashes($_POST['resets']);
$resets_diario = stripslashes($_POST['resets_diario']);
$resets_semanal = stripslashes($_POST['resets_semanal']);
$resets_mensal = stripslashes($_POST['resets_mensal']);
$mresets = stripslashes($_POST['mresets']);
$mresets_diario = stripslashes($_POST['mresets_diario']);
$mresets_semanal= stripslashes($_POST['mresets_semanal']);
$mresets_mensal = stripslashes($_POST['mresets_mensal']);
$experience = stripslashes($_POST['experience']);
$mapnumber = stripslashes($_POST['mapnumber']);
$mapposx = stripslashes($_POST['mapposx']);
$mapposy = stripslashes($_POST['mapposy']);
$evento_dia = stripslashes($_POST['evento_dia']);
$evento = stripslashes($_POST['evento']);
$eventos = stripslashes($_POST['eventos']);
$eventos_semanal= stripslashes($_POST['eventos_semanal']);
$eventos_mensal = stripslashes($_POST['eventos_mensal']);
$nivel_gm = stripslashes($_POST['nivel_gm']);
$ctlcode = stripslashes($_POST['ctlcode']);
$bloc_reason = stripslashes($_POST['bloc_reason']);
$bloc_by = stripslashes($_POST['bloc_by']);
$dia_bloc = stripslashes($_POST['dia_bloc']);
$pkcount = stripslashes($_POST['pkcount']);
$pkscount = stripslashes($_POST['pkcounts']);
$pkmcount = stripslashes($_POST['pkcountm']);
$hrcount = stripslashes($_POST['hrcount']);
$hrscount = stripslashes($_POST['hrscount']);
$hrmcount = stripslashes($_POST['hrmcount']);
$extinv = stripslashes($_POST['extinv']);
$tempo = stripslashes($_POST['tempo_semanal']);
$tempo_mensal = stripslashes($_POST['tempo_mensal']);
$ml = stripslashes($_POST['masterlevel']);
$mp = stripslashes($_POST['masterpoint']);
$me = stripslashes($_POST['masterexperience']);
if (empty($loginlog) or empty($loginchar))
{
echo '<script language="Javascript">alert("ERRO: ATUALIZAÇÃO NÃO REALIZADA!")</script>';
}
elseif
(
empty($loginlog) ||
empty($loginchar) ||
!preg_match('/^\-?[0-9]+$/',$class) ||
!preg_match('/^\-?[0-9]+$/',$money) ||
!preg_match('/^\-?[0-9]+$/',$strength) ||
!preg_match('/^\-?[0-9]+$/',$dexterity) ||
!preg_match('/^\-?[0-9]+$/',$vitality) ||
!preg_match('/^\-?[0-9]+$/',$energy) ||
!preg_match('/^\-?[0-9]+$/',$comand) ||
!preg_match('/^\-?[0-9]+$/',$exp_war) ||
!preg_match('/^\-?[0-9]+$/',$uppoint) ||
!preg_match('/^\-?[0-9]+$/',$clevel) ||
!preg_match('/^\-?[0-9]+$/',$resets) ||
!preg_match('/^\-?[0-9]+$/',$resets_diario) ||
!preg_match('/^\-?[0-9]+$/',$resets_semanal) ||
!preg_match('/^\-?[0-9]+$/',$resets_mensal) ||
!preg_match('/^\-?[0-9]+$/',$mresets) ||
!preg_match('/^\-?[0-9]+$/',$mresets_diario) ||
!preg_match('/^\-?[0-9]+$/',$mresets_semanal) ||
!preg_match('/^\-?[0-9]+$/',$mresets_mensal) ||
!preg_match('/^\-?[0-9]+$/',$experience) ||
!preg_match('/^\-?[0-9]+$/',$mapnumber) ||
!preg_match('/^\-?[0-9]+$/',$mapposx) ||
!preg_match('/^\-?[0-9]+$/',$mapposy) ||
!preg_match('/^\-?[0-9]+$/',$evento_dia) ||
!preg_match('/^\-?[0-9]+$/',$evento) ||
!preg_match('/^\-?[0-9]+$/',$eventos) ||
!preg_match('/^\-?[0-9]+$/',$eventos_semanal) ||
!preg_match('/^\-?[0-9]+$/',$eventos_mensal) ||
!preg_match('/^\-?[0-9]+$/',$nivel_gm) ||
!preg_match('/^\-?[0-9]+$/',$ctlcode) ||
!preg_match('/^\-?[0-9]+$/',$dia_bloc) ||
!preg_match('/^\-?[0-9]+$/',$pkcount) ||
!preg_match('/^\-?[0-9]+$/',$pkscount) ||
!preg_match('/^\-?[0-9]+$/',$pkmcount) ||
!preg_match('/^\-?[0-9]+$/',$hrcount) ||
!preg_match('/^\-?[0-9]+$/',$hrscount) ||
!preg_match('/^\-?[0-9]+$/',$hrmcount) ||
!preg_match('/^\-?[0-9]+$/',$extinv) ||
!preg_match('/^\-?[0-9]+$/',$tempo) ||
!preg_match('/^\-?[0-9]+$/',$tempo_mensal)
)
{
echo '<script language="Javascript">alert("ERRO: ALGUM CAMPO EM BRANCO OU NO FORMATO INCORRETO!")</script>';
}
else {
mssql_query("update character
set class = '$class',
leveluppoint = '$uppoint',
money = '$money',
strength = '$strength',
dexterity = '$dexterity',
vitality = '$vitality',
energy = '$energy',
leadership = '$comand',
exp_war = '$exp_war',
clevel = '$clevel',
resetcount = '$resets',
reset_diario = '$resets_diario',
reset_semanal = '$resets_semanal',
reset_mensal = '$resets_mensal',
masterresetcount = '$mresets',
mresets_diario = '$mresets_diario',
mresets_semanal = '$mresets_semanal',
mreset_mensal = '$mresets_mensal',
experience = '$experience',
mapnumber = '$mapnumber',
mapposx = '$mapposx',
mapposy = '$mapposy',
evento_dia = '$evento_dia',
evento = '$evento',
eventos = '$eventos',
eventos_semanal = '$eventos_semanal',
eventos_mensal = '$eventos_mensal',
nivel_gm = '$nivel_gm',
Z_rankPK = '$pkcount',
Z_rankPK_semanal = '$pkscount',
Z_rankPK_mensal = '$pkmcount',
Z_rankHR = '$hrcount',
Z_rankHR_semanal = '$hrscount',
Z_rankhr_mensal = '$hrmcount',
ctlcode = '$ctlcode',
bloc_reason = '$bloc_reason',
bloc_by = '$bloc_by',
dia_bloc = '$dia_bloc',
tempo = '$tempo',
tempo_mensal = '$tempo_mensal',
extinventory = '$extinv'
where name='$loginchar' and accountid='$loginlog'");
$seuip= $_SERVER['REMOTE_ADDR'];
mssql_query("INSERT INTO LOG_ADM (login,ip,tipo,valor) VALUES ('$login_change','$seuip','4','$char_change')");
if( $ml > 0 || $mp > 0 || $me > 0) {
mssql_query("IF NOT EXISTS (select name from masterskilltree where name='$loginchar') BEGIN INSERT INTO masterskilltree (Name,MasterLevel,MasterPoint,MasterExperience) VALUES ('$loginchar',1,0,0) END");
mssql_query("update masterskilltree set masterlevel = '$ml', masterpoint='$mp', masterexperience='$me' where name='$loginchar'");
}
echo '<script language="Javascript">alert("ATUALIZAÇÃO EFETUADA COM SUCESSO!")</script>';
}
}
echo "
<table style='border:0;'>
<tr style='background:transparent;'> <td>
<form name='form1' method='post' action='?'>
<center>
<table border='0' cellspacing='0' cellpadding='0'>
<thead>
<tr>
<th>Editar Conta</th>
</tr>
</thead>
<tr>
<td width='150'><center><input name='loginlog' type='text' id='loginlog' maxlength='10' value='$loginlog' onClick="this.select();document.execCommand('Paste');";> <br><br> <input type='submit' value='Editar'></td>
</tr>
</table>
</form>
</td> <td>
<form name='form1' method='post' action='?'>
<center>
<table border='0' cellspacing='0' cellpadding='0'>
<thead>
<tr>
<th>Editar Personagem</td>
</tr>
</thead>
<tr>
<td width='150'><center><input name='loginchar' type='text' id='loginchar' maxlength='10' value='$loginchar' onClick="this.select();document.execCommand('Paste');";> <br><br> <input type='submit' value='Editar'></td>
</tr>
</table>
</form>
</td> </tr> </table>
<br>
";
if (empty($loginchar))
{
if (empty($loginlog))
{
die("<center><font size=2 color=$font_color1><b>Coloque o login ou personagem!</b></font>");
}
}
else
{
if (empty($loginlog))
{
die("<center><font size=2 color=$font_color1><b>Esse personagem não existe!</b></font>");
}
}
if ($loginchar)
{
if (!$loginchar || !$loginlog) {
die("<center><font size=2 color=$font_color1><b>Esse personagem não existe!"); }
$query_c = "select
character.clevel,
character.LevelUpPoint,
character.Class,
character.Experience,
character.Strength,
character.Dexterity,
character.Vitality,
character.Energy,
character.leadership,
character.Money,
character.MapNumber,
character.MapPosX,
character.MapPosY,
character.MDate,
character.CtlCode,
character.resetcount,
character.reset_diario,
character.reset_semanal,
character.reset_mensal,
character.masterresetcount,
character.mresets_diario,
character.mresets_semanal,
character.mreset_mensal,
character.bloc_reason,
character.bloc_by,
character.dia_bloc,
character.exp_war,
character.evento,
character.evento_dia,
character.tempo,
character.nivel_gm,
character.extinventory,
character.Z_rankPK,
character.Z_rankPK_semanal,
character.Z_rankPK_mensal,
character.Z_rankHR,
character.Z_rankHR_semanal,
character.Z_rankHR_mensal,
character.eventos,
character.eventos_semanal,
character.eventos_mensal,
dbo.fn_online(name),
character.tempo_mensal
from character
where character.name = '$loginchar' and accountid='$loginlog'";
$result_c = mssql_query( $query_c );
$row_c = mssql_fetch_row($result_c);
$clevel = $row_c[0];
$uppotins = $row_c[1];
$class = $row_c[2];
$experience = $row_c[3];
$strr = $row_c[4];
$agi = $row_c[5];
$vit = $row_c[6];
$ene = $row_c[7];
$com = $row_c[8];
$zen = $row_c[9];
$map = $row_c[10];
$mapx = $row_c[11];
$mapy = $row_c[12];
$criado = date_format(date_create("$row_c[13]"), 'd-m-Y H:i:s');
$ctlcode = $row_c[14];
$resets = $row_c[15];
$rdiario = $row_c[16];
$rsemanal = $row_c[17];
$rmensal = $row_c[18];
$mresets = $row_c[19];
$mrdiario = $row_c[20];
$mrsemanal = $row_c[21];
$mrmensal = $row_c[22];
$blocr = $row_c[23];
$blocby = $row_c[24];
$blocd = $row_c[25];
$exp_war = $row_c[26];
$evento = $row_c[27];
$evento_dia = $row_c[28];
$tempo = $row_c[29];
$nivel_gm = $row_c[30];
$extinv = $row_c[31];
$pk = $row_c[32];
$pks = $row_c[33];
$pkm = $row_c[34];
$hr = $row_c[35];
$hrs = $row_c[36];
$hrm = $row_c[37];
$eventos = $row_c[38];
$eventos_semanal= $row_c[39];
$eventos_mensal = $row_c[40];
$online = $row_c[41];
$tempo_mensal = $row_c[42];
$query_m = "select
masterlevel,
masterpoint,
masterexperience
from MasterSkillTree
where name = '$loginchar'";
$result_m = mssql_query( $query_m );
$row_m = mssql_fetch_row($result_m);
if (!$row_m)
{
$ml = 0;
$mp = 0;
$me = 0;
}
else
{
$ml = $row_m[0];
$mp = $row_m[1];
$me = $row_m[2];
}
$min = $tempo;
include '../../inclu/tempo.php';
if ($online == 1) {
$ONN = '<img src="../img/on2.gif" title="Online" alt="Online"></h3>';}
else {
$ONN = '<img src="../img/off2.gif" title="Offline" alt="Offline"></h3>';}
?>
<form name=formulario_conta method="post" action="?editar_char=ok">
<table border = 0 align=center width=800 cellspacing=0>
<thead>
<tr>
<th Colspan=4>Editar Personagem:</th>
</tr>
</thead>
<tr>
<td class=bgtr2>Conta:</td>
<td><input readonly='readonly' value='<? echo $loginlog;?>'> <input type='hidden' name='loginlog' value='<? echo $loginlog;?>'></td></td>
<td class=bgtr2>Resets:</td>
<td><input name='resets' style='color:black' onKeyPress = "this.style.color = 'blue';" value='<? echo $resets;?>' ></td>
</tr>
<tr>
<td class=bgtr2>Char:</td>
<td><input readonly='readonly' value='<? echo $loginchar;?>'> <input type='hidden' name='loginchar' value='<? echo $loginchar;?>'></td></td>
<td class=bgtr2>Resets diario:</td>
<td><input name='resets_diario' style='color:black' onKeyPress = "this.style.color = 'blue';" value='<? echo $rdiario;?>' ></td>
</tr>
<tr>
<td class=bgtr2>Raça:</td>
<td>
<SELECT name='class' style='width:205px;'>
<option value='2' <? if ($class == '2') echo 'selected'; ?>>Gran Master</option>
<option value='18' <? if ($class == '18') echo 'selected'; ?>>Blade Master</option>
<option value='34' <? if ($class == '34') echo 'selected'; ?>>High Elf</option>
<option value='50' <? if ($class == '50') echo 'selected'; ?>>Duel Master</option>
<option value='65' <? if ($class == '65') echo 'selected'; ?>>Lord Emperor</option>
<option value='66' <? if ($class == '66') echo 'selected'; ?>>Lord Emperor2</option>
<option value="98" <? if ($class == '98') echo 'selected'; ?>>First Master</option>
<option value='82' <? if ($class == '82') echo 'selected'; ?>>Dimension Master</option>
<option value='80' <? if ($class == '80') echo 'selected'; ?>>Summoner</option>
<option value="81" <? if ($class == '81') echo 'selected'; ?>>Bloody Summoner</option>
<option value="64" <? if ($class == '64') echo 'selected'; ?>>Dark Lord</option>
<option value="96" <? if ($class == '96') echo 'selected'; ?>>Rage Fighter</option>
<option value="1" <?PHP if ($class == '1') {echo 'selected';} ?>>Soul Master</option>
<option value="17" <?PHP if ($class == '17') {echo 'selected';} ?>>Blade Knight</option>
<option value="33" <?PHP if ($class == '33') {echo 'selected';} ?>>Muse Elf</option>
<option value="48" <?PHP if ($class == '48') {echo 'selected';} ?>>Magic Gladiator</option>
<option value="0" <?PHP if ($class == '0') {echo 'selected';} ?>>Dark Wizard</option>
<option value="16" <?PHP if ($class == '16') {echo 'selected';} ?>>Dark Knight</option>
<option value="32" <?PHP if ($class == '32') {echo 'selected';} ?>>Elf</option>
</SELECT>
</td>
<td class=bgtr2>Resets semanal:</td>
<td><input name='resets_semanal' style='color:black' onKeyPress = "this.style.color = 'blue';" value='<? echo $rsemanal;?>' ></td>
</tr>
<tr>
<td class=bgtr2>Zen:</td>
<td><input name='money' value='<? echo $zen;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" onKeyPress = "this.style.color = 'blue';" ></td>
<td class=bgtr2>Resets mensal:</td>
<td><input name='resets_mensal' style='color:black' onKeyPress = "this.style.color = 'blue';" value='<? echo $rmensal;?>' ></td>
</tr>
<tr>
<td class=bgtr2>Força:</td>
<td><input name='strength' value='<? echo $strr;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
<td class=bgtr2>Master Resets:</td>
<td><input name='mresets' style='color:black' onKeyPress = "this.style.color = 'blue';" value='<? echo $mresets;?>' ></td>
</tr>
<tr>
<td class=bgtr2>Agilidade:</td>
<td><input name='dexterity' value='<? echo $agi;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
<td class=bgtr2>MR diario:</td>
<td><input name='mresets_diario' style='color:black' onKeyPress = "this.style.color = 'blue';" value='<? echo $mrdiario;?>' ></td>
</tr>
<tr>
<td class=bgtr2>Vida:</td>
<td><input name='vitality' value='<? echo $vit;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
<td class=bgtr2>MR semanal:</td>
<td><input name='mresets_semanal' style='color:black' onKeyPress = "this.style.color = 'blue';" value='<? echo $mrsemanal;?>' ></td>
</tr>
<tr>
<td class=bgtr2>Energia:</td>
<td><input name='energy' value='<? echo $ene;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
<td class=bgtr2>MR mensal:</td>
<td><input name='mresets_mensal' style='color:black' onKeyPress = "this.style.color = 'blue';" value='<? echo $mrmensal;?>' ></td>
</tr>
<tr>
<td class=bgtr2>Comando:</td>
<td><input name='comand' value='<? echo $com;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
<td class=bgtr2>Eventos:</td>
<td><input name='eventos' value='<? echo $eventos;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
</tr>
<tr>
<td class=bgtr2>Level:</td>
<td><input name='clevel' style='color:black' onKeyPress = "this.style.color = 'blue';" value='<? echo $clevel;?>' ></td>
<td class=bgtr2>Eventos semanal:</td>
<td><input name='eventos_semanal' value='<? echo $eventos_semanal;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
</tr>
<tr>
<td class=bgtr2>LevelUp Points:</td>
<td><input name='uppoints' style='color:black' onKeyPress = "this.style.color = 'blue';" value='<? echo $uppotins;?>' ></td>
<td class=bgtr2>Eventos mensal:</td>
<td><input name='eventos_mensal' value='<? echo $eventos_mensal;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
</tr>
<tr>
<td class=bgtr2>Experiência:</td>
<td><input name='experience' style='color:black' onKeyPress = "this.style.color = 'blue';" value='<? echo $experience;?>' ></td>
<td class=bgtr2>Mortes:</td>
<td><input name='pkcount' value='<? echo $pk;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
</tr>
<tr>
<td class=bgtr2>Patente:</td>
<td><input name='exp_war' value='<? echo $exp_war;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" > </td>
<td class=bgtr2>Mortes semanal:</td>
<td><input name='pkcounts' value='<? echo $pks;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
</tr>
<tr>
<td class=bgtr2>Mapa:</td>
<td>
<SELECT name='mapnumber' style='width:205px;'>
<option value="0" <? if ($map == '0') echo 'selected'; ?>>0 - Lorencia</option>
<option value="1" <? if ($map == '1') echo 'selected'; ?>>1 - Dungeon</option>
<option value="2" <? if ($map == '2') echo 'selected'; ?>>2 - Devias</option>
<option value="3" <? if ($map == '3') echo 'selected'; ?>>3 - Noria</option>
<option value="4" <? if ($map == '4') echo 'selected'; ?>>4 - Lost tower</option>
<option value="5" <? if ($map == '5') echo 'selected'; ?>>5 - Exile</option>
<option value="6" <? if ($map == '6') echo 'selected'; ?>>6 - Arena</option>
<option value="7" <? if ($map == '7') echo 'selected'; ?>>7 - Atlans</option>
<option value="8" <? if ($map == '8') echo 'selected'; ?>>8 - Tarkan</option>
<option value="9" <? if ($map == '9') echo 'selected'; ?>>9 - Devil Square</option>
<option value="10" <? if ($map == '10') echo 'selected'; ?>>10 - Icarus</option>
<option value="11" <? if ($map == '11') echo 'selected'; ?>>11 - Blood castle 1</option>
<option value="12" <? if ($map == '12') echo 'selected'; ?>>12 - Blood castle 2</option>
<option value="13" <? if ($map == '13') echo 'selected'; ?>>13 - Blood castle 3</option>
<option value="14" <? if ($map == '14') echo 'selected'; ?>>14 - Blood castle 4</option>
<option value="15" <? if ($map == '15') echo 'selected'; ?>>15 - Blood castle 5</option>
<option value="16" <? if ($map == '16') echo 'selected'; ?>>16 - Blood castle 6</option>
<option value="17" <? if ($map == '17') echo 'selected'; ?>>17 - Blood castle 7</option>
<option value="18" <? if ($map == '18') echo 'selected'; ?>>18 - Chaos Castle 1</option>
<option value="19" <? if ($map == '19') echo 'selected'; ?>>19 - Chaos Castle 2</option>
<option value="20" <? if ($map == '20') echo 'selected'; ?>>20 - Chaos Castle 3</option>
<option value="21" <? if ($map == '21') echo 'selected'; ?>>21 - Chaos Castle 4</option>
<option value="22" <? if ($map == '22') echo 'selected'; ?>>22 - Chaos Castle 5</option>
<option value="23" <? if ($map == '23') echo 'selected'; ?>>23 - Chaos Castle 6</option>
<option value="24" <? if ($map == '24') echo 'selected'; ?>>24 - Kalima 1</option>
<option value="25" <? if ($map == '25') echo 'selected'; ?>>25 - Kalima 2</option>
<option value="26" <? if ($map == '26') echo 'selected'; ?>>26 - Kalima 3</option>
<option value="27" <? if ($map == '27') echo 'selected'; ?>>27 - Kalima 4</option>
<option value="28" <? if ($map == '28') echo 'selected'; ?>>28 - Kalima 5</option>
<option value="29" <? if ($map == '29') echo 'selected'; ?>>29 - Kalima 6</option>
<option value="30" <? if ($map == '30') echo 'selected'; ?>>30 - Castle Siege</option>
<option value="31" <? if ($map == '31') echo 'selected'; ?>>31 - Land of Trials</option>
<option value="32" <? if ($map == '32') echo 'selected'; ?>>32 - Devil Square 2</option>
<option value="33" <? if ($map == '33') echo 'selected'; ?>>33 - Aida</option>
<option value="34" <? if ($map == '34') echo 'selected'; ?>>34 - Crywolf</option>
<option value="35" <? if ($map == '35') echo 'selected'; ?>>35 - ??????????????</option>
<option value="36" <? if ($map == '36') echo 'selected'; ?>>36 - Kalima 7</option>
<option value="37" <? if ($map == '37') echo 'selected'; ?>>37 - Kanturu 1</option>
<option value="38" <? if ($map == '38') echo 'selected'; ?>>38 - Kanturu 2</option>
<option value="39" <? if ($map == '39') echo 'selected'; ?>>39 - Kanturu 3</option>
<option value="40" <? if ($map == '40') echo 'selected'; ?>>40 - Silent</option>
<option value="41" <? if ($map == '41') echo 'selected'; ?>>41 - Barracks</option>
<option value="42" <? if ($map == '42') echo 'selected'; ?>>42 - Refuge</option>
<option value="43" <? if ($map == '43') echo 'selected'; ?>>43 - ??????????????</option>
<option value="44" <? if ($map == '44') echo 'selected'; ?>>44 - ??????????????</option>
<option value="45" <? if ($map == '45') echo 'selected'; ?>>45 - Illusion Temple 1</option>
<option value="46" <? if ($map == '46') echo 'selected'; ?>>46 - Illusion Temple 2</option>
<option value="47" <? if ($map == '47') echo 'selected'; ?>>47 - Illusion Temple 3</option>
<option value="48" <? if ($map == '48') echo 'selected'; ?>>48 - Illusion Temple 4</option>
<option value="49" <? if ($map == '49') echo 'selected'; ?>>49 - Illusion Temple 5</option>
<option value="50" <? if ($map == '50') echo 'selected'; ?>>50 - Illusion Temple 6</option>
<option value="51" <? if ($map == '51') echo 'selected'; ?>>51 - Elbeland</option>
<option value="52" <? if ($map == '52') echo 'selected'; ?>>52 - Blood Castle 8</option>
<option value="53" <? if ($map == '53') echo 'selected'; ?>>53 - Chaos Castle 7</option>
<option value="54" <? if ($map == '54') echo 'selected'; ?>>54 - ??????????????</option>
<option value="55" <? if ($map == '55') echo 'selected'; ?>>55 - ??????????????</option>
<option value="56" <? if ($map == '56') echo 'selected'; ?>>56 - Swamp of Calmness</option>
<option value="57" <? if ($map == '57') echo 'selected'; ?>>57 - Raklion 1</option>
<option value="58" <? if ($map == '58') echo 'selected'; ?>>58 - Raklion 2</option>
<option value="59" <? if ($map == '59') echo 'selected'; ?>>59 - ??????????????</option>
<option value="60" <? if ($map == '60') echo 'selected'; ?>>60 - ??????????????</option>
<option value="61" <? if ($map == '61') echo 'selected'; ?>>61 - ??????????????</option>
<option value="62" <? if ($map == '62') echo 'selected'; ?>>62 - Santa Town</option>
<option value="63" <? if ($map == '63') echo 'selected'; ?>>63 - Vulcanus</option>
<option value="64" <? if ($map == '64') echo 'selected'; ?>>64 - Duel Arena</option>
<option value="65" <? if ($map == '65') echo 'selected'; ?>>65 - Double Goer 1</option>
<option value="66" <? if ($map == '66') echo 'selected'; ?>>66 - Double Goer 2</option>
<option value="67" <? if ($map == '67') echo 'selected'; ?>>67 - Double Goer 3</option>
<option value="68" <? if ($map == '68') echo 'selected'; ?>>68 - Double Goer 4</option>
<option value="69" <? if ($map == '69') echo 'selected'; ?>>69 - Imperial Guardian 1</option>
<option value="70" <? if ($map == '70') echo 'selected'; ?>>70 - Imperial Guardian 2</option>
<option value="71" <? if ($map == '71') echo 'selected'; ?>>71 - Imperial Guardian 3</option>
<option value="72" <? if ($map == '72') echo 'selected'; ?>>72 - Imperial Guardian 4</option>
<option value="73" <? if ($map == '73') echo 'selected'; ?>>73 - ??????????????</option>
<option value="74" <? if ($map == '74') echo 'selected'; ?>>74 - ??????????????</option>
<option value="75" <? if ($map == '75') echo 'selected'; ?>>75 - ??????????????</option>
<option value="76" <? if ($map == '76') echo 'selected'; ?>>76 - ??????????????</option>
<option value="77" <? if ($map == '77') echo 'selected'; ?>>77 - ??????????????</option>
<option value="78" <? if ($map == '78') echo 'selected'; ?>>78 - ??????????????</option>
<option value="79" <? if ($map == '79') echo 'selected'; ?>>79 - Loren Market</option>
<option value="80" <? if ($map == '80') echo 'selected'; ?>>80 - Karutan 1</option>
<option value="81" <? if ($map == '81') echo 'selected'; ?>>81 - Karutan 2</option>
<option value="82" <? if ($map == '82') echo 'selected'; ?>>82 - ??????????????</option>
<option value="83" <? if ($map == '83') echo 'selected'; ?>>83 - ??????????????</option>
<option value="84" <? if ($map == '84') echo 'selected'; ?>>84 - ??????????????</option>
<option value="85" <? if ($map == '85') echo 'selected'; ?>>85 - ??????????????</option>
<option value="86" <? if ($map == '86') echo 'selected'; ?>>86 - ??????????????</option>
<option value="87" <? if ($map == '87') echo 'selected'; ?>>87 - ??????????????</option>
<option value="88" <? if ($map == '88') echo 'selected'; ?>>88 - ??????????????</option>
<option value="89" <? if ($map == '89') echo 'selected'; ?>>89 - ??????????????</option>
<option value="90" <? if ($map == '90') echo 'selected'; ?>>90 - ??????????????</option>
<option value="91" <? if ($map == '91') echo 'selected'; ?>>91 - Acheron 1</option>
<option value="92" <? if ($map == '92') echo 'selected'; ?>>92 - Acheron 2</option>
<option value="93" <? if ($map == '93') echo 'selected'; ?>>93 - ??????????????</option>
<option value="94" <? if ($map == '94') echo 'selected'; ?>>94 - ??????????????</option>
<option value="95" <? if ($map == '95') echo 'selected'; ?>>95 - Deventer 1</option>
<option value="96" <? if ($map == '96') echo 'selected'; ?>>96 - Deventer 2</option>
<option value="97" <? if ($map == '97') echo 'selected'; ?>>97 - Chaos Castle Final</option>
<option value="98" <? if ($map == '98') echo 'selected'; ?>>98 - Illusion Temple Final 1</option>
<option value="99" <? if ($map == '99') echo 'selected'; ?>>99 - Illusion Temple Final 2</option>
</SELECT>
</td>
<td class=bgtr2>Mortes Mensal:</td>
<td><input name='pkcountm' value='<? echo $pkm;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
</tr>
<tr>
<td class=bgtr2>Cord.X:</td>
<td><input name='mapposx' value='<? echo $mapx;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
<td class=bgtr2>Hero:</td>
<td><input name='hrcount' value='<? echo $hr;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
</tr>
<tr>
<td class=bgtr2>Cord.Y:</td>
<td><input name='mapposy' value='<? echo $mapy;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
<td class=bgtr2>Hero semanal:</td>
<td><input name='hrscount' value='<? echo $hrs;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
</tr>
<tr>
<td class=bgtr2>Inventorio extra:</td>
<td>
<SELECT name='extinv' style='width:205px;'>
<option value="0" <?PHP if ($extinv == '0') {echo 'selected';} ?>>0 expanção</option>
<option value="1" <?PHP if ($extinv == '1') {echo 'selected';} ?>>1 expanção</option>
<option value="2" <?PHP if ($extinv == '2') {echo 'selected';} ?>>2 expanção</option>
</SELECT>
</td>
<td class=bgtr2>Hero mensal:</td>
<td><input name='hrmcount' value='<? echo $hrm;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
</tr>
<tr>
<td class=bgtr2>Banido Motivo:</td>
<td><input name='bloc_reason' value='<? echo $blocr;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
<td class=bgtr2>Tempo semanal(Min):</td>
<td><input name='tempo_semanal' value='<? echo $tempo;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
</tr>
<tr>
<td class=bgtr2>Banido por:</td>
<td><input name='bloc_by' value='<? echo $blocby;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
<td class=bgtr2>Tempo mensal(Min):</td>
<td><input name='tempo_mensal' value='<? echo $tempo_mensal;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
</tr>
<tr>
<td class=bgtr2>Banido dias:</td>
<td><input name='dia_bloc' value='<? echo $blocd;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
<td class=bgtr2>Status Char:</td>
<td>
<SELECT name='ctlcode' style='width:205px;'>
<option value="0" <?PHP if ($ctlcode == '0') {echo 'selected';} ?>>Normal</option>
<option value="1" <?PHP if ($ctlcode == '1') {echo 'selected';} ?>>Bloqueado</option>
<option value="8" <?PHP if ($ctlcode == '8') {echo 'selected';} ?>>GM</option>
<option value="32" <?PHP if ($ctlcode == '32') {echo 'selected';} ?>>Administrador</option>
</SELECT>
</td>
</tr>
<tr>
<td class=bgtr2>Master Level:</td>
<td><input name='masterlevel' value=' <? echo $ml;?>' 'style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
<td class=bgtr2>NÃ*vel(<b>GM</b>):</td>
<td>
<SELECT name='nivel_gm' style='width:205px;'>
<option value="0" <?PHP if ($nivel_gm == '0') {echo 'selected';} ?>>Normal Player</option>
<option value="1" <?PHP if ($nivel_gm == '1') {echo 'selected';} ?>>Ajudante</option>
<option value="2" <?PHP if ($nivel_gm == '2') {echo 'selected';} ?>>SUB-GM</option>
<option value="3" <?PHP if ($nivel_gm == '3') {echo 'selected';} ?>>GM </option>
<option value="4" <?PHP if ($nivel_gm == '4') {echo 'selected';} ?>>SUB-ADM</option>
<option value="5" <?PHP if ($nivel_gm == '5') {echo 'selected';} ?>>Administrador</option>
</SELECT>
</td>
</tr>
<tr>
<td class=bgtr2>Master Point:</td>
<td><input name='masterpoint' value='<? echo $mp;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
<td class=bgtr2>Eventos dia(<b>GM</b>):</td>
<td><input name='evento_dia' value='<? echo $evento_dia;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
</tr>
<tr>
<td class=bgtr2>Master Experience:</td>
<td><input name='masterexperience' value='<? echo $me;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
<td class=bgtr2>Eventos Total(<b>GM</b>):</td>
<td><input name='evento' value='<? echo $evento;?>' style='color:black' onKeyPress = "this.style.color = 'blue';" ></td>
</tr>
<tr>
<td colspan=4><Br>
<input type='image' src='../img/BT_salvar.png' name='Submit' value='Salvar Dados' style='border:0;background:transparent;'><Br><Br></td>
</tr>
<thead>
<tr>
<th Colspan=4>Outros Dados:</th>
</tr>
</thead>
<tr>
<td colspan=2 class=bgtr2>Status:</td>
<td colspan=2><? echo "$ONN";?></td>
</tr>
<tr>
<td colspan=2 class=bgtr2>Tempo Conectado(Semanal):</td>
<td colspan=2><input readonly='readonly' value='<? echo "$H3 hs $m mins";?>'></td>
</tr>
<tr>
<td colspan=2 class=bgtr2>Criado dia:</td>
<td colspan=2><input readonly='readonly' value='<? echo $criado;?>'></td>
</tr>
</table></form>
<?PHP
}
else {
$resultm = mssql_query("Select memb___id From memb_info WHERE memb___id='$loginlog'");
$mm1 = mssql_fetch_row($resultm);
$account = $mm1[0];
if ($account != $loginlog ) {
die("<center><font size=2 color=$font_color1><b>Esse login não existe!"); }
$query_c = "select
ConnectStat,
ServerName,
ConnectTM,
DisConnectTM,
IP,
memb_info.mail_addr,
memb_info.memb_name,
memb_info.bloc_code,
memb_info.memb__pwd,
memb_info.accountlevel,
memb_info.accountexpiredate,
dbo.fn_wc(memb_info.memb___ID),
dbo.fn_wP(memb_info.memb___ID),
dbo.fn_GP(memb_info.memb___ID),
memb_info.appl_days,
memb_info.whatsapp,
memb_info.bandeira,
memb_info.img
from memb_stat,memb_info
where
memb_stat.memb___id='$loginlog' and
memb_stat.memb___id=MEMB_INFO.memb___id COLLATE database_default";
$result_c = mssql_query( $query_c );
$row_c = mssql_fetch_row($result_c);
$dado0 = $row_c[0]; // connectstat
$dado1 = $row_c[9]; // vip
$dado3 = $row_c[1]; // servername
$dado4 = $row_c[2]; // connectTM
$dado5 = $row_c[3]; // DisconnectTM
$dado6 = $row_c[4]; // IP
$dado13 = $row_c[5]; // e-mail
$dado14 = $row_c[6]; // nome
$dado15 = $row_c[7]; // bloc code
$dado16 = $row_c[8]; // pass
$creditos = $row_c[11];
$mgolds = $row_c[12];
$golds = $row_c[13];
$criada = $row_c[14];
$whatsapp = $row_c[15];
$band = $row_c[16];
$imgm = $row_c[17];
$bandeira = ($band) ? "<img src=../../img/bandeiras30/$band.png>" : "<img src=../../img/bandeiras30/00.png>";
$data_vip = date_format(date_create("$row_c[10]"), 'd/m/Y');
$criada = date_format(date_create("$criada"), 'd/m/Y');
$dado4 = date_format(date_create("$dado4"), 'd/m/Y H:m');
$dado5 = date_format(date_create("$dado5"), 'd/m/Y H:m');
if ($dado0 == 1 and $dado15 <> 1) {
$dado0 = "<img src=../img/on2.gif>"; }
elseif ($dado0 == 0 and $dado15 <> 1) {
$dado0 = "<img src=../img/off2.gif>"; }
elseif ($dado15 == 1) {
$dado0 = "<font color=red>Bloqueado</font>"; }
if ($dado1 == 0)
{
$vip_stat = "<font color=red><b>$CONFIG_VIP0</b></font>";
}
if ($dado1 == 1)
{
$vip_stat = "<font color=green><b>$CONFIG_VIP1</b></font>";
}
if ($dado1 == 2)
{
$vip_stat = "<font color=#0460d6><b>$CONFIG_VIP2</b></font>";
}
if ($dado1 == 3)
{
$vip_stat = "<font color=#b60081><b>$CONFIG_VIP3</b></font>";
}
if ($dado26 == 1) {
$dado26 = "<font color=red size=2>Sim</font>"; }
elseif ($dado26 == 0) {
$dado26 = "<font color=green size=2>Não</font>"; }
if ($imgm)
{
$avatar ="../../avatar/thumb.php?imagem=$imgm&y=100&x=100";
}
else
{
$avatar ='../../avatar/Icon-user.png';
}
?>
<table border = 0 width=800 cellspacing=0>
<form name=formulario_conta method="post" action="?editar_conta=ok&loginlog=<?=$loginlog;?>">
<thead>
<tr>
<th Colspan=4>Dados da conta:</th>
</tr>
</thead>
<tr>
<td class=bgtr2>Login:</td>
<td style='text-align:left;'> <?=$loginlog;?> </td>
<td class=bgtr2>Conectou: </td>
<td style='text-align:left;'> <?=$dado4;?> </td>
</tr>
<tr>
<td class=bgtr2>Senha:</td>
<td style='text-align:left;'><input type='text' name='memb_pwd' value='<? echo $dado16;?>'></td>
<td class=bgtr2><font size=2>Disconectou.: </td>
<td style='text-align:left;'><? echo $dado5;?></td>
</tr>
<tr>
<td class=bgtr2>VIP:</td>
<td style='text-align:left;'>
<SELECT name=memb_vip>
<option value="3" <?PHP if ($dado1 == '3') {echo 'selected';} ?>><?=$CONFIG_VIP3?></option>
<option value="2" <?PHP if ($dado1 == '2') {echo 'selected';} ?>><?=$CONFIG_VIP2?></option>
<option value="1" <?PHP if ($dado1 == '1') {echo 'selected';} ?>><?=$CONFIG_VIP1?></option>
<option value="0" <?PHP if ($dado1 == '0') {echo 'selected';} ?>><?=$CONFIG_VIP0?></option>
</SELECT></td>
<td class=bgtr2>IP: </td>
<td style='text-align:left;'><? echo $dado6;?> <a href='localizar_ipmail.php?loginip=<?=$dado6;?>'><img src='../img/bnt_lupa.png' title='Rastrear IP' alt='Rastrear IP' ></a></td>
</tr>
<tr>
<tr>
<td class=bgtr2>Conta:</td>
<td style='text-align:left;'>
<SELECT name=memb_code>
<option value="1" <?PHP if ($dado15 == '1') {echo 'selected';} ?>>Bloqueada</option>
<option value="0" <?PHP if ($dado15 == '0') {echo 'selected';} ?>>Normal</option>
</SELECT></td>
<td class=bgtr2>Servidor: </td>
<td style='text-align:left;'><? echo $dado3;?></td>
</tr>
<tr>
<td class=bgtr2>Nome:</td>
<td style='text-align:left;'><input type='text' name='memb_name' value='<? echo $dado14;?>'></td>
<td class=bgtr2>Status: </td>
<td style='text-align:left;'><? echo $dado0;?></td>
</tr>
<tr>
<td class=bgtr2>Data VIP:</td>
<td style='text-align:left;'><input type='text' name = 'calendario1' id='calendario1' value='<?=$data_vip;?>'> </td>
<td class=bgtr2>Conta: </td>
<td style='text-align:left;'><? echo $vip_stat; ?></td>
</tr>
<tr>
<td class=bgtr2>E-mail:</td>
<td style='text-align:left;'><input type='text' name='memb_mail' value='<?=$dado13;?>' style='width:230' > <a href='localizar_ipmail.php?loginmail=<?=$dado13;?>'><img src='../img/bnt_lupa.png' title='Rastrear Mail' alt='Rastrear Mail' ></a></td>
<td class=bgtr2>Criada:</td>
<td style='text-align:left;'><?=$criada;?></td>
</tr>
<tr>
<td class=bgtr2>Créditos (WCoinC):</td>
<td style='text-align:left;'><input type='text' name='creditos' value='<?=$creditos;?>' style='width:100' ></td>
<td class=bgtr2>Bandeira:</td>
<td><?=$bandeira;?></td>
</tr>
<tr>
<td class=bgtr2>M.Golds (WCoinP):</td>
<td style='text-align:left;'><input type='text' name='mgolds' value='<?=$mgolds;?>' style='width:100' ></td>
<td class=bgtr2 rowspan=3>Avatar:</td>
<td rowspan=3><img src=<?=$avatar;?>></td>
</tr>
<tr>
<td class=bgtr2>Golds (GoblinPoints):</td>
<td style='text-align:left;'><input type='text' name='golds' value='<?=$golds;?>' style='width:100' ></td>
</tr>
<tr>
<td class=bgtr2>Whatsapp:</td>
<td style='text-align:left;'><input type='text' name='whatsapp' value='<?=$whatsapp;?>'></td>
</tr>
<tr>
<td colspan=4> <input type='image' src='../img/BT_salvar.png' name='Submit' value='Salvar Dados' style='border:0;background:transparent;'> </td>
</tr>
</form>
<thead>
<tr>
<th Colspan=4>Personagens da conta:</th>
</tr>
</thead>
<?PHP
$query = "Select Name, clevel, Resetcount,exp_war,ctlcode,tempo,MapNumber,nivel_g m,nivel_gm,masterresetcount,dbo.fn_ml(Name), dbo.fn_online(name)
From
Character where accountid='$loginlog' order by character.nivel_gm desc, exp_war desc, resetcount desc";
$result = mssql_query( $query );
if (mssql_num_rows($result) > 0) {
?>
<tr style='background:transparent;'>
<td colspan=4>
<table border=0 cellSpacing=0 width=100%>
<thead>
<tr>
<th Colspan=9 style='height:2px;'></th>
</tr>
<tr>
<th>Nome:</th>
<th>M.Resets</th>
<th>Resets:</th>
<th>Level (ML):</th>
<th>Patente(EXP):</td>
<th>NÃ*vel:</th>
<th>Tempo(semanal):</th>
<th>Editar:</th>
</tr>
<?PHP
while($row = mssql_fetch_row($result))
{
$nome = $row[0];
$lvl = $row[1];
$resets = $row[2];
$exp = $row[3];
$ctl_cd = $row[4];
$min = $row[5];
$patente_num = str_pad($exp, 5, '0', STR_PAD_LEFT);
$niv = $row[7];
$eventos =$row[8];
$mresets =$row[9];
$ml =$row[10];
if ($row[0] == 1) $status = '';
include '../../inclu/patentes.php';
include '../../inclu/mapas.php';
include '../../inclu/tempo.php';
include '../../inclu/status_char.php';
echo "<tr>
<td><a href='info_char.php?name=$nome'><b>$nome</a>".(($row[11]==1) ? ' <img src="../img/Pisca.gif" title="online">' : '')."</td>
<td align=right>$mresets</td>
<td align=right>$resets</td>
<td align=right>$lvl($ml)</td>
<td style='text-align:left;'>$patente_num</font>-$patente</td>
<td><center>".(($niv>0) ? '<font color=$font_color2>' : '')."$nivel_gm</td>
<td>$H3 hs $m mins</td>
<td><a href='?&loginchar=$nome'><img src='../img/Edit.gif'></a></td>
</tr>";
}
echo "</table>";
}
else
{
echo "
<tr>
<td colspan=4> Nenhum personagem encontrado</td>
</tr>
";
}
?>
</td>
</tr>
<thead>
<tr>
<th Colspan=4>Adicionar Observação:</th>
</tr>
<tr>
<th colspan=2>Observação </th>
<th> Exibir no painel:</th>
<th> Adiconar </th>
</tr>
</thead>
<form name='form1' method='post' action="?post2=ok&loginlog=<?=$loginlog;?>">
<tr>
<td colspan=2><center>
<input type='text' name='comentario' maxlength='150' value='Coloque aqui sua observação' style='text-align:center;width:420' onClick="this.select();";></td>
<td><select name='mostrar' id='mostrar'>
<option value='0'> Ocultar </option>
<option value='1'> Mostrar </option>
</select></td>
<td><center><input type='submit' name='Submit' value='ADICIONAR'></td>
</tr></form>
</td></tr>
<tr>
<td colspan=4> </td>
</tr>
<thead>
<tr>
<th Colspan=4>Observações:</th>
</tr>
<tr>
<th colspan=2> Observação:</th>
<th>Exibir no painel</th>
<th>Editar </th>
</tr>
</thead>
<?php
$query = "Select data,obs,mostrar,id_obs From log_obs where login='$loginlog' order by id_obs desc";
$result = mssql_query( $query );
$xex = mssql_num_rows($result);
if ($xex <= 0 ) {
echo "
<tr>
<td colspan=4> Nenhuma Observação</td>
</tr>
";
}
for($i=0;$i < $xex;++$i)
{
$row = mssql_fetch_row($result);
$data = $row[0];
$obs_conta = utf8_decode($row[1]);
$mostrar = $row[2];
$id = $row[3];
$data = date_format(date_create("$data"), 'd/m/Y');
$sele1 = '';
$sele2 = '';
if ($mostrar=="1") $sele1='selected'; else $sele2='selected';
echo "
<form name='form1' method='post' action='?post3=ok&loginlog=$loginlog'>
<tr>
<td colspan=2>$data <input type='text' name='comentario' maxlength='150' value='$obs_conta' style='text-align:center;width:270' onClick="this.select();";></td>
<td><select name='mostrar' id='mostrar'>
<option value='1' $sele1> Mostrar </option>
<option value='0' $sele2> Ocultar </option>
</select>
</td>
<td>
<input type='image' src='../img/save.png' name='Submit' value='Continuar' style='border:0;background:transparent;'></form>
<a href='?post4=$id&loginlog=$loginlog'><img src='../img/excluir.png'></a></td>
</tr>";
}
echo "</table></td></tr></table><BR><BR>";
}
?>
</div>
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.