summary refs log tree commit diff stats
diff options
context:
space:
mode:
authorStarla Insigna <hatkirby@fourisland.com>2009-05-18 09:35:13 -0400
committerStarla Insigna <hatkirby@fourisland.com>2009-05-18 09:35:13 -0400
commitaee267d82cce912dc520419682668490c767f674 (patch)
treed7c5c6f8e25e70afb124d2a402e2237fc5777577
parentaefe1e9de37eee81f2804fd508b131dbfdb882cc (diff)
downloadfourisland-aee267d82cce912dc520419682668490c767f674.tar.gz
fourisland-aee267d82cce912dc520419682668490c767f674.tar.bz2
fourisland-aee267d82cce912dc520419682668490c767f674.zip
Added poll comments to sidebar
-rwxr-xr-xincludes/footer.php15
1 files changed, 14 insertions, 1 deletions
diff --git a/includes/footer.php b/includes/footer.php index a37b438..04fe838 100755 --- a/includes/footer.php +++ b/includes/footer.php
@@ -88,7 +88,7 @@ if (!isset($noRightbar))
88 $i++; 88 $i++;
89 } 89 }
90 90
91 $getcomments = "SELECT * FROM comments WHERE page_id LIKE \"updates-%\" OR page_id LIKE \"quote-%\" ORDER BY id DESC LIMIT 0,5"; 91 $getcomments = "SELECT * FROM comments ORDER BY id DESC LIMIT 0,5";
92 $getcomments2 = mysql_query($getcomments); 92 $getcomments2 = mysql_query($getcomments);
93 $i=0; 93 $i=0;
94 while ($getcomments3[$i] = mysql_fetch_array($getcomments2)) 94 while ($getcomments3[$i] = mysql_fetch_array($getcomments2))
@@ -138,6 +138,19 @@ if (!isset($noRightbar))
138 'TITLE' => 'Quote #' . $num, 138 'TITLE' => 'Quote #' . $num,
139 'AUTHOR' => (($website != '') ? '<A HREF="' . $website . '">' . $username . '</A>' : $username))); 139 'AUTHOR' => (($website != '') ? '<A HREF="' . $website . '">' . $username . '</A>' : $username)));
140 $i++; 140 $i++;
141 } else if (strpos($getcomments3[$i]['page_id'], 'polloftheweek') !== FALSE)
142 {
143 $getpotw = "SELECT * FROM polloftheweek WHERE id = " . substr($getcomments3[$i]['page_id'],strpos($getcomments3[$i]['page_id'],'-')+1);
144 $getpotw2 = mysql_query($getpotw);
145 $getpotw3 = mysql_fetch_array($getpotw2);
146
147 $template->adds_block('COMMENTS', array( 'ID' => $getcomments3[$i]['id'],
148 'AREA' => 'poll',
149 'CODED' => $num,
150 'ENDING' => '.php',
151 'TITLE' => 'Poll "' . $getpotw3['question'] . '"',
152 'AUTHOR' => (($website != '') ? '<A HREF="' . $website . '">' . $username . '</A>' : $username)));
153 $i++;
141 } 154 }
142 } 155 }
143 156