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

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

Update of /cvsroot/comoblog/modules/mod_blogrolling/include
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11362/mod_blogrolling/include

Added Files:
	mod_blogrolling.inc.php 
Log Message:
wasnt in cvs so ive added it to fix a bug raised on the forums, -  also added some of  the stuff thats in use on my site

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


function mod_blogrolling_list () {
   $query = "
               select   b.*
               from     ".CFG_MYSQL_TABPREFIX."mod_blogrolling b
               where blogrolling_url <> ''
		order by b.blogrolling_display_order
   ";
   $res = mysql_query($query);
   
   if (!$res || !mysql_num_rows($res))
      return (false);

   $items = array();
   while ($row = mysql_fetch_assoc($res)) 
      {
	$row['blogrolling_title'] = str_replace("."," ",$row['blogrolling_title'])  ;
      $items[] = $row;
   }
   return ($items);
}

function mod_blogrolling_add ($item) {
   
   $query = "select max(blogrolling_display_order)+1 from ".CFG_MYSQL_TABPREFIX."mod_blogrolling";
   $res = mysql_query($query);
   $item['blogrolling_display_order'] = mysql_result($res,0,0);
   
   $item['blogrolling_added'] = time();
   
   $query = "
               insert into    ".CFG_MYSQL_TABPREFIX."mod_blogrolling
               (blogrolling_url, blogrolling_title, blogrolling_description, blogrolling_display_order, blogrolling_added)
               values        ('".   $item['blogrolling_url']          ."',
                              '".   $item['blogrolling_title']        ."',
                              '".   $item['blogrolling_description']  ."',
                              '".   $item['blogrolling_display_order']."',
                              '".   $item['blogrolling_added']        ."')
   ";
   $res = mysql_query($query);
   
   if (!$res)
      return (false);
      
   $item['id'] = mysql_insert_id();
   
   return ($item);
}

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

function mod_blogrolling_edit ($item) {
   $query = "
               update   ".CFG_MYSQL_TABPREFIX."mod_blogrolling
               set
                        blogrolling_url           = '".  $item['blogrolling_url']          ."',
                        blogrolling_title         = '".  $item['blogrolling_title']        ."',
                        blogrolling_description   = '".  $item['blogrolling_description']  ."',
                        blogrolling_display_order = '".  $item['blogrolling_display_order']."'
               where
                        blogrolling_id            = '".  $item['blogrolling_id']           ."'
   ";
   $res = mysql_query($query);
   
   if (!$res)
      return (false);
      
   return ($item);
}

function mod_blogrolling_up ($item_id) {

}

function mod_blogrolling_down ($item_id) {

}
?>