Advertisement:

Author Topic: [Plugin] Ghostbuster  (Read 19633 times)

trains58554

  • Osclass contributor
  • Hero Member
  • *****
  • Posts: 3642
  • osCanyon, the class of Osclass
[Plugin] Ghostbuster
« on: August 02, 2012, 04:01:53 am »
Hi all,


Update 5-13-13
Added check for the oc_t_item_ip_address table.

Update 12-28-12
Added a check for the item_custom_attr_values table.

Update 12-11-12
Added a check for the payments_publish table.
Added a check for the voting_item table.

Update 10-22-12
Added a check for the businfo table.

Update 9-26-12
Added a check for the adManage_Limit table.

Update 9-24-12
Added a check for the car attributes plugin.

Update 8-18-12
Added a check for the youtube plugin.


I am proud to announce Ghostbuster 2.0.

New features.

  • Now compatible with osclas 3.0 menu structure.
  • Can now automatically check for ghost ads.
  • Has support for the new admin toolbar.

This version is only compatible with osclass 2.3 and up. In osclass 3.0 you will fine the Ghostbuster menu option under the tools menu. Also this version now outputs the error generated when Ghostbuster cannot delete the ghost ad.

Q: What is a ghost ad?

A: Ghost ads are ads where they did not fully delete because a plugin did not correctly delete there rows so the item row in t_item table could not be deleted as it was still had dependences. Ghostbuster goes in and cleans up the tables that are depending on the item and then the item can be deleted.

Jay

Download here: http://market.osclass.org/plugins/ghostbuster_83
« Last Edit: October 30, 2013, 02:54:12 am by trains58554 »

Jesse

  • Hero Member
  • *****
  • Posts: 631
  • Out of my mind, back in 5 minutes
Re: [Plugin] Ghostbuster 2.0
« Reply #1 on: August 08, 2012, 12:39:22 am »
Thanks Jay! I just got around to upgrading my OSC version today to 3.0 and noticed that this plugin wasn't working. Glad to find this update.  ;D

One comment though... the zip file you have here contains a secondary folder inside of it with the same name. OSC didn't like that and gave an error when I tried to upload the zip file you have here. I had to unzip it and re-zip the inside folder for it to work. Just FYI.  ;)

trains58554

  • Osclass contributor
  • Hero Member
  • *****
  • Posts: 3642
  • osCanyon, the class of Osclass
Re: [Plugin] Ghostbuster 2.0
« Reply #2 on: August 08, 2012, 01:39:16 am »
Hi Jesse,

Yep this version works with 3.0 and has some great new features as well.

I think the zip is fixed now can you confirm that for me?

Thanks

Jay

web2graphics

  • Jr. Member
  • **
  • Posts: 74
Re: [Plugin] Ghostbuster 2.0
« Reply #3 on: August 09, 2012, 08:33:59 am »

I think the zip is fixed now can you confirm that for me?


Zip file is ok. Thank you

trains58554

  • Osclass contributor
  • Hero Member
  • *****
  • Posts: 3642
  • osCanyon, the class of Osclass
Re: [Plugin] Ghostbuster 2.0
« Reply #4 on: August 09, 2012, 09:04:42 am »
Thanks for confirming that the zip is good.

Jay

trains58554

  • Osclass contributor
  • Hero Member
  • *****
  • Posts: 3642
  • osCanyon, the class of Osclass
Re: [Plugin] Ghostbuster 2.0
« Reply #5 on: August 19, 2012, 04:09:24 am »
Hi all,

Ghostbuster now checks the youtube plugin now.

zip updated in the first post.

Thanks

Jay

Sirolist.com

  • Newbie
  • *
  • Posts: 45
  • [Running] - Osclass 3.0.1- Classic Theme
Re: [Plugin] Ghostbuster 2.0
« Reply #6 on: August 19, 2012, 04:23:31 am »
Awesome! Worked perfectly.

trains58554

  • Osclass contributor
  • Hero Member
  • *****
  • Posts: 3642
  • osCanyon, the class of Osclass
Re: [Plugin] Ghostbuster 2.0
« Reply #7 on: August 19, 2012, 04:29:03 am »
Glad to hear that it worked. Thanks for reporting the error.

Thanks

Jay

Sirolist.com

  • Newbie
  • *
  • Posts: 45
  • [Running] - Osclass 3.0.1- Classic Theme
Re: [Plugin] Ghostbuster 2.0
« Reply #8 on: August 19, 2012, 04:45:18 am »
No problem at all.

Tex70

  • Newbie
  • *
  • Posts: 10
Re: [Plugin] Ghostbuster 2.0
« Reply #9 on: September 27, 2012, 02:10:59 am »
Hello Jay,
Nothing to do, got the same error for all 12 ads:

Cannot delete or update a parent row: a foreign key constraint fails (`/xc_t_item_admanage_limit`, CONSTRAINT `xc_t_item_admanage_limit_ibfk_1` FOREIGN KEY (`fk_i_item_id`) REFERENCES `xc_t_item` (`pk_i_id`))

Waiting for an updated version, thanks.

Antonio

trains58554

  • Osclass contributor
  • Hero Member
  • *****
  • Posts: 3642
  • osCanyon, the class of Osclass
Re: [Plugin] Ghostbuster 2.0
« Reply #10 on: September 27, 2012, 04:49:46 am »
Hi Antonio,

It is fixed now.

Jay

Tex70

  • Newbie
  • *
  • Posts: 10
Re: [Plugin] Ghostbuster 2.0
« Reply #11 on: October 12, 2012, 07:03:40 pm »
Hi Jay,
great...now it's work, thanks so much my friend...good work! :)

Greetings
Antonio

anypis

  • Newbie
  • *
  • Posts: 18
Re: [Plugin] Ghostbuster 2.0
« Reply #12 on: October 27, 2012, 07:30:38 pm »
Unfortunately it didn't work on me :(

You currently have 0 ghost ads

Ghost ads in stats table 0
Ghost ads in meta table 0
Ghost ads in locations table 0
Ghost ads in resources table 0
Ghost ads in comments table 0
Ghost ads in offer_item_options table 0
Ghost ads in paypal_publish table 0
Ghost ads in item_adManage_limit table 0
Ghost ads in elitpay_publish table 0
Ghost ads in item_products_attr table 0
Ghost ads in item_buysell table 0
Ghost ads in item_youtube table 0
Ghost ads in item_car_attr table 0
Ghost ads in item_businfo table

You are ghost free!



But still i have this ****.com/index.php?page=item&id=0


serjuc11111

  • Hero Member
  • *****
  • Posts: 814
Re: [Plugin] Ghostbuster 2.0
« Reply #13 on: November 06, 2012, 12:58:31 am »
hy again!

i got this error

Cannot delete or update a parent row: a foreign key constraint fails (`database`.`oc_t_voting_item`, CONSTRAINT `oc_t_voting_item_ibfk_1` FOREIGN KEY (`fk_i_item_id`) REFERENCES `oc_t_item` (`pk_i_id`))
Cannot delete or update a parent row: a foreign key constraint fails (`database`.`oc_t_voting_item`, CONSTRAINT `oc_t_voting_item_ibfk_1` FOREIGN KEY (`fk_i_item_id`) REFERENCES `oc_t_item` (`pk_i_id`))

trains58554

  • Osclass contributor
  • Hero Member
  • *****
  • Posts: 3642
  • osCanyon, the class of Osclass
Re: [Plugin] Ghostbuster 2.0
« Reply #14 on: December 12, 2012, 06:00:47 am »
Update

Now check for ghost ads from the payments_publish table and the voting_item table.

Jay