DROP TABLE IF EXISTS rich;
CREATE TABLE rich SELECT obj_Id,char_name FROM characters;
ALTER TABLE rich ADD PRIMARY KEY (obj_Id);
ALTER TABLE rich ADD armor decimal(20) unsigned NOT NULL;
ALTER TABLE rich ADD etcitem decimal(20) unsigned NOT NULL;
ALTER TABLE rich ADD adena decimal(20) unsigned NOT NULL;
ALTER TABLE rich ADD weapon decimal(20) unsigned NOT NULL;
ALTER TABLE rich ADD summary decimal(20) unsigned NOT NULL;
UPDATE rich SET armor = (SELECT SUM(count*price) FROM items,armor WHERE obj_Id=owner_id AND items.item_id=armor.item_id);
UPDATE rich SET etcitem = (SELECT SUM(count*price) FROM items,etcitem WHERE obj_Id=owner_id AND items.item_id != 57 AND items.item_id=etcitem.item_id);
UPDATE rich SET adena = (SELECT SUM(count) FROM items WHERE items.item_id=57 AND obj_Id=owner_id);
UPDATE rich SET weapon = (SELECT SUM(count*price) FROM items,weapon WHERE obj_Id=owner_id AND items.item_id=weapon.item_id);
UPDATE rich SET summary = armor+etcitem+adena+weapon;