$INC_POOL = GET_DIR_AS_ARRAY("inc/autopurge/", "purge-");
// Run the filter
-RUN_FILTER('load_includes', $INC_POOL);
+runFilterChain('load_includes', $INC_POOL);
// Run filters for extra autopurge
-RUN_FILTER('extra_autopurge');
+runFilterChain('extra_autopurge');
//
?>
$INC_POOL = RESET_ADD_INCLUDES();
// Run the filter
- RUN_FILTER('load_includes', $INC_POOL);
+ runFilterChain('load_includes', $INC_POOL);
} // END - if
//
);
}
+// Load configuration and return it as an arry
+function loadConfiguration ($no="0") {
+ global $_CONFIG;
+
+ // Check for cache extension, cache-array and if the requested configuration is in cache
+ if ((is_array($GLOBALS['cache_array'])) && (isset($GLOBALS['cache_array']['config'][$no])) && (is_array($GLOBALS['cache_array']['config'][$no]))) {
+ // Load config from cache
+ //* DEBUG: */ echo gettype($GLOBALS['cache_array']['config'][$no])."<br />\n";
+ foreach ($GLOBALS['cache_array']['config'][$no] as $key => $value) {
+ $_CONFIG[$key] = $value;
+ } // END - foreach
+
+ // Count cache hits if exists
+ if ((isset($_CONFIG['cache_hits'])) && (EXT_IS_ACTIVE("cache"))) {
+ $_CONFIG['cache_hits']++;
+ } // END - if
+ } elseif ((!EXT_IS_ACTIVE("cache")) || (!isset($GLOBALS['cache_array']['config'][$no]))) {
+ // Load config from DB
+ $result_config = SQL_QUERY_ESC("SELECT * FROM `{!_MYSQL_PREFIX!}_config` WHERE config=%d LIMIT 1",
+ array(bigintval($no)), __FUNCTION__, __LINE__);
+
+ // Is the config there?
+ if (SQL_NUMROWS($result_config) == 1) {
+ // Get config from database
+ $_CONFIG = SQL_FETCHARRAY($result_config);
+ } // END - if
+
+ // Free result
+ SQL_FREERESULT($result_config);
+
+ // Remember this config in the array
+ $GLOBALS['cache_array']['config'][$no] = $_CONFIG;
+ }
+}
+
// [EOF]
?>
define('WEBMASTER', "you@some-hoster.tld.invalid");
// CFG: INSTALLED
-define('mxchange_installed', true);
+define('mxchange_installed', false);
// CFG: ADMIN-SETUP
-define('admin_registered', true);
+define('admin_registered', false);
// CFG: FRAMESET
define('frameset_active', false);
// CFG: MYSQL-HOST
'host' => "localhost",
// CFG: MYSQL-DBASE
- 'dbase' => "mxchange",
+ 'dbase' => "db",
// CFG: MYSQL-LOGIN
- 'login' => "root",
+ 'login' => "user",
// CFG: MYSQL-PASSWORD
- 'password' => "ab57dk90",
+ 'password' => "pass",
);
// CFG: MYSQL-PREIFX
// CFG: SMTP-HOSTNAME
define('SMTP_HOSTNAME', "");
// CFG: SMTP-USER
-define('SMTP_USER', "");
+define('SMTP_USER' , "");
// CFG: SMTP-PASSWORD
define('SMTP_PASSWORD', "");
// Current SVN revision
//define('CURR_SVN_REVISION', getActualVersion(0));
-define('CURR_SVN_REVISION', "804");
+define('CURR_SVN_REVISION', "805");
define('CURR_SVN_DATE' , getActualVersion(1));
define('CURR_SVN_VERSION' , getActualVersion(2));
// "Dry-run-mode" activated?
if (!$dry_run) {
// Run installation pre-installation filters
- RUN_FILTER('pre_extension_installed', array('dry_run' => $dry_run));
+ runFilterChain('pre_extension_installed', array('dry_run' => $dry_run));
// Register extension
SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_extensions` (ext_name, ext_active, ext_version) VALUES ('%s','%s','%s')",
array($ext_name, EXT_GET_ALWAYS_ACTIVE(), EXT_GET_VERSION()), __FILE__, __LINE__);
// Remove cache file(s) if extension is active
- RUN_FILTER('post_extension_installed', array('ext_name' => $ext_name, 'task_id' => $task_id, 'inc_pool' => $INC_POOL));
+ runFilterChain('post_extension_installed', array('ext_name' => $ext_name, 'task_id' => $task_id, 'inc_pool' => $INC_POOL));
// In normal mode return a true on success
$ret = true;
//* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, ":SQLs::count=".COUNT_SQLS()."");
if ((IS_SQLS_VALID() && (COUNT_SQLS() > 0))) {
// Run SQL commands...
- RUN_FILTER('run_sqls', array('dry_run' => false));
+ runFilterChain('run_sqls');
// Removal mode?
if ($load_mode == "remove") {
// Remove cache file(s) if extension is active
if (((EXT_IS_ACTIVE("cache")) || (GET_EXT_VERSION("cache") != "")) && (((SQL_AFFECTEDROWS() == 1)) || ($sqlRan === true) || ($load_mode == "activate") || ($load_mode == "deactivate"))) {
// Run filters
- RUN_FILTER('post_extension_run_sql', $ext_name);
+ runFilterChain('post_extension_run_sql', $ext_name);
} // END - if
// Is this the sql_patches?
// In real-mode execute any existing includes
if (!$dry_run) {
$GLOBALS['cache_array']['inc_pool'][$ext_name] = $INC_POOL;
- RUN_FILTER('load_includes', $INC_POOL);
+ runFilterChain('load_includes', $INC_POOL);
$INC_POOL = $GLOBALS['cache_array']['inc_pool'][$ext_name];
unset($GLOBALS['cache_array']['inc_pool'][$ext_name]);
} // END - if
// Run SQLs
- RUN_FILTER('run_sqls', array('dry_run' => $dry_run));
+ runFilterChain('run_sqls', array('dry_run' => $dry_run));
if (!$dry_run) {
// Create task
unset($GLOBALS['cache_array']['update_ver'][$ext_name]);
// Run filters on success extension update
- RUN_FILTER('extension_update', $ext_name);
+ runFilterChain('extension_update', $ext_name);
} // END - if
} // END - if
}
LOAD_INC_ONCE("inc/libs/cache_functions.php");
require(sprintf("%sinc/extensions/ext-cache.php", constant('PATH')));
if ($GLOBALS['cache_instance']->loadCacheFile("extensions", true)) $GLOBALS['cache_instance']->destroyCacheFile();
- if ($GLOBALS['cache_instance']->loadCacheFile("mod_reg")) $GLOBALS['cache_instance']->destroyCacheFile();
+ if ($GLOBALS['cache_instance']->loadCacheFile("modreg")) $GLOBALS['cache_instance']->destroyCacheFile();
} // END - if
} // END - if
define('MT_WORD3', getConfig('mt_word3'));
define('_MAX' , getConfig('rand_no'));
} else {
- // Set some lame ( ;-) ) default settings
+ // Set some lame ( ;-) ) default settings
setConfigEntry('def_refid' , 0);
setConfigEntry('enable_title_deco', "N");
setConfigEntry('title_mod_show' , "Y");
}
// "Runs" the given filters, data is optional and can be any type of data
-function RUN_FILTER ($filterName, $data = null, $silentAbort = true) {
+function runFilterChain ($filterName, $data = null, $silentAbort = true) {
// Is that filter chain there?
if (!isset($GLOBALS['filters']['chains'][$filterName])) {
// Then abort here (quick'N'dirty hack)
} // END - if
// Run the run_sqls filter in non-dry mode
- RUN_FILTER('run_sqls', array('dry_run' => false));
+ runFilterChain('run_sqls');
}
// Filter for calling the handler for login failures
}
// Check if legacy or PHPMailer command
+// @TODO Rewrite this to an extension 'smtp'
// @private
function CHECK_PHPMAILER_USAGE() {
- return ((defined('SMTP_HOSTNAME')) && (defined('SMTP_USER')) && (defined('SMTP_PASSWORD')) && (SMTP_HOSTNAME != "") && (SMTP_USER != ""));
+ return ((defined('SMTP_HOSTNAME')) && (defined('SMTP_USER')) && (defined('SMTP_PASSWORD')) && (constant('SMTP_HOSTNAME') != "") && (constant('SMTP_USER') != ""));
}
/*
function SELECTION_COUNT ($array) {
$ret = 0;
if (is_array($array)) {
- foreach ($array as $key => $sel) {
- if (!empty($sel)) $ret++;
+ foreach ($array as $key => $selected) {
+ if (!empty($selected)) $ret++;
}
}
return $ret;
// Deprecated : $length
// Optional : $DATA
//
-function GEN_RANDOM_CODE ($length, $code, $uid, $DATA="") {
+function generateRandomCodde ($length, $code, $uid, $DATA="") {
// Fix missing _MAX constant
+ // @TODO Rewrite this unnice code
if (!defined('_MAX')) define('_MAX', 15235);
// Build server string
// Add more additional data
if (isSessionVariableSet('u_hash')) $data .= ":".get_session('u_hash');
if (isset($GLOBALS['userid'])) $data .= ":".$GLOBALS['userid'];
- if (isSessionVariableSet('mxchange_theme')) $data .= ":".get_session('mxchange_theme');
- if (isSessionVariableSet('mx_lang')) $data .= ":".GET_LANGUAGE();
- if (isset($GLOBALS['refid'])) $data .= ":".$GLOBALS['refid'];
+ if (isSessionVariableSet('mxchange_theme')) $data .= ":".get_session('mxchange_theme');
+ if (isSessionVariableSet('mx_lang')) $data .= ":".GET_LANGUAGE();
+ if (isset($GLOBALS['refid'])) $data .= ":".$GLOBALS['refid'];
// Calculate number for generating the code
$a = $code + constant('_ADD') - 1;
$rcode = hexdec(substr($saltedHash, strlen(getConfig('master_salt')), 9)) / abs(constant('_MAX') - $a + sqrt(constant('_ADD'))) / pi();
} else {
// Generate hash with "hash of site key" from modula of number with the prime number and other data
- $saltedHash = generateHash(($a % constant('_PRIME')).":".$server.":".$keys.":".$data.":".date("d-m-Y (l-F-T)", time()).":".$a, substr(sha1(SITE_KEY), 0, 8));
+ $saltedHash = generateHash(($a % constant('_PRIME')).":".$server.":".$keys.":".$data.":".date("d-m-Y (l-F-T)", time()).":".$a, substr(sha1(constant('SITE_KEY')), 0, 8));
// Create number from hash
$rcode = hexdec(substr($saltedHash, 8, 9)) / abs(constant('_MAX') - $a + sqrt(constant('_ADD'))) / pi();
}
// Rebuild cache
-function REBUILD_CACHE ($cache, $inc="") {
+function rebuildCacheFiles ($cache, $inc="") {
// Shall I remove the cache file?
if ((EXT_IS_ACTIVE("cache")) && (is_object($GLOBALS['cache_instance']))) {
// Rebuild cache
SQL_ALTER_TABLE("ALTER TABLE `{!_MYSQL_PREFIX!}_refsystem` ADD UNIQUE `userid_level` ( `userid` , `level` )", __FILE__, __LINE__);
// Rebuild cache
- REBUILD_CACHE("refsystem", "refsystem");
+ rebuildCacheFiles("refsystem", "refsystem");
} // END - if
// Free result
// Remember title in constant for the template
define('__PAGE_TITLE', $TITLE);
} elseif ((!isInstalled()) || (!isAdminRegistered())) {
- // Load language here
- LOAD_INC_ONCE("inc/language/install_".GET_LANGUAGE().".php");
-
// Installation mode
define('__PAGE_TITLE', sprintf(getMessage('INSTALLATION_OF_MXCHANGE'), constant('MAIN_TITLE')));
} else {
// Call-back function for running shutdown functions and close database connection
function __SHUTDOWN_HOOK () {
// Call the filter chain 'shutdown'
- RUN_FILTER('shutdown', null, false);
+ runFilterChain('shutdown', null, false);
if (SQL_IS_LINK_UP()) {
// Close link
} // END - if
// Now run all queries through and try to keep out empty or comment queries
- RUN_FILTER('run_sqls', array('dry_run' => false));
+ runFilterChain('run_sqls');
// Ok, all done. So we can write the config data to the php files
if (REQUEST_POST('spath') != constant('PATH')) changeDataInFile(REQUEST_POST('spath')."inc/config.php", "SERVER-PATH", "define('PATH', \"", "\");", REQUEST_POST('spath'), 0);
LOAD_INC_ONCE($INC);
// Check for installation mode
-if (isInstalling()) {
+if ((isInstalling()) || (!isInstalled()) || (!isAdminRegistered())) {
// Load matching language file
LOAD_INC("inc/language/install_".$mx_lang.".php");
}
}
// Remove cache file
- RUN_FILTER('post_admin_edited', REQUEST_POST_ARRAY());
+ runFilterChain('post_admin_edited', REQUEST_POST_ARRAY());
}
// Make admin accounts editable
// Begin the edit loop
$SW = 2; $OUT = "";
- foreach ($POST['sel'] as $id => $sel) {
+ foreach ($POST['sel'] as $id => $selected) {
// Secure ID number
$id = bigintval($id);
// Get the admin's data
$result = SQL_QUERY_ESC("SELECT login, email, default_acl AS mode, la_mode FROM `{!_MYSQL_PREFIX!}_admins` WHERE id=%s LIMIT 1",
array($id), __FUNCTION__, __LINE__);
- if ((SQL_NUMROWS($result) == 1) && ($sel == 1)) {
+ if ((SQL_NUMROWS($result) == 1) && ($selected == 1)) {
// Entry found
$content = SQL_FETCHARRAY($result);
SQL_FREERESULT($result);
if ($accounts > 1) {
// Delete accounts
$SW = 2; $OUT = "";
- foreach ($POST['sel'] as $id => $sel) {
+ foreach ($POST['sel'] as $id => $selected) {
// Secure ID number
$id = bigintval($id);
// Get the admin's data
$result = SQL_QUERY_ESC("SELECT login, email, default_acl AS mode, la_mode FROM `{!_MYSQL_PREFIX!}_admins` WHERE id=%s LIMIT 1",
- array($id), __FUNCTION__, __LINE__);
+ array($id), __FUNCTION__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
// Entry found
$content = SQL_FETCHARRAY($result);
}
// Remove cache if cache system is activated
- RUN_FILTER('post_admin_deleted', REQUEST_POST_ARRAY());
+ runFilterChain('post_admin_deleted', REQUEST_POST_ARRAY());
}
// List all admin accounts
if (EXT_IS_ACTIVE("cache")) {
if ($GLOBALS['cache_instance']->loadCacheFile("config")) $GLOBALS['cache_instance']->destroyCacheFile();
if ($GLOBALS['cache_instance']->loadCacheFile("extensions")) $GLOBALS['cache_instance']->destroyCacheFile();
- if ($GLOBALS['cache_instance']->loadCacheFile("mod_reg")) $GLOBALS['cache_instance']->destroyCacheFile();
+ if ($GLOBALS['cache_instance']->loadCacheFile("modreg")) $GLOBALS['cache_instance']->destroyCacheFile();
} // END - if
// Return it
if ($GLOBALS['cache_instance']->loadCacheFile("admins_acls")) $GLOBALS['cache_instance']->destroyCacheFile();
if ($GLOBALS['cache_instance']->loadCacheFile("config")) $GLOBALS['cache_instance']->destroyCacheFile();
if ($GLOBALS['cache_instance']->loadCacheFile("extensions")) $GLOBALS['cache_instance']->destroyCacheFile();
- if ($GLOBALS['cache_instance']->loadCacheFile("mod_reg")) $GLOBALS['cache_instance']->destroyCacheFile();
+ if ($GLOBALS['cache_instance']->loadCacheFile("modreg")) $GLOBALS['cache_instance']->destroyCacheFile();
if ($GLOBALS['cache_instance']->loadCacheFile("refdepths")) $GLOBALS['cache_instance']->destroyCacheFile();
if ($GLOBALS['cache_instance']->loadCacheFile("refsystem")) $GLOBALS['cache_instance']->destroyCacheFile();
if ($GLOBALS['cache_instance']->loadCacheFile("themes")) $GLOBALS['cache_instance']->destroyCacheFile();
}
// ... and now the validation code
- $valCode = GEN_RANDOM_CODE($length, sha1(SURFBAR_GET_SALT().":".$urlId), $GLOBALS['userid']);
+ $valCode = generateRandomCodde($length, sha1(SURFBAR_GET_SALT().":".$urlId), $GLOBALS['userid']);
//* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "valCode={$valCode}", false);
} // END - while
array($hash, $uid), __FUNCTION__, __LINE__);
// No login bonus by default
- // @TODO Make this filter working: $ADDON = RUN_FILTER('post_login_update', array('login' => $login, 'online' => $online));
+ // @TODO Make this filter working: $ADDON = runFilterChain('post_login_update', array('login' => $login, 'online' => $online));
$BONUS = false;
// Probe for last online timemark
$hash = generatePassString($hash);
// Update global array
- // @TODO Make this filter working: $URL = RUN_FILTER('do_login', array('uid' => $uid, 'hash' => $hash, 'addon' => $ADDON));
+ // @TODO Make this filter working: $URL = runFilterChain('do_login', array('uid' => $uid, 'hash' => $hash, 'addon' => $ADDON));
$GLOBALS['userid'] = $uid;
// Try to set session data (which shall normally always work!)
$INC_POOL = GET_DIR_AS_ARRAY("inc/loader/", "load_cache-");
// Run the filter
-RUN_FILTER('load_includes', $INC_POOL);
+runFilterChain('load_includes', $INC_POOL);
//
?>
}
// Run the filter
-RUN_FILTER('load_includes', $INC_POOL);
+runFilterChain('load_includes', $INC_POOL);
// Uninstall extensions that are no longer in our system
if (!empty($DEL[0])) {
$GLOBALS['cache_instance']->storeExtensionVersion("admins");
// Load every data from DB to cache file
- $ADD = RUN_FILTER('sql_admin_extra_data');
+ $ADD = runFilterChain('sql_admin_extra_data');
// Query the database about this
$result_admins = SQL_QUERY("SELECT id AS aid, login, password, email".$ADD."
}
// Next cached table is the module registry (mod_reg)...
-if (($GLOBALS['cache_instance']->loadCacheFile("mod_reg")) && ($GLOBALS['cache_instance']->extensionVersionMatches("sql_patches"))) {
+if (($GLOBALS['cache_instance']->loadCacheFile("modreg")) && ($GLOBALS['cache_instance']->extensionVersionMatches("sql_patches"))) {
// Load cache
$GLOBALS['cache_array']['modules'] = $GLOBALS['cache_instance']->getArrayFromCache();
);
for ($idx = 0; $idx < 4; $idx++) {
- $content['check'] .= GEN_RANDOM_CODE("8", mt_rand(0, "$MONTH$DAY"), $uid, ($AGE*($idx+1)));
+ $content['check'] .= generateRandomCodde("8", mt_rand(0, "$MONTH$DAY"), $uid, ($AGE*($idx+1)));
}
// Insert row into database
{
case "done":
// Check for access control line of current menu entry
- $GLOBALS['acl_allow'] = RUN_FILTER('check_admin_acl');
+ $GLOBALS['acl_allow'] = runFilterChain('check_admin_acl');
// When type of admin menu is not set fallback to old menu system
if (!isConfigEntrySet('admin_menu')) setConfigEntry('admin_menu', "OLD");
} // END - if
} elseif (!EXT_IS_ACTIVE("cache")) {
// Add extra data via filter now
- $ADD = RUN_FILTER('sql_admin_extra_data');
+ $ADD = runFilterChain('sql_admin_extra_data');
// Get password from DB
$result = SQL_QUERY_ESC("SELECT password".$ADD." FROM `{!_MYSQL_PREFIX!}_admins` WHERE id=%s LIMIT 1",
}
// Rebuild cache
- REBUILD_CACHE("admins", "admin");
+ rebuildCacheFiles("admins", "admin");
// Login has failed by default... ;-)
$ret = "failed";
array($aid), __FUNCTION__, __LINE__);
// Rebuild cache
- REBUILD_CACHE("admins", "admin");
+ rebuildCacheFiles("admins", "admin");
} // END - if
// Return the result
array($adminLogin), __FUNCTION__, __LINE__);
// Rebuild cache
- REBUILD_CACHE("admins", "admin");
+ rebuildCacheFiles("admins", "admin");
} // END - if
// Now set all session variables and return the result
SQL_QUERY($sql, __FUNCTION__, __LINE__);
// Rebuild cache
- REBUILD_CACHE("config", "config");
+ rebuildCacheFiles("config", "config");
// Settings saved
LOAD_TEMPLATE("admin_settings_saved", false, getMessage('SETTINGS_SAVED'));
array($passHash, $login), __FUNCTION__, __LINE__);
// Run filters
- RUN_FILTER('post_admin_reset_pass', array('login' => $login, 'hash' => $passHash));
+ runFilterChain('post_admin_reset_pass', array('login' => $login, 'hash' => $passHash));
// Return output
return ADMIN_PASSWORD_RESET_DONE;
// Close task but not already closes or deleted or update tasks
if (($status != "CLOSED") && ($status != "DELETED") && ($type != "EXTENSION_UPDATE")) {
// Solve the task
- RUN_FILTER('solve_task', $tid);
+ runFilterChain('solve_task', $tid);
} // END - if
}
break;
// Close task
if (($status != "CLOSED") && ($status != "DELETED")) {
// Solve the task
- RUN_FILTER('solve_task', $tid);
+ runFilterChain('solve_task', $tid);
} // END - if
break;
LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_ADMINS_ADD_DONE'));
// Run filter chain
- RUN_FILTER('post_admin_added', REQUEST_POST_ARRAY());
+ runFilterChain('post_admin_added', REQUEST_POST_ARRAY());
} // END - if
} // END - if
if ((REQUEST_ISSET_POST(('edit'))) && ($SEL > 0)) {
// Edit ACLs
$SW = 2; $OUT = "";
- foreach (REQUEST_POST('sel') as $id => $sel) {
+ foreach (REQUEST_POST('sel') as $id => $selected) {
// Load data for the ID
$result = SQL_QUERY_ESC("SELECT admin_id, action_menu, what_menu, access_mode FROM `{!_MYSQL_PREFIX!}_admins_acls` WHERE id=%s LIMIT 1",
array(bigintval($id)), __FILE__, __LINE__);
LOAD_TEMPLATE("admin_config_admins_edit");
} elseif ((REQUEST_ISSET_POST(('change'))) && ($SEL > 0)) {
// Change entries
- foreach (REQUEST_POST('sel') as $id => $sel) {
+ foreach (REQUEST_POST('sel') as $id => $selected) {
// Secure ID
$id = bigintval($id);
} elseif ((REQUEST_ISSET_POST(('del'))) && ($SEL > 0)) {
// Delete ACLs
$SW = 2; $OUT = "";
- foreach (REQUEST_POST('sel') as $id => $sel) {
+ foreach (REQUEST_POST('sel') as $id => $selected) {
// Load data for the ID
$result = SQL_QUERY_ESC("SELECT admin_id, action_menu, what_menu, access_mode FROM `{!_MYSQL_PREFIX!}_admins_acls` WHERE id=%s LIMIT 1",
array(bigintval($id)), __FILE__, __LINE__);
LOAD_TEMPLATE("admin_config_admins_del");
} elseif ((REQUEST_ISSET_POST(('remove'))) && ($SEL > 0)) {
// Remove entries
- foreach (REQUEST_POST('sel') as $id => $sel) {
+ foreach (REQUEST_POST('sel') as $id => $selected) {
SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_admins_acls` WHERE id=%s LIMIT 1",
array(bigintval($id)),__FILE__, __LINE__);
}
// Remove cache file if version matches
if (GET_EXT_VERSION("cache") >= "0.1.2") {
- if ($GLOBALS['cache_instance']->loadCacheFile("mod_reg")) $GLOBALS['cache_instance']->destroyCacheFile();
+ if ($GLOBALS['cache_instance']->loadCacheFile("modreg")) $GLOBALS['cache_instance']->destroyCacheFile();
}
// Entries updated
if (COUNT_SQLS() > 0) {
// Run all SQL commands
- RUN_FILTER('run_sqls', array('dry_run' => false));
+ runFilterChain('run_sqls');
// Entry saved...
$message = SETTINGS_SAVED;
// Destroy config cache file here...
- REBUILD_CACHE("config", "config");
+ rebuildCacheFiles("config", "config");
} else {
// Prepare failed-message
$message = "<span class=\"admin_failed\">{--SETTINGS_NOT_SAVED--}</span>";
// Is this extension selected?
if ($active == 1) {
// Run any assigned removal filters
- RUN_FILTER('extension_remove', GET_EXT_NAME($ext_id));
+ runFilterChain('extension_remove', GET_EXT_NAME($ext_id));
// Run embeded SQL commands
EXTENSION_RUN_SQLS($ext_id, "remove");
// Remove cache file (will be auto-created again!)
if ($GLOBALS['cache_instance']->loadCacheFile("config")) $GLOBALS['cache_instance']->destroyCacheFile();
if ($GLOBALS['cache_instance']->loadCacheFile("extensions", true)) $GLOBALS['cache_instance']->destroyCacheFile();
- if ($GLOBALS['cache_instance']->loadCacheFile("mod_reg")) $GLOBALS['cache_instance']->destroyCacheFile();
+ if ($GLOBALS['cache_instance']->loadCacheFile("modreg")) $GLOBALS['cache_instance']->destroyCacheFile();
} // END - if
} elseif (GET_EXT_VERSION($ext_name) != "") {
// Notify the admin that we have a problem here...
}
// Create message
- $MSG = ADMIN_COUNTRIES_MODIFIED;
+ $MSG = getMessage('ADMIN_COUNTRIES_MODIFIED');
} elseif ((REQUEST_ISSET_POST(('remove'))) && (REQUEST_ISSET_POST(('id')))) {
// Remove
$IDs = implode(",", array_keys(REQUEST_POST('id')));
ADD_SQL("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_countries` WHERE id IN (".$IDs.") LIMIT ".count(REQUEST_POST('id'))."");
// Create message
- $MSG = ADMIN_COUNTRIES_REMOVED;
+ $MSG = getMessage('ADMIN_COUNTRIES_REMOVED');
}
if ((!empty($MSG)) && (COUNT_SQLS() > 0)) {
// Run SQL commands
- RUN_FILTER('run_sqls', array('dry_run' => false));
+ runFilterChain('run_sqls');
// Display message
LOAD_TEMPLATE("admin_settings_saved", false, $MSG);
array(bigintval(REQUEST_POST('uid'))), __FILE__, __LINE__);
// Next the task system...
- RUN_FILTER('solve_task', bigintval(REQUEST_POST('id')));
+ runFilterChain('solve_task', bigintval(REQUEST_POST('id')));
// Send mail to user
$msg = LOAD_EMAIL_TEMPLATE("member_newsletter_done", true, bigintval(REQUEST_POST('uid')));
if ($ret[0] == $eok) {
// Clear task
if ($task > 0) {
- RUN_FILTER('solve_task', $task);
+ runFilterChain('solve_task', $task);
}
// Clear payout request
if (IS_FORM_SENT()) {
if ($task > 0) {
// Clear task
- RUN_FILTER('solve_task', $task);
+ runFilterChain('solve_task', $task);
}
// Clear payout request
$MSG = "";
// Quick actions on a rallye
-if (REQUEST_ISSET_GET(('rallye')))
-{
- // Activate / deactivate
- $sql = "";
- if (REQUEST_ISSET_GET(('activate')))
- {
+if (REQUEST_ISSET_GET(('rallye'))) {
+ // Init SQL queries
+ INIT_SQLS();
+
+ if (REQUEST_ISSET_GET(('activate'))) {
+ // Activate / deactivate
switch (REQUEST_GET('activate'))
{
case "1": // Activate
- $sql = "UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET is_active='Y' WHERE id=%s AND is_active='N' LIMIT 1";
+ ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET is_active='Y' WHERE id=%s AND is_active='N' LIMIT 1");
break;
case "0": // Deactivate
- $sql = "UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET is_active='N' WHERE id=%s AND is_active='Y' LIMIT 1";
+ ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET is_active='N' WHERE id=%s AND is_active='Y' LIMIT 1");
break;
}
- }
-
- // Automatic notification
- if (REQUEST_ISSET_GET(('notify')))
- {
+ } elseif (REQUEST_ISSET_GET(('notify'))) {
+ // Automatic notification
switch (REQUEST_GET('notify'))
{
case "1": // Activate
- $sql = "UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET send_notify='Y' WHERE id=%s AND send_notify='N' LIMIT 1";
+ ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET send_notify='Y' WHERE id=%s AND send_notify='N' LIMIT 1");
break;
case "0": // Deactivate
- $sql = "UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET send_notify='N' WHERE id=%s AND send_notify='Y' LIMIT 1";
+ ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET send_notify='N' WHERE id=%s AND send_notify='Y' LIMIT 1");
break;
}
- }
-
- // Automatic adding of new members
- if (REQUEST_ISSET_GET(('auto')))
- {
+ } elseif (REQUEST_ISSET_GET(('auto'))) {
+ // Automatic adding of new members
switch (REQUEST_GET('auto'))
{
case "1": // Activate
- $sql = "UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET auto_add_new_user='Y' WHERE id=%s AND auto_add_new_user='N' LIMIT 1";
+ ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET auto_add_new_user='Y' WHERE id=%s AND auto_add_new_user='N' LIMIT 1");
break;
case "0": // Deactivate
- $sql = "UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET auto_add_new_user='N' WHERE id=%s AND auto_add_new_user='Y' LIMIT 1";
+ ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET auto_add_new_user='N' WHERE id=%s AND auto_add_new_user='Y' LIMIT 1");
break;
}
}
// Run SQL command
- if (!empty($sql))
- {
- $result = SQL_QUERY_ESC($sql, array(bigintval(REQUEST_GET('rallye'))), __FILE__, __LINE__);
- }
-}
- elseif (REQUEST_ISSET_POST(('remove')))
-{
+ runFilterChain('run_sqls');
+} elseif (REQUEST_ISSET_POST(('remove'))) {
// Delete rallyes
$SEL = SELECTION_COUNT(REQUEST_POST('sel'));
- if ($SEL > 0)
- {
+ if ($SEL > 0) {
// Delete selected rallyes and all it's data
- foreach (REQUEST_POST('sel') as $id => $sel)
- {
+ foreach (REQUEST_POST('sel') as $id => $selected) {
// Remove selected rallye entirely...
SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_rallye_data` WHERE id=%s LIMIT 1",
array(bigintval($id)), __FILE__, __LINE__);
}
// Output message
- $MSG = RALLYE_DELETED;
- }
- else
- {
+ $MSG = getMessage('RALLYE_DELETED');
+ } else {
// No rallye selected to delete!
- $MSG = RALLYE_DELETE_NOTHING_SELECTED;
+ $MSG = getMessage('RALLYE_DELETE_NOTHING_SELECTED');
}
-}
- elseif (REQUEST_ISSET_POST(('change')))
-{
+} elseif (REQUEST_ISSET_POST(('change'))) {
// Change rallye
$SEL = SELECTION_COUNT(REQUEST_POST('title'));
- if ($SEL > 0)
- {
+ if ($SEL > 0) {
// Change selected rallyes and all it's data
- foreach (REQUEST_POST('title') as $id => $title)
- {
+ foreach (REQUEST_POST('title') as $id => $title) {
// Secure ID number
$id = bigintval($id);
}
// Output message
- $MSG = RALLYE_CHANGED;
+ $MSG = getMessage('RALLYE_CHANGED');
}
}
if ($SEL > 0) {
// Make all selected and deactivated rallyes editable
$SW = 2; $OUT = "";
- foreach (REQUEST_POST('sel') as $id => $sel) {
+ foreach (REQUEST_POST('sel') as $id => $selected) {
// Load rallye basic data
$result = SQL_QUERY_ESC("SELECT title, descr, template, start_time, end_time, min_users, min_prices FROM `{!_MYSQL_PREFIX!}_rallye_data` WHERE id=%s LIMIT 1",
- array(bigintval($id)), __FILE__, __LINE__);
+ array(bigintval($id)), __FILE__, __LINE__);
list($title, $descr, $templ, $start, $end, $min_users, $min_prices) = SQL_FETCHROW($result);
SQL_FREERESULT($result);
} elseif ((REQUEST_GET('sub') == "users") && (REQUEST_GET('rallye') > 0)) {
// List users and their refs before start and current
$result = SQL_QUERY_ESC("SELECT userid, refs, curr_points FROM `{!_MYSQL_PREFIX!}_rallye_users` WHERE rallye_id=%s ORDER BY userid",
- array(bigintval(REQUEST_GET('rallye'))), __FILE__, __LINE__);
- if (SQL_NUMROWS($result) > 0)
- {
+ array(bigintval(REQUEST_GET('rallye'))), __FILE__, __LINE__);
+ if (SQL_NUMROWS($result) > 0) {
$SW = 2; $OUT = "";
define('__RALLYE_VALUE', REQUEST_GET('rallye'));
- while (list($uid, $old, $opoints) = SQL_FETCHROW($result))
- {
+ while (list($uid, $old, $opoints) = SQL_FETCHROW($result)) {
// Check for referal count
$cnt = RALLYE_GET_REFCOUNT($uid, $old);
LOAD_TEMPLATE("admin_list_rallye_usr");
} else {
// No entries found?
- LOAD_TEMPLATE("admin_settings_saved", false, RALLYE_ADMIN_USERS_404);
+ LOAD_TEMPLATE("admin_settings_saved", false, getMessage('RALLYE_ADMIN_USERS_404'));
}
} else {
// Start listing rallyes
// Count assigned prices
$result_prices = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_rallye_prices` WHERE rallye_id=%s",
- array(bigintval($id)), __FILE__, __LINE__);
+ array(bigintval($id)), __FILE__, __LINE__);
// Count joined userids
$result_user = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_rallye_users` WHERE rallye_id=%s",
- array($id), __FILE__, __LINE__);
+ array($id), __FILE__, __LINE__);
$joined = SQL_NUMROWS($result_user);
// Did some users joined this rallye?
case "Y":
// Rallye is active so do not edit it!
$content['select'] = "<div class=\"big\">".$id."</strong>";
- $content['active_title'] = RALLYE_DEACTIVATE_NOW;
+ $content['active_title'] = getMessage('RALLYE_DEACTIVATE_NOW');
$content['active'] = 0;
break;
case "N":
- $content['active_title'] = RALLYE_ACTIVATE_NOW;
+ $content['active_title'] = getMessage('RALLYE_ACTIVATE_NOW');
$content['active'] = "1";
break;
}
switch ($notify)
{
case "Y":
- $content['notify_title'] = RALLYE_STOP_NOTIFY_NOW;
+ $content['notify_title'] = getMessage('RALLYE_STOP_NOTIFY_NOW');
$content['notify'] = 0;
break;
case "N":
- $content['notify_title'] = RALLYE_START_NOTIFY_NOW;
+ $content['notify_title'] = getMessage('RALLYE_START_NOTIFY_NOW');
$content['notify'] = "1";
break;
}
switch ($auto_add)
{
case "Y":
- $content['auto_title'] = RALLYE_STOP_AUTO_ADD_NOW;
+ $content['auto_title'] = getMessage('RALLYE_STOP_AUTO_ADD_NOW');
$content['auto'] = 0;
break;
case "N":
- $content['auto_title'] = RALLYE_START_AUTO_ADD_NOW;
+ $content['auto_title'] = getMessage('RALLYE_START_AUTO_ADD_NOW');
$content['auto'] = "1";
break;
}
LOAD_TEMPLATE("admin_list_rallyes");
} else {
// No rallyes setup so far
- LOAD_TEMPLATE("admin_settings_saved", false, RALLYE_NO_RALLYES_SETUP);
+ LOAD_TEMPLATE("admin_settings_saved", false, getMessage('RALLYE_NO_RALLYES_SETUP'));
}
}
// Save settings
if (COUNT_SQLS() > 0) {
// Run all queries
- RUN_FILTER('run_sqls', array('dry_run' => false));
+ runFilterChain('run_sqls');
$content = "<span class=\"admin_failed\">".SETTINGS_SAVED."</span>";
} else {
// Nothing has changed!
$result = SQL_QUERY($sql, __FILE__, __LINE__);
// Rebuild cache
- REBUILD_CACHE("themes", "them");
+ rebuildCacheFiles("themes", "them");
} // END - if
}
array(REQUEST_POST('theme'), $THEME_VERSION, $THEME_NAME), __FILE__, __LINE__);
// Destroy cache
- REBUILD_CACHE("themes", "them");
+ rebuildCacheFiles("themes", "them");
// Prepare message
$msg = ADMIN_THEME_IMPORTED_1.REQUEST_POST('theme').ADMIN_THEME_IMPORTED_2;
// Does he have selected at least one sponsor?
if (SELECTION_COUNT(REQUEST_POST('id')) > 0) {
// At least one entry selected
- foreach (REQUEST_POST('id') as $id => $sel) {
+ foreach (REQUEST_POST('id') as $id => $selected) {
// Secure ID number
$id = bigintval($id);
LOAD_TEMPLATE("online_now");
// Add more links in this block
-RUN_FILTER('online_extra_links');
+runFilterChain('online_extra_links');
//
?>
$lockedUsers = GET_TOTAL_DATA("LOCKED", "user_data", "userid", "status", true);
// Generate hash which will be inserted into confirmation mail
- $hash = generateHash(sha1($confirmedUsers.":".$unconfirmedUsers.":".$lockedUsers.":".REQUEST_POST('month')."-".REQUEST_POST('day')."-".REQUEST_POST('year').":".getenv('SERVER_NAME').":".GET_REMOTE_ADDR().":".GET_USER_AGENT()."/".SITE_KEY."/".DATE_KEY."/".RAND_NUMBER));
+ $hash = generateHash(sha1($confirmedUsers.":".$unconfirmedUsers.":".$lockedUsers.":".REQUEST_POST('month')."-".REQUEST_POST('day')."-".REQUEST_POST('year').":".getenv('SERVER_NAME').":".GET_REMOTE_ADDR().":".GET_USER_AGENT()."/".constant('SITE_KEY')."/".constant('DATE_KEY')."/".constant('RAND_NUMBER')));
// Add design when extension sql_patches is v0.2.7 or greater
$ADD1 = ""; $ADD2 = "";
$rdf = new fase4_rdf();
$rdf->use_dynamic_display(false);
$rdf->set_CacheDir(constant('PATH')."inc/cache/");
-$rdf->set_salt(md5(SITE_KEY));
+$rdf->set_salt(md5(constant('SITE_KEY')));
$rdf->set_max_item(10);
$rdf->set_Options(
array(
// Add new transfer
if (getConfig('transfer_code') > 0) {
// Check for code
- $code = GEN_RANDOM_CODE(getConfig('transfer_code'), REQUEST_POST('code_chk'), $GLOBALS['userid'], constant('__TRANSFER_MAX_VALUE'));
+ $code = generateRandomCodde(getConfig('transfer_code'), REQUEST_POST('code_chk'), $GLOBALS['userid'], constant('__TRANSFER_MAX_VALUE'));
$valid_code = ($code == REQUEST_POST('code'));
} else {
// Zero length (= disabled) is always valid!
define('__TRANSFER_EXPIRES', CREATE_FANCY_TIME(getConfig('transfer_age')));
// Generate tranafer id
- define('__TRANS_ID', bigintval(GEN_RANDOM_CODE("10", mt_rand(0, 99999), $GLOBALS['userid'], REQUEST_POST('reason'))));
+ define('__TRANS_ID', bigintval(generateRandomCodde("10", mt_rand(0, 99999), $GLOBALS['userid'], REQUEST_POST('reason'))));
// Add entries to both tables
SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_user_transfers_in` (userid, from_uid, points, reason, time_trans, trans_id) VALUES ('%s','%s','%s','%s', UNIX_TIMESTAMP(),'%s')",
// Generate Code
if (getConfig('transfer_code') > 0) {
$rand = mt_rand(0, 99999);
- $code = GEN_RANDOM_CODE(getConfig('transfer_code'), $rand, $GLOBALS['userid'], constant('__TRANSFER_MAX_VALUE'));
+ $code = generateRandomCodde(getConfig('transfer_code'), $rand, $GLOBALS['userid'], constant('__TRANSFER_MAX_VALUE'));
$img = GENERATE_IMAGE($code, false);
define('__TRANSFER_IMAGE_INPUT', "<input type=\"hidden\" name=\"code_chk\" value=\"".$rand."\" /><input type=\"text\" name=\"code\" class=\"member_normal\" size=\"5\" maxlength=\"7\"{!__TRANSFER_TO_DISABLED!} /> ".$img);
} else {
unset($MySQL);
// Load configuration stuff
- mergeConfig(LOAD_CONFIG());
+ loadConfiguration();
// Load "databases" aka static arrays
LOAD_INC_ONCE("inc/databases.php");
}
// Run the init filter chain
- RUN_FILTER('init');
+ runFilterChain('init');
// Set default 'what' value
//* DEBUG: */ OUTPUT_HTML("-".$GLOBALS['module']."/".$GLOBALS['what']."-<br />");
// Load all active extension including language files when not upgrading.
// Check module for testing and count one click
- $dummy = CHECK_MODULE($GLOBALS['module']);
- if ($dummy == "done") COUNT_MODULE($GLOBALS['module']);
+ $dummy = checkModulePermissions($GLOBALS['module']);
+ if ($dummy == "done") countModuleHit($GLOBALS['module']);
unset($dummy);
// Shall we activate the exchange?
if (GET_EXT_VERSION("sql_patches") >= "0.3.6") {
// Generate random number
if (isset($GLOBALS['userid'])) {
- define('RAND_NUMBER', GEN_RANDOM_CODE(10, mt_rand(10000,32766), $GLOBALS['userid'], ""));
+ define('RAND_NUMBER', generateRandomCodde(10, mt_rand(10000,32766), $GLOBALS['userid'], ""));
} else {
- define('RAND_NUMBER', GEN_RANDOM_CODE(10, mt_rand(10000,32766), 0, ""));
+ define('RAND_NUMBER', generateRandomCodde(10, mt_rand(10000,32766), 0, ""));
}
} else {
// Generate weak (!!!) code
} // END - if
// Run the init filter chain
- RUN_FILTER('init');
+ runFilterChain('init');
}
if ((getTotalFatalErrors() > 0) && (isInstalled()) && (!defined('mxchange_installing')) && ($GLOBALS['output_mode'] != "1")) {
$name = sprintf("%s (%s)", getMessage('LANG_UNKNOWN_MODULE'), $mod);
if (SQL_NUMROWS($result) == 0) {
// Add module to database
- $dummy = CHECK_MODULE($mod);
+ $dummy = checkModulePermissions($mod);
} // END - if
} // END - if
}
// Check validity of a given module name (no file extension)
-function CHECK_MODULE ($mod) {
+function checkModulePermissions ($mod) {
// Filter module name (names with low chars and underlines are fine!)
$mod = preg_replace("/[^a-z_]/", "", $mod);
} // END - if
// Destroy cache here
- REBUILD_CACHE("mod_reg", "modreg");
+ rebuildCacheFiles("modreg", "modreg");
// And reload data
- $ret = CHECK_MODULE($mod_chk);
+ $ret = checkModulePermissions($mod_chk);
} else {
// Module not found we don't add it to the database
$ret = "404";
$GLOBALS['nav_depth'] = "0";
// Run the filter chain
- $ret = RUN_FILTER('post_youhere_line', array('access_level' => $ACC_LVL, 'type' => $type, 'content' => ""));
+ $ret = runFilterChain('post_youhere_line', array('access_level' => $ACC_LVL, 'type' => $type, 'content' => ""));
$OUT .= $ret['content'];
} // END - if
}
}
// Update module counter
-function COUNT_MODULE($mod) {
+function countModuleHit($mod) {
if ($mod != "css") {
// Do count all other modules but not accesses on CSS file css.php!
SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_mod_reg` SET clicks=clicks+1 WHERE module='%s' LIMIT 1",
} elseif ((($ref == $uid) || ($ref == 0)) && (GET_EXT_VERSION("cache") >= "0.1.2")) {
// Remove cache here
//* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):ref={$ref} - CACHE!<br />\n";
- REBUILD_CACHE("refsystem", "refsystem");
+ rebuildCacheFiles("refsystem", "refsystem");
}
// "Walk" back here
));
// Run SQLs
- RUN_FILTER('run_sqls', array('dry_run' => false));
+ runFilterChain('run_sqls');
- // Rebuild cache
- REBUILD_CACHE("config", "config");
+ // Rebuild caches
+ rebuildCacheFiles("config", "config");
+ rebuildCacheFiles("modreg", "modreg");
} // END - if
}
//
function IS_DEMO () {
return ((EXT_IS_ACTIVE("demo")) && (get_session('admin_login') == "demo"));
}
-//
-function LOAD_CONFIG ($no="0") {
- $CFG_DUMMY = array();
-
- // Check for cache extension, cache-array and if the requested configuration is in cache
- if ((is_array($GLOBALS['cache_array'])) && (isset($GLOBALS['cache_array']['config'][$no])) && (is_array($GLOBALS['cache_array']['config'][$no]))) {
- // Load config from cache
- //* DEBUG: */ echo gettype($GLOBALS['cache_array']['config'][$no])."<br />\n";
- foreach ($GLOBALS['cache_array']['config'][$no] as $key => $value) {
- $CFG_DUMMY[$key] = $value;
- } // END - foreach
-
- // Count cache hits if exists
- if ((isset($CFG_DUMMY['cache_hits'])) && (EXT_IS_ACTIVE("cache"))) {
- $CFG_DUMMY['cache_hits']++;
- } // END - if
- } elseif ((!EXT_IS_ACTIVE("cache")) || (!isset($GLOBALS['cache_array']['config'][$no]))) {
- // Load config from DB
- $result_config = SQL_QUERY_ESC("SELECT * FROM `{!_MYSQL_PREFIX!}_config` WHERE config=%d LIMIT 1",
- array(bigintval($no)), __FUNCTION__, __LINE__);
-
- // Get config from database
- $CFG_DUMMY = SQL_FETCHARRAY($result_config);
- // Free result
- SQL_FREERESULT($result_config);
-
- // Remember this config in the array
- $GLOBALS['cache_array']['config'][$no] = $CFG_DUMMY;
- }
-
- // Return config array
- return $CFG_DUMMY;
-}
// Gets the matching what name from module
function GET_WHAT ($modCheck) {
// Is the request element set?
//* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):entries={$entries},affectedRows={$affectedRows}<br />\n";
// Rebuild cache
- REBUILD_CACHE("config", "config");
+ rebuildCacheFiles("config", "config");
}
// Prepares an SQL statement part for HTML mail and/or holiday depency
$INC_POOL = GET_DIR_AS_ARRAY("inc/pool/", "pool-");
// Run the filter
-RUN_FILTER('load_includes', $INC_POOL);
+runFilterChain('load_includes', $INC_POOL);
// Remove counter again
unset($GLOBALS['pool_cnt']);
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('login',NULL,'Willkommen','Eingangsseite zum Admin-Bereich',0);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('logout',NULL,'Ausloggen','Ausloggen aus dem Admin-Bereich. Dadurch wird Ihre Session gelöscht und Sie müssen sich erneut anmelden.',999);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu',NULL,'Menü-System','Alle drei Menü-System bearbeiten (Admin-, Mitglied- und Gast-Menü)',1);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','adminedit','Vom Admin editieren','Das Administrationsmenü mit neuen Menüs erweitern, bestehende ändern oder löschen. <STRONG>Vorsicht!</STRONG> Löschen Sie nicht das Login-Menü!',2);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email',NULL,'Email-Management','Gebuchte Mails umleiten, Details zu den Buchungen anzeigen, Emails freigeben, registrierte Email-Adress auf Verfügbarkeit testen (Mass-Mailing!), Newsletter versenden, Email-Adressen sperren (Email-Backlist), gebuchte URLs sperren (URL-Blacklist)',4);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup',NULL,'Einstellungen','Interessen ändern, News schreiben, allgmeine Einstellungen (Auto-Versand usw.). Auto-Lock Funktion einrichten, manueller Lock des Versandes einrichten, Teile der Homepage sperren (wegen Wartungsarbeiten)',5);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('misc',NULL,'Verschiedenes','Verschiedene Einstellungen / Info-Seiten, die sonst nirgenswo reinpassten...',6);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','admin_add','Admin-Menü hinzufügen','Weiteren Menüpunkt zum Admin-Bereich hinzufügen',3);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','guest_add','Gäste-Menü hinzufügen','Fügen Sie weitere Menüpunkte dem Gäste-Menü hinzu.',5);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','memedit','Mitgliedsmenü editieren','Mitgliedsmenü editieren oder löschen',6);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','guestedit','Gäste-Menü editieren','Gäste-Menü editieren, löschen',4);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','mem_add','Mitgliedsmenü hinzufügen','Weiteren Menüpunkt zum Mitgliedsmenü hinzufügen',7);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','newsletter','Newsletter versenden','Text- oder HTML-Newsletter verschicken.',5);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','email_stats','Email-Statistiken','Schauen Sie sich detailierte Statistiken zu den bereits versanden Mails an.',5);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','edit_emails','Email-Daten ändern','Hier können Sie u.a. die gebuchte URL der Emails umändern, usw.',5);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','unlock_emails','Emails freigeben','Geben Sie bei manuellem Versand gebuchte Mails hier frei.',5);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','email_details','Email-Details ansehen','Sehen Sie sich jedes Details bereits gebuchter Mails an.',5);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_secure','Sicherheitseinstellungen','Stellen Sie ein, wie lange das Passwort eines Mitgliedes mindestens sein muss uvm.',9);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_email','Versand, Empfang','Hier können Sie die maximal empfangbaren Mails usw. einstellen.',8);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_cats','Kategorien einrichten','Ändern oder löschen Sie bereits bestehende Kategorien oder fügen Sie weitere hinzu.',7);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_points','{!POINTS!}','Stellen Sie hier die Willkommensgutschrift, Referal-Gutschrift (einmalige) usw. ein.',10);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_reg','Anmeldeformular','Stellen Sie ein, wie viel Kategorien der Gast bei der Anmeldung mindestens einstellen muss. Diese Einstellung gilt nachher auch im Mitgliedsbereich!',8);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('stats',NULL,'Statistiken','Sonstige Statistiken, die nirgenswo reinpassen',6);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','refbanner','Referal-Banner','Fügen Sie neue Banner hinzu, die dann die Mitglieder verlinken können, um neue Mitglieder zu werben. Oder editieren / löschen Sie bestehende. Hier sehen Sie auch die Anzahl der Klicks auf den jeweiligen Banner!',12);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','payments','{!POINTS!}-Vergütungen','Fügen Sie neue {!POINTS!}-Vergütungen hinzu oder ändern / löschen Sie bestende.',11);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('login',NULL,'Willkommen','Eingangsseite zum Admin-Bereich',0);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('logout',NULL,'Ausloggen','Ausloggen aus dem Admin-Bereich. Dadurch wird Ihre Session gelöscht und Sie müssen sich erneut anmelden.',999);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu',NULL,'Menü-System','Alle drei Menü-System bearbeiten (Admin-, Mitglied- und Gast-Menü)',1);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','adminedit','Vom Admin editieren','Das Administrationsmenü mit neuen Menüs erweitern, bestehende ändern oder löschen. <STRONG>Vorsicht!</STRONG> Löschen Sie nicht das Login-Menü!',2);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email',NULL,'Email-Management','Gebuchte Mails umleiten, Details zu den Buchungen anzeigen, Emails freigeben, registrierte Email-Adress auf Verfügbarkeit testen (Mass-Mailing!), Newsletter versenden, Email-Adressen sperren (Email-Backlist), gebuchte URLs sperren (URL-Blacklist)',4);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup',NULL,'Einstellungen','Interessen ändern, News schreiben, allgmeine Einstellungen (Auto-Versand usw.). Auto-Lock Funktion einrichten, manueller Lock des Versandes einrichten, Teile der Homepage sperren (wegen Wartungsarbeiten)',5);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('misc',NULL,'Verschiedenes','Verschiedene Einstellungen / Info-Seiten, die sonst nirgenswo reinpassten...',6);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','admin_add','Admin-Menü hinzufügen','Weiteren Menüpunkt zum Admin-Bereich hinzufügen',3);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','guest_add','Gäste-Menü hinzufügen','Fügen Sie weitere Menüpunkte dem Gäste-Menü hinzu.',5);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','memedit','Mitgliedsmenü editieren','Mitgliedsmenü editieren oder löschen',6);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','guestedit','Gäste-Menü editieren','Gäste-Menü editieren, löschen',4);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','mem_add','Mitgliedsmenü hinzufügen','Weiteren Menüpunkt zum Mitgliedsmenü hinzufügen',7);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','newsletter','Newsletter versenden','Text- oder HTML-Newsletter verschicken.',5);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','email_stats','Email-Statistiken','Schauen Sie sich detailierte Statistiken zu den bereits versanden Mails an.',5);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','edit_emails','Email-Daten ändern','Hier können Sie u.a. die gebuchte URL der Emails umändern, usw.',5);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','unlock_emails','Emails freigeben','Geben Sie bei manuellem Versand gebuchte Mails hier frei.',5);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','email_details','Email-Details ansehen','Sehen Sie sich jedes Details bereits gebuchter Mails an.',5);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_secure','Sicherheitseinstellungen','Stellen Sie ein, wie lange das Passwort eines Mitgliedes mindestens sein muss uvm.',9);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_email','Versand, Empfang','Hier können Sie die maximal empfangbaren Mails usw. einstellen.',8);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_cats','Kategorien einrichten','Ändern oder löschen Sie bereits bestehende Kategorien oder fügen Sie weitere hinzu.',7);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_points','{!POINTS!}','Stellen Sie hier die Willkommensgutschrift, Referal-Gutschrift (einmalige) usw. ein.',10);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_reg','Anmeldeformular','Stellen Sie ein, wie viel Kategorien der Gast bei der Anmeldung mindestens einstellen muss. Diese Einstellung gilt nachher auch im Mitgliedsbereich!',8);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('stats',NULL,'Statistiken','Sonstige Statistiken, die nirgenswo reinpassen',6);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','refbanner','Referal-Banner','Fügen Sie neue Banner hinzu, die dann die Mitglieder verlinken können, um neue Mitglieder zu werben. Oder editieren / löschen Sie bestehende. Hier sehen Sie auch die Anzahl der Klicks auf den jeweiligen Banner!',12);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','payments','{!POINTS!}-Vergütungen','Fügen Sie neue {!POINTS!}-Vergütungen hinzu oder ändern / löschen Sie bestende.',11);\r
\r
-INSERT INTO `mxchange_cats` VALUES (1,'Mix / Alles Senden --> keine Erotik!','Y',0);\r
-INSERT INTO `mxchange_cats` VALUES (2,'Mix / Alles Senden --> ohne PopUps, keine Erotik','Y',1);\r
-INSERT INTO `mxchange_cats` VALUES (3,'Traffic, Reflinks, Kostenloses, KEIN MLM!','Y',2);\r
-INSERT INTO `mxchange_cats` VALUES (4,'Geldverdienen, Beruf, Arbeit, KEIN MLM!','Y',3);\r
-INSERT INTO `mxchange_cats` VALUES (5,'Download, PC- Software, HP-Design','Y',4);\r
-INSERT INTO `mxchange_cats` VALUES (6,'Investment, Banken, Börse, Versicherungen, KEIN MLM','Y',5);\r
-INSERT INTO `mxchange_cats` VALUES (7,'Politik, Wissenschaft','Y',6);\r
-INSERT INTO `mxchange_cats` VALUES (8,'Handy, SMS, ISDN, DSL,','Y',7);\r
-INSERT INTO `mxchange_cats` VALUES (9,'Elektronik, Technik, Server, PC-Hardware, Hosting','Y',8);\r
-INSERT INTO `mxchange_cats` VALUES (10,'Auto, Motorrad','Y',9);\r
-INSERT INTO `mxchange_cats` VALUES (11,'Reise,Touristik','Y',10);\r
-INSERT INTO `mxchange_cats` VALUES (12,'Kunst, Kultur, Bildung','Y',11);\r
-INSERT INTO `mxchange_cats` VALUES (13,'Gesundheit, Fitness, Sport, KEIN MLM!','Y',12);\r
-INSERT INTO `mxchange_cats` VALUES (14,'Lifestyle, Mode, Kosmetik, KEIN MLM!','Y',13);\r
-INSERT INTO `mxchange_cats` VALUES (15,'Auktionen, Shopping, Verkauf, KEIN MLM!','Y',14);\r
-INSERT INTO `mxchange_cats` VALUES (16,'Medien, Musik, Film, TV, Video & DVD','Y',15);\r
-INSERT INTO `mxchange_cats` VALUES (17,'Singles, Flirten, Partnerschaft','Y',16);\r
-INSERT INTO `mxchange_cats` VALUES (18,'Gewinnspiele, Wetten, Lotto, KEIN MLM!','Y',17);\r
-INSERT INTO `mxchange_cats` VALUES (19,'Haus, Garten, Freizeit, Hobbys','Y',18);\r
-INSERT INTO `mxchange_cats` VALUES (20,'Erotik --> Keine Hardcore !','Y',19);\r
-INSERT INTO `mxchange_cats` VALUES (21,'Multi Level Marketing (alle Arten)','Y',20);\r
-INSERT INTO `mxchange_cats` VALUES (22,'Klammlose-Seiten','Y',21);\r
+INSERT INTO `{!prefix!}_cats` VALUES (1,'Mix / Alles Senden --> keine Erotik!','Y',0);\r
+INSERT INTO `{!prefix!}_cats` VALUES (2,'Mix / Alles Senden --> ohne PopUps, keine Erotik','Y',1);\r
+INSERT INTO `{!prefix!}_cats` VALUES (3,'Traffic, Reflinks, Kostenloses, KEIN MLM!','Y',2);\r
+INSERT INTO `{!prefix!}_cats` VALUES (4,'Geldverdienen, Beruf, Arbeit, KEIN MLM!','Y',3);\r
+INSERT INTO `{!prefix!}_cats` VALUES (5,'Download, PC- Software, HP-Design','Y',4);\r
+INSERT INTO `{!prefix!}_cats` VALUES (6,'Investment, Banken, Börse, Versicherungen, KEIN MLM','Y',5);\r
+INSERT INTO `{!prefix!}_cats` VALUES (7,'Politik, Wissenschaft','Y',6);\r
+INSERT INTO `{!prefix!}_cats` VALUES (8,'Handy, SMS, ISDN, DSL,','Y',7);\r
+INSERT INTO `{!prefix!}_cats` VALUES (9,'Elektronik, Technik, Server, PC-Hardware, Hosting','Y',8);\r
+INSERT INTO `{!prefix!}_cats` VALUES (10,'Auto, Motorrad','Y',9);\r
+INSERT INTO `{!prefix!}_cats` VALUES (11,'Reise,Touristik','Y',10);\r
+INSERT INTO `{!prefix!}_cats` VALUES (12,'Kunst, Kultur, Bildung','Y',11);\r
+INSERT INTO `{!prefix!}_cats` VALUES (13,'Gesundheit, Fitness, Sport, KEIN MLM!','Y',12);\r
+INSERT INTO `{!prefix!}_cats` VALUES (14,'Lifestyle, Mode, Kosmetik, KEIN MLM!','Y',13);\r
+INSERT INTO `{!prefix!}_cats` VALUES (15,'Auktionen, Shopping, Verkauf, KEIN MLM!','Y',14);\r
+INSERT INTO `{!prefix!}_cats` VALUES (16,'Medien, Musik, Film, TV, Video & DVD','Y',15);\r
+INSERT INTO `{!prefix!}_cats` VALUES (17,'Singles, Flirten, Partnerschaft','Y',16);\r
+INSERT INTO `{!prefix!}_cats` VALUES (18,'Gewinnspiele, Wetten, Lotto, KEIN MLM!','Y',17);\r
+INSERT INTO `{!prefix!}_cats` VALUES (19,'Haus, Garten, Freizeit, Hobbys','Y',18);\r
+INSERT INTO `{!prefix!}_cats` VALUES (20,'Erotik --> Keine Hardcore !','Y',19);\r
+INSERT INTO `{!prefix!}_cats` VALUES (21,'Multi Level Marketing (alle Arten)','Y',20);\r
+INSERT INTO `{!prefix!}_cats` VALUES (22,'Klammlose-Seiten','Y',21);\r
\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','welcome','Willkommen',1,'Y','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main',NULL,'Hauptmenü',0,'Y','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members','register','Anmeldung',2,'Y','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members','confirm','Bestätigungslink',3,'Y','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members',NULL,'Mitglieder',1,'Y','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members','login','Einloggen',3,'Y','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','impressum','Impressum',5,'Y','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','agb','AGBs',4,'Y','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','infos','Infos',2,'Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','welcome','Willkommen',1,'Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main',NULL,'Hauptmenü',0,'Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members','register','Anmeldung',2,'Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members','confirm','Bestätigungslink',3,'Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members',NULL,'Mitglieder',1,'Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members','login','Einloggen',3,'Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','impressum','Impressum',5,'Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','agb','AGBs',4,'Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','infos','Infos',2,'Y','N');\r
\r
-INSERT INTO `mxchange_max_receive` VALUES (1,0,'Urlaub');\r
-INSERT INTO `mxchange_max_receive` VALUES (2,50,'Bonus möglich!');\r
-INSERT INTO `mxchange_max_receive` VALUES (3,90,'Bonus möglich!');\r
-INSERT INTO `mxchange_max_receive` VALUES (4,5,'');\r
-INSERT INTO `mxchange_max_receive` VALUES (5,10,'');\r
-INSERT INTO `mxchange_max_receive` VALUES (6,15,'');\r
-INSERT INTO `mxchange_max_receive` VALUES (7,20,'');\r
-INSERT INTO `mxchange_max_receive` VALUES (8,25,'');\r
-INSERT INTO `mxchange_max_receive` VALUES (9,30,'');\r
-INSERT INTO `mxchange_max_receive` VALUES (10,35,'');\r
-INSERT INTO `mxchange_max_receive` VALUES (11,40,'');\r
-INSERT INTO `mxchange_max_receive` VALUES (12,45,'');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (1,0,'Urlaub');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (2,50,'Bonus möglich!');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (3,90,'Bonus möglich!');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (4,5,'');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (5,10,'');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (6,15,'');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (7,20,'');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (8,25,'');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (9,30,'');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (10,35,'');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (11,40,'');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (12,45,'');\r
\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main',NULL,'Mitgliedsmenü',0,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','welcome','Willkommen!',1,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('logout','logout','Ausloggen',999,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','mydata','Profildaten ändern',2,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('logout',NULL,'Ausloggen',1,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','points','{!POINTS!}-Guthaben',4,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','categories','Kategorien auswählen',3,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','reflinks','Referal-Links',6,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','order','Mailbuchung',8,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','unconfirmed','Unbestätigte Emails',5,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('main','stats','Statistiken', 'Y','N',9);\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('main','support','Support ','Y','N',10);\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('logout','guest','Zum Gastmenü','Y','N',1000);\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main',NULL,'Mitgliedsmenü',0,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','welcome','Willkommen!',1,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('logout','logout','Ausloggen',999,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','mydata','Profildaten ändern',2,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('logout',NULL,'Ausloggen',1,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','points','{!POINTS!}-Guthaben',4,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','categories','Kategorien auswählen',3,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','reflinks','Referal-Links',6,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','order','Mailbuchung',8,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','unconfirmed','Unbestätigte Emails',5,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('main','stats','Statistiken', 'Y','N',9);\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('main','support','Support ','Y','N',10);\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('logout','guest','Zum Gastmenü','Y','N',1000);\r
\r
-INSERT INTO `mxchange_payments` VALUES (1,10,2.000,'Klick-Mail 10 Sek.',1.000);\r
-INSERT INTO `mxchange_payments` VALUES (2,20,10.000,'Klick-Mail 20 Sek.',9.000);\r
-INSERT INTO `mxchange_payments` VALUES (3,30,30.000,'Klick-Mail 30 Sek.',29.000);\r
-INSERT INTO `mxchange_payments` VALUES (4,40,40.000,'Klick-Mail 40 Sek.',39.000);\r
-INSERT INTO `mxchange_payments` VALUES (5,50,50.000,'Klick-Mail 50 Sek.',49.000);\r
+INSERT INTO `{!prefix!}_payments` VALUES (1,10,2.000,'Klick-Mail 10 Sek.',1.000);\r
+INSERT INTO `{!prefix!}_payments` VALUES (2,20,10.000,'Klick-Mail 20 Sek.',9.000);\r
+INSERT INTO `{!prefix!}_payments` VALUES (3,30,30.000,'Klick-Mail 30 Sek.',29.000);\r
+INSERT INTO `{!prefix!}_payments` VALUES (4,40,40.000,'Klick-Mail 40 Sek.',39.000);\r
+INSERT INTO `{!prefix!}_payments` VALUES (5,50,50.000,'Klick-Mail 50 Sek.',49.000);\r
\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','email_archiv','E-Mail Archiv','Sehen Sie sich hier bereits gesendete Mails an.','6');\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','del_email','E-Mail löschen','Löschen Sie hierrüber E-Mails (sowohl Bonus- als auch Normal-Mails) aus Ihrem Mailtausch-System. <STRONG>Nur bei Normal-Mails:</STRONG> {!POINTS!} aus den unbestätigten Mails werden dem Werber wieder vergütet.','7');\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('misc','updates','Updates prüfen','Prüft, ob eine neue Version oder ein Patch auf dem Server exisitiert. Sie müssen dann die Patches/Updates selber herunterladen und einspielen. Dabei werden keine Daten von Ihrer Installation an uns gesendet!','8');\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('misc','extensions','Erweiterungen','Erweiterungen installieren, updaten, sperren, löschen usw.','8');\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','email_archiv','E-Mail Archiv','Sehen Sie sich hier bereits gesendete Mails an.','6');\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','del_email','E-Mail löschen','Löschen Sie hierrüber E-Mails (sowohl Bonus- als auch Normal-Mails) aus Ihrem Mailtausch-System. <STRONG>Nur bei Normal-Mails:</STRONG> {!POINTS!} aus den unbestätigten Mails werden dem Werber wieder vergütet.','7');\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('misc','updates','Updates prüfen','Prüft, ob eine neue Version oder ein Patch auf dem Server exisitiert. Sie müssen dann die Patches/Updates selber herunterladen und einspielen. Dabei werden keine Daten von Ihrer Installation an uns gesendet!','8');\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('misc','extensions','Erweiterungen','Erweiterungen installieren, updaten, sperren, löschen usw.','8');\r
\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','stats','Statistiken','7','Y','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('admin',NULL,'Administrative Links','3','N','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('admin','admin','Zum Admin-Bereich','4','N','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','stats','Statistiken','7','Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('admin',NULL,'Administrative Links','3','N','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('admin','admin','Zum Admin-Bereich','4','N','N');\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('login',NULL,'Willkommen','Eingangsseite zum Admin-Bereich',0);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('logout',NULL,'Ausloggen','Ausloggen aus dem Admin-Bereich. Dadurch wird Ihre Session gelöscht und Sie müssen sich erneut anmelden.',999);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu',NULL,'Menü-System','Alle drei Menü-System bearbeiten (Admin-, Mitglied- und Gast-Menü)',1);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','adminedit','Vom Admin editieren','Das Administrationsmenü mit neuen Menüs erweitern, bestehende ändern oder löschen. <STRONG>Vorsicht!</STRONG> Löschen Sie nicht das Login-Menü!',2);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email',NULL,'Email-Management','Gebuchte Mails umleiten, Details zu den Buchungen anzeigen, Emails freigeben, registrierte Email-Adress auf Verfügbarkeit testen (Mass-Mailing!), Newsletter versenden, Email-Adressen sperren (Email-Backlist), gebuchte URLs sperren (URL-Blacklist)',4);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup',NULL,'Einstellungen','Interessen ändern, News schreiben, allgmeine Einstellungen (Auto-Versand usw.). Auto-Lock Funktion einrichten, manueller Lock des Versandes einrichten, Teile der Homepage sperren (wegen Wartungsarbeiten)',5);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('misc',NULL,'Verschiedenes','Verschiedene Einstellungen / Info-Seiten, die sonst nirgenswo reinpassten...',6);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','admin_add','Admin-Menü hinzufügen','Weiteren Menüpunkt zum Admin-Bereich hinzufügen',3);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','guest_add','Gäste-Menü hinzufügen','Fügen Sie weitere Menüpunkte dem Gäste-Menü hinzu.',5);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','memedit','Mitgliedsmenü editieren','Mitgliedsmenü editieren oder löschen',6);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','guestedit','Gäste-Menü editieren','Gäste-Menü editieren, löschen',4);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','mem_add','Mitgliedsmenü hinzufügen','Weiteren Menüpunkt zum Mitgliedsmenü hinzufügen',7);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','newsletter','Newsletter versenden','Text- oder HTML-Newsletter verschicken.',5);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','email_stats','Email-Statistiken','Schauen Sie sich detailierte Statistiken zu den bereits versanden Mails an.',5);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','edit_emails','Email-Daten ändern','Hier können Sie u.a. die gebuchte URL der Emails umändern, usw.',5);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','unlock_emails','Emails freigeben','Geben Sie bei manuellem Versand gebuchte Mails hier frei.',5);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','email_details','Email-Details ansehen','Sehen Sie sich jedes Details bereits gebuchter Mails an.',5);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_secure','Sicherheitseinstellungen','Stellen Sie ein, wie lange das Passwort eines Mitgliedes mindestens sein muss uvm.',9);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_email','Versand, Empfang','Hier können Sie die maximal empfangbaren Mails usw. einstellen.',8);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_cats','Kategorien einrichten','Ändern oder löschen Sie bereits bestehende Kategorien oder fügen Sie weitere hinzu.',7);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_points','{!POINTS!}','Stellen Sie hier die Willkommensgutschrift, Referal-Gutschrift (einmalige) usw. ein.',10);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_reg','Anmeldeformular','Stellen Sie ein, wie viel Kategorien der Gast bei der Anmeldung mindestens einstellen muss. Diese Einstellung gilt nachher auch im Mitgliedsbereich!',8);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('stats',NULL,'Statistiken','Sonstige Statistiken, die nirgenswo reinpassen',6);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','refbanner','Referal-Banner','Fügen Sie neue Banner hinzu, die dann die Mitglieder verlinken können, um neue Mitglieder zu werben. Oder editieren / löschen Sie bestehende. Hier sehen Sie auch die Anzahl der Klicks auf den jeweiligen Banner!',12);\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','payments','{!POINTS!}-Vergütungen','Fügen Sie neue {!POINTS!}-Vergütungen hinzu oder ändern / löschen Sie bestende.',11);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('login',NULL,'Willkommen','Eingangsseite zum Admin-Bereich',0);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('logout',NULL,'Ausloggen','Ausloggen aus dem Admin-Bereich. Dadurch wird Ihre Session gelöscht und Sie müssen sich erneut anmelden.',999);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu',NULL,'Menü-System','Alle drei Menü-System bearbeiten (Admin-, Mitglied- und Gast-Menü)',1);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','adminedit','Vom Admin editieren','Das Administrationsmenü mit neuen Menüs erweitern, bestehende ändern oder löschen. <STRONG>Vorsicht!</STRONG> Löschen Sie nicht das Login-Menü!',2);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email',NULL,'Email-Management','Gebuchte Mails umleiten, Details zu den Buchungen anzeigen, Emails freigeben, registrierte Email-Adress auf Verfügbarkeit testen (Mass-Mailing!), Newsletter versenden, Email-Adressen sperren (Email-Backlist), gebuchte URLs sperren (URL-Blacklist)',4);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup',NULL,'Einstellungen','Interessen ändern, News schreiben, allgmeine Einstellungen (Auto-Versand usw.). Auto-Lock Funktion einrichten, manueller Lock des Versandes einrichten, Teile der Homepage sperren (wegen Wartungsarbeiten)',5);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('misc',NULL,'Verschiedenes','Verschiedene Einstellungen / Info-Seiten, die sonst nirgenswo reinpassten...',6);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','admin_add','Admin-Menü hinzufügen','Weiteren Menüpunkt zum Admin-Bereich hinzufügen',3);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','guest_add','Gäste-Menü hinzufügen','Fügen Sie weitere Menüpunkte dem Gäste-Menü hinzu.',5);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','memedit','Mitgliedsmenü editieren','Mitgliedsmenü editieren oder löschen',6);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','guestedit','Gäste-Menü editieren','Gäste-Menü editieren, löschen',4);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','mem_add','Mitgliedsmenü hinzufügen','Weiteren Menüpunkt zum Mitgliedsmenü hinzufügen',7);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','newsletter','Newsletter versenden','Text- oder HTML-Newsletter verschicken.',5);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','email_stats','Email-Statistiken','Schauen Sie sich detailierte Statistiken zu den bereits versanden Mails an.',5);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','edit_emails','Email-Daten ändern','Hier können Sie u.a. die gebuchte URL der Emails umändern, usw.',5);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','unlock_emails','Emails freigeben','Geben Sie bei manuellem Versand gebuchte Mails hier frei.',5);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','email_details','Email-Details ansehen','Sehen Sie sich jedes Details bereits gebuchter Mails an.',5);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_secure','Sicherheitseinstellungen','Stellen Sie ein, wie lange das Passwort eines Mitgliedes mindestens sein muss uvm.',9);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_email','Versand, Empfang','Hier können Sie die maximal empfangbaren Mails usw. einstellen.',8);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_cats','Kategorien einrichten','Ändern oder löschen Sie bereits bestehende Kategorien oder fügen Sie weitere hinzu.',7);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_points','{!POINTS!}','Stellen Sie hier die Willkommensgutschrift, Referal-Gutschrift (einmalige) usw. ein.',10);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_reg','Anmeldeformular','Stellen Sie ein, wie viel Kategorien der Gast bei der Anmeldung mindestens einstellen muss. Diese Einstellung gilt nachher auch im Mitgliedsbereich!',8);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('stats',NULL,'Statistiken','Sonstige Statistiken, die nirgenswo reinpassen',6);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','refbanner','Referal-Banner','Fügen Sie neue Banner hinzu, die dann die Mitglieder verlinken können, um neue Mitglieder zu werben. Oder editieren / löschen Sie bestehende. Hier sehen Sie auch die Anzahl der Klicks auf den jeweiligen Banner!',12);\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','payments','{!POINTS!}-Vergütungen','Fügen Sie neue {!POINTS!}-Vergütungen hinzu oder ändern / löschen Sie bestende.',11);\r
\r
-INSERT INTO `mxchange_cats` VALUES (1,'Mix / Alles Senden --> keine Erotik!','Y',0);\r
-INSERT INTO `mxchange_cats` VALUES (2,'Mix / Alles Senden --> ohne PopUps, keine Erotik','Y',1);\r
-INSERT INTO `mxchange_cats` VALUES (3,'Traffic, Reflinks, Kostenloses, KEIN MLM!','Y',2);\r
-INSERT INTO `mxchange_cats` VALUES (4,'Geldverdienen, Beruf, Arbeit, KEIN MLM!','Y',3);\r
-INSERT INTO `mxchange_cats` VALUES (5,'Download, PC- Software, HP-Design','Y',4);\r
-INSERT INTO `mxchange_cats` VALUES (6,'Investment, Banken, Börse, Versicherungen, KEIN MLM','Y',5);\r
-INSERT INTO `mxchange_cats` VALUES (7,'Politik, Wissenschaft','Y',6);\r
-INSERT INTO `mxchange_cats` VALUES (8,'Handy, SMS, ISDN, DSL,','Y',7);\r
-INSERT INTO `mxchange_cats` VALUES (9,'Elektronik, Technik, Server, PC-Hardware, Hosting','Y',8);\r
-INSERT INTO `mxchange_cats` VALUES (10,'Auto, Motorrad','Y',9);\r
-INSERT INTO `mxchange_cats` VALUES (11,'Reise,Touristik','Y',10);\r
-INSERT INTO `mxchange_cats` VALUES (12,'Kunst, Kultur, Bildung','Y',11);\r
-INSERT INTO `mxchange_cats` VALUES (13,'Gesundheit, Fitness, Sport, KEIN MLM!','Y',12);\r
-INSERT INTO `mxchange_cats` VALUES (14,'Lifestyle, Mode, Kosmetik, KEIN MLM!','Y',13);\r
-INSERT INTO `mxchange_cats` VALUES (15,'Auktionen, Shopping, Verkauf, KEIN MLM!','Y',14);\r
-INSERT INTO `mxchange_cats` VALUES (16,'Medien, Musik, Film, TV, Video & DVD','Y',15);\r
-INSERT INTO `mxchange_cats` VALUES (17,'Singles, Flirten, Partnerschaft','Y',16);\r
-INSERT INTO `mxchange_cats` VALUES (18,'Gewinnspiele, Wetten, Lotto, KEIN MLM!','Y',17);\r
-INSERT INTO `mxchange_cats` VALUES (19,'Haus, Garten, Freizeit, Hobbys','Y',18);\r
-INSERT INTO `mxchange_cats` VALUES (20,'Erotik --> Keine Hardcore !','Y',19);\r
-INSERT INTO `mxchange_cats` VALUES (21,'Multi Level Marketing (alle Arten)','Y',20);\r
-INSERT INTO `mxchange_cats` VALUES (22,'Klammlose-Seiten','Y',21);\r
+INSERT INTO `{!prefix!}_cats` VALUES (1,'Mix / Alles Senden --> keine Erotik!','Y',0);\r
+INSERT INTO `{!prefix!}_cats` VALUES (2,'Mix / Alles Senden --> ohne PopUps, keine Erotik','Y',1);\r
+INSERT INTO `{!prefix!}_cats` VALUES (3,'Traffic, Reflinks, Kostenloses, KEIN MLM!','Y',2);\r
+INSERT INTO `{!prefix!}_cats` VALUES (4,'Geldverdienen, Beruf, Arbeit, KEIN MLM!','Y',3);\r
+INSERT INTO `{!prefix!}_cats` VALUES (5,'Download, PC- Software, HP-Design','Y',4);\r
+INSERT INTO `{!prefix!}_cats` VALUES (6,'Investment, Banken, Börse, Versicherungen, KEIN MLM','Y',5);\r
+INSERT INTO `{!prefix!}_cats` VALUES (7,'Politik, Wissenschaft','Y',6);\r
+INSERT INTO `{!prefix!}_cats` VALUES (8,'Handy, SMS, ISDN, DSL,','Y',7);\r
+INSERT INTO `{!prefix!}_cats` VALUES (9,'Elektronik, Technik, Server, PC-Hardware, Hosting','Y',8);\r
+INSERT INTO `{!prefix!}_cats` VALUES (10,'Auto, Motorrad','Y',9);\r
+INSERT INTO `{!prefix!}_cats` VALUES (11,'Reise,Touristik','Y',10);\r
+INSERT INTO `{!prefix!}_cats` VALUES (12,'Kunst, Kultur, Bildung','Y',11);\r
+INSERT INTO `{!prefix!}_cats` VALUES (13,'Gesundheit, Fitness, Sport, KEIN MLM!','Y',12);\r
+INSERT INTO `{!prefix!}_cats` VALUES (14,'Lifestyle, Mode, Kosmetik, KEIN MLM!','Y',13);\r
+INSERT INTO `{!prefix!}_cats` VALUES (15,'Auktionen, Shopping, Verkauf, KEIN MLM!','Y',14);\r
+INSERT INTO `{!prefix!}_cats` VALUES (16,'Medien, Musik, Film, TV, Video & DVD','Y',15);\r
+INSERT INTO `{!prefix!}_cats` VALUES (17,'Singles, Flirten, Partnerschaft','Y',16);\r
+INSERT INTO `{!prefix!}_cats` VALUES (18,'Gewinnspiele, Wetten, Lotto, KEIN MLM!','Y',17);\r
+INSERT INTO `{!prefix!}_cats` VALUES (19,'Haus, Garten, Freizeit, Hobbys','Y',18);\r
+INSERT INTO `{!prefix!}_cats` VALUES (20,'Erotik --> Keine Hardcore !','Y',19);\r
+INSERT INTO `{!prefix!}_cats` VALUES (21,'Multi Level Marketing (alle Arten)','Y',20);\r
+INSERT INTO `{!prefix!}_cats` VALUES (22,'Klammlose-Seiten','Y',21);\r
\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','welcome','Willkommen',1,'Y','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main',NULL,'Hauptmenü',0,'Y','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members','register','Anmeldung',2,'Y','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members','confirm','Bestätigungslink',3,'Y','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members',NULL,'Mitglieder',1,'Y','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members','login','Einloggen',3,'Y','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','impressum','Impressum',5,'Y','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','agb','AGBs',4,'Y','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','infos','Infos',2,'Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','welcome','Willkommen',1,'Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main',NULL,'Hauptmenü',0,'Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members','register','Anmeldung',2,'Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members','confirm','Bestätigungslink',3,'Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members',NULL,'Mitglieder',1,'Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members','login','Einloggen',3,'Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','impressum','Impressum',5,'Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','agb','AGBs',4,'Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','infos','Infos',2,'Y','N');\r
\r
-INSERT INTO `mxchange_max_receive` VALUES (1,0,'Urlaub');\r
-INSERT INTO `mxchange_max_receive` VALUES (2,50,'Bonus möglich!');\r
-INSERT INTO `mxchange_max_receive` VALUES (3,90,'Bonus möglich!');\r
-INSERT INTO `mxchange_max_receive` VALUES (4,5,'');\r
-INSERT INTO `mxchange_max_receive` VALUES (5,10,'');\r
-INSERT INTO `mxchange_max_receive` VALUES (6,15,'');\r
-INSERT INTO `mxchange_max_receive` VALUES (7,20,'');\r
-INSERT INTO `mxchange_max_receive` VALUES (8,25,'');\r
-INSERT INTO `mxchange_max_receive` VALUES (9,30,'');\r
-INSERT INTO `mxchange_max_receive` VALUES (10,35,'');\r
-INSERT INTO `mxchange_max_receive` VALUES (11,40,'');\r
-INSERT INTO `mxchange_max_receive` VALUES (12,45,'');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (1,0,'Urlaub');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (2,50,'Bonus möglich!');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (3,90,'Bonus möglich!');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (4,5,'');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (5,10,'');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (6,15,'');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (7,20,'');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (8,25,'');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (9,30,'');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (10,35,'');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (11,40,'');\r
+INSERT INTO `{!prefix!}_max_receive` VALUES (12,45,'');\r
\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main',NULL,'Mitgliedsmenü',0,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','welcome','Willkommen!',1,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('logout','logout','Ausloggen',999,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','mydata','Profildaten ändern',2,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('logout',NULL,'Ausloggen',1,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','points','{!POINTS!}-Guthaben',4,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','categories','Kategorien auswählen',3,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','reflinks','Referal-Links',6,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','order','Mailbuchung',8,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','unconfirmed','Unbestätigte Emails',5,'Y','N');\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('main','stats','Statistiken', 'Y','N',9);\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('main','support','Support ','Y','N',10);\r
-INSERT INTO `mxchange_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('logout','guest','Zum Gastmenü','Y','N',1000);\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main',NULL,'Mitgliedsmenü',0,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','welcome','Willkommen!',1,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('logout','logout','Ausloggen',999,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','mydata','Profildaten ändern',2,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('logout',NULL,'Ausloggen',1,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','points','{!POINTS!}-Guthaben',4,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','categories','Kategorien auswählen',3,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','reflinks','Referal-Links',6,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','order','Mailbuchung',8,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','unconfirmed','Unbestätigte Emails',5,'Y','N');\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('main','stats','Statistiken', 'Y','N',9);\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('main','support','Support ','Y','N',10);\r
+INSERT INTO `{!prefix!}_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('logout','guest','Zum Gastmenü','Y','N',1000);\r
\r
-INSERT INTO `mxchange_payments` VALUES (1,10,2.000,'Klick-Mail 10 Sek.',1.000);\r
-INSERT INTO `mxchange_payments` VALUES (2,20,10.000,'Klick-Mail 20 Sek.',9.000);\r
-INSERT INTO `mxchange_payments` VALUES (3,30,30.000,'Klick-Mail 30 Sek.',29.000);\r
-INSERT INTO `mxchange_payments` VALUES (4,40,40.000,'Klick-Mail 40 Sek.',39.000);\r
-INSERT INTO `mxchange_payments` VALUES (5,50,50.000,'Klick-Mail 50 Sek.',49.000);\r
+INSERT INTO `{!prefix!}_payments` VALUES (1,10,2.000,'Klick-Mail 10 Sek.',1.000);\r
+INSERT INTO `{!prefix!}_payments` VALUES (2,20,10.000,'Klick-Mail 20 Sek.',9.000);\r
+INSERT INTO `{!prefix!}_payments` VALUES (3,30,30.000,'Klick-Mail 30 Sek.',29.000);\r
+INSERT INTO `{!prefix!}_payments` VALUES (4,40,40.000,'Klick-Mail 40 Sek.',39.000);\r
+INSERT INTO `{!prefix!}_payments` VALUES (5,50,50.000,'Klick-Mail 50 Sek.',49.000);\r
\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','email_archiv','E-Mail Archiv','Sehen Sie sich hier bereits gesendete Mails an.','6');\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','del_email','E-Mail löschen','Löschen Sie hierrüber E-Mails (sowohl Bonus- als auch Normal-Mails) aus Ihrem Mailtausch-System. <STRONG>Nur bei Normal-Mails:</STRONG> {!POINTS!} aus den unbestätigten Mails werden dem Werber wieder vergütet.','7');\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('misc','updates','Updates prüfen','Prüft, ob eine neue Version oder ein Patch auf dem Server exisitiert. Sie müssen dann die Patches/Updates selber herunterladen und einspielen. Dabei werden keine Daten von Ihrer Installation an uns gesendet!','8');\r
-INSERT INTO `mxchange_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('misc','extensions','Erweiterungen','Erweiterungen installieren, updaten, sperren, löschen usw.','8');\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','email_archiv','E-Mail Archiv','Sehen Sie sich hier bereits gesendete Mails an.','6');\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','del_email','E-Mail löschen','Löschen Sie hierrüber E-Mails (sowohl Bonus- als auch Normal-Mails) aus Ihrem Mailtausch-System. <STRONG>Nur bei Normal-Mails:</STRONG> {!POINTS!} aus den unbestätigten Mails werden dem Werber wieder vergütet.','7');\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('misc','updates','Updates prüfen','Prüft, ob eine neue Version oder ein Patch auf dem Server exisitiert. Sie müssen dann die Patches/Updates selber herunterladen und einspielen. Dabei werden keine Daten von Ihrer Installation an uns gesendet!','8');\r
+INSERT INTO `{!prefix!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('misc','extensions','Erweiterungen','Erweiterungen installieren, updaten, sperren, löschen usw.','8');\r
\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','stats','Statistiken','7','Y','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('admin',NULL,'Administrative Links','3','N','N');\r
-INSERT INTO `mxchange_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('admin','admin','Zum Admin-Bereich','4','N','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','stats','Statistiken','7','Y','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('admin',NULL,'Administrative Links','3','N','N');\r
+INSERT INTO `{!prefix!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('admin','admin','Zum Admin-Bereich','4','N','N');\r
-DROP TABLE IF EXISTS `mxchange_admin_menu`;\r
-CREATE TABLE `mxchange_admin_menu` (\r
+DROP TABLE IF EXISTS `{!prefix!}_admin_menu`;\r
+CREATE TABLE `{!prefix!}_admin_menu` (\r
`id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
`action` VARCHAR(255) NOT NULL DEFAULT '',\r
`what` VARCHAR(255) NULL DEFAULT NULL,\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-DROP TABLE IF EXISTS `mxchange_admins`;\r
-CREATE TABLE `mxchange_admins` (\r
+DROP TABLE IF EXISTS `{!prefix!}_admins`;\r
+CREATE TABLE `{!prefix!}_admins` (\r
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,\r
`login` VARCHAR(100) NOT NULL DEFAULT '',\r
`password` VARCHAR(40) NOT NULL DEFAULT '',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-DROP TABLE IF EXISTS `mxchange_cats`;\r
-CREATE TABLE `mxchange_cats` (\r
+DROP TABLE IF EXISTS `{!prefix!}_cats`;\r
+CREATE TABLE `{!prefix!}_cats` (\r
`id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
`cat` VARCHAR(255) NOT NULL DEFAULT '',\r
`visible` ENUM('Y','N') NOT NULL DEFAULT 'Y',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-DROP TABLE IF EXISTS `mxchange_config`;\r
-CREATE TABLE `mxchange_config` (\r
+DROP TABLE IF EXISTS `{!prefix!}_config`;\r
+CREATE TABLE `{!prefix!}_config` (\r
`config` tinyint(1) NOT NULL DEFAULT 0,\r
`pass_len` TINYINT(3) UNSIGNED NOT NULL DEFAULT 5,\r
`points_register` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,\r
PRIMARY KEY (`config`)\r
) TYPE=MyISAM;\r
\r
-INSERT INTO `mxchange_config` VALUES (0,5,2000,200,5,'Y','N','Y',86400,'Y',1000,'Y','N');\r
+INSERT INTO `{!prefix!}_config` VALUES (0,5,2000,200,5,'Y','N','Y',86400,'Y',1000,'Y','N');\r
\r
-DROP TABLE IF EXISTS `mxchange_guest_menu`;\r
-CREATE TABLE `mxchange_guest_menu` (\r
+DROP TABLE IF EXISTS `{!prefix!}_guest_menu`;\r
+CREATE TABLE `{!prefix!}_guest_menu` (\r
`id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
`action` VARCHAR(255) NOT NULL DEFAULT '',\r
`what` VARCHAR(255) NULL DEFAULT NULL,\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-DROP TABLE IF EXISTS `mxchange_max_receive`;\r
-CREATE TABLE `mxchange_max_receive` (\r
+DROP TABLE IF EXISTS `{!prefix!}_max_receive`;\r
+CREATE TABLE `{!prefix!}_max_receive` (\r
`id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
`value` MEDIUMINT(9) NOT NULL DEFAULT 0,\r
`comment` VARCHAR(255) NOT NULL DEFAULT '',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-DROP TABLE IF EXISTS `mxchange_member_menu`;\r
-CREATE TABLE `mxchange_member_menu` (\r
+DROP TABLE IF EXISTS `{!prefix!}_member_menu`;\r
+CREATE TABLE `{!prefix!}_member_menu` (\r
`id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
`action` VARCHAR(255) NOT NULL DEFAULT '',\r
`what` VARCHAR(255) NULL DEFAULT NULL,\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-DROP TABLE IF EXISTS `mxchange_mod_reg`;\r
-CREATE TABLE `mxchange_mod_reg` (\r
+DROP TABLE IF EXISTS `{!prefix!}_mod_reg`;\r
+CREATE TABLE `{!prefix!}_mod_reg` (\r
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,\r
`module` VARCHAR(50) NOT NULL DEFAULT '',\r
`locked` ENUM('Y','N') NOT NULL DEFAULT 'Y',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-INSERT INTO `mxchange_mod_reg` VALUES (1,'admin','N','N','Y','','N',0);\r
-INSERT INTO `mxchange_mod_reg` VALUES (2,'index','N','N','N','','N',0);\r
-INSERT INTO `mxchange_mod_reg` VALUES (3,'frameset','Y','N','N','','N',0);\r
-INSERT INTO `mxchange_mod_reg` VALUES (4,'login','N','N','N','','Y',0);\r
-INSERT INTO `mxchange_mod_reg` VALUES (6,'frametester','N','Y','N','','N',0);\r
-INSERT INTO `mxchange_mod_reg` VALUES (7,'loader','N','Y','N','','N',0);\r
-INSERT INTO `mxchange_mod_reg` VALUES (8,'order','N','N','N','','N',0);\r
+INSERT INTO `{!prefix!}_mod_reg` VALUES (1,'admin','N','N','Y','','N',0);\r
+INSERT INTO `{!prefix!}_mod_reg` VALUES (2,'index','N','N','N','','N',0);\r
+INSERT INTO `{!prefix!}_mod_reg` VALUES (3,'frameset','Y','N','N','','N',0);\r
+INSERT INTO `{!prefix!}_mod_reg` VALUES (4,'login','N','N','N','','Y',0);\r
+INSERT INTO `{!prefix!}_mod_reg` VALUES (6,'frametester','N','Y','N','','N',0);\r
+INSERT INTO `{!prefix!}_mod_reg` VALUES (7,'loader','N','Y','N','','N',0);\r
+INSERT INTO `{!prefix!}_mod_reg` VALUES (8,'order','N','N','N','','N',0);\r
\r
-DROP TABLE IF EXISTS `mxchange_payments`;\r
-CREATE TABLE `mxchange_payments` (\r
+DROP TABLE IF EXISTS `{!prefix!}_payments`;\r
+CREATE TABLE `{!prefix!}_payments` (\r
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,\r
`time` INT(7) NOT NULL DEFAULT 0,\r
`payment` FLOAT(5,3) UNSIGNED NOT NULL DEFAULT '0.000',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-DROP TABLE IF EXISTS `mxchange_pool`;\r
-CREATE TABLE `mxchange_pool` (\r
+DROP TABLE IF EXISTS `{!prefix!}_pool`;\r
+CREATE TABLE `{!prefix!}_pool` (\r
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,\r
`sender` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,\r
`subject` VARCHAR(200) NOT NULL DEFAULT '',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-DROP TABLE IF EXISTS `mxchange_refbanner`;\r
-CREATE TABLE `mxchange_refbanner` (\r
+DROP TABLE IF EXISTS `{!prefix!}_refbanner`;\r
+CREATE TABLE `{!prefix!}_refbanner` (\r
`id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
`url` TEXT NOT NULL,\r
`alternate` TEXT NOT NULL,\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-DROP TABLE IF EXISTS `mxchange_refdepths`;\r
-CREATE TABLE `mxchange_refdepths` (\r
+DROP TABLE IF EXISTS `{!prefix!}_refdepths`;\r
+CREATE TABLE `{!prefix!}_refdepths` (\r
`id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,\r
`level` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,\r
`percents` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-INSERT INTO `mxchange_refdepths` VALUES (1,0,100);\r
-INSERT INTO `mxchange_refdepths` VALUES (2,1,30);\r
-INSERT INTO `mxchange_refdepths` VALUES (3,2,15);\r
-INSERT INTO `mxchange_refdepths` VALUES (4,3,10);\r
-INSERT INTO `mxchange_refdepths` VALUES (5,4,8);\r
-INSERT INTO `mxchange_refdepths` VALUES (6,5,5);\r
+INSERT INTO `{!prefix!}_refdepths` VALUES (1,0,100);\r
+INSERT INTO `{!prefix!}_refdepths` VALUES (2,1,30);\r
+INSERT INTO `{!prefix!}_refdepths` VALUES (3,2,15);\r
+INSERT INTO `{!prefix!}_refdepths` VALUES (4,3,10);\r
+INSERT INTO `{!prefix!}_refdepths` VALUES (5,4,8);\r
+INSERT INTO `{!prefix!}_refdepths` VALUES (6,5,5);\r
\r
-DROP TABLE IF EXISTS `mxchange_refsystem`;\r
-CREATE TABLE `mxchange_refsystem` (\r
+DROP TABLE IF EXISTS `{!prefix!}_refsystem`;\r
+CREATE TABLE `{!prefix!}_refsystem` (\r
`id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,\r
`level` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-DROP TABLE IF EXISTS `mxchange_user_cats`;\r
-CREATE TABLE `mxchange_user_cats` (\r
+DROP TABLE IF EXISTS `{!prefix!}_user_cats`;\r
+CREATE TABLE `{!prefix!}_user_cats` (\r
`id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,\r
`cat_id` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-DROP TABLE IF EXISTS `mxchange_user_data`;\r
-CREATE TABLE `mxchange_user_data` (\r
+DROP TABLE IF EXISTS `{!prefix!}_user_data`;\r
+CREATE TABLE `{!prefix!}_user_data` (\r
`userid` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
`surname` VARCHAR(255) NOT NULL DEFAULT '',\r
`family` VARCHAR(255) NOT NULL DEFAULT '',\r
PRIMARY KEY (`userid`)\r
) TYPE=MyISAM;\r
\r
-DROP TABLE IF EXISTS `mxchange_user_points`;\r
-CREATE TABLE `mxchange_user_points` (\r
+DROP TABLE IF EXISTS `{!prefix!}_user_points`;\r
+CREATE TABLE `{!prefix!}_user_points` (\r
`id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
`userid` BIGINT(22) NOT NULL DEFAULT 0,\r
`ref_depth` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-ALTER TABLE `mxchange_config` ADD `max_send` TINYINT(3) UNSIGNED NOT NULL DEFAULT '100';\r
-ALTER TABLE `mxchange_config` ADD `url_blacklist` ENUM('Y','N') NOT NULL DEFAULT 'Y';\r
-ALTER TABLE `mxchange_config` ADD `auto_purge` TINYINT(3) UNSIGNED NOT NULL DEFAULT '14';\r
-ALTER TABLE `mxchange_config` ADD `auto_purge_active` ENUM('Y','N') NOT NULL DEFAULT 'Y';\r
+ALTER TABLE `{!prefix!}_config` ADD `max_send` TINYINT(3) UNSIGNED NOT NULL DEFAULT '100';\r
+ALTER TABLE `{!prefix!}_config` ADD `url_blacklist` ENUM('Y','N') NOT NULL DEFAULT 'Y';\r
+ALTER TABLE `{!prefix!}_config` ADD `auto_purge` TINYINT(3) UNSIGNED NOT NULL DEFAULT '14';\r
+ALTER TABLE `{!prefix!}_config` ADD `auto_purge_active` ENUM('Y','N') NOT NULL DEFAULT 'Y';\r
\r
-ALTER TABLE `mxchange_pool` MODIFY `url` TINYTEXT NOT NULL;\r
-ALTER TABLE `mxchange_pool` CHANGE `url` `url` TINYBLOB NOT NULL;\r
-ALTER TABLE `mxchange_pool` MODIFY `data_type` ENUM('TEMP','SEND','NEW','ADMIN','ACTIVE') NOT NULL DEFAULT 'TEMP';\r
+ALTER TABLE `{!prefix!}_pool` MODIFY `url` TINYTEXT NOT NULL;\r
+ALTER TABLE `{!prefix!}_pool` CHANGE `url` `url` TINYBLOB NOT NULL;\r
+ALTER TABLE `{!prefix!}_pool` MODIFY `data_type` ENUM('TEMP','SEND','NEW','ADMIN','ACTIVE') NOT NULL DEFAULT 'TEMP';\r
\r
-DROP TABLE IF EXISTS `mxchange_user_links`;\r
-CREATE TABLE `mxchange_user_links` (\r
+DROP TABLE IF EXISTS `{!prefix!}_user_links`;\r
+CREATE TABLE `{!prefix!}_user_links` (\r
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,\r
`stats_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,\r
`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-DROP TABLE IF EXISTS `mxchange_user_stats`;\r
-CREATE TABLE `mxchange_user_stats` (\r
+DROP TABLE IF EXISTS `{!prefix!}_user_stats`;\r
+CREATE TABLE `{!prefix!}_user_stats` (\r
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,\r
`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,\r
`cat_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-ALTER TABLE `mxchange_user_data` ADD `joined` VARCHAR(10) NOT NULL DEFAULT 0;\r
-ALTER TABLE `mxchange_config` ADD `last_update` VARCHAR(10) NOT NULL DEFAULT 0;\r
+ALTER TABLE `{!prefix!}_user_data` ADD `joined` VARCHAR(10) NOT NULL DEFAULT 0;\r
+ALTER TABLE `{!prefix!}_config` ADD `last_update` VARCHAR(10) NOT NULL DEFAULT 0;\r
\r
-INSERT INTO `mxchange_mod_reg` VALUES (NULL,'chk_login','N','N','N','','N',0);\r
-ALTER TABLE `mxchange_pool` MODIFY `data_type` ENUM('TEMP','SEND','NEW','ADMIN','ACTIVE') NOT NULL DEFAULT 'TEMP';\r
-ALTER TABLE `mxchange_config` ADD `unconfirmed` BIGINT(20) UNSIGNED NOT NULL DEFAULT '100';\r
-ALTER TABLE `mxchange_config` ADD `profile_lock` BIGINT(20) UNSIGNED NOT NULL DEFAULT '86400';\r
-ALTER TABLE `mxchange_user_data` ADD `last_update` VARCHAR(10) NOT NULL DEFAULT 0;\r
-ALTER TABLE `mxchange_refbanner` ADD `clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0;\r
-ALTER TABLE `mxchange_config` ADD `online_timeout` BIGINT(20) UNSIGNED NOT NULL DEFAULT '1800';\r
+INSERT INTO `{!prefix!}_mod_reg` VALUES (NULL,'chk_login','N','N','N','','N',0);\r
+ALTER TABLE `{!prefix!}_pool` MODIFY `data_type` ENUM('TEMP','SEND','NEW','ADMIN','ACTIVE') NOT NULL DEFAULT 'TEMP';\r
+ALTER TABLE `{!prefix!}_config` ADD `unconfirmed` BIGINT(20) UNSIGNED NOT NULL DEFAULT '100';\r
+ALTER TABLE `{!prefix!}_config` ADD `profile_lock` BIGINT(20) UNSIGNED NOT NULL DEFAULT '86400';\r
+ALTER TABLE `{!prefix!}_user_data` ADD `last_update` VARCHAR(10) NOT NULL DEFAULT 0;\r
+ALTER TABLE `{!prefix!}_refbanner` ADD `clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0;\r
+ALTER TABLE `{!prefix!}_config` ADD `online_timeout` BIGINT(20) UNSIGNED NOT NULL DEFAULT '1800';\r
\r
-ALTER TABLE `mxchange_config` ADD `mad_timestamp` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0;\r
-ALTER TABLE `mxchange_config` ADD `mad_count` BIGINT(20) UNSIGNED NOT NULL;\r
-ALTER TABLE `mxchange_config` ADD `profile_update` BIGINT(20) UNSIGNED NOT NULL DEFAULT '15768000';\r
-ALTER TABLE `mxchange_config` ADD `send_prof_update` ENUM('Y','N') NOT NULL DEFAULT 'Y';\r
-ALTER TABLE `mxchange_config` ADD `resend_profile_update` BIGINT(20) UNSIGNED NOT NULL DEFAULT '172800';\r
+ALTER TABLE `{!prefix!}_config` ADD `mad_timestamp` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0;\r
+ALTER TABLE `{!prefix!}_config` ADD `mad_count` BIGINT(20) UNSIGNED NOT NULL;\r
+ALTER TABLE `{!prefix!}_config` ADD `profile_update` BIGINT(20) UNSIGNED NOT NULL DEFAULT '15768000';\r
+ALTER TABLE `{!prefix!}_config` ADD `send_prof_update` ENUM('Y','N') NOT NULL DEFAULT 'Y';\r
+ALTER TABLE `{!prefix!}_config` ADD `resend_profile_update` BIGINT(20) UNSIGNED NOT NULL DEFAULT '172800';\r
\r
-ALTER TABLE `mxchange_user_data` ADD `last_profile_sent` VARCHAR(10) NOT NULL DEFAULT 0;\r
-ALTER TABLE `mxchange_user_data` ADD `notified` ENUM('Y','N') NOT NULL DEFAULT 'N';\r
+ALTER TABLE `{!prefix!}_user_data` ADD `last_profile_sent` VARCHAR(10) NOT NULL DEFAULT 0;\r
+ALTER TABLE `{!prefix!}_user_data` ADD `notified` ENUM('Y','N') NOT NULL DEFAULT 'N';\r
\r
-ALTER TABLE `mxchange_config` ADD `patch_level` VARCHAR(100) NOT NULL DEFAULT '78';\r
-ALTER TABLE `mxchange_config` ADD `patch_ctime` VARCHAR(10) NOT NULL DEFAULT 0;\r
+ALTER TABLE `{!prefix!}_config` ADD `patch_level` VARCHAR(100) NOT NULL DEFAULT '78';\r
+ALTER TABLE `{!prefix!}_config` ADD `patch_ctime` VARCHAR(10) NOT NULL DEFAULT 0;\r
\r
-ALTER TABLE `mxchange_admins` ADD `email` VARCHAR(255) NOT NULL;\r
+ALTER TABLE `{!prefix!}_admins` ADD `email` VARCHAR(255) NOT NULL;\r
\r
-DROP TABLE IF EXISTS `mxchange_task_system`;\r
-CREATE TABLE `mxchange_task_system` (\r
+DROP TABLE IF EXISTS `{!prefix!}_task_system`;\r
+CREATE TABLE `{!prefix!}_task_system` (\r
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,\r
`assigned_admin` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,\r
`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-ALTER TABLE `mxchange_pool` ADD INDEX (`sender`);\r
-ALTER TABLE `mxchange_pool` ADD INDEX (`payment_id`);\r
-ALTER TABLE `mxchange_pool` ADD INDEX (`cat_id`);\r
-ALTER TABLE `mxchange_refsystem` ADD INDEX (`userid`);\r
-ALTER TABLE `mxchange_task_system` ADD INDEX (`assigned_admin`);\r
-ALTER TABLE `mxchange_task_system` ADD INDEX (`userid`);\r
-ALTER TABLE `mxchange_user_cats` ADD INDEX (`userid`);\r
-ALTER TABLE `mxchange_user_cats` ADD INDEX (`cat_id`);\r
-ALTER TABLE `mxchange_user_data` ADD INDEX (`refid`);\r
-ALTER TABLE `mxchange_user_links` ADD INDEX (`userid`);\r
-ALTER TABLE `mxchange_user_links` ADD INDEX (`stats_id`);\r
-ALTER TABLE `mxchange_user_points` ADD INDEX (`userid`);\r
-ALTER TABLE `mxchange_user_stats` ADD INDEX (`userid`);\r
-ALTER TABLE `mxchange_user_stats` ADD INDEX (`cat_id`);\r
-ALTER TABLE `mxchange_user_stats` ADD INDEX (`payment_id`);\r
-ALTER TABLE `mxchange_user_stats` ADD INDEX (`pool_id`);\r
-\r
-ALTER TABLE `mxchange_user_stats` ADD `clicks` BIGINT(20) UNSIGNED NOT NULL;\r
-ALTER TABLE `mxchange_config` ADD `code_length` TINYINT(3) UNSIGNED NOT NULL DEFAULT 5;\r
-ALTER TABLE `mxchange_config` ADD `guest_stats` ENUM('MEMBERS','MODULES','INACTIVE') NOT NULL DEFAULT 'MEMBERS';\r
-ALTER TABLE `mxchange_config` ADD `ref_payout` TINYINT(3) UNSIGNED NOT NULL DEFAULT 5;\r
-ALTER TABLE `mxchange_user_data` ADD `ref_payout` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0;\r
-ALTER TABLE `mxchange_user_points` ADD `locked_points` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0;\r
-\r
-DROP TABLE IF EXISTS `mxchange_extensions`;\r
-CREATE TABLE `mxchange_extensions` (\r
+ALTER TABLE `{!prefix!}_pool` ADD INDEX (`sender`);\r
+ALTER TABLE `{!prefix!}_pool` ADD INDEX (`payment_id`);\r
+ALTER TABLE `{!prefix!}_pool` ADD INDEX (`cat_id`);\r
+ALTER TABLE `{!prefix!}_refsystem` ADD INDEX (`userid`);\r
+ALTER TABLE `{!prefix!}_task_system` ADD INDEX (`assigned_admin`);\r
+ALTER TABLE `{!prefix!}_task_system` ADD INDEX (`userid`);\r
+ALTER TABLE `{!prefix!}_user_cats` ADD INDEX (`userid`);\r
+ALTER TABLE `{!prefix!}_user_cats` ADD INDEX (`cat_id`);\r
+ALTER TABLE `{!prefix!}_user_data` ADD INDEX (`refid`);\r
+ALTER TABLE `{!prefix!}_user_links` ADD INDEX (`userid`);\r
+ALTER TABLE `{!prefix!}_user_links` ADD INDEX (`stats_id`);\r
+ALTER TABLE `{!prefix!}_user_points` ADD INDEX (`userid`);\r
+ALTER TABLE `{!prefix!}_user_stats` ADD INDEX (`userid`);\r
+ALTER TABLE `{!prefix!}_user_stats` ADD INDEX (`cat_id`);\r
+ALTER TABLE `{!prefix!}_user_stats` ADD INDEX (`payment_id`);\r
+ALTER TABLE `{!prefix!}_user_stats` ADD INDEX (`pool_id`);\r
+\r
+ALTER TABLE `{!prefix!}_user_stats` ADD `clicks` BIGINT(20) UNSIGNED NOT NULL;\r
+ALTER TABLE `{!prefix!}_config` ADD `code_length` TINYINT(3) UNSIGNED NOT NULL DEFAULT 5;\r
+ALTER TABLE `{!prefix!}_config` ADD `guest_stats` ENUM('MEMBERS','MODULES','INACTIVE') NOT NULL DEFAULT 'MEMBERS';\r
+ALTER TABLE `{!prefix!}_config` ADD `ref_payout` TINYINT(3) UNSIGNED NOT NULL DEFAULT 5;\r
+ALTER TABLE `{!prefix!}_user_data` ADD `ref_payout` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0;\r
+ALTER TABLE `{!prefix!}_user_points` ADD `locked_points` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0;\r
+\r
+DROP TABLE IF EXISTS `{!prefix!}_extensions`;\r
+CREATE TABLE `{!prefix!}_extensions` (\r
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,\r
`ext_name` VARCHAR(255) NOT NULL DEFAULT '',\r
`ext_active` ENUM('Y','N') NOT NULL DEFAULT 'N',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-DROP TABLE IF EXISTS `mxchange_jackpot`;\r
-CREATE TABLE `mxchange_jackpot` (\r
+DROP TABLE IF EXISTS `{!prefix!}_jackpot`;\r
+CREATE TABLE `{!prefix!}_jackpot` (\r
`ok` CHAR(2) NOT NULL DEFAULT 'ok',\r
`points` FLOAT(20,3) NOT NULL DEFAULT '0.000',\r
PRIMARY KEY (`ok`)\r
) TYPE=MyISAM;\r
\r
-ALTER TABLE `mxchange_config` ADD `activate_xchange` BIGINT(20) UNSIGNED NOT NULL DEFAULT 100;\r
-ALTER TABLE `mxchange_config` ADD `order_multi_page` ENUM('Y','N') NOT NULL DEFAULT 'Y';\r
-ALTER TABLE `mxchange_config` ADD `display_refid` ENUM('Y','N') NOT NULL DEFAULT 'Y';\r
-ALTER TABLE `mxchange_config` ADD `ip_timeout` BIGINT(20) UNSIGNED NOT NULL DEFAULT 86400;\r
-ALTER TABLE `mxchange_pool` ADD `zip` VARCHAR(6) NOT NULL DEFAULT '';\r
-\r
-ALTER TABLE `mxchange_task_system` CHANGE `task_type` `task_type` VARCHAR(255) NOT NULL DEFAULT 'FIRST_USER';\r
-ALTER TABLE `mxchange_user_data` MODIFY `zip` VARCHAR(6) NOT NULL DEFAULT '';\r
-ALTER TABLE `mxchange_user_data` MODIFY `last_module` VARCHAR(255) NOT NULL DEFAULT '';\r
-ALTER TABLE `mxchange_config` ADD `allow_direct_pay` ENUM('Y','N') NOT NULL DEFAULT 'N';\r
-ALTER TABLE `mxchange_user_data` MODIFY `last_profile_sent` VARCHAR(10) NOT NULL DEFAULT 0;\r
-ALTER TABLE `mxchange_user_data` MODIFY `last_update` VARCHAR(10) NOT NULL DEFAULT 0;\r
-ALTER TABLE `mxchange_user_data` MODIFY `joined` VARCHAR(10) NOT NULL DEFAULT 0;\r
-ALTER TABLE `mxchange_user_data` MODIFY `last_online` VARCHAR(10) NOT NULL DEFAULT 0;\r
+ALTER TABLE `{!prefix!}_config` ADD `activate_xchange` BIGINT(20) UNSIGNED NOT NULL DEFAULT 100;\r
+ALTER TABLE `{!prefix!}_config` ADD `order_multi_page` ENUM('Y','N') NOT NULL DEFAULT 'Y';\r
+ALTER TABLE `{!prefix!}_config` ADD `display_refid` ENUM('Y','N') NOT NULL DEFAULT 'Y';\r
+ALTER TABLE `{!prefix!}_config` ADD `ip_timeout` BIGINT(20) UNSIGNED NOT NULL DEFAULT 86400;\r
+ALTER TABLE `{!prefix!}_pool` ADD `zip` VARCHAR(6) NOT NULL DEFAULT '';\r
+\r
+ALTER TABLE `{!prefix!}_task_system` CHANGE `task_type` `task_type` VARCHAR(255) NOT NULL DEFAULT 'FIRST_USER';\r
+ALTER TABLE `{!prefix!}_user_data` MODIFY `zip` VARCHAR(6) NOT NULL DEFAULT '';\r
+ALTER TABLE `{!prefix!}_user_data` MODIFY `last_module` VARCHAR(255) NOT NULL DEFAULT '';\r
+ALTER TABLE `{!prefix!}_config` ADD `allow_direct_pay` ENUM('Y','N') NOT NULL DEFAULT 'N';\r
+ALTER TABLE `{!prefix!}_user_data` MODIFY `last_profile_sent` VARCHAR(10) NOT NULL DEFAULT 0;\r
+ALTER TABLE `{!prefix!}_user_data` MODIFY `last_update` VARCHAR(10) NOT NULL DEFAULT 0;\r
+ALTER TABLE `{!prefix!}_user_data` MODIFY `joined` VARCHAR(10) NOT NULL DEFAULT 0;\r
+ALTER TABLE `{!prefix!}_user_data` MODIFY `last_online` VARCHAR(10) NOT NULL DEFAULT 0;\r
if (($time > 0) && ($payment > 0)) {
if (!empty($code)) {
// Generate code
- $img_code = GEN_RANDOM_CODE(getConfig('code_length'), $code, $url_uid, $DATA);
+ $img_code = generateRandomCodde(getConfig('code_length'), $code, $url_uid, $DATA);
} // END - if
switch ($mode) {
define('__MODULE', sprintf("inc/modules/%s.php", SQL_ESCAPE($GLOBALS['module'])));
// Did we found the module listed in allowed modules and are we successfully connected?
- $check = CHECK_MODULE($GLOBALS['module']);
+ $check = checkModulePermissions($GLOBALS['module']);
switch ($check)
{
case "admin_only":
projects / mailer.git / commitdiff