> Hello
> 
> The problem is the same as previous ones. Quoting the 
> row-names in SQL 
> statements will not work with PostgreSQL and i doubt it will 
> with MySQL.
> 
> So "SELECT from 'mumble' WHERE 'row'='some value';  will not work
> 
> while "SELECT from mumble WHERE row='some value'; is perfectly fine.
> 
> This is the only change i have done because i am not really a 
> PHP coder :-(

Hmm .. ok, so can you check if the queries attached also doesn't 
work for you (editadminuser.php):

socrates02:~/svn/web-cyradm/trunk# fgrep "query" *.php | grep "\`"
display.php:                    $query = "UPDATE `settings` SET 
`style`='".$_SESSION['style']."', maxdisplay='".$_SESSION['maxdisplay']."', 
warnlevel='".$_SE
SSION['warnlevel']."' WHERE username='".$_SESSION['user']."'";
editadminuser.php:                      $query = "SELECT `type` FROM adminuser 
WHERE username='".$_GET['username']."'";
editadminuser.php:                              $query = "SELECT `type` FROM 
adminuser WHERE username='".$_POST['username']."'";
manageaccount.php:                              $query = "SELECT 
`prefix`,`domainquota` FROM `domain` WHERE 
`domain_name`='".$_POST['domain']."'";
manageaccount.php:                                      $query = "SELECT 
`username` FROM `accountuser` WHERE `prefix`='$prefix' ORDER BY `username`";


Thanks,

Michael
_______________________________________________
This mailing list is hosted and supported
by bit-heads GmbH | http://www.bit-heads.ch

_______________________________________________
Web-cyradm mailing list
[email protected]
http://www.web-cyradm.org/mailman/listinfo/web-cyradm

Reply via email to