$constants['DB_CHARSET'] = 'utf8';
@mysql_query("SET NAMES 'utf8'", $this->database_connection);
if (@mysql_query($test_table_sql, $this->database_connection)) {
$this->printMessage('Test query has been executed. Its safe to proceed with database migration.');
@mysql_query("DROP TABLE `$test_table_name`", $this->database_connection);
if ($result = mysql_query('SELECT * FROM `' . TABLE_PREFIX . 'message_comments', $this->database_connection)) {
mysql_query('BEGIN WORK', $this->database_connection);
if (!mysql_query($sql, $this->database_connection)) {
mysql_query('ROLLBACK', $this->database_connection);
$this->printMessage('Failed to move project documents. MySQL said: ' . mysql_error(), true);
$sql = sprintf("SELECT `id` FROM `%sfile_types` WHERE `extension` = '%s'", TABLE_PREFIX, mysql_real_escape_string(strtolower(get_file_extension($row['filename']))));
if ($file_type_result = mysql_query($sql)) {
$repository_entry_exists = false;
if ($check_repository_id_result = mysql_query(sprintf(("SELECT COUNT (`id`) AS 'row_count' FROM `%sfile_repo` WHERE `id` = '%s'"), TABLE_PREFIX, $repository_id))) {
mysql_select_db($server_db);
$move = mysql_query("UPDATE forum_threads SET forumid = '".intval($_POST['t_move'])."' WHERE id = '".intval($_GET['t'])."'");
$thread = mysql_fetch_assoc(mysql_query("SELECT * FROM forum_threads WHERE id = '".$threadid."'"))or $error=1;
$postid = mysql_fetch_assoc(mysql_query("SELECT * FROM forum_posts WHERE type = 1 AND postid = '".$thread['id']."'"));
$update = mysql_query("UPDATE forum_threads SET views = views + 1 WHERE id = '".$thread['id']."'");
$forum = mysql_fetch_assoc(mysql_query("SELECT * FROM forum_forums WHERE id = '".$thread['forumid']."'"))or $error=1;
$category = mysql_fetch_assoc(mysql_query("SELECT * FROM forum_categ WHERE id = '".$forum['categ']."'"))or $error=1;
if(isset($_SESSION['username'])){ $userInfo = mysql_fetch_assoc(mysql_query("SELECT * FROM users WHERE id = '".$account_information['id']."'")); }
$insert = mysql_query("INSERT INTO forum_replies (threadid,forumid,content,author,name,date,last_date) VALUES ('".$thread['id']."','".$forum['id']."','".mysql_real_escape_string($reply)."','".mysql_real_escape_string($account_information['id'])."','".mysql_real_escape_string($thread['name'])."','".$ndate."','".$ndate."')")or print(''.$Forum['Forum58'].'');
$replies = mysql_fetch_assoc(mysql_query("SELECT * FROM forum_replies WHERE threadid = '".$thread['id']."' ORDER BY id DESC LIMIT 1"));
$posterAccount = mysql_fetch_assoc(mysql_query("SELECT * FROM $server_adb.account WHERE id = '".$thread['author']."'"));
$posterInfo = mysql_fetch_assoc(mysql_query("SELECT * FROM users WHERE id = '".$posterAccount['id']."'"));
}
$rs = mysql_query("SELECT prj_name FROM wiode_projects WHERE prj_id=$obj_project");
}else{
$rs = mysql_query("SELECT * FROM wiode_objects WHERE obj_id=$obj_id");
}else{
$rs = mysql_query("SELECT * FROM wiode_projects WHERE prj_status=0 AND prj_id!=" . mysql_real_escape_string($_SESSION['curproject']) . " ORDER BY prj_name");
// Copy to project root
$rs = mysql_query("SELECT * FROM wiode_projects WHERE prj_id=$dest_proj");
// Insert into db
$rs = mysql_query("INSERT INTO wiode_objects (obj_project,obj_name,obj_type,obj_parent) VALUES (" . mysql_real_escape_string($_GET['dp']) . ",'" . mysql_real_escape_string($new_name) . "',2,$dest_dir)");
// Update data
$rs = mysql_query("UPDATE wiode_objects SET obj_name='$obj_new_name' WHERE obj_id=$obj_id");
global $objects;
$rs = mysql_query("SELECT obj_id FROM wiode_objects WHERE obj_project=" . mysql_real_escape_string($project) . " AND obj_parent=" . mysql_real_escape_string($parent));
foreach($objects as $v){
mysql_query("DELETE FROM wiode_objects WHERE obj_id=" . mysql_real_escape_string($v));
mysql_query("INSERT INTO `hs_hr_leavetype` VALUES ('LTY010', 'Medical', 1)");
mysql_query("INSERT INTO `hs_hr_leavetype` VALUES ('LTY011', 'Casual', 1)");
mysql_query("INSERT INTO `hs_hr_leavetype` VALUES ('LTY012', 'Annual', 0)");
mysql_query("INSERT INTO `hs_hr_employee_leave_quota` (year, leave_type_id, employee_id, no_of_days_allotted, leave_taken) VALUES ('".date('Y')."', 'LTY010', '012', 10, 5);");
mysql_query("INSERT INTO `hs_hr_employee_leave_quota` (year, leave_type_id, employee_id, no_of_days_allotted, leave_taken) VALUES ('".date('Y')."', 'LTY011', '012', 20, 30);");
mysql_query("INSERT INTO `hs_hr_employee_leave_quota` (year, leave_type_id, employee_id, no_of_days_allotted) VALUES ('".date('Y')."', 'LTY012', '013', 30);");
mysql_query("INSERT INTO `hs_hr_employee_leave_quota` (year, leave_type_id, employee_id, no_of_days_allotted) VALUES ('".date('Y')."', 'LTY010', '011', 10);");
mysql_query("INSERT INTO `hs_hr_employee_leave_quota` (year, leave_type_id, employee_id, no_of_days_allotted) VALUES ('".date('Y')."', 'LTY011', '011', 20);");
mysql_query("INSERT INTO `hs_hr_leave_requests` (`leave_request_id`, `leave_type_id`, `leave_type_name`, `date_applied`, `employee_id`) VALUES (10, 'LTY010', 'Medical', '".date('Y-m-d', time()+3600*24)."', '011')");
mysql_query("INSERT INTO `hs_hr_leave_requests` (`leave_request_id`, `leave_type_id`, `leave_type_name`, `date_applied`, `employee_id`) VALUES (11, 'LTY012', 'Medical', '".date('Y-m-d', time()+3600*24)."', '013')");
mysql_query("TRUNCATE TABLE `hs_hr_project`", $this->connection);
mysql_query("TRUNCATE TABLE `hs_hr_project_admin`", $this->connection);
mysql_query("TRUNCATE TABLE `hs_hr_customer`", $this->connection);
mysql_query("TRUNCATE TABLE `hs_hr_employee`", $this->connection);
// Insert a project and customer and employees for use in the test
mysql_query("INSERT INTO hs_hr_customer(customer_id, name, description, deleted) " .
"VALUES(1, 'Test customer', 'description', 0)");
mysql_query("INSERT INTO hs_hr_project(project_id, customer_id, name, description, deleted) " .
"VALUES(1, 1, 'Test project 1', 'a test proj 1', 0)");
mysql_query("INSERT INTO hs_hr_project(project_id, customer_id, name, description, deleted) " .
"VALUES(2, 1, 'Test project 2', 'a test proj 2', 0)");
mysql_query("INSERT INTO hs_hr_employee(emp_number, employee_id, emp_lastname, emp_firstname, emp_middle_name) " .
"VALUES(1, '0011', 'Rajasinghe', 'Saman', 'Marlon')");
/* Create tables for testing */
$result = mysql_query("DROP TABLE IF EXISTS test_emp_dependents");
$result = mysql_query("CREATE TABLE test_emp_dependents (" .
$result = mysql_query("DROP TABLE IF EXISTS test_users");
$result = mysql_query("CREATE TABLE test_users (" .
$result = mysql_query("DROP TABLE IF EXISTS test_employee");
$result = mysql_query("CREATE TABLE test_employee(" .
$result = mysql_query("DROP TABLE IF EXISTS test_job_title");
$result = mysql_query("CREATE TABLE test_job_title (" .
$sql = "SELECT SUM(tot_htva), SUM(tot_tva)FROM " . $tblpref ."bon_comm WHERE MONTH(date) = '1' AND YEAR(date) = YEAR(NOW());";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$sql = " SELECT SUM(prix)FROM " . $tblpref ."`depense` WHERE MONTH(date) = 1 AND YEAR(date) = YEAR(NOW())";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$sql = "SELECT SUM(tot_htva), SUM(tot_tva)FROM " . $tblpref ."bon_comm WHERE MONTH(date) = '2' AND YEAR(date) = YEAR(NOW())";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$sql = " SELECT SUM(prix)FROM " . $tblpref ."`depense` WHERE MONTH(date) = 2 AND YEAR(date) = YEAR(NOW())";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$sql = "SELECT SUM(tot_htva), SUM(tot_tva)FROM " . $tblpref ."bon_comm WHERE MONTH(date) = '3' AND YEAR(date) = YEAR(NOW())";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$sql = " SELECT SUM(prix)FROM " . $tblpref ."`depense` WHERE MONTH(date) = 3 AND YEAR(date) = YEAR(NOW())";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$sql = "SELECT SUM(tot_htva), SUM(tot_tva)FROM " . $tblpref ."bon_comm WHERE MONTH(date) = '4' AND YEAR(date) = YEAR(NOW())";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$sql = " SELECT SUM(prix)FROM " . $tblpref ."`depense` WHERE MONTH(date) = 4 AND YEAR(date) = YEAR(NOW())";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$sql = "SELECT SUM(tot_htva)FROM bon_comm WHERE MONTH(date) = '1' AND YEAR(date) = YEAR(NOW());";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$sql = " SELECT SUM(prix)FROM `depense` WHERE MONTH(date) = 1 AND YEAR(date) = YEAR(NOW())";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$sql = "SELECT SUM(tot_htva)FROM bon_comm WHERE MONTH(date) = '2' AND YEAR(date) = YEAR(NOW())";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$sql = " SELECT SUM(prix)FROM `depense` WHERE MONTH(date) = 2 AND YEAR(date) = YEAR(NOW())";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$sql = "SELECT SUM(tot_htva)FROM bon_comm WHERE MONTH(date) = '3' AND YEAR(date) = YEAR(NOW())";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$sql = " SELECT SUM(prix)FROM `depense` WHERE MONTH(date) = 3 AND YEAR(date) = YEAR(NOW())";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$sql = "SELECT SUM(tot_htva)FROM bon_comm WHERE MONTH(date) = '4' AND YEAR(date) = YEAR(NOW())";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$sql = " SELECT SUM(prix)FROM `depense` WHERE MONTH(date) = 4 AND YEAR(date) = YEAR(NOW())";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$query = "SELECT * from dependency WHERE id =".$id.";";
$result = mysql_query($query) or die("<b>A fatal MySQL error occured</b>.
$query = "SELECT COUNT(*) as c from dependency_xref_sentence WHERE gov_id = ".$row['gov_id']." AND relation_id = ".$row['relation_id'].";";
$r = mysql_query($query) or die("<b>A fatal MySQL error occured</b>.
$query = "SELECT * from relationship WHERE id = ".$rel_id.";";
$count = mysql_query($query) or die("<b>A fatal MySQL error occured</b>.
$query = "SELECT id, dep_count, gov_count, frequency from dependency WHERE relation_id = ".$rel_id.";";
$results = mysql_query($query) or die("<b>A fatal MySQL error occured</b>.
$query = "UPDATE dependency SET information =".log(($countBoth*$countRel)/($countDep*$countGov))." WHERE id = ".$id.";" ;
mysql_query($query) or die("<b>A fatal MySQL error occured</b>\n<br/> Query: " . $query . "\n<br/> Error: (" . mysql_errno() . ") ". mysql_error());
$query = " SELECT * from word WHERE pos NOT IN ('X', '-LRB-', '-RRB-', '.', ',');";
$result = mysql_query($query);
$query = "SELECT SUM(information) as i FROM dependency where gov_id = ".$row['id']." OR dep_id = ".$row['id']." AND information > 0;";
$r = mysql_query($query) or die("<b>A fatal MySQL error occured</b>\n<br/> Query: " . $query . "\n<br/> Error: (" . mysql_errno() . ") ". mysql_error());
$query = "UPDATE word SET information = ".$information." WHERE id = ".$row['id'].";" or die("<b>A fatal MySQL error occured</b>\n<br/> Query: " . $query . "\n<br/> Error: (" . mysql_errno() . ") ". mysql_error());
$r = mysql_query($query);
$GetID = "SELECT mp_username FROM memberprofile WHERE mp_fullname = '".$SearchName."' ";
$ResultID = mysql_query($GetID);
$GetPID = "SELECT us_id FROM user WHERE us_username = '".$SearchID."' ";
$ResultPID = mysql_query($GetPID);
if ($Result = mysql_query($Sql)) {
<?php
$result = mysql_query ("SELECT COUNT(`ga_whiteplayer`) AS cnt FROM `games` WHERE `ga_whiteplayer`= $Player2ID ");
<?php
$result = mysql_query ("SELECT COUNT(`ga_blackplayer`) AS bcnt FROM `games` WHERE `ga_blackplayer`=$Player2ID ");
<?php
$result = mysql_query ("SELECT COUNT(`ga_whiteplayer`) AS cnt FROM `games` WHERE `ga_whiteplayer`=$Player2ID AND `ga_gamemessage`='checkMate' AND `ga_messagefrom` = 'white'");
<?php
$result = mysql_query ("SELECT COUNT(`ga_blackplayer`) AS cnt FROM `games` WHERE `ga_blackplayer` =$Player2ID AND `ga_gamemessage`='checkMate' AND `ga_messagefrom` = 'black'");
<?php
$result = mysql_query ("SELECT COUNT(`ga_whiteplayer`) AS wcnt FROM `games` WHERE `ga_whiteplayer` =$Player2ID AND `ga_gamemessage`='checkMate' AND `ga_messagefrom` = 'black'");
mysql_select_db($this->BASE);
mysql_query("SET NAMES 'utf8'", $this->link);
case 4: $url = '/'.$params['lang'].'/pages/'.mysql_result(mysql_query("SELECT `head` FROM `objects` WHERE `id`='".$params['object_id']."' LIMIT 1"), 0, 'head').'.html'; break;
case 5: $url = '/'.$params['lang'].'/pages/'.mysql_result(mysql_query("SELECT `head` FROM `objects` WHERE `id`='".$params['object_id']."' LIMIT 1"), 0, 'head').'.html'; break;
case 8: $url = '/'.$params['lang'].'/news/'.$params['object_id'].'/'; break;
# Если лога сегодня нет к этому объекту
if (mysql_num_rows(mysql_query("SELECT `id` FROM `clogs` WHERE `object_id`='".$params['object_id']."' AND `day`='".date('Y-m-d')."' LIMIT 1")) == 0)
{
mysql_query("
return $this->mysql_query("INSERT INTO ".$table." (".join(", ", $str1).") VALUES (".join(", ", $str2).")");
'lang' => $lang_match[1],
'object_type' => mysql_result(mysql_query("SELECT `name` FROM `classes` WHERE `id`='$class_id'"), 0, 'name')
case 3: $atributes['url'] = '/'.$atributes['lang'].'/pages/'.$atributes['object_id'].'.html'; break;
case 4: $url = '/'.$params['lang'].'/pages/'.mysql_result(mysql_query("SELECT `head` FROM `objects` WHERE `id`='".$params['object_id']."' LIMIT 1"), 0, 'head').'.html'; break;
{
$muynuevos = mysql_query("SELECT (HOUR( TIMEDIFF('".date("Y-m-d H:i:s")."', UltimaRespuesta))) AS ur FROM usuario WHERE IDUsuario=".$elusuario);
$salida=$salida."\n"."\n<TD>\n";
$respuestas = mysql_query("SELECT * FROM respuesta where IDPregunta = ".$rowC['IDPregunta']);
$Qusuario = mysql_query("SELECT * FROM usuario WHERE EMail='".$Pemail."' AND AFavor=sha1('".$Pclav1."')");
}
$actualizar = mysql_query("UPDATE usuario SET Municipio=\"".$Pmunicipio."\" WHERE IDUsuario=".$usuario['IDUsuario']);
$actualizar = mysql_query("UPDATE usuario SET CP=\"".$Pcp."\" WHERE IDUsuario=".$usuario['IDUsuario']);
*/
$actualizar = mysql_query("UPDATE usuario SET UltimaRespuesta=\"".date("Y-m-d H-i-s")."\" WHERE IDUsuario=".$usuario['IDUsuario']);
echo "<br>Gracias por colaborar y tener una actitud responsable al ir al doctor<br>";
$actualizar = mysql_query("UPDATE usuario SET AlDoctor=0 WHERE IDUsuario=".$usuario['IDUsuario']);
// ___________________________________________________-----
$preguntas = mysql_query("SELECT * FROM relCuestPreg where IDCuestionario = ".$Pquest);
$Pemail = mysql_real_escape_string($datos_usuario[0]['proxied_email']);
$Qusuario = mysql_query("SELECT * FROM usuario WHERE EMail='".$Pemail."'");
{
$muynuevos = mysql_query("SELECT (HOUR( TIMEDIFF('".date("Y-m-d H:i:s")."', UltimaRespuesta))) AS ur FROM usuario WHERE IDUsuario=".$elusuario);
$preguntas = mysql_query("SELECT * FROM relCuestPreg where IDCuestionario = ".$numcuestionario." ORDER BY Orden");
}
$actualizar = mysql_query("UPDATE usuario SET Municipio=\"".$Pmunicipio."\" WHERE IDUsuario=".$usuario['IDUsuario']);
$actualizar = mysql_query("UPDATE usuario SET CP=\"".$Pcp."\" WHERE IDUsuario=".$usuario['IDUsuario']);
$actualizar = mysql_query("UPDATE usuario SET CP2=\"".$Pcp2."\" WHERE IDUsuario=".$usuario['IDUsuario']);
$actualizar = mysql_query("UPDATE usuario SET ENTRE1=\"".$Pentre1."\" WHERE IDUsuario=".$usuario['IDUsuario']);
$actualizar = mysql_query("UPDATE usuario SET ENTRE2=\"".$Pentre2."\" WHERE IDUsuario=".$usuario['IDUsuario']);
$actualizar = mysql_query("UPDATE usuario SET CALLE=\"".$Pcalle."\" WHERE IDUsuario=".$usuario['IDUsuario']);
*/
$insertar = mysql_query("INSERT into encuesta (IDUsuario,Fecha,IDCuestionario) VALUES (".$usuario['IDUsuario'].",\"".date("Y-m-d H-i-s")."\",".$Pquest.")");
mysql_select_db('citrus_store', $db);
mysql_query ("set character_set_client='cp1251'");
mysql_query ("set character_set_results='cp1251'");
mysql_query ("set collation_connection='cp1251_general_ci'");
AND (bise.IBLOCK_SECTION_ID=149 OR bise.IBLOCK_SECTION_ID=150 OR bise.IBLOCK_SECTION_ID=151 OR bise.IBLOCK_SECTION_ID=566))";
$result = mysql_query($sql, $db);
$sql2="SELECT * FROM b_catalog_price WHERE (CATALOG_GROUP_ID=4 AND PRODUCT_ID=".$r['ID'].")";
$result2 = mysql_query($sql2, $db);
$sql3="UPDATE b_catalog_price set PRICE=".$pr2." WHERE (CATALOG_GROUP_ID=4 AND PRODUCT_ID=".$r['ID'].")";
mysql_query($sql3, $db);
AND bise.IBLOCK_SECTION_ID=676)";
$result = mysql_query($sql, $db);
AND bise.IBLOCK_SECTION_ID=667)";
$result = mysql_query($sql, $db);
if (preg_match('/^utf8/', $this->getCollation())) {
mysql_query("SET NAMES 'utf8'", $db_con);
$sql = "SELECT val FROM " . $tbl . " WHERE k = '" .md5($k). "'";
$rs = mysql_query($sql, $this->getDBCon());
$sql = "SELECT val FROM " . $tbl . " WHERE k = '" .md5($k). "'";
$rs = mysql_query($sql, $this->getDBCon());
}
return mysql_query($sql, $con);
$tbl = $this->getTablePrefix() . 'setting';
return mysql_query("DELETE FROM " . $tbl . " WHERE k = '" . md5($k) . "'", $this->getDBCon());
/* lock */
$rs = mysql_query('LOCK TABLES ' . $this->getTablePrefix() . 'setting WRITE', $con);
$this->setSetting('query_queue', $queue);
mysql_query('UNLOCK TABLES', $con);
/* lock */
mysql_query('LOCK TABLES ' . $this->getTablePrefix() . 'setting WRITE', $con);
$result = mysql_query("SELECT * FROM classifieds WHERE ".
// Create a new record for this classified
$result = mysql_query($sql);
$result = mysql_query("DELETE FROM classifieds WHERE ".
// Check if we already have this one in the database
$check = mysql_query("SELECT COUNT(*) FROM userpicks WHERE ".
$result = mysql_query("DELETE FROM userpicks WHERE ".
$result = mysql_query("SELECT notes FROM usernotes WHERE ".
$check = mysql_query("SELECT COUNT(*) FROM usernotes WHERE ".
// Create a new record for this avatar note
$result = mysql_query("INSERT INTO usernotes VALUES ".
$peerlist_update = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'refresh_realtime_peerlist' LIMIT 1"),0,"field_data");
$queue_update = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'refresh_realtime_queue' LIMIT 1"),0,"field_data");
$server_hash_code = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'server_hash_code' LIMIT 1"),0,"field_data");
{
$max = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'max_active_peers' LIMIT 1"),0,"field_data");
$new = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'max_new_peers' LIMIT 1"),0,"field_data");
$domain = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'server_domain' LIMIT 1"),0,"field_data");
$subfolder = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'server_subfolder' LIMIT 1"),0,"field_data");
$port = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'server_port_number' LIMIT 1"),0,"field_data");
$trans_queue_hash = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'transaction_queue_hash' LIMIT 1"),0,"field_data");
$block_check_start = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'block_check_start' LIMIT 1"),0,"field_data");
$uptime = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'timekoin_start_time' LIMIT 1"),0,"field_data");
$request_max = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'server_request_max' LIMIT 1"),0,"field_data");
$allow_lan_peers = intval(mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'allow_LAN_peers' LIMIT 1"),0,"field_data"));
$loop_active = mysql_result(mysql_query("SELECT * FROM `main_loop_status` WHERE `field_name` = 'generation_heartbeat_active' LIMIT 1"),0,"field_data");
$sql = "UPDATE `main_loop_status` SET `field_data` = '1' WHERE `main_loop_status`.`field_name` = 'generation_heartbeat_active' LIMIT 1";
mysql_query($sql);
$sql_result = mysql_query($sql);
$sql = "DELETE FROM `generating_peer_list` WHERE `generating_peer_list`.`public_key` = '$public_key'";
mysql_query($sql);
$sql_result = mysql_query($sql);
{
$my_private_key = mysql_result(mysql_query("SELECT * FROM `my_keys` WHERE `field_name` = 'server_private_key' LIMIT 1"),0,"field_data");
// Has the server submitted it's currency generation to the transaction queue?
$found_public_key_my_queue = mysql_result(mysql_query("SELECT * FROM `my_transaction_queue` WHERE `attribute` = 'G' LIMIT 1"),0,"timestamp");
$found_public_key_trans_queue = mysql_result(mysql_query("SELECT * FROM `transaction_queue` WHERE `public_key` = '$my_public_key' AND `attribute` = 'G' LIMIT 1"),0,"timestamp");
$join_peer_list = mysql_result(mysql_query("SELECT * FROM `generating_peer_list` WHERE `public_key` = '$my_public_key' LIMIT 1"),0,"join_peer_list");
mysql_query("DELETE FROM $isearch_table_search_log", $isearch_db);
$result = mysql_query("SELECT * FROM $isearch_table_search_log ORDER BY id", $isearch_ro_db);
$result = mysql_query("SELECT alternative, redirect FROM $isearch_table_alts WHERE keyword='".isearch_escape_string($s)."'", $isearch_ro_db);
$quotedWords = isearch_find_suggestion($quotedWords);
$result = mysql_query("SELECT id FROM $isearch_table_urls WHERE words REGEXP ' " . $quotedWords . " '", $isearch_ro_db);
{
$result = mysql_query("SELECT id, score FROM $isearch_table_words WHERE SOUNDEX(word)${mysqlOp}SOUNDEX('" . isearch_escape_string($word) . "') ORDER BY score DESC LIMIT $maxResults", $isearch_ro_db);
{
$result = mysql_query("SELECT id, score FROM $isearch_table_words WHERE word$mysqlOp'" . isearch_escape_string($word) . "' ORDER BY score DESC LIMIT $maxResults", $isearch_ro_db);
{
$result = mysql_query("SELECT description FROM $isearch_table_urls WHERE id='$id'", $isearch_ro_db);
$result = mysql_query("SELECT stripped_body FROM $isearch_table_urls WHERE id='$id'", $isearch_ro_db);
<td><center><font color='orange' face='georgia'><b><small>» Action «</small></b></font></center></td></tr>";
$res = mysql_query("SELECT * FROM $table");
<td><center><font color='orange' face='georgia'><b><small>» Action «</small></b></font></center></td></tr>";
$res = mysql_query("SELECT * FROM $ftp_table");
$my_ip = htmlspecialchars(addslashes($_GET['ip']));
mysql_query("DELETE FROM $ftp_table WHERE ip = '$my_ip'");
<SELECT name='help_section' style='width:365px'>";
//$res = mysql_query("SELECT ip FROM $table");
if($ip && $port){
$res = mysql_query("SELECT ip FROM $table_erte_configuration");
if($total_entries > 0){
mysql_query("UPDATE $table_erte_configuration SET ip = '$ip', port = '$port'");
} else {
mysql_query("INSERT INTO $table_erte_configuration (ip, port) VALUES ('$ip', '$port')");
}
$res = mysql_query("SELECT name FROM $table");