[Spinball]

SELECT user.userid, user.avatarid, user.avatarrevision, avatar.avatarpath, customavatar.filename, NOT ISNULL(filedata) AS hascustom, customavatar.dateline FROM user AS user LEFT
JOIN avatar AS avatar ON avatar.avatarid = user.avatarid LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid WHERE customavatar.userid=238420 OR user.userid=238420;

is grinding our database to a halt.
Is there any way to stop all avatar activity, or have I got to uninstall the arcade?

[MrZeropage]

if you have at least mySQL 4.1:

open /arcade/functions/dbclass.php

search for

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

and replace it with

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

This should help (and is included in next v2.6.8+)