Our GUID table starts at 0, so what this means is that someone bumped it up from say 10,000,000 to 11,000,000 at some point (after checking the db this is true)
Correct?
So with this in mind, I need to do the following:
Run a surgery script on my entire mangos database (all tables included) that does this:
Make multidimensional array (2) template [OLDGUID, NEWGUID]
For `mangos`.`creature`
1) set $new_guid = 0
2) get $old_guid, add to array as well
3) set $old_guid to $new_guid+1, add to array as well
THEN
For all other tables in `mangos`
1) where $guid(old guid) == array.OLDGUID
2) set $guid = array.NEWGUID
And make sure it runs on all fields with creature guid's do they will link properly with the new ID's
Gonna be some nasty surgery, ahhhhh working with other peoples work is so fun!