vBmoddel

Hack Name: vBmoddel
Hack maker: Flup
Hack Version: 2.1
Credits:
Xenon & Hellsatan


What does this hack do?
This hack deletes a moderator from all forums he moderators!!!
Just by giving his userID and press "delete"

Newest version : 2.2
Moddel.php Download Here

New in version 2.2 :
Moderator automaticly becomes a regular member!

[flup]

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

[N9ne]

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

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

[Chris M]

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

Satan

[N9ne]

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

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

[flup]

rofl

[flup]

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

Tell more

[flup]

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

[flup]

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

[flup]

Rest from hack:

<?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]

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

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.