wow thanks for the help MoT , hopefully this might help figure it out... as of right now you are the only decent person i've seen on this forum... patheic , i dont know the lingo like the others here do , but you took the time to help me , thanks man.
--------------- Added [DATE]1199784513[/DATE] at [TIME]1199784513[/TIME] ---------------
can you define how i could take this code.. and make it a variable in that case?
<html>
<head>
<title>Latest 10 PK's BY IHPK</title>
<script type="text/javascript">
<!--
function toggleMenu(id)
{
menu = document.getElementById(id);
if ( menu.style.display && menu.style.display != 'none' )
{
menu.style.display = 'none';
}
else
{
menu.style.display = 'block';
}
}
-->
</script>
<style type="text/css">
body
{
background: #242424;
color: #999999;
font: 11px verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;
margin: 0px;
padding: 0px;
}
.thead
{
background: #050505;
color: #2E2D2D;
font: bold 10px verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;
}
.thead a:link, .thead_alink
{
color: #2E2D2D;
text-decoration: none;
}
.thead a:visited, .thead_avisited
{
color: #2E2D2D;
text-decoration: none;
}
.thead a:hover, .thead a:active, .thead_ahover
{
color: #2E2D2D;
text-decoration: underline;
}
#top10pk {
display: none;
background: #000000;
color: #ffffff;
padding: 0px;
margin: 0px;
border: 1px dashed #ff0000;
}
.alt1, .alt1Active
{
background: #131313;
border: 1px solid #000000;
border-top-width: 0px; border-left-width: 0px;
}
</style>
</head>
<body>
<div align="center">
<span onClick="toggleMenu('top10pk')">*Latest 10 PK's</span>
<div id="top10pk">
<?
function GetMemberUsergroupId($forumname) {
$SelectString = sprintf("SELECT * FROM user WHERE username = '%s'",$forumname);
$fetch_result = mysql_query($SelectString);
if($fetch = mysql_fetch_array ( $fetch_result ))
return $fetch['usergroupid'];
return '0';
}
function GetMemberTagByName($forumname) {
$UserGroupID=GetMemberUsergroupId($forumname);
if($UserGroupID==0)
return '<font color=gray>';
$SelectString = "SELECT * FROM usergroup WHERE usergroupid = ".$UserGroupID;
$fetch_result = mysql_query($SelectString);
if($fetch = mysql_fetch_array ( $fetch_result))
return $fetch['opentag'];
return '<font color=gray>';
}
// Getting Vars
$i = $_GET[ 'page'];
if(!is_numeric ($i))
$i= 0;
if($i!=0 ) {
$x = ($i -1) * 60;
$page = ($i-1) * 60;
}
else {
$x = $i * 60;
$page = $i *60 ;
}
if(isset($_GET['order' ]))
if($_GET['order'] == 'ASC')
$order = 'ASC';
else $order = 'DESC';
if(isset($_GET[ 'realm']))
if($_GET[ 'realm'] == 'USWest' || $_GET ['realm'] == 'USEast' || $_GET['realm'] == 'Europe' )
$realm = mysql_real_escape_string ($_GET['realm']);
if(isset($_GET['viewname' ]))
$viewname = mysql_real_escape_string( $_GET['viewname']);
if(isset( $_GET['sort']))
{
if( $_GET['sort'] == 'time' )
$sort = 'time' ;
else if($_GET['sort' ] == 'level')
$sort = 'o_level';
else if($_GET ['sort'] == 'name' )
$sort = 'o_name' ;
else if($_GET['sort'] == 'type')
$sort = 'o_typ';
else if($_GET[ 'sort'] == 'killer')
$sort = 'killer';
else if( $_GET['sort'] == 'realm' )
$sort = 'realm' ;
else if ($_GET['sort'] == 'points')
$sort = 'Points';
}
// build navbar
$navbits = array('' => $vbphrase[ 'PKLog']);
$templatename = 'PKLog';
// Connecting to MYSQL Database
mysql_connect('localhost','ihpk_xx','xx');
mysql_select_db('ihpk_xxx');
//mysql_real_escape_string
// Generating Select String
$SelectString = "Select * FROM pklog "; // Base string
if(isset( $viewname))
$SelectString = $SelectString . sprintf( " WHERE killer='%s' ", $viewname);
if(isset( $realm) && isset($viewname ))
$SelectString = $SelectString . sprintf(" AND realm='%s' ", $realm );
else if(isset($realm))
$SelectString = $SelectString . sprintf(" WHERE realm='%s' ", $realm );
if(isset($sort))
$SelectString = $SelectString . sprintf(" ORDER BY %s", $sort );
else
$SelectString = $SelectString . sprintf(" ORDER BY id" );
if(isset($order))
$SelectString = $SelectString . " " . $order. " ";
else
$SelectString = $SelectString . " DESC";
// The End
$SelectString = $SelectString . sprintf (" LIMIT ".$page. ",10");
/*
if(isset($_GET['viewname']))
$SelectString = sprintf("SELECT * FROM pklog WHERE killer='%s' ORDER by id ".$order."" LIMIT ".$page.",60" , mysql_real_escape_string($_GET['viewname']));
else
$SelectString = sprintf("SELECT * FROM pklog ORDER by id ".$order." LIMIT ".$page.",60");
*/
$pklog_result = mysql_query($SelectString ) or die ("A database error occured: " . mysql_error ());
function TotalPKs()
{
if(isset($_GET ['realm']))
if($_GET ['realm'] == 'USWest' || $_GET['realm'] == 'USEast' || $_GET['realm'] == 'Europe')
$realm = mysql_real_escape_string($_GET['realm' ]);
if(isset($_GET['viewname' ]))
$viewname = mysql_real_escape_string ($_GET['viewname' ]);
// Generating Select String
$SelectString = "Select * FROM pklog "; // Base string
if(isset($viewname))
$SelectString = $SelectString . sprintf( " WHERE killer='%s' ", $viewname);
if(isset( $realm) && isset($viewname ))
$SelectString = $SelectString . sprintf(" AND realm='%s' ", $realm );
else if(isset($realm))
$SelectString = $SelectString . sprintf(" WHERE realm='%s' ", $realm );
$pkliste_result = mysql_query ($SelectString);
$i =0;
while ( $pkliste = mysql_fetch_array ( $pkliste_result ) )
$i++;
return $i ;
}
if(!isset($_GET[ 'order']))
$dorder = 'DESC';
else if( $_GET['order'] == 'DESC' )
$dorder = 'ASC' ;
else if ($_GET['order'] == 'ASC')
$dorder = 'DESC';
else
$dorder = 'DESC';
// Building Table
echo '<table class="tborder" border="0" width="100%" align="center">
<tr align="center">
<td class="thead">#</td>
<td class="thead">Time</td>
<td class="thead">Victim</td>
<td class="thead">Class</td>
<td class="thead">Level</td>
<td class="thead">Killing Account</td>
<td class="thead">Game Type</td>
<td class="thead">PK Points</td>
<td class="thead">Realm</td>
</tr>';
while ( $pkliste = mysql_fetch_array($pklog_result) ) {
if($alt==2)
$alt=1;
else $alt=2;
$x++;
$killer = GetMemberTagByName($pkliste['killer' ]) . $pkliste['killer'] . "</font>";
// String which will be shown on teh template ^^
echo '<tr>
<td align="center" class="alt">'.$x.'</td>
<td align="center" class="alt">'.$pkliste['zeit' ].'</td>
<td align="center" class="alt">'.$pkliste['o_name'].'</td>
<td align="center" class="alt">'.$pkliste['o_typ' ].'</td>
<td align="center" class="alt">Level '.$pkliste['o_level'].'</td>
<td align="center" class="alt"><a href=pklog.php?viewname='.$pkliste[ 'killer'].'>'.$killer.'</a></td>
<td align="center" class="alt">'.$pkliste['Gametype'].'</td>
<td align="center" class="alt">'.$pkliste[ 'Points'].'</td>
<td align="center" class="alt">'.$pkliste['realm'].'</td>
</tr>';
}
?>
</table>
</div>
</div>
More Information