Project: ejabberd-modules

Revision: 706

Author: kolargol

Date: 12 Aug 2008 08:35:39

• /jorge/trunk/class.db.php

  ......	@@ -392,7 +392,7 @@
  392	392
  393	393	return false;
  394	394
  395		}
  	395	}
  396	396	else{
  397	397
  398	398	$this->result = $result;
  ......	@@ -1855,6 +1855,62 @@
  1855	1855
  1856	1856	}
  1857	1857
  	1858	public function get_jorge_pref() {
  	1859
  	1860	$this->id_query = "Q061";
  	1861	$query="SELECT
  	1862	pref_id,
  	1863	pref_value
  	1864	FROM
  	1865	jorge_pref
  	1866	WHERE
  	1867	owner_id='".$this->user_id."'
  	1868	";
  	1869	$this->select($query,"raw");
  	1870	return $this->commit_select(array("pref_id","pref_value"));
  	1871
  	1872	}
  	1873
  	1874	public function set_jorge_pref($pref_id,$pref_value) {
  	1875
  	1876	$this->id_query = "Q062";
  	1877	$this->vital_check();
  	1878	$pref_id = $this->sql_validate($pref_id,"integer");
  	1879	$pref_value = $this->sql_validate($pref_value,"integer");
  	1880	if ($this->row_count("SELECT pref_id FROM jorge_pref WHERE owner_id='".$this->user_id."' AND pref_id='$pref_id'") === false) {
  	1881
  	1882	return false;
  	1883
  	1884	}
  	1885	if ($this->result > 0) {
  	1886
  	1887	$query="UPDATE
  	1888	jorge_pref
  	1889	SET
  	1890	pref_value='$pref_value'
  	1891	WHERE
  	1892	owner_id='".$this->user_id."'
  	1893	AND
  	1894	pref_id='$pref_id'
  	1895	";
  	1896	return $this->update($query);
  	1897
  	1898	}
  	1899	else{
  	1900
  	1901	$query="INSERT INTO
  	1902	jorge_pref(owner_id,pref_id,pref_value)
  	1903	VALUES
  	1904	('".$this->user_id."','$pref_id','$pref_value')
  	1905	";
  	1906	return $this->insert($query);
  	1907
  	1908	}
  	1909
  	1910	return false;
  	1911
  	1912	}
  	1913
  1858	1914	public function set_user_query($user_query) {
  1859	1915
  1860	1916	$this->user_query = $this->sql_validate($user_query,"string");