<?php ///////////////////////// // LATEST COMMENTS ///////////////////////// $tpl->setCacheKey('cached/latest_comment.tpl', 'latest_comment'); if ($tpl->isCached('cached/latest_comment.tpl', 60) == false) { $rs = $db->select('SELECT c.date AS date, c.name AS name, c.message AS message FROM map_comment AS c JOIN map AS m ON c.map_id=m.id WHERE c.status = 1 AND m.date < ' . time() . ' AND m.status = 1 ORDER BY c.date DESC', 0, 14); foreach ($rs['result'] as $key => $item) { $tpl->assignLoopVar('comment', array('date' => timeWarp($item['date']), 'name' => $item['name'], 'message' => encodeCurly(cutText($item['message'], 120)))); } }
///////////////////////// // COMMENT ///////////////////////// $rs = $db->select('SELECT c.id AS id, c.parent_id AS parent_id, c.date AS date, c.name AS name, c.message AS message, m.id AS map_id, m.title AS map_title, m.guid AS map_guid, m.image_id AS image, g.guid AS game_guid, t.guid AS gametype_guid FROM map_comment AS c JOIN map AS m ON m.id = c.map_id JOIN game AS g ON m.game_id = g.id JOIN gametype AS t ON m.gametype_id = t.id WHERE c.status = 1 ORDER BY c.date DESC', 0, 50); foreach ($rs['result'] as $comment) { $tpl->assignLoopVar('comment', array('time' => timeWarp($comment['date']), 'name' => $comment['name'], 'message' => $comment['message'], 'id' => $comment['id'], 'class' => $comment['parent_id'] != 0 ? 'repply' : 'main', 'image' => $comment['image'], 'map_id' => $comment['map_id'], 'map_title' => $comment['map_title'], 'map_guid' => $comment['map_guid'], 'game_guid' => $comment['game_guid'], 'gametype_guid' => $comment['gametype_guid'], 'author_guid' => $comment['author_guid'])); } ///////////////////////// // RESULT INFOS ///////////////////////// $to = 1; $tpl->assignVar(array('result_from' => number_format(50 + 1, 0, '', ','), 'result_to' => number_format($to > $rs['total'] ? $rs['total'] : $to, 0, '', ','), 'result_total' => number_format($rs['total'], 0, '', ',')));
$rs_response = $db->select('SELECT date, parent_id, name, message FROM map_comment WHERE parent_id IN (' . implode(',', $idList) . ') AND status = 1 ORDER BY date ASC'); $n = 0; foreach ($rs['result'] as $comment) { $message = nl2br($comment['message']); $message = preg_replace('/([\\t\\r\\n\\v\\f]+)/is', '', $message); $message = preg_replace('/((?:<br \\/>){2,})/is', '<br /><br />', $message); $tpl->assignLoopVar('comment', array('time' => timeWarp($comment['date']), 'name' => encodeCurly($comment['name']), 'message' => encodeCurly($message), 'id' => $comment['id'])); foreach ($rs_response['result'] as $response) { if ($response['parent_id'] == $comment['id']) { $message = nl2br($response['message']); $message = preg_replace('/([\\t\\r\\n\\v\\f]+)/is', '', $message); $message = preg_replace('/((?:<br \\/>){2,})/is', '<br /><br />', $message); $tpl->assignLoopVar('comment.response', array('time' => timeWarp($response['date']), 'name' => encodeCurly($response['name']), 'message' => encodeCurly($message))); } } $n++; if ($n > COMMENT_PER_PAGE) { break; } } } else { $tpl->assignVar('commentDisplay', 'none'); $tpl->assignVar('commentClass', 'off'); } ///////////////////////// // PAGINATION ///////////////////////// $pageTotal = ceil($rs['total'] / COMMENT_PER_PAGE);
echo "<br>Skipping because tf not active: " . $tf->get_value("tfName"); continue 2; } $tf = new tf(); $tf->set_id($transactionRepeat->get_value("fromTfID")); $tf->select(); if (!$tf->get_value("tfActive")) { echo "<br>Skipping because tf not active: " . $tf->get_value("tfName"); continue 2; } $amount = page::money_out($transactionRepeat->get_value("currencyTypeID"), $transactionRepeat->get_value("amount")); $transaction = new transaction(); $transaction->set_value("fromTfID", $transactionRepeat->get_value("fromTfID")); $transaction->set_value("tfID", $transactionRepeat->get_value("tfID")); $transaction->set_value("companyDetails", $transactionRepeat->get_value("companyDetails")); $transaction->set_value("amount", $amount); $transaction->set_value("currencyTypeID", $transactionRepeat->get_value("currencyTypeID")); $transaction->set_value("product", $transactionRepeat->get_value("product")); $transaction->set_value("transactionType", $transactionRepeat->get_value("transactionType")); $transaction->set_value("status", "pending"); $transaction->set_value("transactionRepeatID", $transactionRepeat->get_id()); $transaction->set_value("transactionDate", date("Y-m-d", $nextScheduled)); $transaction->save(); echo "\n<br>" . $transaction->get_value("transactionDate"); echo " " . $transactionRepeat->get_value("paymentBasis") . " \$" . $transaction->get_value("amount") . " for TF: " . tf::get_name($transaction->get_value("tfID")); echo " (transactionID: " . $transaction->get_id() . " transactionRepeatID:" . $transactionRepeat->get_id() . " name:" . $transactionRepeat->get_value("product") . ")"; $nextScheduled = timeWarp($nextScheduled, $timeBasisString); } } $TPL["main_alloc_title"] = "Execute Repeating Expenses - " . APPLICATION_NAME; include_template("templates/checkRepeatM.tpl");