SWSRO DC

[szeplaki77]

?????? SWSRO Server File DC :S Help plz

[silkbotter]

i'm working on redoing the databases back to mssql server 2000 since everything over mssql2000 is just a waste of resources.
i am having the same problem atm.
does anyone have an idea why it happened?
still looking for myself, but i'm not finding the cause :S

[Dr.Abdelfattah]

that's cuz the shity globalmanager , try to use globalmanager of SL files or vsro ,
i really don't try but i check and i find that globalmanager with swsro files are completely damaged .

[silkbotter]

wrong.
i found the problem:
you renamed your account database!

now you have to change the name in a stored procedure as well.

open the shard database,
select "programability"
then "stored procedures"
and then right-click the stored procedure called "_GET_REMAIN_SILK"
select "modify"
and then replace the line
"exec SR_AccountDB.dbo._GETSILKDATAFORGAMESERVER @JID, @Silk_Own ....."
with the name of your database. (red needs to be edited )
then click on "execute" at the top

[ÑõÑ_Ŝŧóp]

Shard DB -> Programmability -> Stored Procedures -> dbo._GET_REMAIN_SILK(Modify)

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO


ALTER procedure [dbo].[_GET_REMAIN_SILK]
@JID int,
@Silk_Own int output,
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- 마일리지 최선호)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@Silk_Gift int output,
@Mileage int output
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

as
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- 마일리지 최선호)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
exec YOUR_ACCOUNT_DB_NAME_HERE.dbo._GetSilkDataForGameServer @JID, @Silk_Own output, @Silk_Gift output, @Mileage output
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

and you're done, this error happened when you changed the account db name, its SrAccountDB (w/e) so you need to change it in _GET_REMAIN_SILK


Edit:silkbotter was faster

[silkbotter]

hurr hurr =)
so i deserve a thanks. and you don't :P

btw.. sql server 2000 rocks *****! and it saves 1 gb of ram when full in use :P

[Dr.Abdelfattah]

i say i don't check this well
but it's oky that u find where is the problem ^ _ ^

Originally Posted by silkbotter

hurr hurr =)
so i deserve a thanks. and you don't :P

btw.. sql server 2000 rocks *****! and it saves 1 gb of ram when full in use :P

sure and if u use windows server 2000 u can use only 1 GB ram with only 3GHz normal processor

[silkbotter]

Originally Posted by Dr.Abdelfattah

i say i don't check this well
but it's oky that u find where is the problem ^ _ ^


sure and if u use windows server 2000 u can use only 1 GB ram with only 3GHz normal processor

ewww..yes.. but i was talking about a sql server 2000
running on a win server 2003 :P

and not on win server 2000 ^^