Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?PHP
- class content {
- var $userid;
- var $id;
- var $pid;
- var $cid;
- var $title;
- var $content;
- var $dateposted;
- var $votes;
- var $status;
- // Convert category id to category name.
- function convertCatName($id) {
- $query = "select * from `category` where `id` = ".$id."";
- $result = mysql_query($query);
- $catname = mysql_fetch_object($result);
- return $catname->title;
- }
- // Convert user id to username.
- function convertUserName($id) {
- $query = "select * from `user` where `id` = ".$id."";
- $result = mysql_query($query);
- $usrname = mysql_fetch_object($result);
- return $usrname->username;
- }
- // Count the number of rows in a table, with modifier.
- function countRows($table, $field = 'none', $modify = 'none') {
- if($modify == 'none' || $field == 'none') {
- $query = "select * from `".$table."`";
- }
- else {
- $query = "select * from `".$table."` where `".$field."` = ".$modify."";
- }
- $count = mysql_num_rows(mysql_query($query));
- return $count;
- }
- // Get category list
- function getCategoryList($location) {
- $query = "select * from `category`";
- $result = mysql_query($query);
- if($location == "Home") {
- $output = "<h3>Jump to category...</h3>\n";
- }
- if($location == "Menu") {
- $output = "<h3>Category List</h3>\r";
- }
- $output .= " <ul class=\"catlist\">\r";
- while ($row = mysql_fetch_object($result)) {
- if($location == "Home") {
- $output .= " <li><a href=\"viewideas.php?cat=".$row->id."\" class=\"cat\">".$row->title."</a><br />
- Pages: ".$this->countRows('posts', 'cid', $row->id)."</li>\r";
- }
- if($location == "Menu") {
- $output .= " <li><a href=\"javascript:;\" class=\"cat\" onclick=\"showCat(".$row->id.")\">".$row->title."</a><br />
- Pages: ".$this->countRows('posts', 'cid', $row->id)."</li>\r";
- }
- }
- $output .= " </ul>\r";
- echo $output;
- }
- function getData($table='posts', $field=1, $modify='=1', $limitx=3) {
- if (isset($_GET['pageno'])) {
- $pageno = $_GET['pageno'];
- }
- else {
- $pageno = 1;
- }
- $query = "SELECT count(*) FROM ".$table." WHERE ".$field." ".$modify."";
- $result = mysql_query($query) or trigger_error("SQL", E_USER_ERROR);
- $query_data = mysql_fetch_row($result);
- $numrows = $query_data[0];
- $rows_per_page = $limitx;
- $lastpage = ceil($numrows/$rows_per_page);
- $pageno = (int)$pageno;
- if ($pageno > $lastpage) {
- $pageno = $lastpage;
- }
- if ($pageno < 1) {
- $pageno = 1;
- }
- $limit = 'LIMIT ' .($pageno - 1) * $rows_per_page .',' .$rows_per_page;
- $query2 = "SELECT * FROM ".$table." WHERE ".$field." ".$modify." $limit";
- $result2 = mysql_query($query2) or trigger_error("SQL", E_USER_ERROR);
- while ($row = mysql_fetch_object($result2)) {
- echo "<div class=\"recentlist\">\n";
- echo "<div style=\"padding: 10px;\"><a href=\"viewideas.php?id=".$row->id."\" class=\"post\">".$row->title."</a><br />\n";
- echo "Posted by <a href=\"view.php?id=".$row->pid."\" rel=\"facebox\">".$this->convertUserName($row->pid)."</a> on ".$row->dateposted."<br />\n";
- echo "Category - <strong>".$this->convertCatName($row->cid)."</strong><br /><br />\n";
- echo truncate($row->content, 100)."</div>\n";
- echo "<div class=\"menubar\"><img src=\"images/viewpost.png\" alt=\"View Post\" /> View Idea <img src=\"images/commentpost.png\" alt=\"Comment Post\" /> Comment on Idea</div>\n";
- echo "</div>\n";
- }
- echo "<div class=\"recentlist\">\n";
- echo "<span style=\"display: block; margin-right: 90px; float: left; width: 80px;\">\n";
- if ($pageno == 1) {
- echo " FIRST PREV ";
- } else {
- echo " <a href='{$_SERVER['PHP_SELF']}?pageno=1'>FIRST</a> ";
- $prevpage = $pageno-1;
- echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$prevpage'>PREV</a> ";
- } // if
- echo "</span>\n";
- echo "<span style=\"display: block; margin-right: 90px; float: left; width: 120px;\">\n";
- echo " ( Page $pageno of $lastpage ) ";
- echo "</span>\n";
- echo "<span style=\"display: block; float: left; width: 80px;\">\n";
- if ($pageno == $lastpage) {
- echo " NEXT LAST ";
- } else {
- $nextpage = $pageno+1;
- echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$nextpage'>NEXT</a> ";
- echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$lastpage'>LAST</a> ";
- } // if
- echo "</span>\n";
- echo "<span style=\"display: block; clear: both;\"></span>\n";
- echo "</div>\n";
- }
- }
- ?>
Add Comment
Please, Sign In to add comment