-Adam
04-08-2010, 04:51 PM
I type in my Username, which is shown below, however it doesnt update with a profile link, or username for that matter.
<?php
session_start();
include('includes/db_connect.php');
$username=$_SESSION['username'];
$fetch = mysql_fetch_object(mysql_query("SELECT * FROM `users` WHERE `username` = '$username'"));
if ( isset($_GET['search']) )
{
$find_username = mysql_escape_string($_GET['search']);
$where = array();
switch($_GET['where'])
{
case 1:
$find_username = '%' . $find_username . '%';
break;
case 2:
$find_username = $find_username . '%';
break;
case 3:
$find_username = '%' . $find_username;
break;
case 4:
$find_username = $find_username;
break;
}
switch($_GET['status'])
{
case 2:
$status = 'Alive';
break;
case 3:
$status = 'Dead';
break;
default:
$status = '';
}
if ( !empty($status) )
$where[] = "`status` = '$status'";
if ( !empty($_GET['ranks']) )
{
$ranks = split(';', mysql_escape_string($_GET['ranks']));
for($i=0, $len = count($ranks); $i<$len; ++$i)
{
$ranks[$i] = "'".$ranks[$i]."'";
}
$strRanks = join(',', $ranks);
$where[] = "`rank` IN ($strRanks)";
}
switch($_GET['order'])
{
case 2:
$orderfield = '`date`';
case 3:
$orderfield ='rankpoints';
default:
$orderfield = 'username';
}
switch($_GET['orderby'])
{
case 2:
$ordeby = 'DESC';
default:
$orderby = 'ASC';
}
$order = "ORDER BY $orderfield $orderby";
$result = mysql_query("SELECT * FROM `users` WHERE `username` LIKE '%$find_username%'" . (count($where) > 0 ? ' AND ' . join(' AND ', $where) : '') . ' ' . $order);
$return = "<table width=55% border=1 cellpadding='2' cellspacing=0 align='center' class='thinline'>
<tr height='22' class='topic'>
<td colspan='5' align='center' class='topic'>Users Found</td>
</tr>
<tr height='22' class='topic'>
<td class=tip width='27'>O</td>
<td class=tip width='5'>Friend</td>
<td width='45%' class=tip><center><font color=white><b>Username</font></td>
<td width='20%' class=tip><center><font color=white><b>Rank</b></font></td>
<td width='17%' class=tip><center><font color=white><b>Status</b></font></tr>";
while($row = mysql_fetch_object($result))
{
if ($row->crew=="0"){ $crew="None"; }else{ $crew=$row->crew; }
$checkf = mysql_num_rows(mysql_query("SELECT * FROM friends WHERE person='$username' AND username='$row->username' AND type='Blocked'"));
if($fetch->tester == "1"){ $reg = " <a href='javascript: ;' onclick=\"modal('prof2.php?viewuser=$row->username','<div class=\'header1\'>$row->username\'s Profile</div>','950','600');'>$row->username</a>"; }elseif($fetch->tester == "0"){ $reg = " <a href='profile.php?viewuser=$row->username'>$row->username</a>"; }
$return .= "
<tr height='22' background='>
<td class=tableborder><b>$reg</b></td>
<td class=tableborder><b><center>$row->rank</b></td>
<td class=tableborder><b><center>$row->status</b></td>
</tr>
";
}
$return .= " </table> ";
//url = this.url + "search=" + this.searchOptUsername + "&where=" + this.searchOptWhere + "&status=" + this.searchOptStatus + "&order=" + this.searchOptOrderWhat + "&orderby=" + this.searchOptOrderBy + "&ranks=" + this.searchOptRank;
echo $return;
exit;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="author" content="vladykx" />
<link rel="stylesheet" href="includes/in.php" type="text/css">
<script type="text/javascript" src="ajaxSuggest.js"></script>
<script type="text/javascript">
function modal (page,title,width,height) {
parent.passModal(page,title,width,height);
return false;
}
</script>
<title>Find User</title>
<style type="text/css">
<!--
.style1 {color: #333333}
.style2 {color: #666666}
-->
</style>
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="62%" align="center" valign="top"><table width="700" border="0" align="center" cellpadding="2" cellspacing="0" bordercolor="black" class="thinline">
<tr>
<td class="topic" colspan="6" height="<?php if($fetch->layout == "1"){ echo"20"; }else{ echo"29"; }?>"><center class="bold">
Find Gangster
</center></td>
</tr>
<tr>
<td width="18%" bordercolor="#000000" class="tableborder">Username:</td>
<td colspan="2" bordercolor="#000000" class="tableborder"><input type="text" id="ajaxSuggestElement" class="textbox" /></td>
<td width="15%">Account status:</td>
<td width="33%" colspan="2"><select name="type" class='input' onchange="ajaxSuggest.searchOptStatus=this.value; ajaxSuggest.doSuggest();">
<option value="1">Any</option>
<option value="2">Alive</option>
<option value="3">Dead</option>
</select> </td>
</tr>
<tr>
<td width="18%" align="left">Position of criteria:</td>
<td align="left" colspan="2"><select name="searchtype" class='input' onchange="ajaxSuggest.searchOptWhere=this.value; ajaxSuggest.doSuggest();">
<option value="1">Anywhere</option>
<option value="2">Beginning of the username</option>
<option value="3">End the username</option>
<option value="4">Full username</option>
</select> </td>
<td width="15%">Order by:</td>
<td colspan="2"><select name="order" class='input' onchange="ajaxSuggest.searchOptOrderWhat=this.value; ajaxSuggest.doSuggest();">
<option value="1">Name</option>
<option value="2">Sign up</option>
<option value="3">Rank</option>
</select>
<select name="orderby" class='input' onchange="ajaxSuggest.searchOptOrderBy=this.value; ajaxSuggest.doSuggest();">
<option value="1">Ascending</option>
<option value="2">Descending</option>
</select> </td>
</tr>
<!-- <tr>
<td valign="middle" bordercolor="#000000" colspan="3" class="tableborder" align="center"><input type="submit" class="custombutton" value="Search GB!" id="user_button6" name="user_button"/></td>
</tr>-->
</table></td>
</tr>
</table>
<br />
<div class="style1" id="search-results">
<div align="center" class="style2">Search for a username in the box and it will update automatically.</div>
</div>
</body>
</html>
I type in my Username, which is shown below, however it doesnt update with a profile link, or username for that matter.
http://i34.tinypic.com/264qq2b.png
<?php
session_start();
include('includes/db_connect.php');
$username=$_SESSION['username'];
$fetch = mysql_fetch_object(mysql_query("SELECT * FROM `users` WHERE `username` = '$username'"));
if ( isset($_GET['search']) )
{
$find_username = mysql_escape_string($_GET['search']);
$where = array();
switch($_GET['where'])
{
case 1:
$find_username = '%' . $find_username . '%';
break;
case 2:
$find_username = $find_username . '%';
break;
case 3:
$find_username = '%' . $find_username;
break;
case 4:
$find_username = $find_username;
break;
}
switch($_GET['status'])
{
case 2:
$status = 'Alive';
break;
case 3:
$status = 'Dead';
break;
default:
$status = '';
}
if ( !empty($status) )
$where[] = "`status` = '$status'";
if ( !empty($_GET['ranks']) )
{
$ranks = split(';', mysql_escape_string($_GET['ranks']));
for($i=0, $len = count($ranks); $i<$len; ++$i)
{
$ranks[$i] = "'".$ranks[$i]."'";
}
$strRanks = join(',', $ranks);
$where[] = "`rank` IN ($strRanks)";
}
switch($_GET['order'])
{
case 2:
$orderfield = '`date`';
case 3:
$orderfield ='rankpoints';
default:
$orderfield = 'username';
}
switch($_GET['orderby'])
{
case 2:
$ordeby = 'DESC';
default:
$orderby = 'ASC';
}
$order = "ORDER BY $orderfield $orderby";
$result = mysql_query("SELECT * FROM `users` WHERE `username` LIKE '%$find_username%'" . (count($where) > 0 ? ' AND ' . join(' AND ', $where) : '') . ' ' . $order);
$return = "<table width=55% border=1 cellpadding='2' cellspacing=0 align='center' class='thinline'>
<tr height='22' class='topic'>
<td colspan='5' align='center' class='topic'>Users Found</td>
</tr>
<tr height='22' class='topic'>
<td class=tip width='27'>O</td>
<td class=tip width='5'>Friend</td>
<td width='45%' class=tip><center><font color=white><b>Username</font></td>
<td width='20%' class=tip><center><font color=white><b>Rank</b></font></td>
<td width='17%' class=tip><center><font color=white><b>Status</b></font></tr>";
while($row = mysql_fetch_object($result))
{
if ($row->crew=="0"){ $crew="None"; }else{ $crew=$row->crew; }
$checkf = mysql_num_rows(mysql_query("SELECT * FROM friends WHERE person='$username' AND username='$row->username' AND type='Blocked'"));
if($fetch->tester == "1"){ $reg = " <a href='javascript: ;' onclick=\"modal('prof2.php?viewuser=$row->username','<div class=\'header1\'>$row->username\'s Profile</div>','950','600');'>$row->username</a>"; }elseif($fetch->tester == "0"){ $reg = " <a href='profile.php?viewuser=$row->username'>$row->username</a>"; }
$return .= "
<tr height='22' background='>
<td class=tableborder><b>$reg</b></td>
<td class=tableborder><b><center>$row->rank</b></td>
<td class=tableborder><b><center>$row->status</b></td>
</tr>
";
}
$return .= " </table> ";
//url = this.url + "search=" + this.searchOptUsername + "&where=" + this.searchOptWhere + "&status=" + this.searchOptStatus + "&order=" + this.searchOptOrderWhat + "&orderby=" + this.searchOptOrderBy + "&ranks=" + this.searchOptRank;
echo $return;
exit;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="author" content="vladykx" />
<link rel="stylesheet" href="includes/in.php" type="text/css">
<script type="text/javascript" src="ajaxSuggest.js"></script>
<script type="text/javascript">
function modal (page,title,width,height) {
parent.passModal(page,title,width,height);
return false;
}
</script>
<title>Find User</title>
<style type="text/css">
<!--
.style1 {color: #333333}
.style2 {color: #666666}
-->
</style>
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="62%" align="center" valign="top"><table width="700" border="0" align="center" cellpadding="2" cellspacing="0" bordercolor="black" class="thinline">
<tr>
<td class="topic" colspan="6" height="<?php if($fetch->layout == "1"){ echo"20"; }else{ echo"29"; }?>"><center class="bold">
Find Gangster
</center></td>
</tr>
<tr>
<td width="18%" bordercolor="#000000" class="tableborder">Username:</td>
<td colspan="2" bordercolor="#000000" class="tableborder"><input type="text" id="ajaxSuggestElement" class="textbox" /></td>
<td width="15%">Account status:</td>
<td width="33%" colspan="2"><select name="type" class='input' onchange="ajaxSuggest.searchOptStatus=this.value; ajaxSuggest.doSuggest();">
<option value="1">Any</option>
<option value="2">Alive</option>
<option value="3">Dead</option>
</select> </td>
</tr>
<tr>
<td width="18%" align="left">Position of criteria:</td>
<td align="left" colspan="2"><select name="searchtype" class='input' onchange="ajaxSuggest.searchOptWhere=this.value; ajaxSuggest.doSuggest();">
<option value="1">Anywhere</option>
<option value="2">Beginning of the username</option>
<option value="3">End the username</option>
<option value="4">Full username</option>
</select> </td>
<td width="15%">Order by:</td>
<td colspan="2"><select name="order" class='input' onchange="ajaxSuggest.searchOptOrderWhat=this.value; ajaxSuggest.doSuggest();">
<option value="1">Name</option>
<option value="2">Sign up</option>
<option value="3">Rank</option>
</select>
<select name="orderby" class='input' onchange="ajaxSuggest.searchOptOrderBy=this.value; ajaxSuggest.doSuggest();">
<option value="1">Ascending</option>
<option value="2">Descending</option>
</select> </td>
</tr>
<!-- <tr>
<td valign="middle" bordercolor="#000000" colspan="3" class="tableborder" align="center"><input type="submit" class="custombutton" value="Search GB!" id="user_button6" name="user_button"/></td>
</tr>-->
</table></td>
</tr>
</table>
<br />
<div class="style1" id="search-results">
<div align="center" class="style2">Search for a username in the box and it will update automatically.</div>
</div>
</body>
</html>
I type in my Username, which is shown below, however it doesnt update with a profile link, or username for that matter.
http://i34.tinypic.com/264qq2b.png