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

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

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

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



--- NEW FILE: mod_blogrolling2.inc.php ---
<?php
function mod_blogrolling2_details ($item_id) {
   $query = "select * from ".CFG_MYSQL_TABPREFIX."mod_blogrolling2 where blogrolling2_id = '".$item_id."'";
   $res = mysql_query($query);
   
   if (!$res || !mysql_num_rows($res))
      return (false);
      
   $item = mysql_fetch_assoc($res);
   
   return ($item);
}  


function mod_blogrolling2_list () {
   $query = "
               select   b.*
               from     ".CFG_MYSQL_TABPREFIX."mod_blogrolling2 b
               order by b.blogrolling2_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_blogrolling2_add ($item) {
   
   $query = "select max(blogrolling2_display_order)+1 from ".CFG_MYSQL_TABPREFIX."mod_blogrolling2";
   $res = mysql_query($query);
   $item['blogrolling2_display_order'] = mysql_result($res,0,0);
   
   $item['blogrolling2_added'] = time();
   
   $query = "
               insert into    ".CFG_MYSQL_TABPREFIX."mod_blogrolling2
               (blogrolling2_url, blogrolling2_title, blogrolling2_description, blogrolling2_display_order, blogrolling2_added)
               values        ('".   $item['blogrolling2_url']          ."',
                              '".   $item['blogrolling2_title']        ."',
                              '".   $item['blogrolling2_description']  ."',
                              '".   $item['blogrolling2_display_order']."',
                              '".   $item['blogrolling2_added']        ."')
   ";
   $res = mysql_query($query);
   
   if (!$res)
      return (false);
      
   $item['id'] = mysql_insert_id();
   
   return ($item);
}

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

function mod_blogrolling2_edit ($item) {
   $query = "
               update   ".CFG_MYSQL_TABPREFIX."mod_blogrolling2
               set
                        blogrolling2_url           = '".  $item['blogrolling2_url']          ."',
                        blogrolling2_title         = '".  $item['blogrolling2_title']        ."',
                        blogrolling2_description   = '".  $item['blogrolling2_description']  ."',
                        blogrolling2_display_order = '".  $item['blogrolling2_display_order']."'
               where
                        blogrolling2_id            = '".  $item['blogrolling2_id']           ."'
   ";
   $res = mysql_query($query);
   
   if (!$res)
      return (false);
      
   return ($item);
}

function mod_blogrolling2_up ($item_id) {

}

function mod_blogrolling2_down ($item_id) {

}
?>