X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fgen_refback.php;h=aa7f4f420fe1809fd53cb62d6148c55de387831f;hp=5ef26532d266c47cdcf66977162581f3e91ff90c;hb=33e11a76a6d2d20d20d54ed1a7380ed1375bd3ed;hpb=e01fcf1ca8ddeb72af76465df3ef72301a1cdae7 diff --git a/inc/gen_refback.php b/inc/gen_refback.php index 5ef26532d2..aa7f4f420f 100644 --- a/inc/gen_refback.php +++ b/inc/gen_refback.php @@ -10,10 +10,10 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Refback-Tabelle mit allen Refs generieren * * -------------------------------------------------------------------- * - * $Revision:: 856 $ * - * $Date:: 2009-03-06 20:24:32 +0100 (Fr, 06. March 2009) $ * + * $Revision:: $ * + * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * - * $Author:: stelzi $ * + * $Author:: $ * * Needs to be in all Files and every File needs "svn propset * * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * @@ -38,15 +38,15 @@ // Some security stuff... if (!defined('__SECURITY')) { - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; + $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php'; require($INC); } // Make sure our functions are there -LOAD_INC_ONCE("inc/libs/refback_functions.php"); +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__); @@ -55,34 +55,34 @@ if (SQL_NUMROWS($result) > 0) { 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__); + SQL_ALTER_TABLE("ALTER TABLE `{!_MYSQL_PREFIX!}_refsystem` ADD UNIQUE `userid_level` ( `userid`,`level` )", __FILE__, __LINE__); // Rebuild cache - rebuildCacheFiles("refsystem", "refsystem"); + rebuildCacheFiles('refsystem', 'refsystem'); } // END - if // Free result SQL_FREERESULT($result); // Reset the table -SQL_QUERY("TRUNCATE TABLE `{!_MYSQL_PREFIX!}_user_refs`", __FILE__, __LINE__); +SQL_QUERY('TRUNCATE TABLE `{!_MYSQL_PREFIX!}_user_refs`', __FILE__, __LINE__); // Begin with all users in level one -$result_direct = SQL_QUERY("SELECT u.userid +$result_direct = SQL_QUERY('SELECT u.userid FROM `{!_MYSQL_PREFIX!}_user_data` AS u WHERE u.refid=0 -ORDER BY u.userid ASC", __FILE__, __LINE__); +ORDER BY u.userid ASC', __FILE__, __LINE__); // Do we have entries? if (SQL_NUMROWS($result_direct) > 0) { - // When "walk" through all users + // When 'walk' through all users while ($content = SQL_FETCHARRAY($result_direct)) { // Init level $GLOBALS['cache_array']['back_level'] = 1; // Update refback table //* DEBUG: */ echo "uid={$content['userid']}
\n"; - UPDATE_REFBACK_TABLE($content['userid']); + updateRefbackTable($content['userid']); } // END - while } // END - if