About 12,255 results: "mysql_query"
Page 7 of 50
Filter Results
Sources
Languages
Filter Results
Try Search On
  1. 		//Smiles
  2. 		$querysm=mysql_query('SELECT * FROM `forum_smiles`', $GLOBALS['MySQL_CON']);
  3. 		mysql_select_db($GLOBALS['MySQL_Set']['DBREALM'], $GLOBALS['MySQL_CON']);
  4. 		$dbquery = mysql_query("SELECT gmlevel FROM account WHERE id='".$uid."'", $GLOBALS['MySQL_CON']);
  5. 
                        
  6. 	$dbquery = mysql_query("SELECT gmt FROM forum_accounts WHERE id_account='".$uid."'", $GLOBALS['MySQL_CON']);
  7. 		@mysql_select_db($GLOBALS['MySQL_Set']['DBREALM'], $GLOBALS['$MySQL_CON']);
  8. 		$query= mysql_query("SELECT id_post, isbbcode, `text`, DATE_FORMAT(`date`, '%Y-%m') as datei, DATE_FORMAT(CONCAT(`date`,' ',`hour`), '%d-%m-%Y at %H:%i:%s') as `date`, fa.displayname as dn, ft.title as title FROM `forum_posts` fp
  9. 		mysql_select_db ($GLOBALS['MySQL_Set']['DBREALM'], $GLOBALS['MySQL_CON']);
  10. 		mysql_query('INSERT INTO web_online VALUES("'.$_SESSION['userid'].'","'.$page.'","'.date('Y-m-d H:i:s').'", "'.$_SERVER['REMOTE_ADDR'].'", 0) ON DUPLICATE KEY UPDATE page="'.$page.'", time ="'.date('Y-m-d H:i:s').'", ip="'.$_SERVER['REMOTE_ADDR'].'", isguest=0', $GLOBALS['MySQL_CON']) OR DIE (mysql_error());
  11. 	} else {
  12. 		mysql_query('INSERT INTO web_online VALUES("'.$_SESSION['guestid'].'","'.$page.'","'.date('Y-m-d H:i:s').'", "'.$_SERVER['REMOTE_ADDR'].'", 1) ON DUPLICATE KEY UPDATE page="'.$page.'", time ="'.date('Y-m-d H:i:s').'", ip="'.$_SERVER['REMOTE_ADDR'].'", isguest=1', $GLOBALS['MySQL_CON']) OR DIE (mysql_error());
  13. 	}
  14. 	@mysql_query('DELETE FROM web_online WHERE TIMESTAMPDIFF(MINUTE, `time`, NOW())>=5', $GLOBALS['MySQL_CON']);
  15. function resetavatar($uid) {
  16. 	@mysql_query("UPDATE forum_accounts SET avatar='nochar' WHERE id_account='".$uid."'");





  1. 
                        
  2. 				if ($query = mysql_query('SELECT `id` FROM `' . $this->options['prefix'][0] . 'cache_data` WHERE `id` = ' . $feed_id, $this->mysql))
  3. 
                        
  4. 						if (!mysql_query($sql, $this->mysql))
  5. 					}
  6. 					elseif (!mysql_query('INSERT INTO `' . $this->options['prefix'][0] . 'cache_data` (`id`, `items`, `data`, `mtime`) VALUES(' . $feed_id . ', ' . count($prepared[1]) . ', \'' . mysql_real_escape_string($prepared[0]) . '\', ' . time() . ')', $this->mysql))
  7. 
                        
  8. 								if (!mysql_query('INSERT INTO `' . $this->options['prefix'][0] . 'items` (`feed_id`, `id`, `data`, `posted`) VALUES(' . $feed_id . ', \'' . mysql_real_escape_string($new_id) . '\', \'' . mysql_real_escape_string(serialize($prepared[1][$new_id]->data)) . '\', ' . $date . ')', $this->mysql))
  9. 			}
  10. 			elseif ($query = mysql_query('SELECT `id` FROM `' . $this->options['prefix'][0] . 'cache_data` WHERE `id` = ' . $feed_id, $this->mysql))
  11. 	{
  12. 		if ($this->mysql && ($query = mysql_query('SELECT `mtime` FROM `' . $this->options['prefix'][0] . 'cache_data` WHERE `id` = \'' . mysql_real_escape_string($this->id) . "'", $this->mysql)) && ($row = mysql_fetch_row($query)))
  13. 	{
  14. 		if ($this->mysql && ($query = mysql_query('UPDATE `' . $this->options['prefix'][0] . 'cache_data` SET `mtime` = ' . time() . ' WHERE `id` = \'' . mysql_real_escape_string($this->id) . "'", $this->mysql)) && mysql_affected_rows($this->mysql))
  15. 	{
  16. 		if ($this->mysql && ($query = mysql_query('DELETE FROM `' . $this->options['prefix'][0] . 'cache_data` WHERE `id` = \'' . mysql_real_escape_string($this->id) . "'", $this->mysql)) && ($query2 = mysql_query('DELETE FROM `' . $this->options['prefix'][0] . 'items` WHERE `feed_id` = \'' . mysql_real_escape_string($this->id) . "'", $this->mysql)))


  1. 
                        
  2.     $message = mysql_query("SELECT u2.username sender, m.subject, m.time, m.content FROM user u1, user u2, message m WHERE u1.uid=m.ownerid AND u2.uid=m.senderid AND u1.username='$user'");
  3. 
                        
  4.     $pending = mysql_query("SELECT u1.username requesting, u1.uid uid FROM user u1, user u2, pending_friend p WHERE u1.uid=p.requesting AND u2.uid=p.requested AND u2.username='$user'");
  5. 
                        
  6. $userinfo = mysql_query("SELECT * FROM user u WHERE u.username='$user'");
  7. $education = mysql_query("SELECT * FROM user u, attended a, school s WHERE u.uid=a.uid AND a.sid=s.sid AND u.username='$user'");
  8. $employment = mysql_query("SELECT * FROM user u, company c, employment e WHERE u.uid=e.uid AND c.cid=e.cid AND u.username='$user'");
  9. $songresult = mysql_query("SELECT * FROM user u, song s, likesSong ls WHERE ls.sid = s.sid AND ls.uid = u.uid AND u.username ='$user'
  10.     GROUP BY s.sname");
  11. $artistresult = mysql_query("SELECT * FROM user u, artist a, likesArtist la WHERE la.aid = a.aid AND la.uid = u.uid AND u.username = '$user' GROUP BY name");
  12. $activityresult = mysql_query("SELECT * FROM user u, activity a, interested_in i WHERE i.uid = u.uid AND i.actid = a.aid AND u.username = '$user' Group BY aname");
  13. $friendslist = mysql_query("SELECT u2.username FROM user u1, user u2, friend f WHERE ((u1.uid=f.user1 AND u2.uid=f.user2) OR (u1.uid=f.user2 AND u2.uid=f.user1)) AND (u1.username='$user')");
  14. $mutualfriends = mysql_query("SELECT u2.username FROM user u1, user u2, friend f WHERE ((u1.uid=f.user1 AND u2.uid=f.user2) OR (u1.uid=f.user2 AND u2.uid=f.user1)) AND (u1.username='$curr') AND u2.username IN (SELECT u2.username FROM user u1, user u2, friend f WHERE ((u1.uid=f.user1 AND u2.uid=f.user2) OR (u1.uid=f.user2 AND u2.uid=f.user1)) AND (u1.username='$user'))");
  15. $relationship = mysql_query("select u2.firstname, u2.lastname, r.status, u2.username from user u1, user u2, in_relationship_with r WHERE ((u1.uid=r.user1 AND u2.uid=r.user2) OR (u1.uid=r.user2 AND u2.uid=r.user1)) AND (u1.username = '$user')");
  16. 
                        





  1. 		$strsql = "UPDATE certificates SET cert_amt = cert_amt - pend_order_amt WHERE pend_order_id =".$ordID;
  2. 		mysql_query($strsql);
  3. 		$strsql = "UPDATE certificates SET pend_order_amt = 0, pend_order_id = 0 WHERE pend_order_id =".$ordID;
  4. 		mysql_query($strsql);
  5. 	//	$strsql = "DELETE certificates WHERE cert_amt <= 0";
  6. 	//	mysql_query($strsql);
  7. 		$strsql = "UPDATE orders SET ord_cert_id=".$certid.", ord_cert_amt=".$pendingamt." WHERE ordID =".$ordID;
  8. 		mysql_query($strsql);
  9. 	$sSQL = "SELECT ordID,ordName,ordAddress,ordAddress2,ordCity,ordState,ordZip,ordCountry,ordEmail,ordPhone,ordShipName,ordShipAddress,ordShipAddress2,ordShipCity,ordShipState,ordShipZip,ordShipCountry,ordPayProvider,ordAuthNumber,ordTotal,ordDate,ordStateTax,ordCountryTax,ordHSTTax,ordHandling,ordShipping,ordAffiliate,ordDiscount,ordDiscountText,ordComLoc,ordExtra1,ordExtra2,ordSessionID,ordAddInfo,ordShipType,payProvID FROM orders LEFT JOIN payprovider ON payprovider.payProvID=orders.ordPayProvider WHERE ordAuthNumber<>'' AND ordID='" . mysql_real_escape_string($sorderid) . "'";
  10. 	$result = mysql_query($sSQL) or print(mysql_error());
  11. 	//echo $sSQL;
  12. 	$result = mysql_query($sSQL) or print(mysql_error());
  13. 				$sql_d="SELECT * FROM digitaldownloads WHERE orderID=".$rs["cartOrderID"]." AND type='".$rs["cartProdId"]."'";
  14. 					$result_d=mysql_query($sql_d);	
  15. 						$sql_download="SELECT * FROM digitaldownloads WHERE active=1 AND type='".$rs["cartProdId"]."'";
  16. 						$result_download=mysql_query($sql_download);








Back to Top