Ijji website (ranking)

**Gosu[ru]** · 15-02-11

Ehm, rank don't work

Tables on database
Character Ranking varchar(50)

**MentaL**

**rahulbisme** · 15-02-11

Mine did that too. It just took some time to update.

**Gosu[ru]** · 15-02-11

Originally Posted by rahulbisme

Mine did that too. It just took some time to update.

Don't work..

**wesman2232** · 15-02-11

Check to see if the character has an actual "rank" in the DB.

Or you could post the script here and I'll delete anything keeping it from showing up.

**Gosu[ru]** · 15-02-11

Originally Posted by wesman2232

Check to see if the character has an actual "rank" in the DB.

Or you could post the script here and I'll delete anything keeping it from showing up.

Code:

USE [gunzdb]
GO

/****** Object:  Table [dbo].[Character]    Script Date: 02/16/2011 00:26:04 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Character](
	[CID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[Name] [varchar](24) NOT NULL,
	[Level] [smallint] NOT NULL,
	[Sex] [tinyint] NOT NULL,
	[CharNum] [smallint] NOT NULL,
	[Hair] [tinyint] NULL,
	[Face] [tinyint] NULL,
	[XP] [int] NOT NULL,
	[BP] [int] NOT NULL,
	[HP] [smallint] NULL,
	[AP] [smallint] NULL,
	[FR] [int] NULL,
	[CR] [int] NULL,
	[ER] [int] NULL,
	[WR] [int] NULL,
	[head_slot] [int] NULL,
	[chest_slot] [int] NULL,
	[hands_slot] [int] NULL,
	[legs_slot] [int] NULL,
	[feet_slot] [int] NULL,
	[fingerl_slot] [int] NULL,
	[fingerr_slot] [int] NULL,
	[melee_slot] [int] NULL,
	[primary_slot] [int] NULL,
	[secondary_slot] [int] NULL,
	[custom1_slot] [int] NULL,
	[custom2_slot] [int] NULL,
	[RegDate] [datetime] NULL,
	[LastTime] [datetime] NULL,
	[PlayTime] [int] NULL,
	[GameCount] [int] NULL,
	[KillCount] [int] NULL,
	[DeathCount] [int] NULL,
	[DeleteFlag] [tinyint] NULL,
	[DeleteName] [varchar](24) NULL,
	[head_itemid] [int] NULL,
	[chest_itemid] [int] NULL,
	[hands_itemid] [int] NULL,
	[legs_itemid] [int] NULL,
	[feet_itemid] [int] NULL,
	[fingerl_itemid] [int] NULL,
	[fingerr_itemid] [int] NULL,
	[melee_itemid] [int] NULL,
	[primary_itemid] [int] NULL,
	[secondary_itemid] [int] NULL,
	[custom1_itemid] [int] NULL,
	[custom2_itemid] [int] NULL,
	[QuestItemInfo] [binary](292) NULL,
	[hide] [int] NULL,
	[Views] [int] NOT NULL,
	[Ranking] [varchar](50) NULL,
 CONSTRAINT [Character_PK] PRIMARY KEY CLUSTERED 
(
	[CID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[Character]  WITH CHECK ADD  CONSTRAINT [Account_Character_FK1] FOREIGN KEY([AID])
REFERENCES [dbo].[Account] ([AID])
GO

ALTER TABLE [dbo].[Character] CHECK CONSTRAINT [Account_Character_FK1]
GO

ALTER TABLE [dbo].[Character] ADD  CONSTRAINT [DF_Character_Views]  DEFAULT ((0)) FOR [Views]
GO

**Gosu[ru]** · 16-02-11

Bump!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

**wesman2232** · 16-02-11

I meant the web script :P

**Gosu[ru]** · 17-02-11

Code:

<? SetTitle(""); ?>

<script language="JavaScript" 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[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

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[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

//-->
</script>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

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[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
<body onLoad="MM_preloadImages('img/hallfame_select_on.jpg','img/ministart02.gif','img/clanranking_select_on.jpg')">
<table width="784" height="10" border="0" align="center">
  <tr valign="top">
    <td width="160" height="60" align="center" valign="top" bgcolor="#004f86"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
          <td align="center"><table width="160" height="58" border="0" align="left" cellpadding="0" cellspacing="0" background="img/playlive_bg_subp01a_160px.gif" style="background-position:top; background-repeat:no-repeat; filter: alpha(opacity=80); -moz-opacity:0.80; opacity:0.80;">
      <tr>
        <td align="center" height="58"></td>
      </tr>
    </table><a href="index.php?gunz=download" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('START','','img/ministart02.gif',1)"><img src="img/ministart01.gif" alt="Download" name="START" border="0"  style=" float:none; margin-top:5; margin-left:-155; position:absolute;"></a></td>
        </tr>
        <tr>
          <td align="center" background="img/bg_content_wm.gif" bgcolor="#004f86" style="background-repeat:no-repeat; background-position:top;"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
            <tr>
              <td align="center" valign="top" height="2"></td>
            </tr>
            <tr>
              <td align="center" valign="top"><img src="img/ltit_ranking.gif" width="150" height="42">
                  <table width="150" border="0" align="center" cellpadding="0" cellspacing="0">
                    <tr>
                      <td align="center" background="img/lbox01_t.gif" style="background-repeat:no-repeat; background-position:top;" height="6"></td>
                    </tr>
                    <tr>
                      <td align="center" background="img/lbox01_b.gif" style="background-repeat:no-repeat;"><a href="index.php?gunz=clanrank" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('ClanRank','','img/clanranking_select_on.jpg',1)"><img name="ClanRank" border="0" src="img/clanranking_select.jpg" alt="ClanRank"></a><br>                          <a href="index.php?gunz=playerank"><img src="img/playeranking_select_on.jpg" width="130" height="26" border="0"></a><br>
                          <a href="index.php?gunz=hallofame" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('hallfame','','img/hallfame_select_on.jpg',1)"><img name="hallfame" border="0" src="img/hallfame_select.jpg" alt="HallOfFame"></a></td>
                    </tr>
                    <tr>
                      <td align="center" background="img/lbox01_b.gif" style="background-repeat:no-repeat; background-position:bottom" height="6"></td>
                    </tr>
                </table></td>
            </tr>
          </table></td>
        </tr>
      </table></td>
    <td align="center" valign="top" bgcolor="#FFFFFF" class="Estilo1" width="620" height="100%"><table width="575" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
          <td height="20">&nbsp;</td>
        </tr>
        <tr>
          <td align="left"><img src="img/tit_individualrank.gif" width="150" height="23"></td>
        </tr>
        <tr>
          <td align="center" class="Estilo1" height="25"></td>
        </tr>
        <tr>
          <td align="center"><table width="573" height="45" border="0" align="center" background="img/box_sch.gif" class="Estilo1" style="background-repeat:no-repeat;">
              <tr>
                <td align="center"><form method="GET" name="indsearch" action="index.php">
                    <input type="hidden" name="gunz" value="playerank" />
                    <select name="type" class="login">
                      <option value="1">Game ID</option>
                    </select>
                    <input type="text" name="name" class="login"/>
                    <input name="submit" type="submit" class="login" value="Search" />
                </form></td>
              </tr>
          </table></td>
        </tr>
        <tr>
          <td height="30" align="left"><img src="img/ranking01_sub02_indi.gif" width="150" height="16"></td>
        </tr>
        <tr>
          <td height="30" align="center"><table width="570" border="0" cellpadding="0" cellspacing="0" height="23" background="img/top_li.gif" style="background-repeat:repeat-x;">
              <tr align="center">
                <td width="72" height="23"  align="center" class="Estilo5"> <b>Ranking</b></td>
                <td width="155" height="23"  align="center" class="Estilo5"> <b>Game ID </b></td>
                <td width="61" height="23"align="center" class="Estilo5"> <b>Level</b></td>
                <td width="121" height="21"  align="center" class="Estilo5"> <b>Experience Points </b></td>
                <td width="125" height="23" align="center" class="Estilo5"> <b>Kill/Death %</b></td>
              </tr>
              <tr>
                <td colspan="5" valign="top">
                  <table width="570" border="0">
                    <?
                                                        if( isset($_GET['type']) && isset($_GET['name']) )
                                                        {
                                                            $search = 1;
                                                            $type = clean($_GET['type']);
                                                            $name = clean($_GET['name']);

                                                            if($type == 1)
                                                            {
                                                                $squery = "SELECT CID, Level, XP, Ranking, KillCount, DeathCount FROM Character(nolock) WHERE Name = '$name'";
                                                            }
                                                            elseif($type == 2)
                                                            {
                                                                $accountq = mssql_query("SELECT AID FROM Account(nolock) WHERE UserID = '$name'");
                                                                if( mssql_num_rows($accountq) == 1 )
                                                                {
                                                                $accountdata = mssql_fetch_row($accountq);
                                                                $aid = $accountdata[0];
                                                                $squery = "SELECT CID, Level, XP, Ranking, KillCount, DeathCount FROM Character(nolock) WHERE AID = '$aid' AND (DeleteFlag=0 OR DeleteFlah=NULL) ORDER BY Ranking,Level,XP ASC";
                                                                }
                                                                else
                                                                {
                                                                    echo '
                                                                <tr>
                                                                    <td width="528" colspan="5" class="estilo5">
                                                                    <p align="center">
                                                                    - No data -</td>
                                                                </tr>';
                                                                }
                                                            }
                                                            else
                                                            {
                                                                $search = 0;
                                                            }
                                                        }
                                                        else
                                                        {
                                                            $search = 0;
                                                        }

                                                        if($search == 0 )
                                                        {
                                                        switch( clean($_GET['page']) )
                                                        {
                                                            case "":
                                                                $ranks = "Ranking >= 1 AND Ranking <= 20";
                                                            break;
                                                            case "2":
                                                                $ranks = "Ranking > 20 AND Ranking <= 40";
                                                            break;
                                                            case "3":
                                                                $ranks = "Ranking > 40 AND Ranking <= 60";
                                                            break;
                                                            case "4":
                                                                $ranks = "Ranking > 60 AND Ranking <= 80";
                                                            break;
                                                            case "5":
                                                                $ranks = "Ranking > 80 AND Ranking <= 100";
                                                            break;
                                                            default:
                                                                $ranks = "Ranking <= 20";
                                                            break;
                                                        }


                                                            $res = mssql_query_logged("SELECT TOP 20 CID, Level, XP, Ranking, KillCount, DeathCount FROM Character(nolock) WHERE $ranks AND (DeleteFlag=0 OR DeleteFlag=NULL) ORDER BY Level DESC");
                                                            }
                                                            else
                                                            {
                                                                $res = mssql_query_logged($squery);
                                                            }
                                                              if(mssql_num_rows($res) <> 0)
                                                              {
                                                                while($char = mssql_fetch_object($res))
                                                                  {
                                                                  ?>
                    <tr  background="img/li_x_01.gif" style="background-repeat:repeat-x; background-position:bottom;">
                      <td width="63" height="20" align="center" class="Estilo5">
                        <?=$char->Ranking?>
                      </td>
                      <td width="137" align="center" class="Estilo5"><a href="index.php?gunz=player&info=<?=$char->CID?>"> <font color="#333333"><b>
                        <?=FormatCharName($char->CID)?>
                      </b></font> </a></td>
                      <td width="53" align="center" class="Estilo5">
                        <?=$char->Level?></td>
                      <td width="107" align="center" class="Estilo5">
                        <?=number_format($char->XP, 0, ",", ".")?></td>
                      <td width="109" align="center" class="Estilo5">
                        <?=GetKDRatio($char->KillCount, $char->DeathCount)?></td>
                    </tr>
                    <?
                                                            $count++;
                                                            }
                                                        }else{
                                                        ?>
                    <tr>
                      <td height="35" colspan="5" align="center" class="estilo5">- No Data - </td>
                    </tr>
                    <?
                                                        }
                                                        ?>
                </table></td>
              </tr>
              <tr>
                <td colspan="5" valign="top" height="10"></td>
              </tr>
          </table></td>
        </tr>
        <tr>
          <td height="35" align="center" class="login5"><?
                                    if( $search == 0 )
					                $name = clean($_GET['name']);
								    $type = clean($_GET['type']);
                                    { ?>
              <table width="500" border="0" cellpadding="0" cellspacing="0" align="center">
                <tr>
                  <td height="8" align="center" background="img/rank_pgnavi_t.gif"style="background-repeat:repeat-x; background-position:top;"></td>
                </tr>
                <tr>
                  <td height="30" align="center" class="estilo5" valign="baseline"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
                      <tr>
                        <td align="center"><table width="83" height="22" border="0" align="center" cellpadding="0" cellspacing="0">
                            <tr>
                              <td align="center" class="estilo5" style="background-repeat:no-repeat; background-position:center; font-weight: bold;" background="img/rank_pgnavi_box.gif" height="8"><a href="index.php?gunz=playerank"><font color="#333333">1-20</font></a></td>
                            </tr>
                        </table></td>
                        <td align="center"><table width="83" height="22" border="0" align="center" cellpadding="0" cellspacing="0">
                            <tr>
                              <td align="center" class="estilo5" style="background-repeat:no-repeat; background-position:center; font-weight: bold;" background="img/rank_pgnavi_box.gif" height="8"><a href="index.php?gunz=playerank&page=2"><font color="#333333">20-40</font></a></td>
                            </tr>
                        </table></td>
                        <td align="center"><table width="83" height="22" border="0" align="center" cellpadding="0" cellspacing="0">
                            <tr>
                              <td align="center" class="estilo5" style="background-repeat:no-repeat; background-position:center; font-weight: bold;" background="img/rank_pgnavi_box.gif" height="8"><a href="index.php?gunz=playerank&page=3"><font color="#333333">40-60</font></a></td>
                            </tr>
                        </table></td>
                        <td align="center"><table width="83" height="22" border="0" align="center" cellpadding="0" cellspacing="0">
                            <tr>
                              <td align="center" class="estilo5" style="background-repeat:no-repeat; background-position:center; font-weight: bold;" background="img/rank_pgnavi_box.gif" height="8"><a href="index.php?gunz=playerank&page=4"><font color="#333333">60-80</font></a></td>
                            </tr>
                        </table></td>
                        <td align="center"><table width="83" height="22" border="0" align="center" cellpadding="0" cellspacing="0">
                            <tr>
                              <td align="center" class="estilo5" style="background-repeat:no-repeat; background-position:center; font-weight: bold;" background="img/rank_pgnavi_box.gif" height="8"><a href="index.php?gunz=playerank&page=5"><font color="#333333">80-100</font></a></td>
                            </tr>
                        </table></td>
                      </tr>
                  </table></td>
                </tr>
                <tr>
                  <td background="img/rank_pgnavi_t.gif"style="background-repeat:repeat-x; background-position:bottom;" height="8"></td>
                </tr>
              </table>
              <?
                                    }
                                    ?></td>
        </tr>
    </table></td>
  </tr>
</table>

**wesman2232** · 17-02-11

rofl at :

PHP Code:


(DeleteFlag=0 OR DeleteFlah=NULL)

Well, I'm not sure. I have been away from GunZ for so long I forgot all my sql knowledge ):

**Gosu[ru]** · 17-02-11

Originally Posted by wesman2232

rofl at :

PHP Code:


(DeleteFlag=0 OR DeleteFlah=NULL)

Well, I'm not sure. I have been away from GunZ for so long I forgot all my sql knowledge ):

Emm, where neeed put it? O_O

Or what do you mean? o_O

Ijji website (ranking)

Thread Tools

Ijji website (ranking)

Re: Ijji website (ranking)

Re: Ijji website (ranking)

Re: Ijji website (ranking)

Re: Ijji website (ranking)

Re: Ijji website (ranking)

Re: Ijji website (ranking)

Re: Ijji website (ranking)

Re: Ijji website (ranking)

Re: Ijji website (ranking)

Advertisement