| Server IP : 54.36.91.62 / Your IP : 216.73.217.112 Web Server : Apache System : Linux webm013.cluster127.gra.hosting.ovh.net 5.15.206-ovh-vps-grsec-zfs-classid #1 SMP Fri May 15 02:41:25 UTC 2026 x86_64 User : coopiak ( 151928) PHP Version : 8.3.23 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/coopiak/plats-individuels/lyon/administrator/components/com_djclassifieds/sql/updates/ |
Upload File : |
ALTER TABLE `#__djcf_items` ADD `promotions` TEXT NOT NULL; CREATE TABLE IF NOT EXISTS `#__djcf_days` ( `id` int(11) NOT NULL AUTO_INCREMENT, `days` int(11) NOT NULL, `price` float(12,2) NOT NULL, `points` int(11) NOT NULL, `published` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; INSERT IGNORE INTO `#__djcf_days` (`id`, `days`, `price`, `points`, `published`) VALUES (1, 7, 0.00, 0, 1), (2, 14, 1.00, 0, 1), (3, 21, 2.00, 0, 1), (4, 30, 3.00, 0, 1); CREATE TABLE IF NOT EXISTS `#__djcf_promotions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `label` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `price` float(12,2) NOT NULL, `points` int(11) NOT NULL, `published` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; INSERT IGNORE INTO `#__djcf_promotions` (`id`, `name`, `label`, `description`, `price`, `points`, `published`) VALUES (1, 'p_first', 'COM_DJCLASSIFIEDS_PROMOTION_FIRST', 'COM_DJCLASSIFIEDS_PROMOTION_FIRST_DESC', 1.00, 0, 1), (2, 'p_bold', 'COM_DJCLASSIFIEDS_PROMOTION_BOLD', 'COM_DJCLASSIFIEDS_PROMOTION_BOLD_DESC', 1.00, 0, 1), (3, 'p_border', 'COM_DJCLASSIFIEDS_PROMOTION_BORDER', 'COM_DJCLASSIFIEDS_PROMOTION_BORDER_DESC', 1.00, 0, 1), (4, 'p_bg', 'COM_DJCLASSIFIEDS_PROMOTION_BG', 'COM_DJCLASSIFIEDS_PROMOTION_BG_DESC', 1.00, 0, 1), (5, 'p_special', 'COM_DJCLASSIFIEDS_PROMOTION_SPECIAL', 'COM_DJCLASSIFIEDS_PROMOTION_SPECIAL_DESC', 1.00, 0, 1);