[ m3mo @ 20.12.2005. 18:56 ] @
dali bi mi neko mogao pomoci oko ove skripte da mogu da izabererm djevojke i muskarce koji su online.Trenutno se moze samo da izabere samo svi korisnici sa i bez slika.trenutni kod je

<?php

include('db_connect.php');
include('session_handler.inc');
include('error.php');
include('RadiusAssistant.inc');
save_request();

if (isset( $HTTP_POST_VARS['querystring']))
{
$querystring=$HTTP_POST_VARS['querystring'];
$STARTPOS=$HTTP_POST_VARS['STARTPOS'];
$ENDPOS=$HTTP_POST_VARS['ENDPOS'];
$SHOWNUM=$HTTP_POST_VARS['SHOWNUM'];
$TOTAL=$HTTP_POST_VARS['TOTAL'];
}

# retrieve the template
$query="SELECT * FROM templates WHERE tpl_description='Member Area'";
$retval=mysql_query($query,$link) or die(mysql_error());
$template = mysql_fetch_object($retval);

$query="SELECT COUNT(mem_timeout) FROM members, adverts WHERE adv_userid=mem_userid AND unix_timestamp(mem_timeout) > unix_timestamp(NOW())-120 AND adv_approved=1 AND adv_paused='N'";
$result=mysql_query($query,$link);
$TOTAL_ONLINE = mysql_result($result,0,0);

$whos_cond = $_POST["whos_cond"];
if (empty($whos_cond)) {
$whos_cond = "all";
}

# Return the search results
if (! isset( $querystring) ) {

$STARTPOS = 0;
$ENDPOS = 15;
$SHOWNUM = 15;
$DISPLAYPOS=$STARTPOS+1;

$condition = "AND unix_timestamp(mem_timeout) > unix_timestamp(NOW())-120";
if ($whos_cond == "pic") {
$condition .= " AND ADV_PICTURE != '/images/genericm.gif' AND ADV_PICTURE != '/images/genericf.gif' AND ADV_PICTURE != '/images/genericc.gif' ";
}

$tempYear=date("Y"); $tempMonth=date("n"); $tempDay=date("j");
$upperYear=($tempYear-$txtToAge)-1;
$upperDate=$upperYear."-".$tempMonth."-".$tempDay;
$lowerYear=($tempYear-$txtFromAge);
$lowerDate=$lowerYear."-".$tempMonth."-".$tempDay;


$query="SELECT COUNT(adv_userid) FROM adverts LEFT JOIN members ON (adv_userid=mem_userid) WHERE (adv_approved=1) AND adv_paused='N' ".$condition." ORDER BY adv_createdate desc";
// echo $query;
$result = mysql_query($query,$link) or die(mysql_error());
$TOTAL = mysql_result($result,0,0);
if ($ENDPOS > $TOTAL) { $ENDPOS=$TOTAL; }
if ($TOTAL < 1) {
$STARTPOS = 0;
$ENDPOS = 0;
$SHOWNUM = 0;
$TOTAL = 0;
# only used for displaying
$DISPLAYPOS=0;
}
$query="SELECT *, (YEAR(CURDATE())-YEAR(adv_dob)) - (RIGHT(CURDATE(),5) < RIGHT(adv_dob,5)) AS age,
mem_timeout
FROM adverts
LEFT JOIN members
ON (adv_userid=mem_userid)
LEFT JOIN geo_country
ON (adv_countryid = gcn_countryid)
LEFT JOIN geo_state
ON (adv_stateid = gst_stateid)
LEFT JOIN geo_city
ON (adv_cityid = gct_cityid)
WHERE (adv_approved=1)
".$condition."
AND adv_paused='N'
ORDER BY adv_createdate desc";
// echo $query;
$result=mysql_query($query." LIMIT $STARTPOS,$SHOWNUM",$link);
} else {
$STARTPOS = $ENDPOS;
$ENDPOS = $STARTPOS + $SHOWNUM;
# only used for displaying
$DISPLAYPOS=$STARTPOS+1;
$query=str_replace ('\\', '', $querystring);
$result=mysql_query($query." LIMIT $STARTPOS,$SHOWNUM",$link);

if ($ENDPOS > $TOTAL) { $ENDPOS=$TOTAL; }
}
?>
<?php $sess_id="".session_id(); if (get_magic_quotes_gpc==0) $template->tpl_header=addslashes($template->tpl_header); eval("\$template->tpl_header=\"$template->tpl_header\";"); print(stripslashes($template->tpl_header)); ?>



<table width="<?php print("$CONST_TABLE_WIDTH"); ?>" align="<?php print("$CONST_TABLE_ALIGN"); ?>" border="0" cellspacing="<?php print("$CONST_TABLE_CELLSPACING"); ?>" cellpadding="<?php print("$CONST_TABLE_CELLPADDING"); ?>">
<tr>
<td align="right"> <?php
if ($Sess_UserType == "A") {
print("<a href='$CONST_LINK_ROOT/admin.php?".session_id()."'><img border='0' src='$CONST_LINK_ROOT/images/$CONST_IMAGE_LANG/mem_$Sess_Userlevel.gif' width='$CONST_MEMIMAGE_WIDTH' height='$CONST_MEMIMAGE_HEIGHT'>");
} else {
print("<img border='0' src='$CONST_LINK_ROOT/images/$CONST_IMAGE_LANG/mem_$Sess_Userlevel.gif' width='$CONST_MEMIMAGE_WIDTH' height='$CONST_MEMIMAGE_HEIGHT'>");
}
?>
</td>
</tr>
<tr>

<td class="pageheader"><?php echo WHOSON_SECTION_NAME ?></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="<?php print("$CONST_SUBTABLE_CELLSPACING"); ?>" cellpadding="<?php print("$CONST_SUBTABLE_CELLPADDING"); ?>">
<form method="post" action="<?php echo $CONST_LINK_ROOT ?>/ko_je_online.php<?php print("?".session_id()); ?>">
<tr >
<td colspan="5" align="left"><?=WHOSON_CONDITION?>:
<select name="whos_cond" onchange="this.form.submit()">
<option value="all" <?if ($whos_cond=="all") {echo " SELECTED";}?>><?=WHOSON_ALL?>
<option value="pic" <?if ($whos_cond=="pic") {echo " SELECTED";}?>><?=WHOSON_PIC?>
</select>
</td>
</tr>
</form>
<form method="post" action="<?php echo $CONST_LINK_ROOT ?>/rezultat_pretrage.php<?php print("?".session_id()); ?>">
<tr >
<td colspan="5" align="right"><b>
<input type='hidden' name='querystring' value=<?php print("\"$query\""); ?>>
<input type='hidden' name='STARTPOS' value=<?php print("'$STARTPOS'"); ?>>
<input type='hidden' name='ENDPOS' value=<?php print("'$ENDPOS'"); ?>>
<input type='hidden' name='SHOWNUM' value=<?php print("'$SHOWNUM'"); ?>>
<input type='hidden' name='TOTAL' value=<?php print("'$TOTAL'"); ?>>
<?php print("$DISPLAYPOS - $ENDPOS of $TOTAL"); ?></b></td>
</tr>
<tr >
<td colspan="5" align="left"><b><?php echo WHOSE_ON ?><?php echo $TOTAL_ONLINE ?><?php echo WHOSE_ON2 ?></b></td>
</tr>
<?php
# insert the line code here
while ($sql_array = mysql_fetch_object($result) ) {
if ($sql_array->adv_expiredate >= date("Y-m-d")) {
$statuspic="$CONST_LINK_ROOT/images/$CONST_IMAGE_LANG/gold.gif";
$statustext=STATUS_P;
} else {
$statuspic="$CONST_LINK_ROOT/images/$CONST_IMAGE_LANG/silver.gif";
$statustext=STATUS_S;
}
if( empty($sql_array->adv_location)) {
$locationtext=GENERAL_NOT_STATE;
} else {
$locationtext=$sql_array->adv_location;
}
$age=$sql_array->age;
$comment_text=substr($sql_array->adv_comment,0,120);
$comment_text=stripslashes($comment_text);
$comment_text=str_replace("\n"," ",$comment_text);
$comment_text=str_replace("\t"," ",$comment_text);
$sql_array->adv_title=stripslashes($sql_array->adv_title);
$l_arr = array();
$l_arr[] = $sql_array->gct_name;
$l_arr[] = $sql_array->gst_name;
$l_arr[] = $sql_array->gcn_name;
$location = join(', ',$l_arr);
$temptime=mktime (date("H"),date("i")-2,date("s"),date("m") ,date("d"),date("Y"));
if ($sql_array->mem_timeout >= date('YmdHis',$temptime)) {
$online="<img ALT='".PRGSEARCH_ONLINE."' border='0' src='$CONST_LINK_ROOT/images/$CONST_IMAGE_LANG/online.gif'>";
} else {
$online="<img ALT='".PRGSEARCH_OFFLINE."Member Offline' border='0' src='$CONST_LINK_ROOT/images/$CONST_IMAGE_LANG/offline.gif'>";
}
if (strstr($sql_array->adv_picture, "/members/")) {
if ($CONST_THUMBS == 'Y') {
$thumb_pic=$CONST_LINK_ROOT.str_replace("/members/", "/thumbs/", $sql_array->adv_picture); $dimensions="";
} else {
$thumb_pic=$CONST_LINK_ROOT.$sql_array->adv_picture; $dimensions=" width='59' height='66'";
}
} else {
$thumb_pic=$CONST_LINK_ROOT.$sql_array->adv_picture; $dimensions=" width='59' height='66'";
}
# start print
print("<tr>
<td class='tdhead'> <a href='$CONST_LINK_ROOT/vidi_korisnika.php?$sess_id&userid=$sql_array->adv_userid'>
$sql_array->adv_username</a> </td>
<td colspan='2' class='tdhead'>$sql_array->adv_title</td>
</tr>
<tr >
<td rowspan='3' align='center' valign='top' class='td2'><a href='$CONST_LINK_ROOT/vidi_korisnika.php?".session_id()."&userid=$sql_array->adv_userid'><img border='0' src='$thumb_pic' $dimensions></a></td>
<td colspan='2' align='right' valign='top' class='td3'><strong>$age $agetext $location</strong></td>
</tr>
<tr >
<td colspan='2' valign='top' class='td3'><i>$comment_text ...</i></td>
</tr>
<tr >
<td align='left' valign='top' class='td3'>$statustext</td>
<td align='right' valign='top' class='td3'>$online&nbsp;</td>
</tr>
<tr >
<td colspan='3' align='left' valign='top' class='tdfoot'>&nbsp;</td>
</tr>
"); # end print
}
?>
<tr>
<td colspan="5"> <center>
<?php
if (($STARTPOS + $SHOWNUM) < $TOTAL) {
print ("<input type='submit' name='nextmatch' value='.BUTTON_NEXTMATCH.' class='button' >");
}
else {print (NO_MATCHES_SECTION_NAME);}
?>
</center></td>
</tr>
</form>
</table></td>
</tr>
</table>
<?php if (get_magic_quotes_gpc==0) $template->tpl_footer=addslashes($template->tpl_footer); eval("\$template->tpl_footer=\"$template->tpl_footer\";"); print(stripslashes($template->tpl_footer)); ?>


[Ovu poruku je menjao m3mo dana 20.12.2005. u 19:57 GMT+1]