diff options
| -rwxr-xr-x | includes/footer.php | 33 | ||||
| -rwxr-xr-x | pages/quotes.php | 2 | ||||
| -rwxr-xr-x | theme/footer.tpl | 2 |
3 files changed, 27 insertions, 10 deletions
| diff --git a/includes/footer.php b/includes/footer.php index e4c88c8..09be74f 100755 --- a/includes/footer.php +++ b/includes/footer.php | |||
| @@ -79,15 +79,11 @@ if (!isset($noRightbar)) | |||
| 79 | $i++; | 79 | $i++; |
| 80 | } | 80 | } |
| 81 | 81 | ||
| 82 | $getcomments = "SELECT * FROM comments WHERE page_id LIKE \"updates-%\" ORDER BY id DESC LIMIT 0,5"; | 82 | $getcomments = "SELECT * FROM comments WHERE page_id LIKE \"updates-%\" OR page_id LIKE \"quote-%\" ORDER BY id DESC LIMIT 0,5"; |
| 83 | $getcomments2 = mysql_query($getcomments); | 83 | $getcomments2 = mysql_query($getcomments); |
| 84 | $i=0; | 84 | $i=0; |
| 85 | while ($getcomments3[$i] = mysql_fetch_array($getcomments2)) | 85 | while ($getcomments3[$i] = mysql_fetch_array($getcomments2)) |
| 86 | { | 86 | { |
| 87 | $getpost = "SELECT * FROM updates WHERE id = " . substr($getcomments3[$i]['page_id'],strpos($getcomments3[$i]['page_id'],'-')+1); | ||
| 88 | $getpost2 = mysql_query($getpost); | ||
| 89 | $getpost3 = mysql_fetch_array($getpost2); | ||
| 90 | |||
| 91 | $getuser = "SELECT * FROM users WHERE username = \"" . $getcomments3[$i]['username'] . "\""; | 87 | $getuser = "SELECT * FROM users WHERE username = \"" . $getcomments3[$i]['username'] . "\""; |
| 92 | $getuser2 = mysql_query($getuser); | 88 | $getuser2 = mysql_query($getuser); |
| 93 | $getuser3 = mysql_fetch_array($getuser2); | 89 | $getuser3 = mysql_fetch_array($getuser2); |
| @@ -109,10 +105,29 @@ if (!isset($noRightbar)) | |||
| 109 | } | 105 | } |
| 110 | 106 | ||
| 111 | 107 | ||
| 112 | $template->adds_block('COMMENTS', array( 'CODED' => $getpost3['slug'], | 108 | if (strpos($getcomments3[$i]['page_id'], 'updates') !== FALSE) |
| 113 | 'TITLE' => stripslashes($getpost3['title']), | 109 | { |
| 114 | 'AUTHOR' => (($website != '') ? '<A HREF="http://' . $website . '">' . $username . '</A>' : $username))); | 110 | $getpost = "SELECT * FROM updates WHERE id = " . substr($getcomments3[$i]['page_id'],strpos($getcomments3[$i]['page_id'],'-')+1); |
| 115 | $i++; | 111 | $getpost2 = mysql_query($getpost); |
| 112 | $getpost3 = mysql_fetch_array($getpost2); | ||
| 113 | |||
| 114 | $template->adds_block('COMMENTS', array( 'AREA' => 'blog', | ||
| 115 | 'CODED' => $getpost3['slug'], | ||
| 116 | 'ENDING' => '/', | ||
| 117 | 'TITLE' => stripslashes($getpost3['title']), | ||
| 118 | 'AUTHOR' => (($website != '') ? '<A HREF="http://' . $website . '">' . $username . '</A>' : $username))); | ||
| 119 | $i++; | ||
| 120 | } else if (strpos($getcomments3[$i]['page_id'], 'quote') !== FALSE) | ||
| 121 | { | ||
| 122 | $num = substr($getcomments3[$i]['page_id'],strpos($getcomments3[$i]['page_id'],'-')+1); | ||
| 123 | |||
| 124 | $template->adds_block('COMMENTS', array( 'AREA' => 'quotes', | ||
| 125 | 'CODED' => $num, | ||
| 126 | 'ENDING' => '.php', | ||
| 127 | 'TITLE' => 'Quote #' . $num, | ||
| 128 | 'AUTHOR' => (($website != '') ? '<A HREF="http://' . $website . '">' . $username . '</A>' : $username))); | ||
| 129 | $i++; | ||
| 130 | } | ||
| 116 | } | 131 | } |
| 117 | 132 | ||
| 118 | $getusers = "SELECT DISTINCT username FROM comments"; | 133 | $getusers = "SELECT DISTINCT username FROM comments"; |
| diff --git a/pages/quotes.php b/pages/quotes.php index e6eb9f6..f208f70 100755 --- a/pages/quotes.php +++ b/pages/quotes.php | |||
| @@ -161,7 +161,9 @@ if (!isset($_GET['act'])) | |||
| 161 | { | 161 | { |
| 162 | $query = "SELECT id, quote, rating, flag FROM rash_quotes WHERE id = " . $_GET['act']; | 162 | $query = "SELECT id, quote, rating, flag FROM rash_quotes WHERE id = " . $_GET['act']; |
| 163 | quote_generation($query, "#" . $_GET['act'], -1); | 163 | quote_generation($query, "#" . $_GET['act'], -1); |
| 164 | |||
| 164 | $page_id = 'quote-' . $_GET['act']; | 165 | $page_id = 'quote-' . $_GET['act']; |
| 166 | include('includes/comments.php'); | ||
| 165 | } else { | 167 | } else { |
| 166 | generateError('404'); | 168 | generateError('404'); |
| 167 | } | 169 | } |
| diff --git a/theme/footer.tpl b/theme/footer.tpl index 220e0f7..fdf62ad 100755 --- a/theme/footer.tpl +++ b/theme/footer.tpl | |||
| @@ -110,7 +110,7 @@ | |||
| 110 | <P> | 110 | <P> |
| 111 | <UL> | 111 | <UL> |
| 112 | <!--BEGIN COMMENTS--> | 112 | <!--BEGIN COMMENTS--> |
| 113 | <LI STYLE="font-size: 0.9em"><!--COMMENTS.AUTHOR--> on <A HREF="/blog/<!--COMMENTS.CODED-->/"><!--COMMENTS.TITLE--></A></LI> | 113 | <LI STYLE="font-size: 0.9em"><!--COMMENTS.AUTHOR--> on <A HREF="/<!--COMMENTS.AREA-->/<!--COMMENTS.CODED--><!--COMMENTS.ENDING-->"><!--COMMENTS.TITLE--></A></LI> |
| 114 | <!--END COMMENTS--> | 114 | <!--END COMMENTS--> |
| 115 | </UL> | 115 | </UL> |
| 116 | </P> | 116 | </P> |
