X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fgen_refback.php;h=77fd532d80d0ad71b36fc74285c4f5c172ce0f55;hb=b9edcfb00bb14c7b53b107ff5b1290841340b434;hp=7d0a6b7d7b9178a891d7f3538241ddd144a09d11;hpb=64c8349613addc3da2242c5cd6b99d64e3fb5f8e;p=mailer.git diff --git a/inc/gen_refback.php b/inc/gen_refback.php index 7d0a6b7d7b..77fd532d80 100644 --- a/inc/gen_refback.php +++ b/inc/gen_refback.php @@ -45,13 +45,13 @@ if (!defined('__SECURITY')) { loadIncludeOnce('inc/libs/refback_functions.php'); // Sanity-check: Do we have ref level 0? -$result = SQL_QUERY("SELECT `id` FROM `{?_MYSQL_PREFIX?}_refsystem` WHERE level=0", __FILE__, __LINE__); +$result = SQL_QUERY("SELECT `id` FROM `{?_MYSQL_PREFIX?}_refsystem` WHERE `level`=0", __FILE__, __LINE__); if (SQL_NUMROWS($result) > 0) { // Remove index temporaly 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__); + SQL_QUERY("UPDATE `{?_MYSQL_PREFIX?}_refsystem` SET `level`=`level`+1", __FILE__, __LINE__); // Add it again SQL_ALTER_TABLE("ALTER TABLE `{?_MYSQL_PREFIX?}_refsystem` ADD UNIQUE `userid_level` ( `userid`,`level` )", __FILE__, __LINE__);