private function getChangePassword($id, $key)
{
$text = Core_Text::__getInstance();
$text->setFile('main');
$text->setSection('lostpass');
// Check the key
$db = Core_Database::__getInstance();
$chk = $db->select('players', array('plid'), "plid = " . intval($id) . " AND seckey = '" . $db->escape($key) . "'");
if (count($chk) === 1) {
$password1 = Core_Tools::getInput('_POST', 'pass1', 'varchar');
$password2 = Core_Tools::getInput('_POST', 'pass2', 'varchar');
$page = new Core_Template();
$page->set('title', $text->get('changepass'));
$page->set('about', $text->get('aboutchange'));
$page->set('pass1', $text->get('pass1'));
$page->set('pass2', $text->get('pass2'));
$page->set('submit', $text->get('submitchange'));
if ($password1 && $password1 === $password2) {
$login = Core_Login::__getInstance();
$login->setPassword($chk[0]['plid'], $password1);
$page->set('success', $text->get('passchanged'));
} elseif ($password1 || $password2) {
$page->set('warning', $text->get('passmismatch'));
}
return $page->parse('lostPassword_res.tpl');
} else {
return '<p class="false">Security Key Not Found.</p>';
}
}
private function processIMLogin($key, $msg)
{
$text = Core_Text::__getInstance();
$db = Core_Database::__getInstance();
$commands = explode(' ', $msg);
$command = array_shift($commands);
switch ($command) {
case 'login':
if (count($commands) == 1) {
$email = array_shift($commands);
// Search in the database for this user
$user = $db->select('players', array('plid', 'realname', 'email'), "email = '" . $db->escape($email) . "'");
if (count($user) == 1) {
// Invent a new key
$passkey = substr(md5(rand(0, 100000)), 0, 6);
$db->insert('im_users', array('im_user' => $key, 'im_player' => $user[0]['plid'], 'im_key' => $passkey));
// Send the secret key to this user
Core_Tools::sendMail($text->get('subject', 'bot', 'main'), Core_Tools::output_text(Core_Tools::putIntoText($text->getFile('mails/bot_activation'), array('name' => $user[0]['realname'], 'key' => $passkey))), $user[0]['email']);
echo 'We have found your account. We have sent an email containing a secret key.<br />Please show me the key here.';
} else {
echo 'This user (' . $username . ') is not found. Please try again, or register at http://www.1brood.be/';
}
} else {
echo '"Login" should be followed by your email and password.';
}
break;
default:
echo 'Please login in 1Brood by typing "Login your_email".<br />';
echo 'We will start sending out reminders as soon as you are logged in.';
break;
}
}
public function getClickTo($sKey, $sSection = null, $sFile = null)
{
if (!isset($this->objText)) {
$this->objText = Core_Text::__getInstance();
}
return $this->objText->getClickTo($this->getText($sKey, $sSection, $sFile));
}
protected function getContent()
{
$page = new Core_Template();
$text = Core_Text::__getInstance();
$text->setFile('about');
$text->setSection('about');
return $page->parse('donate.tpl');
}
protected function getContent()
{
$page = new Core_Template();
$text = Core_Text::__getInstance();
$page->set('title', Core_Tools::putIntoText($text->get('title', 'error404', 'main'), array($this->sPage)));
$page->set('descr', $text->get('descr', 'error404', 'main'));
return $page->parse('error404.tpl');
}
protected function getContent()
{
$text = Core_Text::__getInstance();
$text->setFile('about');
$text->setSection('home');
$page = new Core_Template();
$page->set('title', $text->get('title'));
$page->set('manual', $text->get('manual'));
$page->set('companies', $text->get('companies'));
$page->set('login', $text->get('login'));
$page->set('choose', $text->get('choose'));
$page->set('order', $text->get('order'));
$page->set('eat', $text->get('eat'));
$page->set('toMoreInfo', $text->getClickTo($text->get('toMoreInfo')));
$page->set('moreInfoLink', self::getUrl('page=about'));
return $page->parse('home.tpl');
}
protected function getContent()
{
$action = Core_Tools::getInput('_POST', 'welcome_selection', 'varchar');
switch ($action) {
case 'honger':
header('Location: ' . $this->getUrl('page=register&nocompany=false'));
break;
case 'geld':
header('Location: ' . $this->getUrl('page=register&nocompany=true&action=shopowner'));
break;
}
$text = Core_Text::__getInstance();
$text->setFile('about');
$text->setSection('home');
$page = new Core_Template();
$page->set('action', $this->getUrl('page=welcome'));
return $page->parse('welcome.tpl');
}
protected function getContent()
{
$page = new Core_Template();
$text = Core_Text::__getInstance();
$text->setFile('about');
$text->setSection('about');
$page->set('title', $text->get('title'));
$page->set('about1', $text->get('about1'));
$page->set('about2', $text->get('about2'));
$page->set('forWho', $text->get('forWho'));
$page->set('forWho1', $text->get('forWho1'));
$page->set('cost', $text->get('cost'));
$page->set('cost1', $text->get('cost1'));
$page->set('examp', $text->get('examp'));
$page->set('examp1', $text->get('examp1'));
$page->set('examp2', $text->get('examp2'));
$page->set('examp3', $text->get('examp3'));
return $page->parse('about.tpl');
}
private function getOverview()
{
$text = Core_Text::__getInstance();
$text->setFile('account');
$text->setSection('overview');
$page = new Core_Template();
$page->set('title', $text->get('title'));
$page->set('about', $text->get('about'));
$page->set('companies', $text->get('companies'));
$page->set('compAbout', $text->get('compAbout'));
$page->set('noCompanies', $text->get('noCompanies'));
$page->set('pending', $text->get('pending'));
$page->set('aboutPending', $text->get('aboutPending'));
$page->set('poeflog', $text->get('poeflog'));
$page->set('addCompany', $text->getClickTo($text->get('toAddCompanie')));
$page->set('addCompanyUrl', self::getUrl('page=register&action=companies'));
$myself = Profile_Member::getMyself();
$page->set('name_value', Core_Tools::output_varchar($myself->getFullName()));
$page->set('email_value', Core_Tools::output_varchar($myself->getEmail()));
$page->set('edit_link', self::getUrl('page=register&action=edit'));
$companies = $myself->getMyCompanies();
foreach ($companies as $v) {
$page->addListValue('companies', array(Core_Tools::output_varchar($v->getName()), self::getUrl('page=company&id=' . $v->getId()), self::getUrl('page=company&id=' . $v->getId() . '&action=poeflog&uid=' . $myself->getId())));
}
$pending = $myself->getMyCompanies(true);
foreach ($pending as $v) {
$page->addListValue('pending', array(Core_Tools::output_varchar($v->getName()), self::getUrl('page=company&id=' . $v->getId())));
}
$page->set('addshop_url', self::getUrl('page=register&action=shopowner'));
$shops = $myself->getMyShops();
foreach ($shops as $v) {
$page->addListValue('shops', array(Core_Tools::output_varchar($v->getName()), self::getUrl('page=shop&id=' . $v->getId())));
}
return $page->parse('account_overview.tpl');
}
public function sendReminder($company)
{
$text = Core_Text::__getInstance();
$text->setFile('account');
$text->setSection('reminder');
$email = $this->getEmail();
// Get company owner
$owner = $company->getOwner();
// Check for negative poefboek
$poefboek = $company->getMemberPoefboek($this);
if ($poefboek > 0) {
$txt = Core_Tools::output_text($text->getFile('mails/reminder'));
} else {
$txt = Core_Tools::output_text(Core_Tools::putIntoText($text->getFile('mails/angry_reminder'), array('poefboek' => $poefboek, 'admin' => Core_Tools::output_varchar($owner->getFullname()))));
}
if ($owner) {
Core_Tools::sendMail($text->get('subject'), $txt, $email, $this->getFullname(), $owner->getFullname(), $owner->getEmail(), false);
}
// Notify members by message:
$db = Core_Database::__getInstance();
$accounts = $db->select('im_users', array('im_user'), "im_player = " . $this->getId() . " AND im_activated = 1");
$url = 'https://www.imified.com/api/bot/';
foreach ($accounts as $v) {
$data = array('botkey' => '53881418-A97D-9713-415C46EA2843C806', 'apimethod' => 'send', 'userkey' => $v['im_user'], 'msg' => 'Tijd voor broodjes! Ga snel naar http://www.1brood.be/ !');
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_USERPWD, 'daedelson@gmail.com:aukv0006');
curl_setopt($ch, CURLOPT_POSTFIELDS, $data);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_TIMEOUT, 100);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
$xml = curl_exec($ch);
if (!$xml) {
echo curl_error($ch);
}
curl_close($ch);
}
}
protected function getBasket()
{
$myself = Profile_Member::getMyself();
if ($myself) {
$orders = $myself->getPendingOrders();
if (count($orders) > 0) {
// Process Input
$remId = Core_Tools::getInput('_GET', 'bRem', 'int');
if ($remId > 0) {
$myself->removeProductFromBasket($remId);
// Reload ;-)
$orders = $myself->getPendingOrders();
}
$text = Core_Text::__getInstance();
$page = new Core_Template();
$page->set('remove', addslashes($text->get('remove', 'basket', 'main')));
$page->set('title', $text->get('title', 'basket', 'main'));
foreach ($orders as $v) {
// Create combination string
$comb = $v[1]['op_amount'] . 'x ' . Core_Tools::output_varchar($v[0]['p_name']) . ", ";
$comb .= !empty($v[1]['op_message']) ? Core_Tools::output_varchar($v[1]['op_message']) . ", " : null;
$comb .= Core_Tools::output_varchar($v[2]->getName()) . ", ";
$comb .= Core_Tools::output_varchar($v[3]->getName());
$page->addListValue('products', array(Core_Tools::output_varchar($v[0]['p_name']), Core_Tools::output_varchar($v[1]['op_amount']), Core_Tools::output_varchar($v[1]['op_message']), Core_Tools::output_varchar($v[1]['op_price']), Core_Tools::output_varchar($v[2]->getName()), Core_Tools::output_varchar($v[3]->getName()), addslashes($comb), self::getUrl('page=register&bRem=' . $v[1]['op_id'])));
}
return $page->parse('blocks/basket.tpl');
} else {
return null;
}
} else {
return null;
}
}
public function getShopManagement($objShop)
{
$login = Core_Login::__getInstance();
$db = Core_Database::__getInstance();
$text = Core_Text::__getInstance();
$text->setFile('shop');
$text->setSection('manager');
// Check for input
$input = Core_Tools::getInput('_POST', 'submit', 'varchar');
if ($input == 'saveSettings') {
$this->processManagementInput($objShop);
}
$page = new Core_Template();
$categories = $objShop->getCategories();
$colsToShow = $objShop->getMaxPricesPerCategory($categories);
foreach ($categories as $v) {
$page->addListValue('categories', array('id' => $v['c_id'], 'name' => Core_Tools::output_varchar($v['c_name'])));
}
$page->set('priceColsToShow', $colsToShow);
$page->set('title', Core_Tools::putIntoText($text->get('title'), array(Core_Tools::output_varchar($objShop->getName()))));
$page->set('message', $text->get('message'));
$page->set('message_value', Core_Tools::output_form($objShop->getMessage()));
$page->set('products', $text->get('products'));
$page->set('productName', $text->get('productName'));
$page->set('productText', $text->get('productText'));
$page->set('productPrice', $text->get('productPrice'));
$page->set('noRows', $text->get('noRows'));
$page->set('submit', $text->get('submit'));
$page->set('formAction', self::getUrl('page=shop&id=' . $objShop->getId() . '&action=manage'));
// Add row link
$page->set('toAddRow', $text->getClickTo($text->get('toAddRow')));
$page->set('addRow', $text->get('addRow'));
$page->set('editCategory', $text->get('editCategory'));
$page->set('editCategory_url', self::getUrl('page=shop&id=' . $objShop->getId() . '&action=categories'));
// Loop products
$products = $objShop->getProducts();
foreach ($products as $v) {
// Fetch the prices
$page->addListValue('products', array($v['p_id'], Core_Tools::output_form($v['p_name']), Core_Tools::output_form($v['p_info']), $v['prices'], $v['c_id']));
}
return $page->parse('shop_manage.tpl');
}
public function getPoefboekLog($objUser, $bShowDetails = false)
{
$db = Core_Database::__getInstance();
$bShowDetails = $bShowDetails ? true : false;
$logs = $db->getDataFromQuery($db->customQuery("\n\t\t\t\tSELECT\n\t\t\t\t\t*,\n\t\t\t\t\tUNIX_TIMESTAMP(p.l_date) AS date\n\t\t\t\tFROM\n\t\t\t\t\tplayers_poefboeklog p\n\t\t\t\tLEFT JOIN\n\t\t\t\t\torder_prods o ON p.l_action = 'order' AND p.l_actor = o.o_id AND o.plid = p.plid\n\t\t\t\tLEFT JOIN\n\t\t\t\t\tproducts prod ON o.p_id = prod.p_id\n\t\t\t\tWHERE\n\t\t\t\t\tp.c_id = {$this->getId()} AND \n\t\t\t\t\tp.plid = {$objUser->getId()} \n\t\t\t\t" . (!$bShowDetails ? 'GROUP BY p.l_id ' : null) . "\n\t\t\t\tORDER BY\n\t\t\t\t\tp.l_date DESC\n\t\t\t"));
$out = array();
$text = Core_Text::__getInstance();
foreach ($logs as $v) {
// Check if there are details available
if ($bShowDetails && isset($v['p_name']) && isset($v['op_price']) && isset($v['op_amount'])) {
$details = array('amount' => $v['op_amount'], 'price' => $v['op_price'], 'name' => $v['p_name']);
} else {
$details = false;
}
// Are we still processing the same unit?
if (isset($latest) && $latest['id'] == $v['l_id']) {
if ($details) {
$latest['details'][] = $details;
}
} else {
switch ($v['l_action']) {
case 'order':
$actor_name = $text->get('order', 'poeflog', 'company') . ' #' . $v['l_actor'];
$actor_url = Pages_Page::getUrl('page=order&oid=' . $v['l_actor']);
break;
default:
$user = Profile_Member::getMember($v['l_actor']);
if ($user->isFound()) {
$actor_name = $user->getUsername();
$actor_url = 'mailto:' . $user->getEmail();
} else {
$actor_name = 'user_not_found';
$actor_url = '#';
}
break;
}
$aDetails = array();
if ($details) {
$aDetails[] = $details;
}
$out[] = array('id' => $v['l_id'], 'date' => $v['date'], 'amount' => $v['l_amount'], 'actor_name' => $actor_name, 'actor_url' => $actor_url, 'newpoef' => $v['l_newpoef'], 'comment' => $v['l_description'], 'details' => $aDetails);
$latest =& $out[count($out) - 1];
}
}
return $out;
}
private function getOrderOverview($order, $showOnlineVersion = true, $showSended = false, $showNames = true)
{
$db = Core_Database::__getInstance();
$text = Core_Text::__getInstance();
$text->setFile('order');
$text->setSection('submit');
$page = new Core_Template();
$company = Profile_Company::getCompany($order['c_id']);
$company->setData($order);
$shop = Profile_Shop::getShop($order['s_id']);
$page->set('company', $text->get('company'));
$page->set('shop', $text->get('shop'));
$page->set('listProducts', $text->get('listProducts'));
$page->set('orderId', $order['o_id']);
$page->set('company_adres', $company->getAdress());
$page->set('shop_adres', $shop->getAdress());
$page->set('currency', Core_Tools::output_varchar($shop->getCurrency()));
$page->set('date', new DateTime($order['o_orderDate']));
$page->set('thanks', $text->get('thanks'));
if ($showOnlineVersion && $order['o_isDone'] == 1) {
$page->set('sendMail', $text->get('sendMail'));
$page->set('email', $text->get('email'));
$page->set('sendIt', $text->get('sendIt'));
$page->set('printIt', $text->get('printIt'));
if ($showSended) {
$page->set('sended', $text->get('sended'));
}
$page->set('mail_action', Pages_Page::getUrl('page=order&oid=' . $order['o_id']));
}
$products = $this->getOrderedProducts($order['o_id']);
$page->set('table_cols', $showOnlineVersion ? 3 : 2);
// Fetch the categories for this shop
$categories = $shop->getCategories();
foreach ($products as $v) {
if ($v['op_amount'] > 1) {
$name = $v['op_amount'] . ' x ' . Core_Tools::output_varchar($v['p_name']);
} else {
$name = Core_Tools::output_varchar($v['p_name']);
}
// Fetch price name
$catname = '';
if (isset($categories[$v['c_id']]) && count($categories[$v['c_id']]['prices']) > 1) {
if (isset($categories[$v['c_id']]['prices'][$v['p_pid']])) {
$catname = ' (' . $categories[$v['c_id']]['prices'][$v['p_pid']]['c_name'] . ')';
}
}
$page->addListValue('products', array($name, $showNames ? Core_Tools::output_varchar($v['realname']) : null, Core_Tools::convert_price($v['op_amount'] * $v['op_price']), $v['op_message'], $catname));
}
return $page->parse('order_view.tpl');
}
public function getPoefboekLog($objCompany)
{
$me = Profile_Member::getMyself();
$status = $objCompany->getUserStatus($me);
$bShowLogs = Core_Tools::getInput('_GET', 'details', 'int') == 1;
if ($status != 'pending') {
$user = Profile_Member::getMember(Core_Tools::getInput('_GET', 'uid', 'int'));
if ($user->isFound()) {
$text = Core_Text::__getInstance();
$text->setFile('company');
$text->setSection('poeflog');
$page = new Core_Template();
$locname = Core_Tools::output_varchar($user->getUsername()) . ' @ ' . Core_Tools::output_varchar($objCompany->getName());
$page->set('poeflog', $text->get('poeflog') . ': ' . $locname);
$page->set('nologs', $text->get('nologs'));
$page->set('return', $text->get('return'));
$page->set('return_url', self::getUrl('page=company&id=' . $objCompany->getId()));
if (!$bShowLogs) {
$page->set('show_details_url', self::getUrl('page=company&id=' . $objCompany->getId() . '&action=poeflog&uid=' . $user->getId() . '&details=1'));
} else {
$page->set('hide_details_url', self::getUrl('page=company&id=' . $objCompany->getId() . '&action=poeflog&uid=' . $user->getId() . '&details=0'));
}
$page->set('datum', $text->get('datum'));
$page->set('amount', $text->get('amount'));
$page->set('balance', $text->get('balance'));
$page->set('actor', $text->get('actor'));
foreach ($objCompany->getPoefboekLog($user, $bShowLogs) as $v) {
$page->addListValue('logs', array('date' => date(DATETIME, $v['date']), 'amount' => Core_Tools::convert_price($v['amount']), 'newpoef' => Core_Tools::convert_price($v['newpoef']), 'actor_name' => $v['actor_name'], 'actor_url' => $v['actor_url'], 'comment' => Core_Tools::output_varchar($v['comment']), 'details' => $v['details']));
}
$page->set('showDetails', $bShowLogs);
return $page->parse('company_poeflog.tpl');
} else {
return '<p>User not found.</p>';
}
} else {
return '<p>No permission to watch logs.</p>';
}
}
public function date_long($stamp)
{
$text = Core_Text::__getInstance();
$dag = $text->get('day' . (date('w', $stamp) + 1), 'days', 'main');
$maand = $text->get('mon' . date('m', $stamp), 'months', 'main');
return Core_Tools::putIntoText($text->get('longDateFormat', 'dateFormat', 'main'), array($dag, date('d', $stamp), $maand, date('Y', $stamp)));
}
