';
global $db_prefix;
$wm=0;
$rand=mysql_query("select id_topic from {$db_prefix}topics order by rand() limit 5");
while($rrow=mysql_fetch_array($rand)){
$row=mysql_fetch_array(mysql_query("select id_topic,subject from {$db_prefix}messages where id_topic = '".$rrow['id_topic']."'"));
$wm++;
$row['subject']=str_replace("Ynt:","",$row['subject']);
$krow=substr($row['subject'],0,30);
$ksay=strlen($row['subject']);
echo '
';
}
echo '
|
|
';
global $db_prefix;
if($_GET['wm']=="esy" or !$_GET['wm']=="ecc" or !$_GET['wm']=="ecg"){
$wm=0;
$esy=mysql_query("select id_topic,id_msg,id_member,subject from {$db_prefix}messages order by id_msg desc limit 5");
while($row=mysql_fetch_array($esy)){
$wm++;
$row['subject']=str_replace("Ynt:","",$row['subject']);
$krow=substr($row['subject'],0,45);
$ksay=strlen($row['subject']);
$mname=mysql_fetch_array(mysql_query("select id_member,real_name from {$db_prefix}members where id_member = '".$row['id_member']."'"));
$grup=mysql_fetch_array(mysql_query("Select * from {$db_prefix}members where id_member = '".$row['id_member']."'"));
if($grup['id_group']==0){
$renk=mysql_fetch_array(mysql_query("Select * from {$db_prefix}membergroups where id_group = '".$grup['id_post_group']."'"));
}else{
$renk=mysql_fetch_array(mysql_query("Select * from {$db_prefix}membergroups where id_group = '".$grup['id_group']."'"));
}
echo '
';}
}elseif($_GET['wm']=="ecc"){
$wm=0;
$ecc=mysql_query("select id_topic,num_replies,num_views from {$db_prefix}topics order by num_replies desc limit 5");
while($erow=mysql_fetch_array($ecc)){
$row=mysql_fetch_array(mysql_query("select id_topic,subject from {$db_prefix}messages where id_topic = '".$erow['id_topic']."'"));
$wm++;
$row['subject']=str_replace("Ynt:","",$row['subject']);
$krow=substr($row['subject'],0,45);
$ksay=strlen($row['subject']);
echo '';}
}elseif($_GET['wm']=="ecg"){
$wm=0;
$ecg=mysql_query("select id_topic,num_replies,num_views from {$db_prefix}topics order by num_views desc limit 5");
while($erow=mysql_fetch_array($ecg)){
$row=mysql_fetch_array(mysql_query("select id_topic,subject from {$db_prefix}messages where id_topic = '".$erow['id_topic']."'"));
$wm++;
$row['subject']=str_replace("Ynt:","",$row['subject']);
$krow=substr($row['subject'],0,45);
$ksay=strlen($row['subject']);
echo '';}
}else{
$wm=0;
$esy=mysql_query("select id_topic,id_msg,id_member,subject from {$db_prefix}messages order by id_msg desc limit 5");
while($row=mysql_fetch_array($esy)){
$wm++;
$row['subject']=str_replace("Ynt:","",$row['subject']);
$krow=substr($row['subject'],0,45);
$ksay=strlen($row['subject']);
$mname=mysql_fetch_array(mysql_query("select id_member,real_name from {$db_prefix}members where id_member = '".$row['id_member']."'"));
$grup=mysql_fetch_array(mysql_query("Select * from {$db_prefix}members where id_member = '".$row['id_member']."'"));
if($grup['id_group']==0){
$renk=mysql_fetch_array(mysql_query("Select * from {$db_prefix}membergroups where id_group = '".$grup['id_post_group']."'"));
}else{
$renk=mysql_fetch_array(mysql_query("Select * from {$db_prefix}membergroups where id_group = '".$grup['id_group']."'"));
}
echo '
';}
}
echo '
|
|
';
$wm=0;
if($_GET['wm']=="ecy"){
$ecy=mysql_query("select id_member,real_name,posts from {$db_prefix}members order by posts desc limit 5");
while($row=mysql_fetch_array($ecy)){
$wm++;
$grup=mysql_fetch_array(mysql_query("Select * from {$db_prefix}members where id_member = '".$row['id_member']."'"));
if($grup['id_group']==0){
$renk=mysql_fetch_array(mysql_query("Select * from {$db_prefix}membergroups where id_group = '".$grup['id_post_group']."'"));
}else{
$renk=mysql_fetch_array(mysql_query("Select * from {$db_prefix}membergroups where id_group = '".$grup['id_group']."'"));
}
echo '
';
}
}elseif($_GET['wm']!="ecy" and $_GET['wm']=="eck" and $_GET['wm']!="eyu"){
$wm=0;
$uyeler=mysql_query("select id_member from smf_members limit 1");
while($row=mysql_fetch_array($uyeler)){
$id_member=$row['id_member'];
$say=mysql_query("select count(id_member_started) as count, id_member_started from smf_topics group by id_member_started order by count desc limit 5");
while($rsay=mysql_fetch_array($say)){
$wm++;
$grup=mysql_fetch_array(mysql_query("Select * from smf_members where id_member = '".$rsay['id_member_started']."'"));
if($grup['id_group']==0){
$renk=mysql_fetch_array(mysql_query("Select * from smf_membergroups where id_group = '".$grup['id_post_group']."'"));
}else{
$renk=mysql_fetch_array(mysql_query("Select * from smf_membergroups where id_group = '".$grup['id_group']."'"));
}
$isim=mysql_fetch_array(mysql_query("select id_member,real_name from smf_members where id_member = '".$rsay['id_member_started']."'"));
echo '';
}
}
}elseif($_GET['wm']!="ecy" and $_GET['wm']!="eck" and $_GET['wm']=="eyu"){
$eyu=mysql_query("select id_member,real_name,posts from {$db_prefix}members order by id_member desc limit 5");
while($row=mysql_fetch_array($eyu)){
$wm++;
$grup=mysql_fetch_array(mysql_query("Select * from {$db_prefix}members where id_member = '".$row['id_member']."'"));
if($grup['id_group']==0){
$renk=mysql_fetch_array(mysql_query("Select * from {$db_prefix}membergroups where id_group = '".$grup['id_post_group']."'"));
}else{
$renk=mysql_fetch_array(mysql_query("Select * from {$db_prefix}membergroups where id_group = '".$grup['id_group']."'"));
}
echo '
';
}
}else{
$ecy=mysql_query("select id_member,real_name,posts from {$db_prefix}members order by posts desc limit 5");
while($row=mysql_fetch_array($ecy)){
$wm++;
$grup=mysql_fetch_array(mysql_query("Select * from {$db_prefix}members where id_member = '".$row['id_member']."'"));
if($grup['id_group']==0){
$renk=mysql_fetch_array(mysql_query("Select * from {$db_prefix}membergroups where id_group = '".$grup['id_post_group']."'"));
}else{
$renk=mysql_fetch_array(mysql_query("Select * from {$db_prefix}membergroups where id_group = '".$grup['id_group']."'"));
}
echo '
';
}
}
echo '
|
|