About 24,582 results: "mysql_query"
Page 4 of 50
Filter Results
Sources
Languages
Filter Results
Try Search On







  1. 	// Check last heartbeat and make sure it was more than X seconds ago
  2. 	$watchdog_heartbeat_active = mysql_result(mysql_query("SELECT * FROM `main_loop_status` WHERE `field_name` = 'watchdog_heartbeat_active' LIMIT 1"),0,"field_data");
  3. 	{
  4. 		mysql_query("UPDATE `main_loop_status` SET `field_data` = '" . time() . "' WHERE `main_loop_status`.`field_name` = 'watchdog_last_heartbeat' LIMIT 1");
  5. 		// Set loop at active now
  6. 		mysql_query("UPDATE `main_loop_status` SET `field_data` = '1' WHERE `main_loop_status`.`field_name` = 'watchdog_heartbeat_active' LIMIT 1");
  7. 	// Are we to remain active?
  8. 	$loop_active = mysql_result(mysql_query("SELECT * FROM `main_loop_status` WHERE `field_name` = 'watchdog_heartbeat_active' LIMIT 1"),0,"field_data");
  9. 		// Set the working status of 2
  10. 		mysql_query("UPDATE `main_loop_status` SET `field_data` = '2' WHERE `main_loop_status`.`field_name` = 'watchdog_heartbeat_active' LIMIT 1");
  11. //*****************************************************************************************************	
  12. 		$script_loop_active = mysql_result(mysql_query("SELECT * FROM `main_loop_status` WHERE `field_name` = 'main_heartbeat_active' LIMIT 1"),0,"field_data");
  13. 		$script_last_heartbeat = mysql_result(mysql_query("SELECT * FROM `main_loop_status` WHERE `field_name` = 'main_last_heartbeat' LIMIT 1"),0,"field_data");
  14. 
                        
  15. 
                        
  16. 		$script_loop_active = mysql_result(mysql_query("SELECT * FROM `main_loop_status` WHERE `field_name` = 'generation_heartbeat_active' LIMIT 1"),0,"field_data");
  17. 		$script_last_heartbeat = mysql_result(mysql_query("SELECT * FROM `main_loop_status` WHERE `field_name` = 'generation_last_heartbeat' LIMIT 1"),0,"field_data");











  1. 		if ($_REQUEST['topic']=='edit' AND $_SERVER['REQUEST_METHOD']!='POST') {
  2. 			$rowj=mysql_fetch_array(mysql_query("SELECT *, ft.title as title, ft.category as category, ft.image as image
  3. 						ORDER BY `id_post` ASC ", $MySQL_CON));
  4. 			$rowk=mysql_fetch_array(mysql_query("SELECT id_post FROM forum_posts WHERE id_topic='".$_REQUEST['t']."' ORDER BY `id_post` DESC LIMIT 0, 1", $MySQL_CON));
  5. 				if ($rowj['poll_question']!='') {
  6. 					$getvote = mysql_query("SELECT name FROM forum_rel_topics_polls WHERE id_topic='".$_REQUEST['t']."' ORDER by id_poll ASC", $MySQL_CON);
  7. 					if ($_POST['removepoll']=='1') { 
  8. 						mysql_query("DELETE FROM forum_rel_topics_polls WHERE id_topic='".$_REQUEST['t']."'", $MySQL_CON); 
  9. 						mysql_query("DELETE FROM forum_rel_account_polls WHERE id_topic='".$_REQUEST['t']."'", $MySQL_CON); 
  10. 						mysql_query("DELETE FROM forum_rel_account_polls WHERE id_topic='".$_REQUEST['t']."'", $MySQL_CON); 
  11. 						mysql_query("UPDATE forum_topics SET poll_question='', poll_lasts='0', poll_stamp='0000-00-00 00:00:00' WHERE id_topic='".$_REQUEST['t']."'", $MySQL_CON) OR DIE(mysql_error());
  12. 					} else {
  13. 						if (strlen($_POST['pollask'])>0) {
  14. 							$query =  mysql_query("UPDATE forum_topics SET poll_question='".$_POST["pollask"]."', poll_lasts='".$_POST["pollfor"]."' WHERE id_topic='".$_REQUEST['t']."'", $MySQL_CON) OR DIE(mysql_error());
  15. 								if (strlen($_POST['polloption'][$i])>0) {
  16. 									$query =  mysql_query("INSERT INTO forum_rel_topics_polls(id_topic, name) 


Back to Top