I got this when i went in.
SELECT sum(module_userprefs.value) AS pks, count(accounts.clanid) AS memcount, clans.clanname,accounts.clanid FROM accounts
INNER JOIN clans
ON accounts.clanid=clans.clanid
INNER JOIN module_userprefs
ON accounts.acctid=module_userprefs.userid
WHERE accounts.clanid != 0
AND module_userprefs.modulename='pktrack'
AND module_userprefs.settting='count'
GROUP BY accounts.clanid
ORDER BY pks DESC,
memcount ASC LIMIT 0,50
Unknown column 'module_userprefs.settting' in 'where clause'
Call Stack:
1: db_query("SELECT sum(module_userpre...") called from /var/www/html/naruto/modules/hofclanpk.php on line 73
2: hofclanpk_run() called from /var/www/html/naruto/runmodule.php on line 35