[Web-cyradm] Patch against SVN latest

Muenz, Michael M.Muenz at maxonline.de
Fri Aug 4 10:43:21 CEST 2006


> 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


More information about the Web-cyradm mailing list