8 {

9 $query="SELECT userid FROM users WHERE 1";

10 $result = mysql_query($query);

11

12 //global $useriddata;

20 function showDormantUsers() {

21 $query = "SELECT DISTINCT userid,username FROM users WHERE isAdmin = 0 AND isAssigned = 1 AND isMember = 0 AND userid NOT IN (SELECT iduser FROM logins WHERE DATEDIFF(CURDATE(), time) < 30)";

22 $result = mysql_query($query);

23 global $dormantData;

24 while ($row = mysql_fetch_object($result)) {

29 function showUnvalidUsers() {

30 $query = "SELECT DISTINCT u.userid,u.username FROM users AS u JOIN validation AS v ON u.userid = v.id WHERE u.isAdmin = 0 AND u.isValidated = 0 AND DATEDIFF(CURDATE(), v.timestamp) > 30";

31 $result = mysql_query($query);

32 global $unvalidData;

33 while ($row = mysql_fetch_object($result)) {

45 {

46 $sql = "SELECT * FROM easysms WHERE carrierEmail = '".$results->ID."'";

47 $result1 = mysql_query($sql);

48 $num_rows = mysql_num_rows($result1);

49 if($num_rows == 0){$num_rows = 'None';}

78 $sms_domain = str_replace('@', '', $_POST['sms_carrier_email']);

79 $sql = "SELECT * FROM easysms_carriers WHERE carrierName = '".$_POST['sms_carrier_name']."'";

80 $result = mysql_query($sql);

81 $num_rows = mysql_num_rows($result);

82 $sql1 = "SELECT * FROM easysms_carriers WHERE carrierEmail = '".$sms_domain."'";

83 $result1 = mysql_query($sql1);

84 $num_rows1 = mysql_num_rows($result1);

85

19 ERROR - 2016-01-20 12:20:54 --> Severity: 8192 --> mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead /usr/home/astfou/domains/astral-foundations.com/public_html/system/database/drivers/mysql/mysql_driver.php 135

20 ERROR - 2016-01-20 12:20:54 --> Severity: error --> Exception: Configured database connection is persistent. Aborting. /usr/home/astfou/domains/astral-foundations.com/public_html/system/libraries/Session/drivers/Session_database_driver.php 94

21 ERROR - 2016-01-20 12:37:40 --> Severity: 8192 --> mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39

22 ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39

23 ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_query(): A link to the server could not be established /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39

24 ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_fetch_array() expects parameter 1 to be resource, boolean given /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 40

25 ERROR - 2016-01-20 12:40:19 --> Severity: 8192 --> mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39

26 ERROR - 2016-01-20 12:40:19 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39

27 ERROR - 2016-01-20 12:40:19 --> Severity: Warning --> mysql_query(): A link to the server could not be established /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39

28 ERROR - 2016-01-20 12:40:19 --> Severity: Warning --> mysql_fetch_array() expects parameter 1 to be resource, boolean given /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 40

29 ERROR - 2016-01-20 12:40:55 --> Severity: 8192 --> mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39

30 ERROR - 2016-01-20 12:40:55 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39

6 foreach($_POST AS $key => $value) { $_POST[$key] = mysql_real_escape_string($value); }

7 $sql = "UPDATE `opportunities` SET `AccountId` = '{$_POST['AccountId']}' , `Amount` = '{$_POST['Amount']}' , `CampaignId` = '{$_POST['CampaignId']}' , `CloseDate` = '{$_POST['CloseDate']}' , `CreatedById` = '{$_POST['CreatedById']}' , `CreatedDate` = '{$_POST['CreatedDate']}' , `CurrentGenerators__c` = '{$_POST['CurrentGenerators__c']}' , `DeliveryInstallationStatus__c` = '{$_POST['DeliveryInstallationStatus__c']}' , `Description` = '{$_POST['Description']}' , `ExpectedRevenue` = '{$_POST['ExpectedRevenue']}' , `Fiscal` = '{$_POST['Fiscal']}' , `FiscalQuarter` = '{$_POST['FiscalQuarter']}' , `FiscalYear` = '{$_POST['FiscalYear']}' , `ForecastCategory` = '{$_POST['ForecastCategory']}' , `ForecastCategoryName` = '{$_POST['ForecastCategoryName']}' , `HasOpportunityLineItem` = '{$_POST['HasOpportunityLineItem']}' , `IsClosed` = '{$_POST['IsClosed']}' , `IsDeleted` = '{$_POST['IsDeleted']}' , `IsPrivate` = '{$_POST['IsPrivate']}' , `IsWon` = '{$_POST['IsWon']}' , `LastActivityDate` = '{$_POST['LastActivityDate']}' , `LastModifiedById` = '{$_POST['LastModifiedById']}' , `LastModifiedDate` = '{$_POST['LastModifiedDate']}' , `LeadSource` = '{$_POST['LeadSource']}' , `MainCompetitors__c` = '{$_POST['MainCompetitors__c']}' , `Name` = '{$_POST['Name']}' , `NextStep` = '{$_POST['NextStep']}' , `OrderNumber__c` = '{$_POST['OrderNumber__c']}' , `OwnerId` = '{$_POST['OwnerId']}' , `Pricebook2Id` = '{$_POST['Pricebook2Id']}' , `Probability` = '{$_POST['Probability']}' , `StageName` = '{$_POST['StageName']}' , `SystemModstamp` = '{$_POST['SystemModstamp']}' , `TotalOpportunityQuantity` = '{$_POST['TotalOpportunityQuantity']}' , `TrackingNumber__c` = '{$_POST['TrackingNumber__c']}' , `Type` = '{$_POST['Type']}' WHERE `id` = '$id' ";

8 mysql_query($sql) or die(mysql_error());

9 echo (mysql_affected_rows()) ? "Edited row.<br />" : "Nothing changed. <br />";

10 echo "<a href='list.php'>Back To Listing</a>";

11 }

12 $row = mysql_fetch_array ( mysql_query("SELECT * FROM `opportunities` WHERE `id` = '$id' "));

13 ?>

14

22 global $website;

23

24 $albumcount = mysql_result(mysql_query("SELECT COUNT(DISTINCT `user_id`) FROM `cms_album_files` WHERE `website` = '$website'"), 0);

25 $photocount = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` WHERE `website` = '$website'"), 0);

26 $newcount = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` where `website` = '$website' AND `time` > '" . (time() - 259200) . "' AND `access` > '1'"), 0);

27 return $albumcount . '&#160;/&#160;' . $photocount . ($newcount ? '&#160;/&#160;<span class="red"><a href="' . core::$system_set['homeurl'] . '/users/album.php?act=top">+' . $newcount . '</a></span>' : '');

28 }

37 global $website;

38

39 $total = mysql_result(mysql_query("SELECT COUNT(*) FROM `download` where `website` = '$website' AND `type` = 'file'"), 0);

40 $new = mysql_result(mysql_query("SELECT COUNT(*) FROM `download` where `website` = '$website' AND `time` > '" . (time() - 259200) . "' AND `type` = 'file'"), 0);

53 global $website;

54

55 $total_thm = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` where `website` = '$website' AND `type` = 't'" . (core::$user_rights >= 7 ? "" : " AND `close` != '1'")), 0);

56 $total_msg = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` where `website` = '$website' AND `type` = 'm'" . (core::$user_rights >= 7 ? "" : " AND `close` != '1'")), 0);

15 global $c;

16 $is =

17 mysql_query(

18 "SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid",

19 $c) or die(mysql_error());

67 <table width=75%><tr style='background:gray'> <th>Pos</th> <th>User</th> <th>Level</th> </tr>";

68 $q =

69 mysql_query(

70 "SELECT u.* FROM users u WHERE u.user_level != 0 ORDER BY level DESC,userid ASC LIMIT 20",

71 $c);

97 <table width=75%><tr style='background:gray'> <th>Pos</th> <th>User</th> <th>Money</th> </tr>";

98 $q =

99 mysql_query(

100 "SELECT u.* FROM users u WHERE u.user_level != 0 ORDER BY money DESC,userid ASC LIMIT 20",

101 $c);

38

39 $sql = "SELECT * FROM CMS_ONLINE_RESOURCES".$orderByQuery.$limitQuery;

40 $result = MYSQL_QUERY($sql);

41 $numberOfRows = MYSQL_NUM_ROWS($result);

42

14

15 $sqlUpdate = "UPDATE CMS_GROUPUSERS SET GROUP_ID = '$thisGROUP_ID' , USER_ID = '$thisUSER_ID' , GROUPUSER_FLAGS = '$thisGROUPUSER_FLAGS' WHERE GROUP_ID = '$thisGROUP_ID'";

16 $resultUpdate = MYSQL_QUERY($sqlUpdate);

17 echo "<b>Record with Id ".$thisGROUP_IDFromForm." has been Updated<br></b>";

18 $thisGROUP_IDFromForm = "";

27

28 $sqlInsert = "INSERT INTO CMS_GROUPUSERS (GROUP_ID , USER_ID , GROUPUSER_FLAGS ) VALUES ('$thisGROUP_ID' , '$thisUSER_ID' , '$thisGROUPUSER_FLAGS' )";

29 $resultInsert = MYSQL_QUERY($sqlInsert);

30 echo "<b>Record has been inserted in Database<br></b>";

31 $thisGROUP_IDFromForm = "";

40

41 $sqlDelete = "DELETE FROM CMS_GROUPUSERS WHERE GROUP_ID = '$thisGROUP_ID'";

42 $resultDelete = MYSQL_QUERY($sqlDelete);

43

44 echo "<b>Record with Id ".$thisGROUP_IDFromForm." has been Deleted<br></b>";

38

39 $sql = "SELECT * FROM CMS_OFFLINE_RESOURCES".$orderByQuery.$limitQuery;

40 $result = MYSQL_QUERY($sql);

41 $numberOfRows = MYSQL_NUM_ROWS($result);

42

132 //guardar path imatge a bbdd

133 //echo "<br>update ".$mPars['taulaProductes']." set imatge='".$nomImatge."' where id='".$idProducte."' AND llista_id='".$mPars['selLlistaId']."'";

134 if(!$result=mysql_query("update ".$mPars['taulaProductes']." set imatge='".$nomImatge."' where id='".$idProducte."' AND llista_id='".$mPars['selLlistaId']."'",$db))

135 {

136 //echo "<br> 136 upload.php ".mysql_errno() . ": " . mysql_error(). "\n";

265

266 //guardar path imatge a bbdd

267 if(!$result=mysql_query("update vehicles set imatge='".$nomImatge."' where id='".$idVehicle."'",$db))

268 {

269 //echo "<br> 77. upload.php ".mysql_errno() . ": " . mysql_error(). "\n";

24 $query = "UPDATE assignment SET AssnName='$assnName', GroupWork='$groupWork', MaxMark='$maxMark', AvgMark='$avgMark', MedianMark='$medianMark', CourseID='$courseID', DueTime=FROM_UNIXTIME('$dueTime') WHERE AssnID='$assnID'";

25

26 if (!mysql_query($query, $mysqlConnection))

27 {

28 die ('Error: ' . mysql_error());

46 $query = "UPDATE automarking SET SampleSoln='$sampleSoln', Configs='$configs', AssnID='$assnID' WHERE AutomarkID='$automarkID'";

47

48 if (!mysql_query($query, $mysqlConnection))

49 {

50 die ('Error: ' . mysql_error());

66

67 $query = "SELECT * FROM `course` WHERE CourseName = '$courseName' AND SemesterName = '$semesterName '";

68 $result = mysql_query($query) or die(mysql_error());

69 if($row = mysql_fetch_array($result)) //if we did return a record

70 {

33 sort_order ASC,

34 subcategory_name ASC';

35 $rs = @mysql_query($sql, $connection) or die("Couldn't execute category query: ".mysql_error());

36 while ( $row = mysql_fetch_array($rs) )

37 {

97 ORDER BY

98 '.TABLE_MEMBER.'.business_name';

99 $resultp = @mysql_query($sqlp, $connection) or die("Couldn't execute query 2.");

100 while ( $row = mysql_fetch_array($resultp) )

101 {

127 product_name ASC,

128 unit_price ASC';

129 $result = @mysql_query($sql, $connection) or die("Couldn't execute search query: " . mysql_error());

130 while ( $row = mysql_fetch_array($result) )

131 {

33

34 /**

35 * @var Mysql_Query

36 */

37 protected $_query;

313 /**

314 *

315 * @return Main_Mysql_Query object

316 */

317 public function _getQuery()

318 {

319 if(!$this->_query) {

320 $this->_query = new Main_Mysql_Query();

321 }

322 return $this->_query;

27 <?php

28

29 $result=mysql_query("select lgumunicipality, lguprovince, lguoffice from ebpls_buss_preference") or die(mysql_error());

30 $resulta=mysql_fetch_row($result);

31

125

126 // unang gawang tama

127 $result=mysql_query("select ' ', ' ', ' ' , ' ', ' '

128 from ebpls_business_enterprise") or die(mysql_error());

129 while ($resulta=mysql_fetch_row($result)){

130

131 /* sample/test ko lng

132 $result=mysql_query("select a.owner_id, a.business_name, a.business_city_code, a.business_type_code,

133 a.business_street, a.business_capital_investment, a.business_last_yrs_dec_gross_sales, b.fee_amount,

134 b.input_date from ebpls_business_enterprise a, ebpls_fees_paid b where a.owner_id = b.owner_id and

25 mysql_select_db($dbname, $con);

26

27 mysql_query("UPDATE user set password='$newpassword' where fsuid='$fsuid'");

28 }

29

38 mysql_select_db($dbname, $con);

39

40 $result = mysql_query("SELECT * from user WHERE fsuid='$username' AND password='$password'");

41 $arr=array();

42 while($row = mysql_fetch_array($result))

103 }

104

105 $result = mysql_query($query);

106 $arr=array();

107 while($row = mysql_fetch_array($result))

150 $errorvalue = urlencode($value);

151 $value = mysql_real_escape_string($errorvalue);

152 mysql_query("INSERT INTO panel(userid,rss,posx,posy,sizex,sizey,themeid,minimized) VALUES ('$userid','$value','$posx','$posy','$sizex','$sizey','$themeid','$minimized')");

153 $rows = mysql_affected_rows();

154 if($rows != -1){

170 {

171 $feed = mysql_real_escape_string(urlencode($feed));

172 $rssCheck = mysql_query("DELETE FROM panel WHERE userid='$userid' AND rss='$feed'");

173 $rssCheckTheme = mysql_query("DELETE FROM theme WHERE userid='$userid' AND rss='$feed'");

192 //Get it so it matches the database

193 $feed = mysql_real_escape_string(urlencode($rss[0]));

194 if(mysql_query("UPDATE panel SET posx='$posx',posy='$posy', sizex='$sizex' , sizey='$sizey' WHERE userid='$userid' AND rss='$feed'")){

195 successMessage('');

196 }

208 $panelTheme = "AND rss='".urlencode($rss[0])."'";

209 }

210 $getRSS = mysql_query("SELECT * FROM panel WHERE userid='$userid' $panelTheme");

211 $rssarr = array();

212 while ($row = mysql_fetch_assoc($getRSS))

115 public function query($query)

116 {

117 $result = mysql_query($query, $this->link);

118

119 $this->result = $result;

83 //echo("SQL ($dbLink, $post) : $sqlSelect<BR>");

84

85 $res = mysql_query( $sqlSelect, $dbLink );

86

87 if ( $res ) {

110 //echo "SQL $sqlSelect<BR>";

111

112 $res = mysql_query( $sqlSelect, $dbLink );

113

114 if ( $res ) {

138 //echo "SQL $sqlSelect<BR>";

139

140 $res = mysql_query( $sqlSelect, $dbLink );

141

142 if ( $res ) {

43 // $SQL = "SELECT * FROM $table_name WHERE $clause";

44 // //echo $SQL;die();

45 // $result = mysql_query($SQL);

46 // mysql_close($db_handle);

47

69 // $SQL = "SELECT * FROM $table_name WHERE $clause";

70 //echo $SQL;die();

71 // $result = mysql_query($SQL);

72 // mysql_close($db_handle);

73

95 // $SQL = "SELECT * FROM $table_name WHERE $clause ORDER BY $order";

96 // echo $SQL;die();

97 // $result = mysql_query($SQL);

98 // mysql_close($db_handle);

99

13

14 $req_nav = "SELECT COUNT(logiciel) AS user_agent_total FROM ".lire_config("spongespip/prefixe")."_statistiques WHERE $format_date_sql and logiciel!='';";

15 $nb_nav_total = @mysql_result(mysql_query($req_nav),0,"user_agent_total");

16

17 $req_browser = @mysql_query("SELECT logiciel,COUNT(logiciel) AS nbref FROM ".lire_config("spongespip/prefixe")."_statistiques WHERE $format_date_sql AND type_logiciel!=2 GROUP BY logiciel ORDER BY nbref DESC;");

40 if($logiciel != 'unknown' || $logiciel != 'safari')

41 {

42 $req_browser_version = @mysql_query("SELECT version,COUNT(version) AS nbref FROM ".lire_config("spongespip/prefixe")."_statistiques WHERE $format_date_sql AND type_logiciel != '2' AND logiciel='$logiciel' AND version != '0' GROUP BY version ORDER BY nbref DESC;");

43

44 $ivers = 0;

93

94

95 $req_browser = mysql_query("SELECT logiciel,COUNT(logiciel) AS nbref FROM ".lire_config("spongespip/prefixe")."_statistiques WHERE $format_date_sql AND type_logiciel=2 GROUP BY logiciel ORDER BY nbref DESC;");

96

97

44 include('conexion.inc.php');

45 $sql = "INSERT INTO registros VALUES('','$_POST[titulo]','$_POST[textoIntroduccion]','$_POST[textoCompleto]')";

46 $consulta = mysql_query($sql) or die(mysql_error());

47 echo 'El registro a sido guardado exitosamente';

48 include('cconexion.inc.php');

75 include('conexion.inc.php');

76 $sql = "DELETE FROM registros WHERE registro_id = '$_POST[registro_id]'";

77 $consulta = mysql_query($sql) or die(mysql_error());

78 echo 'El registro a sido eliminado exitosamente';

79 include('cconexion.inc.php');

91 include('controles/conexion.php');

92 $sql = "SELECT * FROM usuarios";

93 $consulta = mysql_query($sql) or die(mysql_error());

94 while($resultados = mysql_fetch_array($consulta)){

95 echo '

54 <tbody>

55 <?php $std_row="select * from student ORDER BY STUD_NO DESC";

56 $q=mysql_query($std_row);

57 while($row=mysql_fetch_array($q))

58 {

1 <?php

2 $sel_hoteluri = "SELECT Accommodation_UnitID, Accommodation_Name, Accommodation_Stars, Accommodation_City_Name, Accommodation_City_ID FROM preturi_transilvania GROUP BY Accommodation_UnitID ";

3 $que_hoteluri = mysql_query($sel_hoteluri);

4 while($row_hoteluri = mysql_fetch_array($que_hoteluri)) {

5 $nume_hotel = explode("*", $row_hoteluri['Accommodation_Name']);

14 foreach($hotels['denumire'] as $key => $value) {

15 $sel_loc = "SELECT * FROM localitati_corespondent WHERE nume_furnizor = '".$hotels['localitate'][$key]."' AND code_furnizor = '".$hotels['localitate_id'][$key]."' AND id_furnizor = '".$id_furnizor."' ";

16 $que_loc = mysql_query($sel_loc);

17 $row_loc = mysql_fetch_array($que_loc);

18 if(mysql_num_rows($que_loc)<1) {

19 $ins_city = "INSERT INTO localitati_corespondent (nume_furnizor, code_furnizor, id_furnizor) VALUES ('".$hotels['localitate'][$key]."', '".$hotels['localitate_id'][$key]."', '".$id_furnizor."') ";

20 $que_city = mysql_query($ins_city) or die(mysql_error());

21 @mysql_free_result($que_city);

22

114 }

115

116 if (!mysql_query("SET CHARACTER SET ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");

117 if (!mysql_query("SET character_set_client = ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");

118 if (!mysql_query("SET character_set_results = ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");

119 if (!mysql_query("SET character_set_connection = ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");

256 public function executeQuery($query)

257 {

258 return mysql_query($query, $this->conn);

259 }

260

10 require("connect.php");

11

12 $config=mysql_fetch_assoc(mysql_query("SELECT * FROM config WHERE id = '1'"));

13

14 if (($config['klubadresse']=="") || ($config['klubpath']=="") || ($config['klubnavn']=="")){

24 require("theme.php");

25

26 if(!mysql_num_rows(mysql_query("SELECT * FROM `teams` WHERE `name` = '-'"))){

27 mysql_query("INSERT INTO `teams` (`id`, `name`) VALUES ('9999','-')");

39 switch ($viewgames) {

40 case "default":

41 $query = mysql_query("SELECT * FROM `games` WHERE CURDATE() <= `date` AND `homegame`= 1 ORDER BY `date`,`time` ASC ");

42 $query2 = mysql_query("SELECT * FROM `games` WHERE `date` = '0000-00-00' AND `homegame`= 1 ORDER BY `date`,`time` ASC ");

43 break;

44 case "unassigned":

45 $query = mysql_query("SELECT * FROM `games` WHERE CURDATE() <= `date` AND `status` = 1 AND `homegame`= 1 ORDER BY `date`,`time` ASC ");

46 $query2 = mysql_query("SELECT * FROM `games` WHERE `date` = '0000-00-00' AND `status` = 1 AND `homegame`= 1 ORDER BY `date`,`time` ASC ");

28 //$tabel = "SELECT p.*, h.sebelumdm FROM penduduk p, hasil h where p.NIK = h.idpenduduk";

29 $tabel = "select * from penduduktrain";

30 $hasilSelect = mysql_query($tabel) or die (mysql_error());

31 $jumlahRow = mysql_num_rows($hasilSelect);

32 ?>

54 <?php

55 $querycek = "select * from hasiltrain where hasil is not null";

56 $c = mysql_query($querycek) or die (mysql_error());

57 if(mysql_num_rows($c) > 0 ) {

58

61 $querySejahtera = "SELECT * FROM hasiltrain WHERE hasil = '" . "SEJAHTERA" . "'";

62 //echo $querySejahtera;

63 $s = mysql_query($querySejahtera) or die (mysql_error());

64 $jmlSejahtera = mysql_num_rows($s);

65 echo $jmlSejahtera;

125 $memory_usage = 0;

126 $sql = 'SELECT p.* FROM '.TABLE_PREFIX.'pa_photos p LEFT JOIN '.TABLE_PREFIX."pa_course_album ca ON p.album_id=ca.album_id WHERE member_id=$member_id AND ca.course_id IS NULL";

127 $result = mysql_query($sql, $db);

128 if ($result){

129 while ($row=mysql_fetch_assoc($result)){

96

97 // Execute query

98 $ret = @mysql_query( $query, $this->_connection );

99

100 // If there were error, throw Exception

135 int allocate_lex_string);

136 void thd_get_xid(const void* thd, MYSQL_XID *xid);

137 void mysql_query_cache_invalidate4(void* thd,

138 const char *key, unsigned int key_length,

139 int using_trx);

170

171 $q = "SELECT admin FROM {$CONFIG->dbprefix}users_entity WHERE guid = $guid";

172 $r = mysql_query($q);

173

174 $admin = mysql_fetch_assoc($r);

187

188 $q = "SELECT admin FROM {$CONFIG->dbprefix}users_entity WHERE guid = $guid";

189 $r = mysql_query($q);

190

191 $admin = mysql_fetch_assoc($r);

105

106 // Check for database

107 $test = mysql_query("SHOW TABLES FROM $this->_db LIKE '$this->_table'",$this->_link);

108 if (!is_resource($test)) {

109 throw new WURFL_Xml_PersistenceProvider_Exception("Couldn't show tables from database $this->_db (".mysql_error($this->_link).")");

124 $this->_keycolumn

125 );

126 $success = mysql_query($query, $this->_link);

127 if (!$success) {

128 throw new WURFL_Xml_PersistenceProvider_Exception("Table $this->_table missing in $this->_db (".mysql_error($this->_link).")");

138 $key = mysql_escape_string($key);

139 $sql="select `value` from `$this->_db`.`$this->_table` where `key`='$key'";

140 $result=mysql_query($sql,$this->_link);

141 if (!is_resource($result)) {

142 throw new WURFL_Xml_PersistenceProvider_Exception("MySql error ".mysql_error($this->_link)."in $this->_db");

17 $sql = "select * from tbl_product where name like '%".$keyword."%' order by sort,date_added desc limit ".$row*$col*$p.",".$row*$col;

18

19 $result = @mysql_query($sql,$conn);

20

21 $total = countRecord("tbl_product","name like '%".$keyword."%'");

84 ) ". $this->getTableOptionsCode() . "

85 ";

86 return mysql_query($sql, $this->getDBCon());

87 }

88

96 MODIFY o_lang_dt int(10) UNSIGNED NOT NULL

97 ";

98 return mysql_query($sql, $this->getDBCon());

99 }

100

109 ) ". $this->getTableOptionsCode() . "

110 ";

111 return mysql_query($sql, $this->getDBCon());

112 }

113

243 WHERE `tool_id` <= 0";

244

245 $sql = mysql_query($req);

246

247 $res = mysql_fetch_assoc($sql);

255 WHERE `code` = '".$course_code."'";

256

257 $sql = mysql_query($req);

258

259 $res = mysql_fetch_assoc($sql);

155 }

156

157 inline Variant x_mysql_query(CStrRef query, CVarRef link_identifier = null) {

158 FUNCTION_INJECTION_BUILTIN(mysql_query);

159 return f_mysql_query(query, link_identifier);

160 }

161

93 'link_identifier' => array(Variant, 'null')));

94

95 f('mysql_query', Variant,

96 array('query' => String,

97 'link_identifier' => array(Variant, 'null')));

29 $pageIdList = join($pageIdArray, ",");

30 $query = 'SELECT `page_id`, `page_name`, `page_title` FROM `' . MYSQL_DATABASE_PREFIX . 'pages` WHERE `page_id` IN (' . $pageIdList . ')';

31 $resultId = mysql_query($query);

32

33 while ($row = mysql_fetch_assoc($resultId))

22 $getPluginId = $_GET['plugin_id'];

23 $getPluginVersion = $_GET['plugin_version'];

24 $res = mysql_query("SELECT * FROM plugins WHERE plugin_ID='$getPluginId' AND plugin_Version='$getPluginVersion'");

25 $numrows = mysql_numrows($res);

26 if ($numrows <> 1) die("Are you scamming an old or non-existant plugin?");

32 VoteWorking($_GET['profile_id'], $getPluginId, $getPluginVersion, $v, null);

33 }

34 $res = mysql_query("SELECT plugin_ID, plugin_Name, plugin_Author, max(plugin_Date) as maxdate FROM plugins WHERE plugin_ReviewFlag = 'FALSE' GROUP BY plugin_ID ORDER BY maxdate desc LIMIT 10");

35 while (($enreg=@mysql_fetch_array($res)))

36 ////////////////////////////////////////////////////////////////////////////////

40 $where = "WHERE download_profil_id='$u'";

41 if ($u == "binary64") $where = "";

42 $res = mysql_query("SELECT * FROM userdownloads $where ORDER BY download_Date DESC LIMIT 0,10");

43 while (($enreg=@mysql_fetch_array($res)))

44 {

76

77 if($this->CurrentResult>1){ if(!$this->DoNotFreeResult){ mysql_free_result($this->CurrentResult); }}

78 $this->CurrentResult=mysql_query($ss,$this->Connection_id);

79 $this->checkError($ss,$Line);

80 return $this->CurrentResult;

9 if($_SESSION['access_type'] != "mgr"){ echo "Operation cannot be performed in demo mode"; exit; }

10

11 $settings_result = mysql_query("SELECT * FROM settings where id = '1'", $db);

12 $setting = mysql_fetch_object($settings_result);

13

27 // SAVE DATA

28 $sql = "INSERT INTO email_copy (title,subject,article,image_upload,image_area_name,image_w,image_h,file_upload,file_area_name) VALUES ('$title','$subject','$article','$set_image_upload','$set_image_area_name','$set_image_width','$set_image_height','$set_file_upload','$set_file_area_name')";

29 $result = mysql_query($sql);

30

31 $last_result = mysql_query("SELECT id FROM email_copy order by id desc", $db);

43

44 $sql = "INSERT INTO uploaded_files (reference,reference_id,filename,file_text) VALUES ('$_POST[reference]','$last->id','$fname','$_POST[file_text]')";

45 $result = mysql_query($sql);

46

47 }

15

16 if ($migrateAll) {

17 mysql_query("delete from transforms where transf_from != ''" .

18 "or transf_to != ''");

19 }

32

33 // Load all the DMLR model records

34 mysql_query("delete from model_description where md_model = {$model->id}");

35 $query = "select form, infl_id, variant, is_baseform from dmlr_models " .

36 "where model_type = '{$model->modelType}' " .

41 // Si se envía el correo se almacena en base de datos

42 $insertar="INSERT into contacto (nomb_ape_cont,email_cont,come_cont,fech_cont,status,telefono) value ('".$nombre."','".$correo."','".$contenido."','".date('Y-m-d')."','pendiente','".$telefono."')";

43 $insertar=mysql_query($insertar);

44 echo mysql_error();

45 if (mysql_error()==NULL){

10 $isAdmin = $_SESSION['Admin'];

11 $canBuy = $_SESSION['canBuy'];

12 $queryAuctions=mysql_query("SELECT * FROM WA_Auctions");

13 if ($useMySQLiConomy){

14 $queryiConomy=mysql_query("SELECT * FROM $iConTableName WHERE username='$user'");

15 $iConRow = mysql_fetch_row($queryiConomy);

16 }

17 $playerQuery = mysql_query("SELECT * FROM WA_Players WHERE name='$user'");

18 $playerRow = mysql_fetch_row($playerQuery);

19 $mailQuery = mysql_query("SELECT * FROM WA_Mail WHERE player='$user'");

19 $this->setMySQL('pconnect', @mysql_pconnect);

20 $this->setMysql('select_db', @mysql_select_db);

21 $this->setMySQL('query', @mysql_query);

22 $this->setMySQL('num_rows', @mysql_num_rows);

23 $this->setMySQL('fetch_assoc', @mysql_fetch_assoc);

7 include('connect.php');

8 $query = "SELECT * FROM ice_4_1 WHERE roll='$roll'";

9 $result = mysql_query($query) or die(mysql_error());

10 $count = mysql_num_rows($result);

11

34 include('connect.php');

35 $query1 = "SELECT * FROM reg_info WHERE roll='$roll'";

36 $result1 = mysql_query($query1) or die(mysql_error());

37 $count1 = mysql_num_rows($result1);

38 while ($row1 = mysql_fetch_array($result1)) {

105 $this->num_queries++;

106

107 $this->query_result = @mysql_query($query, $this->db_connect_id);

108 }

109 if($this->query_result)

34 $usuario_clave = md5($usuario_clave);

35 // comprobamos que los datos ingresados en el formulario coincidan con los de la BD

36 $sql = mysql_query("SELECT * FROM usuarios WHERE usuario_nombre='" . $usuario_nombre . "' AND usuario_clave='" . $usuario_clave . "'");

37 if ($row = mysql_fetch_array($sql)) {

38 $_SESSION['id_usuario'] = $row['id_usuario']; // creamos la sesion "usuario_id" y le asignamos como valor el campo usuario_id

45 $modulo = "Iniciar Sessión";

46 $accion = "Inicio de sesión";

47 $bit = mysql_query("INSERT INTO bitacora (id_usuario, fecha, modulo, accion) VALUES ('" . $_SESSION['id_usuario'] . "', NOW(),'" . $modulo . "' , '" . $accion . "')");

48

49

117 $usuario_clave = md5($usuario_clave);

118 // comprobamos que los datos ingresados en el formulario coincidan con los de la BD

119 $sql = mysql_query("SELECT * FROM usuarios WHERE usuario_nombre='" . $usuario_nombre . "' AND usuario_clave='" . $usuario_clave . "'");

120 if ($row = mysql_fetch_array($sql)) {

121 $_SESSION['id_usuario'] = $row['id_usuario']; // creamos la sesion "usuario_id" y le asignamos como valor el campo usuario_id

26 $config = MK_Config::getInstance();

27

28 $get_module = mysql_query("SELECT * FROM `modules` WHERE `id` = '".mysql_real_escape_string($this->getId(), $config->db->con)."'", $config->db->con);

29 $this->meta = mysql_fetch_assoc($get_module);

30 mysql_free_result($get_module);

37 }

38

39 $get_fields = mysql_query("SELECT * FROM `modules_fields` WHERE `module_id` = '".mysql_real_escape_string($this->getId(), $config->db->con)."' ORDER BY `order` ASC", $config->db->con);

40 while($res_fields = mysql_fetch_assoc($get_fields)){

41 $this->fields[$res_fields['name']] = $res_fields['id'];

62 }

63

64 $get_records = mysql_query("SELECT * FROM `".$this->getTable()."`".(count($sql_where) > 0 ? " WHERE ".implode(" AND ", $sql_where) : '').(count($sql_orderby) > 0 ? " ORDER BY ".implode(", ", $sql_orderby) : ''), $config->db->con);

65

66 if(mysql_num_rows($get_records) > 0){

68 }

69

70 $ins = mysql_query("INSERT INTO timetracker (user,project,task,comment,started,ended,hours,pstatus) VALUES ($user,$project,$task,'$comment','$started','$ended','$hours',0)");

71

72 if ($ins)

110 $hours = round($hours, 2);

111

112 $upd = mysql_query("UPDATE timetracker SET task='$task',comment='$comment',started='$started',ended='$ended',hours='$hours' WHERE ID = $id");

113

114 if ($upd)

131 $id = (int) $id;

132

133 $del = mysql_query("DELETE FROM timetracker WHERE ID = $id");

134

135 if ($del)

21

22 $query = 'SELECT agency_name FROM agency';

23 $result = mysql_query($query, $cityDBLink) or die('Query failed: '. mysql_error());

24 $totalRows= mysql_num_rows($result);

25

62

63 $query = 'SELECT service_id,start_date,end_date FROM calendar ORDER BY end_date DESC';

64 $result = mysql_query($query, $cityDBLink) or die('Query failed: '. mysql_error());

65 $totalRows= mysql_num_rows($result);

66

77

78 $query = 'SELECT service_id, date FROM calendar_dates ORDER BY date DESC';

79 $result = mysql_query($query, $cityDBLink) or die('Query failed: '. mysql_error());

80 $totalRows= mysql_num_rows($result);

81

111 if($email_address != '') {

112 $qry = "SELECT * FROM users WHERE email_address='$email_address'";

113 $result = mysql_query($qry);

114 if($result) {

115 if(mysql_num_rows($result) > 0) {

137 $qry= "INSERT INTO users(first_name, last_name, school, email_address, gender, password, phone) VALUES ('$first_name', '$last_name', '$school', '$email_address', '$gender', '".md5($_POST['password'])."', '$phone')";

138

139 $result = @mysql_query($qry);

140

141 //Check whether the query was successful or not

30 {

31 $sql = "SELECT * FROM " . $this->_prefix . "core_privilege";

32 $rs = mysql_query($sql);

33 $rows = array();

34 while ($row = mysql_fetch_object($rs)) {

43 $sql = sprintf("SELECT * FROM " . $this->_prefix . "core_privilege WHERE privilege_id = '%s' LIMIT 1",

44 mysql_real_escape_string($id));

45 $rs = mysql_query($sql);

46 $return = (0 == mysql_num_rows($rs)) ? null : new Core_Models_Privilege(mysql_fetch_object($rs));

47 mysql_free_result($rs);

57 mysql_real_escape_string($privilege->module_name),

58 mysql_real_escape_string($privilege->controller_name));

59 mysql_query($sql);

60 return mysql_insert_id();

61 }

63 if (is_resource($connect_db)) {

64 mysql_select_db($bdd_db,$connect_db);

65 mysql_query("SET NAMES UTF8");

66 return $connect_db;

67 } else {

13 <?php

14

15 $q1=mysql_query("select count(uid) from students") or die(mysql_error());

16 $q2=mysql_query("select count(id) from guest") or die(mysql_error());

17 $q3=mysql_query("select count(id) from staff") or die(mysql_error());

18 $r1=mysql_fetch_array($q1) or die(mysql_error());

19 $r2=mysql_fetch_array($q2) or die(mysql_error());

25 $tot_no=$c1+$c2+$c3;

26

27 $q1v=mysql_query("select count(uid) from students where veg_non='YES'") or die(mysql_error());

28 $q2v=mysql_query("select count(id) from guest where veg_non='YES'") or die(mysql_error());

29 $q3v=mysql_query("select count(id) from staff where veg_non='YES'") or die(mysql_error());

30 $r1v=mysql_fetch_array($q1v) or die(mysql_error());

31 $r2v=mysql_fetch_array($q2v) or die(mysql_error());

10 $notitie_id = mysql_escape_safe($_GET['notitie_id']);

11

12 $result = mysql_query_safe(<<<EOQ

13 SELECT tag, CONCAT(IFNULL(CONCAT(afkorting, ' '), ''), parents.text) text, CONCAT(agenda.week, CASE agenda.dag WHEN 1 THEN 'ma' WHEN 2 THEN 'di' WHEN 3 THEN 'wo' WHEN 4 THEN 'do' ELSE 'vr' END, agenda.lesuur) moment

14 FROM notities

10 mysql_select_db($db_database) or die(mysql_error());

11

12 $result = mysql_query(<<<SQL

13 select a.name, a.type, a.id,

14 coalesce(b.balance, i.avail_cash + p.market_value) balance,

39 <?php

40 $query = "SELECT $monitorDeviceAndOidC4Name FROM $monitorDeviceAndOid ORDER BY $monitorDeviceAndOidC4Name ";

41 $recordList = mysql_query ( $query, $session ) or die ( "ERR: <b>$query</b>: " . mysql_error () );

42 while ( $record = mysql_fetch_array ( $recordList ) )

43 {

51 $query = "SELECT * FROM $monitorDeviceList ORDER BY $monitorDeviceListC2Name ";

52 }

53 $recordList = mysql_query ( $query, $session ) or die ( "ERR: <b>$query</b>: " . mysql_error () );

54

55

28

29 if($type == "page") {

30 $data = mysql_query("SELECT p.* FROM core_pages p WHERE p.page_title = \"$id\"");

31 $page_clicks = 0;

32 while($p = mysql_fetch_array($data)) {

37 }

38

39 mysql_query("UPDATE core_pages p SET

40 p.hits = $page_clicks

41 WHERE p.page_title = $id");

43

44 if($type == "entry") {

45 $data = mysql_query("SELECT e.* FROM core_entries e WHERE e.entry_id = $id AND e.entry_show = 1");

46 $entry_clicks = 0;

47 if(@mysql_num_rows($data) < 1) {

13 if(isset($_POST['Submit'])){

14 $query="SELECT * FROM Behavior b, Groups g WHERE g.GROUP_ID=" . $session->GROUP_ID . " AND b.CONTRACT_ID=g.CONTRACT_ID";

15 $btwo = mysql_query($query) or die(mysql_error());

16 $numB = mysql_num_rows($btwo);

17 $query2="INSERT INTO Eval (STUDENT_ID, Grader_ID, GROUP_ID, Grade) VALUES (" . $_POST[graded] . ", " . $session->STUDENT_ID . ", " . $session->GROUP_ID . ", '10')";

18 mysql_query($query2) or die(mysql_error());

19

20 $evalid = mysql_insert_id();

22 $r2 = mysql_fetch_array($btwo);

23 $query3="INSERT INTO EvalComment (CONTRACT_ID, BEHAVIOR_ID, Comment, EVAL_ID) VALUES (" . $r2[CONTRACT_ID] . ", " . $r2[BEHAVIOR_ID] . ", \"" . $_POST[$r2[BEHAVIOR_ID]] . "\", " . $evalid . ")";

24 mysql_query($query3) or die(mysql_error());

25 };

26 $qfour = mysql_query("SELECT * FROM users WHERE GROUP_ID=" . $session->GROUP_ID . " AND STUDENT_ID=" . $_POST[graded]);

7 mysql_connect($server,$username,$password);

8 @mysql_select_db($database) or die("Unable to select database");

9 mysql_query("SET time_zone = '-5:00';");

10

11

67 //MySQL Query for Each Item

68 $query = "INSERT INTO e3_live(fulldate, date, event_id, event, league, sport, time, thumb) VALUES(NOW(), DATE('{$safe['date']}'), '{$safe['idnum']}', '{$safe['event']}', '{$safe['league']}', '{$safe['sport']}', '{$safe['time']}', '{$safe['thumb']}')";

69 mysql_query($query);

70

71 }

127 //MySQL Query for Each Item

128 $query = "INSERT INTO e3_live(fulldate, date, event_id, event, league, sport, time, thumb) VALUES(NOW(), DATE('{$safe['date']}'), '{$safe['idnum']}', '{$safe['event']}', '{$safe['league']}', '{$safe['sport']}', '{$safe['time']}', '{$safe['thumb']}')";

129 mysql_query($query);

130

131 }

11 $input = $_GET[id];

12

13 $userid = @mysql_result(mysql_query(

14 "SELECT `id` FROM `{$mysql->prefix}users`

15 WHERE email='$input' OR username='$input'

38

39 $sql = "SELECT * FROM CMS_ONLINE_RESOURCE_RELATIONS".$orderByQuery.$limitQuery;

40 $result = MYSQL_QUERY($sql);

41 $numberOfRows = MYSQL_NUM_ROWS($result);

42

38

39 $sql = "SELECT * FROM CMS_OFFLINE_RESOURCE_RELATIONS".$orderByQuery.$limitQuery;

40 $result = MYSQL_QUERY($sql);

41 $numberOfRows = MYSQL_NUM_ROWS($result);

42

38

39 $sql = "SELECT * FROM CMS_PROJECTS".$orderByQuery.$limitQuery;

40 $result = MYSQL_QUERY($sql);

41 $numberOfRows = MYSQL_NUM_ROWS($result);

42

27 $description = mysql_real_escape_string($description);

28

29 $ins = mysql_query("INSERT INTO plugins (name,description) VALUES ('$name','$description')");

30 if ($ins)

31 {

56 {

57 $plugin = (int) $plugin;

58 $del = mysql_query("DELETE FROM plugins WHERE ID = $plugin");

59 $this->delAllPluginEvents($plugin);

60

78 {

79 $plugin = (int) $plugin;

80 $upd = mysql_query("UPDATE plugins SET state = 1 WHERE ID = $id");

81 }

82

62 ";

63

64 $result = mysql_query($main_query);

65

66 start_table();

27 }

28 function getLists($conn,$table,$size,$sort,$field){

29 mysql_query("SET NAMES 'UTF8'",$conn);

30 $page =isset($_GET['page'])?$_GET['page']:1; //获取查询页数，如果没有get到page，默认就是第一页！

31 if(!preg_match('/^\d+$/',$page) || $page < 1) $page = 1; //如果输入的不是数字 或者小于1 默认第一页

32 $table=$table; //获取要查询的数据表

33 $pageSize =$size; //每页多少条

34 $result_pag_num = mysql_query("SELECT COUNT(*) AS count FROM $table"); //获取数据表中总记录条数

35 $row = mysql_fetch_array($result_pag_num);

36 $count = $row['count']; //返回记录总条数

39 $start = ($page - 1) * $pageSize; //sql查询起始位置

40 $query_pag_data = "SELECT $field from $table order by id $sort LIMIT $start, $pageSize";

41 $result_pag_data = mysql_query($query_pag_data) or die('MySql Error' . mysql_error());

42 $arrList = array(); //初始化列表数组

43 $arr=array();

33 }

34 $query = "select uid from drusessions where sid = '$sid'";

35 $result = mysql_query($query);

36 if(!$result) {

37 return False;

63

64

65 $result = mysql_query($query);

66 if(!$result) {

67 return False;

80 }

81 $query = "select full_id as cardid, front, type, name, swap, cost, body_atk, body_def, body_bst, mind_atk, mind_def, mind_bst, soul_atk, soul_def, soul_bst, vit, level, action, duration, `range`, card_img from cards_lu where full_id = '$cardid'";

82 $result = mysql_query($query);

83 if(!$result) {

84 return False;

19

20 $sqlUpdate = "UPDATE CMS_HISTORY_PRINCIPALS SET PRINCIPAL_ID = '$thisPRINCIPAL_ID' , PRINCIPAL_NAME = '$thisPRINCIPAL_NAME' , PRINCIPAL_DESCRIPTION = '$thisPRINCIPAL_DESCRIPTION' , PRINCIPAL_OU = '$thisPRINCIPAL_OU' , PRINCIPAL_EMAIL = '$thisPRINCIPAL_EMAIL' , PRINCIPAL_TYPE = '$thisPRINCIPAL_TYPE' , PRINCIPAL_USERDELETED = '$thisPRINCIPAL_USERDELETED' , PRINCIPAL_DATEDELETED = '$thisPRINCIPAL_DATEDELETED' WHERE PRINCIPAL_ID = '$thisPRINCIPAL_ID'";

21 $resultUpdate = MYSQL_QUERY($sqlUpdate);

22 echo "<b>Record with Id ".$thisPRINCIPAL_IDFromForm." has been Updated<br></b>";

23 $thisPRINCIPAL_IDFromForm = "";

37

38 $sqlInsert = "INSERT INTO CMS_HISTORY_PRINCIPALS (PRINCIPAL_ID , PRINCIPAL_NAME , PRINCIPAL_DESCRIPTION , PRINCIPAL_OU , PRINCIPAL_EMAIL , PRINCIPAL_TYPE , PRINCIPAL_USERDELETED , PRINCIPAL_DATEDELETED ) VALUES ('$thisPRINCIPAL_ID' , '$thisPRINCIPAL_NAME' , '$thisPRINCIPAL_DESCRIPTION' , '$thisPRINCIPAL_OU' , '$thisPRINCIPAL_EMAIL' , '$thisPRINCIPAL_TYPE' , '$thisPRINCIPAL_USERDELETED' , '$thisPRINCIPAL_DATEDELETED' )";

39 $resultInsert = MYSQL_QUERY($sqlInsert);

40 echo "<b>Record has been inserted in Database<br></b>";

41 $thisPRINCIPAL_IDFromForm = "";

55

56 $sqlDelete = "DELETE FROM CMS_HISTORY_PRINCIPALS WHERE PRINCIPAL_ID = '$thisPRINCIPAL_ID'";

57 $resultDelete = MYSQL_QUERY($sqlDelete);

58

59 echo "<b>Record with Id ".$thisPRINCIPAL_IDFromForm." has been Deleted<br></b>";

81

82 $query = "SELECT * FROM ms_barang WHERE flags='9' ORDER BY ex_year,ex_month,ex_year ASC";

83 $hasil = mysql_query($query);

84

85 // nilai awal untuk baris cell

100 $counter = 1;

101 $query = "SELECT name, amount FROM donations ORDER BY amount DESC LIMIT 10";

102 $result = mysql_query($query);

103 while ($counter <= 10 && $row = mysql_fetch_array($result)) {

104 $name = $row['name'];

71 foreach ($this->infos['query']['target_graphs'] as $g) {

72 if ($g_id = $this->getTermID($g, 'g')) {

73 $rs = mysql_query('DELETE FROM ' . $tbl_prefix . 'g2t WHERE g = ' .$g_id, $con);

74 $r += mysql_affected_rows($con);

75 }

132 $sql .= ' FROM ' . $this->getTripleTable() . ' T WHERE ' . $q;

133 }

134 $rs = mysql_query($sql, $con);

135 if ($er = mysql_error($con)) {

136 $this->addError($er .' in ' . $sql);

166 WHERE G.t IS NULL LIMIT 1

167 ';

168 if (($rs = mysql_query($sql, $con)) && mysql_num_rows($rs)) {

169 /* delete unconnected triples */

170 $sql = ($dbv < '04-01') ? 'DELETE ' . $tbl_prefix . 'triple' : 'DELETE T';

13 $query = "DELETE FROM assignment WHERE assnID = '$rowID'";

14

15 if (!mysql_query($query, $mysqlConnection))

16 {

17 die ('Error: ' . mysql_error());

32 $query = "DELETE FROM automarking WHERE AutomarkID = '$rowID'";

33

34 if (!mysql_query($query, $mysqlConnection))

35 {

36 die ('Error: ' . mysql_error());

51 $query = "DELETE FROM course WHERE CourseID = '$rowID'";

52

53 if (!mysql_query($query, $mysqlConnection))

54 {

55 die ('Error: ' . mysql_error());

128

129 $sql = "SELECT * FROM phpspeed_config";

130 $result = mysql_query($sql,$con);

131 $ver = mysql_fetch_assoc($result);

132

63 private static function moveUserToInternal($userEmail, $userId) {

64 $query = "SELECT `page_modulecomponentid` FROM `newsletter_externalusers` WHERE `user_email` = '$userEmail'";

65 $result = mysql_query($query);

66 while ($row = mysql_fetch_row($result)) {

67 if (!isInternalUserRegistered($userId, $row[0], false)) {

68 $insertQuery = "INSERT INTO `newsletter_users`(`page_modulecomponentid`, `newsletter_subscriptiontype`, `user_id`, `user_joindatetime`) VALUES ({$row[0]}, 'user', $userId, NOW())";

69 if (!mysql_query($insertQuery)) {

70 displayerror('Could not add user to internal list.');

71 }

72 else {

73 $deleteQuery = "DELETE FROM `newsletter_externalusers` WHERE `page_modulecomponentid` = {$row[0]} AND `user_email` = '$userEmail'";

74 if (!mysql_query($deleteQuery))

75 displayerror('Could not remove user from external list.');

76 }

19 //first take care of the database

20 //check if signup db exits

21 $test = mysql_query("select * from sul_signup_profile");//which is faster? this or mysql_list_table function

22 if (!$test)

23 {

31 }

32

33 $r = mysql_query("CREATE TABLE `sul_signup_profile`(

34 `uid` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,".$tstring."`profile` varchar(45), PRIMARY KEY (`uid`))");

35

55

56 //backup present table and create another one

57 if (mysql_query("select * from sul_signup_profile_backup"))

58 {

59

27 $CONF = &$GLOBALS["config"];

28 If($id){

29 $radek=mysql_fetch_assoc(mysql_query("SELECT * FROM $CONF[sqlPrefix]rezervRezervace WHERE id='$id'"));

30 $dotaz=mysql_query("SELECT * FROM $CONF[sqlPrefix]rezervRezervaceUdaje WHERE idRezervace='$id'");

62 Function setPokoj($pokojId){

63 $CONF = &$GLOBALS["config"];

64 $radek=mysql_fetch_assoc(mysql_query("SELECT * FROM $CONF[sqlPrefix]rezervPokoje WHERE id='$pokojId'"));

65 if($radek["nazev"]){

66 $this->pokojId = $pokojId;

185 $CONF = &$GLOBALS["config"];

186 if($this->pokojId AND $this->datumStart AND $this->datumEnd AND $this->udaj){

187 $radek=mysql_fetch_assoc(mysql_query("SELECT * FROM $CONF[sqlPrefix]rezervRezervace

188 WHERE pokojId='$this->pokojId'

189 AND ((datumStart>'$this->datumStart' AND datumStart>'$this->datumEnd') OR (datumEnd<'$this->datumStart' AND datumEnd<'$this->datumEnd'))

190 AND potvrzeno='1'") );

191 if(!$radek["datumEnd"] or True){

192 $insert = mysql_query("INSERT INTO $CONF[sqlPrefix]rezervRezervace (pokojId, datumStart, datumEnd, potvrzeno, pocetHostu, cena, detaily, datum) VALUES ('$this->pokojId','$this->datumStart','$this->datumEnd','$this->potvrzeno','$this->pocetHostu','$this->cena','$this->detaily',NOW())");

193 $rezervInsertId = mysql_insert_id();

194 $radek2=mysql_fetch_assoc(mysql_query("SELECT id FROM $CONF[sqlPrefix]rezervRezervace WHERE pokojId='$this->pokojId' AND datumStart='$this->datumStart'"));

2 // populate the topics panel

3 $query_getTopics = sprintf("SELECT cat_id, cat_name, undone, (SELECT COUNT(quiz_id) FROM `q_quizzes` WHERE isPublished = 1 AND fk_quiz_cat = cat_id) as total FROM (SELECT COUNT(fk_quiz_cat) as undone, fk_quiz_cat FROM q_quizzes q WHERE q.quiz_id NOT IN (SELECT DISTINCT(fk_quiz_id) FROM `q_store_result` WHERE `fk_member_id` = %s) AND isPublished = 1 GROUP BY fk_quiz_cat) t RIGHT JOIN q_quiz_cat r ON t.fk_quiz_cat = r.cat_id", $member->id);

4 $getTopics = mysql_query($query_getTopics, $quizroo) or die(mysql_error());

5 $row_getTopics = mysql_fetch_assoc($getTopics);

6 $totalRows_getTopics = mysql_num_rows($getTopics);

12 if(array_key_exists('id',$_GET)&& $_GET['id']!=0){

13 $clientid=$_GET['id'];

14 $query_for_cheching_status=mysql_query("select deptYN from clientdetails where id='$clientid'");

15 $row_for_status=mysql_fetch_array($query_for_cheching_status);

16 $status=$row_for_status['deptYN'];

17 if($status==1){

18

19 $mysql_query=mysql_query("select * from cdeptmaster where clientId='$clientid' order by id desc");

20 if(mysql_num_rows($mysql_query)>0){

21

22 $flag_for_checking=true;

23 $POST=mysql_fetch_array($mysql_query);

24

25 $name=$POST['name'];

76 if(array_key_exists('id',$_GET) && $_GET['id']!=0){

77 $clientid1=$_GET['id'];

78 $noofrows=(mysql_query("select id from cdeptmaster where clientId='$clientid1' order by id desc"));

79 $flag=1;

80 if(mysql_num_rows($noofrows)>0){

231

232 /* inject into database */

233 mysql_query( $query . $val_query);

234 }

235

101 }

102

103 // Execute query. (mysql_query)

104 # @param string $sql

105 #

109 $this->sql_query = $sql;

110 $this->query_counter++;

111 $this->result = @mysql_query($this->sql_query, $this->connection);

112

113 if($this->result === false) { $this->error('QUERY.FAILED', NULL); return false; }

5

6 $query = sprintf("SELECT result_id, result_title, result_description, result_picture FROM q_results WHERE fk_quiz_id = %d", GetSQLValueString($_GET['id'], "int"));

7 $getQuery = mysql_query($query, $quizroo) or die(mysql_error());

8 $row_getQuery = mysql_fetch_assoc($getQuery);

9 $totalRows_getQuery = mysql_num_rows($getQuery);

28 if ($cfgSkipLockedTables == TRUE && PMA_MYSQL_INT_VERSION >= 32330) {

29 $local_query = 'SHOW OPEN TABLES FROM ' . PMA_backquote($db);

30 $result = mysql_query($query) or PMA_mysqlDie('', $local_query, '', $err_url);

31 // Blending out tables in use

32 if ($result != FALSE && mysql_num_rows($result) > 0) {

41 if (isset($sot_cache)) {

42 $local_query = 'SHOW TABLES FROM ' . PMA_backquote($db);

43 $result = mysql_query($query) or PMA_mysqlDie('', $local_query, '', $err_url);

44 if ($result != FALSE && mysql_num_rows($result) > 0) {

45 while ($tmp = mysql_fetch_array($result)) {

46 if (!isset($sot_cache[$tmp[0]])) {

47 $local_query = 'SHOW TABLE STATUS FROM ' . PMA_backquote($db) . ' LIKE \'' . addslashes($tmp[0]) . '\'';

48 $sts_result = mysql_query($local_query) or PMA_mysqlDie('', $local_query, '', $err_url);

49 $sts_tmp = mysql_fetch_array($sts_result);

50 $tables[] = $sts_tmp;

2 if($_POST['room_code'])

3 {

4 if(mysql_query("UPDATE `room` SET `ROOM_CODE`='".$_POST['room_code']."', `ROOM_DESC`='".$_POST['room_name']."', `ROOM_CAPACITY`='".$_POST['capacity']."', `LOCATION_NO`='".$_POST['location']."', `STATUS`='".$_POST['is_active']."' WHERE `ROOM_NO`=".$_GET['rid']))

5 $_SESSION['s_msg']="<strong>Well done!</strong> room successfully updated";

6 else

25 "WHERE zone.zoneidnumber=zoneid AND short_name='%s' "

26 "ORDER BY gridid,number", zone);

27 if(mysql_query(m, query) != 0) {

28 printf("Unable to query: %s\n", mysql_error(m));

29 return(false);

115 "SELECT x,y,z FROM spawn2 "

116 "WHERE zone='%s'", zone);

117 if(mysql_query(m, query) != 0) {

118 printf("Unable to query: %s\n", mysql_error(m));

119 return(false);

150 "SELECT pos_x,pos_y,pos_z FROM doors "

151 "WHERE zone='%s'", zone);

152 if(mysql_query(m, query) != 0) {

153 printf("Unable to query: %s\n", mysql_error(m));

154 return(false);

67 ('.NEW_TABLE_PRODUCTS.'.pvid = "'.mysql_real_escape_string ($pvid).'"

68 AND '.NEW_TABLE_PRODUCTS.'.pvid != "0")';

69 $result = mysql_query($query, $connection) or die(debug_print ("ERROR: 754004 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));

70 if ($row = mysql_fetch_array($result))

71 {

92 FROM

93 '.NEW_TABLE_PRODUCTS;

94 $result = mysql_query($query, $connection) or die (debug_print ("ERROR: 856249 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));

95 if ($row = mysql_fetch_array($result))

96 {

106 product_version = "1",

107 producer_id = "'.mysql_real_escape_string($producer_id).'"';

108 $result = mysql_query($query, $connection) or die (debug_print ("ERROR: 460569 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));

109 $pvid = mysql_insert_id();

110 // Now increment the product_id until it is unique in the database

52 function byClass() {

53

54 $prog_array = mysql_query("SELECT * FROM degree_program");

55 while ($programs = mysql_fetch_array($prog_array)) {

56 extract($programs);

68 </tr>";

69

70 $offered_subjects = mysql_query("SELECT * FROM offered_subjects a, section b WHERE a.degree_program_id=$degree_program_id AND a.course_code = b.course_code ");

71 $count=1;

72 $rowclass=0;

108 echo "<p class=headfont><u>ENROLLMENT by COURSE</u><br/><br/></p>";

109

110 $prog_array = mysql_query("SELECT * FROM degree_program");

111 echo "<center><table width=800><tr bgcolor=#A2A2A2>

112 <td width=50>#</td>

122 }

123 //echo $sql.'<br />';

124 if (mysql_query($sql)) {

125 return TRUE;

126 } else {

160 $sql="SELECT * FROM `cn_conteneurs`

161 WHERE `id` ='".$id_conteneur."' ";

162 $result = mysql_query($sql);

163 if ($result) {

164 $donnee_recu = mysql_fetch_array($result);

12

13 // Create the posts table if it does not exist

14 if (mysql_num_rows(mysql_query("SHOW TABLES LIKE '" . TINYIB_DBPOSTS . "'")) == 0) {

15 mysql_query("CREATE TABLE `" . TINYIB_DBPOSTS . "` (

43

44 // Create the bans table if it does not exist

45 if (mysql_num_rows(mysql_query("SHOW TABLES LIKE '" . TINYIB_DBBANS . "'")) == 0) {

46 mysql_query("CREATE TABLE `" . TINYIB_DBBANS . "` (

57 # Post Functions

58 function uniquePosts() {

59 $row = mysql_fetch_row(mysql_query("SELECT COUNT(DISTINCT(`ip`)) FROM " . TINYIB_DBPOSTS));

60 return $row[0];

61 }

62

63 function postByID($id) {

64 $result = mysql_query("SELECT * FROM `" . TINYIB_DBPOSTS . "` WHERE `id` = '" . mysql_real_escape_string($id) . "' LIMIT 1");

65 if ($result) {

66 while ($post = mysql_fetch_assoc($result)) {

15 function are_email_notifications_enabled($uid) {

16 $query = sprintf("SELECT disable_email_notifications FROM users WHERE id=%d", $uid);

17 $res = mysql_query($query);

18 $row = mysql_fetch_assoc($res);

19 return (!(bool)$row['disable_email_notifications']);

23 function award_exp($uid,$act,$exp_value) {

24 $query = sprintf("INSERT INTO experience (uid,act,value) VALUES (%d,'%s',%d)", $uid,mysql_real_escape_string($act),$exp_value);

25 mysql_query($query);

26 return;

27 }

29 function calculate_leaderboard() {

30 $query = sprintf("set @cnt :=0");

31 mysql_query($query);

32 $query = sprintf("select @cnt := @cnt+1 as rank,dt.* FROM (SELECT users.username,sum(experience.value) as score from experience,users where users.id=experience.uid group by uid order by score desc limit 50) as dt");

33

48

49 $query = "SELECT * FROM `registrations` WHERE deleted_at IS NULL";

50 $result = mysql_query($query);

51

52 while ($row = mysql_fetch_object($result)) {

68

69 $query = "SELECT * FROM `registrations` WHERE id=" . $id;

70 $result = mysql_query($query);

71 $row = mysql_fetch_object($result);

72 return $row;

85 $query = "DELETE FROM `miniproject`.`registrations` WHERE `registrations`.`id` =" . $id;

86

87 $result = mysql_query($query);

88

89 // var_dump($result);

23 <?

24 $sql = "DELETE FROM CMS_HISTORY_RESOURCES WHERE RESOURCE_ID = '$thisRESOURCE_ID'";

25 $result = MYSQL_QUERY($sql);

26

27 ?>

71 ORDER BY hour";

72

73 $result1 = mysql_query($query1);

74 $result2 = mysql_query($query2);

75 $result3 = mysql_query($transCountQ);

76 $num1 = mysql_num_rows($result1);

77 $num2 = mysql_num_rows($result3);

4

5 $select="select * from login_detail where username='".$_POST['username']."' and password='".$_POST['password']."'";

6 $view=mysql_query($select) or die("Error in Insert plantype Table".mysql_error());

7 $num=mysql_fetch_array($view);

8 if($num>0)

9 if(isset($_GET['did']))

10 {

11 $del=mysql_query("delete from users where username='".$_GET['did']."'")or die(mysql_error());

12 $delet=mysql_query("delete from emsuser where username='".$_GET['did']."'")or die(mysql_error());

62 </thead>

63 <?php

64 $qry=mysql_query("select * from emsuser")or die(mysql_error());

65 $i=1;

66 while($fetch=mysql_fetch_array($qry)){

26

27 $sQuery = "SELECT consoleid, naam FROM consoles WHERE consoleid='" . add($_GET['id']) . "';";

28 $cResult = mysql_query($sQuery);

29 if ($cResult && $aData = mysql_fetch_assoc($cResult)) {

30 $cTPL->setPlace('NAAMCONSOLE', $aData['naam']);

54 ORDER BY naam;";

55 }

56 if ($cResult = mysql_query($sQuery)) {

57 $sKleur = '';

58 while ($aData = mysql_fetch_assoc($cResult)) {

101 WHERE c.consoleid = sv.consoleid AND c.consoleid=s.consoleid AND s.spelid=sv.spelid

102 AND s.consoleid='" . add($_GET['id']) . "' ORDER BY RAND() LIMIT 0,3;";

103 if ($cResult = mysql_query($sQuery)) {

104 $iTeller = 0;

105 while ($aData = mysql_fetch_assoc($cResult)) {

113 $SQLquery .= ' AND (`filetime` = -1)';

114 $SQLquery .= ' AND (`analyzetime` = -1)';

115 if ($this->cursor = mysql_query($SQLquery, $this->connection)) {

116 list($version) = mysql_fetch_array($this->cursor);

117 }

128 public function clear_cache() {

129

130 $this->cursor = mysql_query('DELETE FROM `'.mysql_real_escape_string($this->table).'`', $this->connection);

131 $this->cursor = mysql_query('INSERT INTO `'.mysql_real_escape_string($this->table).'` VALUES (\''.getID3::VERSION.'\', -1, -1, -1, \''.getID3::VERSION.'\')', $this->connection);

149 $SQLquery .= ' AND (`filesize` = \''.mysql_real_escape_string($filesize).'\')';

150 $SQLquery .= ' AND (`filetime` = \''.mysql_real_escape_string($filetime).'\')';

151 $this->cursor = mysql_query($SQLquery, $this->connection);

152 if (mysql_num_rows($this->cursor) > 0) {

153 // Hit

168 $SQLquery .= ', \''.mysql_real_escape_string(time() ).'\'';

169 $SQLquery .= ', \''.mysql_real_escape_string(base64_encode(serialize($analysis))).'\')';

170 $this->cursor = mysql_query($SQLquery, $this->connection);

171 }

172 return $analysis;

21 global $g_table_prefix;

22

23 $query = mysql_query("

24 SELECT *

25 FROM {$g_table_prefix}module_export_groups

30

31 // get any custom list of clients, if this is a Private export type

32 $query = mysql_query("

33 SELECT account_id

34 FROM {$g_table_prefix}module_export_group_clients

55 global $g_table_prefix;

56

57 $query = mysql_query("

58 SELECT *

59 FROM {$g_table_prefix}module_export_groups

16

17 echo "obj.options[obj.options.length] = new Option('-Please Select City-','');\n";

18 $resultset = mysql_query("SELECT * FROM `ebpls_city_municipality`where upper='$prov'") or die(mysql_error()."dd");

19 while($datarow = @mysql_fetch_array($resultset))

20 {

37

38 echo "obj.options[obj.options.length] = new Option('-Please Select District-','');\n";

39 $resultset = mysql_query("SELECT * FROM ebpls_district where upper='$prov'") or die(mysql_error()."dd");

40 while($datarow = @mysql_fetch_array($resultset))

41 {

69

70 echo "obj.options[obj.options.length] = new Option('-Please Select Barangay-','');\n";

71 $resultset = mysql_query("SELECT * FROM ebpls_barangay where upper='$prov'") or die(mysql_error()."dd");

72 while($datarow = @mysql_fetch_array($resultset))

73 {

90 runkit_function_redefine('mysql_pconnect', '', 'return "mysql_pconnect";');

91 runkit_function_redefine('mysql_connect', '', 'return "mysql_connect";');

92 runkit_function_redefine('mysql_query', '', 'return "mysql_query";');

93 runkit_function_redefine(

94 'mysql_fetch_array', '', 'return "mysql_fetch_array";'

189 $ret = $this->object->realQuery($query, $link, $options);

190 $this->assertEquals(

191 'mysql_query',

192 $ret

193 );

47 $this->professors[0]["infos"] = array();

48

49 $result = mysql_query($query);

50 $count = 0;

51 if($result){

20 {

21 /* Execute the query */

22 int success = mysql_query(sqlConn, sqlGetNextVectorID);

23 if( success != 0 )

24 {

53 sprintf( strRenameTableSQL, sqlTemplateRenameTable, oldName, newName);

54

55 int success = mysql_query(sqlConn, strRenameTableSQL);

56

57 return ( success != 0 )? 0 : 1;

101

102 /* Execute the query */

103 int success = mysql_query(sqlConn, strGetRecCounterSQL);

104 if( success != 0 )

105 return 0;

55

56 $consulta_cliente= "select cod_cliente from cliente where cod_zona = $codigo"; // consulta en la base de datos si ya no se ha registrado el stock inicial

57 $result_cliente = mysql_query($consulta_cliente); // hace la consulta

58 $nfilas_cliente = mysql_num_rows ($result_cliente); //indica la cantidad de resultados

59

107 else

108 PHP_ADD_LIBRARY(z,, PDO_MYSQL_SHARED_LIBADD)

109 PHP_CHECK_LIBRARY($PDO_MYSQL_LIBNAME, mysql_query, [], [

110 AC_MSG_ERROR([Try adding --with-zlib-dir=<DIR>. Please check config.log for more information.])

111 ], [

18 total = qty*price

19 WHERE id_quote_item = %d", $item["'color'"], $item["'qty'"], $key_quote);

20 mysql_query($sql) or die("Invalid query: " . mysql_error());

21 }

22 }

27 {

28 $key_del = intval($key_del);

29 mysql_query(sprintf("DELETE FROM quote_item WHERE id_quote_item = %d", $key_del)) or die("Invalid query: " . mysql_error());

30 }

31 foreach($_POST['item'] as $key_quote => $item)

41 total = qty*price

42 WHERE id_quote_item = %d", $item["'color'"], $item["'qty'"], $key_quote);

43 mysql_query($sql) or die("Invalid query: " . mysql_error());

44 }

45 }

20 $query .= " WHERE userID = ". $data['userID'];

21

22 $re = mysql_query($query);

23

24 fSession::set('name',$data['name']);

34 $newpass = fCryptography::hashPassword($data['password']);

35 $query = "INSERT INTO chat_admin (name,email,usertype,status,password,aspID) VALUES ('".$data['name']."', '".$data['email']."','". $data['usertype'] ."','". $data['status'] ."','". $newpass ."','1')";

36 $re = mysql_query($query);

37 $ret = mysql_insert_id($link);

38 return $ret;

46 $query .= " WHERE userID = ". $data['userID'];

47

48 $re = mysql_query($query);

49

50 }

9 mysql_real_escape_string($url_id)

10 );

11 $result = mysql_query($query);

12

13 if (!$result) {

150 );

151

152 if (!mysql_query($query))

153 {

154 beaconError(mysql_error());