Results 1 to 8 of 8

Hybrid View

  1. #1
    Join Date
    Aug 2005
    Location
    United Kingdom
    Posts
    457
    Plugin Contributions
    0

    Default Re: which css files has the banners?

    Quote Originally Posted by afo View Post
    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

  2. #2
    Join Date
    Aug 2004
    Location
    New York City
    Posts
    7,174
    Plugin Contributions
    0

    Default Re: which css files has the banners?

    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.
    Mary Ellen
    I came; I saw; I Zenned
    Taking over the world... one website at a time
    Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.

    Holzheimer
    Fan Odyssey

  3. #3
    Join Date
    Aug 2005
    Location
    United Kingdom
    Posts
    457
    Plugin Contributions
    0

    Default Re: which css files has the banners?

    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

  4. #4
    Join Date
    Aug 2005
    Location
    United Kingdom
    Posts
    457
    Plugin Contributions
    0

    Default Re: which css files has the banners?

    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

  5. #5
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: which css files has the banners?

    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.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

 

 

Similar Threads

  1. which PHP files writes the Order to the DB?
    By tcarden in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 29 Mar 2013, 05:02 PM
  2. v139a Which .php file has the homepage information?
    By hhalliburton in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 31 Mar 2012, 06:20 PM
  3. which is the category page in the ftp files?
    By abhishek1711 in forum Templates, Stylesheets, Page Layout
    Replies: 6
    Last Post: 18 Mar 2011, 02:45 PM
  4. which files do I upload to the server?
    By mindapolis in forum Installing on a Windows Server
    Replies: 14
    Last Post: 23 Nov 2010, 08:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg