SphereServer BugTracker - SphereServer
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0001863SphereServernew feature requestpublic04-12-10 21:4224-07-14 20:39
ReporterRobert 
Assigned ToXuN 
PrioritynormalSeveritycrashReproducibilityN/A
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version20-09-2009, 0.56b Prerelease 
Target VersionFixed in Version0.56c Nightly 
Nightly Version20-09-2009
Experimental FlagsUnicode
Option FlagsOSIMultiSight
Internal Build Number
Summary0001863: More Sql Connections
DescriptionI'm using one sql database on local, and one on web. I have to use web's database asynchronously to avoid sphere(game) from freezing. When i need a data on web's server i change the MySqlHost and other parameters at runtime, but when both of this databases needed because of using aquerys (for web's database) sphere crashes. It will be great for us to have more than one "db." declarations in sphere.ini.
Steps To Reproduce
Additional InformationLike this
serv.MySqlHost=127.0.0.1
serv.MySqlUser=aaa
serv.MySqlPassword=xxxx
serv.MySqlDatabase=yyyy

serv.MySql2Host=72.100.200.50
serv.MySql2User=bbb
serv.MySql2Password=tttt
serv.MySql2Database=uuuu

db.connect, db2.connect
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
04-12-10 21:42RobertNew Issue
04-12-10 21:44RobertIssue Monitored: Robert
24-07-14 20:39XuNNote Added: 0002370
24-07-14 20:39XuNStatusnew => resolved
24-07-14 20:39XuNFixed in Version => 0.56c Nightly
24-07-14 20:39XuNResolutionopen => fixed
24-07-14 20:39XuNAssigned To => XuN

Notes
(0002370)
XuN   
24-07-14 20:39   
MySql values can be writen:

[function db1.connect]
serv.MySqlHost=127.0.0.1
serv.MySqlUser=aaa
serv.MySqlPassword=xxxx
serv.MySqlDatabase=yyyy
db.connect

[function db2.connect]
serv.MySql2Host=72.100.200.50
serv.MySql2User=bbb
serv.MySql2Password=tttt
serv.MySql2Database=uuuu
db.connect