EHCP-Force-Edition/ehcp/scriptsupdate.sql

-- Execute follownig sql on your phpmyadmin, ehcp database,
-- go to phpmyadmin, click on sql, copy and paste following, then click go
-- this truncates your scripts table, so,
-- if you have custom settings on this table, you need to backup them, or manually update your scripts table.. 

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=utf8 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.6', '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\
(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'),
(28, 'ehcp webmail', NULL, NULL, 'directurl', 'http://www.ehcp.net/other/webmail.tgz', 'webmail', NULL)
;



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';