[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