-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathehcpupgrade.sql
99 lines (71 loc) · 20.2 KB
/
ehcpupgrade.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
-- upgrade from previous versions to ehcp 0.29
-- may not fully work
use ehcp;
ALTER TABLE misc ADD panelusername VARCHAR( 30 ) NULL ;
ALTER TABLE ftpaccounts ADD type VARCHAR( 10 ) NULL ;
CREATE TABLE IF NOT EXISTS servers (
id smallint(6) NOT NULL auto_increment,
servertype varchar(10) default NULL,
ip varchar(20) default NULL,
mandatory char(1) default NULL,
location varchar(20) default NULL,
password varchar(20) default NULL,
defaultmysqlhostname varchar(30) default NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM;
ALTER TABLE `domains` ADD `serverip` VARCHAR( 20 ) NULL ;
ALTER TABLE `mysqldb` ADD `host` VARCHAR( 30 ) NULL ;
ALTER TABLE `mysqlusers` ADD `host` VARCHAR( 30 ) NULL ;
drop table scripts;
CREATE TABLE IF NOT EXISTS `scripts` (
`id` tinyint(4) NOT NULL auto_increment,
`scriptname` varchar(50) default NULL,
`homepage` varchar(50) default NULL,
`description` text,
`filetype` varchar(15) default NULL,
`fileinfo` varchar(200) default NULL,
`scriptdirtocopy` varchar(50) default NULL,
`commandsaftercopy` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='stores scripts that can be installed in ehcp' AUTO_INCREMENT=29 ;
--
-- Tablo döküm verisi `scripts`
--
INSERT INTO `scripts` (`id`, `scriptname`, `homepage`, `description`, `filetype`, `fileinfo`, `scriptdirtocopy`, `commandsaftercopy`) VALUES
(1, 'cms- joomla - 1.5.4', NULL, NULL, 'directurl', 'http://www.joomlatr.org/downloads/Joomla_1.5.5-Stable-Full_Package_tr.zip', '', 'cp /dev/null configuration.php\r\nchmod a+w configuration.php'),
(2, 'phpbb Forum script-3.02-tr', NULL, NULL, 'directurl', 'http://download.phpbbturkey.net/phpBB-3.0.2-tr.zip', 'phpBB3', 'chmod a+w cache\r\nchmod a+w files\r\nchmod a+w store\r\nchmod a+w config.php\r\nchmod a+w images/avatars/upload/\r\n'),
(3, 'cms - drupal 6.6', NULL, NULL, 'directurl', 'http://ftp.drupal.org/files/projects/drupal-6.6.tar.gz', 'drupal-6.4', 'cp ./sites/default/default.settings.php ./sites/default/settings.php\r\n\r\nchmod -Rvf a+w ./sites/default\r\n'),
(4, 'CMS - xoops 2.0.18.1', NULL, NULL, 'directurl', 'http://switch.dl.sourceforge.net/sourceforge/xoops/xoops-2.0.18.1.tar.gz', 'xoops-2.0.18.1/htdocs', NULL),
(5, 'netoffice Online Project Management ', NULL, NULL, 'directurl', 'http://download.ehcp.net/netoffice.dailybuild.20080927.zip', 'netoffice', NULL),
(6, 'phpmyadmin 3.0', NULL, NULL, 'directurl', 'http://heanet.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-3.0.0-all-languages.zip', 'phpMyAdmin-3.0.0-all-languages', NULL),
(7, 'blog - b2evolution 2.4.5', NULL, NULL, 'directurl', 'http://downloads.sourceforge.net/evocms/b2evolution-2.4.5-stable-2008-09-17.zip', 'b2evolution/blogs', NULL),
(8, 'cms - wordpress', NULL, NULL, 'directurl', 'http://wordpress.org/latest.tar.gz', '', NULL),
(9, 'phpfreechat', NULL, NULL, 'directurl', 'http://mesh.dl.sourceforge.net/sourceforge/phpfreechat/phpfreechat-1.2.tar.gz', 'phpfreechat-1.2', NULL),
(10, 'cms - modx ', NULL, NULL, 'directurl', 'http://download.ehcp.net/modx-0.9.6.2.tar.gz', 'modx-0.9.6.2', NULL),
(11, 'cms - e107', NULL, NULL, 'directurl', 'http://mesh.dl.sourceforge.net/sourceforge/e107/e107_v0.7.13_full.tar.gz', '', 'chmod a+w e107_config.php\r\nchmod a+w e107_files/cache/\r\nchmod a+w e107_files/public/\r\nchmod a+w e107_files/public/avatars/\r\nchmod a+w e107_plugins/\r\nchmod a+w e107_themes/'),
(12, 'cms - tikiwikicms - Huge !', NULL, NULL, 'directurl', 'http://garr.dl.sourceforge.net/sourceforge/tikiwiki/tikiwiki-2.2.tar.bz2', 'tikiwiki-2.2', NULL),
(13, 'osCommerce', '', NULL, 'directurl', 'http://www.oscommerce.com/ext/oscommerce-2.2rc2a.zip', 'oscommerce-2.2rc2a/catalog', 'chmod a+w includes/configure.php\r\nchmod a+w admin/includes/configure.php \r\n'),
(14, 'Gallery - Coppermine', NULL, NULL, 'directurl', 'http://garr.dl.sourceforge.net/sourceforge/coppermine/cpg1.4.19.tar.bz2', 'cpg1419', 'chmod a+w include\r\nchmod a+w albums\r\nchmod a+w albums/userpics\r\nchmod a+w albums/edit'),
(15, 'cms - cmsmadesimple', NULL, NULL, 'directurl', 'http://dev.cmsmadesimple.org/frs/download.php/2536/cmsmadesimple-1.4.1-full.tar.gz', '', NULL),
(16, 'cms - e-xoops', NULL, NULL, 'directurl', 'http://www.seslisevdasi.com/e-xoops_1.05Rev3.zip', 'exoops', 'chmod a+w mainfile.php\r\n\r\nchmod 777 cache/system\r\nchmod 666 images/verify.png\r\nchmod 777 images/smilies\r\nchmod 666 images/smilies/icon_biggrin.gif\r\nchmod 666 images/smilies/icon_confused.gif\r\nchmod 666 images/smilies/icon_cool.gif\r\nchmod 666 images/smilies/icon_cry.gif\r\nchmod 666 images/smilies/icon_drink.gif\r\nchmod 666 images/smilies/icon_eek.gif\r\nchmod 666 images/smilies/icon_evil.gif\r\nchmod 666 images/smilies/icon_frown.gif\r\nchmod 666 images/smilies/icon_hammer.gif\r\nchmod 666 images/smilies/icon_idea.gif\r\nchmod 666 images/smilies/icon_lol.gif\r\nchmod 666 images/smilies/icon_mad.gif\r\nchmod 666 images/smilies/icon_razz.gif\r\nchmod 666 images/smilies/icon_redface.gif\r\nchmod 666 images/smilies/icon_rolleyes.gif\r\nchmod 666 images/smilies/icon_smile.gif\r\nchmod 666 images/smilies/icon_wink.gif\r\nchmod 777 images/ranks\r\nchmod 666 images/ranks/moderator.gif\r\nchmod 666 images/ranks/rank0.gif\r\nchmod 666 images/ranks/rank1.gif\r\nchmod 666 images/ranks/rank2.gif\r\nchmod 666 images/ranks/rank3.gif\r\nchmod 666 images/ranks/rank4.gif\r\nchmod 666 images/ranks/rank5.gif\r\nchmod 666 images/ranks/webmaster.gif\r\nchmod 777 images/library\r\nchmod 777 images/avatar\r\nchmod 666 images/avatar/001.gif\r\nchmod 666 images/avatar/002.gif\r\nchmod 666 images/avatar/003.gif\r\nchmod 666 images/avatar/004.gif\r\nchmod 666 images/avatar/005.gif\r\nchmod 666 images/avatar/006.gif\r\nchmod 666 images/avatar/033.gif\r\nchmod 666 images/avatar/034.gif\r\nchmod 666 images/avatar/036.gif\r\nchmod 666 images/avatar/037.gif\r\nchmod 666 images/avatar/039.gif\r\nchmod 666 images/avatar/040.gif\r\nchmod 666 images/avatar/043.gif\r\nchmod 666 images/avatar/044.gif\r\nchmod 666 images/avatar/045.gif\r\nchmod 666 images/avatar/046.gif\r\nchmod 666 images/avatar/047.gif\r\nchmod 666 images/avatar/048.gif\r\nchmod 666 images/avatar/049.gif\r\nchmod 666 images/avatar/050.gif\r\nchmod 666 images/avatar/052.gif\r\nchmod 666 images/avatar/056.gif\r\nchmod 666 images/avatar/075.gif\r\nchmod 666 images/avatar/088.gif\r\nchmod 666 images/avatar/091.gif\r\nchmod 666 images/avatar/093.gif\r\nchmod 666 images/avatar/095.gif\r\nchmod 666 images/avatar/096.gif\r\nchmod 666 images/avatar/097.gif\r\nchmod 666 images/avatar/099.gif\r\nchmod 666 images/avatar/100.gif\r\nchmod 666 images/avatar/102.gif\r\nchmod 666 images/avatar/103.gif\r\nchmod 666 images/avatar/104.gif\r\nchmod 666 images/avatar/105.gif\r\nchmod 666 images/avatar/122.gif\r\nchmod 666 images/avatar/124.gif\r\nchmod 666 images/avatar/125.gif\r\nchmod 666 images/avatar/126.gif\r\nchmod 666 images/avatar/127.gif\r\nchmod 666 images/avatar/128.gif\r\nchmod 666 images/avatar/129.gif\r\nchmod 666 images/avatar/130.gif\r\nchmod 666 images/avatar/131.gif\r\nchmod 666 images/avatar/132.gif\r\nchmod 666 images/avatar/133.gif\r\nchmod 666 images/avatar/134.gif\r\nchmod 666 images/avatar/135.gif\r\nchmod 666 images/avatar/136.gif\r\nchmod 666 images/avatar/137.gif\r\nchmod 666 images/avatar/138.gif\r\nchmod 666 images/avatar/139.gif\r\nchmod 666 images/avatar/140.gif\r\nchmod 666 images/avatar/141.gif\r\nchmod 666 images/avatar/142.gif\r\nchmod 666 images/avatar/143.gif\r\nchmod 666 images/avatar/144.gif\r\nchmod 666 images/avatar/145.gif\r\nchmod 666 images/avatar/146.gif\r\nchmod 666 images/avatar/147.gif\r\nchmod 666 images/avatar/148.gif\r\nchmod 666 images/avatar/149.gif\r\nchmod 666 images/avatar/150.gif\r\nchmod 666 images/avatar/151.gif\r\nchmod 666 images/avatar/152.gif\r\nchmod 666 images/avatar/153.gif\r\nchmod 666 images/avatar/154.gif\r\nchmod 666 images/avatar/155.gif\r\nchmod 666 images/avatar/156.gif\r\nchmod 666 images/avatar/157.gif\r\nchmod 666 images/avatar/158.gif\r\nchmod 666 images/avatar/159.gif\r\nchmod 666 images/avatar/160.gif\r\nchmod 666 images/avatar/161.gif\r\nchmod 666 images/avatar/162.gif\r\nchmod 666 images/avatar/163.gif\r\nchmod 666 images/avatar/164.gif\r\nchmod 666 images/avatar/165.gif\r\nchmod 666 images/avatar/166.gif\r\nchmod 666 images/avatar/167.gif\r\nchmod 666 images/avatar/168.gif\r\nchmod 666 images/avatar/169.gif\r\nchmod 666 images/avatar/170.gif\r\nchmod 666 images/avatar/171.gif\r\nchmod 666 images/avatar/172.gif\r\nchmod 666 images/avatar/173.gif\r\nchmod 666 images/avatar/174.gif\r\nchmod 666 images/avatar/175.gif\r\nchmod 666 images/avatar/176.gif\r\nchmod 666 images/avatar/177.gif\r\nchmod 666 images/avatar/178.gif\r\nchmod 666 images/avatar/179.gif\r\nchmod 666 images/avatar/180.gif\r\nchmod 666 images/avatar/181.gif\r\nchmod 666 images/avatar/182.gif\r\nchmod 666 images/avatar/183.gif\r\nchmod 666 images/avatar/184.gif\r\nchmod 666 images/avatar/185.gif\r\nchmod 666 images/avatar/186.gif\r\nchmod 666 images/avatar/187.gif\r\nchmod 666 images/avatar/188.gif\r\nchmod 666 images/avatar/189.gif\r\nchmod 666 images/avatar/190.gif\r\nchmod 666 images/avatar/191.gif\r\nchmod 666 images/avatar/192.gif\r\nchmod 666 images/avatar/193.gif\r\nchmod 666 images/avatar/194.gif\r\nchmod 666 images/avatar/195.gif\r\nchmod 666 images/avatar/196.gif\r\nchmod 666 images/avatar/197.gif\r\nchmod 666 images/avatar/198.gif\r\nchmod 666 images/avatar/199.gif\r\nchmod 666 images/avatar/200.gif\r\nchmod 666 images/avatar/201.gif\r\nchmod 666 images/avatar/202.gif\r\nchmod 666 images/avatar/203.gif\r\nchmod 666 images/avatar/204.gif\r\nchmod 666 images/avatar/205.gif\r\nchmod 666 images/avatar/206.gif\r\nchmod 666 images/avatar/207.gif\r\nchmod 666 images/avatar/208.gif\r\nchmod 666 images/avatar/209.gif\r\nchmod 666 images/avatar/210.gif\r\nchmod 666 images/avatar/211.gif\r\nchmod 666 images/avatar/212.gif\r\nchmod 666 images/avatar/213.gif\r\nchmod 666 images/avatar/214.gif\r\nchmod 666 images/avatar/215.gif\r\nchmod 666 images/avatar/216.gif\r\nchmod 666 images/avatar/217.gif\r\nchmod 666 images/avatar/218.gif\r\nchmod 666 images/avatar/219.gif\r\nchmod 666 images/avatar/220.gif\r\nchmod 666 images/avatar/221.gif\r\nchmod 666 images/avatar/222.gif\r\nchmod 666 images/avatar/223.gif\r\nchmod 666 images/avatar/224.gif\r\nchmod 666 images/avatar/225.gif\r\nchmod 666 images/avatar/226.gif\r\nchmod 666 images/avatar/227.gif\r\nchmod 666 images/avatar/228.gif\r\nchmod 666 images/avatar/229.gif\r\nchmod 666 images/avatar/230.gif\r\nchmod 666 images/avatar/231.gif\r\nchmod 666 images/avatar/232.gif\r\nchmod 666 images/avatar/233.gif\r\nchmod 666 images/avatar/234.gif\r\nchmod 666 images/avatar/235.gif\r\nchmod 666 images/avatar/236.gif\r\nchmod 666 images/avatar/237.gif\r\nchmod 666 images/avatar/238.gif\r\nchmod 666 images/avatar/239.gif\r\nchmod 666 images/avatar/240.gif\r\nchmod 666 images/avatar/241.gif\r\nchmod 666 images/avatar/242.gif\r\nchmod 666 images/avatar/243.gif\r\nchmod 666 images/avatar/blank.gif\r\nchmod 777 images/avatar/users\r\nchmod 777 images/avatar/smilies\r\nchmod 666 images/avatar/smilies/007.gif\r\nchmod 666 images/avatar/smilies/008.gif\r\nchmod 666 images/avatar/smilies/009.gif\r\nchmod 666 images/avatar/smilies/010.gif\r\nchmod 666 images/avatar/smilies/011.gif\r\nchmod 666 images/avatar/smilies/012.gif\r\nchmod 666 images/avatar/smilies/013.gif\r\nchmod 666 images/avatar/smilies/014.gif\r\nchmod 666 images/avatar/smilies/015.gif\r\nchmod 666 images/avatar/smilies/016.gif\r\nchmod 666 images/avatar/smilies/017.gif\r\nchmod 666 images/avatar/smilies/018.gif\r\nchmod 666 images/avatar/smilies/019.gif\r\nchmod 666 images/avatar/smilies/020.gif\r\nchmod 666 images/avatar/smilies/021.gif\r\nchmod 666 images/avatar/smilies/022.gif\r\nchmod 666 images/avatar/smilies/023.gif\r\nchmod 666 images/avatar/smilies/024.gif\r\nchmod 666 images/avatar/smilies/025.gif\r\nchmod 666 images/avatar/smilies/026.gif\r\nchmod 666 images/avatar/smilies/027.gif\r\nchmod 666 images/avatar/smilies/028.gif\r\nchmod 666 images/avatar/smilies/029.gif\r\nchmod 666 images/avatar/smilies/030.gif\r\nchmod 666 images/avatar/smilies/031.gif\r\nchmod 666 images/avatar/smilies/032.gif\r\nchmod 666 images/avatar/smilies/035.gif\r\nchmod 666 images/avatar/smilies/038.gif\r\nchmod 666 images/avatar/smilies/041.gif\r\nchmod 666 images/avatar/smilies/042.gif\r\nchmod 666 images/avatar/smilies/053.gif\r\nchmod 666 images/avatar/smilies/054.gif\r\nchmod 666 images/avatar/smilies/057.gif\r\nchmod 666 images/avatar/smilies/059.gif\r\nchmod 666 images/avatar/smilies/060.gif\r\nchmod 666 images/avatar/smilies/061.gif\r\nchmod 666 images/avatar/smilies/062.gif\r\nchmod 666 images/avatar/smilies/063.gif\r\nchmod 666 images/avatar/smilies/064.gif\r\nchmod 666 images/avatar/smilies/065.gif\r\nchmod 666 images/avatar/smilies/066.gif\r\nchmod 666 images/avatar/smilies/067.gif\r\nchmod 666 images/avatar/smilies/068.gif\r\nchmod 666 images/avatar/smilies/069.gif\r\nchmod 666 images/avatar/smilies/070.gif\r\nchmod 666 images/avatar/smilies/071.gif\r\nchmod 666 images/avatar/smilies/072.gif\r\nchmod 666 images/avatar/smilies/073.gif\r\nchmod 666 images/avatar/smilies/074.gif\r\nchmod 666 images/avatar/smilies/076.gif\r\nchmod 666 images/avatar/smilies/077.gif\r\nchmod 666 images/avatar/smilies/078.gif\r\nchmod 666 images/avatar/smilies/079.gif\r\nchmod 666 images/avatar/smilies/080.gif\r\nchmod 666 images/avatar/smilies/081.gif\r\nchmod 666 images/avatar/smilies/082.gif\r\nchmod 666 images/avatar/smilies/083.gif\r\nchmod 666 images/avatar/smilies/084.gif\r\nchmod 666 images/avatar/smilies/085.gif\r\nchmod 666 images/avatar/smilies/086.gif\r\nchmod 666 images/avatar/smilies/087.gif\r\nchmod 666 images/avatar/smilies/092.gif\r\nchmod 666 images/avatar/smilies/094.gif\r\nchmod 666 images/avatar/smilies/098.gif\r\nchmod 666 images/avatar/smilies/106.gif\r\nchmod 666 images/avatar/smilies/108.gif\r\nchmod 666 images/avatar/smilies/109.gif\r\nchmod 666 images/avatar/smilies/110.gif\r\nchmod 666 images/avatar/smilies/111.gif\r\nchmod 666 images/avatar/smilies/112.gif\r\nchmod 666 images/avatar/smilies/113.gif\r\nchmod 666 images/avatar/smilies/114.gif\r\nchmod 666 images/avatar/smilies/115.gif\r\nchmod 666 images/avatar/smilies/116.gif\r\nchmod 666 images/avatar/smilies/117.gif\r\nchmod 666 images/avatar/smilies/118.gif\r\nchmod 666 images/avatar/smilies/119.gif\r\nchmod 666 images/avatar/smilies/120.gif\r\nchmod 666 images/avatar/smilies/121.gif\r\nchmod 777 modules/headlines/cache\r\nchmod 666 modules/mydownloads/cache/downloads.xml\r\nchmod 666 modules/mydownloads/cache/config.php\r\nchmod 666 modules/mydownloads/cache/disclaimer.php\r\nchmod 777 modules/mydownloads/cache/files\r\nchmod 777 modules/mydownloads/cache/logos\r\nchmod 777 modules/mydownloads/cache/shots\r\nchmod 666 modules/mylinks/cache/links.xml\r\nchmod 666 modules/mylinks/cache/config.php\r\nchmod 666 modules/mylinks/cache/disclaimer.php\r\nchmod 777 modules/mylinks/cache/logos\r\nchmod 777 modules/mylinks/cache/shots\r\nchmod 666 modules/newbb/cache/config.php\r\nchmod 666 modules/newbb/cache/disclaimer.php\r\nchmod 666 modules/news/cache/config.php\r\nchmod 666 modules/news/cache/news.xml\r\nchmod 777 modules/news/cache/topics\r\nchmod 666 modules/news/cache/topics/AllTopics.gif\r\nchmod 666 modules/news/cache/topics/announces.gif\r\nchmod 666 modules/news/cache/topics/blank.gif\r\nchmod 666 modules/news/cache/topics/blocks.gif\r\nchmod 666 modules/news/cache/topics/bug.gif\r\nchmod 666 modules/news/cache/topics/doc.gif\r\nchmod 666 modules/news/cache/topics/e-xoops.gif\r\nchmod 666 modules/news/cache/topics/graphics.gif\r\nchmod 666 modules/news/cache/topics/hacks.gif\r\nchmod 666 modules/news/cache/topics/hardware.gif\r\nchmod 666 modules/news/cache/topics/ideas.gif\r\nchmod 666 modules/news/cache/topics/info.gif\r\nchmod 666 modules/news/cache/topics/links.gif\r\nchmod 666 modules/news/cache/topics/misc.gif\r\nchmod 666 modules/news/cache/topics/modules.gif\r\nchmod 666 modules/news/cache/topics/money.gif\r\nchmod 666 modules/news/cache/topics/multimedia.gif\r\nchmod 666 modules/news/cache/topics/news.gif\r\nchmod 666 modules/news/cache/topics/patches.gif\r\nchmod 666 modules/news/cache/topics/privacy.gif\r\nchmod 666 modules/news/cache/topics/programming.gif\r\nchmod 666 modules/news/cache/topics/questions.gif\r\nchmod 666 modules/news/cache/topics/security.gif\r\nchmod 666 modules/news/cache/topics/software.gif\r\nchmod 666 modules/news/cache/topics/themes.gif\r\nchmod 666 modules/partners/cache/config.php\r\nchmod 777 modules/partners/cache/images\r\nchmod 777 modules/phpRPC/cache/logs\r\nchmod 666 modules/phpRPC/cache/config.php\r\nchmod 666 modules/sections/cache/sections.xml\r\nchmod 666 modules/sections/cache/intro.php\r\nchmod 666 modules/sections/cache/config.php\r\nchmod 777 modules/sections/cache/images\r\nchmod 666 modules/system/cache/adminmenu.php\r\nchmod 666 modules/system/cache/badips.php\r\nchmod 666 modules/system/cache/badunames.php\r\nchmod 666 modules/system/cache/bademails.php\r\nchmod 666 modules/system/cache/badwords.php\r\nchmod 666 modules/system/cache/config.php\r\nchmod 666 modules/system/cache/footer.php\r\nchmod 666 modules/system/cache/header.php\r\nchmod 666 modules/system/cache/meta.php\r\nchmod 666 modules/system/cache/unwanted.php\r\nchmod 666 modules/system/cache/wanted.php\r\nchmod 777 modules/xoopsfaq/cache\r\nchmod 666 modules/xoopsfaq/cache/config.php\r\nchmod 666 modules/xoopsfaq/cache/faq.xml\r\n\r\nchmod a+x modules/system/cache'),
(17, 'cms - MemHT 4.01', NULL, NULL, 'directurl', 'http://www.memht.com/files/memht_portal/releases/MemHT_Portal_4.0.1.rar', 'MemHT_Portal_4.0.1/files', NULL),
(18, 'Mediawiki 1.13.2', NULL, NULL, 'directurl', 'http://download.wikimedia.org/mediawiki/1.13/mediawiki-1.13.2.tar.gz', 'mediawiki-1.13.2', NULL),
(19, 'ecommerce-Magento', NULL, NULL, 'directurl', 'http://download.ehcp.net/magento-downloader-1.1.3.tar.bz2', 'magento', NULL),
(20, 'osTicket 1.6 rc4', NULL, NULL, 'directurl', 'http://osticket.com/download/osticket_1.6.rc4.tar.gz', 'osticket_1.6.rc4/upload', 'chmod a+w ostconfig.php'),
(21, 'forum - smf 1.1.7', NULL, NULL, 'directurl', 'http://mirror.pdx.simplemachines.org/downloads/smf_1-1-7_install.tar.gz', '', 'chmod a+w attachments\r\nchmod a+w avatars\r\nchmod a+w Packages\r\nchmod a+w Packages/installed.list\r\nchmod a+w Smileys\r\nchmod a+w Themes\r\nchmod a+w agreement.txt\r\nchmod a+w Settings.php\r\nchmod a+w Settings_bak.php\r\n'),
(22, 'ecommerce - ZenCart', NULL, NULL, 'directurl', 'http://dfn.dl.sourceforge.net/sourceforge/zencart/zen-cart-v1.3.8a-full-fileset-12112007.zip', 'zen-cart-v1.3.8a-full-fileset-12112007', 'cp /dev/null includes/configure.php\r\ncp /dev/null admin/includes/configure.php\r\n\r\nchmod a+w includes/configure.php\r\nchmod a+w admin/includes/configure.php\r\n\r\nchmod a+w cache\r\nchmod a+w -Rf images\r\nchmod a+w -Rf includes/languages/english/html_includes\r\nchmod a+w -Rf media\r\nchmod a+w -Rf pub\r\nchmod a+w -Rf admin/backups\r\nchmod a+w -Rf admin/images/graphs\r\n'),
(23, 'Gallery 2.3', NULL, NULL, 'directurl', 'http://puzzle.dl.sourceforge.net/sourceforge/gallery/gallery-2.3-typical.tar.gz', 'gallery2', NULL),
(24, 'course - moodle 1.9.3', NULL, NULL, 'directurl', 'http://download.moodle.org/stable19/moodle-weekly-19.tgz', 'moodle', 'mkdir moodledata\r\nchmod a+w moodledata'),
(25, 'phpAuction 3.3 gpl', NULL, NULL, 'directurl', 'http://download.ehcp.net/phpauction-gpl-3.3.tar.gz', 'phpauction-gpl-3.3', 'chmod 666 includes/config.inc.php\r\nchmod 666 includes/passwd.inc.php\r\nchmod 666 includes/categories_select_box.ES.inc.php\r\nchmod 666 includes/categories_select_box.EN.inc.php\r\nchmod 666 includes/countries.inc.php\r\nchmod 777 uploaded\r\nchmod 777 uploaded/cache\r\n'),
(26, 'Crafty Syntax Live Help', NULL, NULL, 'directurl', 'http://dfn.dl.sourceforge.net/sourceforge/cslive/craftysyntax.2.15.0.tar.gz', 'craftysyntax2.15.0', 'chmod 777 config.php'),
(27, 'openrealty 2.5.5', NULL, NULL, 'directurl', 'http://open-realty.org/release/open-realty2.5.5.zip', '', 'chmod a+w include/common.dist.php\r\nchmod a+w include\r\nchmod a+w images/listing_photos\r\nchmod a+w images/user_photos\r\nchmod a+w images/vtour_photos\r\nchmod a+w images/page_upload\r\nchmod a+w files/listings\r\nchmod a+w files/users');
drop table scripts_log;
CREATE TABLE IF NOT EXISTS `scripts_log` (
`id` tinyint(4) NOT NULL auto_increment,
`scriptname` varchar(50) default NULL,
`dir` text,
`panelusername` varchar(30) default NULL,
`domainname` varchar(30) default NULL,
`link` varchar(200) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM COMMENT='stores scripts that can be installed in ehcp';