Where possible we try and contact the
artist or author for permission to use their work but this is not
always possible due to the artist or author not being listed at the
source we find, out of date links or incorrect contact details. If
we are using some of your work please email art@swcombine.com
and we will happily provide credit.
[0.00048]SELECT c.handle
FROM `transactions` as t,
`characters` as c
WHERE t.`sender` LIKE 'Veynom' AND
t.`senderType` = 1 AND
t.`receiverType` = 1 AND
t.type=1 AND
t.receiver = c.characterID
GROUP BY c.handle
ORDER BY t.DATE DESC
db_query
["SELECT c.handle
FROM `...transactions` as t,
`characters` as c
WHERE t.`sender` LIKE 'Veynom' AND
t.`senderType` = 1 AND
t.`receiverType` = 1 AND
t.type=1 AND
t.receiver = c.characterID
GROUP BY c.handle
ORDER BY t.DATE DESC"]
[0.00022]SELECT count(*) AS ttl FROM `players` WHERE `loginStamp` > 415393904 [0.00036]SELECT count(*) AS ttl FROM `players` WHERE `loginStamp` > 415996904
Footer
Banner Exchange
[0.00018]SELECT DISTINCT counter FROM bannerRotate WHERE type=0 [0.00032]SELECT counter FROM bannerRotate WHERE name='Purchasing Banner Counter' LIMIT 1 [0.00031]SELECT * FROM bannerRotate WHERE type=0 ORDER BY counter LIMIT 1 [0.00034]UPDATE bannerRotate SET counter=0 WHERE name='Purchasing Banner Counter' LIMIT 1 [0.00011]UPDATE bannerRotate SET counter=counter+1 WHERE bannerID=1