function editcat($showmenu = false, $categoryid = 0, $nb_subcats = 4, $categoryObj = null)
{
global $xoopsDB, $smartsection_category_handler, $xoopsUser, $myts, $xoopsConfig, $xoopsModuleConfig, $xoopsModule;
include_once XOOPS_ROOT_PATH . '/modules/smartsection/class/form-editcategory.php';
// if there is a parameter, and the id exists, retrieve data: we're editing a category
if ($categoryid != 0) {
// Creating the category object for the selected category
$categoryObj = $smartsection_category_handler->get($categoryid);
if ($categoryObj->notLoaded()) {
redirect_header("category.php", 1, _AM_SSECTION_NOCOLTOEDIT);
exit;
}
} else {
if (!$categoryObj) {
$categoryObj = $smartsection_category_handler->create();
}
}
if ($categoryid != 0) {
if ($showmenu) {
smartsection_adminMenu(1, _AM_SSECTION_CATEGORIES . " > " . _AM_SSECTION_EDITING);
}
echo "<br />\n";
smartsection_collapsableBar('edittable', 'edittableicon', _AM_SSECTION_EDITCOL, _AM_SSECTION_CATEGORY_EDIT_INFO);
} else {
if ($showmenu) {
smartsection_adminMenu(1, _AM_SSECTION_CATEGORIES . " > " . _AM_SSECTION_CREATINGNEW);
}
//echo "<br />\n";
smartsection_collapsableBar('createtable', 'createtableicon', _AM_SSECTION_CATEGORY_CREATE, _AM_SSECTION_CATEGORY_CREATE_INFO);
}
$sform =& new SmartsectionForm_EditCategory($categoryObj, $nb_subcats);
if (!$categoryid) {
$sform->display();
smartsection_close_collapsable('createtable', 'createtableicon');
} else {
$sform->display();
smartsection_close_collapsable('edittable', 'edittableicon');
}
//Added by fx2024
if ($categoryid) {
include_once XOOPS_ROOT_PATH . "/modules/smartsection/include/displaysubcats.php";
include_once XOOPS_ROOT_PATH . "/modules/smartsection/include/displayitems.php";
}
//end of fx2024 code
}
echo "<br />";
if ($error == true) {
$endMsg = _AM_SSECTION_IMPORT_ERROR;
} else {
$endMsg = _AM_SSECTION_IMPORT_SUCCESS;
}
echo $endMsg;
echo "<br /><br />";
echo "<a href='import.php'>" . _AM_SSECTION_IMPORT_BACK . "</a>";
echo "<br /><br />";
break;
case "default":
default:
$importfile = 'none';
smartsection_xoops_cp_header();
smartsection_adminMenu(-1, _AM_SSECTION_IMPORT);
smartsection_collapsableBar('import', 'importicon', _AM_SSECTION_IMPORT_TITLE, _AM_SSECTION_IMPORT_INFO);
include_once XOOPS_ROOT_PATH . '/class/xoopsformloader.php';
$module_handler =& xoops_gethandler('module');
// WF-Section
$moduleObj = $module_handler->getByDirname('wfsection');
if ($moduleObj) {
$from_module_version = round($moduleObj->getVar('version') / 100, 2);
if ($from_module_version == 1.5 || $from_module_version == 1.04 || $from_module_version == 1.01 || $from_module_version == 2.07 || $from_module_version == 2.06) {
$importfile_select_array["wfsection"] = "WF-Section " . $from_module_version;
$wfs_version = $from_module_version;
}
}
// News
$moduleObj = $module_handler->getByDirname('news');
if ($moduleObj) {
echo "<td width='40px' class='bg3' align='center'><b>" . _AM_SSECTION_ITEMID . "</b></td>";
echo "<td width='100px' class='bg3' align='center'><b>" . _AM_SSECTION_ITEMCAT . "</b></td>";
echo "<td class='bg3' align='center'><b>" . _AM_SSECTION_TITLE . "</b></td>";
echo "<td width='90px' class='bg3' align='center'><b>" . _AM_SSECTION_CREATED . "</b></td>";
echo "<td width='90px' class='bg3' align='center'><b>" . _AM_SSECTION_STATUS . "</b></td>";
echo "<td width='90px' class='bg3' align='center'><b>" . _AM_SSECTION_ACTION . "</b></td>";
echo "</tr>";
}
// Code for the page
include_once XOOPS_ROOT_PATH . "/class/xoopslists.php";
include_once XOOPS_ROOT_PATH . '/class/pagenav.php';
global $smartsection_category_handler, $smartsection_item_handler;
$startentry = isset($_GET['startentry']) ? intval($_GET['startentry']) : 0;
smartsection_xoops_cp_header();
global $xoopsUser, $xoopsConfig, $xoopsModuleConfig, $xoopsModule;
smartsection_adminMenu(0, _AM_SSECTION_INDEX);
// Total ITEMs -- includes everything on the table
$totalitems = $smartsection_item_handler->getItemsCount();
// Total categories
$totalcategories = $smartsection_category_handler->getCategoriesCount(-1);
// Total submitted ITEMs
$totalsubmitted = $smartsection_item_handler->getItemsCount(-1, array(_SSECTION_STATUS_SUBMITTED));
// Total published ITEMs
$totalpublished = $smartsection_item_handler->getItemsCount(-1, array(_SSECTION_STATUS_PUBLISHED));
// Total offline ITEMs
$totaloffline = $smartsection_item_handler->getItemsCount(-1, array(_SSECTION_STATUS_OFFLINE));
// Total rejected
$totalrejected = $smartsection_item_handler->getItemsCount(-1, array(_SSECTION_STATUS_REJECTED));
// Check Path Configuration
if (smartsection_admin_getPathStatus('root', true) < 0 || smartsection_admin_getPathStatus('images', true) < 0 || smartsection_admin_getPathStatus('images/category', true) < 0 || smartsection_admin_getPathStatus('images/item', true) < 0 || smartsection_admin_getPathStatus('content', true) < 0) {
createDir();
foreach (array_keys($block_arr) as $i) {
$item_list[$block_arr[$i]->getVar("bid")] = $block_arr[$i]->getVar("title");
}
$form = new MyXoopsGroupPermForm(_MD_AM_ADGS, 1, 'block_read', '');
if ($target_mid > 1) {
$form->addAppendix('module_admin', $target_mid, $target_mname . ' ' . _AM_ACTIVERIGHTS);
$form->addAppendix('module_read', $target_mid, $target_mname . ' ' . _AM_ACCESSRIGHTS);
}
foreach ($item_list as $item_id => $item_name) {
$form->addItem($item_id, $item_name);
}
echo $form->render();
smartsection_close_collapsable('groupstable', 'groupsicon');
}
if (!empty($_POST['submit'])) {
if (!$xoopsGTicket->check(true, 'myblocksadmin')) {
redirect_header(XOOPS_URL . '/', 3, $xoopsGTicket->getErrors());
}
include "mygroupperm.php";
redirect_header(XOOPS_URL . "/modules/" . $xoopsModule->dirname() . "/admin/myblocksadmin.php{$query4redirect}", 1, _MD_AM_DBUPDATED);
}
smartsection_xoops_cp_header();
if (file_exists('./mymenu.php')) {
include './mymenu.php';
}
smartsection_adminMenu(4, _AM_SSECTION_BLOCKSANDGROUPS);
if (!empty($block_arr)) {
list_blocks();
}
list_groups();
xoops_cp_footer();
* Author: The SmartFactory <www.smartfactory.ca>
* Licence: GNU
*/
include_once "admin_header.php";
include_once XOOPS_ROOT_PATH . '/class/xoopsform/grouppermform.php';
if (!$smartsection_isAdmin) {
redirect_header("javascript:history.go(-1)", 1, _NOPERM);
exit;
}
$op = '';
switch ($op) {
case "default":
default:
global $xoopsDB, $xoopsModule;
smartsection_xoops_cp_header();
smartsection_adminMenu(3, _AM_SSECTION_PERMISSIONS);
// View Categories permissions
$item_list_view = array();
$block_view = array();
smartsection_collapsableBar('permissionstable', 'permissionsicon', _AM_SSECTION_PERMISSIONSVIEWMAN, _AM_SSECTION_VIEW_CATS);
$result_view = $xoopsDB->query("SELECT categoryid, name FROM " . $xoopsDB->prefix("smartsection_categories") . " ");
if ($xoopsDB->getRowsNum($result_view)) {
while ($myrow_view = $xoopsDB->fetcharray($result_view)) {
$item_list_view['cid'] = $myrow_view['categoryid'];
$item_list_view['title'] = $myrow_view['name'];
$form_view = new XoopsGroupPermForm("", $xoopsModule->getVar('mid'), "category_read", "");
$block_view[] = $item_list_view;
foreach ($block_view as $itemlists) {
$form_view->addItem($itemlists['cid'], $myts->displayTarea($itemlists['title']));
}
}
}
switch ($op) {
case 'replacepermissions':
$categoriesObj = $smartsection_category_handler->getObjects();
$groups_read = isset($_POST['groups_read']) ? $_POST['groups_read'] : array();
foreach ($categoriesObj as $categoryObj) {
smartsection_saveCategory_Permissions($groups_read, $categoryObj->categoryid(), 'category_read');
smartsection_overrideItemsPermissions($groups_read, $categoryObj->categoryid());
}
redirect_header("index.php", 3, _AM_SSECTION_PERMISSIONS_UPDATED);
exit;
break;
case "default":
default:
smartsection_xoops_cp_header();
smartsection_adminMenu(-1, _AM_SSECTION_TOOLS);
smartsection_collapsableBar('tools1', 'tools1icon', _AM_SSECTION_CONFIGURE_READ_PERMISSIONS, _AM_SSECTION_CONFIGURE_READ_PERMISSIONS_EXP);
include_once XOOPS_ROOT_PATH . "/class/xoopsformloader.php";
$sform = new XoopsThemeForm(_AM_SSECTION_FULLACCESS, "form", xoops_getenv('PHP_SELF'));
$sform->setExtra('enctype="multipart/form-data"');
// READ PERMISSIONS
$groups_read_checkbox = new XoopsFormCheckBox(_AM_SSECTION_PERMISSIONS_CAT_READ, 'groups_read[]');
$member_handler =& xoops_gethandler('member');
foreach ($member_handler->getGroupList() as $group_id => $group_name) {
if ($group_id != XOOPS_GROUP_ADMIN) {
$groups_read_checkbox->addOption($group_id, $group_name);
}
}
$sform->addElement($groups_read_checkbox);
$button_tray = new XoopsFormElementTray('', '');
$button_tray->addElement(new XoopsFormButton('', 'replacepermissions', _AM_SSECTION_REPLACE_PERMISSIONS, 'submit'));
function upgradeDB()
{
global $xoopsModule, $dbupdater;
$xoopsDB =& Database::getInstance();
//1. Determine previous release
// *** Update this in sql/mysql.sql for each release **
if (!smartsection_TableExists('smartsection_meta')) {
$ver = '0.93';
} else {
if (!($ver = smartsection_GetMeta('version'))) {
exit(_AM_SSECTION_DB_VERSION_ERR);
}
}
$mid = $xoopsModule->getVar('mid');
xoops_cp_header();
smartsection_adminMenu(-1, _AM_SSECTION_DB_UPDATE_DB);
echo "<h2>" . _AM_SSECTION_DB_UPDATE_DB . "</h2>";
$ret = true;
//2. Do All Upgrades necessary to make current
// Break statements are omitted on purpose
switch ($ver) {
/// SMARTSECTION 0.93 ////////////////////////////////////////////////
case '0.93':
set_time_limit(60);
printf("<h3>" . _AM_SSECTION_DB_UPDATE_TO . "</h3>", '1.0');
echo "<ul>";
// Create table smartsection_meta
$table = new SmartsectionTable('smartsection_meta');
$table->setStructure("CREATE TABLE %s (\n \t\t\t\t\t\tmetakey varchar(50) NOT NULL default '',\n \t\t\t\t\t\tmetavalue varchar(255) NOT NULL default '',\n \t\t\t\t\t\tPRIMARY KEY (metakey))\n \t\t\t\t\t\tTYPE=MyISAM;");
$table->setData(sprintf("'version', %s", $xoopsDB->quoteString($ver)));
$ret = $ret && $dbupdater->updateTable($table);
unset($table);
// Edit fields in smartsection_categories
$table = new SmartsectionTable('smartsection_categories');
$table->addAlteredField('categoryid', "`categoryid` INT( 11 ) NOT NULL AUTO_INCREMENT");
$table->addAlteredField('parentid', "`parentid` INT( 11 ) DEFAULT '0' NOT NULL");
$ret = $dbupdater->updateTable($table) && $ret;
unset($table);
// Edit fields in smartsection_items
$table = new SmartsectionTable('smartsection_items');
$table->addAlteredField('categoryid', "`categoryid` INT( 11 ) DEFAULT '0' NOT NULL");
$table->addAlteredField('itemid', "`itemid` INT( 11 ) NOT NULL AUTO_INCREMENT");
$ret = $dbupdater->updateTable($table) && $ret;
unset($table);
// Edit fields in smartsection_files
$table = new SmartsectionTable('smartsection_files');
$table->addAlteredField('itemid', "`itemid` INT( 11 ) DEFAULT '0' NOT NULL");
$table->addAlteredField('fileid', "`fileid` INT( 11 ) NOT NULL AUTO_INCREMENT");
$ret = $dbupdater->updateTable($table) && $ret;
unset($table);
echo "</ul>";
/// SMARTSECTION 1.0 ////////////////////////////////////////////////
/// SMARTSECTION 1.0 ////////////////////////////////////////////////
case '1.0':
set_time_limit(60);
printf("<h3>" . _AM_SSECTION_DB_UPDATE_TO . "</h3>", '1.01');
echo "<ul>";
// Edit fields in smartsection_items
$table = new SmartsectionTable('smartsection_items');
$table->addAlteredField('body', "`body` LONGTEXT NOT NULL");
$ret = $dbupdater->updateTable($table) && $ret;
unset($table);
echo "</ul>";
/// SMARTSECTION 1.0.1 ////////////////////////////////////////////////
/// SMARTSECTION 1.0.1 ////////////////////////////////////////////////
case '1.01':
set_time_limit(60);
printf("<h3>" . _AM_SSECTION_DB_UPDATE_TO . "</h3>", '1.02');
echo "<ul>";
// Create table smartsection_mimetypes
$table = new SmartsectionTable('smartsection_mimetypes');
$table->setStructure("CREATE TABLE %s (\n \t\t\t\t\t\t\t mime_id int(11) NOT NULL auto_increment,\n \t\t\t\t\t\t\t mime_ext varchar(60) NOT NULL default '',\n \t\t\t\t\t\t\t mime_types text NOT NULL,\n \t\t\t\t\t\t\t mime_name varchar(255) NOT NULL default '',\n \t\t\t\t\t\t\t mime_admin int(1) NOT NULL default '1',\n \t\t\t\t\t\t\t mime_user int(1) NOT NULL default '0',\n \t\t\t\t\t\t\t KEY mime_id (mime_id)\n \t\t\t\t\t\t\t ) TYPE=MyISAM;");
$table->setData("1, 'bin', 'application/octet-stream', 'Binary File/Linux Executable', 0, 0");
$table->setData("2, 'dms', 'application/octet-stream', 'Amiga DISKMASHER Compressed Archive', 0, 0");
$table->setData("3, 'class', 'application/octet-stream', 'Java Bytecode', 0, 0");
$table->setData("4, 'so', 'application/octet-stream', 'UNIX Shared Library Function', 0, 0");
$table->setData("5, 'dll', 'application/octet-stream', 'Dynamic Link Library', 0, 0");
$table->setData("6, 'hqx', 'application/binhex application/mac-binhex application/mac-binhex40', 'Macintosh BinHex 4 Compressed Archive', 0, 0");
$table->setData("7, 'cpt', 'application/mac-compactpro application/compact_pro', 'Compact Pro Archive', 0, 0");
$table->setData("8, 'lha', 'application/lha application/x-lha application/octet-stream application/x-compress application/x-compressed application/maclha', 'Compressed Archive File', 0, 0");
$table->setData("9, 'lzh', 'application/lzh application/x-lzh application/x-lha application/x-compress application/x-compressed application/x-lzh-archive zz-application/zz-winassoc-lzh application/maclha application/octet-stream', 'Compressed Archive File', 0, 0");
$table->setData("10, 'sh', 'application/x-shar', 'UNIX shar Archive File', 0, 0");
$table->setData("11, 'shar', 'application/x-shar', 'UNIX shar Archive File', 0, 0");
$table->setData("12, 'tar', 'application/tar application/x-tar applicaton/x-gtar multipart/x-tar application/x-compress application/x-compressed', 'Tape Archive File', 0, 0");
$table->setData("13, 'gtar', 'application/x-gtar', 'GNU tar Compressed File Archive', 0, 0");
$table->setData("14, 'ustar', 'application/x-ustar multipart/x-ustar', 'POSIX tar Compressed Archive', 0, 0");
$table->setData("15, 'zip', 'application/zip application/x-zip application/x-zip-compressed application/octet-stream application/x-compress application/x-compressed multipart/x-zip', 'Compressed Archive File', 0, 0");
$table->setData("16, 'exe', 'application/exe application/x-exe application/dos-exe application/x-winexe application/msdos-windows application/x-msdos-program', 'Executable File', 0, 0");
$table->setData("17, 'wmz', 'application/x-ms-wmz', 'Windows Media Compressed Skin File', 0, 0");
$table->setData("18, 'wmd', 'application/x-ms-wmd', 'Windows Media Download File', 0, 0");
$table->setData("19, 'doc', 'application/msword application/doc appl/text application/vnd.msword application/vnd.ms-word application/winword application/word application/x-msw6 application/x-msword', 'Word Document', 1, 1");
$table->setData("20, 'pdf', 'application/pdf application/acrobat application/x-pdf applications/vnd.pdf text/pdf', 'Acrobat Portable Document Format', 1, 1");
$table->setData("21, 'eps', 'application/eps application/postscript application/x-eps image/eps image/x-eps', 'Encapsulated PostScript', 0, 0");
$table->setData("22, 'ps', 'application/postscript application/ps application/x-postscript application/x-ps text/postscript', 'PostScript', 0, 0");
$table->setData("23, 'smi', 'application/smil', 'SMIL Multimedia', 0, 0");
$table->setData("24, 'smil', 'application/smil', 'Synchronized Multimedia Integration Language', 0, 0");
$table->setData("25, 'wmlc', 'application/vnd.wap.wmlc ', 'Compiled WML Document', 0, 0");
$table->setData("26, 'wmlsc', 'application/vnd.wap.wmlscriptc', 'Compiled WML Script', 0, 0");
$table->setData("27, 'vcd', 'application/x-cdlink', 'Virtual CD-ROM CD Image File', 0, 0");
$table->setData("28, 'pgn', 'application/formstore', 'Picatinny Arsenal Electronic Formstore Form in TIFF Format', 0, 0");
$table->setData("29, 'cpio', 'application/x-cpio', 'UNIX CPIO Archive', 0, 0");
$table->setData("30, 'csh', 'application/x-csh', 'Csh Script', 0, 0");
$table->setData("31, 'dcr', 'application/x-director', 'Shockwave Movie', 0, 0");
$table->setData("32, 'dir', 'application/x-director', 'Macromedia Director Movie', 0, 0");
$table->setData("33, 'dxr', 'application/x-director application/vnd.dxr', 'Macromedia Director Protected Movie File', 0, 0");
$table->setData("34, 'dvi', 'application/x-dvi', 'TeX Device Independent Document', 0, 0");
$table->setData("35, 'spl', 'application/x-futuresplash', 'Macromedia FutureSplash File', 0, 0");
$table->setData("36, 'hdf', 'application/x-hdf', 'Hierarchical Data Format File', 0, 0");
$table->setData("37, 'js', 'application/x-javascript text/javascript', 'JavaScript Source Code', 0, 0");
$table->setData("38, 'skp', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Play File', 0, 0");
$table->setData("39, 'skd', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Design File', 0, 0");
$table->setData("40, 'skt', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Template File', 0, 0");
$table->setData("41, 'skm', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Mix File', 0, 0");
$table->setData("42, 'latex', 'application/x-latex text/x-latex', 'LaTeX Source Document', 0, 0");
$table->setData("43, 'nc', 'application/x-netcdf text/x-cdf', 'Unidata netCDF Graphics', 0, 0");
$table->setData("44, 'cdf', 'application/cdf application/x-cdf application/netcdf application/x-netcdf text/cdf text/x-cdf', 'Channel Definition Format', 0, 0");
$table->setData("45, 'swf', 'application/x-shockwave-flash application/x-shockwave-flash2-preview application/futuresplash image/vnd.rn-realflash', 'Macromedia Flash Format File', 0, 0");
$table->setData("46, 'sit', 'application/stuffit application/x-stuffit application/x-sit', 'StuffIt Compressed Archive File', 0, 0");
$table->setData("47, 'tcl', 'application/x-tcl', 'TCL/TK Language Script', 0, 0");
$table->setData("48, 'tex', 'application/x-tex', 'LaTeX Source', 0, 0");
$table->setData("49, 'texinfo', 'application/x-texinfo', 'TeX', 0, 0");
$table->setData("50, 'texi', 'application/x-texinfo', 'TeX', 0, 0");
$table->setData("51, 't', 'application/x-troff', 'TAR Tape Archive Without Compression', 0, 0");
$table->setData("52, 'tr', 'application/x-troff', 'Unix Tape Archive = TAR without compression (tar)', 0, 0");
$table->setData("53, 'src', 'application/x-wais-source', 'Sourcecode', 0, 0");
$table->setData("54, 'xhtml', 'application/xhtml+xml', 'Extensible HyperText Markup Language File', 0, 0");
$table->setData("55, 'xht', 'application/xhtml+xml', 'Extensible HyperText Markup Language File', 0, 0");
$table->setData("56, 'au', 'audio/basic audio/x-basic audio/au audio/x-au audio/x-pn-au audio/rmf audio/x-rmf audio/x-ulaw audio/vnd.qcelp audio/x-gsm audio/snd', 'ULaw/AU Audio File', 0, 0");
$table->setData("57, 'XM', 'audio/xm audio/x-xm audio/module-xm audio/mod audio/x-mod', 'Fast Tracker 2 Extended Module', 0, 0");
$table->setData("58, 'snd', 'audio/basic', 'Macintosh Sound Resource', 0, 0");
$table->setData("59, 'mid', 'audio/mid audio/m audio/midi audio/x-midi application/x-midi audio/soundtrack', 'Musical Instrument Digital Interface MIDI-sequention Sound', 0, 0");
$table->setData("60, 'midi', 'audio/mid audio/m audio/midi audio/x-midi application/x-midi', 'Musical Instrument Digital Interface MIDI-sequention Sound', 0, 0");
$table->setData("61, 'kar', 'audio/midi audio/x-midi audio/mid x-music/x-midi', 'Karaoke MIDI File', 0, 0");
$table->setData("62, 'mpga', 'audio/mpeg audio/mp3 audio/mgp audio/m-mpeg audio/x-mp3 audio/x-mpeg audio/x-mpg video/mpeg', 'Mpeg-1 Layer3 Audio Stream', 0, 0");
$table->setData("63, 'mp2', 'video/mpeg audio/mpeg', 'MPEG Audio Stream, Layer II', 0, 0");
$table->setData("64, 'mp3', 'audio/mpeg audio/x-mpeg audio/mp3 audio/x-mp3 audio/mpeg3 audio/x-mpeg3 audio/mpg audio/x-mpg audio/x-mpegaudio', 'MPEG Audio Stream, Layer III', 0, 0");
$table->setData("65, 'aif', 'audio/aiff audio/x-aiff sound/aiff audio/rmf audio/x-rmf audio/x-pn-aiff audio/x-gsm audio/x-midi audio/vnd.qcelp', 'Audio Interchange File', 0, 0");
$table->setData("66, 'aiff', 'audio/aiff audio/x-aiff sound/aiff audio/rmf audio/x-rmf audio/x-pn-aiff audio/x-gsm audio/mid audio/x-midi audio/vnd.qcelp', 'Audio Interchange File', 0, 0");
$table->setData("67, 'aifc', 'audio/aiff audio/x-aiff audio/x-aifc sound/aiff audio/rmf audio/x-rmf audio/x-pn-aiff audio/x-gsm audio/x-midi audio/mid audio/vnd.qcelp', 'Audio Interchange File', 0, 0");
$table->setData("68, 'm3u', 'audio/x-mpegurl audio/mpeg-url application/x-winamp-playlist audio/scpls audio/x-scpls', 'MP3 Playlist File', 0, 0");
$table->setData("69, 'ram', 'audio/x-pn-realaudio audio/vnd.rn-realaudio audio/x-pm-realaudio-plugin audio/x-pn-realvideo audio/x-realaudio video/x-pn-realvideo text/plain', 'RealMedia Metafile', 0, 0");
$table->setData("70, 'rm', 'application/vnd.rn-realmedia audio/vnd.rn-realaudio audio/x-pn-realaudio audio/x-realaudio audio/x-pm-realaudio-plugin', 'RealMedia Streaming Media', 0, 0");
$table->setData("71, 'rpm', 'audio/x-pn-realaudio audio/x-pn-realaudio-plugin audio/x-pnrealaudio-plugin video/x-pn-realvideo-plugin audio/x-mpegurl application/octet-stream', 'RealMedia Player Plug-in', 0, 0");
$table->setData("72, 'ra', 'audio/vnd.rn-realaudio audio/x-pn-realaudio audio/x-realaudio audio/x-pm-realaudio-plugin video/x-pn-realvideo', 'RealMedia Streaming Media', 0, 0");
$table->setData("73, 'wav', 'audio/wav audio/x-wav audio/wave audio/x-pn-wav', 'Waveform Audio', 0, 0");
$table->setData("74, 'wax', ' audio/x-ms-wax', 'Windows Media Audio Redirector', 0, 0");
$table->setData("75, 'wma', 'audio/x-ms-wma video/x-ms-asf', 'Windows Media Audio File', 0, 0");
$table->setData("76, 'bmp', 'image/bmp image/x-bmp image/x-bitmap image/x-xbitmap image/x-win-bitmap image/x-windows-bmp image/ms-bmp image/x-ms-bmp application/bmp application/x-bmp application/x-win-bitmap application/preview', 'Windows OS/2 Bitmap Graphics', 1, 1");
$table->setData("77, 'gif', 'image/gif image/x-xbitmap image/gi_', 'Graphic Interchange Format', 1, 1");
$table->setData("78, 'ief', 'image/ief', 'Image File - Bitmap graphics', 0, 0");
$table->setData("79, 'jpeg', 'image/jpeg image/jpg image/jpe_ image/pjpeg image/vnd.swiftview-jpeg', 'JPEG/JIFF Image', 1, 1");
$table->setData("80, 'jpg', 'image/jpeg image/jpg image/jp_ application/jpg application/x-jpg image/pjpeg image/pipeg image/vnd.swiftview-jpeg image/x-xbitmap', 'JPEG/JIFF Image', 1, 1");
$table->setData("81, 'jpe', 'image/jpeg', 'JPEG/JIFF Image', 1, 1");
$table->setData("82, 'png', 'image/png application/png application/x-png', 'Portable (Public) Network Graphic', 1, 1");
$table->setData("83, 'tiff', 'image/tiff', 'Tagged Image Format File', 1, 1");
$table->setData("84, 'tif', 'image/tif image/x-tif image/tiff image/x-tiff application/tif application/x-tif application/tiff application/x-tiff', 'Tagged Image Format File', 1, 1");
$table->setData("85, 'ico', 'image/ico image/x-icon application/ico application/x-ico application/x-win-bitmap image/x-win-bitmap application/octet-stream', 'Windows Icon', 0, 0");
$table->setData("86, 'wbmp', 'image/vnd.wap.wbmp', 'Wireless Bitmap File Format', 0, 0");
$table->setData("87, 'ras', 'application/ras application/x-ras image/ras', 'Sun Raster Graphic', 0, 0");
$table->setData("88, 'pnm', 'image/x-portable-anymap', 'PBM Portable Any Map Graphic Bitmap', 0, 0");
$table->setData("89, 'pbm', 'image/portable bitmap image/x-portable-bitmap image/pbm image/x-pbm', 'UNIX Portable Bitmap Graphic', 0, 0");
$table->setData("90, 'pgm', 'image/x-portable-graymap image/x-pgm', 'Portable Graymap Graphic', 0, 0");
$table->setData("91, 'ppm', 'image/x-portable-pixmap application/ppm application/x-ppm image/x-p image/x-ppm', 'PBM Portable Pixelmap Graphic', 0, 0");
$table->setData("92, 'rgb', 'image/rgb image/x-rgb', 'Silicon Graphics RGB Bitmap', 0, 0");
$table->setData("93, 'xbm', 'image/x-xpixmap image/x-xbitmap image/xpm image/x-xpm', 'X Bitmap Graphic', 0, 0");
$table->setData("94, 'xpm', 'image/x-xpixmap', 'BMC Software Patrol UNIX Icon File', 0, 0");
$table->setData("95, 'xwd', 'image/x-xwindowdump image/xwd image/x-xwd application/xwd application/x-xwd', 'X Windows Dump', 0, 0");
$table->setData("96, 'igs', 'model/iges application/iges application/x-iges application/igs application/x-igs drawing/x-igs image/x-igs', 'Initial Graphics Exchange Specification Format', 0, 0");
$table->setData("97, 'css', 'application/css-stylesheet text/css', 'Hypertext Cascading Style Sheet', 0, 0");
$table->setData("98, 'html', 'text/html text/plain', 'Hypertext Markup Language', 0, 0");
$table->setData("99, 'htm', 'text/html', 'Hypertext Markup Language', 0, 0");
$table->setData("100, 'txt', 'text/plain application/txt browser/internal', 'Text File', 1, 1");
$table->setData("101, 'rtf', 'application/rtf application/x-rtf text/rtf text/richtext application/msword application/doc application/x-soffice', 'Rich Text Format File', 1, 1");
$table->setData("102, 'wml', 'text/vnd.wap.wml text/wml', 'Website META Language File', 0, 0");
$table->setData("103, 'wmls', 'text/vnd.wap.wmlscript', 'WML Script', 0, 0");
$table->setData("104, 'etx', 'text/x-setext', 'SetText Structure Enhanced Text', 0, 0");
$table->setData("105, 'xml', 'text/xml application/xml application/x-xml', 'Extensible Markup Language File', 0, 0");
$table->setData("106, 'xsl', 'text/xml', 'XML Stylesheet', 0, 0");
$table->setData("107, 'php', 'text/php application/x-httpd-php application/php magnus-internal/shellcgi application/x-php', 'PHP Script', 0, 0");
$table->setData("108, 'php3', 'text/php3 application/x-httpd-php', 'PHP Script', 0, 0");
$table->setData("109, 'mpeg', 'video/mpeg', 'MPEG Movie', 0, 0");
$table->setData("110, 'mpg', 'video/mpeg video/mpg video/x-mpg video/mpeg2 application/x-pn-mpg video/x-mpeg video/x-mpeg2a audio/mpeg audio/x-mpeg image/mpg', 'MPEG 1 System Stream', 0, 0");
$table->setData("111, 'mpe', 'video/mpeg', 'MPEG Movie Clip', 0, 0");
$table->setData("112, 'qt', 'video/quicktime audio/aiff audio/x-wav video/flc', 'QuickTime Movie', 0, 0");
$table->setData("113, 'mov', 'video/quicktime video/x-quicktime image/mov audio/aiff audio/x-midi audio/x-wav video/avi', 'QuickTime Video Clip', 0, 0");
$table->setData("114, 'avi', 'video/avi video/msvideo video/x-msvideo image/avi video/xmpg2 application/x-troff-msvideo audio/aiff audio/avi', 'Audio Video Interleave File', 0, 0");
$table->setData("115, 'movie', 'video/sgi-movie video/x-sgi-movie', 'QuickTime Movie', 0, 0");
$table->setData("116, 'asf', 'audio/asf application/asx video/x-ms-asf-plugin application/x-mplayer2 video/x-ms-asf application/vnd.ms-asf video/x-ms-asf-plugin video/x-ms-wm video/x-ms-wmx', 'Advanced Streaming Format', 0, 0");
$table->setData("117, 'asx', 'video/asx application/asx video/x-ms-asf-plugin application/x-mplayer2 video/x-ms-asf application/vnd.ms-asf video/x-ms-asf-plugin video/x-ms-wm video/x-ms-wmx video/x-la-asf', 'Advanced Stream Redirector File', 0, 0");
$table->setData("118, 'wmv', 'video/x-ms-wmv', 'Windows Media File', 0, 0");
$table->setData("119, 'wvx', 'video/x-ms-wvx', 'Windows Media Redirector', 0, 0");
$table->setData("120, 'wm', 'video/x-ms-wm', 'Windows Media A/V File', 0, 0");
$table->setData("121, 'wmx', 'video/x-ms-wmx', 'Windows Media Player A/V Shortcut', 0, 0");
$table->setData("122, 'ice', 'x-conference-xcooltalk', 'Cooltalk Audio', 0, 0");
$table->setData("123, 'rar', 'application/octet-stream', 'WinRAR Compressed Archive', 0, 0");
$ret = $ret && $dbupdater->updateTable($table);
unset($table);
echo "</ul>";
/// SMARTSECTION 1.0.2 ////////////////////////////////////////////////
/// SMARTSECTION 1.0.2 ////////////////////////////////////////////////
case '1.02':
set_time_limit(60);
printf("<h3>" . _AM_SSECTION_DB_UPDATE_TO . "</h3>", '1.03');
echo "<ul>";
// Add field Address in items table
$table = new SmartsectionTable('smartsection_items');
$table->addNewField('address', "varchar(255) NOT NULL default ''");
$ret = $ret && $dbupdater->updateTable($table);
unset($table);
echo "</ul>";
/// SMARTSECTION 1.0.3 ////////////////////////////////////////////////
/// SMARTSECTION 1.0.3 ////////////////////////////////////////////////
case '1.03':
set_time_limit(60);
printf("<h3>" . _AM_SSECTION_DB_UPDATE_TO . "</h3>", '1.04');
echo "<ul>";
// Drop field adress in items table
$table = new SmartsectionTable('smartsection_items');
$table->addDropedField('address');
$ret = $ret && $dbupdater->updateTable($table);
unset($table);
echo "</ul>";
/// SMARTSECTION 1.0.4 ////////////////////////////////////////////////
/// SMARTSECTION 1.0.4 ////////////////////////////////////////////////
case '1.04':
set_time_limit(60);
printf("<h3>" . _AM_SSECTION_DB_UPDATE_TO . "</h3>", '1.05');
echo "<ul>";
echo "<li>No database changes are needed</li>";
echo "</ul>";
/// SMARTSECTION 1.0.5 ////////////////////////////////////////////////
/// SMARTSECTION 1.0.5 ////////////////////////////////////////////////
case '1.05':
set_time_limit(60);
printf("<h3>" . _AM_SSECTION_DB_UPDATE_TO . "</h3>", '1.1');
echo "<ul>";
echo "<li>No database changes are needed</li>";
echo "</ul>";
/// SMARTSECTION 1.1 ////////////////////////////////////////////////
/// SMARTSECTION 1.1 ////////////////////////////////////////////////
case '1.1':
set_time_limit(60);
printf("<h3>" . _AM_SSECTION_DB_UPDATE_TO . "</h3>", '2.0');
echo "<ul>";
// Add field template
$table = new SmartsectionTable('smartsection_categories');
$table->addNewField('template', "varchar(255) NOT NULL default ''");
$ret = $ret && $dbupdater->updateTable($table);
unset($table);
// Create mimetypes table if not already created
if (!smartsection_TableExists('smartsection_mimetypes')) {
// Create table smartsection_mimetypes
$table = new SmartsectionTable('smartsection_mimetypes');
$table->setStructure("CREATE TABLE %s (\n\t \t\t\t\t\t\t\t mime_id int(11) NOT NULL auto_increment,\n\t \t\t\t\t\t\t\t mime_ext varchar(60) NOT NULL default '',\n\t \t\t\t\t\t\t\t mime_types text NOT NULL,\n\t \t\t\t\t\t\t\t mime_name varchar(255) NOT NULL default '',\n\t \t\t\t\t\t\t\t mime_admin int(1) NOT NULL default '1',\n\t \t\t\t\t\t\t\t mime_user int(1) NOT NULL default '0',\n\t \t\t\t\t\t\t\t KEY mime_id (mime_id)\n\t \t\t\t\t\t\t\t ) TYPE=MyISAM;");
$table->setData("1, 'bin', 'application/octet-stream', 'Binary File/Linux Executable', 0, 0");
$table->setData("2, 'dms', 'application/octet-stream', 'Amiga DISKMASHER Compressed Archive', 0, 0");
$table->setData("3, 'class', 'application/octet-stream', 'Java Bytecode', 0, 0");
$table->setData("4, 'so', 'application/octet-stream', 'UNIX Shared Library Function', 0, 0");
$table->setData("5, 'dll', 'application/octet-stream', 'Dynamic Link Library', 0, 0");
$table->setData("6, 'hqx', 'application/binhex application/mac-binhex application/mac-binhex40', 'Macintosh BinHex 4 Compressed Archive', 0, 0");
$table->setData("7, 'cpt', 'application/mac-compactpro application/compact_pro', 'Compact Pro Archive', 0, 0");
$table->setData("8, 'lha', 'application/lha application/x-lha application/octet-stream application/x-compress application/x-compressed application/maclha', 'Compressed Archive File', 0, 0");
$table->setData("9, 'lzh', 'application/lzh application/x-lzh application/x-lha application/x-compress application/x-compressed application/x-lzh-archive zz-application/zz-winassoc-lzh application/maclha application/octet-stream', 'Compressed Archive File', 0, 0");
$table->setData("10, 'sh', 'application/x-shar', 'UNIX shar Archive File', 0, 0");
$table->setData("11, 'shar', 'application/x-shar', 'UNIX shar Archive File', 0, 0");
$table->setData("12, 'tar', 'application/tar application/x-tar applicaton/x-gtar multipart/x-tar application/x-compress application/x-compressed', 'Tape Archive File', 0, 0");
$table->setData("13, 'gtar', 'application/x-gtar', 'GNU tar Compressed File Archive', 0, 0");
$table->setData("14, 'ustar', 'application/x-ustar multipart/x-ustar', 'POSIX tar Compressed Archive', 0, 0");
$table->setData("15, 'zip', 'application/zip application/x-zip application/x-zip-compressed application/octet-stream application/x-compress application/x-compressed multipart/x-zip', 'Compressed Archive File', 0, 0");
$table->setData("16, 'exe', 'application/exe application/x-exe application/dos-exe application/x-winexe application/msdos-windows application/x-msdos-program', 'Executable File', 0, 0");
$table->setData("17, 'wmz', 'application/x-ms-wmz', 'Windows Media Compressed Skin File', 0, 0");
$table->setData("18, 'wmd', 'application/x-ms-wmd', 'Windows Media Download File', 0, 0");
$table->setData("19, 'doc', 'application/msword application/doc appl/text application/vnd.msword application/vnd.ms-word application/winword application/word application/x-msw6 application/x-msword', 'Word Document', 1, 1");
$table->setData("20, 'pdf', 'application/pdf application/acrobat application/x-pdf applications/vnd.pdf text/pdf', 'Acrobat Portable Document Format', 1, 1");
$table->setData("21, 'eps', 'application/eps application/postscript application/x-eps image/eps image/x-eps', 'Encapsulated PostScript', 0, 0");
$table->setData("22, 'ps', 'application/postscript application/ps application/x-postscript application/x-ps text/postscript', 'PostScript', 0, 0");
$table->setData("23, 'smi', 'application/smil', 'SMIL Multimedia', 0, 0");
$table->setData("24, 'smil', 'application/smil', 'Synchronized Multimedia Integration Language', 0, 0");
$table->setData("25, 'wmlc', 'application/vnd.wap.wmlc ', 'Compiled WML Document', 0, 0");
$table->setData("26, 'wmlsc', 'application/vnd.wap.wmlscriptc', 'Compiled WML Script', 0, 0");
$table->setData("27, 'vcd', 'application/x-cdlink', 'Virtual CD-ROM CD Image File', 0, 0");
$table->setData("28, 'pgn', 'application/formstore', 'Picatinny Arsenal Electronic Formstore Form in TIFF Format', 0, 0");
$table->setData("29, 'cpio', 'application/x-cpio', 'UNIX CPIO Archive', 0, 0");
$table->setData("30, 'csh', 'application/x-csh', 'Csh Script', 0, 0");
$table->setData("31, 'dcr', 'application/x-director', 'Shockwave Movie', 0, 0");
$table->setData("32, 'dir', 'application/x-director', 'Macromedia Director Movie', 0, 0");
$table->setData("33, 'dxr', 'application/x-director application/vnd.dxr', 'Macromedia Director Protected Movie File', 0, 0");
$table->setData("34, 'dvi', 'application/x-dvi', 'TeX Device Independent Document', 0, 0");
$table->setData("35, 'spl', 'application/x-futuresplash', 'Macromedia FutureSplash File', 0, 0");
$table->setData("36, 'hdf', 'application/x-hdf', 'Hierarchical Data Format File', 0, 0");
$table->setData("37, 'js', 'application/x-javascript text/javascript', 'JavaScript Source Code', 0, 0");
$table->setData("38, 'skp', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Play File', 0, 0");
$table->setData("39, 'skd', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Design File', 0, 0");
$table->setData("40, 'skt', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Template File', 0, 0");
$table->setData("41, 'skm', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Mix File', 0, 0");
$table->setData("42, 'latex', 'application/x-latex text/x-latex', 'LaTeX Source Document', 0, 0");
$table->setData("43, 'nc', 'application/x-netcdf text/x-cdf', 'Unidata netCDF Graphics', 0, 0");
$table->setData("44, 'cdf', 'application/cdf application/x-cdf application/netcdf application/x-netcdf text/cdf text/x-cdf', 'Channel Definition Format', 0, 0");
$table->setData("45, 'swf', 'application/x-shockwave-flash application/x-shockwave-flash2-preview application/futuresplash image/vnd.rn-realflash', 'Macromedia Flash Format File', 0, 0");
$table->setData("46, 'sit', 'application/stuffit application/x-stuffit application/x-sit', 'StuffIt Compressed Archive File', 0, 0");
$table->setData("47, 'tcl', 'application/x-tcl', 'TCL/TK Language Script', 0, 0");
$table->setData("48, 'tex', 'application/x-tex', 'LaTeX Source', 0, 0");
$table->setData("49, 'texinfo', 'application/x-texinfo', 'TeX', 0, 0");
$table->setData("50, 'texi', 'application/x-texinfo', 'TeX', 0, 0");
$table->setData("51, 't', 'application/x-troff', 'TAR Tape Archive Without Compression', 0, 0");
$table->setData("52, 'tr', 'application/x-troff', 'Unix Tape Archive = TAR without compression (tar)', 0, 0");
$table->setData("53, 'src', 'application/x-wais-source', 'Sourcecode', 0, 0");
$table->setData("54, 'xhtml', 'application/xhtml+xml', 'Extensible HyperText Markup Language File', 0, 0");
$table->setData("55, 'xht', 'application/xhtml+xml', 'Extensible HyperText Markup Language File', 0, 0");
$table->setData("56, 'au', 'audio/basic audio/x-basic audio/au audio/x-au audio/x-pn-au audio/rmf audio/x-rmf audio/x-ulaw audio/vnd.qcelp audio/x-gsm audio/snd', 'ULaw/AU Audio File', 0, 0");
$table->setData("57, 'XM', 'audio/xm audio/x-xm audio/module-xm audio/mod audio/x-mod', 'Fast Tracker 2 Extended Module', 0, 0");
$table->setData("58, 'snd', 'audio/basic', 'Macintosh Sound Resource', 0, 0");
$table->setData("59, 'mid', 'audio/mid audio/m audio/midi audio/x-midi application/x-midi audio/soundtrack', 'Musical Instrument Digital Interface MIDI-sequention Sound', 0, 0");
$table->setData("60, 'midi', 'audio/mid audio/m audio/midi audio/x-midi application/x-midi', 'Musical Instrument Digital Interface MIDI-sequention Sound', 0, 0");
$table->setData("61, 'kar', 'audio/midi audio/x-midi audio/mid x-music/x-midi', 'Karaoke MIDI File', 0, 0");
$table->setData("62, 'mpga', 'audio/mpeg audio/mp3 audio/mgp audio/m-mpeg audio/x-mp3 audio/x-mpeg audio/x-mpg video/mpeg', 'Mpeg-1 Layer3 Audio Stream', 0, 0");
$table->setData("63, 'mp2', 'video/mpeg audio/mpeg', 'MPEG Audio Stream, Layer II', 0, 0");
$table->setData("64, 'mp3', 'audio/mpeg audio/x-mpeg audio/mp3 audio/x-mp3 audio/mpeg3 audio/x-mpeg3 audio/mpg audio/x-mpg audio/x-mpegaudio', 'MPEG Audio Stream, Layer III', 0, 0");
$table->setData("65, 'aif', 'audio/aiff audio/x-aiff sound/aiff audio/rmf audio/x-rmf audio/x-pn-aiff audio/x-gsm audio/x-midi audio/vnd.qcelp', 'Audio Interchange File', 0, 0");
$table->setData("66, 'aiff', 'audio/aiff audio/x-aiff sound/aiff audio/rmf audio/x-rmf audio/x-pn-aiff audio/x-gsm audio/mid audio/x-midi audio/vnd.qcelp', 'Audio Interchange File', 0, 0");
$table->setData("67, 'aifc', 'audio/aiff audio/x-aiff audio/x-aifc sound/aiff audio/rmf audio/x-rmf audio/x-pn-aiff audio/x-gsm audio/x-midi audio/mid audio/vnd.qcelp', 'Audio Interchange File', 0, 0");
$table->setData("68, 'm3u', 'audio/x-mpegurl audio/mpeg-url application/x-winamp-playlist audio/scpls audio/x-scpls', 'MP3 Playlist File', 0, 0");
$table->setData("69, 'ram', 'audio/x-pn-realaudio audio/vnd.rn-realaudio audio/x-pm-realaudio-plugin audio/x-pn-realvideo audio/x-realaudio video/x-pn-realvideo text/plain', 'RealMedia Metafile', 0, 0");
$table->setData("70, 'rm', 'application/vnd.rn-realmedia audio/vnd.rn-realaudio audio/x-pn-realaudio audio/x-realaudio audio/x-pm-realaudio-plugin', 'RealMedia Streaming Media', 0, 0");
$table->setData("71, 'rpm', 'audio/x-pn-realaudio audio/x-pn-realaudio-plugin audio/x-pnrealaudio-plugin video/x-pn-realvideo-plugin audio/x-mpegurl application/octet-stream', 'RealMedia Player Plug-in', 0, 0");
$table->setData("72, 'ra', 'audio/vnd.rn-realaudio audio/x-pn-realaudio audio/x-realaudio audio/x-pm-realaudio-plugin video/x-pn-realvideo', 'RealMedia Streaming Media', 0, 0");
$table->setData("73, 'wav', 'audio/wav audio/x-wav audio/wave audio/x-pn-wav', 'Waveform Audio', 0, 0");
$table->setData("74, 'wax', ' audio/x-ms-wax', 'Windows Media Audio Redirector', 0, 0");
$table->setData("75, 'wma', 'audio/x-ms-wma video/x-ms-asf', 'Windows Media Audio File', 0, 0");
$table->setData("76, 'bmp', 'image/bmp image/x-bmp image/x-bitmap image/x-xbitmap image/x-win-bitmap image/x-windows-bmp image/ms-bmp image/x-ms-bmp application/bmp application/x-bmp application/x-win-bitmap application/preview', 'Windows OS/2 Bitmap Graphics', 1, 1");
$table->setData("77, 'gif', 'image/gif image/x-xbitmap image/gi_', 'Graphic Interchange Format', 1, 1");
$table->setData("78, 'ief', 'image/ief', 'Image File - Bitmap graphics', 0, 0");
$table->setData("79, 'jpeg', 'image/jpeg image/jpg image/jpe_ image/pjpeg image/vnd.swiftview-jpeg', 'JPEG/JIFF Image', 1, 1");
$table->setData("80, 'jpg', 'image/jpeg image/jpg image/jp_ application/jpg application/x-jpg image/pjpeg image/pipeg image/vnd.swiftview-jpeg image/x-xbitmap', 'JPEG/JIFF Image', 1, 1");
$table->setData("81, 'jpe', 'image/jpeg', 'JPEG/JIFF Image', 1, 1");
$table->setData("82, 'png', 'image/png application/png application/x-png', 'Portable (Public) Network Graphic', 1, 1");
$table->setData("83, 'tiff', 'image/tiff', 'Tagged Image Format File', 1, 1");
$table->setData("84, 'tif', 'image/tif image/x-tif image/tiff image/x-tiff application/tif application/x-tif application/tiff application/x-tiff', 'Tagged Image Format File', 1, 1");
$table->setData("85, 'ico', 'image/ico image/x-icon application/ico application/x-ico application/x-win-bitmap image/x-win-bitmap application/octet-stream', 'Windows Icon', 0, 0");
$table->setData("86, 'wbmp', 'image/vnd.wap.wbmp', 'Wireless Bitmap File Format', 0, 0");
$table->setData("87, 'ras', 'application/ras application/x-ras image/ras', 'Sun Raster Graphic', 0, 0");
$table->setData("88, 'pnm', 'image/x-portable-anymap', 'PBM Portable Any Map Graphic Bitmap', 0, 0");
$table->setData("89, 'pbm', 'image/portable bitmap image/x-portable-bitmap image/pbm image/x-pbm', 'UNIX Portable Bitmap Graphic', 0, 0");
$table->setData("90, 'pgm', 'image/x-portable-graymap image/x-pgm', 'Portable Graymap Graphic', 0, 0");
$table->setData("91, 'ppm', 'image/x-portable-pixmap application/ppm application/x-ppm image/x-p image/x-ppm', 'PBM Portable Pixelmap Graphic', 0, 0");
$table->setData("92, 'rgb', 'image/rgb image/x-rgb', 'Silicon Graphics RGB Bitmap', 0, 0");
$table->setData("93, 'xbm', 'image/x-xpixmap image/x-xbitmap image/xpm image/x-xpm', 'X Bitmap Graphic', 0, 0");
$table->setData("94, 'xpm', 'image/x-xpixmap', 'BMC Software Patrol UNIX Icon File', 0, 0");
$table->setData("95, 'xwd', 'image/x-xwindowdump image/xwd image/x-xwd application/xwd application/x-xwd', 'X Windows Dump', 0, 0");
$table->setData("96, 'igs', 'model/iges application/iges application/x-iges application/igs application/x-igs drawing/x-igs image/x-igs', 'Initial Graphics Exchange Specification Format', 0, 0");
$table->setData("97, 'css', 'application/css-stylesheet text/css', 'Hypertext Cascading Style Sheet', 0, 0");
$table->setData("98, 'html', 'text/html text/plain', 'Hypertext Markup Language', 0, 0");
$table->setData("99, 'htm', 'text/html', 'Hypertext Markup Language', 0, 0");
$table->setData("100, 'txt', 'text/plain application/txt browser/internal', 'Text File', 1, 1");
$table->setData("101, 'rtf', 'application/rtf application/x-rtf text/rtf text/richtext application/msword application/doc application/x-soffice', 'Rich Text Format File', 1, 1");
$table->setData("102, 'wml', 'text/vnd.wap.wml text/wml', 'Website META Language File', 0, 0");
$table->setData("103, 'wmls', 'text/vnd.wap.wmlscript', 'WML Script', 0, 0");
$table->setData("104, 'etx', 'text/x-setext', 'SetText Structure Enhanced Text', 0, 0");
$table->setData("105, 'xml', 'text/xml application/xml application/x-xml', 'Extensible Markup Language File', 0, 0");
$table->setData("106, 'xsl', 'text/xml', 'XML Stylesheet', 0, 0");
$table->setData("107, 'php', 'text/php application/x-httpd-php application/php magnus-internal/shellcgi application/x-php', 'PHP Script', 0, 0");
$table->setData("108, 'php3', 'text/php3 application/x-httpd-php', 'PHP Script', 0, 0");
$table->setData("109, 'mpeg', 'video/mpeg', 'MPEG Movie', 0, 0");
$table->setData("110, 'mpg', 'video/mpeg video/mpg video/x-mpg video/mpeg2 application/x-pn-mpg video/x-mpeg video/x-mpeg2a audio/mpeg audio/x-mpeg image/mpg', 'MPEG 1 System Stream', 0, 0");
$table->setData("111, 'mpe', 'video/mpeg', 'MPEG Movie Clip', 0, 0");
$table->setData("112, 'qt', 'video/quicktime audio/aiff audio/x-wav video/flc', 'QuickTime Movie', 0, 0");
$table->setData("113, 'mov', 'video/quicktime video/x-quicktime image/mov audio/aiff audio/x-midi audio/x-wav video/avi', 'QuickTime Video Clip', 0, 0");
$table->setData("114, 'avi', 'video/avi video/msvideo video/x-msvideo image/avi video/xmpg2 application/x-troff-msvideo audio/aiff audio/avi', 'Audio Video Interleave File', 0, 0");
$table->setData("115, 'movie', 'video/sgi-movie video/x-sgi-movie', 'QuickTime Movie', 0, 0");
$table->setData("116, 'asf', 'audio/asf application/asx video/x-ms-asf-plugin application/x-mplayer2 video/x-ms-asf application/vnd.ms-asf video/x-ms-asf-plugin video/x-ms-wm video/x-ms-wmx', 'Advanced Streaming Format', 0, 0");
$table->setData("117, 'asx', 'video/asx application/asx video/x-ms-asf-plugin application/x-mplayer2 video/x-ms-asf application/vnd.ms-asf video/x-ms-asf-plugin video/x-ms-wm video/x-ms-wmx video/x-la-asf', 'Advanced Stream Redirector File', 0, 0");
$table->setData("118, 'wmv', 'video/x-ms-wmv', 'Windows Media File', 0, 0");
$table->setData("119, 'wvx', 'video/x-ms-wvx', 'Windows Media Redirector', 0, 0");
$table->setData("120, 'wm', 'video/x-ms-wm', 'Windows Media A/V File', 0, 0");
$table->setData("121, 'wmx', 'video/x-ms-wmx', 'Windows Media Player A/V Shortcut', 0, 0");
$table->setData("122, 'ice', 'x-conference-xcooltalk', 'Cooltalk Audio', 0, 0");
$table->setData("123, 'rar', 'application/octet-stream', 'WinRAR Compressed Archive', 0, 0");
$ret = $ret && $dbupdater->updateTable($table);
unset($table);
}
// Add header template in categories
$table = new SmartsectionTable('smartsection_categories');
$table->addNewField('header', "TEXT NOT NULL");
$ret = $ret && $dbupdater->updateTable($table);
unset($table);
echo "</ul>";
/// SMARTSECTION 2.0 ////////////////////////////////////////////////
/// SMARTSECTION 2.0 ////////////////////////////////////////////////
case '2.0':
set_time_limit(60);
printf("<h3>" . _AM_SSECTION_DB_UPDATE_TO . "</h3>", '2.1');
echo "<ul>";
// Add fields in smartsection_categories
$table = new SmartsectionTable('smartsection_categories');
$table->addNewField('meta_keywords', "TEXT NOT NULL");
$table->addNewField('meta_description', "TEXT NOT NULL");
$table->addNewField('short_url', "VARCHAR(255) NOT NULL");
$ret = $dbupdater->updateTable($table);
unset($table);
// Add fields in smartsection_items
$table = new SmartsectionTable('smartsection_items');
$table->addNewField('meta_keywords', "TEXT NOT NULL");
$table->addNewField('meta_description', "TEXT NOT NULL");
$table->addNewField('short_url', "VARCHAR(255) NOT NULL");
$ret = $dbupdater->updateTable($table);
unset($table);
// Automatically create meta tag infos
global $smartsection_category_handler, $smartsection_item_handler;
$categoriesObj = $smartsection_category_handler->getObjects();
foreach ($categoriesObj as $categoryObj) {
$categoryObj->store();
echo "<li>Meta tags info automatically generated for category '<em>" . $categoryObj->name() . "</em>'</li>";
}
$itemsObj = $smartsection_item_handler->getObjects();
foreach ($itemsObj as $itemObj) {
$itemObj->store();
echo "<li>Meta tags info automatically generated for article '<em>" . $itemObj->title() . "</em>'</li>";
}
echo "</ul>";
case '2.1':
set_time_limit(60);
printf("<h3>" . _AM_SSECTION_DB_UPDATE_TO . "</h3>", '2.11');
echo "<ul>";
// Add fields in smartsection_items
$table = new SmartsectionTable('smartsection_items');
$table->addNewField('partial_view', "int(1) NOT NULL default '0'");
$ret = $dbupdater->updateTable($table);
unset($table);
echo "</ul>";
}
$newversion = round($xoopsModule->getVar('version') / 100, 2);
//if successful, update smartsection_meta table with new ver
if ($ret) {
printf(_AM_SSECTION_DB_UPDATE_OK, $newversion);
$ret = smartsection_SetMeta('version', $newversion);
} else {
printf(_AM_SSECTION_DB_UPDATE_ERR, $newversion);
}
smart_xoops_cp_footer();
}
function editfile($showmenu = false, $fileid = 0, $itemid = 0)
{
global $smartsection_file_handler, $xoopsModule;
include_once XOOPS_ROOT_PATH . '/class/xoopsformloader.php';
// if there is a parameter, and the id exists, retrieve data: we're editing a file
if ($fileid != 0) {
// Creating the File object
$fileObj = new smartsectionfile($fileid);
if ($fileObj->notLoaded()) {
redirect_header("javascript:history.go(-1)", 1, _AM_SSECTION_NOFILESELECTED);
exit;
}
if ($showmenu) {
smartsection_adminMenu(2, _AM_SSECTION_FILE . " > " . _AM_SSECTION_EDITING);
}
echo "<br />\n";
echo "<span style='color: #2F5376; font-weight: bold; font-size: 16px; margin: 6px 06 0 0; '>" . _AM_SSECTION_FILE_EDITING . "</span>";
echo "<span style=\"color: #567; margin: 3px 0 12px 0; font-size: small; display: block; \">" . _AM_SSECTION_FILE_EDITING_DSC . "</span>";
smartsection_collapsableBar('editfile', 'editfileicon', _AM_SSECTION_FILE_INFORMATIONS);
} else {
// there's no parameter, so we're adding an item
$fileObj =& $smartsection_file_handler->create();
$fileObj->setVar('itemid', $itemid);
if ($showmenu) {
smartsection_adminMenu(2, _AM_SSECTION_FILE . " > " . _AM_SSECTION_FILE_ADD);
}
echo "<span style='color: #2F5376; font-weight: bold; font-size: 16px; margin: 6px 06 0 0; '>" . _AM_SSECTION_FILE_ADDING . "</span>";
echo "<span style=\"color: #567; margin: 3px 0 12px 0; font-size: small; display: block; \">" . _AM_SSECTION_FILE_ADDING_DSC . "</span>";
smartsection_collapsableBar('addfile', 'addfileicon', _AM_SSECTION_FILE_INFORMATIONS);
}
// FILES UPLOAD FORM
$files_form = new XoopsThemeForm(_AM_SSECTION_UPLOAD_FILE, "files_form", xoops_getenv('PHP_SELF'));
$files_form->setExtra("enctype='multipart/form-data'");
// NAME
$name_text = new XoopsFormText(_AM_SSECTION_FILE_NAME, 'name', 50, 255, $fileObj->name());
$name_text->setDescription(_AM_SSECTION_FILE_NAME_DSC);
$files_form->addElement($name_text, true);
// DESCRIPTION
$description_text = new XoopsFormTextArea(_AM_SSECTION_FILE_DESCRIPTION, 'description', $fileObj->description());
$description_text->setDescription(_AM_SSECTION_FILE_DESCRIPTION_DSC);
$files_form->addElement($description_text, 7, 60);
// FILE TO UPLOAD
if ($fileid == 0) {
$file_box = new XoopsFormFile(_AM_SSECTION_FILE_TO_UPLOAD, "userfile", 0);
$file_box->setExtra("size ='50'");
$files_form->addElement($file_box);
}
$status_select = new XoopsFormRadioYN(_AM_SSECTION_FILE_STATUS, 'file_status', $fileObj->status());
$status_select->setDescription(_AM_SSECTION_FILE_STATUS_DSC);
$files_form->addElement($status_select);
$files_button_tray = new XoopsFormElementTray('', '');
$files_hidden = new XoopsFormHidden('op', 'uploadfile');
$files_button_tray->addElement($files_hidden);
if ($fileid == 0) {
$files_butt_create = new XoopsFormButton('', '', _AM_SSECTION_UPLOAD, 'submit');
$files_butt_create->setExtra('onclick="this.form.elements.op.value=\'uploadfile\'"');
$files_button_tray->addElement($files_butt_create);
$files_butt_another = new XoopsFormButton('', '', _AM_SSECTION_FILE_UPLOAD_ANOTHER, 'submit');
$files_butt_another->setExtra('onclick="this.form.elements.op.value=\'uploadanother\'"');
$files_button_tray->addElement($files_butt_another);
} else {
$files_butt_create = new XoopsFormButton('', '', _AM_SSECTION_MODIFY, 'submit');
$files_butt_create->setExtra('onclick="this.form.elements.op.value=\'modify\'"');
$files_button_tray->addElement($files_butt_create);
}
$files_butt_clear = new XoopsFormButton('', '', _AM_SSECTION_CLEAR, 'reset');
$files_button_tray->addElement($files_butt_clear);
$butt_cancel = new XoopsFormButton('', '', _AM_SSECTION_CANCEL, 'button');
$butt_cancel->setExtra('onclick="history.go(-1)"');
$files_button_tray->addElement($butt_cancel);
$files_form->addElement($files_button_tray);
// fileid
$files_form->addElement(new XoopsFormHidden('fileid', $fileid));
// itemid
$files_form->addElement(new XoopsFormHidden('itemid', $itemid));
$files_form->display();
if ($fileid != 0) {
smartsection_close_collapsable('editfile', 'editfileicon');
} else {
smartsection_close_collapsable('addfile', 'addfileicon');
}
}
<?php
/**
* $Id: pagewrap.php 331 2007-12-23 16:01:11Z malanciault $
* Module: SmartSection
* Author: The SmartFactory <www.smartfactory.ca>
* Credits : TinyContent developped by Tobias Liegl (AKA CHAPI) (http://www.chapi.de)
* Licence: GNU
*/
include_once "admin_header.php";
smartsection_xoops_cp_header();
smartsection_adminMenu(-1, _AM_SSECTION_ITEMS . " > " . _AM_SSECTION_PAGEWRAP);
smartsection_collapsableBar('pagewraptable', 'pagewrapicon', _AM_SSECTION_PAGEWRAP, _AM_SSECTION_PAGEWRAPDSC);
$dir = smartsection_getUploadDir(true, 'content');
if (!eregi("777", decoct(fileperms($dir)))) {
echo "<font color='FF0000'><h4>" . _AM_SSECTION_PERMERROR . "</h4></font>";
}
// Upload File
echo "<form name='form_name2' id='form_name2' action='pw_upload_file.php' method='post' enctype='multipart/form-data'>";
echo "<table cellspacing='1' width='100%' class='outer'>";
echo "<tr><th colspan='2'>" . _AM_SSECTION_UPLOAD_FILE . "</th></tr>";
echo "<tr valign='top' align='left'><td class='head'>" . _AM_SSECTION_SEARCH . "</td><td class='even'><input type='file' name='fileupload' id='fileupload' size='30' /></td></tr>";
echo "<tr valign='top' align='left'><td class='head'><input type='hidden' name='MAX_FILE_SIZE' id='op' value='500000' /></td><td class='even'><input type='submit' name='submit' value='" . _AM_SSECTION_UPLOAD . "' /></td></tr>";
echo "</table>";
echo "</form>";
// Delete File
$form = new XoopsThemeForm(_AM_SSECTION_DELETEFILE, "form_name", "pw_delete_file.php");
$pWrap_select = new XoopsFormSelect(smartsection_getUploadDir(true, 'content'), "address");
$folder = dir($dir);
while ($file = $folder->read()) {
if ($file != "." && $file != "..") {
function search()
{
global $oAdminButton, $hMime, $limit, $start, $imagearray, $aSearchBy, $aOrderBy, $aLimitBy, $aSortBy;
if (isset($_POST['deleteMimes'])) {
$aMimes = $_POST['mimes'];
$crit = new Criteria('mime_id', "(" . implode($aMimes, ',') . ")", "IN");
if ($hMime->deleteAll($crit)) {
header("Location: " . SMARTSECTION_ADMIN_URL . "/mimetypes.php?limit={$limit}&start={$start}");
} else {
redirect_header(SMARTSECTION_ADMIN_URL . "/mimetypes.php?limit={$limit}&start={$start}", 3, _AM_SSECTION_MESSAGE_DELETE_MIME_ERROR);
}
}
if (isset($_POST['add_mime'])) {
header("Location: " . SMARTSECTION_ADMIN_URL . "/mimetypes.php?op=add&start={$start}&limit={$limit}");
exit;
}
if (isset($_REQUEST['order'])) {
$order = $_REQUEST['order'];
} else {
$order = "ASC";
}
if (isset($_REQUEST['sort'])) {
$sort = $_REQUEST['sort'];
} else {
$sort = "mime_name";
}
smartsection_xoops_cp_header();
smartsection_adminMenu(4, _AM_SSECTION_MIMETYPES . " > " . _AM_SSECTION_BUTTON_SEARCH);
smartsection_collapsableBar('mimemsearchtable', 'mimesearchicon', _AM_SSECTION_MIME_SEARCH);
if (!isset($_REQUEST['mime_search'])) {
echo "<form action='mimetypes.php?op=search' method='post'>";
echo "<table width='100%' cellspacing='1' class='outer'>";
echo "<tr><th colspan='2'>" . _AM_SSECTION_TEXT_SEARCH_MIME . "</th></tr>";
echo "<tr><td class='head' width='20%'>" . _AM_SSECTION_TEXT_SEARCH_BY . "</td>\n <td class='even'>\n <select name='search_by'>";
foreach ($aSortBy as $value => $text) {
echo "<option value='{$value}'>{$text}</option>";
}
echo "</select>\n </td>\n </tr>";
echo "<tr><td class='head'>" . _AM_SSECTION_TEXT_SEARCH_TEXT . "</td>\n <td class='even'>\n <input type='text' name='search_text' id='search_text' value='' />\n </td>\n </tr>";
echo "<tr class='foot'>\n <td colspan='2'>\n <input type='submit' name='mime_search' id='mime_search' value='" . _AM_SSECTION_BUTTON_SEARCH . "' />\n </td>\n </tr>";
echo "</table></form>";
} else {
$search_field = $_REQUEST['search_by'];
$search_text = $_REQUEST['search_text'];
$crit = new Criteria($search_field, "%{$search_text}%", 'LIKE');
$crit->setSort($sort);
$crit->setOrder($order);
$crit->setLimit($limit);
$crit->setStart($start);
$mime_count =& $hMime->getCount($crit);
$mimetypes =& $hMime->getObjects($crit);
$nav = new XoopsPageNav($mime_count, $limit, $start, 'start', "op=search&limit={$limit}&order={$order}&sort={$sort}&mime_search=1&search_by={$search_field}&search_text={$search_text}");
// Display results
echo '<script type="text/javascript" src="' . SMARTSECTION_URL . '/include/functions.js"></script>';
echo "<table width='100%' cellspacing='1' class='outer'>";
echo "<tr><td colspan='6' align='right'>";
echo "<form action='" . SMARTSECTION_ADMIN_URL . "/mimetypes.php?op=search' style='margin:0; padding:0;' method='post'>";
echo "<table>";
echo "<tr>";
echo "<td align='right'>" . _AM_SSECTION_TEXT_SEARCH_BY . "</td>";
echo "<td align='left'><select name='search_by'>";
foreach ($aSearchBy as $value => $text) {
$search_field == $value ? $selected = "selected='selected'" : ($selected = '');
echo "<option value='{$value}' {$selected}>{$text}</option>";
}
echo "</select></td>";
echo "<td align='right'>" . _AM_SSECTION_TEXT_SEARCH_TEXT . "</td>";
echo "<td align='left'><input type='text' name='search_text' id='search_text' value='{$search_text}' /></td>";
echo "<td><input type='submit' name='mime_search' id='mime_search' value='" . _AM_SSECTION_BUTTON_SEARCH . "' /></td>";
echo "</tr></table></form></td></tr>";
echo "<tr><td colspan='6'>";
echo "<form action='" . SMARTSECTION_ADMIN_URL . "/mimetypes.php?op=search' style='margin:0; padding:0;' method='post'>";
echo "<table width='100%'>";
echo "<tr><td align='right'>" . _AM_SSECTION_TEXT_SORT_BY . " \n <select name='sort'>";
foreach ($aSortBy as $value => $text) {
$sort == $value ? $selected = "selected='selected'" : ($selected = '');
echo "<option value='{$value}' {$selected}>{$text}</option>";
}
echo "</select>\n \n " . _AM_SSECTION_TEXT_ORDER_BY . "\n <select name='order'>";
foreach ($aOrderBy as $value => $text) {
$order == $value ? $selected = "selected='selected'" : ($selected = '');
echo "<option value='{$value}' {$selected}>{$text}</option>";
}
echo "</select>\n \n " . _AM_SSECTION_TEXT_NUMBER_PER_PAGE . "\n <select name='limit'>";
foreach ($aLimitBy as $value => $text) {
$limit == $value ? $selected = "selected='selected'" : ($selected = '');
echo "<option value='{$value}' {$selected}>{$text}</option>";
}
echo "</select>\n <input type='submit' name='mime_sort' id='mime_sort' value='" . _AM_SSECTION_BUTTON_SUBMIT . "' />\n <input type='hidden' name='mime_search' id='mime_search' value='1' />\n <input type='hidden' name='search_by' id='search_by' value='{$search_field}' />\n <input type='hidden' name='search_text' id='search_text' value='{$search_text}' />\n </td>\n </tr>";
echo "</table>";
echo "</td></tr>";
if (count($mimetypes) > 0) {
echo "<tr><th colspan='6'>" . _AM_SSECTION_TEXT_SEARCH_MIME . "</th></tr>";
echo "<tr class='head'>\n <td>" . _AM_SSECTION_MIME_ID . "</td>\n <td>" . _AM_SSECTION_MIME_NAME . "</td>\n <td>" . _AM_SSECTION_MIME_EXT . "</td>\n <td>" . _AM_SSECTION_MIME_ADMIN . "</td>\n <td>" . _AM_SSECTION_MIME_USER . "</td>\n <td>" . _AM_SSECTION_MINDEX_ACTION . "</td>\n </tr>";
foreach ($mimetypes as $mime) {
echo "<tr class='even'>\n <td><input type='checkbox' name='mimes[]' value='" . $mime->getVar('mime_id') . "' />" . $mime->getVar('mime_id') . "</td>\n <td>" . $mime->getVar('mime_name') . "</td>\n <td>" . $mime->getVar('mime_ext') . "</td>\n <td>\n <a href='" . SMARTSECTION_ADMIN_URL . "/mimetypes.php?op=updateMimeValue&id=" . $mime->getVar('mime_id') . "&mime_admin=" . $mime->getVar('mime_admin') . "&limit=" . $limit . "&start=" . $start . "'>\n " . ($mime->getVar('mime_admin') ? $imagearray['online'] : $imagearray['offline']) . "</a>\n </td>\n <td>\n <a href='" . SMARTSECTION_ADMIN_URL . "/mimetypes.php?op=updateMimeValue&id=" . $mime->getVar('mime_id') . "&mime_user="******"&limit=" . $limit . "&start=" . $start . "'>\n " . ($mime->getVar('mime_user') ? $imagearray['online'] : $imagearray['offline']) . "</a>\n </td>\n <td>\n <a href='" . SMARTSECTION_ADMIN_URL . "/mimetypes.php?op=edit&id=" . $mime->getVar('mime_id') . "&limit=" . $limit . "&start=" . $start . "'>" . $imagearray['editimg'] . "</a>\n <a href='" . SMARTSECTION_ADMIN_URL . "/mimetypes.php?op=delete&id=" . $mime->getVar('mime_id') . "&limit=" . $limit . "&start=" . $start . "'>" . $imagearray['deleteimg'] . "</a>\n </td>\n </tr>";
}
echo "<tr class='foot'>\n <td colspan='6' valign='top'>\n <a href='http://www.filext.com' style='float: right' target='_blank'>" . _AM_SSECTION_MIME_FINDMIMETYPE . "</a>\n <input type='checkbox' name='checkAllMimes' value='0' onclick='selectAll(this.form,\"mimes[]\",this.checked);' />\n <input type='submit' name='deleteMimes' id='deleteMimes' value='" . _AM_SSECTION_BUTTON_DELETE . "' />\n <input type='submit' name='add_mime' id='add_mime' value='" . _AM_SSECTION_MIME_CREATEF . "' class='formButton' />\n </td>\n </tr>";
} else {
echo "<tr><th>" . _AM_SSECTION_TEXT_SEARCH_MIME . "</th></tr>";
echo "<tr class='even'>\n <td>" . _AM_SSECTION_TEXT_NO_RECORDS . "</td>\n </tr>";
}
echo "</table>";
echo "<div id='pagenav'>" . $nav->renderNav() . "</div>";
}
smartsection_close_collapsable('mimesearchtable', 'mimesearchicon');
xoops_cp_footer();
}
function edititem($showmenu = false, $itemid = 0, $clone = false)
{
global $smartsection_current_page, $smartsection_file_handler, $smartsection_item_handler, $smartsection_category_handler, $xoopsUser, $xoopsModule, $xoopsConfig, $xoopsDB;
include_once XOOPS_ROOT_PATH . '/class/xoopsformloader.php';
include_once SMARTSECTION_ROOT_PATH . '/class/formdatetime.php';
// if there is a parameter, and the id exists, retrieve data: we're editing a item
if ($itemid != 0) {
// Creating the ITEM object
$itemObj = $smartsection_item_handler->get($itemid);
if (!$itemObj) {
redirect_header("item.php", 1, _AM_SSECTION_NOITEMSELECTED);
exit;
}
if ($clone) {
$itemObj->setNew();
$itemObj->setVar('status', _SSECTION_STATUS_NOTSET);
$itemObj->setVar('datesub', time());
}
switch ($itemObj->status()) {
case _SSECTION_STATUS_SUBMITTED:
$breadcrumb_action1 = _AM_SSECTION_SUBMITTED;
$breadcrumb_action2 = _AM_SSECTION_APPROVING;
$page_title = _AM_SSECTION_SUBMITTED_TITLE;
$page_info = _AM_SSECTION_SUBMITTED_INFO;
$button_caption = _AM_SSECTION_APPROVE;
$new_status = _SSECTION_STATUS_PUBLISHED;
break;
case _SSECTION_STATUS_PUBLISHED:
$breadcrumb_action1 = _AM_SSECTION_PUBLISHED;
$breadcrumb_action2 = _AM_SSECTION_EDITING;
$page_title = _AM_SSECTION_PUBLISHEDEDITING;
$page_info = _AM_SSECTION_PUBLISHEDEDITING_INFO;
$button_caption = _AM_SSECTION_MODIFY;
$new_status = _SSECTION_STATUS_PUBLISHED;
break;
case _SSECTION_STATUS_OFFLINE:
$breadcrumb_action1 = _AM_SSECTION_OFFLINE;
$breadcrumb_action2 = _AM_SSECTION_EDITING;
$page_title = _AM_SSECTION_OFFLINEEDITING;
$page_info = _AM_SSECTION_OFFLINEEDITING_INFO;
$button_caption = _AM_SSECTION_MODIFY;
$new_status = _SSECTION_STATUS_OFFLINE;
break;
case _SSECTION_STATUS_REJECTED:
$breadcrumb_action1 = _AM_SSECTION_REJECTED;
$breadcrumb_action2 = _AM_SSECTION_REJECTED;
$page_title = _AM_SSECTION_REJECTED_EDIT;
$page_info = _AM_SSECTION_REJECTED_EDIT_INFO;
$button_caption = _AM_SSECTION_MODIFY;
$new_status = _SSECTION_STATUS_REJECTED;
break;
case _SSECTION_STATUS_NOTSET:
// Then it's a clone...
$breadcrumb_action1 = _AM_SSECTION_ITEMS;
$breadcrumb_action2 = _AM_SSECTION_CLONE_NEW;
$button_caption = _AM_SSECTION_CREATE;
$new_status = _SSECTION_STATUS_PUBLISHED;
$page_title = _AM_SSECTION_ITEM_DUPLICATING;
$page_info = _AM_SSECTION_ITEM_DUPLICATING_DSC;
break;
case "default":
default:
$breadcrumb_action1 = _AM_SSECTION_ITEMS;
$breadcrumb_action2 = _AM_SSECTION_EDITING;
$page_title = _AM_SSECTION_PUBLISHEDEDITING;
$page_info = _AM_SSECTION_PUBLISHEDEDITING_INFO;
$button_caption = _AM_SSECTION_MODIFY;
$new_status = _SSECTION_STATUS_PUBLISHED;
break;
}
$categoryObj = $itemObj->category();
if ($showmenu) {
smartsection_adminMenu(2, $breadcrumb_action1 . " > " . $breadcrumb_action2);
}
echo "<br />\n";
smartsection_collapsableBar('edititemtable', 'edititemicon', $page_title, $page_info);
if (!$clone) {
echo "<form><div style=\"margin-bottom: 10px;\">";
echo "<input type='button' name='button' onclick=\"location='item.php?op=clone&itemid=" . $itemObj->itemid() . "'\" value='" . _AM_SSECTION_CLONE_ITEM . "'> ";
echo "</div></form>";
}
} else {
// there's no parameter, so we're adding an item
$itemObj =& $smartsection_item_handler->create();
$itemObj->setVar('uid', $xoopsUser->uid());
$categoryObj =& $smartsection_category_handler->create();
$breadcrumb_action1 = _AM_SSECTION_ITEMS;
$breadcrumb_action2 = _AM_SSECTION_CREATINGNEW;
$button_caption = _AM_SSECTION_CREATE;
$new_status = _SSECTION_STATUS_PUBLISHED;
if ($showmenu) {
smartsection_adminMenu(2, $breadcrumb_action1 . " > " . $breadcrumb_action2);
}
$sel_categoryid = isset($_GET['categoryid']) ? $_GET['categoryid'] : 0;
$categoryObj->setVar('categoryid', $sel_categoryid);
smartsection_collapsableBar('createitemtable', 'createitemicon', _AM_SSECTION_ITEM_CREATING, _AM_SSECTION_ITEM_CREATING_DSC);
}
// ITEM FORM
$sform = new XoopsThemeForm(_AM_SSECTION_ITEMS, "op", xoops_getenv('PHP_SELF'));
$sform->setExtra('enctype="multipart/form-data"');
// CATEGORY
$mytree = new XoopsTree($xoopsDB->prefix("smartsection_categories"), "categoryid", "parentid");
ob_start();
//$sform->addElement(new XoopsFormHidden('categoryid', $categoryObj->categoryid()));
$mytree->makeMySelBox("name", "weight", $categoryObj->categoryid());
$category_label = new XoopsFormLabel(_AM_SSECTION_CATEGORY, ob_get_contents());
$category_label->setDescription(_AM_SSECTION_CATEGORY_DSC);
$sform->addElement($category_label);
ob_end_clean();
// TITLE
$title_text = new XoopsFormText(_AM_SSECTION_TITLE, 'title', 50, 255, $itemObj->title(0, 'e'));
$sform->addElement($title_text, true);
if (SMARTSECTION_LEVEL >= 5) {
// SUMMARY
$summary_text = smartsection_getEditor(_AM_SSECTION_SUMMARY, 'summary', $itemObj->getVar('summary', 'e'));
$summary_text->setDescription(_AM_SSECTION_SUMMARY_DSC);
$sform->addElement($summary_text, false);
// DISPLAY_SUMMARY
$display_summary_radio = new XoopsFormRadioYN(_AM_SSECTION_DISPLAY_SUMMARY, 'display_summary', $itemObj->display_summary(), ' ' . _AM_SSECTION_YES . '', ' ' . _AM_SSECTION_NO . '');
$sform->addElement($display_summary_radio);
}
// BODY
/*if ($itemObj->address()) {
// Main body : pagewrap
$address_select = new XoopsFormSelect(_AM_SSECTION_BODY_SELECTFILE, "address", $itemObj->address());
$address_select->setDescription(_AM_SSECTION_BODY_SELECTFILE_DSC);
$dir = smartsection_getUploadDir(true, 'content');
$folder = dir($dir);
while($file = $folder->read()) {
if ($file != "." && $file != "..") {
$address_select->addOption($file, "".$file."");
}
}
$folder->close();
$sform->addElement($address_select);
$sform->addElement(new XoopsFormHidden('body', ''));
} else {*/
$body_text = smartsection_getEditor(_AM_SSECTION_BODY, 'body', $itemObj->getVar('body', 'e'));
if (SMARTSECTION_LEVEL >= 5) {
$body_text->setDescription(sprintf(_AM_SSECTION_BODY_DSC, SMARTSECTION_URL . "/admin/pagewrap_lookup.php"));
}
$sform->addElement($body_text);
//}
if (SMARTSECTION_LEVEL >= 5) {
// Available pages to wrap
$wrap_pages = XoopsLists::getHtmlListAsArray(smartsection_getUploadDir(true, 'content'));
$available_wrap_pages_text = array();
foreach ($wrap_pages as $page) {
$available_wrap_pages_text[] = "<span onclick='smartsectionPageWrap(\"body\", \"[pagewrap={$page}] \");' onmouseover='style.cursor=\"pointer\"'>{$page}</span>";
}
$available_wrap_pages = new XoopsFormLabel(_AM_SSECTION_AVAILABLE_PAGE_WRAP, implode(', ', $available_wrap_pages_text));
$available_wrap_pages->setDescription(_AM_SSECTION_AVAILABLE_PAGE_WRAP_DSC);
$sform->addElement($available_wrap_pages);
// Tags
if (smartsection_tag_module_included()) {
include_once XOOPS_ROOT_PATH . "/modules/tag/include/formtag.php";
$text_tags = new XoopsFormTag("item_tag", 60, 255, $itemObj->getVar('item_tag', 'e'), 0);
$sform->addElement($text_tags);
}
// IMAGE
$image_array = XoopsLists::getImgListAsArray(smartsection_getImageDir('item'));
$image_select = new XoopsFormSelect('', 'image', $itemObj->image());
//$image_select -> addOption ('-1', '---------------');
$image_select->addOptionArray($image_array);
$image_select->setExtra("onchange='showImgSelected(\"image3\", \"image\", \"" . 'uploads/smartsection/images/item/' . "\", \"\", \"" . XOOPS_URL . "\")'");
$image_tray = new XoopsFormElementTray(_AM_SSECTION_IMAGE_ITEM, ' ');
$image_tray->addElement($image_select);
$image_tray->addElement(new XoopsFormLabel('', "<br /><br /><img src='" . smartsection_getImageDir('item', false) . $itemObj->image() . "' name='image3' id='image3' alt='' />"));
$image_tray->setDescription(_AM_SSECTION_IMAGE_ITEM_DSC);
$sform->addElement($image_tray);
// IMAGE UPLOAD
$max_size = 5000000;
$image_file_box = new XoopsFormFile(_AM_SSECTION_IMAGE_UPLOAD, "image_file", $max_size);
$image_file_box->setExtra("size ='50'");
$image_file_box->setDescription(_AM_SSECTION_IMAGE_UPLOAD_ITEM_DSC);
$sform->addElement($image_file_box);
}
// File upload UPLOAD
$file_box = new XoopsFormFile(smartsection_new_feature_tag() . _AM_SSECTION_ITEM_UPLOAD_FILE, "userfile", 0);
$file_box->setDescription(_AM_SSECTION_ITEM_UPLOAD_FILE_DSC . smartsection_new_feature_tag());
$file_box->setExtra("size ='50'");
$sform->addElement($file_box);
// Uid
/* We need to retreive the users manually because for some reason, on the frxoops.org server,
the method users::getobjects encounters a memory error
*/
$uid = $itemObj->uid();
$uid_select = new XoopsFormSelect(_AM_SSECTION_UID, 'uid', $uid, 1, false);
$uid_select->setDescription(_AM_SSECTION_UID_DSC);
$sql = "SELECT uid, uname FROM " . $xoopsDB->prefix('users') . " ORDER BY uname ASC";
$result = $xoopsDB->query($sql);
$users_array = array();
$users_array[0] = $xoopsConfig['anonymous'];
while ($myrow = $xoopsDB->fetchArray($result)) {
$users_array[$myrow['uid']] = $myrow['uname'];
}
$uid_select->addOptionArray($users_array);
$sform->addElement($uid_select);
// Datesub
$datesub = $itemObj->getVar('datesub') == 0 ? time() : $itemObj->getVar('datesub');
$datesub_datetime = new SmartsectionFormDateTime(_AM_SSECTION_DATESUB, 'datesub', $size = 15, $datesub);
$datesub_datetime->setDescription(_AM_SSECTION_DATESUB_DSC);
$sform->addElement($datesub_datetime);
// STATUS
$options = array(_SSECTION_STATUS_PUBLISHED => _AM_SSECTION_PUBLISHED, _SSECTION_STATUS_OFFLINE => _AM_SSECTION_OFFLINE, _SSECTION_STATUS_SUBMITTED => _AM_SSECTION_SUBMITTED, _SSECTION_STATUS_REJECTED => _AM_SSECTION_REJECTED);
$status_select = new XoopsFormSelect(_AM_SSECTION_STATUS, 'status', $new_status);
$status_select->addOptionArray($options);
$status_select->setDescription(_AM_SSECTION_STATUS_DSC);
$sform->addElement($status_select);
if (SMARTSECTION_LEVEL > 0) {
// Short url
$text_short_url = new XoopsFormText(_AM_SSECTION_ITEM_SHORT_URL, 'short_url', 50, 255, $itemObj->short_url('e'));
$text_short_url->setDescription(_AM_SSECTION_ITEM_SHORT_URL_DSC);
$sform->addElement($text_short_url);
// Meta Keywords
$text_meta_keywords = new XoopsFormTextArea(_AM_SSECTION_ITEM_META_KEYWORDS, 'meta_keywords', $itemObj->meta_keywords('e'), 7, 60);
$text_meta_keywords->setDescription(_AM_SSECTION_ITEM_META_KEYWORDS_DSC);
$sform->addElement($text_meta_keywords);
// Meta Description
$text_meta_description = new XoopsFormTextArea(_AM_SSECTION_ITEM_META_DESCRIPTION, 'meta_description', $itemObj->meta_description('e'), 7, 60);
$text_meta_description->setDescription(_AM_SSECTION_ITEM_META_DESCRIPTION_DSC);
$sform->addElement($text_meta_description);
}
// WEIGHT
$sform->addElement(new XoopsFormText(_AM_SSECTION_WEIGHT, 'weight', 5, 5, $itemObj->weight()), true);
if (SMARTSECTION_LEVEL >= 5) {
// COMMENTS
$addcomments_radio = new XoopsFormRadioYN(_AM_SSECTION_ALLOWCOMMENTS, 'cancomment', $itemObj->cancomment(), ' ' . _AM_SSECTION_YES . '', ' ' . _AM_SSECTION_NO . '');
$sform->addElement($addcomments_radio);
}
// PER ITEM PERMISSIONS
$member_handler =& xoops_gethandler('member');
$group_list = $member_handler->getGroupList();
$groups_checkbox = new XoopsFormCheckBox(_AM_SSECTION_PERMISSIONS_ITEM, 'groups[]', $itemObj->getGroups_read());
$groups_checkbox->setDescription(_AM_SSECTION_PERMISSIONS_ITEM_DSC);
foreach ($group_list as $group_id => $group_name) {
if ($group_id != XOOPS_GROUP_ADMIN) {
$groups_checkbox->addOption($group_id, $group_name);
}
}
$sform->addElement($groups_checkbox);
$p_view_checkbox = new XoopsFormCheckBox(_AM_SSECTION_PARTIAL_VIEW, 'partial_view[]', $itemObj->partial_view());
$p_view_checkbox->setDescription(_AM_SSECTION_PARTIAL_VIEWDSC);
foreach ($group_list as $group_id => $group_name) {
if ($group_id != XOOPS_GROUP_ADMIN) {
$p_view_checkbox->addOption($group_id, $group_name);
}
}
$sform->addElement($p_view_checkbox);
/*$partial_view_radio = new XoopsFormRadioYN(_AM_SSECTION_PARTIAL_VIEW, 'partial_view', $itemObj->partial_view(), ' ' . _AM_SSECTION_YES . '', ' ' . _AM_SSECTION_NO . '');
$partial_view_radio->setDescription(_AM_SSECTION_PARTIAL_VIEWDSC);
$sform->addElement($partial_view_radio);*/
if (SMARTSECTION_LEVEL >= 5) {
// VARIOUS OPTIONS
$options_tray = new XoopsFormElementTray(_AM_SSECTION_OPTIONS, '<br />');
$html_checkbox = new XoopsFormCheckBox('', 'dohtml', $itemObj->dohtml());
$html_checkbox->addOption(1, _AM_SSECTION_DOHTML);
$options_tray->addElement($html_checkbox);
$smiley_checkbox = new XoopsFormCheckBox('', 'dosmiley', $itemObj->dosmiley());
$smiley_checkbox->addOption(1, _AM_SSECTION_DOSMILEY);
$options_tray->addElement($smiley_checkbox);
$xcodes_checkbox = new XoopsFormCheckBox('', 'doxcode', $itemObj->doxcode());
$xcodes_checkbox->addOption(1, _AM_SSECTION_DOXCODE);
$options_tray->addElement($xcodes_checkbox);
$images_checkbox = new XoopsFormCheckBox('', 'doimage', $itemObj->doimage());
$images_checkbox->addOption(1, _AM_SSECTION_DOIMAGE);
$options_tray->addElement($images_checkbox);
$linebreak_checkbox = new XoopsFormCheckBox('', 'dobr', $itemObj->dobr());
$linebreak_checkbox->addOption(1, _AM_SSECTION_DOLINEBREAK);
$options_tray->addElement($linebreak_checkbox);
$sform->addElement($options_tray);
}
// item ID
if ($clone) {
$itemid = 0;
}
$sform->addElement(new XoopsFormHidden('itemid', $itemid));
$button_tray = new XoopsFormElementTray('', '');
$hidden = new XoopsFormHidden('op', 'additem');
$button_tray->addElement($hidden);
if (!$itemid) {
// there's no itemid? Then it's a new item
// $button_tray -> addElement( new XoopsFormButton( '', 'mod', _AM_SSECTION_CREATE, 'submit' ) );
$butt_create = new XoopsFormButton('', '', _AM_SSECTION_CREATE, 'submit');
$butt_create->setExtra('onclick="this.form.elements.op.value=\'additem\'"');
$button_tray->addElement($butt_create);
$butt_clear = new XoopsFormButton('', '', _AM_SSECTION_CLEAR, 'reset');
$button_tray->addElement($butt_clear);
$butt_cancel = new XoopsFormButton('', '', _AM_SSECTION_CANCEL, 'button');
$butt_cancel->setExtra('onclick="history.go(-1)"');
$button_tray->addElement($butt_cancel);
$sform->addElement($button_tray);
$sform->display();
smartsection_close_collapsable('createitemtable', 'createitemicon');
} else {
// else, we're editing an existing item
// $button_tray -> addElement( new XoopsFormButton( '', 'mod', _AM_SSECTION_MODIFY, 'submit' ) );
$butt_create = new XoopsFormButton('', '', $button_caption, 'submit');
$butt_create->setExtra('onclick="this.form.elements.op.value=\'additem\'"');
$button_tray->addElement($butt_create);
$butt_cancel = new XoopsFormButton('', '', _AM_SSECTION_CANCEL, 'button');
$butt_cancel->setExtra('onclick="history.go(-1)"');
$button_tray->addElement($butt_cancel);
$sform->addElement($button_tray);
$sform->display();
smartsection_close_collapsable('edititemtable', 'edititemicon');
}
if (SMARTSECTION_LEVEL >= 5) {
smartsection_collapsableBar('pagewraptable', 'pagewrapicon', _AM_SSECTION_PAGEWRAP, _AM_SSECTION_PAGEWRAPDSC);
$dir = smartsection_getUploadDir(true, 'content');
if (!eregi("777", decoct(fileperms($dir)))) {
echo "<font color='FF0000'><h4>" . _AM_SSECTION_PERMERROR . "</h4></font>";
}
// Upload File
echo "<form name='form_name2' id='form_name2' action='pw_upload_file.php' method='post' enctype='multipart/form-data'>";
echo "<table cellspacing='1' width='100%' class='outer'>";
echo "<tr><th colspan='2'>" . _AM_SSECTION_UPLOAD_FILE . "</th></tr>";
echo "<tr valign='top' align='left'><td class='head'>" . _AM_SSECTION_SEARCH_PW . "</td><td class='even'><input type='file' name='fileupload' id='fileupload' size='30' /></td></tr>";
echo "<tr valign='top' align='left'><td class='head'><input type='hidden' name='MAX_FILE_SIZE' id='op' value='500000' /></td><td class='even'><input type='submit' name='submit' value='" . _AM_SSECTION_UPLOAD . "' /></td></tr>";
echo "<input type='hidden' name='backto' value='{$smartsection_current_page}'/>";
echo "</table>";
echo "</form>";
// Delete File
$form = new XoopsThemeForm(_AM_SSECTION_DELETEFILE, "form_name", "pw_delete_file.php");
$pWrap_select = new XoopsFormSelect(smartsection_getUploadDir(true, 'content'), "address");
$folder = dir($dir);
while ($file = $folder->read()) {
if ($file != "." && $file != "..") {
$pWrap_select->addOption($file, $file);
}
}
$folder->close();
$form->addElement($pWrap_select);
$delfile = "delfile";
$form->addElement(new XoopsFormHidden('op', $delfile));
$submit = new XoopsFormButton("", "submit", _AM_SSECTION_BUTTON_DELETE, "submit");
$form->addElement($submit);
$form->addElement(new XoopsFormHidden('backto', $smartsection_current_page));
$form->display();
smartsection_close_collapsable('pagewraptable', 'pagewrapicon');
}
unset($hidden);
if ($itemid != 0) {
showfiles($itemObj);
}
}
