which css files has the banners?

[hangman21]

I am looking for the file where i can edit the option in notepad to make the banners in the banner manager, all off, so when i install zen-cart on my apparent hosting company, i dont have to deal with the hassle of turning it back on, where can this be done at?

I am also looking for the file which i can edit the layout box controllers to a parament, so again i dont i have to go back inside after i re-install zen cart and turn off the unwanted to sideboxes.

thanks everyone for your support

[RobWUK]

These settings are stored in the database, i reckon you need to editing your sql file in your installation folder

You could get the values you need for them to be switched of in your current database and then ammend the sql in your installation to match these values

Rob

[afo]

admin>tools>banner manager

[RobWUK]

admin>tools>banner manager

i think he's after a permanent way of settings these settings to off, so whenever he installs zencart he don't have to log in admin and turn banners off

Rob

[afo]

All of what he's asking is stored in the database, not in a file. I can't think of any way to permanently turn them off at installation. Someone may have a bright idea of how to do this. I suppose you could backup the tables involved and copy them to new installations, but that still wouldn't turn them on/off permanently at installation.

[RobWUK]

yes i have, ive suggested he alter the sql files used when installing, it has all commands for propergating the tables, if he finds out what values need to be in the table fields he can alter the sql code to insert these values instead of the default values.

Rob

[RobWUK]

in your zc_install/sql you could alter the zencart.sql and alter the status of the banners that are added with the install,

scroll down to where the banners are added and you will find the following, ive added carriage returns to make easier

INSERT INTO banners (banners_title, banners_url, banners_image, banners_group, banners_html_text, expires_impressions, expires_date, date_scheduled, date_added, date_status_change, status, banners_open_new_windows, banners_on_ssl, banners_sort_order)
VALUES ('Zen Cart', 'http://www.zen-cart.com', 'banners/zencart_468_60_02.gif', 'Wide-Banners', '', 0, NULL, NULL, '2004-01-11 20:59:12', NULL, 1, 1, 1, 0);

4th from the end replace with 0 and it will turn them off
VALUES ('Zen Cart', 'http://www.zen-cart.com', 'banners/zencart_468_60_02.gif', 'Wide-Banners', '', 0, NULL, NULL, '2004-01-11 20:59:12', NULL, 0, 1, 1, 0);

banners will still be installed but not switched on

Rob

[kuroi]

Rather than editing the main SQL file, there's a plugin folder in the install SQL directory called plugins. Custom SQL can be put in there.