[Comoblog-commit] comoblog/modules/mod_showpage/include mod_showpage.inc.php, NONE, 1.1
Status: Inactive
Brought to you by:
markwallis
|
From: iamdecal <iam...@us...> - 2006-10-22 11:44:25
|
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) { } ?> |