vb.org Archive
Page 6 of 6 « First 45 6
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)
-   -   freddie's Repair & Optimize Database (vB integration) (https://vborg.vbsupport.ru/showthread.php?t=38144)

Floris 05-03-2002 12:22 PM
it is in his attached screenshot

Stretchr 05-27-2002 01:25 AM
The script seems to be working for me but I'm getting this error:
PHP Code:
Warning: Supplied argument is not a valid MySQL result resource in /home/wdj/www/forums/admin/db_mysql.php on line 154 
FYI, here's the block which includes line 154 in my db_mysql.php
PHP Code:
function fetch_array($query_id=-1,$query_string="") {
    // retrieve row
    if ($query_id!=-1) {
      $this->query_id=$query_id;
    }
    if ( isset($this->query_id) ) {
      $this->record = mysql_fetch_array($this->query_id);
    } else {
      if ( !empty($query_string) ) {
        $this->halt("Invalid query id (".$this->query_id.") on this query: $query_string");
      } else {
        $this->halt("Invalid query id ".$this->query_id." specified");
      }
    } 

Any help would be appreciated.

Also: I didn't realize until I ran it the first time you modified repair.php. Might make a note of that, (unless you already did and I missed it somewhere) or, better yet, rename repair.php to something else and change it in the hack.

Anyway, this is really handy to have available from the Admin console. Thank you!

Boofo 07-08-2002 12:38 AM
If you find out how this is done, I would be very interested to know. :)

Quote:
Originally posted by NTLDR


I have freddies hack installed, but I wanted to know how the avatar and attachment count was added as that isn't part of the freddies hack (or at least not the version I installed).

I'll take another look.

Schorsch 08-20-2002 08:35 PM
thank you Nakkid and freddie, I'll try this later, hope it works...

Schorsch

Schorsch 08-21-2002 01:39 AM
ok I tried it now, no errors :banana:

DB size

before: 64.71 MB
after: 63.47 MB

has this repair.php any other features, like better performance of the board, etc.. ???

cu
Schorsch

TECK 08-21-2002 02:04 AM
yes it does. is like you format your hard drive in a way.. you basically order your database to remove errors and little empty spaces.

Asso 09-17-2002 06:13 PM
great hack m8!

tuga-gsm 04-26-2006 05:34 PM
any update on this tool or similar for vbulletin 3.5.1?

best regards


All times are GMT. The time now is 01:46 AM.
Page 6 of 6 « First 45 6
Show 40 post(s) from this thread on one page

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.00991 seconds
  • Memory Usage 1,737KB
  • 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_php_printable
  • (1)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
  • (8)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