[SHARE] Shaiya Server with Video Guide

Printable View

Show 100 post(s) from this thread on one page

11-05-09
Twilight

Re: [SHARE] Shaiya Server with Video Guide

Quote:

Originally Posted by dot

Hi guys,

[/code]PSM_Client\Bin\Config\ps_dbAgent.ini

Code:

[SERVER] ServerName=DBAgent01 ServerPort= MaxConnection= [DB] GameData=10.3.20.43, PS_GameData, sa, ECC664A5BF515B2B0F173BCE4BB6ADF85105037BC788F79D15447C6CC1E8E54DB4ACBC69A98C02151DC82C260075DA466ABAE7694F434FCF19624949CFD58E77B2F32F1978BE1F061460582DCE6F06721278CEDA3A4809ADE740FA4C1FD3DEF3DE865C24BE7F4569D2C27621BEB71E0E5B7493F30556337CE28F886A8149A724

Does someone have any ideas how to solve this?

Check GameData=10.3.20.43, PS_GameData, sa,
if local server db set 127.0.0.1 or (local) or enable remote connection
12-05-09
w_mana

Re: [SHARE] Shaiya Server with Video Guide

Quote:

Originally Posted by reflax

Anybody else notice DC's and rollbacks with 30-100 people on?

my server DC's and rollback same. :blushing:
12-05-09
anticool

Re: [SHARE] Shaiya Server with Video Guide

Edit money drop from monster ? (Gold)
12-05-09
ZeroSignal

Re: [SHARE] Shaiya Server with Video Guide

Anyone know how to parse parameters to services by default?

So parsing to:
ps_login /vchkoff
ps_game /nprotectoff

Everytime instead of manually having to enter it in each time?

I tried:

Code:

net start ps_login /vchkoff -OR- sc start ps_login /vchkoff

But did not work. Anyone know how to do this?

Quote:

Originally Posted by anticool

Edit money drop from monster ? (Gold)

Database PS_GameDefs, Table Mobs, Need to alter Money1 and Money2 fields.
Just adapt my previous update statement to multiply the Money1 and Money2 fields instead.
Don't ask for exact syntax, google SQL UPDATE statements in order to LEARN what your actually doing.

edit:
In-game GM Commands. Some show what type arguments are required after command (%d = integer, %s = string etc).
http://img12.imageshack.us/img12/566...gmcommands.jpg
12-05-09
MAZDIK

Re: [SHARE] Shaiya Server with Video Guide

TOP players

Code:

<?php $sql_server = "127.0.0.1"; $sql_user = "sa"; $sql_pass = "123456"; $sql_data = "PS_GameData"; $conn=mssql_connect($sql_server,$sql_user,$sql_pass); $xadb = mssql_select_db($sql_data,$conn) or die("$uwebmsg_cerr"); $toplvlq = "SELECT * FROM CHARS ORDER BY Level DESC"; $toplvlr = mssql_query($toplvlq); $toplvl_num = 0; echo "TOP PLAYERS"; echo "<Table width=100% border=1><TR><TD>RANK NUMBER</td><TD>PLAYER NAME</td><TD>PLAYER LEVEL</td></tr>"; while ($toplvlrow = mssql_fetch_array($toplvlr)) { $toplvl_num++; echo "<TR><TD>$toplvl_num</td><TD>".$toplvlrow[CharName]."</td><TD>".$toplvlrow[Level]."</td>"; if ($toplvl_num >= 100) break; } echo "</table>"; ?>

Whos online

Code:

<?php $sql_server = "127.0.0.1"; $sql_user = "sa"; $sql_pass = "123456"; $sql_data = "PS_GameData"; $conn=mssql_connect($sql_server,$sql_user,$sql_pass); $xadb = mssql_select_db($sql_data,$conn) or die("$uwebmsg_cerr"); $toplvlq = "SELECT * FROM CHARS WHERE (LoginStatus = 1) ORDER BY Level DESC"; $toplvlr = mssql_query($toplvlq); $toplvl_num = 0; echo "TOP PLAYERS"; echo "<Table width=100% border=1><TR><TD>RANK NUMBER</td><TD>PLAYER NAME</td><TD>PLAYER LEVEL</td></tr>"; while ($toplvlrow = mssql_fetch_array($toplvlr)) { $toplvl_num++; echo "<TR><TD>$toplvl_num</td><TD>".$toplvlrow[CharName]."</td><TD>".$toplvlrow[Level]."</td>"; if ($toplvl_num >= 100) break; } echo "</table>"; ?>
12-05-09
ZeroSignal

Re: [SHARE] Shaiya Server with Video Guide

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.
12-05-09
w_mana

Re: [SHARE] Shaiya Server with Video Guide

Twilight...

Do you know fix disconnect and rollback?

My server online 20+ users client disconnect can't save and rollback :grr:

Thx.
12-05-09
Twilight

Re: [SHARE] Shaiya Server with Video Guide

Quote:

Originally Posted by w_mana

Twilight...

Do you know fix disconnect and rollback?

My server online 20+ users client disconnect can't save and rollback :grr:

Thx.

mb..
/setmaxuser XX ?
or
MaxConnection= in ini?

I do not know this problem.. I have not enough of players...
12-05-09
Destroyer6666

Re: [SHARE] Shaiya Server with Video Guide

hi ZeroSignal

Quote:

An example of a command that requires high GM priviliges is /nmake which I think is used to create Monster spawns

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:

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

and for GM u can use the method twilight said without the use of /adminopen or u use adminopen but then all are admin xDD
12-05-09
madcows7

Re: [SHARE] Shaiya Server with Video Guide

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
13-05-09
anticool

Re: [SHARE] Shaiya Server with Video Guide

Quote:

Originally Posted by ZeroSignal

Anyone know how to parse parameters to services by default?

So parsing to:
ps_login /vchkoff
ps_game /nprotectoff

Everytime instead of manually having to enter it in each time?

I tried:

Code:

net start ps_login /vchkoff -OR- sc start ps_login /vchkoff

But did not work. Anyone know how to do this?

Database PS_GameDefs, Table Mobs, Need to alter Money1 and Money2 fields.
Just adapt my previous update statement to multiply the Money1 and Money2 fields instead.
Don't ask for exact syntax, google SQL UPDATE statements in order to LEARN what your actually doing.

edit:
In-game GM Commands. Some show what type arguments are required after command (%d = integer, %s = string etc).
http://img12.imageshack.us/img12/566...gmcommands.jpg

i edit sql
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
13-05-09
limpamesa

Re: [SHARE] Shaiya Server with Video Guide

Quote:

Originally Posted by anticool

i edit sql
Database PS_GameDefs, Table Mobs,
UPDATE Mobs SET Money1=Money1*10, Money2=Money2
OK
,but run server error

this error is because the money cant be great then 32767 so try something like this:

UPDATE Mobs SET Money1=Money1*10 where (Money1< 3276)
UPDATE Mobs SET Money2=Money2*10 where (Money2< 3276)
14-05-09
ZeroSignal

Re: [SHARE] Shaiya Server with Video Guide

See Shaiya Data Extractor.
14-05-09
Twilight

Re: [SHARE] Shaiya Server with Video Guide

Quote:

Originally Posted by ZeroSignal

See Shaiya Data Extractor.

Well. Works. We shall wait for function of packing in your tool(packer function saf,sah) for use with old updaters.
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.
14-05-09
Twilight

Re: [SHARE] Shaiya Server with Video Guide

Three maps are added in the server. It is necessary to change paths of movements

Show 100 post(s) from this thread on one page