private function getEditProfile()
{
$myself = Profile_Member::getMyself();
if (!$myself) {
return $this->getRegistrationForm();
}
// Process incoming data
$firstname = Core_Tools::getInput('_POST', 'firstname', 'varchar');
$name = Core_Tools::getInput('_POST', 'name', 'varchar');
$nickname = Core_Tools::getInput('_POST', 'nickname', 'username');
$email = Core_Tools::getInput('_POST', 'email', 'email');
$page = new Core_Template();
if ($firstname && $name && $nickname && $email) {
// Update the database
$db = Core_Database::__getInstance();
$db->update('players', array('firstname' => $firstname, 'lastname' => $name, 'realname' => $nickname, 'email' => $email), "plid = {$myself->getId()}");
$myself->reloadData();
$page->set('done', true);
} elseif ($firstname || $name || $nickname || $email) {
$page->set('done', false);
}
$page->set('nickname', Core_Tools::output_form($myself->getUsername()));
$page->set('firstname', Core_Tools::output_form($myself->getFirstname()));
$page->set('name', Core_Tools::output_form($myself->getName()));
$page->set('email', Core_Tools::output_form($myself->getEmail()));
return $page->parse('account_edit.tpl');
}
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 getModerators()
{
$db = Core_Database::__getInstance();
$users = $db->getDataFromQuery($db->customQuery("\n\t\t\t\tSELECT\n\t\t\t\t\tplayers.*\n\t\t\t\tFROM\n\t\t\t\t\tplayers_shop\n\t\t\t\tLEFT JOIN\n\t\t\t\t\tplayers USING(plid)\n\t\t\t\tWHERE\n\t\t\t\t\tplayers_shop.s_id = {$this->getId()}\n\t\t\t"));
$out = array();
foreach ($users as $v) {
$p = Profile_Member::getMember($v['plid']);
$p->setData($v);
$out[] = $p;
}
return $out;
}
private function processIMCommand($plid, $msg)
{
$player = Profile_Member::getMember($plid);
if ($player->isFound()) {
$commands = explode(' ', $msg);
$command = array_shift($commands);
echo 'Hi there, ' . $player->getUsername() . '. How are you doing?';
} else {
echo 'Something went wrong. Please contact the administrator.';
}
}
public function getOverview($shop)
{
/*
$login = Core_Login::__getInstance ();
$db = Core_Database::__getInstance ();
$text = Core_Text::__getInstance ();
$text->setFile ('shop');
$text->setSection ('overview');
$page = new Core_Template ();
// Fetch the title
$page->set
(
'title',
Core_Tools::putIntoText
(
$text->get ('title'),
array
(
Core_Tools::output_varchar ($objShop->getName ())
)
)
);
$page->set ('products', $text->get ('products'));
$page->set ('noProducts', $text->get ('noProducts'));
// Loop products
$products = $objShop->getProducts ();
foreach ($products as $v)
{
$page->addListValue
(
'products',
array
(
Core_Tools::output_varchar ($v['p_name']),
Core_Tools::output_varchar ($v['p_info']),
$v['p_price']
)
);
}
$page->set ('currency', Core_Tools::output_varchar ($objShop->getCurrency ()));
return $page->parse ('shop_overview.tpl');
*/
$text = Core_Text::__getInstance();
$text->setFile('order');
$text->setSection('products');
$page = new Core_Template();
if ($shop->canModerate(Profile_Member::getMyself())) {
$page->set('manage_url', self::getUrl('page=shop&id=' . $shop->getId() . '&action=manage'));
$page->set('moderator_url', self::getUrl('page=shop&id=' . $shop->getId() . '&action=moderator'));
}
$page->set('title', Core_Tools::putIntoText($text->get('title', 'overview', 'shop'), array(Core_Tools::output_varchar($shop->getName()))));
if (isset($poefboek)) {
$page->set('poefboek', Core_Tools::putIntoText($text->get('poefboek'), array($poefboek, $shop->getCurrency())));
$page->set('poefboek_value', $poefboek);
}
$categories = $shop->getCategories(true);
$page->set('order', $text->get('order', 'products', 'order'));
$page->set('currency', $shop->getCurrency());
$page->set('noProducts', $text->get('noProducts'));
$page->set('products', $text->get('products'));
$page->set('message', Core_Tools::output_text($shop->getMessage()));
$products = $shop->getProducts();
foreach ($products as $v) {
if (!isset($catProducts[$v['c_id']])) {
$catProducts[$v['c_id']] = array();
}
$catProducts[$v['c_id']][] = $v;
}
foreach ($categories as $category) {
$orderUrl = array();
$newProducts = array();
if (isset($catProducts[$category['c_id']])) {
foreach ($catProducts[$category['c_id']] as $v) {
$oUrls = array();
foreach ($orderUrl as $key => $url) {
$oUrls[$key] = self::getUrl($url . '&pid=' . $v['p_id']);
}
$newProducts[] = array(Core_Tools::output_varchar($v['p_name']), Core_Tools::output_varchar($v['p_info']), $v['prices'], $oUrls);
}
}
$page->addListValue('categories', array('name' => $category['c_name'], 'products' => $newProducts, 'prices' => $category['prices']));
}
// Show all moderators
foreach ($shop->getModerators() as $v) {
$page->addListValue('moderators', array('name' => Core_Tools::output_varchar($v->getFullname()), 'url' => 'mailto:' . $v->getEmail()));
}
return $page->parse('shop_products.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 sendMail($order, $email, $toName = "")
{
$myself = Profile_Member::getMyself();
if (!$myself) {
return;
}
Core_Tools::sendMail($this->getMailSubject($order), $this->getMailBody($order), $email, $toName, $myself->getFullname(), $myself->getEmail());
}
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>';
}
}
