[Disasterpiece]

You'd have to create a new column with the exact datatype like the original column (if that istn't already done) then you'd have to create a php script, that queries every user row, builds a new query with updated userid (+1) in the WHERE clause to apply the sql query.

Could look something like this:

SELECT userid, thankedamount FROM vb4_user

The function will return an array which you'll run through in a foreach loop, then you run a query for every user:

UPDATE vb4_user SET thankedamount = ".$thankedamount." WHERE userid = ".$userid+1

Depending on how good your knowledge in php is, this will be a quite simple task.