none
Hidden Link Spam in Forum Posts RRS feed

  • Question

  • I just found the following hidden link spam (...greyin.net...)  in a sql documentation thread:

    class="body"><blockquote>
    <p>Welcome to the forum. Here is a hyperlink to Pinalkumar Dave's blog that has a download for the keyboard
    <a href="http://www.greyin.net/th/relationships/how-to-make-up-with-your-ex-girlfriend.html" style="color:#333; text-decoration:none">
    shortcuts</a> for SSMS. He has created quite a comprehensive list that is very useful.</p>
    <p align="left">&nbsp;</p>
    <p align="left">&nbsp;</p>
    <p align="left">&nbsp;</p>
    <p align="left"><a title="http://blog.sqlauthority.com/2007/05/04/sql-server-download-sql-server-management-studio-keyboard-shortcuts-ssms-shortcuts/" href="http://blog.sqlauthority.com/2007/05/04/sql-server-download-sql-server-management-studio-keyboard-shortcuts-ssms-shortcuts/">http://blog.sqlauthority.com/2007/05/04/sql-server-download-sql-server-management-studio-keyboard-shortcuts-ssms-shortcuts/</a></p>
    <p align="left">&nbsp;</p>
    </blockquote>
    <br/>
    What's the problem? Why I cannot open the link here?</div></div><div 
    

    This is the thread: http://social.msdn.microsoft.com/Forums/en/sqldocumentation/thread/db0a273e-a08e-4a7e-80ca-068e2fd89616


    Kalman Toth SQL SERVER 2012 & BI TRAINING
    New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012
    • Edited by Kalman Toth Monday, October 1, 2012 5:55 PM
    Friday, February 18, 2011 2:44 PM

Answers

  • Thanks, this is a known issue. I don't have an ETA for fixing this, but we will be working on spam mitigation in the coming months.
    Community Forums Program Manager
    • Marked as answer by Kalman Toth Tuesday, February 22, 2011 9:44 PM
    Tuesday, February 22, 2011 5:31 PM
    Answerer

All replies

  • Indeed most spammers reported in the spam report thread are SEO spams like this. You can find more if you search the phrases used by these spammers (there are not a lot of phrases that can fit in every forum).

    The following is signature, not part of post
    Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
    Visual C++ MVP
    Tuesday, February 22, 2011 3:31 AM
  • Here is another - it has been reported to be deleted. Note ...rersoft...

    class="body"><blockquote>
    <p>Hi Jim,</p>
    <p align="left">&nbsp;</p>
    <p align="left">Thank you for your reply. to asnswer your question. the transaction log is saved to the shared disk. before almost 2 years ago we haven't encounter this problem. just then that our shared drive queue is in higher performance. as what we did
     to the&nbsp;other PC or Servers if the disk queue is in high performance we just defrag the drive and the operation is back to its normal. we might also think that this will also&nbsp;<a href="http://www.rersoft.com/download/download-zen-x-fi-wlan-movie-converter-patch.html" style="color:#333; text-decoration:none">help</a>
     us to reolve the issue. </p>
    <p align="left">&nbsp;</p>
    <p align="left"><font face="Arial" size="2"></font>&nbsp;</p>
    </blockquote>
    <br/>
    Thanks for your analysis! It's quite useful.</div></div><
    

    A second one (reported) - Notice ...infosum.net...:

    <blockquote>Nonrepeatabel read: If somebody&nbsp;<a href="http://www.infosum.net/fr/programming/ajax-tutorial-with-fbjs-in-facebook-application.html" style="color:#333; text-decoration:none">performed</a> UPDATE or DELETE of any of the rows you read earlier.<br/>
    <br/>
    Phantom: If anybody INSERTed a row within the range you had for an earlier query (i.e., you see new rows).
    <hr class="x_sig">
    Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi</blockquote>
    <br/>
    Perhaps it's a stupid question, Why this? Please explain it in details.</div><

     


    Kalman Toth, Admin/Prog, SSAS, SSIS, SSRS; SQL 2008 GRAND SLAM

    Tuesday, February 22, 2011 8:38 AM
  • you can report to the spam report thread..

    The following is signature, not part of post
    Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
    Visual C++ MVP
    Tuesday, February 22, 2011 2:42 PM
  • Reported. Naomi brought it to my attention the apparently common tag:

    <style="color:#333; text-decoration:none">
    

    Kalman Toth, Admin/Prog, SSAS, SSIS, SSRS; SQL 2008 GRAND SLAM
    • Edited by Kalman Toth Tuesday, February 22, 2011 5:40 PM
    Tuesday, February 22, 2011 5:06 PM
  • Thanks, this is a known issue. I don't have an ETA for fixing this, but we will be working on spam mitigation in the coming months.
    Community Forums Program Manager
    • Marked as answer by Kalman Toth Tuesday, February 22, 2011 9:44 PM
    Tuesday, February 22, 2011 5:31 PM
    Answerer
  • I would put link rel=nofollow above this, because even if you ban 333 you an still use 332,334, 333332,333334, etc.

    The following is signature, not part of post
    Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
    Visual C++ MVP
    Tuesday, February 22, 2011 5:54 PM
  • Sheng,

    Can you explain me what exactly can be achieved by embedding such SPAM in the text? It can not be clicked, so except for pollution (extra messages), I don't understand the exact impact.


    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    Tuesday, February 22, 2011 10:19 PM
    Moderator
  • Make the linked web site to be indexed quicker by search engines and appear higher in the search results of the linked text. On the web traffic is money. That's why Microsoft's forum is ranked lower than content farm web sites who duplicate Microsoft forum content and add ads.

    Wordpress has rel=nofollow on by default. Slashdot adds rel="nofollow" only for potentially misbehaving users.



    The following is signature, not part of post
    Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
    Visual C++ MVP
    Wednesday, February 23, 2011 3:31 AM
  • Yes, we have a bug on adding nofollow to the hrefs, bugs on not allowing users to include hrefs, and a lot of other tactics. Spam mitigatin will likely include a few different aspects.
    Community Forums Program Manager
    Wednesday, February 23, 2011 3:48 AM
    Answerer
  • To respond to what Sheng said:

     

    He is right on. To elaborate more, even though you and me can not see these said links(i.e. we would never click on them) -- It doesn't mean that the search engines do not see them. So it helps them by passing authority or "trust" to their sites. Almost as if microsoft's site "trusts" these links so they must be "important". There are many forums where this takes place--not just here.


    Mixing web dev with beer pong. Why not...
    Wednesday, February 23, 2011 8:24 PM
  • I see, thanks to all for explanation.
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    Wednesday, February 23, 2011 8:50 PM
    Moderator
  • In the current and reported samples the hyperlink keywords are:

    shortcuts

    help

    performed

    repost

    files

    quite

    encountered

    Certainly "reasonable" to a search engine.

    Another html source:

    ><div class="container"><div class="body"><br/>
    Where is the new post? Did you <a href="http://www.powdershell.com/pt/press-release/the-new-canon-ixus-digital-camera-s-design-and.html" style="color:#333; text-decoration:none">
    repost</a> it?</div></div>

    Kalman Toth, Admin/Prog, SSAS, SSIS, SSRS; SQL 2008 GRAND SLAM
    Wednesday, February 23, 2011 9:46 PM