} 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;
}
