| Server IP : 104.21.21.239 / Your IP : 216.73.216.11 Web Server : Apache/2.4.68 (Amazon Linux) OpenSSL/3.5.5 System : Linux ip-172-31-69-123.ec2.internal 6.1.176-223.369.amzn2023.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Jul 24 13:34:27 UTC 2026 x86_64 User : ec2-user ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/home2/cgny/nympadmin/ |
Upload File : |
<cfquery name=deleter datasource="#ds#">
select * from CampListings
where approved = 1
and campregion = '' or campregion is null
order by id desc
</cfquery>
<br />
<font face="Verdana, Geneva, sans-serif" size=+2 color="red"><strong>BROWSE USER SUBMISSIONS - MISSING APPROVED REGIONS</strong></font><br /><br />
<br /><br />
<Table border="1" cellpadding="4" cellspacing="0">
<Tr>
<td><strong>id</strong></td>
<Td><strong>name</strong></td>
<Td><strong>address</strong></td>
<Td><strong>city</strong></td>
<Td><strong>state</strong></td>
<Td><strong>zip</strong></td>
<Td><strong>phone</strong></td>
<Td><strong>sales email</strong></td>
<Td><strong>email</strong></td>
<Td><strong>website</strong></td>
<Td><strong>description</strong></td>
<Td><strong>fulldescription</strong></td>
<Td><strong>contactfirst</strong></td>
<Td><strong>contactlist</strong></td>
<Td><strong>contacttitle</strong></td>
<Td><strong>contactemail</strong></td>
<Td><strong>contactphone</strong></td>
<Td><strong>dateadded</strong></td>
<Td><strong>region</strong></td>
<Td><strong>updateid</strong></td>
</Tr>
<Cfoutput query="deleter">
<Tr>
<td><a href="approvecamplistings.cfm?id=#id#">Edit</a></td>
<Td>#name#</td>
<Td>#address#</td>
<Td>#city#</td>
<Td>#state#</td>
<Td>#zip#</td>
<Td>#phone#</td>
<Td>#salesemail#</td>
<Td>#email#</td>
<Td>#website#</td>
<Td><Font size=-2>#left(description,100)#...</td>
<Td><Font size=-2>#left(fulldescription,100)#...</td>
<Td>#contactfirst#</td>
<Td>#contactlist#</td>
<Td>#contacttitle#</td>
<Td>#contactemail#</td>
<Td>#contactphone#</td>
<Td>#dateformat(dateadded,'m/d/yyyy')#</td>
<Td>#region#</td>
<Td>#updateid#</td>
</Tr>
</Cfoutput> </Table>
<p>