[Comoblog-commit] comoblog/modules/mod_showpage/include mod_showpage.inc.php, NONE, 1.1

[iamdecal <iam...@us...>]

Update of /cvsroot/comoblog/comoblog/modules/mod_showpage/include
In directory sc8-pr-cvs4.sourceforge.net:/tmp/cvs-serv27709/modules/mod_showpage/include

Added Files:
	mod_showpage.inc.php 
Log Message:
work in progress, ditching this server cos its borked ;(



--- NEW FILE: mod_showpage.inc.php ---
<?php  

function mod_showpage_details_from_text ($item_text) {
   $query = "select * from ".CFG_MYSQL_TABPREFIX."mod_showpage where showpage_nav_text = '".$item_text."'";
   $res = mysql_query($query);
   
   if (!$res || !mysql_num_rows($res))
      return (false);
      
   $item = mysql_fetch_assoc($res);
   
   return ($item);
}  
 




function mod_showpage_details ($item_id) {
   $query = "select * from ".CFG_MYSQL_TABPREFIX."mod_showpage where showpage_id = '".$item_id."'";
   $res = mysql_query($query);
   
   if (!$res || !mysql_num_rows($res))
      return (false);
      
   $item = mysql_fetch_assoc($res);
   
   return ($item);
}  
 



function mod_showpage_adminlist () {
  
   $query = "
               select   b.*
               from     ".CFG_MYSQL_TABPREFIX."mod_showpage b
               order by b.showpage_display_order
   "; 
   $res = mysql_query($query);
   
   if (!$res || !mysql_num_rows($res))
      return (false);

   $items = array();
   while ($row = mysql_fetch_assoc($res)) {
      $items[] = $row;
   }
   return ($items);
}


function mod_showpage_list () {

   $query = "
               select   b.*
               from     ".CFG_MYSQL_TABPREFIX."mod_showpage b
               where showpage_visible ='Y'
               order by b.showpage_display_order"; 
  #echo $query;
   $res = mysql_query($query);
   
   if (!$res || !mysql_num_rows($res))
      return (false);

   $items = array();
   while ($row = mysql_fetch_assoc($res)) {
      $items[] = $row;
   }
   return ($items);
}

function mod_showpage_add ($item) {
   
   $query = "select max(showpage_display_order)+1 from ".CFG_MYSQL_TABPREFIX."mod_showpage";
   $res = mysql_query($query);
   $item['showpage_display_order'] = mysql_result($res,0,0);
   
   $item['showpage_added'] = time();
   
   $query = "
               insert into    ".CFG_MYSQL_TABPREFIX."mod_showpage
               (showpage_title,showpage_description ,showpage_headcode,showpage_bodytag,showpage_nav_text,showpage_nav_link,showpage_nav_link2,showpage_nav_image,showpage_nav_class ,showpage_visible ,showpage_meta ,showpage_url ,showpage_added ,showpage_display_order,showpage_parent_id)
               values        ('".   $item['showpage_title']          ."',
                              '".   $item['showpage_description']        ."',
                              '".   $item['showpage_headcode']  ."',
                              '".   $item['showpage_bodytag']."', 
                              '".   $item['showpage_nav_text']."', 
                              '".   $item['showpage_nav_link']."',
                              '".   $item['showpage_nav_link2']."',                                                                
                              '".   $item['showpage_nav_image']."',
                              '".   $item['showpage_nav_class']."',
                              '".   $item['showpage_visible']."',
                              '".   $item['showpage_meta']."',
                              '".   $item['showpage_url']."',
                              '".   $item['showpage_added']."',
                              '".   $item['showpage_display_order']."',
                              '".   $item['showpage_parent_id']        ."')
   ";
   $res = mysql_query($query);
   
   if (!$res)
      return (false);
      
   $item['id'] = mysql_insert_id();
   
   return ($item);
}

function mod_showpage_del ($item_id) {
   $query = "delete from ".CFG_MYSQL_TABPREFIX."mod_showpage where showpage_id = '".$item_id."'";
   $res = mysql_query($query);
   
   if (!$res)
      return (false);
      
   return (true);
}

function mod_showpage_edit ($item) {
   $query = "update ".CFG_MYSQL_TABPREFIX."mod_showpage set
showpage_title='".   $item['showpage_title']          ."',
showpage_description='".   $item['showpage_description']        ."',
showpage_headcode='".   $item['showpage_headcode']  ."',
showpage_bodytag='".   $item['showpage_bodytag']."', 
showpage_nav_text='".   $item['showpage_nav_text']."',
showpage_nav_link='".   $item['showpage_nav_link']."',
showpage_nav_link2='".   $item['showpage_nav_link2']."',
showpage_nav_image='".   $item['showpage_nav_image']."',
showpage_nav_class= '".   $item['showpage_nav_class']."',
showpage_visible='".   $item['showpage_visible']."',
showpage_meta='".   $item['showpage_meta']."',
showpage_url='".   $item['showpage_url']."',
showpage_added=  '".   $item['showpage_added']."',
showpage_display_order=  '".   $item['showpage_display_order']."',
showpage_parent_id= '".   $item['showpage_parent_id']        ."'
where showpage_id = '".  $item['showpage_id']  ."'";
define_syslog_variables();
openlog("TextLog", LOG_PID, LOG_LOCAL0);

$data = date("Y/m/d H:i:s");
syslog(LOG_DEBUG,"Messagge: $query");

closelog();

   $res = mysql_query($query);
   
   if (!$res)
      return (false);
      
   return ($item);
}

function mod_showpage_up ($item_id) {

}

function mod_showpage_down ($item_id) {

}
?>