Konu Yazar
Viva La Muerte
Kimseye Etmem Şikayet
- May
- 525
- 28
PHP:
<?
if ($security == 1) {
$msconnect=odbc_connect("$dbname","$dbuser","$dbpass");
$msteste="SELECT us.strUserID, us.Level, us.Loyalty, us.Gold, us.Strong, us.Dex, us.Sta, us.Intel, us.Cha, us.Class, us.Nation, us.Knights, us.strSkill, us.Exp FROM USERDATA us, ACCOUNT_CHAR ac, TB_USER tu WHERE tu.strAccountID = '".$_SESSION['sesuser']."' AND (ac.strCharID1 = us.strUserID OR ac.strCharID2 = us.strUserID OR ac.strCharID3 = us.strUserID) AND ac.strAccountID = '".$_SESSION['sesuser']."'";
$msresul=odbc_exec($msconnect,$msteste) or die(odbc_error());
$information = '';
$totalChar = 0;
$totalGold = 0;
while (odbc_fetch_row($msresul)) {
$name = odbc_result($msresul, 1);
$level = odbc_result($msresul, 2);
$np = odbc_result($msresul, 3);
$gold = odbc_result($msresul, 4);
$str = odbc_result($msresul, 5);
$dxt = odbc_result($msresul, 6);
$vit = odbc_result($msresul, 7);
$int = odbc_result($msresul, 8);
$mag = odbc_result($msresul, 9);
$mstest="SELECT Exp FROM Level_Up WHERE level = $level + 1";
$msresult=odbc_exec($msconnect,$mstest);
$exp2 = odbc_result($msresult, 1);
$class = getClass(odbc_result($msresul, 10));
$nation = getNation(odbc_result($msresul, 11));
$clan = odbc_result($msresul, 12);
$skill = odbc_result($msresul, 13);
$exp = odbc_result($msresul, 14);
$skills = getSkills($skill);
$skill1 = $skills[5];
$skill2 = $skills[6];
$skill3 = $skills[7];
$unused = $skills[0];
$nameSkills = getNameSkills($class);
$nameSkill1 = $nameSkills[1];
$nameSkill2 = $nameSkills[2];
$nameSkill3 = $nameSkills[3];
$getClan = "SELECT k.IDName FROM KNIGHTS k, KNIGHTS_USER ku WHERE ku.strUserID = '$name' AND ku.sIDNum = k.IDNum";
$msclan=odbc_exec($msconnect,$getClan) or die(odbc_error());
odbc_fetch_row($msclan);
$clan = odbc_result($msclan, 1);
$actions = "";
if (!empty($clan)) {
$actions .= '
<tr>
<td class="alt2" width="50%" colspan="1" align="center" height="4"><a onClick="alert(\'Coming...\')">Clandan Çýk</a></td>
</tr>
';
}
$charsinformation = '
<tr align="center">
<td class="thead" width="60%" colspan="1" align="center" height="4">Karakter Adi: '.$name.'</td>
<td class="thead" width="40%" colspan="1" align="center" height="4">Clan: '.$clan.'</td>
</tr>
<tr align="center">
<td class="alt1" width="100%" colspan="2" align="left" height="4">
<table class="tborder" align="left" border="0" cellpadding="2" cellspacing="1" width="50%" style="float:left;">
<tr>
<td class="alt1" width="100%" colspan="2" align="center" height="4">Karakter Hakkýnda</td>
</tr>
<tr>
<td class="alt1" width="50%" colspan="1" align="left" height="4">Level</td>
<td class="alt2" width="50%" colspan="1" align="center" height="4">'.$level.'</td>
</tr>
<tr>
<td class="alt1" width="50%" colspan="1" align="left" height="4">Experience</td>
<td class="alt2" width="50%" colspan="1" align="center" height="4">'.$exp.'/'.$exp2.'</td>
</tr>
<tr>
<td class="alt1" width="50%" colspan="1" align="left" height="4">Is</td>
<td class="alt2" width="50%" colspan="1" align="center" height="4">'.$class.'</td>
</tr>
<tr>
<td class="alt1" width="50%" colspan="1" align="left" height="4">Irk</td>
<td class="alt2" width="50%" colspan="1" align="center" height="4">'.$nation.'</td>
</tr>
<tr>
<td class="alt1" width="50%" colspan="1" align="left" height="4">Para</td>
<td class="alt2" width="50%" colspan="1" align="center" height="4">'.$gold.'</td>
</tr>
<tr>
<td class="alt1" width="50%" colspan="1" align="left" height="4">National Point</td>
<td class="alt2" width="50%" colspan="1" align="center" height="4">'.$np.'</td>
</tr>
</table>
<table class="tborder" align="left" border="0" cellpadding="2" cellspacing="1" width="20%" style="float:left;margin-left:2px;">
<tr>
<td class="alt1" width="100%" colspan="2" align="center" height="4">Statlariniz</td>
</tr>
<tr>
<td class="alt1" width="50%" colspan="1" align="left" height="4">STR</td>
<td class="alt2" width="50%" colspan="1" align="center" height="4">'.$str.'</td>
</tr>
<tr>
<td class="alt1" width="50%" colspan="1" align="left" height="4">DXT</td>
<td class="alt2" width="50%" colspan="1" align="center" height="4">'.$dxt.'</td>
</tr>
<tr>
<td class="alt1" width="50%" colspan="1" align="left" height="4">HP</td>
<td class="alt2" width="50%" colspan="1" align="center" height="4">'.$vit.'</td>
</tr>
<tr>
<td class="alt1" width="50%" colspan="1" align="left" height="4">INT</td>
<td class="alt2" width="50%" colspan="1" align="center" height="4">'.$int.'</td>
</tr>
<tr>
<td class="alt1" width="50%" colspan="1" align="left" height="4">MP</td>
<td class="alt2" width="50%" colspan="1" align="center" height="4">'.$mag.'</td>
</tr>
</table>
<table class="tborder" align="left" border="0" cellpadding="2" cellspacing="1" width="30%" style="float:left;margin-left:2px;">
<tr>
<td class="alt1" width="100%" colspan="2" align="center" height="4">Skilleriniz</td>
</tr>
<tr>
<td class="alt1" width="50%" colspan="1" align="left" height="4">'.$nameSkill1.'</td>
<td class="alt2" width="50%" colspan="1" align="center" height="4">'.$skill1.'</td>
</tr>
<tr>
<td class="alt1" width="50%" colspan="1" align="left" height="4">'.$nameSkill2.'</td>
<td class="alt2" width="50%" colspan="1" align="center" height="4">'.$skill2.'</td>
</tr>
<tr>
<td class="alt1" width="50%" colspan="1" align="left" height="4">'.$nameSkill3.'</td>
<td class="alt2" width="50%" colspan="1" align="center" height="4">'.$skill3.'</td>
</tr>
<tr>
<td class="alt1" width="50%" colspan="1" align="left" height="4">Kullanilmayan Puan</td>
<td class="alt2" width="50%" colspan="1" align="center" height="4">'.$unused.'</td>
</tr>
</table><br>
</td>
</tr>
<tr><td class="alt2" colspan="2"> </td></tr>
';
$totalChar++;
$totalGold += $gold;
}
if (empty($charsinformation)) {
$charsinformation = "<br><center>Karakter Yok.</center>";
} else {
$selVault = "SELECT nMoney FROM WAREHOUSE WHERE strAccountID ='".$_SESSION['sesuser']."'";
$msVault=odbc_exec($msconnect,$selVault) or die(odbc_error());
odbc_fetch_row($msVault);
$goldVault = odbc_result($msVault, 1);
if (empty($goldVault)) { $goldVault = 0; }
$accountinformation = '
<tr><td class="alt2" colspan="2" align="center">
<table class="tborder" align="center" border="0" cellpadding="2" cellspacing="1" width="50%">
<tr>
<td class="alt1" width="100%" colspan="2" align="center" height="4">Hesabiniz Hakkinda</td>
</tr>
<tr>
<td class="alt1" width="50%" colspan="1" align="left" height="4">Hesabinizdaki Karakter Sayisi</td>
<td class="alt2" width="50%" colspan="1" align="center" height="4">'.$totalChar.'</td>
</tr>
<tr>
<td class="alt1" width="50%" colspan="1" align="left" height="4">Karakterlerinizdeki Toplam Para</td>
<td class="alt2" width="50%" colspan="1" align="center" height="4">'.$totalGold.'</td>
</tr>
<tr>
<td class="alt1" width="50%" colspan="1" align="left" height="4">Bankanizdaki Para</td>
<td class="alt2" width="50%" colspan="1" align="center" height="4">'.$goldVault.'</td>
</tr>
<tr>
<td class="alt1" width="50%" colspan="1" align="left" height="4">Toplam Paraniz</td>
<td class="alt2" width="50%" colspan="1" align="center" height="4">'.($totalGold+$goldVault).'</td>
</tr>
</table>
</td></tr>
';
}
$accountInfo = '
<table class="tborder" align="center" border="0" cellpadding="6" cellspacing="1" width="100%">
<tbody id="" style="">
'.$charsinformation.' <br> '.$accountinformation.'
</tbody>
</table>
<br>';
parth1tr();
parth1('25%', 1, 1);
echo 'Hesap Bilgisi';
parth2();
parth2tr();
part1tr();
part1('25%', 1, 1, 'left');
echo $accountInfo;
part2();
part2tr();
}
?>bu kod ko paneldeki account.php
kullanıcıların bilgilerini gösteriyor(stat, skill, gold, np, level vs vs ) zaten biliyorsunuzdur ne işe yaradığınıda soruyu tam sorabilmek için ön bilgiyi vereyim dedim...
Bu Kodda Şöyle Bişey Var Yalnız Hesaptaki Tüm Karakterleri Değil Sadece Bir Tek Karakteri Gösteriyor Nasıl Yapabilirim Diye Düşündüm Düşündüm Aklıma Yukardaki kodda şu kısmı değiştirmek geldi....
AND (ac.strCharID1 = us.strUserID OR ac.strCharID2 = us.strUserID OR ac.strCharID3 = us.strUserID) AND ac.strAccountID = '".$_SESSION['sesuser']."'";
burda strcharID1 strcharID2 ve strcharID3 yazan kısımları strcharID1 olarak değiştirdim .... sonra en üstteki kodu 3 kere alt alta yapıştırdım ve strchardID2 ve strcharID3 üde aynı şekilde yaptım... ama şöyle bir sorun oluştu...
mesela hesapta strcharid1 var... strcharid2 var ama strcharid3 yok
işte strcharid3 olmadığında stchardid2 yada strcharid1 in bilgilerini gösteriyor ben istiyorumki strchardid3 boşsa hiç göstermesin böyle bir ekleme yapılabilirmi ?
Yardımlarınızı Bekliyorum
