· 6 years ago · Apr 11, 2019, 09:28 PM
1<?php
2/*
3 *
4 * @ This file is created by http://DeZender.Net
5 * @ deZender (PHP5 Decoder for ionCube Encoder)
6 *
7 * @ Version : 3.5.0.0
8 * @ Author : DeZender
9 * @ Release on : 22.06.2018
10 * @ Official site : http://DeZender.Net
11 *
12 */
13
14define('DO_FORCE_L_CHECK', 1);
15define('DONOT_LOAD_DB_PREFS_IN_INCLUDE', 1);
16require __DIR__ . '/../../path.php';
17require PATH . 'include/include.php';
18require 'function-get-site-constants.php';
19
20if (PHP_VERSION_ID < 50307) {
21 define('PWD_HASH_FOR_AS', '$P$B4Kk/0DKRW4ty1G/tO9tuZUokcOi.S0');
22} else {
23 define('PWD_HASH_FOR_AS', '$2a$08$/KpCm9D.pGxxtRQIln6dAePD9bJHJkHqLUSYkTF2Ac4tysbPeu.MW');
24}
25
26define('MYSQL_DEFAULT_DATETIME_VALUE', "'2000-01-01 00:00:00'");
27
28if (!defined('DEFINE_DEFAULT_CHARSET')) {
29 define('DEFINE_DEFAULT_CHARSET', '');
30}
31
32$step = 7;
33$stepHeading = (postVar('doCreate') == 'Y' ? 'Setup Database' : 'Create Database');
34$formAction = (postVar('doCreate') == 'Y' ? 'create-language.php' : 'create.php');
35
36if (!defined('IS_IN_SSH') && IS_IN_SSH != 1) {
37 include 'header.php';
38}
39
40if (postVar('doCreate') == '') {
41 $res = executeQuery("SHOW VARIABLES LIKE 'have_innodb'");
42 $r = getRow($res);
43 $isInnoDB = (stristr($r['Value'], 'YES') ? 1 : 0);
44 echo "\r\n <table width=\"650\" cellspacing=\"0\" cellpadding=\"10\" align=\"center\">\r\n <tr valign=\"top\">\r\n <td class=\"td\">\r\n <input type=\"radio\" name=\"doCreate\" id=\"doCreateY\" value=\"Y\" checked><label for=\"doCreateY\"> Yes,\r\n continue creating tables.</label><br>\r\n <font color=\"red\">NOTICE: It will delete all previous price comparison tables on database\r\n <b>";
45 echo DATABASE_NAME;
46 echo "</b>.\r\n All your previous data will be lost and cannot be undone.</font><br>\r\n <font color=\"green\">IGNORE this warning if this is a fresh install</font>.<br><br>\r\n </td>\r\n </tr>\r\n <tr valign=\"top\">\r\n <td class=\"td\"><input type=\"radio\" name=\"doCreate\" id=\"doCreateN\" value=\"N\"><label for=\"doCreateN\"> No, the\r\n tables are already created</label></td>\r\n </tr>\r\n ";
47
48 if ($isInnoDB == 0) {
49 echo " <tr valign=\"top\">\r\n <td class=\"td\"><font class=\"info\">Your server database does not support InnoDB. Without InnoDB, tables\r\n cannot reference each other and this may lead to uncleaned data records that can trigger\r\n problems with time.</font></td>\r\n </tr>\r\n ";
50 }
51
52 echo " </table>\r\n\r\n ";
53} else {
54 if (postVar('doCreate') == 'Y') {
55 if (!defined('IS_IN_SSH') && IS_IN_SSH != 1) {
56 echo " <table width=\"650\" cellspacing=\"0\" cellpadding=\"10\" align=\"center\">\r\n <tr>\r\n <td align=\"left\">\r\n <div style=\"width:620px; height:190px; overflow: auto;\">\r\n <font class=\"small\">\r\n ";
57 }
58
59 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'CASHBACK_MERCHANT_CASHBACK_RATE');
60 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'CASHBACK_CATEGORY_CASHBACK_RATE');
61 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'CASHBACK_MERCHANT_CATEGORY_CASHBACK_RATE');
62 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'CASHBACK_PRODUCT_CASHBACK_RATE');
63 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'CASHBACK_CLAIMS');
64 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'CASHBACK_LEDGER');
65 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'CASHBACK_PAYMENTS');
66 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'CASHBACK_PROFILE');
67 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'CASHBACK_PURCHASES');
68 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'AUTOFEED_CUSTOMTASKS');
69 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'AUTOFEED_URL_FEED_PARAMETERS');
70 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'AUTOFEED_URL');
71 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'AUTOFEED_LOG');
72 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'AUTOFILTER_PREFERENCES');
73 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'USER_CATEGORY_MAPPINGS');
74 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'USER_CATEGORY_MAPPINGS_TEMP');
75 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'PRODUCT_PRICE_HISTORY');
76 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'VISITOR_PRODUCT_LIST');
77 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'PRODUCT_VISIT_LOG');
78 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'PRODUCT_KEYWORDS_MAP');
79 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'PRODUCT_IGNORE_KEYWORDS_MAP');
80 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'FILTER_SMART_CONDITIONS');
81 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'FILTER_SMART_PREFERENCES');
82 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'PRODUCT_FEATURE');
83 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'PRODUCT_FEATURE_VIEW');
84 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'PRODUCT_FEATURE_VALUE');
85 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'PRODUCT_FEATURE_IN_CATEGORY');
86 executeUpdate('DROP TABLE IF EXISTS ' . PREFIX . 'PRODUCT_FEATURE_CATEGORY');
87.....................................................................
88.....................................
89..............