case "BannerClientDelete2":
$cid = isset($_POST['cid']) ? intval($_POST['cid']) : 0;
$db =& Database::getInstance();
if ($cid <= 0 || !xoops_confirm_validate()) {
redirect_header("admin.php?fct=banners&op=BannersAdmin#top");
}
$sql = sprintf("DELETE FROM %s WHERE cid = %u", $db->prefix("banner"), $cid);
$db->query($sql);
$sql = sprintf("DELETE FROM %s WHERE cid = %u", $db->prefix("bannerclient"), $cid);
$db->query($sql);
redirect_header("admin.php?fct=banners&op=BannersAdmin#top", 1, _AM_DBUPDATED);
break;
case "BannerClientEdit":
$cid = isset($_GET['cid']) ? intval($_GET['cid']) : 0;
if ($cid > 0) {
BannerClientEdit($cid);
}
break;
case "BannerClientChange":
$cid = isset($_POST['cid']) ? intval($_POST['cid']) : 0;
if ($cid <= 0 || !XoopsSingleTokenHandler::quickValidate('banners_ClientChange')) {
redirect_header("admin.php?fct=banners&op=BannersAdmin#top");
}
$name = isset($_POST['name']) ? trim($_POST['name']) : '';
$contact = isset($_POST['contact']) ? trim($_POST['contact']) : '';
$email = isset($_POST['email']) ? trim($_POST['email']) : '';
$login = isset($_POST['login']) ? trim($_POST['login']) : '';
$passwd = isset($_POST['passwd']) ? trim($_POST['passwd']) : '';
$extrainfo = isset($_POST['extrainfo']) ? trim($_POST['extrainfo']) : '';
$db =& Database::getInstance();
$myts =& MyTextSanitizer::getInstance();
break;
case 'BannerClientDelete2':
$db =& icms_db_Factory::instance();
if ($cid <= 0 | !icms::$security->check()) {
redirect_header('admin.php?fct=banners&op=BannersAdmin#top', 3, implode('<br />', icms::$security->getErrors()));
}
$sql = sprintf("DELETE FROM %s WHERE cid = '%u'", $db->prefix('banner'), $cid);
$db->query($sql);
$sql = sprintf("DELETE FROM %s WHERE cid = '%u'", $db->prefix('bannerclient'), $cid);
$db->query($sql);
redirect_header('admin.php?fct=banners&op=BannersAdmin#top', 1, _AM_DBUPDATED);
break;
case 'BannerClientEdit':
if ($cid > 0) {BannerClientEdit($cid);}
break;
case 'BannerClientChange':
if ($cid <= 0 | !icms::$security->check()) {
redirect_header('admin.php?fct=banners&op=BannersAdmin#top', 3, implode('<br />', icms::$security->getErrors()));
}
$db =& icms_db_Factory::instance();
$sql = sprintf("UPDATE %s SET name = %s, contact = %s, email = %s, login = %s, passwd = %s, extrainfo = %s WHERE cid = '%d'",
$db->prefix("bannerclient"),
$db->quoteString(icms_core_DataFilter::stripSlashesGPC($name)),
$db->quoteString(icms_core_DataFilter::stripSlashesGPC($contact)),
$db->quoteString(icms_core_DataFilter::stripSlashesGPC($email)),
$db->quoteString(icms_core_DataFilter::stripSlashesGPC($login)),
$db->quoteString(icms_core_DataFilter::stripSlashesGPC($passwd)),
$db->quoteString(icms_core_DataFilter::stripSlashesGPC($extrainfo)),
