1: <?php // nats.db.inc.php -- nats db module class
  2: 
  3: function ss($s) // safestring
  4: {
  5: return mysql_escape_string($s);
  6: }
  7: 
  8: class TNATS_DB
  9: 	{
 10: 	var $connected=false;
 11: 	var $sql=0;
 12: 	
 13: 	function Connect()
 14: 		{
 15: 		global $fnCfg;
 16: 		$this->sql=mysql_connect($fnCfg['db.server'],$fnCfg['db.username'],$fnCfg['db.password'])
 17: 			or die("Cannot connect to MySQL server");
 18: 		mysql_select_db($fnCfg['db.database'])
 19: 			or die("Cannot select MySQL database");
 20: 		$this->connected=true;
 21: 		return $this->sql;
 22: 		}
 23: 		
 24: 	function Disconnect()
 25: 		{
 26: 		mysql_close($this->sql);
 27: 		$this->sql=0;
 28: 		$this->connected=false;
 29: 		}
 30: 		
 31: 	function Query($query)
 32: 		{
 33: 		if (!$this->connected) return -1;
 34: 		return mysql_query($query,$this->sql);
 35: 		}
 36: 		
 37: 	function Free($result)
 38: 		{
 39: 		mysql_free_result($result);
 40: 		}
 41: 		
 42: 	function Fetch_Array($result)
 43: 		{
 44: 		return mysql_fetch_array($result);
 45: 		}
 46: 		
 47: 	function Affected_Rows()
 48: 		{
 49: 		return mysql_affected_rows();
 50: 		}
 51: 		
 52: 	function Insert_Id()
 53: 		{
 54: 		return mysql_insert_id();
 55: 		}
 56: 		
 57: 	function Num_Rows($result)
 58: 		{
 59: 		return mysql_num_rows($result);
 60: 		}
 61: 		
 62: 	}