vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Portal Software - vBISpy module - live AJAX feed of new threads - for vBAdvanced CMPS (https://vborg.vbsupport.ru/showthread.php?t=126421)

MPDev 05-23-2007 04:55 PM

I will try to take a look; I wasn't aware there was an update.

Red Blaze 05-23-2007 09:36 PM

I'm getting this error when I try to upload the module:

Quote:

Database error in vBulletin 3.6.7:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO forumadv_modules
(`0`, `active`, `userperms`)
VALUES
('', '1', '4,6,7,2,9,5,1,3');

MySQL Error : Unknown column '0' in 'field list'
Error Number : 1054
Date : Wednesday, May 23rd 2007 @ 10:33:14 PM
Script : http://www.***********.net/admincp/v...o=uploadmodule
Referrer : http://www..***********.net/admincp/...hp?do=download
IP Address : **.***.**.***
Username : Red Blaze
Classname : vb_database
This is what I'm gettin. Stud did point out that this would need to be updated. I would love this. I'm using vBadvanced CMPS v3.0 RC1.

EDIT: Welp, I got it to work manually. Opened the module file in a txt file and just copy pasted the template code. Good stuff. Thanks. ^_^

voter 05-24-2007 01:43 PM

Quote:

Originally Posted by Red Blaze (Post 1253488)
I'm getting this error when I try to upload the module:



This is what I'm gettin. Stud did point out that this would need to be updated. I would love this. I'm using vBadvanced CMPS v3.0 RC1.

EDIT: Welp, I got it to work manually. Opened the module file in a txt file and just copy pasted the template code. Good stuff. Thanks. ^_^

Same by me
Quote:

Database error in vBulletin 3.6.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO vbadv_modules
(`0`, `active`, `userperms`)
VALUES
('', '1', '4,6,7,5,1,3,2,13,15,18,17,14,16,19');

MySQL Error : Unknown column '0' in 'field list'
Error Number : 1054

stud 05-24-2007 02:23 PM

Quote:

Originally Posted by MPDev (Post 1253322)
I will try to take a look; I wasn't aware there was an update.

Thanks MPDev... sorry that we all seem so impatient.. as I've indicated before, this could easily be one of the single most popular and important mods for a website running CMPS - as it's FAR superior to the "Recent Threads" Module.

If you are going to go into development to update the functionality of this module, may I re-list a few suggestions people here have made that I don't think ever made it into this version?

a. The ability update without duplication? Currently, if someone makes two posts in a single thread, it will list that thread topic twice rather then just represent the most recent thread. Similar to how the "Recent Threads" module bolds and brings to the top of the list, if the vBIspy module had a way of preventing duplicates, it would be AMAZING.

b. On that same notion, to bold and unbold topics as their status changes from Unread to Read.

c. the ability to minimize it using the #top feature that many other modules use. (this may have been added since the request, it hasen't worked for me since I upgraded to 3.6 so i'm not sure)



Thanks again for your attention on this MPDev.

BozzaJos 05-27-2007 03:55 PM

Well, the new added module file did work and I've got it on my forum now. One thing tho, is it possible to add a scrollbar to the box so that it only shows the first 5 or so and to see the other 15 you'll have to scroll. I would like to have a scrollbar coz now it makes my forum twice the size as that it is at the moment.

Can you please help me with this? Many thanks in advance.

MPDev 05-29-2007 12:36 PM

No, there is not a scrollbar feature available with how this updates HTML tables (not that I know of anyways).

Pirate45 05-30-2007 09:59 AM

Does this not work with vbAdvanced 3.0?

davidw 06-09-2007 02:27 PM

Quote:

Originally Posted by MPDev (Post 1219371)
Sorry guys, I've tried to be as helpful as I can not knowing vBadvanced that well. I had it working on my site and exported the module, but that was the extent of my ability to make it work. The code itself should work just fine, I just dont know how to wrap it up as a module for it to be imported.

I did another export of the file from my current setup which you can try; it works on my current setup with 3.6.4 and vBadvanced. You may need to change the path in the file if you don't use "/forum/vaispy.php"; otherwise the instructions in the original post apply.

I have the module [quoted in this post] working with an exception - I had to add
Code:

<script language="javascript" src="clientscript/va_prototype.js"></script>
<script language="javascript" src="clientscript/va_effects.js"></script>
<script language="javascript" src="clientscript/va_spy.js"></script>
<script language="javascript">
    spymax = 10;
    highestid = 0;
</script>

to the top of the template in order for anything to display. Once done, it worked as described :D

Secondly, there is a missing tag in the first half of the template
Code:

<table class="tborder" cellpadding="0" cellspacing="0" border="0" width="100%" align="center" id="spy_table">
<tr><td colspan="4" class="tcat smallfont" align="left"  style="height:25px;"><strong>&raquo; <a href="/forum/vaispy.php">Live Forum Updates</a></strong></td></tr>
<tr><td width="20" class="tcat" nowrap="nowrap" style="height:25px;">&nbsp;</td>
<td class="tcat" width="190" nowrap="nowrap" style="height:20px;">By</td>
<td class="tcat" width="80%" style="height:20px;">Thread/Post</td>
<td class="tcat" width="200" nowrap="nowrap" style="height:20px;">Forum
</tr>
...

after Forum there is no closing </td> tag. I don't use Opera, so I don't know if it actually hurts anything or not, but I thought I would add that.

stud 06-10-2007 07:25 PM

interesting... thanks for the update David... i'm going to give your suggestions a go tomorrow when i get a minute

MPDev 06-10-2007 10:00 PM

Isn't the head code part of Step 2?


All times are GMT. The time now is 03:59 PM.

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