Przedszkolak
Postów: 26 Ostrzeżeń: 1
Data rejestracji: 25.04.2008 14:28
ZBANOWANY: Dożywotnio
|
Dobra wszystko fajnie w pro download panel tylko troche za_dlugo sie pliki laduje a jak ja sobie pomysle zeby tak wrzucac kilka tys. plikow to mnie skreca.
Poza_tym nie dodaje fotek chociaz da chmody poustawiane.
Wiec jest jednak inny sposob aby dodac te kategorie ale w Master Downlaod Panel???
Kefirek tamten sposob nie dziala, albo nie robie tak jak trzeba.
Tu masz moje pliki z bazy od kategorii i subkategorii. Jakbys je poprzerabial troche i pokazal co i jak to bym zakapowal i bym sobie poradzil juz dalej sam xD
# Structure for Table `ep_master_download_cats`
#
DROP TABLE IF EXISTS `ep_master_download_cats`;
CREATE TABLE `ep_master_download_cats` (
`cat_id` smallint(5) unsigned NOT NULL auto_increment,
`cat_name` varchar(100) NOT NULL default '',
`cat_desc` text NOT NULL,
`cat_order` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
#
# Table Data for `ep_master_download_cats`
#
INSERT INTO `ep_master_download_cats` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES (1, 'Gry Java', '', 0);
INSERT INTO `ep_master_download_cats` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES (2, 'Gry Symbian', '', 1);
INSERT INTO `ep_master_download_cats` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES (3, 'Aplikacje', '', 2);
INSERT INTO `ep_master_download_cats` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES (4, 'Dzwonki', '', 3);
INSERT INTO `ep_master_download_cats` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES (5, 'Filmy 3GP', '', 4);
INSERT INTO `ep_master_download_cats` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES (6, 'Programy PC', '', 5);
INSERT INTO `ep_master_download_cats` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES (7, 'Motywy', '', 6);
INSERT INTO `ep_master_download_cats` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES (9, 'Tuning Telefonu', '', 7);
#
# Structure for Table `ep_master_download_subcats`
#
DROP TABLE IF EXISTS `ep_master_download_subcats`;
CREATE TABLE `ep_master_download_subcats` (
`subcat_id` smallint(5) unsigned NOT NULL auto_increment,
`subcat_cat` smallint(5) unsigned NOT NULL default '0',
`subcat_name` varchar(100) NOT NULL default '',
`subcat_desc` text NOT NULL,
`subcat_sort` varchar(16) NOT NULL default 'custom',
`subcat_viewaccess` tinyint(3) unsigned NOT NULL default '0',
`subcat_getaccess` tinyint(3) unsigned NOT NULL default '0',
`subcat_count` smallint(5) unsigned NOT NULL default '0',
`subcat_order` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`subcat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;
#
# Table Data for `ep_master_download_subcats`
#
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (1, 1, '128x160', '', 'datedesc', 0, 101, 6, 0);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (2, 1, '176x220', '', 'datedesc', 0, 101, 4, 1);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (3, 1, '240x320', '', 'datedesc', 0, 101, 29, 2);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (9, 4, 'True Tone', '', 'datedesc', 0, 101, 0, 2);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (4, 1, 'MultiScreen', '', 'datedesc', 0, 101, 16, 3);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (5, 2, '176x220', '', 'datedesc', 0, 101, 0, 0);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (6, 2, '240x320', '', 'datedesc', 0, 101, 0, 1);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (7, 3, 'Java', '', 'datedesc', 0, 101, 0, 0);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (8, 3, 'Symbian', '', 'datedesc', 0, 101, 0, 1);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (10, 4, 'WAV', '', 'datedesc', 0, 101, 0, 1);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (11, 4, 'MP3', '', 'datedesc', 0, 101, 0, 0);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (12, 5, 'Teledyski', '', 'datedesc', 0, 101, 0, 0);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (13, 5, 'Trailery', '', 'datedesc', 0, 101, 0, 1);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (14, 5, 'Inne', '', 'datedesc', 0, 101, 0, 2);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (15, 6, 'Edytory, Kreatory', '', 'datedesc', 0, 101, 0, 2);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (16, 6, 'Kompresja Audio/Video', '', 'datedesc', 0, 101, 0, 1);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (17, 6, 'Sterowniki', '', 'datedesc', 0, 101, 0, 0);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (18, 7, 'Nokia 128x160', '', 'datedesc', 0, 101, 0, 0);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (19, 7, 'Nokia 176x220', '', 'datedesc', 0, 101, 0, 1);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (20, 7, 'Nokia 240x320', '', 'datedesc', 0, 101, 0, 2);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (21, 7, 'SE 128x160', '', 'datedesc', 0, 101, 0, 3);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (22, 7, 'SE 176x220', '', 'datedesc', 0, 101, 0, 4);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (23, 7, 'SE 240x320', '', 'datedesc', 0, 101, 0, 5);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (24, 9, 'Softy', '', 'datedesc', 0, 101, 0, 4);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (25, 9, 'Patche', '', 'datedesc', 0, 101, 0, 3);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (28, 9, 'Inne', '', 'datedesc', 0, 101, 0, 5);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (26, 9, 'Flash Menu', '', 'datedesc', 0, 101, 0, 2);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (27, 9, 'Camdrivery', '', 'datedesc', 0, 101, 0, 1);
INSERT INTO `ep_master_download_subcats` (`subcat_id`, `subcat_cat`, `subcat_name`, `subcat_desc`, `subcat_sort`, `subcat_viewaccess`, `subcat_getaccess`, `subcat_count`, `subcat_order`) VALUES (29, 9, 'Akustyki', '', 'datedesc', 0, 101, 0, 0);
Kategorii, subkategorii, podkategorii - dwa "i" na końcu. /szymon
Edytowane przez szymon dnia 24.05.2008 17:31:36
|