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

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

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

Added Files:
	mod_fortune_db.inc.php 
Log Message:
like mod fortune, but i wanted a db based one - 
warning slight bug in this commit.

will fix in the next 24 hours
.



--- NEW FILE: mod_fortune_db.inc.php ---
<?php
 
function mod_fortune_db() 
 {
 if (CFG_USE_PATH_INFO == 'no')
    $iisbug = '?';
 else
    $iisbug = '';
 
 
 $query = "
    select 
       *
    from 
        ".CFG_MYSQL_TABPREFIX."mod_fortune_db
        order by rand() 
    limit 1 ";
 $res = mysql_query($query);
 if (!$res || !mysql_num_rows($res)){
	 echo "<hr>\n" . mysql_errno() . ": " . mysql_error(). ":" . mysql_num_rows($res) . ":" .$query . "<hr>\n";
    
	 exit;
	 return (false);
 }
 $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);
 #if (!$res || !mysql_num_rows($res)){
 #	echo "<hr>\n" . mysql_errno() . ": " . mysql_error(). ":" . mysql_num_rows($res) . ":" .$query . "<hr>\n";
 #}
 $row['mod_fortune_db_title'] = CFG_MOD_FORTUNE_DB_TITLE;
 
 $items[] = $row;
 }
 return ($items);
 }
?>