Last post Jan 27, 2011 09:15 AM by sabalimotu
Apr 20, 2008 10:24 PM|pedewede|LINK
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
Please help me.
Apr 21, 2008 12:33 AM|ashmetry|LINK
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
Apr 21, 2008 12:48 AM|darkknight187|LINK
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.
Apr 23, 2008 09:10 PM|pedewede|LINK
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.
Apr 23, 2008 10:13 PM|darkknight187|LINK
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.
Apr 24, 2008 09:46 AM|ashmetry|LINK
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...)
May 02, 2008 01:27 PM|pedewede|LINK
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!!
Jan 27, 2011 09:15 AM|sabalimotu|LINK
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.