include("1/connection.inc");
include("1/sendmail.inc");
$LIST_PREFIX = "l.";
$_states = "Cleaning Maid Services, Interior Home Cleaning Maid Service, ";
if($finished=="2"){
$sql="Select id FROM $tableCategoryShema WHERE category_id = '$categorys' AND item_id = '$category_items'";
$resu=mysql_query($sql);
$rows=mysql_num_rows($resu);
if($rows > 0)
$sid = mysql_result($resu, 0, "id");
$sql="Select count FROM $tableTopSearches WHERE sxema = '$sid' AND zip = '$zipss'";
$resu=mysql_query($sql);
$rows=mysql_num_rows($resu);
if($rows > 0){
$count = mysql_result($resu, 0, "count");
$count++;
$sql="UPDATE $tableTopSearches SET count = '$count' WHERE sxema = '$sid' AND zip = '$zipss' AND provider like '$webHostName'";
$resu=mysql_query($sql);
} else {
$sql="INSERT INTO $tableTopSearches (sxema, zip, count, provider) VALUES ('$sid', '$zipss', '1', '$webHostName')";
$resu=mysql_query($sql);
}
$loc = $webHostName."/l.";
$loc = "http://www.prescreenedpros.com/l.";
$sql="Select category_item_prefix as name FROM $tableCategoryItem WHERE id = '$category_items'";
$resu=mysql_query($sql);
$rows=mysql_num_rows($resu);
if($rows > 0)
$name = mysql_result($resu, 0, "name");
$loc .= "$name";
$sql="Select category_prefix as name FROM $tableCategory WHERE id = '$categorys'";
$resu=mysql_query($sql);
$rows=mysql_num_rows($resu);
if($rows > 0)
$name = mysql_result($resu, 0, "name");
$loc .= ".$name";
$sql="Select LastLineCity_prefix as LastLineCity, State, county_prefix as County FROM $tableZip WHERE zip = '$zipss'";
$resu=mysql_query($sql);
$rows=mysql_num_rows($resu);
if($rows > 0){
$name = mysql_result($resu, 0, "county");
$loc .= ".$name";
$name = mysql_result($resu, 0, "LastLineCity");
$loc .= ".$name";
$name = mysql_result($resu, 0, "state");
$name = str_replace(" ", " ", str_replace(" ", "_", $name));
$loc .= ".$name.$zipss";
}
$loc .= ".html";
Header( "Location: ".$loc);
}
$msg = "";
$invalidAuth = false;
$not_existing_member = false;
$chek_email=false;
$null_member = false;
$invalidStatus = false;
if($sendPassword!="" && $myUserName==""){
$null_member = true;
}
if($sendPassword!="" && $myUserName!=""){
$SQL = "SELECT contractor_id FROM $tableMembers WHERE user_name = '$myUserName'";
$result = mysql_query($SQL);
$rows = 0;
if (@$result) {
$rows = mysql_num_rows($result);
}
if ($rows > 0) {
$memb_id = mysql_result($result, 0, "contractor_id");
$chpass[0]="0"; $chpass[21]="l"; $chpass[41]="F";
$chpass[1]="1"; $chpass[22]="m"; $chpass[42]="G";
$chpass[2]="2"; $chpass[23]="n"; $chpass[43]="H";
$chpass[3]="3"; $chpass[24]="o"; $chpass[44]="I";
$chpass[4]="4"; $chpass[25]="p"; $chpass[45]="J";
$chpass[5]="5"; $chpass[26]="q"; $chpass[46]="K";
$chpass[6]="6"; $chpass[27]="r"; $chpass[47]="L";
$chpass[7]="7"; $chpass[28]="s"; $chpass[48]="M";
$chpass[8]="8"; $chpass[29]="t"; $chpass[49]="N";
$chpass[9]="9"; $chpass[30]="u"; $chpass[50]="O";
$chpass[10]="a"; $chpass[31]="v"; $chpass[51]="P";
$chpass[11]="b"; $chpass[32]="v"; $chpass[52]="Q";
$chpass[12]="c"; $chpass[33]="x"; $chpass[53]="R";
$chpass[13]="d"; $chpass[34]="y"; $chpass[54]="S";
$chpass[14]="e"; $chpass[35]="z"; $chpass[55]="T";
$chpass[15]="f"; $chpass[36]="A"; $chpass[56]="U";
$chpass[16]="g"; $chpass[37]="B"; $chpass[57]="V";
$chpass[17]="h"; $chpass[38]="C"; $chpass[58]="V";
$chpass[18]="i"; $chpass[39]="D"; $chpass[59]="X";
$chpass[19]="j"; $chpass[40]="E"; $chpass[60]="Y";
$chpass[20]="k"; $chpass[61]="Z";
$tmpPassword = "";
for ($i=0; $i<8; $i++) {
mt_srand((double)microtime()*1000000);
$n = mt_rand(0, 61);
$tmpPassword .= $chpass[$n];
}
$tmpMD5Password = md5($tmpPassword);
$SQL = "SELECT * FROM $tableContractorInfo WHERE id = '$memb_id'";
$result = mysql_query($SQL);
$rows = 0;
if (@$result) {
$rows = mysql_num_rows($result);
}
if ($rows > 0) {
$mail_ = mysql_result($result, 0, "email");
$Fname_ = mysql_result($result, 0, "firstName");
$Lname_ = mysql_result($result, 0, "lastName");
$SQL = "UPDATE $tableMembers SET user_pass='$tmpMD5Password' WHERE contractor_id = '$memb_id'";
if(mysql_query($SQL)){
$msg="Your password is $tmpPassword";
$msg = "Dear $Fname_ $Lname_ , ";
$msg .= "Thank you for your password request.
";
$msg .= "Your password is: $tmpPassword ";
$msg .= "Your Username is: $mail_
";
$msg .= "Your username and password will enable you to log in to your account. ";
$msg .= "If you would like to change your password to something you can more easily remember, please visit the Account Manager area of your site.
";
$msg .= "Thank you for being part of PrescreenedPros community. Let us know if there's anything else we can do to help.
Listings
Free listings in PRESCREENEDPRO's directory.
Webpage Profile
Your free webpage profile comprise a mini-website that displays your logo, graphics, business details, Prescreening Certificate and Ratings & Reviews. If you have a website, add your website's URL to your webpage profile and increase your search engine ranking.
Subdomain Name
Free subdomain name www.yourname.prescreenedpro.net. Once you pick your subdomain name for your site, it's yours forever!
Prescreening Certificate
Prescreening Certificate on your site will show your audience that you are periodically prescreened for bankruptcy and legal background, insurance and licensing.
Coupon or Referrals' ID #
Enter here your Coupon Code or Referrals' ID # and you will get 25% off first paid Monthly Membership Plan
Ratings & Reviews
Created by PRESCREENEDPRO on your site.
Ratings & Reviews
Use your Ratings & Reviews to your advantage! If your business generates great Ratings & Reviews, you should be proud of them. Link from your website directly to your Ratings & Reviews on our website.
Q: What does the Prescreening Certificate fee cover and why is it yearly?
A: This yearly fee of $59.99 is used to purchase 3rd party bankruptcy and legal background information, and perform analytics based on provided information, as well as monitor member status throughout the year.
Join PrescreenedPro's network to begin receiving unlimited job leads. We only send you the potential customers that are specifically looking for the services you offer in the locations that you serve. Simply adding your profile and website to our directories, enables any PrescreenedPro visitor to find you.
FAQ's
Q: How much will this cost me?
A: You can join our network for free as a non-prescreened pro member with no obligation. Once you add your business information into our online system, your company will be listed under non-prescreened pro members in our directories. To gain a competitive advantage through priority listing, you need to obtain our Prescreening Certificate for as little as $59.99 p/year. Our prescreened pro members appear at the top of our listings and have other advantages.
Q: What benefit is there for me?
A:
There are three main benefits of joining our network:
1) Internet exposure to the homeowner
2) Gaining a reputation through our Prescreening Certificate and Rating & Reviews system and
3) The ability to recieve unlimited quality leads in your area and line of work.