|
February 22, 2012
|
|
Search_Blog
|
 |
|
|
|
|
|
Blog_Archive
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Blog
|
|
|
View_Blog
|
|
|
Jan
25
Written by:
host
Wednesday, January 25, 2012 9:09 PM
Lately my site has become a target of posters of a Chinese footware reseller ... amoung other things
Both the blog and the forum has been ``attacked`` by various spammers leaving excessive number ofposting and comments. The following are the steps I have taken to remove the unwanted entries.
Currently this site is a rather dated - but functional - DNN 4.9.4 - so these steps may not working the more currently versions of DNN, but the methods may prove helpful.
NOTE: These tips use T-SQL to update the DNN database directly. I recomend backup the database prior to any changes. Also, both the blog module and the forum module provide a method to delete individual entries. If the number of entries is low, you may want to use that method.
Cleaning the forum
1) determine the userid of the user entring the posts.
2) Via the User Manager I unathorize the user to stop future posting. However typically they will just register another account.
3) Using the Host SQL module I get a list of PostIDs as follows:
Select * from dbo.Forum_posts where userid = 1234
4) Still using the Host SQL module I execute the appropriate stored procedure to delete the post
Exec dbo.Forum_Post_Delete 1111, 3, `spam`, 2
where 1111 is the postid, 3 is the admin id, `spam` is the reason for deleting, 2 is the portalID containing the posts. Repeat the execution of the procedure changing the PostID based on the list from step 3. Luckly, I had not had many so I do it manually , however it would not take much to create a new procedure to delete all post for a userid. NOTE: You will need to change the value of the Admin UserID and the PortalID to match your site.
Cleaning the Blog comments
1) Attempt to determine the UserID of the user posting the comments
2) Unathorize the User to ensure no new comments.
3) Using the Host SQL module delete all the post by the user
Delete dbo.Blog_Comments where UserID = 1234
Hope this helps
Paul
Tags:
26 comment(s) so far...
Re: Chinese Footware - and the removal of...
Cheap Moncler Jackets has began his fashion pace and developed fashion products to enter the fashion world after his 50th anniversary.
By Abercrombie & Fitch Düsseldorf on
Sunday, January 29, 2012 1:28 AM
|
Re: Chinese Footware - and the removal of...
What a fun pattern! It's great to hear from you and see what you've sent up to. All of the projects look great! You make it so simple to this. Thanks
By Abercrombie Fitch Düsseldorf on
Sunday, January 29, 2012 1:30 AM
|
cheap oakley sunglasses
cheap oakleys
oakleys
RGNPJLWMDFFYY I like it very much!
By cheap oakley sunglasses on
Tuesday, January 31, 2012 1:50 AM
|
Re: Chinese Footware - and the removal of...
In this modern and fashionable society, people are pursuing for oakley sunglasses online cool, unique, stylish and innovative. Whether it is cheap oakley sunglasses or fashion accessories all means a lot for modern society of today. Same is the case with trendy looking fake oakley sunglasses. When these are tiffany jewellery uk, the excitement just gets doubled. Most chic looking tiffany and co are in fashion now. These are one of the favorite fashion accessories for men and women long time ago. If you have not yet tried tiffany co jewellery, it's time to own one and feel the difference it can make to your personality. These are just brilliant and fabulous tiffany jewellery. They are most iconic and can provide you with a new feeling and enhance confidence. The quality of tiffany uk is just superior to what you have dreamt of.
By links of London on
Tuesday, January 31, 2012 1:59 AM
|
echarpe burberry
On estime surtout sac burberryles truites de l'arrondissement burberry pas cherde Vend?me et particulièrementsac burberry pas chercelles de la Braye et du Loirburberry soldes, dont les carpes dorées echarpe burberryjouissent aussi d'unetrench burberrycertaine réputation www.sacburberryspascher.com/.
By lena on
Wednesday, February 01, 2012 10:12 PM
|
guess sac
mais rarement, le fleuve sac guessjusqu'à Orléans. L'anguille etla guess sactanche sont les h?tes les plus ordinaires sac a main guessdes étangs, où l'on rencontresacs guessaussi la sangsue www.sacsguess.com/.
By Lillian on
Wednesday, February 01, 2012 10:13 PM
|
Re: Chinese Footware - and the removal of...
GameCoach Factory Outlet Onlineare usuallyCoach Factoryin By Coach Outlet Online on
Thursday, February 02, 2012 1:00 AM
|
|
|
sac
Attaché Publicité Sorciers requin tn pas cher avant Avancé André ( espace) un nouveau jordan shoes nike air max reste encore Banc botte ugg moncler demande et sera certainement laisser passer requin pas cher mois . Assistants mentor Randy (vide) ugg soldes gucci france Whitman et l' sac a ugg main dans la course technologique Les cours , avant l' nike pas chere Rapports éditeurs étaient sont sac acheter ugg gucci laissé entendre.
Tout au long sacs de tn requin foot locker la dernière aventure contre le Sorciers jeu , nike air max pas cher Bracher blessés se blesser. Juste après chaussures ugg sacs gucci une ugg sorte d' foot locker europe IRM, le médecin le g. p décerné son propre cheap jordan shoes nike air rift aide autres parties .
chaussures requin sac gucci pas cher Dernières sac pas cher recherches air max nike par, caractéristiques Télévision son adapté jordan 6 nues doudoune moncler pas cher et aussi oublié tn nike gucci soldes sacs 3 air max 2011 Correspondances . Cette année , cet individu Dix cheap jordans idées doudoune pas cher avec cinq nike tn pas cher sac gucci pas cher timberland chaussures air max 1 récupère.
Compte tenu du fait que acquises clinique air jordans survivent moncler pas cher période , est tn pas cher sac à main gucci timberland pas cher air max classic pour le régulières en plus. Pour compenser cheap jordan shoes pour l' nike pas cher ne suffit pas nike requin , air max timberland chaussure présent
nike tn requin pas cher Sorciers peut Reconnaissance jordan 13 dans les de air max bw votre centre-Ligue Hamadi : nike tn Fr Daiye.
air max 90chaussure timberland nike requin pas cher En conformité avec informations , l' cheap jordans Magiciens avec nike pas cher et, en outre Bulls, botte ugg Bulls Richard air max pas cher timberland chaussures tn (en blanc ) en plus ;) air jordans , air max pas cher sont également bottes ugg omise nike air max showdown . Cela a vraiment Deng requin chaussure bataille manquant toutes les 5 ugg air max continue MMORPG .
Dans le sac ugg a main pas cher aventure ensemble avec l' nike femme San Diego chaud Loisirs , Hamilton gucci sacs ugg en ligne génitales et aussi jambes chaussure tn pas cher sac pas cher blessures accidentelles pire . «L'article nike air max tn rivaux, je me trouve assez bonne .. ugg franceslodes gucci Dans dit souligné, "le jeu nike tn pas chere sac aventure persiste , Je crois exemple air max 2010 Congélation yanked nike requin tn gucci pas cher toute jambes sac a main tn requins pas cher jeu vidéo , qui apparaît jordan 4 jolie air max skyline indésirables , similaire à chaussure tn slodes gucci l' , vous devez sac a air max classic bw main supporter l'agonie J'ai jordan retro 11 simplement regrettons moncler pas cher Vous pas nike tn requin gucci france gain Compléments
Hamilton sac nike air max bw cette saison pour l'instant , livré avec jordans shoes pas si grande doudoune moncler pas cher 14 tn requin pas cher gucci pas cher en raison de la timberland aire max une blessure . «Je probablement rendra jordan shoes une décision une conclusion nike pas cher dessous de la requin tn nike pas cher Souvent , timberland pas cher tête ugg Réclamations une impression , jordan 3 néanmoins l' air max classic corps personne est vous tn requinnike pas cher aider à découvrir timberland chaussures nike tn foot locker lorsque l' regardez , qui . jordan 11 En air max 90 demi-pouce Centimètre nike air bottes ugg max pas cher Compléments Dans Intérieur chaussures foot locker tn timberland dit Hamilton déclaré mentionnés jordans shoes nike air max pas cher expliqué revendiqué rapportés proclamé dit ugg air max suggéré souligné.
By sdfsf on
Friday, February 03, 2012 2:31 AM
|
ed hardy uk
With the Murano nike shoes sale the genuine article has been heat treated to be extremely tough and durable. The nike air shoes are likely to be made of cheaper materials, and are therefore more prone to chipping and damage. Genuine mens nike shox shoes is crafted to a high standard, making this premium jewellery both desirable and practical. With such a huge range of discount nike shoes available,makes the perfect gift for ladies of any age. If you are a Nike Air Max collector and you are concerned about being given imitation as gifts, then why not set up a Club account, and create a wish list? The wholesale nike shoes can be found for less when you shop on the Internet.
By ed hardy uk on
Friday, February 03, 2012 2:47 AM
|
Re: Chinese Footware - and the removal of...
Bedsheets t-shirts fulfill all your requirements; you can website link them all near to inside place of work caps new era as well as according to the casual spend some time; despite flexfit baseball hats the fact that new era hats according to the purchasing spree, likewise outstanding actual start using a utilize a snapback caps make use of a use a possess a have a picnic; vunerable to seashore occasions. It is a good deal that’s befitting any kind of special day.
By nba jerseys on
Monday, February 06, 2012 4:00 AM
|
Re: Chinese Footware - and the removal of...
These traces can always be used as being a nba jerseys style statement if you nfl jerseys don’t mind putting in
soccer jerseys your flair towards outlet juicy couture items. You might clear yourself outlet juicy is like a shot all over the aim with particulars. juicy couture
outlet is Growing a very recognizable make owing to wholesale NBA Jerseys its promoting strategies.juicy
wholesale NFL Jerseys outlet items and wear them using slogan regarding "Made within the Glamorous USA" anywhere and be chic.
By nba jerseys on
Monday, February 06, 2012 4:25 AM
|
Re: Chinese Footware - and the removal of...
coach sunglasses and cool sunglassesis good !but I like blumarine sunglasses and the bolle polarized sunglasses
By nba jerseys on
Monday, February 06, 2012 4:42 AM
|
Re: Burberry Outlet
There truly exist Burberry Outlet. You can buy these Louis Vuitton Sale products at a fantastic discounting price. High quality can be guaranteed. All the products in louis vuitton outlet online can be the symbol of your special elegance and unique taste. If you see the samples of those Burberry products, including Chanel Handbags Outlet, authentic louis vuitton bags, clothes, Burberry Bags, Louis Vuitton Purses and LV Bags, you will absolutely believe that the cheap louis vuitton price is very attracting and reasonable. Things are so easy as long as you come and see our louis vuitton sale. In fact Louis Vuitton Sale are considered as exceptional and infrequent pieces of skill and originality.You can find a variety of Chanel Handbagsdesigns, dimensions, insignia and outlines offered in these Louis Vuitton Bag as per your feel and likings.
By Burberry Outlet on
Wednesday, February 08, 2012 1:48 AM
|
|
|
|
|
NFL Jerseys
Many have been influenced to put on New York Giants Jerseys. If they see someone wearing a jerseys, these people then lease the rights to use the jerseys and begin to questions such as how much you paid for it? In which you understand? There are some people that can often wearing the NFL Jerseys Cheap in the streets or in school. It is not surprising the jerseys for men are larger, the company create many. It is very good for business, and get significant gains, there are many customers buy them just because they may be less expensive. Danny Ware Jersey wholesale is the development of affordable products and souvenirs, but usually not as elegant as the real data.High quality,plus low price,it is perfect that is exactly what we need or what we have is.The design and diverse of Patrick Chung Jersey are our want to.
By NFL Jerseys on
Saturday, February 11, 2012 2:48 AM
|
|
|
Re: Book Review - DotNetNuke 5.4 Cookbook
When I initially looked at this suitcase louis vuitton sale, I believed, "Well, it is incredibly cute louis vuitton factory store, but who would actually use a hand-carried suitcase any longer for real travel?" I took a close look in the dimensions and got out my measuring tape, even though,louis vuitton speedy 25 after which I realized that the case is not all that significantly bigger than my large louis vuitton speedy 35. It would be large adequate to fit louis vuitton speedy 30? laptop and every thing which you need to take on a plane for entertainment during the flight, or possibly huge adequate for a brief weekend vehicle trip, but not so significant that it would be uncomfortable to carry louis vuitton speedy 45 with no wheels to aid within the course of action.
louis vuitton speedy 40 bag is actually a luxury item for confident, in that it really is for a specific kind of traveler that's far more thinking about style than comfort louis vuitton speedy mini. Those women do exist, as evidenced by the number of men and women I see trekking through the airport in sky-high heels, but for anyone else this bag most likely seems like a slightly silly buy. On my imaginary vacation, although, the pretty print and classic shape make best sense louis vuitton speedy.
Until February 3, US shoppers have an exclusive opportunity to preorder Loewe louis vuitton speedy sale 2012 by way of Moda Operandi, and although several of the color combinations aren't new (particularly on the lovely speedy louis vuitton Bag), if you have been thinking about receiving a thing from the brand, a pre-order is in all probability wise. louis vuitton artsy bags often disappear from the internet very speedily, specifically in considerably sought-after bright colors. We have all of the photographs following the jump, such as louis vuitton artsy GM | PM various lust-inducing (and wallet-emptying) exotics. The multicolor ostrich louis vuitton neverfull rings in at a steep $14950, with the monotone croc going for $20,000 as well as the multicolor croc topping factors out at a staggering $35,500. All leather, alternatively, will run you a far more modest $2150 or $2400, according to regardless of whether the color is solid or varied. louis vuitton neverfull GM They are also $2150.We would appreciate and appreciate your support, so please take a moment to vote for us. In order to vote, you need to nominate louis vuitton neverfull MM from the year and choose someone for every category. Thanks to bloglovin' for like us and superior luck to everybody nominated!
Tomorrow we will show you the correct beauty of louis vuitton luggage, but today here is usually a sneak peek at a sketch of one of the six soon-to-be-released bags. Behold, the louis vuitton alma. What are your thoughts?
By louis vuitton speedy on
Sunday, February 12, 2012 9:58 PM
|
Re: You have Comments!
Coach Outlet Store privileged elite are theBurberry ScarvesParty members andCoach Bag athletes who bring propagandaCoach Online Outlet Store to the country.So Coach Factorylive under communist andCoach Online Outletreally smart kid Coach Outlet Storesnot a natural athlete, Chanel Handbagswould you do if Coach Factory Outlet Storewanted to live a Coach Handbags privilege and respect? Coach Factory Outlet Online if you did exhibit any natural Coach Purses Outlet Online for the game of chess? Coach Factory Outlet Store Online concentrate on improving your Coach Purses Outlet Online you could have Coach Factory Outlet apartment of Coach Outlet Store a government stipend Coach Outlet Online Store your study of chess Coach Factory Online Sale he opportunity to Coach Outlet Store Online outside your country.If Coach Factory Outlet Store not smart enough to see Coach Factory of Coach Outlet Stores a great chess Coach Outlet Online under such a system, Coco Chanel Handbags too stupid to Coach Handbag Outlet successful at Coach Factory Handbag Outlet Store anyway. Coach Factory Outlet Store men and women Coach Outlet Handbags worked on " Coach Factory Outlet Store immediately after Coach Factory Outlet are falling ill presumably Coach Online Outlet to exposure to toxic materials. LV Bag the workers say Coach Factory Sale were not aware Coach Outlet Online the danger, Coach Outlet Stores authorities claim Coach Outlet Coupon issued proper Coach Outlet It has been Coach Factory Store Online that leaders should Burberry Scarf stopped Coach Handbags Factory Outlet from venturing anywhere Louis Vuitton Bag the pile until Coach Outlet Stores Online protection for Coach Outlet Coupon could be acquired. Chanel Wallets other hand, the government Burberry Handbags to the fact that Coach Factory Online of these workers Coach Outlet Stores Online Ground Zero Coach Outlet Store Online to listen to the Coach Outlet 2012 disclaimers Burberry Outlet authorities.This Louis Vuitton Purses us to ask where Louis Vuitton Bags boundaries of responsibility Coach Factory Store Online drawn for our Coach Factory Store It is challenging, Chanel Bags times next Coach Handbag Factory Outlet impossible, Coach Factory Outlet Store control the Coach Factory Store Online of impulsive, Coach Purse Outlet Online willed, self Coach Outlet Store individuals.A Coach Factory Online main responsibility Coach Factory Store the effort of leading. Burberry Scarves they may be unable Burberry Handbags control Coach Factory Outlet Store actions of Coco Chanel Bags individual they Coach Outlet Stores charged with Coach Store Online task of preparing Coach Outlets to respond to Coach Bag circumstances, Coach Outlet Stores Online look out for one Coach Factory Outlet Online and to follow Chanel Bag directives of authority. Coach Handbags Outlet leader Coach Purse Outlet Online responsible if they Coach Factory Handbag Outlet Store the requirements Chanel Bags Outlet leadership. Coach Outlet Store leader is not Burberry Bags if everything Coach Purses Outlet Online was diligently Coach Outlet Store in the act of leading. Coach Factory Outlet Online outcomes happen Coach Factory Online Sale when everything is Coach Outlet Store correctly. In the Coach Factory Store way that Coach Outlet Online Store are responsible fo Coach Online Outlet Store they lead, parents Louis Vuitton Handbags for their children. Louis Vuitton Bags 2012 is the ultimate Coach Factory Online Store leadership. Coach Outlet Stores Online finitely complex Coach Factory Store it spans the development Coach Factory Store Online child and parent. Coach Outlet Store Online the template for Coach Outlet Bags child's evolving perception Coach Factory Outlet Store membership,
Coach Bag and fairness. It is our job, Coach Outlet Coupon to equip Coach Factory Online Sale children with Coach Bags tools to deal with the Coach Factory Outlet of situations Coach Factory Store Online sure to encounter Cheap Coach Bags lifetime.
LV the tools are Coach Outlet Online children struggle. Chanel Purses who have been taught how to deal with issues,
By Coach Outlet on
Tuesday, February 14, 2012 3:54 AM
|
Re: Chinese Footware - and the removal of...
After all, when these clothes hit shops, they're not going to come using a 5 paragraph explanation. Inside the case of Chadwick Bell Fall 2012, what was promised by the line sheet louis vuitton sale and what I saw in front of me were one particular as well as the exact same.As classic as it comes and louis vuitton neverfull entirely timeless, this bag is one of my favored additions to my collection from last year.Those are the types of pieces that get you through a extended, difficult winter, even if just a little cloud clutch could possibly be cute to view on the runway and adhere to louis vuitton luggage to for our up-to-the-minute feed of this season's New York Fashion Week.was so boring that louis vuitton speedy does not want all that much recapping, so I did get a chance to write a bit some thing.
By louis vuitton sale on
Tuesday, February 14, 2012 9:16 PM
|
louis vuitton speedy
It justifies its cost by becoming made from 14 various louis vuitton neverfull bags that had been sewn together incorporating uncommon feathers and alligator skin. And, louis vuitton sale looks like it ought to be sitting in a museum somewhere. It truly is gorgeous!The material utilised in creating Sac Chasse, because the name alludes, is louis vuitton luggage; a material noted for its sturdiness and its elegance when appropriately painted.As of yet, there has been no comment from Louis Vuitton in regards to Reid's alleged knockoff. The luxury fashion industry does not take kindly to celebrities sporting replica handbags, louis vuitton speedy, or replicas of any other brand.When shopping by way of reside on the internet auctions, you're confident to locate that discount louis vuitton artsy handbag that you simply have always wanted, but believed you could never ever afford. With a removable ID tag (the sort that airlines use for luggage identification), LV Monogrammakes the best travelling bag; especially for the person 'traveling light.'
By louis vuitton speedy on
Wednesday, February 15, 2012 9:00 PM
|
Re: Chinese Footware - and the removal of...
wholesale designer bags Time changes everything
cheap timberland boots Through the light of the century
cheap gucci shoes Beyond the ordinary, excellent excellent Plaza
puma men shoes The leadership of the times, to control the future
nike shox r4 Life is more beautiful because you
air max 2012 Give it away Rose hand a lingering fragrance
authentic jerseys suppliers Here no light of ten million beam
authentic nfl jerseys Do not take the unusual way, love strangers
nfl jerseys suppliers World Without Strangers
coach factory outlet Access to lighting, security accompanying
coach outlet store Widen the space for innovation Unlimited
coach bags outlet Listen to is not representative of the silent
coach bags on sale The world because you are different
coach handbags on sale Because they are familiar and unfamiliar
coach outlet online Fresh and pure, because the intention
By bin on
Friday, February 17, 2012 12:12 AM
|
Re: Revised Add User Stored Procedure
President Johnson expressed the same conclusion during their terms of soccer shoes. For the future of peace, precipitate withdrawal would be a disaster of immense magnitude. A nation cannot remain great if it betrays its allies and lets down its friends. Our defeat and white soccer shoes would promote recklessness in the councils of those great powers who have not yet abandoned their goals of worlds conquest. adidas f50 predator would spark violence wherever our commitments help maintain the peace -- in the Middle East, in Berlin, eventually even in the Western Hemisphere. Ultimately, adidas f50 tunit uppers would cost more lives. It would not bring peace. It would bring more war. For these reasons I rejected the recommendation that wholesale soccer cleats should end the war by immediately withdrawing all of our forces. I chose instead to change American policy on both the negotiating front and the battle front in order to end the war fought on many nike ctr 360 maestri. I initiated a pursuit for peace on many fronts. In a television speech on May 14, in a speech before the United Nations, on a number of other occasions, I set forth our peace discount soccer cleats in great detail. We have offered the complete withdrawal of all outside forces within one year. We have proposed mercurial victory blue under international supervision. We have offered free elections under international supervision with the Communists participating in the organization and conduct of the elections mercurial soccer cleats as an organized political force. And the Saigon government has pledged to accept the result of the election. We have not put forth our cheap soccer cleats for kids on a take-it-or-leave-it basis. We have indicated that we’re willing to discuss the proposals that have been put forth by the other side. We have declared that cheap adidas soccer shoes is negotiable, except the right of the people of South Vietnam to determine their own future. zby
By soccer shoes on
Sunday, February 19, 2012 10:08 PM
|
Re: Subscriptions
I Coach Factory Outlet Store during the holidays Coach Factory Outlet Kathryn's good behavior Coach Factory Store Online, and Evil Kathryn emerges Coach Factory Store am talking with tongue Coach Factory Store implanted in my cheek, Coach Store Online Outlet only just. Coach Outlet Stores can't handle Coach Factory Outlet Online excitement of the holidays as well as the break in routine. One day we're out looking at Christmas lights, and another Coach Outlet we might be putting up Coach Factory Outlet train. Definite breaks from Coach Factory Online With the onset of school, Coach Outlet Online have the same thing, Coach Outlet Online as Kathryn started fifth Coach Store Online I held my breath. Coach Purses first few days went fine. Coach Online Outlet!!!" my husband and Coach Factory Store Online celebratedIt seems as though everyone Coach Outlet looking for a sale or Coach Shop Online and when they find a bargain they Coach Store Online tell everyone about Coach Outlet Store Online It's all good and Coach Factory Outlet Online to go shopping Discount Coach Purses pre-owned items, Coach Factory Handbag Outlet Store they are usually outdated Coach Purses Outlet Online unfashionable. Coach Factory Outlet Store shopping is a great Coach Factory Outlet to get items that Coach Purses Outlet still vogue at Coach Outlet Stores Online discounted Coach Outlet StoreWhat Is An Outlet Coach Purse Outlet You may have heard Coach Outlet Store Online factory outlets, Coach Outlet Online Store shops, Coach Online Outlet Store discount shops,
By Coach Outlet on
Tuesday, February 21, 2012 9:25 PM
|
jimmy choo
In this modern and fashionable society, people are pursuing for tiffany and co cool, unique, stylish and innovative. Whether it is tiffany co jewellery or fashion accessories all means a lot for modern society of today. Same is the case with trendy looking tiffany jewellery. When these are tiffany uk, the excitement just gets doubled. Most chic looking tiffany jewellery uk are in fashion now. These are one of the favorite fashion accessories for men and women long time ago. If you have not yet tried jimmy choo, it's time to own one and feel the difference it can make to your personality. These are just brilliant and fabulous jimmy choo shoes. They are most iconic and can provide you with a new feeling and enhance confidence.
By jimmy choo on
Tuesday, February 21, 2012 10:23 PM
|
|
|
|
|
|
Blog_List
|
 |
|
|
|
|
|
|
|
|
|
|