X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fgen_refback.php;h=77fd532d80d0ad71b36fc74285c4f5c172ce0f55;hp=7d0a6b7d7b9178a891d7f3538241ddd144a09d11;hb=a49d1f4613f3f7d47fb57d946e9f7f705bd34a9b;hpb=dc48c8d18b395c1bf2147baadbecd056f843b818 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__);