Printable View
As far as I can tell PS_UserData -> Users_Master Status column is based on permission bits, however I have yet to find the number that gives complete GM rights. An example of a command that requires high GM priviliges is /nmake which I think is used to create Monster spawns.
edit:
And about the SAF extractor, I have created one in the past in Lua but it was very dodgy. I plan to re-write it in Python when I get a decent amount of time free.
Twilight...
Do you know fix disconnect and rollback?
My server online 20+ users client disconnect can't save and rollback :grr:
Thx.
mb..Quote:
Originally Posted by w_mana
/setmaxuser XX ?
or
MaxConnection= in ini?
I do not know this problem.. I have not enough of players...
hi ZeroSignal
nope as i said in a post earlier its for creating NPCs..thats why it called /nmake..if u want to spawn mob just use /mmake...Quote:
An example of a command that requires high GM priviliges is /nmake which I think is used to create Monster spawns
and for GM u can use the method twilight said without the use of /adminopen or u use adminopen but then all are admin xDDQuote:
EDIT :
I found out how to make NPCs now, but i cant find them in the databases.....so where are they???
/nmake <Type> <ID>
e.g. /nmake 9 1 will make a cow
Types so far i found out:
1 Merchants
2 GateKeeper
3 Blacksmith
4 WarriorManager
5 GamblingHouse
6 Warehouse Keeper
7 other NPCs
8 Guards
9 Animals
10 App. Task Master
11 GuildMaster
12 Battle Instructor
if anyone is having issues running this feel free to pm me and ill help. my pm box is almost full so if it get to many pms you may have to wait
i edit sqlQuote:
Originally Posted by ZeroSignal
Database PS_GameDefs, Table Mobs,
UPDATE Mobs SET Money1=Money1*10, Money2=Money2
OK
,but run server error
File log >>
2009-05-13 05:24:05 PS_GAME__system log start (Game01)
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/sorp1
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/croco1
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/croco2
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/Troll1
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/Spink1
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/GoldenPig
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/Sorp3
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/SorpNamed1
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/SorpNamed2
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/Sorp2
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/CrocoNamed1
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/CrocoNamed2
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/CrocoNamed3
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/OrcNamed1
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/OrcNamed2
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/OrcNamed3
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/TrollNamed1
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/HellTouthNamed1
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/Deinos
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/Parridalis
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/Alcarian
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/ZinAlcaria
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/Belizabeth
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/Kirhiross
2009-05-13 05:24:05 Loaded Behavior In Factory : data/ai/CrypticOne
2009-05-13 05:24:07 CGameData::LoadConstMob: err=-1, query=EXEC usp_Read_Mobs_R
2009-05-13 05:24:07 DB table load error
2009-05-13 05:24:07 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2009-05-13 05:24:07 Call save all waiting...
2009-05-13 05:24:07 Call save all failed dbagent disconnected(user count = 0)...
2009-05-13 05:24:07 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
2009-05-13 05:24:07 Save MobID=3020556
2009-05-13 05:24:07 PS_GAME__system log end (Game01)
2009-05-13 05:24:07 3 1 SService::ServiceCtrlDispatcher(): service shutdown
this error is because the money cant be great then 32767 so try something like this:Quote:
Originally Posted by anticool
UPDATE Mobs SET Money1=Money1*10 where (Money1< 3276)
UPDATE Mobs SET Money2=Money2*10 where (Money2< 3276)
Well. Works. We shall wait for function of packing in your tool(packer function saf,sah) for use with old updaters.Quote:
Originally Posted by ZeroSignal
For new Updater in the further it is necessary to provide function of updating in archive without full unpacking and if Updater will be on Pithon to provide that registration of its libraries in OS or to make them in one exe
We wait for an output of new versions.. Once again thanks.
Three maps are added in the server. It is necessary to change paths of movements
Hi Twilight.Quote:
Originally Posted by Twilight
US or RunUP client?
RunUP.Quote:
Originally Posted by w_mana
For add maps need edit correct map.ini
:):
help meQuote:
Originally Posted by Twilight
How to edit correct map.ini tree maps
To learn how to add information.
Backdoor inside... => Reported => filedelete
Twilight can you please explan for me what these two rows mean ? and how do you know what the number to enter in.Quote:
Originally Posted by Twilight
RebirthMapPos1 = 20, 66, 26, 33
RebirthMapPos2 = 33, 563, 3, 27
thanks in advanced.
Note: i editing my map.ini correctly but when i use /cmove 45 or 46 47 to move to new maps. the error : "map data load error" occur. anyway to solve this ? I use RunUP Client
I'm planning to open a closed-beta server, I am now working on the Game Shop. I was wondering if anyone has an English version or translation of items table?
Thanks in advance.
1. in PS_Game_logs maps loaded?Quote:
Originally Posted by LightRitual
example
2009-05-14 22:22:48 map 45, zone 47 mob count = 285
2009-05-14 22:22:48 map 46, zone 48 mob count = 268
2009-05-14 22:22:48 map 47, zone 49 mob count = 458
2. use /cmove with coordinates ex:
/cmove 45,166.1815,9.359992,175.4331
Good work.....
Thanks ZeroSignal and Twilight for everything - release and all help with files.
Someone can release configured data.saf and PS_GameDefs with working item store? I dont understand how can i configure it....I need test it.
The English language any client of the game understands. The Item Store gains titles of items from the table.Quote:
Originally Posted by kag0ryu
data.saf - big size also is permanently inflected (Cash. SData) with upgrading. I already told as to inflect. The packer later will appear and we can easier inflect and construct new stands in Cash. SDataQuote:
Originally Posted by Perseusz
help new skill bug
how to add this?
http://img269.imageshack.us/img269/2442/777q.jpg
Thats true..... so maybe you can release only Cash.SData and PS_GameDefs?Quote:
data.saf - big size also is permanently inflected (Cash. SData) with upgrading. I already told as to inflect. The packer later will appear and we can easier inflect and construct new stands in Cash. SData
Thanks.
ok i think i will quit this shit here....
i deleted all and setup whole new mssql and shaiya pserverfiles
i did it 3 times on 2 different PCs but every time i can not create a char, its always telling me "name already in use"
i cant figure out where is the prob....checked many times the SQL stuff and all Logfiles but i dont get it.
i dont know why it all worked the first time i set up a server and yet not anymore
so bye bye all :(:
Try it:Quote:
i did it 3 times on 2 different PCs but every time i can not create a char, its always telling me "name already in use"
SQL Database - PS_GameData - CHAR - Design table and clear AllowNulls in Character table. And done :P
nope---that didnt work :P still same probQuote:
Originally Posted by Perseusz
and YES i did like all here is written and again YES i use these damned 2 DBs from here but it wont work :grr:
hiQuote:
Originally Posted by Destroyer6666
GO TO
SQL Database - PS_GameData - CHAR - design table and change Maketime in varchar
xd you have the same problem I've had but I am a good programmer
CHANGE MY SCRYPT
go to USP_SAVE_CHAR_ITEM_ADD_E
/****** Object: Stored Procedure dbo.usp_Save_Char_Item_Add_E Script Date: 2008-6-7 18:31:57 ******/
/****** Object: Stored Procedure dbo.usp_Save_Char_Item_Add_E Script Date: 2008/3/15 下午 05:25:52 ******/
/****** 偃羹: 盪濰 煎衛盪 dbo.usp_Save_Char_Item_Add_E 蝶觼董 陳瞼: 2006-04-11 螃 10:57:16 ******/
CREATE Proc usp_Save_Char_Item_Add_E
@CharID int,
@ItemUID bigint,
@Bag tinyint,
@Slot tinyint,
@ItemID int,
@Type tinyint,
@TypeID tinyint,
@Quality int,
@Gem1 tinyint,
@Gem2 tinyint,
@Gem3 tinyint,
@Gem4 tinyint,
@Gem5 tinyint,
@Gem6 tinyint,
@Craftname varchar(20) = '',
@Count tinyint,
@Maketime varchar(20)='01/01/1999',
@Maketype char(1)
AS
--SET NOCOUNT ON
IF(@Quality >= 5000)
BEGIN
SET @Quality=0
END
INSERT INTO CharItems
(CharID, bag, slot, ItemID, Type, TypeID, ItemUID, quality, gem1, gem2, gem3, gem4,
gem5, gem6, craftname, [count], maketime, maketype)
VALUES(@CharID, @Bag, @Slot, @ItemID, @Type, @TypeID, @ItemUID, @Quality, @Gem1, @Gem2, @Gem3, @Gem4,
@Gem5, @Gem6, @Craftname, @Count, @Maketime, @Maketype)
IF(@@ERROR = 0)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END
--SET NOCOUNT OFF
GO
and
go to usp_Read_Char_Items_Detail_R
CHANGE MY SCRYPT
/****** Object: Stored Procedure dbo.usp_Read_Char_Items_Detail_R Script Date: 2008-6-7 18:31:57 ******/
/****** Object: Stored Procedure dbo.usp_Read_Char_Items_Detail_R Script Date: 2008/3/15 下午 05:25:51 ******/
CREATE Proc usp_Read_Char_Items_Detail_R
@CharID int
AS
/******SET NOCOUNT ON******/
SELECT ItemID, Type, TypeID, ItemUID, Bag, Slot, Quality,
Gem1, Gem2, Gem3, Gem4, Gem5, Gem6, Craftname, [Count], Maketype ,
'2009' AS MakeTime_YYYY,
'01' AS MakeTime_MM,
'01' AS MakeTime_DD,
'00' AS MakeTime_HH,
'00' AS MakeTime_MI,
'00' AS MakeTime_SS
FROM CharItems
WHERE CharID = @CharID AND Del = 0
/******SET NOCOUNT OFF******/
GO
and restarts all the service and good luck:thumbup1:
I've spend 4 days but I've successfully with these changes it is sufficient to look for or just the error ^ ^
And you can create characters now
can any one add here registration web site? :/
Does this work with 64 bit windows, because my server will start and be like > then after 10 secs it will stop.
and when I try to update the cmd with vhckoff i cant go to the cmd screen, it keeps saying "disable update.Please restart psmAgenr"(Im using teh english version of psm server agent) its same with the chinese version.
I managed to do the Monster Name translation on the Database, by extracting the name from the Monster.SData file.
Note that this will also need to be adapted for the Cash.SData, Skill.SData, and Item.SData binary files.
This was coded in Python:
Main.py
Code:import struct
import re
# Open SData File.
input = open("Monster.SData", mode='rb')
# Open SQL File for writing.
output = open("Monster.SData.txt.sql", mode='w')
# Unpack binary into 4-byte integer.
file_header = struct.unpack('i', input.read(4))
# The total amount of records.
record_total = file_header[0]
print 'Monster records: ' + str(record_total)
monster = []
for i in range(record_total):
monster.append({})
# Length of monster name string.
data = struct.unpack('i', input.read(4))
name_len = data[0]
# Read Monster name string, stripping NULL Terminator.
monster[i]['name'] = input.read(name_len)[:-1]
# Other Data we don't need.
input.read(31)
# Sanitize string by adding escape char quotes.
sanitize_name = monster[i]['name'].replace('\'', '\'\'')
# Generate update SQL String.
sql = "UPDATE Mobs SET MobName = '" + sanitize_name + "' WHERE MobID = " + str(i) +";\n"
# Write the SQL to a file.
output.write(sql)
Good Work.Quote:
Originally Posted by ZeroSignal
Hey HASKOMAN
YEY -- that worked :thumbup: thanx man!
after 2 nights i was at same spot as u that it had to do with markettime^^
but im sure u mean
SQL Database - PS_GameData - CHARItem - design table and change Maketime in varchar
after all it works now fine :thumbup1:
have fun!
The Goals Are as Follows:
- To be able to get all the SData binary files (including English names) reflected in the Server Database. I think it's best to create Comma Separated Extracts as they produce best results and can easily be imported.
- To add re-combine functionality to the DATA.SAF Extractor. This is actually a fairly big task and not trivial at all.
- To make programs to convert the SData files to CSV Files that can be edited, and be re-combined back into the SAF format. Pretty Easy as partly demonstrated below.
- Make the DATA.SAF Extractor be able to create Update Patch Files. Fairly Difficult as it will need to compare DIFF changes.
I'm currently as Goal 1:
I have created a program to create a Cash.SData CSV (Comma Separated) Input File, which then can be used to Import into the Database.Quote:
Originally Posted by Twilight
A few issues, appending records to the existing ProductList (from RowID == 92) causes the Game Server to not start. Not sure why.
Removing the existing records, and importing the new data launches the Game Server.
However actually purchasing the Items causes a disconnect. Could this be because of the name differences in the Items Table?
Anyway here is the script for you to have a play with:
Code: Python
File: Cash.py
Code:import struct
import re
startRowID = 0
# Open SData File.
input = open("Cash.SData", mode='rb')
# Open File for output.
output = open("ProductList.csv", mode='w')
# Unpack binary into 4-byte integer.
file_header = struct.unpack('i', input.read(4))
# The total amount of records.
record_total = file_header[0]
print 'Total records: ' + str(record_total)
# Create CSV Header
csv = "RowID,ProductName,ProductCode,BuyCost"
for j in range(1,25):
csv = csv + ",ItemID"+str(j)+",ItemCount"+str(j)
output.write(csv)
record = []
for i in range(record_total):
record.append({})
data = struct.unpack('iiii', input.read(0x10))
record[i]['RowID'] = data[0]
record[i]['na1'] = data[1]
record[i]['na2'] = data[2]
record[i]['cost'] = data[3]
for j in range(1,25):
data = struct.unpack('iB', input.read(0x5))
record[i][('ItemID'+str(j))] = data[0]
record[i][('ItemCount'+str(j))] = data[1]
# Length of name string.
data = struct.unpack('i', input.read(4))
name_len = data[0]
# Read name string, stripping NULL Terminator.
record[i]['name'] = input.read(name_len)[:-2]
print("name: " + record[i]['name'])
data = struct.unpack('i', input.read(4))
type_len = data[0]
record[i]['code'] = input.read(type_len)[:-2]
data = struct.unpack('i', input.read(4))
desc_len = data[0]
input.read(desc_len)[:-2]
# Sanitize string by adding escape char quotes.
sz_name = record[i]['name'].replace('\'', '\'\'')
sz_code = record[i]['code'].replace('\'', '\'\'')
# Create CSV Records.
csv = "\n" + str((startRowID + record[i]['RowID'])) + ",\"" + sz_name + "\",\"" + sz_code + "\"," + str(record[i]['cost'])
for j in range(1,25):
csv = csv + "," + str(record[i][('ItemID'+str(j))]) + "," + str(record[i][('ItemCount'+str(j))])
#csv = csv + ",\n"
output.write(csv)
You need to remove the existing ones (1-92). This will result in conflict in some of the product names. I'm only missing the extraction hammer ID and the29/249 package, if you have them I will post the completed table of ProductList.
Thanks.
Did you try purchasing the items in-game? When I removed all the existing ones, and imported the new data in, purchasing them in-game disconnected me. Perhaps I am using broken stored procedures or something?Quote:
Originally Posted by kag0ryu
And just run the source I provided and it will give you those records. If there on the client, they will be in the Item.SData file. ;)
OTHER STUFF:
I have been able to reverse engineer _MOST_ of the Item.SData File. There are 19 (0x13) Bytes, that still need figuring out. Anyone up for the challenge? Here is my source as it stands:
Source Code Provided & in Python.
Item.py
I was able to purchase the items in-game including the packaged ones. Please note that the names are case sensitive.
Ok that most likely is the issue, I don't have the english names in the Items table yet. ^^Quote:
Originally Posted by kag0ryu
*Edit no that was not the reason, most likely a screwed SP*
so does this work with x64 windows? becasue mine keeps crashing.
Help Sommons use.
Unavailable clan
Cannot equip Red Lion Sommons Stone
http://img361.imageshack.us/img361/6374/sommmm.jpg
There are many kinds of summon stones in-game, party, guild, warehouse just to name a few. Check what is it for. And also check your current mode, some items requires specific mode.
Sometimes the jumbo box from item shop fail. I don't know if it's normal or a bug.
Have anyone have same problem?
In picture you can see Jumbo Box give a link hammer lvl 2 as a drop but Mini Mystery just fail. Both box fail sometimes...
http://img301.imageshack.us/img301/4254/shaiya.th.jpg
Btw, I dit not added any item in product, just rewrite the old ones :)
Yes, working fine in windows vista 64.Quote:
Originally Posted by naruto820
Twilight:
Ok I've here are all the english translations for Ep3, release 51, from the SData Binary Files.
There are SQL Update files which you apply via SQL Query Analyzer.
Also a CSV file which you need to import data.
Produces strange results when used with Ep4, as many records have been left out. Also most of the scripts do not work well Ep4 because the full records need to be extracted, not just the names, and Unique Identifiers.
If you can apply this to a clean Database (Ep3 r51), and re-release the Data Backups in one file I would be very grateful. ^-^
shaiya_SData_ep3_r51.zip
Check PMQuote:
Originally Posted by ZeroSignal
Ep4, it is a lot of errors. To finish it is necessary not only the client but also a server.
At this stage I suggest to mix resources Ep4 with Ep3, but packer SAF/SAH is necessary.
:wink:
any1 have an idea on how to fix the crashing problem? becasue I have setup on 2 computers followed guide fully but server keeps crashing.
Is it because Im using different directory and not D? but I have changed al configs to my directory.
What other programs do you have running, give me a list of your processes.Quote:
Originally Posted by naruto820
Got the full specification of the Item.SData file, needs a bit more testing if someone wants to do that. ^-^
Readme:
Note - It will still need to have functionality to extract the complete Item.SData into a file that easily can be edited (most likely CSV). And a re-combine function to make it back into an SData binary file.Code:Item.py
Needs to have the Item.SData in the same folder.
USAGE 1:
>python Item.py csv_complete
TODO
USAGE 2:
>python Item.py csv_import
Creates an Items.import.csv file which can be used to import into
PS_GameDefs.dbo.Items.
File Format: Delimited
File type: ANSI
Row delimiter: {CR}{LF}
First row has column names: enabled
Text Qualifier: Double Quote {"}
Column Delimiter: Comma
USAGE 3:
>python Item.py sql_update_lang
Creates Items.update.sql file which has Update Queries that can be used to
update the names into the language of the Item.SData file.
Item_SData_0_1a.zip
help "name already in use"
http://img32.imageshack.us/img32/6366/aeee.jpg
Heres a ListQuote:
Originally Posted by YGM
http://74.201.58.82/process.jpg
http://74.201.58.82/processs.jpg
Hmm, to me that looks all fine. Was this an old instal of you OS?
Also you made sure you upgraded your SQL to SP4 ??
TWilight
I can't get my GM_Tool To work, it says GM Server connection failed, how can I get that working?
WIndows is new running windows server 2003, installed 5 days ago with latest updates.
Server is running from C:\ShaiyaServer and I changed PSMClient-Config and changed the directory from D:\ShaiyaServer to C:\, and yes mssql does have sp4 installed. Tried on 2 different computers with Windows Server 2003 x64 and both when I install all service the icon changes to the pause sign then when i start all they change to > but after 10-15 seconds they change back to pause sign.
naruto820, your restore function is not adding the SQL Databases to MSSQL.
I can't remember exactly how to query them into your database, but that's how to fix, also make sure you go through EVERY .txt .bat .ini and anything "editable" and make sure the directory's, server name, IP are correct.
all of those seems to be right.
also i did Databases 2 different ways in each computer. FIrst one i copied the databases and pasted on data folder like the video tut, second one got other version of db from epvp and restored from those to a new directory. however the tables in the db seems fine.
see ... PSM_Client\Bin\Log\*.logQuote:
Originally Posted by naruto820
Change GroupList tableQuote:
Originally Posted by YGM
.... nevermind lol
I will let my Dev have a look into that :PQuote:
Originally Posted by Twilight
Anyway, wanted to ask How can I get on my site showing how many users are online (Server)
Be not lazy. In the last messages changes in two store procs are given and to the table, are given as all php scripts (Reg,Status Servers,Top,Online Users...etc)Quote:
Originally Posted by YGM
Anybody knows how or what are the parameters to start off the events?
You lost me there...Quote:
Originally Posted by Twilight
Got the full specification of the Skill.SData file.
There is however major issues:
1. The first 4-byte integer does not match the amount of records (which means it most likely represents something else).
2. There are duplicates, garbage, and blank records. I'm not sure how to go about resolving these.
Comment - The file is just messy in general, I have no idea how the Client loads the file properly. Which is very bad news for us because we need a clean extract that we can import into the database.
Please run the program and look at the CSV file, perhaps some can make sense of why it has duplicate values, and which ones we should be using, and which should be discarded.
Skill_SData_0_1a.zipCode:USAGE 1:
Skill.SData Must be contained in the same folder.
TODO -
* First Integer is usually a record count, however the number does not specify enough of them.
* There are blank records, duplicates, and garbage records, which need to be resolved.
>python Skill.py csv_import
Creates an Skills.import.csv file which can be used to import into
PS_GameDefs.dbo.Skills.
File Format: Delimited
File type: ANSI
Row delimiter: {CR}{LF}
First row has column names: enabled
Text Qualifier: Double Quote {"}
Column Delimiter: Comma
Regarding Disconnects from purchasing from Item Store, I fixed it by running this in SQL Query Analyzer:
I will add this to my batch script. You need to have Remote Procedure Call enabled for your linked Server.Code:exec sp_serveroption @server='game', @optname='rpc', @optvalue='true'
exec sp_serveroption @server='game', @optname='rpc out', @optvalue='true'
Now I got the "Inventory Full" error for purchasing Extraction Hammers, and AP Mytery Boxes, but I'm sure it's pretty trivial to fix.
edit:
It's because Items do not exist in DB, I have full working Item.SData Extractor. Rather than giving you individual files, I will wait until I have done the Monster.SData Extractor too, then release them all together. Not sure what can be done about the Skill.SData as the files seems a bit broken or beyond my understanding at this time (SonoV developer must have been smoking crack).
very good ^^
[QUOTE=Twilight;5031501]see ... PSM_Client\Bin\Log\*.log
Hmm tehre are a lot of logs there
but nothing like *.log
theres login/session sytem and other logs.
[QUOTE=naruto820;5032484]He means all the logs in that folder lol. * is considered a wildcard, so any file with a ".log" file extension.Quote:
Originally Posted by Twilight
I have run my server
it
[QUOTE=siemens_mr;5033012]I have run my server
it
Needed a clean executable I did, thanks.Quote:
Originally Posted by Twilight
I haw this problem :/
http://img36.imageshack.us/img36/8190/przechwy.jpg
wen i want start server he run and a 5 sekend stop ;...
wat wrong ??
someone do for pople video guild in english how to set up server . PLz and thx
Has anyone been able to find out how to do messages to all (across both darkie and lightie)
Also the Notices (white text in middle of screen)
And any other forms of text for GM/GS???
ZeroSignal Hi I have a problem when using python Error as below.
Error sue it every time you use this command python Skill.py csv_import or python Item.py csv_import.Quote:
C:\Python31>python Skill.py csv_import
Traceback (most recent call last):
File "Skill.py", line 157, in <module>
rec['SkillName'] = "\"" + rec['SkillName'] + "\""
TypeError: Can't convert 'bytes' object to str implicitly
C:\Python31>python Item.py csv_import
Traceback (most recent call last):
File "Item.py", line 175, in <module>
rec['ItemName'] = "\"" + rec['ItemName'] + "\""
TypeError: Can't convert 'bytes' object to str implicitly
Thanks for helping.
I work all but wen i wont start all server service she start and in 5 sekend stop ;(
wat i do wrong maybe some ip is bad ;/
List of Commands, can people help me update with a definition next to them all.
I can't find the ones for purple text, the ones GS's use alot on US Servers
/http://paste-it.info/13652
Please visit and upgrade the list!
I haw this error now
http://img39.imageshack.us/img39/4869/hhhhx.jpg
Im us http://shaiya.aeriagames.com/ klient
some log in PSM_Client\Bin\Log
2009-05-23 09:19:35 PS_SESSION__system log start (Session)
2009-05-23 09:19:35 connect login
2009-05-23 09:19:48 connect game
2009-05-23 09:24:04 1 1 SAgent::Disconnect: (4, 64)
2009-05-23 09:24:04 1 1 T=000:04:00:000, RC=7,RCS=0, RB=133,RBS=0, SC=2,SCS=0, SB=***SBS=0
2009-05-23 09:24:04 disconnect game
2009-05-23 09:24:04 3 1 SERVICE_CONTROL_STOP
2009-05-23 09:24:06 1 1 SAgent::Disconnect: (4, 64)
2009-05-23 09:24:06 1 1 T=000:04:00:000, RC=***RCS=0, RB=493,RBS=1, SC=10,SCS=0, SB=165,SBS=0
2009-05-23 09:24:06 disconnect login
2009-05-23 09:24:06 1 1 SAgent::Disconnect: (3, 1236)
2009-05-23 09:24:06 1 1 T=000:04:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=1,SCS=0, SB=37,SBS=0
2009-05-23 09:24:06 log system server disconnection
2009-05-23 09:24:06 PS_SESSION__system log end (Session)
2009-05-23 09:24:06 3 1 SService::ServiceCtrlDispatcher(): service shutdown
Have u got Item.SData, and Skill.SData in the same folder as the scripts?Quote:
Originally Posted by teamza
I haven't tested them thoroughly.
I'm using Python v2.6
YGM:
I have pasted the file here, so everyone can modify it, without having to re-post it, and adding to clutter. If everyone chips in when they find out the command information, we will have it documented much quickly which is a benefit for all.
Shaiya - Game Commands
Thanks ZeroSignal, I have updated the list some more.
Thanks ZeroSignal do now, no problem.
I've been playing around with Stored Procedures, and decided to create one of my own. I wanted to share this with you my friends so here it is. ^_^
Code:-- ============================================================================
-- Author: ZeroSignal
-- Create date: 24/05/09
-- Description: Adjusts Mobs Money Drop Ranges.
-- Truncated Values are set to max value.
-- Params:
-- @multiplier The gold multiplier. Less than 1 will decrease value,
-- More than 1 will increase.
-- ============================================================================
CREATE PROCEDURE usp_AdjustMobsMoney
@multiplier float
AS
BEGIN TRAN
SET NOCOUNT ON
IF (@multiplier > 1.0)
BEGIN
DECLARE
@overflow smallint
SET @overflow = 32767 / @multiplier;
UPDATE Mobs SET Money1 = 32767 WHERE Money1 > @overflow;
UPDATE Mobs SET Money2 = 32767 WHERE Money2 > @overflow;
UPDATE Mobs SET Money1 = Money1 * @multiplier WHERE Money1 <= @overflow;
UPDATE Mobs SET Money2 = Money2 * @multiplier WHERE Money2 <= @overflow;
END
ELSE
BEGIN
UPDATE Mobs SET Money1 = ROUND(Money1 * @multiplier,0);
UPDATE Mobs SET Money2 = ROUND(Money2 * @multiplier,0);
END
SET NOCOUNT OFF
COMMIT TRAN
GO
Your SP is OK, but this four lines:Quote:
Originally Posted by ZeroSignal
should be ordered this way:Code:UPDATE Mobs SET Money1 = 32767 WHERE Money1 > @overflow;
UPDATE Mobs SET Money2 = 32767 WHERE Money2 > @overflow;
UPDATE Mobs SET Money1 = Money1 * @multiplier WHERE Money1 <= @overflow;
UPDATE Mobs SET Money2 = Money2 * @multiplier WHERE Money2 <= @overflow;
or replace them with:Code:UPDATE Mobs SET Money1 = Money1 * @multiplier WHERE Money1 <= @overflow;
UPDATE Mobs SET Money2 = Money2 * @multiplier WHERE Money2 <= @overflow;
UPDATE Mobs SET Money1 = 32767 WHERE Money1 > @overflow;
UPDATE Mobs SET Money2 = 32767 WHERE Money2 > @overflow;
Code:UPDATE Mobs
SET Money1 = (
CASE
WHEN (Money1 * @multiplier) > 32767 THEN 32767
ELSE (Money1 * @multiplier)
END
),
Money2 = (
CASE
WHEN (Money2 * @multiplier) > 32767 THEN 32767
ELSE (Money2 * @multiplier)
END
)
Ok i fix me error XD
Server work god :D
how do you fix the disconnect error?
eXtreme admin? :PQuote:
Originally Posted by metalknuxx
D/C City!
.....what? .-.
AngryBvr how does the ordering make a difference? I haven't tested it thoroughly, but if there is a bug in my ordering I would be happy to change my code. You last example looks much neater and more efficient than my previous method, Ill update my query very soon. ^_^
Hi. me too 1-2 min and d/c server. error code : 10054, 87, 126 :( and create cahrakter -100005678 kill. no good:) Thanks for help.
Have received results on correction of skills in Ep4? At me it has turned out to add in the table of skill, but the list is formed on a condition [Number] and its position influences correct display in game. Each skill enters the name in three lines on a level....
I hope to the help... I do not understand while logic....
Quote:
Originally Posted by lajt
I can help you with both, but can only explain one.
D/C Issue read back a few pages.
The negative kills for each character, you can fix by doing:
1) Load Enterprise Manager/SQL Manager
2) Expand folder until you see/find: PS_GameData
3) Click on Tables
4) Now you should see a table called "CHARS"
5) Right click "CHARS" and click on "Design Table"
6) Scroll down to K1/K2/K3/K4
7) Click in each box for K1 to K4 and in the default value put 0
Close, create character and done, no Kill/Death bug
Thank you. Would you be able to help?
2009-05-24 13:55:16 discon client: (****64) T=000:00:00:000, RC=1,RCS=0, RB=24,RBS=2, SC=8,SCS=0, SB=93,SBS=8
dc the game:(
I have completed an Alpha version of the Shaiya SData Extractor. I make no promises to it's accuracy, there is over 500 lines of code and has not been tested thoroughly.
SData files should now be placed in the SData folder.
Output files will be placed in the Output folder.
Since this is a source code release, you will have to run the script in Python (tested on v2.6).
Syntax to compile and run is as follows:
Help:Code:Python SData.py input [-o[:]outformat]
Supported Files:Code:Extracts SData Files into various output formats.
SData input [-o[:]outformat]
input The name of the SData file in the SData folder.
-o The output format of the file.
outformat csv_import (def) Creates CSV File suitable for DB Importing.
csv_complete Creates complete CSV File for Editing.
sql_update_lang Creates language update sql file for DB.
EXAMPLES:
>SData Cash
>SData Item -o csv_complete
>SData Skill -o sql_update_lang
Item.SData
Skill.SData
Cash.SData (csv_import, csv_complete)
Monster.SData (only sql_update_lang)
Shaiya_SData_Extract_Py_0-1a.zip
Help me i mark server work no monstar
2009-05-24 20:25:16 PS_GAMELOG__system log start (GameLog01)
2009-05-24 20:25:21 connect game
2009-05-24 20:28:22 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'usp_Insert_Action_Log_E'., SQL STATE: 42000, NATIVE ERROR: 2812 (0xAFC)
Somebody does not know it what's the problem? :( thank you.
Make sure that the procedure exists within the actual database and make sure that you are using the right owner declaration for this.Code:Could not find stored procedure 'usp_Insert_Action_Log_E'
edit:
It looks like for Ep4 The SData Binary Records have changed in specification, so my SData Extractor is currently only compatible with Ep3.
The ordering makes a difference because the WHERE statement in this two lines:Quote:
Originally Posted by ZeroSignal
are not stopping any of the moneys fields of getting bigger than 32767,Code:
UPDATE Mobs SET Money1 = Money1 * @multiplier WHERE Money1 <= @overflow;
UPDATE Mobs SET Money2 = Money2 * @multiplier WHERE Money2 <= @overflow;
ex: Money1 = 15000, the value is smaller than @overflow, but if you put a @multiplier value like 3, (Money1*@multiplier) = 45000 and this value would make your server crash.
so if you put this two lines:
below the others two, they correct the wrong values settings them to 32767Code:UPDATE Mobs SET Money1 = 32767 WHERE Money1 > @overflow;
UPDATE Mobs SET Money2 = 32767 WHERE Money2 > @overflow;
I hope you understand me my English is not very good.
The overflow would never be 15,000. If the multiplier was 3, then the overflow would be 32767 / 3 = 10,922 (.333 should be dropped when casted). So if the value is greater than the overflow it's going to be larger than the maximum allowable value 32767, so it gets changed to 32767. Even if a value is exactly 10,922, then 10,922 * 3 = 32766 a legal change that would not cause the field to be truncated.
Because of the drop when casting, the conditions never allows the values to be truncated even on border value cases.
For example:
Code:@multiplier = 2
@overflow = 32767 / @multiplier # @overflow = 16383
UPDATE Mobs SET Money1 = 32767 WHERE Money1 > @overflow;; # we have value 16383 and 16384, 16384 gets changed to 32767, 16383 doesn't.
UPDATE Mobs SET Money1 = Money1 * @multiplier WHERE Money1 <= @overflow; # 16383 <= 16383 evaluates to True, so (16383 * 2 = 32766) Valid.
Many people forget this wen start Server
PSMServer_Mgr:
Close version checking:
Select Logins >> Login01, right click, then Command. Enter "/vchkoff" press Enter.
this part is important !!
If you dont enter this comand ! server disconect you in 5 secend
!!
Close NProtect verification:
Select GameGroups >> GameGroups01 >> Game, right click, then Command. Enter "/nprotectoff" press Enter.
http://main.intrex.hu/cintia/er.jpg I struggle yet :(
Quote:
Originally Posted by ZeroSignal
You are right, was my mistake, I've never saw the division part in the @overflow assignment.
i have same problem.Quote:
Originally Posted by Mantios
who can fix it? :(:
lajt it is a bad habit to rely on others for answers when a google search could have provided you an answer much more quickly.
google: "SQL Must Declare the variable"
First hit gives you your answer:
Must declare the variable '%.*ls'.
Thanks Zere. But I do not understand the sqlhez,I would have liked trying the server only.
Anyone have any idea why Guilds do not save into the database?
The Server Software is still in an alpha stage, as many stored procedures still require a bit of fixing. So don't expect it to work out of the box yet and have full functionality. Learning at least the basics of MS SQL is essential if you want to host a Shaiya Private Server.Quote:
Originally Posted by lajt
MS SQL is one of the most commonly used RDBMS's in the world so it pays off to know how to use it fluently if your interested in Information Technology.
Start here: SQL Tutorial
Then: Microsoft SQL Server Tutorials
Hi. i managed to solve it, thank you. I do not understand it the reg script onto what okay? OMG_GameWeb is not attached database. One more thing, gm exists 100% linking ? ty
Can you help me?Quote:
Originally Posted by Mantios
Do you fix disconnect error?