Kopanelle İlgili Soru :)

Viva La Muerte · 28 May 2008

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">&nbsp;</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

Ganks · 28 May 2008

Cevap: Kopanelle İlgili Soru

Şu an cafedeyim
Eve gidince sana yardım edeceğim..

Viva La Muerte · 28 May 2008

Cevap: Kopanelle İlgili Soru

valla ganks bu soruyu cevaplayabilirsen çok memnun olucam

Ganks · 28 May 2008

Cevap: Kopanelle İlgili Soru

PHP:

<? 

// Code BY ganks...
// ko-cuce.Com için kodLanmistir !
$connect = odbc_connect("$dbname", "$dbuser", "$dbpass") or die("SQL Servera Baglanilamiyor, odbc_error()");

$results=odbc_exec($connect,"SELECT strUserID FROM USERDATA");

while (odbc_fetch_row($results)) {
}
$user = odbc_result($results,1);
$userler = odbc_exec($connect, "SELECT strCharID1, strCharID2, strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = '".$_SESSION['sesuser']."'");
        $carbir = odbc_result($userler, 1);
        $cariki = odbc_result($userler, 2);
        $carc = odbc_result($userler, 3);

$userler = odbc_exec($connect, "SELECT Level, Exp, Loyalty, Strong, Sta, Dex, Intel, Cha, Authority, Gold FROM USERDATA WHERE StrUserID = '".$carbir."'");
        $level = odbc_result($userler, 1);
        $exp = odbc_result($userler, 2);
        $np = odbc_result($userler, 3);
        $str = odbc_result($userler, 4);
        $hp = odbc_result($userler, 5);
        $dex = odbc_result($userler, 6);
        $int = odbc_result($userler, 7);
        $magic = odbc_result($userler, 8);
        $authority = odbc_result($userler, 9);
        $gold = odbc_result($userler, 10);
        

$userlers = odbc_exec($connect, "SELECT Level, Exp, Loyalty, Strong, Sta, Dex, Intel, Cha, Authority, Gold FROM USERDATA WHERE StrUserID = '".$cariki."'");
        $levels = odbc_result($userlers, 1);
        $exps = odbc_result($userlers, 2);
        $nps = odbc_result($userlers, 3);
        $strs = odbc_result($userlers, 4);
        $hps = odbc_result($userlers, 5);
        $dexs = odbc_result($userlers, 6);
        $ints = odbc_result($userlers, 7);
        $magics = odbc_result($userlers, 8);
        $authoritys = odbc_result($userlers, 9);
        $golds = odbc_result($userler, 10);
        
        $userlert = odbc_exec($connect, "SELECT Level, Exp, Loyalty, Strong, Sta, Dex, Intel, Cha, Authority, Gold FROM USERDATA WHERE StrUserID = '".$carc."'");
        $levelt = odbc_result($userlert, 1);
        $expt = odbc_result($userlert, 2);
        $npt = odbc_result($userlert, 3);
        $strt = odbc_result($userlert, 4);
        $hpt = odbc_result($userlert, 5);
        $dext = odbc_result($userlert, 6);
        $intt = odbc_result($userlert, 7);
        $magict = odbc_result($userlert, 8);
        $authorityt = odbc_result($userlert, 9);
        


if ($security == 1) {
echo '<table width="955" height="46" border="1" cellspacing="0">
  <tr>
    <td width="107"><div align="center">Level</div></td>
    <td width="80"><div align="center">Exp</div></td>
    <td width="68"><div align="center">Np</div></td>
    <td width="62"><div align="center">Str</div></td>
    <td width="65"><div align="center">Hp</div></td>
    <td width="83"><div align="center">Dex</div></td>
    <td width="50"><div align="center">int</div></td>
    <td width="74"><div align="center">Mp</div></td>
    <td width="126"><div align="center">Char Durumu</div></td>
    <td width="198">Char İsmi</td>
  </tr>
  <tr>
    <td>'.$level.'</td>
    <td>'.$exp.'</td>
    <td>'.$np.'</td>
    <td>'.$str.'</td>
    <td>'.$hp.'</td>
    <td>'.$dex.'</td>
    <td>'.$int.'</td>
    <td>'.$magic.'</td>
    <td>'.$authority.'</td>
    <td>'.$carbir.'</td>
  </tr>
   <tr>
    <td>'.$levels.'</td>
    <td>'.$exps.'</td>
    <td>'.$nps.'</td>
    <td>'.$strs.'</td>
    <td>'.$hps.'</td>
    <td>'.$dexs.'</td>
    <td>'.$ints.'</td>
    <td>'.$magics.'</td>
    <td>'.$authoritys.'</td>
    <td>'.$cariki.'</td>
  </tr>
     <tr>
    <td>'.$levelt.'</td>
    <td>'.$expt.'</td>
    <td>'.$npt.'</td>
    <td>'.$strt.'</td>
    <td>'.$hpt.'</td>
    <td>'.$dext.'</td>
    <td>'.$intt.'</td>
    <td>'.$magict.'</td>
    <td>'.$authorityt.'</td>
    <td>'.$carc.'</td>
  </tr>
</table>
</table>';

}
else {
echo "GMLere ayit bir bolum...";

}

// Code End :)
// emege saygı ! Code by ganks...
 ?>

Buyur senin için en baştan kodladım Hayrını gör..
+rep :d

Viva La Muerte · 28 May 2008

Cevap: Kopanelle İlgili Soru

Teşekkür Ederim Ganks

Çok Makbule Geçti...
Ayrıca Repledim

Eno7 · 5 Haz 2008

Cevap: Kopanelle İlgili Soru

Mami gene günün kurtarıcısı

Kopanelle İlgili Soru :)

Viva La Muerte

Kimseye Etmem Şikayet

Ganks

Well-Known Member

Viva La Muerte

Kimseye Etmem Şikayet

Ganks

Well-Known Member

Viva La Muerte

Kimseye Etmem Şikayet

Eno7

Kıdemli Cüce

Online istatistikleri

About Us

En yeni üyeler

Kopanelle İlgili Soru :)

Viva La Muerte

Kimseye Etmem Şikayet

Ganks

Well-Known Member

Viva La Muerte

Kimseye Etmem Şikayet

Ganks

Well-Known Member

Viva La Muerte

Kimseye Etmem Şikayet

Eno7

Kıdemli Cüce

Online istatistikleri

About Us

En yeni üyeler

Stay Connected