| Eco-$mart, Inc. On-line Administration |
";
$dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1');
mysql_select_db('ecosmar_website', $dbcnx);
$ok = @mysql_query("SELECT ID,first_name,last_name,usrn,email,pswd,pswrep,pswcon,pswcal,pswwbs,pswdls,pswvid,pswcat,pswpdb,pswsp,pswinv,pswweb,pswtr,pswpub,pswadmin,pswpsw,pswml,up_date FROM psw WHERE usrn ='$usrn'");
if (!$ok){
die ("Error Selecting User from Data Base!
".
'Error:' . mysql_error() . '
Project CalendarProject Calendar" .
"Regional Project Calendar";
}elseif($pswcal == 'All'){
$cal = "Project Calendar" .
"All Project Calendars";
}else{
$cal = " ";
}
if($pswcon == 'Own'){
$con = "My Contacts";
}elseif($pswcon == 'RD'){
$con = "My Contacts" .
"Regional Contacts";
}elseif($pswcon == 'All'){
$con = "My Contacts" .
"All Contacts" .
"Web Contacts";
}else{
$con = " ";
}
if($pswvid == 'OK'){
$aud = "Audio Library";
}else{
$aud = " ";
}
if($pswpsw == 'All'){
$aud2 = "Audio Profiles";
}else{
$aud2 =" ";
}
if($pswpsw == 'All'){
$dls = "Documents" .
" Download List ";
}elseif($pswdls == 'OK'){
$dls = "Documents";
}else{
$dls = " ";
}
if($pswvid == 'OK'){
$vid = "Video";
}else{
$vid = " ";
}
if($pswwbs == 'Yes'){
$wbs = "My Webpage*";
}else{
$wbs = " ";
}
if($pswpub == 'Write'){
$pub = "Public Calendar";
}else{
$pub = " ";
}
if($pswtr == 'OK'){
$tr = "Traffic Report" .
" Last Report";
}else{
$tr = " ";
}
if($pswpsw == 'All'){
$agt = "Agents";
$off = "Offices";
$ref1 = "Referrers List";
$ref2 = "New Requested Referrers";
$psw = "Username/Password";
$inv1 = "All Invoices";
$inv2 = "New Invoices";
}
if($pswsp == 'Yes'){
$sp = "Special Pricing";
}
if($pswpsw == 'Read'){
$psw = "Check Username/Password";
}
if($pswpdb == 'Yes'){
$pdb = "Product Data Base";
}else{
$pdb = " ";
}
if($pswinv == 'Read'){
$ivtrd = "Inventory Check*";
}
elseif($pswinv == 'Read_Write'){
$ivtrw = "Inventory - Update";
}
elseif($pswinv == 'All'){
$ivt = "Product Inventory";
}
$log = "Edit Log-in Information";
mysql_select_db('ecosmar_contacts', $dbcnx);
$checkem = @mysql_query("SELECT react_month FROM con_reactivity WHERE usrn='$usrn'");
if(!$checkem){
echo('Error Checking Activity.
' . 'Error: '. mysql_error(). '
|
| Eco-$mart, Inc. On-line Administration |
|
Functions for | |||||||
|
|
| ||||||
|
Current Invoices:
" . "Error: ". mysql_error()." ");
}else{
$numrows = mysql_num_rows($listem);
if($numrows < 1){
echo("Under Development");
}else{
while($inv = mysql_fetch_array($listem)){
$IID = $inv[0];
$invnum = $inv[1];
$rec_co = $inv[2];
$rec_name = $inv[3];
if($rec_co == ""){
$re = $rec_name;
}else{
$re = $rec_co;
}
$Istatus = $inv[4];
echo("$re - $Istatus "); } } } ?>
|
Current Projects:
0){
while($row = mysql_fetch_array($new)){
$ProjID = $row[0];
$ProjName = $row[1];
$ProjStat = $row[2];
echo("  " .
" $ProjName - $ProjStat"); } } $newt = @mysql_query("SELECT ID,Project_Name,status,due FROM task WHERE usrn='$usrn' ORDER BY due DESC"); if(!$newt){ echo("Problem getting Projects. Error: ". mysql_error()); } $num_rows = mysql_num_rows($newt); if($num_rows < 1){ echo("No Current Projects"); }else{ while($row = mysql_fetch_array($newt)){ $ProjID = $row[0]; $ProjName = $row[1]; $ProjStat = $row[2]; echo(" $ProjName - $ProjStat"); } } } ?>
| ||||||
| |||||||
| " .
"General Administration:" .
" | |||||||
| $agt" . " | $ref1" . " | $sp" . " | |||||
| $off" . " | $ref2" . " | $psw" . " | |||||
| " .
"Invoicing" .
" | $inv1" . " | $inv2" . " |
| " .
"Mail:" .
" | Send to Mailing List" .
" |
| " .
"Products:" .
" | $pdb" . " | $ivt" . " |
" .
" Products:" .
" | $ivtrd $ivtrw" . " |
 Website:
| |||
 Memo:
No Memo Posted");
}else{
$author = $row['author'];
$memo = stripslashes($row['memo']);
$dtnum = $row['dtnum'];
$chunk_mdt = chunk_split($dtnum, 2, ':');
$chunk_arrm = explode(":", $chunk_mdt);
$duem = $chunk_arrm[2].'/'.$chunk_arrm[3].'/'.$chunk_arrm[0].$chunk_arrm[1];
echo("
" .
"From: $author -- $duem" . " $memo" . " "); } } ?>  Edit Memo" .
"");
}
?>
|
|
| ©2007 - Data Base Interface - Custom Built at: | 
|
Downloads: