X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fgen_refback.php;h=e9073dae38dc1f1b8727db6b75928c26b0139ad0;hb=d9beb49c154cc021a4863645c28f98a2455cc3ff;hp=7d0a6b7d7b9178a891d7f3538241ddd144a09d11;hpb=1ebf518b9552f71ee95de6f4b80e6de3a27716d1;p=mailer.git diff --git a/inc/gen_refback.php b/inc/gen_refback.php index 7d0a6b7d7b..e9073dae38 100644 --- a/inc/gen_refback.php +++ b/inc/gen_refback.php @@ -1,7 +1,7 @@ 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__); // Rebuild cache - rebuildCacheFile('refsystem', 'refsystem'); + rebuildCache('refsystem', 'refsystem'); } // END - if // Free result