Web Wiz Forums Modifications - MOD Question; Since You Been Gone

Print Page | Close Window

MOD Question; Since You Been Gone

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Modifications
Forum Description: Mod's and Add-on's for Web Wiz Forums.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20558
Printed Date: 29 March 2026 at 4:41am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: MOD Question; Since You Been Gone

Posted By: jeffdaro
Subject: MOD Question; Since You Been Gone
Date Posted: 05 July 2006 at 9:03pm

in our 7.x forum we had a feature called Since You Been Gone, that was a customized Active Items page. It only showed you items that had been updated either as new topics, or edited since you last read them. It helped cut down a lot of the clutter of the Active Topics page.

I am trying to implement it in 8.x, but I am having a dickens of a time finding each place that the replies happen in the database. It seems to be in more then one place.

I've currently updated new_post.asp, and edit_post.asp as those appear to be the two main places that updates are done to the DB. Where am I missing an update?

Replies:

Posted By: jeffdaro
Date Posted: 06 July 2006 at 2:51am

I think I have solved my problem, and completed the BETA of the MOD. We're still testing it on our forums, but I am happy to share it, if anyone wants to give it a try.

http://www.darofamily.com/jeff/forums/forum_posts.asp?TID=110&PN=1 - Check it out here

Posted By: chorn
Date Posted: 07 July 2006 at 7:55pm

Well, looksl iek the site is back up.

I installed all the code and the stored procedures. and this is what I get when I try to go to the sybg.asp

----------------------------------------------------------------

Server Error in Forum Application
An error has occured while executing SQL query on database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_get_active_topics
File Name:- sybg.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid object name 'tblSYBG'.

----------------------------------------------------------------

The table "dbo.SYBG" does exist in the database and is being populated.

Posted By: chorn
Date Posted: 10 July 2006 at 8:32pm

well, I couldnt find where in the script it was calling the table tblSYBG, so I renamed the table to that and changed the name of it in the stored procedures. Seems to be working now.

Great Mod, Much thanks

Posted By: jeffdaro
Date Posted: 10 July 2006 at 10:08pm

I believe when you created the tables, and SP's maybe you didn't take into consideration the WWF table prefix? I looked at my documentation, and I don't see a reference to tblSYBG, but SYBG.

I am glad you got it working though. Honestly, over on my forums, nobody there including me can survive without this feature, it makes it so much easier to read forums that have a lot of action.

I am hoping some day WWF will include this in their source, and give me some attaboy credit. :)

I am glad you like it, and any feedback is very much welcomed so I can improve the documentation and the MOD, and formally take it out of BETA.

Posted By: jeffdaro
Date Posted: 10 July 2006 at 10:11pm

BTW...I'd love it if anyone using the MOD, just dumped a quick post in the thread on my forums about this MOD, so I know who is using it...just for fun. You don't need to register to post in this forum...

http://www.darofamily.com/jeff/forums/forum_posts.asp?TID=110 - http://www.darofamily.com/jeff/forums/forum_posts.asp?TID=110

Posted By: chorn
Date Posted: 10 July 2006 at 10:39pm

i tried posting on it earlier, and not only did it ask me to register, then it said that I had to wait for administratoe approval to post.