SQL Server Performance

New forum?

Discussion in 'Please Tell Us What You Think' started by FrankKalis, Nov 5, 2003.

  1. FrankKalis Moderator

    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=':D' />]<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>
  2. bambola New Member

    &gt; 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 />
  3. satya Moderator

    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
  4. FrankKalis Moderator

    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=':D' />].<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>
  5. bradmcgehee New Member

    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
  6. Luis Martin Moderator

    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
  7. FrankKalis Moderator

    <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>
  8. satya Moderator

    True, further I would suggest to discount posts made on SQL-Server-Performance.Com Other category forum.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  9. FrankKalis Moderator

    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>
  10. bambola New Member

    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.

  11. satya Moderator

    ... great minds are at work...

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  12. FrankKalis Moderator

    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
  13. bradmcgehee New Member

    Thanks for the feedback and tips.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com

Share This Page