About 23,759 results: "mysql_query"
Page 8 of 50
Filter Results
Sources
Languages
Filter Results
Try Search On


  1. /*						echo $ins_user_det = "insert into user_details(`user_id`, `first_name`,`last_name`,`dob`,`email`) values('".$userId."','".$this->data['User']['first_name']."','".$this->data['User']['last_name']."','".$this->data['User']['dob']."','".$this->data['User']['email']."')";exit();
  2. */						$res_det = mysql_query($updatUserDet);
  3. 					$sql = "update `users` set `user_status` = '1' where `id` ='".$value."'";
  4. 					$res = mysql_query($sql);
  5. 		$qry="update `users` set `user_status`='1' where `id`='".$_REQUEST['id']."'";
  6. 		$res=mysql_query($qry);
  7. 				
  8. 				$userSave = mysql_query("insert into users(id, username, password, user_group_master_id, user_status) values('', '".$this->data['User']['username']."', '".base64_encode($this->data['User']['password'])."', '".$this->data['User']['user_group_master_id']."', '".$this->data['User']['user_status']."')");
  9. 					$qry = "INSERT INTO `user_details` ( `id` , `user_id`, `first_name`, `last_name`, `email`, `dob`, `c_id` )VALUES ('',".$id.",'".$fname."','".$lname."','".$email."', '".$dob."', ".$_REQUEST['country'].")" ;
  10. 					if($res = mysql_query($qry))
  11. 				$usrqry = "insert into users(id, username, password, user_group_master_id, user_status) values('', '".$this->data['User']['username']."', '".base64_encode($this->data['User']['password'])."', ".$this->data['User']['user_group_master_id'].", '".$this->data['User']['user_status']."')";
  12. 				$userSave = mysql_query($usrqry);
  13. 					echo $qry = "INSERT INTO `user_details` ( `id` , `user_id`, `first_name`, `last_name`, `email`, `dob`, `c_id` )VALUES ('',".$id.",'".$fname."','".$lname."','".$email."', '".$dob."', ".$_REQUEST['country'].")" ;
  14. 					if($res = mysql_query($qry))
  15. 				//echo $sql = "delete from `users` where `id` = '".$value."'";exit();
  16. 				$res = mysql_query($sql);












  1. 	//make draft_name
  2. 	$draft_name_result = mysql_query("SELECT exp_shortname FROM md_exp WHERE pk_exp_id = $pack1 UNION ALL SELECT exp_shortname FROM md_exp WHERE pk_exp_id = $pack2 UNION ALL SELECT exp_shortname FROM md_exp WHERE pk_exp_id = $pack3");
  3. 	//insert data for now
  4. 	mysql_query("INSERT INTO md_draft(draft_password, draft_is_tournament, draft_name, max_players, show_picks, draft_speed, pack_1, pack_2, pack_3) VALUES('$password', $tour_after, '$draft_name', $max_players, $show_picks, $speed, $pack1, $pack2, $pack3)");
  5. 	//join player (as seat #1, "the Creator")
  6. 	mysql_query("INSERT INTO md_draft2user(fk_draft_id, fk_user_id, seat_number) VALUES(".$draft_id.", $_SESSION[md_userid], 1)");
  7. 	//ett welcome-chat-message frŒn mdboten
  8. 	mysql_query("INSERT INTO md_chat (fk_draft_id, fk_user_id, chat_message, chat_date)
  9. 		//insert data for now
  10. 		$sealed_name = mysql_result(mysql_query("SELECT exp_shortname FROM md_exp WHERE pk_exp_id = $tourpack"),0);
  11. 		mysql_query("INSERT INTO md_draft(draft_name, max_players, draft_status, pack_1, pack_2, pack_3, draft_start, draft_is_sealed) VALUES('Sealed $sealed_name', 1, 3, '$tourpack', '$boosterpack1', '$boosterpack2', NOW(), 1)");
  12. 		$draft_id = mysql_insert_id();
  13. 		//join player
  14. 		mysql_query("INSERT INTO md_basicland (fk_user_id, fk_draft_id) VALUES ($_SESSION[md_userid], $draft_id)");
  15. 		mysql_query("INSERT INTO md_draft2user(fk_draft_id, fk_user_id) VALUES('$draft_id', $_SESSION[md_userid])");




  1. 
                        
  2. 				if ($query = mysql_query('SELECT `id` FROM `' . $this->options['prefix'][0] . 'cache_data` WHERE `id` = ' . $feed_id, $this->mysql))
  3. 
                        
  4. 						if (!mysql_query($sql, $this->mysql))
  5. 					}
  6. 					elseif (!mysql_query('INSERT INTO `' . $this->options['prefix'][0] . 'cache_data` (`id`, `items`, `data`, `mtime`) VALUES(' . $feed_id . ', ' . count($prepared[1]) . ', \'' . mysql_real_escape_string($prepared[0]) . '\', ' . time() . ')', $this->mysql))
  7. 
                        
  8. 								if (!mysql_query('INSERT INTO `' . $this->options['prefix'][0] . 'items` (`feed_id`, `id`, `data`, `posted`) VALUES(' . $feed_id . ', \'' . mysql_real_escape_string($new_id) . '\', \'' . mysql_real_escape_string(serialize($prepared[1][$new_id]->data)) . '\', ' . $date . ')', $this->mysql))
  9. 			}
  10. 			elseif ($query = mysql_query('SELECT `id` FROM `' . $this->options['prefix'][0] . 'cache_data` WHERE `id` = ' . $feed_id, $this->mysql))
  11. 	{
  12. 		if ($this->mysql && ($query = mysql_query('SELECT `mtime` FROM `' . $this->options['prefix'][0] . 'cache_data` WHERE `id` = \'' . mysql_real_escape_string($this->id) . "'", $this->mysql)) && ($row = mysql_fetch_row($query)))
  13. 	{
  14. 		if ($this->mysql && ($query = mysql_query('UPDATE `' . $this->options['prefix'][0] . 'cache_data` SET `mtime` = ' . time() . ' WHERE `id` = \'' . mysql_real_escape_string($this->id) . "'", $this->mysql)) && mysql_affected_rows($this->mysql))
  15. 	{
  16. 		if ($this->mysql && ($query = mysql_query('DELETE FROM `' . $this->options['prefix'][0] . 'cache_data` WHERE `id` = \'' . mysql_real_escape_string($this->id) . "'", $this->mysql)) && ($query2 = mysql_query('DELETE FROM `' . $this->options['prefix'][0] . 'items` WHERE `feed_id` = \'' . mysql_real_escape_string($this->id) . "'", $this->mysql)))


Back to Top