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







  1. if ($installMode != 0) {
  2.     $rs = mysql_query("SELECT properties, disabled FROM $dbase.`" . $table_prefix . "site_plugins` WHERE name='Inherit Parent Template'");
  3.     $siteid = uniqid('');
  4.     mysql_query("REPLACE INTO $dbase.`" . $table_prefix . "system_settings` (setting_name,setting_value) VALUES('site_id','$siteid'),('manager_theme','MODxCarbon')", $sqlParser->conn);
  5.     // update site_id if missing
  6.     $ds = mysql_query("SELECT setting_name,setting_value FROM $dbase.`" . $table_prefix . "system_settings` WHERE setting_name='site_id'", $sqlParser->conn);
  7. 
                        
  8.             $rs = mysql_query("SELECT * FROM $dbase.`" . $table_prefix . "site_tmplvars` WHERE name='$name'", $sqlParser->conn);
  9.                 while($row = mysql_fetch_assoc($rs)) {
  10.                     if (!@ mysql_query("UPDATE $dbase.`" . $table_prefix . "site_tmplvars` SET type='$input_type', caption='$caption', description='$desc', category=$category, locked=$locked, elements='$input_options', display='$output_widget', display_params='$output_widget_params', default_text='$input_default' WHERE id={$row['id']};", $sqlParser->conn)) {
  11.                 $q = "INSERT INTO $dbase.`" . $table_prefix . "site_tmplvars` (type,name,caption,description,category,locked,elements,display,display_params,default_text) VALUES('$input_type','$name','$caption','$desc',$category,$locked,'$input_options','$output_widget','$output_widget_params','$input_default');";
  12.                 if (!@ mysql_query($q, $sqlParser->conn)) {
  13.                 // remove existing tv -> template assignments
  14.                 $ds=mysql_query("SELECT id FROM $dbase.`".$table_prefix."site_tmplvars` WHERE name='$name' AND description='$desc';",$sqlParser->conn);
  15.                 $id = $row["id"];
  16.                 mysql_query('DELETE FROM ' . $dbase . '.`' . $table_prefix . 'site_tmplvar_templates` WHERE tmplvarid = \'' . $id . '\'');

  1. if ($installMode != 0) {
  2.     $rs = mysql_query("SELECT properties, disabled FROM $dbase.`" . $table_prefix . "site_plugins` WHERE name='Inherit Parent Template'");
  3.     $siteid = uniqid('');
  4.     mysql_query("REPLACE INTO $dbase.`" . $table_prefix . "system_settings` (setting_name,setting_value) VALUES('site_id','$siteid'),('manager_theme','MODxCarbon')", $sqlParser->conn);
  5.     // update site_id if missing
  6.     $ds = mysql_query("SELECT setting_name,setting_value FROM $dbase.`" . $table_prefix . "system_settings` WHERE setting_name='site_id'", $sqlParser->conn);
  7. 
                        
  8.             $rs = mysql_query("SELECT * FROM $dbase.`" . $table_prefix . "site_tmplvars` WHERE name='$name'", $sqlParser->conn);
  9.                 while($row = mysql_fetch_assoc($rs)) {
  10.                     if (!@ mysql_query("UPDATE $dbase.`" . $table_prefix . "site_tmplvars` SET type='$input_type', caption='$caption', description='$desc', category=$category, locked=$locked, elements='$input_options', display='$output_widget', display_params='$output_widget_params', default_text='$input_default' WHERE id={$row['id']};", $sqlParser->conn)) {
  11.                 $q = "INSERT INTO $dbase.`" . $table_prefix . "site_tmplvars` (type,name,caption,description,category,locked,elements,display,display_params,default_text) VALUES('$input_type','$name','$caption','$desc',$category,$locked,'$input_options','$output_widget','$output_widget_params','$input_default');";
  12.                 if (!@ mysql_query($q, $sqlParser->conn)) {
  13.                 // remove existing tv -> template assignments
  14.                 $ds=mysql_query("SELECT id FROM $dbase.`".$table_prefix."site_tmplvars` WHERE name='$name' AND description='$desc';",$sqlParser->conn);
  15.                 $id = $row["id"];
  16.                 mysql_query('DELETE FROM ' . $dbase . '.`' . $table_prefix . 'site_tmplvar_templates` WHERE tmplvarid = \'' . $id . '\'');











  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());

Back to Top