Hi there,<br /><br />what about having a forum for the lighter moments in life?<br />I mean a forum for something that is not so db or sql related. I think I have heard from a friend who knows someone who bets that there is a world outside of databases [<img src='/community/emoticons/emotion-2.gif' alt='' />]<br /><br />...and I do not mean something to chat!<br /><br />Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /<a target="_blank" href=http://www.familienzirkus.de>http://www.familienzirkus.de</a>
> I think I have heard from a friend who knows someone who bets that there is a world outside of databases <br /><br />Don't believe anything you hear!<br /><br />I think it's a great idea <img src='/community/emoticons/emotion-5.gif' alt=';-)' /><br /><br />Bambola.<br />
First of all ... cheers for your century mark... Definetly there will be another world outside databases... and I evoke your idea of forum...with some restrictions. _________ Satya SKJ Moderator SQL-Server-Performance.Com
Thanks satya,<br /><br />a small step for SQL Server Performance, a big step for me...<br />and based on my qualified empirical approach I will beat you ceteris paribus on posts by 09/26/2014.<br />Under the assumption that you stop posting immediately [<img src='/community/emoticons/emotion-2.gif' alt='' />].<br /><br />See what you can do!<br /><br /><br />Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /<a target="_blank" href=http://www.familienzirkus.de>http://www.familienzirkus.de</a>
I'll give it a try. See the new forum called "The Lighter Side of Being a DBA". ----------------------------- Brad M. McGehee, MVP Webmaster SQL-Server-Performance.Com
Great idea, Frank. I suggest no post count. Luis Martin ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true. Bertrand Russell
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by LuisMartin</i><br /><br />Great idea, Frank. I suggest no post count.<br /><hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote"><br />I'm with you, Luis. It shouldn't count.<br />...but, that means to hack the code of the forum software. I run Snitz here for internal purposes and I tell you following and hacking this is sometimes really messy. <br />I mean that's not a trivial thing to do. I'll take a look in the forum of Snitz. Maybe someone else has already done this and is willing to share.<br /><br />I also think that we all can separate quantity from quality. [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /<a target="_blank" href=http://www.familienzirkus.de>http://www.familienzirkus.de</a>
True, further I would suggest to discount posts made on SQL-Server-Performance.Com Other category forum. _________ Satya SKJ Moderator SQL-Server-Performance.Com
he, he don't let it end in some kind of rating system on every reply. [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br />I've just logged in Snitz community and see what I can find.<br /><br />Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /<a target="_blank" href=http://www.familienzirkus.de>http://www.familienzirkus.de</a>
Wouldn't it be easier to leave the number of posts as is, and write a small query that sums all posts that are not in certain forums? Like this there's no need to change anything in the code. I have a copy of Snitz at home. will try to write it later. Bambola.
Good point! Sometimes I don't see the forest for the tree (I hope I can say so?!?) Seems like Brad only needs to hack some lines in topic.asp. '## Forum_SQL - Get original topic and check for the Category, Forum or Topic Status and existence strSql = "SELECT M.M_NAME, M.M_RECEIVE_EMAIL, M.M_AIM, M.M_ICQ, M.M_MSN, M.M_YAHOO" & _ ", M.M_TITLE, M.M_HOMEPAGE, M.MEMBER_ID, M.M_LEVEL, M.M_POSTS, M.M_COUNTRY" & _ ", T.T_DATE, T.T_SUBJECT, T.T_AUTHOR, T.TOPIC_ID, T.T_STATUS, T.T_LAST_EDIT" & _ ", T.T_LAST_EDITBY, T.T_LAST_POST, T.T_SIG, T.T_REPLIES" & _ ", C.CAT_STATUS, C.CAT_ID, C.CAT_NAME, C.CAT_SUBSCRIPTION, C.CAT_MODERATION" & _ ", F.F_STATUS, F.FORUM_ID, F.F_SUBSCRIPTION, F.F_SUBJECT, F.F_MODERATION, T.T_MESSAGE" if CanShowSignature = 1 then strSql = strSql & ", M.M_SIG" end if strSql = strSql & " FROM " & strActivePrefix & "TOPICS T, " & strTablePrefix & "FORUM F, " & _ strTablePrefix & "CATEGORY C, " & strMemberTablePrefix & "MEMBERS M " & _ " WHERE T.TOPIC_ID = " & Topic_ID & _ " AND F.FORUM_ID = T.FORUM_ID " & _ " AND C.CAT_ID = T.CAT_ID " & _ " AND M.MEMBER_ID = T.T_AUTHOR " Frank http://www.insidesql.de http://www.familienzirkus.de
Thanks for the feedback and tips. ----------------------------- Brad M. McGehee, MVP Webmaster SQL-Server-Performance.Com
