[AtomicAcidbath]

Posting this for the developer.

Buying "Title Change" with two funding sources required (Points & Cash, aka- method 4) throws this database error:

Database error in vBulletin 4.0.4:

Invalid SQL:
update lc_user set  `market_xperience`=1027.00-, market_purchases=market_purchases+1, customtitle='2', usertitle ='MyNewTitle' where userid='1';

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' market_purchases=market_purchases+1, customtitle='2', usertitle ='MyNewTitle' where u' at line 1
Error Number  : 1064
Request Date  : Sunday, July 25th 2010 @ 06:12:38 PM
Error Date    : Sunday, July 25th 2010 @ 06:12:38 PM
Script        : http://76.121.10.37/forum/market.php?do=purchase
Referrer      : http://76.121.10.37/forum/market.php?do=item&id=2
IP Address    : 76.121.10.37
Username      : --------
Classname     : vB_Database
MySQL Version : 5.1.47-community

Check file 'market.php'
Change section:

        // User Edits Own User Title
        if ($itembuy[marketid] != 6) {
            if (!$method != 4) {

To:

        // User Edits Own User Title
        if ($itembuy[marketid] != 6) {
            if ($method != 4) {

Problem is resolved.