View previous topic :: View next topic |
Author |
Message |
Kato
Joined: 05 Mar 2010 Posts: 47
|
Posted: Thu Jun 23, 2011 8:41 Post subject: Pure MySQL Object Storage? |
|
|
Anyone knows if it's possible to store and retrieve objects from a MySQL table without using StoreCampaignObject() and RetrieveCampaignObject? SetPersistentObject calls StoreCampaignObject, just like all the storage systems I have seen so far...
Thank you!
Kato |
|
Back to top |
|
|
virusman
Joined: 30 Jan 2005 Posts: 1020 Location: Russia
|
Posted: Thu Jun 23, 2011 11:35 Post subject: |
|
|
What's wrong with SCO/RCO? _________________ In Soviet Russia, NWN plays you! |
|
Back to top |
|
|
Kato
Joined: 05 Mar 2010 Posts: 47
|
Posted: Thu Jun 23, 2011 20:21 Post subject: |
|
|
Nothing, I guess, except that I don't trust BioWare DBs. I'm currently using a MySQL DB for all my systems(guild, gold and xp bank etc...), except the item storage one, still under an old, huge, slow BioWare DB(.dbf), and since I need to "dump" it to the MySQL one for speed, flexibility and reliability, I only wished to make sure I was using the best possible technique to avoid messing with this all over again. Calling a BioWare DB function from a MySQL query feels strange, but if there is no other way, then I suppose I have no choice...
Kato |
|
Back to top |
|
|
virusman
Joined: 30 Jan 2005 Posts: 1020 Location: Russia
|
Posted: Thu Jun 23, 2011 20:50 Post subject: |
|
|
NWNX ODBC hooks SCO/RCO, bypassing the built-in DB. You call the same functions, but the query will be passed to MySQL instead of dbf if you use SetSCORCOQuery and pass "NWNX" as database name to SCO/RCO. _________________ In Soviet Russia, NWN plays you! |
|
Back to top |
|
|
Kato
Joined: 05 Mar 2010 Posts: 47
|
Posted: Thu Jun 23, 2011 21:14 Post subject: |
|
|
Okay, thank you Virusman, you were quick to answer, indeed!
Kato |
|
Back to top |
|
|
|