adds_block('EXTERNAL',array('exi'=>1)); $curID = 0; $getpost = "SELECT * FROM updates ORDER BY id DESC LIMIT 0,4"; $getpost2 = mysql_query($getpost); while ($getpost3 = mysql_fetch_array($getpost2)) { updatePop($getpost3['id'],'home_views'); $page_id = 'updates-' . $getpost3['id']; $getcomments = "SELECT * FROM comments WHERE page_id = \"" . $page_id . "\" ORDER BY posttime"; $getcomments2 = mysql_query($getcomments); $total_post=0; while ($getcomments3[$total_post] = mysql_fetch_array($getcomments2)) { $total_post++; } if ($total_post >= 2) { $plural = 's'; } if ($total_post == 0) { $comText = 'No Comments'; } elseif ($total_post == 1) { $comText = '1 Comment'; } else { $comText = $total_post . ' Comments'; } $template->add_ref($curID, 'POST', array( 'ID' => $getpost3['id'], 'YEARID' => ((date('Y',strtotime($getpost3['pubDate']))-2006) % 4), 'DATE' => date('F dS Y \a\\t g:i:s a',strtotime($getpost3['pubDate'])), 'MONTH' => date('M',strtotime($getpost3['pubDate'])), 'DAY' => date('d',strtotime($getpost3['pubDate'])), 'CODED' => $getpost3['slug'], 'TITLE' => $getpost3['title'], 'AUTHOR' => $getpost3['author'], 'PLURALCOMMENT' => (isset($plural) ? $plural : ''), 'COMMENTS' => $comText, 'RATING' => $getpost3['rating'], 'TEXT' => parseText($getpost3['text']))); $tags = getTags($getpost3['id']); foreach ($tags as $tag) { $template->adds_ref_sub($curID, 'TAGS', array('TAG' => $tag)); } $curID++; } $template->display(); ?> m>

path: root/admin/editQuote.php

blob: b250ece52e83992e6d468e660604c1d81d67fba0 (plain) (blame)