* -------------------------------------------------------------------- *
* Kurzbeschreibung : TOP-Logins / Bestverdiener usw. *
* -------------------------------------------------------------------- *
- * *
+ * $Revision:: $ *
+ * $Date:: $ *
+ * $Tag:: 0.2.1-FINAL $ *
+ * $Author:: $ *
+ * Needs to be in all Files and every File needs "svn propset *
+ * svn:keywords Date Revision" (autoprobset!) at least!!!!!! *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2008 by Roland Haeder *
* For more information visit: http://www.mxchange.org *
// 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);
-} elseif ((!EXT_IS_ACTIVE("top10")) && (!IS_ADMIN())) {
- addFatalMessage(EXTENSION_PROBLEM_EXT_INACTIVE, "top10");
+} elseif ((!EXT_IS_ACTIVE('top10')) && (!IS_ADMIN())) {
+ addFatalMessage(__FILE__, __LINE__, generateExtensionInactiveNotInstalledMessage('top10'));
return;
}
// Add description as navigation point
-ADD_DESCR("guest", __FILE__);
+ADD_DESCR('guest', __FILE__);
//// TOP logins
$result = SQL_QUERY_ESC("
SELECT
userid, total_logins, last_online
FROM
- "._MYSQL_PREFIX."_user_data
+ {!_MYSQL_PREFIX!}_user_data
WHERE
total_logins > 0 AND
- status='CONFIRMED'
+ `status`='CONFIRMED'
ORDER BY
total_logins DESC
LIMIT %s",
- array(getConfig('top10_max')), __FILE__, __LINE__);
+array(getConfig('top10_max')), __FILE__, __LINE__);
-$OUT = ""; $SW = 2; $cnt = 1;
-while (list($uid, $logins, $last) = SQL_FETCHROW($result)) {
- $nick2 = "---";
+$OUT = ''; $SW = 2; $cnt = 1;
+while ($content = SQL_FETCHARRAY($result)) {
+ // Init nickname
+ $content['nickname'] = '---';
// Get nickname
- if (EXT_IS_ACTIVE("nickname")) $nick2 = NICKNAME_GET_NICK($uid);
+ if (EXT_IS_ACTIVE('nickname')) $content['nickname'] = NICKNAME_GET_NICK($content['userid']);
// Prepare data for template
+ // @TODO Rewritings: uid->userid,nick->nickname,logins->total_logins in template
$content = array(
'sw' => $SW,
'cnt' => $cnt,
- 'uid' => $uid,
- 'nick' => $nick2,
- 'logins' => $logins,
- 'points' => TRANSLATE_COMMA(GET_TOTAL_DATA($uid, "user_points", "points")),
- 'last' => MAKE_DATETIME($last, "3"),
+ 'uid' => $content['userid'],
+ 'nick' => $content['nickname'],
+ 'logins' => $content['total_logins'],
+ 'points' => translateComma(GET_TOTAL_DATA($content['userid'], "user_points", "points")),
+ 'last' => generateDateTime($content['last_online'], '3'),
);
// Load row template
// Switch colors and count one up
$SW = 3 - $SW; $cnt++;
-}
+} // END - while
if ($cnt < getConfig('top10_max')) {
// Add more "blank" rows
// Load row template
$OUT .= LOAD_TEMPLATE("guest_top10_empty5", true, $content);
$SW = 3 - $SW;
- }
-}
+ } // END - for
+} // END - if
+
+// @TODO Rewrite this constant
define('__TOP_LOGINS_ROWS', $OUT);
// Free result
(SUM(p.points) - d.used_points) AS tpoints,
d.last_online
FROM
- `{!MYSQL_PREFIX!}_user_data` AS d
+ `{!_MYSQL_PREFIX!}_user_data` AS d
LEFT JOIN
- {!MYSQL_PREFIX!}_user_points AS p
+ {!_MYSQL_PREFIX!}_user_points AS p
ON
p.userid=d.userid
WHERE
p.points > 0 AND
- d.status='CONFIRMED'
+ d.`status`='CONFIRMED'
GROUP BY
p.userid
ORDER BY
tpoints DESC,
d.last_online DESC
LIMIT %s",
- array(getConfig('top10_max')), __FILE__, __LINE__);
+array(getConfig('top10_max')), __FILE__, __LINE__);
-$OUT = ""; $SW = 2; $cnt = 1;
-while (list($uid, $points, $last) = SQL_FETCHROW($result)) {
- $nick2 = "---";
+$OUT = ''; $SW = 2; $cnt = 1;
+while ($content = SQL_FETCHARRAY($result)) {
+ // Init nickname
+ $content['nickname'] = '---';
// Get nickname
- if (EXT_IS_ACTIVE("nickname")) $nick2 = NICKNAME_GET_NICK($uid);
+ if (EXT_IS_ACTIVE('nickname')) $content['nickname'] = NICKNAME_GET_NICK($content['userid']);
// Prepare data for template
+ // @TODO Rewritings: nick->nickname,uid->userid in template
$content = array(
'sw' => $SW,
'cnt' => $cnt,
- 'uid' => bigintval($uid),
- 'nick' => $nick2,
- 'points' => TRANSLATE_COMMA($points),
- 'last' => MAKE_DATETIME($last, "3")
+ 'uid' => $content['userid'],
+ 'nick' => $content['nickname'],
+ 'points' => translateComma($content['points']),
+ 'last' => generateDateTime($content['last_online'], '3')
);
// Load row template
// Switch colors and count one up
$SW = 3 - $SW; $cnt++;
-}
+} // END - while
if ($cnt < getConfig('top10_max')) {
// Add more "blank" rows
// Load row template
$OUT .= LOAD_TEMPLATE("guest_top10_empty4", true, $content);
$SW = 3 - $SW;
- }
-}
+ } // END - for
+} // END - if
+
+// @TODO Rewrite this constant
define('__TOP_POINTS_ROWS', $OUT);
// Free result
SUM(r.counter) AS refs,
d.last_online
FROM
- `{!MYSQL_PREFIX!}_user_data` AS d
+ `{!_MYSQL_PREFIX!}_user_data` AS d
LEFT JOIN
- {!MYSQL_PREFIX!}_refsystem AS r
+ {!_MYSQL_PREFIX!}_refsystem AS r
ON
r.userid=d.userid
WHERE
r.counter > 0 AND
- d.status='CONFIRMED'
+ d.`status`='CONFIRMED'
GROUP BY
r.userid
ORDER BY
refs DESC,
d.last_online DESC
LIMIT %s",
- array(getConfig('top10_max')), __FILE__, __LINE__);
+array(getConfig('top10_max')), __FILE__, __LINE__);
-$OUT = ""; $SW = 2; $cnt = 1;
-while (list($uid, $refs, $last) = SQL_FETCHROW($result)) {
- $nick2 = "---";
+$OUT = ''; $SW = 2; $cnt = 1;
+while ($content = SQL_FETCHARRAY($result)) {
+ // Init nickname
+ $content['nickname'] = '---';
// Get nickname
- if (EXT_IS_ACTIVE("nickname")) $nick2 = NICKNAME_GET_NICK($uid);
+ if (EXT_IS_ACTIVE('nickname')) $content['nickname'] = NICKNAME_GET_NICK($content['userid']);
// Prepare data for template
+ // @TODO Rewritings: nick->nickname,uid->userid in template
$content = array(
'sw' => $SW,
'cnt' => $cnt,
- 'uid' => bigintval($uid),
- 'refs' => $refs,
- 'nick' => $nick2,
- 'points' => TRANSLATE_COMMA(GET_TOTAL_DATA($uid, "user_points", "points")),
- 'last' => MAKE_DATETIME($last, "3")
+ 'uid' => $content['userid'],
+ 'refs' => $content['refs'],
+ 'nick' => $content['nickname'],
+ 'points' => translateComma(GET_TOTAL_DATA($content['userid'], "user_points", "points")),
+ 'last' => generateDateTime($content['last_online'], '3')
);
// Load row template
// Switch colors and count one up
$SW = 3 - $SW; $cnt++;
-}
+} // END - while
if ($cnt < getConfig('top10_max')) {
// Add more "blank" rows
// Load row template
$OUT .= LOAD_TEMPLATE("guest_top10_empty5", true, $content);
$SW = 3 - $SW;
- }
-}
+ } // END - for
+} // END - if
+
+// @TODO Rewrite this constant
define('__TOP_REFERRAL_ROWS', $OUT);
// Free result
SQL_FREERESULT($result);
// Remember other values in constants
+// @TODO Rewrite this constant
define('__TOP10_MAX', getConfig('top10_max'));
// Load final template