Пример #1
0
    print_form_header('profilefield', 'kill');
    construct_hidden_code('profilefieldid', $vbulletin->GPC['profilefieldid']);
    print_table_header(construct_phrase($vbphrase['confirm_deletion_x'], htmlspecialchars_uni($vbphrase['field' . $vbulletin->GPC['profilefieldid'] . '_title'])));
    print_description_row($vbphrase['are_you_sure_you_want_to_delete_this_user_profile_field']);
    print_submit_row($vbphrase['yes'], '', 2, $vbphrase['no']);
}
// ###################### Start Kill #######################
if ($_POST['do'] == 'kill') {
    $db->query_write("\n\t\tDELETE FROM " . TABLE_PREFIX . "phrase\n\t\tWHERE fieldname = 'cprofilefield' AND\n\t\t\t\tvarname IN ('field" . $vbulletin->GPC['profilefieldid'] . "_title', 'field" . $vbulletin->GPC['profilefieldid'] . "_desc')\n\t");
    require_once DIR . '/includes/adminfunctions_language.php';
    build_language();
    require_once DIR . '/includes/class_dbalter.php';
    $db_alter = new vB_Database_Alter_MySQL($db);
    $db->query_write("DELETE FROM " . TABLE_PREFIX . "profilefield WHERE profilefieldid = " . $vbulletin->GPC['profilefieldid']);
    if ($db_alter->fetch_table_info('userfield')) {
        $db_alter->drop_field("field" . $vbulletin->GPC['profilefieldid']);
    }
    $db->query_write("OPTIMIZE TABLE " . TABLE_PREFIX . "userfield");
    build_profilefield_cache();
    define('CP_REDIRECT', 'profilefield.php?do=modify');
    print_stop_message('deleted_user_profile_field_successfully');
}
// ###################### Start modify #######################
if ($_REQUEST['do'] == 'modify') {
    // cache profile field categories
    $pfcs = array(0);
    $pfcs_result = $db->query_read("\n\t\tSELECT * FROM " . TABLE_PREFIX . "profilefieldcategory\n\t\tORDER BY displayorder\n\t");
    while ($pfc = $db->fetch_array($pfcs_result)) {
        $pfcs["{$pfc['profilefieldcategoryid']}"] = $pfc['profilefieldcategoryid'];
    }
    $db->free_result($pfcs_result);
Пример #2
0
 //remove some common resources that a product may have registered.
 //tags
 $db->query_write("\r\n\t\tDELETE tagcontent\r\n\t\tFROM " . TABLE_PREFIX . "package AS package JOIN\r\n\t\t\t" . TABLE_PREFIX . "contenttype AS contenttype ON\r\n\t\t\t\tcontenttype.packageid = package.packageid JOIN\r\n\t\t\t" . TABLE_PREFIX . "tagcontent AS tagcontent ON\r\n\t\t\t\tcontenttype.contenttypeid = tagcontent.contenttypeid\r\n\t\tWHERE productid = '{$safe_productid}'\r\n\t");
 // Packages, routes, actions, contenttypes
 $db->query_write("\r\n\t\tDELETE package, route, action, contenttype\r\n\t\tFROM " . TABLE_PREFIX . "package AS package\r\n\t\tLEFT JOIN " . TABLE_PREFIX . "route AS route\r\n\t\t\tON route.packageid = package.packageid\r\n\t\tLEFT JOIN " . TABLE_PREFIX . "action AS action\r\n\t\t\tON action.routeid = route.routeid\r\n\t\tLEFT JOIN " . TABLE_PREFIX . "contenttype AS contenttype\r\n\t\t\tON contenttype.packageid = package.packageid\r\n\t\tWHERE productid = '{$safe_productid}'\r\n\t");
 // Clear routes from datastore
 build_datastore('routes', serialize(array()), 1);
 //clear the type cache.
 vB_Cache::instance()->purge('vb_types.types');
 // need to remove the language columns for this product as well
 require_once DIR . '/includes/class_dbalter.php';
 $db_alter = new vB_Database_Alter_MySQL($db);
 if ($db_alter->fetch_table_info('language')) {
     $phrasetypes = $db->query_read("\r\n\t\t\tSELECT fieldname\r\n\t\t\tFROM " . TABLE_PREFIX . "phrasetype\r\n\t\t\tWHERE product = '" . $db->escape_string($vbulletin->GPC['productid']) . "'\r\n\t\t");
     while ($phrasetype = $db->fetch_array($phrasetypes)) {
         $db_alter->drop_field("phrasegroup_{$phrasetype['fieldname']}");
     }
 }
 delete_product($vbulletin->GPC['productid']);
 build_all_styles();
 vBulletinHook::build_datastore($db);
 require_once DIR . '/includes/adminfunctions_language.php';
 build_language();
 build_options();
 require_once DIR . '/includes/functions_cron.php';
 build_cron_next_run();
 build_product_datastore();
 // build bitfields to remove/add this products bitfields
 require_once DIR . '/includes/class_bitfield_builder.php';
 vB_Bitfield_Builder::save($db);
 // reload block types
Пример #3
0
	vB_Cache::instance()->purge('vb_types.types');

	// need to remove the language columns for this product as well
	require_once(DIR . '/includes/class_dbalter.php');

	$db_alter = new vB_Database_Alter_MySQL($db);
	if ($db_alter->fetch_table_info('language'))
	{
		$phrasetypes = $db->query_read("
			SELECT fieldname
			FROM " . TABLE_PREFIX . "phrasetype
			WHERE product = '" . $db->escape_string($vbulletin->GPC['productid']) . "'
		");
		while ($phrasetype = $db->fetch_array($phrasetypes))
		{
			$db_alter->drop_field("phrasegroup_$phrasetype[fieldname]");
		}
	}

	delete_product($vbulletin->GPC['productid']);

	build_all_styles();

	vBulletinHook::build_datastore($db);

	require_once(DIR . '/includes/adminfunctions_language.php');
	build_language();

	build_options();

	require_once(DIR . '/includes/functions_cron.php');