} else { $reg = pg_fetch_assoc($result); $json['suc'] = 'oikea'; $json['idu'] = $reg['id']; $json['sdu'] = $contra; } } else { $json['suc'] = 'väärä parametri'; } } elseif (isset($_REQUEST['tg']) && $_REQUEST['tg'] != "" && isset($_REQUEST['id']) && $_REQUEST['id'] != "" && isset($_REQUEST['sd']) && $_REQUEST['sd'] != "") { if ($_REQUEST['tg'] == 'yhteys') { // Verifica contraseñas $sql = "SELECT count(*) FROM log_visitas WHERE id = " . $_REQUEST["id"] . " AND sd = MD5('" . $_REQUEST["sd"] . "');"; $result = pg_query($dbconn, $sql); $reg = pg_fetch_assoc($result); if (!$reg['count']) { $json['suc'] = 'virhe'; exit; } else { $sql = "INSERT INTO log_uso(idu, ip, nav) VALUES (" . $_REQUEST['id'] . ", '" . get_user_ip_address() . "', '" . $_SERVER['HTTP_USER_AGENT'] . "');"; $result = pg_query($dbconn, $sql); $json['suc'] = 'oikea'; } } else { $json['suc'] = 'väärä parametri'; } } else { $json['suc'] = 'puuttuvat parametrit'; } $json = json_encode($json); echo $callback ? "{$callback}({$json})" : $json;
}); // Customer requests service // // A) Create a help session // Request: (URL encoded) // Response: (JSON encoded) // * `apiKey`: OpenTok API Key // * `sessionId`: OpenTok session ID // * `token`: User's token for the `sessionId` $app->post('/help/session', function () use($app, $con, $opentok, $config) { $session = $opentok->createSession(); $responseData = array('apiKey' => $config->opentok('key'), 'sessionId' => $session->getSessionId(), 'token' => $session->generateToken()); $campaignId = $app->request->params('campaignId'); $bannerId = $app->request->params('bannerId'); $userAgent = $app->request->params('userAgent'); $userIpAddress = get_user_ip_address(); $country = get_user_country($userIpAddress); // Save the help session details $query = sprintf("INSERT INTO Sessions (SessionId, CampaignId, BannerId, UserAgent, UserIpAddress, UserCountry) VALUES ('%s', '%s', '%s', '%s', '%s', '%s');", mysqli_real_escape_string($con, $session->getSessionId()), mysqli_real_escape_string($con, $campaignId), mysqli_real_escape_string($con, $bannerId), mysqli_real_escape_string($con, $userAgent), mysqli_real_escape_string($con, $userIpAddress), mysqli_real_escape_string($con, $country)); $result = sendQuery($query); // Handle errors if (!handleMySqlError($result, $app, 'Could not create the help session.')) { return; } $app->response->headers->set('Content-Type', 'application/json'); $app->response->setBody(json_encode($responseData)); }); // B) Enqueue in service queue // Request: (URL encoded) // * `session_id`: The session which is ready to be enqueued $app->post('/help/queue', function () use($app, $con) {
<?php include "conectadb.php"; include "ip-addresses.php"; if (isset($_POST['i']) && $_POST["i"] != "" && isset($_POST['s']) && $_POST["s"] != "") { $sql = "SELECT count(*) FROM log_visitas WHERE id = " . $_POST["i"] . " AND sd = MD5('" . $_POST["s"] . "');"; $result = pg_query($dbconn, $sql); $reg = pg_fetch_assoc($result); if (!$reg['count']) { exit; } } else { exit; } $sql = "INSERT INTO dom (dnt, mun, loc, snt, cp, vld, num, ntr, ref1, ref2, ref3, ref4, lat, lon, ip, idu) VALUES ('" . $_POST["id"] . "', " . $_POST["mun"] . ", " . $_POST["loc"] . ", " . $_POST["snt"] . ", " . $_POST["cp"] . ", " . $_POST["vld"] . ", '" . $_POST["num"] . "', '" . $_POST["int"] . "', " . $_POST["ref1"] . ", " . $_POST["ref2"] . ", " . $_POST["ref3"] . ", '" . $_POST["ref4"] . "', " . $_POST["cx"] . ", " . $_POST["cy"] . ", '" . get_user_ip_address(TRUE) . "', " . $_POST["i"] . ");"; $sql = str_replace(" ,", " NULL,", $sql); $sql = str_replace("''", "NULL", $sql); $result = pg_query($dbconn, $sql);
<?php /** * Created by Naveed-ul-Hassan Malik * Date: 6/17/2015 * Time: 11:37 AM */ $allowedIPs = ['101.50.98.115']; $userIp = get_user_ip_address(); if (!in_array($userIp, $allowedIPs)) { ChromePhp::log($userIp); echo "<h3>Under Development....</h3>"; echo "<p><a href='http://www.dynamologic.com'>Dynamologic Solutions</a><p>"; exit; }