vb.org Archive

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)

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:03 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01155 seconds
  • Memory Usage 1,741KB
  • 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
  • (2)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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