Panelde User SıraLaması war Sadece Np ye Göre sıraLıyor kisiLeri Leader pointLer yazmıyor Leader Pointte ekLemek istiyorum
Buda User SıraLaması Dosyası Şimdiden tşk ederim...
<?php
$filename = "logs/log.log";
$handle= fopen($filename,'a+');
$_SERVER['REMOTE_ADDR'] ." Bilgileri: ". $_SERVER['HTTP_USER_AGENT'] ;
fputs($handle, $string);
fclose($handle);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>KoArea - User Rankings</title>
<body background="../images/arkaplan.bmp" bgcolor="#230000">
<link href="img/style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style1 {
font-size: 12px;
font-family: "Tahoma";
color: #61422F;
}
body {
background-color: #F6F2EE;
}
#apDiv1 {
position:absolute;
left:440px;
top:242px;
width:77px;
height:16px;
z-index:1;
}
#apDiv2 {
position:absolute;
left:441px;
top:365px;
width:79px;
height:18px;
z-index:2;
}
#apDiv3 {
position:absolute;
left:198px;
top:242px;
width:69px;
height:14px;
z-index:3;
}
#apDiv4 {
position:absolute;
left:201px;
top:474px;
width:44px;
height:17px;
z-index:4;
}
.style6 {
color: #61422F;
font-family: "Tahoma";
font-size: 14px;
font-weight: bold;
}
.style7 {color: #F8EBD3}
.style8 {color: #F8EBD3; font-family: "Tahoma"; font-size: 14px; font-weight: bold; }
.style9 {color: #915B1B; font-family: "Tahoma"; font-size: 14px; font-weight: bold; }
.style10 {font-size: 18px}
.style11 {font-size: 18px; color: #F8EBD3; }
.style12 {
font-size: 16px;
font-weight: bold;
}
.style13 { color: #F8EBD3;
font-family: "Tahoma";
font-size: 24px;
font-weight: bold;
}
-->
</style>
<script type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a.indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a;}}
}
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a)&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src;
x.src=a[i+2];}
}
function MM_jumpMenuGo(objId,targ,restore){ //v9.0
var selObj = null; with (document) {
if (getElementById) selObj = getElementById(objId);
if (selObj) eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0; }
}
//-->
</script>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
</head>
<body
onload="MM_preloadImages('btn/user_on.png','btn/regist_on.png','btn/clan_on.png','btn/current_o
n.png')">
<?
/// by extreme.
include ("ayar.php");
$connect = odbc_connect("$dbname", "$dbuser", "$dbpass") or die("Sql Servera baglanilamiyor,
odbc_error()");
$asd = 0;
$user_rank_job = odbc_exec($connect,"SELECT TOP ".$userrankingsnum." strUserId, Level, Nation,
Class, Knights, Loyalty strCharID FROM USERDATA WHERE Authority = 1 ORDER BY Loyalty DESC,
Level DESC");
function getNation($nation) {
if ($nation == 1) {
$nation = '<img src=img/karus.gif>';
} elseif ($nation == 2) {
$nation = '<img src=img/elmo.gif>';
}
return $nation;
}
function getClass($class) {
global $lang;
$class3 = $class;
$class2 = $class;
if ($class == 106) {
$class2 = '<img src=img/wroi.gif>';
}
if ($class == 108) {
$class2 = '<img src=img/rogu.gif>';
}
if ($class == 110) {
$class2 = '<img src=img/wiz.gif>';
}
if ($class == 112) {
$class2 = '<img src=img/puri.gif>';
}
if ($class == 205) {
$class2 = '<img src=img/wroi.gif>';
}
if ($class == 206) {
$class2 = '<img src=img/wroi.gif>';
}
if ($class == 207) {
$class2 = '<img src=img/rogu.gif>';
}
if ($class == 208) {
$class2 = '<img src=img/rogu.gif>';
}
if ($class == 209) {
$class2 = '<img src=img/wiz.gif>';
}
if ($class == 210) {
$class2 = '<img src=img/wiz.gif>';
}
if ($class == 211) {
$class2 = '<img src=img/puri.gif>';
}
if ($class == 212) {
$class2 = '<img src=img/puri.gif>';
}
if ($class2 == $class3) {
$class2 = '<img src=img/newbie.gif>';
}
return $class2;
}
$user_rank_tablo_1 = '
<table width="100%" cellpadding="0" style="font-size:10px; font-family:Verdana">
<tr bgcolor="#0e1928" style="color:#FFFFFF">
<td align="center">#</td>
<td align="center"> </td>
<td align="center">Character</td>
<td align="center">lvl</td>
<td align="center">Class</td>
<td align="center">Clan</td>
<td align="center">NP</td>
</tr>
';
echo $user_rank_tablo_1;
while (odbc_fetch_row($user_rank_job)) {
$user = odbc_result($user_rank_job, 1);
$lvl_job=odbc_exec($connect,"SELECT Level FROM USERDATA WHERE strUserId =
'".$user."'");
$lvl=odbc_result($lvl_job,1);
$nation = odbc_result($user_rank_job, 3);
$class = odbc_result($user_rank_job, 4);
$clan = odbc_result($user_rank_job, 5);
$clan_job=odbc_exec($connect,"SELECT IDName FROM KNIGHTS WHERE IDNum = '".$clan."'");
$clan=odbc_result($clan_job, 1);
if ($clan == '') {
$clan = '<img src=img/none.gif>';
}
$np = odbc_result($user_rank_job, 6);
$asd++;
$nation = getNation($nation);
$class = getClass($class);
$user_rank_tablo_2 = '
<td align="center">'.$nation.'</td>
<td align="center">'.$asd.'</td>
<td align="center">'.$user.'</td>
<td align="center">'.$lvl.'</td>
<td align="center">'.$class.'</td>
<td align="center">'.$clan.'</td>
<td align="center">'.$np.'</td>
<td align="center">'.$lp.'</td>
</tr>
';echo $user_rank_tablo_2;
}
$clan_rank_tablo_3 = '
<table width="100%" cellpadding="0" cellspacing="0" style="font-size:10px; font-family:Verdana">
<tr bgcolor="#0e1928" style="color:#FFFFFF">
<td align="center">'.$asd.' User Showing</td>
</tr>
</table> </td>
</tr>
</tbody>
</table>
';
echo $clan_rank_tablo_3;
?>
</body>
</html>
</html>
</html>
Buda User SıraLaması Dosyası Şimdiden tşk ederim...
<?php
$filename = "logs/log.log";
$handle= fopen($filename,'a+');
$_SERVER['REMOTE_ADDR'] ." Bilgileri: ". $_SERVER['HTTP_USER_AGENT'] ;
fputs($handle, $string);
fclose($handle);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>KoArea - User Rankings</title>
<body background="../images/arkaplan.bmp" bgcolor="#230000">
<link href="img/style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style1 {
font-size: 12px;
font-family: "Tahoma";
color: #61422F;
}
body {
background-color: #F6F2EE;
}
#apDiv1 {
position:absolute;
left:440px;
top:242px;
width:77px;
height:16px;
z-index:1;
}
#apDiv2 {
position:absolute;
left:441px;
top:365px;
width:79px;
height:18px;
z-index:2;
}
#apDiv3 {
position:absolute;
left:198px;
top:242px;
width:69px;
height:14px;
z-index:3;
}
#apDiv4 {
position:absolute;
left:201px;
top:474px;
width:44px;
height:17px;
z-index:4;
}
.style6 {
color: #61422F;
font-family: "Tahoma";
font-size: 14px;
font-weight: bold;
}
.style7 {color: #F8EBD3}
.style8 {color: #F8EBD3; font-family: "Tahoma"; font-size: 14px; font-weight: bold; }
.style9 {color: #915B1B; font-family: "Tahoma"; font-size: 14px; font-weight: bold; }
.style10 {font-size: 18px}
.style11 {font-size: 18px; color: #F8EBD3; }
.style12 {
font-size: 16px;
font-weight: bold;
}
.style13 { color: #F8EBD3;
font-family: "Tahoma";
font-size: 24px;
font-weight: bold;
}
-->
</style>
<script type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a.indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a;}}
}
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a)&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src;
x.src=a[i+2];}
}
function MM_jumpMenuGo(objId,targ,restore){ //v9.0
var selObj = null; with (document) {
if (getElementById) selObj = getElementById(objId);
if (selObj) eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0; }
}
//-->
</script>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
</head>
<body
onload="MM_preloadImages('btn/user_on.png','btn/regist_on.png','btn/clan_on.png','btn/current_o
n.png')">
<?
/// by extreme.
include ("ayar.php");
$connect = odbc_connect("$dbname", "$dbuser", "$dbpass") or die("Sql Servera baglanilamiyor,
odbc_error()");
$asd = 0;
$user_rank_job = odbc_exec($connect,"SELECT TOP ".$userrankingsnum." strUserId, Level, Nation,
Class, Knights, Loyalty strCharID FROM USERDATA WHERE Authority = 1 ORDER BY Loyalty DESC,
Level DESC");
function getNation($nation) {
if ($nation == 1) {
$nation = '<img src=img/karus.gif>';
} elseif ($nation == 2) {
$nation = '<img src=img/elmo.gif>';
}
return $nation;
}
function getClass($class) {
global $lang;
$class3 = $class;
$class2 = $class;
if ($class == 106) {
$class2 = '<img src=img/wroi.gif>';
}
if ($class == 108) {
$class2 = '<img src=img/rogu.gif>';
}
if ($class == 110) {
$class2 = '<img src=img/wiz.gif>';
}
if ($class == 112) {
$class2 = '<img src=img/puri.gif>';
}
if ($class == 205) {
$class2 = '<img src=img/wroi.gif>';
}
if ($class == 206) {
$class2 = '<img src=img/wroi.gif>';
}
if ($class == 207) {
$class2 = '<img src=img/rogu.gif>';
}
if ($class == 208) {
$class2 = '<img src=img/rogu.gif>';
}
if ($class == 209) {
$class2 = '<img src=img/wiz.gif>';
}
if ($class == 210) {
$class2 = '<img src=img/wiz.gif>';
}
if ($class == 211) {
$class2 = '<img src=img/puri.gif>';
}
if ($class == 212) {
$class2 = '<img src=img/puri.gif>';
}
if ($class2 == $class3) {
$class2 = '<img src=img/newbie.gif>';
}
return $class2;
}
$user_rank_tablo_1 = '
<table width="100%" cellpadding="0" style="font-size:10px; font-family:Verdana">
<tr bgcolor="#0e1928" style="color:#FFFFFF">
<td align="center">#</td>
<td align="center"> </td>
<td align="center">Character</td>
<td align="center">lvl</td>
<td align="center">Class</td>
<td align="center">Clan</td>
<td align="center">NP</td>
</tr>
';
echo $user_rank_tablo_1;
while (odbc_fetch_row($user_rank_job)) {
$user = odbc_result($user_rank_job, 1);
$lvl_job=odbc_exec($connect,"SELECT Level FROM USERDATA WHERE strUserId =
'".$user."'");
$lvl=odbc_result($lvl_job,1);
$nation = odbc_result($user_rank_job, 3);
$class = odbc_result($user_rank_job, 4);
$clan = odbc_result($user_rank_job, 5);
$clan_job=odbc_exec($connect,"SELECT IDName FROM KNIGHTS WHERE IDNum = '".$clan."'");
$clan=odbc_result($clan_job, 1);
if ($clan == '') {
$clan = '<img src=img/none.gif>';
}
$np = odbc_result($user_rank_job, 6);
$asd++;
$nation = getNation($nation);
$class = getClass($class);
$user_rank_tablo_2 = '
<td align="center">'.$nation.'</td>
<td align="center">'.$asd.'</td>
<td align="center">'.$user.'</td>
<td align="center">'.$lvl.'</td>
<td align="center">'.$class.'</td>
<td align="center">'.$clan.'</td>
<td align="center">'.$np.'</td>
<td align="center">'.$lp.'</td>
</tr>
';echo $user_rank_tablo_2;
}
$clan_rank_tablo_3 = '
<table width="100%" cellpadding="0" cellspacing="0" style="font-size:10px; font-family:Verdana">
<tr bgcolor="#0e1928" style="color:#FFFFFF">
<td align="center">'.$asd.' User Showing</td>
</tr>
</table> </td>
</tr>
</tbody>
</table>
';
echo $clan_rank_tablo_3;
?>
</body>
</html>
</html>
</html>
Son düzenleme: