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

---

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.

---

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

---

quote:

---

Originally posted by 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?

---

quote:

---

Originally posted by plb

I am continuing to rework the stock forum cosmetically. Today I revised the ShowThreads page. I reworked the Literal that shows the Forum Threads so that it mirrors the style of the site Bread Crumbs. I also changed the layout of the identity block to make it smaller and more compact.

I have made up a set of custom buttons for posting, locking, and quoting but these are a little hard to just substitute. It takes some coding to make image button equivalents.

Its starting to look like a real forum. A couple more days of formatting and then I will add some new functions. Then I think I can use this nice little forum in the new site I'm going to try to build next week.

Pat


http://weboperahouse.com

---

SELECT 
   ForumID, 
   COUNT(PostID) AS NumPosts
FROM 
   dbo.tbh_Posts
GROUP BY 
   ForumID

SELECT 
   ForumID, 
   COUNT(PostID) AS NumThreads
FROM 
   dbo.tbh_Posts
GROUP BY 
   ForumID, 
   ParentPostID
HAVING
   (ParentPostID = 0)

SELECT     
   ForumID, 
   MAX(LastPostDate) AS LastForumPostDate
FROM         
   dbo.tbh_Posts
GROUP BY 
   ForumID

quote:

---

Originally posted by 99mary

Good work jimi.
The Forum now simply excellent!
There was quite well add else voting, as well as searching for on forum.
But anyone have done the choice Avatars (in existing versions this uncomfortably). Necessary to provide possibility of the loading on server and choice with server already.

---

quote:

---

Originally posted by vantoko

Hi Jimi,

can you add in your readme that you should update the posts table in the priority list (set it to 0 ? (if not you get a cast error).
I also saw on your site that you added categories to the forum. did you put that code online?

koen

---

quote:

---

Originally posted by vantoko

no problem. good luck with the gifted geezer :)

---

quote:

---

Originally posted by plb

Ignore all that avatar code I posted before. It creates a serious bug. If you have an UploadFile ascx control in your user profiles you can't register. Th UploadFiles control throws a security exception for unregistered users.

I ripped all of it out of my current project. I will think about this again.

Pat

http://weboperahouse.com

---

quote:

---

Originally posted by 99mary

Choice avatar with loading on server if to whom will be necessary

UserProfile.ascx

<asp:FileUpload ID="filUpload" runat="server" />&nbsp;
<asp:Button ID="btnUpload" runat="server" OnClick="btnUpload_Click" Text="Add" CausesValidation="false" />

UserProfile.ascx.cs

       protected void btnUpload_Click(object sender, EventArgs e)
       {
           lblFeedbackKO.Visible = false;
           lblFeedbackOK.Visible = false;
           if (filUpload.PostedFile != null && filUpload.PostedFile.ContentLength > 0 && filUpload.PostedFile.FileName != string.Empty)
           {
               try
               {
                   // if not already present, create a directory named /Uploads/<CurrentUserName>
                   string dirUrl = (this.Page as MB.TheBeerHouse.UI.BasePage).BaseUrl +
                      "Uploads/" + this.Page.User.Identity.Name;
                   string dirPath = Server.MapPath(dirUrl);
                   if (!Directory.Exists(dirPath))
                       Directory.CreateDirectory(dirPath);
                   // save the file under the user's personal folder
                   string fileUrl = dirUrl + "/" + Path.GetFileName(filUpload.PostedFile.FileName);
                   string _inputFile = fileUrl;
                   string contentType = filUpload.PostedFile.ContentType;
                   int contentLength = filUpload.PostedFile.ContentLength;
                   
                   if (contentType != "image/pjpeg" && contentType != "image/gif" && contentType != "image/jpeg" && contentType != "image/x-png")
                      {
                          lblFeedbackKO.Visible = true;
                          lblFeedbackKO.Text =   "Only GIF, JPEG and PNG image types are supported.";
                          
                      }
                   else

                          if (contentLength > 25000)
                          {
                              lblFeedbackKO.Visible = true;
                              lblFeedbackKO.Text = "Avatar images must be less than 25K in size.";

                          }
                          else
                          {
                              System.Drawing.Image image = System.Drawing.Image.FromStream(filUpload.PostedFile.InputStream);
                              if (!((image.Width > 0 && image.Width <= 100) && (image.Height > 0 && image.Height <= 100)))
                              {
                                  lblFeedbackKO.Visible = true;
                                  lblFeedbackKO.Text = "Avatar images must be no larger than 150 by 150 pixels.";

                              }
                              else
                              {
                                  filUpload.PostedFile.SaveAs(Server.MapPath(fileUrl));
                                  txtAvatarUrl.Text = fileUrl;
                                  lblFeedbackOK.Visible = true;
                                  lblFeedbackOK.Text = "File is successfully added.<br /> For change necessary to save profile.";
                              }
                          }
                          
                  }
               
               catch (Exception ex)
               {
                   lblFeedbackKO.Visible = true;
                   lblFeedbackKO.Text = ex.Message;
               }
           }
       }

---

quote:

---

Originally posted by jimibt

OK,

Finally, the latest version of this forums/posts thing. this release includes both the new layout for the Forum listing as per previous messages, toghether with the much vaunted Priority flag for top level posts (can only be applied by admin/editors of course!!).

ok, grab yourself the code here:

http://www.worldindependentnews.com/files/ForumsUpdateV1.3.zip

---

quote:

---

Originally posted by Maxxim

quote:

---

Originally posted by jimibt

OK,

Finally, the latest version of this forums/posts thing. this release includes both the new layout for the Forum listing as per previous messages, toghether with the much vaunted Priority flag for top level posts (can only be applied by admin/editors of course!!).

ok, grab yourself the code here:

http://www.worldindependentnews.com/files/ForumsUpdateV1.3.zip

---

Jimi, I saw that you have foruns and subforuns, right?
But who do you manage them into your admin pages?

I entered on your site with sampleeditor account but I only see, for example, 5 or 7 "GENERAL FORUMS" etc...

---