root/trunk/website/forums/forums.cfm @ 33

<cfsetting enablecfoutputonly=true>
<!---
        Name         : forums.cfm
        Author       : Raymond Camden 
        Created      : June 10, 2004
        Last Updated : August 4, 2006
        History      : Support for UUID (rkc 1/27/05)
                                   Display lastmsg, msgcount (rkc 4/6/05)
                                   Fixed code that gets # of pages (rkc 4/8/05)                         
                                   Right colspan if no data (rkc 4/15/05)
                                   Pass mode to pagination tag, used to hide/show subscribe button (rkc 7/29/05)
                                   Remove mappings (8/27/05)
                                   Support for sorting (rkc 9/15/05)
                                   show last user (rkc 7/12/06)
                                   show title (rkc 8/4/06)
        Purpose          : Displays forums for conference
--->

<cfif not isDefined("url.conferenceid") or not len(url.conferenceid)>
        <cflocation url="index.cfm" addToken="false">
</cfif>

<!--- get parent conference --->
<cftry>
        <cfset request.conference = application.galleon.conference.getConference(url.conferenceid)>
        <cfcatch>
                <cflocation url="index.cfm" addToken="false">
        </cfcatch>
</cftry>

<!--- get my forums --->
<cfset data = application.galleon.forum.getForums(conferenceid=url.conferenceid)>

<!--- sort --->
<cfset data = request.udf.querySort(data,url.sort,url.sortdir)>

<!--- Loads header --->
<cfmodule template="tags/layout.cfm" templatename="main" title="#application.galleon.settings.title# : #request.conference.name#">

<!--- determine max pages --->
<cfif data.recordCount and data.recordCount gt application.galleon.settings.perpage>
        <cfset pages = ceiling(data.recordCount / application.galleon.settings.perpage)>
<cfelse>
        <cfset pages = 1>
</cfif>

<!--- Displays pagination on right side, plus left side buttons for threads --->
<cfmodule template="tags/pagination.cfm" pages="#pages#" mode="conference" />

<!--- Now display the table. This changes based on what our data is. --->
<cfoutput>
<p>
<table width="100%" cellpadding="6" class="tableDisplay" cellspacing="1" border="0">
        <tr class="tableHeader">
                <td colspan="5" class="tableHeader">Conference: #request.conference.name#</td>
        </tr>
        <tr class="tableSubHeader">
                <td class="tableSubHeader">#request.udf.headerLink("Forum","name")#</td>
                <td class="tableSubHeader">#request.udf.headerLink("Description")#</td>
                <td class="tableSubHeader">#request.udf.headerLink("Messages","messagecount")#</td>
                <td class="tableSubHeader">#request.udf.headerLink("Last Post","lastpost")#</td>
                <td class="tableSubHeader">#request.udf.headerLink("Read Only","readonly")#</td>
        </tr>
        <cfif data.recordCount>
                <cfset cachedUserInfo = request.udf.cachedUserInfo>
                <cfloop query="data" startrow="#(url.page-1)*application.galleon.settings.perpage+1#" endrow="#(url.page-1)*application.galleon.settings.perpage+application.galleon.settings.perpage#">
                        <tr class="tableRow#currentRow mod 2#">
                                <td><a href="threads.cfm?forumid=#id#">#name#</a></td>
                                <td>#description#</td>
                                <td>#messagecount#</td>
                                <td>
                                <cfif len(useridfk)>
                                <cfset uinfo = cachedUserInfo(username=useridfk,userid=true)>
                                <a href="messages.cfm?threadid=#threadidfk###last">#dateFormat(lastpost,"m/d/yy")# #timeFormat(lastpost,"h:mm tt")#</a> by #uinfo.username#
                                <cfelse>&nbsp;</cfif>
                                </td>
                                <td>#yesNoFormat(readonly)#</td>
                        </tr>
                </cfloop>
        <cfelse>
                <tr class="tableRow1">
                        <td colspan="5">Sorry, but there are no forums available for this conference.</td>
                </tr>
        </cfif>
</table>
</p>
</cfoutput>
        
</cfmodule>

<cfsetting enablecfoutputonly=false>