<?php
defined( '_VALID_LM' ) or die( 'Direct Access to this location is not allowed.' );
	/*
	 *	WSI Flat Table Manager DELETE functions
	 * (C)2003 WSI, ALL RIGHTS RESERVED. E-mail: support@webbstyle.com
	 * Version stable 0.1
	 *
	 * Flat File Database Engine
	*********************************************************************************************/

	if (!defined("DB_ERRORMSG_102")) { define ("DB_ERRORMSG_102", "ERROR 102 Could not open table schema, check table name and path."); }

	function &_delete(&$thiz, $sqlstring) {

		$rs = false;

		// format sqlstring
		$search = array("DELETE ", "FROM ", " WHERE ", " = ");
		$replace = array("", "", "|", "=");
		$sqlstring = str_replace ($search, $replace, $sqlstring);
		$sqlstring = explode ("|", trim($sqlstring));
		$table = $sqlstring[0];

		if (!@include ($thiz->db_name.$table.'/schema.php')) {

			$thiz->ErrorMsg[0] = DB_ERRORMSG_102;

		} else {

			if (isset ($columns) && is_array ($columns)) { $thiz->columns = $columns; }
			isset ($sqlstring[1]) ? $search = $sqlstring[1] : $search = '';

			include_once('read_table.php');
			$rs = _read_table($thiz, $thiz->db_name.$table, array("id"), $search);

			if (is_array ($thiz->rowset)) {

				include_once('delete_table.php');

				foreach ($thiz->rowset as $row) {

					if ($rs = _delete_table($thiz, $table, $row['id'])) {

						$thiz->aff_rows++;

					} else {

						$rs = false;

					}

				}

			} else {

				$thiz->aff_rows = 0;

			}

			$thiz->rowset = false;

		}

		if ($rs) {

			return true;

		} else {

			return false;

		}

	}

?>