I have a problem that prevent me from get my plugin for vBExperience working right.
I have customs columns in the users table. I need to pass this columns to "$xPerience->CalculateXP" and calculate them over there without calling another query in the SQL.
The problem is that vBExperience only use some users columns and no all the columns from the users table.
I recommend change this:
PHP Code:
SELECT
u.lastactivity,
u.username,
u.userid,
u.joindate,
u.lastactivity,
u.reputation,
u.usergroupid,
u.membergroupids,
u.ipoints,
u.posts,
u.xperience_ppd
FROM " . TABLE_PREFIX . "user as u
for this
PHP Code:
SELECT *
FROM " . TABLE_PREFIX . "user as u
I know that the first one is faster but is not scalable.
Sorry for my english