function MG_saveEnroll()
{
global $_CONF, $_MG_CONF, $_MG_USERPREFS, $_TABLES, $_USER, $LANG_MG03;
if ($_MG_CONF['member_albums'] != 1) {
echo COM_refresh($_MG_CONF['site_url'] . '/index.php');
exit;
}
if (!isset($_MG_CONF['member_quota'])) {
$_MG_CONF['member_quota'] = 0;
}
$sql = "SELECT album_id FROM {$_TABLES['mg_albums']} WHERE owner_id=" . (int) $_USER['uid'] . " AND album_parent=" . $_MG_CONF['member_album_root'];
$result = DB_query($sql);
$nRows = DB_numRows($result);
if ($nRows > 0) {
$display = MG_siteHeader();
$display .= COM_showMessageText($LANG_MG03['existing_member_album'], '', true);
$display .= MG_siteFooter();
echo $display;
exit;
}
$uid = (int) $_USER['uid'];
$aid = plugin_user_create_mediagallery($uid, 1);
$result = DB_query("UPDATE {$_TABLES['mg_userprefs']} SET member_gallery=1,quota=" . $_MG_CONF['member_quota'] . " WHERE uid=" . $uid, 1);
$affected = DB_affectedRows($result);
if (DB_error()) {
$sql = "INSERT INTO {$_TABLES['mg_userprefs']} (uid, active, display_rows, display_columns, mp3_player, playback_mode, tn_size, quota, member_gallery) VALUES (" . $uid . ",1,0,0,-1,-1,-1," . $_MG_CONF['member_quota'] . ",1)";
DB_query($sql, 1);
}
CACHE_remove_instance('menu');
echo COM_refresh($_MG_CONF['site_url'] . '/album.php?aid=' . $aid);
exit;
}
if (DB_error()) {
$msg = $LANG_CLASSIFIEDS_2['save_fail'];
} else {
$msg = $LANG_CLASSIFIEDS_2['deletion_succes'];
if (function_exists('CLASSIFIEDS_emailDeleteAd')) {
CLASSIFIEDS_emailDeleteAd(stripslashes($A['title']), '', $_REQUEST['ad'], $_USER['uid'], $A['price']);
}
}
echo COM_refresh($_CLASSIFIEDS_CONF['site_url'] . "/index.php?mode=my&msg={$msg}");
exit;
}
break;
case 'delete':
if (SEC_hasRights('classifieds.admin')) {
DB_delete($_TABLES['cl'], 'clid', $_REQUEST['clid']);
if (DB_affectedRows('') == 1) {
$msg = $LANG_CLASSIFIEDS_2['deletion_succes'];
} else {
$msg = $LANG_CLASSIFIEDS_2['deletion_fail'];
}
// delete complete, return to ad list
echo COM_refresh($_CONF['site_url'] . "/admin/plugins/classifieds/index.php?msg={$msg}");
}
exit;
break;
case 'save':
$missingfields = CLASSIFIEDS_missingField($_REQUEST);
if ($missingfields != '') {
$display .= COM_startBlock($LANG_CLASSIFIEDS_2['error']);
$display .= $LANG_CLASSIFIEDS_2['missing_field'];
$display .= '<ul>';
function CMT_updateCommentcodes()
{
global $_CONF, $_TABLES;
$cleared = 0;
if ($_CONF['comment_close_rec_stories'] > 0) {
$results = DB_query("SELECT sid FROM {$_TABLES['stories']} ORDER BY date DESC LIMIT " . (int) $_CONF['comment_close_rec_stories']);
while ($A = DB_fetchArray($results)) {
$allowedcomments[] = $A['sid'];
}
//update comment codes.
$sql = '';
if (is_array($allowedcomments)) {
foreach ($allowedcomments as $sid) {
$sql .= "AND sid <> '" . DB_escapeString($sid) . "' ";
}
$sql = "UPDATE {$_TABLES['stories']} SET commentcode = 1 WHERE commentcode = 0 " . $sql;
$result = DB_query($sql, 1);
if (DB_affectedRows($result) > 0) {
CACHE_remove_instance('story_');
$cleared = 1;
}
}
}
$sql = "UPDATE {$_TABLES['stories']} SET commentcode = 1 WHERE UNIX_TIMESTAMP(comment_expire) < UNIX_TIMESTAMP() AND UNIX_TIMESTAMP(comment_expire) <> 0";
$result = DB_query($sql, 1);
if ($cleared == 0) {
if (DB_affectedRows($result) > 0) {
CACHE_remove_instance('story_');
}
}
}
function bb2_db_affected_rows()
{
return DB_affectedRows();
}
//Create mode
$sql = "INSERT INTO {$_TABLES['paypal_shipping_cost']} SET {$sql} ";
}
DB_query($sql);
if (DB_error()) {
$msg = $LANG_PAYPAL_1['save_fail'];
} else {
$msg = $LANG_PAYPAL_1['save_success'];
}
echo COM_refresh($_CONF['site_admin_url'] . '/plugins/paypal/index.php?mode=shipping&msg=' . urlencode($msg));
exit;
break;
case 'delete_shipping_cost':
//delete shipping cost
DB_delete($_TABLES['paypal_shipping_cost'], 'shipping_id', $shipping_id);
if (DB_affectedRows('') >= 1) {
$msg = $LANG_PAYPAL_1['deletion_succes'];
} else {
$msg = $LANG_PAYPAL_1['deletion_fail'];
}
// delete complete, return to shipping page
echo COM_refresh($_CONF['site_admin_url'] . '/plugins/paypal/index.php?mode=shipping&msg=' . urlencode($msg));
exit;
break;
default:
PAYPAL_reorderShippingTo();
$display .= PAYPAL_shippingServices();
break;
}
break;
default: