Change serveridx to 1, but can't create guild or have buddies in game

[silvermcd]

I've changed all serveridx to 1
but after that i can't make a guild or simply have my own buddies

any fix for that?

 

[chiosin2]

Look @ ur GlobalMgrSvr.ini maybe you haven't change any ServerIdx=X there =D.

 

[silvermcd]

Look @ ur GlobalMgrSvr.ini maybe you haven't change any ServerIdx=X there =D.

????

i don't have any serveridx at that ini file !

:O

anyone has a fix for THIS?...

 

[chacina]

for change id is not fast, some files, include DB...

 

[silvermcd]

for change id is not fast, some files, include DB...

witch files?

 

[chacina]

go to /etc/cabal/
change all _24 for _01

ChatNode_01

ServerNationIdx=1
ChatNodeIdx=1

DBAgent_01

ServerIdx=1
DBAppName=DBAgent_01

GlobalMgrSvr

[Server01]
# Adult(On)
ServerOpen01=1
ChannelType01=1
MaxUserNum01=300

server_list

GlobalDBAgent
DBAgent_01
GlobalMgrSvr
ChatNode_01
LoginSvr_01
CashDBAgent
WorldSvr_01_01

WorldSvr_01_XX

ServerIdx=1

go to /usr/bin/
DBAgent_24 => DBAgent_01
ChatNode_24 => ChatNode_01
WorldSvr_24_01 => WorldSvr_01_01

open you database and check all procedures, have 1 function on GAMEDB u need change too... you will spend some time here...
good luck...

IMPORTANT:

GameDB > Functions > GetServerIdx

CREATE FUNCTION [dbo].[GetServerIdx] ()
RETURNS INT  AS
BEGIN
    RETURN ([COLOR="Red"]1[/COLOR]) 

END

cabal_managerdb > table > cabal_server_table



change 192.168.227.1 for you SQL IP...
u can change too cabalserver

 

[silvermcd]

thanks it worked

 

[plemaster]

change all _24_XX for _01_XX

chatnode_01

ServerNationIdx=1
ChatNodeIdx=1

DBAgent_01

ServerIdx=1

GlobalMgrSvr

[Server01]
# Adult(On)
ServerOpen01=1
ChannelType01=1
MaxUserNum01=300

WorldSvr_01_XX

ServerIdx=1

go to init.d and find all link _24 and change for _01

open you database and check all procedures, have 1 function on GAMEDB u need change too... you will spend some time here...
good luck...

what's function need to change ?

 

[chacina]

GameDB > Functions > GetServerIdx

CREATE FUNCTION [dbo].[GetServerIdx] ()
RETURNS INT  AS
BEGIN
    RETURN ([COLOR="Red"]25[/COLOR]) 

END

change 25 for 1...

 

[plemaster]

GameDB > Functions > GetServerIdx

CREATE FUNCTION [dbo].[GetServerIdx] ()
RETURNS INT  AS
BEGIN
    RETURN ([COLOR=red]25[/COLOR]) 
 
END

change 25 for 1...

RETURN (25)

after i changed all link _24 to _01

and go to GAMDB
GameDB > Functions > GetServerIdx

CREATE FUNCTION [dbo].[GetServerIdx] ()
RETURNS INT AS
BEGIN
RETURN (25)

END

change 25 for 1

.... WHEN
service cabal start

GlobalDBAgent (pid 8189) is running...
DBAgent_24 is stopped
GlobalMgrSvr (pid 8263) is running...
ChatNode_24 is stopped
LoginSvr_01 (pid 8328) is running...
CashDBAgent (pid 8361) is running...
WorldSvr_24_01 is stopped

----

my file DBAgent_01.ini

[DBAgent]
ServerIdx=24
DBProcessTNum=5
DSN=CabalGame24 << i need to cange to 01 ?
[DSN]
DBId=cabal
DBPwd=cabal
DBAppName=DBAgent_24 << i need to cange to 01 ?

and file odbc.ini
[CabalGame24] << i need to cange to 01 ?
Driver = FreeTDS
Address = 192.168.2.102
Port = 1433
Database = GAMEDB
TDS_Version = 8.0



T T:scratch: how can i fixed it ?~

thank you

 

[chacina]

i think is not necessary change odbc, DBAppName you can change 24 for 01
here you fix... sorry... (etc\cabal)
server_list

GlobalDBAgent
DBAgent_24
GlobalMgrSvr
ChatNode_24
LoginSvr_01
CashDBAgent
WorldSvr_24_01

and change for

GlobalDBAgent
DBAgent_01
GlobalMgrSvr
ChatNode_01
LoginSvr_01
CashDBAgent
WorldSvr_01_01

 

[Twiddle]

I try change to 1 but it doesn't work. SOme one can give me gude step by step coz i dont remember where files with "24"
Big tnx!

 

[plemaster]

i think is not necessary change odbc, DBAppName you can change 24 for 01
here you fix... sorry... (etc\cabal)
server_list

GlobalDBAgent
DBAgent_24
GlobalMgrSvr
ChatNode_24
LoginSvr_01
CashDBAgent
WorldSvr_24_01

and change for

GlobalDBAgent
DBAgent_01
GlobalMgrSvr
ChatNode_01
LoginSvr_01
CashDBAgent
WorldSvr_01_01

it's work !! :flag_schwthank you ^;_;^

:drinks_no

 

[chumpywumpy]

I try change to 1 but it doesn't work. SOme one can give me gude step by step coz i dont remember where files with "24"
Big tnx!

Simply wait a bit. I hear a solution for this is being released soon :wink_4:

 

[Twiddle]

Simply wait a bit. I hear a solution for this is being released soon :wink_4:

ill be wait for it tnx bro

 

[vzae]

Please help. I have followed your steps but stuck on the last 2 on database changes.

IMPORTANT:

GameDB > Functions > GetServerIdx

CREATE FUNCTION [dbo].[GetServerIdx] ()
RETURNS INT  AS
BEGIN
    RETURN ([COLOR="Red"]1[/COLOR]) 


END

I tried the change as follows but I ended up could not create a char. Gave me unknown DB error message when I tried to create a char in-game.

cabal_managerdb > table > cabal_server_table

View attachment 59927

change 192.168.227.1 for you SQL IP...
u can change too cabalserver

When I go to cabal_managerdb > table > cabal_server_table it is empty there with lots of null. When I tried to edit it according to the picture, I could not however change the NULL to 1 for the bReal. It gave me an error.