<?php
/*
handles all ajax requests
WARNING: COULD BE VERY INSECURE. USE FOR TESTING ONLY
@author kamasheto
*/
include 'functions.php';
include 'logic.php';
// connect to db and like, yeah
mysql_connect('localhost', 'root', '');
mysql_select_db('el7a2ony');
$in = clean($_REQUEST);
// get all request vars (_POST and _GET combined)
switch ($in['action']) {
case 'quickreport':
quickreport($in['lat'], $in['lng']);
break;
case 'requests':
get_requests($in['lat'], $in['lng']);
break;
}
/*
* This is the page that displays the request to the end user after being created.
*/
include(SERVER_ROOT.'/classes/class_text.php');
$Text = new TEXT;
if(empty($_GET['id']) || !is_number($_GET['id'])) {
error(0);
}
$RequestID = $_GET['id'];
//First things first, lets get the data for the request.
$Request = get_requests(array($RequestID));
$Request = $Request['matches'][$RequestID];
if(empty($Request)) {
error(404);
}
list($RequestID, $RequestorID, $RequestorName, $TimeAdded, $LastVote, $CategoryID, $Title, $Year, $Image, $Description, $CatalogueNumber, $ReleaseType,
$BitrateList, $FormatList, $MediaList, $LogCue, $FillerID, $FillerName, $TorrentID, $TimeFilled) = $Request;
//Convenience variables
$IsFilled = !empty($TorrentID);
$CanVote = (empty($TorrentID) && check_perms('site_vote'));
if($CategoryID == 0) {
$CategoryName = "Unknown";
} else {
include "../../include/header.php";
?>
<div class="BasicsBox">
<h1><?php
echo $lang["managerequestsorders"];
?>
</h1>
<p><?php
echo text("introtext");
?>
</p>
<?php
$requests = get_requests();
# pager
$per_page = 20;
$results = count($requests);
$totalpages = ceil($results / $per_page);
$curpage = floor($offset / $per_page) + 1;
$url = "team_request.php?";
$jumpcount = 1;
?>
<div class="TopInpageNav"><?php
pager();
?>
</div>
<div class="Listview">
<table border="0" cellspacing="0" cellpadding="0" class="ListviewStyle">
# Get a list of games to pull
$results = run_sql($db, $sql);
// Loop through the results
while ($row = db_fetch_assoc($results[0])) {
// Set URL
$url = $url_root . $api_accesscode . $row['apikey'] . $api_key . $row['apikey'] . $start . $end;
$urls[] = array('game_id' => $row['game_id'], 'client_id' => $row['device_id'], 'ref_name' => $row['ref_name'], 'url' => $url);
note("Curl URL for Game: " . $row['game_id'] . ", Client: " . $row['device_id'] . " is:\n{$url}.");
}
mysqli_free_result($results[0]);
mysqli_close($db);
$count = 1;
$n_urls = count($urls);
// Loop through the games making requests for data
while ($n_urls > count($reports) && $count < 100) {
get_requests($urls, $reporsts);
// Only sleep if we have not finished.
if ($n_urls > count($reports)) {
\get_reports($reports, $files);
note("Waiting five minutes for reports. Count={$count}.");
sleep(300);
$count++;
}
}
note("Got reports for all games as follows:");
print_r($reports);
if ($count == 100) {
die("ERROR: " . date("Y-m-d H:i:s") . ": Could not get a valid reports for {$start_date} to {$end_date}.\n");
}
$count = 0;
$n_reports = count($reports);
break;
}
if ($result == 'self') {
echo 'self';
break;
}
echo $result;
break;
case 'send_friend_request':
echo send_request();
break;
case 'get_friend_req_result':
echo get_friends_req_result();
break;
case 'get_requests':
echo get_requests();
break;
case 'accept_ignore_request':
$friend_user_name = $_POST['username'];
$note_id = $_POST['note_id'];
if (isset($_POST['ignore']) && ($ignore = 'ignore')) {
echo accept_ignore_request($friend_user_name, $note_id, $ignore);
break;
}
echo accept_ignore_request($friend_user_name, $note_id);
break;
case 'get_all_friends':
echo get_all_friends();
break;
case 'delete_friend':
$friend_user_name = $_POST['username'];
<br>
<?php
}
?>
<table border="0" class="trans" width="100%" cellspacing="2" cellpadding="2">
<tr>
<td valign="top">
<span style="font-size:15px;font-weight:bold;color:#1E7BBB ;"><?php
echo $lang['players_for_fight'];
?>
</span><br/>
<br>
<?php
$req = get_requests($user['id']);
$query = mysql_query("SELECT * FROM users WHERE id NOT IN ({$req}) ORDER BY RAND() LIMIT 24");
if (mysql_num_rows($query) > 0) {
while ($row = mysql_fetch_array($query)) {
if ($row['avatar']) {
$avatar = $row['avatar'];
} else {
$avatar = 'assets/imgs/avatar.jpg';
}
$act = "'{$row['id']}'";
echo '<div id="player" class="player_' . $row[id] . '"><a href="javascript:void(0);" onclick="send_request(' . $act . ')"><img src="' . $avatar . '" width="20px"> ' . $row[usern] . '</a></div>';
}
} else {
echo error($lang['no_players_for_fight']);
}
?>
<div class="container theme-showcase" role="main">
<br />
<br>
<div class="page-header">
<h1 style="font-weight: 200">New Customer Requests</h1>
</div>
<!-- end -->
<div class="row">
<div class="col-md-8">
<?php
$arr = array("1.jpg", "2.jpg", "3.jpg", "4.jpg", "5.jpg");
$i = 0;
$sql = get_requests();
while (($data = $database->fetchAssoc()) != null) {
echo '
<span class="title" style="float:left;width:30%;height:50%;padding:5px; margin-bottom: 20px; margin-right: 10px;font-weight: 200;">
<span style="color:#337ab7"><b>@' . $data['user'] . '<b></span>
<br><span style="width:100%"><img src="img/' . $arr[$i] . '" alt="Smiley face" height="180px" width="220px"></span><br><br><code>' . $data['name'] . '</code> <span style="float:right;font-weight: 200;"> <i class="fa fa-inr"></i>' . $data['proposedPrice'] . '</span><br><code>' . $data['cuisine'] . ' / ' . $data['category'] . ' / ' . $data['spiceLevel'] . '</code> ';
for ($k = 0; $k < $data['spiceLevel']; $k++) {
echo '<img src="./img/chilli.png" style="width:10px; height: 10px;"/>';
}
echo '
<br><a href="requests.php?id=' . $data['id'] . '&p_id=' . $arr[$i] . '">View Request</a>
<br><br>
</span>
';
$i++;
}
//print($Way); print($OrderBy); die();
$SS->SetSortMode($Way, $OrderBy);
if(count($Queries) > 0) {
$Query = implode(' ',$Queries);
} else {
$Query='';
}
$SS->set_index('requests requests_delta');
$SphinxResults = $SS->search($Query, '', 0, array(), '', '');
$NumResults = $SS->TotalResults;
//We don't use sphinxapi's default cache searcher, we use our own functions
if(!empty($SphinxResults['notfound'])) {
$SQLResults = get_requests($SphinxResults['notfound']);
if(is_array($SQLResults['notfound'])) {
//Something wasn't found in the db, remove it from results
reset($SQLResults['notfound']);
foreach($SQLResults['notfound'] as $ID) {
unset($SQLResults['matches'][$ID]);
unset($SphinxResults['matches'][$ID]);
}
}
// Merge SQL results with memcached results
foreach($SQLResults['matches'] as $ID => $SQLResult) {
$SphinxResults['matches'][$ID] = $SQLResult;
//$Requests['matches'][$ID] = array_merge($Requests['matches'][$ID], $SQLResult);
//We ksort because depending on the filter modes, we're given our data in an unpredictable order
table{
position: relative;
top: -150px;
}
table td{
padding: 5px;
}
</style>
</head>
<body>
<div id="mydiv">
<?php
include_once './includes/init.php';
$sql = get_requests($_GET['id']);
while (($data = $database->fetchAssoc()) != null) {
echo '
<div>
<h1><b>@' . $data['user'] . '</b></h1><br>
<div width="100%" style="height: 300px;background-image:url(./img/' . $_GET['p_id'] . ');background-repeat:no-repeat; background-size:cover ;"></div>
</div>
<table>
<tr><td><b>Dish:</b></td><td> <code>' . $data['name'] . '</code></td></tr>
<br>
<tr><td><b>Cuisine:</b></td><td> <code>' . $data['cuisine'] . '</code></td></tr>
<br>
<tr><td><b>Category:</b></td><td> <code>' . $data['category'] . '</code></td></tr>
<br>
<tr><td><b>Spice Level:</b></td><td>';
for ($k = 0; $k < $data['spiceLevel']; $k++) {
