Forum Extensions

[plb]

This is a little ironic. I'm rushing to get out of thr house to go to Reno to teach a couple classes on SQL. In my opening lecture I will say that SQL is a set processing language in which you normally don't need looping.

I look in the .sql scripts jimibt provides and I see a lot of temp tables and loops. I have been tying to resurect a five year old forum I wrote. As I remember all the PROCs were set based.

Sorry gotta go. More later. I will study the PROCs that jimibt provided - maybe that's the way to go.

http://weboperahouse.com

[jimibt]

quote:Originally posted by plb
 This is a little ironic. I'm rushing to get out of thr house to go to Reno to teach a couple classes on SQL. In my opening lecture I will say that SQL is a set processing language in which you normally don't need looping.

I look in the .sql scripts jimibt provides and I see a lot of temp tables and loops. I have been tying to resurect a five year old forum I wrote. As I remember all the PROCs were set based.

Sorry gotta go. More later. I will study the PROCs that jimibt provided - maybe that's the way to go.

http://weboperahouse.com

plb - i'd say that it's 'a way' to go, not sure if it's 'the way' to go mind you. likewise, this is prolly the only time that i've used loops in my t-sql 'ever' but can't think of another way to achieve the same result easily. of course, here's hoping that you dig in a bit and optimise it further :)

all the best

jimi

[edit] - i'd also be interested to see any approach that you'd take to promote those sp's up thro' the DAL etc to the UI. that's the end game really...

[jimibt]

ok - updated my ForumsUpdate.zip with additional code in the Post.cs class to purge the forums cache on any post action (i.e BizObject.PurgeCacheItems("forums_forums");). [this was to resolve an issue where the posts count and last post values weren't being updated when new posts were added]

all works as expected now and ready to be tweaked by someone else to the next level.

jim

http://www.eventdriventhing.com/sql/ForumsUpdate.zip

[99mary]

Hello!
Could not find stored procedure 'tbh_Forums_UnCloseThread'.
jimibt please add code of the stored procedure

And one mistake
It is impossible add new forum on page ManageForums.aspx
even added
      <InsertParameters>
           <asp:Parameter Name="title" Type="String" />
           <asp:Parameter Name="moderated" Type="Boolean" />
           <asp:Parameter Name="importance" Type="Int32" />
           <asp:Parameter Name="description" Type="String" />
           <asp:Parameter Name="imageUrl" Type="String" />
           <asp:Parameter Name="lastpostby" Type="String" />
           <asp:Parameter Name="lastpostdate" Type="DateTime" />
           <asp:Parameter Name="posts" Type="Int32" />
           <asp:Parameter Name="topics" Type="Int32" />
       </InsertParameters>

in base record is added, but on page ManageForums.aspx, ShowForums.aspx no.
And at accompaniment of the new forum is required nonzero field description, earlier so was not
possible, there was add and without description

Sorry for bad english.

[jimibt]

quote:Originally posted by 99mary


Hello!
Could not find stored procedure 'tbh_Forums_UnCloseThread'.
jimibt please add code of the stored procedure

And one mistake
It is impossible add new forum on page ManageForums.aspx
even added
     <InsertParameters>
         <asp:Parameter Name="title" Type="String" />
         <asp:Parameter Name="moderated" Type="Boolean" />
         <asp:Parameter Name="importance" Type="Int32" />
         <asp:Parameter Name="description" Type="String" />
         <asp:Parameter Name="imageUrl" Type="String" />
         <asp:Parameter Name="lastpostby" Type="String" />
         <asp:Parameter Name="lastpostdate" Type="DateTime" />
         <asp:Parameter Name="posts" Type="Int32" />
         <asp:Parameter Name="topics" Type="Int32" />
     </InsertParameters>

in base record is added, but on page ManageForums.aspx, ShowForums.aspx no.
And at accompaniment of the new forum is required nonzero field description, earlier so was not
possible, there was add and without description

Sorry for bad english.

99mary,

no problems with your english - understand perfectly!! :)

ok, i've updated the UpdateForums.zip file, so if you pick it up, the stored proc 'tbh_Forums_UnCloseThread' is there, as are the updated sp's for getforums etc..

the problem that you had was probably due to the initial tbh_Forums_GetForums sp not doing an outer join test on post, therefore, it wasn't showing any rows for forums that contained no posts. i've sorted this now and you'll need to update tbh_Forums_GetForums again and all should work fine.

let me know how you get on. (also, any errors that you fix and/or optimisations, be sure to pass those on too ;)

jim

http://www.eventdriventhing.com/sql/ForumsUpdate.zip

[99mary]

Hi,
Regrettably in archive no the stored proc 'tbh_Forums_UnCloseThread'.
So can not check possible open subjects anew.

New forum now adds, but requires nonzero field description, url, that not comfortable.

And one error on page ShowForums.aspx:
since I use Russian
field LastPostBy is displayed in wrong coding.
I do not know why. On other page is displayed orderly.


I have added on forum on pages ShowThread.aspx navigation
            <pagersettings mode="NumericFirstLast"
            firstpagetext="first"
            lastpagetext="last"
            pagebuttoncount="3"
            position="TopAndBottom"/>

and on pages BrowseThreads.aspx.cs
            Forum forum = Forum.GetForumByID(int.Parse(forumID));
            this.Title = string.Format(this.Title, forum.Title);
            ddlForums.SelectedValue = forumID;
in lieu thereof
            Forum forum = Forum.GetForumByID(int.Parse(forumID));



Respectfully yours, Mary

[jimibt]

quote:Originally posted by 99mary
 Hi,
Regrettably in archive no the stored proc 'tbh_Forums_UnCloseThread'.
So can not check possible open subjects anew.

New forum now adds, but requires nonzero field description, url, that not comfortable.

And one error on page ShowForums.aspx:
since I use Russian
field LastPostBy is displayed in wrong coding.
I do not know why. On other page is displayed orderly.


I have added on forum on pages ShowThread.aspx navigation
            <pagersettings mode="NumericFirstLast"
            firstpagetext="first"
            lastpagetext="last"
            pagebuttoncount="3"
            position="TopAndBottom"/>

and on pages BrowseThreads.aspx.cs
            Forum forum = Forum.GetForumByID(int.Parse(forumID));
            this.Title = string.Format(this.Title, forum.Title);
            ddlForums.SelectedValue = forumID;
in lieu thereof
            Forum forum = Forum.GetForumByID(int.Parse(forumID));



Respectfully yours, Mary

hi again mary,

the proc 'tbh_Forums_UnCloseThread' is actually in the archive. i think you may have to clear your browser cache and then click the download link again. otherwise if you're having issues getting the latest version, i'll rename it and then you may have more success.

let me know how you get on, and i'll try your additions too ;)

cheers

jmi

[plb]

Bug in Forum ?

I can't really tell because I've made so many changes to the forum that it may be a bug that only exists in my implimentation.

In TBH forum's data design a thread is identified as a post with ParentPostID of 0. If you are logged on as the administrator and you try to delete a regular posting you get a warning message asking you to verify the deletion of post. The deletion of a single post works fine as far as can tell. However if from the ShowThread page you delete a thread (parentID = 0) you get a nasty error message.

Deleting a thread from the BrowseThreads page works OK. I think I see what's happening with the deletion bug but I won't bother to fix it myself if its part of the Starter Kit code.


http://weboperahouse.com

[plb]

My forum extentions so far have been reserved for cosmetics not functionality. In an effort to make my forum look more like the popular PHP forum software vBulletin, I have emulated their UI. Instead of text links I have substituted graphic buttons. I'm only at down to the BrowseThread level but I will work my way down through all the pages.



http://weboperahouse.com

[99mary]

When viewing the page ShowThread.aspx is changed number of the users in network - time their last activity, possible somehow this avoid, so in network from users only I?