vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Top 10 Posters Display (https://vborg.vbsupport.ru/showthread.php?t=82254)

SlipNslide281 08-10-2005 01:42 PM

Maybe in your instructions tell people to run this query:ALTER TABLE post ADD INDEX (dateline)

enstead of saying "If you don't already have an index on the dateline field in the user table then you should add one"

some people are new to this and don't understand what to do. Its kinda like saying if you don't already have this hack installed, install it. Thats what makes me so frustrated on these hacks is the coders automaticly thinks you know what your doing and get about 80% done and bam!!! instructions are not clearn. If we knew we would be making our own hacks. All we users ask is just put exactly what we should do in the instructions.

selwonk 08-10-2005 02:09 PM

Quote:

Originally Posted by SlipNslide281
Maybe in your instructions tell people to run this query:ALTER TABLE post ADD INDEX (dateline)

enstead of saying "If you don't already have an index on the dateline field in the user table then you should add one"

some people are new to this and don't understand what to do. Its kinda like saying if you don't already have this hack installed, install it. Thats what makes me so frustrated on these hacks is the coders automaticly thinks you know what your doing and get about 80% done and bam!!! instructions are not clearn. If we knew we would be making our own hacks. All we users ask is just put exactly what we should do in the instructions.

The instructions read:

Step 5.

If you don't already have an index on the dateline field in the user table then you should add one ;

ALTER TABLE post ADD INDEX (dateline)


I'm probably opening myself up for a flame here, but hey...

I don't think it's too much to ask that if you feel confident enough to start hacking vBulletin, you should really be able to check if a field is indexed. It's just my humble opinion of course! :classic:

At the end of the day, this will not stop this particular hack working. If your site is so large that failing to index this field causes a huge delay in displaying the results, but you don't understand why the indexing change might be required (or how to deal with it), isn't time you learned a bit more about MySQL! :nervous:

Cheers!

SlipNslide281 08-10-2005 02:41 PM

I did my own site not even knowing how to register my domain. I started out as a complete noob and still am. Yes the confidence isn't there. But I have learned so much from detailed instructions. Here is my site, and its my first site. So detailed instructions can help people learn.

www.sonaf.com

Gutspiller 08-10-2005 03:55 PM

How do we know if we need to run Step 5?

Quote:

If you don't already have an index on the dateline field in the user table then you should add one ;

ALTER TABLE post ADD INDEX (dateline)
If the topposters.php works, does that mean we don't need to do this?

Sleepyk 08-10-2005 07:51 PM

Quote:

Originally Posted by Sleepyk
how i get on my forum home template under last 10 threads?

help?

faast 08-14-2005 01:19 AM

Does this work with vB 3.0.7?

Paul M 08-20-2005 06:37 PM

Quote:

Originally Posted by selwonk
Hi Paul

Great hack - thanks very much! Any objections to me removing the link to your profile at the bottom:

Version 1.55 : ? Paul Marsden 2005

I have no objections to it staying, but unless my users are registered on cable forum they can't see your profile anyway! :ermm:

Cheers!

You may remove the actual link to my CF profile - as long as the copyright message (text) remains. :)

MillerLight 09-01-2005 12:48 PM

Installed on VB Ver 3.0.8.

Left out Step 5 and works fine. Straight forward install, works great!

michaelbenson 09-16-2005 09:05 PM

Excellent idea and hack .. keep up the good work :)
Installed

tuanluu 09-27-2005 02:30 AM

How can I show top 10 poster on index page, and right below the navar board


All times are GMT. The time now is 10:26 AM.

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.01479 seconds
  • Memory Usage 1,739KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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