Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 09-24-2001, 06:03 AM
snyx's Avatar
snyx snyx is offline
 
Join Date: Oct 2001
Location: Vancouver (whistler.2010)
Posts: 556
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Okay installed NanoEntity (i believe it was his) stats hack. NOW its gone, and I have a problem. Here is the code. (sorry if im not suppost to post it)

PHP Code:
// Top 5 Statistics BY NanoEntity
// Top 5 Attachments
$attach5 $DB_site->query('SELECT attachmentid,counter,filename FROM attachment ORDER BY attachmentid DESC LIMIT 5');
while (
$attach5top mysql_fetch_array($attach5)):
    ++
$attach5topnbsp;
    
$attach5file .= "$attach5top[filename]<br>";
    
$attach5hits .= "$attach5top[counter]<br>";

endwhile;
// Top 5 Attachments
// Top 5 New Members
$user $DB_site->query('SELECT userid,posts,username,joindate FROM user ORDER BY joindate DESC LIMIT 5');
while (
$usertop mysql_fetch_array($user)):
    ++
$usertopnbsp;
    
$username .= "<a href=member.php?s=$session[sessionhash]&action=getinfo&userid=$usertop[userid]>$usertop[username]</a><br>";
    
$userposts .= "$usertop[posts]<br>";

endwhile;
// Top 5 New Members
// Top 5 Thread Replys
$pop $DB_site->query('SELECT title,threadid,lastpost,lastposter,views FROM thread ORDER BY lastpost DESC LIMIT 5');
while (
$poptop mysql_fetch_array($pop)):
    ++
$poptopnbsp;
    
$popthread .= "<a href=showthread.php?s=$session[sessionhash]&threadid=$poptop[threadid]>$poptop[title]</a><br>";
    
$poplastposter .= "$poptop[lastposter]<br>";
    
$popviews .= "$poptop[views]<br>";

endwhile;
// Top 5 Thread Replys
// Top 1 Most Popular Thread
$pop1 $DB_site->query('SELECT title,threadid,views FROM thread ORDER BY views DESC LIMIT 1');
while (
$pop1top mysql_fetch_array($pop1)):
    ++
$pop1topnbsp;
    
$pop1title .= "<a href=showthread.php?s=$session[sessionhash]&threadid=$pop1top[threadid]>$pop1top[title]</a>";
    
$pop1views .= "$pop1top[views]";

endwhile;
// Top 1 Most Popular Thread
// Top 1 Most Rated Thread
$rated $DB_site->query('SELECT title,threadid,votenum FROM thread ORDER BY votenum DESC LIMIT 1');
while (
$ratedtop mysql_fetch_array($rated)):
    ++
$ratedtopnbsp;
    
$ratedtitle .= "<a href=showthread.php?s=$session[sessionhash]&threadid=$ratedtop[threadid]>$ratedtop[title]</a>";
    
$ratedrating .= "$ratedtop[votenum]";

endwhile;
// Top 1 Most Rated Thread
eval("\$top5threadstats = \"".gettemplate("g_statistics")."\";");
// Top 5 Statistics BY NanoEntity 
The hack works great! But see in my attachment, it lists 6 of the last attachments, and 5 of there hits. Could someone help fix this? It sets everything outta wack, I went though the code as best I could, and couldn't find what the problem was? Why is it showing 6 attachment names, and only 5 hits?

Thanks!
snyx
Attached Images
File Type: jpg 6not5.jpg (23.0 KB, 0 views)
  #2  
Old 09-24-2001, 07:22 AM
snyx's Avatar
snyx snyx is offline
 
Join Date: Oct 2001
Location: Vancouver (whistler.2010)
Posts: 556
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I dumped the whole attachment thing, and worked in the top 5 posters (a sinch) Plus I revamped the template, so everything is all linned up. (btw there wasnt 6 showing, it was just me being a idiot) If anyone wants my template (works for attachments) or my top 5 posters (simple, SIMPLE, index.php edit) PM me.
  #3  
Old 09-24-2001, 07:24 AM
snyx's Avatar
snyx snyx is offline
 
Join Date: Oct 2001
Location: Vancouver (whistler.2010)
Posts: 556
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Here is my example, of my template editing, and top 5 posters.
Attached Images
File Type: jpg stats.jpg (95.6 KB, 0 views)
  #4  
Old 09-24-2001, 07:41 AM
Neo's Avatar
Neo Neo is offline
 
Join Date: Oct 2001
Location: Anywhere
Posts: 1,817
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hey, in your statistics you have top 5 posters how did you get that there? and do you know how to put up a top 5 newest threads? that would really help...

and i cant really see anything anything wrong with the attach files hmm...
  #5  
Old 09-24-2001, 08:35 AM
snyx's Avatar
snyx snyx is offline
 
Join Date: Oct 2001
Location: Vancouver (whistler.2010)
Posts: 556
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by snyx
btw there wasnt 6 showing, it was just me being a idiot
no problem. just me being a goof.
so you want top 5 new THREADS, not replyed threads?
yeah I can probolly work that!
the top five posters was easy, you want it?
  #6  
Old 09-24-2001, 09:06 AM
Neo's Avatar
Neo Neo is offline
 
Join Date: Oct 2001
Location: Anywhere
Posts: 1,817
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

[QUOTE]Originally posted by snyx

no problem. just me being a goof.
so you want top 5 new THREADS, not replyed threads?
yeah I can probolly work that!
the top five posters was easy, you want it?
  #7  
Old 09-24-2001, 09:57 AM
snyx's Avatar
snyx snyx is offline
 
Join Date: Oct 2001
Location: Vancouver (whistler.2010)
Posts: 556
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

sorry dood, it's 4am so im really not in the mood to be editing it all now. let me look into it tomrrow for ya.
  #8  
Old 09-24-2001, 10:04 AM
Neo's Avatar
Neo Neo is offline
 
Join Date: Oct 2001
Location: Anywhere
Posts: 1,817
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

[QUOTE]Originally posted by snyx
sorry dood, it's 4am so im really not in the mood to be editing it all now. let me look into it tomrrow for ya.
  #9  
Old 09-24-2001, 10:48 AM
tweak's Avatar
tweak tweak is offline
 
Join Date: Oct 2001
Location: Canada
Posts: 113
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

snyx do you think i can have this hack please?
  #10  
Old 09-24-2001, 10:52 AM
Neo's Avatar
Neo Neo is offline
 
Join Date: Oct 2001
Location: Anywhere
Posts: 1,817
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

[QUOTE]Originally posted by Tweak
snyx do you think i can have this hack please?
Attached Files
File Type: txt top5[1].thread.stats.txt (5.9 KB, 58 views)
Closed Thread


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04257 seconds
  • Memory Usage 2,302KB
  • Queries Executed 14 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (3)postbit_attachment
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete