The Arcive of Official vBulletin Modifications Site.

flup · #1 12-28-2002, 01:21 PM

Hi,,

when i edit one of my moderators to normal member,
I've to delete him everywhere he is moderator.

Now, i would prefer a hack that deletes a moderator on all forums he moderators!!!
Or, a hack that makes you able to specify @ wich forums
he has to be deleted wich check boxes.

Thx in Advanced,

flup · #2 12-28-2002, 03:34 PM

^bump^

Xenon · #3 12-28-2002, 08:19 PM

run this query:
[sql]DELETE FROM moderator WHERE userid=xx[/sql]

change xx into his userid, and he will be deleted from all forums he was moderator

flup · #4 12-28-2002, 08:44 PM

Ok thx!

flup · #5 12-29-2002, 02:17 PM

I'm goin' to make a full hack of this!

flup · #6 12-29-2002, 02:18 PM

Hmm, dat won't go, i guess i can;t add SQL commands to a PHP script without logging into SQL database first:/

Chris M · #7 12-29-2002, 04:47 PM

Try using:

Code:

$DB_site->query("DELETE FROM moderator WHERE userid=$scriptname[userid]");

Then create an Admin Script that you can enter a Value ($scriptname[userid])

Satan

flup · #8 12-29-2002, 04:53 PM

Hmm, and i don't need to use any usernames or passwords?

flup · #9 12-29-2002, 07:32 PM

Hmmz, i've got this for now:

Code:

//vB Mod Del Start
<html>
<form>
<input type="text" name="$moddel[userid]">
<input type="submit" name="Submit" value="Submit">
</form>
</html>
<?php
$DB_site->query("DELETE FROM moderator WHERE userid=$moddel[userid]");
?>
//vB Mod Del End

And i don't know how to say:
On hit SUMBIM->db query

Chris M · #10 12-29-2002, 09:54 PM

Create a file named "moddel.php" with content:

PHP Code:


			
<?php

error_reporting(7);



require("./global.php");



cpheader();



if (isset($action)==0) {

  $action="go";

}



// ###################### Start go #######################

if ($action=="go") {



  doformheader("moddel","dogo");



  maketableheader("Remove Mods");

  makeinputcode("Userid","$moddel[userid]");



  doformfooter("Go");

}



// ###################### Start dogo #######################

if ($HTTP_POST_VARS['action']=="dogo") {



  $DB_site->query("DELETE FROM moderator WHERE userid=$moddel[userid]");



  $action="go";



  echo "<p>Moderator Deleted</p>";



}



cpfooter();

?>

Satan

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04221 seconds Memory Usage 2,260KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (2)bbcode_code (1)bbcode_php (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!