function getMenu() { if (!isset($_SESSION['user_id'])) { $getMenu = select_from_db(array('id,name'), array('menus'), array('id = 1')); } else { $getMenu = select_from_db(array('id,name'), array('menus'), array('id = 2')); } $results = select_from_db(array('id,parent_id,label,link,level'), array('menu_items'), array('menu_id = ' . $getMenu[0]['id']), "", "id"); $menuName = $getMenu[0]["name"]; $menuSelections = getMenuSelection($results, "0", "-1"); if (!empty($menuSelections)) { $menu = '{"' . $menuName . '":[' . $menuSelections . '] }'; } echo $menu; }
function createEvent($params) { $event_name = $params['eventName']; $user_id = $_SESSION['user_id']; $event_info = select_from_db(array('name'), array('events'), array("name='{$event_name}'")); if (isset($event_info[0]['name'])) { echo '{"added":"none"}'; } else { $membershipRules = $params['membershipRules']; // $groupId = isset($params['groupId'])?$params['groupId']:'0'; $event_id = insert_to_db(array('access' => $membershipRules, 'name' => $event_name), 'events'); insert_to_db(array('user_id' => $user_id, 'event_id' => $event_id), 'user__has__event'); echo '{"added":"event"}'; } }
function getAllPublicGroupsExeptTheOnesUserHas($params) { $events = select_from_db(array('name,id'), array('events, user__has__event'), array("events.id = user__has__event.event_id AND user__has__event.user_id = 1"), "", "name"); echo json_encode($events); }
function select_id_name_where_parent_mediatype($parent, $mediatype) { return select_from_db(array('id', 'name'), array('parent' => $parent, 'mediatype' => $mediatype)); }
function login($values) { $email = $values['email']['value']; $password = $values['password']['value']; if ($email && $password) { $userinfo = select_from_db(array('password', 'id'), array('users'), array("email='{$email}'")); //hämtar hem användaruppgifter från angiven email if ($password == $userinfo[0]['password']) { //Kontrollerar om lösenordet stämmer $_SESSION['user_id'] = $userinfo[0]['id']; //Sätter anändarid i en session $_SESSION['user_name'] = $email; header('Location: ../index.php'); } else { header('Location: ../index.php?msg=1'); //Användarnamnet och lösenordet stämmer inte överens } } else { header('Location: ../index.php?msg=2'); //Inget användarnamn eller lösenord angvet } }
function get_users_in_game_but_not_in_this_chat($params) { $game_id = $params['game_id']; $chat_room_id = $params['chat_room_id']; $user_id = $_SESSION['user_id']; $result = select_from_db(array('alias,users.id'), array('users,users__got__games'), array("users__got__games.game_id = {$game_id} AND \n\t\t\t\t\t\t\tusers__got__games.user_id = users.id AND users.id NOT IN (\n\t\t\t\t\t\t\tSELECT users.id FROM users,chat_rooms__got__users\n\t\t\t\t\t\t\tWHERE chat_rooms__got__users.chat_room_id = {$chat_room_id} AND\n\t\t\t\t\t\t\tchat_rooms__got__users.user_id = users.id )")); echo json_encode($result); }
function get_category($categori_id) { $category_selection = "<select name='category' id='category'>"; $categorys = select_from_db(array('id', 'category'), array('categories')); foreach ($categorys as $categori) { $category_selection = $category_selection . "<option value='" . $categori['id'] . "'"; if ($categori['id'] == $categori_id) { $category_selection = $category_selection . "selected"; } $category_selection = $category_selection . ">" . $categori['category'] . "</option>"; } $category_selection = $category_selection . "</select>"; return $category_selection; }
function login($values) { $email = $values['email']['value']; $password = $values['password']['value']; if ($email && $password) { $userinfo = select_from_db(array('password', 'id'), array('users'), array("email='{$email}'")); //hämtar hem användaruppgifter från angiven email $blogs = select_from_db(array('blogs.id', 'blogs.name', 'users__has__blogs.accesslevel'), array('blogs', 'users__has__blogs'), array('users__has__blogs.blogs_id = blogs.id', 'users__has__blogs.users_id =' . $userinfo[0]['id'])); //print_r(blogs); if ($password == $userinfo[0]['password']) { //Kontrollerar om lösenordet stämmer $_SESSION['user_id'] = $userinfo[0]['id']; //Sätter anändarid i en session $_SESSION['user_name'] = $email; $_SESSION['blog_list'] = serialize($blogs); header('Location: ../index.php'); } else { header('Location: ../index.php?msg=1'); //Användarnamnet och lösenordet stämmer inte överens } } else { header('Location: ../index.php?msg=2'); //Inget användarnamn eller lösenord angvet } }