vb.org Archive
Page 3 of 4 12 3 4
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Recently Viewed Threads (https://vborg.vbsupport.ru/showthread.php?t=107739)

bashy 02-12-2006 06:55 PM
Whats the text box with Test in it in your image Livewire?

Logikos 02-12-2006 07:16 PM
This post marks a newer version

v1.2 Beta Released

The forumhome Recent table can now be collapsed. The Main Zip file has been updated. For those who wish to upgrade there templates, please follow these Template Instructions:

Template Forumhome:
------------------------------
Find:
HTML Code:
        <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center" id="threadslist">
        <tr>
                <td colspan="6" class="tcat">Recently Viewed Threads</td>
        </tr>
        <tr>
                <td class="thead" colspan="2">&nbsp;</td>
                <td class="thead" width="100%">$vbphrase[thread] / $vbphrase[thread_starter]</td>
                <td class="thead" width="150" align="center" nowrap="nowrap"><span style="white-space:nowrap">$vbphrase[last_post]</span></td>
                <td class="thead" align="center" nowrap="nowrap"><span style="white-space:nowrap">$vbphrase[replies]</span></td>
                <td class="thead" align="center" nowrap="nowrap"><span style="white-space:nowrap">$vbphrase[views]</span></td>
        </tr>

        $recentbits
        </table>
Replace With
HTML Code:
        <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center" id="threadslist">
        <tbody>
        <tr>
                <td colspan="6" class="tcat">
                        <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_recent')"><img id="collapseimg_forumhome_recent" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_forumhome_recent].gif" alt="" border="0" /></a>
                        Recently Viewed Threads
                </td>
        </tr>
        </tbody>
        <tbody id="collapseobj_forumhome_recent" style="$vbcollapse[collapseobj_forumhome_recent]">
        <tr>
                <td class="thead" colspan="2">&nbsp;</td>
                <td class="thead" width="100%">$vbphrase[thread] / $vbphrase[thread_starter]</td>
                <td class="thead" width="150" align="center" nowrap="nowrap"><span style="white-space:nowrap">$vbphrase[last_post]</span></td>
                <td class="thead" align="center" nowrap="nowrap"><span style="white-space:nowrap">$vbphrase[replies]</span></td>
                <td class="thead" align="center" nowrap="nowrap"><span style="white-space:nowrap">$vbphrase[views]</span></td>
        </tr>
        $recentbits
        </tbody>
        </table>

Logikos 02-12-2006 07:17 PM
Quote:
Originally Posted by bashy
Whats the text box with Test in it in your image Livewire?
That is a title of a thread. You can use AJAX to edit the titles and close threads.

bashy 02-12-2006 07:19 PM
Great m8, thanks for doing this :)
Works well

Bison 02-12-2006 11:00 PM
Good work! *Installed*

sonicdriven 02-13-2006 08:33 PM
I was going to try and create this hack myslef but why when yours works perfect! Install was smooth as can be! I'm going to try and extend this so it can be used on the pages created with the Drupal Plugin..

Awesome Job, not shabby at all, a much needed mod for VB IMO.

dxguru 02-15-2006 01:35 PM
Could this be done so that it shows on the users MEMBERPROFILE page?
ie when I look at someone elses profile I see the threads they have recently viewed.

bashy 02-16-2006 03:27 PM
Hi

It appears that i am now getting this DB error whilst using your hack

Code:
Database error in vBulletin 3.5.3:

Invalid SQL:

                        SELECT post.pagetext AS preview,
                                thread.threadid, thread.title AS threadtitle, lastpost, forumid, pollid, open, replycount, postusername, postuserid, lastposter,
                                thread.dateline, views, thread.iconid AS threadiconid, notes, thread.visible
                               

                        FROM thread AS thread
                       
                        LEFT JOIN recentlyviewed AS recentlyviewed ON(recentlyviewed.threadid = thread.threadid)
                        LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
                        WHERE thread.threadid IN(132,1550,1584,1580,1585,1573,1586,1587,1588,1381,1589,1559,1590,1591,1579,92,1594,1595,1597,1562,1596,1599,1600,1565,1602,1603,1577,1605,1608,1623,1625,1624,1627,1628,1629,1622,1630,1643,1645,1644,1641,1647,942,362,509,1581,1606,1648,1345,1620,1089,1649,130,1651,1650,1505,1658,1668,1666,1413,1667,1660,1663,1669,554,993,1384,1670,1672,1673,1390,1635,1677,1675,1676)
                        ORDER BY recentlyviewed.dateline DESC
                        LIMIT 5;

MySQL Error  : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay Error Number : 1104
Date        : Thursday, February 16th 2006 @ 02:11:15 PM
Script      : http://www.bashys-place.com/forums/
Referrer    :
Please advise?

Logikos 02-16-2006 05:02 PM
Bashy. Log into the Admincp and go to Execute SQL Query and run this query:

[sql]
DELETE FROM recentlyviewed
WHERE dateline < (1140115611 - 3600)
[/sql]
This should fix it for a couple of days. When I get home I'll create a maintance script. :)

bashy 02-16-2006 05:09 PM
Ok m8 thanks for that....
I take it without a main fix i will get the issue again, if ya not done the main fix by then do i run that again if i get the same issue?


All times are GMT. The time now is 03:51 PM.
Page 3 of 4 12 3 4
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.01151 seconds
  • Memory Usage 1,760KB
  • 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)bbcode_code_printable
  • (2)bbcode_html_printable
  • (1)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