<?php
defined( '_VALID_LM' ) or die( 'Direct Access to this location is not allowed.' );
	/*
	 *	WSI Flat Table Manager UPDATE functions
	 * (C)2003 WSI, ALL RIGHTS RESERVED. E-mail: support@webbstyle.com
	 * Version stable 0.1
	 *
	 * Flat File Database Engine
	*********************************************************************************************/

	if (!defined("DB_ERRORMSG_101")) { define ("DB_ERRORMSG_101", "ERROR 101 SQL-string not valid."); }
	if (!defined("DB_ERRORMSG_102")) { define ("DB_ERRORMSG_102", "ERROR 102 Could not open table schema, check table name and path."); }

	function &_update(&$thiz, $sqlstring) {

		$rs = false;

		$sp=&$thiz->sp;
        $sp->setString($sqlstring);
		$vals=$sp->parseSqlQuery();
		
		$table=$vals->table;
		$search=trim($vals->where_expr);
		for($i=0;$i<count($vals->colNames);$i++)
		{
		if($vals->fieldValues[$i][0]=="'" || $vals->fieldValues[$i][0]=="\"" )
		$set[ ($vals->colNames[$i] )]=substr($vals->fieldValues[$i],1,strlen($vals->fieldValues[$i])-2);
		else $set[ ($vals->colNames[$i] )]=$vals->fieldValues[$i];
		}

		if (!@include_once ($thiz->db_name.$table.'/schema.php')) {

			$thiz->ErrorMsg[0] = DB_ERRORMSG_102;

		} else {

			if (isset ($columns) && is_array ($columns)) { $thiz->columns = $columns; }
			include_once('read_table.php');
			is_array ($set) ? $rs = _read_table($thiz, $thiz->db_name.$table, '', $search) :
									$thiz->ErrorMsg[] = DB_ERRORMSG_101;

			if (is_array ($thiz->rowset)) {

				foreach ($thiz->rowset as $row) {

					foreach ($row as $key=>$val) { if (!isset ($set[$key])) { $set[$key] = $val; } }

					include_once('write_table.php');
					if ($rs = _write_table($thiz, $table, $row['id'], $set)) {

						$thiz->aff_rows++;

					} else {

						$rs = false;

					}

				}

			} else {

				$thiz->aff_rows = 0;

			}

			$thiz->rowset = false;

		}

		if ($rs) {

			return true;

		} else {

			return false;

		}

	}

?>