public function resolve($sessionId, $urn) { mysqlConnect(USER, PASS, TABLE, HOST); // connecting mysql $urls = array(); // initialise the urls array to be returned // wildcard parsing //TODO: if there is more than one *, this doesnt work anymore, but first we have to know how the possible wildcard could be. To know the wildcard design, we should take contact with Silvan (BitFlux) $wildcard = explode("*", $urn); // make array with hashed values, separator: * $substring = $wildcard[0]; // take everything before the * in the urn string $query = "SELECT path FROM urn WHERE urn LIKE '" . $substring . "%'"; // building query string $result = mysql_query($query); // execute mysql query $rows = mysql_num_rows($result); // count the number of results if ($rows == 0) { $urls[] = "URN not found!"; // put error message into urls array witch is returned } else { while ($row = mysql_fetch_row($result)) { $urls[] = $row[0]; // push the paths into the urls array } } mysql_close(); // close mysql connection return $urls; }
public function resolve($sessionId, $urn) { mysqlConnect(USER, PASS, TABLE, HOST); // connecting mysql $urls = array(); // initialise the urls array to be returned // wildcard $wildcard = str_replace("*", "%", $urn); // remplace the * with % and make it compatible for the mysql query $query = "SELECT path FROM urn WHERE urn LIKE '" . $wildcard . "%'"; // building query string $result = mysql_query($query); // execute mysql query $rows = mysql_num_rows($result); // count the number of results if ($rows == 0) { $urls[] = "URN not found!"; // put error message into urls array witch is returned } else { while ($row = mysql_fetch_row($result)) { $urls[] = $row[0]; // push the paths into the urls array } } mysql_close(); // close mysql connection return $urls; }
function dbConnect($srcName) { global $DBProvider; if (isset($DBProvider)&&($DBProvider=='mysql')) { return mysqlConnect($srcName); } else { return sqliteConnect($srcName); } }
function getDptInfo() { $sql = "SELECT * FROM dpt"; $result = mysqli_query(mysqlConnect(), $sql); $mainHTML .= "<ul>"; while ($row = mysqli_fetch_array($result)) { $mainHTML .= "<li class='menu_titles'><a href='?option=viewDept&dpt=" . $row['dpt_name'] . "' class='menuTitles'>" . $row['dpt_name'] . "</a>"; $sql1 = "SELECT * FROM cats WHERE cat_dpt_id = '" . $row['dpt_id'] . "'"; $result1 = mysqli_query(mysqlConnect(), $sql1); if ($result1) { $mainHTML .= "<ul class='subMenu'>"; while ($row1 = mysqli_fetch_array($result1)) { $mainHTML .= "<li><a href='#'>" . $row1['cat_name'] . "</a></li>"; } $mainHTML .= "</ul>"; } $mainHTML .= "</li>"; } $mainHTML .= "</ul>"; return $mainHTML; }
function ae_nocache() { header("Expires: Tue, 03 Jul 2001 06:00:00 GMT"); header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); header("Cache-Control: no-store, no-cache, must-revalidate, max-age=0"); header("Cache-Control: post-check=0, pre-check=0", false); header("Pragma: no-cache"); } ae_nocache(); session_start(); ini_set('display_errors', 1); $USERLOGGEDIN = false; $BODY = "<div id=innercontent>"; require_once "mysql.inc.php"; require_once "auth.lib.php"; mysqlConnect(); if (checkSessionAuth() == true) { $USERLOGGEDIN = true; } if (!isset($_GET['page'])) { $page = "home"; } else { $page = $_GET['page']; if ($page == "") { $page = "home"; } } if ($page == "login") { require_once "ui/login.lib.php"; checkLogin($USERLOGGEDIN); if ($USERLOGGEDIN == true) {
} return $mysqli; } // Check trade configuration if (!(isset($TRADE['trade_pair']) && isset($TRADE['trade_wait']) && isset($TRADE['trade_stop_loss']) && isset($TRADE['trade_sma_short']) && isset($TRADE['trade_sma_long']) && isset($TRADE['trade_threshold']))) { die("Not all configuration options are present"); } // Enter trade loop $simulation = isset($argv[2]) && $argv[2] === 'real' ? false : true; $tradeLog = './logs/' . $profile . '.log'; $bought = 0; $buy_price = 0; $trailing_stop_margin = 0; while (true) { if (!$mysqli) { $mysqli = mysqlConnect($CONFIG); } // Get ticker status for trading pair $ticker = getTicker($TRADE['trade_pair']); if ($ticker === false) { sleep($TRADE['trade_wait']); continue; } // Get balance for trading pair from db list($currency1, $currency2) = explode('_', $TRADE['trade_pair']); $balance = $mysqli->query("SELECT * FROM balance LIMIT 1")->fetch_assoc(); $accountValue = $balance[$currency1] * $ticker['sell'] + $balance[$currency2]; // Calculate average/threshold/etc $SmaShort = floatval($mysqli->query("SELECT AVG(x." . $TRADE['trade_pair'] . ") FROM (SELECT " . $TRADE['trade_pair'] . " FROM ticker ORDER BY id DESC LIMIT " . $TRADE['trade_sma_short'] . ") x")->fetch_array()[0]); $SmaLong = floatval($mysqli->query("SELECT AVG(x." . $TRADE['trade_pair'] . ") FROM (SELECT " . $TRADE['trade_pair'] . " FROM ticker ORDER BY id DESC LIMIT " . $TRADE['trade_sma_long'] . ") x")->fetch_array()[0]); $SmaDiff = 100 * ($SmaShort - $SmaLong) / (($SmaShort + $SmaLong) / 2);
$db = mysqlConnect(''); $query = "UPDATE ".$datasource['Table']." SET ".$IN['UpdateField']."='".md5(htmlentities($IN['UpdateValue'],ENT_QUOTES,'UTF-8'))."' WHERE ".$datasource['PK'].'='.$IN[$datasource['PK']]; $result = mysql_query($query,$db) or trigger_error("MySQL Datasource($dsname) Query Error:".mysql_error($db)); print '{"Status":"Updated","Id":"'.$IN[$datasource['PK']].'"}'; fb($query,FIREPHP::INFO); break; case "Delete": $db = mysqlConnect(''); if (isset($IN['Id'])) { $query = "DELETE FROM ".$datasource['Table']." WHERE ".$datasource['PK'].'='.$IN['Id']; $result = mysql_query($query,$db) or trigger_error("MySQL Datasource($dsname) Query Error:".mysql_error($db)); print '{"Status":"Deleted","Id":"'.$IN['Id'].'"}'; fb($query,FIREPHP::INFO); } else { trigger_error('PK not found.'); } break; case "CascadeDelete": $db = mysqlConnect(''); $query = $datasource['CascadeSQL']; $result = mysql_query($query,$db) or trigger_error("MySQL Datasource($dsname) Query Error:".mysql_error($db)); print '{"Status":"Deleted"}'; fb($query,FIREPHP::INFO); break; } break; } } else { print "alert('Gateway Error:Unknown Datasource (".$IN['datasource'].")');"; }
<?php /* require_once('../../include/connect.php'); $mysqli = mysqlConnect(); */ require_once '../../include/connect.php'; $mysqli = mysqlConnect(); $id = $_POST['id']; $status = $mysqli->escape_string($_POST['status']); $placed = $mysqli->escape_string($_POST['placed']); $dispatched = $mysqli->escape_string($_POST['dispatched']); $placed = date($placed); $dispatched = date($dispatched); $sqlupdate = "UPDATE `Order` SET date_placed='{$placed}', date_dispatched='{$dispatched}', status='{$status}' WHERE id='{$id}'"; $mysqli->query($sqlupdate); header('Location: orders.php');
<?php require "function.php"; $con = mysqlConnect('localhost', 'root', '123qwe', 'stock'); $sql = "select * from price where code = '" . $_GET['name'] . "'"; $result = mysqlQuery($con, $sql); if ($row = mysql_fetch_array($result)) { $diff = $row['time']; $diff = time() - $diff; $up = true; } else { $diff = 4 * 3600; $up = false; } if ($diff >= 4 * 3600) { $url = sprintf("http://download.finance.yahoo.com/d/quotes.csv?s=%s&f=sl1d1t1c1ohgv&e=.csv", $_GET['name']); $handle = fopen($url, "r"); if ($handle !== FALSE) { $data = fgetcsv($handle); fclose($handle); } if (!$up) { $sql = "Insert into price (avg,max,min,code,time) values (%s,%s,%s,'%s',%d)"; $sql = sprintf($sql, $data[1], $data[6], $data[7], $data[0], time()); } else { $sql = "update price set avg=%s,max=%s,min=%s,time=%s where code = '%s'"; $sql = sprintf($sql, $data[1], $data[6], $data[7], time(), $data[0]); } mysqlQuery($con, $sql); echo $data[1] . " " . $data[6] . " " . $data[7] . " " . $data[0]; } else {
#!/usr/bin/php <?php require_once '/var/www/www.example.org/Engine/Utils/CLI.inc'; if ($argc < 2 || $argc > 3) { echo "Usage: {$argv[0]} <partner_id> [date]\n"; die; } $partnerId = (int) $argv[1]; $date = strftime('%Y-%m-%d', strtotime($argv[2] ?: 'now')); echo "User agents for {$partnerId} on {$date}\n"; mysqlConnect(MYSQL_SLAVE); $sql = "SELECT lsm.user_agent AS user_agent FROM log_sessions ls LEFT JOIN log_session_meta lsm ON (lsm.log_session_id=ls.id) WHERE ls.time_firstaction >= '{$date}' AND ls.time_firstaction < TIMESTAMPADD(DAY, 1, '{$date}') AND ls.partner_id={$partnerId};"; $select = mysql_query($sql); $uas = array(); while ($row = mysql_fetch_assoc($select)) { $uas[$row['user_agent']]++; } $browsers = array(); $parser = new \UAS\Parser(); $parser->SetCacheDir(sys_get_temp_dir() . "/uascache/"); foreach ($uas as $ua => $count) { $browser = 'unknown'; if ($ret = $parser->parse($ua)) { $browser = "{$ret['typ']} - {$ret['ua_family']}"; } $browsers[$browser] += $count; } ksort($browsers); $total = $max1 = $max2 = 0; foreach ($browsers as $browser => $count) { $max1 = max($max1, strlen($browser));
function jobStart($cronId, $hostname, $pid) { $cronId = (int) $cronId; $hostnameSQL = mysql_real_escape_string($hostname); $pid = (int) $pid; if ($pid <= 0) { return null; } debug("Storing start time for cron id {$cronId}, pid {$pid}."); // Update start time and pid in database. $master = mysqlConnect(MYSQL_MASTER); $select = mysql_query_debug("SELECT id FROM cron_status WHERE cron_id='{$cronId}' AND hostname='{$hostnameSQL}';", __LINE__, $master); $row = mysql_fetch_assoc($select); $statusId = (int) $row['id']; if (!$statusId) { $upsert = mysql_query_debug("INSERT INTO cron_status (cron_id, hostname, pid) VALUES ('{$cronId}', '{$hostnameSQL}', '{$pid}') ON DUPLICATE KEY UPDATE time_start=NOW(), time_end=NULL, pid='{$pid}';", __LINE__, $master); $statusId = $result ? mysql_insert_id() : null; } else { $update = mysql_query_debug("UPDATE cron_status SET time_start=NOW(), time_end=NULL, pid='{$pid}' WHERE id='{$statusId}';", __LINE__, $master); } return $statusId; }
function core_inputCheck($str) { mysqlConnect(); return mysql_real_escape_string($str); }
} $response->getBody()->write(json_encode($rows)); return $response; }); $app->get('/scene/{id}', function (Request $request, Response $response) { $id = $request->getAttribute('id'); $conn = mysqlConnect(); $sth = $conn->query("UPDATE scenes SET accessCount = accessCount + 1, lastAccess = NOW() where id = {$id}"); $sth = $conn->query("SELECT id, nickname as nickName, title, description as 'desc', jsondata from scenes where id = {$id}"); $rows = array(); while ($r = mysqli_fetch_assoc($sth)) { $rows[] = $r; } $response->getBody()->write(json_encode($rows)); return $response; }); $app->post('/scene', function (Request $request, Response $response) { $jsondata = $request->getBody(); $obj = json_decode($jsondata); $conn = mysqlConnect(); $nickName = $conn->real_escape_string($obj->nickName); $title = $conn->real_escape_string($obj->title); $descr = $conn->real_escape_string($obj->desc); $jsondata = $conn->real_escape_string($jsondata); $ip = $_SERVER['REMOTE_ADDR']; $sth = $conn->query("insert into scenes (nickname, title, description, ipaddress, jsondata, lastaccess, added) values('{$nickName}','{$title}','{$descr}','{$ip}','{$jsondata}', NOW(), NOW())"); $response->getBody()->write($obj->nickName); return $response; }); $app->run(); //$conn->close();
} $mysqli_result->free(); return $res; } function getInsertCommand($wowzaHostName, $wowzaDc, $wowzaServerNodeType) { $t = time(); $date = date("Y-m-d", $t); $insertCommand = "insert into server_node set created_at = \"{$date}\", updated_at = \"{$date}\", dc = {$wowzaDc}, name = \"{$wowzaHostName}\", host_name = \"{$wowzaHostName}\", type = {$wowzaServerNodeType}, partner_id = -5, status = 1"; $custom_data = array(); $custom_data["application_name"] = "kLive"; $serializedCustomData = serialize($custom_data); $insertCommand .= ", custom_data = '{$serializedCustomData}'"; return $insertCommand; } $link = mysqlConnect(); $wowzaServerNodeType = getWowzaServerNodeDynamicType($link); $mysqli_result = mysqli_query($link, "SELECT * from media_server"); while ($row = $mysqli_result->fetch_assoc()) { $wowzaDc = $row[DC_INDEX]; $wowzaHostName = $row[HOST_NAME_INDEX]; if (!validateHostNameDoesNotExist($link, $wowzaHostName, $wowzaServerNodeType)) { $insertCommand = getInsertCommand($wowzaHostName, $wowzaDc, $wowzaServerNodeType); $result = mysqli_query($link, $insertCommand); if (!$result) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $insertCommand; die($message); } } }