[SHARE] Shaiya Server with Video Guide

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

Quote:

---

Originally Posted by ZeroSignal

Twilight:
If you can apply this to a clean Database (Ep3 r51)

---

Check PM
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.

Quote:

---

Originally Posted by naruto820

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.

Got the full specification of the Item.SData file, needs a bit more testing if someone wants to do that. ^-^

Readme:

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.

---

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.

Item_SData_0_1a.zip

help "name already in use"

http://img32.imageshack.us/img32/6366/aeee.jpg

Quote:

---

Originally Posted by YGM

What other programs do you have running, give me a list of your processes.

---

Heres a List

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.

Quote:

---

Originally Posted by naruto820

but after 10-15 seconds they change back to pause sign.

---

see ... PSM_Client\Bin\Log\*.log

Quote:

---

Originally Posted by YGM

Hmm, to me that looks all fine. Was this an old instal of you OS?
TWilight
I can't get my GM_Tool To work, it says GM Server connection failed, how can I get that working?

---

Change GroupList table

.... nevermind lol

Quote:

---

Originally Posted by Twilight

Change GroupList table

---

I will let my Dev have a look into that :P

Anyway, wanted to ask How can I get on my site showing how many users are online (Server)

Quote:

---

Originally Posted by YGM

I will let my Dev have a look into that :P

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)