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











  1.     { 
  2.     $res = @mysql_query("SELECT guid, name,mid(lpad( hex( CAST(substring_index(substring_index(data,' ',".(36+1)."),' ',-1) as unsigned) ),8,'0'),4,1) AS gender, data, race, class FROM `characters` WHERE guid='".mysql_real_escape_string($player)."' LIMIT 1;", $this->pvpdbconn); 
  3.     { 
  4.     $res = @mysql_query("SELECT guid, name,mid(lpad( hex( CAST(substring_index(substring_index(data,' ',".(36+1)."),' ',-1) as unsigned) ),8,'0'),4,1) AS gender, data, race, class FROM `characters` WHERE convert(name using utf8) COLLATE utf8_bin  = '".mysql_real_escape_string($player)."' LIMIT 1;", $this->pvpdbconn); 
  5.     { 
  6.     $res = @mysql_query("SELECT * FROM `guild` WHERE guildid='".mysql_real_escape_string($guild)."' LIMIT 1;", $this->pvpdbconn); 
  7.     { 
  8.     $res = @mysql_query("SELECT * FROM `guild` WHERE convert( name USING utf8 ) COLLATE utf8_bin = '".mysql_real_escape_string($guild)."' LIMIT 1;", $this->pvpdbconn); 
  9.     { 
  10.     $res = mysql_query("SELECT a.arenateamid, a.name,a.type,a.BackgroundColor,a.EmblemStyle,a.EmblemColor,a.BorderStyle,a.BorderColor, ats.rating, ats.rank, ats.games, ats.wins, ats.played, ats.wins2, c.race FROM `arena_team` a JOIN `arena_team_stats` ats on a.arenateamid = ats.arenateamid JOIN characters c ON c.guid = a.captainguid WHERE convert( a.name USING utf8 ) COLLATE utf8_bin = '".mysql_real_escape_string($team)."' LIMIT 1;", $this->pvpdbconn); 
  11. 	$this->SearchCharactersResults = array(); 
  12.     $res = mysql_query("SELECT c.race,c.class,mid(lpad( hex( CAST(substring_index(substring_index(data,' ',".(36+1)."),' ',-1) as unsigned) ),8,'0'),4,1) AS gender,CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) AS UNSIGNED) AS level,c.name, g.name as gname FROM `characters` c LEFT JOIN `guild_member` gm on gm.guid = c.guid LEFT JOIN `guild` g on g.guildid=gm.guildid WHERE c.name LIKE '".$this->searchstring."%';", $this->pvpdbconn); 
  13. 	$this->SearchCharactersResults = array(); 
  14.     $res = mysql_query("SELECT g.BackgroundColor,g.BorderStyle, g.EmblemColor, g.EmblemStyle, g.BorderColor, g.name, c.race FROM `guild` g JOIN characters c on g.leaderguid = c.guid WHERE g.name LIKE '".$this->searchstring."%';", $this->pvpdbconn); 
  15. 	
  16.     $res = @mysql_query("SELECT faction, standing FROM `character_reputation` WHERE `guid`='".$this->charid."' AND (flags & 1 = 1);", $this->pvpdbconn); 


  1. 
                        
  2. 		$this->assertTrue(mysql_query("INSERT INTO `hs_hr_customer` (`customer_id`, `name`, `description`, `deleted`) ".
  3.     				"VALUES (10, 'OrangeHRM', 'Implement OrangeHRM', 0)"));
  4.     	$this->assertTrue(mysql_query("INSERT INTO `hs_hr_project` (`project_id`, `customer_id`, `name`, `description`, `deleted`) ".
  5.     				"VALUES (10, 10, 'OrangeHRM', 'Implement OrangeHRM', 0)"));
  6.     	$this->assertTrue(mysql_query("INSERT INTO `hs_hr_timesheet_submission_period` (`timesheet_period_id`, `name`, `frequency`, `period`, `start_day`, `end_day`, `description`) ".
  7. 
                        
  8. 		$this->assertTrue(mysql_query("INSERT IGNORE INTO `hs_hr_project_activity`(activity_id, project_id, name) " .
  9. 				    "VALUES (10, 10, 'Test Activity')"));
  10.     	$this->assertTrue(mysql_query("INSERT INTO `hs_hr_timesheet` (`timesheet_id`, `employee_id`, `timesheet_period_id`, `start_date`, `end_date`, `status`) ".
  11.     				"VALUES (10, 10, 10, '".date('Y-m-d')."', '".date('Y-m-d', time()+3600*24*7)."', 0)"));
  12.     	$this->assertTrue(mysql_query("INSERT INTO `hs_hr_timesheet` (`timesheet_id`, `employee_id`, `timesheet_period_id`, `start_date`, `end_date`, `status`) ".
  13.     				"VALUES (11, 10, 10, '".date('Y-m-d', time()+3600*24*7)."', '".date('Y-m-d', time()+3600*24*7*2)."', 10)"));
  14.     	$this->assertTrue(mysql_query("INSERT INTO `hs_hr_timesheet` (`timesheet_id`, `employee_id`, `timesheet_period_id`, `start_date`, `end_date`, `status`) ".
  15.     				"VALUES (12, 10, 10, '".date('Y-m-d', time()+3600*24*7*2)."', '".date('Y-m-d', time()+3600*24*7*3)."', 20)"));







Back to Top