* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team *
- * For more information visit: http://www.mxchange.org *
+ * Copyright (c) 2009 - 2013 by Mailer Developer Team *
+ * 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 *
}
// Translates the "earning name" into human-readable
-function translateEarningName ($earningName) {
- return sprintf("{--EARNING_NAME_%s--}", $earningName);
+function translateEarningProvider ($earningProvider) {
+ return sprintf("{--EARNING_PROVIDER_%s--}", $earningProvider);
}
/*
* Generates a table (with templates) to display data for extra earnings (to
* the member) by given "earning name".
*
- * @param $earningName Name of the earning
+ * @param $earningProvider Name of the earning
* @return $output Generated HTML output
*/
-function generateMemberEarningDataTable ($earningName) {
+function generateMemberEarningDataTable ($earningProvider) {
// Init array for filter
$filterData = array(
// Minimum points to get
// "earning group"
'earning_group' => 'INVALID',
// "earning name" again
- 'earning_name' => $earningName
+ 'earning_provider' => $earningProvider
);
// Run the filter chain to get the data
$filterData = runFilterChain('member_earning_table_data', $filterData);
// Load the proper template and return it
- $output = loadTemplate('member_earning_data_' . strtolower($filterData['earning_group']), true, $filterData);
+ $output = loadTemplate('member_earning_data_' . strtolower($filterData['earning_group']), TRUE, $filterData);
// Return it
return $output;
// Handle earning id
function doMemberEarning ($earningId, $dailyAmount, $isActive = 'Y') {
- // Does the user already have this earning?
- $result = SQL_QUERY_ESC("SELECT COUNT(`id`) AS `cnt` FROM `{?_MYSQL_PREFIX?}_user_earning` WHERE `earning_id`=%s AND `earning_userid`=%s LIMIT 1",
- array(
- bigintval($earningId),
- getMemberId()
- ), __FUNCTION__, __LINE__);
-
- // Get the count
- list($count) = SQL_FETCHROW($result);
-
// Does the user have this?
- if ($count == 1) {
+ if (countSumTotalData(bigintval($earningId), 'user_earning', 'id', 'earning_id', TRUE, ' AND `earning_userid`=' . getMemberId()) == 1) {
// Then update it
$status = updateMemberEarning($earningId, $dailyAmount, $isActive);
} else {
$status = insertMemberEarning($earningId, $dailyAmount, $isActive);
}
- // Free result
- SQL_FREERESULT($result);
-
// Return status
return $status;
}
// Insert member earning entry
function insertMemberEarning ($earningId, $dailyAmount, $isActive = 'Y') {
// Insert the record
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_earning` (`earning_id`,`earning_userid`,`earning_daily_amount`,`earning_active`) VALUES(%s,%s,%s,'%s')",
+ SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_earning` (`earning_id`, `earning_userid`, `earning_daily_amount`, `earning_active`) VALUES(%s,%s,%s,'%s')",
array(
bigintval($earningId),
getMemberId(),
// Prepare content
$content = array(
- 'insert_id' => SQL_INSERTID(),
+ 'insert_id' => SQL_INSERT_ID(),
'earning_id' => bigintval($earningId),
'daily_amount' => bigintval($dailyAmount),
'is_active' => $isActive
// Does the user cancel the earning?
if ($isActive == 'N') {
// Then update cancellation timestamp as well
- $moreSql = ', `earning_cancelled`=NOW()';
+ $moreSql = ',`earning_canceled`=NOW()';
} // END - if
// Update database record
getMemberId()
), __FUNCTION__, __LINE__);
- // Determine wether something has changed
+ // Determine whether something has changed
$status = (!SQL_HASZEROAFFECTED());
// Has the record changed?
- if ($status === true) {
+ if ($status === TRUE) {
// Prepare content
$content = array(
'earning_id' => bigintval($earningId),