<?
require("../common/database.php");
require("../common/utility.php");
$objDatabase = new cDatabase();
$oCompleteText = "";
$file  =  file("art_table.txt");
$j = count($file);
$oOffset;
echo "j: $j<BR>";
for($i=0; $i<$j; $i++)
	{
	$oCompleteText .= $file[$i];
	}
fExtract($oCompleteText);


function fExtract($pText)
	{
	global $objDatabase;
	$oOffset = 0;
	while((strlen($pText) > $oOffset) && (strpos($pText, "^", $oOffset) > 0))
		{
	 	// find end of id
		/*
	 	if(strpos ($pText, "^", $oOffset))
	 		{
			echo "looking for ^ ending id starting at oOffset: $oOffset<BR>";
	 		$oOffset = strpos ($pText, "^", $oOffset);
			echo "found it at offset $oOffset<BR>";
			if($oNewOffset > 0)
				$oNewOffset++;
	 		$oID = substr($pText,$oNewOffset,$oOffset-$oNewOffset);
			echo "<BR>the newfound id is ID: $oID<BR>";
	 		$oOffset ++;
	 		}
		 */

	 	// find end of id
	 	if(strpos ($pText, "^", $oOffset))
	 		{
	 		$oNewOffset = strpos ($pText, "^", $oOffset);
	 		$oID = substr($pText,$oOffset,$oNewOffset-$oOffset);
			//$oID = str_replace("\"\"","\"",$oName);
	 		$oOffset = $oNewOffset + 1;
	 		}


	 	// find end of name
	 	if(strpos ($pText, "^", $oOffset))
	 		{
	 		$oNewOffset = strpos ($pText, "^", $oOffset);
	 		$oName = substr($pText,$oOffset,$oNewOffset-$oOffset);
			$oName = str_replace("\"\"","\"",$oName);
	 		$oOffset = $oNewOffset + 1;
	 		}

	 	// find end of filename
	 	if(strpos ($pText, "^", $oOffset))
	 		{
	 		$oNewOffset = strpos ($pText, "^", $oOffset);
	 		$oFilename = substr($pText,$oOffset,$oNewOffset-$oOffset);
	 		$oOffset = $oNewOffset + 1;
	 		}

	 	// find end of email
	 	if(strpos ($pText, "^", $oOffset))
	 		{
	 		$oNewOffset = strpos ($pText, "^", $oOffset);
	 		$oEmail = substr($pText,$oOffset,$oNewOffset-$oOffset);
	 		$oOffset = $oNewOffset + 1;
	 		}

	 	// find end of title
	 	if(strpos ($pText, "^", $oOffset))
	 		{
	 		$oNewOffset = strpos ($pText, "^", $oOffset);
	 		$oTitle = substr($pText,$oOffset,$oNewOffset-$oOffset);
			$oTitle = str_replace("\"\"","\"",$oTitle);
			$oTitle = str_replace("\"\"","\"",$oTitle);
	 		$oOffset = $oNewOffset + 1;
	 		}

	 	// find end of posted
	 	if(strpos ($pText, "^", $oOffset))
	 		{
	 		$oNewOffset = strpos ($pText, "^", $oOffset);
	 		$oPosted = substr($pText,$oOffset,$oNewOffset-$oOffset);
	 		$oOffset = $oNewOffset + 1;
	 		}

	 	// find end of IP
	 	if(strpos ($pText, "^", $oOffset))
	 		{
	 		$oNewOffset = strpos ($pText, "^", $oOffset);
	 		$oIP = substr($pText,$oOffset,$oNewOffset-$oOffset);
	 		$oOffset = $oNewOffset + 1;
	 		}

	 	// find end of Visible
	 	if(strpos ($pText, "^", $oOffset))
	 		{
	 		$oNewOffset = strpos ($pText, "^", $oOffset);
	 		$oVisible = substr($pText,$oOffset,$oNewOffset-$oOffset);
	 		$oOffset = $oNewOffset + 1;
	 		}

	 	// find end of Story
	 	if(strpos ($pText, "^", $oOffset))
	 		{
	 		$oNewOffset = strpos ($pText, "^", $oOffset);
			//$oNewOffset = strrpos($pText,"\"", $oOffset);
	 		$oStory = substr($pText,$oOffset,$oNewOffset-$oOffset);
			$oLengthFirst = strlen($oStory);
			$oLastQuote = strrpos($oStory,"\"");
	 		$oStory = substr($oStory,0,$oLastQuote+1);
			$oLengthSecond = strlen($oStory);

			$oStory = str_replace("\"\"","\"",$oStory);
	 		$oOffset = $oNewOffset - ($oLengthFirst - $oLengthSecond);
	 		}


	 	echo "oID: $oID<BR>";
	 	echo "oName: $oName<BR>";
	 	echo "oFilename: $oFilename<BR>";
	 	echo "oEmail: $oEmail<BR>";
	 	echo "oTitle: <FONT COLOR=BLUE>$oTitle</FONT><BR>";
	 	echo "oPosted: $oPosted<BR>";
	 	echo "oIP: $oIP<BR>";
	 	echo "oVisible: $oVisible<BR>";
	 	echo "oStory: $oStory<BR>";

		if(strlen($oName) > 2)
		  $oName = substr($oName,1,strlen($oName)-2);
		else
			$oName = "";

    if(strlen($oFilename) > 2)
		  $oFilename = substr($oFilename,1,strlen($oFilename)-2);
		else
			$oFilename = "";

    if(strlen($oEmail) > 2)
		  $oEmail = substr($oEmail,1,strlen($oEmail)-2);
		else
			$oEmail = "";

    if(strlen($oTitle) > 2)
		  $oTitle = substr($oTitle,1,strlen($oTitle)-2);
		else
			$oTitle = "";

    if(strlen($oStory) > 2)
		  $oStory = substr($oStory,1,strlen($oStory)-2);
		else
			$oStory = "";

    if(strlen($oVisible) > 2)
		  $oVisible = substr($oVisible,1,strlen($oVisible)-2);
		else
			$oVisible = "";

		if($oVisible == "")
			$oVisible = "no";

		if($oVisible != "yes" && $oVisible != "no")
			$oVisible = "no";


		$oName = addslashes($oName);
		$oEmail = addslashes($oEmail);
		$oFilename = addslashes($oFilename);
		$oTitle = addslashes($oTitle);
		$oStory = addslashes($oStory);
		$oPosted = strtotime($oPosted);

		echo "INSERT INTO gallery_table VALUES ('', '$oName', '$oEmail', '$oFilename', '$oTitle', '$oStory', '$oVisible', $oPosted);";
		$oStrSql =  "INSERT INTO gallery_table VALUES ('', '$oName', '$oEmail', '$oFilename', '$oTitle', '$oStory', '$oVisible', $oPosted)";
		echo "<BR>";
	 	//echo "<HR>";
    $result = $objDatabase->mfQuery($oStrSql, "RECORDSET");
		}
  } // end function
?>