mssql.driver.php

渣渣网络商店系统[ZZShop] V1.0

<?php
/*
+-------------------------------------------------------------------------------
|   {ProgID}
|   ========================================
|   by {Author}
|   (c) 2004 - 2005 ZhazhaSoft inc.
|   {HomePage}
|   ========================================
|   Web: http://www.zhazhasoft.com
|   Email: {Email}
|   Licence Info: {License}
+-------------------------------------------------------------------------------
|
|   > Virtual database abstract of mysql driver
|	> use this tier for abstract database operate
|   > 
|   > Script written by 帅的像人渣
|   > Last Modify: 2004-5-28 19:18
|
+-------------------------------------------------------------------------------
*/

  define('VDA_FETCH_ASSOC',		MYSQL_ASSOC);
  define('VDA_FETCH_NUM',		MYSQL_NUM);
  define('VDA_FETCH_BOTH',		MYSQL_BOTH);
  
  define('VDA_LIMIT',		0);
  define('VDA_TOP',			1);

  function vda_connect($host, $user, $pass)
  {
  	return mysql_connect($host, $user, $pass);
  }

  function vda_pconnect($host, $user, $pass)
  {
  	return mysql_pconnect($host, $user, $pass);
  }

  function vda_close($linkId)
  {
	return mysql_close($linkId);
  }

  function vda_create_db($dbName, $linkId)
  {
  	return mysql_create_db($dbName, $linkId);
  }
  
  function vda_drop_db($dbName, $linkId)
  {
  	return mysql_drop_db($dbName, $linkId);
  }
  
  function vda_list_dbs($linkId)
  {
  	return mysql_list_dbs($linkId);
  }
  
  function vda_select_db($dbName, $linkId)
  {
  	return mysql_select_db($dbName, $linkId);
  }
  
  function vda_db_name($rslt, $row)
  {
  	return mysql_db_name($rslt, $row);
  }
  
  function vda_query($qrStr, $linkId)
  {
  	return mysql_query($qrStr, $linkId);
  }
  
  function vda_data_seek($rslt, $row)
  {
  	return mysql_data_seek($rtlt, $row);
  }
  
  function vda_affected_rows($linkId)
  {
  	return mysql_affected_rows($linkId);
  }
  
  function vda_num_rows($rslt)
  {
  	return mysql_num_rows($rslt);
  }
  
  function vda_num_fields($rslt)
  {
  	return mysql_num_fields($rslt);
  }
  
  function vda_tablename($rslt, $index)
  {
  	return mysql_tablename($rslt, $index);
  }
  
  function vda_field_name($rslt, $field_offset)
  {
  	return mysql_field_name($rslt, $field_offset);
  }
  
  function vda_field_type($rslt, $field_offset)
  {
  	return mysql_field_type($rslt, $field_offset);
  }
  
  function vda_field_len($rslt, $field_offset)
  {
  	return mysql_field_len($rslt, $field_offset);
  }
  
  function vda_field_seek($rslt, $field_offset)
  {
  	return mysql_field_seek($rslt, $field_offset);
  }
  
  function vda_field_table($rslt, $field_offset)
  {
  	return mysql_field_table($rslt, $field_offset);
  }
  
  function vda_insert_id($linkId)
  {
  	$rslt = vda_query('select Last_insert_id() as InsertID', $linkId);
  	
  	$arr = vda_fetch_array($rslt, VDA_FETCH_ASSOC);
  	
  	return $arr['InsertID'];
  }
  
  function vda_list_tables($dbName, $linkId)
  {
  	return mysql_list_tables($dbName, $tableName, $linkId);
  }
  
  function vda_list_fields()
  {
  	return mysql_list_fields($dbName, $tableName, $linkId);
  }
  
  function vda_error($linkId)
  {
  	return mysql_error($linkId);
  }
  
  function vda_errno($linkId)
  {
  	return mysql_errno($linkId);
  }
  
  function vda_fetch_array($rslt, $fetchMode = VDA_FETCH_ASSOC)
  {
  	return mysql_fetch_array($rslt, $fetchMode);
  }
  
  function vda_fetch_object($rslt)
  {
  	return mysql_fetch_object($rslt);
  }
  
  function vda_fetch_field($rslt, $field_offset)
  {
  	return mysql_fetch_field($rslt, $field_offset);
  }
  
  function vda_escape_string($str)
  {
  	return mysql_escape_string($str);
  }
  
  function vda_version($linkId)
  {
  	$rslt = mysql_query('select version() as Version', $linkId);
  	
  	$arr = mysql_fetch_array($rslt);
  	
  	return $arr['Version'];
  }
  
  function vda_top_syntax()
  {
  	return VDA_LIMIT;
  }
  
  function vda_generate_sql($linkId, $dbName, $tables = '')
  {
  	if(empty($tables))
  	{
  		$tables	= Array();
  		
  		$rslt	= vda_list_tables($dbName, $linkId);
  		
  		for($i = 0, $cnt = vda_num_rows($rslt); $i < $cnt; $i++)
  		{
  			$tables[] = vda_tablename($rslt, $i);
  		}
  	}
  	
  	$dumpStr = '';
  	
  	for($i = 0, $cnt = Count($tables); $i < $cnt; $i++)
  	{
		$dumpStr	.= "DROP TABLE IF EXISTS {$tables[$i]};\n";
		
		$rslt		= vda_query("SHOW CREATE TABLE {$tables[$i]}", $linkId);
		
		$arr		= vda_fetch_array($rslt);
		
		$dumpStr	.= $arr['Create Table'] . ";\n\n";
		
		$rslt		= vda_query("SELECT * FROM {$tables[$i]}", $linkId);
		
		$numFields = vda_num_fields($rslt);
		
		$startTime = my_Time();
		
		while($row = vda_fetch_array($rslt, VDA_FETCH_NUM))
		{
			$comma = "";
			$dumpStr .= "INSERT INTO {$tables[$i]} VALUES(";
	
			for($i = 0, $cnt = vda_num_fields($rslt); $i < $cnt; $i++)
			{
				$dumpStr	.= $comma . "'" . vda_escape_string($row[$i]) . "'";

				$comma		= " ,";
			}
			
			$dumpStr .= ");\n";
			
			if(!((my_Time() - $startTime) % 30)) Header("Noop-Header: noop");
		}

		return $dumpStr;
	}
  }
  	
  function vda_autocommit()
  {
  }

  function vda_beginTrans()
  {
  }
  	
  function vda_rollback()
  {
  }
  	
  function vda_commit()
  {
  
  }
?>