[Comoblog-commit] modules/mod_fortune_db/include mod_fortune_db.inc.php,1.2,1.3

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

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

Modified Files:
	mod_fortune_db.inc.php 
Log Message:
I've added the admin sections for this, it can be seen working in the top bar
of http://www.iamdecal.co.uk so it just needs some peer review before release

iamdecal
2006-02-16

 ----------------------------------------------------------------------
 Enter Log.  Lines beginning with `CVS:' are removed automatically
 
Committing in .
 
 Modified Files:
	index.php mod_fortune_db.php css/mod_fortune_db.css.php 
 	img/mod_fortune_db.gif img/mod_fortune_db_big.gif 
 	include/mod_fortune_db.inc.php install/mod_fortune_db.xml 
 	templates/sidebar/mod_fortune_db.tpl.htm 
 	templates/top/mod_fortune_db.tpl.htm 
 ----------------------------------------------------------------------


Index: mod_fortune_db.inc.php
===================================================================
RCS file: /cvsroot/comoblog/modules/mod_fortune_db/include/mod_fortune_db.inc.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- mod_fortune_db.inc.php	2 Feb 2006 10:37:50 -0000	1.2
+++ mod_fortune_db.inc.php	16 Feb 2006 14:22:19 -0000	1.3
@@ -1,20 +1,106 @@
-<?php
- 
-function mod_fortune_db() 
- {
- $query = "select fortune_db_id, fortune_db_content from  ".CFG_MYSQL_TABPREFIX."mod_fortune_db order by rand()  limit 1 ";
- $res = mysql_query($query);
-	$error= "error no " .  mysql_errno() . " : error " . mysql_error(). " :  rows" . mysql_num_rows($res) . ": query " .$query ;
-	error_log($error,0);
- $items = array();
- 
- while ($row = mysql_fetch_assoc($res)) 
- { 
- $query = "update ".CFG_MYSQL_TABPREFIX."mod_fortune_db set fortune_db_display_count = (fortune_db_display_count +1) where fortune_db_id =". addslashes( $row['fortune_db_id']).";" ;
- $res = mysql_query($query);
- $row['mod_fortune_db_title'] = CFG_MOD_FORTUNE_DB_TITLE;
- $items[] = $row;
- }
- return ($items);
- }
-?>
+<?php
+ 
+function mod_fortune_db() 
+ {
+ $query = "select fortune_db_id, fortune_db_content from  ".CFG_MYSQL_TABPREFIX."mod_fortune_db order by rand()  limit 1 ";
+ $res = mysql_query($query);
+ $query = "update ".CFG_MYSQL_TABPREFIX."mod_fortune_db set fortune_db_display_count = (fortune_db_display_count +1) where fortune_db_id =". addslashes(mysql_result($res, 0,0)) ;
+ $res2 = mysql_query($query);
+ return mysql_result($res, 0,1);
+ }
+
+ 
+ 
+ 
+function mod_fortune_db_details ($item_id) {
+   $query = "select * from ".CFG_MYSQL_TABPREFIX."mod_fortune_db where fortune_db_id = '".$item_id."'";
+   $res = mysql_query($query);
+   
+   if (!$res || !mysql_num_rows($res))
+      return (false);
+      
+   $item = mysql_fetch_assoc($res);
+   
+   return ($item);
+}  
+
+
+function mod_fortune_db_list () {
+   $query = "
+               select   b.*
+               from     ".CFG_MYSQL_TABPREFIX."mod_fortune_db b
+               order by b.fortune_db_content
+   ";
+   $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_fortune_db_add ($item) {
+   
+   $query = "select max(fortune_db_display_order)+1 from ".CFG_MYSQL_TABPREFIX."mod_fortune_db";
+   $res = mysql_query($query);
+   $item['fortune_db_display_order'] = mysql_result($res,0,0);
+   
+   $item['fortune_db_added'] = time();
+   
+   $query = "
+               insert into    ".CFG_MYSQL_TABPREFIX."mod_fortune_db
+               ( fortune_db_content, fortune_db_display_count, fortune_db_display_order, fortune_db_added)
+               values        ('".   $item['fortune_db_content']        ."',
+                              '".   $item['fortune_db_display_count']  ."',
+                              '".   $item['fortune_db_display_order']."',
+                              '".   $item['fortune_db_added']        ."')
+   ";
+   $res = mysql_query($query);
+   
+   if (!$res)
+      return (false);
+      
+   $item['id'] = mysql_insert_id();
+   
+   return ($item);
+}
+
+function mod_fortune_db_del ($item_id) {
+   $query = "delete from ".CFG_MYSQL_TABPREFIX."mod_fortune_db where fortune_db_id = '".$item_id."'";
+   $res = mysql_query($query);
+   
+   if (!$res)
+      return (false);
+      
+   return (true);
+}
+
+function mod_fortune_db_edit ($item) {
+   $query = "
+               update   ".CFG_MYSQL_TABPREFIX."mod_fortune_db
+               set        fortune_db_content         = '".    $item['fortune_db_content']        ."',
+                        fortune_db_display_count   = '".  $item['fortune_db_display_count']  ."',
+                        fortune_db_display_order = '".  $item['fortune_db_display_order']."'
+               where
+                        fortune_db_id            = '".  $item['fortune_db_id']           ."'
+   ";
+   $res = mysql_query($query);
+   
+   if (!$res)
+      return (false);
+      
+   return ($item);
+}
+
+function mod_fortune_db_up ($item_id) {
+
+}
+
+function mod_fortune_db_down ($item_id) {
+
+}