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



  1. GetSQLValueString($employid_emploeeRec, "int"));
  2. $emploeeRec = mysql_query($query_emploeeRec, $cnpgdataport) or die(mysql_error());
  3. $query_confirmation = sprintf("SELECT effectivedate FROM tblconfirmation WHERE employeeid = %s", GetSQLValueString($colname_confirmation, "int"));
  4. $confirmation = mysql_query($query_confirmation, $cnpgdataport) or die(mysql_error());
  5. $query_positions = sprintf("SELECT * FROM tblpositionsheld WHERE employeeid = %s", GetSQLValueString($colname_positions, "int"));
  6. $positions = mysql_query($query_positions, $cnpgdataport) or die(mysql_error());
  7. $query_profSoc = sprintf("SELECT * FROM tblprofmembership WHERE employeeid = %s", GetSQLValueString($colname_profSoc, "int"));
  8. $profSoc = mysql_query($query_profSoc, $cnpgdataport) or die(mysql_error());
  9. $query_teaching = sprintf("SELECT * FROM tblteaching WHERE employeeid = %s", GetSQLValueString($colname_teaching, "int"));
  10. $teaching = mysql_query($query_teaching, $cnpgdataport) or die(mysql_error());
  11. $query_adminduties = sprintf("SELECT tbladminduty.dutylevel, tbladminduty.datefrom, tbladminduty.dateto, tbladminduty.institution, tbladmindutytype.dutyname  FROM tbladminduty, tbladmindutytype WHERE employeeid = %s AND tbladminduty.dutytype=tbladmindutytype.dutytypeid", GetSQLValueString($colname_adminduties, "int"));
  12. $adminduties = mysql_query($query_adminduties, $cnpgdataport) or die(mysql_error());
  13. //echo $query_localconferences; exit;
  14. $localconferences = mysql_query($query_localconferences, $cnpgdataport) or die(mysql_error());
  15. $query_internationalconf = sprintf("SELECT * FROM tblconferences WHERE employeeid = %s AND tblconferences.conferencetype='international' ORDER BY datefrom DESC", GetSQLValueString($colname_internationalconf, "int"));
  16. $internationalconf = mysql_query($query_internationalconf, $cnpgdataport) or die(mysql_error());




  1.     
  2.     mysql_query("DELETE FROM uts_pinfo WHERE id = $mplayer2") or die(mysql_error());
  3.     mysql_query("UPDATE uts_player SET pid = $mplayer1  WHERE pid = $mplayer2") or die(mysql_error());
  4.     mysql_query("UPDATE uts_weaponstats SET pid = $mplayer1  WHERE pid = $mplayer2") or die(mysql_error());
  5.     mysql_query("DELETE FROM uts_weaponstats WHERE pid = $mplayer2") or die(mysql_error());
  6.     mysql_query("DELETE FROM uts_weaponstats WHERE matchid='0' AND pid = '$mplayer1'") or die(mysql_error());
  7.     
  8.     $q_weaponstats = mysql_query("SELECT weapon, SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE pid = '$mplayer1'  GROUP BY weapon") or die(mysql_error());
  9.     while ($r_weaponstats = mysql_fetch_array($q_weaponstats)) {
  10.         mysql_query("INSERT INTO uts_weaponstats SET matchid='0', pid='$mplayer1',  weapon='${r_weaponstats['weapon']}', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysql_error());
  11.     }
  12.     mysql_query("UPDATE uts_match SET firstblood = $mplayer1  WHERE firstblood = $mplayer2") or die(mysql_error());
  13.     mysql_query("UPDATE uts_rank SET pid = $mplayer2 WHERE pid= $mplayer1") or die(mysql_error());
  14.     $sql_nrank = "SELECT SUM(time) AS time, pid, gid, AVG(rank) AS rank, AVG(prevrank) AS prevrank, SUM(matches) AS matches FROM uts_rank WHERE pid = $mplayer2 GROUP BY pid, gid";
  15.     $q_nrank = mysql_query($sql_nrank) or die(mysql_error());

  1. global $_REQUEST;
  2. if(!intval($exp)) $exp = mysql_result(mysql_query("SELECT pk_exp_id FROM md_exp WHERE exp_name = '".addslashes($exp)."'"),0);
  3. 	//create packrow in md_pack and generate pk_pack_id
  4. 	mysql_query($apa = "INSERT INTO md_pack(fk_draft_id, fk_exp_id, pack_number, fk_user_id, seat_number, pack_type) SELECT '$draft_id', pk_exp_id, '$pack_number', '$user_id', '$seat_number', '$pack_type' FROM md_exp WHERE pk_exp_id = '$exp'");
  5. 		//reg cards
  6. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) 
  7. 		
  8. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) SELECT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'C' AND card_color = 'B' AND card_type NOT LIKE 'Basic Land%' ORDER BY rand() LIMIT 1");
  9. 		$cq_result = mysql_query("SELECT fk_card_id FROM md_packcard WHERE pk_packcard_id = ".mysql_insert_id());
  10. 		$cq_values = mysql_fetch_array($cq_result);
  11. 		$c1 = $cq_values[fk_card_id];
  12. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) SELECT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'C' AND card_color = 'R' AND card_type NOT LIKE 'Basic Land%' ORDER BY rand() LIMIT 1");
  13. 		$cq_result = mysql_query("SELECT fk_card_id FROM md_packcard WHERE pk_packcard_id = ".mysql_insert_id());
  14. 		$cq_values = mysql_fetch_array($cq_result);
  15. 		$c2 = $cq_values[fk_card_id];
  16. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) SELECT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'C' AND card_color = 'U' AND card_type NOT LIKE 'Basic Land%' ORDER BY rand() LIMIT 1");
  17. 		$cq_result = mysql_query("SELECT fk_card_id FROM md_packcard WHERE pk_packcard_id = ".mysql_insert_id());







  1. 		{
  2. 		$query=mysql_query("select * from {$pref}db_{$modul} where id={$_POST['pid']} $home_parent limit 1");
  3. 		while ($parid<>0) {
  4. 			$parid=mysql_result(mysql_query("select * from {$pref}db_{$modul} where id=$parid $home_parent "),0, 'pid');
  5. 		// $parent=$parent2;
  6. 		if (mysql_num_rows(mysql_query("select * from {$pref}db_{$modul} where id={$id} $home_parent limit 1"))==0) {die();}
  7. 
                        
  8. 		mysql_query("delete from {$pref}db_structure_alias where id_type=$id_modules and id_el={$id}");
  9. 		if (intval(mysql_num_rows(mysql_query("select * from {$pref}db_structure_alias where href='{$href}'")))>0)
  10. 		$mes_er="<font><b class='saveinfo'>Ошибка создания алиаса</b></font>";
  11. 		else
  12. 		mysql_query("insert into {$pref}db_structure_alias set href='{$href}',id_page='{$id}',id_type={$id_modules},id_el={$id}");
  13. 
                        
  14. 		$mes="<font color='green'><b class='saveinfo'>Сохранено</b></font>";
  15. 		mysql_query("update {$pref}db_{$modul} set href='{$href}',alias='{$name}',anons='{$anons}',title='{$title}',name='{$fname}',error='{$error}',menu_name='{$mname}',`description`='{$descr}',`keyword`='{$key_w}',text='{$text}',pid='{$pid}',parent='{$parent}',type='{$typ}',menu1='{$menu1}',menu2='{$menu2}',menu3='{$menu3}',menu4='{$menu4}',menu4_par='{$menu4_par}',catalog='{$catalog}',materials='{$materials}',catalog2='{$banners1}',materials2='{$banners2}',menu='{$banners3}',access_admin='{$access_admin}',access_moder='{$access_moder}',access_user='{$access_user}',access_notuser='{$access_notuser}',tpl='{$tpl}',status='{$status}' where id='{$id}'  $home_parent ");




  1. 
                        
  2. 		mysql_query("INSERT INTO `hs_hr_leavetype` VALUES ('LTY010', 'Medical', 1)");
  3. 		mysql_query("INSERT INTO `hs_hr_leavetype` VALUES ('LTY011', 'Casual', 1)");
  4. 		mysql_query("INSERT INTO `hs_hr_leavetype` VALUES ('LTY012', 'Annual', 0)");
  5. 
                        
  6. 		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);");
  7. 		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);");
  8. 
                        
  9. 		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);");
  10. 
                        
  11. 		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);");
  12. 		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);");
  13. 
                        
  14. 		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')");
  15. 		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')");

Back to Top