hi i have my server running i had make some change on it but i cant find out the way to get it work the item mall if anyone can help me out please thanks..
Printable View
hi i have my server running i had make some change on it but i cant find out the way to get it work the item mall if anyone can help me out please thanks..
Client: Cash.SData(decrypt EP-4 or 5) ->export to csv or sql script -> SQL Database PS_GameDefs ProductList table (Server)
example attach
This actually took me a while to figure out and get to work, but it worked wonders when it finally did.
The first step is extracting your data.saf. ledok made a post containing a file to download for that here. This can take a few minutes, so a soda and a snack or 2 may come in handy, depending on your system performance ^_^
Step 2 is to decrypt the cash.sdata you'll find in the extracted folder. I haven't been able to find a good decrypter on here, but I know there is one on another forum-that-shall-not-be-named-here. I'd post it, but I don't want to accidentally upset someone by posting their programs. When it's decrypted it should have a file name of cash.sdata.decrypted. You'll need to copy this to a new location and change it back to cash.sdata
Step 3, Twilight pretty much covered. You'll want to run the Cash Editor that he posted. Be careful, though, this cash editing program can be a little glitchy, especially with the SQL query it can create.
In the Cash Editor, you'll want to remove any items you don't wish to have in there. Let me explain the boxes that really mean much of anything (or that I've been able to figure out):
- ID: This pertains to the RowID column in your dbo.ProductList table in your GameDefs DB.
- Pack: This will put the item in the respective pack in the item mall. This corresponds to the packs in the Item Mall itself, from left-most tab (1) to right-most tab (4).
- Icon: The item's icon number. Haven't figured out how to get this to work properly yet.
- Point: How much you want the item to be. This will be displayed in the item mall window.
- ItemID: This corresponds to the ItemID column in the dbo.Items table in the GameDefs DB.
- Name: The name you wish displayed for that particular item
- Code: This corresponds to the ProductCode column in dbo.ProductList. It should be short. An example code I have is the Max Flash lapises I have up in my own item mall: B1_MaxLapi0001
- Desc: This is the description of the item
Now, one thing I've noticed while working on this: The ID's of the items should be in sequential order as you go down the list. If they're not, I've run into some errors, the worst of which being that my game doesn't start up properly.
When you want to make a new item, just fill in over one of the items with the appropriate information and click the "Add" button at the bottom. When you're finished, click the "Save" button and save over your decrypted cash.sdata file. Then click "SQL Save" and it will create a SQL query for you. If it shows up with any errors, look through and fix them up, and it should put this into your dbo.ProductList table.
Step 4: Re-encrypt the cash.sdata file. It will end up with a ".encrypted" file extension. Simply rename it to "cash.sdata" and replace the file in the extracted data.saf folder.
Step 5: You're going to need to repack your data.saf file. I use a program called SHAIYA_MAKE_v0-1, personally and it's never given me any kinds of issues. I'd post the program here, but as before, I won't do that without the developer's permission. Again, a soda and snack or 2 may come in handy while you wait.
Step 6: While the data.saf and .sah are making, make a new folder in your client folder. When it's made, place the data.saf and .sah in there, since that is the last known working files you have. When the new data.saf and .sah files are done making, simply place those in the client folder with your game.exe and start it up.
If everything worked out according to plan, your item mall should be fully customized.
If you want to change the number of items that show up when someone purchasing something, you can do that in the dbo.ProductList table. You'll see some columns named "ItemID<#>" and "ItemCount<#>" where the "<#>" is a number between 1 and 24. In the ItemID columns is where the ItemID's of your item mall items should be. ItemCount is how many of that item will show up in the inventory after it's been purchased. If you want to make packages with multiple items, simply put in another ItemID in the next ItemID column with the amount of the item in the corresponding ItemCount column.
I hope this helps!
As per the icons...
If you look within your data.saf you will find a directory labeled "interface". Within this dir there are files with the following names:
icon_somo2.tga
icon_somo2.dds
these are the item mall icons.
I recommend using the .dds file as a reference as it has icons that the other does not.
To get the icon number, simply start at the top left corner and count to the icon you need.
I would recommend editing the file to already have the icons numbered for faster reference. There is also a means of creating a new icon, but I have not gotten this to work 100% of the time, as such I will not go on further about it.
-Syn
Good, good, good tutorial. :thumbup:
I managed to put the item mall to work :D:
But... :?:
When the item goes to the character's inventory is disconnected and I get the following error message:
connection with server has Been disconected.
When I relog, the item is no longer in inventory.
How to fix it?
PSM_Client\Bin\Log\*.log
:blushing:
PS_DBAGENT__charsave
PS_DBAGENT__systemCode://PS_DBAGENT__charsave log start (DBAgent01)
PS_GAME__systemCode:2010-10-04 15:52:50 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'SERVER' is unavailable., SQL STATE: 42000, NATIVE ERROR: 8501 (0x2135)
2010-10-04 15:52:50 SaveBuyPointItem 14 .Raziya qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,14,849,'PK_shaiy0001','2010-10-04 15:52:50')}
2010-10-04 15:53:40 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'SERVER' is unavailable., SQL STATE: 42000, NATIVE ERROR: 8501 (0x2135)
2010-10-04 15:53:40 SaveBuyPointItem 78 Moonbane. qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(44,78,49,'B1_Misun0001','2010-10-04 15:53:40')}
2010-10-04 15:54:33 <Console input> /help
2010-10-04 15:54:33 <Console output> /h /help /quit /exit /shutdown/CrashDump
/mem(0) /uc(0) /dbglcon(0) /dbglcoff(0)
PS_GAMELOG__systemCode:2010-10-04 13:59:27 PS_GAME__system log start (Game254) [KR]
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/sorp1
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/croco1
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/croco2
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/Troll1
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/Spink1
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/GoldenPig
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/Sorp3
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/SorpNamed1
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/SorpNamed2
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/Sorp2
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/CrocoNamed1
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/CrocoNamed2
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/CrocoNamed3
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/OrcNamed1
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/OrcNamed2
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/OrcNamed3
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/TrollNamed1
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/HellTouthNamed1
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/Deinos
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/Parridalis
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/Alcarian
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/ZinAlcaria
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/Belizabeth
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/Kirhiross
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/CrypticOne
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/Haruhion
2010-10-04 13:59:27 Loaded Behavior In Factory : data/ai/Freezing
2010-10-04 13:59:28 connect mgr 800
2010-10-04 13:59:28 connect dbagentwar 804
2010-10-04 13:59:28 connect gamelogwar 816
2010-10-04 13:59:34 3 1 SERVICE_CONTROL_STOP
2010-10-04 13:59:34 Call save all waiting...
2010-10-04 13:59:34 1 1 SAgent::Disconnect2010-10-04 13:59:46 <Console input> /nprotect off
2010-10-04 13:59:46 <Console output> error cmd not found
2010-10-04 13:59:52 <Console input> /nprotectoff
2010-10-04 13:59:52 <Console output> cmd NProtect off ok
2010-10-04 14:00:00 <Console input> /exp2xenable 50
2010-10-04 14:00:00 <Console output> cmd exp2x enable ok(byadmin=1,bysys=0,current ExpX=50.000)
2010-10-04 14:01:52 discon client: (104, 1236) T=000:00:00:000, RC=8,RCS=0, RB=79,RBS=1, SC=89,SCS=1, SB=4820,SBS=102
2010-10-04 14:59:39 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2010-10-04 15:52:50 discon client: (104, 1236) T=000:00:00:000, RC=5,RCS=0, RB=65,RBS=1, SC=84,SCS=2, SB=4766,SBS=116
2010-10-04 15:53:40 discon client: (104, 1236) T=000:05:00:000, RC=55,RCS=0, RB=544,RBS=1, SC=462,SCS=1, SB=7962,SBS=25
,RCS=0, RB=2060,RBS=412, SC=1,SCS=0, SB=37,SBS=7
2010-10-04 13:59:34 mgr server disconnection
2010-10-04 13:59:34 db agentwar server disconnected...
2010-10-04 13:59:34 discon userlog ((3,1236, 0,105)
2010-10-04 13:59:34 discon gamelogwar[0] ((3,1236, 0,37)
2010-10-04 13:59:34 userlog Connection Lost INFO : T=000:00:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=2,SCS=0, SB=105,SBS=21
2010-10-04 13:59:34 gamelogwar Connection Lost INFO : T=000:00:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=1,SCS=0, SB=37,SBS=7
2010-10-04 13:59:34 userlog log server disconnection
2010-10-04 13:59:34 game logwar server disconnection
2010-10-04 13:59:34 server shutdown Connection INFO : T=000:00:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0
2010-10-04 13:59:34 PS_GAME__system log end (Game254)
2010-10-04 13:59:34 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_LOGIN__systemCode:2010-10-04 13:59:22 PS_GAMELOG__system log start (GameLog01)
2010-10-04 13:59:26 connect game
2010-10-04 13:59:28 connect game
2010-10-04 13:59:34 1 1 SAgent::Disconnect: (4, 64)
2010-10-04 13:59:34 1 1 T=000:00:00:000, RC=1,RCS=0, RB=37,RBS=7, SC=0,SCS=0, SB=0,SBS=0
2010-10-04 13:59:34 disconnect game
2010-10-04 14:38:46 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)
2010-10-04 14:38:46 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cicero',11,31,'ExtreMe', 58,867273706,42, 45.030338,1.891644,44.107998, '2010-10-04 14:38:46' ,122, 3058795057315381248,100082, 66,33,NULL,5,20,3300,NULL,NULL,'Operator's Exclusive',NULL,'0,0,0,0,0,0 (Option:)','2010-09-25 16:23:38'
2010-10-04 14:39:07 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)
2010-10-04 14:39:07 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cicero',11,31,'ExtreMe', 58,867273706,42, 56.191902,1.891644,43.169765, '2010-10-04 14:39:07' ,112, 3058795057315381248,100082,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Operator's Exclusive','use_item','0,0,0,0,0,0 (Option:)-2010-09-25 16:23:38','bag=5,slot=20'
2010-10-04 14:39:16 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)
2010-10-04 14:39:16 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cicero',11,31,'ExtreMe', 58,867273706,42, 56.191902,1.891644,43.169765, '2010-10-04 14:39:16' ,112, 3058795057315381248,100082,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Operator's Exclusive','use_item','0,0,0,0,0,0 (Option:)-2010-09-25 16:23:38','bag=5,slot=20'
2010-10-04 14:39:19 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)
2010-10-04 14:39:19 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cicero',11,31,'ExtreMe', 58,867273706,42, 56.191902,1.891644,43.169765, '2010-10-04 14:39:19' ,112, 3058795057315381248,100082,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Operator's Exclusive','use_item','0,0,0,0,0,0 (Option:)-2010-09-25 16:23:38','bag=5,slot=20'
2010-10-04 14:39:27 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)
2010-10-04 14:39:27 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cicero',11,31,'ExtreMe', 58,867273706,42, 56.191902,1.891644,43.169765, '2010-10-04 14:39:27' ,112, 3058795057315381248,100082,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Operator's Exclusive','use_item','0,0,0,0,0,0 (Option:)-2010-09-25 16:23:38','bag=5,slot=20'
2010-10-04 14:40:24 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)
2010-10-04 14:40:24 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cicero',11,31,'ExtreMe', 58,867273706,42, 56.318905,1.891644,44.223492, '2010-10-04 14:40:24' ,112, 3058795057315381248,100082,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Operator's Exclusive','use_item','0,0,0,0,0,0 (Option:)-2010-09-25 16:23:38','bag=5,slot=20'
2010-10-04 14:40:36 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)
2010-10-04 14:40:36 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cicero',11,31,'ExtreMe', 58,867273706,42, 44.195473,1.891644,43.613522, '2010-10-04 14:40:36' ,121, 3058795057315381248,100082, 61,5,20, NULL,33,NULL,NULL,NULL,'Operator's Exclusive',NULL,'0,0,0,0,0,0 (Option:)','2010-09-25 16:23:38'
PS_SESSION__systemCode:2010-10-04 13:59:29 PS_LOGIN__system log start (Login01)
2010-10-04 14:00:28 <Console input> /vchkoff
2010-10-04 14:00:28 <Console output> cmd version chk off ok
2010-10-04 14:59:42 cmd_auto server info log
user = 0 (0/5000)
2010-10-04 14:59:42 T=001:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=3,CReq=3,CCnt=3,DCCnt=3, CTimeT=000:02:00:000,CTimeAvg=000:00:00:000, RBT=638,RBS=0,RBSC=4,SBT=857,SBS=0,SBSC=5
2010-10-04 14:59:42 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
PS_USERLOG__systemCode:2010-10-04 13:59:20 PS_SESSION__system log start (Session)
2010-10-04 13:59:27 connect game
2010-10-04 13:59:29 connect game war
2010-10-04 13:59:30 connect login
2010-10-04 13:59:34 1 1 SAgent::Disconnect: (4, 64)
2010-10-04 13:59:34 1 1 T=000:00:00:000, RC=3,RCS=0, RB=77,RBS=15, SC=1,SCS=0, SB=5,SBS=1
2010-10-04 13:59:34 disconnect game war
2010-10-04 14:01:11 [Heroes] NewUser Enter : Char=.Raziya, Lv=60, Map=2, X=964.6, Z=1114.9
2010-10-04 14:01:53 [Heroes] NewUser Leave : Char=.Raziya, Lv=60, Map=2, X=964.6, Z=1114.9
Thx for any help.Code:2010-10-04 13:59:20 PS_USERLOG__system log start (UserLog)
2010-10-04 13:59:20 connect
2010-10-04 13:59:26 connect
2010-10-04 13:59:28 connect
2010-10-04 13:59:29 connect
2010-10-04 13:59:34 1 1 SAgent::Disconnect: (4, 64)
2010-10-04 13:59:34 1 1 T=000:00:00:000, RC=2,RCS=0, RB=105,RBS=21, SC=0,SCS=0, SB=0,SBS=0
2010-10-04 13:59:34 disconnect
PS_DBAGENT__system
You may receive a 7391 error message in SQLOLEDB when you run a distributed transaction against a linked server after you install Windows XP Service Pack 2 or Windows XP Tablet PC Edition 2005
PS_GAMELOG__system
Incorrect syntax near 's' - just rename (skills,items,etc)
example
Operator's Exclusive - > Operators Exclusive
Hi all!
Solved after few hours. :-)
My problem was with the Windows Vista operating system that does not have the MSDTC by default.
I performed these steps:
1 - Ran the CMD
2 - Type cd "c:\windows\system32"
3 - msdtc -uninstall (enter)
4 - I rebooted my pc
5 - Steps 1 and 2 again
6 - msdtc -install (enter)
7 - Steps from Microsoft - Enable Network DTC Access
8 - Control Panel > Administrative Tools > Services
9 - I started the service Distributed Transaction Coordinate
Solved two problems: DC after picking up items in BankTeller and the Item Mall.
Thx all.
Ty for posting back with both steps, as well as the other issues it resolved. I am curious as to whether or not this may cure the issue many are having with using the bankteller.
I run on windows server 2003 R2, and I am curious if it is lacking the same feature. Now I can begin looking for resolve again.
Ty much as many do not reply back with the "what and how" when an issue is resolved.
-Syn
Have you found?
The same problem exists yes. By default is disabled.
See here: How to enable network DTC access in Windows Server 2003
GL :thumbup: