function getEventbriteEvents($eb_keywords, $eb_city, $eb_proximity)
{
global $eb_app_key;
$xml_url = "https://www.eventbrite.com/xml/event_search?...&within=50&within_unit=M&keywords=" . $eb_keywords . "&city=" . $eb_city . "&date=This+month&app_key=" . $eb_app_key;
echo $xml_url . "<br />";
$xml = simplexml_load_file($xml_url);
$count = 0;
// loop over events from eventbrite xml
foreach ($xml->event as $event) {
// add event if it doesn't already exist
$event_query = mysql_query("SELECT * FROM events WHERE id_eventbrite={$event->id}") or die(mysql_error());
if (mysql_num_rows($event_query) == 0) {
echo $event_id . " ";
// get event url
foreach ($event->organizer as $organizer) {
$event_organizer_url = $organizer->url;
}
// get event address
foreach ($event->venue as $venue) {
$event_venue_address = $venue->address;
$event_venue_city = $venue->city;
$event_venue_postal_code = $venue->postal_code;
}
// get event title
$event_title = str_replace(array("\r\n", "\r", "\n"), ' ', $event->title);
// add event to database
mysql_query("INSERT INTO events (id_eventbrite, \n title,\n created, \n organizer_name, \n uri, \n start_date, \n end_date, \n address\n ) VALUES (\n '{$event->id}',\n '" . parseInput($event_title) . "',\n '" . strtotime($event->created) . "',\n '" . trim(parseInput($event->organizer->name)) . "',\n '{$event_organizer_url}',\n '" . strtotime($event->start_date) . "',\n '" . strtotime($event->end_date) . "',\n '{$event_venue_address}, {$event_venue_city}, {$event_venue_postal_code}'\n )") or die(mysql_error());
}
$count++;
}
}
function createMainDataElement($plan, $num, $dbConn)
{
if ($plan['dato_principal_' . $num] != NULL) {
$query_dato = sprintf("SELECT * FROM tipoDatosServicios WHERE id_tipoDato=%s", GetSQLValueString($plan['id_tipoDato_principal_' . $num], "int"));
$dato = mysql_query($query_dato, $dbConn) or die(mysql_error());
$row_dato = mysql_fetch_assoc($dato);
$display = true;
$label = "";
if ($row_dato['tipo'] == "boolean") {
if ($plan['dato_principal_' . $num] == "1") {
$label = $row_dato['label'];
} else {
$display = false;
}
} else {
if ($row_dato['display_label']) {
$label = $plan['dato_principal_' . $num] . " " . $row_dato['label'];
} else {
$label = $plan['dato_principal_' . $num];
}
}
if ($display) {
echo "<div class='dato'>";
echo "\t<li class='tipo_" . $plan['id_tipoDato_principal_' . $num] . "' value='" . $plan['dato_principal_' . $num] . "'>";
echo $label;
echo "\t</li>";
echo "</div>";
}
}
//if
}
public function grabar_venta($pedido, $cliente, $tipo_documento, $nro_documento, $serie_documento)
{
$query = "INSERT INTO ventas(ped_id,cli_id,ven_fecha,ven_estado,ven_nrodoc,tipc_id,ven_seriedoc) VALUES ('{$pedido}','{$cliente}','" . date('y-m-d') . "','0','{$nro_documento}','{$tipo_documento}','{$serie_documento}')";
$rs = mysql_query($query);
$_SESSION['venta_codigo'] = mysql_insert_id();
return $rs;
}
function db($dbhost, $dbuser, $dbpw, $dbname = '', $dbcharset = 'utf8', $pconnect = 0)
{
if ($pconnect) {
if (!($this->mlink = @mysql_pconnect($dbhost, $dbuser, $dbpw))) {
$this->halt('Can not connect to MySQL');
}
} else {
if (!($this->mlink = @mysql_connect($dbhost, $dbuser, $dbpw))) {
$this->halt('Can not connect to MySQL');
}
}
if ($this->version() > '4.1') {
if ('utf-8' == strtolower($dbcharset)) {
$dbcharset = 'utf8';
}
if ($dbcharset) {
mysql_query("SET character_set_connection={$dbcharset}, character_set_results={$dbcharset}, character_set_client=binary", $this->mlink);
}
if ($this->version() > '5.0.1') {
mysql_query("SET sql_mode=''", $this->mlink);
}
}
if ($dbname) {
mysql_select_db($dbname, $this->mlink);
}
}
function getTangentText($type, $keyword)
{
global $dbHost, $dbUser, $dbPassword, $dbName;
$link = @mysql_connect($dbHost, $dbUser, $dbPassword);
if (!$link) {
die("Cannot connect : " . mysql_error());
}
if (!@mysql_select_db($dbName, $link)) {
die("Cannot find database : " . mysql_error());
}
$result = mysql_query("SELECT sr_keywords, sr_text FROM soRandom WHERE sr_type = '" . $type . "' ORDER BY sr_ID ASC;", $link);
$tempCounter = 0;
while ($row = mysql_fetch_assoc($result)) {
$pKey = "/" . $keyword . "/";
$pos = preg_match($pKey, $row['sr_keywords']);
//echo $pos . " is pos<br>";
//echo $keyword;
//echo " is keyword and this is the search return: " . $row['keywords'];
if ($pos != 0) {
$text[$tempCounter] = stripslashes($row["sr_text"]);
$tempCounter++;
}
}
mysql_close($link);
//$text=htmlentities($text);
return $text;
}
function Query($sqlString)
{
if (!($resourseId = @mysql_query($sqlString, $this->dbId))) {
die("<b>MySQL</b>: Unable to execute<br /><b>SQL</b>: " . $sqlString . "<br /><b>Error (" . mysql_errno() . ")</b>: " . @mysql_error());
}
return $resourseId;
}
function executesql($sql, $link)
{
if (!mysql_query($sql, $link)) {
die('Error: ' . mysql_error());
exit(0);
}
}
function dataInsert($table, $dataArray)
{
$fldArray = $dataArray;
$i = 0;
$j = 0;
$sql .= "insert into `" . $table . "` (";
while (list($key1, $value1) = each($fldArray)) {
$sql .= "`" . $key1 . "`";
$j++;
if ($j != count($fldArray)) {
$sql .= ",";
}
if ($j == count($fldArray)) {
$sql .= ") VALUES (";
}
}
while (list($key1, $value1) = each($dataArray)) {
$sql .= "'" . $value1 . "'";
$i++;
if ($i != count($dataArray)) {
$sql .= ",";
}
if ($i == count($dataArray)) {
$sql .= ")";
}
}
mysql_query($sql) or die(CHECK_QUERY . $sql);
$id = mysql_insert_id();
return $id;
}
function checkIndividually()
{
#----------------------------------------------------------------------
global $competitionCondition, $chosenWhich;
echo "<hr /><p>Checking <b>" . $chosenWhich . " individual results</b>... (wait for the result message box at the end)</p>\n";
#--- Get all results (id, values, format, round).
$dbResult = mysql_query("\n SELECT\n result.id, formatId, roundId, personId, competitionId, eventId, result.countryId,\n value1, value2, value3, value4, value5, best, average\n FROM Results result, Competitions competition\n WHERE competition.id = competitionId\n {$competitionCondition}\n ORDER BY formatId, competitionId, eventId, roundId, result.id\n ") or die("<p>Unable to perform database query.<br/>\n(" . mysql_error() . ")</p>\n");
#--- Build id sets
$countryIdSet = array_flip(getAllIDs(dbQuery("SELECT id FROM Countries")));
$competitionIdSet = array_flip(getAllIDs(dbQuery("SELECT id FROM Competitions")));
$eventIdSet = array_flip(getAllIDs(dbQuery("SELECT id FROM Events")));
$formatIdSet = array_flip(getAllIDs(dbQuery("SELECT id FROM Formats")));
$roundIdSet = array_flip(getAllIDs(dbQuery("SELECT id FROM Rounds")));
#--- Process the results.
$badIds = array();
echo "<pre>\n";
while ($result = mysql_fetch_array($dbResult)) {
if ($error = checkResult($result, $countryIdSet, $competitionIdSet, $eventIdSet, $formatIdSet, $roundIdSet)) {
extract($result);
echo "Error: {$error}\nid:{$id} format:{$formatId} round:{$roundId}";
echo " ({$value1},{$value2},{$value3},{$value4},{$value5}) best+average({$best},{$average})\n";
echo "{$personId} {$countryId} {$competitionId} {$eventId}\n\n";
$badIds[] = $id;
}
}
echo "</pre>";
#--- Free the results.
mysql_free_result($dbResult);
#--- Tell the result.
noticeBox2(!count($badIds), "All checked results pass our checking procedure successfully.<br />" . wcaDate(), count($badIds) . " errors found. Get them with this:<br /><br />SELECT * FROM Results WHERE id in (" . implode(', ', $badIds) . ")");
}
function consulta($sql=""){
if($sql!="")
{
$this->consultaId=mysql_query($sql,$this->conexionId);
return $this->consultaId;
}
}
function get_user_paid_expenses_test($userid_array)
{
if (is_array($userid_array)) {
$userids = implode(",", $userid_array);
} else {
$userids = $userid_array;
}
$sql = "SELECT user_id as userid, expense_id as exid, group_id, amount, UNIX_TIMESTAMP(expense_date) AS expensedate, \n description FROM expenses WHERE user_id in ({$userids})";
if (!($result = mysql_query($sql))) {
return false;
} else {
$total = 0;
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$paid['users'][$row['userid']]['groups'][$row['group_id']][$row['exid']]['amount'] = $row['amount'];
$paid['users'][$row['userid']]['groups'][$row['group_id']][$row['exid']]['expense_date'] = date("j M Y", $row['expensedate']);
$paid['users'][$row['userid']]['groups'][$row['group_id']][$row['exid']]['description'] = $row['description'];
$paid['users'][$row['userid']]['groups'][$row['group_id']]['group_total'] += $row['amount'];
$paid['users'][$row['userid']]['user_total'] += $row['amount'];
$total += $row['amount'];
// format totals with two decimals
$paid['users'][$row['userid']]['groups'][$row['group_id']]['total'] = number_format($paid['users'][$row['userid']]['groups'][$row['group_id']]['total'], DECIMALS, DSEP, TSEP);
$paid['users'][$row['userid']]['total'] = number_format($paid['users'][$row['userid']]['total'], DECIMALS, DSEP, TSEP);
$paid['users'][$row['userid']]['groups'][$row['group_id']][$row['exid']]['running_total'] += $row['amount'] + $last_running[$row['userid']][$row['group_id']];
$last_running[$row['userid']][$row['group_id']] = $paid['users'][$row['userid']]['groups'][$row['group_id']][$row['exid']]['running_total'];
}
$paid['total'] = number_format($total, DECIMALS, DSEP, TSEP);
}
// array structure: ['users'][$userid]['groups'][$groupid][$expenseid]['amount|expense_date|description']
return $paid;
}
function get_img_old($id)
{
$query = mysql_query("select menu_img from menus \n\t\t\t\t\t\twhere menu_id = '" . $id . "'");
$result = mysql_fetch_array($query);
$row = $result['menu_img'];
return $row;
}
public function query($sql)
{
if ($this->link) {
$resource = mysql_query($sql, $this->link);
if ($resource) {
if (is_resource($resource)) {
$i = 0;
$data = array();
while ($result = mysql_fetch_assoc($resource)) {
$data[$i] = $result;
$i++;
}
mysql_free_result($resource);
$query = new \stdClass();
$query->row = isset($data[0]) ? $data[0] : array();
$query->rows = $data;
$query->num_rows = $i;
unset($data);
return $query;
} else {
return true;
}
} else {
$trace = debug_backtrace();
trigger_error('Error: ' . mysql_error($this->link) . '<br />Error No: ' . mysql_errno($this->link) . '<br /> Error in: <b>' . $trace[1]['file'] . '</b> line <b>' . $trace[1]['line'] . '</b><br />' . $sql);
}
}
}
public function saveRatinglist()
{
foreach ($this->ratings as $player) {
//Controleren of speler al bestaat + ophalen id
$sql = "SELECT * FROM svn_leden WHERE knsb = " . $player["knsb"];
$query = mysql_query($sql);
if (mysql_num_rows($query) == 1) {
$data = mysql_fetch_assoc($query);
$player["id"] = $data["id"];
} elseif (mysql_num_rows($query) == 0) {
//Toevoegen van de speler
print_r($player);
}
//Controleren of de rating al bestaat
$sql = "SELECT * FROM svn_rating WHERE id = " . $player["id"] . " AND datum = '" . $this->ratingList . "'";
$query = mysql_query($sql);
if (mysql_num_rows($query) == 0) {
//Toevoegen rating
$sql = "INSERT INTO svn_rating VALUES ('',\"" . $this->ratingList . "\"," . $player["id"] . ",1," . $player["rating"] . ")";
mysql_query($sql);
}
}
$sql = "SELECT * FROM svn_leden WHERE knsb = " . $speler_geg["id"];
$result = mysql_query($sql);
$speler_dat = mysql_fetch_array($result);
if ($speler_geg["rating"] != "") {
$sql = "INSERT INTO svn_rating VALUES ('',\"" . $datum . "\"," . $speler_dat[0] . ",1," . $speler_geg["rating"] . ")";
//echo $sql;
mysql_query($sql);
}
}
function insert_item()
{
// Connect to the 'test' database
// The parameters are defined in the teach_cn.inc file
// These are global constants
connect_and_select_db(DB_SERVER, DB_UN, DB_PWD, DB_NAME);
// Get the information entered into the webpage by the user
// These are available in the super global variable $_POST
// This is actually an associative array, indexed by a string
$itemNumber = mysql_real_escape_string($_POST['itemNumber']);
$itemDescription = mysql_real_escape_string($_POST['itemDescription']);
$category = mysql_real_escape_string($_POST['category']);
$departmentName = mysql_real_escape_string($_POST['departmentName']);
$purchaseCost = mysql_real_escape_string($_POST['purchaseCost']);
$retailPrice = mysql_real_escape_string($_POST['retailPrice']);
// Create a String consisting of the SQL command. Remember that
// . is the concatenation operator. $varname within double quotes
// will be evaluated by PHP
$insertStmt = "INSERT INTO Item (ItemNumber, ItemDescription, Category, DepartmentName,\n\t\t PurchaseCost, FullRetailPrice) values ( '{$itemNumber}','{$itemDescription}', '{$category}',\n '{$departmentName}', '{$purchaseCost}', '{$retailPrice}')";
//Execute the query. The result will just be true or false
$result = mysql_query($insertStmt);
$message = "";
if (!$result) {
$message = "Error in inserting Item. <br />Item Number: {$itemNumber}<br />Item Description:\n{$itemDescription} <br />Category:\n{$category}\n<br />Department\n Name: {$departmentName} <br />" . mysql_error();
} else {
$message = "Data for Item inserted successfully. <br />Item Number: {$itemNumber}<br />Item Description: {$itemDescription} <br />Category: {$category} <br />Department Name: {$departmentName}";
}
ui_show_item_insert_result($message, $itemNumber, $itemDescription, $category, $departmentName, $purchaseCost, $retailPrice);
}
public function query($sql)
{
$resource = mysql_query($sql, $this->link);
if ($resource) {
if (is_resource($resource)) {
$i = 0;
$data = array();
while ($result = mysql_fetch_assoc($resource)) {
$data[$i] = $result;
$i++;
}
mysql_free_result($resource);
$query = new stdClass();
$query->row = isset($data[0]) ? $data[0] : array();
$query->rows = $data;
$query->num_rows = $i;
unset($data);
return $query;
} else {
return true;
}
} else {
trigger_error('Error: ' . mysql_error($this->link) . '<br />Error No: ' . mysql_errno($this->link) . '<br />' . $sql);
exit;
}
}
function getNumTaxtype()
{
$sql = "select count(taxtype) from cri_ro_taxtypes where status=1";
$result = mysql_query($sql);
$total = mysql_fetch_array($result);
return $total[0];
}
function getGameCount()
{
// Load game info
$gameData = mysql_query("SELECT * FROM games");
// Get game count and return it
return mysql_num_rows($gameData);
}
function service($text)
{
$text = str_replace("\\\"","\"",$text);
$token = explode(",",$text);
$last_token = $token[sizeof($token)-1];
$last_token = trim($last_token);
$items = array();
$result = mysql_query("select firstName, lastName, email from employees where CONCAT(firstName,' ',lastName,' ', email) like '%$last_token%' order by email;");
while($row = mysql_fetch_assoc($result))
{
$text = '"'.$row["firstName"]." ".$row["lastName"].'"'."<".$row["email"].">";
$text_array = $token;
$text_array[sizeof($text_array)-1] = $text;
$text = join(",",$text_array);
$html = '"'.$row["firstName"]." ".$row["lastName"].'"'."[".$row["email"]."]";
$html = preg_replace("/".$last_token."/i","<b>$last_token</b>",$html);
$html = str_replace("[","<",$html);
$html = str_replace("]",">",$html);
$item = array("text"=>$text,"html"=>$html);
array_push($items,$item);
}
return $items;
}
function candidatesArePeopleToo()
{
$s = mysql_query("SELECT * FROM candidates");
while ($r = mysql_fetch_array($s)) {
$name = $r['name_cleaned'];
$sid = $r['id'];
if (strpos($r['url'], "http://") === 0) {
$url = $r['url'];
} else {
$url = 'http://www.alegeri-2008.ro' . $r['url'];
}
$idString = '<a href=' . $url . '>alegeri2008</a>';
$persons = getPersonsByName($name, $idString);
// If I reached this point, I know for sure I either have one
// or zero matches, there are no ambiguities.
if (count($persons) == 0) {
$person = addPersonToDatabase($name, $r['name_cleaned']);
} else {
$person = $persons[0];
info("Found {" . $name . "}");
}
// First and foremost, attempt to add this to the person's history.
addPersonHistory($person->id, "alegeri/2008", $url);
// Locate these people and update them in several tables now.
// We're mainly interested in updating the ID to the new ID that
// will be in the People database, from the previous ID that was
// the senator's ID in the senators table.
mysql_query("UPDATE candidates " . "SET idperson={$person->id} " . "WHERE id=" . $r['id']);
}
}
function connect($dbhost, $dbuser, $dbpw, $dbname = '', $dbcharset = '', $pconnect = 0, $tablepre = '', $time = 0)
{
$this->dbhost = $dbhost;
$this->dbuser = $dbuser;
$this->dbpw = $dbpw;
$this->dbname = $dbname;
$this->dbcharset = $dbcharset;
$this->pconnect = $pconnect;
$this->tablepre = $tablepre;
$this->time = $time;
if ($pconnect) {
if (!($this->link = mysql_pconnect($dbhost, $dbuser, $dbpw))) {
$this->halt('Can not connect to MySQL server');
}
} else {
if (!($this->link = mysql_connect($dbhost, $dbuser, $dbpw))) {
$this->halt('Can not connect to MySQL server');
}
}
if ($this->version() > '4.1') {
if ($dbcharset) {
mysql_query("SET character_set_connection=" . $dbcharset . ", character_set_results=" . $dbcharset . ", character_set_client=binary", $this->link);
}
if ($this->version() > '5.0.1') {
//mysql_query("SET sql_mode=''", $this->link); //关闭严格模式
}
}
if ($dbname) {
mysql_select_db($dbname, $this->link);
}
}
function inserir($coluna, $valor, $tabela)
{
//Perguntar se os dado recebidos são arrays
if (is_array($coluna) and is_array($valor)) {
//Verificar o numero de elementos
if (count($coluna) == count($valor)) {
//Montar sql
$inserir = "INSERT INTO {$tabela}(" . implode(', ', $coluna) . ")\n VALUES('" . implode('\', \'', $valor) . "')";
} else {
return false;
}
} else {
//
//Montar sql
$inserir = "INSERT INTO {$tabela} ({$coluna}) values ('{$valor}')";
}
//Conectou?
if ($conexao = connect()) {
//Inseriu?
if (mysql_query($inserir, $conexao)) {
//Fechar conexao
fecharConexao($conexao);
return TRUE;
} else {
echo "Query invalida!";
return false;
}
} else {
return FALSE;
}
}
function add_pack()
{
$msg = new messages();
$response = new StdClass();
/*recibimos variables*/
$ini = $_POST["ini"];
$fin = $_POST["fin"];
$inter = $_POST["inter"];
$per = $_POST["per"];
if ($ini == "" || $fin == "" || $inter == "") {
$res = false;
$mes = $msg->get_msg("e005");
} else {
$con = new con();
$con->connect();
/* ingresamos datos de la finca */
$qry = "INSERT INTO tbl_remisiones_fisicas (rf_persona_entrega, rf_interventor, rf_dig_ini, rf_dig_fin, rf_created, rf_estado)\n\t\t\t\t\tVALUES ('" . $per . "','" . $inter . "'," . $ini . "," . $fin . "," . $_SESSION["ses_id"] . ",1);";
$resp = mysql_query($qry);
if (!$resp) {
$res = false;
$mes = $msg->get_msg("e003");
} else {
$res = true;
$mes = $msg->get_msg("e004");
}
}
$response->res = $res;
$response->mes = $mes;
echo json_encode($response);
$con->disconnect();
}
function get_table_rows($table)
{
$temp = mysql_query("SELECT SQL_CALC_FOUND_ROWS * FROM {$table} LIMIT 1");
$result = mysql_query("SELECT FOUND_ROWS()");
$total = mysql_fetch_row($result);
return $total[0];
}
function alertnoticias_consultar($consulta,$accion)
{
$enlace = mysql_connect('atc-nh-natsdb.nationalnet.com', 'staffcenter','XgwofvLY2ayLf') or die('No pudo conectarse : ' . mysql_error());
mysql_select_db('staffcenter',$enlace) or die('No pudo seleccionarse la BD.');
$sql = $consulta;
$resultado = mysql_query($sql,$enlace) or die('La consulta falló: ' . mysql_error());
while ($row = mysql_fetch_array($resultado)){
switch($accion)
{
case "noticiasdeldia":
$idsnoticias[]=$row['idnoticia'].",".$row['titulo'];
break;
}
}
mysql_free_result($resultado);
switch($accion)
{
case "noticiasdeldia":
return $idsnoticias;
break;
}
}
function RetrieveRecordArray($filter = null)
{
$dtoArray = array();
$query = "SELECT * FROM cobranca WHERE removido = 0 AND " . $filter;
if (empty($filter)) {
$query = "SELECT * FROM cobranca WHERE removido = 0";
}
$recordSet = mysql_query($query, $this->mysqlConnection);
if (!$recordSet && $this->showErrors) {
print_r(mysql_error());
echo '<br/><br/>';
}
$recordCount = mysql_num_rows($recordSet);
if ($recordCount == 0) {
return $dtoArray;
}
$index = 0;
while ($record = mysql_fetch_array($recordSet)) {
$dto = new ContractChargeDTO();
$dto->id = $record['id'];
$dto->codigoContrato = $record['contrato_id'];
$dto->codigoSubContrato = $record['subContrato_id'];
$dto->codigoContador = $record['contador_id'];
$dto->modalidadeMedicao = $record['modalidadeMedicao'];
$dto->fixo = $record['fixo'];
$dto->variavel = $record['variavel'];
$dto->franquia = $record['franquia'];
$dto->individual = $record['individual'];
$dtoArray[$index] = $dto;
$index++;
}
mysql_free_result($recordSet);
return $dtoArray;
}
function print_table($table, $attributes, $callback = NULL)
{
$attr_list_str = implode(', ', $attributes);
$query = "SELECT {$attr_list_str} FROM {$table}";
$result = mysql_query($query);
$num = @mysql_numrows($result);
echo "<table>";
echo "<tr>";
foreach ($attributes as $attr) {
echo "<th>";
echo $attr;
echo "</th>";
}
echo "</tr>";
$i = 0;
while ($i < $num) {
echo "<tr>";
foreach ($attributes as $attr) {
echo "<td>";
if ($callback != NULL) {
$value = mysql_result($result, $i, $attr);
$callback($attr, $value);
} else {
echo mysql_result($result, $i, $attr);
}
echo "</td>";
}
echo "</tr>";
$i++;
}
echo "</table>";
return $num;
}
/**
* execute query - show be regarded as private to insulate the rest of
* the application from sql differences
* @access private
*/
function query($sql)
{
global $CONF;
if (is_null($this->dblink)) {
$this->_connect();
}
//been passed more parameters? do some smart replacement
if (func_num_args() > 1) {
//query contains ? placeholders, but it's possible the
//replacement string have ? in too, so we replace them in
//our sql with something more unique
$q = md5(uniqid(rand(), true));
$sql = str_replace('?', $q, $sql);
$args = func_get_args();
for ($i = 1; $i <= count($args); $i++) {
$sql = preg_replace("/{$q}/", "'" . preg_quote(mysql_real_escape_string($args[$i])) . "'", $sql, 1);
}
//we shouldn't have any $q left, but it will help debugging if we change them back!
$sql = str_replace($q, '?', $sql);
}
$this->dbresult = mysql_query($sql, $this->dblink);
if (!$this->dbresult) {
die("Query failure: " . mysql_error() . "<br />{$sql}");
}
return $this->dbresult;
}
function query($sql)
{
if (!empty($this->db) || $this->connect()) {
return @mysql_query($sql, $this->db);
}
return false;
}
/**
* Find pixels coords and draw these on the current image
*
* @param integer $image Number of the image (to be used with $this->height)
* @return boolean Success
**/
function drawPixels($image)
{
$limit = 0;
do {
/** Select with limit */
$result = mysql_query(sprintf($this->query, $image * $this->height, ($image + 1) * $this->height - 1) . ' LIMIT ' . $limit . ',' . $this->limit);
if ($result === false) {
return $this->raiseError('Query failed: ' . mysql_error());
}
$count = mysql_num_rows($result);
while ($click = mysql_fetch_row($result)) {
$x = (int) $click[0];
$y = (int) ($click[1] - $image * $this->height);
if ($x < 0 || $x >= $this->width) {
continue;
}
/** Apply a calculus for the step, with increases the speed of rendering : step = 3, then pixel is drawn at x = 2 (center of a 3x3 square) */
$x -= $x % $this->step - $this->startStep;
$y -= $y % $this->step - $this->startStep;
/** Add 1 to the current color of this pixel (color which represents the sum of clicks on this pixel) */
$color = imagecolorat($this->image, $x, $y) + 1;
imagesetpixel($this->image, $x, $y, $color);
$this->maxClicks = max($this->maxClicks, $color);
if ($image === 0) {
/** Looking for the maximum height of click */
$this->maxY = max($y, $this->maxY);
}
}
/** Free resultset */
mysql_free_result($result);
$limit += $this->limit;
} while ($count === $this->limit);
return true;
}