I´m new about this but I understad the first of this
1. Create table - Make sure to add your table prefix if you have
==================================
CREATE TABLE `banners` (
`adid` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`title` VARCHAR( 250 ) NOT NULL DEFAULT '',
`status` INT( 1 ) NOT NULL DEFAULT '0',
`dateline` INT NOT NULL DEFAULT '0',
`html` VARCHAR( 250 ) NOT NULL DEFAULT '' ,
`url` VARCHAR( 250 ) NOT NULL DEFAULT '#',
`type` INT( 1 ) NOT NULL DEFAULT '1',
`width` INT( 10 ) DEFAULT '0' NOT NULL,
`height` INT( 10 ) DEFAULT '0' NOT NULL,
PRIMARY KEY ( `adid` )
);
==================================
but shuld I create this to mysql qvery to or ??
2. Master switch
==================================
INSERT INTO phrase (languageid, varname, text, phrasetypeid) VALUES (0, 'setting_enbanners_title', 'Enable Banners & Ads System', 5000);
INSERT INTO phrase (languageid, varname, text, phrasetypeid) VALUES (0, 'setting_enbanners_desc', 'If this option set to Yes, overal show banners and ads on navbar function will be turned on.', 5000);
INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('enbanners', 'general', '1', '1', 'yesno', '1000', '0', '0');
|