Not sure if this is what you're looking for, but in the `items1 table, there are columns related to click effects for various items.
Assuming you have PEQ database loaded somewhere, run this in a query window:
Code:
select id,name,clicktype,clicklevel2,clicklevel,clickeffect from items where clickeffect > 0
Should see a bunch of items w/clickie effects. Not sure what all the -1 clickeffects values are.