
Originally Posted by
The special Cypher readme
At present the server queries execute stored procedures in the databases and some of these have hard coded values. For example cabal_sp_newchar in account db does similar to this this several times:
EXEC account.dbo.cabal_sp_update_character_count @userNum, @serverIdx, 1
This points the query at a database called "account" and the cabal_sp_update_character_count SP in that specific database. What if your account database is not called "account"? Several SPs need to know what databases they are connecting to, for example 2 different servers (mercury/mars) would be accessible for 1 login unless they knew which "server" (and account/game databases) they belonged to. This is not good. Database stored procedures need to be self aware of their names and partner databases.