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)
-   -   Optimizing Forumhome (https://vborg.vbsupport.ru/showthread.php?t=46848)

Alien 08-09-2003 05:48 PM

Definatly one of the best things you can do for your site, this deserves a major bumpity-bump after 3 months! :D

Xenon 08-10-2003 03:25 PM

arrigato ;)

Danielo 08-11-2003 10:22 AM

let's try for it....
i hope my actual db query can be lesser :(

julius 08-21-2003 07:25 PM

Installed.
Before 20 queries, now 16 queries.

Thanks Xenon.

StrykerContact 09-08-2003 04:08 AM

I get this error when I edit a forum and save it (not editing anything)

Database error in vBulletin Control Panel 2.3.2:

Invalid SQL: UPDATE forum SET moderators=' '
mysql error: Unknown column 'moderators' in 'field list'

mysql error number: 1054

==============================================
Help please, I don't think I made an error I did this twice and nothing changed, mayby it's somthing I had installed already that messed up a line of code.

Edit: I fixed it, I don't know why but the step:

find:
PHP Code:

      $DB_site->query("DELETE FROM forumpermission WHERE forumid=$forumid AND ((usergroupid>=1 AND usergroupid<=4) OR usergroupid>6)");
    }
  }

  
updateparentlists(); 


change to:
PHP Code:

      $DB_site->query("DELETE FROM forumpermission WHERE forumid=$forumid AND ((usergroupid>=1 AND usergroupid<=4) OR usergroupid>6)");
    }
  }

  
updateparentlists();
  
updatemoderators(); 

Causes a Mysql error, all I had to do was remove 'updatemoderators();' from under updateparentlists();

It could just be me but I dunno. Great hack.

Xenon 09-08-2003 04:30 PM

easy answer is you have installed the hack incorrectly.

you have to add a column moderators at forum table.
it's the first step you have to do, described in install file

StrykerContact 09-09-2003 09:47 PM

Wow I'm sorry for missing that, I have never missed a step in a hack before without realising it later. Mayby I just missed it because I started right where I saw open index.php thinking everything above it wasn't part of the hacking. Thanks for pointing that out. You don't need to take my suggestion, but organise your instructions a little more, put some indicators and make them easy to identify like:

########################################
Start Install of Hack
########################################

=========================
RUN QUERY
=========================
ALTER TABLE `forum` ADD `moderators` MEDIUMTEXT NOT NULL

=========================
Open Index.php
=========================
Etc etc. Your a much more experienced hacker then me so I'm not going to tell you to do anything, but some people are as dumb as me and screw up like that. Thanks for the great hack.

Xenon 09-09-2003 09:52 PM

:)

i've already planned to organize my hack instructions more when i start vb3 hack releases ;)

Blizzb 09-12-2003 12:40 AM

You make the best hacks Xenon :)

Xenon 09-12-2003 12:50 AM

:)

thank you very much :)


All times are GMT. The time now is 03:50 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.01264 seconds
  • Memory Usage 1,736KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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