| The idea here is that I have one function that changes quest flags (because the alternative is to write fifty billion every time I want to make a change anywhere). Each quest 'flag' has eleven variables that can hold a full, signed integer, allowing each stage in each quest to hold a pretty fantastic range of states.
The problem is that if I pass that function one new value and ten NULLs, it'll set all of those other columns to NULL. After thinking about it all day I remembered that in MySQL you can set a column to the value held by that column. |
