vb.org Archive - vBmoddel

Page 2 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - vBmoddel (https://vborg.vbsupport.ru/showthread.php?t=47129)

Chris M

01-02-2003 09:08 AM

Er...

Perhaps you can select which forums to delete?:)

i.e. You can mass prune the moderators, but from certain forums instead of having to go and delete individual ones;)

Satan

Boofo

01-02-2003 09:52 AM

Does this delete them from the board or just take their moderatorship (is that even a word?) away?

flup	01-02-2003 09:58 AM

Well, when you have deleted a moderator, or let's say, you've took his moderator (or Super Mod) status away and changed it into Member or whatever, he will still be listed as moderator in showgroups.php because he isn't deleted from the forums!

That's why i made this hack, i had 7 mods wich i have deleted
And i had to delete them manualy what took lots time more that this!

So this hack don't delete them from the forum, but just what you
said, it take their moderatorship away!

Boofo

01-02-2003 10:02 AM

Ok, I see. Then you could basically take his moderatorship away from all forums and leave him as a moderator without anything to moderate. Like a "Moderator Langoliers", so to speak. The drop down with the forums listing that they are mods of would be great in case you didn't want to delete them from all forums.

Chris M

01-02-2003 12:30 PM

Uhuh;) What I asked for:)

Satan

Boofo

01-02-2003 01:12 PM

I figured if 2 of us ask, it might happen a little quicker? :p

Chris M

01-02-2003 01:35 PM

Lol:p

Good idea;)

Satan

flup	01-02-2003 01:43 PM

:P LoL

Satan, do you have ICQ or MSN?!
I need your help again I think

Chris M

01-02-2003 02:00 PM

MSN: msn@darkblazes.com / darkblazes_cm@hotmail.com
AIM: noXchris / hellsatancoa

:)

Satan

flup	01-02-2003 02:32 PM

Ok i'm now in your MSN but you are doin' homework hahah :)

Learner29

01-02-2003 02:51 PM

Quote:

Originally posted by Boofo
Does this delete them from the board or just take their moderatorship (is that even a word?) away?

Thanks Boofo for asking the exact question that I had in mind....

and thanks to flup for providing this hack and for providing support for it

I shall try it now.

flup	01-02-2003 03:01 PM

Well you also have to thank HellSatan and Xenon for helping me with this hack!

Learner29

01-02-2003 03:19 PM

:surprised: :surprised: :surprised: :surprised: :surprised:

Yes your hack works very well buddies.. it DOES delete the moderator from All forums in One Shot..........

BUT I COULD STILL ENTER PRIVATE FORUMS AS A KILLED MODERATOR!!!!!

ANY HELP OUT THERE??????

Learner29

01-02-2003 03:23 PM

and the killed moderator status in the admin control panel is STILL as MODERATOR after deleting the mod with your method.

when I kill a mod manually, his status would go back to simple normal members....

flup	01-02-2003 03:36 PM

I know that's coming in version 2.2
Mod's wil automaticly turned into Member status.

But I think this would result in some problems, but i'll look!

Chris M

01-02-2003 04:14 PM

Why would it result in problems?

Just add a query in the "dogo" part:

Code:

$DB_site->query("UPDATE user SET usergroupid='2' WHERE userid='$modtodel'");

Satan

flup	01-02-2003 04:45 PM

Caus I thougt I couldn't make 2 db queries

Chris M

01-02-2003 04:56 PM

Of course you can:)

You can have 100 "$DB_site->query" lines in a row (as long as they are correctly formed)

I wouldn't recommend that though;)

Satan

flup	01-02-2003 05:29 PM

Ok, version 2.2 laucned, in 1st post the DONWLOAD link is renewed and .txt file is renewed., have fun :)

Chris M

01-02-2003 05:36 PM

Lol:)

Now for v3;)

^^^^^^^^^

Satan

flup	01-02-2003 07:00 PM

Yeah V3 will have checkboxes with the forums a moderator has to be deleted from :|
It will take some time though but i think me and hellsatan, and some other hacker wich is able to help will get it :)

flup	01-03-2003 12:47 PM

I'm still bussy, ;)
I can't get it really actually :|

yzztik

01-03-2003 10:26 PM

How about an option for removing their access from any private forums? Like any set to yes it sets to default or something?

Chris M

01-03-2003 11:08 PM

Well by defualt it will set the user to the usergroupid 2 (registered), so it isn't possible unless you use an option to say "reset to registered usergroup?", and then code that above;)

Satan

yzztik

01-04-2003 12:53 AM

ok fair enough. At least with this hack is one less step.

flup	01-04-2003 10:05 AM

I just can't get this code working (check boxes)
Sorry :|

Chris M

01-04-2003 12:55 PM

Have you tried using Radio buttons?

It would be much simpler;)

Satan

flup	01-04-2003 01:28 PM

Radio Buttons or Check Boxes I can't get it :(

N9ne	01-04-2003 01:30 PM

What would be the point of using radio buttons...? You wouldn't be able to select more than one moderator ;).

If you do figure out the checkboxes, here's some indepth do'da's you could do :D :

Each moderator is listed, and under his name is:

Checkboxes for each forum he mods, if selected, he will be demodded from that forum.

A select all checkbox which selects all forums.

A 'usergroupid to put mod into after being demodded'
(this is good for say putting a mod as a supermod)

A checkbox which will reset all his access masks to default.

There could be a link on the page which will demod all mods from all forums.

There could be a link on the page which will reset every mod's usergroupid to a given usergroupid, IF all mods are demodded.

There could be a link on the page which will reset all mods' access masks to default.

There's loads of stuff you could do here :D

Anyway, great hack, will use it, very useful as I have over 20 mods!

Chris M

01-04-2003 01:32 PM

:bored:

Anyone help him?

@N9ne - Sure you can:)

And not any more you don't;)

Satan

flup	01-04-2003 01:34 PM

Thx for support I will add some of this stuff certainly to V3

N9ne	01-04-2003 01:35 PM

Quote:

Originally posted by hellsatan
:bored:

Anyone help him?

@N9ne - Sure you can:)

And not any more you don't;)

Satan

'And not any more you don't;)'

Directed at me? Well technically I still do have 20 mods left in my DB backup :p

And you can't select multiple radio buttons, that's why checkboxes are around...

Chris M

01-04-2003 01:37 PM

Who said anything about multiple radio buttons?:bored:

You have a dropbox with values to show the set number of mods on the page

You have the moderator's name as a heading, and all the forums they moderate, and a "yes" or "no" option to delete them as moderator of that forum, and then the next moderator is below with a similar setup etc:p

Satan

N9ne	01-04-2003 01:47 PM

LOL well if you put it THAT way then yes you CAN use radio buttons :p

Hellsatan 2003, still confusing people...522,353 victims :p

flup	01-04-2003 03:08 PM

rofl

flup	01-04-2003 03:13 PM

Quote:

Originally posted by N9ne
There's loads of stuff you could do here :D

Tell more :)

flup	01-04-2003 03:33 PM

This would be the first to for me to work with DB commands ....

flup	01-04-2003 03:35 PM

Code:

$DB_site->query("DELETE FROM moderator WHERE userid="$modtodel ON forumid=$forums2del");

flup	01-04-2003 03:36 PM

Rest from hack:

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");



      $mods = $DB_site->query("SELECT DISTINCT moderator.userid, user.* FROM moderator LEFT JOIN user ON moderator.userid=user.userid");

        while ($moddel = $DB_site->fetch_array($mods)) {

          $moddels .= '<option value="'.$moddel[userid].'">'.htmlspecialchars($moddel[username]).'</option>';

           }



      $forumsdf = $DB_site->query("SELECT DISTINCT forum.forumid, forum.* moderator LEFT JOIN forum ON moderator.forumid=forum.forumid");

        while ($forums2del = $DB_site->fetch_arrays($forumsdf)) {        

          $forums2del .= '<option value="'.$forums2del[forumid].'">'.htmlspecialchars($forums2del[forumname]).'</option>';

           }



      print '<tr class="'.getrowbg().'"><td>Select Moderator</td><td>';

      print '<select name="modtodel">'.$moddels.'</select></td>';

      print '</tr>';

      print '<br>';

      print '<tr class="'.getrowbg().'"><td>Select Forum</td><td>';

      print '<select forum="forumtodelmod">'.$forums2del.'</select></td>';

      print '</tr>';



  doformfooter("Go");

}



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

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



  $DB_site->query("DELETE FROM moderator WHERE userid=$modtodel");

  $DB_site->query("DELETE FROM moderator WHERE userid="$modtodel ON forumid=$forums2del");

  $DB_site->query("UPDATE user SET usergroupid='2' WHERE userid='$modtodel'");





  $action="go";



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



}



cpfooter();

?>

Im quite a n00b with DB queries :)

flup	01-04-2003 03:38 PM

By The Way, I just copied the DB query from the 1st made by Xenon and than edited it a little bit :p

But the problem is that "home made db querie :)"
If that's working I have got step 1 of delete mod from forum finished, and i could work on checkboxes/radiobuttons to make it easier.

All times are GMT. The time now is 01:16 AM.

Page 2 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01190 seconds Memory Usage 1,811KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: