| Server IP : 172.67.201.108 / 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 : |
<cfcontent type="text/html;charset=iso-8859-1">
<cfprocessingDirective pageencoding="iso-8859-1">
<cfset setEncoding("Form", "ISO-8859-15")>
<cfinclude template="header.cfm">
<div id="content">
<div id="content-header">
</div>
<div class="container-fluid" style="margin-left:200px;">
<cfif parameterexists(getuser.id)>
<cfif parameterexists(url.updater)>
<cfquery name="upds" datasource="#ds#">
update nympexperts
set
expertfullname = '#form.expertfullname#',
credentials = '#form.credentials#',
business = '#form.businessname#',
includebusiness = '#form.includebusiness#',
twitter = '#form.twitter#',
facebook = '#form.facebook#',
bio = '#form.textBox1#',
subject = '#form.subject#',
question = '#form.question#',
answer = '#form.answer#',
fullname = '#form.fullname#',
phone = '#form.phonenumber#',
email = '#form.email#',
posted = #form.posted#
where id = #url.updater#
</cfquery>
</cfif>
<cfif parameterexists(url.edit)>
<cfquery name="gets" datasource="#ds#">
select * from nympexperts
where id = #url.edit#
</cfquery>
<cfif #gets.photoname# is not ''>
<cfoutput query="Gets"><a href="https://www.nymetroparents.com/experts/#photoname#" target="_new"><img src="https://www.nymetroparents.com/experts/#photoname#" style="max-height: 300px;"></a>
</cfoutput>
</cfif>
<div align="center"><font face=verdana size=+1><strong></strong></font>
<cfFORM action="addexpert.cfm?updater=#url.edit#" method="post" enctype="multipart/form-data">
<table width=100% cellspacing=5 cellpadding=5 border=1>
<tr><td style="padding:4px;"style="padding:4px;">
<b><font SIZE="-2" FACE="verdana">Expert's Full Name:</font></b>
</td><td style="padding:4px;"style="padding:4px;">
<cfinput NAME="expertfullname" SIZE="35" required="Yes" message="You Must Enter Your Expert's Name" value="#gets.expertfullname#">
</td></tr>
<tr><td style="padding:4px;"style="padding:4px;">
<b><font SIZE="-2" FACE="verdana">Expert's Credentials:</font></b>
</td><td style="padding:4px;"style="padding:4px;"><font SIZE="-2" FACE="verdana">
<input <Cfif #gets.credentials# contains 'DDS'>checked</Cfif> type="radio" required="yes" name="credentials" value="DDS" > DDS
<input <Cfif #gets.credentials# contains 'DMD'>checked</Cfif> type="radio" required="yes" name="credentials" value="DMD"> DMD
<input <Cfif #gets.credentials# contains 'Ed.D'>checked</Cfif> type="radio" required="yes" name="credentials" value="Ed.D"> Ed.d
<input <Cfif #gets.credentials# contains 'LCSW'>checked</Cfif> type="radio" required="yes" name="credentials" value="LCSW"> LCSW
<input <Cfif #gets.credentials# contains 'MD'>checked</Cfif> type="radio" required="yes" name="credentials" value="MD"> MD
<input <Cfif #gets.credentials# contains 'Ph.D.'>checked</Cfif> type="radio" required="yes" name="credentials" value="Ph.D."> Ph.D.
<input <Cfif #gets.credentials# contains 'Other'>checked</Cfif> type="radio" required="yes" name="credentials" value="Other"> Other
</td></tr>
<tr><td style="padding:4px;"style="padding:4px;">
<b><font SIZE="-2" FACE="verdana">Expert's Business Name*::</font></b>
</td><td style="padding:4px;"style="padding:4px;">
<cfinput NAME="businessname" SIZE="35" required="yes" message="You Must Enter a business name" value="#gets.business#">
</td></tr>
<tr><td style="padding:4px;"style="padding:4px;">
<b><font SIZE="-2" FACE="verdana">Include your business name in your post?*:</font></b>
</td><td style="padding:4px;"style="padding:4px;"><font SIZE="-2" FACE="verdana">
<input <Cfif #gets.includebusiness# contains 'Yes'>checked</Cfif> type="radio" required="yes" name="includebusiness" value="Yes" message="You must choose whether or not to include your business name.">Yes
<input <Cfif #gets.includebusiness# contains 'No'>checked</Cfif> type="radio" required="yes" name="includebusiness" value="No" message="You must choose whether or not to include your business name.">No
</td></tr>
<tr><td style="padding:4px;"style="padding:4px;">
<b><font SIZE="-2" FACE="verdana">Business or Expert Twitter Handle:</font></b><br><small>(We will tweet your link to our audience if provided)
</td><td style="padding:4px;"style="padding:4px;">
<cfinput NAME="twitter" SIZE="20" required="no" value="#gets.twitter#">
</td></tr>
<tr><td style="padding:4px;"style="padding:4px;">
<b><font SIZE="-2" FACE="verdana">Business or Expert Facebook Page:</font></b><br><small>(We will share your link on our Facebook feed if provided)
</td><td style="padding:4px;"style="padding:4px;">
<cfinput NAME="facebook" SIZE="20" required="no" value="#gets.facebook#">
</td></tr>
<tr><td style="padding:4px;"colspan="2">
<b><font SIZE="-2" FACE="verdana"> Expert Bio (75 words max)*
<br>
<script language="javascript">
//Alter this variable depending on how many words you want to limit the textarea to.
var maxwords = 75;
function check_length(obj, cnt, rem)
{
var ary = obj.value.split(" ");
var len = ary.length;
cnt.innerHTML = len;
rem.innerHTML = maxwords - len;
if (len > maxwords) {
alert("Message in '" + obj.name + "' limited to " + maxwords + " words.");
ary = ary.slice(0,maxwords-1);
obj.value = ary.join(" ");
cnt.innerHTML = maxwords;
rem.innerHTML = 0;
return false;
}
return true;
}
</script>
<textarea name="textBox1" style="width:400px;height:100px;" placeholder="Enter the Bio Here" onkeypress=" return check_length(this, document.getElementById('count_number_words'), document.getElementById('show_remaining_words'));"><cfoutput>#gets.bio#</cfoutput></textarea>
<br>
<font color="black">Word count:</font><font color="red">
<span id="count_number_words">0</span>
</font>
<br>
<font color="black">Words remaining: </font><font color="red">
<span id="show_remaining_words">75</span>
</font>
<p>
</td>
</tr>
<tr><td style="padding:4px;"style="padding:4px;">
<b><font SIZE="-2" FACE="verdana">Subject of THIS Post (check one)*:</font></b>
</td><td style="padding:4px;"style="padding:4px;"><font SIZE="-2" FACE="verdana">
<table><Tr><td style="padding:4px;"style="padding:4px;"> <font SIZE="-2" FACE="verdana" >
<input <Cfif #gets.subject# contains 'TOD'>checked</Cfif> name="subject" type="radio" value="TOD" required="Yes" message="You Must Select a Subject" > Pre-school (3-5) / Toddler or Younger<br>
<input <Cfif #gets.subject# contains 'Health'>checked</Cfif> name="subject" type="radio" value="Child Health" required="Yes" message="You Must Select a Subject" > Child Health<br>
<input <Cfif #gets.subject# contains 'Women'>checked</Cfif> name="subject" type="radio" value="Child Women's" required="Yes" message="You Must Select a Subject" > Women's Health<br>
<input <Cfif #gets.subject# contains 'Development'>checked</Cfif> name="subject" type="radio" value="Child Development" required="Yes" message="You Must Select a Subject" > Child Development <br>
<input <Cfif #gets.subject# contains 'Education'>checked</Cfif> name="subject" type="radio" value="Education" required="Yes" message="You Must Select a Subject" > Education<br>
<input <Cfif #gets.subject# contains 'Special'>checked</Cfif> name="subject" type="radio" value="Special Needs" required="Yes" message="You Must Select a Subject" > Special Needs <br>
</td><td style="padding:4px;"style="padding:4px;">
<font SIZE="-2" FACE="verdana" >
<input <Cfif #gets.Subject# contains 'Sports'>checked</Cfif> name="subject" type="radio" value="Sports & Extracurricular Activities" required="Yes" message="You Must Select a Subject" > Sports & Extracurricular Activities<br>
<input <Cfif #gets.subject# contains 'Camp'>checked</Cfif> name="subject" type="radio" value="Camp" required="Yes" message="You Must Select a Subject" > Camp <br>
<input <Cfif #gets.subject# contains 'Birthday'>checked</Cfif> name="subject" type="radio" value="Birthday" required="Yes" message="You Must Select a Subject" > Birthday<br>
<input <Cfif #gets.subject# contains 'Finance'>checked</Cfif> name="subject" type="radio" value="Family Finance" required="Yes" message="You Must Select a Subject" > Family Finance <br>
<input <Cfif #gets.subject# contains 'Other'>checked</Cfif> name="subject" type="radio" value="Other" required="Yes" message="You Must Select a Subject" > Other</Td></Tr></table>
</td></tr>
<tr>
<td style="padding:4px;"colspan=2 align="left" valign="top">
<font SIZE="-2" FACE="verdana" ><b>QUESTION (1-2 sentences)*:
</b></font><br>
<textarea name="question" cols="55" rows="10" wrap="VIRTUAL"><cfoutput>#gets.question#</cfoutput></textarea>
</td>
</tr>
<tr>
<td style="padding:4px;"colspan=2 align="left" valign="top">
<font SIZE="-2" FACE="verdana" ><b>ANSWER (250-700 words)*:
</b></font><br>
<textarea name="answer" cols="55" rows="10" wrap="VIRTUAL"><cfoutput>#gets.answer#</cfoutput></textarea>
</td>
</tr>
<tr>
<td style="padding:4px;"colspan=2 align="left" valign="top">
<font SIZE="-1" FACE="verdana" >
<strong> Contact Information
</strong> <Br /> For our editor's purposes only. This info will NOT be shown in your article.
</font></td>
</tr>
<tr><td style="padding:4px;"style="padding:4px;">
<b><font SIZE="-2" FACE="verdana">Your Name:</font></b>
</td><td style="padding:4px;"style="padding:4px;">
<cfinput NAME="fullname" SIZE="35" required="yes" message="You Must Enter Your Name" value="#gets.fullname#"> </td></tr>
<tr><td style="padding:4px;"style="padding:4px;">
<b><font SIZE="-2" FACE="verdana">Your Phone Number:</font></b>
</td><td style="padding:4px;"style="padding:4px;">
<cfinput NAME="phonenumber" SIZE="35" required="yes" message="You Must Enter Your Phone Number" value="#gets.phone#"> </td></tr>
<tr><td style="padding:4px;"style="padding:4px;">
<b><font SIZE="-2" FACE="verdana">Contact Email:</font></b>
</td><td style="padding:4px;"style="padding:4px;">
<cfinput NAME="email" SIZE="35" required="yes" message="You Must Enter Your Email Address" value="#gets.email#"> </td></tr>
<tr><td style="padding:4px;"style="padding:4px;">
<b><font SIZE="-2" FACE="verdana">Mark as Posted:</font></b>
</td><td style="padding:4px;"style="padding:4px;">
<Select name="posted">
<cfif #gets.posted# eq 0> <option value="0">No</option>
<option value="1">Yes</option>
<cfelse> <option value="1">Yes</option>
<option value="0">No</option>
</cfif>
</Select> </td></tr>
</table><br>
<center><input type="submit" Value="Update Expert Listing"></center>
</cfform>
<cfabort>
</cfif>
<cfquery name="getlastquiz" datasource="#ds#" >
select *
from nympexperts
where posted = 0
order by id desc
</cfquery>
<table with="653" border="1" cellpadding="4" cellspacing="0">
<tr bgcolor="#efefef">
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>
id</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>
date</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>expertfullname</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>credentials</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>business</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>includebusiness</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>twitter</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>facebook</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>subject</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>question</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>fullname</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>phone</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>email</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>photo?</td>
</tr>
<cfoutput query="Getlastquiz">
<tr>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>
<a href="addexpert.cfm?edit=#id#">edit</a></td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>
#dateformat(datetime,'m/d')#</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>#expertfullname#</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>#credentials#</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>#business#</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>#includebusiness#</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>#twitter#</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>#facebook#</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>#subject#</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>#question#</td>
<td style="padding:4px;"style="padding:4px;">
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>#fullname#</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>#phone#</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>#email#</td>
<td style="padding:4px;"style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><cfif #photoname# is not ''>yes</cfif></td>
</tr>
</cfoutput>
</table>
</td></tr></table>
</cfif>
</div>
<!--Footer-part-->
<br><br><br><br>
<cfinclude template="footer.cfm">