[RSS Feed/News] Modifying column data and adding that data to new column

[XenForo]

I have a xf_user column that has data from an old custom add-on. I'd like to modify the number value of this field and then import it into a column for a new add-on. I'm not familiar with SQL commands, but after a little research, this is what I came up with:

Code:

UPDATE xf_user set post_quota = post_quota *.01

Takes old add-on data, where users have earned a post credit, and reduces by 100x. (necessary due to how old add-on counted data). 8000 credits becomes 80 credits, and so on...

Read more

ادامه مطلب...