[moonray]

Hi,
Everything is working great and I love this hack. I have even disabled the built in reputation system in favor of this.

However, after upgrading to v1.2, I get this error when I delete a thread:

Database error in vBulletin 3.6.7:

Invalid SQL:

                               UPDATE vb_user SET
                                        credits = CASE  WHEN userid IN (0,1) THEN credits + -2.285
, posts = CASE  WHEN userid IN (0,1) AND posts > 1 THEN posts - 1
 ELSE 0 END
                               WHERE userid IN (0,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 ' posts = CASE  WHEN userid IN (0,1) AND posts > 1 THEN posts - 1
 ELSE 0 END
                       ' at line 3
Error Number : 1064

I have only changed the credits awarded for each action (+2 for thread, +0.03 per character of post and - for thread deletion). Even with the default credits value, when a thread is deleted, the author gets to keep the 'credits per character', or am I mistaken?

That may be reason for this, but I appreciate any help with this.

Thank you!