PageRenderTime 84ms queryFilters 76ms Sphinxql 136ms GetByIds 379ms meta 0ms repositoryFilters 306ms languageFilters 0ms sourceFilters 40ms

24,271 results for 'mysql_query lang:PHP repo:Dzoki/travianx' (84 ms)

Source

Language

Repository

mysql_query.php git://github.com/facebook/hiphop-php.git | PHP | 106 lines
6
7if (!is_null($tmp = @mysql_query()))
8	printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
9
10if (false !== ($tmp = @mysql_query($link)))
11	printf("[002] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
14
15if (NULL !== ($tmp = @mysql_query("SELECT 1 AS a", $link, "foo")))
16	printf("[003] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
17
18if (false !== ($tmp = mysql_query('THIS IS NOT SQL', $link)))
19	printf("[004] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
20
21if (false !== ($tmp = mysql_query("SELECT 'this is sql but with backslash g'\g", $link)))
22	printf("[005] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
mysql_query.php git://github.com/facebook/hiphop-php.git | PHP | 18 lines
5var_dump(create_test_table('query'));
6var_dump(mysql_query(
7  "insert into test_query (name) values ('test'),('test2')"));
8
9$res = mysql_query('select * from test_query');
10$row = mysql_fetch_assoc($res);
db_MYSQL.php https://hg.codeplex.com/traviant4 | PHP | 3,175 lines
14        		$q = "INSERT INTO " . TB_PREFIX . "users (username,password,access,email,timestamp,tribe,location,act,protect,clp,cp) VALUES ('$username', '$password', " . USER . ", '$email', $time, $tribe, $locate, '$act', $timep, '$rand', 1)";
15        		if(mysql_query($q, $this->connection)) {
16        			return mysql_insert_id($this->connection);
24        		$q = "INSERT INTO " . TB_PREFIX . "activate (username,password,access,email,tribe,timestamp,location,act,act2) VALUES ('$username', '$password', " . USER . ", '$email', $tribe, $time, $locate, '$act', '$act2')";
25        		if(mysql_query($q, $this->connection)) {
26        			return mysql_insert_id($this->connection);
33        		$q = "DELETE from " . TB_PREFIX . "activate where username = '$username'";
34        		return mysql_query($q, $this->connection);
35        	}
37        		$q = "DELETE from " . TB_PREFIX . "enforcement where id = '$id'";
38        		mysql_query($q, $this->connection);
39        	}
42        		$q = "UPDATE " . TB_PREFIX . "vdata set " . $what . "=" . $number . " where wref = $vid";
43        		$result = mysql_query($q, $this->connection);
44        		return mysql_query($q, $this->connection);
openerp-synchro.php http://hornerp.googlecode.com/svn/trunk/ | PHP | 980 lines
95
96		$result = mysql_query("select tax_class_id, tax_class_title from tax_class;");
97		if ($result) while ($row = mysql_fetch_row($result)) {
106
107		$result = mysql_query("select languages_id, name from languages;");
108		if ($result) while ($row = mysql_fetch_row($result)) {
117
118		$result = mysql_query("select categories_id, min(language_id) from categories_description group by categories_id;");
119		if ($result) while ($row = mysql_fetch_row($result)) {
119		if ($result) while ($row = mysql_fetch_row($result)) {
120			$resultb = mysql_query("select categories_id, categories_name from categories_description where categories_id=".$row[0]." and language_id=".$row[1].";");
121			if ($resultb and $row = mysql_fetch_row($resultb)) {
135		$lang_ids = substr($lang_ids, 0, strlen($lang_ids)-2);
136		$result = mysql_query("select categories_id, parent_id from categories order by parent_id;");
137		if ($result) while ($row = mysql_fetch_row($result)) {
migre.php http://gevu.googlecode.com/svn/trunk/ | PHP | 1,414 lines
80		//on récup?re les enfants de reférence et ceux ? comparer pour le niveau suivant
81		$rs2 = mysql_query($sql);
82		$r2=mysql_fetch_array($rs2);
93			$sql="UPDATE gevu_batiments SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];			          			
94			mysql_query($sql);
95	    }
98	        $sql="UPDATE gevu_diagnostics SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];			          			
99			mysql_query($sql);
100	    }
103			$sql="UPDATE gevu_diagnosticsxvoirie SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];			          			
104			mysql_query($sql);
105	    }
108	        $sql="UPDATE gevu_docsxlieux SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];			          			
109			mysql_query($sql);
110	    }
index.php https://code.google.com/p/nuked-klan/ | PHP | 1,568 lines
63
64        $result = mysql_query("SELECT moderateurs FROM " . FORUM_TABLE . " WHERE '" . $visiteur . "' >= level AND id = '" . $_REQUEST['forum_id'] . "'");
65        list($modos) = mysql_fetch_array($result);
90
91            $sql2 = mysql_query("SELECT thread_id FROM " . FORUM_MESSAGES_TABLE . " WHERE id = '" . $mess_id . "'");
92            list($thread_id) = mysql_fetch_row($sql2);
93
94            $sql3 = mysql_query("SELECT id FROM " . FORUM_MESSAGES_TABLE . " WHERE thread_id = '" . $thread_id . "' ORDER BY id LIMIT 0, 1");
95            list($mid) = mysql_fetch_row($sql3);
96
97            $sql = mysql_query("UPDATE " . FORUM_MESSAGES_TABLE . " SET titre = '" . $_REQUEST['titre'] . "', txt = '" . $_REQUEST['texte'] . "'" . $edition . ", usersig = '" . $_REQUEST['usersig'] . "', emailnotify = '" . $_REQUEST['emailnotify'] . "' WHERE id = '" . $mess_id . "'");
98
100            {
101                $upd = mysql_query("UPDATE " . FORUM_THREADS_TABLE . " SET titre = '" . $_REQUEST['titre'] . "' WHERE id = '" . $thread_id . "'");
102            }
dummyDBCreator.php git://git.savannah.nongnu.org/easymagazine.git | PHP | 672 lines
51           PRIMARY KEY (id));";
52        $result = mysql_query($cmd, $this->connection);
53        return $result;
59           'Summary of my first number', 1, '', '', NOW(), NOW())";
60        $result = mysql_query($cmd, $this->connection);
61        $cmd = "insert into ".TBPREFIX."numbers (id, indexnumber, published, title, subtitle, summary, commentsallowed, metadescription, metakeyword, created, updated)
63           'Summary of my second number', 1, '', '', NOW(), NOW())";
64        $result = mysql_query($cmd, $this->connection);
65        $cmd = "insert into ".TBPREFIX."numbers (id, indexnumber, published, title, subtitle, summary, commentsallowed, metadescription, metakeyword, created, updated)
67           'Summary of my third number', 0, '', '', NOW(), NOW())";
68        $result = mysql_query($cmd, $this->connection);
69        $cmd = "insert into ".TBPREFIX."numbers (id, indexnumber, published, title, subtitle, summary, commentsallowed, metadescription, metakeyword, created, updated)
71           'Summary of my first number', 1, '', '', NOW(), NOW())";
72        $result = mysql_query($cmd, $this->connection);
73        $cmd = "insert into ".TBPREFIX."numbers (id, indexnumber, published, title, subtitle, summary, commentsallowed, metadescription, metakeyword, created, updated)
lib.php http://part-db.googlecode.com/svn/trunk/ | PHP | 1,855 lines
208        debug_print($query);
209        $r = mysql_query ($query);
210        $d = mysql_fetch_row ($r);
239            debug_print ($query."<br>");
240            $result = mysql_query($query);
241            if ( mysql_num_rows( $result) == 0)
523            " ORDER BY name ASC;";
524        $result = mysql_query( $query) or die( mysql_error());
525        while ( $data = mysql_fetch_assoc( $result))
543            smart_escape( $parent_node) .");";
544        mysql_query( $query) or die( mysql_error());
545        return( mysql_insert_id());
553            " WHERE id=". smart_escape( $old) .";";
554        $result = mysql_query( $query) or die( mysql_error());
555        $data   = mysql_fetch_assoc( $result);
sql_functions.php git://pkgs.fedoraproject.org/php-voms-admin | PHP | 2,303 lines
33		// begin transaction in SQL
34		mysql_query("START TRANSACTION",$db_connection);
35		// invoke function
48						$updator);
49				if ( ! mysql_query($sql, $db_connection) ) {
50					$f_result = 0;
54		}
55		if ( $f_result === 1 ) mysql_query("COMMIT",$db_connection);
56			else mysql_query("ROLLBACK",$db_connection);
63		// begin transaction in SQL
64		mysql_query("START TRANSACTION",$db_connection);
65		$f_result = 1;
74					$updator);
75		if ( ! mysql_query($sql, $db_connection) ) {
76			$op_errno = mysql_errno($db_connection);
ebpls5502.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 2,181 lines
65	$iAddOns=strip_tags($iAddOns);
66	$insertComplex=mysql_query("INSERT INTO ebpls_buss_complex (taxfeeid,tfoid,coptr,revdate,addons,taxfeeid1,natureid) VALUES ('$aTAXFEEid','$explodeKey[0]','$iOperator',Now(),'$iAddOns','$explodeKey[1]','$natureid' )",$link2db);
67	//, taxfeeoption='$iOption', itfotype='$itfotype'
67	//, taxfeeoption='$iOption', itfotype='$itfotype'
68	$updateMe = mysql_query("UPDATE ebpls_buss_taxfeeother SET taxfeeamtfor='$iAmountFormula', taxfeeoption='$iOption', uom='$iuom',defamt=$iMinAmount WHERE natureid = '$natureid'  and tfo_id='$aTFOID' and taxfeeid='$aTAXFEEid' ",$link2db);
69	//$tbl_DeleRecord_123=th_query($tbl_DeleRecord123)// or die("Cannot Update...");;
102	// this must be given confirmation page first before deletion...(subject for enhancement)
103	$chkRecord=mysql_query("Select * from ebpls_buss_taxfeeother where taxfeeid='$valueof_tfoid' and tfo_id='$aTFOID' and natureid='$natureid' ",$link2db);
104	$mychkRow=mysql_num_rows($chkRecord);
115	if ($ctaxfeeind==3){
116	$updateNature=mysql_query("UPDATE ebpls_buss_nature SET natureoption=Null WHERE natureid='$cnatureid'",$link2db); // update both nature with L flag for range link.
117
119	
120	$seleTaxFeeOther=mysql_query("Select * from ebpls_buss_taxfeeother WHERE taxfeeid='$ctaxfeeid'",$link2db);
121	$rowtfother=mysql_num_rows($seleTaxFeeOther);
ebpls_comparative_annual.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 723 lines
80
81$result=mysql_query("select lguname, lguprovince, lguoffice from ebpls_buss_preference") 
82	or die(mysql_error());
85    //taxes
86$sumtaxq1 = mysql_query("select sum(taxes) from comparative_statement where for_year='$dateprev' and
87						paid = 0 and month>=1 and month<=3");
89
90$sumtaxq2 = mysql_query("select sum(taxes) from comparative_statement where for_year='$dateprev' and
91						paid = 0 and month>=4 and month<=6");
93
94$sumtaxq3 = mysql_query("select sum(taxes) from comparative_statement where for_year='$dateprev' and
95						paid = 0 and month>=7 and month<=9");
97
98$sumtaxq4 = mysql_query("select sum(taxes) from comparative_statement where for_year='$dateprev' and
99						paid = 0 and month>=10 and month<=12");
mtop.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 711 lines
15if ($permit_type=='Motorized' || $permit_type=='Franchise') {
16$checkrentype = @mysql_query("select * from ebpls_motorized_penalty where permit_type = '$permit_type'");
17$checkrentype1 = @mysql_fetch_assoc($checkrentype);
22		and permit_type='$permit_type' and retire>'2'");
23		$totvehicles = @mysql_query("select * from ebpls_motorized_vehicles where motorized_operator_id = '$owner_id' 
24		and permit_type='$permit_type' and retire>'2'");
24		and permit_type='$permit_type' and retire>'2'");
25		$totnewvehicles = @mysql_query("select * from ebpls_motorized_vehicles where motorized_operator_id = '$owner_id' and permit_type='$permit_type' and retire='0' and transaction = 'New'");
26} elseif ($stat =="Transfer/Dropping") {
48} elseif ($stat=="Transfer/Dropping") {
49	$getoldvec = @mysql_query("select * from ebpls_motorized_vehicles where permit_type= '$permit_type' and motorized_operator_id = '$owner_id' and transaction = 'Drop' and retire = '1'");
50$theorig = @mysql_num_rows($getoldvec);
53	if ($stat == "New") {
54        $getoldvec = @mysql_query("select * from ebpls_motorized_vehicles where permit_type= '$permit_type' and motorized_operator_id = '$owner_id' and retire = '0'");
55	} else {
tinyerp-synchro.php http://hornerp.googlecode.com/svn/trunk/ | PHP | 674 lines
33	
34  $result=mysql_query("select tax_rate_id, tax_rate*100 from ".$dbprefix."vm_tax_rate;");
35  if ($result) while ($row=mysql_fetch_row($result)) {
43
44  mysql_query("truncate  table ".$dbprefix."vm_product_attribute;");
45  mysql_query("truncate  table ".$dbprefix."vm_product_price;");
45  mysql_query("truncate  table ".$dbprefix."vm_product_price;");
46  mysql_query("truncate  table ".$dbprefix."vm_product_tax;");
47  mysql_query("truncate  table ".$dbprefix."vm_product_category_xref;");
47  mysql_query("truncate  table ".$dbprefix."vm_product_category_xref;");
48  mysql_query("delete from ".$dbprefix."jf_content where reference_table='vm_product' and reference_field in ('product_s_desc','product_desc') ;");
49  $result=mysql_query("truncate  table ".$dbprefix."vm_product;");
49  $result=mysql_query("truncate  table ".$dbprefix."vm_product;");
50  //$result=mysql_query("update ".$dbprefix."vm_product set `product_publish` = 'N';");
51  //$result=mysql_query("update ".$dbprefix."vm_product set ".
class.factuur.php http://freshinvoice.googlecode.com/svn/trunk/ | PHP | 1,084 lines
38			$query = "SELECT klantId FROM klant WHERE mail=''";
39			$query = mysql_query($query) or die (mysql_error());
40			if(mysql_num_rows($query)>0){
46			('".$mail."','".md5($password1)."','".addslashes($voornaam)."','".addslashes($tussenvoegsel)."','".addslashes($achternaam)."','".$geslacht."','".addslashes($bedrijfsnaam)."','".addslashes($straatnaam)."','".addslashes($huisnummer)."','".addslashes($postcode)."','".addslashes($plaatsnaam)."','".addslashes($land)."','".addslashes($telefoon)."','".addslashes($fax)."','".addslashes($BTWnummer)."','".addslashes($KVKnummer)."','".$KVKplaats."','".addslashes($bedrijfsvorm)."')";
47			mysql_query($query) or die (mysql_error());
48			
91			$query 	= "SELECT password FROM klant WHERE klantId='".$klantId."'";
92			$query 	= mysql_query($query) or die (mysql_error());
93			
130			".$extra." WHERE klantId='".$klantId."'";
131			mysql_query($query) or die (mysql_error());
132			
153			$query = "INSERT INTO artikelen (catId,naam,periode,inkoop_prijs,verkoop_prijs) VALUES ('".$catId."','".addslashes($naam)."','".$periode."','".$inkoop_prijs."','".$verkoop_prijs."')";
154			mysql_query($query) or die (mysql_error());
155			
index.php http://thegamesdb.googlecode.com/svn/trunk/ | PHP | 2,542 lines
22    $query = "SELECT * FROM users WHERE id=$cookieid AND userpass='$cookiepass'";
23    $result = mysql_query($query) or die('Query failed: ' . mysql_error());
24    $cookieuser = mysql_fetch_object($result);
49    $query = "SELECT * FROM users WHERE username='$username' AND userpass=PASSWORD('$password')";
50    $result = mysql_query($query) or die('Query failed: ' . mysql_error());
51    $user = mysql_fetch_object($result);
53        $query = "SELECT * FROM users WHERE id=$user->lastupdatedby_admin";
54        $result = mysql_query($query) or die('Query failed: ' . mysql_error());
55        $adminuser = mysql_fetch_object($result);
109    $query = "SELECT * FROM users WHERE id=$loggedin_userid AND userpass='$loggedin_password'";
110    $result = mysql_query($query) or die('Query failed: ' . mysql_error());
111    $user = mysql_fetch_object($result);
155$query = "SELECT * FROM languages ORDER BY name";
156$result = mysql_query($query) or die('Query failed: ' . mysql_error());
157while ($lang = mysql_fetch_object($result)) {
billing.php http://bios.googlecode.com/svn/trunk/ | PHP | 681 lines
7{
8	mysql_query("UPDATE setting SET setting_layout='$setting_layouts' LIMIT 1");
9	$setting_layout = mysql_result(mysql_query("SELECT setting_layout FROM setting LIMIT 1"),0);
21$zone_tarif=date("G",mktime(gmdate("H")+$setting_timezone,gmdate("i"),gmdate("s"),gmdate("m"),gmdate("d"),gmdate("Y")));
22$data_tarif=mysql_fetch_array(mysql_query("SELECT tarif_perjam,tarif_min,tarif_min_durasi FROM tarif WHERE tarif_pkl=$zone_tarif"));
23?>
49        $client_status=1;
50		$status_now=mysql_result(mysql_query("SELECT client_status FROM client WHERE client_id=$start"),0);
51		if($status_now <> $client_status && $status_now=='0')
52		{
53			mysql_query("UPDATE client SET client_start='$client_start',client_status=$client_status WHERE client_id=$start");
54			mysql_query("UPDATE client_status SET client_status_old=$client_status WHERE client_status_id=$start");
61
62		$status_now=mysql_result(mysql_query("SELECT client_status FROM client WHERE client_id=$stop"),0);
63		if($start==1) $status_now=1;
topic.php http://novaboard.googlecode.com/svn/trunk/ | PHP | 1,076 lines
48$query2167 = "select APPROVED from {$db_prefix}posts WHERE TOPIC_ID='$topic' AND TITLE!=''" ;
49$result2167 = mysql_query($query2167) or die("topic.php - Error in query: $query2167") ; 
50$approved = mysql_result($result2167, 0);
58
59$result2167 = mysql_query($query2167) or die("topic.php - Error in query: $query2167") ; 
60$does_exist = mysql_num_rows($result2167);
85		$query3 = "select CAN_VIEW_FORUM, CAN_READ_TOPICS, CAN_ADD_TOPICS, CAN_REPLY_TOPICS, CAN_DOWNLOAD_ATTACHMENT from {$db_prefix}permissions WHERE GROUP_ID='$role' AND FORUM_ID='$forum_id'" ;
86		$result3 = mysql_query($query3) or die("topic.php - Error in query: $query3") ;                                  
87		while ($results3 = mysql_fetch_array($result3)){
95$query211 = "select READ_ONLY from {$db_prefix}categories WHERE ID='$forum_id'" ;
96$result211 = mysql_query($query211) or die("board.php - Error in query: $query211") ;                                  
97$read_only = mysql_result($result211, 0);
113$topic=escape_string($topic);
114mysql_query("UPDATE {$db_prefix}posts SET views=views+1 WHERE topic_id = '$topic' AND TITLE!=''");
115
siteadmin.php http://rate-my-boss.googlecode.com/svn/trunk/ | PHP | 396 lines
24$query = "SELECT userId FROM user WHERE isPending";
25$result = mysql_query($query);
26
29		$subquery = "UPDATE user SET isPending=0 WHERE userId=$row[userId]";
30		mysql_query($subquery);
31
33		$query = "INSERT INTO userActivity (userId, type) VALUE ($row[userId], 'approval')";
34		$result = mysql_query($query);
35	}
37		$subquery = "DELETE FROM user WHERE userId=$row[userId]";
38		mysql_query($subquery);
39	}
45$query = "SELECT * FROM user WHERE isPending ORDER BY type";
46$result = mysql_query($query);
47
admin.php https://code.google.com/p/nuked-klan/ | PHP | 986 lines
156
157                $sql = mysql_query("INSERT INTO " . GALLERY_TABLE . " ( `sid` , `titre` , `description` , `url` , `url2` , `url_file` , `cat` , `date` , `autor` ) VALUES ( '' , '" . $titre . "' , '" . $description . "' , '" . $url . "' , '" . $url2 . "' , '" . $url_file . "' , '" . $cat . "' , '" . $date . "' , '" . $auteur . "')");
158                
161                $acdate = time();
162                $sqlaction = mysql_query("INSERT INTO ". $nuked['prefix'] ."_action  (`date`, `pseudo`, `action`)  VALUES ('".$acdate."', '".$user[0]."', '".$texteaction."')");
163                // Fin action
168                . "</div>\n";
169                $sqls = mysql_query("SELECT sid FROM " . GALLERY_TABLE . " WHERE date = '" . $date . "' AND titre='" . $titre . "'");
170                list($sid) = mysql_fetch_array($sqls);
203
204        $sqls = mysql_query("SELECT titre FROM " . GALLERY_TABLE . " WHERE sid = '" . $sid . "'");
205        list($titre) = mysql_fetch_array($sqls);
206        $titre = mysql_real_escape_string($titre);
207        $sql = mysql_query("DELETE FROM " . GALLERY_TABLE . " WHERE sid = '" . $sid . "'");
208        $del_com = mysql_query("DELETE FROM " . COMMENT_TABLE . " WHERE im_id = '" . $sid . "' AND module = 'Gallery'");
admin.php https://code.google.com/p/nuked-klan/ | PHP | 845 lines
89
90        $sql = mysql_query("INSERT INTO " . LINKS_TABLE . " ( `id` , `date` , `titre` , `description` , `url` , `cat` , `webmaster`, `country`, `count` , `broke` ) VALUES ( '' , '" . $date . "' , '" . $titre . "' , '" . $description . "' , '" . $url . "' , '" . $cat . "' , '" . $webmaster ."' , '" . $country . "' , '' , '' )");
91        // Action
93        $acdate = time();
94        $sqlaction = mysql_query("INSERT INTO ". $nuked['prefix'] ."_action  (`date`, `pseudo`, `action`)  VALUES ('".$acdate."', '".$user[0]."', '".$texteaction."')");
95        //Fin action
100                . "</div>\n";
101        $sql = mysql_query("SELECT id FROM " . LINKS_TABLE . " WHERE titre = '" . $titre . "' AND date='".$date."'");
102        list($link_id) = mysql_fetch_array($sql);
113
114        $sql = mysql_query("SELECT titre FROM " . LINKS_TABLE . " WHERE id = '" . $link_id . "'");
115        list($titre) = mysql_fetch_array($sql);
116        $titre = mysql_real_escape_string(stripslashes($titre));
117        $sql = mysql_query("DELETE FROM " . LINKS_TABLE . " WHERE id = '" . $link_id . "'");
118        $del_com = mysql_query("DELETE FROM " . COMMENT_TABLE . " WHERE im_id = '" . $link_id . "' AND module = 'Links'");
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21