<?php
/************************************************************************
- * MXChange v0.2.1 Start: 11/24/2004 *
- * ================ Last change: 11/26/2004 *
+ * Mailer v0.2.1-FINAL Start: 11/24/2004 *
+ * =================== Last change: 11/26/2004 *
* *
* -------------------------------------------------------------------- *
* File : what-top10.php *
* 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 *
+ * Copyright (c) 2003 - 2009 by Roland Haeder *
+ * Copyright (c) 2009, 2010 by Mailer Developer Team *
* For more information visit: http://www.mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
// Some security stuff...
if (!defined('__SECURITY')) {
- $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php';
- require($INC);
-} elseif ((!EXT_IS_ACTIVE('top10')) && (!IS_ADMIN())) {
- addFatalMessage(__FILE__, __LINE__, sprintf(getMessage('EXTENSION_PROBLEM_EXT_INACTIVE'), 'top10'));
- return;
-}
+ die();
+} // END - if
// Add description as navigation point
-ADD_DESCR('guest', __FILE__);
+addMenuDescription('guest', __FILE__);
+
+if ((!isExtensionActive('top10')) && (!isAdmin())) {
+ loadTemplate('admin_settings_saved', false, generateExtensionInactiveNotInstalledMessage('top10'));
+ return;
+} // END - if
+
+// Init array
+$rows = array();
//// TOP logins
-$result = SQL_QUERY_ESC("
-SELECT
- userid, total_logins, last_online
+$result = SQL_QUERY("SELECT
+ `userid`, `total_logins`, `last_online`
FROM
- {!_MYSQL_PREFIX!}_user_data
+ `{?_MYSQL_PREFIX?}_user_data`
WHERE
- total_logins > 0 AND
+ `total_logins` > 0 AND
`status`='CONFIRMED'
ORDER BY
- total_logins DESC
-LIMIT %s",
-array(getConfig('top10_max')), __FILE__, __LINE__);
+ `total_logins` DESC
+LIMIT {?top10_max?}", __FILE__, __LINE__);
-$OUT = ''; $SW = 2; $cnt = 1;
+$OUT = ''; $cnt = 1;
while ($content = SQL_FETCHARRAY($result)) {
// Init nickname
- $content['nickname'] = '---';
+ $content['nickname'] = '';
// Get nickname
- if (EXT_IS_ACTIVE('nickname')) $content['nickname'] = NICKNAME_GET_NICK($content['userid']);
+ if (isExtensionActive('nickname')) $content['nickname'] = getNickname($content['userid']);
// Prepare data for template
- // @TODO Rewritings: uid->userid,nick->nickname,logins->total_logins in template
$content = array(
- 'sw' => $SW,
- 'cnt' => $cnt,
- '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'),
+ 'cnt' => $cnt,
+ 'userid' => $content['userid'],
+ 'nickname' => $content['nickname'],
+ 'total_logins' => $content['total_logins'],
+ 'points' => getTotalPoints($content['userid']),
+ 'last_online' => generateDateTime($content['last_online'], 3),
);
// Load row template
- $OUT .= LOAD_TEMPLATE("guest_top10_row_login", true, $content);
+ $OUT .= loadTemplate('guest_top10_row_login', true, $content);
- // Switch colors and count one up
- $SW = 3 - $SW; $cnt++;
+ // Count one up
+ $cnt++;
} // END - while
if ($cnt < getConfig('top10_max')) {
for ($i = $cnt; $i <= getConfig('top10_max'); $i++) {
// Prepare data for template
$content = array(
- 'sw' => $SW,
- 'idx' => $i
+ 'index' => $i
);
// Load row template
- $OUT .= LOAD_TEMPLATE("guest_top10_empty5", true, $content);
- $SW = 3 - $SW;
+ $OUT .= loadTemplate('guest_top10_empty5', true, $content);
} // END - for
} // END - if
-// @TODO Rewrite this constant
-define('__TOP_LOGINS_ROWS', $OUT);
+// Remember the rows in array
+$rows['logins_out'] = $OUT;
// Free result
SQL_FREERESULT($result);
//// TOP earners
-$result = SQL_QUERY_ESC("
-SELECT DISTINCT
+$result = SQL_QUERY("SELECT
d.userid,
- (SUM(p.points) - d.used_points) AS tpoints,
+ (SUM(p.points) - d.used_points) AS points,
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
GROUP BY
p.userid
ORDER BY
- tpoints DESC,
+ points DESC,
d.last_online DESC
-LIMIT %s",
-array(getConfig('top10_max')), __FILE__, __LINE__);
+LIMIT {?top10_max?}", __FILE__, __LINE__);
-$OUT = ''; $SW = 2; $cnt = 1;
+$OUT = ''; $cnt = 1;
while ($content = SQL_FETCHARRAY($result)) {
// Init nickname
- $content['nickname'] = '---';
+ $content['nickname'] = '';
// Get nickname
- if (EXT_IS_ACTIVE('nickname')) $content['nickname'] = NICKNAME_GET_NICK($content['userid']);
+ if (isExtensionActive('nickname')) $content['nickname'] = getNickname($content['userid']);
// Prepare data for template
- // @TODO Rewritings: nick->nickname,uid->userid in template
$content = array(
- 'sw' => $SW,
- 'cnt' => $cnt,
- 'uid' => $content['userid'],
- 'nick' => $content['nickname'],
- 'points' => translateComma($content['points']),
- 'last' => generateDateTime($content['last_online'], '3')
+ 'cnt' => $cnt,
+ 'userid' => $content['userid'],
+ 'nickname' => $content['nickname'],
+ 'points' => $content['points'],
+ 'last_online' => generateDateTime($content['last_online'], 3)
);
// Load row template
- $OUT .= LOAD_TEMPLATE("guest_top10_row_earner", true, $content);
+ $OUT .= loadTemplate('guest_top10_row_earner', true, $content);
- // Switch colors and count one up
- $SW = 3 - $SW; $cnt++;
+ // Count one up
+ $cnt++;
} // END - while
if ($cnt < getConfig('top10_max')) {
for ($i = $cnt; $i <= getConfig('top10_max'); $i++) {
// Prepare data for template
$content = array(
- 'sw' => $SW,
- 'idx' => $i
+ 'index' => $i
);
// Load row template
- $OUT .= LOAD_TEMPLATE("guest_top10_empty4", true, $content);
- $SW = 3 - $SW;
+ $OUT .= loadTemplate('guest_top10_empty4', true, $content);
} // END - for
} // END - if
-// @TODO Rewrite this constant
-define('__TOP_POINTS_ROWS', $OUT);
+// Remember the rows in array
+$rows['points_out'] = $OUT;
// Free result
SQL_FREERESULT($result);
//// TOP referal "hunter"
-$result = SQL_QUERY_ESC("
-SELECT DISTINCT
+$result = SQL_QUERY("SELECT
d.userid,
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
ORDER BY
refs DESC,
d.last_online DESC
-LIMIT %s",
-array(getConfig('top10_max')), __FILE__, __LINE__);
+LIMIT {?top10_max?}", __FILE__, __LINE__);
-$OUT = ''; $SW = 2; $cnt = 1;
+$OUT = ''; $cnt = 1;
while ($content = SQL_FETCHARRAY($result)) {
// Init nickname
- $content['nickname'] = '---';
+ $content['nickname'] = '';
// Get nickname
- if (EXT_IS_ACTIVE('nickname')) $content['nickname'] = NICKNAME_GET_NICK($content['userid']);
+ if (isExtensionActive('nickname')) $content['nickname'] = getNickname($content['userid']);
// Prepare data for template
- // @TODO Rewritings: nick->nickname,uid->userid in template
$content = array(
- 'sw' => $SW,
- 'cnt' => $cnt,
- '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')
+ 'cnt' => $cnt,
+ 'userid' => $content['userid'],
+ 'refs' => $content['refs'],
+ 'nickname' => $content['nickname'],
+ 'points' => getTotalPoints($content['userid']),
+ 'last_online' => generateDateTime($content['last_online'], 3)
);
// Load row template
- $OUT .= LOAD_TEMPLATE("guest_top10_row_refs", true, $content);
+ $OUT .= loadTemplate('guest_top10_row_refs', true, $content);
- // Switch colors and count one up
- $SW = 3 - $SW; $cnt++;
+ // Count one up
+ $cnt++;
} // END - while
if ($cnt < getConfig('top10_max')) {
for ($i = $cnt; $i <= getConfig('top10_max'); $i++) {
// Prepare data for template
$content = array(
- 'sw' => $SW,
- 'idx' => $i
+ 'index' => $i
);
// Load row template
- $OUT .= LOAD_TEMPLATE("guest_top10_empty5", true, $content);
- $SW = 3 - $SW;
+ $OUT .= loadTemplate('guest_top10_empty5', true, $content);
} // END - for
} // END - if
-// @TODO Rewrite this constant
-define('__TOP_REFERRAL_ROWS', $OUT);
+// Remember the rows in array
+$rows['referals_out'] = $OUT;
// Free result
SQL_FREERESULT($result);
-// Remember other values in constants
-// @TODO Rewrite this constant
-define('__TOP10_MAX', getConfig('top10_max'));
-
// Load final template
-LOAD_TEMPLATE("guest_top10");
+loadTemplate('guest_top10', false, $rows);
-//
+// [EOF]
?>