<?php include "databaseName.php"; $con = connect($address, $username, $password, $database); if (isset($_POST['MatchNumber']) && isset($_POST['TeamNumber'])) { $postKeys = array_keys($_POST); fillPosts($posts); sendAll($postKeys, $posts, $con); print "Submission received!<br><br> <a href='http://xbotsrobotics.com/Scouting'> Click here to return to the scouting page.</a>"; } else { //display graphical data here } disconnect($con); function sendAll($keys, $values) { $keyString = ''; $valString = ''; for ($i = 0; $i < sizeof($keys); $i++) { $keyString .= $keys[$i]; $valString .= "'" . $values[$i] . "'"; if ($i + 1 < sizeof($keys)) { $keyString .= ','; $valString .= ','; } } sendQuery($keyString, $valString); } function sendQuery($column, $value) { $insert_query = "INSERT INTO MatchDatabase ({$column}) VALUES ({$value});"; mysql_query($insert_query);
function apply_ws_query($connect, $sess_id, $q) { if ($sess_id != '0' and $GLOBALS['sess_data'][$sess_id]['online'] < time()) { $GLOBALS['sess_data'][$sess_id]['online'] = time() + 120; } switch ($q[0]) { case 'sid': return array('type' => 'sid', 'answer' => $sess_id); break; case "uniqid": return array('type' => 'uniqid', 'answer' => uniqid()); case 'test': return array('answer' => '1'); break; case 'teleport': $GLOBALS['sess_data'][$sess_id]['x'] = $q[1]; $GLOBALS['sess_data'][$sess_id]['y'] = $q[2]; $GLOBALS['sess_data'][$sess_id]['dir'] = $q[3]; sendAll(array('type' => 'teleport', 'char' => $GLOBALS['sess_data'][$sess_id]['cid'], 'x' => $q[1], 'y' => $q[2], 'dir' => $q[3])); return array('type' => 'default', 'answer' => '1'); break; case 'clientjs': return array('type' => 'clientjs', 'answer' => rpgjs_getcmd($q[1])); break; case 'getposition': if (!isset($GLOBALS['sess_data'][$sess_id]['x']) or !isset($GLOBALS['sess_data'][$sess_id]['y']) or !isset($GLOBALS['sess_data'][$sess_id]['dir'])) { $GLOBALS['sess_data'][$sess_id]['x'] = char($GLOBALS['sess_data'][$sess_id]['cid'])->pos_x; $GLOBALS['sess_data'][$sess_id]['y'] = char($GLOBALS['sess_data'][$sess_id]['cid'])->pos_y; $GLOBALS['sess_data'][$sess_id]['dir'] = char($GLOBALS['sess_data'][$sess_id]['cid'])->dir; $GLOBALS['sess_data'][$sess_id]['loc'] = char($GLOBALS['sess_data'][$sess_id]['cid'])->map; } return array('type' => 'getposition', 'x' => $GLOBALS['sess_data'][$sess_id]['x'], 'y' => $GLOBALS['sess_data'][$sess_id]['y'], 'loc' => $GLOBALS['sess_data'][$sess_id]['map'], 'dir' => $GLOBALS['sess_data'][$sess_id]['dir']); break; case 'online': $array = array('type' => 'online'); foreach ($GLOBALS['sess_data'] as $key => $value) { if ($value['online'] < time()) { continue; } $array[$value['_id']]['id'] = $value['_id']; $array[$value['_id']]['x'] = $value['x']; $array[$value['_id']]['y'] = $value['y']; $array[$value['_id']]['dir'] = $value['dir']; $array[$value['_id']]['name'] = $value['name']; $array[$value['_id']]['online'] = $value['online']; $array[$value['_id']]['map'] = $value['map']; $array[$value['_id']]['skin'] = $value['skin']; } return $array; break; case 'events': return array('type' => 'events', 'answer' => implode(" ", array_values(check_player_events($GLOBALS['sess_data'][$sess_id]['cid'], true, true)['js']))); break; case 'mapchars': $array = array('type' => 'mapchars'); foreach ($GLOBALS['sess_data'] as $key => $value) { if ($value['map'] != $q[1] or $GLOBALS['sess_data'][$sess_id]['cid'] == $value['_id']) { continue; } $array[$value['_id']]['id'] = $value['_id']; $array[$value['_id']]['x'] = $value['x']; $array[$value['_id']]['y'] = $value['y']; $array[$value['_id']]['dir'] = $value['dir']; $array[$value['_id']]['name'] = $value['name']; $array[$value['_id']]['online'] = $value['online']; $array[$value['_id']]['map'] = $value['map']; $array[$value['_id']]['skin'] = $value['skin']; } return $array; break; case 'exists': return array('type' => 'default', 'error' => 'Deprecated method. Use API.'); break; default: return array('type' => 'default', 'error' => 'Bad query ID (' . $q[0] . ')'); break; } }