however i´m still facing problems. Now I can´t assign an article to a column (author)
Just in case, here follows the whole "admin/article.php" file without the nice fix you´ve provided:
<?php /** * $Id: article.php v 1.5 25 April 2004 hsalazar Exp $ * Module: Soapbox * Version: v 1.5 * Release Date: 25 April 2004 * Author: hsalazar * Licence: GNU */ // -- General Stuff -- // include( "admin_header.php" ); $op = ''; foreach ( $_POST as $k => $v ) { ${$k} = $v; } foreach ( $_GET as $k => $v ) { ${$k} = $v; } if ( isset( $_GET['op'] ) ) $op = $_GET['op']; if ( isset( $_POST['op'] ) ) $op = $_POST['op']; // -- Edit function -- // function editarticle( $articleID = '' ) { global $xoopsUser, $xoopsUser, $xoopsConfig, $xoopsDB, $modify, $xoopsModuleConfig, $xoopsModule, $XOOPS_URL; include_once XOOPS_ROOT_PATH . '/class/xoopsformloader.php'; /** * Clear all variables before we start */ if(!isset($block)) { $block = 1; } if(!isset($html)) { $html = 1; } else { $html = intval($html); } if(!isset($smiley)) { $smiley = 1; } else { $smiley = intval($smiley); } if(!isset($xcodes)) { $xcodes = 1; } else { $xcodes = intval($xcodes); } if(!isset($breaks)) { $breaks = 1; } else { $breaks = intval($breaks); } if(!isset($weight)) { $weight = 1; } if(!isset($comments)) { $comments = 1; } if(!isset($offline)) { $offline = 0; } if(!isset($votes)) { $votes = 0; } if(!isset($rating)) { $rating = 0.00; } if(!isset($columnID)) { $columnID = 1; } if(!isset($headline)) { $headline = ""; } if(!isset($lead)) { $lead = ""; } if(!isset($bodytext)) { $bodytext = ""; } if(!isset($teaser)) { $teaser = ""; } if(!isset($title)) { $title = ""; } $artimage = "blank.png"; // If there is a parameter, and the id exists, retrieve data: we're editing an article if ( $articleID ) { $result = $xoopsDB -> query( "SELECT columnID, headline, lead, bodytext, teaser, weight, html, smiley, xcodes, breaks, block, artimage, votes, rating, comments, offline FROM " . $xoopsDB -> prefix( "sbarticles" ) . " WHERE articleID = '$articleID'" ); list( $columnID, $headline, $lead, $bodytext, $teaser, $weight, $html, $smiley, $xcodes, $breaks, $block, $artimage, $votes, $rating, $comments, $offline ) = $xoopsDB -> fetchrow( $result ); if ( !$xoopsDB -> getRowsNum( $result ) ) { redirect_header( "index.php", 1, _AM_SB_NOARTTOEDIT ); exit(); } adminMenu(2, _AM_SB_ARTS._AM_SB_EDITING.$headline."'"); echo "<h3 style='color: #2F5376; '>" . _AM_SB_ADMINARTMNGMT . "</h5>"; $sform = new XoopsThemeForm( _AM_SB_MODART . ": $headline" , "op", xoops_getenv( 'PHP_SELF' ) ); } else // there's no parameter, so we're adding an article { $result01 = $xoopsDB -> query( "SELECT COUNT(*) FROM " . $xoopsDB -> prefix( "sbcolumns" ) . " " ); list( $totalcolumns ) = $xoopsDB -> fetchRow( $result01 ); if ( $totalcolumns == 0 ) { redirect_header( "index.php", 1, _AM_SB_NEEDONECOLUMN ); exit(); } adminMenu(2, _AM_SB_ARTS._AM_SB_CREATINGART); echo "<h3 style='color: #2F5376; '>" . _AM_SB_ADMINARTMNGMT . "</h5>"; $sform = new XoopsThemeForm( _AM_SB_NEWART, "op", xoops_getenv( 'PHP_SELF' ) ); } $sform -> setExtra( 'enctype="multipart/form-data"' ); // COLUMN /* * Get information for pulldown menu using XoopsTree. * First var is the database table * Second var is the unique field ID for the categories * Last one is not set as we do not have sub menus in WF-FAQ */ $mytree = new XoopsTree( $xoopsDB->prefix( "sbcolumns" ), "columnID" , "0" ); ob_start(); $sform -> addElement( new XoopsFormHidden( 'columnID', $columnID ) ); $mytree -> makeMySelBox( "name", "name", $columnID ); $sform -> addElement( new XoopsFormLabel( _AM_SB_COLNAME, ob_get_contents() ) ); ob_end_clean(); // HEADLINE, LEAD, BODYTEXT // This part is common to edit/add $sform -> addElement( new XoopsFormText( _AM_SB_ARTHEADLINE, 'headline', 50, 80, $headline ), true ); $sform -> addElement( new XoopsFormTextArea( _AM_SB_ARTLEAD, 'lead', $lead, 5, 60 ) ); // TEASER $sform -> addElement( new XoopsFormTextArea( _AM_SB_ARTTEASER, 'teaser', $teaser, 5, 60 ) ); $autoteaser_radio = new XoopsFormRadioYN( _AM_SB_AUTOTEASER, 'autoteaser', 0, ' ' . _AM_SB_YES . '', ' ' . _AM_SB_NO . '' ); $sform -> addElement( $autoteaser_radio ); $sform -> addElement( new XoopsFormText( _AM_SB_AUTOTEASERAMOUNT, 'teaseramount', 4, 4, 100 ) ); // BODY $sform -> addElement( new XoopsFormDhtmlTextArea( _AM_SB_ARTBODY, 'bodytext', $bodytext, 15, 60 ) ); // IMAGE // The article CAN have its own image :) // First, if the article's image doesn't exist, set its value to the blank file if (!file_exists(XOOPS_ROOT_PATH . "/" . $xoopsModuleConfig['sbuploaddir'] . "/" . $artimage) || !$artimage) { $artimage = "blank.png"; } // Code to create the image selector $graph_array = & XoopsLists :: getImgListAsArray( XOOPS_ROOT_PATH . "/" . $xoopsModuleConfig['sbuploaddir'] ); $artimage_select = new XoopsFormSelect( '', 'artimage', $artimage ); $artimage_select -> addOptionArray( $graph_array ); $artimage_select -> setExtra( "onchange='showImgSelected("image5", "artimage", "" . $xoopsModuleConfig['sbuploaddir'] . "", "", "" . XOOPS_URL . "")'" ); $artimage_tray = new XoopsFormElementTray( _AM_SB_SELECT_IMG, ' ' ); $artimage_tray -> addElement( $artimage_select ); $artimage_tray -> addElement( new XoopsFormLabel( '', "<br /><br /><img src='" . XOOPS_URL . "/" . $xoopsModuleConfig['sbuploaddir'] . "/" . $artimage . "' name='image5' id='image5' alt='' />" ) ); $sform -> addElement( $artimage_tray ); // Code to call the file browser to select an image to upload $sform -> addElement( new XoopsFormFile( _AM_SB_UPLOADIMAGE, 'cimage', $xoopsModuleConfig['maxfilesize'] ), false ); // COMMENTS // Code to allow comments $addcomments_radio = new XoopsFormRadioYN( _AM_SB_ALLOWCOMMENTS, 'comments', $comments, ' ' . _AM_SB_YES . '', ' ' . _AM_SB_NO . '' ); $sform -> addElement( $addcomments_radio ); // OFFLINE // Code to take article offline, for maintenance purposes $offline_radio = new XoopsFormRadioYN(_AM_SB_SWITCHOFFLINE, 'offline', $offline, ' '._AM_SB_YES.'', ' '._AM_SB_NO.''); $sform -> addElement($offline_radio); // ARTICLE IN BLOCK // Code to put article in block $block_radio = new XoopsFormRadioYN( _AM_SB_BLOCK, 'block', $block , ' ' . _AM_SB_YES . '', ' ' . _AM_SB_NO . '' ); $sform -> addElement( $block_radio ); // VARIOUS OPTIONS $options_tray = new XoopsFormElementTray(_AM_SB_OPTIONS,'<br />'); $html_checkbox = new XoopsFormCheckBox( '', 'html', $html ); $html_checkbox -> addOption( 1, _AM_SB_DOHTML ); $options_tray -> addElement( $html_checkbox ); $smiley_checkbox = new XoopsFormCheckBox( '', 'smiley', $smiley ); $smiley_checkbox -> addOption( 1, _AM_SB_DOSMILEY ); $options_tray -> addElement( $smiley_checkbox ); $xcodes_checkbox = new XoopsFormCheckBox( '', 'xcodes', $xcodes ); $xcodes_checkbox -> addOption( 1, _AM_SB_DOXCODE ); $options_tray -> addElement( $xcodes_checkbox ); $breaks_checkbox = new XoopsFormCheckBox( '', 'breaks', $breaks ); $breaks_checkbox -> addOption( 1, _AM_SB_BREAKS ); $options_tray -> addElement( $breaks_checkbox ); $sform -> addElement( $options_tray ); $sform -> addElement( new XoopsFormHidden( 'articleID', $articleID ) ); $button_tray = new XoopsFormElementTray( '', '' ); $hidden = new XoopsFormHidden( 'op', 'addart' ); $button_tray -> addElement( $hidden ); if ( !$articleID ) // there's no articleID? Then it's a new article { $butt_create = new XoopsFormButton( '', '', _AM_SB_CREATE, 'submit' ); $butt_create->setExtra('onclick="this.form.elements.op.value='addart'"'); $button_tray->addElement( $butt_create ); $butt_clear = new XoopsFormButton( '', '', _AM_SB_CLEAR, 'reset' ); $button_tray->addElement( $butt_clear ); $butt_cancel = new XoopsFormButton( '', '', _AM_SB_CANCEL, 'button' ); $butt_cancel->setExtra('onclick="history.go(-1)"'); $button_tray->addElement( $butt_cancel ); } else // else, we're editing an existing article { $butt_create = new XoopsFormButton( '', '', _AM_SB_MODIFY, 'submit' ); $butt_create->setExtra('onclick="this.form.elements.op.value='addart'"'); $button_tray->addElement( $butt_create ); $butt_cancel = new XoopsFormButton( '', '', _AM_SB_CANCEL, 'button' ); $butt_cancel->setExtra('onclick="history.go(-1)"'); $button_tray->addElement( $butt_cancel ); } $sform -> addElement( $button_tray ); $sform -> display(); unset( $hidden ); } /* -- Available operations -- */ switch ( $op ) { case "mod": xoops_cp_header(); $articleID = isset( $_POST['articleID'] ) ? intval( $_POST['articleID'] ) : intval( $_GET['articleID'] ); editarticle($articleID); break; case "addart": // global $xoopsUser, $xoopsUser, $xoopsConfig, $xoopsDB, $xoopsModuleConfig ; $articleID = (isset($_POST['articleID'])) ? intval($_POST['articleID']) : 0; $columnID = (isset($_POST['columnID'])) ? intval($_POST['columnID']) : 0; $block = (isset($_POST['block'])) ? intval($_POST['block']) : 1; $offline = (isset($_POST['offline'])) ? intval($_POST['offline']) : 0; $breaks = (isset($_POST['breaks'])) ? intval($_POST['breaks']) : 0; $comments = isset( $comments ) ? intval( $comments ) : 0; $html = isset( $html ) ? intval( $html ) : 0; $smiley = isset( $smiley ) ? intval( $smiley ) : 0; $xcodes = isset( $xcodes ) ? intval( $xcodes ) : 0; $weight = (isset($_POST['weight'])) ? intval($_POST['weight']) : 1; $artimage = ($_POST['artimage'] != 'blank.png' ) ? $myts -> addSlashes($_POST['artimage']) : ''; $headline = $myts -> htmlSpecialChars($_POST['headline']); $lead = $myts -> addSlashes($_POST['lead']); $bodytext = $myts -> addSlashes($_POST['bodytext']); $votes = (isset($_POST['votes'])) ? intval($_POST['votes']) : 0; $rating = (isset($_POST['rating'])) ? intval($_POST['rating']) : 0.00; if ( $_POST['autoteaser'] ) { $charlength = $_POST['teaseramount']; $teasertemp = $_POST['bodytext']; if ( !XOOPS_USE_MULTIBYTES ) { $teasertemp = strip_tags( $teasertemp, '' ); $teasertemp = $myts -> addSlashes( substr( $teasertemp, 0, ( $charlength -1 ) ) ) . "..."; } $teaser = $teasertemp; } else { $teaser = $myts -> addSlashes( $_POST['teaser'] ); } $date = time(); // ARTICLE IMAGE // Define variables $error = 0; $word = null; $uid = $xoopsUser -> uid(); $submit = 1; $date = time(); if ( $HTTP_POST_FILES['cimage']['name'] != "" ) { include_once XOOPS_ROOT_PATH . '/class/uploader.php'; if ( file_exists( XOOPS_ROOT_PATH . "/" . $xoopsModuleConfig['sbuploaddir'] . "/" . $HTTP_POST_FILES['cimage']['name'] ) ) { redirect_header( "index.php", 1, _AM_SB_FILEEXISTS ); } $allowed_mimetypes = array( 'image/gif', 'image/jpeg', 'image/pjpeg', 'image/png' ); uploading($allowed_mimetypes, $HTTP_POST_FILES['cimage']['name'], "index.php", 0, $xoopsModuleConfig['sbuploaddir']); $artimage = $HTTP_POST_FILES['cimage']['name']; } elseif ($_POST["artimage"] != "blank.png") { $artimage = $myts -> addSlashes( $_POST["artimage"] ); } else { $artimage = ''; } // Save to database if ( !$articleID ) { if ( $xoopsDB -> query( "INSERT INTO " . $xoopsDB -> prefix( "sbarticles" ) . " (articleID, columnID, headline, lead, bodytext, teaser, weight, html, smiley, xcodes, breaks, block, artimage, votes, rating, comments, offline, datesub ) VALUES ('', '$columnID', '$headline', '$lead', '$bodytext', '$teaser', '$weight', '$html', '$smiley', '$xcodes', '$breaks', '$block', '$artimage', '$votes', '$rating', '$comments', '$offline', '$date' )" ) ) { $xoopsDB =& Database::getInstance(); $newid = mysql_insert_id(); $result = $xoopsDB -> query( "SELECT columnID FROM " . $xoopsDB -> prefix( "sbarticles" ) . " WHERE articleID = '$newid'" ); list($columnID) = $xoopsDB -> fetchrow($result); $result = $xoopsDB -> query( "SELECT name, total FROM " . $xoopsDB -> prefix( "sbcolumns" ) . " WHERE colid = '$columnID'" ); list( $name, $total ) = $xoopsDB -> fetchrow( $result ); $total++; $tags = array(); $tags['ARTICLE_NAME'] = $headline; $tags['ARTICLE_URL'] = XOOPS_URL . '/modules/' . $xoopsModule -> getVar( 'dirname' ) . '/index.php?art&lid=' . $newid; $tags['COLUMN_NAME'] = $name; $tags['COLUMN_URL'] = XOOPS_URL . '/modules/' . $xoopsModule -> getVar( 'dirname' ) . '/index.php?op=col&columnID=' . $columnID; $notification_handler = & xoops_gethandler( 'notification' ); $notification_handler -> triggerEvent( 'global', 0, 'new_article', $tags ); $notification_handler -> triggerEvent( 'category', $columnID, 'new_article', $tags ); if ( $xoopsDB -> queryF( "UPDATE " . $xoopsDB -> prefix( "sbcolumns" ) . " SET total = '$total' WHERE columnID = '$columnID'" ) ) redirect_header( "index.php", 1, _AM_SB_ARTCREATEDOK ); } else { redirect_header( "index.php", 1, _AM_SB_ARTNOTCREATED ); } } else // That is, $articleID exists, thus we're editing an article { if ( $xoopsDB -> query( "UPDATE " . $xoopsDB -> prefix( "sbarticles" ) . " SET columnID = '$columnID', headline = '$headline', lead = '$lead', bodytext = '$bodytext', teaser = '$teaser', weight = '$weight', html = '$html', smiley = '$smiley', xcodes = '$xcodes', breaks = '$breaks', block = '$block', artimage = '$artimage', votes = '$votes', rating = '$rating', comments = '$comments', offline = '$offline', datesub = '$date' WHERE articleID = '$articleID'" ) ) { redirect_header( "index.php", 1, _AM_SB_ARTMODIFIED ); } else { redirect_header( "index.php", 1, _AM_SB_ARTNOTUPDATED ); } } exit(); break; case "del": Global $xoopsUser, $xoopsUser, $xoopsConfig, $xoopsDB; $confirm = ( isset( $confirm ) ) ? 1 : 0; if ( $confirm ) { $xoopsDB->query( "DELETE FROM " . $xoopsDB->prefix( "sbarticles" ) . " WHERE articleID = $articleID" ); xoops_comment_delete($xoopsModule->getVar('mid'), $articleID); redirect_header( "index.php", 1, sprintf( _AM_SB_ARTISDELETED, $headline ) ); exit(); } else { $articleID = ( isset( $_POST['articleID'] ) ) ? intval($_POST['articleID']) : intval($articleID); $result = $xoopsDB -> query( "SELECT articleID, headline FROM " . $xoopsDB -> prefix( "sbarticles" ) . " WHERE articleID = $articleID" ); list( $articleID, $headline ) = $xoopsDB -> fetchrow( $result ); xoops_cp_header(); xoops_confirm( array( 'op' => 'del', 'articleID' => $articleID, 'confirm' => 1, 'headline' => $headline ), 'article.php', _AM_SB_DELETETHISARTICLE . "<br /><br>" . $headline, _AM_SB_DELETE ); xoops_cp_footer(); } exit(); break; case "default": default: xoops_cp_header(); include_once XOOPS_ROOT_PATH . "/class/xoopsformloader.php"; global $xoopsUser, $xoopsUser, $xoopsConfig, $xoopsDB, $xoopsModuleConfig, $xoopsModule; $myts =& MyTextSanitizer::getInstance(); editarticle(); showArticles (0); break; } xoops_cp_footer(); ?>
<?php /** * $Id: column.php v 1.5 25 April 2004 hsalazar Exp $ * Module: Soapbox * Version: v 1.5 * Release Date: 25 April 2004 * Author: hsalazar * Licence: GNU */ // -- General Stuff -- // include( "admin_header.php" ); $op = ''; foreach ( $_POST as $k => $v ) { ${$k} = $v; } foreach ( $_GET as $k => $v ) { ${$k} = $v; } if ( isset( $_GET['op'] ) ) $op = $_GET['op']; if ( isset( $_POST['op'] ) ) $op = $_POST['op']; function editcol( $columnID = '' ) { $weight = 1; $name = ''; $author = ''; $description = ''; $colimage = 'blank.png'; Global $xoopsUser, $xoopsUser, $xoopsConfig, $xoopsDB, $modify, $xoopsModuleConfig, $xoopsModule, $_GET; include_once XOOPS_ROOT_PATH . '/class/xoopsformloader.php'; // If there is a parameter, and the id exists, retrieve data: we're editing a column if ( $columnID ) { $result = $xoopsDB -> query( "SELECT columnID, author, name, description, total, weight, colimage, created FROM " . $xoopsDB -> prefix( "sbcolumns" ) . " WHERE columnID = '$columnID'" ); list( $columnID, $author, $name, $description, $total, $weight, $colimage, $created ) = $xoopsDB -> fetchrow( $result ); if ( $xoopsDB -> getRowsNum( $result ) == 0 ) { redirect_header( "column.php", 1, _AM_SB_NOCOLTOEDIT ); exit(); } xoops_cp_header(); adminMenu(1, _AM_SB_COLS._AM_SB_EDITING.$name."'"); echo "<h3 style='color: #2F5376; '>" . _AM_SB_ADMINCOLMNGMT . "</h3>"; $sform = new XoopsThemeForm( _AM_SB_MODCOL . ": $name" , "op", xoops_getenv( 'PHP_SELF' ) ); } else { xoops_cp_header(); adminMenu(1, _AM_SB_COLS._AM_SB_CREATINGCOL); echo "<h3 style='color: #2F5376; '>" . _AM_SB_ADMINCOLMNGMT . "</h3>"; $sform = new XoopsThemeForm( _AM_SB_NEWCOL, "op", xoops_getenv( 'PHP_SELF' ) ); } $sform -> setExtra( 'enctype="multipart/form-data"' ); $sform -> addElement( new XoopsFormText( _AM_SB_COLNAME, 'name', 50, 80, stripslashes($name) ), true ); // Selector to get author if (is_numeric($author)) { $authorinput = ''; } else { $authorinput = $author; } ob_start(); getuserForm( intval($author) ); $sform -> addElement( new XoopsFormLabel( _AM_SB_AUTHOR, ob_get_contents() ) ); ob_end_clean(); $sform -> addElement( new XoopsFormTextArea( _AM_SB_COLDESCRIPT, 'description', $description, 7, 60 ) ); $sform -> addElement( new XoopsFormText( _AM_SB_COLPOSIT, 'weight', 4, 4, $weight ) ); if ( !$colimage ) $colimage = "nopicture.png"; $graph_array = & XoopsLists :: getImgListAsArray( XOOPS_ROOT_PATH . "/" . $xoopsModuleConfig['sbuploaddir'] ); $colimage_select = new XoopsFormSelect( '', 'colimage', $colimage ); $colimage_select -> addOptionArray( $graph_array ); $colimage_select -> setExtra( "onchange='showImgSelected("image3", "colimage", "" . $xoopsModuleConfig['sbuploaddir'] . "", "", "" . XOOPS_URL . "")'" ); $colimage_tray = new XoopsFormElementTray( _AM_SB_COLIMAGE, ' ' ); $colimage_tray -> addElement( $colimage_select ); $colimage_tray -> addElement( new XoopsFormLabel( '', "<br /><br /><img src='" . XOOPS_URL . "/" . $xoopsModuleConfig['sbuploaddir'] . "/" . $colimage . "' name='image3' id='image3' alt='' />" ) ); $sform -> addElement( $colimage_tray ); // Code to call the file browser to select an image to upload $sform -> addElement( new XoopsFormFile( _AM_SB_COLIMAGEUPLOAD, 'cimage', $xoopsModuleConfig['maxfilesize'] ), false ); $sform -> addElement( new XoopsFormHidden( 'columnID', $columnID ) ); $button_tray = new XoopsFormElementTray( '', '' ); $hidden = new XoopsFormHidden( 'op', 'addcol' ); $button_tray -> addElement( $hidden ); // No ID for column -- then it's new column, button says 'Create' if ( !$columnID ) { $butt_create = new XoopsFormButton( '', '', _AM_SB_CREATE, 'submit' ); $butt_create->setExtra('onclick="this.form.elements.op.value='addcol'"'); $button_tray->addElement( $butt_create ); $butt_clear = new XoopsFormButton( '', '', _AM_SB_CLEAR, 'reset' ); $button_tray->addElement( $butt_clear ); $butt_cancel = new XoopsFormButton( '', '', _AM_SB_CANCEL, 'button' ); $butt_cancel->setExtra('onclick="history.go(-1)"'); $button_tray->addElement( $butt_cancel ); } else // button says 'Update' { $butt_create = new XoopsFormButton( '', '', _AM_SB_MODIFY, 'submit' ); $butt_create->setExtra('onclick="this.form.elements.op.value='addcol'"'); $button_tray->addElement( $butt_create ); $butt_cancel = new XoopsFormButton( '', '', _AM_SB_CANCEL, 'button' ); $butt_cancel->setExtra('onclick="history.go(-1)"'); $button_tray->addElement( $butt_cancel ); } $sform -> addElement( $button_tray ); $sform -> display(); unset( $hidden ); } switch ( $op ) { case "mod": $columnID = isset( $_POST['columnID'] ) ? intval( $_POST['columnID'] ) : intval( $_GET['columnID'] ); editcol( $columnID ); break; case "addcol": Global $xoopsUser, $xoopsUser, $xoopsConfig, $xoopsDB, $modify, $myts, $columnID; if ( isset( $_POST['columnID'] ) ) $columnID = $_POST['columnID']; if ( ( $_POST['weight'] ) && is_numeric( $_POST['weight'] ) ) { $weight = $myts -> addSlashes( $_POST['weight'] ); } else { $weight = 1; } $name = $myts -> htmlSpecialChars( $_POST['name'] ); $description = $myts -> addslashes( $_POST['description'] ); $description = $myts->xoopsCodeDecode($description, $allowimage = 1); if ($_POST['author'] == '-1') { $author = $myts->makeTboxData4Save($_POST['authorinput']); } else { $author = $myts->makeTboxData4Save($_POST['author']); } if ( $HTTP_POST_FILES['cimage']['name'] != "" ) { if ( file_exists( XOOPS_ROOT_PATH . "/" . $xoopsModuleConfig['sbuploaddir'] . "/" . $HTTP_POST_FILES['cimage']['name'] ) ) { redirect_header( "column.php", 1, _AM_SB_FILEEXISTS ); } $allowed_mimetypes = array( 'image/gif', 'image/jpeg', 'image/pjpeg', 'image/png' ); uploading( $allowed_mimetypes, $HTTP_POST_FILES['cimage']['name'], "index.php", 0, $xoopsModuleConfig['sbuploaddir'] ); $colimage = $HTTP_POST_FILES['cimage']['name']; } elseif ( $_POST["colimage"] != "blank.png" ) { $colimage = $myts -> addSlashes( $_POST["colimage"] ); } else { $colimage = ''; } // Run the query and update the data if ( !$_POST['columnID'] ) { if ( $xoopsDB -> query( "INSERT INTO " . $xoopsDB -> prefix( "sbcolumns" ) . " (columnID, name, author, description, weight, total, colimage) VALUES ('', '$name', '$author', '$description', '$weight', '0', '$colimage')" ) ) { redirect_header( "permissions.php", 1, _AM_SB_COLCREATED ); $newid = $xoopsDB -> getInsertId(); // Notify of new column global $xoopsModule; $tags = array(); $tags['COLUMN_NAME'] = $name; $tags['COLUMN_URL'] = XOOPS_URL . '/modules/' . $xoopsModule -> getVar( 'dirname' ) . '/index.php?op=col&columnID=' . $newid; $notification_handler = & xoops_gethandler( 'notification' ); $notification_handler -> triggerEvent( 'global', 0, 'new_column', $tags ); } else { redirect_header( "index.php", 1, _AM_SB_NOTUPDATED ); } } else { if ( $xoopsDB -> queryF( "UPDATE " . $xoopsDB -> prefix( "sbcolumns" ) . " SET name = '$name', author = '$author', description = '$description', weight = '$weight', colimage = '$colimage' WHERE columnID = '$columnID'" ) ) { redirect_header( "index.php", 1, _AM_SB_COLMODIFIED ); } else { redirect_header( "index.php", 1, _AM_SB_NOTUPDATED ); } } exit(); break; case "del": global $xoopsUser, $xoopsUser, $xoopsConfig, $xoopsDB; $groups = ( $xoopsUser ) ? $xoopsUser -> getGroups() : XOOPS_GROUP_ANONYMOUS; $module_id = $xoopsModule -> getVar( 'mid' ); $gperm_handler = & xoops_gethandler( 'groupperm' ); $confirm = ( isset( $confirm ) ) ? 1 : 0; if ( $confirm ) { $xoopsDB -> query( "DELETE FROM " . $xoopsDB -> prefix( "sbcolumns" ) . " WHERE columnID = '$columnID'" ); $xoopsDB -> query( "DELETE FROM " . $xoopsDB -> prefix( "sbarticles" ) . " WHERE columnID = '$columnID'" ); xoops_groupperm_deletebymoditem ($module_id, _AM_SB_COLPERMS, $columnID); redirect_header( "index.php", 1, sprintf( _AM_SB_COLISDELETED, $name ) ); exit(); } else { $columnID = ( isset( $_POST['columnID'] ) ) ? $_POST['columnID'] : $columnID; $result = $xoopsDB -> query( "SELECT columnID, name FROM " . $xoopsDB -> prefix( "sbcolumns" ) . " WHERE columnID = '$columnID'" ); list( $colid, $name ) = $xoopsDB -> fetchrow( $result ); xoops_cp_header(); xoops_confirm( array( 'op' => 'del', 'columnID' => $columnID, 'confirm' => 1, 'name' => $name ), 'column.php', _AM_SB_DELETETHISCOL . "<br /><br>" . $name, _AM_SB_DELETE ); xoops_cp_footer(); } exit(); break; case "cancel": redirect_header( "index.php", 1, sprintf( _AM_SB_BACK2IDX, '' ) ); exit(); case "default": default: editcol(); showColumns( 0 ); break; } xoops_cp_footer(); ?>
