$userid = $_SESSION['userid']; if (isset($_POST['favourite'])) { yasDB_delete("DELETE FROM favourite WHERE userid='{$userid}' AND gameid = '{$_POST['gamedelete']}'", false); } $result = yasDB_select("SELECT gameid FROM favourite WHERE userid='{$_SESSION['userid']}'", false); $numrows = $result->num_rows; $result->close(); if ($numrows == 0) { echo "<center><h3>You have no favorite games.</h3></center>"; } else { $pageurl = new pagination($numrows, $setting['seo'], 'favourites', $setting['gperpage'], 3); $query = yasDB_select("SELECT * FROM favourite WHERE userid= '{$userid}' LIMIT " . $pageurl->start . ", " . $pageurl->limit); while ($row = $query->fetch_array(MYSQLI_ASSOC)) { $games = yasDB_select("SELECT * FROM games WHERE id = '{$row['gameid']}'"); $games = $games->fetch_array(MYSQLI_ASSOC); $gameurl = prepGame($games['file']); $games['description'] = stripslashes($games['description']); if (strlen($games['description']) > 75) { $games['description'] = substr($games['description'], 0, 75) . "..."; } else { $games['description'] = $games['description']; } if ($setting['seo'] == 'yes') { $gurl = $setting['siteurl'] . 'game/' . $games['id'] . '/' . $gameurl . '.html'; } else { $gurl = $setting['siteurl'] . 'index.php?act=game&id=' . $games['id']; } if (file_exists($setting['sitepath'] . '/' . $games['thumbnail'])) { $thumbnail = $setting['siteurl'] . $games['thumbnail']; $thumbnail = urldecode($thumbnail); } else {
function get_mgffeed() { global $mysqli; error_reporting(E_ALL ^ E_NOTICE); @ini_set("max_execution_time", 600); @ini_set("default_socket_timeout", 240); // create array of game tags for duplicate checking $query = yasDB_select("SELECT `uid` FROM `mgffeed`", false); $tags = array(); $i = 0; while ($alltags = $query->fetch_array(MYSQLI_ASSOC)) { $tags[$i] = $alltags['uid']; $i++; } unset($alltags); $query->close(); // This is the MGF feed url. For more info go here: http://www.mochigamefeed.com/feed.php $feedUrl = 'http://mochigamefeed.com/updatedfeed.php'; $data = get_content_of_url($feedUrl); $json_data = json_decode($data, true); unset($data); $json_count = count($json_data); //$cat_array = array("puzzle", "action", "adventure", "sports", "shooter", "casino", "other", "girls", "education", "strategy", "jigsaw", "coloring", "driving", "fighting", "rhythm", "board game", "customize"); $cat_array = array("puzzle", "action", "adventure", "sports", "shooter", "casino", "other", "dressup", "arcade", "strategy", "cartoon", "coloring"); foreach ($json_data as $json) { if ($json['title'] == NULL) { break; } if (!in_array($json['id'], $tags)) { $cat = strtolower(yasDB_clean($json['category'])); if (in_array($cat, $cat_array)) { $category = array_search($cat, $cat_array) + 1; } else { $category = 7; // if not found set category to other } $title = yasDB_clean($json['title']); $uid = intval($json['id']); $game_file = yasDB_clean($json['file']); $game_url = "http://www.mochigamefeed.com/view/" . intval($json['id']) . "/" . prepGame($title) . ".html"; $width = intval($json['width']); $height = intval($json['height']); $description = yasDB_clean($json['description']); $instructions = yasDB_clean($json['instructions']); $small_thumburl = yasDB_clean($json['thumbnail']); $medium_thumburl = yasDB_clean($json['medthumb']); $large_thumburl = yasDB_clean($json['lgthumb']); $screen1 = yasDB_clean($json['screen1']); $screen1 = yasDB_clean($json['screen2']); $zip = yasDB_clean($json['zip']); $controls = yasDB_clean(stripslashes($json['controls'])); $created = yasDB_clean($json['installdate']); $review = yasDB_clean($json['review']); $rating = yasDB_clean($json['rating']); $ads = yasDB_clean($json['ads']); $hsapi = yasDB_clean($json['hsapi']); $keywords = yasDB_clean($json['keywords']); $sql = "INSERT INTO mgffeed (`id`, `uid`, `title`, `controls`, `installdate`, `game_url`, `description`, `instructions`, `category`, `thumbnail`, `medthumb`, `lgthumb`, `file`, `zip`, `screen1`, `screen2`, `width`, `height`, `review`, `rating`, `ads`, `hsapi`, `keywords`,`installed`, `hidden`)\n VALUES (NULL, {$uid}, '{$title}', '{$controls}', '{$created}', '{$game_url}', '{$description}', '{$instructions}', {$category}, '{$small_thumburl}', '{$medium_thumburl}', '{$large_thumburl}', '{$game_file}', '{$zip}', '{$screen1}', '{$screen2}', {$width}, {$height}, '{$review}', '{$rating}', '{$ads}', '{$hsapi}', '{$keywords}', '0', '0')"; $return = yasDB_insert($sql, false); if (!$return) { break; } // if there is a db insert error just keep going. } } unset($json); unset($json_data); return true; }
<div id="center"> <div class="container_box1"> <div class="header">Search Results for <?php echo $q; ?> </div> <?php if (!ctype_digit($q)) { $query = yasDB_select("SELECT * FROM games WHERE title LIKE '%{$q}%' OR description LIKE '%{$q}%' ORDER BY (CASE WHEN title LIKE '%{$q}%' THEN 1 ELSE 0 END) DESC limit 20", false); } if ($query->num_rows == '0') { echo '<div id="text_box">No results!</div>'; echo ""; } while ($games = $query->fetch_array(MYSQLI_ASSOC)) { $gameurl = prepGame($games['title']); $games['description'] = substr($games['description'], 0, 140) . '...'; $games['description'] = stripslashes($games['description']); $description = str_replace(array("\r\n", "\r", "\n", "'", '"'), ' ', $games['description']); if (strlen($games['title']) > 19) { $games['title'] = substr($games['title'], 0, 16) . '...'; } else { $games['title'] = $games['title']; } if (file_exists($games['thumbnail'])) { $thumbnail = $games['thumbnail']; $thumbnail = urldecode($thumbnail); } else { $thumbnail = $setting['siteurl'] . 'templates/' . $setting['theme'] . '/skins/' . $setting['skin'] . '/images/nopic.jpg'; } $pic_settings = array('w' => 130, 'h' => 100);