Complete refacture for previously discovered inconsistency

diff --git a/inc/extensions/ext-surfbar.php b/inc/extensions/ext-surfbar.php
index 61e92bcce43ce3d7627932a6c0d36f2cfe093a26..8b2fb94ffb28d661fb83143424b05dae3fd82678 100644 (file)
--- a/inc/extensions/ext-surfbar.php
+++ b/inc/extensions/ext-surfbar.php
@@ -56,96 +56,96 @@ switch (getExtensionMode()) {
                // SQL commands to run (surfbar URLs)
                addExtensionSql("DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_surfbar_urls`");
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_surfbar_urls` (
                // SQL commands to run (surfbar URLs)
                addExtensionSql("DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_surfbar_urls`");
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_surfbar_urls` (

-`id` BIGINT(20) UNSIGNED  NOT NULL AUTO_INCREMENT,
-`userid` BIGINT(20) UNSIGNED  NOT NULL DEFAULT 0,
+`url_id` BIGINT(20) UNSIGNED  NOT NULL AUTO_INCREMENT,
+`url_userid` BIGINT(20) UNSIGNED  NOT NULL DEFAULT 0,

 `url` VARCHAR(255) NOT NULL DEFAULT '',
 `url` VARCHAR(255) NOT NULL DEFAULT '',

-`last_salt` VARCHAR(255) NOT NULL DEFAULT '',
-`views_total` BIGINT(20) UNSIGNED  NOT NULL DEFAULT 0,
-`views_max` BIGINT(20) UNSIGNED  NOT NULL DEFAULT 0,
-`views_allowed` BIGINT(20) UNSIGNED  NOT NULL DEFAULT 0,
-`status` ENUM('PENDING','ACTIVE','LOCKED','STOPPED','REJECTED','DELETED','MIGRATED','DEPLETED') NOT NULL DEFAULT 'PENDING',
-`registered` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
-`last_locked` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
-`lock_reason` VARCHAR(255) NOT NULL DEFAULT '',
-`reject_reason` VARCHAR(255) NOT NULL DEFAULT '',
-`fixed_reload` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-PRIMARY KEY (`id`),
-UNIQUE KEY `userid_url` (`userid`,`url`),
-INDEX `status_userid` (`status`,`userid`)
+`url_last_salt` VARCHAR(255) NOT NULL DEFAULT '',
+`url_views_total` BIGINT(20) UNSIGNED  NOT NULL DEFAULT 0,
+`url_views_max` BIGINT(20) UNSIGNED  NOT NULL DEFAULT 0,
+`url_views_allowed` BIGINT(20) UNSIGNED  NOT NULL DEFAULT 0,
+`url_status` ENUM('PENDING','ACTIVE','LOCKED','STOPPED','REJECTED','DELETED','MIGRATED','DEPLETED') NOT NULL DEFAULT 'PENDING',
+`url_registered` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+`url_last_locked` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
+`url_lock_reason` VARCHAR(255) NOT NULL DEFAULT '',
+`url_reject_reason` VARCHAR(255) NOT NULL DEFAULT '',
+`url_fixed_reload` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+PRIMARY KEY (`url_id`),
+UNIQUE KEY `userid_url` (`url_userid`,`url`),
+INDEX `status_userid` (`url_status`,`url_userid`)

 ) TYPE={?_TABLE_TYPE?} COMMENT='Surfbar URLs'");
 
                // Reload locks
                addExtensionSql("DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_surfbar_locks`");
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_surfbar_locks` (
 ) TYPE={?_TABLE_TYPE?} COMMENT='Surfbar URLs'");
 
                // Reload locks
                addExtensionSql("DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_surfbar_locks`");
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_surfbar_locks` (

-`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-`userid` BIGINT(20) UNSIGNED  NOT NULL DEFAULT 0,
-`url_id` BIGINT(20) UNSIGNED  NOT NULL DEFAULT 0,
-`last_surfed` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
-PRIMARY KEY (`id`),
-UNIQUE KEY `userid_url` (`userid`,`url_id`),
-INDEX (`url_id`)
+`locks_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`locks_userid` BIGINT(20) UNSIGNED  NOT NULL DEFAULT 0,
+`locks_url_id` BIGINT(20) UNSIGNED  NOT NULL DEFAULT 0,
+`locks_last_surfed` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+PRIMARY KEY (`locks_id`),
+UNIQUE KEY `userid_url` (`locks_userid`,`locks_url_id`),
+INDEX (`locks_url_id`)

 ) TYPE={?_TABLE_TYPE?} COMMENT='Surfbar reload locks'");
 
                // Surfbar salts
                addExtensionSql("DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_surfbar_salts`");
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_surfbar_salts` (
 ) TYPE={?_TABLE_TYPE?} COMMENT='Surfbar reload locks'");
 
                // Surfbar salts
                addExtensionSql("DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_surfbar_salts`");
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_surfbar_salts` (

-`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-`userid` BIGINT(20) UNSIGNED  NOT NULL DEFAULT 0,
-`url_id` BIGINT(20) UNSIGNED  NOT NULL DEFAULT 0,
-`last_salt` VARCHAR(255) NOT NULL DEFAULT '',
-PRIMARY KEY (`id`),
-UNIQUE KEY `userid_url` (`userid`,`url_id`),
-INDEX (`url_id`)
+`salts_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`salts_userid` BIGINT(20) UNSIGNED  NOT NULL DEFAULT 0,
+`salts_url_id` BIGINT(20) UNSIGNED  NOT NULL DEFAULT 0,
+`salts_last_salt` VARCHAR(255) NOT NULL DEFAULT '',
+PRIMARY KEY (`salts_id`),
+UNIQUE KEY `salts_userid_url` (`salts_userid`,`salts_url_id`),
+INDEX (`salts_url_id`)

 ) TYPE={?_TABLE_TYPE?} COMMENT='Surfbar last used salts'");
 
                // Statistics
                addExtensionSql("DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_surfbar_stats`");
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_surfbar_stats` (
 ) TYPE={?_TABLE_TYPE?} COMMENT='Surfbar last used salts'");
 
                // Statistics
                addExtensionSql("DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_surfbar_stats`");
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_surfbar_stats` (

-`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`url_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`count` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`last_surfed` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
-PRIMARY KEY (`id`),
-UNIQUE KEY `userid_url` (`userid`,`url_id`),
-INDEX (`url_id`)
+`stats_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`stats_userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`stats_url_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`stats_count` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`stats_last_surfed` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+PRIMARY KEY (`stats_id`),
+UNIQUE KEY `userid_url` (`stats_userid`,`stats_url_id`),
+INDEX (`stats_url_id`)

 ) TYPE={?_TABLE_TYPE?} COMMENT='Surfbar Statistics'");
 
                // Member actions pending on status
                addExtensionSql("DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_surfbar_actions`");
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_surfbar_actions` (
 ) TYPE={?_TABLE_TYPE?} COMMENT='Surfbar Statistics'");
 
                // Member actions pending on status
                addExtensionSql("DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_surfbar_actions`");
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_surfbar_actions` (

-`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-`status` ENUM('PENDING','ACTIVE','LOCKED','STOPPED','REJECTED','DELETED','MIGRATED','DEPLETED') NULL DEFAULT NULL,
-`action` ENUM('EDIT','DELETE','PAUSE','UNPAUSE','FRAMETEST','RETREAT','RESUBMIT','BOOKNOW') NULL DEFAULT NULL,
-`new_status` ENUM('PENDING','ACTIVE','LOCKED','STOPPED','REJECTED','DELETED','MIGRATED','DEPLETED') NULL DEFAULT NULL,
-PRIMARY KEY (`id`),
-UNIQUE KEY `status_action` (`status`,`action`)
+`actions_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`actions_status` ENUM('PENDING','ACTIVE','LOCKED','STOPPED','REJECTED','DELETED','MIGRATED','DEPLETED') NULL DEFAULT NULL,
+`actions_action` ENUM('EDIT','DELETE','PAUSE','UNPAUSE','FRAMETEST','RETREAT','RESUBMIT','BOOKNOW') NULL DEFAULT NULL,
+`actions_new_status` ENUM('PENDING','ACTIVE','LOCKED','STOPPED','REJECTED','DELETED','MIGRATED','DEPLETED') NULL DEFAULT NULL,
+PRIMARY KEY (`actions_id`),
+UNIQUE KEY `status_action` (`actions_status`,`actions_action`)

 ) TYPE={?_TABLE_TYPE?} COMMENT='Surfbar Member Actions'");
 
                // Member actions
 ) TYPE={?_TABLE_TYPE?} COMMENT='Surfbar Member Actions'");
 
                // Member actions

-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('PENDING','RETREAT','DELETED')");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('PENDING','FRAMETEST',NULL)");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('PENDING','EDIT',NULL)");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('ACTIVE','EDIT','PENDING')");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('ACTIVE','DELETE','DELETED')");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('ACTIVE','PAUSE','STOPPED')");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('ACTIVE','FRAMETEST',NULL)");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('LOCKED','DELETE','DELETED')");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('LOCKED','FRAMETEST',NULL)");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('LOCKED','RESUBMIT','PENDING')");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('STOPPED','EDIT','PENDING')");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('STOPPED','DELETE','DELETED')");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('STOPPED','UNPAUSE','PENDING')");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('DEPLETED','EDIT','PENDING')");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('DEPLETED','DELETE','DELETED')");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('REJECTED','EDIT','PENDING')");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('REJECTED','DELETE','DELETED')");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('REJECTED','FRAMETEST',NULL)");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('REJECTED','RESUBMIT','PENDING')");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('MIGRATED','EDIT','MIGRATED')");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('MIGRATED','DELETE','DELETED')");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('MIGRATED','FRAMETEST',NULL)");
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`status`,`action`,`new_status`) VALUES ('MIGRATED','BOOKNOW','PENDING')");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('PENDING','RETREAT','DELETED')");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('PENDING','FRAMETEST',NULL)");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('PENDING','EDIT',NULL)");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('ACTIVE','EDIT','PENDING')");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('ACTIVE','DELETE','DELETED')");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('ACTIVE','PAUSE','STOPPED')");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('ACTIVE','FRAMETEST',NULL)");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('LOCKED','DELETE','DELETED')");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('LOCKED','FRAMETEST',NULL)");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('LOCKED','RESUBMIT','PENDING')");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('STOPPED','EDIT','PENDING')");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('STOPPED','DELETE','DELETED')");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('STOPPED','UNPAUSE','PENDING')");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('DEPLETED','EDIT','PENDING')");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('DEPLETED','DELETE','DELETED')");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('REJECTED','EDIT','PENDING')");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('REJECTED','DELETE','DELETED')");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('REJECTED','FRAMETEST',NULL)");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('REJECTED','RESUBMIT','PENDING')");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('MIGRATED','EDIT','MIGRATED')");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('MIGRATED','DELETE','DELETED')");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('MIGRATED','FRAMETEST',NULL)");
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`,`actions_action`,`actions_new_status`) VALUES ('MIGRATED','BOOKNOW','PENDING')");

 
                // Config entries
                addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `surfbar_pay_model` ENUM('STATIC','DYNAMIC') NOT NULL DEFAULT 'STATIC'");
 
                // Config entries
                addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `surfbar_pay_model` ENUM('STATIC','DYNAMIC') NOT NULL DEFAULT 'STATIC'");

diff --git a/inc/language/de.php b/inc/language/de.php
index 122104458fe7ff4b1cd6f68fd2bc97b43d97130c..6e6be642b1776ed01e5f55e96b83d2358f579b51 100644 (file)
--- a/inc/language/de.php
+++ b/inc/language/de.php
@@ -1045,7 +1045,7 @@ addMessages(array(
        'ADMIN_NO_POINTS_REPAYED' => "Die Mailbuchung hatte keine {?POINTS?} zum zurückbuchen.",
        'ADMIN_POINTS_SHREDDED' => "Es wurden <span class=\"data\">%s&nbsp; {?POINTS?}</span> geschrettert.",
        'EXTENSION_PROBLEM_EXT_INACTIVE' => "Kann nicht fortfahren! Fehler: Erweiterung <span class=\"data\">%s</span> deaktiviert.",
        'ADMIN_NO_POINTS_REPAYED' => "Die Mailbuchung hatte keine {?POINTS?} zum zur&uuml;ckbuchen.",
        'ADMIN_POINTS_SHREDDED' => "Es wurden <span class=\"data\">%s&nbsp; {?POINTS?}</span> geschrettert.",
        'EXTENSION_PROBLEM_EXT_INACTIVE' => "Kann nicht fortfahren! Fehler: Erweiterung <span class=\"data\">%s</span> deaktiviert.",

-       'ADMIN_EXTENSION_PROBLEM_EXT_INACTIVE' => "Die Erweiterung <span class=\"data\">%s</span> ist derzeit deaktiviert. <a href=\"{%url=modules.php?module=admin&amp;what=extensions%}\">Hier</a> k&ouml;nnen Sie diese aktivieren.",
+       'ADMIN_EXTENSION_PROBLEM_EXT_INACTIVE' => "Die Erweiterung <span class=\"data\">%s</span> ist derzeit deaktiviert. <a href=\"{%%url=modules.php?module=admin&amp;what=extensions%%}\">Hier</a> k&ouml;nnen Sie diese aktivieren.",

        'EXTENSION_PROBLEM_EXT_NOT_INSTALLED' => "Kann nicht fortfahren! Fehler: Erweiterung <span class=\"data\">%s</span> nicht installiert.",
        'ADMIN_EXTENSION_PROBLEM_EXT_NOT_INSTALLED' => "Die Erweiterung <span class=\"data\">%s</span> ist derzeit nicht installiert. <a href=\"{%%url=modules.php?module=admin&amp;what=extensions%%}\">Hier</a> k&ouml;nnen Sie diese aktivieren.",
        'EXTENSION_PROBLEM_NOT_INSTALLED' => "Erweiterung <span class=\"data\">%s</span> nicht installiert.",
        'EXTENSION_PROBLEM_EXT_NOT_INSTALLED' => "Kann nicht fortfahren! Fehler: Erweiterung <span class=\"data\">%s</span> nicht installiert.",
        'ADMIN_EXTENSION_PROBLEM_EXT_NOT_INSTALLED' => "Die Erweiterung <span class=\"data\">%s</span> ist derzeit nicht installiert. <a href=\"{%%url=modules.php?module=admin&amp;what=extensions%%}\">Hier</a> k&ouml;nnen Sie diese aktivieren.",
        'EXTENSION_PROBLEM_NOT_INSTALLED' => "Erweiterung <span class=\"data\">%s</span> nicht installiert.",

diff --git a/inc/libs/surfbar_functions.php b/inc/libs/surfbar_functions.php
index 8736faeafc43a1e71b9833f280b6c4a409d69d5d..01173c9de3033f72a4ceca5cc46c3f8c4f4c8cc4 100644 (file)
--- a/inc/libs/surfbar_functions.php
+++ b/inc/libs/surfbar_functions.php
@@ -350,7 +350,7 @@ function SURFBAR_MEMBER_UNPAUSE_ACTION ($urlData) {
        // Fix missing entry for template
        $urlData['edit'] = $urlData['unpause'];
        $urlData['edit']['url'] = $urlData['url'];
        // Fix missing entry for template
        $urlData['edit'] = $urlData['unpause'];
        $urlData['edit']['url'] = $urlData['url'];

-       $urlData['edit']['limit'] = $urlData['views_max'];
+       $urlData['edit']['limit'] = SURFBAR_GET_VIEWS_MAX();

 
        // Return status change
        return SURFBAR_CHANGE_STATUS($urlData['id'], $urlData['url_status'], $urlData['new_status'], array($urlData['id'] => $urlData));
 
        // Return status change
        return SURFBAR_CHANGE_STATUS($urlData['id'], $urlData['url_status'], $urlData['new_status'], array($urlData['id'] => $urlData));


@@ -363,12 +363,8 @@ function SURFBAR_MEMBER_RESUBMIT_ACTION ($urlData) {
 
 // Display selected "action form"
 function SURFBAR_MEMBER_DISPLAY_ACTION_FORM ($action, $urlData) {
 
 // Display selected "action form"
 function SURFBAR_MEMBER_DISPLAY_ACTION_FORM ($action, $urlData) {

-       // Translate some data
-       $urlData['url_registered']  = generateDateTime($urlData['url_registered'], 2);
-       $urlData['views_total']     = translateComma($urlData['views_total']);
-       $urlData['views_max']       = translateComma($urlData['views_max']);
-       $urlData['views_allowed']   = translateComma($urlData['views_allowed']);
-       $urlData['url_last_locked'] = generateDateTime($urlData['url_last_locked'], 2);
+       // Translate some data if present
+       $content = SURFBAR_PREPARE_CONTENT_FOR_TEMPLATE($content);

 
        // Is the lock reason empty?
        if (empty($urlData['lock_reason'])) {
 
        // Is the lock reason empty?
        if (empty($urlData['lock_reason'])) {


@@ -384,7 +380,7 @@ function SURFBAR_MEMBER_DISPLAY_ACTION_FORM ($action, $urlData) {
                $urlData['limited']   = 'false';
 
                // Is this URL limited?
                $urlData['limited']   = 'false';
 
                // Is this URL limited?

-               if ($urlData['views_max'] > 0) {
+               if (SURFBAR_GET_VIEWS_MAX() > 0) {

                        // Then rewrite form data
                        $urlData['limited_y'] = ' checked="checked"';
                        $urlData['limited_n'] = '';
                        // Then rewrite form data
                        $urlData['limited_y'] = ' checked="checked"';
                        $urlData['limited_n'] = '';


@@ -413,12 +409,6 @@ function SURFBAR_MEMBER_EXECUTE_ACTION ($action, $urlData) {
        // Construct function name
        $functionName = sprintf("SURFBAR_MEMBER_EXECUTE_%s_ACTION", strtoupper($action));
 
        // Construct function name
        $functionName = sprintf("SURFBAR_MEMBER_EXECUTE_%s_ACTION", strtoupper($action));
 

-       // Is 'userid' set and not 'userid' ?
-       if ((!isset($urlData['userid'])) && (isset($urlData['userid']))) {
-               // Auto-fix this
-               $urlData['userid'] = $urlData['userid'];
-       } // END - if
-

        // Is that function there?
        if (function_exists($functionName)) {
                // Execute the function
        // Is that function there?
        if (function_exists($functionName)) {
                // Execute the function


@@ -441,9 +431,9 @@ function SURFBAR_MEMBER_EXECUTE_EDIT_ACTION ($urlData) {
 
        // Has the URL or limit changed?
        if (true) {
 
        // Has the URL or limit changed?
        if (true) {

-               //if (($urlData['views_allowed'] != $urlData['edit']['limit']) || ($url1 != $url2)) {
+               //if (($urlData['url_views_allowed'] != $urlData['edit']['limit']) || ($url1 != $url2)) {

                // Run the query
                // Run the query

-               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_surfbar_urls` SET url='%s', views_allowed=%s, views_max=%s WHERE `id`=%s AND `status`='%s' LIMIT 1",
+               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_surfbar_urls` SET `url`='%s', `url_views_allowed`=%s, `url_views_max`=%s WHERE `url_id`=%s AND `status`='%s' LIMIT 1",

                        array($urlData['url'], $urlData['edit']['limit'], $urlData['edit']['limit'], $urlData['id'], $urlData['url_status']), __FUNCTION__, __LINE__);
 
                // All fine
                        array($urlData['url'], $urlData['edit']['limit'], $urlData['edit']['limit'], $urlData['id'], $urlData['url_status']), __FUNCTION__, __LINE__);
 
                // All fine


@@ -474,7 +464,7 @@ function SURFBAR_HANDLE_SELF_MAINTENANCE () {
 // Handle URLs which limit has depleted
 function SURFBAR_HANDLE_DEPLETED_VIEWS () {
        // Get all URLs
 // Handle URLs which limit has depleted
 function SURFBAR_HANDLE_DEPLETED_VIEWS () {
        // Get all URLs

-       $urlArray = SURFBAR_GET_URL_DATA(0, 'views_max', 'id', 'ASC', 'id', " AND views_allowed>0 AND `status`='ACTIVE'");
+       $urlArray = SURFBAR_GET_URL_DATA(0, 'url_views_max', 'url_id', 'ASC', 'url_id', " AND `url_views_allowed` > 0 AND `url_status`='ACTIVE'");

 
        // Do we have some entries?
        if (count($urlArray) > 0) {
 
        // Do we have some entries?
        if (count($urlArray) > 0) {


@@ -514,8 +504,8 @@ function SURFBAR_HANDLE_LOW_POINTS () {
                        SURFBAR_NOTIFY_USER('low_points', $content);
 
                        // Update last notified
                        SURFBAR_NOTIFY_USER('low_points', $content);
 
                        // Update last notified

-                       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET surfbar_low_notified=NOW() WHERE `userid`=%s LIMIT 1",
-                       array($userid), __FUNCTION__, __LINE__);
+                       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `surfbar_low_notified`=NOW() WHERE `userid`=%s LIMIT 1",
+                               array($userid), __FUNCTION__, __LINE__);

                } // END - if
        } // END - foreach
 }
                } // END - if
        } // END - foreach
 }


@@ -529,19 +519,19 @@ function SURFBAR_HANDLE_LOW_POINTS () {
 // Looks up by an URL
 function SURFBAR_LOOKUP_BY_URL ($url, $userid) {
        // Now lookup that given URL by itself
 // Looks up by an URL
 function SURFBAR_LOOKUP_BY_URL ($url, $userid) {
        // Now lookup that given URL by itself

-       $urlArray = SURFBAR_GET_URL_DATA($url, 'url', 'id', 'ASC', 'id', sprintf(" AND `userid`=%s", bigintval($userid)));
+       $urlArray = SURFBAR_GET_URL_DATA($url, 'url', 'url_id', 'ASC', 'url_id', sprintf(" AND `url_userid`=%s", bigintval($userid)));

 
        // Was it found?
        return (count($urlArray) > 0);
 }
 
 // Load URL data by given search term and column
 
        // Was it found?
        return (count($urlArray) > 0);
 }
 
 // Load URL data by given search term and column

-function SURFBAR_GET_URL_DATA ($searchTerm, $column = 'id', $order = 'id', $sort = 'ASC', $group = 'id', $add = '') {
+function SURFBAR_GET_URL_DATA ($searchTerm, $column = 'url_id', $order = 'url_id', $sort = 'ASC', $group = 'url_id', $add = '') {

        // By default nothing is found
        $GLOBALS['last_url_data'] = array();
 
        // Is the column an id number?
        // By default nothing is found
        $GLOBALS['last_url_data'] = array();
 
        // Is the column an id number?

-       if (($column == 'id') || ($column == 'userid')) {
+       if (($column == 'url_id') || ($column == 'url_userid')) {

                // Extra secure input
                $searchTerm = bigintval($searchTerm);
        } // END - if
                // Extra secure input
                $searchTerm = bigintval($searchTerm);
        } // END - if


@@ -554,10 +544,19 @@ function SURFBAR_GET_URL_DATA ($searchTerm, $column = 'id', $order = 'id', $sort
 
        // Look up the record
        $result = SQL_QUERY_ESC("SELECT
 
        // Look up the record
        $result = SQL_QUERY_ESC("SELECT

-       `id`, `userid`, `url`,
-       `views_total`, `views_max`, `views_allowed`, `status` AS `url_status`,
-       UNIX_TIMESTAMP(`registered`) AS `url_registered`, UNIX_TIMESTAMP(`last_locked`) AS `url_last_locked`, `lock_reason`,
-       `views_max`, `views_allowed`, `fixed_reload`
+       `url_id`,
+       `url_userid`,
+       `url`,
+       `url_views_total`,
+       `url_views_max`,
+       `url_views_allowed`,
+       `url_status`,
+       UNIX_TIMESTAMP(`url_registered`) AS `url_registered`,
+       UNIX_TIMESTAMP(`url_last_locked`) AS `url_last_locked`,
+       `url_lock_reason`,
+       `url_views_max`,
+       `url_views_allowed`,
+       `url_fixed_reload`

 FROM
        `{?_MYSQL_PREFIX?}_surfbar_urls`
 WHERE
 FROM
        `{?_MYSQL_PREFIX?}_surfbar_urls`
 WHERE


@@ -578,12 +577,12 @@ ORDER BY
                // Then load all!
                while ($dataRow = SQL_FETCHARRAY($result)) {
                        // Shall we group these results?
                // Then load all!
                while ($dataRow = SQL_FETCHARRAY($result)) {
                        // Shall we group these results?

-                       if ($group == 'id') {
+                       if ($group == 'url_id') {

                                // Add the row by id as index
                                // Add the row by id as index

-                               $GLOBALS['last_url_data'][$dataRow['id']] = $dataRow;
+                               $GLOBALS['last_url_data'][$dataRow['url_id']] = $dataRow;

                        } else {
                                // Group entries
                        } else {
                                // Group entries

-                               $GLOBALS['last_url_data'][$dataRow[$group]][$dataRow['id']] = $dataRow;
+                               $GLOBALS['last_url_data'][$dataRow[$group]][$dataRow['url_id']] = $dataRow;

                        }
                } // END - while
        } // END - if
                        }
                } // END - while
        } // END - if


@@ -606,7 +605,7 @@ function SURFBAR_REGISTER_URL ($url, $userid, $status = 'PENDING', $addMode = 'r
        $content = merge_array($extraFields, array(
                'url'         => $url,
                'frametester' => generateFrametesterUrl($url),
        $content = merge_array($extraFields, array(
                'url'         => $url,
                'frametester' => generateFrametesterUrl($url),

-               'userid'      => $userid,
+               'url_userid'  => $userid,

                'url_status'  => $status,
        ));
 
                'url_status'  => $status,
        ));
 


@@ -633,11 +632,11 @@ function SURFBAR_REGISTER_URL ($url, $userid, $status = 'PENDING', $addMode = 'r
        // If in reg-mode we notify admin
        if (($addMode == 'reg') || (getConfig('surfbar_notify_admin_unlock') == 'Y')) {
                // Notify admin even when he as unlocked an email
        // If in reg-mode we notify admin
        if (($addMode == 'reg') || (getConfig('surfbar_notify_admin_unlock') == 'Y')) {
                // Notify admin even when he as unlocked an email

-               SURFBAR_NOTIFY_ADMIN("url_{$addMode}", $content);
+               SURFBAR_NOTIFY_ADMIN('url_' . $addMode, $content);

        } // END - if
 
        // Send mail to user
        } // END - if
 
        // Send mail to user

-       SURFBAR_NOTIFY_USER("url_{$addMode}", $content);
+       SURFBAR_NOTIFY_USER('url_' . $addMode, $content);

 
        // Return the insert id
        return $content['insert_id'];
 
        // Return the insert id
        return $content['insert_id'];


@@ -646,13 +645,13 @@ function SURFBAR_REGISTER_URL ($url, $userid, $status = 'PENDING', $addMode = 'r
 // Inserts an url by given data array and return the insert id
 function SURFBAR_INSERT_URL_BY_ARRAY ($urlData) {
        // Get userid
 // Inserts an url by given data array and return the insert id
 function SURFBAR_INSERT_URL_BY_ARRAY ($urlData) {
        // Get userid

-       $userid = bigintval($urlData['userid']);
+       $userid = bigintval($urlData['url_userid']);

 
        // Is the id set?
        if (empty($userid)) $userid = '0';
 
        // Just run the insert query for now
 
        // Is the id set?
        if (empty($userid)) $userid = '0';
 
        // Just run the insert query for now

-       SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_urls` (userid,url,status,views_max,views_allowed,fixed_reload) VALUES (%s,'%s','%s',%s,%s,%s)",
+       SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_urls` (`url_userid`,`url`,`url_status`,`url_views_max`,`url_views_allowed`,`url_fixed_reload`) VALUES (%s,'%s','%s',%s,%s,%s)",

                array(
                        $userid,
                        $urlData['url'],
                array(
                        $userid,
                        $urlData['url'],


@@ -684,12 +683,7 @@ function SURFBAR_NOTIFY_ADMIN ($messageType, $content) {
        } // END - if
 
        // Translate some data if present
        } // END - if
 
        // Translate some data if present

-       if (isset($content['url_status']))      $content['url_status']      = translateSurfbarUrlStatus($content['url_status']);
-       if (isset($content['url_registered']))  $content['url_registered']  = generateDateTime($content['url_registered'], 2);
-       if (isset($content['url_last_locked'])) $content['url_last_locked'] = generateDateTime($content['url_last_locked'], 2);
-       if (isset($content['views_total']))     $content['views_total']     = translateComma($content['views_total']);
-       if (isset($content['views_allowed']))   $content['views_allowed']   = translateComma($content['views_allowed']);
-       if (isset($content['views_max']))       $content['views_max']       = translateComma($content['views_max']);
+       $content = SURFBAR_PREPARE_CONTENT_FOR_TEMPLATE($content);

 
        // Send the notification out
        return sendAdminNotification($subject, $templateName, $content, $content['userid']);
 
        // Send the notification out
        return sendAdminNotification($subject, $templateName, $content, $content['userid']);


@@ -707,7 +701,7 @@ function SURFBAR_NOTIFY_USER ($messageType, $content) {
 
        // Prepare subject
        $subject = getMessage(sprintf("MEMBER_SURFBAR_NOTIFY_%s_SUBJECT",
 
        // Prepare subject
        $subject = getMessage(sprintf("MEMBER_SURFBAR_NOTIFY_%s_SUBJECT",

-       strtoupper($messageType)
+               strtoupper($messageType)

        ));
 
        // Is the subject line there?
        ));
 
        // Is the subject line there?


@@ -717,12 +711,7 @@ function SURFBAR_NOTIFY_USER ($messageType, $content) {
        } // END - if
 
        // Translate some data if present
        } // END - if
 
        // Translate some data if present

-       if (isset($content['url_status']))      $content['url_status']      = translateSurfbarUrlStatus($content['url_status']);
-       if (isset($content['url_registered']))  $content['url_registered']  = generateDateTime($content['url_registered'], 2);
-       if (isset($content['url_last_locked'])) $content['url_last_locked'] = generateDateTime($content['url_last_locked'], 2);
-       if (isset($content['views_total']))     $content['views_total']     = translateComma($content['views_total']);
-       if (isset($content['views_allowed']))   $content['views_allowed']   = translateComma($content['views_allowed']);
-       if (isset($content['views_max']))       $content['views_max']       = translateComma($content['views_max']);
+       $content = SURFBAR_PREPARE_CONTENT_FOR_TEMPLATE($content);

 
        // Load template
        $mailText = loadEmailTemplate($templateName, $content, $content['userid']);
 
        // Load template
        $mailText = loadEmailTemplate($templateName, $content, $content['userid']);


@@ -731,6 +720,21 @@ function SURFBAR_NOTIFY_USER ($messageType, $content) {
        return sendEmail($content['userid'], $subject, $mailText);
 }
 
        return sendEmail($content['userid'], $subject, $mailText);
 }
 

+// Translates some data for template usage
+// @TODO Can't we use our new expression language instead of this ugly code?
+function SURFBAR_PREPARE_CONTENT_FOR_TEMPLATE ($content) {
+       // Prepare some code
+       if (isset($content['url_status']))      $content['url_status']      = translateSurfbarUrlStatus($content['url_status']);
+       if (isset($content['url_registered']))  $content['url_registered']  = generateDateTime($content['url_registered'], 2);
+       if (isset($content['url_last_locked'])) $content['url_last_locked'] = generateDateTime($content['url_last_locked'], 2);
+       if (isset($content['url_views_total'])) $content['url_views_total'] = translateComma($content['url_views_total']);
+       if (isset($content['url_views_allowed']))   $content['url_views_allowed']   = translateComma($content['url_views_allowed']);
+       if (isset($content['views_max']))       $content['views_max']       = translateComma($content['views_max']);
+
+       // Return translated content
+       return $content;
+}
+

 // Translates the limit
 function translateSurfbarLimit ($limit) {
        // Is this zero?
 // Translates the limit
 function translateSurfbarLimit ($limit) {
        // Is this zero?


@@ -841,19 +845,19 @@ function SURFBAR_CHECK_RELOAD_FULL() {
 
        // Ask the database
        $result = SQL_QUERY_ESC("SELECT
 
        // Ask the database
        $result = SQL_QUERY_ESC("SELECT

-       COUNT(l.id) AS cnt
+       COUNT(l.locks_id) AS cnt

 FROM
        `{?_MYSQL_PREFIX?}_surfbar_locks` AS l
 INNER JOIN
        `{?_MYSQL_PREFIX?}_surfbar_urls` AS u
 ON
 FROM
        `{?_MYSQL_PREFIX?}_surfbar_locks` AS l
 INNER JOIN
        `{?_MYSQL_PREFIX?}_surfbar_urls` AS u
 ON

-       u.id=l.url_id
+       u.url_id=l.locks_url_id

 WHERE
 WHERE

-       l.userid=%s AND
-       (UNIX_TIMESTAMP() - ".SURFBAR_GET_SURF_LOCK().") < UNIX_TIMESTAMP(l.last_surfed) AND
+       l.locks_userid=%s AND
+       (UNIX_TIMESTAMP() - ".SURFBAR_GET_SURF_LOCK().") < UNIX_TIMESTAMP(l.locks_last_surfed) AND

        (
        (

-               ((UNIX_TIMESTAMP(l.last_surfed) - u.fixed_reload) < 0 AND u.fixed_reload > 0) OR
-               u.fixed_reload = '0'
+               ((UNIX_TIMESTAMP(l.locks_last_surfed) - u.url_fixed_reload) < 0 AND u.url_fixed_reload > 0) OR
+               u.url_fixed_reload = '0'

        )
 LIMIT 1",
                array(getMemberId()), __FUNCTION__, __LINE__
        )
 LIMIT 1",
                array(getMemberId()), __FUNCTION__, __LINE__


@@ -900,9 +904,14 @@ function SURFBAR_GET_TOTAL_URLS ($status = 'ACTIVE', $excludeUserId = '0') {
        } // END - if
 
        // Get amount from database
        } // END - if
 
        // Get amount from database

-       $result = SQL_QUERY_ESC("SELECT COUNT(`id`) AS cnt
-FROM `{?_MYSQL_PREFIX?}_surfbar_urls`
-WHERE `userid` NOT IN (".implode(', ', $userids['userid']).") AND `status`='%s'",
+       $result = SQL_QUERY_ESC("SELECT
+       COUNT(`url_id`) AS cnt
+FROM
+       `{?_MYSQL_PREFIX?}_surfbar_urls`
+WHERE
+       `url_userid` NOT IN (".implode(', ', $userids['userid']).") AND
+       `url_status`='%s'
+LIMIT 1",

                array($status), __FUNCTION__, __LINE__
        );
 
                array($status), __FUNCTION__, __LINE__
        );
 


@@ -923,7 +932,7 @@ function SURFBAR_IF_USER_BOOK_MORE_URLS ($userid = '0') {
 }
 
 // Get total amount of URLs of given status for current user
 }
 
 // Get total amount of URLs of given status for current user

-function SURFBAR_GET_TOTAL_USER_URLS ($userid = '0', $status = '',$exclude = '') {
+function SURFBAR_GET_TOTAL_USER_URLS ($userid = '0', $status = '', $exclude = '') {

        // Is the user 0 and user is logged in?
        if (($userid == '0') && (isMember())) {
                // Then use this userid
        // Is the user 0 and user is logged in?
        if (($userid == '0') && (isMember())) {
                // Then use this userid


@@ -939,20 +948,20 @@ function SURFBAR_GET_TOTAL_USER_URLS ($userid = '0', $status = '',$exclude = '')
        // Is the status set?
        if (is_array($status)) {
                // Only URLs with these status
        // Is the status set?
        if (is_array($status)) {
                // Only URLs with these status

-               $add = sprintf(" AND `status` IN('%s')", implode("','", $status));
+               $add = sprintf(" AND `url_status` IN('%s')", implode("','", $status));

        } elseif (!empty($status)) {
                // Only URLs with this status
        } elseif (!empty($status)) {
                // Only URLs with this status

-               $add = sprintf(" AND `status`='%s'", $status);
+               $add = sprintf(" AND `url_status`='%s'", $status);

        } elseif (is_array($exclude)) {
                // Exclude URLs with these status
        } elseif (is_array($exclude)) {
                // Exclude URLs with these status

-               $add = sprintf(" AND `status` NOT IN('%s')", implode("','", $exclude));
+               $add = sprintf(" AND `url_status` NOT IN('%s')", implode("','", $exclude));

        } elseif (!empty($exclude)) {
                // Exclude URLs with this status
        } elseif (!empty($exclude)) {
                // Exclude URLs with this status

-               $add = sprintf(" AND `status` != '%s'", $exclude);
+               $add = sprintf(" AND `url_status` != '%s'", $exclude);

        }
 
        // Get amount from database
        }
 
        // Get amount from database

-       $cnt = countSumTotalData($userid, 'surfbar_urls', 'id', 'userid', true, $add);
+       $cnt = countSumTotalData($userid, 'surfbar_urls', 'url_id', 'url_userid', true, $add);

 
        // Return result
        return $cnt;
 
        // Return result
        return $cnt;


@@ -1009,8 +1018,8 @@ function SURFBAR_CHECK_VALIDATION_CODE ($urlId, $check, $salt) {
 
        // Return result of checking hashes and salts
        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, '---'.$code.'|'.$check.'---', false);
 
        // Return result of checking hashes and salts
        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, '---'.$code.'|'.$check.'---', false);

-       //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, '+++'.$salt.'|'.SURFBAR_GET_DATA('last_salt').'+++', false);
-       return (($code == $check) && ($salt == SURFBAR_GET_DATA('last_salt')));
+       //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, '+++'.$salt.'|'.SURFBAR_GET_DATA('salts_last_salt').'+++', false);
+       return (($code == $check) && ($salt == SURFBAR_GET_DATA('salts_last_salt')));

 }
 
 // Lockdown the userid/id combination (reload lock)
 }
 
 // Lockdown the userid/id combination (reload lock)


@@ -1018,11 +1027,11 @@ function SURFBAR_LOCKDOWN_ID ($urlId) {
        //* DEBUG: */ outputHtml('LOCK!');
        ///* DEBUG: */ return;
        // Just add it to the database
        //* DEBUG: */ outputHtml('LOCK!');
        ///* DEBUG: */ return;
        // Just add it to the database

-       SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_locks` (`userid`, `url_id`) VALUES (%s, %s)",
+       SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_locks` (`locks_userid`, `locks_url_id`) VALUES (%s, %s)",

                array(getMemberId(), bigintval($urlId)), __FUNCTION__, __LINE__);
 
        // Remove the salt from database
                array(getMemberId(), bigintval($urlId)), __FUNCTION__, __LINE__);
 
        // Remove the salt from database

-       SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_surfbar_salts` WHERE `url_id`=%s AND `userid`=%s LIMIT 1",
+       SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_surfbar_salts` WHERE `salts_url_id`=%s AND `salts_userid`=%s LIMIT 1",

                array(bigintval($urlId), getMemberId()), __FUNCTION__, __LINE__);
 }
 
                array(bigintval($urlId), getMemberId()), __FUNCTION__, __LINE__);
 }
 


@@ -1054,18 +1063,24 @@ function SURFBAR_UPDATE_INSERT_STATS_RECORD () {
        } // END - if
 
        // Update URL stats
        } // END - if
 
        // Update URL stats

-       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_surfbar_urls` SET `views_total`=`views_total`+1".$add." WHERE `id`=%s LIMIT 1",
+       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_surfbar_urls` SET `url_views_total`=`url_views_total`+1".$add." WHERE `url_id`=%s LIMIT 1",

                array(SURFBAR_GET_ID()), __FUNCTION__, __LINE__);
 
        // Update the stats entry
                array(SURFBAR_GET_ID()), __FUNCTION__, __LINE__);
 
        // Update the stats entry

-       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_surfbar_stats` SET `count`=`count`+1 WHERE `userid`=%s AND `url_id`=%s LIMIT 1",
-               array(getMemberId(), SURFBAR_GET_ID()), __FUNCTION__, __LINE__);
+       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_surfbar_stats` SET `stats_count`=`stats_count`+1 WHERE `stats_userid`=%s AND `stats_url_id`=%s LIMIT 1",
+               array(
+                       getMemberId(),
+                       SURFBAR_GET_ID()
+               ), __FUNCTION__, __LINE__);

 
        // Was that update okay?
        if (SQL_AFFECTEDROWS() < 1) {
                // No, then insert entry
 
        // Was that update okay?
        if (SQL_AFFECTEDROWS() < 1) {
                // No, then insert entry

-               SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_stats` (userid,url_id,count) VALUES (%s,%s,1)",
-               array(getMemberId(), SURFBAR_GET_ID()), __FUNCTION__, __LINE__);
+               SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_stats` (`stats_userid`, `stats_url_id`, `stats_count`) VALUES (%s,%s,1)",
+                       array(
+                               getMemberId(),
+                               SURFBAR_GET_ID()
+                       ), __FUNCTION__, __LINE__);

        } // END - if
 
        // Update total/daily/weekly/monthly counter
        } // END - if
 
        // Update total/daily/weekly/monthly counter


@@ -1084,8 +1099,12 @@ function SURFBAR_UPDATE_SALT_STATS () {
        SURFBAR_UPDATE_INSERT_STATS_RECORD();
 
        // Simply store the salt from cache away in database...
        SURFBAR_UPDATE_INSERT_STATS_RECORD();
 
        // Simply store the salt from cache away in database...

-       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_surfbar_salts` SET `last_salt`='%s' WHERE `url_id`=%s AND `userid`=%s LIMIT 1",
-               array(SURFBAR_GET_SALT(), SURFBAR_GET_ID(), getMemberId()), __FUNCTION__, __LINE__);
+       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_surfbar_salts` SET `salts_last_salt`='%s' WHERE `salts_url_id`=%s AND `salts_userid`=%s LIMIT 1",
+               array(
+                       SURFBAR_GET_SALT(),
+                       SURFBAR_GET_ID(),
+                       getMemberId()
+               ), __FUNCTION__, __LINE__);

 
        // Debug message
        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'salt='.SURFBAR_GET_SALT().',id='.SURFBAR_GET_ID().',userid='.getMemberId().'', false);
 
        // Debug message
        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'salt='.SURFBAR_GET_SALT().',id='.SURFBAR_GET_ID().',userid='.getMemberId().'', false);


@@ -1093,7 +1112,7 @@ function SURFBAR_UPDATE_SALT_STATS () {
        // Was that okay?
        if (SQL_AFFECTEDROWS() < 1) {
                // Insert missing entry!
        // Was that okay?
        if (SQL_AFFECTEDROWS() < 1) {
                // Insert missing entry!

-               SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_salts` (`url_id`, `userid`, `last_salt`) VALUES (%s, %s, '%s')",
+               SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_salts` (`salts_url_id`, `salts_userid`, `salts_last_salt`) VALUES (%s, %s, '%s')",

                        array(SURFBAR_GET_ID(), getMemberId(), SURFBAR_GET_SALT()), __FUNCTION__, __LINE__);
        } // END - if
 
                        array(SURFBAR_GET_ID(), getMemberId(), SURFBAR_GET_SALT()), __FUNCTION__, __LINE__);
        } // END - if
 


@@ -1108,13 +1127,15 @@ function SURFBAR_UPDATE_SALT_STATS () {
 function SURFBAR_CHECK_RELOAD_LOCK ($urlId) {
        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'id=' . $urlId . '', false);
        // Ask the database
 function SURFBAR_CHECK_RELOAD_LOCK ($urlId) {
        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'id=' . $urlId . '', false);
        // Ask the database

-       $result = SQL_QUERY_ESC("SELECT COUNT(`id`) AS cnt
+       $result = SQL_QUERY_ESC("SELECT COUNT(`locks_id`) AS cnt

 FROM
        `{?_MYSQL_PREFIX?}_surfbar_locks`
 WHERE
 FROM
        `{?_MYSQL_PREFIX?}_surfbar_locks`
 WHERE

-       `userid`=%s AND `url_id`=%s AND (UNIX_TIMESTAMP() - ".SURFBAR_GET_SURF_LOCK().") < UNIX_TIMESTAMP(`last_surfed`)
+       `locks_userid`=%s AND
+       `locks_url_id`=%s AND
+       (UNIX_TIMESTAMP() - ".SURFBAR_GET_SURF_LOCK().") < UNIX_TIMESTAMP(`locks_last_surfed`)

 ORDER BY
 ORDER BY

-       `last_surfed` ASC
+       `locks_last_surfed` ASC

 LIMIT 1",
                array(getMemberId(), bigintval($urlId)), __FUNCTION__, __LINE__
        );
 LIMIT 1",
                array(getMemberId(), bigintval($urlId)), __FUNCTION__, __LINE__
        );


@@ -1148,36 +1169,36 @@ function SURFBAR_DETERMINE_DEPLETED_USERIDS ($limit=0) {
 
                // Get all userid except logged in one
                $result = SQL_QUERY_ESC("SELECT
 
                // Get all userid except logged in one
                $result = SQL_QUERY_ESC("SELECT

-       u.userid, UNIX_TIMESTAMP(d.surfbar_low_notified) AS notified
+       u.url_userid, UNIX_TIMESTAMP(d.surfbar_low_notified) AS notified

 FROM
        `{?_MYSQL_PREFIX?}_surfbar_urls` AS u
 INNER JOIN
        `{?_MYSQL_PREFIX?}_user_data` AS d
 ON
 FROM
        `{?_MYSQL_PREFIX?}_surfbar_urls` AS u
 INNER JOIN
        `{?_MYSQL_PREFIX?}_user_data` AS d
 ON

-       u.userid=d.userid
+       u.url_userid=d.userid

 WHERE
 WHERE

-       u.userid NOT IN (%s,0) AND u.`status`='ACTIVE'
+       u.url_userid NOT IN (%s,0) AND u.url_status='ACTIVE'

 GROUP BY
 GROUP BY

-       u.userid
+       u.url_userid

 ORDER BY
 ORDER BY

-       u.userid ASC",
+       u.url_userid ASC",

                        array(getMemberId()), __FUNCTION__, __LINE__);
        } else {
                // Get all userid
                $result = SQL_QUERY("SELECT
                        array(getMemberId()), __FUNCTION__, __LINE__);
        } else {
                // Get all userid
                $result = SQL_QUERY("SELECT

-       u.userid, UNIX_TIMESTAMP(d.surfbar_low_notified) AS notified
+       u.url_userid, UNIX_TIMESTAMP(d.surfbar_low_notified) AS notified

 FROM
        `{?_MYSQL_PREFIX?}_surfbar_urls` AS u
 INNER JOIN
        `{?_MYSQL_PREFIX?}_user_data` AS d
 ON
 FROM
        `{?_MYSQL_PREFIX?}_surfbar_urls` AS u
 INNER JOIN
        `{?_MYSQL_PREFIX?}_user_data` AS d
 ON

-       u.userid=d.userid
+       u.url_userid=d.userid

 WHERE
 WHERE

-       u.`status`='ACTIVE'
+       u.url_status='ACTIVE'

 GROUP BY
 GROUP BY

-       u.userid
+       u.url_userid

 ORDER BY
 ORDER BY

-       u.userid ASC", __FUNCTION__, __LINE__);
+       u.url_userid ASC", __FUNCTION__, __LINE__);

        }
 
        // Load all userid
        }
 
        // Load all userid


@@ -1210,13 +1231,13 @@ ORDER BY
 function SURFBAR_DETERMINE_TOTAL_ONLINE () {
        // Count all users in surfbar modue and return the value
        $result = SQL_QUERY("SELECT
 function SURFBAR_DETERMINE_TOTAL_ONLINE () {
        // Count all users in surfbar modue and return the value
        $result = SQL_QUERY("SELECT

-       `id`
+       `stats_id`

 FROM
        `{?_MYSQL_PREFIX?}_surfbar_stats`
 WHERE
 FROM
        `{?_MYSQL_PREFIX?}_surfbar_stats`
 WHERE

-       (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`last_surfed`)) <= {?online_timeout?}
+       (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`stats_last_surfed`)) <= {?online_timeout?}

 GROUP BY
 GROUP BY

-       `userid` ASC", __FUNCTION__, __LINE__);
+       `stats_userid` ASC", __FUNCTION__, __LINE__);

 
        // Fetch count
        $cnt = SQL_NUMROWS($result);
 
        // Fetch count
        $cnt = SQL_NUMROWS($result);


@@ -1396,13 +1417,13 @@ function SURFBAR_GET_LOCK_IDS () {
        $ignored = array();
 
        // Get all id from locks within the timestamp
        $ignored = array();
 
        // Get all id from locks within the timestamp

-       $result = SQL_QUERY_ESC("SELECT `id`, `url_id`, UNIX_TIMESTAMP(`last_surfed`) AS last_surfed
+       $result = SQL_QUERY_ESC("SELECT `locks_id`, `locks_url_id`, UNIX_TIMESTAMP(`locks_last_surfed`) AS last_surfed

 FROM
        `{?_MYSQL_PREFIX?}_surfbar_locks`
 WHERE
 FROM
        `{?_MYSQL_PREFIX?}_surfbar_locks`
 WHERE

-       `userid`=%s
+       `locks_userid`=%s

 ORDER BY
 ORDER BY

-       `id` ASC", array(getMemberId()),
+       `locks_id` ASC", array(getMemberId()),

        __FUNCTION__, __LINE__);
 
        // Load all entries
        __FUNCTION__, __LINE__);
 
        // Load all entries


@@ -1446,24 +1467,24 @@ ORDER BY
 function SURFBAR_GET_MAX_RANDOM ($userids, $add) {
        // Count max availabe entries
        $result = SQL_QUERY("SELECT
 function SURFBAR_GET_MAX_RANDOM ($userids, $add) {
        // Count max availabe entries
        $result = SQL_QUERY("SELECT

-       sbu.id AS cnt
+       sbu.url_id AS cnt

 FROM
        `{?_MYSQL_PREFIX?}_surfbar_urls` AS sbu
 LEFT JOIN
        `{?_MYSQL_PREFIX?}_surfbar_salts` AS sbs
 ON
 FROM
        `{?_MYSQL_PREFIX?}_surfbar_urls` AS sbu
 LEFT JOIN
        `{?_MYSQL_PREFIX?}_surfbar_salts` AS sbs
 ON

-       sbu.id=sbs.url_id
+       sbu.url_id=sbs.salts_url_id

 LEFT JOIN
        `{?_MYSQL_PREFIX?}_surfbar_locks` AS l
 ON
 LEFT JOIN
        `{?_MYSQL_PREFIX?}_surfbar_locks` AS l
 ON

-       sbu.id=l.url_id
+       sbu.url_id=l.locks_url_id

 WHERE
 WHERE

-       sbu.userid NOT IN (".implode(',', $userids).") AND
-       (sbu.views_allowed=0 OR (sbu.views_allowed > 0 AND sbu.views_max > 0)) AND
-       sbu.`status`='ACTIVE'
+       sbu.url_userid NOT IN (".implode(',', $userids).") AND
+       (sbu.url_views_allowed=0 OR (sbu.url_views_allowed > 0 AND sbu.url_views_max > 0)) AND
+       sbu.url_status='ACTIVE'

        ".$add."
 GROUP BY
        ".$add."
 GROUP BY

-       sbu.id ASC", __FUNCTION__, __LINE__);
+       sbu.url_id ASC", __FUNCTION__, __LINE__);

 
        // Log last query
        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'lastQuery='.getConfig('db_last_query').'|numRows='.SQL_NUMROWS($result).'|Affected='.SQL_AFFECTEDROWS().'', false);
 
        // Log last query
        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'lastQuery='.getConfig('db_last_query').'|numRows='.SQL_NUMROWS($result).'|Affected='.SQL_AFFECTEDROWS().'', false);


@@ -1485,18 +1506,23 @@ function SURFBAR_GET_USER_URLS () {
 
        // Begin the query
        $result = SQL_QUERY_ESC("SELECT
 
        // Begin the query
        $result = SQL_QUERY_ESC("SELECT

-       u.id, u.userid, u.url, u.status,
-       u.views_total, u.views_max, u.views_allowed,
-       UNIX_TIMESTAMP(u.registered) AS url_registered,
-       UNIX_TIMESTAMP(u.last_locked) AS url_last_locked,
-       u.lock_reason AS lock_reason
+       u.url_id,
+       u.url_userid,
+       u.url,
+       u.url_status,
+       u.url_views_total,
+       u.url_views_max,
+       u.url_views_allowed,
+       UNIX_TIMESTAMP(u.url_registered) AS `url_registered`,
+       UNIX_TIMESTAMP(u.url_last_locked) AS `url_last_locked`,
+       u.url_lock_reason

 FROM
        `{?_MYSQL_PREFIX?}_surfbar_urls` AS u
 WHERE
 FROM
        `{?_MYSQL_PREFIX?}_surfbar_urls` AS u
 WHERE

-       u.userid=%s AND
-       u.status != 'DELETED'
+       u.url_userid=%s AND
+       u.url_status != 'DELETED'

 ORDER BY
 ORDER BY

-       u.id ASC",
+       u.url_id ASC",

        array(getMemberId()), __FUNCTION__, __LINE__);
 
        // Are there entries?
        array(getMemberId()), __FUNCTION__, __LINE__);
 
        // Are there entries?


@@ -1521,7 +1547,7 @@ function SURFBAR_GET_ARRAY_FROM_STATUS ($status) {
        $returnArray = array();
 
        // Get all assigned actions
        $returnArray = array();
 
        // Get all assigned actions

-       $result = SQL_QUERY_ESC("SELECT `action` FROM `{?_MYSQL_PREFIX?}_surfbar_actions` WHERE `status`='%s' ORDER BY `id` ASC",
+       $result = SQL_QUERY_ESC("SELECT `action` FROM `{?_MYSQL_PREFIX?}_surfbar_actions` WHERE `actions_status`='%s' ORDER BY `actions_id` ASC",

                array($status), __FUNCTION__, __LINE__);
 
        // Some entries there?
                array($status), __FUNCTION__, __LINE__);
 
        // Some entries there?


@@ -1568,7 +1594,7 @@ function SURFBAR_DETERMINE_NEXT_ID ($urlId = '0') {
                $add = '';
                if (count($USE) > 0) {
                        // Ignore some!
                $add = '';
                if (count($USE) > 0) {
                        // Ignore some!

-                       $add = " AND sbu.id NOT IN (";
+                       $add = " AND sbu.url_id NOT IN (";

                        foreach ($USE as $url_id => $lid) {
                                // Add URL id
                                $add .= $url_id.',';
                        foreach ($USE as $url_id => $lid) {
                                // Add URL id
                                $add .= $url_id.',';


@@ -1592,27 +1618,66 @@ function SURFBAR_DETERMINE_NEXT_ID ($urlId = '0') {
 
                // And query the database
                //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'randNum='.$randNum.',maxRand='.$maxRand.',surfLock='.SURFBAR_GET_SURF_LOCK().'', false);
 
                // And query the database
                //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'randNum='.$randNum.',maxRand='.$maxRand.',surfLock='.SURFBAR_GET_SURF_LOCK().'', false);

-               $result = SQL_QUERY_ESC("SELECT sbu.id, sbu.userid, sbu.url, sbs.last_salt, sbu.views_total, sbu.views_max, sbu.views_allowed, UNIX_TIMESTAMP(l.last_surfed) AS last_surfed, sbu.fixed_reload
-FROM `{?_MYSQL_PREFIX?}_surfbar_urls` AS sbu
-LEFT JOIN `{?_MYSQL_PREFIX?}_surfbar_salts` AS sbs
-ON sbu.id=sbs.url_id
-LEFT JOIN `{?_MYSQL_PREFIX?}_surfbar_locks` AS l
-ON sbu.id=l.url_id
-WHERE sbu.userid NOT IN (".implode(',', $userids['userid']).") AND sbu.`status`='ACTIVE' AND (sbu.views_allowed=0 OR (sbu.views_allowed > 0 AND sbu.views_max > 0))".$add."
-GROUP BY sbu.id
-ORDER BY l.last_surfed ASC, sbu.id ASC
+               $result = SQL_QUERY_ESC("SELECT
+       sbu.url_id,
+       sbu.url_userid,
+       sbu.url,
+       sbs.salts_last_salt,
+       sbu.url_views_total,
+       sbu.url_views_max,
+       sbu.url_views_allowed,
+       UNIX_TIMESTAMP(l.locks_last_surfed) AS last_surfed,
+       sbu.url_fixed_reload
+FROM
+       `{?_MYSQL_PREFIX?}_surfbar_urls` AS sbu
+LEFT JOIN
+       `{?_MYSQL_PREFIX?}_surfbar_salts` AS sbs
+ON
+       sbu.url_id=sbs.salts_url_id
+LEFT JOIN
+       `{?_MYSQL_PREFIX?}_surfbar_locks` AS l
+ON
+       sbu.url_id=l.locks_url_id
+WHERE
+       sbu.url_userid NOT IN (".implode(',', $userids['userid']).") AND
+       sbu.url_status='ACTIVE' AND
+       (sbu.url_views_allowed=0 OR (sbu.url_views_allowed > 0 AND sbu.url_views_max > 0))
+       ".$add."
+GROUP BY
+       sbu.url_id
+ORDER BY
+       l.locks_last_surfed ASC,
+       sbu.url_id ASC

 LIMIT %s,1",
                        array($randNum), __FUNCTION__, __LINE__
                );
        } else {
                // Get data from specified id number
 LIMIT %s,1",
                        array($randNum), __FUNCTION__, __LINE__
                );
        } else {
                // Get data from specified id number

-               $result = SQL_QUERY_ESC("SELECT sbu.id, sbu.userid, sbu.url, sbs.last_salt, sbu.views_total, sbu.views_max, sbu.views_allowed, UNIX_TIMESTAMP(l.last_surfed) AS last_surfed, sbu.fixed_reload
-FROM `{?_MYSQL_PREFIX?}_surfbar_urls` AS sbu
-LEFT JOIN `{?_MYSQL_PREFIX?}_surfbar_salts` AS sbs
-ON sbu.id=sbs.url_id
-LEFT JOIN `{?_MYSQL_PREFIX?}_surfbar_locks` AS l
-ON sbu.id=l.url_id
-WHERE sbu.userid != %s AND sbu.`status`='ACTIVE' AND sbu.id=%s AND (sbu.views_allowed=0 OR (sbu.views_allowed > 0 AND sbu.views_max > 0))
+               $result = SQL_QUERY_ESC("SELECT
+       sbu.url_id,
+       sbu.url_userid,
+       sbu.url,
+       sbs.salts_last_salt,
+       sbu.url_views_total,
+       sbu.url_views_max,
+       sbu.url_views_allowed,
+       UNIX_TIMESTAMP(l.locks_last_surfed) AS last_surfed,
+       sbu.url_fixed_reload
+FROM
+       `{?_MYSQL_PREFIX?}_surfbar_urls` AS sbu
+LEFT JOIN
+       `{?_MYSQL_PREFIX?}_surfbar_salts` AS sbs
+ON
+       sbu.url_id=sbs.salts_url_id
+LEFT JOIN
+       `{?_MYSQL_PREFIX?}_surfbar_locks` AS l
+ON
+       sbu.url_id=l.locks_url_id
+WHERE
+       sbu.url_userid != %s AND
+       sbu.url_status='ACTIVE' AND
+       sbu.url_id=%s AND
+       (sbu.url_views_allowed=0 OR (sbu.url_views_allowed > 0 AND sbu.url_views_max > 0))

 LIMIT 1",
                        array(getMemberId(), bigintval($urlId)), __FUNCTION__, __LINE__
                );
 LIMIT 1",
                        array(getMemberId(), bigintval($urlId)), __FUNCTION__, __LINE__
                );


@@ -1630,10 +1695,10 @@ LIMIT 1",
                $GLOBALS['surfbar_cache']['time'] = SURFBAR_DETERMINE_WAIT_TIME();
 
                // Is the last salt there?
                $GLOBALS['surfbar_cache']['time'] = SURFBAR_DETERMINE_WAIT_TIME();
 
                // Is the last salt there?

-               if (is_null($GLOBALS['surfbar_cache']['last_salt'])) {
+               if (is_null($GLOBALS['surfbar_cache']['salts_last_salt'])) {

                        // Then repair it wit the static!
                        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'last_salt - FIXED!', false);
                        // Then repair it wit the static!
                        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'last_salt - FIXED!', false);

-                       $GLOBALS['surfbar_cache']['last_salt'] = '';
+                       $GLOBALS['surfbar_cache']['salts_last_salt'] = '';

                } // END - if
 
                // Fix missing last_surfed
                } // END - if
 
                // Fix missing last_surfed


@@ -1729,13 +1794,13 @@ function SURFBAR_GET_SALT () {
 // Getter for id from cache
 function SURFBAR_GET_ID () {
        // Get data element and return its contents
 // Getter for id from cache
 function SURFBAR_GET_ID () {
        // Get data element and return its contents

-       return SURFBAR_GET_DATA('id');
+       return SURFBAR_GET_DATA('url_id');

 }
 
 // Getter for userid from cache
 function SURFBAR_GET_USERID () {
        // Get data element and return its contents
 }
 
 // Getter for userid from cache
 function SURFBAR_GET_USERID () {
        // Get data element and return its contents

-       return SURFBAR_GET_DATA('userid');
+       return SURFBAR_GET_DATA('url_userid');

 }
 
 // Getter for user reload locks
 }
 
 // Getter for user reload locks


@@ -1753,13 +1818,19 @@ function SURFBAR_GET_RELOAD_TIME () {
 // Getter for allowed views
 function SURFBAR_GET_VIEWS_ALLOWED () {
        // Get data element and return its contents
 // Getter for allowed views
 function SURFBAR_GET_VIEWS_ALLOWED () {
        // Get data element and return its contents

-       return SURFBAR_GET_DATA('views_allowed');
+       return SURFBAR_GET_DATA('url_views_allowed');
+}
+
+// Getter for maximum views
+function SURFBAR_GET_VIEWS_MAX () {
+       // Get data element and return its contents
+       return SURFBAR_GET_DATA('url_views_max');

 }
 
 // Getter for fixed reload
 function SURFBAR_GET_FIXED_RELOAD () {
        // Get data element and return its contents
 }
 
 // Getter for fixed reload
 function SURFBAR_GET_FIXED_RELOAD () {
        // Get data element and return its contents

-       return SURFBAR_GET_DATA('fixed_reload');
+       return SURFBAR_GET_DATA('url_fixed_reload');

 }
 
 // Getter for surf lock
 }
 
 // Getter for surf lock

diff --git a/inc/libs/task_functions.php b/inc/libs/task_functions.php
index cf56f78df15feaf1662e2fbab18ad07efeff6956..c6c61aafd10cacce9df151b4b7f768d17c67ebb2 100644 (file)
--- a/inc/libs/task_functions.php
+++ b/inc/libs/task_functions.php
@@ -524,13 +524,13 @@ ORDER BY
 
        if (isExtensionActive('surfbar')) {
                // List all URLs in surfbar
 
        if (isExtensionActive('surfbar')) {
                // List all URLs in surfbar

-               addSql("SELECT `id` FROM `{?_MYSQL_PREFIX?}_surfbar_urls` ORDER BY `id` ASC");
+               addSql("SELECT `url_id` FROM `{?_MYSQL_PREFIX?}_surfbar_urls` ORDER BY `url_id` ASC");

                $WHATs[]  = 'list_surfbar_urls';
                $DESCRs[] = getMessage('ADMIN_TASK_LIST_SURFBAR_URLS_ALL');
                $TITLEs[] = getMessage('ADMIN_TASK_LIST_SURFBAR_URLS_ALL_TITLE');
 
                // List all pending URLs in surfbar
                $WHATs[]  = 'list_surfbar_urls';
                $DESCRs[] = getMessage('ADMIN_TASK_LIST_SURFBAR_URLS_ALL');
                $TITLEs[] = getMessage('ADMIN_TASK_LIST_SURFBAR_URLS_ALL_TITLE');
 
                // List all pending URLs in surfbar

-               addSql("SELECT `id` FROM `{?_MYSQL_PREFIX?}_surfbar_urls` WHERE `status`='PENDING' ORDER BY `id` ASC");
+               addSql("SELECT `url_id` FROM `{?_MYSQL_PREFIX?}_surfbar_urls` WHERE `url_status`='PENDING' ORDER BY `url_id` ASC");

                $WHATs[]  = 'unlock_surfbar_urls';
                $DESCRs[] = getMessage('ADMIN_TASK_LIST_SURFBAR_URLS_PENDING');
                $TITLEs[] = getMessage('ADMIN_TASK_LIST_SURFBAR_URLS_PENDING_TITLE');
                $WHATs[]  = 'unlock_surfbar_urls';
                $DESCRs[] = getMessage('ADMIN_TASK_LIST_SURFBAR_URLS_PENDING');
                $TITLEs[] = getMessage('ADMIN_TASK_LIST_SURFBAR_URLS_PENDING_TITLE');

diff --git a/inc/modules/admin/what-list_surfbar_actions.php b/inc/modules/admin/what-list_surfbar_actions.php
index 4a358ca1c0211c3c5e89a36a9ae7618b62a3efe1..4d36b16d4e65d6b8c40d479c5ce75b7e3f4eaf70 100644 (file)
--- a/inc/modules/admin/what-list_surfbar_actions.php
+++ b/inc/modules/admin/what-list_surfbar_actions.php
@@ -47,12 +47,15 @@ addMenuDescription('admin', __FILE__);
 
 // Load all actions
 $result = SQL_QUERY("SELECT
 
 // Load all actions
 $result = SQL_QUERY("SELECT

-       `id`, `status`, `action`, `new_status`
+       `actions_id`,
+       `actions_status`,
+       `actions_action`,
+       `actions_new_status`

 FROM
        `{?_MYSQL_PREFIX?}_surfbar_actions`
 ORDER BY
 FROM
        `{?_MYSQL_PREFIX?}_surfbar_actions`
 ORDER BY

-       `status` ASC,
-       `action` ASC", __FILE__, __LINE__);
+       `actions_status` ASC,
+       `actions_action` ASC", __FILE__, __LINE__);

 
 // Entries found?
 if (SQL_NUMROWS($result) > 0) {
 
 // Entries found?
 if (SQL_NUMROWS($result) > 0) {


@@ -60,16 +63,16 @@ if (SQL_NUMROWS($result) > 0) {
        $OUT = ''; $SW = 2;
        while ($content = SQL_FETCHARRAY($result)) {
                // "Translate" some data
        $OUT = ''; $SW = 2;
        while ($content = SQL_FETCHARRAY($result)) {
                // "Translate" some data

-               $content['status']     = translateSurfbarUrlStatus($content['status']);
-               $content['action']     = getMessage(sprintf("MEMBER_SURFBAR_ACTION_%s_SUBMIT", $content['action']));
+               $content['actions_status'] = translateSurfbarUrlStatus($content['actions_status']);
+               $content['actions_action'] = getMessage(sprintf("MEMBER_SURFBAR_ACTION_%s_SUBMIT", $content['actions_action']));

 
                // New status set?
 
                // New status set?

-               if (!is_null($content['new_status'])) {
+               if (!is_null($content['actions_new_status'])) {

                        // Translate it
                        // Translate it

-                       $content['new_status'] = translateSurfbarUrlStatus($content['new_status']);
+                       $content['actions_new_status'] = translateSurfbarUrlStatus($content['actions_new_status']);

                } else {
                        // "Do nothing" status
                } else {
                        // "Do nothing" status

-                       $content['new_status'] = getMessage('SURFBAR_URL_STATUS_NONE');
+                       $content['actions_new_status'] = getMessage('SURFBAR_URL_STATUS_NONE');

                }
 
                // Add color
                }
 
                // Add color

diff --git a/inc/modules/admin/what-list_surfbar_urls.php b/inc/modules/admin/what-list_surfbar_urls.php
index e9964c13cca376b7923a7fb451a2c83201c695fe..9afddf7f6a692df3454abfd5ed497f27076c7f40 100644 (file)
--- a/inc/modules/admin/what-list_surfbar_urls.php
+++ b/inc/modules/admin/what-list_surfbar_urls.php
@@ -140,14 +140,14 @@ if ($show === false) return false;
 
 // List all URLs
 $result = SQL_QUERY("SELECT
 
 // List all URLs
 $result = SQL_QUERY("SELECT

-       `id`, `userid`, `url`, `views_total`, `status` AS `url_status`,
-       UNIX_TIMESTAMP(`registered`) AS url_registered,
-       UNIX_TIMESTAMP(`last_locked`) AS url_last_locked,
-       `lock_reason`
+       `url_id`, `url_userid`, `url`, `url_views_total`, `url_status`,
+       UNIX_TIMESTAMP(`url_registered`) AS `url_registered`,
+       UNIX_TIMESTAMP(`url_last_locked`) AS `url_last_locked`,
+       `url_lock_reason`

 FROM
        `{?_MYSQL_PREFIX?}_surfbar_urls`
 ORDER BY
 FROM
        `{?_MYSQL_PREFIX?}_surfbar_urls`
 ORDER BY

-       `id` ASC", __FILE__, __LINE__);
+       `url_id` ASC", __FILE__, __LINE__);

 
 // Do we have some URLs left?
 if (SQL_NUMROWS($result) > 0) {
 
 // Do we have some URLs left?
 if (SQL_NUMROWS($result) > 0) {


@@ -156,9 +156,9 @@ if (SQL_NUMROWS($result) > 0) {
        while ($content = SQL_FETCHARRAY($result)) {
                // "Translate"/add content
                $content['sw']              = $SW;
        while ($content = SQL_FETCHARRAY($result)) {
                // "Translate"/add content
                $content['sw']              = $SW;

-               $content['userid']          = generateUserProfileLink($content['userid']);
+               $content['url_userid']      = generateUserProfileLink($content['url_userid']);

                $content['url']             = generateFrametesterUrl($content['url']);
                $content['url']             = generateFrametesterUrl($content['url']);

-               $content['views_total']     = translateComma($content['views_total']);
+               $content['views_total']     = translateComma($content['url_views_total']);

                $content['url_status']      = translateSurfbarUrlStatus($content['url_status']);
                $content['url_registered']  = generateDateTime($content['url_registered'], 2);
                $content['url_last_locked'] = generateDateTime($content['url_last_locked'], 2);
                $content['url_status']      = translateSurfbarUrlStatus($content['url_status']);
                $content['url_registered']  = generateDateTime($content['url_registered'], 2);
                $content['url_last_locked'] = generateDateTime($content['url_last_locked'], 2);

diff --git a/inc/modules/admin/what-surfbar_stats.php b/inc/modules/admin/what-surfbar_stats.php
index 58fabb982b1956e7759d9dc20f15b18bc809e437..54ff5df476f48c92f282f3778132f8dd43861973 100644 (file)
--- a/inc/modules/admin/what-surfbar_stats.php
+++ b/inc/modules/admin/what-surfbar_stats.php
@@ -48,11 +48,17 @@ addMenuDescription('admin', __FILE__);
 // Is the 'url_id' set?
 if (isGetRequestParameterSet(('url_id'))) {
        // Generate general statistics
 // Is the 'url_id' set?
 if (isGetRequestParameterSet(('url_id'))) {
        // Generate general statistics

-       $result = SQL_QUERY_ESC("SELECT `userid`,`count` AS `total_visits`, UNIX_TIMESTAMP(`last_surfed`) AS `last_surfed`
-FROM `{?_MYSQL_PREFIX?}_surfbar_stats`
-WHERE `url_id`=%s
-ORDER BY `userid` ASC",
-       array(bigintval(getRequestParameter('url_id'))), __FILE__, __LINE__);
+       $result = SQL_QUERY_ESC("SELECT
+       `stats_userid`,
+       `stats_count` AS `total_visits`,
+       UNIX_TIMESTAMP(`stats_last_surfed`) AS `last_surfed`
+FROM
+       `{?_MYSQL_PREFIX?}_surfbar_stats`
+WHERE
+       `stats_url_id`=%s
+ORDER BY
+       `stats_userid` ASC",
+               array(bigintval(getRequestParameter('url_id'))), __FILE__, __LINE__);

 
        // Entries found?
        if (SQL_NUMROWS($result) > 0) {
 
        // Entries found?
        if (SQL_NUMROWS($result) > 0) {


@@ -63,7 +69,7 @@ ORDER BY `userid` ASC",
                        $visits += $content['total_visits'];
 
                        // "Translate" some data
                        $visits += $content['total_visits'];
 
                        // "Translate" some data

-                       $content['userid']       = generateUserProfileLink($content['userid']);
+                       $content['stats_userid'] = generateUserProfileLink($content['stats_userid']);

                        $content['total_visits'] = translateComma($content['total_visits']);
                        $content['last_surfed']  = generateDateTime($content['last_surfed'], 2);
                        $content['sw']           = $SW;
                        $content['total_visits'] = translateComma($content['total_visits']);
                        $content['last_surfed']  = generateDateTime($content['last_surfed'], 2);
                        $content['sw']           = $SW;


@@ -90,13 +96,15 @@ ORDER BY `userid` ASC",
 } else {
        // Generate general statistics
        $result = SQL_QUERY("SELECT
 } else {
        // Generate general statistics
        $result = SQL_QUERY("SELECT

-       `userid`, COUNT(`url_id`) AS `visited_urls`, SUM(`count`) AS `total_visits`
+       `stats_userid`,
+       COUNT(`stats_url_id`) AS `visited_urls`,
+       SUM(`stats_count`) AS `total_visits`

 FROM
        `{?_MYSQL_PREFIX?}_surfbar_stats`
 GROUP BY
 FROM
        `{?_MYSQL_PREFIX?}_surfbar_stats`
 GROUP BY

-       `userid`
+       `stats_userid`

 ORDER BY
 ORDER BY

-       `userid` ASC", __FILE__, __LINE__);
+       `stats_userid` ASC", __FILE__, __LINE__);

 
        // Entries found?
        if (SQL_NUMROWS($result) > 0) {
 
        // Entries found?
        if (SQL_NUMROWS($result) > 0) {


@@ -108,7 +116,8 @@ ORDER BY
                        $visits += $content['total_visits'];
 
                        // "Translate" some data
                        $visits += $content['total_visits'];
 
                        // "Translate" some data

-                       $content['userid']       = generateUserProfileLink($content['userid']);
+                       // @TODO Can't all these translation blocks moved into templates? This code looks ugly.
+                       $content['stats_userid'] = generateUserProfileLink($content['stats_userid']);

                        $content['visited_urls'] = translateComma($content['visited_urls']);
                        $content['total_visits'] = translateComma($content['total_visits']);
                        $content['sw']           = $SW;
                        $content['visited_urls'] = translateComma($content['visited_urls']);
                        $content['total_visits'] = translateComma($content['total_visits']);
                        $content['sw']           = $SW;

diff --git a/inc/modules/admin/what-unlock_surfbar_urls.php b/inc/modules/admin/what-unlock_surfbar_urls.php
index 32a6624c27812debad57480315085b2b0f619554..dbde6a592609de698c3b6b9b9badda27bd9af577 100644 (file)
--- a/inc/modules/admin/what-unlock_surfbar_urls.php
+++ b/inc/modules/admin/what-unlock_surfbar_urls.php
@@ -68,13 +68,16 @@ if ((isPostRequestParameterSet('unlock')) && (is_array(postRequestParameter('id'
 
 // List all URLs
 $result = SQL_QUERY("SELECT
 
 // List all URLs
 $result = SQL_QUERY("SELECT

-       `id`, `userid`, `url`, UNIX_TIMESTAMP(`registered`) AS url_registered
+       `url_id`,
+       `url_userid`,
+       `url`,
+       UNIX_TIMESTAMP(`url_registered`) AS `url_registered`

 FROM
        `{?_MYSQL_PREFIX?}_surfbar_urls`
 WHERE
 FROM
        `{?_MYSQL_PREFIX?}_surfbar_urls`
 WHERE

-       `status`='PENDING'
+       `url_status`='PENDING'

 ORDER BY
 ORDER BY

-       `id` ASC", __FILE__, __LINE__);
+       `url_id` ASC", __FILE__, __LINE__);

 
 // Do we have some URLs left?
 if (SQL_NUMROWS($result) > 0) {
 
 // Do we have some URLs left?
 if (SQL_NUMROWS($result) > 0) {

diff --git a/surfbar.php b/surfbar.php
index 69a3e241e76950f9cc0cd56dd3a9443ee3eee69a..fb6a5dd02c7fdf057c51c92b7569a88e662047ba 100644 (file)
--- a/surfbar.php
+++ b/surfbar.php
@@ -201,7 +201,7 @@ if ((SURFBAR_CHECK_RELOAD_FULL()) || ((isGetRequestParameterSet('frame')) && (in
                if ($nextId > 0) {
                        // Then prepare other content
                        $content = array(
                if ($nextId > 0) {
                        // Then prepare other content
                        $content = array(

-                               'id'          => $nextId,
+                               'url_id'      => $nextId,

                                'check'       => SURFBAR_GENERATE_VALIDATION_CODE($nextId),
                                'salt'        => SURFBAR_GET_SALT(),
                                'reward'      => translateComma(SURFBAR_GET_REWARD($nextId)),
                                'check'       => SURFBAR_GENERATE_VALIDATION_CODE($nextId),
                                'salt'        => SURFBAR_GET_SALT(),
                                'reward'      => translateComma(SURFBAR_GET_REWARD($nextId)),

diff --git a/templates/de/emails/admin/admin_del_surfbar_urls.tpl b/templates/de/emails/admin/admin_del_surfbar_urls.tpl
index b4736c8efe8b3a71ecdbb6d47a490271e06603d3..98ddba136681d6b6acc2ee3ae4b8d2dc36281918 100644 (file)
--- a/templates/de/emails/admin/admin_del_surfbar_urls.tpl
+++ b/templates/de/emails/admin/admin_del_surfbar_urls.tpl
@@ -18,7 +18,7 @@ Zuletzt gesperrt: $content[url_last_locked]
 ------------------------------------------
 Sperrgrund: $content[lock_reason]
 ------------------------------------------
 ------------------------------------------
 Sperrgrund: $content[lock_reason]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 
 Mit freundlichen Grüßen,
 ------------------------------------------
 
 Mit freundlichen Grüßen,

diff --git a/templates/de/emails/admin/admin_edit_surfbar_urls.tpl b/templates/de/emails/admin/admin_edit_surfbar_urls.tpl
index 674cf655fbdb839be484ad8833e4a37d5c5107e5..0555c8e123171041e7cacbac5d1348f24bba5758 100644 (file)
--- a/templates/de/emails/admin/admin_edit_surfbar_urls.tpl
+++ b/templates/de/emails/admin/admin_edit_surfbar_urls.tpl
@@ -15,7 +15,7 @@ Neue Mitglieder-Id: $content[userid]
 ------------------------------------------
 Angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 Angemeldet: $content[url_registered]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 
 Mit freundlichen Grüßen,
 ------------------------------------------
 
 Mit freundlichen Grüßen,

diff --git a/templates/de/emails/admin/admin_lock_active_surfbar_urls.tpl b/templates/de/emails/admin/admin_lock_active_surfbar_urls.tpl
index e49b3adb65fb2338874ed6a3a65b255a5a72d8e0..4224fedfe43b2cc419ae3a5c7c2325a70d8f2dc1 100644 (file)
--- a/templates/de/emails/admin/admin_lock_active_surfbar_urls.tpl
+++ b/templates/de/emails/admin/admin_lock_active_surfbar_urls.tpl
@@ -17,7 +17,7 @@ Letzte Sperrung: $content[url_last_locked]
 ------------------------------------------
 Angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 Angemeldet: $content[url_registered]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 
 Mit freundlichen Grüßen,
 ------------------------------------------
 
 Mit freundlichen Grüßen,

diff --git a/templates/de/emails/admin/admin_lock_locked_surfbar_urls.tpl b/templates/de/emails/admin/admin_lock_locked_surfbar_urls.tpl
index 8fdbb115a86281dc42b59e1e6061d945a12e2b9b..2415c6eda2d0598429e6f8f297cd7cffdba991b5 100644 (file)
--- a/templates/de/emails/admin/admin_lock_locked_surfbar_urls.tpl
+++ b/templates/de/emails/admin/admin_lock_locked_surfbar_urls.tpl
@@ -17,7 +17,7 @@ Letzte Sperrung: $content[url_last_locked]
 ------------------------------------------
 Angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 Angemeldet: $content[url_registered]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 
 Mit freundlichen Grüßen,
 ------------------------------------------
 
 Mit freundlichen Grüßen,

diff --git a/templates/de/emails/admin/admin_surfbar_url_active_deleted.tpl b/templates/de/emails/admin/admin_surfbar_url_active_deleted.tpl
index bbea0cec55324939e5f7e8da94bd2093a191049c..c45d95b9af34ef2779625782b5df397428763421 100644 (file)
--- a/templates/de/emails/admin/admin_surfbar_url_active_deleted.tpl
+++ b/templates/de/emails/admin/admin_surfbar_url_active_deleted.tpl
@@ -12,7 +12,7 @@ Name: {%user,surname=$userid%} {%user,family=$userid%}
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------


@@ -29,8 +29,6 @@ Vergütung/Aufruf: $content[reward] {?POINTS?}
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------

-ID in der Surfbar: $content[id]
-------------------------------------------

 
 Mit freundlichen Grüßen,
   Ihr {?MAIN_TITLE?} Script
 
 Mit freundlichen Grüßen,
   Ihr {?MAIN_TITLE?} Script

diff --git a/templates/de/emails/admin/admin_surfbar_url_active_pending.tpl b/templates/de/emails/admin/admin_surfbar_url_active_pending.tpl
index 1755637edcbcb8c4eeafe5fa851eda5116adac94..fd1e121d29654bcdbb6b11160b271b1da460f834 100644 (file)
--- a/templates/de/emails/admin/admin_surfbar_url_active_pending.tpl
+++ b/templates/de/emails/admin/admin_surfbar_url_active_pending.tpl
@@ -12,7 +12,7 @@ Name: {%user,surname=$userid%} {%user,family=$userid%}
 ------------------------------------------
 Gebuchte URL: $content[url] (Neu: $content[edit][url])
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url] (Neu: $content[edit][url])
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/admin/admin_surfbar_url_active_stopped.tpl b/templates/de/emails/admin/admin_surfbar_url_active_stopped.tpl
index f1df37478bb927de212149bd5058d4e0ff903788..c6ffff707b3bff40e1c0bb1170f5253f6a75971e 100644 (file)
--- a/templates/de/emails/admin/admin_surfbar_url_active_stopped.tpl
+++ b/templates/de/emails/admin/admin_surfbar_url_active_stopped.tpl
@@ -12,7 +12,7 @@ Name: {%user,surname=$userid%} {%user,family=$userid%}
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/admin/admin_surfbar_url_confirmed.tpl b/templates/de/emails/admin/admin_surfbar_url_confirmed.tpl
index 67063eb72a96161e56026cc9f778ca7b68e39dff..d42f7a7310d17c484a1fcfb56af1bf3b2ad42af4 100644 (file)
--- a/templates/de/emails/admin/admin_surfbar_url_confirmed.tpl
+++ b/templates/de/emails/admin/admin_surfbar_url_confirmed.tpl
@@ -15,7 +15,7 @@ Angemeldet: $content[url_registered]
 ------------------------------------------
 Status: $content[url_status]
 ------------------------------------------
 ------------------------------------------
 Status: $content[url_status]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 
 Mit freundlichen Grüßen,
 ------------------------------------------
 
 Mit freundlichen Grüßen,

diff --git a/templates/de/emails/admin/admin_surfbar_url_depleted.tpl b/templates/de/emails/admin/admin_surfbar_url_depleted.tpl
index 7ffda238fe6b21d427bbca640a0694b8d360eb19..48aefe3456fe5e3e7b610fd76321dddc44f3fd8f 100644 (file)
--- a/templates/de/emails/admin/admin_surfbar_url_depleted.tpl
+++ b/templates/de/emails/admin/admin_surfbar_url_depleted.tpl
@@ -25,7 +25,7 @@ Vergütung/Aufruf: $content[reward] {?POINTS?}
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 
 Mit freundlichen Grüßen,
 ------------------------------------------
 
 Mit freundlichen Grüßen,

diff --git a/templates/de/emails/admin/admin_surfbar_url_locked_deleted.tpl b/templates/de/emails/admin/admin_surfbar_url_locked_deleted.tpl
index 84f42741f7cd7550ad666ceb360c56af2a53d331..c9b8eadf54b4bf1cb86a88f928edf512522ec0ae 100644 (file)
--- a/templates/de/emails/admin/admin_surfbar_url_locked_deleted.tpl
+++ b/templates/de/emails/admin/admin_surfbar_url_locked_deleted.tpl
@@ -12,7 +12,7 @@ Name: {%user,surname=$userid%} {%user,family=$userid%}
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------


@@ -33,8 +33,6 @@ Vergütung/Aufruf: $content[reward] {?POINTS?}
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------

-ID in der Surfbar: $content[id]
-------------------------------------------

 
 Mit freundlichen Grüßen,
   Ihr {?MAIN_TITLE?} Script
 
 Mit freundlichen Grüßen,
   Ihr {?MAIN_TITLE?} Script

diff --git a/templates/de/emails/admin/admin_surfbar_url_locked_pending.tpl b/templates/de/emails/admin/admin_surfbar_url_locked_pending.tpl
index e1a5294d59d45c819a90aa8e1777837a64e3b9c3..fe91558237d1f37e85c8144c5aa70b1c5f3989f0 100644 (file)
--- a/templates/de/emails/admin/admin_surfbar_url_locked_pending.tpl
+++ b/templates/de/emails/admin/admin_surfbar_url_locked_pending.tpl
@@ -12,7 +12,7 @@ Name: {%user,surname=$userid%} {%user,family=$userid%}
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/admin/admin_surfbar_url_migrated_deleted.tpl b/templates/de/emails/admin/admin_surfbar_url_migrated_deleted.tpl
index a3e5bb72a240c9e03bbaa0bd1eddbe2b9ac596aa..ce03b4d33269b181197c2e00788f6630bfae25dd 100644 (file)
--- a/templates/de/emails/admin/admin_surfbar_url_migrated_deleted.tpl
+++ b/templates/de/emails/admin/admin_surfbar_url_migrated_deleted.tpl
@@ -12,7 +12,7 @@ Name: {%user,surname=$userid%} {%user,family=$userid%}
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/admin/admin_surfbar_url_migrated_migrated.tpl b/templates/de/emails/admin/admin_surfbar_url_migrated_migrated.tpl
index d64635c393b39f4536326d50f54b6ce882106c68..1d26684b07f1728cdd5c71b2a4b52f8d1b4451ce 100644 (file)
--- a/templates/de/emails/admin/admin_surfbar_url_migrated_migrated.tpl
+++ b/templates/de/emails/admin/admin_surfbar_url_migrated_migrated.tpl
@@ -12,7 +12,7 @@ Name: {%user,surname=$userid%} {%user,family=$userid%}
 ------------------------------------------
 Gebuchte URL: $content[url] (Neu: $content[edit][url])
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url] (Neu: $content[edit][url])
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/admin/admin_surfbar_url_migrated_pending.tpl b/templates/de/emails/admin/admin_surfbar_url_migrated_pending.tpl
index c92846fffd3e812d7e350a97edd2d059b370a61d..2eab14288f6626effac18917ba78354d7c634fa3 100644 (file)
--- a/templates/de/emails/admin/admin_surfbar_url_migrated_pending.tpl
+++ b/templates/de/emails/admin/admin_surfbar_url_migrated_pending.tpl
@@ -12,7 +12,7 @@ Name: {%user,surname=$userid%} {%user,family=$userid%}
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/admin/admin_surfbar_url_pending.tpl b/templates/de/emails/admin/admin_surfbar_url_pending.tpl
index b12b4354301788987738a9f3ec3baa92f90cfe93..289be22cc3b1867dce2e9f39af347e44a9fe6ddc 100644 (file)
--- a/templates/de/emails/admin/admin_surfbar_url_pending.tpl
+++ b/templates/de/emails/admin/admin_surfbar_url_pending.tpl
@@ -21,7 +21,7 @@ Vergütung/Aufruf: $content[reward] {?POINTS?}
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 
 Mit freundlichen Grüßen,
 ------------------------------------------
 
 Mit freundlichen Grüßen,

diff --git a/templates/de/emails/admin/admin_surfbar_url_pending_active.tpl b/templates/de/emails/admin/admin_surfbar_url_pending_active.tpl
index a58344f612e90b172e68e18f8ed63d7044e39e94..bdc1d94bb69eb659d6600b1ec9bf0290b022c1d4 100644 (file)
--- a/templates/de/emails/admin/admin_surfbar_url_pending_active.tpl
+++ b/templates/de/emails/admin/admin_surfbar_url_pending_active.tpl
@@ -12,7 +12,7 @@ Name: {%user,surname=$userid%} {%user,family=$userid%}
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------


@@ -29,8 +29,6 @@ Vergütung/Aufruf: $content[reward] {?POINTS?}
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------

-ID in der Surfbar: $content[id]
-------------------------------------------

 
 Mit freundlichen Grüßen,
   Ihr {?MAIN_TITLE?} Script
 
 Mit freundlichen Grüßen,
   Ihr {?MAIN_TITLE?} Script

diff --git a/templates/de/emails/admin/admin_surfbar_url_pending_deleted.tpl b/templates/de/emails/admin/admin_surfbar_url_pending_deleted.tpl
index ffe2c5d734c85c81a650d945cd6208451c9723c6..c34989b4c720d22741e50eadd43d308676dfa022 100644 (file)
--- a/templates/de/emails/admin/admin_surfbar_url_pending_deleted.tpl
+++ b/templates/de/emails/admin/admin_surfbar_url_pending_deleted.tpl
@@ -12,7 +12,7 @@ Name: {%user,surname=$userid%} {%user,family=$userid%}
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------


@@ -29,8 +29,6 @@ Vergütung/Aufruf: $content[reward] {?POINTS?}
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------

-ID in der Surfbar: $content[id]
-------------------------------------------

 
 Mit freundlichen Grüßen,
   Ihr {?MAIN_TITLE?} Script
 
 Mit freundlichen Grüßen,
   Ihr {?MAIN_TITLE?} Script

diff --git a/templates/de/emails/admin/admin_surfbar_url_pending_rejected.tpl b/templates/de/emails/admin/admin_surfbar_url_pending_rejected.tpl
index 90b5c1f988e346f70b319773f7f287c938b8082c..f760cead5cf6b1660d746ec698301489a3e28776 100644 (file)
--- a/templates/de/emails/admin/admin_surfbar_url_pending_rejected.tpl
+++ b/templates/de/emails/admin/admin_surfbar_url_pending_rejected.tpl
@@ -12,7 +12,7 @@ Name: {%user,surname=$userid%} {%user,family=$userid%}
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------


@@ -29,8 +29,6 @@ Vergütung/Aufruf: $content[reward] {?POINTS?}
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------

-ID in der Surfbar: $content[id]
-------------------------------------------

 
 Mit freundlichen Grüßen,
   Ihr {?MAIN_TITLE?} Script
 
 Mit freundlichen Grüßen,
   Ihr {?MAIN_TITLE?} Script

diff --git a/templates/de/emails/admin/admin_surfbar_url_rejected.tpl b/templates/de/emails/admin/admin_surfbar_url_rejected.tpl
index ed6cf86ed0961dd1c4221033486d4bae1b4cd974..69be42d28c01fba874eb581cac906d1e44bc8de5 100644 (file)
--- a/templates/de/emails/admin/admin_surfbar_url_rejected.tpl
+++ b/templates/de/emails/admin/admin_surfbar_url_rejected.tpl
@@ -15,7 +15,7 @@ Angemeldet: $content[url_registered]
 ------------------------------------------
 Status: $content[url_status]
 ------------------------------------------
 ------------------------------------------
 Status: $content[url_status]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 
 Mit freundlichen Grüßen,
 ------------------------------------------
 
 Mit freundlichen Grüßen,

diff --git a/templates/de/emails/admin/admin_surfbar_url_stopped_continued.tpl b/templates/de/emails/admin/admin_surfbar_url_stopped_continued.tpl
index b4ffaa06e455cf1d368eee8a9153f24ae5455198..74f6dd89d936a1d9d5e6d0165cb0f367a76344dc 100644 (file)
--- a/templates/de/emails/admin/admin_surfbar_url_stopped_continued.tpl
+++ b/templates/de/emails/admin/admin_surfbar_url_stopped_continued.tpl
@@ -12,7 +12,7 @@ Name: {%user,surname=$userid%} {%user,family=$userid%}
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/admin/admin_surfbar_url_stopped_deleted.tpl b/templates/de/emails/admin/admin_surfbar_url_stopped_deleted.tpl
index d0df013035327508cbfc82c77790bf5b61a3f2de..f6ab6fc6ff528dc97a7345655f1eff2c49499085 100644 (file)
--- a/templates/de/emails/admin/admin_surfbar_url_stopped_deleted.tpl
+++ b/templates/de/emails/admin/admin_surfbar_url_stopped_deleted.tpl
@@ -12,7 +12,7 @@ Name: {%user,surname=$userid%} {%user,family=$userid%}
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------


@@ -29,8 +29,6 @@ Vergütung/Aufruf: $content[reward] {?POINTS?}
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------

-ID in der Surfbar: $content[id]
-------------------------------------------

 
 Mit freundlichen Grüßen,
   Ihr {?MAIN_TITLE?} Script
 
 Mit freundlichen Grüßen,
   Ihr {?MAIN_TITLE?} Script

diff --git a/templates/de/emails/admin/admin_surfbar_url_stopped_pending.tpl b/templates/de/emails/admin/admin_surfbar_url_stopped_pending.tpl
index 6a2c1924ddf0a6101a43c549464fa12817d9f808..f149f0e3b6edcf559a77403709adc2a8f4c56e8f 100644 (file)
--- a/templates/de/emails/admin/admin_surfbar_url_stopped_pending.tpl
+++ b/templates/de/emails/admin/admin_surfbar_url_stopped_pending.tpl
@@ -12,7 +12,7 @@ Name: {%user,surname=$userid%} {%user,family=$userid%}
 ------------------------------------------
 Gebuchte URL: $content[url] (Neu: $content[edit][url])
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url] (Neu: $content[edit][url])
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/admin/admin_undelete_active_surfbar_urls.tpl b/templates/de/emails/admin/admin_undelete_active_surfbar_urls.tpl
index 8e064ce0604a92497ff96e25f69b57274e289b8a..476da80c6252ee35e779434ad698cee3c9474558 100644 (file)
--- a/templates/de/emails/admin/admin_undelete_active_surfbar_urls.tpl
+++ b/templates/de/emails/admin/admin_undelete_active_surfbar_urls.tpl
@@ -17,7 +17,7 @@ Letzte Sperrung: $content[url_last_locked]
 ------------------------------------------
 Angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 Angemeldet: $content[url_registered]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 
 Mit freundlichen Grüßen,
 ------------------------------------------
 
 Mit freundlichen Grüßen,

diff --git a/templates/de/emails/member/member_del_surfbar_urls.tpl b/templates/de/emails/member/member_del_surfbar_urls.tpl
index 95dc88544c421bcf573b05e2b5dd6b2e2c65eb4a..f33c843e0e3480bf7547040903395a6a9016ff7e 100644 (file)
--- a/templates/de/emails/member/member_del_surfbar_urls.tpl
+++ b/templates/de/emails/member/member_del_surfbar_urls.tpl
@@ -12,7 +12,7 @@ Aufrufe gesamt: $content[views_total]
 ------------------------------------------
 Angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 Angemeldet: $content[url_registered]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 
 Mit freundlichen Grüßen,
 ------------------------------------------
 
 Mit freundlichen Grüßen,

diff --git a/templates/de/emails/member/member_edit_surfbar_urls.tpl b/templates/de/emails/member/member_edit_surfbar_urls.tpl
index 553d56acee518f376a143447366eabcda2daea02..557b50046b2064945874db96a6637c7d53c736af 100644 (file)
--- a/templates/de/emails/member/member_edit_surfbar_urls.tpl
+++ b/templates/de/emails/member/member_edit_surfbar_urls.tpl
@@ -12,7 +12,7 @@ Angemeldet: $content[url_registered]
 ------------------------------------------
 Ihre Mitglieder-Id: $content[userid]
 ------------------------------------------
 ------------------------------------------
 Ihre Mitglieder-Id: $content[userid]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 
 Mit freundlichen Grüßen,
 ------------------------------------------
 
 Mit freundlichen Grüßen,

diff --git a/templates/de/emails/member/member_lock_active_surfbar_urls.tpl b/templates/de/emails/member/member_lock_active_surfbar_urls.tpl
index 7247429eb96d2e6081941da4635396e92e4ccde7..ef2eceafef6968a10c017093c4177242d674a0b8 100644 (file)
--- a/templates/de/emails/member/member_lock_active_surfbar_urls.tpl
+++ b/templates/de/emails/member/member_lock_active_surfbar_urls.tpl
@@ -10,7 +10,7 @@ Angemeldet: $content[url_registered]
 ------------------------------------------
 Ihre Mitglieder-Id: $content[userid]
 ------------------------------------------
 ------------------------------------------
 Ihre Mitglieder-Id: $content[userid]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 
 Mit freundlichen Grüßen,
 ------------------------------------------
 
 Mit freundlichen Grüßen,

diff --git a/templates/de/emails/member/member_lock_locked_surfbar_urls.tpl b/templates/de/emails/member/member_lock_locked_surfbar_urls.tpl
index d8b47a0558665563ecb3d6da48298dece16908db..331522d346ef16de3d98b33d3e5a4c0999691cea 100644 (file)
--- a/templates/de/emails/member/member_lock_locked_surfbar_urls.tpl
+++ b/templates/de/emails/member/member_lock_locked_surfbar_urls.tpl
@@ -12,7 +12,7 @@ Angemeldet: $content[url_registered]
 ------------------------------------------
 Ihre Mitglieder-Id: $content[userid]
 ------------------------------------------
 ------------------------------------------
 Ihre Mitglieder-Id: $content[userid]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 
 Mit freundlichen Grüßen,
 ------------------------------------------
 
 Mit freundlichen Grüßen,

diff --git a/templates/de/emails/member/member_surfbar_url_active_deleted.tpl b/templates/de/emails/member/member_surfbar_url_active_deleted.tpl
index e71a90eebd55fe47865f5858f1116952f2af9c88..a1a6e6e70a7fa200d49633b86ba4b314c444fdcb 100644 (file)
--- a/templates/de/emails/member/member_surfbar_url_active_deleted.tpl
+++ b/templates/de/emails/member/member_surfbar_url_active_deleted.tpl
@@ -8,7 +8,7 @@ Mitglieder-Id: $content[userid]
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/member/member_surfbar_url_active_pending.tpl b/templates/de/emails/member/member_surfbar_url_active_pending.tpl
index 8102f79c36f8d95bfbe377a0fc64d4be9e9592a9..f3ed2bd1e447c084ff6d77a6b8e87ea2f4f4ec42 100644 (file)
--- a/templates/de/emails/member/member_surfbar_url_active_pending.tpl
+++ b/templates/de/emails/member/member_surfbar_url_active_pending.tpl
@@ -8,7 +8,7 @@ Mitglieder-Id: $content[userid]
 ------------------------------------------
 Gebuchte URL: $content[url] (Neu: $content[edit][url])
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url] (Neu: $content[edit][url])
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/member/member_surfbar_url_active_stopped.tpl b/templates/de/emails/member/member_surfbar_url_active_stopped.tpl
index 36adbbc729c361232485bcd83cfef709bc3bcff0..54f8becfddee86459413ae7e10a874411d5da820 100644 (file)
--- a/templates/de/emails/member/member_surfbar_url_active_stopped.tpl
+++ b/templates/de/emails/member/member_surfbar_url_active_stopped.tpl
@@ -8,7 +8,7 @@ Mitglieder-Id: $content[userid]
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/member/member_surfbar_url_confirmed.tpl b/templates/de/emails/member/member_surfbar_url_confirmed.tpl
index 1b742634d0ec4b64cd84a12791ad2fa4c1ba76af..1af3c4f58645cc8ca16744d375ed5749fbbd9659 100644 (file)
--- a/templates/de/emails/member/member_surfbar_url_confirmed.tpl
+++ b/templates/de/emails/member/member_surfbar_url_confirmed.tpl
@@ -10,7 +10,7 @@ Ihre Mitglieder-Id: $content[userid]
 ------------------------------------------
 Status: $content[url_status]
 ------------------------------------------
 ------------------------------------------
 Status: $content[url_status]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 
 Mit freundlichen Grüßen,
 ------------------------------------------
 
 Mit freundlichen Grüßen,

diff --git a/templates/de/emails/member/member_surfbar_url_depleted.tpl b/templates/de/emails/member/member_surfbar_url_depleted.tpl
index 18eeeffd2e9e207c701d5a2f05f946ad96f15304..243c4bf9adac329aea784018de125e0595d84d2c 100644 (file)
--- a/templates/de/emails/member/member_surfbar_url_depleted.tpl
+++ b/templates/de/emails/member/member_surfbar_url_depleted.tpl
@@ -20,7 +20,7 @@ Davon übrig: $content[views_max]
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 
 Wenn Sie die URL dennoch weiterlaufen wollen, so loggen Sie sich bitte im Mitgliedsbereich ein und stellen Sie erneut Einblendungen oder auf unendlich ein.
 ------------------------------------------
 
 Wenn Sie die URL dennoch weiterlaufen wollen, so loggen Sie sich bitte im Mitgliedsbereich ein und stellen Sie erneut Einblendungen oder auf unendlich ein.

diff --git a/templates/de/emails/member/member_surfbar_url_locked_deleted.tpl b/templates/de/emails/member/member_surfbar_url_locked_deleted.tpl
index fdbde640cab1b9ddab88e57c1fb2221727f0a4de..74d2830cc9bd5814627173909e4bce4984691f4e 100644 (file)
--- a/templates/de/emails/member/member_surfbar_url_locked_deleted.tpl
+++ b/templates/de/emails/member/member_surfbar_url_locked_deleted.tpl
@@ -8,7 +8,7 @@ Mitglieder-Id: $content[userid]
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/member/member_surfbar_url_locked_pending.tpl b/templates/de/emails/member/member_surfbar_url_locked_pending.tpl
index a595e77f9886141076367124169ae100b31eb11f..f0194230b7ab563e0c1a59e5be5650f32ebae250 100644 (file)
--- a/templates/de/emails/member/member_surfbar_url_locked_pending.tpl
+++ b/templates/de/emails/member/member_surfbar_url_locked_pending.tpl
@@ -8,7 +8,7 @@ Mitglieder-Id: $content[userid]
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/member/member_surfbar_url_migrated_deleted.tpl b/templates/de/emails/member/member_surfbar_url_migrated_deleted.tpl
index 94836f7594ae1b91d5f0883f947c4a4372f1b76b..065f81bfe99d78777aae18589a2539b3c61742ef 100644 (file)
--- a/templates/de/emails/member/member_surfbar_url_migrated_deleted.tpl
+++ b/templates/de/emails/member/member_surfbar_url_migrated_deleted.tpl
@@ -8,7 +8,7 @@ Mitglieder-Id: $content[userid]
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/member/member_surfbar_url_migrated_migrated.tpl b/templates/de/emails/member/member_surfbar_url_migrated_migrated.tpl
index a26ea58724063b696f46ed1a1e6775f95d4bdd5f..6aefb5e2c08b5460bf39973c018701b303bfb6c8 100644 (file)
--- a/templates/de/emails/member/member_surfbar_url_migrated_migrated.tpl
+++ b/templates/de/emails/member/member_surfbar_url_migrated_migrated.tpl
@@ -8,7 +8,7 @@ Mitglieder-Id: $content[userid]
 ------------------------------------------
 Gebuchte URL: $content[url] (Neu: $content[edit][url])
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url] (Neu: $content[edit][url])
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/member/member_surfbar_url_migrated_pending.tpl b/templates/de/emails/member/member_surfbar_url_migrated_pending.tpl
index fec218e11b718f9549deaaeb752ae9a3da2b40ba..5f04940a511aa7fb31e94f7d0fa1d14f12be2c67 100644 (file)
--- a/templates/de/emails/member/member_surfbar_url_migrated_pending.tpl
+++ b/templates/de/emails/member/member_surfbar_url_migrated_pending.tpl
@@ -8,7 +8,7 @@ Mitglieder-Id: $content[userid]
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/member/member_surfbar_url_pending.tpl b/templates/de/emails/member/member_surfbar_url_pending.tpl
index 464592ddb408ef76063451c35f78cc63f0af7501..558ad5b39fc499ed3a613540ffffa5fecbf18cc2 100644 (file)
--- a/templates/de/emails/member/member_surfbar_url_pending.tpl
+++ b/templates/de/emails/member/member_surfbar_url_pending.tpl
@@ -14,7 +14,7 @@ Datum der Buchung: $content[url_registered]
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------
 ------------------------------------------
 Kosten/Aufruf: $content[costs] {?POINTS?}
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 
 Wir werden Ihre URL bald kontrollieren und dann freigeben.
 ------------------------------------------
 
 Wir werden Ihre URL bald kontrollieren und dann freigeben.

diff --git a/templates/de/emails/member/member_surfbar_url_pending_active.tpl b/templates/de/emails/member/member_surfbar_url_pending_active.tpl
index 1b765eee2008731f40e68b12dc069f51469a9ee3..ae1d5da5ebe35fa9b0937a02b2ebc6e71e58f2a6 100644 (file)
--- a/templates/de/emails/member/member_surfbar_url_pending_active.tpl
+++ b/templates/de/emails/member/member_surfbar_url_pending_active.tpl
@@ -8,7 +8,7 @@ Mitglieder-Id: $content[userid]
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/member/member_surfbar_url_pending_deleted.tpl b/templates/de/emails/member/member_surfbar_url_pending_deleted.tpl
index 2eecc79ce71223fd59206c56ce6c7f5709226302..852359ed03ef8e88c9b5ff7fcc8ff679bb587ca0 100644 (file)
--- a/templates/de/emails/member/member_surfbar_url_pending_deleted.tpl
+++ b/templates/de/emails/member/member_surfbar_url_pending_deleted.tpl
@@ -8,7 +8,7 @@ Mitglieder-Id: $content[userid]
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/member/member_surfbar_url_pending_rejected.tpl b/templates/de/emails/member/member_surfbar_url_pending_rejected.tpl
index fca1f235e82fba38f1ccf3f287bce5b12ea1f57c..83e054d0c88be06b7e86b12e6e4f4e1896e5d8be 100644 (file)
--- a/templates/de/emails/member/member_surfbar_url_pending_rejected.tpl
+++ b/templates/de/emails/member/member_surfbar_url_pending_rejected.tpl
@@ -8,7 +8,7 @@ Mitglieder-Id: $content[userid]
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/member/member_surfbar_url_rejected.tpl b/templates/de/emails/member/member_surfbar_url_rejected.tpl
index 205c0d16defc590e4a27c50c3919645738898a0f..c6d58f5ddd7fc16752adfbd3d18a8c49095efc29 100644 (file)
--- a/templates/de/emails/member/member_surfbar_url_rejected.tpl
+++ b/templates/de/emails/member/member_surfbar_url_rejected.tpl
@@ -10,7 +10,7 @@ Ihre Mitglieder-Id: $content[userid]
 ------------------------------------------
 Status: $content[url_status]
 ------------------------------------------
 ------------------------------------------
 Status: $content[url_status]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 
 Mit freundlichen Grüßen,
 ------------------------------------------
 
 Mit freundlichen Grüßen,

diff --git a/templates/de/emails/member/member_surfbar_url_stopped_continued.tpl b/templates/de/emails/member/member_surfbar_url_stopped_continued.tpl
index 12cc884a923ea15e93910d0fc24def9f0a45b7bd..b00ce3798635ec375df36dc0cec29b805de4e06f 100644 (file)
--- a/templates/de/emails/member/member_surfbar_url_stopped_continued.tpl
+++ b/templates/de/emails/member/member_surfbar_url_stopped_continued.tpl
@@ -8,7 +8,7 @@ Mitglieder-Id: $content[userid]
 ------------------------------------------
 Gebuchte URL: $content[url] (Neu: $content[edit][url])
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url] (Neu: $content[edit][url])
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/member/member_surfbar_url_stopped_deleted.tpl b/templates/de/emails/member/member_surfbar_url_stopped_deleted.tpl
index 6fc0ebd44e8f6e5a60cc2ade7288a4120990f4c2..ce8ad4820b8091748c1809ebffe5d9d6f24e596d 100644 (file)
--- a/templates/de/emails/member/member_surfbar_url_stopped_deleted.tpl
+++ b/templates/de/emails/member/member_surfbar_url_stopped_deleted.tpl
@@ -8,7 +8,7 @@ Mitglieder-Id: $content[userid]
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/member/member_surfbar_url_stopped_pending.tpl b/templates/de/emails/member/member_surfbar_url_stopped_pending.tpl
index 63a3eb5d019248162b32158c9cac13913152b708..a8ce779e85de0bfdc6c195b4d6547c262bb103fc 100644 (file)
--- a/templates/de/emails/member/member_surfbar_url_stopped_pending.tpl
+++ b/templates/de/emails/member/member_surfbar_url_stopped_pending.tpl
@@ -8,7 +8,7 @@ Mitglieder-Id: $content[userid]
 ------------------------------------------
 Gebuchte URL: $content[url] (Neu: $content[edit][url])
 ------------------------------------------
 ------------------------------------------
 Gebuchte URL: $content[url] (Neu: $content[edit][url])
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------
 ------------------------------------------
 URL angemeldet: $content[url_registered]
 ------------------------------------------

diff --git a/templates/de/emails/member/member_undelete_active_surfbar_urls.tpl b/templates/de/emails/member/member_undelete_active_surfbar_urls.tpl
index 1f86d6c156683ebb5e5280df1eef1ab361f92881..5e36fc951ef704b6c4fef9cdc1295b63ba23b104 100644 (file)
--- a/templates/de/emails/member/member_undelete_active_surfbar_urls.tpl
+++ b/templates/de/emails/member/member_undelete_active_surfbar_urls.tpl
@@ -12,7 +12,7 @@ Angemeldet: $content[url_registered]
 ------------------------------------------
 Ihre Mitglieder-Id: $content[userid]
 ------------------------------------------
 ------------------------------------------
 Ihre Mitglieder-Id: $content[userid]
 ------------------------------------------

-ID in der Surfbar: $content[id]
+ID in der Surfbar: $content[url_id]

 ------------------------------------------
 
 Mit freundlichen Grüßen,
 ------------------------------------------
 
 Mit freundlichen Grüßen,

diff --git a/templates/de/html/admin/admin_del_surfbar_urls_row.tpl b/templates/de/html/admin/admin_del_surfbar_urls_row.tpl
index 0c73084c2517fd081c1d674cedbc7feb0b12c35f..4e2108813f697218cbdc62f74b36546a956fbca8 100644 (file)
--- a/templates/de/html/admin/admin_del_surfbar_urls_row.tpl
+++ b/templates/de/html/admin/admin_del_surfbar_urls_row.tpl
@@ -1,8 +1,8 @@
 <tr>
        <td align="center" class="bottom right switch_sw$content[sw]">
 <tr>
        <td align="center" class="bottom right switch_sw$content[sw]">

-               <input type="hidden" name="id[$content[id]]" value="1" />
-               <input type="hidden" name="userid_raw[$content[id]]" value="$content[userid_raw]" />
-               $content[userid]
+               <input type="hidden" name="id[$content[url_id]]" value="1" />
+               <input type="hidden" name="userid_raw[$content[url_id]]" value="$content[userid_raw]" />
+               $content[url_userid]

        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
                <a href="$content[url]" target="_blank" title="{--ADMIN_TEST_URL--}">{--ADMIN_TEST_URL--}</a>
        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
                <a href="$content[url]" target="_blank" title="{--ADMIN_TEST_URL--}">{--ADMIN_TEST_URL--}</a>

diff --git a/templates/de/html/admin/admin_edit_surfbar_urls_row.tpl b/templates/de/html/admin/admin_edit_surfbar_urls_row.tpl
index 41b5ff8b831ca6bdd32d03e6dee084f791383cca..c105ae39395691b887108229f708db22a8794d0b 100644 (file)
--- a/templates/de/html/admin/admin_edit_surfbar_urls_row.tpl
+++ b/templates/de/html/admin/admin_edit_surfbar_urls_row.tpl
@@ -1,10 +1,10 @@
 <tr>
        <td align="center" class="bottom right switch_sw$content[sw]">
 <tr>
        <td align="center" class="bottom right switch_sw$content[sw]">

-               <input type="hidden" name="id[$content[id]]" value="1" />
-               <input type="hidden" name="userid_raw[$content[id]]" value="$content[userid_raw]" />
-               $content[userid]
+               <input type="hidden" name="id[$content[url_id]]" value="1" />
+               <input type="hidden" name="userid_raw[$content[url_id]]" value="$content[userid_raw]" />
+               $content[url_userid]

        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">

-               <input type="text" name="url[$content[id]]" size="20" maxlength="255" value="$content[url]" />
+               <input type="text" name="url[$content[url_id]]" size="20" maxlength="255" value="$content[url]" />

        </td>
 </tr>
        </td>
 </tr>

diff --git a/templates/de/html/admin/admin_list_surfbar_actions_row.tpl b/templates/de/html/admin/admin_list_surfbar_actions_row.tpl
index c84c9d5b1f2c33f9add64c0c45a92a4510ad0a7f..afdb904efd073c320dd88a78d4e300d2f0db4186 100644 (file)
--- a/templates/de/html/admin/admin_list_surfbar_actions_row.tpl
+++ b/templates/de/html/admin/admin_list_surfbar_actions_row.tpl
@@ -1,14 +1,14 @@
 <tr>
        <td align="center" class="bottom right switch_sw$content[sw]">
 <tr>
        <td align="center" class="bottom right switch_sw$content[sw]">

-               <input type="checkbox" class="admin_normal" title="{--ID_SELECT--} $content[id]" name="id[$content[id]]" value="1" />
+               <input type="checkbox" class="admin_normal" title="{--ID_SELECT--} $content[actions_id]" name="id[$content[actions_id]]" value="1" />

        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">

-               $content[status]
+               $content[actions_status]

        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">

-               $content[action]
+               $content[actions_action]

        </td>
        <td align="center" class="bottom switch_sw$content[sw]">
        </td>
        <td align="center" class="bottom switch_sw$content[sw]">

-               $content[new_status]
+               $content[actions_new_status]

        </td>
 </tr>
        </td>
 </tr>

diff --git a/templates/de/html/admin/admin_list_surfbar_urls_row.tpl b/templates/de/html/admin/admin_list_surfbar_urls_row.tpl
index 36471a6f0606ff8d26043e4301add32fa60afa11..25bed4ae70ed6e2abdb263a0fed9644d428ff60d 100644 (file)
--- a/templates/de/html/admin/admin_list_surfbar_urls_row.tpl
+++ b/templates/de/html/admin/admin_list_surfbar_urls_row.tpl
@@ -1,15 +1,15 @@
 <tr>
        <td align="center" class="bottom right switch_sw$content[sw]">
 <tr>
        <td align="center" class="bottom right switch_sw$content[sw]">

-               <input type="checkbox" class="admin_normal" title="{--ID_SELECT--} $content[id]" name="id[$content[id]]" value="1" />
+               <input type="checkbox" class="admin_normal" title="{--ID_SELECT--} $content[url_id]" name="id[$content[url_id]]" value="1" />

        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">

-               $content[userid]
+               $content[url_userid]

        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
                <a href="$content[url]" target="_blank" title="{--ADMIN_TEST_URL--}">{--ADMIN_TEST_URL--}</a>
        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
                <a href="$content[url]" target="_blank" title="{--ADMIN_TEST_URL--}">{--ADMIN_TEST_URL--}</a>
        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">

-               <a href="{%url=modules.php?module=admin&amp;what=surfbar_stats&amp;url_id=$content[id]%}">$content[views_total]</a>
+               <a href="{%url=modules.php?module=admin&amp;what=surfbar_stats&amp;url_id=$content[url_id]%}">$content[views_total]</a>

        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
                $content[url_status]
        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
                $content[url_status]

diff --git a/templates/de/html/admin/admin_lock_surfbar_urls_row.tpl b/templates/de/html/admin/admin_lock_surfbar_urls_row.tpl
index 5e1afc10ee4e90723b718de159f8075c918e09d4..c9df9ba0b817ade964c3ff853f631207ce9d3e0a 100644 (file)
--- a/templates/de/html/admin/admin_lock_surfbar_urls_row.tpl
+++ b/templates/de/html/admin/admin_lock_surfbar_urls_row.tpl
@@ -1,21 +1,21 @@
 <tr>
        <td align="center" class="bottom right switch_sw$content[sw]">
 <tr>
        <td align="center" class="bottom right switch_sw$content[sw]">

-               <input type="hidden" name="id[$content[id]]" value="1" />
-               <input type="hidden" name="userid_raw[$content[id]]" value="$content[userid_raw]" />
-               <input type="hidden" name="last_locked[$content[id]]" value="NOW()" />
-               $content[userid]
+               <input type="hidden" name="id[$content[url_id]]" value="1" />
+               <input type="hidden" name="userid_raw[$content[url_id]]" value="$content[url_userid_raw]" />
+               <input type="hidden" name="last_locked[$content[url_id]]" value="NOW()" />
+               $content[url_userid]

        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
                <a href="$content[url]" target="_blank" title="{--ADMIN_TEST_URL--}">{--ADMIN_TEST_URL--}</a>
        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
                <a href="$content[url]" target="_blank" title="{--ADMIN_TEST_URL--}">{--ADMIN_TEST_URL--}</a>
        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">

-               $content[status]
+               $content[url_status]

        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">

-               $content[registered]
+               $content[url_registered]

        </td>
        <td align="center" class="bottom switch_sw$content[sw]">
                Bitte angeben:<br />
        </td>
        <td align="center" class="bottom switch_sw$content[sw]">
                Bitte angeben:<br />

-               <textarea name="lock_reason[$content[id]]" rows="2" cols="15"></textarea>
+               <textarea name="lock_reason[$content[url_id]]" rows="2" cols="15"></textarea>

        </td>
 </tr>
        </td>
 </tr>

diff --git a/templates/de/html/admin/admin_surfbar_stats_row.tpl b/templates/de/html/admin/admin_surfbar_stats_row.tpl
index fd2bfaeb110b04cf9de697593537ef73773ee466..6f92d20bc874adc3579f3d654c2fed787d14a397 100644 (file)
--- a/templates/de/html/admin/admin_surfbar_stats_row.tpl
+++ b/templates/de/html/admin/admin_surfbar_stats_row.tpl
@@ -1,5 +1,5 @@
 <tr>
 <tr>

-       <td align="center" class="switch_$content[sw] bottom right">[<strong>$content[userid]</strong>]</td>
+       <td align="center" class="switch_$content[sw] bottom right">$content[stats_userid]</td>

        <td align="center" class="switch_$content[sw] bottom right">$content[visited_urls]</td>
        <td align="center" class="switch_$content[sw] bottom">$content[total_visits]</td>
 </tr>
        <td align="center" class="switch_$content[sw] bottom right">$content[visited_urls]</td>
        <td align="center" class="switch_$content[sw] bottom">$content[total_visits]</td>
 </tr>

diff --git a/templates/de/html/admin/admin_surfbar_url_stats_row.tpl b/templates/de/html/admin/admin_surfbar_url_stats_row.tpl
index b2b82a8b717273f7042938845cd551816b5c998a..51a4d81575d5363b0c4854894d876ef81c6c9092 100644 (file)
--- a/templates/de/html/admin/admin_surfbar_url_stats_row.tpl
+++ b/templates/de/html/admin/admin_surfbar_url_stats_row.tpl
@@ -1,5 +1,5 @@
 <tr>
 <tr>

-       <td align="center" class="switch_$content[sw] bottom right">[<strong>$content[userid]</strong>]</td>
+       <td align="center" class="switch_$content[sw] bottom right">[<strong>$content[url_userid]</strong>]</td>

        <td align="center" class="switch_$content[sw] bottom right">$content[total_visits]</td>
        <td align="center" class="switch_$content[sw] bottom">$content[last_surfed]</td>
 </tr>
        <td align="center" class="switch_$content[sw] bottom right">$content[total_visits]</td>
        <td align="center" class="switch_$content[sw] bottom">$content[last_surfed]</td>
 </tr>

diff --git a/templates/de/html/admin/admin_undelete_surfbar_urls_row.tpl b/templates/de/html/admin/admin_undelete_surfbar_urls_row.tpl
index 1770775ee00900e0eff5e323f8a0a6afa683e32a..901ed2e4fb9b5161a60d968b57afdf699e52e141 100644 (file)
--- a/templates/de/html/admin/admin_undelete_surfbar_urls_row.tpl
+++ b/templates/de/html/admin/admin_undelete_surfbar_urls_row.tpl
@@ -1,16 +1,16 @@
 <tr>
        <td align="center" class="bottom right switch_sw$content[sw]">
 <tr>
        <td align="center" class="bottom right switch_sw$content[sw]">

-               <input type="hidden" name="id[$content[id]]" value="1" />
-               <input type="hidden" name="userid_raw[$content[id]]" value="$content[userid_raw]" />
-               $content[userid]
+               <input type="hidden" name="id[$content[url_id]]" value="1" />
+               <input type="hidden" name="userid_raw[$content[url_id]]" value="$content[url_userid_raw]" />
+               $content[url_userid]

        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
                <a href="$content[url]" target="_blank" title="{--ADMIN_TEST_URL--}">{--ADMIN_TEST_URL--}</a>
        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
                <a href="$content[url]" target="_blank" title="{--ADMIN_TEST_URL--}">{--ADMIN_TEST_URL--}</a>
        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">

-               $content[status]
+               $content[url_status]

        </td>
        <td align="center" class="bottom switch_sw$content[sw]">
        </td>
        <td align="center" class="bottom switch_sw$content[sw]">

-               $content[registered]
+               $content[url_registered]

        </td>
 </tr>
        </td>
 </tr>

diff --git a/templates/de/html/admin/admin_unlock_surfbar_urls_row.tpl b/templates/de/html/admin/admin_unlock_surfbar_urls_row.tpl
index 4d797f269ba95b4bea03578ac090bd8c2a1d96e4..477c08db27390b2fce99c1bf202f8795274fe30c 100644 (file)
--- a/templates/de/html/admin/admin_unlock_surfbar_urls_row.tpl
+++ b/templates/de/html/admin/admin_unlock_surfbar_urls_row.tpl
@@ -1,9 +1,9 @@
 <tr>
        <td align="center" class="bottom right switch_sw$content[sw]">
 <tr>
        <td align="center" class="bottom right switch_sw$content[sw]">

-               <input type="checkbox" class="admin_normal" title="{--ID_SELECT--} $content[id]" name="id[$content[id]]" value="1" />
+               <input type="checkbox" class="admin_normal" title="{--ID_SELECT--} $content[url_id]" name="id[$content[url_id]]" value="1" />

        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">

-               $content[userid]
+               $content[url_userid]

        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
                $content[url]
        </td>
        <td align="center" class="bottom right switch_sw$content[sw]">
                $content[url]

diff --git a/templates/de/html/member/member_surfbar_delete_action_form.tpl b/templates/de/html/member/member_surfbar_delete_action_form.tpl
index a4bb2507d11d6f876bc2ac6c57e51f1e1102b968..32f7ec8a08168fc374290e537a1ca57e187f5bd7 100644 (file)
--- a/templates/de/html/member/member_surfbar_delete_action_form.tpl
+++ b/templates/de/html/member/member_surfbar_delete_action_form.tpl
@@ -22,7 +22,7 @@
 
        <div class="member_title top" style="padding-top:5px;padding-bottom:5px">
                <input type="reset" class="member_reset" value="{--CLEAR_FORM--}" />
 
        <div class="member_title top" style="padding-top:5px;padding-bottom:5px">
                <input type="reset" class="member_reset" value="{--CLEAR_FORM--}" />

-               <input type="hidden" name="id" value="$content[id]" />
+               <input type="hidden" name="id" value="$content[url_id]" />

                <input type="hidden" name="action" value="delete" />
                <input type="hidden" name="execute" value="1" />
                <input type="submit" class="member_submit" name="ok" value="{--MEMBER_SURFBAR_ACTION_DELETE_NOW_SUBMIT--}" />
                <input type="hidden" name="action" value="delete" />
                <input type="hidden" name="execute" value="1" />
                <input type="submit" class="member_submit" name="ok" value="{--MEMBER_SURFBAR_ACTION_DELETE_NOW_SUBMIT--}" />

diff --git a/templates/de/html/member/member_surfbar_edit_action_form.tpl b/templates/de/html/member/member_surfbar_edit_action_form.tpl
index 63cebdb0e460555df8c819a6922da77d9a4478c3..68cc5f942eb5815ac61e83b290d0961470ff4a70 100644 (file)
--- a/templates/de/html/member/member_surfbar_edit_action_form.tpl
+++ b/templates/de/html/member/member_surfbar_edit_action_form.tpl
@@ -21,7 +21,7 @@
 
        <div class="member_title top" style="padding-top:5px;padding-bottom:5px">
                <input type="reset" class="member_reset" value="{--CLEAR_FORM--}" />
 
        <div class="member_title top" style="padding-top:5px;padding-bottom:5px">
                <input type="reset" class="member_reset" value="{--CLEAR_FORM--}" />

-               <input type="hidden" name="id" value="$content[id]" />
+               <input type="hidden" name="id" value="$content[url_id]" />

                <input type="hidden" name="action" value="edit" />
                <input type="hidden" name="execute" value="1" />
                <input type="submit" class="member_submit" name="ok" value="{--MEMBER_SURFBAR_ACTION_EDIT_NOW_SUBMIT--}" />
                <input type="hidden" name="action" value="edit" />
                <input type="hidden" name="execute" value="1" />
                <input type="submit" class="member_submit" name="ok" value="{--MEMBER_SURFBAR_ACTION_EDIT_NOW_SUBMIT--}" />

diff --git a/templates/de/html/member/member_surfbar_list_form.tpl b/templates/de/html/member/member_surfbar_list_form.tpl
index 16412764cdb86e43a441e2740fcf1eac41e5ca71..0b9dc1686239fb2b351a7423abfecf6960b13c5f 100644 (file)
--- a/templates/de/html/member/member_surfbar_list_form.tpl
+++ b/templates/de/html/member/member_surfbar_list_form.tpl
@@ -1,6 +1,6 @@
 <td align="center" width="$content[width]%%">
        <form accept-charset="utf-8" action="{%url=modules.php?module=login&amp;what=surfbar_list%}" method="post">
 <td align="center" width="$content[width]%%">
        <form accept-charset="utf-8" action="{%url=modules.php?module=login&amp;what=surfbar_list%}" method="post">

-               <input type="hidden" name="id" value="$content[id]" />
+               <input type="hidden" name="id" value="$content[url_id]" />

                <input type="hidden" name="action" value="$content[action]" />
                <input type="submit" class="member_submit" name="ok" title="$content[title]" value="$content[submit]" />
        </form>
                <input type="hidden" name="action" value="$content[action]" />
                <input type="submit" class="member_submit" name="ok" title="$content[title]" value="$content[submit]" />
        </form>

diff --git a/templates/de/html/surfbar/surfbar_frame_top.tpl b/templates/de/html/surfbar/surfbar_frame_top.tpl
index 5dccbdc27c29f90b0c2ccdcefe0bc4de026465dd..5b693f81ca1361e14f389ef84c044c4cf5912eab 100644 (file)
--- a/templates/de/html/surfbar/surfbar_frame_top.tpl
+++ b/templates/de/html/surfbar/surfbar_frame_top.tpl
@@ -48,7 +48,7 @@ function Init() {
 }
 
 function Confirm() {
 }
 
 function Confirm() {

-       parent.surfbar_url.location="{%url=surfbar.php?id=$content[id]&check=$content[check]&salt=$content[salt]%}";
+       parent.surfbar_url.location="{%url=surfbar.php?id=$content[url_id]&check=$content[check]&salt=$content[salt]%}";

 }
 
 function ReloadThis() {
 }
 
 function ReloadThis() {