$dnum = date(Ymd)*4;
$from = $_GET['fr'];
if($from == ""){
$from = $_POST['fr'];
}
if($from != $dnum){
echo("<<<<Restricted Area>>>>" .
"
Sorry, you must Log In to view this Page
");
exit();
}
$usrn = $_GET['usrn'];
if($usrn == ""){
$usrn = $_POST['usrn'];
}
if($usrn == ""){
echo("<<<<Restricted Area>>>>" .
"
Problem with your username. Please Log In again.
");
exit();
}
$dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_webadmin', 'istration');
mysql_select_db('ecosmar_website', $dbcnx);
?>
User List Click [View/Edit] for complete details.
|
New User
Legend
|
Name
| A D M I N I S T R A T I O N
| M A I L I N G
L I S T
| P A S S W O R D
| C A T A L O G
| P R O D U C T
D A T A
B A S E
| I N V E N T O R Y
| S P E C I A L
P R I C I N G
| R E P R E S E N T A T I V E
| C A L E N D A R
| C O N T A C T
D A T A
B A S E
| D O W N L O A D S
| V I D E O
| R E P
W E B S I T E
| E C O | $ M A R T
W E B S I T E
| P U B L I C
C A L E N D A R
| T R A F F I C
R E P O R T
| P A Y
P E R C E N T
| View/Edit
| DEL
|
$listem = @mysql_query("SELECT ID,first_name,last_name,usrn,email,pswd,pswrep,pswcon,pswcal,pswdls,pswvid,pswcat,pswpdb,pswsp,pswinv,pswweb,pswtr,pswpub,pswadmin,pswpsw,pswml,per FROM psw ORDER BY last_name");
if (!$listem) {
die("Error retrieving data from data base. " . "Error: " . mysql_error(). " |
");
}
while ($row = mysql_fetch_array($listem)) {
$id = $row['ID'];
$first_name = $row['first_name'];
$last_name = $row['last_name'];
$repusrn = $row['usrn'];
$email = $row['email'];
$pswd = $row['pswd'];
$pswrep = $row['pswrep'];
if($pswrep == 'Standard' or $pswrep == 'Yes'){$pswrep='S';}
elseif($pswrep == 'Regional Director'){$pswrep='RD';}else{$pswrep='N';}
$pswcal = $row['pswcal'];
if($pswcal == 'All'){$pswcal='A';}elseif($pswcal == 'Own'){$pswcal='O';}elseif($pswcal == 'RD'){$pswcal='RD';}else{$pswcal='N';}
$pswcon = $row['pswcon'];
if($pswcon == 'All'){$pswcon='A';}elseif($pswcon == 'Own'){$pswcon='O';}elseif($pswcon == 'RD'){$pswcon='RD';}else{$pswcon='N';}
$pswdls = $row['pswdls'];
if($pswdls == 'OK'){$pswdls='OK';}else{$pswdls='N';}
$pswvid = $row['pswvid'];
if($pswvid == 'OK'){$pswvid='OK';}else{$pswvid='N';}
$pswwbs = $row['pswwbs'];
if($pswwbs == 'Yes'){$pswwbs ='Y';}else{$pswwbs='N';}
$pswcat = $row['pswcat'];
if($pswcat == 'Yes'){$pswcat='Y';}else{$pswcat='N';}
$pswpdb = $row['pswpdb'];
if($pswpdb == 'Yes'){$pswpdb='Y';}else{$pswpdb='N';}
$pswsp = $row['pswsp'];
if($pswsp == 'Yes'){$pswsp='Y';}else{$pswsp='N';}
$pswinv = $row['pswinv'];
if($pswinv == 'Yes'){$pswinv='Y';}elseif($pswinv == 'Read_Write'){$pswinv='RW';}elseif($pswinv == 'Read_Only'){$pswinv='R';}else{$pswinv='N';}
$pswweb = $row['pswweb'];
if($pswweb == 'Yes'){$pswweb='Y';}else{$pswweb='N';}
$pswtr = $row['pswtr'];
if($pswtr == 'OK'){$pswtr='OK';}else{$pswtr='N';}
$pswpub = $row['pswpub'];
if($pswpub == 'Yes'){$pswpub='Y';}elseif($pswpub == 'Write'){$pswpub='W';}else{$pswpub='N';}
$pswadmin = $row['pswadmin'];
if($pswadmin == 'Yes'){$pswadmin='Y';}else{$pswadmin='N';}
$pswpsw = $row['pswpsw'];
if($pswpsw == 'All'){$pswpsw='A';}elseif($pswpsw == 'Read_Only'){$pswpsw='R';}else{$pswpsw='N';}
$pswml = $row['pswml'];
if($pswml == 'All'){$pswml='A';}elseif($pswml == 'Send'){$pswml='S';}elseif($pswml == 'Add'){$pswml='AD';}else{$pswml='N';}
$per = $row['per'];
echo("$first_name $last_name | $pswadmin | $pswml | $pswpsw | " .
"$pswcat | $pswpdb | $pswinv | $pswsp | " .
"$pswrep | $pswcal | $pswcon | $pswdls | $pswvid | $pswwbs | " .
"$pswweb | $pswpub | $pswtr | $per | " .
" View/Edit | DEL |
");
}
?>
©2005 - Data Base Interface - Custom Built at:
|
|