[PHP+MSSQL]

[Drinllyn]

Boa Noite a Todos como sou novo no forum se postei em luga errado por favor me avise.

Esto com um pequeno problema Esto com um site, Gostaria de acrecentar um comando a um já Existente.

no caso um comando referente ao Jogo Mu

no caso esse

<?
if (eregi("includes/character_manager.php", $_SERVER['SCRIPT_NAME'])) { die ("Access Denied!"); }
if (isset($_SESSION['user'])){$login = stripslashes($_SESSION['user']);}
include('config.php');
$login = clean_Var($login);
$query = "SELECT Name,Class,cLevel,Resets,Strength,Dexterity,Vitality,Energy,MapNumber,AccountID from Character where accountid=? order by Resets desc, cLevel desc ";
$query3 ="SELECT Name,Class,cLevel,Resets,Strength,Dexterity,Vitality,Energy,MapNumber,AccountID from Character where accountid=? order by Resets desc, cLevel desc ";
$result = $db->Execute($query,array($login));
$result3 = $db->Execute($query3,array($login));
$content='<table class="sort-table" id="table-1" height=30 border="0" cellpadding="0" cellspacing="0" width="490">                
          <thead><tr>
          <td class=thead2>Nº</td>
          <td class=thead2 title="Name Of Character">Nome</td>
          <td class=thead2>Raça</td>
          <td class=thead2>Level</td>
          <td class=thead2>Força</td>
          <td class=thead2>Agilidade</td>
          <td class=thead2>Vitalidade</td>
          <td class=thead2>Energia</td>
          </tr></thead>';
for($i=0;$i < $result->numrows();++$i)
{
$row = $result->fetchrow();

$query2="Select ConnectStat from MEMB_STAT where memb___id='$row[9]'";
$result2 = $db->Execute($query2);
$row3 = $result3->fetchrow();
$row2 = $result2->fetchrow();
$rank = $i+1;
if($row[1] == 0){ $row[1] ='DW';}
if($row[1] == 1){ $row[1] ='SM';}
if($row[1] == 16){ $row[1] ='DK';}
if($row[1] == 17){ $row[1] ='BK';}
if($row[1] == 32){ $row[1] ='ELF';}
if($row[1] == 33){ $row[1] ='ME';}
if($row[1] == 48){ $row[1] ='MG';}
if($row[1] == 64){ $row[1] ='DL';}

$reset_no_zen = '<span class=normal_text>Não Tem Zen</span> <img src=./images/warning.gif align=top>';
$reset_no_level = '<span class=normal_text>Não tá no level 350</span> <img src=./images/warning.gif align=top>';
$reset_allow = '<a href=#><img src=images/reset.png  border=0 onclick=reset_chr.submit()></a>';

$pk_no_zen = '<span class=normal_text>Não Tem Zen</span> <img src=./images/warning.gif align=top>';
$pk_no_kill = '<span class=normal_text>Não Tem PK</span> <img src=./images/warning.gif align=top>';
$pk_allow = '<a href=#><img src=images/clear_pk.png  border=0 onclick=clearpk.submit()></a>';

$stats_no_points = '<span class=normal_text>Não Tem pontos</span> <img src=./images/warning.gif align=top>';
$stats_allow = '<a href=#><img src=images/add_stats.png  border=0 onclick=stats.submit()></a>';

$info_query = $db->Execute("SELECT Name,Class,cLevel,Resets,money,PkLevel,LevelUpPoint from Character where name='$row[0]'");
$info_result = $info_query->fetchrow();
$info_result2 = $info_query->fetchrow();

$resetmoeny=$info_result[4]-($muweb['resetmoney']);
$money_check = $info_result[4]-($muweb['pkmoney']);

if($resetmoeny < 0){$reset_="$reset_no_zen";}
elseif($info_result[2] < $muweb['resetlevel']){$reset_="$reset_no_level";}
elseif($info_result[2] >= $muweb['resetlevel']){$reset_="$reset_allow";}

if($money_check  < 0){$pk_="$pk_no_zen";}
elseif($info_result[5] == 3){$pk_="$pk_no_kill";}
elseif($info_result[5] > 3){$pk_="$pk_allow";}

if($info_result[6] <= 0){$stats_="$stats_no_points";}
elseif($info_result[6] >= 1){$stats_="$stats_allow";}

$reset_table = "<table width=150 border=0 cellspacing=2 cellpadding=0><tr><td><form action=\'\' method=post name=reset_chr id=reset_chr><table width=260 border=0 cellspacing=0 cellpadding=0><tr><td width=110><span class=normal_text>Resetar Pesonagem:</span></td><td width=130 valign=bottom><div align=left><input name=reset_character type=hidden id=reset_character value=$row[0]><span class=style62>$reset_</span></div></td></tr></table></form></td></tr></table>";
$clearpk_table = "<table width=150 border=0 cellspacing=2 cellpadding=0><tr><td><form action=\'\' method=post name=clearpk id=clearpk><table width=260 border=0 cellspacing=0 cellpadding=0><tr><td width=110><span class=normal_text>Tira PK: </span></td><td width=130 valign=bottom><div align=left><input name=clearpk_character type=hidden id=clearpk_character value=$row[0]><span class=style62>$pk_</span></div></td></tr></table> </form></td> </tr></table>";
$statsadd_table = "<table width=150 border=0 cellspacing=2 cellpadding=0><tr><td><form action=\'\' method=post name=stats id=stats><table width=260 border=0 cellspacing=0 cellpadding=0><tr><td width=110><span class=normal_text>Distribuir Pontos: </span></td><td width=130 valign=bottom><div align=left><input name=stats_character type=hidden id=stats_character value=$row[0]><span class=style62>$stats_</span></div></td></tr></table></form></td></tr></table>";

$status_check="Select ConnectStat from MEMB_STAT where memb___id='$row[9]'";
$status_reults = $db->Execute($status_check);
$status = $status_reults->fetchrow();

if($status[0] == 0){ $status[0] ='<img src=./images/Offline.gif width=6 height=6>';
}
if($status[0] == 1){ $status[0] ='<img src=./images/Online.gif width=6 height=6 >';
}

$content .="<tbody><tr><td align=left><font color=#333333>$rank.</font></td>
            <td align=left>$status[0] <a class=helpLink2 href=? onclick=\"showHelpTip(event, '$reset_table $clearpk_table $statsadd_table' ,false); return false\">$row[0]</a></td>
            <td align=left><font color=#333333>$row[1]</font></td>
            <td align=left><font color=#333333>$row[2]</font><small style='color:red;'>[$row[3]]</small></td>
            <td align=left><font color=#333333>$row[4]</font></td>
            <td align=left><font color=#333333>$row[5]</font></td>
            <td align=left><font color=#333333>$row[6]</font></td>
            <td align=left><font color=#333333>$row[7]</font></td>
            </tr></tbody>";
}
$content .="</table>";
show($content);
?>

Esse comando no Caso Busca no Mssql as tabelas para reseta uma determinada tabela e Adicionar um a Outra Eu Gostaria de altera isso para Ele checa no Caso outra Tabela e e diminuir pontos Gastos EX:

Quando ele Checa Resetar o charactere XXXXXX e se ele tiver 50 resets ele não ganhara mais 200 pontos em na tabela pontos e sim 100!

muito obrigado e postem também se não entenderem.

Editado Março 4, 2009 por Drinllyn