Method Advisors

query("SELECT * FROM `users_accts` WHERE `uid`='$uidx'"); $row=$db->get_row(); $user=$row['utype']; $CompanyIDx=$row['CompanyID']; $CompanyNamex=$row['CompanyName']; $email=$row['email']; $pass=$row['pass']; $fname=$row['fname']; $lname=$row['lname']; $msg=''; if (isset($user) && $user>"" && $_SERVER['REQUEST_METHOD']=="POST"){ if($user=='Admin'){ $email=mysql_real_escape_string(trim($_POST['email'])); $pass=mysql_real_escape_string(trim($_POST['pass'])); $fname=mysql_real_escape_string(trim($_POST['fname'])); $lname=mysql_real_escape_string(trim($_POST['lname'])); $db->query("SELECT email FROM `users_accts` WHERE `email`='$email' AND uid!='$uidx'"); if($db->count_rows()==0){ $db->query("UPDATE `users_accts` SET `utype`='Admin', `email`='$email', `fname`='$fname', `lname`='$lname' WHERE `uid`='$uidx'"); if($pass>''){ $db->query("UPDATE `users_accts` SET `pass`=OLD_PASSWORD('$pass') WHERE `uid`='$uidx'"); } $msg='Admin Updated'; }else{ $msg='Email Already Exists'; } }elseif($user=='Company'){ $CompanyName=mysql_real_escape_string(trim($_POST['CompanyName'])); $db->query("SELECT CompanyName FROM `users_accts` WHERE `utype`='Company' AND `CompanyName`='$CompanyName' AND uid!='$uidx'"); if($db->count_rows()==0){ $db->query("UPDATE `users_accts` SET `utype`='Company', `CompanyName`='$CompanyName' WHERE `uid`='$uidx'"); $msg='Company Updated'; }else{ $msg='Comany Name Already Exists'; } }elseif($user=='Consultant'){ $email=mysql_real_escape_string(trim($_POST['email'])); $pass=mysql_real_escape_string(trim($_POST['pass'])); $fname=mysql_real_escape_string(trim($_POST['fname'])); $lname=mysql_real_escape_string(trim($_POST['lname'])); $db->query("SELECT email FROM `users_accts` WHERE `email`='$email' AND uid!='$uidx'"); if($db->count_rows()==0){ $db->query("UPDATE `users_accts` SET `utype`='Consultant', `email`='$email', `fname`='$fname', `lname`='$lname' WHERE `uid`='$uidx'"); if($pass>''){ $db->query("UPDATE `users_accts` SET `pass`=OLD_PASSWORD('$pass') WHERE `uid`='$uidx'"); } if($utype=='Admin'){ $db->query("DELETE FROM `consultant_companies` WHERE (`cuid`='$uidx') "); foreach($_POST['CompanyIDb'] as $ccomid){ $db->query("INSERT INTO `consultant_companies` SET `cuid`='$uidx',`ccomid`='$ccomid'"); } } $msg='Consultant Updated'; }else{ $msg='Email Already Exists'; } }elseif($user=='Client'){ $email=mysql_real_escape_string(trim($_POST['email'])); $pass=mysql_real_escape_string(trim($_POST['pass'])); $fname=mysql_real_escape_string(trim($_POST['fname'])); $lname=mysql_real_escape_string(trim($_POST['lname'])); $CompanyID=mysql_real_escape_string(trim($_POST['CompanyID'])); $db->query("SELECT email FROM `users_accts` WHERE `email`='$email' AND uid!='$uidx'"); if($db->count_rows()==0){ $db->query("UPDATE `users_accts` SET `utype`='Client', `email`='$email', `fname`='$fname', `lname`='$lname', CompanyID='$CompanyID' WHERE `uid`='$uidx' "); if($pass>''){ $db->query("UPDATE `users_accts` SET `pass`=OLD_PASSWORD('$pass') WHERE `uid`='$uidx'"); } $msg='Client Updated'; }else{ $msg='Email Already Exists'; } } } ///UPDATE `users_accts` SET `utype`='$CompanyName',`email`='$Email',`pass`='$Pass',`CompanyID`='12',`CompanyName`='12',`fname`='$frname',`lname`='$lname' WHERE (`uid`='2') $db->query("SELECT * FROM `consultant_companies` WHERE (`cuid`='$uidx') "); if($db->count_rows()>0){ $consoltantIDs=''; while($row=$db->get_row()){ $consoltantIDs[]=$row['ccomid']; } }else{ $consoltantIDs=array(); } $db->query("SELECT * FROM `users_accts` WHERE `utype` = 'Company' "); $numberofcompanies=$db->count_rows(); if($utype=='Admin'){ $CompanySelect=' '.$CompanyName.' '; } $CompanySelect.=''; $CompanyBoxes.=''; }else{ $CompanyBoxes=''; while($row=$db->get_row()){ $CompanyName=$row['CompanyName']; $CompanyID=$row['uid']; if($CompanyID==$CompanyIDx){ $CompanySelect=''.$CompanyName.' '; } if(in_array($CompanyID,$consoltantIDs)){ $CompanyBoxes.=''; } } $CompanyBoxes.='

'.$CompanyName.'

'; } ?> Method Advisors

Files Add File Users Add User Edit Profile Logout

INTRANET_TITLE > Edit Profile ''){ print "
".$msg; } ?>

User Type

Email
Password	Leave password blank to keep the current password

First Name
Last Name

Limited Partner

Email
Password	Leave password blank to keep the current password

First Name
Last Name

Limited Partners

Limited Partner

Email
Password	Leave password blank to keep the current password

First Name
Last Name

INTRANET_TITLE > Edit Profile ''){ print "".$msg; } ?>

INTRANET_TITLE > Edit Profile ''){ print "
".$msg; } ?>