About 23,759 results: "mysql_query"
Page 15 of 50
Filter Results
Sources
Languages
Filter Results
Try Search On
  1. 				$query = "SELECT * FROM domain WHERE domain_id=$domainId";
  2. 				$result = mysql_query ($query) or die (errorMsgBlock(3006, $query, 'main', $DBName, $DBHost, $DBUserName, mysql_error()));
  3. 		$query = "SELECT domain_id FROM domain WHERE domain_name='$domainName'";
  4. 		$result = mysql_query ($query) or die (errorMsgBlock(3006, $query, 'main', $DBName, $DBHost, $DBUserName, mysql_error()));
  5. 		$query = "SELECT * FROM user where Login='$login'";
  6. 		$result = mysql_query ($query) or die (errorMsgBlock(3006, $query, 'main', $DBName, $DBHost, $DBUserName, mysql_error()));
  7. 				$query = "INSERT INTO user (Login, Password) VALUES ('$login', '$password')";
  8. 				$result = mysql_query ($query) or die (errorMsgBlock(3006, $query, 'main', $DBName, $DBHost, $DBUserName, mysql_error()));
  9. 				$query = "SELECT * FROM user WHERE Login='$login'";
  10. 				$result = mysql_query ($query) or die (errorMsgBlock(3006, $query, 'main', $DBName, $DBHost, $DBUserName, mysql_error()));
  11. 						$query = "INSERT INTO permission (UId, ClientApplication, ShardId, AccessPrivilege) VALUES ('".$row["UId"]."', '$clientApplication', -1, '$domainStatus')";
  12. 						$result = mysql_query ($query) or die (errorMsgBlock(3006, $query, 'main', $DBName, $DBHost, $DBUserName, mysql_error()));
  13. 							$query = "UPDATE permission set AccessPrivilege='".$permission['AccessPrivilege'].",$accessPriv' WHERE prim=".$permission['prim'];
  14. 							$result = mysql_query ($query) or die (errorMsgBlock(3006, $query, 'main', $DBName, $DBHost, $DBUserName, mysql_error()));
  15. //								$query = "update shard set NbPlayers=NbPlayers-1 where ShardId=".$row["ShardId"];
  16. //								$result = mysql_query ($query) or die ("Can't execute the query: '$query' errno:".mysql_errno().": ".mysql_error());

  1. GetSQLValueString($employid_emploeeRec, "int"));
  2. $emploeeRec = mysql_query($query_emploeeRec) 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) or die(mysql_error());
  5. $query_profSoc = sprintf("SELECT * FROM tblprofmembership WHERE employeeid = %s", GetSQLValueString($colname_profSoc, "int"));
  6. $profSoc = mysql_query($query_profSoc) or die(mysql_error());
  7. $query_teaching = sprintf("SELECT * FROM tblteaching WHERE employeeid = %s", GetSQLValueString($colname_teaching, "int"));
  8. $teaching = mysql_query($query_teaching) or die(mysql_error());
  9. $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"));
  10. $adminduties = mysql_query($query_adminduties) or die(mysql_error());
  11. //echo $query_localconferences; exit;
  12. $localconferences = mysql_query($query_localconferences) or die(mysql_error());
  13. $query_internationalconf = sprintf("SELECT * FROM tblconferences WHERE employeeid = %s AND tblconferences.conferencetype='international' ORDER BY datefrom DESC", GetSQLValueString($colname_internationalconf, "int"));
  14. $internationalconf = mysql_query($query_internationalconf) or die(mysql_error());
  15. $query_publications = sprintf("SELECT  tbljournalspublication.title, tbljournalspublication.journalname, tbljournalspublication.authors, tbljournalspublication.publicationdate, tbljournalspublication.url, tblpublictiontype.publictiontypeid, tblpublictiontype.eventoractivity FROM tbljournalspublication, tblpublictiontype WHERE tblpublictiontype.publictiontypeid=tbljournalspublication.typeid AND tbljournalspublication.employeeid=%s and typeid=1", GetSQLValueString($emplid_publications, "int"));
  16. $publications = mysql_query($query_publications) or die(mysql_error());

  1. 	{
  2. 		$result = @mysql_query($command,$_link);
  3. 
                        
  4. 	$result = @mysql_query("ALTER TABLE `".@mysql_real_escape_string($_prefix)."res` CHANGE `html` `value` longtext character set utf8 collate utf8_bin NOT NULL",$_link);
  5. 
                        
  6. 	$result = @mysql_query("ALTER TABLE `".@mysql_real_escape_string($_prefix)."res` ADD `size` bigint(20) unsigned NOT NULL default '0'",$_link);
  7. 	$sql = "CREATE TABLE `".@mysql_real_escape_string($_prefix)."predefined` (`id` int(11) unsigned NOT NULL,`internal_id` varchar(32) character set utf8 collate utf8_bin NOT NULL,`group_id` varchar(32) character set utf8 collate utf8_bin NOT NULL,`lang_iso` varchar(2) character set utf8 collate utf8_bin NOT NULL,`invitation` mediumtext character set utf8 collate utf8_bin NOT NULL,`welcome` mediumtext character set utf8 collate utf8_bin NOT NULL,`website_push` mediumtext character set utf8 collate utf8_bin NOT NULL,`browser_ident` tinyint(1) unsigned NOT NULL default '0',`is_default` tinyint(1) unsigned NOT NULL default '0', `auto_welcome` tinyint(1) unsigned NOT NULL default '0',PRIMARY KEY  (`id`)) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_bin;";
  8. 	$result = mysql_query($sql,$_link);
  9. 		{
  10. 			@mysql_query("INSERT INTO `".@mysql_real_escape_string($_prefix)."predefined` (`id` ,`internal_id`, `group_id` ,`lang_iso` ,`invitation` ,`welcome` ,`website_push` ,`browser_ident` ,`is_default` ,`auto_welcome`) VALUES ('".@mysql_real_escape_string($counter++)."', '', '".@mysql_real_escape_string($gid)."', 'EN', 'Hello, my name is %name%. Do you need help? Start Live-Chat now to get assistance.', 'Hello %external_name%, my name is %name%, how may I help you?', 'Website Operator %name% would like to redirect you to this URL:\r\n\r\n%url%', '1', '1', '1');",$_link);
  11. 			@mysql_query("INSERT INTO `".@mysql_real_escape_string($_prefix)."predefined` (`id` ,`internal_id`, `group_id` ,`lang_iso` ,`invitation` ,`welcome` ,`website_push` ,`browser_ident` ,`is_default` ,`auto_welcome`) VALUES ('".@mysql_real_escape_string($counter++)."', '', '".@mysql_real_escape_string($gid)."', 'DE', '".utf8_encode("Guten Tag, meine Name ist %name%. Benötigen Sie Hilfe? Gerne berate ich Sie in einem Live Chat")."', 'Guten Tag %external_name%, mein Name ist %name% wie kann ich Ihnen helfen?', '".utf8_encode("Ein Betreuer dieser Webseite (%name%) möchte Sie auf einen anderen Bereich weiterleiten:\\r\\n\\r\\n%url%")."', '1', '0', '1');",$_link);
  12. 		}
  13. 	$sql = "CREATE TABLE `".@mysql_real_escape_string($_prefix)."rooms` (`id` int(11) NOT NULL,`time` int(11) NOT NULL,`last_active` int(11) NOT NULL,`status` tinyint(1) NOT NULL default '0',`target_group` varchar(64) NOT NULL, PRIMARY KEY  (`id`)) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_bin;";
  14. 	$result = mysql_query($sql,$_link);
  15. 	$sql = "CREATE TABLE `".@mysql_real_escape_string($_prefix)."posts` (`id` varchar(32) character set utf8 collate utf8_bin NOT NULL,`time` int(10) unsigned NOT NULL default '0',`micro` int(10) unsigned NOT NULL default '0',`sender` varchar(32) character set utf8 collate utf8_bin NOT NULL,`receiver` varchar(32) character set utf8 collate utf8_bin NOT NULL,`receiver_group` varchar(32) character set utf8 collate utf8_bin NOT NULL,`text` mediumtext character set utf8 collate utf8_bin NOT NULL,`received` tinyint(1) unsigned NOT NULL default '0',`persistent` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY  (`id`)) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_bin;";
  16. 	$result = mysql_query($sql,$_link);



  1. 				$query = "SELECT * FROM domain WHERE domain_id=$domainId";
  2. 				$result = mysql_query ($query) or die (errorMsgBlock(3006, $query, 'main', $DBName, $DBHost, $DBUserName, mysql_error()));
  3. 		$query = "SELECT domain_id FROM domain WHERE domain_name='$domainName'";
  4. 		$result = mysql_query ($query) or die (errorMsgBlock(3006, $query, 'main', $DBName, $DBHost, $DBUserName, mysql_error()));
  5. 		$query = "SELECT * FROM user where Login='$login'";
  6. 		$result = mysql_query ($query) or die (errorMsgBlock(3006, $query, 'main', $DBName, $DBHost, $DBUserName, mysql_error()));
  7. 				$query = "INSERT INTO user (Login, Password) VALUES ('$login', '$password')";
  8. 				$result = mysql_query ($query) or die (errorMsgBlock(3006, $query, 'main', $DBName, $DBHost, $DBUserName, mysql_error()));
  9. 				$query = "SELECT * FROM user WHERE Login='$login'";
  10. 				$result = mysql_query ($query) or die (errorMsgBlock(3006, $query, 'main', $DBName, $DBHost, $DBUserName, mysql_error()));
  11. 						$query = "INSERT INTO permission (UId, ClientApplication, ShardId, AccessPrivilege) VALUES ('".$row["UId"]."', '$clientApplication', -1, '$domainStatus')";
  12. 						$result = mysql_query ($query) or die (errorMsgBlock(3006, $query, 'main', $DBName, $DBHost, $DBUserName, mysql_error()));
  13. 							$query = "UPDATE permission set AccessPrivilege='".$permission['AccessPrivilege'].",$accessPriv' WHERE prim=".$permission['prim'];
  14. 							$result = mysql_query ($query) or die (errorMsgBlock(3006, $query, 'main', $DBName, $DBHost, $DBUserName, mysql_error()));
  15. //								$query = "update shard set NbPlayers=NbPlayers-1 where ShardId=".$row["ShardId"];
  16. //								$result = mysql_query ($query) or die ("Can't execute the query: '$query' errno:".mysql_errno().": ".mysql_error());















Back to Top