/** getConfig
* @return object $config
*/
public function getConfig($temakor_id = 0)
{
$res = false;
$db = JFactory::getDBO();
if ($temakor_id != 0) {
$db->setQuery('select * from #__beallitasok where id = (10+' . $temakor_id . ')');
$res = $db->loadObject();
if ($res->json == '' | $res->json == '[]') {
$res = false;
}
}
if ($res == false) {
$db->setQuery('select * from #__beallitasok where id = 1');
$res = $db->loadObject();
}
if ($res) {
$result = JSON_decode($res->json);
} else {
$result = JSON_decode('{
"temakor_felvivok":1,
"tobbszintu_atruhazas":1,
"atruhazas_lefele_titkos":0
}');
}
return $result;
}
/**
* @test
*/
public function shouldRemoveProgressInfoFromRequest()
{
// given
$handler = new RequestHandlerMock();
// when
$json = $handler->handle("Car/1/read", array('LudoDBProgressID' => $this->getUniqueProgressId()));
$response = JSON_decode($json, true);
$data = $response['response'];
// then
$this->assertTrue($response['success'], $json);
$this->assertNotNull($data['brand'], $json);
$this->assertEquals('Opel', $data['brand'], $json);
}
/**
* objektum generálás
*/
function __construct()
{
parent::__construct();
// ============================== FIGYELEM Ha több szüro mezo van akkor át kell írni! ===================
$this->state = JSON_decode('{
"orderCol":"1",
"orderDir":"asc",
"filterStr":"",
"limitstart":0,
"limit":10,
"id":""
}
');
$this->message = JSON_decode('{
"txt":"",
"class":"msg"
}
');
if (file_exists(JPATH_COMPONENT . '/helpers/keszlet.php')) {
include_once JPATH_COMPONENT . '/helpers/keszlet.php';
$this->helper = new keszletHelper();
}
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
//
// For this week's batch of items
$requiredItems = array();
if (isset($_GET['all'])) {
// Want all orders for some reason, use with caution
$orders = Order::orderBy('id', 'desc')->get();
foreach ($orders as $order) {
// Parse it so that the template knows how to use it
$order->item_array = JSON_decode($order->item_array);
}
} else {
// Get unpaid orders by default
$orders = Order::where('paid', '=', 0)->orderBy('id', 'desc')->get();
// Calculate totals for this batch
foreach ($orders as $order) {
$order->item_array = JSON_decode($order->item_array);
foreach ($order->item_array as $item) {
if (array_key_exists($item->name, $requiredItems)) {
// The item was already added, just add the quantity
$requiredItems[$item->name] += $item->qty;
} else {
// The item isn't added yet, make a new entry
$requiredItems[$item->name] = $item->qty;
}
}
}
}
return Response::json(array('orders' => $orders, 'requiredItems' => $requiredItems));
/*
return view('orders.index')->with(array(
'orders' => $orders,
'requiredItems' => $requiredItems
));*/
}
$ext[$tmp['se']] = $tmp;
}
// Languages
$langs = query_as_array("SELECT * FROM cardname WHERE card_id = {$id}");
?>
<a href="http://magiccards.info/query?q=!<?php
echo $card_bdd['name'];
?>
&v=card&s=cname">View on MCI</a>
<table>
<tr>
<th>Extensions</th>
<td>
<ul>
<?php
$json = JSON_decode($card_bdd['attrs']);
foreach ($ext as $i => $value) {
if ($ext[$i]['nbpics'] == 0) {
echo ' <li>' . $ext[$i]['name'] . ' (' . $ext[$i]['rarity'] . ')</li>';
} else {
if ($ext[$i]['nbpics'] == 1) {
$imgurl = $cardimages_default . '/' . $ext[$i]['se'] . '/' . addslashes(card_img_by_name($card_bdd['name']));
if (isset($json->transformed_attrs->name)) {
$imgurl .= "', '" . $cardimages_default . '/' . $ext[$i]['se'] . '/' . addslashes(card_img_by_name($json->transformed_attrs->name));
}
echo ' <li><a href="extension.php?ext=' . $ext[$i]['se'] . '" onmouseover="javascript:setimage(\'' . $imgurl . '\')">' . $ext[$i]['name'] . '</a> (' . $ext[$i]['rarity'] . ')' . "\n";
echo ' </li>';
if (!isset($firstimgurl)) {
$firstimgurl = $imgurl;
}
} else {
/**
* szellemi termelés változat adat térolás adatbázisba
* @param object
* @JRequest imgdel0,imgdel1,imgdel2,imgdel3
* @JRequest img0, img1, img2, img3
* @return boolean
*/
public function save($item)
{
$user = JFactory::getUser();
// eredeti rekord elérése
$orig = $this->get_product_view_product_row($item->id);
// eredeti images elérése
if ($orig->images != '') {
$origImages = JSON_decode($orig->images);
} else {
$origImages = array();
}
while (count($origImages) < 4) {
$origImages[] = '';
}
// images_delete kérések teljesitése
for ($i = 0; $i < 5; $i++) {
$fn = 'imgdel' . $i;
if (JRequest::getVar($fn) == 1) {
unlink($origImages[$i]);
$origImages[$i] = '';
}
}
// alapértelmezett értékek beirása
$item->published = 1;
if ($item->model == '') {
$item->model = $user->username;
}
$item->alias = strtolower(preg_replace("/[^A-Za-z0-9]/", '', $item->name));
$item->date_added = date('Y-m-d H:i:s');
$item->category_id = JRequest::getVar('category_id', $orig->category_id);
if ($item->category_id == '') {
$item->category_id = $orig->category_id;
}
// tárolás adatbázisba
$table = JTable::getInstance('products', 'EcommercewdTable');
foreach ($item as $fn => $fv) {
$table->{$fn} = $fv;
}
$result = $table->store();
// új product_id lekérdezése
$product_id = $table->id;
$this->product_id = $product_id;
// image uploadok végrehajtása, új images kialakitása
if ($result) {
for ($i = 0; $i < 5; $i++) {
if (file_exists($_FILES['img' . $i]['tmp_name']) & is_uploaded_file($_FILES['img' . $i]['tmp_name'])) {
$targetFile = 'media/com_ecommercewd/uploads/images/products/' . substr($product_id, 0, 2);
if (!is_dir($targetFile)) {
mkdir($targetFile, 0777);
}
$fileExt = strtolower(pathinfo($_FILES['img' . $i]['name'], PATHINFO_EXTENSION));
if ($fileExt == 'jpg' | $fileExt == 'png') {
$targetFile .= '/' . $product_id . '_' . $_FILES['img' . $i]['name'];
if (file_exists($targetFile)) {
unlink($targetFile);
}
if (move_uploaded_file($_FILES['img' . $i]["tmp_name"], $targetFile)) {
$origImages[$i] = $targetFile;
} else {
$this->setError(JTEXT::_('COM_ECOMMERCEWD_SAVE_ERROR_1'));
$result = false;
}
} else {
$this->setError(JTEXT::_('COM_ECOMMERCEWD_ILLEGAL_FILE_EXTENSION') . ' fileExt=' . $fileExt);
$result = false;
}
}
}
// rekord update, új images adat kitárolása az adatbázisba
$images = array();
foreach ($origImages as $image) {
if ($image != '') {
$images[] = $image;
}
}
$table->images = JSON_encode($images);
if ($table->store() == false) {
$this->setError(JTEXT::_('COM_ECOMMERCEWD_SAVE_ERROR_2'));
$result = false;
}
} else {
$this->setError(JTEXT::_('COM_ECOMMERCEWD_SAVE_ERROR_0'));
}
return $result;
}
/**
* do cancelClick: redirect to lister
* JRequest: --
*/
public function cancel()
{
// pop lister status from listStatusStack
$session = JFactory::getSession();
$listStatusStack = JSON_decode($session->get('listStatusStack', '[]'));
$listStatus = $listStatusStack[count($listStatusStack) - 1];
unset($listStatusStack[count($listStatusStack) - 1]);
$link = JURI::base() . 'index.php?option=com_ammvc' . '&task=' . $this->viewName . '.list' . '&limitstart=' . $listStatus->limitstart . '&limit=' . $listStatus->limit . '&ordering=' . $listStatus->ordering . '&parent=' . $listStatus->parent . '&filterStr=' . $listStatus->filterStr;
$this->setRedirect($link);
}
/**
* browse task
* @return void
* @request integer limit
* @request integer limitstart
* @request integer order
* @request integer filterStr
* @session object 'temakoroklist_status'
*/
public function browse()
{
jimport('hs.user.user');
JHTML::_('behavior.modal');
$temakor_id = JRequest::getVar('temakor', 0);
$config = $this->temakorokHelper->getConfig($temakor_id);
$kepviseletAtruhazasMegngedett = $config->tobbszintu_atruhazas == 1;
$total = 0;
$pagination = null;
$user = JFactory::getUser();
$db = JFactory::getDBO();
// alapértelmezett browser status beolvasása sessionból
$session = JFactory::getSession();
$brStatusStr = $session->get($this->NAME . 'list_status');
if ($brStatusStr == '') {
$brStatusStr = '{"limit":20,"limitStart":0,"order":1,"filterStr":""}';
}
$brStatus = JSON_decode($brStatusStr);
$limitStart = JRequest::getVar('limitstart', $brStatus->limitstart);
$limit = JRequest::getVar('limit', $brStatus->limit);
$order = JRequest::getVar('order', $brStatus->order);
$filterStr = urldecode(JRequest::getVar('filterStr', $brStatus->filterStr));
// browser status save to session and JRequest
$brStatus->limit = $limit;
$brStatus->limitStart = $limitStart;
$brStatus->order = $order;
$brStatus->filterStr = $filterStr;
$session->set($this->NAME . 'list_status', JSON_encode($brStatus));
JRequest::setVar('limit', $limit);
JRequest::setVar('limitstart', $limitStart);
JRequest::setVar('order', $order);
JRequest::setVar('filterStr', $filterStr);
// adattábla tartalom elérése és átadása a view -nek
$items = $this->model->getItems();
$this->view->set('Items', $items);
// browser müködéshez linkek definiálása
$reorderLink = JURI::base() . 'index.php?option=com_' . $this->NAME . '&view=' . $this->NAME . 'list' . '&limit=' . JRequest::getVar('limit', '20') . '&limitstart=0' . '&filterStr=' . urlencode($filterStr);
$doFilterLink = JURI::base() . 'index.php?option=com_' . $this->NAME . '&view=' . $this->NAME . 'list' . '&limit=' . JRequest::getVar('limit', '20') . '&limitstart=0' . '&order=' . JRequest::getVar('order', '1');
$itemLink = JURI::base() . 'index.php?option=com_szavazasok&view=szavazasoklist' . '&limit=' . JRequest::getVar('limit', '20') . '&limitstart=0' . '&filterStr=' . urlencode($filterStr) . '&order=' . JRequest::getVar('order', '1');
$this->view->set('reorderLink', $reorderLink);
$this->view->set('doFilterLink', $doFilterLink);
$this->view->set('itemLink', $itemLink);
// van ált. képviselője?
$kepviseloje = 0;
$db->setQuery('select k.kepviselo_id, u.name
from #__kepviselok k, #__users u
where k.kepviselo_id = u.id and
k.user_id = "' . $user->id . '" and k.temakor_id=0 and k.szavazas_id = 0 and
k.lejarat >= "' . date('Y-m-d') . '"');
$res = $db->loadObject();
if ($db->getErrorNum() > 0) {
$db->stderr();
}
if ($res) {
$kepviseloje = $res->kepviselo_id;
}
// Ő maga képviselő jelölt?
$kepviseloJelolt = false;
$db->setQuery('select user_id
from #__kepviselojeloltek
where user_id = "' . $user->id . '" and temakor_id=0');
$res = $db->loadObject();
if ($db->getErrorNum() > 0) {
$db->stderr();
}
if ($res) {
$kepviseloJelolt = true;
}
// kik a témakor felvivők?
$temakor_felvivo = $this->temakor_felvivo();
// akciók definiálása
$akciok = array();
if ($this->temakorokHelper->isAdmin($user) | $temakor_felvivo == 1 & $user->id > 0) {
$akciok['ujTemakor'] = JURI::base() . 'index.php?option=com_' . $this->NAME . '&view=' . $this->NAME . '&task=add';
}
if ($this->temakorokHelper->isAdmin($user)) {
$akciok['beallitasok'] = JURI::base() . 'index.php?option=com_beallitasok';
}
$akciok['tagok'] = JURI::base() . 'index.php?option=com_tagok';
$akciok['sugo'] = JURI::base() . 'index.php?option=com_content&view=article' . '&id=' . JText::_(strtoupper($this->NAME) . 'LIST_SUGO') . '&Itemid=435&tmpl=component';
$this->view->set('Akciok', $akciok);
// globális képviselő/képviselő jelölt gombok definiálása
$kepviselo = array();
$kepviselo['kepviselojeLink'] = '';
$kepviselo['kepviseloJeloltLink'] = '';
$kepviselo['kepviselotValasztLink'] = '';
$kepviselo['ujJeloltLink'] = '';
if ($user->id > 0) {
if ($kepviseloje > 0) {
$kepviseloUser = JFactory::getUser($kepviseloje);
if ($kepviseloUser) {
$userEx = HsUser::getInstance($kepviseloje);
$kepviselo['kepviselojeLink'] = JURI::base() . 'index.php?option=com_kepviselok&view=kepviselok&task=show&id=' . $kepviseloje;
if (isset($userEx->image)) {
$kepviselo['image'] = $userEx->get('image');
} else {
$kepviselo['image'] = '<img src="components/com_hs_users/asset/images/noimage.png" width="50" height="50" />';
}
$kepviselo['nev'] = $kepviseloUser->name;
}
} else {
if ($kepviseloJelolt) {
$kepviselo['kepviseloJeloltLink'] = JURI::base() . 'index.php?option=com_kepviselojeloltek&view=kepviselojeloltek&task=add&id=' . $user->id;
} else {
$kepviselo['kepviselotValasztLink'] = JURI::base() . 'index.php?option=com_kepviselok&view=kepviseloklist&task=add&temekor=0&szavazas=0';
$kepviselo['ujJeloltLink'] = JURI::base() . 'index.php?option=com_kepviselojeloltek&task=add&temekor=0&szavazas=0&id=' . $user->id;
}
}
if ($kepviseletAtruhazasMegngedett) {
if ($kepviseloje == 0) {
$kepviselo['kepviselotValasztLink'] = JURI::base() . 'index.php?option=com_kepviselok&view=kepviseloklist&task=add&temekor=0&szavazas=0';
}
if (!$kepviseloJelolt) {
$kepviselo['ujJeloltLink'] = JURI::base() . 'index.php?option=com_kepviselojeloltek&task=add&temekor=0&szavazas=0&id=' . $user->id;
}
}
}
$this->view->set('Kepviselo', $kepviselo);
//lapozósor definiálása
jimport('joomla.html.pagination');
$total = $this->model->getTotal($filterStr);
$pagination = new JPagination($total, $limitStart, $limit);
$pagination->setAdditionalUrlParam('order', $order);
$pagination->setAdditionalUrlParam('filterStr', urlencode($filterStr));
$this->view->set('LapozoSor', $pagination->getListFooter());
$this->view->display();
}
<?php
session_start();
$contents = file_get_contents('php://input');
$data = JSON_decode($contents);
//var_dump($data);
if (!empty($data)) {
$sid = $data->SID;
$firstname = $data->firstname;
$surname = $data->surname;
$sex = $data->sex;
$year = $data->year;
$username = $data->username;
$password = $data->password;
$class = $data->class;
}
$sql = "UPDATE MyStudents SET `firstname` = '{$firstname}', `lastname` = '{$surname}', `sex` = '{$sex}', `year` = '{$year}', `username` = '{$username}', `password` = '{$password}', `class` = '{$class}' WHERE `Sid` = '{$sid}'";
$conn = new mysqli("localhost", "root", "duckvin", "myDb");
if ($conn->connect_errno > 0) {
die("Connection failed: " . mysqli_connect_error());
}
if ($conn->query($sql) === TRUE) {
echo "Student updated";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
/**
* $this->state feltöltése a session és JRequest alapjánn
* Ha JRequest érkezik az irja felül a session -t
*/
protected function getState()
{
$session = JFactory::getSession();
$storedState = JSON_decode($session->get($this->browserName . 'State'));
if (is_object($storedState)) {
$this->state = $storedState;
}
foreach ($this->state as $fn => $fv) {
$this->state->{$fn} = JRequest::getVar($fn, $fv);
}
}
$db->setQuery('select sz.*
from #__szavazasok sz
left outer join #__temakorok t on t.id = sz.temakor_id
left outer join #__tagok ta on ta.temakor_id = sz.temakor_id
where sz.id=' . $db->quote($data->poll_id) . ' and
((ta.user_id = ' . $db->quote($user->id) . ') or (t.lathatosag = 0))
limit 1');
$szavazas = $db->loadObject();
JRequest::setVar('szavazas', $szavazas->id);
JRequest::setVar('temakor', $szavazas->temakor_id);
if ($szavazas) {
// ha van cachelt eredmény beolvasom azt és azt használom
$db->setQuery('select * from #__poll_value_cache where pollid="' . $szavazas->id . '" and vote_count = -1');
$res = $db->loadObject();
if ($res) {
$result1 = JSON_decode($res->report);
$result = $result->result;
$result->voters = $result1->voters;
$result->api_status = $result1->api_status;
} else {
// ha nincs most képzem az eredményt
$c = new Condorcet($db, $szavazas->temmakor_id, $szavazas->id);
$result = $c->report('json');
$db->setQuery('select count(*) cc from #__szavazok where szavazas_id = ' . $db->quote($szavazas->id));
$res = $db->loadObject();
$result->voters = $res->cc;
$result->api_status = "OK";
// ha lezárt szavazás akkor tárolom a cache -be
if ($szavazas->lezart == 1) {
$db->setQuery('INSERT INTO #__poll_value_cache
VALUES (' . $szavazas->temakor_id . ',
/**
* userData objektum lekérése az ADA szervertől
* @param object token {"access_token":"xxxxxxxx",......}
* @return object {"userid":"xxxxxxxx", "email":"xxxxxxxx",......}
*/
protected function getADAuserData($token)
{
$userData = new stdClass();
$url = $this->ADA_USER_URI;
$data = array('timeout' => 30, 'redirection' => 10, 'httpversion' => '1.0', 'blocking' => true, 'cookies' => array(), 'sslverify' => $this->sslverify);
$extraHeader = 'Authorization: Bearer ' . $token->access_token;
$result = $this->remoteCall($url, 'GET', $data, $extraHeader);
if ($result != '') {
$userData = JSON_decode($result);
}
return $userData;
}
/**
* browse task
* @return void
* @request integer limit
* @request integer limitstart
* @request integer order
* @request integer filterStr
* @request integer temakor
* @request integer szavazas
* @session object 'temakoroklist_status'
*/
public function browse()
{
jimport('hs.user.user');
JHTML::_('behavior.modal');
$total = 0;
$pagination = null;
$user = JFactory::getUser();
$db = JFactory::getDBO();
// alapértelmezett browser status beolvasása sessionból
$session = JFactory::getSession();
$brStatusStr = $session->get($this->NAME . 'list_status');
if ($brStatusStr == '') {
$brStatusStr = '{"limit":20,"limitstart":0,"order":1,"filterStr":"","temakor_id":0,"szavazas_id":0}';
}
$brStatus = JSON_decode($brStatus);
$limitStart = JRequest::getVar('limitstart', $brStatus->limitstart);
$limit = JRequest::getVar('limit', $brStatus->limit);
$order = JRequest::getVar('order', $brStatus->order);
$filterStr = urldecode(JRequest::getVar('filterStr', $brStatus->filterStr));
if ($this->temakor_id == '') {
$this->temakor_id = $brStatus->temakor_id;
}
if ($this->szavazas_id == '') {
$this->szavazas_id = $brStatus->szavazas_id;
}
// browser status save to session and JRequest
$brStatus->limit = $limit;
$brStatus->limitStart = $limitStart;
$brStatus->order = $order;
$brStatus->filterStr = $filterStr;
$brStatus->temakor_id = $this->temakor_id;
$brStatus->szavazas_id = $this->szavazas_id;
$session->set($this->NAME . 'list_status', JSON_encode($brStatus));
JRequest::setVar('limit', $limit);
JRequest::setVar('limitstart', $limitstart);
JRequest::setVar('order', $order);
JRequest::setVar('filterStr', $filterStr);
JRequest::setVar('temakor', $this->temakor_id);
JRequest::setVar('szavazas', $this->szavazas_id);
// adattábla tartalom elérése és átadása a view -nek
$items = $this->model->getItems();
//DBG echo $this->model->getDBO()->getQuery();
if ($this->model->getError() != '') {
$this->view->Msg = $this->model->getError();
}
$this->view->set('Items', $items);
$this->view->set('Temakor', $this->temakor);
$this->view->set('Szavazas', $this->szavazas);
$this->view->set('Title', JText::_('ALTERNATIVAK'));
// browser müködéshez linkek definiálása
if ($this->szavazas->vita1 == 1) {
$itemLink = JURI::base() . 'index.php?option=com_alternativak&view=alternativak' . '&task=edit' . '&limit=' . JRequest::getVar('limit', '20') . '&limitstart=0' . '&filterStr=' . urlencode($filterStr) . '&order=' . JRequest::getVar('order', '1') . '&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id;
} else {
$itemLink = '';
}
$backLink = JURI::base() . 'index.php?option=com_szavazasok&view=szavazasoklist' . '&temakor=' . $this->temakor_id . '&task=browse';
$homeLink = JURI::base() . 'index.php?option=com_temakorok&view=temakoroklist' . '&task=browse';
$this->view->set('itemLink', $itemLink);
$this->view->set('backLink', $backLink);
$this->view->set('homeLink', $homeLink);
// van ált. képviselője?
$altKepviseloje = 0;
$db->setQuery('select k.kepviselo_id, u.name
from #__kepviselok k, #__users u
where k.kepviselo_id = u.id and
k.user_id = "' . $user->id . '" and k.temakor_id=0 and k.szavazas_id = 0 and
k.lejarat >= "' . date('Y-m-d') . '"');
$res = $db->loadObject();
if ($db->getErrorNum() > 0) {
$db->stderr();
}
if ($res) {
$altKepviseloje = $res->kepviselo_id;
}
// van témakör képviselője?
$kepviseloje = 0;
$db->setQuery('select k.kepviselo_id, u.name
from #__kepviselok k, #__users u
where k.kepviselo_id = u.id and
k.user_id = "' . $user->id . '" and k.temakor_id=' . $this->temakor_id . ' and k.szavazas_id = 0 and
k.lejarat >= "' . date('Y-m-d') . '"');
$res = $db->loadObject();
if ($db->getErrorNum() > 0) {
$db->stderr();
}
if ($res) {
$kepviseloje = $res->kepviselo_id;
}
// Ő maga képviselő jelölt?
$kepviseloJelolt = false;
$db->setQuery('select user_id
from #__kepviselojeloltek
where user_id = "' . $user->id . '"');
$res = $db->loadObject();
if ($db->getErrorNum() > 0) {
$db->stderr();
}
if ($res) {
$kepviseloJelolt = true;
}
// kik az alternativa felvivők?
$alternativa_felvivo = $this->alternativa_felvivo();
// akciók definiálása
$akciok = array();
if ($this->temakorokHelper->isAdmin($user) | $szavazas_felvivo == 10 & ($this->szavazas->szavazok = 1) & $user->id > 0 | $szavazas_felvivo == 10 & $this->userTag($this->temakor_id, $user) | $this->szavazasIndito($this->szavazas_id, $user)) {
if ($this->szavazas->vita1 == 1) {
$akciok['ujAlternativa'] = JURI::base() . 'index.php?option=com_' . $this->NAME . '&view=' . $this->NAME . '&task=add' . '&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id . '&limit=' . JRequest::getVar('limit', 20) . '&limitstart=' . JRequest::getVar('limitstart', 0) . '&order=' . JRequest::getVar('order', 1) . '&filterStr=' . JRequest::getVar('filterStr', '');
}
}
if ($this->temakorokHelper->isAdmin($user) | $this->szavazas->letrehozo == $user->id) {
$akciok['szavazasedit'] = JURI::base() . 'index.php?option=com_szavazasok&view=szavazasok&task=edit' . '&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id;
}
if ($this->temakorokHelper->isAdmin($user) | $this->szavazas->letrehozo == $user->id) {
$akciok['szavazastorles'] = JURI::base() . 'index.php?option=com_szavazasok&view=szavazasok&task=deleteform' . '&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id;
}
if ($this->temakorokHelper->isAdmin($user) | $this->temakorIndito($this->temakor_id, $user)) {
$akciok['temakoredit'] = JURI::base() . 'index.php?option=com_temakorok&view=temakorok&task=edit' . '&temakor=' . $this->temakor_id;
}
if ($this->temakorokHelper->isAdmin($user) | $this->temakorIndito($this->temakor_id, $user)) {
$akciok['temakortorles'] = JURI::base() . 'index.php?option=com_temakorok&view=temakorok&task=deleteform' . '&temakor=' . $this->temakor_id;
}
if ($this->temakorokHelper->isAdmin($user) | $this->temakorIndito($this->temakor_id, $user)) {
if ($this->szavazas->vita1 == 1) {
$akciok['alternativaedit'] = JURI::base() . 'index.php?option=com_alternativak&view=alternativak&task=edit' . '&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id;
}
}
if ($this->temakorokHelper->isAdmin($user) | $this->temakorIndito($this->temakor_id, $user)) {
if ($this->szavazas->vita1 == 1) {
$akciok['alternativatorles'] = JURI::base() . 'index.php?option=com_alternativak&view=alternativak&task=deleteform' . '&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id;
}
}
if ($this->szavazas->szavazas == 1 & $user->id > 0) {
$db = JFactory::getDBO();
$db->setQuery('select id from #__szavazatok
where szavazas_id="' . $this->szavazas_id . '" and
user_id="' . $user->id . '"');
$res = $db->loadObjectList();
if (count($res) == 0) {
$akciok['szavazok'] = JURI::base() . 'index.php?option=com_szavazasok&view=szavazasok&task=szavazoform&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id;
}
}
if ($this->szavazas->lezart == 1) {
$akciok['eredmeny'] = JURI::base() . 'index.php?option=com_szavazasok&view=szavazasok&task=eredmeny&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id;
}
$akciok['tagok'] = JURI::base() . 'index.php?option=com_tagok&temakor=' . $this->temakor_id;
$akciok['sugo'] = JURI::base() . 'index.php?option=com_content&view=article' . '&id=' . JText::_(strtoupper($this->NAME) . 'LIST_SUGO') . '&Itemid=435&tmpl=component';
$this->view->set('Akciok', $akciok);
// globális képviselő/képviselő jelölt gombok definiálása
$altKepviselo = array();
$altKepviselo['kepviselojeLink'] = '';
$kepviselo = array();
$kepviselo['kepviselojeLink'] = '';
$kepviselo['kepviseloJeloltLink'] = '';
$kepviselo['kepviselotValasztLink'] = '';
$kepviselo['ujJeloltLink'] = '';
if ($user->id > 0) {
if ($altKepviseloje > 0) {
$kepviseloUser = JFactory::getUser($altKepviseloje);
if ($kepviseloUser) {
$userEx = HsUser::getInstance($altKepviseloje);
$altKepviselo['kepviselojeLink'] = JURI::base() . 'index.php?option=com_kepviselok&task=show&id=' . $altKepviseloje;
if (isset($userEx->image)) {
$altKepviselo['image'] = $userEx->get('image');
} else {
$altKepviselo['image'] = '<img src="components/com_hs_users/asset/images/noimage.png" width="50" height="50" />';
}
$altKepviselo['nev'] = $kepviseloUser->name;
}
}
if ($kepviseloje > 0) {
$kepviseloUser = JFactory::getUser($kepviseloje);
if ($kepviseloUser) {
$userEx = HsUser::getInstance($kepviseloje);
$kepviselo['kepviselojeLink'] = JURI::base() . 'index.php?option=com_kepviselok&task=show&id=' . $kepviseloje;
if (isset($userEx->image)) {
$kepviselo['image'] = $userEx->get('image');
} else {
$kepviselo['image'] = '<img src="components/com_hs_users/asset/images/noimage.png" width="50" height="50" />';
}
$kepviselo['nev'] = $kepviseloUser->name;
}
} else {
if ($kepviseloJelolt) {
$kepviselo['kepviseloJeloltLink'] = JURI::base() . 'index.php?option=com_kepviselo&task=edit&id=' . $user->id;
} else {
$kepviselo['kepviselotValasztLink'] = JURI::base() . 'index.php?option=com_kepviselok&task=find&temekor=' . $this->temakor_id . '&szavazas=0';
$kepviselo['ujJeloltLink'] = JURI::base() . 'index.php?option=com_kepviselojeloltek&task=add&temekor=' . $this->temakor_id . '&szavazas=0&id=' . $user->id;
}
}
}
$this->view->set('Kepviselo', $kepviselo);
$this->view->set('AltKepviselo', $altKepviselo);
//lapozósor definiálása
jimport('joomla.html.pagination');
$total = $this->model->getTotal($filterStr);
$pagination = new JPagination($total, $limitStart, $limit);
$pagination->setAdditionalUrlParam('order', $order);
$pagination->setAdditionalUrlParam('filterStr', urlencode($filterStr));
$this->view->set('Lapozosor', $pagination->getListFooter());
$this->view->display();
}
public function available_boards(&$db)
{
try {
$sql = 'SELECT boardid, title, client, creationDate, dueDate, is_locked, locked_by, lock_expires
FROM storyboards
WHERE boardid
IN (SELECT boardid FROM permissions WHERE userid = :userid)
ORDER BY creationDate DESC';
$stmt = $db->prepare($sql);
$stmt->bindValue(':userid', $this->userid);
$stmt->execute();
$stmt->bindColumn('boardid', $boardid);
$stmt->bindColumn('title', $title);
$stmt->bindColumn('client', $client);
$stmt->bindColumn('creationDate', $creationDate);
$stmt->bindColumn('dueDate', $dueDate);
$stmt->bindColumn('is_locked', $is_locked);
$stmt->bindColumn('locked_by', $locked_by);
$stmt->bindColumn('lock_expires', $lock_expires);
$errorInfo = $stmt->errorInfo();
if (isset($errorInfo[2])) {
$error = $errorInfo[2];
}
} catch (Exception $e) {
$error = $e->getMessage();
}
$stmt->fetch(PDO::FETCH_BOUND);
if ($boardid) {
echo '<div class="board-selection">';
echo '<h2>Select a Storyboard:</h2>';
echo '<form method="post" action="/storyboardapp/"><fieldset>';
$i = 0;
do {
echo "<label for=\"board-{$i}\"><input type=\"radio\" name=\"boardid\" id=\"board-{$i}\" value=\"{$boardid}\"> <p>" . JSON_decode($title) . ' by ' . JSON_decode($client) . " (created {$creationDate}";
if ($dueDate != "") {
echo '; due ' . $dueDate;
}
echo ')';
if ($is_locked && $locked_by != $this->userid && time() < $lock_expires) {
echo ' <span class="submessage">* read-only</span>';
}
echo '</p></label>';
$i++;
} while ($stmt->fetch(PDO::FETCH_BOUND));
echo '<label for="board-new"><input type="radio" name="boardid" id="board-new" value="new"> <p>New Storyboard</p></label>';
echo '</fieldset>';
echo '<input type="submit" value="Load Board" class="load-board-button">';
echo '</form>';
echo '<h4><span class="green">* Boards may be read-only because they are currently being edited by someone else or because you do not have permission to edit them.</span></h4>';
echo '</div>';
return true;
} else {
return false;
}
}
/**
* ujTag felvételi form
* @return void
* &JRequest: limit, limitstart, filterStr, order
*/
public function ujTag()
{
JHTML::_('behavior.modal');
$total = 0;
$pagination = null;
$user = JFactory::getUser();
$db = JFactory::getDBO();
if (!$this->temakorokHelper->isAdmin($user) & !$this->temakor_admin) {
echo '<div class="">Access denied</div>';
return;
}
// alapértelmezett browser status beolvasása sessionból
$session = JFactory::getSession();
$brStatusStr = '{"limit":20,"limitstart":0,"order":1,"filterStr":""}';
$brStatus = JSON_decode($brStatusStr);
$limitStart = JRequest::getVar('limitstart', $brStatus->limitstart);
$limit = JRequest::getVar('limit', $brStatus->limit);
$order = JRequest::getVar('order', $brStatus->order);
$filterStr = urldecode(JRequest::getVar('filterStr', $brStatus->filterStr));
JRequest::setVar('limit', $limit);
JRequest::setVar('limitstart', $limitStart);
JRequest::setVar('order', $order);
JRequest::setVar('filterStr', $filterStr);
// adattábla tartalom elérése és átadása a view -nek
$items = $this->model->getItems();
//DBG echo $this->model->getDBO()->getQuery();
$this->view->set('Items', $items);
// browser müködéshez linkek definiálása
$reorderLink = JURI::base() . 'index.php?option=com_' . $this->NAME . '&view=' . $this->NAME . 'list&tas=ujTag' . '&limit=' . JRequest::getVar('limit', '20') . '&limitstart=0' . '&temakor=' . $this->temakor_id . '&filterStr=' . urlencode($filterStr);
$doFilterLink = JURI::base() . 'index.php?option=com_' . $this->NAME . '&view=' . $this->NAME . 'list&task=ujTag' . '&limit=' . JRequest::getVar('limit', '20') . '&limitstart=0' . '&temakor=' . $this->temakor_id . '&order=' . JRequest::getVar('order', '1');
if ($this->temakor_id > 0) {
$itemLink = JURI::base() . 'index.php?option=com_tagok&view=tagok&task=doujtag' . '&limit=' . JRequest::getVar('limit', '20') . '&limitstart=0' . '&filterStr=' . urlencode($filterStr) . '&temakor=' . $this->temakor_id . '&order=' . JRequest::getVar('order', '1');
}
$this->view->set('reorderLink', $reorderLink);
$this->view->set('doFilterLink', $doFilterLink);
$this->view->set('itemLink', $itemLink);
// akciók definiálása
$akciok = array();
if ($this->temakor_id > 0) {
$akciok['temakor'] = JURI::base() . 'index.php?option=com_szavazasok&view=szavazasoklist&task=browse' . '&temakor=' . $this->temakor_id;
} else {
$akciok['temakorok'] = JURI::base() . 'index.php?option=com_temakorok&view=temakoroklist&task=browse';
}
$akciok['sugo'] = JURI::base() . 'index.php?option=com_content&view=article' . '&id=' . JText::_('UJTAG_SUGO') . '&Itemid=435&tmpl=component';
$this->view->set('Akciok', $akciok);
$this->view->set('Title', JText::_('UJTAG'));
$this->view->set('Temakor', $this->temakor);
//lapozósor definiálása
jimport('joomla.html.pagination');
$total = $this->model->getTotal($filterStr);
$pagination = new JPagination($total, $limitStart, $limit);
$pagination->setAdditionalUrlParam('order', $order);
$pagination->setAdditionalUrlParam('filterStr', urlencode($filterStr));
$pagination->setAdditionalUrlParam('temakor', $this->temakor_id);
$this->view->set('LapozoSor', $pagination->getListFooter());
$this->view->setLayout('ujtag');
$this->view->display();
}
/**
* képviselő eddigi szavazatainak megjelenítése
* (böngésző képernyő)
* @return void
* @JRequest integer temakor
* @JRequest integer id - kepviselo_id
* @JRequest integer limitstart
* @JRequest integer limit
* @JRequest string filterStr
* @JRequest integer order
*/
public function szavazatok()
{
JHTML::_('behavior.modal');
$total = 0;
$pagination = null;
$user = JFactory::getUser();
$db = JFactory::getDBO();
$document = JFactory::getDocument();
$viewType = $document->getType();
$view =& $this->getView('szavazatoklist', $viewType);
$model =& $this->getModel('szavazatoklist');
// alapértelmezett browser status beolvasása sessionból
$session = JFactory::getSession();
$brStatusStr = $session->get('szavazasoklist_status');
if ($brStatusStr == '') {
$brStatusStr = '{"limit":20,"limitstart":0,"order":1,"filterStr":""}';
}
$brStatus = JSON_decode($brStatus);
$limitStart = JRequest::getVar('limitstart', $brStatus->limitstart);
$limit = JRequest::getVar('limit', $brStatus->limit);
$order = JRequest::getVar('order', $brStatus->order);
$filterStr = urldecode(JRequest::getVar('filterStr', $brStatus->filterStr));
// browser status save to session and JRequest
$brStatus->limit = $limit;
$brStatus->limitStart = $limitStart;
$brStatus->order = $order;
$brStatus->filterStr = $filterStr;
// ebben az esetben inkább ne jegyezze meg....
//$session->set('szavazatoklist_status', JSON_encode($brStatus));
JRequest::setVar('limit', $limit);
JRequest::setVar('limitstart', $limitStart);
JRequest::setVar('order', $order);
JRequest::setVar('filterStr', $filterStr);
// adattábla tartalom elérése és átadása a view -nek
$items = $model->getItems();
//DBG echo '<p>'.$model->getDBO()->getQuery().'</p>';
// items-temakor-user hozzáférés ellenörzés
if ($this->temakorokHelper->isAdmin($user) == false) {
for ($i = 0; $i < count($items); $i++) {
$item = $items[$i];
if ($item->lathatosag == 1 & $user->id == 0 | $item->lathatosag == 2 & $this->temakorokHelper->userTag($item->id, $user) == false) {
// letiltott
$items[$i]->szmegenevezes = '***';
$items[$i]->amegenevezes = '***';
$items[$i]->pozicio = '**';
}
}
}
$view->set('Items', $items);
// témakör beolvasása
$db->setQuery('select * from #__temakorok where id="' . JRequest::getVar('temakor', 0) . '"');
$view->Temakor = $db->loadObject();
if ($view->Temakor == false) {
$view->Temakor = new stdclass();
$view->Temakor->megnevezes = JText::_('ALTALANOSKEPVISELO');
$view->Temakor->id = 0;
} else {
$view->Temakor->megnevezes .= ' ' . JText::_('KEPVISELO');
}
// képviselő adatok beolvasása
$view->set('Kuser', JFactory::getUser(JRequest::getVar('id', 0)));
// browser müködéshez linkek definiálása
$reorderLink = JURI::base() . 'index.php?option=com_kepviselok&view=kepviselok&task=szavazatok' . '&limit=' . JRequest::getVar('limit', '20') . '&limitstart=0' . '&filterStr=' . urlencode($filterStr) . '&temakor=' . JRequest::getVar('temakor') . '&id=' . JRequest::getVar('id', 0);
$doFilterLink = JURI::base() . 'index.php?option=com_kepviselok&view=kepviselok&task=add' . '&limit=' . JRequest::getVar('limit', '20') . '&limitstart=0' . '&order=' . JRequest::getVar('order', '1') . '&temakor=' . JRequest::getVar('temakor') . '&id=' . JRequest::getVar('id', 0);
$view->set('reorderLink', $reorderLink);
$view->set('doFilterLink', $doFilterLink);
// akciók definiálása
$akciok = array();
$akciok['back'] = JURI::base() . 'index.php?option=com_kepviselok&view=kepviselok&task=show' . '&temakor=' . JRequest::getVar('temakor') . '&id=' . JRequest::getVar('id', 0);
$akciok['sugo'] = JURI::base() . 'index.php?option=com_content&view=article' . '&id=' . JText::_('SZAVAZATOKSUGO') . '&Itemid=435&tmpl=component';
$view->set('Akciok', $akciok);
//lapozósor definiálása
jimport('joomla.html.pagination');
$total = $model->getTotal($filterStr);
$pagination = new JPagination($total, $limitStart, $limit);
$pagination->setAdditionalUrlParam('order', $order);
$pagination->setAdditionalUrlParam('filterStr', urlencode($filterStr));
$view->set('LapozoSor', $pagination->getListFooter());
// display
$view->setLayout('browse');
$view->display();
}
/**
* browse task
* @return void
* @request integer limit
* @request integer limitstart
* @request integer order
* @request integer filterStr
* @request integer temakor
* @request integer szavazas
* @session object 'temakoroklist_status'
*/
public function browse()
{
jimport('hs.user.user');
JHTML::_('behavior.modal');
$total = 0;
$pagination = null;
$user = JFactory::getUser();
$db = JFactory::getDBO();
// hozzáférés ellenörzés
if ($this->temakorokHelper->isAdmin($user) == false) {
if ($this->temakor->lathatosag == 1 & $user->id == 0 | $this->temakor->lathatosag == 2 & $this->temakorokHelper->userTag($this->temakor->id, $user) == false) {
// Redirect to login
$this->temakorokHelper->getLogin(JText::_('TEMAKOR_NEKED_NEM_ELERHETO'));
}
}
// alapértelmezett browser status beolvasása sessionból
$session = JFactory::getSession();
$brStatusStr = $session->get($this->NAME . 'list_status');
if ($brStatusStr == '') {
$brStatusStr = '{"limit":20,"limitStart":0,"order":1,"filterStr":"","temakor_id":0,"szavazas_id":0}';
}
$brStatus = JSON_decode($brStatusStr);
$limitStart = JRequest::getVar('limitstart', $brStatus->limitstart);
$limit = JRequest::getVar('limit', $brStatus->limit);
$order = JRequest::getVar('order', $brStatus->order);
$filterStr = urldecode(JRequest::getVar('filterStr', $brStatus->filterStr));
if ($this->temakor_id == '') {
$this->temakor_id = $brStatus->temakor_id;
}
if ($this->szavazas_id == '') {
$this->szavazas_id = $brStatus->szavazas_id;
}
// browser status save to session and JRequest
$brStatus->limit = $limit;
$brStatus->limitStart = $limitStart;
$brStatus->order = $order;
$brStatus->filterStr = $filterStr;
$brStatus->temakor_id = $this->temakor_id;
$brStatus->szavazas_id = $this->szavazas_id;
$session->set($this->NAME . 'list_status', JSON_encode($brStatus));
JRequest::setVar('limit', $limit);
JRequest::setVar('limitstart', $limitStart);
JRequest::setVar('order', $order);
JRequest::setVar('filterStr', $filterStr);
JRequest::setVar('temakor', $this->temakor_id);
JRequest::setVar('szavazas', $this->szavazas_id);
// adattábla tartalom elérése és átadása a view -nek
$items = $this->model->getItems();
$db->setQuery('select sum(igen) igen, sum(nem) nem
from #__szavazasok_in
where szavazas_id = ' . $db->quote($this->szavazas_id));
$igenNem = $db->loadObject();
// user szavazott?
$db->setQuery('select * from #__szavazok where szavazas_id="' . $this->szavazas->id . '" and user_id="' . $user->id . '"');
$szavazo = $db->loadObject();
//DBG echo $this->model->getDBO()->getQuery();
if ($this->model->getError() != '') {
$this->view->Msg = $this->model->getError();
}
$this->view->set('Items', $items);
$this->view->set('igen', $igenNem->igen);
$this->view->set('nem', $igenNem->nem);
$this->view->set('Temakor', $this->temakor);
$this->view->set('Szulok', $this->temakorokHelper->getSzulok());
$this->view->set('Szavazas', $this->szavazas);
$this->view->set('Szavazo', $szavazo);
$this->view->set('Title', JText::_('ALTERNATIVAK'));
$this->view->set('TemakorGroupId', $this->temakorokHelper->getTemakorGroupId($this->temakor->id));
//+ 2014.09.10 Az alternativa név csak akkor link ha jogosult módosítani
$this->view->set('isAdmin', $this->temakorokHelper->isAdmin($user));
$this->view->set('temakor_admin', $this->temakor_admin);
$this->view->set('user', $user);
//- 2014.09.10 Az alternativa név csak akkor link ha jogosult módosítani
// hányan szavaztak már?
$db->setQuery('select count(distinct szavazo_id) cc from #__szavazatok where szavazas_id="' . $this->szavazas->id . '"');
$res = $db->loadObject();
$szavaztak = $res->cc;
$this->view->set('szavaztak', $szavaztak);
// browser müködéshez linkek definiálása
if ($this->szavazas->vita1 == 1) {
$itemLink = JURI::base() . 'index.php?option=com_alternativak&view=alternativak' . '&task=edit' . '&limit=' . JRequest::getVar('limit', '20') . '&limitstart=0' . '&filterStr=' . urlencode($filterStr) . '&order=' . JRequest::getVar('order', '1') . '&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id;
} else {
$itemLink = '';
}
$backLink = JURI::base() . 'index.php?option=com_szavazasok&view=szavazasoklist' . '&temakor=' . $this->temakor_id . '&task=browse';
$homeLink = JURI::base() . 'index.php?option=com_temakorok&view=temakoroklist' . '&task=browse';
$this->view->set('itemLink', $itemLink);
$this->view->set('backLink', $backLink);
$this->view->set('homeLink', $homeLink);
// van ált. képviselője?
$altKepviseloje = 0;
$db->setQuery('select k.kepviselo_id, u.name
from #__kepviselok k, #__users u
where k.kepviselo_id = u.id and
k.user_id = "' . $user->id . '" and k.temakor_id=0 and k.szavazas_id = 0 and
k.lejarat >= "' . date('Y-m-d') . '"');
$res = $db->loadObject();
if ($db->getErrorNum() > 0) {
$db->stderr();
}
if ($res) {
$altKepviseloje = $res->kepviselo_id;
}
// van témakör képviselője?
$kepviseloje = 0;
$db->setQuery('select k.kepviselo_id, u.name
from #__kepviselok k, #__users u
where k.kepviselo_id = u.id and
k.user_id = "' . $user->id . '" and k.temakor_id=' . $this->temakor_id . ' and k.szavazas_id = 0 and
k.lejarat >= "' . date('Y-m-d') . '"');
$res = $db->loadObject();
if ($db->getErrorNum() > 0) {
$db->stderr();
}
if ($res) {
$kepviseloje = $res->kepviselo_id;
}
// Ő maga képviselő jelölt?
$kepviseloJelolt = false;
$db->setQuery('select user_id
from #__kepviselojeloltek
where user_id = "' . $user->id . '"');
$res = $db->loadObject();
if ($db->getErrorNum() > 0) {
$db->stderr();
}
if ($res) {
$kepviseloJelolt = true;
}
// kik az alternativa felvivők?
$alternativa_felvivo = $this->alternativa_felvivo($user);
// akciók definiálása
$akciok = array();
if ($this->temakorokHelper->isAdmin($user) | $szavazas_felvivo == 10 & ($this->szavazas->szavazok = 1) & $user->id > 0 | $szavazas_felvivo == 10 & $this->temakorokHelper->userTag($this->temakor_id, $user) | $this->temakor_admin | $this->alternativa_felvivo($user)) {
if ($this->szavazas->vita1 == 1) {
$akciok['ujAlternativa'] = JURI::base() . 'index.php?option=com_' . $this->NAME . '&view=' . $this->NAME . '&task=add' . '&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id . '&limit=' . JRequest::getVar('limit', 20) . '&limitstart=' . JRequest::getVar('limitstart', 0) . '&order=' . JRequest::getVar('order', 1) . '&filterStr=' . JRequest::getVar('filterStr', '');
}
}
if ($this->temakorokHelper->isAdmin($user) | $this->temakor_admin | $this->szavazas->letrehozo == $user->id) {
$akciok['szavazasedit'] = JURI::base() . 'index.php?option=com_szavazasok&view=szavazasok&task=edit' . '&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id;
}
if ($this->temakorokHelper->isAdmin($user) | $this->temakor_admin | $this->szavazas->letrehozo == $user->id) {
$akciok['szavazastorles'] = JURI::base() . 'index.php?option=com_szavazasok&view=szavazasok&task=deleteform' . '&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id;
}
if ($this->temakorokHelper->isAdmin($user) | $this->temakor_admin | $this->temakorIndito($this->temakor_id, $user)) {
$akciok['temakoredit'] = JURI::base() . 'index.php?option=com_temakorok&view=temakorok&task=edit' . '&temakor=' . $this->temakor_id;
}
if ($this->temakorokHelper->isAdmin($user) | $this->temakor_admin | $this->temakorIndito($this->temakor_id, $user)) {
$akciok['temakortorles'] = JURI::base() . 'index.php?option=com_temakorok&view=temakorok&task=deleteform' . '&temakor=' . $this->temakor_id;
}
if ($this->temakorokHelper->isAdmin($user) | $this->temakor_admin | $this->temakorIndito($this->temakor_id, $user)) {
if ($this->szavazas->vita1 == 1) {
$akciok['alternativaedit'] = JURI::base() . 'index.php?option=com_alternativak&view=alternativak&task=edit' . '&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id;
}
}
if ($this->temakorokHelper->isAdmin($user) | $this->temakor_admin | $this->temakorIndito($this->temakor_id, $user)) {
if ($this->szavazas->vita1 == 1) {
$akciok['alternativatorles'] = JURI::base() . 'index.php?option=com_alternativak&view=alternativak&task=deleteform' . '&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id;
}
}
if ($this->szavazas->szavazas == 1 & $user->id > 0) {
// a szavazás folyamatban van és bejelentkezett user
$db = JFactory::getDBO();
$db->setQuery('select id from #__szavazatok
where szavazas_id="' . $this->szavazas_id . '" and
user_id="' . $user->id . '"');
$res = $db->loadObjectList();
if (count($res) == 0) {
// ez a user még nem szavazott
if ($this->szavazas->szavazok == 1 | $this->szavazas->szavazok == 2 & $this->temakorokHelper->userTag($this->temakor_id, $user, false) | $this->szavazas->szavazok == 3 & $this->temakorokHelper->userTag($this->temakor_id, $user, true)) {
$akciok['szavazok'] = JURI::base() . 'index.php?option=com_szavazasok&view=szavazasok&task=szavazoform&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id;
}
} else {
$akciok['szavaztal'] = 'Y';
if ($this->szavazas->titkos == 0) {
$akciok['szavazatTorles'] = JURI::base() . 'index.php?option=com_alternativak&&task=szavazattorles&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id;
}
}
}
// if ($this->szavazas->lezart == 1) {
$akciok['eredmeny'] = JURI::base() . 'index.php?option=com_szavazasok&view=szavazasok&task=eredmeny&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id;
// }
if ($this->szavazas->szavazas == 1 & $user->id > 0) {
$akciok['emailszavazas'] = JURI::base() . 'index.php?option=com_szavazasok&view=szavazasok&task=meghivo&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id;
}
$akciok['copy'] = JURI::base() . 'index.php?option=com_alternativak&view=alternativaklist&task=copy' . '&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id;
$akciok['tagok'] = JURI::base() . 'index.php?option=com_tagok&temakor=' . $this->temakor_id;
$akciok['sugo'] = JURI::base() . 'index.php?option=com_content&view=article' . '&id=' . JText::_(strtoupper($this->NAME) . 'LIST_SUGO') . '&Itemid=435&tmpl=component';
$akciok['deleteSzavazas'] = JURI::base() . 'index.php?option=com_szavazasok&view=szavazasok&task=deleteform' . '&temakor=' . $this->temakor_id . '&szavazas=' . $this->szavazas_id;
$this->view->set('Akciok', $akciok);
// globális képviselő/képviselő jelölt gombok definiálása
$altKepviselo = array();
$altKepviselo['kepviselojeLink'] = '';
$kepviselo = array();
$kepviselo['kepviselojeLink'] = '';
$kepviselo['kepviseloJeloltLink'] = '';
$kepviselo['kepviselotValasztLink'] = '';
$kepviselo['ujJeloltLink'] = '';
if ($user->id > 0) {
if ($altKepviseloje > 0) {
$kepviseloUser = JFactory::getUser($altKepviseloje);
if ($kepviseloUser) {
$userEx = HsUser::getInstance($altKepviseloje);
$altKepviselo['kepviselojeLink'] = JURI::base() . 'index.php?option=com_kepviselok&task=show&id=' . $altKepviseloje;
if (isset($userEx->image)) {
$altKepviselo['image'] = $userEx->get('image');
} else {
$altKepviselo['image'] = '<img src="components/com_hs_users/asset/images/noimage.png" width="50" height="50" />';
}
$altKepviselo['nev'] = $kepviseloUser->name;
}
}
if ($kepviseloje > 0) {
$kepviseloUser = JFactory::getUser($kepviseloje);
if ($kepviseloUser) {
$userEx = HsUser::getInstance($kepviseloje);
$kepviselo['kepviselojeLink'] = JURI::base() . 'index.php?option=com_kepviselok&task=show&id=' . $kepviseloje;
if (isset($userEx->image)) {
$kepviselo['image'] = $userEx->get('image');
} else {
$kepviselo['image'] = '<img src="components/com_hs_users/asset/images/noimage.png" width="50" height="50" />';
}
$kepviselo['nev'] = $kepviseloUser->name;
}
} else {
if ($kepviseloJelolt) {
$kepviselo['kepviseloJeloltLink'] = JURI::base() . 'index.php?option=com_kepviselo&task=edit&id=' . $user->id;
} else {
$kepviselo['kepviselotValasztLink'] = JURI::base() . 'index.php?option=com_kepviselok&task=find&temekor=' . $this->temakor_id . '&szavazas=0';
$kepviselo['ujJeloltLink'] = JURI::base() . 'index.php?option=com_kepviselojeloltek&task=add&temekor=' . $this->temakor_id . '&szavazas=0&id=' . $user->id;
}
}
}
$this->view->set('Kepviselo', $kepviselo);
$this->view->set('AltKepviselo', $altKepviselo);
//lapozósor definiálása
jimport('joomla.html.pagination');
$total = $this->model->getTotal($filterStr);
$pagination = new JPagination($total, $limitStart, $limit);
$pagination->setAdditionalUrlParam('order', $order);
$pagination->setAdditionalUrlParam('filterStr', urlencode($filterStr));
$this->view->set('LapozoSor', $pagination->getListFooter());
// kacsolodó cikk id-jének elérése és átadása a viewer-nek
$db->setQuery('SELECT id from #__content WHERE alias="sz' . $this->szavazas_id . '"');
$res = $db->loadObject();
if ($res) {
$this->view->set('CommentId', $res->id);
} else {
$this->view->set('CommentId', 0);
}
$this->view->display();
}
function exchange_set_gravity_story_attachments($entry)
{
$gf_story_images_field_id = $GLOBALS['EXCHANGE_PLUGIN_CONFIG']['GRAVITY_FORMS']['fields']['story-images'];
// the story attachments
$gf_story_title_field_id = $GLOBALS['EXCHANGE_PLUGIN_CONFIG']['GRAVITY_FORMS']['fields']['story-title'];
//Retrieve story form ID from options and verify.
$story_form_id = get_option('options_story_update_form');
if (empty($story_form_id) || intval($entry['form_id']) !== intval($story_form_id)) {
return;
}
$post_id = $entry['post_id'];
$story_submission_hash = get_post_meta($post_id, 'story_form_submission_hash', true);
if (sha1($entry['id'] . $entry[$gf_story_title_field_id]) !== $story_submission_hash) {
return;
}
// Delete submission hash.
delete_post_meta($post_id, 'story_form_submission_hash');
$images = JSON_decode($entry[$gf_story_images_field_id]);
if (!is_array($images) || count($images) < 1) {
return;
}
// Attach images to post.
foreach ($images as $image) {
$attachment_id = exchange_create_image_id($image, $post_id);
}
}
public function load_board(&$db, $boardid, $userid)
{
try {
$sql = 'SELECT title, client, creationDate, dueDate, scenes, is_locked, locked_by, lock_expires
FROM storyboards
WHERE boardid = :boardid';
$stmt = $db->prepare($sql);
$stmt->bindValue(':boardid', $boardid);
$stmt->execute();
$stmt->bindColumn('title', $title);
$stmt->bindColumn('client', $client);
$stmt->bindColumn('creationDate', $creationDate);
$stmt->bindColumn('dueDate', $dueDate);
$stmt->bindColumn('scenes', $scenes);
$stmt->bindColumn('is_locked', $is_locked);
$stmt->bindColumn('locked_by', $locked_by);
$stmt->bindColumn('lock_expires', $lock_expires);
$errorInfo = $stmt->errorInfo();
if (isset($errorInfo[2])) {
$error = $errorInfo[2];
}
} catch (Exception $e) {
$error = $e->getMessage();
}
if (isset($error)) {
return [false, $error];
}
$stmt->fetch(PDO::FETCH_BOUND);
if ($creationDate) {
$content['title'] = JSON_decode($title);
$content['client'] = JSON_decode($client);
$content['creationDate'] = strftime("%F", strtotime($creationDate));
if ($dueDate !== NULL) {
$content['dueDate'] = strftime("%F", strtotime($dueDate));
} else {
$content['dueDate'] = '';
}
$content['scenes'] = JSON_decode($scenes);
if ($is_locked && $locked_by != $userid && time() < $lock_expires) {
$content['readonly'] = true;
} else {
$content['readonly'] = false;
try {
$sql = 'SELECT userid
FROM permissions
WHERE boardid = :boardid';
$stmt = $db->prepare($sql);
$stmt->bindValue(':boardid', $boardid);
$stmt->execute();
$stmt->bindColumn('userid', $userlist);
$errorInfo = $stmt->errorInfo();
if (isset($errorInfo[2])) {
$error = $errorInfo[2];
}
} catch (Exception $e) {
$error = $e->getMessage();
}
if (isset($error)) {
return [false, $error];
}
$stmt->fetch(PDO::FETCH_BOUND);
if ($userlist) {
$userarray = array();
do {
$userarray[] = $userlist;
} while ($stmt->fetch(PDO::FETCH_BOUND));
$usercount = count(array_count_values($userarray));
if ($usercount > 1) {
$this->is_shared = true;
} else {
$this->is_shared = false;
}
}
$this->lock_expires = time() + 5400;
try {
$sql = 'UPDATE storyboards
SET is_locked = 1, locked_by = :locked_by, lock_expires = :lock_expires
WHERE boardid = :boardid';
$stmt = $db->prepare($sql);
$stmt->bindValue(':locked_by', $userid);
$stmt->bindValue(':lock_expires', $this->lock_expires);
$stmt->bindValue(':boardid', $boardid);
$stmt->execute();
$errorInfo = $stmt->errorInfo();
if (isset($errorInfo[2])) {
$error = $errorInfo[2];
}
} catch (Exception $e) {
$error = $e->getMessage();
}
if (isset($error)) {
return [false, $error];
}
}
$this->modify($boardid, $content);
}
return [true];
}
/**
* Return the post data
*/
public function getPostData()
{
if (isset($_POST[$this->name])) {
$val = $_POST[$this->name];
$className = $this->getClass() ? $this->getClass() : 'stdClass';
$decoded = JSON_decode(stripslashes($val));
unset($items);
unset($obj_item);
$items = array();
foreach ($decoded as $std_object) {
$obj_item = new $className();
foreach ($std_object as $subkey => $value) {
//substitui pq o ttable gera com quebra de linha no multifield
//$obj_item->$subkey = URLdecode($value);
$obj_item->{$subkey} = str_replace("\n", '', URLdecode($value));
}
$items[] = $obj_item;
}
return $items;
} else {
return '';
}
}
// simplify the product record
$vod = JSON_decode($vod);
$vod = simplify($vod);
// console output
echo "<pre>";
print_r($vod);
echo "</pre>";
// store simplified record
$vod = JSON_encode($vod);
file_put_contents('cache/vod.json', $vod);
/* trends */
// fetch and store raw trends data
$trends = fetch('trends');
file_put_contents('cache/trends-raw.json', $trends);
// simplify product records
$records = JSON_decode($trends)->items;
$items = array();
foreach ($records as &$item) {
$items[] = simplify($item);
}
// store complete simplified trends records
file_put_contents('cache/trends.json', JSON_encode($items));
// tranche simplified trends records
$slice = array_slice($items, 0, 8);
// console output
echo "<pre>";
print_r($slice);
echo "</pre>";
// store simplifed trend record tranche
$slice = JSON_encode($slice);
file_put_contents('cache/trends-top.json', $slice);
/**
* Return the post data
*/
public function getPostData()
{
if (isset($_POST[$this->name])) {
$val = $_POST[$this->name];
$className = $this->getClass() ? $this->getClass() : 'stdClass';
$decoded = JSON_decode(stripslashes($val));
unset($items);
unset($obj_item);
$items = array();
if (is_array($decoded)) {
foreach ($decoded as $std_object) {
$obj_item = new $className();
foreach ($std_object as $subkey => $value) {
// substitui pq o ttable gera com quebra de linha no multifield
$obj_item->{$subkey} = str_replace("\n", '', URLdecode($value));
// verifica se é um json
if (is_array(json_decode($obj_item->{$subkey}))) {
$content = json_decode($obj_item->{$subkey});
$return = array();
foreach ($content as $position) {
$return[$position->{'id'}] = $position->{'text'};
}
$obj_item->{$subkey} = $return;
}
}
$items[] = $obj_item;
}
}
return $items;
} else {
return '';
}
}
}
}
}
//PART 2: NEW ANNOUNCEMENTS
//The maximum tweetid in the *announcements* table, grab everything newer than this via twitter api
$annoMaxId = 1024;
$resultset = mysql_query('SELECT max(tweetid) as maxid from ' . $appTableAnnouncements);
if (mysql_num_rows($resultset) > 0) {
$row = mysql_fetch_array($resultset, MYSQL_ASSOC);
$annoMaxId = $row['maxid'];
}
echo 'Announcements MAXID: ' . $annoMaxId . "\n";
//PART 2: Open the JSON file of the SPACES user timeline for reading
$tmhOAuth->request('GET', $tmhOAuth->url('1/statuses/user_timeline'), array('include_entities' => '0', 'include_rts' => '1', 'screen_name' => $twitterAccountName, 'count' => '20'));
//if ($data = file_get_contents_utf8("http://$twitterAccountName:$twitterAccountPass@api.twitter.com/1/statuses/user_timeline/$twitterAccountName.json?since_id=".$annoMaxId))
if ($tmhOAuth->response['code'] == 200) {
$announcements = JSON_decode($tmhOAuth->response['response'], true);
print_r($announcements);
foreach ($announcements as $tweetdata) {
$firstContestTag = hashtagFilter($tweetdata['text']);
if (!empty($firstContestTag)) {
$sql = 'REPLACE INTO ' . $appTableAnnouncements . ' (tweetid,content,SPChashtag) VALUES ("' . mysql_real_escape_string($tweetdata['id']) . '","' . mysql_real_escape_string(json_encode($tweetdata)) . "\",\"{$firstContestTag}\")";
mysql_query($sql);
#echo "$sql<br/><br/>!!".hashtagFilter($tweetdata['text']);
printf(mysql_error() . "Records inserted: %d\n", mysql_affected_rows());
}
}
}
?>
<?php
$modules = JSON_decode(file_get_contents('manifest.json'));
$payload = '';
foreach ($modules as $module) {
$payload .= "<!--------------------------------------------------------------------------\n" . " {$module}\n" . "--------------------------------------------------------------------------->\n" . file_get_contents($module) . "\n";
}
// main index
$index = file_get_contents('main.html');
// replace client-side load instruction with constructed payload
$index = str_replace('<link rel="import" href="imports.html">', $payload, $index);
echo $index;
$redirect_uri = $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF'];
// Load the Yakwala API library
$yakwala = new YakwalaAPI($client_key, $client_secret);
if (array_key_exists("code", $_GET)) {
// IDENTIFY USER
$response = $yakwala->GetToken($_GET['code'], $redirect_uri);
echo 'TOKEN' . $response->access_token;
$yakwala->SetAccessToken($response->access_token);
showUserBasics($response->user);
$userid = $response->user->id;
// POST a place
$params = array("place" => json_encode(array("title" => 'place title3', "content" => 'place content', "yakcat" => array('50923b9afa9a95d409000', '50923b9afa9a95d409000001'), "freetag" => array('tag11', 'tag22'), "outgoinglink" => 'http://www.theplacewebsite.com', "location" => array('lat' => 48.2, 'lng' => 2.3), "formatted_address" => " 3 rue du Ruisseau, Paris , France", "address" => array("street_number" => "3", "street" => "rue du Ruisseau", "arr" => "", "city" => "Paris", "state" => "Paris", "area" => "Ile de France", "country" => "France", "zip" => "75018"), "contact" => array("tel" => "0123456789", "mobile" => "0612345678", "mail" => "*****@*****.**", "transportation" => "metro 3 station Ruisseau", "web" => "http://www.theplace.com", "opening" => "Tlj de 8h à 20h", "closing" => "dimanches et jours fériés", "specialopening" => "Nocture le jeudi de 19h à minuit"))), "picture" => "@C:\\miro.jpg;type=image/jpeg");
$response = $yakwala->GetPrivate("api/place/" . $userid, $params, 'POST');
echo '<br>RESULT:<br>';
var_dump($response);
$theplace = JSON_decode($response)->place;
// POST an info ( in the user's feed )
$params = array("info" => json_encode(array("title" => 'info TOTO', "content" => 'info content', "yakcat" => array('50923b9afa9a95d409000', '50923b9afa9a95d409000001'), "yaktype" => 3, "print" => '1', "freetag" => array('tag11', 'tag22'), "placeid" => array('_id' => $theplace->_id))), "picture" => "@C:\\miro.jpg;type=image/jpeg");
$response = $yakwala->GetPrivate("api/user/feed/" . $userid, $params, 'POST');
$insert = $response;
echo '<br>RESULT:<br>';
var_dump($insert);
// POST an info ( in the user's feed )
$params = array("info" => json_encode(array("title" => 'info DODOD', "content" => 'info content', "yakcat" => array('50923b9afa9a95d409000', '50923b9afa9a95d409000001'), "yaktype" => 3, "print" => '1', "freetag" => array('tag11', 'tag22'), "location" => array('lat' => 48.3, 'lng' => 2.4), "address" => " 3 rue du Ruisseau, Paris , France")), "picture" => "@C:\\miro.jpg;type=image/jpeg");
$response = $yakwala->GetPrivate("api/user/feed/" . $userid, $params, 'POST');
$insert = $response;
echo '<br>RESULT:<br>';
var_dump($insert);
} else {
$authlink = $yakwala->AuthenticationLink($redirect_uri);
//echo $authlink;
<?php
header('Access-Control-Allow-Origin: http://game257530.konggames.com');
require 'db_connect.php';
$replays = [];
$s = "SELECT * FROM oa_best_race WHERE trackid=" . $_POST["map"] . " ORDER BY time";
if ($result = mysqli_query($link, $s)) {
$i = 0;
while ($row = mysqli_fetch_assoc($result)) {
if ($i < $_POST['max'] && $_POST['bests'] === 'true' && $row['userid'] !== $_POST['userid'] || $row['userid'] === $_POST['userid'] && $_POST['own'] === 'true') {
$topush = [$row['userid'], $row['userid']];
if ($_POST['replay'] === 'true') {
// wut
array_push($topush, JSON_decode($row["replay"]));
} else {
array_push($topush, $row['time']);
}
array_push($replays, $topush);
++$i;
}
}
}
for ($i = 0; $i < count($replays); ++$i) {
$s = "SELECT * FROM oa_users WHERE id=" . $replays[$i][0];
if ($result = mysqli_query($link, $s)) {
$done = false;
while ($row = mysqli_fetch_assoc($result)) {
if (!$done) {
$replays[$i][0] = $row["name"];
$done = true;
}
}
// Remote version
$content = @file_get_contents($version_url);
if ($content === false) {
die('Unable to download remote version');
}
$remote_version = JSON_decode($content);
// Version changed
if ($remote_version != $local_version) {
echo "Version change : {$local_version} -> {$remote_version} : \n";
file_put_contents($version_file, $content);
$content = @file_get_contents($changelog_url);
if ($content === false) {
die('Unable to download changelog');
}
$changelog = JSON_decode($content);
foreach ($changelog as $log) {
if (version_compare($log->version, $local_version, '>')) {
echo "{$local_version} -> {$log->version} ({$log->when}) : \n";
foreach ($log->changes as $change) {
echo " - {$change}\n";
}
if (property_exists($log, 'newSetFiles')) {
echo "New sets : " . join(', ', $log->newSetFiles) . "\n";
}
if (property_exists($log, 'updatedSetFiles')) {
echo "Updated sets : " . join(', ', $log->updatedSetFiles) . "\n";
}
$local_version = $log->version;
echo "\n";
}
function json_decode_loose($json)
{
$GLOBALS['json_strings'] = array();
#
# first find obvious strings
#
#echo "PRE-FIND: $json\n";
$json = preg_replace_callback('!"((?:[^\\\\"]|\\\\\\\\|\\\\")*)"!', 'json_dqs', $json);
$json = preg_replace_callback("!'((?:[^\\\\']|\\\\\\\\|\\\\')*)'!", 'json_sqs', $json);
#echo "POST-FIND: $json\n";
#print_r($GLOBALS['json_strings']);
$json = preg_replace('!\\s+!', '', $json);
#
# missing elements
#
$json = str_replace('[,', '[null,', $json);
$json = str_replace('{,', '{', $json);
$json = str_replace(',]', ']', $json);
$json = str_replace(',}', '}', $json);
$json = preg_replace('!\\[([^[{]+),(\\s*),!', '[$1,null,', $json);
$json = preg_replace('!\\{([^[{]+),(\\s*),!', '{$1,', $json);
#
# quote unquoted key names
#
$json = preg_replace_callback('!([a-zA-Z0-9-_]+):!', 'json_key', $json);
#
# turn remaning barewords into nulls.
# loosely based on the ECMA spec, but avoiding requiring unicode PCRE.
# http://www.ecma-international.org/publications/files/ECMA-ST/Ecma-262.pdf
# (section 7.6)
#
$start = "[A-Za-z\$_]|(\\\\u[0-9A-Fa-f]{4})";
$continue = $start . '|[0-9-.]';
$json = preg_replace_callback("!(({$start})({$continue})*)!", 'json_bareword', $json);
#
# strip functions
#
$l = strlen($json);
while (1) {
$json = preg_replace("!null\\(([^()]*)\\)!", 'null', $json);
$l2 = strlen($json);
if ($l == $l2) {
break;
}
$l = $l2;
}
#
# replace the strings
#
#echo "PRE-CONV: $json\n";
$pre = preg_quote($GLOBALS['json_str_prefix'], '!');
$json = preg_replace_callback('!' . $pre . '(\\d+)!', 'json_strs', $json);
#echo "POST-CONV: $json\n";
$ret = JSON_decode($json, true);
if ($ret === null) {
die("Failed to parse JSON:\n{$json}\n");
}
return $ret;
}
/**
* egy rekord olvasása id alapján, id='' esetén felvitelhez inicializált rekord
* @param string id
* @return record object kiegészitve a rooter filedel; ami a rooter php tartalma
*/
public function getItem($id)
{
$db = JFactory::getDBO();
$user = JFactory::getUser();
if ($id == '' | $id == 0) {
$result = new stdClass();
// felvitelhez inicializálás
$result->extension_id = 0;
$result->client_id = 1;
$result->enabled = 1;
$result->manifest_cache = new stdClass();
$result->manifest_cache->type = 'component';
$result->manifest_cache->name = 'new_component';
$result->manifest_cache->description = 'new component description';
$result->manifest_cache->author = $user->username . ' ' . $user->email;
$result->manifest_cache->copyRyght = '(c) ' . date('Y') . ')';
$result->manifest_cache->license = 'GNU';
$result->manifest_cache->version = 'V 1.00';
$result->rooter = $this->loadTemplate($result->manifest_cache, JPATH_COMPONENT . '/templates/rooter.php');
} else {
$db->setQuery('select *
from ' . $this->tableName . '
where ' . $this->tableId . '=' . $db->quote($id));
$result = $db->loadObject();
if ($db->setErrorNum() > 0) {
$result = false;
$this->setError($db->getErrorNum() . ' ' . $db->getErrorMsg());
}
$result->rooter = $this->loadRooter($result);
$result->manifest_cache = JSON_decode($result->manifest_cache);
}
// init vagy load?
return $result;
}
<?php
var_dump($_POST);
if (isset($_GET['logout'])) {
setcookie('authenticatedUserId', '', time() - 1000);
header('location: phpoefening-022-b.php');
}
$fileContent = file_get_contents('phpoefening-022-b.txt');
$userData = JSON_decode($fileContent, true);
$message = false;
$isAuthenticated = false;
if (isset($_POST['submit'])) {
foreach ($userData as $id => $user) {
if ($_POST['username'] == $user['username'] && $_POST['password'] == $user['password']) {
$cookieTime = isset($_POST['rememberMe']) ? time() + 60 * 60 * 24 * 30 : time() + 3600;
setcookie('authenticatedUserId', $id, $cookieTime);
header('location: phpoefening-022-b.php');
break;
}
}
$message = 'Er ging iets mis. Probeer opnieuw.';
}
if (isset($_COOKIE['authenticatedUserId'])) {
$userId = $_COOKIE['authenticatedUserId'];
$message = 'Welkom ' . $userData[$userId]['username'] . '. U bent ingelogd.';
$isAuthenticated = true;
}
?>
<!DOCTYPE html>
<html>
