vb.org Archive
Page 1 of 8 1 23 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Best&Worst Thread of the day-Week-Month (https://vborg.vbsupport.ru/showthread.php?t=107711)

Developer 02-10-2006 10:00 PM
Best&Worst Thread of the day-Week-Month
 
Best&Worst Thread of the day-Week-Month
Description::.
This hack shows in forum home Best&Worst Thread of the day-Week-Month
[Hack Features::.
1-easy yo install
[See Screen Shots]
Admin Controllable
From vBulletin Options ==> vBulletin Options ==> Best&Worst Thread of the (day,week,month) Statistics.]

Installation::.
1-Import The Product.
2-Edit Template FORUMHOME
Find:
Code:
<!-- end what's going on box -->
Add After it
Code:
<if condition="$vboptions[enbwt]"><if condition="$vboptions[enbt]"><table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center" height="10"><tbody>
        <tr>
                <td class="thead" height="10" colspan="3">
                        <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('bthread')"><img id="collapseimg_bthread" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_bthread].gif" alt="" border="0" /></a>
                $vbphrase[bthread]</td>
        </tr>
</tbody>
<tbody id="collapseobj_bthread" style="$vbcollapse[collapseobj_bthread]"
<tr>
<if condition="$vboptions[encolbt1]"><td class='alt1' width='33%' height='20%'>$devebdt</td></if>
<if condition="$vboptions[encolbt2]"><td class='alt1' width='33%' height='20%'>$devebwt</td></if>
<if condition="$vboptions[encolbt3]"><td class='alt1' width='33%' height='20%'>$devebmt</td></if>
</tr>
</tbody></table></if>
<if condition="$vboptions[enwt]"><table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center" height="10"><tbody>
        <tr>
                <td class="thead" height="10" colspan="3">
                        <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('wthreads')"><img id="collapseimg_wthreads" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_wthreads].gif" alt="" border="0" /></a>
        $vbphrase[wthread]</td>
        </tr>
</tbody>
<tbody id="collapseobj_wthreads" style="$vbcollapse[collapseobj_wthreads]">
<tr>
<if condition="$vboptions[encolwt1]"><td class='alt1' width='33%' height='20%'>$devewdt</td></if>
<if condition="$vboptions[encolwt2]"><td class='alt1' width='33%' height='20%'>$devewwt</td></if>
<if condition="$vboptions[encolwt3]"><td class='alt1' width='33%' height='20%'>$devewmt</td></if>
</tr>
</tbody></table></if><br></if>
History::.
1.0 On 11. Feb 2006 Initial Version.
1.1 On 12 feb 2006 Fixes SQL Query
Hack Languages::.
allan Had translate the hack to french. here
Hellraider Had translate the hack to german. here
Details::.
6 plugin, 26 phrases, 12 options, 6 queries(reading only not change or add)
Donation::.
Feel Free To https://www.paypal.com/en_US/i/btn/x...tcc-donate.gif
aT lAsT::.
IF YOu lIkE iT cLIcK INSTALL
vbulletin.orghttps://vborg.vbsupport.ru/

Support Given For Who Clicked Install {ONLY}

RFViet 02-11-2006 12:57 PM
I'll try it, thanks !!

Marco van Herwaarden 02-11-2006 12:57 PM
just a question: is good or bad only determined by the number of replies?

Also when you are not using an exclude (thread or forum) you are still using it in the where clause. This make the query perform less good. I suggest you only include those in the where if you are excluding something.

I would also suggest you prefix all the used Phraseid's and Varnames, for example with the productid, so there can be no problems with other hacks or future vB versions for using the same names.

Gizmo5h1t3 02-11-2006 12:57 PM
qyuestion : is this a hack that just calls a random thread for a section?
or are the threads selectable??

Developer 02-11-2006 01:29 PM
Quote:
Originally Posted by MarcoH64
just a question: is good or bad only determined by the number of replies?
__________________________________________________ ___________
i think it's good and this hack requested in vbh.com with just hack of the day ordered by replies only

Also when you are not using an exclude (thread or forum) you are still using it in the where clause. This make the query perform less good. I suggest you only include those in the where if you are excluding something.
__________________________________________________ ___________
i think this is the best way :surprised:

I would also suggest you prefix all the used Phraseid's and Varnames, for example with the productid, so there can be no problems with other hacks or future vB versions for using the same names.
__________________________________________________ ___________
ok i'll keep this in mind and now i am putting such a codes like devel,developer,first letter hack name like this hack i used bwt (best&worst thread)
my reply in green

Developer 02-11-2006 01:31 PM
Quote:
Originally Posted by Gizmo5h1t3
qyuestion : is this a hack that just calls a random thread for a section?
or are the threads selectable??
it calls all threads that's not in the exclude forums and threads then ordered by posts

kofoid 02-11-2006 03:08 PM
Do you think that code for FORUMHOME could easily be put into a CMPS Module?

GamerJunk.net 02-11-2006 03:16 PM
Database error in vBulletin 3.5.2:

Invalid SQL:

SELECT thread.postusername,
thread.postuserid,
thread.title AS fth,
thread.lastposter,
thread.replycount,
thread.views,
thread.threadid,
thread.forumid tid,
forum.forumid AS fid,
forum.title AS ft
FROM vb3_thread, forum
WHERE forum.forumid = thread.forumid
AND dateline BETWEEN 1139591779 AND 1139764579
AND thread.forumid NOT IN (0)
AND thread.threadid NOT IN (0)
ORDER BY thread.replycount DESC LIMIT 1;

MySQL Error : Table '******_*****.forum' doesn't exist
Error Number : 1146
Date : Saturday, February 11th 2006 @ 12:16:19 PM

apdcanari 02-11-2006 08:51 PM
same error :speechless:

Mr Chad 02-11-2006 09:37 PM
When i enable this i get:

[sql]
Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT thread.postusername,
thread.postuserid,
thread.title AS fth,
thread.lastposter,
thread.replycount,
thread.views,
thread.threadid,
thread.forumid tid,
forum.forumid AS fid,
forum.title AS ft
FROM BlizzedOut_thread, forum
WHERE forum.forumid = thread.forumid
AND dateline BETWEEN 1139613221 AND 1139786021
AND thread.forumid NOT IN ()
AND thread.threadid NOT IN ()
ORDER BY thread.replycount DESC LIMIT 1;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND thread.threadid NOT IN ()
ORD
Error Number : 1064
Date : Saturday, February 11th 2006 @ 06:13:42 PM
Script : http://www.BeastToast.com/forums/index.php?
Referrer :
IP Address : *.*.*.*
Username : Chad
Classname : vb_database
[/sql]


All times are GMT. The time now is 11:23 PM.
Page 1 of 8 1 23 Last »
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.01460 seconds
  • Memory Usage 1,753KB
  • 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_code_printable
  • (2)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
  • (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