* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
* Copyright (c) 2009 - 2011 by Mailer Developer Team *
- * For more information visit: http://www.mxchange.org *
+ * For more information visit: http://mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
$result = SQL_QUERY('SELECT
d.`earning_id`,
d.`earning_group`,
- d.`earning_name`
+ d.`earning_provider`
FROM
`{?_MYSQL_PREFIX?}_earning_data` AS d
ORDER BY
$result2 = SQL_QUERY_ESC('SELECT
u.`earning_active`,
UNIX_TIMESTAMP(u.`earning_added`) AS `earning_added`,
- UNIX_TIMESTAMP(u.`earning_cancelled`) AS `earning_cancelled`,
+ UNIX_TIMESTAMP(u.`earning_canceled`) AS `earning_canceled`,
u.`earning_daily_amount`,
u.`earning_points`
FROM