[!]<!--HAS_WEBDNA_TAGS-->[/!]
[include file=protect.inc&group=]
[include file=header.inc]

<script language="javascript" >
<!--
	function OpenUpload(the_id, the_return)
	{
		window.open('upload.htm?theID='+the_id+'&theReturn='+the_return,'Upload', 'menubar=0,location=0,width=400,height=400,resizable=1,scrollbars=1');
	}
//-->
</script>
<b><a href="default.htm">Home</a></b><br>
<br>
[showif [raw][show][/raw]=[show]]
	[text]show=list[/text]
[/showif]

[showif [action]=update]
	[text]the_date_expires=[date_expires][/text]
	[showif [url][date_expires][/url]=]
		[text]the_date_expires=1/1/2010[/text]
	[/showif]
	[showif [format days_to_date %Y][math]{[the_date_expires]}[/math][/format]<1980]
		[text]the_date_expires=[format days_to_date %m/%d/][math]{[the_date_expires]}[/math][/format][math][format days_to_date %Y][math]{[the_date_expires]}[/math][/format]+100[/math][/text]
	[/showif]
	<!--Updated-->
	[replace db=admin/ad.db&eqUSER_IDdatarq=[g_member_id]&eqIDdatarq=[id]&IDblnk=T]VISIBLE=&DATE_EXPIRES=[url][the_date_expires][/url]&DATE_MODIFIED=[date]&[formvariables name=__&exact=f][getchars start=3][name][/getchars]=[url][value][/url]&[/formvariables][/replace]
	[commitdatabase db=admin/ad.db]

	[hideif [g_member_id]=240]
	[include file=notify.inc&theID=[id]]
	[/hideif]
	[appendfile file=admin/log.db][date]	[time]	[ipaddress]	[url][the_user];[the_pass][/url]	[url][formvariables][name]=[url][value][/url]&[/formvariables][/url][unurl]%0D%0A[/unurl][/appendfile]
[/showif]

[showif [action]=delete]
	Really delete? <a href="modify.htm?action=deleteOK&id=[id]">Yes</a> | <a href="modify.htm">No</>
[/showif]

[showif [action]=deleteOK]
	[delete db=admin/ad.db&eqUSER_IDdatarq=[g_member_id]&eqIDdatarq=[id]]
	[commitdatabase db=admin/ad.db]
	[appendfile file=admin/log.db][date]	[time]	[ipaddress]	[url][the_user];[the_pass][/url]	[url][formvariables][name]=[url][value][/url]&[/formvariables][/url][unurl]%0D%0A[/unurl][/appendfile]
[/showif]

[showif [action]=deleteImage]
	[replace db=admin/ad.db&eqUSER_IDdatarq=[g_member_id]&eqIDdatarq=[id]]IMAGE=[/replace]
	[commitdatabase db=admin/ad.db]
	[appendfile file=admin/log.db][date]	[time]	[ipaddress]	[url][the_user];[the_pass][/url]	[url][formvariables][name]=[url][value][/url]&[/formvariables][/url][unurl]%0D%0A[/unurl][/appendfile]
[/showif]

[showif [show]=list]
	[search db=admin/ad.db&eqUSER_IDdatarq=[g_member_id]&DATE_MODIFIEDtype=date&asDATE_MODIFIEDsort=1]
	<table>
	<tr>
		<td></td><td><b>Visible</b></td><td><b>Date Modified</b></td><td><b>Name</b></td><td><b>Subject</b></td><td><b>Expires</b></td>
	</tr>
	[showif [numfound]=0]
	<tr><td></td><td colspan="4">No records found</td></tr>
	[/showif]
	[founditems]
	<tr>
		<td valign="top"><a href="modify.htm?action=delete&id=[id]&show=">Delete</a> | <a href="modify.htm?id=[id]&show=edit">Edit</a></td>
		<td align="center">[if "[visible]"="T"][then]Yes[/then][else]No[/else][/if]</td>
		<td valign="top">[date_modified]</td>
		<td valign="top">[name]</td>
		<td valign="top">[subject]</td>
		<td valign="top">[date_expires]</td>
	</tr>
	[/founditems]
	</table>
	[/search]
[/showif]

[showif [show]=edit]
	<script language="javascript">
		function Validate(theForm) {
			if ( theForm.__name.value == "" ) {
				alert("Please enter a name");
				theForm.__name.focus();
				return false;
			}
			if ( theForm.__email.value == "" ) {
				alert("Please enter an email address");
				theForm.__email.focus();
				return false;
			}
			if ( theForm.__subject.value == "" ) {
				alert("Please enter a subject");
				theForm.__subject.focus();
				return false;
			}
			if ( theForm.__description.value == "" ) {
				alert("Please enter a description");
				theForm.__description.focus();
				return false;
			}
			return true;
		}
	</script>
	
	[search db=admin/ad.db&eqIDdatarq=[id]&eqUSER_IDdatarq=[g_member_id]][founditems]
	<form method="post" action="modify.htm" onSubmit="return Validate(this)">
	<table>
	<tr><td valign="top">
	
	<table>
	<input type="hidden" name="action" value="update">
	<input type="hidden" name="show" value="list">
	<input type="hidden" name="id" value="[id]">
		<tr><td><b>Name*</b></td><td><input name="__name" value="[convertchars db=admin/convert_quotes.db][name][/convertchars]" size="30"></td></tr>
		<tr><td><b>Phone</b></td><td><input name="__phone" value="[convertchars db=admin/convert_quotes.db][phone][/convertchars]" size="15"></td></tr>	
		<tr><td><b>Email*</b></td><td><input name="__email" value="[convertchars db=admin/convert_quotes.db][email][/convertchars]" size="30"></td></tr>
		<tr><td colspan="2"><hr></td></tr>
		<tr><td><b>Subject*</b></td><td><input name="__subject" value="[convertchars db=admin/convert_quotes.db][subject][/convertchars]" size="40" ></td></tr>
		<tr><td valign="top"><b>Description*</b></td><td><textarea name="__description" rows="8" cols="40" wrap="virtual">[input][description][/input]</textarea></td></tr>
		<tr><td valign="top"><b>Keywords</b></td><td><textarea name="__keywords" rows="2" cols="40" wrap="virtual">[input][keywords][/input]</textarea><br>Keywords are used when searching the ad<br>database and are not visible</td></tr>
		<tr><td><b>Category</b></td><td><select name="__category">[search db=admin/category.db&RANKtype=num&asRANKsort=1&neIDdatarq=findall][founditems]<option value="[name]" [showif [category]=[name]]selected[/showif]>[name][/founditems][/search]</select></td></tr>
		<tr><td><b>Expiration Date</b></td><td><input name="date_expires" value="[date_expires]" size="15"> mm/dd/yyyy<br>Leave blank for none</td></tr>
		<tr><td></td><td><input type="submit" value="Update"></td></tr>
	</table>
	* - Required fields<br>
	Note: Ads are reviewed before posting and may be deleted<br>if deemed inappropriate.
	
	</td><td valign="top">
	[if "[image]"=""][then]
		<center><a href="#" onClick="OpenUpload('[id]', '[url]modify.htm?show=edit&id=[id][/url]')">Upload Image</a></center><br>
		<br>
		Note: Images must be in GIF or JPG format and less than 100K. Thumbnail size on home page is 200 x 150 pixels.<br>
	[/then][else]
		<center><a href="#" onClick="OpenUpload('[id]', '[url]modify.htm?show=edit&id=[id][/url]')">Change Image</a> | <a href="modify.htm?action=deleteImage&id=[id]&show=edit">Delete Image</a></center><br>
		<img src="images/[id]/[image]">
	[/else][/if]
	</td></tr>
	</table>
	</form>
	[/founditems][/search]
	[/showif]

[include file=footer.inc]