[COLOR=#0000bb] ALTER TABLE [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#0000bb]forum[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#0000bb]banner[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]VARCHAR[/COLOR][COLOR=#007700]( [/COLOR][COLOR=#0000bb]50 [/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000bb]NOT NULL AFTER [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#0000bb]description[/COLOR][COLOR=#007700]` ;

[/COLOR][COLOR=#0000bb]ALTER TABLE [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#0000bb]forum[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#0000bb]bannerlink[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]VARCHAR[/COLOR][COLOR=#007700]( [/COLOR][COLOR=#0000bb]250 [/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000bb]NOT NULL AFTER [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#0000bb]banner[/COLOR][COLOR=#007700]` ; 
[/COLOR]

[COLOR=#0000bb] print_textarea_row[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$vbphrase[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'description'[/COLOR][COLOR=#007700]], [/COLOR][COLOR=#dd0000]'forum[description]'[/COLOR][COLOR=#007700], [/COLOR][COLOR=#0000bb]$forum[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'description'[/COLOR][COLOR=#007700]]); 

[/COLOR][COLOR=#0000bb][/COLOR]

[COLOR=green][LEFT]    [COLOR=#000000][COLOR=#0000bb] print_input_row[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$vbphrase[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'banner'[/COLOR][COLOR=#007700]], [/COLOR][COLOR=#dd0000]'forum[banner]'[/COLOR][COLOR=#007700], [/COLOR][COLOR=#0000bb]$forum[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'banner'[/COLOR][COLOR=#007700]]);
[/COLOR][COLOR=#0000bb]print_input_row[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$vbphrase[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'bannerlink'[/COLOR][COLOR=#007700]], [/COLOR][COLOR=#dd0000]'forum[bannerlink]'[/COLOR][COLOR=#007700], [/COLOR][COLOR=#0000bb]$forum[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'bannerlink'[/COLOR][COLOR=#007700]]); 
[/COLOR][COLOR=#0000bb][/COLOR][/COLOR]  [/LEFT]
[/COLOR]

[COLOR=#0000bb] $forum[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'description'[/COLOR][COLOR=#007700]] = [/COLOR][COLOR=#0000bb]convert_to_valid_html[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$forum[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'description'[/COLOR][COLOR=#007700]]); 

[/COLOR][COLOR=#0000bb][/COLOR]

[COLOR=green][LEFT]    [COLOR=#000000][COLOR=#0000bb] $forum[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'banner'[/COLOR][COLOR=#007700]] = [/COLOR][COLOR=#0000bb]convert_to_valid_html[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$forum[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'banner'[/COLOR][COLOR=#007700]]);
[/COLOR][COLOR=#0000bb]$forum[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'bannerlink'[/COLOR][COLOR=#007700]] = [/COLOR][COLOR=#0000bb]convert_to_valid_html[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$forum[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'bannerlink'[/COLOR][COLOR=#007700]]); 
[/COLOR][COLOR=#0000bb][/COLOR][/COLOR]  [/LEFT]
[/COLOR]

[COLOR=#0000bb] $navbar 
[/COLOR]

[COLOR=green][LEFT]    [COLOR=#000000][COLOR=#0000bb] [/COLOR][COLOR=#007700]<if [/COLOR][COLOR=#0000bb]condition[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"$foruminfo['banner'] AND $foruminfo['bannerlink']"[/COLOR][COLOR=#007700]><[/COLOR][COLOR=#0000bb]center[/COLOR][COLOR=#007700]><[/COLOR][COLOR=#0000bb]td[/COLOR][COLOR=#007700]><[/COLOR][COLOR=#0000bb]a href[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"$foruminfo[bannerlink]" [/COLOR][COLOR=#0000bb]target[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"_blank"[/COLOR][COLOR=#007700]><[/COLOR][COLOR=#0000bb]img src[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"images/banner/$foruminfo[banner]" [/COLOR][COLOR=#0000bb]alt[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"$foruminfo[banner]" [/COLOR][COLOR=#0000bb]border[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"0" [/COLOR][COLOR=#007700]/></[/COLOR][COLOR=#0000bb]a[/COLOR][COLOR=#007700]></[/COLOR][COLOR=#0000bb]td[/COLOR][COLOR=#007700]></[/COLOR][COLOR=#0000bb]center[/COLOR][COLOR=#007700]>
<else />
<if [/COLOR][COLOR=#0000bb]condition[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"$foruminfo['banner']"[/COLOR][COLOR=#007700]><[/COLOR][COLOR=#0000bb]center[/COLOR][COLOR=#007700]><[/COLOR][COLOR=#0000bb]td[/COLOR][COLOR=#007700]><[/COLOR][COLOR=#0000bb]img src[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"images/banner/$foruminfo[banner]" [/COLOR][COLOR=#0000bb]alt[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"$foruminfo[banner]" [/COLOR][COLOR=#0000bb]border[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"0" [/COLOR][COLOR=#007700]/></[/COLOR][COLOR=#0000bb]td[/COLOR][COLOR=#007700]></[/COLOR][COLOR=#0000bb]center[/COLOR][COLOR=#007700]>
</if>
</if> 
[/COLOR][COLOR=#0000bb][/COLOR][/COLOR]  [/LEFT]
[/COLOR]

 
[COLOR=#0000bb] $lastread [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000bb]$bbuserinfo[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'lastvisit'[/COLOR][COLOR=#007700]];

	} 
[/COLOR]

[COLOR=#0000bb] $topposter[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]''[/COLOR][COLOR=#007700];

	[/COLOR][COLOR=#0000bb]$top [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000bb]$DB_site[/COLOR][COLOR=#007700]->[/COLOR][COLOR=#0000bb]query[/COLOR][COLOR=#007700]([/COLOR][COLOR=#dd0000]"

		SELECT count(post.postid) AS total_post,count(thread.threadid) AS total_thread, user.userid,user.username,user.joindate from " [/COLOR][COLOR=#007700]. [/COLOR][COLOR=#0000bb]TABLE_PREFIX [/COLOR][COLOR=#007700]. [/COLOR][COLOR=#dd0000]"user AS user

  LEFT JOIN " [/COLOR][COLOR=#007700]. [/COLOR][COLOR=#0000bb]TABLE_PREFIX [/COLOR][COLOR=#007700]. [/COLOR][COLOR=#dd0000]"post AS post ON(user.userid = post.userid)

LEFT JOIN " [/COLOR][COLOR=#007700]. [/COLOR][COLOR=#0000bb]TABLE_PREFIX [/COLOR][COLOR=#007700]. [/COLOR][COLOR=#dd0000]"thread AS thread ON(post.threadid = thread.threadid) where

  thread.forumid='$forumid'

group by user.userid order by total_post DESC LIMIT 5"[/COLOR][COLOR=#007700]);

	[/COLOR][COLOR=#0000bb]$counteruser[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000bb]0[/COLOR][COLOR=#007700];

	while ([/COLOR][COLOR=#0000bb]$topp [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000bb]$DB_site[/COLOR][COLOR=#007700]->[/COLOR][COLOR=#0000bb]fetch_array[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$top[/COLOR][COLOR=#007700]))

	{

[/COLOR][COLOR=#0000bb]$counteruser[/COLOR][COLOR=#007700]++;

[/COLOR][COLOR=#0000bb]$topp[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'joindate'[/COLOR][COLOR=#007700]] = [/COLOR][COLOR=#0000bb]vbdate[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$vboptions[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'dateformat'[/COLOR][COLOR=#007700]], [/COLOR][COLOR=#0000bb]$topp[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'joindate'[/COLOR][COLOR=#007700]], [/COLOR][COLOR=#0000bb]true[/COLOR][COLOR=#007700]);

eval([/COLOR][COLOR=#dd0000]'$topposter .= "' [/COLOR][COLOR=#007700]. [/COLOR][COLOR=#0000bb]fetch_template[/COLOR][COLOR=#007700]([/COLOR][COLOR=#dd0000]'forumdisplay_topposter'[/COLOR][COLOR=#007700]) . [/COLOR][COLOR=#dd0000]'";'[/COLOR][COLOR=#007700]);

} 

[/COLOR][COLOR=#0000bb][/COLOR]

[COLOR=#0000bb] [/COLOR][COLOR=#dd0000]'forumhome_lastpostby'[/COLOR][COLOR=#007700], 

[/COLOR][COLOR=#0000bb][/COLOR]

[COLOR=#0000bb] [/COLOR][COLOR=#dd0000]'forumdisplay_topposter'[/COLOR][COLOR=#007700], 

[/COLOR][COLOR=#0000bb][/COLOR]

[COLOR=#0000bb] $navbar 

[/COLOR]

[COLOR=#0000bb] [/COLOR][COLOR=#007700]<[/COLOR][COLOR=#0000bb]br [/COLOR][COLOR=#007700]/>

<[/COLOR][COLOR=#0000bb]table border[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"0" [/COLOR][COLOR=#0000bb]cellspacing[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"$stylevar[cellspacing]" [/COLOR][COLOR=#0000bb]cellpadding[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"4" [/COLOR][COLOR=#007700]class=[/COLOR][COLOR=#dd0000]"tborder" [/COLOR][COLOR=#0000bb]width[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"$stylevar[tablewidth]"[/COLOR][COLOR=#007700]>

 <[/COLOR][COLOR=#0000bb]tr width[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"100%" [/COLOR][COLOR=#007700]class=[/COLOR][COLOR=#dd0000]"alt1"[/COLOR][COLOR=#007700]>

<[/COLOR][COLOR=#0000bb]td [/COLOR][COLOR=#007700]class=[/COLOR][COLOR=#dd0000]"thead" [/COLOR][COLOR=#0000bb]width[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"50%" [/COLOR][COLOR=#0000bb]align[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"$stylevar[left]"[/COLOR][COLOR=#007700]>[/COLOR][COLOR=#0000bb]أفضل خمس أعضاء[/COLOR][COLOR=#007700]</[/COLOR][COLOR=#0000bb]td[/COLOR][COLOR=#007700]>

<[/COLOR][COLOR=#0000bb]td [/COLOR][COLOR=#007700]class=[/COLOR][COLOR=#dd0000]"thead" [/COLOR][COLOR=#0000bb]width[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"50%" [/COLOR][COLOR=#0000bb]align[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"$stylevar[left]"[/COLOR][COLOR=#007700]>[/COLOR][COLOR=#0000bb]المشاركات[/COLOR][COLOR=#007700]</[/COLOR][COLOR=#0000bb]td[/COLOR][COLOR=#007700]>

[/COLOR][COLOR=#0000bb]$topposter

[/COLOR][COLOR=#007700]</[/COLOR][COLOR=#0000bb]table[/COLOR][COLOR=#007700]>

<[/COLOR][COLOR=#0000bb]br [/COLOR][COLOR=#007700]/> 

[/COLOR][COLOR=#0000bb][/COLOR]

[COLOR=#0000bb] [/COLOR][COLOR=#007700]<[/COLOR][COLOR=#0000bb]tr[/COLOR][COLOR=#007700]>

<[/COLOR][COLOR=#0000bb]td [/COLOR][COLOR=#007700]class=[/COLOR][COLOR=#dd0000]"alt1Active" [/COLOR][COLOR=#0000bb]align[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"$stylevar[left]" [/COLOR][COLOR=#0000bb]width[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"80%" [/COLOR][COLOR=#0000bb]id[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"u$topp[userid]"[/COLOR][COLOR=#007700]><[/COLOR][COLOR=#0000bb]span [/COLOR][COLOR=#007700]class=[/COLOR][COLOR=#dd0000]"smallfont"[/COLOR][COLOR=#007700]>[/COLOR][COLOR=#0000bb]$counteruser[/COLOR][COLOR=#007700])

		<[/COLOR][COLOR=#0000bb]a href[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"member.php?$session[sessionurl]u=$topp[userid]"[/COLOR][COLOR=#007700]>[/COLOR][COLOR=#0000bb]$topp[/COLOR][COLOR=#007700][[/COLOR][COLOR=#0000bb]username[/COLOR][COLOR=#007700]]</[/COLOR][COLOR=#0000bb]a[/COLOR][COLOR=#007700]><[/COLOR][COLOR=#0000bb]br [/COLOR][COLOR=#007700]/>[/COLOR][COLOR=#0000bb]تاريخ تسجيله [/COLOR][COLOR=#007700]: [/COLOR][COLOR=#0000bb]$topp[/COLOR][COLOR=#007700][[/COLOR][COLOR=#0000bb]joindate[/COLOR][COLOR=#007700]]</[/COLOR][COLOR=#0000bb]span[/COLOR][COLOR=#007700]></[/COLOR][COLOR=#0000bb]td[/COLOR][COLOR=#007700]>

  <[/COLOR][COLOR=#0000bb]td [/COLOR][COLOR=#007700]class=[/COLOR][COLOR=#dd0000]"alt1Active" [/COLOR][COLOR=#0000bb]width[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"20%"[/COLOR][COLOR=#007700]><[/COLOR][COLOR=#0000bb]span [/COLOR][COLOR=#007700]class=[/COLOR][COLOR=#dd0000]"smallfont"[/COLOR][COLOR=#007700]>[/COLOR][COLOR=#0000bb]$topp[/COLOR][COLOR=#007700][[/COLOR][COLOR=#0000bb]total_post[/COLOR][COLOR=#007700]]   (<[/COLOR][COLOR=#0000bb]a href[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"search.php?do=finduser&u=$topp[userid]&f=$forumid"[/COLOR][COLOR=#007700]>[/COLOR][COLOR=#0000bb]عرض هذه المشاركات[/COLOR][COLOR=#007700]</[/COLOR][COLOR=#0000bb]a[/COLOR][COLOR=#007700]>)</[/COLOR][COLOR=#0000bb]span[/COLOR][COLOR=#007700]></[/COLOR][COLOR=#0000bb]td[/COLOR][COLOR=#007700]> 

[/COLOR][COLOR=#0000bb][/COLOR]

 
[COLOR=green][LEFT]    [COLOR=#000000][COLOR=#0000bb] [/COLOR][COLOR=#007700]eval([/COLOR][COLOR=#dd0000]'$navbar = "' [/COLOR][COLOR=#007700]. [/COLOR][COLOR=#0000bb]fetch_template[/COLOR][COLOR=#007700]([/COLOR][COLOR=#dd0000]'navbar'[/COLOR][COLOR=#007700]) . [/COLOR][COLOR=#dd0000]'";'[/COLOR][COLOR=#007700]); 
[/COLOR][COLOR=#0000bb][/COLOR][/COLOR]  [/LEFT]
[/COLOR]

[COLOR=#0000bb] [/COLOR][COLOR=#ff8000]// Hack: most active user

[/COLOR][COLOR=#0000bb]$start [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000bb]TIMENOW [/COLOR][COLOR=#007700]- [/COLOR][COLOR=#0000bb]TIMENOW [/COLOR][COLOR=#007700]% [/COLOR][COLOR=#0000bb]86400[/COLOR][COLOR=#007700];

[/COLOR][COLOR=#0000bb]$end [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000bb]$start [/COLOR][COLOR=#007700]+ [/COLOR][COLOR=#0000bb]86400[/COLOR][COLOR=#007700];

[/COLOR][COLOR=#0000bb]$maxposter [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000bb]$DB_site[/COLOR][COLOR=#007700]->[/COLOR][COLOR=#0000bb]query_first[/COLOR][COLOR=#007700]([/COLOR][COLOR=#dd0000]"SELECT user.username,user.userid,count(*) total FROM "[/COLOR][COLOR=#007700].[/COLOR][COLOR=#0000bb]TABLE_PREFIX[/COLOR][COLOR=#007700].[/COLOR][COLOR=#dd0000]"user AS user,"[/COLOR][COLOR=#007700].[/COLOR][COLOR=#0000bb]TABLE_PREFIX[/COLOR][COLOR=#007700].[/COLOR][COLOR=#dd0000]"post AS post WHERE user.userid=post.userid AND post.dateline BETWEEN $start AND $end GROUP BY post.userid ORDER BY total DESC LIMIT 1"[/COLOR][COLOR=#007700]);



eval([/COLOR][COLOR=#dd0000]'$navbar = "' [/COLOR][COLOR=#007700]. [/COLOR][COLOR=#0000bb]fetch_template[/COLOR][COLOR=#007700]([/COLOR][COLOR=#dd0000]'navbar'[/COLOR][COLOR=#007700]) . [/COLOR][COLOR=#dd0000]'";'[/COLOR][COLOR=#007700]); 

[/COLOR][COLOR=#0000bb][/COLOR]

[COLOR=#0000bb] [/COLOR][COLOR=#007700]<[/COLOR][COLOR=#0000bb]div[/COLOR][COLOR=#007700]><[/COLOR][COLOR=#0000bb]phrase 1[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"member.php?$session[sessionurl]u=$newuserid" [/COLOR][COLOR=#0000bb]2[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"$newusername"[/COLOR][COLOR=#007700]>[/COLOR][COLOR=#0000bb]$vbphrase[/COLOR][COLOR=#007700][[/COLOR][COLOR=#0000bb]welcome_to_our_newest_member_x[/COLOR][COLOR=#007700]]</[/COLOR][COLOR=#0000bb]phrase[/COLOR][COLOR=#007700]></[/COLOR][COLOR=#0000bb]div[/COLOR][COLOR=#007700]> 

[/COLOR][COLOR=#0000bb][/COLOR]

[COLOR=#0000bb] [/COLOR][COLOR=#007700]<[/COLOR][COLOR=#0000bb]div[/COLOR][COLOR=#007700]><[/COLOR][COLOR=#0000bb]phrase 1[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"member.php?$session[sessionurl]u=$newuserid" [/COLOR][COLOR=#0000bb]2[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"$newusername"[/COLOR][COLOR=#007700]>[/COLOR][COLOR=#0000bb]$vbphrase[/COLOR][COLOR=#007700][[/COLOR][COLOR=#0000bb]welcome_to_our_newest_member_x[/COLOR][COLOR=#007700]]</[/COLOR][COLOR=#0000bb]phrase[/COLOR][COLOR=#007700]></[/COLOR][COLOR=#0000bb]div[/COLOR][COLOR=#007700]>

<if [/COLOR][COLOR=#0000bb]condition[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"$maxposter[userid]"[/COLOR][COLOR=#007700]><[/COLOR][COLOR=#0000bb]div[/COLOR][COLOR=#007700]><[/COLOR][COLOR=#0000bb]phrase 1[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"member.php?$session[sessionurl]u=$maxposter[userid]" [/COLOR][COLOR=#0000bb]2[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#dd0000]"$maxposter[username]"[/COLOR][COLOR=#007700]>[/COLOR][COLOR=#0000bb]$vbphrase[/COLOR][COLOR=#007700][[/COLOR][COLOR=#0000bb]most_active_user_in_forums[/COLOR][COLOR=#007700]]</[/COLOR][COLOR=#0000bb]phrase[/COLOR][COLOR=#007700]></[/COLOR][COLOR=#0000bb]div[/COLOR][COLOR=#007700]></if> 

[/COLOR][COLOR=#0000bb][/COLOR]