[SHARE] Shaiya Server with Video Guide

Quote:

---

Originally Posted by teamza

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.

Thanks for helping.

---

Have u got Item.SData, and Skill.SData in the same folder as the scripts?

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

---

Quote:

---

Originally Posted by ZeroSignal

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:

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;

---

should be ordered this way:

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;

---

or replace them with:

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?

Quote:

---

Originally Posted by metalknuxx

how do you fix the disconnect error?

---

eXtreme admin? :P

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

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.

---

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:

Code:

---

Python SData.py input [-o[:]outformat]

---

Help:

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

---

Supported Files:
Item.SData
Skill.SData
Cash.SData (csv_import, csv_complete)
Monster.SData (only sql_update_lang)

Shaiya_SData_Extract_Py_0-1a.zip