vb.org Archive
Page 16 of 92 « First 61415 16 17182666 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Add-On Releases - vBISpy - AJAX real-time feed of new posts/threads (https://vborg.vbsupport.ru/showthread.php?t=125947)

bashy 09-08-2006 11:50 PM
Hi m8, thanks but changing that actually stops it displaying any posts!! :(

Its this ya need to change ;)

PHP Code:
        ORDER BY lastpost DESC LIMIT 10"); 
Also....ya need to add more lines here i think, then perhaps change your amount that you posted

PHP Code:
<tr id="row1" style="display: none;"></tr>
<tr id="row2" style="display: none;"></tr>
<tr id="row3" style="display: none;"></tr>
<tr id="row4" style="display: none;"></tr>
<tr id="row5" style="display: none;"></tr>
<tr id="row6" style="display: none;"></tr>
<tr id="row7" style="display: none;"></tr>
<tr id="row8" style="display: none;"></tr>
<tr id="row9" style="display: none;"></tr>
<tr id="row10" style="display: none;"></tr>
<tr id="row11" style="display: none;"></tr>
<tr id="row12" style="display: none;"></tr>
<tr id="row13" style="display: none;"></tr>
<tr id="row14" style="display: none;"></tr>
<tr id="row15" style="display: none;"></tr>
<tr id="row16" style="display: none;"></tr>
<tr id="row17" style="display: none;"></tr>
<tr id="row18" style="display: none;"></tr>
<tr id="row19" style="display: none;"></tr>
<tr id="row20" style="display: none;"></tr>
<tr id="row21" style="display: none; opacity:.85"></tr>
<tr id="row22" style="display: none; opacity:.65"></tr>
<tr id="row23" style="display: none; opacity:.45"></tr>
<tr id="row24" style="display: none; opacity:.25"></tr>
<tr id="row25" style="display: none; opacity:.05"></tr> 
Quote:
Originally Posted by buro9
In the PHP file I noticed a line that had this:
PHP Code:
spymax = 25; 
See what happens when you change it :)

bashy 09-09-2006 12:04 AM
EDIT:

To change the amount of posts to show:
Find and change the 50 to the amount you require
[phpORDER BY lastpost DESC LIMIT 50");[/php]

Find and change the 50 to the amount you require
PHP Code:
    spymax = 50; 
Find and add more rows to the amount that you require
[php]
PHP Code:
<tr id="row1" style="display: none;"></tr>
<tr id="row2" style="display: none;"></tr>
<tr id="row3" style="display: none;"></tr>
<tr id="row4" style="display: none;"></tr>
<tr id="row5" style="display: none;"></tr>
<tr id="row6" style="display: none;"></tr>
<tr id="row7" style="display: none;"></tr>
<tr id="row8" style="display: none;"></tr>
<tr id="row9" style="display: none;"></tr>
<tr id="row10" style="display: none;"></tr>
<tr id="row11" style="display: none;"></tr>
<tr id="row12" style="display: none;"></tr>
<tr id="row13" style="display: none;"></tr>
<tr id="row14" style="display: none;"></tr>
<tr id="row15" style="display: none;"></tr>
<tr id="row16" style="display: none;"></tr>
<tr id="row17" style="display: none;"></tr>
<tr id="row18" style="display: none;"></tr>
<tr id="row19" style="display: none;"></tr>
<tr id="row20" style="display: none;"></tr>
<tr id="row21" style="display: none; opacity:.85"></tr>
<tr id="row22" style="display: none; opacity:.65"></tr>
<tr id="row23" style="display: none; opacity:.45"></tr>
<tr id="row24" style="display: none; opacity:.25"></tr>
<tr id="row25" style="display: none; opacity:.05"></tr> 
This is mine as i have set it to 50
PHP Code:
<tr id="row1" style="display: none;"></tr>
<tr id="row2" style="display: none;"></tr>
<tr id="row3" style="display: none;"></tr>
<tr id="row4" style="display: none;"></tr>
<tr id="row5" style="display: none;"></tr>
<tr id="row6" style="display: none;"></tr>
<tr id="row7" style="display: none;"></tr>
<tr id="row8" style="display: none;"></tr>
<tr id="row9" style="display: none;"></tr>
<tr id="row10" style="display: none;"></tr>
<tr id="row11" style="display: none;"></tr>
<tr id="row12" style="display: none;"></tr>
<tr id="row13" style="display: none;"></tr>
<tr id="row14" style="display: none;"></tr>
<tr id="row15" style="display: none;"></tr>
<tr id="row16" style="display: none;"></tr>
<tr id="row17" style="display: none;"></tr>
<tr id="row18" style="display: none;"></tr>
<tr id="row19" style="display: none;"></tr>
<tr id="row20" style="display: none;"></tr>
<tr id="row21" style="display: none;"></tr>
<tr id="row22" style="display: none;"></tr>
<tr id="row23" style="display: none;"></tr>
<tr id="row24" style="display: none;"></tr>
<tr id="row25" style="display: none;"></tr>
<tr id="row26" style="display: none;"></tr>
<tr id="row27" style="display: none;"></tr>
<tr id="row28" style="display: none;"></tr>
<tr id="row29" style="display: none;"></tr>
<tr id="row30" style="display: none;"></tr>
<tr id="row31" style="display: none;"></tr>
<tr id="row32" style="display: none;"></tr>
<tr id="row33" style="display: none;"></tr>
<tr id="row34" style="display: none;"></tr>
<tr id="row35" style="display: none;"></tr>
<tr id="row36" style="display: none;"></tr>
<tr id="row37" style="display: none;"></tr>
<tr id="row38" style="display: none;"></tr>
<tr id="row39" style="display: none;"></tr>
<tr id="row40" style="display: none;"></tr>
<tr id="row41" style="display: none; opacity:.95"></tr>
<tr id="row42" style="display: none; opacity:.85"></tr>
<tr id="row43" style="display: none; opacity:.75"></tr>
<tr id="row44" style="display: none; opacity:.65"></tr>
<tr id="row45" style="display: none; opacity:.55"></tr>
<tr id="row46" style="display: none; opacity:.45"></tr>
<tr id="row47" style="display: none; opacity:.35"></tr>
<tr id="row48" style="display: none; opacity:.25"></tr>
<tr id="row49" style="display: none; opacity:.15"></tr>
<tr id="row45" style="display: none; opacity:.08"></tr> 

Lizard King 09-09-2006 09:21 AM
All the credit goes to TECK ( Floren )

In order to optimize the code Replace
Code:
    $getthreads = $db->query_read("
            SELECT thread.*, post.pagetext AS preview, post.userid AS lastpuserid
            FROM ".TABLE_PREFIX."thread AS thread
            LEFT JOIN ".TABLE_PREFIX."deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
            LEFT JOIN ".TABLE_PREFIX."post AS post ON(post.postid = thread.lastpostid)
            WHERE open <> 10 AND thread.lastpostid > $lastpostid
            AND forumid NOT IN (0$blockforums)
            AND thread.visible = '1'
            AND deletionlog.primaryid IS NULL
            ORDER BY lastpost DESC LIMIT 10");
with
Code:
        // The number of days to scan the table for ...
        // 86400 represents the number of seconds in 24hrs
        $daysprune = 1;
        $datecut = "AND thread.lastpost >= " . (TIMENOW - ($daysprune * 86400));

        $getthreads = $db->query_read("
                SELECT thread.*, post.pagetext AS preview, post.userid AS lastpuserid
                FROM " . TABLE_PREFIX . "thread AS thread
                LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
                LEFT JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = thread.lastpostid)
                WHERE open <> 10 AND thread.lastpostid > $lastpostid
                        AND forumid NOT IN (0$blockforums)
                        AND thread.visible = '1'
                        AND deletionlog.primaryid IS NULL
                        $datecut
                ORDER BY thread.lastpost DESC LIMIT 10
        ");

MPDev 09-09-2006 09:25 PM
Just curious about adding that to the query; does that speed up the query or is it to just make sure you only grab something from the past day?

Cole2026 09-09-2006 09:32 PM
Problem here.

The query is going correctly, it has valid information in it:
http://yourconvo.com/forums/vaispy.php?do=xml

However, The actual page is not filling up with data.
http://www.yourconvo.com/forums/vaispy.php

da420 09-09-2006 09:34 PM
Quote:
Originally Posted by Cole2026
Problem here.

The query is going correctly, it has valid information in it:
http://yourconvo.com/forums/vaispy.php?do=xml

However, The actual page is not filling up with data.
http://www.yourconvo.com/forums/vaispy.php
What do you mean it's not filling up with data?

It seems to be working for me...

DementedMindz 09-09-2006 09:35 PM
yeah me too

Cole2026 09-09-2006 09:40 PM
I just figured out what's wrong.

It won't work when there is no www.

MPDev 09-10-2006 02:57 AM
I made an update with some minor changes to the JavaScript to remove the split strings.

I'm not sure what to do about Opera; I just dont use it to know enough what might need to be done. I wonder if it works like IE and we need:

Code:
if (is_ie || is_opera)
in the javascript file va_spy.js.

Wired1 09-10-2006 03:39 AM
Quote:
Originally Posted by bashy
This is mine as i have set it to 50
PHP Code:
<tr id="row49" style="display: none; opacity:.15"></tr>
<tr id="row45" style="display: none; opacity:.08"></tr> 
row 49, then 45? :)


All times are GMT. The time now is 01:33 PM.
Page 16 of 92 « First 61415 16 17182666 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.01737 seconds
  • Memory Usage 1,840KB
  • 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
  • (3)bbcode_code_printable
  • (7)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (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