Bogus selling prices in pp_classifieds

[Rich Z]

Apparently I have some clown on my site posting bogus ads with real high dollar amounts and then marking them as being sold to screw up my statistics display of total value of animals sold on the site. How can I track down who is doing this without having to scan through every ad to try to pick him out of the crowd?

[Chuck S]

You would need to view one of the ads and get the userid of the individual and track him down. Any sold ad can be viewed in the expired que in approve ads in admin

[Rich Z]

The expired queu in my system doesn't show SOLD ads.......

[Chuck S]

Are you running the cron task sendnotice.php to expire ads?

[Rich Z]

Beats me. You installed the script on my server. Were you supposed to set that up or was I? First I've heard of it......

[Chuck S]

Cron task setup would be something you would setup. On most shared setups you may need your host to assist you

Cron Job: sendnotice.php

[Rich Z]

Well I installed the cron job, but I must be doing something wrong. I set it up to run the job every 15 minutes. So, every 15 minutes I was getting a notice about the test auction I had set up. Come to find out, the person helping me with this auction was also getting an email, every 15 minutes.

I know I may be jumping to a conclusion here (which is why I deleted that cron job), but am I reading this right that any user who set up an auction (and maybe has an ad that has closed as well) will get a notice like this for all eternity? If so, I'm going to rename that script from "sendnotices.php" to "solicit_hatemail.php"..........

Even setting it to run only every 24 hours is still going to be a problem if people with closed ads or running auctions gets a notice everytime that cron job runs. So what am I doing wrong or interpretting incorrectly about this process?

[Chuck S]

They should only get one notice.

[Rich Z]

No, I got a notice every 15 minutes, both from my FaunaClassifieds site as well as my GunWantAds site. Any idea on how to keep that from happening so I can run that script like it is supposed to?

[Rich Z]

Any resolution to this problem? Is there something I can do to keep those messages from being generated with every CRON run?

[Chuck S]

What version of the software you have?? The code is pretty specific its only going to send out emails for ads that expire in 3 days.

I would suggest you go to your approve ads expired section and delete those ads if you never have deleted anything

then if your running a version other than the latest code upgrade your files

Content visible to verified customers only.

[Rich Z]

This happens in both my FaunaClassifieds site as well as my GunWantAds site. You just upgraded the GunWantAds site very recently, so this should have the latest code.

I've got the options set in both sites to retain closed ads for 180 days after they are closed. Does the sendnotify code continue sending out notices on those ads for that length of time?

[Chuck S]

what do you mean to retain ads 180 days after they are closed??

If an ad expires it should be marked like so which means it will not show

// Close out expired ads
$query = "UPDATE {$Globals['pp_db_prefix']}products SET approved=2,status='$today' WHERE enddate < $today AND isauction=0";
$result = ppmysql_query($query,$link);


then in showcat where ads are shown see approved=1

$query .= "WHERE approved=1 $catcheck AND date > $searchdate $exclude_cat $sortcode";

So your losing me here saying you have it set to show 180 days after. Once an ad expires you should delete it or relist it

[Chuck S]

Your gunwantads thing works fine. I ran sendnotice and the ads are in the expired section waiting for you to reapprove them or delete them. I saw one email getting sent to users.

As stated I would suggest you update your other site

[Rich Z]

Originally Posted by omegatron

what do you mean to retain ads 180 days after they are closed??

If an ad expires it should be marked like so which means it will not show

// Close out expired ads
$query = "UPDATE {$Globals['pp_db_prefix']}products SET approved=2,status='$today' WHERE enddate < $today AND isauction=0";
$result = ppmysql_query($query,$link);


then in showcat where ads are shown see approved=1

$query .= "WHERE approved=1 $catcheck AND date > $searchdate $exclude_cat $sortcode";

So your losing me here saying you have it set to show 180 days after. Once an ad expires you should delete it or relist it

In the admin section, under the Show Ads Options, there is this selection:

Number of days to show sold/closed ads?

I have this set to 180 days. This is because some users have asked that those old ads remain for a period of time in case there is any question about the details listed in them later on. Not everyone who sells their items will take the time to mark it as such. I assumed that option is accomodated for within the sendnotice code.

As for updating the FaunaClassifieds pp_classifieds, that is going to be more complicated then for the GunWantAds site. You did some custom coding there for me as well as my vBulletin guy modifying the feedback screeen to utilize one I already have in vBulletin. I want to have this done, but I know you are going to need some details that I just have not had the time to pull together yet to be able to provide to you. I'm sure you probabably don't remember the coding you did on that site for me so I am going to have to find those old emails to give you those details to incorporate into the upgrade.

[Chuck S]

Yes I think I did layout to you what modifications you would need to do when upgrading and nope I dont keep old code.

You could safely update sendnotice.php on the other site