Community Add-Ons

these files are modified:
-optimize_table.php
-empty_db.php

not to store your actual DB name in the scripts, but to relate to the DB_DATABASE name stored in your admin/includes/configure.php

step 6 is left away from the previous install guide

Version 4 - which will allow user input to queries(if applic).

Correction to delete all orders query.

All files here.

New Installs - Follow all instructions.

Upgrades from V2 - Follow all instructions.

Existing V3 users - just run the sql file.

Correction to delete all orders query.

All files here.

New Installs - Follow all instructions.

Upgrades from V2 - Follow all instructions.

Existing V3 users - just run the sql file.

All files here plus some added queries.

New Installs - Follow all instructions.

Upgrades from V2 - Follow all instructions.

Existing V3 users - just run the sql file.

ALL files here.

Correction to install instruction from previous upload - noticed by fablog, thanx.

More user friendly version.

Install instructions are the same for upgrades or new installs.

ALL files here.

2 added queries to this release:

Mark ALL products as taxable
Mark ALL products as not taxable

Correction to SQL file.

2 Addition Queries added:

1) Reset Counter
2) Reset sold items

Full file set here including:

1) New script to empty all DB tables (excluding required structural ones).

2) Correction to optimize db table install instructions i.e. replace 2 occurences of XXXXXX in the optimize_tables.php file with your DB name.

Donations (to afford me more time to contribute)gratefully accepted at payments@hostingoscommerce.com.

Thank you.

Amend Database from Admin - Version 2.0
Modified by Emmett Brosnan - http://www.hostingosCommerce.com
------------------------------------------------
The update to this Contribution is to:

1) Allow query running from the database or from a script.
2) Add further consistency with osCommerce standards in coding. Also thank you to Aaron Hiat in this respect also.
------------------------------------------------

Written by Emmett – http://www.hostingosCommerce.com
http://www.hostingoscommerce.com/forum/showthread.php?t=28

Amend Database v1.5
Modified by Aaron Hiatt - http://www.scaredrabbit.com
-------------------------------------------------------
The update to this Contribution is for MS2.2 compatibility and for consistency with osCommerce standards in coding and file placement. Contribution creation credit goes to Emmett
-------------------------------------------------------

This has been rewritten and is now DB driven following a suggestion from bruyndoncx.

Which makes it easier for you to build your own queries and add them to the DB and they will then show as an option in admin.

Slight amendment to file to be uploaded.

This contrib allows you to:

delete all products or
delete all orders or
delete all customers
and perform other db manipulation operations

ALL

from your stores admin area.