Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <?php
- echo '<TITLE>Uq_jumpstats Tops</TITLE>';
- ?>
- <STYLE>
- body {background:#232323;color:#cfcbc2;}
- .tbl {font-family:sans-serif;font-size:12px;}
- a {color:#70A401;text-decoration:none;}
- a:hover {color:red;}
- a:visited {color:#70A401;}
- a:visited:hover {color:red;}
- </style>
- </head>
- <body>
- <?php
- /************************************************************************
- * *
- * @original author kib0rg(and MaHy), modded for uq_jumpstats by BorJomi*
- * version 1.17 *
- * @copyright 2010 *
- ************************************************************************/
- define('DB_HOST', '');
- define('DB_USER', '');
- define('DB_PASS', '');
- define('DB_NAME', '');
- $per_page=20;
- $sql = mysql_connect(DB_HOST, DB_USER, DB_PASS);
- mysql_select_db(DB_NAME, $sql);
- $type = mysql_real_escape_string($_GET['type']);
- $blocktop=isset($_GET['block']) ? intval($_GET['block']) : null;
- $page = isset($_GET['page']) ? intval($_GET['page']) - 1 : null;
- $idplayer=isset($_GET['id']) ? mysql_real_escape_string($_GET['id']) : null;
- $start=abs($page*$per_page);
- $techs = array('lj', 'cj', 'bj', 'sbj', 'wj','doublecj','multicj','dropbj','dropcj','doubledropcj','multidropcj','duckbhop','ladder','ladderbhop','realladderbhop','scj','doublescj','multiscj','dropscj','dropdoublescj','dropmultiscj','multibhop','upbj','upsbj','upbhopinduck','bhopinduck');
- $techs_name = array('lj' => 'LongJump', 'cj' => 'CountJump', 'bj' => 'BhoplongJump', 'sbj' => 'StandUp BhoplongJump', 'wj' => 'WeirdlongJump','doublecj' => 'Double CountJump','multicj' => 'Multi CountJump','dropbj' => 'Drop BhopJump','dropcj' => 'Drop CJ','ladderbhop' => 'LadderBhop Jump','ladder' => 'Ladder Jump');
- $techs_name1 = array('scj' => 'StandUp CountJump','doublescj' => 'Double SCJ','multiscj' => 'Multi SCJ','dropscj' => 'Drop SCJ','dropdoublescj' => 'Drop Double SCJ','dropmultiscj' => 'Drop Multi SCJ','multibhop' => 'MultiBhop','upbj' => 'Up Bhop','doubledropcj' => 'Double Drop CJ','multidropcj' => 'Multi Drop CJ','upsbj' => 'Up StandupBhop','upbhopinduck' => 'Up Bhop in Duck','bhopinduck' => 'Bhop in Duck','duckbhop' => 'DuckBhop','realladderbhop' => 'Real LadderBhop Jump');
- $techs_name2 = array('LongJump','CountJump','BhoplongJump','StandUp BhoplongJump','WeirdlongJump','Double CountJump','Drop BhopJump','Drop CJ','Double Drop CJ','DuckBhop','Ladder Jump','LadderBhop Jump','Real LadderBhop Jump','StandUp CountJump','Double SCJ','Drop SCJ','Drop Double SCJ','Up Bhop','Up StandupBhop','Up Bhop in Duck','Bhop in Duck');
- $techs_name3 = array('Multi CountJump','Multi Drop CJ','Multi SCJ','Drop Multi SCJ');
- $techs_name4 = array('MultiBhop');
- $techs_name5 = array('','LongJump','CountJump','BhoplongJump','StandUp BhoplongJump','WeirdlongJump','Double CountJump','Drop BhopJump','Drop CJ','Double Drop CJ','DuckBhop','Ladder Jump','LadderBhop Jump','Real LadderBhop Jump','StandUp CountJump','Double SCJ','Drop SCJ','Drop Double SCJ','Up Bhop','Up StandupBhop','Up Bhop in Duck','Bhop in Duck','Multi CountJump','Multi Drop CJ','Multi SCJ','Drop Multi SCJ','MultiBhop');
- $techs1 = array('lj', 'cj', 'bj', 'sbj', 'wj','doublecj','dropbj','dropcj','doubledropcj','duckbhop','ladder','ladderbhop','realladderbhop','scj','doublescj','dropscj','dropdoublescj','upbj','upsbj','upbhopinduck','bhopinduck');
- $techs2 = array('multicj','multidropcj','multiscj','dropmultiscj');
- $techs3 = array('multibhop');
- $idname=mysql_real_escape_string($_GET['name']);
- $nametype=$_GET['nametype'];
- $test=1;
- if($blocktop!=1 && isset($type) && in_array($nametype,$techs_name5) && (in_array($type,$techs) || isset($idname))){
- $top_extras = mysql_query("SELECT num FROM `info_stats` WHERE cvars='kz_uq_save_extras_top'", $sql);
- $data_top_extras = mysql_fetch_array($top_extras);
- if(isset($idplayer))
- {
- $top_by = mysql_query("SELECT num FROM `info_stats` WHERE cvars='kz_uq_top_by'", $sql);
- $data_top_by = mysql_fetch_array($top_by);
- $j=0;
- $ss=0;
- $Checkaem=0;
- foreach($techs1 as $key=>$value)
- {
- $check = mysql_query("SELECT distance FROM `".$value."_top` WHERE authid='". $idplayer ."'", $sql);
- if(!$check)
- {
- echo "Error - ".mysql_error()."<br>";
- echo $sql;
- exit();
- }
- $data_check = mysql_fetch_array($check);
- if(isset($data_check['distance']))
- {
- $techs_array1[$j-$ss]=$value;
- }
- else
- {
- $ss++;
- $Checkaem++;
- }
- $j++;
- }
- $ss=0;
- $j=0;
- foreach($techs2 as $key=>$value)
- {
- $check = mysql_query("SELECT distance FROM `".$value."_top` WHERE authid='". $idname ."'", $sql);
- if(!$check)
- {
- echo "Error - ".mysql_error()."<br>";
- echo $sql;
- exit();
- }
- $data_check = mysql_fetch_array($check);
- if(isset($data_check['distance']))
- {
- $techs_array2[$j-$ss]=$value;
- }
- else
- {
- $ss++;
- $Checkaem++;
- }
- $j++;
- }
- $ss=0;
- $j=0;
- foreach($techs3 as $key=>$value)
- {
- $check = mysql_query("SELECT distance FROM `".$value."_top` WHERE authid='". $idname ."'", $sql);
- if(!$check)
- {
- echo "Error - ".mysql_error()."<br>";
- echo $sql;
- exit();
- }
- $data_check = mysql_fetch_array($check);
- if(isset($data_check['distance']))
- {
- $techs_array3[$j-$ss]=$value;
- }
- else
- {
- $ss++;
- $Checkaem++;
- }
- $j++;
- }
- if($Checkaem==26)
- {
- //echo '<script type="text/javascript">document.location.href="uq_jumpstats.php?nametype=LongJump&type=lj";</script>';
- }
- //print($Checkaem);
- $query = mysql_query("SELECT * FROM `lj_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `cj_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `bj_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `sbj_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `wj_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `doublecj_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `dropbj_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `dropcj_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `doubledropcj_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `duckbhop_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `ladder_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `ladderbhop_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `realladderbhop_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `scj_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `doublescj_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `dropscj_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `dropdoublescj_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `upbj_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `upsbj_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `upbhopinduck_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `bhopinduck_top` WHERE authid='". $idname ."'", $sql);
- if(!$query)
- {
- echo "Error - ".mysql_error()."<br>";
- echo $sql;
- exit();
- }
- $query1 = mysql_query("SELECT * FROM `multicj_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `multidropcj_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `multiscj_top` WHERE authid='". $idname ."'
- UNION ALL
- SELECT * FROM `dropmultiscj_top` WHERE authid='". $idname ."'", $sql);
- if(!$query1)
- {
- echo "Error - ".mysql_error()."<br>";
- echo $sql;
- exit();
- }
- $query2 = mysql_query("SELECT * FROM `multibhop_top` WHERE authid='". $idname ."'", $sql);
- if(!$query2)
- {
- echo "Error - ".mysql_error()."<br>";
- echo $sql;
- exit();
- }
- foreach($techs as $value)
- {
- $queryy = mysql_query("SELECT * FROM `".$value."_top` ORDER BY distance DESC", $sql);
- if(!$queryy)
- {
- echo "Error - ".mysql_error()."<br>";
- echo $sql;
- exit();
- }
- while($data_queryy = mysql_fetch_array($queryy))
- {
- if($data_queryy['distance']<100000000)
- {
- $dist_re = $data_queryy['distance']/100000000;
- $dist_re = str_replace (".", "", $dist_re);
- mysql_query("UPDATE `".$value."_top` SET distance='".$dist_re."' WHERE authid='".$data_queryy['authid']."'", $sql);
- }
- if($data_queryy['maxspeed']<100000000)
- {
- $dist_re = $data_queryy['maxspeed']/100000000;
- $dist_re = str_replace (".", "", $dist_re);
- mysql_query("UPDATE `".$value."_top` SET maxspeed='".$dist_re."' WHERE authid='".$data_queryy['authid']."'", $sql);
- }
- if($data_queryy['prestrafe']<100000000)
- {
- $dist_re = $data_queryy['prestrafe']/100000000;
- $dist_re = str_replace (".", "", $dist_re);
- mysql_query("UPDATE `".$value."_top` SET prestrafe='".$dist_re."' WHERE authid='".$data_queryy['authid']."'", $sql);
- }
- }
- }
- }
- else
- {
- if(!isset($nametype))
- {
- //echo '<script type="text/javascript">document.location.href="uq_jumpstats.php?nametype=LongJump&type=lj";</script>';
- }
- $queryy = mysql_query("SELECT * FROM `".$type."_top` ORDER BY distance DESC", $sql);
- if(!$queryy)
- {
- echo "Error - ".mysql_error()."<br>";
- echo $sql;
- exit();
- }
- while($data_queryy = mysql_fetch_array($queryy))
- {
- if($data_queryy['distance']<100000000)
- {
- $dist_re = $data_queryy['distance']/100000000;
- $dist_re = str_replace (".", "", $dist_re);
- mysql_query("UPDATE `".$type."_top` SET distance='".$dist_re."' WHERE authid='".$data_queryy['authid']."'", $sql);
- }
- if($data_queryy['maxspeed']<100000000)
- {
- $dist_re = $data_queryy['maxspeed']/100000000;
- $dist_re = str_replace (".", "", $dist_re);
- mysql_query("UPDATE `".$type."_top` SET maxspeed='".$dist_re."' WHERE authid='".$data_queryy['authid']."'", $sql);
- }
- if($data_queryy['prestrafe']<100000000)
- {
- $dist_re = $data_queryy['prestrafe']/100000000;
- $dist_re = str_replace (".", "", $dist_re);
- mysql_query("UPDATE `".$type."_top` SET prestrafe='".$dist_re."' WHERE authid='".$data_queryy['authid']."'", $sql);
- }
- }
- $query = mysql_query("SELECT * FROM `".$type."_top` ORDER BY distance DESC LIMIT $start,$per_page", $sql);
- $queryzz = mysql_query("SELECT * FROM `".$type."_top` ORDER BY distance DESC LIMIT $start,$per_page", $sql);
- $datas = mysql_fetch_array($queryzz);
- if($datas['distance'])
- {
- $checktop=1;
- }
- else $checktop=0;
- if(!$query)
- {
- echo "Error - ".mysql_error()."<br>";
- echo $sql;
- exit();
- }
- $dist = mysql_query("SELECT distance FROM `".$type."_top` ORDER BY distance DESC", $sql);
- if(!$dist)
- {
- echo "Error - ".mysql_error()."<br>";
- echo $sql;
- exit();
- }
- $data_dist = mysql_fetch_array($dist);
- $mxspeed = mysql_query("SELECT maxspeed FROM `".$type."_top` ORDER BY maxspeed DESC", $sql);
- if(!$mxspeed)
- {
- echo "Error - ".mysql_error()."<br>";
- echo $sql;
- exit();
- }
- $data_mxspeed = mysql_fetch_array($mxspeed);
- $prest = mysql_query("SELECT prestrafe FROM `".$type."_top` ORDER BY prestrafe DESC", $sql);
- if(!$prest)
- {
- echo "Error - ".mysql_error()."<br>";
- echo $sql;
- exit();
- }
- $data_prest = mysql_fetch_array($prest);
- $syncc = mysql_query("SELECT sync FROM `".$type."_top` ORDER BY sync DESC", $sql);
- if(!$syncc)
- {
- echo "Error - ".mysql_error()."<br>";
- echo $sql;
- exit();
- }
- $data_syncc = mysql_fetch_array($syncc);
- $max_dist=$data_dist['distance'];
- $max_maxspeed=$data_mxspeed['maxspeed'];
- $max_prestrafe=$data_prest['prestrafe'];
- $max_sync=$data_syncc['sync'];
- while($data_syncc = mysql_fetch_array($syncc))
- {
- if($data_syncc['sync']==100)
- {
- $max_sync=100;
- }
- }
- }
- echo '
- <table align="center" width="650" border="0" class = "tbl" bgcolor="#232323">
- <tr>
- ';
- foreach($techs_name as $key=>$value)
- {
- echo '
- <td><b><a href="uq_jumpstats.php?nametype='.urlencode($value).'&type='.urlencode($key).'"><center>'.htmlspecialchars($value).'</center></a></b></td>
- ';
- }
- if(isset($idplayer))
- {
- echo '
- </tr>
- <tr>';
- if($idplayer==$idname || $data_top_by['num']==0)
- {
- echo '</table><b><center>Stats for Player <font color = "orange">'.htmlspecialchars($idplayer).'</font></center></b></center><br>';
- }
- else if($data_top_by['num']==2)
- {
- echo '</table><b><center>Stats for Player <font color = "orange">'.htmlspecialchars($idname).'</font><br>ID: '.htmlspecialchars($idplayer).'</center></b><br>';
- }
- else echo '</table><b><center>Stats for Player <font color = "orange">'.htmlspecialchars($idname).'</font><br>IP: '.htmlspecialchars($idplayer).'</center></b><br>';
- echo '<table border="0" cellspacing="0" cellpadding="0" align="center" class="tbl" width="650" bgcolor=#22697B>
- <tr bgcolor="#52697B">
- <td align="center" width="80">Jump Type</td>
- <td align="center">Distance</td>
- <td align="center">Maxspeed</td>
- <td align="center">Prestrafe</td>
- <td align="center">Strafes</td>
- <td align="center">Sync</td>
- <td align="center" width="80">Place in Top</td>
- </tr>
- ';
- }else {
- echo '
- </tr>
- <tr>
- </table><b><center>Top10 <font color = "orange">'.htmlspecialchars($nametype).'</font></center></b><br>
- <table border="0" cellspacing="0" cellpadding="0" align="center" class="tbl" width="650" bgcolor=#22697B>
- <tr bgcolor="#52697B">
- <td width="20">#</td>
- <td width="200" align="center">Name</td>
- <td align="center">Distance</td>
- <td align="center">Maxspeed</td>
- <td align="center">Prestrafe</td>
- <td align="center">Strafes</td>
- <td align="center">Sync</td>';
- if($type=="multicj" || $type=="multidropcj" || $type=="multiscj" || $type=="dropmultiscj")
- {
- echo '<td align="center">Ducks</td>';
- }
- else if($type=="multibhop")
- {
- echo '<td align="center">Bhops</td>';
- }
- $top_cvar = mysql_query("SELECT num FROM `info_stats` WHERE cvars='kz_uq_top_by'", $sql);
- $data_top_cvar = mysql_fetch_array($top_cvar);
- $block_cvar = mysql_query("SELECT num FROM `info_stats` WHERE cvars='kz_uq_block_top'", $sql);
- $data_block_cvar = mysql_fetch_array($block_cvar);
- $sql_top=$data_top_cvar['num'];
- $blockon=$data_block_cvar['num'];
- if($sql_top!=2 && $blockon!=0)
- {
- if($type=='lj')
- {
- echo '<td align="center"><b>Block </b><a href="uq_jumpstats.php?block=1&type=lj"><b>LJ</b></a>/<a href="uq_jumpstats.php?block=1&type=hj"><b>HJ</b></a></td>
- <td align="center">Jumpoff</td></tr>';
- }
- else if($type!='ladder')
- {
- echo '<td align="center"><a href="uq_jumpstats.php?block=1&type='.urlencode($type).'"><b>Block</b></a></td>
- <td align="center">Jumpoff</td></tr>';
- }
- }
- }
- $check_namess=0;
- $i = 0;
- if(isset($idplayer))
- {
- while($data = mysql_fetch_array($query)){
- $check_name = mysql_query("SELECT name FROM `".$techs_array1[$i]."_top` WHERE authid='".$idplayer."'", $sql);
- $data_check_name = mysql_fetch_array($check_name);
- if($idname==$data_check_name['name'])
- {
- $check_namess=1;
- }
- echo '
- <tr align="left" bgcolor="'.($i % 2 == 0 ? "#2f3030" : "").'">';
- echo '<td><font color = "yellow"><b>'.$techs_array1[$i].'</b></font></td>';
- if($data['distance']<100000000) echo '<td align="center">'.$data['distance'] = substr($data['distance'], 1, 2).'.'.substr($data['distance'], 2, 3).'</td>';
- else echo '<td align="center">'.$data['distance'] = substr($data['distance'], 0, 3).'.'.substr($data['distance'], 3, 3).'</td>';
- if($data['maxspeed']<100000000) echo '<td align="center">'.$data['maxspeed'] = substr($data['maxspeed'], 1, 2).'.'.substr($data['maxspeed'], 2, 3).'</td>';
- else echo '<td align="center">'.$data['maxspeed'] = substr($data['maxspeed'], 0, 3).'.'.substr($data['maxspeed'], 3, 3).'</td>';
- if($data['prestrafe']<100000000) echo '<td align="center">'.$data['prestrafe'] = substr($data['prestrafe'], 1, 2).'.'.substr($data['prestrafe'], 2, 3).'</td>';
- else echo '<td align="center">'.$data['prestrafe'] = substr($data['prestrafe'], 0, 3).'.'.substr($data['prestrafe'], 3, 3).'</td>';
- echo '<td align="center">'.$data['strafes'].'</td>
- <td align="center">'.$data['sync'].'</td>';
- $topplace = mysql_query("SELECT authid FROM `".$techs_array1[$i]."_top` ORDER BY distance DESC", $sql);
- $kk=1;
- while($data_place = mysql_fetch_array($topplace))
- {
- if($data_place['authid']==$idplayer)
- {
- switch($kk) {
- case 1:
- echo '<td align="center"><font color=red>'.$kk.'</font></td>';
- break;
- case 2:
- echo '<td align="center"><font color=#70A401>'.$kk.'</font></td>';
- break;
- case 3:
- echo '<td align="center"><font color=orange>'.$kk.'</font></td>';
- break;
- default:
- echo '<td align="center">'.$kk.'</td>';
- break;
- }
- }
- $kk++;
- }
- echo '</tr>';
- $i++;
- }
- $ii=$i;
- $i = 0;
- while($data1 = mysql_fetch_array($query1)){
- $check_name = mysql_query("SELECT name FROM `".$techs_array2[$i]."_top` WHERE authid='".$idplayer."'", $sql);
- $data_check_name = mysql_fetch_array($check_name);
- if($idname==$data_check_name['name'])
- {
- $check_namess=1;
- }
- echo '
- <tr align="left" bgcolor="'.($ii % 2 == 0 ? "#2f3030" : "").'">
- <td ><font color = "yellow"><b>'.$techs_array2[$i].'</b></font></td>';
- if($data1['distance']<100000000) echo '<td align="center">'.$data1['distance'] = substr($data1['distance'], 1, 2).'.'.substr($data1['distance'], 2, 3).'</td>';
- else echo '<td align="center">'.$data1['distance'] = substr($data1['distance'], 0, 3).'.'.substr($data1['distance'], 3, 3).'</td>';
- if($data1['maxspeed']<100000000) echo '<td align="center">'.$data1['maxspeed'] = substr($data1['maxspeed'], 1, 2).'.'.substr($data1['maxspeed'], 2, 3).'</td>';
- else echo '<td align="center">'.$data1['maxspeed'] = substr($data1['maxspeed'], 0, 3).'.'.substr($data1['maxspeed'], 3, 3).'</td>';
- if($data1['prestrafe']<100000000) echo '<td align="center">'.$data1['prestrafe'] = substr($data1['prestrafe'], 1, 2).'.'.substr($data1['prestrafe'], 2, 3).'</td>';
- else echo '<td align="center">'.$data1['prestrafe'] = substr($data1['prestrafe'], 0, 3).'.'.substr($data1['prestrafe'], 3, 3).'</td>';
- echo '
- <td align="center">'.$data1['strafes'].'</td>
- <td align="center">'.$data1['sync'].'</td>';
- $topplace = mysql_query("SELECT authid FROM `".$techs_array2[$i]."_top` ORDER BY distance DESC", $sql);
- $kk=1;
- while($data_place = mysql_fetch_array($topplace))
- {
- if($data_place['authid']==$idplayer)
- {
- switch($kk) {
- case 1:
- echo '<td align="center"><font color=red>'.$kk.'</font></td>';
- break;
- case 2:
- echo '<td align="center"><font color=#70A401>'.$kk.'</font></td>';
- break;
- case 3:
- echo '<td align="center"><font color=orange>'.$kk.'</font></td>';
- break;
- default:
- echo '<td align="center">'.$kk.'</td>';
- break;
- }
- }
- $kk++;
- }
- echo '</tr>';
- $i++;$ii++;
- }
- $iii=$ii;
- $i = 0;
- while($data2 = mysql_fetch_array($query2)){
- $check_name = mysql_query("SELECT name FROM `".$techs_array3[$i]."_top` WHERE authid='".$idplayer."'", $sql);
- $data_check_name = mysql_fetch_array($check_name);
- if($idname==$data_check_name['name'])
- {
- $check_namess=1;
- }
- echo '
- <tr align="left" bgcolor="'.($iii % 2 == 0 ? "#2f3030" : "").'">
- <td><font color = "yellow"><b>'.$techs_array3[$i].'</b></font></td>';
- if($data2['distance']<100000000) echo '<td align="center">'.$data2['distance'] = substr($data2['distance'], 1, 2).'.'.substr($data2['distance'], 2, 3).'</td>';
- else echo '<td align="center">'.$data2['distance'] = substr($data2['distance'], 0, 3).'.'.substr($data2['distance'], 3, 3).'</td>';
- if($data2['maxspeed']<100000000) echo '<td align="center">'.$data2['maxspeed'] = substr($data2['maxspeed'], 1, 2).'.'.substr($data2['maxspeed'], 2, 3).'</td>';
- else echo '<td align="center">'.$data2['maxspeed'] = substr($data2['maxspeed'], 0, 3).'.'.substr($data2['maxspeed'], 3, 3).'</td>';
- if($data2['prestrafe']<100000000) echo '<td align="center">'.$data2['prestrafe'] = substr($data2['prestrafe'], 1, 2).'.'.substr($data2['prestrafe'], 2, 3).'</td>';
- else echo '<td align="center">'.$data2['prestrafe'] = substr($data2['prestrafe'], 0, 3).'.'.substr($data2['prestrafe'], 3, 3).'</td>';
- echo '<td align="center">'.$data2['strafes'].'</td>';
- echo '<td align="center">'.$data2['sync'].'</td>';
- $topplace = mysql_query("SELECT authid FROM `".$techs_array3[$i]."_top` ORDER BY distance DESC", $sql);
- $kk=1;
- while($data_place = mysql_fetch_array($topplace))
- {
- if($data_place['authid']==$idplayer)
- {
- switch($kk) {
- case 1:
- echo '<td align="center"><font color=red>'.$kk.'</font></td>';
- break;
- case 2:
- echo '<td align="center"><font color=#70A401>'.$kk.'</font></td>';
- break;
- case 3:
- echo '<td align="center"><font color=orange>'.$kk.'</font></td>';
- break;
- default:
- echo '<td align="center">'.$kk.'</td>';
- break;
- }
- }
- $kk++;
- }
- echo '</tr>';
- $i++;$iii++;
- }
- if($check_namess==0)
- {
- echo '<script type="text/javascript">document.location.href="uq_jumpstats.php?nametype=LongJump&type=lj";</script>';
- }
- }
- else
- {
- if($checktop==0)
- {
- echo '<tr align="left" bgcolor="#2f3030">
- <td width="20">1</td>
- <td width="200" align="center"><b>-</b></td>
- <td align="center"><b>-</b></td>
- <td align="center"><b>-</b></td>
- <td align="center"><b>-</b></td>
- <td align="center"><b>-</b></td>
- <td align="center"><b>-</b></td>';
- if($type!='ladder' && $sql_top!=2 && $blockon!=0)
- {
- echo '<td align="center"><b>-</b></td>
- <td align="center"><b>-</b></td>';
- }
- if($type=="multicj" || $type=="multidropcj" || $type=="multiscj" || $type=="dropmultiscj" || $type=="multibhop")
- {
- echo '<td align="center"><b>-</b></td>';
- }
- }
- else
- {
- while($data = mysql_fetch_array($query)){
- if($type!='ladder' && $sql_top!=2 && $blockon!=0)
- {
- $check_block = mysql_query("SELECT * FROM `block_tops` WHERE authid='".$data['authid']."' AND jumptype='".$type."'", $sql);
- $data_block = mysql_fetch_array($check_block);
- if($data_block['distance']==$data['distance'])
- {
- $block_true=true;
- }
- else
- { if($type=='lj')
- {
- $check_block = mysql_query("SELECT * FROM `block_tops` WHERE authid='".$data['authid']."' AND jumptype='hj'", $sql);
- $data_block = mysql_fetch_array($check_block);
- if($data_block['distance']==$data['distance'])
- {
- $block_true=true;
- $hj_type=true;
- }
- else $block_true=false;
- }
- else $block_true=false;
- }
- }
- echo '
- <tr align="left" bgcolor="'.($i % 2 == 0 ? "#2f3030" : "").'">
- <td width="20">'.($i+$start+1).'</td>
- <td><font color = "yellow"><b><a href="uq_jumpstats.php?id='.$data['authid'].'&name='.$data['name'].'">'.$data['name'].'</a></b></font></td>';
- if($max_dist==$data['distance'])
- {
- if($data['distance']<100000000) echo '<td align="center"><font color = "red"><b>'.$data['distance'] = substr($data['distance'], 1, 2).'.'.substr($data['distance'], 2, 3).'</b></font></td>';
- else echo '<td align="center"><font color = "red"><b>'.$data['distance'] = substr($data['distance'], 0, 3).'.'.substr($data['distance'], 3, 3).'</b></font></td>';
- }
- else
- {
- if($data['distance']<100000000) echo '<td align="center">'.$data['distance'] = substr($data['distance'], 1, 2).'.'.substr($data['distance'], 2, 3).'</td>';
- else echo '<td align="center">'.$data['distance'] = substr($data['distance'], 0, 3).'.'.substr($data['distance'], 3, 3).'</td>';
- }
- if($max_maxspeed==$data['maxspeed'])
- {
- if($data['maxspeed']<100000000) echo '<td align="center"><font color = "red"><b>'.$data['maxspeed'] = substr($data['maxspeed'], 1, 2).'.'.substr($data['maxspeed'], 2, 3).'</b></font></td>';
- else echo '<td align="center"><font color = "red"><b>'.$data['maxspeed'] = substr($data['maxspeed'], 0, 3).'.'.substr($data['maxspeed'], 3, 3).'</b></font></td>';
- }
- else
- {
- if($data['maxspeed']<100000000) echo '<td align="center">'.$data['maxspeed'] = substr($data['maxspeed'], 1, 2).'.'.substr($data['maxspeed'], 2, 3).'</td>';
- else echo '<td align="center">'.$data['maxspeed'] = substr($data['maxspeed'], 0, 3).'.'.substr($data['maxspeed'], 3, 3).'</td>';
- }
- if($max_prestrafe==$data['prestrafe'])
- {
- if($data['prestrafe']<100000000) echo '<td align="center"><font color = "red"><b>'.$data['prestrafe'] = substr($data['prestrafe'], 1, 2).'.'.substr($data['prestrafe'], 2, 3).'</b></font></td>';
- else echo '<td align="center"><font color = "red"><b>'.$data['prestrafe'] = substr($data['prestrafe'], 0, 3).'.'.substr($data['prestrafe'], 3, 3).'</b></font></td>';
- }
- else
- {
- if($data['prestrafe']<100000000) echo '<td align="center">'.$data['prestrafe'] = substr($data['prestrafe'], 1, 2).'.'.substr($data['prestrafe'], 2, 3).'</td>';
- else echo '<td align="center">'.$data['prestrafe'] = substr($data['prestrafe'], 0, 3).'.'.substr($data['prestrafe'], 3, 3).'</td>';
- }
- echo '<td align="center">'.$data['strafes'].'</td>';
- if($max_sync==$data['sync'])
- {
- echo '<td align="center"><font color = "red"><b>'.$data['sync'].'</b></font></td>';
- }
- else echo '<td align="center">'.$data['sync'].'</td>';
- if($type=="multicj" || $type=="multidropcj" || $type=="multiscj" || $type=="dropmultiscj")
- {
- echo '<td align="center">'.$data['ducks'].'</td>';
- }
- else if($type=="multibhop")
- {
- echo '<td align="center">'.$data['bhops'].'</td>';
- }
- if($type!='ladder' && $sql_top!=2 && $blockon!=0)
- {
- if($block_true==true)
- {
- if($hj_type==true)
- {
- echo '<td align="center">'.$data_block['block'].'<font color=yellow size=1><b>HJ</b></font></td>';
- }
- else echo '<td align="center">'.$data_block['block'].'</td>';
- echo '<td align="center">'.$data_block['jumpoff'].'</td>';
- }
- else
- {
- echo '<td align="center">-</td>';
- echo '<td align="center">-</td>';
- }
- }
- echo '</tr>';
- $i++;
- }
- }
- }
- echo '
- </table>
- ';
- if(isset($idplayer))
- {
- echo '
- <table align="center" width="650" border="0" class = "tbl" bgcolor="#232323">
- <tr>
- ';
- }
- else
- {
- echo '
- <table align="center" width="650" border="0" class = "tbl" bgcolor="#232323">
- <tr>
- ';
- $q="SELECT count(*) FROM `".$type."_top`";
- $res=mysql_query($q);
- $row=mysql_fetch_row($res);
- $total_rows=$row[0];
- $num_pages=ceil($total_rows/$per_page);
- if($num_pages!=1 && $num_pages!=0)
- {
- echo '<tr><br><Font color = "white"><b><center>Pages</b></Font><br>';
- for($i=1,$k=1;$i<=$num_pages;$i++)
- {
- if ($i-1 == $page)
- {
- if($i==$k*48)
- {
- echo '<font size=2> '.$i.' </font><br>';
- $k++;
- }
- else echo '<font size=2> '.$i.' </font>';
- }
- else
- {
- if($i==$k*48)
- {
- echo '<font size=2><a href="uq_jumpstats.php?nametype='.urlencode($nametype).'&type='.urlencode($type).'&page='.intval($i).'"> <U>'.intval($i).'</U> </a></font><br>';
- $k++;
- }
- else echo '<font size=2><a href="uq_jumpstats.php?nametype='.urlencode($nametype).'&type='.urlencode($type).'&page='.intval($i).'"> <U>'.intval($i).'</U> </a></font>';
- }
- }
- echo '</center></tr>';
- }
- }
- //echo '<br>';
- //$i=0;
- if($data_top_extras['num']==1)
- {
- foreach($techs_name1 as $key=>$value)
- {
- //if($i % 4 == 0)
- //{
- // echo '<tr>';
- //}
- echo '<td><b><a href="uq_jumpstats.php?nametype='.urlencode($value).'&type='.urlencode($key).'"><center>'.htmlspecialchars($value).'</a></b></td>';
- //$i++;
- }
- }
- else echo '<br><td><b><center>Extra Tops disabled by server</b></td>';
- echo '
- </tr>
- </table>
- <tr>
- <td colspan="8" bgcolor="#70A401"><br/><center><b> uq_jumpstats by BorJomi 2010<br><a href=http://unique-kz.com/>unique-kz.com</a></b></center><br/>
- </tr>
- ';
- }else if($blocktop==1)
- {
- foreach($techs as $value)
- {
- if($value==$type || $type=='hj')
- {
- $check_type=1;
- }
- }
- if($check_type!=1)
- {
- echo '
- <script type="text/javascript">document.location.href="uq_jumpstats.php?nametype=LongJump&type=lj";</script>';
- }
- echo '<b><center>Block Top for <font color = "orange">'.htmlspecialchars($type).'</font></center></b></center><br>';
- echo '<table border="0" cellspacing="0" cellpadding="0" align="center" class="tbl" width="650" bgcolor=#22697B>
- <tr bgcolor="#52697B">
- <td width="20">#</td>
- <td width="200" align="center">Name</td>
- <td align="center">Block</td>
- <td align="center">Distance</td>
- <td align="center">Jumpoff</td>
- </tr>
- ';
- $check = mysql_query("SELECT distance FROM `block_tops` WHERE jumptype='".$type."' LIMIT 1", $sql);
- $data_check = mysql_fetch_array($check);
- if(!$data_check['distance'])
- {
- echo '<tr align="left" bgcolor="#2f3030">
- <td width="20">1</td>
- <td width="200" align="center"><b>-</b></td>
- <td align="center"><b>-</b></td>
- <td align="center"><b>-</b></td>
- <td align="center"><b>-</b></td></tr>';
- }
- else
- {
- $max_jof = mysql_query("SELECT jumpoff FROM `block_tops` WHERE jumptype='".$type."' ORDER BY jumpoff LIMIT 1", $sql);
- $data_max_jof = mysql_fetch_array($max_jof);
- $max_block = mysql_query("SELECT block FROM `block_tops` WHERE jumptype='".$type."' ORDER BY block DESC LIMIT 1", $sql);
- $data_max_block = mysql_fetch_array($max_block);
- $old_block=$data_max_block['block'];
- $top_block = mysql_query("SELECT * FROM `block_tops` WHERE jumptype='".$type."' ORDER BY block DESC,distance DESC LIMIT $start,$per_page", $sql);
- $jj=0;
- while($data_topblock = mysql_fetch_array($top_block))
- {
- if($old_block!=$data_topblock['block'])
- {
- echo '<tr><td bgcolor=#232323 COLSPAN=9><br></td></tr>';
- if(($jj%2)==1)
- {
- $jj=$oldjj;
- }
- }
- echo '
- <tr align="left" bgcolor="'.($jj % 2 == 0 ? "#2f3030" : "").'">
- <td width="20">'.($i+$start+1).'</td>';
- echo '<td align="center"><a href="uq_jumpstats.php?id='.urlencode($data_topblock['authid']).'&name='.urlencode($data_topblock['name']).'">'.htmlspecialchars($data_topblock['name']).'</a></td>';
- echo '<td align="center"><b>'.$data_topblock['block'].'</b></td>';
- if($data_topblock['distance']<100000000) echo '<td align="center">'.$data_topblock['distance'] = substr($data_topblock['distance'], 1, 2).'.'.substr($data_topblock['distance'], 2, 3).'</td>';
- else echo '<td align="center">'.$data_topblock['distance'] = substr($data_topblock['distance'], 0, 3).'.'.substr($data_topblock['distance'], 3, 3).'</td>';
- if($data_max_jof['jumpoff']==$data_topblock['jumpoff'])
- {
- echo '<td align="center"><font color=red><b>'.$data_topblock['jumpoff'].'</b></font></td>';
- }
- else echo '<td align="center">'.$data_topblock['jumpoff'].'</td></tr>';
- $old_block=$data_topblock['block'];
- $oldjj=$jj;
- $jj++;
- $i++;
- }
- }
- echo '<tr>
- <td colspan="8" bgcolor=#232323><center><b><br><a href="uq_jumpstats.php?nametype=LongJump&type=lj">Back to Main Tops</a></b>
- </tr>';
- $q="SELECT count(*) FROM `block_tops` WHERE jumptype='".$type."'";
- $res=mysql_query($q);
- $row=mysql_fetch_row($res);
- $total_rows=$row[0];
- $num_pages=ceil($total_rows/$per_page);
- if($num_pages!=1 && $num_pages!=0)
- {
- echo '<tr><td bgcolor=#232323 COLSPAN=9><br><Font color = "white"><b><center>Pages</b></Font><br>';
- for($i=1,$k=1;$i<=$num_pages;$i++)
- {
- if ($i-1 == $page)
- {
- if($i==$k*48)
- {
- echo '<font size=2> '.$i.' </font><br>';
- $k++;
- }
- else echo '<font size=2> '.$i.' </font>';
- }
- else
- {
- if($i==$k*48)
- {
- echo '<font size=2><a href="uq_jumpstats.php?block=1&type='.$type.'&page='.$i.'"> <U>'.$i.'</U> </a></font><br>';
- $k++;
- }
- else echo '<font size=2><a href="uq_jumpstats.php?block=1&type='.$type.'&page='.$i.'"> <U>'.$i.'</U> </a></font>';
- }
- }
- echo '</td></tr>';
- }
- echo '<tr>
- <td colspan="8" bgcolor=#232323><br><center><b> uq_jumpstats by BorJomi 2010<br><a href=http://unique-kz.com/>unique-kz.com</a></b></center><br/>
- </tr>';
- echo '</table>';
- }
- else
- {
- echo '
- <script type="text/javascript">document.location.href="uq_jumpstats.php?nametype=LongJump&type=lj";</script>';
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement