Panelde 1.siralamasi np ye gore degilde lp gore nasil yapariz userrankİng kodu vrdm

  • Konbuyu başlatan Konbuyu başlatan aykutsel
  • Başlangıç tarihi Başlangıç tarihi
aykutsel
Konu Yazar

aykutsel

Member
Kas
437
1
PANELDE 1.SIRALAMASI NP YE GORE DEGILDE LiderPointe GORE NASIL YAPARIZ BİLEN WARSA YARDIM LUTFENNN

USERRANKİNG kodlarım yaparsanız sevınırım


PHP: 
<?php

include('./anti_inject.php');

$title = $name." ".$lang[31];

if (!empty($_GET['num'])) {
    $userrankingsnum = $_GET['num'];
}
$userrankingsnum = test($userrankingsnum);

parth1('5%','','center');
echo $lang[0];
parth2();
parth1('10%','','center');
echo $lang[3];
parth2();
parth1('30%','','center');
echo $lang[1];
parth2();
parth1('10%','','center');
echo $lang[2];
parth2();
parth1('20%','','center');
echo $lang[4];
parth2();
parth1('30%','','center');
echo $lang[5];
parth2();
parth1('15%','','center');
echo $lang[6];
parth2();
parth2tr();

$count = 0;
$msconnect=odbc_connect("$dbname","$dbuser","$dbpass");
$results=odbc_exec($msconnect,"SELECT TOP ".$userrankingsnum." strUserID, Level, Nation, Class, Knights, Loyalty, LoyaltyMonthly  FROM USERDATA Where Authority = 1 or Authority = 2 ORDER BY Loyalty DESC, Level DESC");

while (odbc_fetch_row($results)) {
    // Data
    $user = odbc_result($results, 1);
    $lvlr=odbc_exec($msconnect,"SELECT Level FROM USERDATA WHERE strUserId = '".$user."'");
    $lvl=odbc_result($lvlr,1);
    $nation = odbc_result($results, 3);
    $class = odbc_result($results, 4);
    $clan = odbc_result($results, 5);
    $clan2 = odbc_result($results, 5);
    $clanr=odbc_exec($msconnect,"SELECT IDName FROM KNIGHTS WHERE IDNum = '$clan'");
    $clan=odbc_result($clanr, 1);
    if ($clan == '') {
        $clan = 'None';
    }
    $np = odbc_result($results, 6);
    $np2 = odbc_result($results, 7);
    $count++;

    // Change Info
    $nation = getNation($nation);
    $class = getClass($class);

    part1tr();
    part2();
    part1('5%',1,1,'center');
    echo $count;
    if ($nation=='Karus')
    {
        
        part1('10%',1,1,'top');
        image($skindir.'karus.gif');
        part2();
    }
    else
    {
        part1('10%',1,1,'top');
        image($skindir.'elmo.gif');
        part2();
    }    

    part1('30%',1,1,'center');
    echo '<A class="mlink" HREF="index.php?act=userdet&userid='.$user.'">'.$user.'</A>';
    part2();
    part1('10%',1,1,'center');
    echo $lvl;
    part2();
    part1('20%',1,1,'center');
    echo $class;
    part2();
    part1('30%',1,1,'center');
    if ($clan == 'None')
    {
        echo 'None';
    }
    else echo '<A class="mlink" HREF="index.php?act=clan&id='.$clan2.'">'.$clan.'</A>';
    part2();
    part1('15%',1,1,'center');
    echo $np;
    part2();
    part1('15%',1,1,'center');
    echo $np2;
    part2();
    part2tr();
    
}
?>
 
Son düzenleme:
Cevap: Panelde 1.siralamasi np ye gore degilde lp gore nasil yapariz userrankİng kodu

PHP: 
<?php

include('./anti_inject.php');

$title = $name." ".$lang[31];

if (!empty($_GET['num'])) {
    $userrankingsnum = $_GET['num'];
}
$userrankingsnum = test($userrankingsnum);

parth1('5%','','center');
echo $lang[0];
parth2();
parth1('10%','','center');
echo $lang[3];
parth2();
parth1('30%','','center');
echo $lang[1];
parth2();
parth1('10%','','center');
echo $lang[2];
parth2();
parth1('20%','','center');
echo $lang[4];
parth2();
parth1('30%','','center');
echo $lang[5];
parth2();
parth1('15%','','center');
echo $lang[6];
parth2();
parth2tr();

$count = 0;
$msconnect=odbc_connect("$dbname","$dbuser","$dbpass");
$results=odbc_exec($msconnect,"SELECT TOP ".$userrankingsnum." strUserID, Level, Nation, Class, Knights, Loyalty, LoyaltyMonthly  FROM USERDATA Where Authority = 1 or Authority = 2 ORDER BY Loyalty DESC, Level DESC");

while (odbc_fetch_row($results)) {
    // Data
    $user = odbc_result($results, 1);
    $lvlr=odbc_exec($msconnect,"SELECT Level FROM USERDATA WHERE strUserId = '".$user."'");
    $lvl=odbc_result($lvlr,1);
    $nation = odbc_result($results, 3);
    $class = odbc_result($results, 4);
    $clan = odbc_result($results, 5);
    $clan2 = odbc_result($results, 5);
    $clanr=odbc_exec($msconnect,"SELECT IDName FROM KNIGHTS WHERE IDNum = '$clan'");
    $clan=odbc_result($clanr, 1);
    if ($clan == '') {
        $clan = 'None';
    }
    $np = odbc_result($results, 6);
    $np2 = odbc_result($results, 7);
    $count++;

    // Change Info
    $nation = getNation($nation);
    $class = getClass($class);

    part1tr();
    part2();
    part1('5%',1,1,'center');
    echo $count;
    if ($nation=='Karus')
    {
        
        part1('10%',1,1,'top');
        image($skindir.'karus.gif');
        part2();
    }
    else
    {
        part1('10%',1,1,'top');
        image($skindir.'elmo.gif');
        part2();
    }    

    part1('30%',1,1,'center');
    echo '<A class="mlink" HREF="index.php?act=userdet&userid='.$user.'">'.$user.'</A>';
    part2();
    part1('10%',1,1,'center');
    echo $lvl;
    part2();
    part1('20%',1,1,'center');
    echo $class;
    part2();
    part1('30%',1,1,'center');
    if ($clan == 'None')
    {
        echo 'None';
    }
    else echo '<A class="mlink" HREF="index.php?act=clan&id='.$clan2.'">'.$clan.'</A>';
    part2();
    part1('15%',1,1,'center');
    echo $np;
    part2();
    part1('15%',1,1,'center');
    echo $np2;
    part2();
    part2tr();
    
}
?>
$count = 0;
$msconnect=odbc_connect("$dbname","$dbuser","$dbpass");
$results=odbc_exec($msconnect,"SELECT TOP ".$userrankingsnum." strUserID, Level, Nation, Class, Knights, Loyalty, LoyaltyMonthly FROM USERDATA Where Authority = 1 or Authority = 2 ORDER BY LoyaltyMonthly DESC, Level DESC");
Genişletmek için tıkla ...
burda kodun sonunda "order by loyalty desc,level desc" demiş gördün mü
genel np ye göre büyükten küçüğe sırala demek bu ve ayrıca level a göre de sırala denmiş
sen burayı "order by loyaltymonthly desc,level desc" yaparsan istediğin şekli alır.

açıklamayı yaptıktan sonra

kodun tamamıne eklersek bunu

düzenlenmiş hali
PHP: 
<?php

include('./anti_inject.php');

$title = $name." ".$lang[31];

if (!empty($_GET['num'])) {
    $userrankingsnum = $_GET['num'];
}
$userrankingsnum = test($userrankingsnum);

parth1('5%','','center');
echo $lang[0];
parth2();
parth1('10%','','center');
echo $lang[3];
parth2();
parth1('30%','','center');
echo $lang[1];
parth2();
parth1('10%','','center');
echo $lang[2];
parth2();
parth1('20%','','center');
echo $lang[4];
parth2();
parth1('30%','','center');
echo $lang[5];
parth2();
parth1('15%','','center');
echo $lang[6];
parth2();
parth2tr();

$count = 0;
$msconnect=odbc_connect("$dbname","$dbuser","$dbpass");
$results=odbc_exec($msconnect,"SELECT TOP ".$userrankingsnum." strUserID, Level, Nation, Class, Knights, Loyalty, LoyaltyMonthly  FROM USERDATA Where Authority = 1 or Authority = 2 ORDER BY LoyaltyMonthly DESC, Level DESC");

while (odbc_fetch_row($results)) {
    // Data
    $user = odbc_result($results, 1);
    $lvlr=odbc_exec($msconnect,"SELECT Level FROM USERDATA WHERE strUserId = '".$user."'");
    $lvl=odbc_result($lvlr,1);
    $nation = odbc_result($results, 3);
    $class = odbc_result($results, 4);
    $clan = odbc_result($results, 5);
    $clan2 = odbc_result($results, 5);
    $clanr=odbc_exec($msconnect,"SELECT IDName FROM KNIGHTS WHERE IDNum = '$clan'");
    $clan=odbc_result($clanr, 1);
    if ($clan == '') {
        $clan = 'None';
    }
    $np = odbc_result($results, 6);
    $np2 = odbc_result($results, 7);
    $count++;

    // Change Info
    $nation = getNation($nation);
    $class = getClass($class);

    part1tr();
    part2();
    part1('5%',1,1,'center');
    echo $count;
    if ($nation=='Karus')
    {
        
        part1('10%',1,1,'top');
        image($skindir.'karus.gif');
        part2();
    }
    else
    {
        part1('10%',1,1,'top');
        image($skindir.'elmo.gif');
        part2();
    }    

    part1('30%',1,1,'center');
    echo '<A class="mlink" HREF="index.php?act=userdet&userid='.$user.'">'.$user.'</A>';
    part2();
    part1('10%',1,1,'center');
    echo $lvl;
    part2();
    part1('20%',1,1,'center');
    echo $class;
    part2();
    part1('30%',1,1,'center');
    if ($clan == 'None')
    {
        echo 'None';
    }
    else echo '<A class="mlink" HREF="index.php?act=clan&id='.$clan2.'">'.$clan.'</A>';
    part2();
    part1('15%',1,1,'center');
    echo $np;
    part2();
    part1('15%',1,1,'center');
    echo $np2;
    part2();
    part2tr();
    
}
?>
 
Cevap: Panelde 1.siralamasi np ye gore degilde lp gore nasil yapariz userrankİng kodu

Eyw saol eline koluna sagilik
 
Cevap yazmak için giriş yap yada kayıt ol.

Online istatistikleri

Çevrimiçi kullanıcılar
2
Çevrimiçi ziyaretçiler
1,428
Toplam ziyaretçi
1,430
Toplamlar, gizli ziyaretçiler içerebilir.

About Us

Ko-Cuce.Net 2007 yılından bu yana pvp serverler tanıtım sektöründe öncü tanıtım sitesi olarak yayın hayatına devam eden bir private server forum sitesidir. 2007 yılından bu yana Ko-Cuce.Net olarak hizmet veren ve tüm oyunlara oyuncu katkısı sağlayan bir lider platform'dur Pvp Serverler m3u iptv gamers4life metin2 pvp Knight Online Pvp

silkroad private server

En yeni üyeler

Stay Connected

Geri
Üst Alt