More bugs resolved, thanks to profi-concept

diff --git a/.gitattributes b/.gitattributes
index b0c1b1cf655e2c100cb2275256a6f724345d2d9c..c4281ff5929fe3b7e79b65b82b728c1b595783c4 100644 (file)
--- a/.gitattributes
+++ b/.gitattributes
@@ -87,6 +87,7 @@ inc/autopurge/purge-mails.php -text
 inc/autopurge/purge-tsks.php -text
 inc/autopurge/purge-unconfirmed.php -text
 inc/cache/.htaccess -text
 inc/autopurge/purge-tsks.php -text
 inc/autopurge/purge-unconfirmed.php -text
 inc/cache/.htaccess -text

+inc/cache/.revision -text

 inc/check-reset.php -text
 inc/config.php -text
 inc/databases.php -text
 inc/check-reset.php -text
 inc/config.php -text
 inc/databases.php -text


@@ -1229,6 +1230,7 @@ templates/de/html/ext/ext_doubler.tpl -text
 templates/de/html/ext/ext_events.tpl -text
 templates/de/html/ext/ext_holiday.tpl -text
 templates/de/html/ext/ext_html_mail.tpl -text
 templates/de/html/ext/ext_events.tpl -text
 templates/de/html/ext/ext_holiday.tpl -text
 templates/de/html/ext/ext_html_mail.tpl -text

+templates/de/html/ext/ext_logs.tpl -text

 templates/de/html/ext/ext_mailid.tpl -text
 templates/de/html/ext/ext_maintenance.tpl -text
 templates/de/html/ext/ext_mediadata.tpl -text
 templates/de/html/ext/ext_mailid.tpl -text
 templates/de/html/ext/ext_maintenance.tpl -text
 templates/de/html/ext/ext_mediadata.tpl -text


@@ -1259,6 +1261,7 @@ templates/de/html/ext/ext_task.tpl -text
 templates/de/html/ext/ext_theme.tpl -text
 templates/de/html/ext/ext_top10.tpl -text
 templates/de/html/ext/ext_transfer.tpl -text
 templates/de/html/ext/ext_theme.tpl -text
 templates/de/html/ext/ext_top10.tpl -text
 templates/de/html/ext/ext_transfer.tpl -text

+templates/de/html/ext/ext_usage.tpl -text

 templates/de/html/ext/ext_user.tpl -text
 templates/de/html/ext/ext_wernis.tpl -text
 templates/de/html/ext/ext_yoomedia.tpl -text
 templates/de/html/ext/ext_user.tpl -text
 templates/de/html/ext/ext_wernis.tpl -text
 templates/de/html/ext/ext_yoomedia.tpl -text

diff --git a/inc/cache/.revision b/inc/cache/.revision
new file mode 100644 (file)
index 0000000..3e5126c
--- /dev/null
+++ b/inc/cache/.revision
@@ -0,0 +1 @@
+new
\ No newline at end of file

diff --git a/inc/databases.php b/inc/databases.php
index 23c6fef4ed98c259448380de0b6ef5664cd9ac90..d50dd36e3ee8c7e357e16967b972acddb8536e06 100644 (file)
--- a/inc/databases.php
+++ b/inc/databases.php
@@ -79,10 +79,10 @@ define('FULL_VERSION', "0.2.1-FINAL");
 
 // Replacement strings
 $REPLACER = array(
 
 // Replacement strings
 $REPLACER = array(

-       'userid'  => "%uid%",                   // User-ID
-       'surname' => "%vorname%",               // Surname
-       'family'  => "%nachname%",              // Family name
-       'gender'  => "%anrede%",                // Gender
+       'userid'  => "%uid%",           // User-ID
+       'surname' => "%vorname%",       // Surname
+       'family'  => "%nachname%",      // Family name
+       'gender'  => "%anrede%",        // Gender

 );
 
 // One day
 );
 
 // One day


@@ -97,7 +97,9 @@ define('START_TDAY', MAKE_TIME(0, 0, 0, time()));
 define('SERVER_URL', "http://www.mxchange.org");
 
 // Current SVN revision
 define('SERVER_URL', "http://www.mxchange.org");
 
 // Current SVN revision

-define('CURR_SVN_REVISION', "725");
+define('CURR_SVN_REVISION', getActualVersion(0));
+define('CURR_SVN_DATE'    , getActualVersion(1));
+define('CURR_SVN_VERSION' , getActualVersion(2));

 
 // Take a prime number which is long (if you know a longer one please try it out!)
 define('_PRIME', 591623);
 
 // Take a prime number which is long (if you know a longer one please try it out!)
 define('_PRIME', 591623);

diff --git a/inc/db/lib-mysql3.php b/inc/db/lib-mysql3.php
index f41591f0ee3dc6957f371a4a37701ef10817c6e0..ada4e4795f987c93e10cac39cca0930700b5df66 100644 (file)
--- a/inc/db/lib-mysql3.php
+++ b/inc/db/lib-mysql3.php
@@ -41,6 +41,9 @@ if (!defined('__SECURITY')) {
 function SQL_QUERY ($sql_string, $F, $L) {
        global $link, $CSS, $_CONFIG, $OK;
 
 function SQL_QUERY ($sql_string, $F, $L) {
        global $link, $CSS, $_CONFIG, $OK;
 

+       // Link is up?
+       if (!is_resource($link)) return false;
+

        // Remove \t, \n and \r from queries they may confuse some MySQL version I have heard
        $sql_string = str_replace("\t", " ", str_replace("\n", " ", str_replace("\r", " ", $sql_string)));
 
        // Remove \t, \n and \r from queries they may confuse some MySQL version I have heard
        $sql_string = str_replace("\t", " ", str_replace("\n", " ", str_replace("\r", " ", $sql_string)));
 


@@ -49,7 +52,7 @@ function SQL_QUERY ($sql_string, $F, $L) {
 
        // Run SQL command
        //* DEBUG: */ echo $sql_string."<br />\n";
 
        // Run SQL command
        //* DEBUG: */ echo $sql_string."<br />\n";

-       $result = @mysql_query($sql_string, $link)
+       $result = mysql_query($sql_string, $link)

         or addFatalMessage($F." (".$L."):".mysql_error()."<br />
 Query string:<br />
 ".$sql_string);
         or addFatalMessage($F." (".$L."):".mysql_error()."<br />
 Query string:<br />
 ".$sql_string);


@@ -101,7 +104,7 @@ function SQL_NUMROWS($result) {
        // Is the result a valid resource?
        if (is_resource($result)) {
                // Get the count of rows from database
        // Is the result a valid resource?
        if (is_resource($result)) {
                // Get the count of rows from database

-               $lines = @mysql_num_rows($result);
+               $lines = mysql_num_rows($result);

 
                // Is the result empty? Then we have an error!
                if (empty($lines)) $lines = 0;
 
                // Is the result empty? Then we have an error!
                if (empty($lines)) $lines = 0;


@@ -120,7 +123,7 @@ function SQL_AFFECTEDROWS() {
        if (!is_resource($link)) return false;
 
        // Get affected rows
        if (!is_resource($link)) return false;
 
        // Get affected rows

-       $lines = @mysql_affected_rows($link);
+       $lines = mysql_affected_rows($link);

 
        // Return it
        return $lines;
 
        // Return it
        return $lines;


@@ -134,7 +137,7 @@ function SQL_FETCHROW($result) {
        // Is a result resource set?
        if (!is_resource($result)) return false;
 
        // Is a result resource set?
        if (!is_resource($result)) return false;
 

-       $DATA = @mysql_fetch_row($result);
+       $DATA = mysql_fetch_row($result);

        return $DATA;
 }
 
        return $DATA;
 }
 


@@ -147,7 +150,7 @@ function SQL_FETCHARRAY($res, $nr=0, $remove_numerical=true) {
        $row = array();
 
        // Load row from database
        $row = array();
 
        // Load row from database

-       $row = @mysql_fetch_array($res);
+       $row = mysql_fetch_array($res);

 
        // Return only arrays here
        if (is_array($row)) {
 
        // Return only arrays here
        if (is_array($row)) {


@@ -171,19 +174,19 @@ function SQL_FETCHARRAY($res, $nr=0, $remove_numerical=true) {
 
 // SQL result
 function SQL_RESULT($res, $row, $field) {
 
 // SQL result
 function SQL_RESULT($res, $row, $field) {

-       $result = @mysql_result($res, $row, $field);
+       $result = mysql_result($res, $row, $field);

        return $result;
 }
 // SQL connect
 function SQL_CONNECT($host, $login, $password, $F, $L) {
        return $result;
 }
 // SQL connect
 function SQL_CONNECT($host, $login, $password, $F, $L) {

-       $connect = @mysql_connect($host, $login, $password) or addFatalMessage($F." (".$L."):".mysql_error());
+       $connect = mysql_connect($host, $login, $password) or addFatalMessage($F." (".$L."):".mysql_error());

        return $connect;
 }
 // SQL select database
 function SQL_SELECT_DB($dbName, $link, $F, $L) {
        $select = false;
        if (is_resource($link)) {
        return $connect;
 }
 // SQL select database
 function SQL_SELECT_DB($dbName, $link, $F, $L) {
        $select = false;
        if (is_resource($link)) {

-               $select = @mysql_select_db($dbName, $link) or addFatalMessage($F." (".$L."):".mysql_error());
+               $select = mysql_select_db($dbName, $link) or addFatalMessage($F." (".$L."):".mysql_error());

        }
        return $select;
 }
        }
        return $select;
 }


@@ -212,20 +215,25 @@ function SQL_CLOSE(&$link, $F, $L) {
        $link = null;
        return $close;
 }
        $link = null;
        return $close;
 }

+

 // SQL free result
 // SQL free result

-function SQL_FREERESULT($result) {
+function SQL_FREERESULT ($result) {

        if (!is_resource($result)) {
                // Abort here
                return false;
        } // END - if
 
        if (!is_resource($result)) {
                // Abort here
                return false;
        } // END - if
 

-       $res = @mysql_free_result($result);
+       $res = mysql_free_result($result);

        return $res;
 }
        return $res;
 }

+

 // SQL string escaping
 // SQL string escaping

-function SQL_QUERY_ESC($qstring, $data, $file, $line, $run=true, $strip=true) {
+function SQL_QUERY_ESC ($qstring, $data, $file, $line, $run=true, $strip=true) {

        global $link;
 
        global $link;
 

+       // Link is there?
+       if (!is_resource($link)) return false;
+

        // Init variable
        $query = "failed";
 
        // Init variable
        $query = "failed";
 


@@ -270,12 +278,16 @@ function SQL_QUERY_ESC($qstring, $data, $file, $line, $run=true, $strip=true) {
                return $query;
        }
 }
                return $query;
        }
 }

+

 // Get ID from last INSERT command
 // Get ID from last INSERT command

-function SQL_INSERTID() {
-       return @mysql_insert_id();
+function SQL_INSERTID () {
+       global $link;
+       if (!is_resource($link)) return false;
+       return mysql_insert_id();

 }
 }

+

 // Escape a string for the database
 // Escape a string for the database

-function SQL_ESCAPE($str, $secureString=true,$strip=true) {
+function SQL_ESCAPE ($str, $secureString=true,$strip=true) {

        global $link;
 
        // Secure string first? (which is the default behaviour!)
        global $link;
 
        // Secure string first? (which is the default behaviour!)


@@ -310,9 +322,15 @@ function SQL_RESULT_FROM_ARRAY ($table, $columns, $idRow, $id, $F, $L) {
        return SQL_QUERY_ESC($SQL, array(bigintval($id)), $F, $L);
 }
 // ALTER TABLE wrapper function
        return SQL_QUERY_ESC($SQL, array(bigintval($id)), $F, $L);
 }
 // ALTER TABLE wrapper function

-function SQL_ALTER_TABLE($sql, $F, $L) {
-       // Shall we add?
-       if (eregi("ADD", $sql) > 0) {
+function SQL_ALTER_TABLE ($sql, $F, $L) {
+       // This is the default result...
+       $result = false;
+
+       // Determine index/fulltext/unique word
+       $noIndex = ((eregi("INDEX", $sql) == false) && (eregi("FULLTEXT", $sql) == false) && (eregi("UNIQUE", $sql) == false);
+
+       // Shall we add/drop?
+       if (((eregi("ADD", $sql) > 0) || (eregi("DROP", $sql) > 0)) && ($noIndex)) {

                // Extract table name
                $tableArray = explode(" ", $sql);
                $tableName = str_replace("`", "", $tableArray[2]);
                // Extract table name
                $tableArray = explode(" ", $sql);
                $tableName = str_replace("`", "", $tableArray[2]);


@@ -324,15 +342,18 @@ function SQL_ALTER_TABLE($sql, $F, $L) {
                $result = SQL_QUERY_ESC("SHOW COLUMNS FROM %s LIKE '%s'",
                        array($tableName, $columnName), $F, $L);
 
                $result = SQL_QUERY_ESC("SHOW COLUMNS FROM %s LIKE '%s'",
                        array($tableName, $columnName), $F, $L);
 

-               // Do we have no entry?
-               if (SQL_NUMROWS($result) == 0) {
+               // Do we have no entry on ADD or an entry on DROP?
+               if (((SQL_NUMROWS($result) == 0) && (eregi("ADD", $sql) > 0)) || ((SQL_NUMROWS($result) == 1) && (eregi("DROP", $sql) > 0))) {

                        // Do the query
                        // Do the query

-                       return SQL_QUERY($sql, $F, $L, false);
+                       $result = SQL_QUERY($sql, $F, $L, false);

                } // END - if
        } else {
                // Send it to the SQL_QUERY() function
                } // END - if
        } else {
                // Send it to the SQL_QUERY() function

-               return SQL_QUERY($sql, $F, $L, false);
+               $result = SQL_QUERY($sql, $F, $L, false);

        }
        }

+
+       // Return result
+       return $result;

 }
 //
 ?>
 }
 //
 ?>

diff --git a/inc/extensions/ext-logs.php b/inc/extensions/ext-logs.php
index 385a5dd1c1bbc00b079cd9d52a0c7cf170bff95b..74c5ee2ea5769e7f66fdb7eec9698fd9af9743d6 100644 (file)
--- a/inc/extensions/ext-logs.php
+++ b/inc/extensions/ext-logs.php
@@ -56,7 +56,7 @@ case "register": // Do stuff when installation is running (modules.php?module=ad
 
 case "remove": // Do stuff when removing extension
        // SQL commands to run
 
 case "remove": // Do stuff when removing extension
        // SQL commands to run

-       $SQLs[] = "DELETE LOW_PRIOIRTY FROM `"._MYSQL_PREFIX."_admin_menu` WHERE what='logs' LIMIT 1";
+       $SQLs[] = "DELETE LOW_PRIORITY FROM `"._MYSQL_PREFIX."_admin_menu` WHERE what='logs' LIMIT 1";

        break;
 
 case "activate": // Do stuff when admin activates this extension
        break;
 
 case "activate": // Do stuff when admin activates this extension

diff --git a/inc/extensions/ext-other.php b/inc/extensions/ext-other.php
index 2afb6ac1cc3b9aa6f86cb559d2c3cae73a8c7fff..d25000b674be5fb2641823b47b6dbaa4aa8d3635 100644 (file)
--- a/inc/extensions/ext-other.php
+++ b/inc/extensions/ext-other.php
@@ -50,7 +50,7 @@ switch ($EXT_LOAD_MODE)
 {
 case "register": // Do stuff when installation is running (modules.php?module=admin&action=login is called)
        // SQL commands to run
 {
 case "register": // Do stuff when installation is running (modules.php?module=admin&action=login is called)
        // SQL commands to run

-       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_other','Sonstige Einstellungen','Sonstige Einstellungen an Ihrem Mailtausch.','13')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_other','Sonstige Einstellungen','Sonstige Einstellungen an Ihrem Mailtausch.',13)";

        break;
 
 case "remove": // Do stuff when removing extension
        break;
 
 case "remove": // Do stuff when removing extension

diff --git a/inc/extensions/ext-sponsor.php b/inc/extensions/ext-sponsor.php
index 8bc5cf8fc959d791b3c48d852b838ff2ea974ce1..bc1dccab0d4b58524b596a2ef397b8c68a9afef9 100644 (file)
--- a/inc/extensions/ext-sponsor.php
+++ b/inc/extensions/ext-sponsor.php
@@ -57,8 +57,8 @@ case "register": // Do stuff when installation is running (modules.php?module=ad
        //
        // Sponsor data
        //
        //
        // Sponsor data
        //

-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_data";
-       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_data (
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_data`";
+       $SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_sponsor_data` (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 company VARCHAR(255) NOT NULL DEFAULT '',
 position VARCHAR(255) NOT NULL DEFAULT '',
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 company VARCHAR(255) NOT NULL DEFAULT '',
 position VARCHAR(255) NOT NULL DEFAULT '',


@@ -98,8 +98,8 @@ PRIMARY KEY(id)
        //
        // Sponsor orders
        //
        //
        // Sponsor orders
        //

-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_orders";
-       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_orders (
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_orders`";
+       $SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_sponsor_orders` (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 aid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 aid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,


@@ -118,8 +118,8 @@ PRIMARY KEY(id)
        //
        // Pay-types
        //
        //
        // Pay-types
        //

-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_paytypes";
-       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_paytypes (
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_paytypes`";
+       $SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_sponsor_paytypes` (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 pay_name VARCHAR(255) NOT NULL DEFAULT '',
 pay_rate FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 pay_name VARCHAR(255) NOT NULL DEFAULT '',
 pay_rate FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,


@@ -130,8 +130,8 @@ PRIMARY KEY(id)
        //
        // Points-to-action converting
        //
        //
        // Points-to-action converting
        //

-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_action_convert";
-       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_action_convert (
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_action_convert`";
+       $SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_sponsor_action_convert` (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 ext_name VARCHAR(255) NOT NULL DEFAULT 'sponsor',
 conv_rate BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 ext_name VARCHAR(255) NOT NULL DEFAULT 'sponsor',
 conv_rate BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,


@@ -142,8 +142,8 @@ PRIMARY KEY(id)
        //
        // Sponsor menu system (default)
        //
        //
        // Sponsor menu system (default)
        //

-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_menu";
-       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_menu (
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_menu`";
+       $SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_sponsor_menu` (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 action VARCHAR(255) NOT NULL DEFAULT '',
 what  VARCHAR(255) NULL DEFAULT NULL,
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 action VARCHAR(255) NOT NULL DEFAULT '',
 what  VARCHAR(255) NULL DEFAULT NULL,


@@ -157,8 +157,8 @@ PRIMARY KEY(id)
        //
        // Registry for performable actions by your sponsors
        //
        //
        // Registry for performable actions by your sponsors
        //

-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_registry";
-       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_registry (
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_registry`";
+       $SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_sponsor_registry` (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 aid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 ext_name VARCHAR(255) NOT NULL DEFAULT 'sponsor',
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 aid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 ext_name VARCHAR(255) NOT NULL DEFAULT 'sponsor',


@@ -171,8 +171,8 @@ PRIMARY KEY(id)
        //
        // URLs from the sponsors
        //
        //
        // URLs from the sponsors
        //

-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_urls";
-       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_urls (
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_urls`";
+       $SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_sponsor_urls` (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 url VARCHAR(255) NOT NULL DEFAULT 'http://',
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 url VARCHAR(255) NOT NULL DEFAULT 'http://',


@@ -185,8 +185,8 @@ PRIMARY KEY(id)
        //
        // Banners of any size from the sponsors
        //
        //
        // Banners of any size from the sponsors
        //

-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_banner";
-       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_banner (
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_banner`";
+       $SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_sponsor_banner` (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 url VARCHAR(255) NOT NULL DEFAULT 'http://',
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 url VARCHAR(255) NOT NULL DEFAULT 'http://',


@@ -201,8 +201,8 @@ PRIMARY KEY(id)
        //
        // Campaigns
        //
        //
        // Campaigns
        //

-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_campaigns";
-       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_campaigns (
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_campaigns`";
+       $SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_sponsor_campaigns` (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 aid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 aid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,


@@ -223,8 +223,8 @@ PRIMARY KEY(id)
        //
        // Campaigns + URLs + Banner
        //
        //
        // Campaigns + URLs + Banner
        //

-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_campaign_assigns";
-       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_campaign_assigns (
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_campaign_assigns`";
+       $SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_sponsor_campaign_assigns` (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 campaignid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 urlid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 campaignid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 urlid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,


@@ -239,8 +239,8 @@ PRIMARY KEY(id)
        //
        // Allowed data to display (administrative)
        //
        //
        // Allowed data to display (administrative)
        //

-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_admin_data";
-       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_admin_data (
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_admin_data`";
+       $SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_sponsor_admin_data` (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 data_row VARCHAR(255) NOT NULL DEFAULT '',
 display ENUM('Y','N') NOT NULL DEFAULT 'N',
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 data_row VARCHAR(255) NOT NULL DEFAULT '',
 display ENUM('Y','N') NOT NULL DEFAULT 'N',


@@ -249,8 +249,8 @@ PRIMARY KEY(id)
        //
        // Allowed data to display (sponsor-side)
        //
        //
        // Allowed data to display (sponsor-side)
        //

-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_display_data";
-       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_display_data (
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_display_data`";
+       $SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_sponsor_display_data` (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 data_row VARCHAR(255) NOT NULL DEFAULT '',
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 data_row VARCHAR(255) NOT NULL DEFAULT '',


@@ -261,46 +261,46 @@ PRIMARY KEY(id)
        //
        // Default allowed data to display
        //
        //
        // Default allowed data to display
        //

-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('id','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('company','Y')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('position','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('tax_ident','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('gender','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('surname','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('family','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('street_nr1','Y')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('street_nr2','Y')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('zip','Y')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('city','Y')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('country','Y')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('phone','Y')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('fax','Y')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('email','Y')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('url','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('password','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('remote_addr','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('sponsor_created','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('last_online','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('last_change','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('status','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('receive_warnings','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('warning_interval','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('points_amount','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('points_used','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('refid','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('ref_count','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('hash','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('last_pay','N')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('last_curr','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('id','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('company','Y')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('position','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('tax_ident','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('gender','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('surname','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('family','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('street_nr1','Y')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('street_nr2','Y')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('zip','Y')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('city','Y')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('country','Y')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('phone','Y')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('fax','Y')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('email','Y')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('url','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('password','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('remote_addr','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('sponsor_created','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('last_online','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('last_change','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('status','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('receive_warnings','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('warning_interval','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('points_amount','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('points_used','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('refid','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('ref_count','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('hash','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('last_pay','N')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_admin_data` (data_row, display) VALUES ('last_curr','N')";

        //
        // Add default entries
        //
        //
        // Add default entries
        //

-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_registry (ext_name, is_active, aid, stamp_added) VALUES ('sponsor','N',".GET_CURRENT_ADMIN_ID().",UNIX_TIMESTAMP())";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_action_convert (ext_name, conv_rate, conv_name) VALUES ('sponsor','10','Mails')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_paytypes (pay_name, pay_min_count, pay_rate, pay_currency) VALUES ('Standart-Paket', 5, 1000.00000, '€')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_paytypes (pay_name, pay_min_count, pay_rate, pay_currency) VALUES ('Spar-Paket', 1, 200.00000, '€')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_paytypes (pay_name, pay_min_count, pay_rate, pay_currency) VALUES ('Power-Paket', 10, 2000.00000, '€')";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_paytypes (pay_name, pay_min_count, pay_rate, pay_currency) VALUES ('Sponsor-Paket', 20, 4000.00000, '€')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_registry` (ext_name, is_active, aid, stamp_added) VALUES ('sponsor','N',".GET_CURRENT_ADMIN_ID().",UNIX_TIMESTAMP())";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_action_convert` (ext_name, conv_rate, conv_name) VALUES ('sponsor','10','Mails')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_paytypes` (pay_name, pay_min_count, pay_rate, pay_currency) VALUES ('Standart-Paket', 5, 1000.00000, '€')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_paytypes` (pay_name, pay_min_count, pay_rate, pay_currency) VALUES ('Spar-Paket', 1, 200.00000, '€')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_paytypes` (pay_name, pay_min_count, pay_rate, pay_currency) VALUES ('Power-Paket', 10, 2000.00000, '€')";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_paytypes` (pay_name, pay_min_count, pay_rate, pay_currency) VALUES ('Sponsor-Paket', 20, 4000.00000, '€')";

        //
        // Admin menu
        //
        //
        // Admin menu
        //


@@ -330,36 +330,36 @@ PRIMARY KEY(id)
        //
        // Guest menu
        //
        //
        // Guest menu
        //

-       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_guest_menu` (action, what, title, sort) VALUES ('sponsor', NULL, 'Sponsoren', 2)";
-       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_guest_menu` (action, what, title, sort) VALUES ('sponsor','sponsor_reg','Anmeldung', 1)";
-       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_guest_menu` (action, what, title, sort) VALUES ('sponsor','sponsor_login','Einloggen', 2)";
-       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_guest_menu` (action, what, title, sort) VALUES ('sponsor','sponsor_infos','Infos/Preise', 3)";
-       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_guest_menu` (action, what, title, sort) VALUES ('sponsor','sponsor_agb','AGBs', 4)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_guest_menu` (`action`, `what`, `title`, `sort`) VALUES ('sponsor', NULL, 'Sponsoren', 2)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_guest_menu` (`action`, `what`, `title`, `sort`) VALUES ('sponsor','sponsor_reg','Anmeldung', 1)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_guest_menu` (`action`, `what`, `title`, `sort`) VALUES ('sponsor','sponsor_login','Einloggen', 2)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_guest_menu` (`action`, `what`, `title`, `sort`) VALUES ('sponsor','sponsor_infos','Infos/Preise', 3)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_guest_menu` (`action`, `what`, `title`, `sort`) VALUES ('sponsor','sponsor_agb','AGBs', 4)";

        //
        // Member menu
        //
        //
        // Member menu
        //

-       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_member_menu` (action, what, title, sort) VALUES ('main','sponsor','Unsere Sponsoren', 8)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_member_menu` (`action`, `what`, `title`, `sort`) VALUES ('main','sponsor','Unsere Sponsoren', 8)";

        //
        // Add default menus to sponsor menu
        //
        //
        // Add default menus to sponsor menu
        //

-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main', NULL, 'Hauptauswahl','N', 1)";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','welcome','Willkommen','N', 1)";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','account','Ihr Account','N', 2)";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','campaigns','Kampagnen','N', 3)";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','urls','URL-Verwaltung','N', 4)";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','banner','Banner-Verwaltung','N', 5)";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','settings','Einstellungen','N', 6)";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','fillup','Konto auffüllen','N', 7)";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','stats','Statistiken','N', 8)";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','inquiry','Kontaktanfrage','N', 9)";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','refid','Referal-Link','N', 10)";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('actions', NULL, 'Sponsorenaktionen','N', 2)";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('actions','mail','Sponsor-Mail','N', 1)";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('actions','banner','Banner buchen','N', 2)";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('actions','text','Textlink buchen','N', 3)";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('logout', NULL, 'Ausloggen','N', 3)";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('logout','logout','Ausloggen','N', 1)";
-       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('logout','guest','Zum Gastbereich','N', 2)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_menu` (`action`, `what`, `title`, `active`, `sort`) VALUES ('main', NULL, 'Hauptauswahl','N', 1)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_menu` (`action`, `what`, `title`, `active`, `sort`) VALUES ('main','welcome','Willkommen','N', 1)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_menu` (`action`, `what`, `title`, `active`, `sort`) VALUES ('main','account','Ihr Account','N', 2)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_menu` (`action`, `what`, `title`, `active`, `sort`) VALUES ('main','campaigns','Kampagnen','N', 3)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_menu` (`action`, `what`, `title`, `active`, `sort`) VALUES ('main','list_urls','URL-Verwaltung','N', 4)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_menu` (`action`, `what`, `title`, `active`, `sort`) VALUES ('main','list_banner','Banner-Verwaltung','N', 5)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_menu` (`action`, `what`, `title`, `active`, `sort`) VALUES ('main','settings','Einstellungen','N', 6)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_menu` (`action`, `what`, `title`, `active`, `sort`) VALUES ('main','fillup','Konto auffüllen','N', 7)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_menu` (`action`, `what`, `title`, `active`, `sort`) VALUES ('main','stats','Statistiken','N', 8)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_menu` (`action`, `what`, `title`, `active`, `sort`) VALUES ('main','inquiry','Kontaktanfrage','N', 9)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_menu` (`action`, `what`, `title`, `active`, `sort`) VALUES ('main','refid','Referal-Link','N', 10)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_menu` (`action`, `what`, `title`, `active`, `sort`) VALUES ('actions', NULL, 'Sponsorenaktionen','N', 2)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_menu` (`action`, `what`, `title`, `active`, `sort`) VALUES ('actions','mail','Sponsor-Mail','N', 1)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_menu` (`action`, `what`, `title`, `active`, `sort`) VALUES ('actions','banner','Banner buchen','N', 2)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_menu` (`action`, `what`, `title`, `active`, `sort`) VALUES ('actions','text','Textlink buchen','N', 3)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_menu` (`action`, `what`, `title`, `active`, `sort`) VALUES ('logout', NULL, 'Ausloggen','N', 3)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_menu` (`action`, `what`, `title`, `active`, `sort`) VALUES ('logout','logout','Ausloggen','N', 1)";
+       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_menu` (`action`, `what`, `title`, `active`, `sort`) VALUES ('logout','guest','Zum Gastbereich','N', 2)";

        //
        // General configuration stuff
        //
        //
        // General configuration stuff
        //


@@ -372,18 +372,18 @@ PRIMARY KEY(id)
 
 case "remove": // Do stuff when removing extension
        // SQL commands to run
 
 case "remove": // Do stuff when removing extension
        // SQL commands to run

-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_data";
-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_orders";
-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_action_convert";
-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_paytypes";
-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_menu";
-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_registry";
-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_urls";
-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_banner";
-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_campaigns";
-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_campaign_assigns";
-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_admin_data";
-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_display_data";
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_data`";
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_orders`";
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_action_convert`";
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_paytypes`";
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_menu`";
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_registry`";
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_urls`";
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_banner`";
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_campaigns`";
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_campaign_assigns`";
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_admin_data`";
+       $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_sponsor_display_data`";

        $SQLs[] = "DELETE LOW_PRIORITY FROM `"._MYSQL_PREFIX."_admin_menu` WHERE action='sponsor' OR what IN('repr_sponsor','sponsor_medit','sponsor_madd') LIMIT 20";
        $SQLs[] = "DELETE LOW_PRIORITY FROM `"._MYSQL_PREFIX."_guest_menu` WHERE action='sponsor' LIMIT 5";
        $SQLs[] = "DELETE LOW_PRIORITY FROM `"._MYSQL_PREFIX."_member_menu` WHERE what='sponsor' LIMIT 1";
        $SQLs[] = "DELETE LOW_PRIORITY FROM `"._MYSQL_PREFIX."_admin_menu` WHERE action='sponsor' OR what IN('repr_sponsor','sponsor_medit','sponsor_madd') LIMIT 20";
        $SQLs[] = "DELETE LOW_PRIORITY FROM `"._MYSQL_PREFIX."_guest_menu` WHERE action='sponsor' LIMIT 5";
        $SQLs[] = "DELETE LOW_PRIORITY FROM `"._MYSQL_PREFIX."_member_menu` WHERE what='sponsor' LIMIT 1";


@@ -393,16 +393,16 @@ case "activate": // Do stuff when admin activates this extension
        // SQL commands to run
        $SQLs[] = "UPDATE `"._MYSQL_PREFIX."_guest_menu` SET visible='Y', locked='N' WHERE action='sponsor' LIMIT 4";
        $SQLs[] = "UPDATE `"._MYSQL_PREFIX."_member_menu` SET visible='Y', locked='N' WHERE what='sponsor' LIMIT 1";
        // SQL commands to run
        $SQLs[] = "UPDATE `"._MYSQL_PREFIX."_guest_menu` SET visible='Y', locked='N' WHERE action='sponsor' LIMIT 4";
        $SQLs[] = "UPDATE `"._MYSQL_PREFIX."_member_menu` SET visible='Y', locked='N' WHERE what='sponsor' LIMIT 1";

-       $SQLs[] = "UPDATE "._MYSQL_PREFIX."_sponsor_menu SET active='Y' WHERE active='N'";
-       $SQLs[] = "UPDATE "._MYSQL_PREFIX."_sponsor_registry SET is_active='Y' WHERE is_active='N'";
+       $SQLs[] = "UPDATE `"._MYSQL_PREFIX."_sponsor_menu` SET active='Y' WHERE active='N'";
+       $SQLs[] = "UPDATE `"._MYSQL_PREFIX."_sponsor_registry` SET is_active='Y' WHERE is_active='N'";

        break;
 
 case "deactivate": // Do stuff when admin deactivates this extension
        // SQL commands to run
        $SQLs[] = "UPDATE `"._MYSQL_PREFIX."_guest_menu` SET visible='N', locked='Y' WHERE action='sponsor' LIMIT 4";
        $SQLs[] = "UPDATE `"._MYSQL_PREFIX."_member_menu` SET visible='N', locked='Y' WHERE what='sponsor' LIMIT 1";
        break;
 
 case "deactivate": // Do stuff when admin deactivates this extension
        // SQL commands to run
        $SQLs[] = "UPDATE `"._MYSQL_PREFIX."_guest_menu` SET visible='N', locked='Y' WHERE action='sponsor' LIMIT 4";
        $SQLs[] = "UPDATE `"._MYSQL_PREFIX."_member_menu` SET visible='N', locked='Y' WHERE what='sponsor' LIMIT 1";

-       $SQLs[] = "UPDATE "._MYSQL_PREFIX."_sponsor_menu SET active='N' WHERE active='Y'";
-       $SQLs[] = "UPDATE "._MYSQL_PREFIX."_sponsor_registry SET is_active='N' WHERE is_active='Y'";
+       $SQLs[] = "UPDATE `"._MYSQL_PREFIX."_sponsor_menu` SET active='N' WHERE active='Y'";
+       $SQLs[] = "UPDATE `"._MYSQL_PREFIX."_sponsor_registry` SET is_active='N' WHERE is_active='Y'";

        break;
 
 case "update": // Update an extension
        break;
 
 case "update": // Update an extension

diff --git a/inc/functions.php b/inc/functions.php
index 6a87f258cce888a8cdc0a1836a5d528ac22922d8..b326dab09832063588ebb76fd1a328c91088a55e 100644 (file)
--- a/inc/functions.php
+++ b/inc/functions.php
@@ -3013,6 +3013,23 @@ function READ_FILE ($FQFN, $sqlPrepare = false) {
        return $content;
 }
 
        return $content;
 }
 

+// Writes content to a file
+function WRITE_FILE ($FQFN, $content) {
+       // Is the function there?
+       if (function_exists('file_put_contents')) {
+               // Write it directly
+               file_put_contents($FQFN, $content);
+       } else {
+               // Write it with fopen
+               $fp = fopen($FQFN, 'w') or mxchange_die("Cannot write file ".basename($FQFN)."!");
+               fwrite($fp, $content);
+               fclose($fp);
+
+               // Set CHMOD rights
+               chmod($FQFN, 0644);
+       }
+}
+

 // Generates an error code from given account status
 function GEN_ERROR_CODE_FROM_ACCOUNT_STATUS ($status) {
        // Default error code if unknown account status
 // Generates an error code from given account status
 function GEN_ERROR_CODE_FROM_ACCOUNT_STATUS ($status) {
        // Default error code if unknown account status


@@ -3043,6 +3060,48 @@ function clearOutputBuffer () {
        } // END - if
 }
 
        } // END - if
 }
 

+// "Getter" for revision/version data
+function getActualVersion ($type = 0) {
+       // By default nothing is new... ;-)
+       $new = false;
+
+       // FQFN of revision file
+       $FQFN = sprintf("%sinc/cache/.revision", PATH);
+
+       // Check for revision file
+       if (!FILE_READABLE($FQFN)) {
+               // Not found, so we need to create it
+               $new = true;
+       } else {
+               // Revision file found
+               $ins_vers = explode("\n", READ_FILE($FQFN));
+
+               // Is the content valid?
+               if ((!is_array($ins_vers)) || (count($ins_vers) <= 0) || (!isset($ins_vers[$type])) || ($ins_vers[0]) == "new") {
+                       // File needs update!
+                       $new = true;
+               } else {
+                       // Revision-File has valid Data and isn't 'new' so return the Rev-Number
+                       return trim($ins_vers[$type]);
+               }
+       }
+
+       if ($new)  {
+               // no Revision-File or has no valid Data so read the Revision from the Server.
+               $version = GET_URL("check-updates3.php");
+
+               // Prepare content
+               $akt_vers[] = trim($version[10]);
+               $akt_vers[] = trim($version[9]);
+               $akt_vers[] = trim($version[8]);
+
+               // Write file
+               WRITE_FILE($FQFN, implode("\n", $akt_vers));
+
+               // Return requested content
+               return trim($akt_vers[$type]);
+       }
+}

 //////////////////////////////////////////////////
 // AUTOMATICALLY RE-GENERATED MISSING FUNCTIONS //
 //////////////////////////////////////////////////
 //////////////////////////////////////////////////
 // AUTOMATICALLY RE-GENERATED MISSING FUNCTIONS //
 //////////////////////////////////////////////////

diff --git a/inc/gen_refback.php b/inc/gen_refback.php
index 444a85ace8bbce551395dabfd2e5f09a24111647..16dbc51d1dc539d80f71d29570b9ec18f4846cac 100644 (file)
--- a/inc/gen_refback.php
+++ b/inc/gen_refback.php
@@ -44,13 +44,13 @@ require_once(PATH."inc/libs/refback_functions.php");
 $result = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_refsystem WHERE level=0", __FILE__, __LINE__);
 if (SQL_NUMROWS($result) > 0) {
        // Remove index temporaly
 $result = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_refsystem WHERE level=0", __FILE__, __LINE__);
 if (SQL_NUMROWS($result) > 0) {
        // Remove index temporaly

-       SQL_QUERY("ALTER TABLE `"._MYSQL_PREFIX."_refsystem` DROP INDEX `userid_level`", __FILE__, __LINE__);
+       SQL_ALTER_TABLE("ALTER TABLE `"._MYSQL_PREFIX."_refsystem` DROP INDEX `userid_level`", __FILE__, __LINE__);

 
        // Upgrade refsystem, ref-level 0 is silly here
        SQL_QUERY("UPDATE "._MYSQL_PREFIX."_refsystem SET level=level+1", __FILE__, __LINE__);
 
        // Add it again
 
        // Upgrade refsystem, ref-level 0 is silly here
        SQL_QUERY("UPDATE "._MYSQL_PREFIX."_refsystem SET level=level+1", __FILE__, __LINE__);
 
        // Add it again

-       SQL_QUERY("ALTER TABLE `"._MYSQL_PREFIX."_refsystem` ADD UNIQUE `userid_level` ( `userid` , `level` )", __FILE__, __LINE__);
+       SQL_ALTER_TABLE("ALTER TABLE `"._MYSQL_PREFIX."_refsystem` ADD UNIQUE `userid_level` ( `userid` , `level` )", __FILE__, __LINE__);

 
        // Rebuild cache
        REBUILD_CACHE("refsystem", "refsystem");
 
        // Rebuild cache
        REBUILD_CACHE("refsystem", "refsystem");

diff --git a/inc/gen_sql_patches.php b/inc/gen_sql_patches.php
index 9f822c302e6da29540ae1787bd60aaa621312745..62ef9909e9e65266de14f52fd9e6728b130e6db9 100644 (file)
--- a/inc/gen_sql_patches.php
+++ b/inc/gen_sql_patches.php
@@ -74,22 +74,17 @@ if (getConfig('file_hash') == "") {
        $file_hash = sha1(GEN_PASS(mt_rand(128, 256)));
        $file = PATH."inc/.secret/.".$file_hash;
 
        $file_hash = sha1(GEN_PASS(mt_rand(128, 256)));
        $file = PATH."inc/.secret/.".$file_hash;
 

+       // Count of chars to be taken from back of the string
+       $nums = mt_rand(40, 45);
+
+       // Generate secret key from a randomized string
+       $secretKey = substr(sha1(GEN_PASS(mt_rand(128, 256))), -$nums);
+

        // File hash was never created
        // File hash was never created

-       $fp = @fopen($file, 'w') or mxchange_die("Cannot write secret key file!");
-       if ($fp != false) {
-               // Could write to secret file! So let's generate the secret key...
-               // 1. Count of chars to be taken from back of the string
-               $nums = mt_rand(40, 45);
-               // 2. Generate secret key from a randomized string
-               $secretKey = substr(sha1(GEN_PASS(mt_rand(128, 256))), -$nums);
-               // 3. Write the key to the file
-               fwrite($fp, $secretKey);
-               // 4. Close file
-               fclose($fp);
-
-               // Change access rights for more security
-               @chmod($file, 0644);
+       WRITE_FILE($file, $secretKey);

 
 

+       // Is the file there?
+       if (FILE_READABLE($file)) {

                //* DEBUG: */ unlink($file);
                //* DEBUG: */ $test = hexdec(get_session('u_hash')) / hexdec($secretKey);
                //* DEBUG: */ $test = generateHash(str_replace('.', "", $test));
                //* DEBUG: */ unlink($file);
                //* DEBUG: */ $test = hexdec(get_session('u_hash')) / hexdec($secretKey);
                //* DEBUG: */ $test = generateHash(str_replace('.', "", $test));


@@ -99,17 +94,13 @@ if (getConfig('file_hash') == "") {
                SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_config` SET file_hash='%s' WHERE config=0 LIMIT 1",
                        array($file_hash), __FILE__, __LINE__);
 
                SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_config` SET file_hash='%s' WHERE config=0 LIMIT 1",
                        array($file_hash), __FILE__, __LINE__);
 

+               // Generate FQFN for .htaccess file
+               $FQFN = PATH."inc/.secret/.htaccess";
+

                // Is the .htaccess file there?
                // Is the .htaccess file there?

-               if (!FILE_READABLE(PATH."inc/.secret/.htaccess")) {
+               if (!FILE_READABLE($FQFN)) {

                        // Also create .htaccess file
                        // Also create .htaccess file

-                       $fp = @fopen(PATH."inc/.secret/.htaccess", 'w') or mxchange_die("Cannot write to .htaccess file!");
-                       if ($fp != false) {
-                               // Add deny line to file
-                               fwrite($fp, "Deny from all");
-
-                               // Close the file
-                               fclose($fp);
-                       } // END - if
+                       WRITE_FILE($FQFN, "Deny from all\n");

                } // END - if
 
                // Also update configuration
                } // END - if
 
                // Also update configuration

diff --git a/inc/libs/sponsor_functions.php b/inc/libs/sponsor_functions.php
index f5774c69e541f6f765e4c2d02416402b2f816928..6e07f8f46c89513a469ccac4cd7a46da3e29617f 100644 (file)
--- a/inc/libs/sponsor_functions.php
+++ b/inc/libs/sponsor_functions.php
@@ -69,7 +69,7 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S
                                        $SAVE = false;
                                } else {
                                        // Do we want to add a new sponsor or update his data?
                                        $SAVE = false;
                                } else {
                                        // Do we want to add a new sponsor or update his data?

-                                       $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_sponsor_data WHERE email='%s' LIMIT 1",
+                                       $result = SQL_QUERY_ESC("SELECT id FROM `"._MYSQL_PREFIX."_sponsor_data` WHERE email='%s' LIMIT 1",

                                                array($POST['email']), __FILE__, __LINE__);
 
                                        // Is a sponsor alread in the db?
                                                array($POST['email']), __FILE__, __LINE__);
 
                                        // Is a sponsor alread in the db?


@@ -125,7 +125,7 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S
                // Update?
                if ($UPDATE) {
                        // Update his data
                // Update?
                if ($UPDATE) {
                        // Update his data

-                       $SQL = "UPDATE "._MYSQL_PREFIX."_sponsor_data SET ";
+                       $SQL = "UPDATE `"._MYSQL_PREFIX."_sponsor_data` SET ";

                        foreach ($DATA['keys'] as $k => $v) {
                                $SQL .= $v."='%s', ";
                        }
                        foreach ($DATA['keys'] as $k => $v) {
                                $SQL .= $v."='%s', ";
                        }


@@ -160,7 +160,7 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S
                        $VALUES = str_repeat("%s', '", count($DATA['values']) - 1);
 
                        // Generate string
                        $VALUES = str_repeat("%s', '", count($DATA['values']) - 1);
 
                        // Generate string

-                       $SQL = "INSERT INTO "._MYSQL_PREFIX."_sponsor_data (".$KEYS.") VALUES ('".$VALUES."%s')";
+                       $SQL = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_data` (".$KEYS.") VALUES ('".$VALUES."%s')";

 
                        // Generate message
                        $MSG = SPONSOR_GET_MESSAGE(ADMIN_SPONSOR_ADDED, "added", $MSGs);
 
                        // Generate message
                        $MSG = SPONSOR_GET_MESSAGE(ADMIN_SPONSOR_ADDED, "added", $MSGs);


@@ -264,7 +264,7 @@ function IS_SPONSOR () {
        $ret = false;
        if ((isSessionVariableSet('sponsorid'))) && (isSessionVariableSet('sponsorpass')))) {
                // Check cookies against database records...
        $ret = false;
        if ((isSessionVariableSet('sponsorid'))) && (isSessionVariableSet('sponsorpass')))) {
                // Check cookies against database records...

-               $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_sponsor_data
+               $result = SQL_QUERY_ESC("SELECT id FROM `"._MYSQL_PREFIX."_sponsor_data`

 WHERE id='%s' AND password='%s' AND status='CONFIRMED' LIMIT 1",
                        array(bigintval(get_session('sponsorid')), get_session('sponsorpass')), __FILE__, __LINE__);
                if (SQL_NUMROWS($result) == 1) {
 WHERE id='%s' AND password='%s' AND status='CONFIRMED' LIMIT 1",
                        array(bigintval(get_session('sponsorid')), get_session('sponsorpass')), __FILE__, __LINE__);
                if (SQL_NUMROWS($result) == 1) {


@@ -287,7 +287,7 @@ function GENERATE_SPONSOR_MENU($current)
        if (IS_ADMIN()) $WHERE = "";
 
        // Load main menu entries
        if (IS_ADMIN()) $WHERE = "";
 
        // Load main menu entries

-       $result_main = SQL_QUERY("SELECT action, title FROM "._MYSQL_PREFIX."_sponsor_menu
+       $result_main = SQL_QUERY("SELECT action, title FROM `"._MYSQL_PREFIX."_sponsor_menu`

 WHERE (what='' OR what IS NULL) ".$WHERE."
 ORDER BY sort", __FILE__, __LINE__);
        if (SQL_NUMROWS($result_main) > 0)
 WHERE (what='' OR what IS NULL) ".$WHERE."
 ORDER BY sort", __FILE__, __LINE__);
        if (SQL_NUMROWS($result_main) > 0)


@@ -296,7 +296,7 @@ ORDER BY sort", __FILE__, __LINE__);
                while(list($action, $title_main) = SQL_FETCHROW($result_main))
                {
                        // Load sub menus
                while(list($action, $title_main) = SQL_FETCHROW($result_main))
                {
                        // Load sub menus

-                       $result_sub = SQL_QUERY_ESC("SELECT what, title FROM "._MYSQL_PREFIX."_sponsor_menu
+                       $result_sub = SQL_QUERY_ESC("SELECT what, title FROM `"._MYSQL_PREFIX."_sponsor_menu`

 WHERE action='%s' AND what != '' AND what IS NOT NULL ".$WHERE."
 ORDER BY sort", array($action), __FILE__, __LINE__);
                        if (SQL_NUMROWS($result_sub) > 0)
 WHERE action='%s' AND what != '' AND what IS NOT NULL ".$WHERE."
 ORDER BY sort", array($action), __FILE__, __LINE__);
                        if (SQL_NUMROWS($result_sub) > 0)


@@ -374,7 +374,7 @@ function UPDATE_SPONSOR_LOGIN () {
        // Is sponsor?
        if (IS_SPONSOR()) {
                // Update last online timestamp
        // Is sponsor?
        if (IS_SPONSOR()) {
                // Update last online timestamp

-               SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data
+               SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_sponsor_data`

 SET last_online=UNIX_TIMESTAMP()
 WHERE id='%s' AND password='%s' LIMIT 1",
                        array(bigintval(get_session('sponsorid')), get_session('sponsorpass')), __FILE__, __LINE__);
 SET last_online=UNIX_TIMESTAMP()
 WHERE id='%s' AND password='%s' LIMIT 1",
                        array(bigintval(get_session('sponsorid')), get_session('sponsorpass')), __FILE__, __LINE__);


@@ -417,7 +417,7 @@ function SPONSOR_SAVE_DATA ($POST, $content) {
        $DATA = array();
 
        // Prepare SQL string
        $DATA = array();
 
        // Prepare SQL string

-       $SQL = "UPDATE "._MYSQL_PREFIX."_sponsor_data SET";
+       $SQL = "UPDATE `"._MYSQL_PREFIX."_sponsor_data` SET";

        foreach ($POST as $key => $value) {
                // Mmmmm, too less security here???
                $SQL   .= " ".strip_tags($key)."='%s',";
        foreach ($POST as $key => $value) {
                // Mmmmm, too less security here???
                $SQL   .= " ".strip_tags($key)."='%s',";

diff --git a/inc/libs/task_functions.php b/inc/libs/task_functions.php
index f0e1ed2cd71bb0ba0924ce67874f49b8c88629f2..cc989decf4893f3bef94f12e805fdbaa48d6585b 100644 (file)
--- a/inc/libs/task_functions.php
+++ b/inc/libs/task_functions.php
@@ -439,37 +439,37 @@ ORDER BY beg_points DESC, userid";
 
        if (EXT_IS_ACTIVE("sponsor")) {
                // List all sponsors
 
        if (EXT_IS_ACTIVE("sponsor")) {
                // List all sponsors

-               $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_sponsor_data ORDER BY id";
+               $SQLs[]   = "SELECT id FROM `"._MYSQL_PREFIX."_sponsor_data` ORDER BY id";

                $WHATs[]  = "list_sponsor";
                $DESCRs[] = TASK_ADMIN_LIST_SPONSOR;
                $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_TITLE;
 
                // List confirmed sponsor accounts
                $WHATs[]  = "list_sponsor";
                $DESCRs[] = TASK_ADMIN_LIST_SPONSOR;
                $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_TITLE;
 
                // List confirmed sponsor accounts

-               $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_sponsor_data WHERE status='CONFIRMED' ORDER BY id";
+               $SQLs[]   = "SELECT id FROM `"._MYSQL_PREFIX."_sponsor_data` WHERE status='CONFIRMED' ORDER BY id";

                $WHATs[]  = "list_sponsor";
                $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_CONFIRMED;
                $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_CONFIRMED_TITLE;
 
                // List unconfirmed sponsor accounts
                $WHATs[]  = "list_sponsor";
                $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_CONFIRMED;
                $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_CONFIRMED_TITLE;
 
                // List unconfirmed sponsor accounts

-               $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_sponsor_data WHERE status='UNCONFIRMED' ORDER BY id";
+               $SQLs[]   = "SELECT id FROM `"._MYSQL_PREFIX."_sponsor_data` WHERE status='UNCONFIRMED' ORDER BY id";

                $WHATs[]  = "list_sponsor";
                $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_UNCONFIRMED;
                $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_UNCONFIRMED_TITLE;
 
                // List locked sponsor accounts
                $WHATs[]  = "list_sponsor";
                $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_UNCONFIRMED;
                $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_UNCONFIRMED_TITLE;
 
                // List locked sponsor accounts

-               $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_sponsor_data WHERE status='LOCKED' ORDER BY id";
+               $SQLs[]   = "SELECT id FROM `"._MYSQL_PREFIX."_sponsor_data` WHERE status='LOCKED' ORDER BY id";

                $WHATs[]  = "list_sponsor";
                $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_LOCKED;
                $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_LOCKED_TITLE;
 
                // List waiting sponsor accounts to be approved
                $WHATs[]  = "list_sponsor";
                $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_LOCKED;
                $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_LOCKED_TITLE;
 
                // List waiting sponsor accounts to be approved

-               $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_sponsor_data WHERE status='PENDING' ORDER BY id";
+               $SQLs[]   = "SELECT id FROM `"._MYSQL_PREFIX."_sponsor_data` WHERE status='PENDING' ORDER BY id";

                $WHATs[]  = "unlock_sponsor";
                $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_PENDING;
                $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_PENDING_TITLE;
 
                // Waiting payments
                $WHATs[]  = "unlock_sponsor";
                $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_PENDING;
                $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_PENDING_TITLE;
 
                // Waiting payments

-               $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_sponsor_orders WHERE pay_status='PENDING' ORDER BY id";
+               $SQLs[]   = "SELECT id FROM `"._MYSQL_PREFIX."_sponsor_orders` WHERE pay_status='PENDING' ORDER BY id";

                $WHATs[]  = "list_sponsor_pays";
                $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_ORDERS;
                $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_ORDERS_TITLE;
                $WHATs[]  = "list_sponsor_pays";
                $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_ORDERS;
                $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_ORDERS_TITLE;

diff --git a/inc/modules/admin/what-del_sponsor.php b/inc/modules/admin/what-del_sponsor.php
index 9bf42b78303e38e8c4a7691f8043f6bc62c92998..8f850b5a2bd8aeb89724920fd524fe4174410334 100644 (file)
--- a/inc/modules/admin/what-del_sponsor.php
+++ b/inc/modules/admin/what-del_sponsor.php
@@ -42,7 +42,7 @@ ADD_DESCR("admin", __FILE__);
 
 if (!empty($_GET['id'])) {
        // Check for selected sponsor
 
 if (!empty($_GET['id'])) {
        // Check for selected sponsor

-       $result = SQL_QUERY_ESC("SELECT email, gender, surname, family FROM "._MYSQL_PREFIX."_sponsor_data WHERE id='%s' LIMIT 1",
+       $result = SQL_QUERY_ESC("SELECT email, gender, surname, family FROM `"._MYSQL_PREFIX."_sponsor_data` WHERE id='%s' LIMIT 1",

                array(bigintval($_GET['id'])), __FILE__, __LINE__);
        if (SQL_NUMROWS($result) == 1) {
                // Remove sponsor
                array(bigintval($_GET['id'])), __FILE__, __LINE__);
        if (SQL_NUMROWS($result) == 1) {
                // Remove sponsor


@@ -63,11 +63,11 @@ if (!empty($_GET['id'])) {
                        SEND_EMAIL($email, SPONSOR_ADMIN_DEL_SUBJECT, $msg);
 
                        // Remove account
                        SEND_EMAIL($email, SPONSOR_ADMIN_DEL_SUBJECT, $msg);
 
                        // Remove account

-                       SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_sponsor_data WHERE id='%s' LIMIT 1",
+                       SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `"._MYSQL_PREFIX."_sponsor_data` WHERE id='%s' LIMIT 1",

                                array(bigintval($_GET['id'])), __FILE__, __LINE__);
 
                        // Remove orders
                                array(bigintval($_GET['id'])), __FILE__, __LINE__);
 
                        // Remove orders

-                       SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_sponsor_orders WHERE sponsorid='%s' LIMIT 1",
+                       SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `"._MYSQL_PREFIX."_sponsor_orders` WHERE sponsorid='%s' LIMIT 1",

                                array(bigintval($_GET['id'])), __FILE__, __LINE__);
 
                        // Output message
                                array(bigintval($_GET['id'])), __FILE__, __LINE__);
 
                        // Output message

diff --git a/inc/modules/admin/what-edit_sponsor.php b/inc/modules/admin/what-edit_sponsor.php
index 8e496ed325bec1f24ac7dfb18dd8073e08c2a553..f265cca365cf3637e4430498fc174b8aabff4d53 100644 (file)
--- a/inc/modules/admin/what-edit_sponsor.php
+++ b/inc/modules/admin/what-edit_sponsor.php
@@ -42,7 +42,7 @@ ADD_DESCR("admin", __FILE__);
 
 if ((!empty($_GET['id'])) && (!empty($_GET['mode']))) {
        // Check for selected sponsor
 
 if ((!empty($_GET['id'])) && (!empty($_GET['mode']))) {
        // Check for selected sponsor

-       $result = SQL_QUERY_ESC("SELECT company, position, gender, surname, family, street_nr1, street_nr2, zip, city, country, phone, fax, cell, email, url, tax_ident, receive_warnings, warning_interval FROM "._MYSQL_PREFIX."_sponsor_data WHERE id='%s' LIMIT 1",
+       $result = SQL_QUERY_ESC("SELECT company, position, gender, surname, family, street_nr1, street_nr2, zip, city, country, phone, fax, cell, email, url, tax_ident, receive_warnings, warning_interval FROM `"._MYSQL_PREFIX."_sponsor_data` WHERE id='%s' LIMIT 1",

         array(bigintval($_GET['id'])), __FILE__, __LINE__);
        if (SQL_NUMROWS($result) == 1) {
                // Load sponsor details
         array(bigintval($_GET['id'])), __FILE__, __LINE__);
        if (SQL_NUMROWS($result) == 1) {
                // Load sponsor details


@@ -109,7 +109,7 @@ if ((!empty($_GET['id'])) && (!empty($_GET['mode']))) {
                                        $POINTS = strval(REVERT_COMMA($_POST['points']));
 
                                        // Add points to account
                                        $POINTS = strval(REVERT_COMMA($_POST['points']));
 
                                        // Add points to account

-                                       SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data SET points_amount=points_amount+%s WHERE id='%s' LIMIT 1",
+                                       SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_sponsor_data` SET points_amount=points_amount+%s WHERE id='%s' LIMIT 1",

                                                array($POINTS, bigintval($_GET['id'])), __FILE__, __LINE__);
 
                                        // Remember points /reason for the template
                                                array($POINTS, bigintval($_GET['id'])), __FILE__, __LINE__);
 
                                        // Remember points /reason for the template


@@ -132,7 +132,7 @@ if ((!empty($_GET['id'])) && (!empty($_GET['mode']))) {
                                        $POINTS = strval(REVERT_COMMA($_POST['points']));
 
                                        // Add points to account
                                        $POINTS = strval(REVERT_COMMA($_POST['points']));
 
                                        // Add points to account

-                                       SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data SET points_used=points_used+%s WHERE id='%s' LIMIT 1",
+                                       SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_sponsor_data` SET points_used=points_used+%s WHERE id='%s' LIMIT 1",

                                                array($POINTS, bigintval($_GET['id'])), __FILE__, __LINE__);
 
                                        // Remember points /reason for the template
                                                array($POINTS, bigintval($_GET['id'])), __FILE__, __LINE__);
 
                                        // Remember points /reason for the template

diff --git a/inc/modules/admin/what-guestedit.php b/inc/modules/admin/what-guestedit.php
index b4161cb7c9c5c4d5b9fd274d34ad76f02d75f13b..b9b23e6f18d5dc43db8417a59451700398502af4 100644 (file)
--- a/inc/modules/admin/what-guestedit.php
+++ b/inc/modules/admin/what-guestedit.php
@@ -279,10 +279,10 @@ if ((isset($_POST['edit'])) && ($chk > 0) && (!IS_DEMO()))
        // By default list menus
        if (empty($SUB)) {
                // List only main menus
        // By default list menus
        if (empty($SUB)) {
                // List only main menus

-               $result = SQL_QUERY("SELECT id, action, what, title, sort FROM `"._MYSQL_PREFIX."_guest_menu` WHERE (what='' OR what IS NULL) ORDER BY sort ASC", __FILE__, __LINE__);
+               $result = SQL_QUERY("SELECT `id`, `action`, `what`, `title`, `sort` FROM `"._MYSQL_PREFIX."_guest_menu` WHERE (`what`='' OR `what` IS NULL) ORDER BY `sort` ASC", __FILE__, __LINE__);

        } else {
                // List sub menus
        } else {
                // List sub menus

-               $result = SQL_QUERY_ESC("SELECT id, action, what, title, sort FROM `"._MYSQL_PREFIX."_guest_menu` WHERE action='%s' AND what != '' AND what IS NOT NULL ORDER BY sort ASC",
+               $result = SQL_QUERY_ESC("SELECT `id`, `action`, `what`, `title`, `sort` FROM `"._MYSQL_PREFIX."_guest_menu` WHERE `action`='%s' AND `what` != '' AND `what` IS NOT NULL ORDER BY `sort` ASC",

                 array($SUB), __FILE__, __LINE__);
        }
 
                 array($SUB), __FILE__, __LINE__);
        }
 

diff --git a/inc/modules/admin/what-list_sponsor.php b/inc/modules/admin/what-list_sponsor.php
index 8d4659103830b9f711b18b8e0f3646e2207f2f95..3aceeb5f013919132338db90f9d35b180f91f7c8 100644 (file)
--- a/inc/modules/admin/what-list_sponsor.php
+++ b/inc/modules/admin/what-list_sponsor.php
@@ -43,7 +43,7 @@ ADD_DESCR("admin", __FILE__);
 if (!empty($_GET['id'])) {
        // Show detailed informations to a sponsor
        $result = SQL_QUERY_ESC("SELECT company, position, gender, surname, family, street_nr1, street_nr2, zip, city, country, phone, fax, cell, email, url, tax_ident, status, sponsor_created, last_online, last_change, receive_warnings, points_amount, points_used, remote_addr, warning_interval, refid, ref_count
 if (!empty($_GET['id'])) {
        // Show detailed informations to a sponsor
        $result = SQL_QUERY_ESC("SELECT company, position, gender, surname, family, street_nr1, street_nr2, zip, city, country, phone, fax, cell, email, url, tax_ident, status, sponsor_created, last_online, last_change, receive_warnings, points_amount, points_used, remote_addr, warning_interval, refid, ref_count

-FROM "._MYSQL_PREFIX."_sponsor_data
+FROM `"._MYSQL_PREFIX."_sponsor_data`

 WHERE id='%s' LIMIT 1",
  array(bigintval($_GET['id'])), __FILE__, __LINE__);
 
 WHERE id='%s' LIMIT 1",
  array(bigintval($_GET['id'])), __FILE__, __LINE__);
 


@@ -58,7 +58,7 @@ WHERE id='%s' LIMIT 1",
                }
 
                // Check for sponsor's orders (only count)
                }
 
                // Check for sponsor's orders (only count)

-               $result_orders = SQL_QUERY_ESC("SELECT COUNT(id) FROM "._MYSQL_PREFIX."_sponsor_orders WHERE sponsorid='%s'",
+               $result_orders = SQL_QUERY_ESC("SELECT COUNT(id) FROM `"._MYSQL_PREFIX."_sponsor_orders` WHERE sponsorid='%s'",

                 array(bigintval($_GET['id'])), __FILE__, __LINE__);
                list($orders) = SQL_FETCHROW($result_orders);
                SQL_FREERESULT($result_orders);
                 array(bigintval($_GET['id'])), __FILE__, __LINE__);
                list($orders) = SQL_FETCHROW($result_orders);
                SQL_FREERESULT($result_orders);


@@ -113,7 +113,7 @@ WHERE id='%s' LIMIT 1",
        }
 } elseif (!empty($_GET['rid'])) {
        // Search for sponsor
        }
 } elseif (!empty($_GET['rid'])) {
        // Search for sponsor

-       $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_sponsor_data WHERE id='%s' LIMIT 1",
+       $result = SQL_QUERY_ESC("SELECT id FROM `"._MYSQL_PREFIX."_sponsor_data` WHERE id='%s' LIMIT 1",

         array(bigintval($_GET['rid'])), __FILE__, __LINE__);
        if (SQL_NUMROWS($result) == 1) {
                // Free memory
         array(bigintval($_GET['rid'])), __FILE__, __LINE__);
        if (SQL_NUMROWS($result) == 1) {
                // Free memory


@@ -121,7 +121,7 @@ WHERE id='%s' LIMIT 1",
 
                // Sponsor found so let's list all his referals
                $result = SQL_QUERY_ESC("SELECT id, gender, surname, family, email, status, sponsor_created, last_online, points_amount, points_used, remote_addr, ref_count
 
                // Sponsor found so let's list all his referals
                $result = SQL_QUERY_ESC("SELECT id, gender, surname, family, email, status, sponsor_created, last_online, points_amount, points_used, remote_addr, ref_count

-FROM "._MYSQL_PREFIX."_sponsor_data
+FROM `"._MYSQL_PREFIX."_sponsor_data`

 WHERE refid='%s' ORDER BY id",
  array(bigintval($_GET['rid'])), __FILE__, __LINE__);
 
 WHERE refid='%s' ORDER BY id",
  array(bigintval($_GET['rid'])), __FILE__, __LINE__);
 


@@ -140,7 +140,7 @@ WHERE refid='%s' ORDER BY id",
 } else {
        // List all sponsors
        $result_main = SQL_QUERY("SELECT id, gender, surname, family, email, status, sponsor_created, last_online, points_amount, points_used, remote_addr
 } else {
        // List all sponsors
        $result_main = SQL_QUERY("SELECT id, gender, surname, family, email, status, sponsor_created, last_online, points_amount, points_used, remote_addr

-FROM "._MYSQL_PREFIX."_sponsor_data ORDER BY id", __FILE__, __LINE__);
+FROM `"._MYSQL_PREFIX."_sponsor_data` ORDER BY id", __FILE__, __LINE__);

        if (SQL_NUMROWS($result_main) > 0) {
                // At least one sponsor found!
                $OUT = ""; $SW = 2;
        if (SQL_NUMROWS($result_main) > 0) {
                // At least one sponsor found!
                $OUT = ""; $SW = 2;

diff --git a/inc/modules/admin/what-list_sponsor_pay.php b/inc/modules/admin/what-list_sponsor_pay.php
index e8052b9a08ccafa0ea05698cb726089fe82343ee..7d6cace8eaca5da219af01b5b00aab2deae47619 100644 (file)
--- a/inc/modules/admin/what-list_sponsor_pay.php
+++ b/inc/modules/admin/what-list_sponsor_pay.php
@@ -64,7 +64,7 @@ if (isset($_POST['add'])) {
                        $id = bigintval($id);
 
                        // Save entry
                        $id = bigintval($id);
 
                        // Save entry

-                       SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_paytypes
+                       SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_sponsor_paytypes`

 SET pay_name='%s', pay_rate='%s', pay_min_count='%s', pay_currency='%s' WHERE id='%s' LIMIT 1",
  array($_POST['name'][$id], $_POST['rate'][$id], bigintval($_POST['min'][$id]), $_POST['curr'][$id], $id),
  __FILE__, __LINE__);
 SET pay_name='%s', pay_rate='%s', pay_min_count='%s', pay_currency='%s' WHERE id='%s' LIMIT 1",
  array($_POST['name'][$id], $_POST['rate'][$id], bigintval($_POST['min'][$id]), $_POST['curr'][$id], $id),
  __FILE__, __LINE__);


@@ -76,7 +76,7 @@ SET pay_name='%s', pay_rate='%s', pay_min_count='%s', pay_currency='%s' WHERE id
                // Remove entries here...
                foreach ($_POST['id'] as $id => $sel) {
                        // Remove entry
                // Remove entries here...
                foreach ($_POST['id'] as $id => $sel) {
                        // Remove entry

-                       SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_sponsor_paytypes WHERE id='%s' LIMIT 1",
+                       SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `"._MYSQL_PREFIX."_sponsor_paytypes` WHERE id='%s' LIMIT 1",

                                array(bigintval($id)), __FILE__, __LINE__);
                }
 
                                array(bigintval($id)), __FILE__, __LINE__);
                }
 


@@ -93,11 +93,11 @@ SET pay_name='%s', pay_rate='%s', pay_min_count='%s', pay_currency='%s' WHERE id
 
 if (isset($_POST['add'])) {
        // Check if entry with same name does exists
 
 if (isset($_POST['add'])) {
        // Check if entry with same name does exists

-       $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_sponsor_paytypes WHERE pay_name='%s' LIMIT 1",
+       $result = SQL_QUERY_ESC("SELECT id FROM `"._MYSQL_PREFIX."_sponsor_paytypes` WHERE pay_name='%s' LIMIT 1",

         array($_POST['pay_name']), __FILE__, __LINE__);
        if (SQL_NUMROWS($result) == 0) {
                // No entry found so add this line
         array($_POST['pay_name']), __FILE__, __LINE__);
        if (SQL_NUMROWS($result) == 0) {
                // No entry found so add this line

-               SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_sponsor_paytypes (pay_name, pay_rate, pay_min_count, pay_currency)
+               SQL_QUERY_ESC("INSERT INTO `"._MYSQL_PREFIX."_sponsor_paytypes` (pay_name, pay_rate, pay_min_count, pay_currency)

  VALUES ('%s','%s','%s','%s')",
  array(htmlspecialchars($_POST['pay_name']), REVERT_COMMA($_POST['pay_rate']), bigintval($_POST['pay_min_count']), htmlspecialchars($_POST['pay_currency'])),
  __FILE__, __LINE__);
  VALUES ('%s','%s','%s','%s')",
  array(htmlspecialchars($_POST['pay_name']), REVERT_COMMA($_POST['pay_rate']), bigintval($_POST['pay_min_count']), htmlspecialchars($_POST['pay_currency'])),
  __FILE__, __LINE__);


@@ -120,7 +120,7 @@ if (isset($_POST['add'])) {
        $OUT = ""; $SW = 2;
        foreach ($_POST['id'] as $id => $sel) {
                // Load entry
        $OUT = ""; $SW = 2;
        foreach ($_POST['id'] as $id => $sel) {
                // Load entry

-               $result = SQL_QUERY_ESC("SELECT pay_name, pay_rate, pay_min_count, pay_currency FROM "._MYSQL_PREFIX."_sponsor_paytypes WHERE id='%s' LIMIT 1",
+               $result = SQL_QUERY_ESC("SELECT pay_name, pay_rate, pay_min_count, pay_currency FROM `"._MYSQL_PREFIX."_sponsor_paytypes` WHERE id='%s' LIMIT 1",

                 array(bigintval($id)), __FILE__, __LINE__);
                if (SQL_NUMROWS($result) == 1) {
                        // Load data
                 array(bigintval($id)), __FILE__, __LINE__);
                if (SQL_NUMROWS($result) == 1) {
                        // Load data


@@ -166,7 +166,7 @@ if (isset($_POST['add'])) {
        }
 } else {
        // Load all payment types
        }
 } else {
        // Load all payment types

-       $result = SQL_QUERY("SELECT id, pay_name, pay_rate, pay_min_count, pay_currency FROM "._MYSQL_PREFIX."_sponsor_paytypes ORDER BY pay_name",
+       $result = SQL_QUERY("SELECT id, pay_name, pay_rate, pay_min_count, pay_currency FROM `"._MYSQL_PREFIX."_sponsor_paytypes` ORDER BY pay_name",

         __FILE__, __LINE__);
 
        // Do we have some paytypes setup?
         __FILE__, __LINE__);
 
        // Do we have some paytypes setup?

diff --git a/inc/modules/admin/what-list_sponsor_pays.php b/inc/modules/admin/what-list_sponsor_pays.php
index 146536da7aa627289bc69fcab2a7fa483e6ec058..39038484becfe2389498ab757b0eb393b6944e8d 100644 (file)
--- a/inc/modules/admin/what-list_sponsor_pays.php
+++ b/inc/modules/admin/what-list_sponsor_pays.php
@@ -42,7 +42,7 @@ ADD_DESCR("admin", __FILE__);
 
 if (!empty($_GET['id'])) {
        // Check for selected sponsor
 
 if (!empty($_GET['id'])) {
        // Check for selected sponsor

-       $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_sponsor_data WHERE id='%s' LIMIT 1",
+       $result = SQL_QUERY_ESC("SELECT id FROM `"._MYSQL_PREFIX."_sponsor_data` WHERE id='%s' LIMIT 1",

         array(bigintval($_GET['id'])), __FILE__, __LINE__);
        if (SQL_NUMROWS($result) == 1) {
                // ...
         array(bigintval($_GET['id'])), __FILE__, __LINE__);
        if (SQL_NUMROWS($result) == 1) {
                // ...

diff --git a/inc/modules/admin/what-lock_sponsor.php b/inc/modules/admin/what-lock_sponsor.php
index 96d40ae5b0a48571915c38e3534d3fc24b8fb662..53034beb33f29dd45c3300949a8f951c8c1ade5d 100644 (file)
--- a/inc/modules/admin/what-lock_sponsor.php
+++ b/inc/modules/admin/what-lock_sponsor.php
@@ -43,7 +43,7 @@ $MSG = "";
 
 if (!empty($_GET['id'])) {
        // Check for selected sponsor
 
 if (!empty($_GET['id'])) {
        // Check for selected sponsor

-       $result = SQL_QUERY_ESC("SELECT gender, surname, family, email, status FROM "._MYSQL_PREFIX."_sponsor_data WHERE id='%s' LIMIT 1",
+       $result = SQL_QUERY_ESC("SELECT gender, surname, family, email, status FROM `"._MYSQL_PREFIX."_sponsor_data` WHERE id='%s' LIMIT 1",

         array(bigintval($_GET['id'])), __FILE__, __LINE__);
        if (SQL_NUMROWS($result) == 1) {
                // Get sponsor's current status and let only confirmed and locked status pass
         array(bigintval($_GET['id'])), __FILE__, __LINE__);
        if (SQL_NUMROWS($result) == 1) {
                // Get sponsor's current status and let only confirmed and locked status pass


@@ -78,7 +78,7 @@ if (!empty($_GET['id'])) {
                                SEND_EMAIL($email, $subject, $msg);
 
                                // Update sponsor's account
                                SEND_EMAIL($email, $subject, $msg);
 
                                // Update sponsor's account

-                               SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data SET status='".$status."' WHERE id='%s' LIMIT 1",
+                               SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_sponsor_data` SET status='".$status."' WHERE id='%s' LIMIT 1",

                                        array(bigintval($_GET['id'])), __FILE__, __LINE__);
                        } elseif (!empty($_POST['no'])) {
                                // No don't lock / unlock now!
                                        array(bigintval($_GET['id'])), __FILE__, __LINE__);
                        } elseif (!empty($_POST['no'])) {
                                // No don't lock / unlock now!

diff --git a/inc/modules/admin/what-unlock_sponsor.php b/inc/modules/admin/what-unlock_sponsor.php
index 0e959659de2e299136e4c8a354bb99d64ae97195..bed2bab1f14e21e953dd27f5c741a258bd1d1e70 100644 (file)
--- a/inc/modules/admin/what-unlock_sponsor.php
+++ b/inc/modules/admin/what-unlock_sponsor.php
@@ -51,7 +51,7 @@ if (isset($_POST['ok'])) {
 
                        // Load his personal data
                        $result_main = SQL_QUERY_ESC("SELECT gender, surname, family, email, remote_addr, sponsor_created, points_amount, refid
 
                        // Load his personal data
                        $result_main = SQL_QUERY_ESC("SELECT gender, surname, family, email, remote_addr, sponsor_created, points_amount, refid

-FROM "._MYSQL_PREFIX."_sponsor_data
+FROM `"._MYSQL_PREFIX."_sponsor_data`

 WHERE status='PENDING' AND id='%s' LIMIT 1",
  array($id), __FILE__, __LINE__);
                        $refid = 0;
 WHERE status='PENDING' AND id='%s' LIMIT 1",
  array($id), __FILE__, __LINE__);
                        $refid = 0;


@@ -62,8 +62,8 @@ WHERE status='PENDING' AND id='%s' LIMIT 1",
                                // Check for open payments and close them
                                $result = SQL_QUERY_ESC("SELECT DISTINCT so.aid, so.pay_count, so.pay_ordered, so.pay_status,
 sp.pay_name, sp.pay_rate, sp.pay_currency
                                // Check for open payments and close them
                                $result = SQL_QUERY_ESC("SELECT DISTINCT so.aid, so.pay_count, so.pay_ordered, so.pay_status,
 sp.pay_name, sp.pay_rate, sp.pay_currency

-FROM "._MYSQL_PREFIX."_sponsor_orders AS so
-LEFT JOIN "._MYSQL_PREFIX."_sponsor_paytypes AS sp
+FROM `"._MYSQL_PREFIX."_sponsor_orders` AS so
+LEFT JOIN `"._MYSQL_PREFIX."_sponsor_paytypes` AS sp

 ON sp.id=so.payid
 WHERE so.sponsorid='%s'
 ORDER BY sp.pay_name",
 ON sp.id=so.payid
 WHERE so.sponsorid='%s'
 ORDER BY sp.pay_name",


@@ -103,14 +103,14 @@ ORDER BY sp.pay_name",
                        SQL_FREERESULT($result_main);
 
                        // Unlock sponsor account
                        SQL_FREERESULT($result_main);
 
                        // Unlock sponsor account

-                       SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data SET status='CONFIRMED'
+                       SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_sponsor_data` SET status='CONFIRMED'

 WHERE id='%s' AND status='PENDING' LIMIT 1",
  array($id), __FILE__, __LINE__);
 
                        // Update, if applyable, referal count and points
                        if (($refid > 0) && ($refid != $id)) {
                                // Update referal account
 WHERE id='%s' AND status='PENDING' LIMIT 1",
  array($id), __FILE__, __LINE__);
 
                        // Update, if applyable, referal count and points
                        if (($refid > 0) && ($refid != $id)) {
                                // Update referal account

-                               SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data
+                               SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_sponsor_data`

 SET points_amount=points_amount+%s, ref_count=ref_count+1
 WHERE id='%s' LIMIT 1",
  array(getConfig('sponsor_ref_points'), bigintval($refid)), __FILE__, __LINE__);
 SET points_amount=points_amount+%s, ref_count=ref_count+1
 WHERE id='%s' LIMIT 1",
  array(getConfig('sponsor_ref_points'), bigintval($refid)), __FILE__, __LINE__);


@@ -120,7 +120,7 @@ WHERE id='%s' LIMIT 1",
                                        // Load referal's data
                                        $result = SQL_QUERY_ESC("SELECT id, gender, surname, family, email,
 (points_amount - points_used) AS points, receive_warnings, ref_count AS refs
                                        // Load referal's data
                                        $result = SQL_QUERY_ESC("SELECT id, gender, surname, family, email,
 (points_amount - points_used) AS points, receive_warnings, ref_count AS refs

-FROM "._MYSQL_PREFIX."_sponsor_data
+FROM `"._MYSQL_PREFIX."_sponsor_data`

 WHERE id='%s' LIMIT 1",
  array(bigintval($refid)), __FILE__, __LINE__);
                                        $REFERRAL = SQL_FETCHARRAY($result);
 WHERE id='%s' LIMIT 1",
  array(bigintval($refid)), __FILE__, __LINE__);
                                        $REFERRAL = SQL_FETCHARRAY($result);


@@ -164,7 +164,7 @@ WHERE id='%s' LIMIT 1",
 
 // Begin listing of all pending sponsor accounts
 $result = SQL_QUERY("SELECT id, gender, surname, family, email, remote_addr, sponsor_created
 
 // Begin listing of all pending sponsor accounts
 $result = SQL_QUERY("SELECT id, gender, surname, family, email, remote_addr, sponsor_created

-FROM "._MYSQL_PREFIX."_sponsor_data
+FROM `"._MYSQL_PREFIX."_sponsor_data`

 WHERE status='PENDING' ORDER BY id", __FILE__, __LINE__);
 
 if (SQL_NUMROWS($result) > 0) {
 WHERE status='PENDING' ORDER BY id", __FILE__, __LINE__);
 
 if (SQL_NUMROWS($result) > 0) {

diff --git a/inc/modules/guest/what-sponsor_infos.php b/inc/modules/guest/what-sponsor_infos.php
index 1c999753f518c9b7acbec8fa27d388bb75543fc0..7dbcd2fdd665563783b66003b85f1cb6f619f4ea 100644 (file)
--- a/inc/modules/guest/what-sponsor_infos.php
+++ b/inc/modules/guest/what-sponsor_infos.php
@@ -51,9 +51,9 @@ unset($result_act);
 
 // Load all sponsor actions
 $result_act = SQL_QUERY("SELECT DISTINCT m.title, c.conv_rate, c.conv_name
 
 // Load all sponsor actions
 $result_act = SQL_QUERY("SELECT DISTINCT m.title, c.conv_rate, c.conv_name

-FROM "._MYSQL_PREFIX."_sponsor_menu AS m
-LEFT JOIN "._MYSQL_PREFIX."_sponsor_action_convert AS c ON m.what=c.ext_name
-LEFT JOIN "._MYSQL_PREFIX."_sponsor_registry AS r ON m.what=r.ext_name
+FROM `"._MYSQL_PREFIX."_sponsor_menu` AS m
+LEFT JOIN `"._MYSQL_PREFIX."_sponsor_action_convert` AS c ON m.what=c.ext_name
+LEFT JOIN `"._MYSQL_PREFIX."_sponsor_registry` AS r ON m.what=r.ext_name

 WHERE m.action='actions' AND r.is_active='Y'
 ORDER BY m.sort ASC", __FILE__, __LINE__);
 $num_act = SQL_NUMROWS($result_act);
 WHERE m.action='actions' AND r.is_active='Y'
 ORDER BY m.sort ASC", __FILE__, __LINE__);
 $num_act = SQL_NUMROWS($result_act);


@@ -76,7 +76,7 @@ if ($num_act > 0) {
        } // END - while
 
        // Check for pay types
        } // END - while
 
        // Check for pay types

-       $result_pay = SQL_QUERY("SELECT pay_name, pay_rate, pay_min_count, pay_currency FROM "._MYSQL_PREFIX."_sponsor_paytypes ORDER BY pay_name", __FILE__, __LINE__);
+       $result_pay = SQL_QUERY("SELECT pay_name, pay_rate, pay_min_count, pay_currency FROM `"._MYSQL_PREFIX."_sponsor_paytypes` ORDER BY pay_name", __FILE__, __LINE__);

        if (SQL_NUMROWS($result_pay) > 0) {
                // Load all pay types
                $OUT_PAY = ""; $SW = 2;
        if (SQL_NUMROWS($result_pay) > 0) {
                // Load all pay types
                $OUT_PAY = ""; $SW = 2;

diff --git a/inc/modules/guest/what-sponsor_login.php b/inc/modules/guest/what-sponsor_login.php
index c175a55b8b59b477fbb426993662d2b94635b12c..b81d0b51b01e61f4b80d1f4289e5d116a36f3913 100644 (file)
--- a/inc/modules/guest/what-sponsor_login.php
+++ b/inc/modules/guest/what-sponsor_login.php
@@ -63,7 +63,7 @@ if (!empty($_GET['hash'])) {
 company, position, tax_ident,
 street_nr1, street_nr2, country, zip, city, email, phone, fax, cell,
 points_amount AS points, last_pay AS pay, last_curr AS curr
 company, position, tax_ident,
 street_nr1, street_nr2, country, zip, city, email, phone, fax, cell,
 points_amount AS points, last_pay AS pay, last_curr AS curr

-FROM "._MYSQL_PREFIX."_sponsor_data
+FROM `"._MYSQL_PREFIX."_sponsor_data`

 WHERE hash='%s' AND (status='UNCONFIRMED' OR status='EMAIL')
 LIMIT 1", array($_GET['hash']), __FILE__, __LINE__);
        if (SQL_NUMROWS($result) == 1) {
 WHERE hash='%s' AND (status='UNCONFIRMED' OR status='EMAIL')
 LIMIT 1", array($_GET['hash']), __FILE__, __LINE__);
        if (SQL_NUMROWS($result) == 1) {


@@ -78,7 +78,7 @@ LIMIT 1", array($_GET['hash']), __FILE__, __LINE__);
                // Unconfirmed account or changed email address?
                if ($SPONSOR['status'] == "UNCONFIRMED") {
                        // Set account to pending
                // Unconfirmed account or changed email address?
                if ($SPONSOR['status'] == "UNCONFIRMED") {
                        // Set account to pending

-                       SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data SET status='PENDING'
+                       SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_sponsor_data` SET status='PENDING'

 WHERE id='%s' AND hash='%s' AND status='UNCONFIRMED' LIMIT 1",
  array(bigintval($SPONSOR['id']), $_GET['hash']), __FILE__, __LINE__);
 
 WHERE id='%s' AND hash='%s' AND status='UNCONFIRMED' LIMIT 1",
  array(bigintval($SPONSOR['id']), $_GET['hash']), __FILE__, __LINE__);
 


@@ -99,7 +99,7 @@ WHERE id='%s' AND hash='%s' AND status='UNCONFIRMED' LIMIT 1",
                        }
                } elseif ($SPONSOR['status'] == "EMAIL") {
                        // Changed email adress need to be confirmed
                        }
                } elseif ($SPONSOR['status'] == "EMAIL") {
                        // Changed email adress need to be confirmed

-                       SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data SET status='CONFIRMED'
+                       SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_sponsor_data` SET status='CONFIRMED'

 WHERE id='%s' AND hash='%s' AND status='EMAIL' LIMIT 1",
  array(bigintval($SPONSOR['id']), $_GET['hash']), __FILE__, __LINE__);
 
 WHERE id='%s' AND hash='%s' AND status='EMAIL' LIMIT 1",
  array(bigintval($SPONSOR['id']), $_GET['hash']), __FILE__, __LINE__);
 


@@ -132,7 +132,7 @@ WHERE id='%s' AND hash='%s' AND status='EMAIL' LIMIT 1",
        if (isset($_POST['ok'])) {
                // Check email
                $result = SQL_QUERY_ESC("SELECT id, hash, status, remote_addr, gender, surname, family, sponsor_created
        if (isset($_POST['ok'])) {
                // Check email
                $result = SQL_QUERY_ESC("SELECT id, hash, status, remote_addr, gender, surname, family, sponsor_created

-FROM "._MYSQL_PREFIX."_sponsor_data
+FROM `"._MYSQL_PREFIX."_sponsor_data`

 WHERE email='%s' AND (status='UNCONFIRMED' OR status='EMAIL') LIMIT 1",
                        array($_POST['email']), __FILE__, __LINE__);
 
 WHERE email='%s' AND (status='UNCONFIRMED' OR status='EMAIL') LIMIT 1",
                        array($_POST['email']), __FILE__, __LINE__);
 


@@ -178,7 +178,7 @@ WHERE email='%s' AND (status='UNCONFIRMED' OR status='EMAIL') LIMIT 1",
        if (isset($_POST['ok'])) {
                // Check email
                $result = SQL_QUERY_ESC("SELECT id, hash, remote_addr, gender, surname, family, sponsor_created
        if (isset($_POST['ok'])) {
                // Check email
                $result = SQL_QUERY_ESC("SELECT id, hash, remote_addr, gender, surname, family, sponsor_created

-FROM "._MYSQL_PREFIX."_sponsor_data
+FROM `"._MYSQL_PREFIX."_sponsor_data`

 WHERE email='%s' AND id='%s' AND status='CONFIRMED' LIMIT 1",
                        array($_POST['email'], bigintval($_POST['id'])), __FILE__, __LINE__);
                // Entry found?
 WHERE email='%s' AND id='%s' AND status='CONFIRMED' LIMIT 1",
                        array($_POST['email'], bigintval($_POST['id'])), __FILE__, __LINE__);
                // Entry found?


@@ -198,7 +198,7 @@ WHERE email='%s' AND id='%s' AND status='CONFIRMED' LIMIT 1",
                        SEND_EMAIL($_POST['email'], SPONSOR_LOST_PASSWORD_SUBJ, $msg_sponsor);
 
                        // Update password
                        SEND_EMAIL($_POST['email'], SPONSOR_LOST_PASSWORD_SUBJ, $msg_sponsor);
 
                        // Update password

-                       SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data SET password='%s'
+                       SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_sponsor_data` SET password='%s'

 WHERE id='%s' LIMIT 1",
  array(md5($SPONSOR['password']), bigintval($SPONSOR['id'])), __FILE__, __LINE__);
 
 WHERE id='%s' LIMIT 1",
  array(md5($SPONSOR['password']), bigintval($SPONSOR['id'])), __FILE__, __LINE__);
 


@@ -217,7 +217,7 @@ WHERE id='%s' LIMIT 1",
        }
 } elseif (isset($_POST['ok'])) {
        // Check status and login data ...
        }
 } elseif (isset($_POST['ok'])) {
        // Check status and login data ...

-       $result = SQL_QUERY_ESC("SELECT status FROM "._MYSQL_PREFIX."_sponsor_data
+       $result = SQL_QUERY_ESC("SELECT status FROM `"._MYSQL_PREFIX."_sponsor_data`

 WHERE id='%s' AND password='%s' LIMIT 1",
  array(bigintval($_POST['sponsorid']), md5($_POST['pass'])), __FILE__, __LINE__);
        if (SQL_NUMROWS($result) == 1) {
 WHERE id='%s' AND password='%s' LIMIT 1",
  array(bigintval($_POST['sponsorid']), md5($_POST['pass'])), __FILE__, __LINE__);
        if (SQL_NUMROWS($result) == 1) {

diff --git a/inc/modules/guest/what-sponsor_reg.php b/inc/modules/guest/what-sponsor_reg.php
index d718d37849b21682924db227ef0f9ebda0e26c96..cfd9279b35f8569408ddb486c4a4c12e632b6c12 100644 (file)
--- a/inc/modules/guest/what-sponsor_reg.php
+++ b/inc/modules/guest/what-sponsor_reg.php
@@ -211,7 +211,7 @@ if ((isset($_POST['ok'])) && (count($FORM_ERRORS) == 0)) {
 
        // Calulate points
        $result = SQL_QUERY_ESC("SELECT (pay_rate * pay_min_count) AS points, pay_min_count AS pay, pay_currency AS curr
 
        // Calulate points
        $result = SQL_QUERY_ESC("SELECT (pay_rate * pay_min_count) AS points, pay_min_count AS pay, pay_currency AS curr

-FROM "._MYSQL_PREFIX."_sponsor_paytypes
+FROM `"._MYSQL_PREFIX."_sponsor_paytypes`

 WHERE id='%s' LIMIT 1", array($_POST['pay_type']), __FILE__, __LINE__);
        list($points, $pay, $curr) = SQL_FETCHROW($result);
 
 WHERE id='%s' LIMIT 1", array($_POST['pay_type']), __FILE__, __LINE__);
        list($points, $pay, $curr) = SQL_FETCHROW($result);
 


@@ -232,7 +232,7 @@ WHERE id='%s' LIMIT 1", array($_POST['pay_type']), __FILE__, __LINE__);
        {
        case "added": // Sponsor successfully added with account status = UNCONFIRMED!
                // Check for his ID number
        {
        case "added": // Sponsor successfully added with account status = UNCONFIRMED!
                // Check for his ID number

-               $result = SQL_QUERY_ESC("SELECT id, hash FROM "._MYSQL_PREFIX."_sponsor_data WHERE email='%s' LIMIT 1",
+               $result = SQL_QUERY_ESC("SELECT id, hash FROM `"._MYSQL_PREFIX."_sponsor_data` WHERE email='%s' LIMIT 1",

                 array($_POST['email']), __FILE__, __LINE__);
                if (SQL_NUMROWS($result) == 1)
                {
                 array($_POST['email']), __FILE__, __LINE__);
                if (SQL_NUMROWS($result) == 1)
                {


@@ -286,7 +286,7 @@ WHERE id='%s' LIMIT 1", array($_POST['pay_type']), __FILE__, __LINE__);
 } else {
        // Check for payment types
        $result = SQL_QUERY("SELECT id, pay_name, pay_rate, pay_currency, pay_min_count
 } else {
        // Check for payment types
        $result = SQL_QUERY("SELECT id, pay_name, pay_rate, pay_currency, pay_min_count

-FROM "._MYSQL_PREFIX."_sponsor_paytypes
+FROM `"._MYSQL_PREFIX."_sponsor_paytypes`

 ORDER BY pay_name", __FILE__, __LINE__);
        if (SQL_NUMROWS($result) > 0) {
                // Load all types...
 ORDER BY pay_name", __FILE__, __LINE__);
        if (SQL_NUMROWS($result) > 0) {
                // Load all types...

diff --git a/inc/modules/sponsor/account.php b/inc/modules/sponsor/account.php
index 747104be271497a12d118b849743e62c0dfc5403..d13ff959c823e013da9e661ccf15d23bd5ee5e30 100644 (file)
--- a/inc/modules/sponsor/account.php
+++ b/inc/modules/sponsor/account.php
@@ -48,7 +48,7 @@ $result = SQL_QUERY_ESC("SELECT company, position, tax_ident,
 gender, surname, family, street_nr1, street_nr2, zip, city, country,
 phone, fax, cell, email, url,
 status, receive_warnings
 gender, surname, family, street_nr1, street_nr2, zip, city, country,
 phone, fax, cell, email, url,
 status, receive_warnings

-FROM "._MYSQL_PREFIX."_sponsor_data
+FROM `"._MYSQL_PREFIX."_sponsor_data`

 WHERE id='%s' AND password='%s' LIMIT 1",
  array(bigintval(get_session('sponsorid')), get_session('sponsorpass')), __FILE__, __LINE__);
 if (SQL_NUMROWS($result) == 1) {
 WHERE id='%s' AND password='%s' LIMIT 1",
  array(bigintval(get_session('sponsorid')), get_session('sponsorpass')), __FILE__, __LINE__);
 if (SQL_NUMROWS($result) == 1) {

diff --git a/inc/modules/sponsor/settings.php b/inc/modules/sponsor/settings.php
index b1b2464830890761a6de2a21c888397d3d1c2576..7b846b9a8f5f4347932fa07f43a5664c7bf772a1 100644 (file)
--- a/inc/modules/sponsor/settings.php
+++ b/inc/modules/sponsor/settings.php
@@ -45,7 +45,7 @@ if (!defined('__SECURITY')) {
 
 // Data for the formular
 $result = SQL_QUERY_ESC("SELECT status, receive_warnings, warning_interval, email, surname, family, gender
 
 // Data for the formular
 $result = SQL_QUERY_ESC("SELECT status, receive_warnings, warning_interval, email, surname, family, gender

-FROM "._MYSQL_PREFIX."_sponsor_data
+FROM `"._MYSQL_PREFIX."_sponsor_data`

 WHERE id='%s' AND password='%s' LIMIT 1",
  array(bigintval(get_session('sponsorid')), get_session('sponsorpass')), __FILE__, __LINE__);
 if (SQL_NUMROWS($result) == 1) {
 WHERE id='%s' AND password='%s' LIMIT 1",
  array(bigintval(get_session('sponsorid')), get_session('sponsorpass')), __FILE__, __LINE__);
 if (SQL_NUMROWS($result) == 1) {

diff --git a/inc/modules/sponsor/welcome.php b/inc/modules/sponsor/welcome.php
index 0c4be620507e9360bbeaa5c4310091d55147f51c..f8362058097419b755a359ea04a051ee549ae34e 100644 (file)
--- a/inc/modules/sponsor/welcome.php
+++ b/inc/modules/sponsor/welcome.php
@@ -45,7 +45,7 @@ if (!defined('__SECURITY')) {
 
 // Load some data
 $result = SQL_QUERY_ESC("SELECT gender, surname, family, (points_amount - points_used) AS points
 
 // Load some data
 $result = SQL_QUERY_ESC("SELECT gender, surname, family, (points_amount - points_used) AS points

-FROM "._MYSQL_PREFIX."_sponsor_data
+FROM `"._MYSQL_PREFIX."_sponsor_data`

 WHERE id='%s' AND password='%s' LIMIT 1",
  array(bigintval(get_session('sponsorid')), get_session('sponsorpass')), __FILE__, __LINE__);
 list($gender, $surname, $family, $points) = SQL_FETCHROW($result);
 WHERE id='%s' AND password='%s' LIMIT 1",
  array(bigintval(get_session('sponsorid')), get_session('sponsorpass')), __FILE__, __LINE__);
 list($gender, $surname, $family, $points) = SQL_FETCHROW($result);

diff --git a/templates/de/html/ext/ext_logs.tpl b/templates/de/html/ext/ext_logs.tpl
new file mode 100644 (file)
index 0000000..dac00a3
--- /dev/null
+++ b/templates/de/html/ext/ext_logs.tpl
@@ -0,0 +1,3 @@
+Verwalten und Downloaden Sie die access_logs von Ihrem Server.
+<strong>Wichtig:</strong> Dies muss auch von Ihrem Server unterst&uuml;tzt
+sein!

diff --git a/templates/de/html/ext/ext_mailid.tpl b/templates/de/html/ext/ext_mailid.tpl
index 862ef3664a73f97125cd2e2967b4a694cf3321ef..c273d42f5189efc7ab9621fbeb666e2de473c902 100644 (file)
--- a/templates/de/html/ext/ext_mailid.tpl
+++ b/templates/de/html/ext/ext_mailid.tpl
@@ -1,2 +1,2 @@
-Platzhalter für spätere Updates. Vorsicht! Sichern Sie zuerst
-Ihre geänderten Templates ab!
+Diese Erweiterung erlaubt es Ihren Mitgliedern, Mails zu bestätigen. Sie
+gilt somit als "essential" und sollte immer installiert und aktiviert sein.

diff --git a/templates/de/html/ext/ext_maintenance.tpl b/templates/de/html/ext/ext_maintenance.tpl
index 22e15a66f6fe4e58691cd113ed765726166a1729..f49c9dc446b562ecf6787119cf83deceb8c01621 100644 (file)
--- a/templates/de/html/ext/ext_maintenance.tpl
+++ b/templates/de/html/ext/ext_maintenance.tpl
@@ -1 +1,10 @@
-Platzhalter für spätere Updates.
+Schalten Sie Ihren {!MT_WORD!} in den Wartungsmodus, wenn dieser mal nicht
+funktionieren sollte und Sie in Ruhe dran debuggen müssen. Bitte
+aktualisieren dann zuerst Ihre SVN-Version (SVN-Update) und falls Sie den
+Fehler nicht selber finden können, melden Sie sich bitte im
+<a href="http://forum.mxchange.org/" rel="external" target="_blank"
+ title="Direkt-Link zum Support-Forum">Forum</a> und/oder <a rel="external"
+ href="http://bugs.mxchange.org/" target="_blank"
+ title="Direkt-Link zum Bug-Tracker">Bug-Tracker</a>.<br />
+<br />
+Danke f&uuml;r Ihre Mithilfe bei der Suche nach Bugs! :-)

diff --git a/templates/de/html/ext/ext_mydata.tpl b/templates/de/html/ext/ext_mydata.tpl
index 955e791b906ff72249753fd7ae1cebe404498de2..81be68da8f3cfc0b2fa05c81b47de72bf4a012ef 100644 (file)
--- a/templates/de/html/ext/ext_mydata.tpl
+++ b/templates/de/html/ext/ext_mydata.tpl
@@ -1,2 +1,3 @@
-Ausgelagerter Link "Profildaten ändern" aus dem
-Mitgliedsbereich. Dient als Platzhalter für spätere Versionen!
+Diese Erweiterung erlaubt es Ihren Mitgliedern, Ihre Profildaten zu
+ändern. Sie sollte daher in keinem {!MT_WORD!} fehlen und immer
+aktiviert sein.

diff --git a/templates/de/html/ext/ext_other.tpl b/templates/de/html/ext/ext_other.tpl
index e6f90d35b7e0f18671670e7aa65252220508f76b..7df643af6de3c0db2d664e8b2bf762ce49efeb00 100644 (file)
--- a/templates/de/html/ext/ext_other.tpl
+++ b/templates/de/html/ext/ext_other.tpl
@@ -1,2 +1,2 @@
-Andere Administrative Funktionen. Diese Erweiterung dient derzeit als
-Platzhalter, um das spätere Patchen der Datenbank zu erleichtern.
+Weitere wichtige Einstellungen zu Ihrem {!MT_WORD!}. Diese Erweiterung sollte
+immer installiert und aktiviert sein.

diff --git a/templates/de/html/ext/ext_register.tpl b/templates/de/html/ext/ext_register.tpl
index e4a368996e54ba484d7470317e5738dadbc3afe9..0a3e41a64f49339a1deebca237278e76be5d5fd0 100644 (file)
--- a/templates/de/html/ext/ext_register.tpl
+++ b/templates/de/html/ext/ext_register.tpl
@@ -1,4 +1,2 @@
-Platzhalter für spätere Updates. Derzeit können Sie
-Pflichtfelder im Anmeldeformular (noch nicht im Mitgliedsbereich unter
-Profildaten ändern) vorgeben. Diese müsen dann bei der
-Anmeldung eingegeben werden.
+Das Anmeldeformular zu Ihrem {!MT_WORD!}. Bitte installieren Sie diese
+Erweiterung und aktivieren Sie diese auch.

diff --git a/templates/de/html/ext/ext_usage.tpl b/templates/de/html/ext/ext_usage.tpl
new file mode 100644 (file)
index 0000000..b248e6a
--- /dev/null
+++ b/templates/de/html/ext/ext_usage.tpl
@@ -0,0 +1,2 @@
+Schauen Sie sich Ihre Server-Statistiken - derzeit werden nur
+Webalizer-Statistiken unterstützt bequem aus Ihrem Adminbereich an.