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



  1. 		} else {
  2. 			$query = mysql_query("SELECT fa.id_account as id_account, a.gmlevel as gmlvl, fa.enablepm as enablepm FROM account a LEFT JOIN (forum_accounts fa) ON a.id = fa.id_account WHERE LOWER(fa.displayname)=LOWER('".$_POST['uto']."')");
  3. 			} else {
  4. 				$queryb = mysql_query("SELECT id_account_to FROM forum_pm WHERE id_account_to='".$my['id_account']."' AND isdeleted!='".$my['id_account']."'") OR DIE (mysql_error());
  5. 		} else {
  6. 			$queryc = mysql_query("INSERT INTO forum_pm(id_account_to, id_account_from, subject, message, isread, date, hour, issignature, isbbcode) VALUES ('".$my['id_account']."','".$_SESSION['userid']."','".$_POST['usu']."','".$_POST['ume']."','0','".date('Y-m-d')."','".date('H:i:s')."','".$_POST['issigned']."','".$_POST['isbbcode']."')") or die (mysql_error());
  7. 		for($i=0;$i<count($_POST['pmdelete']);$i++) {
  8. 			@mysql_query("UPDATE forum_pm SET isdeleted='".$_SESSION['userid']."' WHERE id_pm='".$_POST['pmdelete'][$i]."' AND id_account_".$source."='".$_SESSION['userid']."' AND isdeleted=0") or die (mysql_error());
  9. 			@mysql_query("DELETE FROM forum_pm WHERE id_pm='".$_POST['pmdelete'][$i]."' AND id_account_".$source."='".$_SESSION['userid']."' AND isdeleted!='".$_SESSION['userid']."' AND isdeleted!=0") or die (mysql_error());
  10. 						if ($_REQUEST['pm']!='') {
  11. 							$query = mysql_query("SELECT *, a.displayname as dn, a.signature as signa FROM forum_pm p LEFT JOIN (forum_accounts a) ON p.id_account_from = a.id_account WHERE id_account_to='".$_SESSION['userid']."' AND isdeleted!='".$_SESSION['userid']."' AND id_pm='".$_REQUEST['pm']."'GROUP BY p.id_pm") or die (mysql_error());
  12. 								if ($row['issignature']=='1') { $body .= '<img src="new-hp/images/pixel.gif" style="background-color: white;" width=100% height=1><br><div style="margin-top: 10px; width: 100%; min-height: 50px; max-height: 170px; overflow: auto;">'.bbcode($row['signa']).'</div>'; }
  13. 								$query = mysql_query("UPDATE forum_pm SET isread='1' WHERE id_pm='".$row['id_pm']."'") or die (mysql_error());
  14. 						} else {
  15. 							$query = mysql_query("SELECT *, DATE_FORMAT(CONVERT_TZ(CONCAT(`date`, ' ', `hour`), '".$GMT[$SETTING['WEB_GMT']][0]."', '".verifygmt($_SESSION['userid'])."'), '%Y-%m-%d at %h:%i %p') as `date`, a.displayname as dn FROM forum_pm p LEFT JOIN (forum_accounts a) ON p.id_account_from = a.id_account WHERE id_account_to='".$_SESSION['userid']."' AND isdeleted!='".$_SESSION['userid']."' GROUP BY p.id_pm ORDER BY isread ASC, date DESC, hour DESC") or die (mysql_error());




  1. 
                        
  2. 	if (!mysql_query ($query))
  3. 					$query = "update wars set over=30, causer=".$me->aid.", end_of_war=now() where aid1=".$aid1." and aid2=".$aid2;
  4. 					if (!mysql_query($query))
  5. 						$query = "select A.uid,  A.villageid, A.outpost_of, A.x, A.y, A.name, B.aid,B.user  from village as A, user as B where A.uid=".$player[$village_key]." and A.name='".$village."' AND A.uid=B.uid";
  6. 						if (!$res=mysql_query($query))
  7. 						$query = "select A.villageid, B.over from war_flags as A, wars as B where A.aid1=B.aid1 AND A.aid2=B.aid2 AND A.villageid=".$villageid." AND B.over=0  AND A.aid1=".$aid1."  AND A.aid2=".$aid2 ; //FIXME: insegsamt nur ein fähnchen pro dorf oder pro krieg? Im Moment: pro Krieg
  8. 						if(!$res = mysql_query($query))
  9. 									$query = "insert into war_flags (aid1, aid2, villageid,current_villageid) values (".$aid1.", ".$aid2.", ". $villageid.", ".$villageid.")";
  10. 									if (!mysql_query($query))
  11. 			$query = "update wars set over=20, causer='".$me->aid."', end_of_war=now() where aid1=".(int)$tmp[0]." and aid2=".(int)$tmp[1];
  12. 			if (!mysql_query($query))
  13. 				$query = "select flag_score1, flag_score2 from wars where  aid1=".(int)$tmp[0]." and aid2=".(int)$tmp[1];
  14. 				if (!$res = mysql_query($query))
  15. 			$query = "select A.*, date_format(A.begin, \"%d.%c.%Y - %H:%i\") as startdate, time_to_sec(timediff(now(), A.begin)) as remainingTime,B.tag as tag1, C.tag as tag2, D.score1,D.score2 from wars A join allies B on (A.aid1=B.aid) join allies C on (A.aid2=C.aid) join war_stats_tmp D on (A.aid1=D.aid1 AND A.aid2=D.aid2)  AND over = 0";
  16. 		if ($res = mysql_query($query))













Back to Top