Rollback 2.2.3

[rafa023]

First of all, I would like to thank any help.

Let`s begin with my problem. We were developing a 2.2.3 server. Everything went fine until our dev tried to able the login of the staff. We had a annoying "Loging Server Connection Failure" error and after oppeing lots of ports and search, we decided to try the HAMACHI. It worked, we managed to login.

The problem is, we are now getting a strange rollback with our GM accounts. Let me explain it further, we login our GM account, set the lvl to 65, put some random gears. As soon as we logout, our char is back to lvl 1 and sometimes the items are there, but sometimes even the items are gone (and in some cases, even the created char is gone).

And when you select the character, you enter in a black screen. We suppose we get dced in that black screen, but we are not sure. And when it happens, the only way is to delete it and create a new one. And the process repeat it self over and over again.

We have already tried the 2.2.3.2 and we had the same error. We restored the database several times, we tried different versions of the SQL and we even changed the pc where the server was... Still the same error keep showing up.

We use Windows 7 64bits, SQL Server 2008 R2.

I can fraps the errror if needed.

 

[Marnkx]

First of all, I would like to thank any help.

Let`s begin with my problem. We were developing a 2.2.3 server. Everything went fine until our dev tried to able the login of the staff. We had a annoying "Loging Server Connection Failure" error and after oppeing lots of ports and search, we decided to try the HAMACHI. It worked, we managed to login.

The problem is, we are now getting a strange rollback with our GM accounts. Let me explain it further, we login our GM account, set the lvl to 65, put some random gears. As soon as we logout, our char is back to lvl 1 and sometimes the items are there, but sometimes even the items are gone (and in some cases, even the created char is gone).

And when you select the character, you enter in a black screen. We suppose we get dced in that black screen, but we are not sure. And when it happens, the only way is to delete it and create a new one. And the process repeat it self over and over again.

We have already tried the 2.2.3.2 and we had the same error. We restored the database several times, we tried different versions of the SQL and we even changed the pc where the server was... Still the same error keep showing up.

We use Windows 7 64bits, SQL Server 2008 R2.

I can fraps the errror if needed.

My opinion is there are might some wrongs in your databases and use MSSQL enterprise to make it better well message me ill help you since not really sure what your problem is

 

[jbrannon2]

1st thing you should try, do not level yourself to 65 right off the bat.
create one, level it to say 49, then exit game

log in and see if you're lvl 1 again, or still 49.

That's most likely not the cause of your problem, but may as well rule it out competely

 

[maxpmes]

1st thing you should try, do not level yourself to 65 right off the bat.
create one, level it to say 49, then exit game

log in and see if you're lvl 1 again, or still 49.

That's most likely not the cause of your problem, but may as well rule it out competely

I have this problem, and already try put lv 30, 40, 50, 60, 65... all lvl he put, when log out and log in again, he got lv1, and lost itens from you bag, like the initial itens... I will make a explanation with files configs and SS from the problem to all see what happen...

Ok, I'll try to show my problem...

My config files:

rfacc.ini

[Options]
DBSTR    = Provider=mssql;Data Source=BillCruxRF;User ID=rfadmin; Password=123456;
ErrDBSTR =                              ^^^^ My login and pass ^^^^
LogLevel = 2

AccountSystem.ini

[Database]
AccountDB_Machine = 192.168.1.10
AccountDB_Name = RF_USER

[System]
NationCode = US

[DB_INFO]
IP = 192.168.1.10
Port = 1433
DSN = BillCruxRF
DBName = BillCruxRF
Acc = rfadmin <<< my login
PW = 123456  <<<<my pass


[Service]
MaxAccountNum = 200

[World]
WorldSet_Num = 1
ServiceSet_Num = 1

Name0 = RF Prometheus
Address0 = 192.168.1.10
DBName0 = RF_WORLD_NOVUS
Type0 = 0

BillingSystem.ini

[System]
ZoneAddress = 192.168.1.10
NationCode = BR

[BILLING NETWORK BRAZIL]
SERVER_NAME = BillCruxRF
IP = 192.168.1.10
PORT = 1433
CP_ID = 1
GROUP_NUM = 1
SERVER_NUM = 1
GAME_ID = 1

LoginSystem.ini

[Account]
AccountAddress = 192.168.1.10

[System]
NationCode = CN

[CHECK ADDRESS]
CHECK = TRUE

[LOG]
AUTH_LOG = TRUE

[World]
Lim World Num = 7
DB Push Job = 0

[BILLING]
Check = FALSE
BillingCode = 78

[MOTP]
Service = TRUE
HostName = 192.168.1.10
HostIP = 192.168.1.10
URLPath = /MOTPValidation/ValidationServlet
Port = 12380

[IP Address Filter]
FilterNum = 1
Filter0 = 192.168.1.10
FilterRange0 = 255

[UserCountDisplyLimit]
Limit0 = 5000
Limit1 = 12000
Limit2 = 27000

[CHI_BILLING]
Addr = 192.168.1.10
Port = 1433
DBName = BillCruxRF
ACC = rfadmin <<< My login
PW = 123456  <<<< My Passw

LoginSystem.ini

[IPAddress]
FilterNum = 0

Filter0 = 192.168.1.10
FilterRange0 = 255
[ID]

FilterNum = 8
Filter0 = !sora
Filter1 = !maxwel
Filter2 = !teste1
Filter3 = !teste2
Filter4 = !teste3
Filter5 = !teste4
Filter6 = !teste5
Filter7 = !teste6

WorldInfo.ini

[System]
WorldName = RF Prometheus
ServerType = 0

BillingCode = 32
BillOper = 1
FreeServer = 1
Address = 192.168.1.10
GateIP = 192.168.1.10

HBKPath = c:\Work\HBK
HistoryPath = c:\Work\History

NationCode = US

[Rule]
CrystalHPMultiple   = 1.0
CrystalHPMultiple_1 = 5.0
CrystalHPMultiple_2 = 8.0
CrystalHPMultiple_3 = 11.0

[GUILD CREATE EVENT]
Enable = TRUE
START_DATE = 20090119
END_DATE = 20090120

WorldSystem.ini

[System]
AccountAddress = 192.168.1.10
LimUserNum = 10000

[MainThread]
SleepTerm = 2
SleepValue = 2
SleepIgnore = 2

[Messenger]
Use = TRUE

[RankJob]
JobHour = 23
JobMin = 40

[Rule]
AttackSpareDelay = 200

[Economy]
Default_MgrVal =1000
Default_TaxVal =10
;Default_OreVal =10000
Default_OreVal =3500
2004/6/19_MgrVal = 1000
2004/6/19_TaxVal = 10

[HolySystem]
KeeperCreateMap = resources    
KeeperCreateDummy = dk0001
KeeperActiveDummy = hskactdum
KeeperCenterDummy = dk0001
KeeperMonrCode = 04903

StoneNum = 3

StoneCreateMap0 = resources
StoneCreateDummy0 = dh001
StoneMonsterCode0 = 04B00
StoneMasterRace0 = 0    

StoneCreateMap1 = resources
StoneCreateDummy1 = dh002
StoneMonsterCode1 = 04B01
StoneMasterRace1 = 1    

StoneCreateMap2 = resources
StoneCreateDummy2 = dh003
StoneMonsterCode2 = 04B02
StoneMasterRace2 = 2    
QuestInit=1

[Schedule]
ScheduleInit=0

[Formula]
StdDefPoint=3
RcvDefPoint=10

[Buddha Event]
Enable = FALSE
GiveItem = irpre01
ExchangeItem = irpre01
DeleteItem1 = 
DeleteItem2 = 


[CLASS REFINE EVENT]
ENABLE = TRUE
START_DATE = 20090810
END_DATE = 20090810
LIMIT_COUNT = 1

[PcBang Favor]

USE = FALSE

[System]

[Time Limit]
Use = FALSE

CNT = 3
Time_0 = 0
Time_1 = 300
Time_2 = 500

Percent_0 = 1.0
Percent_1 = 0.5
Percent_2 = 0.0

LogoutTerm = 10
NotifyTerm = 2

[VersionCheck]
;Ver_CheckKey = 4cd89361876d5dbe2d9abfb79951079f - 5
;Ver_CheckKey = 69a4038868c8a2e5c24bc9760f360e4f - 6
;Ver_CheckKey = 2092c70681144ec40b8ca27ee4d79540 - 7
;Ver_CheckKey = 411245623aff770e230654f29e3e5d87 - 7
;Ver_CheckKey = 8cd8aab1551122715050d8eedc3b511b - 8
;Ver_CheckKey = 98d12740c527fde4514d46d2a3869c63 - 8
;Ver_CheckKey = 8cd8aab1551122715050d8eedc3b511b - 8
;Ver_CheckKey = 98d12740c527fde4514d46d2a3869c63 - 8
;Ver_CheckKey = a1acbc0562a1372dcca375865f6cc98a - 9
;Ver_Checkkey = f69e40dcb39fb9d24c05c60a1b5398c4 - 10
;Ver_Checkkey = 75a32d4a6daff548fcfcb4Ofea838aOd - 11

WebAgentSystem.ini

[World]

WorldSet_Num = 1

Name0 = RF Prometheus
Address0 = 192.168.1.10
Code0 = 0

SystemManager.ini

[LOGINFO]
LOGFILEPATH    = c:\historymanager

[SERVERINFO]
SERVERNUMBER     =    1

SERVERIP0    =    192.168.1.10
SERVERNAME0    =    RF Prometheus
USEHISTORYBACKUP0=    FALSE
SERVERTYPE0    =    0

Apex.ini

[Apex_Setting]
Server = 192.168.1.10
Port = 15306

ControlSystem.ini

;; [MONEYTRAFFIC] ?????? ???­·® ±?·??? °??? ????????
;; Save?? ???­·® ±?·??» »????©???? ???? ???¤??·?, TRUE?? °??????? »??? FALSE?? °??????? »???????????.
;; Time?? ???­·®?» ±?·??? ???? ???» °??®????. 1300?? ???? 1???? ±?·??» ????°???°?, 1330?? ???? 1??30???? ±?·??» ????.
;; Time?? 2356(23??59??)???? ?¬ ?? ??????, 0???? ???» ?? ????. ?? °??????? Save°? ??µ???·? FALSE°? µ???.
[MONEYTRAFFIC]
Save    = TRUE
Time    = 1659

;; [NATIONALCODE] ??????????·? ???? ±?°??° ??µ? ?? ???? ??µ??? ???? ????????.
;; NationCode ?? °? ±?°??? ??µ?°??» ???¤????.
;; ServiceMode ?? ?????® ?­????????, ?¤?? ?­???????? ±???????.
;; ???? 2009-01-12 ???? ±??» ???????­?? »???????, ?????? ??±? ±????? »??? ?©???¦ ???©????µ? »???????.
;; NOMAL :  ?¤???­??, TEST ?????® ?­??

[NATIONALCODE]
NationCode = US
ServiceMode = NOMAL

[Account]
;Temp
AccountAddress = 127.0.0.1

[LogSpy]
LogSpy = TRUE
LogSpyNum = 1
LogSpyAddress0 = 127.0.0.1


;; WorldServer(ZoneServer)?? ???­?? °??¤?­???? µ?·?µ??? ???? ??µ? ?­???? ???­?? °°???????? --
[WorldServer]
Number = 1

WorldServerIndex_0    = 0
WorldServerName_0    = Rf
WorldServerIP_0        = 127.0.0.1

[IP Adderss Filter]
FilterNum = 2
Filter0 = 192.168.1.10
FilterRange0 = 255

Filter1 = 127.0.0.1
FilterRange1 = 255

rmt_env.ini

; Controll Sever Address
[Control]
;±¹³» Á¤½Ä ¼­¹ö
;ControlAddress = 127.0.0.1
;Àεµ³×½Ã¾Æ
ControlAddress = 127.0.0.1
;ControlAddress = 192.168.1.232

[NATIONALCODE]
NationCode = US
ServiceMode = NOMAL

[Trunk Hints]
Hint Num = 8
Hint0 = ³ªÀǺ¸¹° 1È£
Hint1 = ÁÁ¾ÆÇÏ´Â Àå¼Ò
Hint2 = ÁÁ¾ÆÇÏ´Â ²É
Hint3 = ÁÁ¾ÆÇÏ´Â Ç༺
Hint4 = Á¸°æÇÏ´Â Àι°
Hint5 = ÁÁ¾ÆÇÏ´Â »ö
Hint6 = ³ªÀÇ Á¿ì¸í
Hint7 = ³ªÀÇ Ãâ»ýÁö

[MP3PLAY]
;; mp3 À½¾ÇÀÌ µé¾îÀÖ´Â Æú´õ(µð·ºÅ丮)
MP3PATH = .\mp3pfile        
;; À½¾ÇÀÌ ¾øÀ» °æ¿ì ±âº» Àç»ý À½¾Ç
MP3DEFAULT = partytime.mp3    
;; ¿î¿µÅø¿¡¼­ °ü¸®ÇÏ°ÔµÉ ¿¹»ó ¼­¹öÀÇ ¼ö
MP3SERVER = 10            

;; MP3PLAY µÚÀÇ 0ºÎÅÍ ¼ýÀÚ´Â ¿ùµå ÄÚµå
;; ù¹ø° ¼­¹ö À½¾Ç(0ºÎÅÍ ½ÃÀÛ)
MP3PLAY0  = partytime.mp3    
MP3PLAY1  = partytime.mp3    
MP3PLAY2  = partytime.mp3    
MP3PLAY3  = partytime.mp3    
MP3PLAY4  = partytime.mp3    
MP3PLAY5  = partytime.mp3    
MP3PLAY6  = partytime.mp3    
MP3PLAY7  = partytime.mp3    
MP3PLAY8  = partytime.mp3    
MP3PLAY9  = partytime.mp3    

; ¿ùµå Á¤º¸ â ¼­¹ö »óÅ ¾÷µ¥ÀÌÆ® °£°Ý
[WorldInfo]
RefreshTime = 1000

; ¼­¹ö ÀÀ´ä ¾øÀ½ ÅëÁö »ç¿îµå À̸§ ¹× ÅëÁö °£°Ý
[AlertSoundName]
Name = alert.wav
; millisecond
Interval = 1200

; History ¹× HolyStone °Ë»ö ½ÃÀÛ ³¯Â¥
[HistoryStartDate]
Year = 2004
Month = 1
Day = 1

; IP History °Ë»ö ½ÃÀÛ ³¯Â¥
[IPHistoryStartDate]
Year = 2004
Month = 9
Day = 21

; °ü¸®¸Þ´º â Å©±â
[MainMenuWindowsize]
Width = 320
Height = 500
SGHeight = 158


; °èÁ¤ Á¤º¸ â Å©±â
[AccountInfoWindowSize]
Width = 560
Height = 521

; ij¸¯ÅÍ Á¤º¸ â Å©±â
[CharacterInfoWindowSize]
Width = 600
Height = 472

; ¿ùµå ¼­¹ö â Å©±â
[WorldInfoWindowSize]
Width = 470
Height = 820
SGHeight = 535

; °øÁö ¸Þ¼¼Áö ÁøÇàâ Å©±â
[NotifyMsgWindowSize]
Width = 425
Height = 590

; À¯Àú Á¢¼Ó Á¤º¸ â Å©±â
[UserCountWindowSize]
Width = 463
Height = 542

; Ȧ¸®½ºÅæ Á¤º¸ â Å©±â
[HolyStoneWindowSize]
Width = 950
Height = 711

; ¼­¹ö ¼­ºñ½º ON, OFF ÁøÇà â Å©±â
[ServerOnOffWindowSize]
Width = 410
Height = 530

; ¼­¹ö Kick ÁøÇàâ Å©±â
[ServerKickWindowSize]
Width = 345
Height = 370

; IP History °Ë»ö °á°úâ(IP ·Î °Ë»ö) Å©±â
[IPHistoryInfoByIPWindowSize]
Width = 791
Height = 497
DWidth = 319
DHeight = 385

; »èÁ¦ ij¸¯ÅÍ ¸®½ºÆ®Ã¢ Å©±â
[DelCharacListInfoWindowSize]
Width = 588
Height = 428

; »èÁ¦ ij¸¯ÅÍ Á¤º¸Ã¢ Å©±â
[DelCharacInfoWindowSize]
Width = 432
Height = 533

; ±æµå Á¤º¸Ã¢ Å©±â
[GuildInfoWindowSize]
Width = 512
Height = 620

; ¿ùµåº° Àüü ±æµå Á¤º¸Ã¢ Å©±â
[WholeGuildInfoWindowSize]
Width = 805
Height = 635

; ij¸¯ÅÍ Àκ¥ Á¤º¸Ã¢ Å©±â
[CharacterInvenInfoWindowSize]
Width = 810
Height = 710

; ·Î±×ÀÎ ¾ÆÀÌÇÇ ºí·° Á¤º¸Ã¢ Å©±â
[LoginIPBlockInfoWindowSize]
width = 810
Height = 710

fg.ini

[Game Server]
Server Name=RF Prometheus

[FireGuard Server]
Server IP= 192.168.1.10
Server PORT=15444

[Detect Info]
Time Interval=180000

fgrs.ini

[Game Server]
Game Name=RFOnline
Server Name=RF Prometheus
Port=15445

[FireGuard Server]
Server URL=http://192.168.1.10:8080

Server URL=http://192.168.1.10:80

Server Port=80

[Detect Info]
Time Interval=5000

[FireGuard Use]
Use = TRUE

My SQL Configuration:


My ODBC Configuration:


My Login SQL:


All open without problem:


To create a GM account, I just run this script:

DECLARE @RC int
DECLARE @id varchar(13)
DECLARE @pw varchar(13)
DECLARE @depart varchar(32)
DECLARE @class varchar(12)
DECLARE @name varchar(12)
DECLARE @birthday varchar(10)
DECLARE @grade int
DECLARE @subgrade int
SELECT @id = 'maxwel'
SELECT @pw = '123456'
SELECT @depart = 'none'
SELECT @class = 'GM'
SELECT @name = 'Max'
SELECT @birthday = 'none'
SELECT @grade = 2
SELECT @subgrade = 4
EXEC @RC = [rf_user].[dbo].[pInsert_Staff] @id, @pw, @depart, @class, @name, @birthday, @grade, @subgrade
DECLARE @PrnLine nvarchar(4000)
PRINT 'Stored Procedure: rf_user.dbo.pInsert_Staff'
SELECT @PrnLine = ' Return Code = ' + CONVERT(nvarchar, @RC)
go

With these settings, the server opens apparently correct, but when I create a new character, put him on another level, like 65, 50, 40, no matter what level... when I log out and log in again... my char lost the level, and itens, like the initial itens...

I will try get more information and put here, anyone can help us??? I have five days of terror with this problem.
Thanks in advance for anyone help ... we really need ...

 

[maxpmes]

Video with problem:

Someone help us please ... we no longer know what to do ...

 

[Marnkx]

Video with problem:

Someone help us please ... we no longer know what to do ...

well just in my opinion its the database that has a problem, and one more thing why dont you guys just use the 2.2.3.2 so you dont have to worry about tht problem..

 

[maxpmes]

I try it now, and have same problem... I hope we can solve this problem...
I use files:
2232: http://forum.ragezone.com/f479/release-2-2-3-2-a-813133/
223: http://forum.ragezone.com/f479/release-server-file-2-2-a-799004/

It has a different configuration of SQL? Or maybe it's the way I am creating administrator accounts? I used the tutorial: http://forum.ragezone.com/f480/guide-rf-v2-2-3-a-803273/

And use the SqlScripts do creat GM account:

USE RF_User 
go

Insert Into tbl_StaffAccount (ID,PW,Grade,Depart,RealName,SubGrade,Birthday,ComClass) 
Values (Convert(binary,'!admin1'),convert(binary,'123456'),'2','none','test','4','01/01/1991','ADM')
go

 

[Marnkx]

I try it now, and have same problem... I hope we can solve this problem...
I use files:
2232: http://forum.ragezone.com/f479/release-2-2-3-2-a-813133/
223: http://forum.ragezone.com/f479/release-server-file-2-2-a-799004/

It has a different configuration of SQL? Or maybe it's the way I am creating administrator accounts? I used the tutorial: http://forum.ragezone.com/f480/guide-rf-v2-2-3-a-803273/

And use the SqlScripts do creat GM account:

USE RF_User 
go

Insert Into tbl_StaffAccount (ID,PW,Grade,Depart,RealName,SubGrade,Birthday,ComClass) 
Values (Convert(binary,'!admin1'),convert(binary,'123456'),'2','none','test','4','01/01/1991','ADM')
go

pm me ill help you with that..

 

[maxpmes]

pm me ill help you with that..

Patience and dedication unparalleled ... certainly more a friend who found ... lost hours of sleep to help someone who had never seen ... sensible and just opposite is true!
I'm downloading the SQL Enterprise 2008 to try again... see you soon... I have no words to thank ... just thanks again...

All work fine now... thks for the help Marnkx123... the problem is the SQL Server 2008 R2 Evaluation Portuguese version, I dunno if the problem is from Evaluation of the language... I know my problem is resolve... xD
Thks guys for atention.