Go Back   vb.org Archive > Search Forums
Reload this Page Search Results
FAQ Community Calendar Today's Posts Search

Showing results 1 to 21 of 21
Search took 0.00 seconds. Search: Posts Made By: pwr_sneak
Forum: vBulletin 2.x Full Releases 08-03-2003, 04:44 PM
Replies: 36
Views: 9,365
Posted By pwr_sneak
for moderated forums you'll need the other query...

for moderated forums you'll need the other query ($postscount = $DB_site->query_first("SELECT COUNT(*)...) too, to get the right pagecount and page navigation.
this hack speeds thread-display...
Forum: vBulletin 2.x Full Releases 07-30-2003, 10:04 AM
Replies: 36
Views: 9,365
Posted By pwr_sneak
they didn't implement this because it would not...

they didn't implement this because it would not work for forums which moderate new posts.
but you could use $forum['moderatenew'] to decide which version you wanted to use.

if...
Forum: vBulletin 2.x Full Releases 07-13-2003, 02:53 PM
Replies: 34
Views: 6,719
Posted By pwr_sneak
you could try to read the code and understand how...

you could try to read the code and understand how it works :P
which vbulletin version do you use? if its not the latest stable (2.3.0), try to update it.
Forum: vBulletin 2.x Full Releases 02-03-2003, 08:20 AM
Replies: 34
Views: 6,719
Posted By pwr_sneak
you're right, this is a typo. It won't change...

you're right, this is a typo.
It won't change anything but $dotjoin is right ;)
I found this typo in the original member2.php too (2.2.9).

My Instructions have been updated once again.
Forum: vBulletin 2.x Full Releases 02-02-2003, 07:58 PM
Replies: 258
Views: 36,240
Posted By pwr_sneak
the 3 pm-queries on index.php run 0.0068 seconds...

the 3 pm-queries on index.php run 0.0068 seconds on my servers. no matter how huge the privatemessage table is since mysql doesn't have to read anything from disk or crawl through big B-Trees.
Forum: vBulletin 2.x Full Releases 02-02-2003, 07:19 PM
Replies: 34
Views: 6,719
Posted By pwr_sneak
I've updated the instructions for search.php,...

I've updated the instructions for search.php, usercp.php and member2.php :)
Forum: vBulletin 2.x Full Releases 02-02-2003, 06:25 PM
Replies: 258
Views: 36,240
Posted By pwr_sneak
where's the threshold of this considerable...

where's the threshold of this considerable amount?
I do like those well scaling solutions more than those with unneccesary performance breaks.

I just wanted to say that it's not always good to...
Forum: vBulletin 2.x Full Releases 02-02-2003, 05:25 PM
Replies: 258
Views: 36,240
Posted By pwr_sneak
Matt runs Sybase instead of MySQL, you can't...

Matt runs Sybase instead of MySQL, you can't compare this.
MySQL optimizes count(*) queries because it keeps an extra counter in its index-files when using MyISAM Tables. The Index should be read...
Forum: vBulletin 2.x Full Releases 02-02-2003, 04:00 PM
Replies: 258
Views: 36,240
Posted By pwr_sneak
I've updated my last post due to an cut'n'paste...

I've updated my last post due to an cut'n'paste error...


you have to run the original 3 queries to make it faster.
it's a good idea trying to decrease the number of queries, but it won't help...
Forum: vBulletin 2.x Full Releases 02-02-2003, 02:50 PM
Replies: 258
Views: 36,240
Posted By pwr_sneak
i just read your instructions to see if this hack...

i just read your instructions to see if this hack would work for my forum.
but this query is much slower then the original ones:
SELECT COUNT(*) AS messages,
SUM(IF(dateline>$bbuserinfo[lastvisit]...
Forum: vBulletin 2.x Full Releases 02-02-2003, 01:05 PM
Replies: 34
Views: 6,719
Posted By pwr_sneak
if you test it with small post and thread tables...

if you test it with small post and thread tables it wouldn't make a huge difference, but the original code doesn't scale very well.
my forum got 1.4 million posts and 47k threads and it definitely...
Forum: vBulletin 2.x Full Releases 02-02-2003, 12:25 PM
Replies: 34
Views: 6,719
Posted By pwr_sneak
the one before showed up often in my...

the one before showed up often in my slowqueries.log and took much longer than 10 seconds sometimes.
the two new queries takes 13 millisecondes :p
Forum: vBulletin 2.x Full Releases 02-02-2003, 12:10 PM
Replies: 34
Views: 6,719
Posted By pwr_sneak
means it will just work with PHP 4 or higher.

means it will just work with PHP 4 or higher.
Forum: vBulletin 2.x Full Releases 02-01-2003, 10:00 PM
Replies: 34
Views: 6,719
Posted By pwr_sneak
improved dot icons - decreases DB load

This Hack will decrease the Load on your DB-Server.
It adds one small Query to forumdisplay.php and modifies one big, slow query.
If you have lots of posts and $showdots enabled, this is a must....
Forum: vBulletin 2.x Full Releases 04-04-2002, 05:37 PM
Replies: 11
Views: 2,487
Posted By pwr_sneak
ok, this works now, but adds load to the server...

ok, this works now, but adds load to the server and doesn't work on forums, which use multiple boxes, but these problems are very special :)

Another problem could occur more often. Your hack won't...
Forum: vBulletin 2.x Full Releases 04-03-2002, 09:11 AM
Replies: 11
Views: 2,487
Posted By pwr_sneak
how about sending the PM when the system updates...

how about sending the PM when the system updates the birthday-templates once per day (first hit after midnight) ?
search for "if ($showbirthdays) {" in your index.php and for "function...
Forum: vBulletin 2.x Full Releases 02-06-2002, 07:32 AM
Replies: 45
Views: 8,614
Posted By pwr_sneak
Your last Version uses hard-coded usergroupid and...

Your last Version uses hard-coded usergroupid and it don't let the user close his own thread if he started it.
If you changed your Admin Usergroup not to close their own threads, why should they...
Forum: vBulletin 2.x Full Releases 02-05-2002, 02:33 PM
Replies: 45
Views: 8,614
Posted By pwr_sneak
if you still want it the way, it should work, try...

if you still want it the way, it should work, try this:
if ($permissions['canopenclose'] and (ismoderator($threadinfo[forumid],"canopenclose") or $isstarter=$DB_site->query_first("SELECT postuserid...
Forum: Community Lounge 02-05-2002, 09:58 AM
Replies: 163
Views: 24,077
Posted By pwr_sneak
and there are 25 posts per page, not the default...

and there are 25 posts per page, not the default value of 15.
Forum: Community Lounge 02-05-2002, 08:42 AM
Replies: 163
Views: 24,077
Posted By pwr_sneak
my users have started something like that by...

my users have started something like that by themself. Our longest thread has about 15000 replies.
See it here (beware, its german *g*):
http://forum.hotornot.de/forum/showthread.php?threadid=16155...
Forum: vBulletin 2.x Full Releases 07-04-2001, 01:31 PM
Replies: 55
Views: 10,279
Posted By pwr_sneak
Hi, i just installed this hack on my Board...

Hi,

i just installed this hack on my Board for the first time an tried to access the stats. I was wondering why it didn't show up, checked my server and saw one HTTP-Process using 150 Megs of...
Showing results 1 to 21 of 21

 
Forum Jump

All times are GMT. The time now is 04:44 PM.

Contact Us - Archive - Top

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.05423 seconds
  • Memory Usage 2,003KB
  • 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
  • (1)footer
  • (1)forumjump
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (2)navbar_link
  • (120)option
  • (1)post_thanks_navbar_search
  • (1)search_results
  • (21)search_results_postbit
  • (1)spacer_close
  • (1)spacer_open
  • (61)threadbit_pagelink 
Phrase Groups Available:
  • global
  • inlinemod
  • prefix
  • search
Included Files:
  • ./search.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/functions_search.php
  • ./includes/functions_databuild.php
  • ./includes/functions_forumlist.php
  • ./includes/functions_misc.php
  • ./includes/functions_forumdisplay.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • search_before_process
  • search_start
  • search_results_start
  • search_results_query_posts
  • search_results_prebits
  • threadbit_process
  • search_results_postbit
  • forumjump
  • search_complete
  • navbits
  • navbits_complete