basically, you have to be very SQL literate to make if efficient. Doing simple insert ignores don't UPDATE existing rows...nor would you want them to in case they would overwrite what you put out there.
I basically do everything by hand for every update. Painful the first couple times, but once you get your wpm to 200+ and are a select/join/update god then you'll be fine. Its not really that bad. I can get my server sync'd up to the most recent database, source, and quests in about 30 mins.
__________________
OP of Irreverent Server (The Solo Server)
Our Forums
|