increasing damage of items and adding them to new table

i am willing to create some new items using the existing ones

i want to create new items in a new table lets call new_items and i want to increase the damage of items by percentage of 30%

can any one give me an example of the query i must use ?
question on stackoverflow

Which core are you wanting to do this for? 3.3.5 or 4.3.4? The answer will change depending on which core you’re using.


For a global increase, a core modification is needed for 4.3.4. The damage data is taken from a db2 file (there are multiples, based on type of weapon). Essentially, with the 4.3.4 server, damage is based entirely on item level.