How to Extend User Ad as Administrator! for www.birdzee.com RRS feed

  • Question

  • User1335671932 posted

    Please help guys...I know you are busy.......but I have about 100 registered users who's ads have expired and deactivated. I need to reactivate and extend each ad as an administrator for www.birdzee.com

    Please help me.

    Sunday, April 20, 2008 10:24 PM

All replies

  • User1128022426 posted

    Whats your question then?

    Just run a sql script on the database to update the rows to adstatus 100 and ExpirationDate to something in the future

    Monday, April 21, 2008 12:33 AM
  • User730446648 posted

    I don't understand the problem, what you want is built in.

    Just log in as Admin, go to Site Administation, manage Listings and features, in the search dialog change the status to inactive.

    You now see all the inactive ads. check the boxes next to the ones you want to change, and use the drop down to reactivate the listings.

    If that's not it explain more.


    Monday, April 21, 2008 12:48 AM
  • User1335671932 posted

    Here is the deal darkK...there is a command that runs on the hr. to check ad against expiration date. So even if you reactivate the ad it will still deactivate within the hr.if the expiration day is outdated. How do I stop that. I have a lot of ads that are expired. I want to reactivate the ad.

    Wednesday, April 23, 2008 9:10 PM
  • User730446648 posted

    I did not search but I think admin is the only one that uses the storedprocedure UpdateAdStatus, so I would check that it's the only place it's used, and add expiration to the stored procedure and the code behind. In the code behind you could do a simple declaration expiration = DateTime.Today.AddDays(30)

    If you wanted these ads to show up at the top of the list you could also add a parameter to update datecreated.

    And then your set.


    Wednesday, April 23, 2008 10:13 PM
  • User1128022426 posted

    to reactivate an ad you need 2 things..

    1.Extend the expired date to something in the future

    2.Set ad status to 100


    You can do that in bulk by runing a sql query.

    Update classified_ads set adstatus=100 AND ExpiredDate='01/01/2009' where (....you can remove this if you want to activate everything...)

    Thursday, April 24, 2008 9:46 AM
  • User1335671932 posted

    This is awesome!!! However...if you have time can you give me a step by step on how to create and run a stored procedure?? Please!!

    Friday, May 2, 2008 1:27 PM
  • User626708885 posted

    u can easily extend the date or time of expiration of ad, under the code by simply changing the expiration time to your desire days, weeks or months, check the code behind the file of post ad.

    Thursday, January 27, 2011 9:15 AM