'; global $db_prefix; $wm=0; $rand=mysql_query("select id_topic from {$db_prefix}topics order by rand() limit 10"); 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 10"); 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 10"); 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 10"); 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 10"); 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 10"); 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 10"); 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 10"); 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 10"); 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 '
|
|