The Official Taiwan SRO Server files v1.258 // CSRO-R Server Files

[Isoline]

How to change the 2 hour and 28 minutes to 28 days ~ lol.

lol, this is a standart procedure, find out the item codename and check its values on _RefObjCommon / _RefobjItem, sniff arround a littile bit.
btw, send me the item codename, or how did you get it.

[RenePunik]

This is the item codename "ITEM_MALL_PET_WATCH_AGOL_4W" ~ btw the item was inactive i activated it... the only problem is the time.. i want to change 2hours - 28 minutes to 28 days.

[Nemo07Back]

This is the item codename "ITEM_MALL_PET_WATCH_AGOL_4W" ~ btw the item was inactive i activated it... the only problem is the time.. i want to change 2hours - 28 minutes to 28 days.

from _refskill

[RenePunik]

from _refskill

I think it won't work, because this is an old item and its paramters are incorrect in both refskill and refobjitem ~ i think problem is on "INC_INVENTORY_SIZE" i'm searching for this code it may be the code for changing the time.

[Francisco Laiho]

Guys, help please. i try to restore db but i get this error, can you help me? its my free day so i have time to setgup my server

[slander]

Help me for connection

[sherio]

Help me for connection

Me too i have this problem ...can any one help ?

[Blacksheep25]

Me too i have this problem ...can any one help ?

Help me for connection

Use edxloader, it will fix this error message

[sherio]

Fixed Thx

[Kaspars Erglis]

why these files now got viruss on them? In fierst day those files was clean!

[Kaspars Erglis]

Hello. Somebody can share querry to clean all old user data + characters from DB's
Damit spended 6h on that but no result! Always something to destroy items(cant destroy eny degree).

[RenePunik]

Hello guys, Anyone still developing on this files?, If yea. So report your bugs.
It will show some errors in first time on executing, so you have to make 2 or 3 times of cleaning to protect yourself from any error. in real i didn't know what cause of errors that showing but anyway it's working fine.

Like if helped.

Query for clean databases:

USE [SRO_TW_ACCOUNT]
GO
TRUNCATE TABLE [dbo].[__SiegeFortressStatus__]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[_ShardCurrentUser]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[SK_Silk]
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
TRUNCATE TABLE [dbo].[SR_ShardCharNames]
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[SK_SilkChange_By_Web_Log]
----------------------------------------------------------------------------------------------------------------------------------------------------
USE [SRO_TW_SHARD] 
GO
TRUNCATE TABLE [dbo].[_Chest]
TRUNCATE TABLE [dbo].[_ChestInfo]
TRUNCATE TABLE [dbo].[_User]
TRUNCATE TABLE [dbo].[_OpenMarket]
DELETE FROM [dbo].[_AccountJID]
TRUNCATE TABLE [dbo].[_BlockedPartyInviter]
TRUNCATE TABLE [dbo].[_BlockedWhisperers]
TRUNCATE TABLE [dbo].[_GuildWar]
TRUNCATE TABLE [dbo].[_GuildMember]
TRUNCATE TABLE [dbo].[_GuildChest]
TRUNCATE TABLE [dbo].[_SiegeFortressStruct]
TRUNCATE TABLE [dbo].[_SiegeFortressObject]
TRUNCATE TABLE [dbo].[_SiegeFortressItemForge]
DELETE FROM [dbo].[_SiegeFortress]
INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (1)
INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (3)
INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (6)
UPDATE [dbo].[_AlliedClans] SET Ally1 = '0', Ally2 = '0', Ally3 = '0', Ally4 = '0', Ally5 = '0', Ally6 = '0', Ally7 = '0', Ally8 = '0'
DELETE FROM [dbo].[_Guild] WHERE ID > 0
DELETE FROM [dbo].[_AlliedClans] WHERE ID > 0
TRUNCATE TABLE [dbo].[_InventoryForAvatar]
TRUNCATE TABLE [dbo].[_TrainingCampSubMentorHonorPoint]
TRUNCATE TABLE [dbo].[_BlockedWhisperers]
TRUNCATE TABLE [dbo].[_TrainingCampMember]
TRUNCATE TABLE [dbo].[_CharTrijobSafeTrade]
DELETE FROM [dbo].[_CharTrijob] WHERE CharID > 0
TRUNCATE TABLE [dbo].[_TimedJob]
TRUNCATE TABLE [dbo].[_StaticAvatar]
TRUNCATE TABLE [dbo].[_Inventory]
TRUNCATE TABLE [dbo].[_Memo]
TRUNCATE TABLE [dbo].[_FleaMarketNetwork]
TRUNCATE TABLE [dbo].[_Friend]
TRUNCATE TABLE [dbo].[_FriendGroup]
TRUNCATE TABLE [dbo].[_CharSkillMastery]
TRUNCATE TABLE [dbo].[_CharTradeConflictJob]
TRUNCATE TABLE [dbo].[_CharTradeConflictJob_Kill]
TRUNCATE TABLE [dbo].[_CharSkill]
TRUNCATE TABLE [dbo].[_InvCOS]
DELETE FROM [dbo].[_CharCOS] WHERE ID > 0
DELETE FROM [dbo].[_Char] WHERE CharID > 0
TRUNCATE TABLE [dbo].[_CharAlchemy_MK_Recipe]
TRUNCATE TABLE [dbo].[_CharCollectionBook]
TRUNCATE TABLE [dbo].[_CharInstanceWorldData]
TRUNCATE TABLE [dbo].[_CharNameList]
TRUNCATE TABLE [dbo].[_CharNewTrade]
TRUNCATE TABLE [dbo].[_CharNickNameList]
TRUNCATE TABLE [dbo].[_CharQuest]
TRUNCATE TABLE [dbo].[_ClientConfig]
TRUNCATE TABLE [dbo].[_ConsignmentTrade_Invest]
TRUNCATE TABLE [dbo].[_DeletedChar]
TRUNCATE TABLE [dbo].[_GPHistory]
TRUNCATE TABLE [dbo].[_ItemPool]
TRUNCATE TABLE [dbo].[_TempChest]
DELETE FROM [dbo].[_Items] WHERE ID64 > 0
TRUNCATE TABLE [dbo].[_TimedJobForPet]
TRUNCATE TABLE [dbo].[_TrainingCampBuffStatus]
TRUNCATE TABLE [dbo].[_TrainingCampHonorRank]
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (1)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (2)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (3)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (4)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (5)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (6)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (7)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (8)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (9)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (10)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (11)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (12)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (13)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (14)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (15)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (16)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (17)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (18)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (19)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (20)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (21)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (22)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (23)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (24)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (25)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (26)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (27)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (28)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (29)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (30)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (31)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (32)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (33)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (34)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (35)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (36)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (37)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (38)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (39)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (40)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (41)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (42)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (43)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (44)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (45)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (46)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (47)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (48)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (49)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (50)
EXEC [dbo].[_TRAINING_CAMP_UPDATEHONORRANK]
DELETE FROM [dbo].[_TrainingCamp]
TRUNCATE TABLE [dbo].[Tab_RefRanking_HunterContribution]
TRUNCATE TABLE [dbo].[Tab_RefRanking_RobberContribution]
TRUNCATE TABLE [dbo].[_TradeBagInventory]
TRUNCATE TABLE [dbo].[_TradeEquipInventory]
TRUNCATE TABLE [dbo].[_UserTradeConflictJob]
TRUNCATE TABLE [dbo].[_RenameLog_Char]
TRUNCATE TABLE [dbo].[_SilkItemRepairedLog]
TRUNCATE TABLE [dbo].[_UserTradeConflictJob]
----------------------------------------------------------------------------------------------------------------------------------------------------
USE [SRO_TW_LOG]
GO
TRUNCATE TABLE [dbo].[_CompeltedConsignmentTradeLOG]
TRUNCATE TABLE [dbo].[_ConsignmentTrade_PrevInvestCharLog]
TRUNCATE TABLE [dbo].[_ConsignmentTrade_Progress_RuntimeLog]
TRUNCATE TABLE [dbo].[_ConsignmentTrade_Reward]
TRUNCATE TABLE [dbo].[_LogCashItem]
TRUNCATE TABLE [dbo].[_LogEventChar]
TRUNCATE TABLE [dbo].[_LogEventItem]
TRUNCATE TABLE [dbo].[_LogEventSiegeFortress]
TRUNCATE TABLE [dbo].[_LogSchedule]
TRUNCATE TABLE [dbo].[_LogServerEvent]

[RenePunik]

Could someone manage to find what is exactly lines was making crash in learn recipes?

Use edxloader, it will fix this error message

Can we use "Vsro Patch Address Detector" for make it open on server machine?

[SnapPop]

Sorry to say that but CSRO-R Files are fake thats not csro-r file, not even the dlls of csro, but i hope that community do something with the twsro files if they are not fake too ^^

BTW, Merry Christmas babies ;)

bingo!
obviously they are vsro files in many ways: xtrap(Agent), BillingServer(Shard) and ./Script/VIETNAM/ within GameServer
however there's no guarantee which version these files are specially there's no certain modified date just all of them 2013 makes it hard to determine
but from the size of GameServer and ShardManager compared to vsro 193, lemme guess xD vsro v208! or maybe a lil bit newer idk

[isHabboFan1]

Can someone please send me the cracked gameserver?
I never used ollydbg...