[COMMUNITY RELEASE] Shaiya Server Extended

Page 1 of 6

08/07/2016 17:50 Trayne01#1

Hello E*PvP, i'm proud to present you the first stable Shaiya Server Extended Release. This is still a beta release, I suggest you to wait for the 2.0 release to write serious plugins and/or for using it in your plublic server.

Credits:

[Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] && [Only registered and activated users can see links. Click Here To Register...] && [Only registered and activated users can see links. Click Here To Register...] staff

Donators who made this project possible:

Sebastien Huard ([Only registered and activated users can see links. Click Here To Register...] player)
Amburn Amburn ([Only registered and activated users can see links. Click Here To Register...] player)
[Only registered and activated users can see links. Click Here To Register...] ([Only registered and activated users can see links. Click Here To Register...] owner)
[Only registered and activated users can see links. Click Here To Register...] (E*PVP User)

Requirements
EP 5.4 Serverfiles (or "greater" (Juuf & Shen files are also working fine with this)) for the SExtended.dll (and so the ability to notice 1 player only)
Tested with SQL Server 2016, but it should work with the 2008 version and greater (let me know your feedback).

Short release tour:
This release contain 2 different projects. The first one, called "ShaiyaServer _Extended.exe" is a new C# console made for our Shaiya Servers, that bring a lot of cool new features.
The last one called "SExtended.dll / ps_game.exe / Config" is here to add new server-side commands (that we can call via SQL)

How to setup:
v1.1 & later: Find needed file in the needed files in SSE_X.X.X.rar/Setup/*

As the current auto-install script is still a bit bugged, I will describe here how to manually install the Shaiya Server Extended.
Firstly, download the lastest build (below), then create a floder with the name you whant, and where you want, and extract all the .rar files into this floder.
Feel free to make a shortcut of the ShaiyaServer_Extended.exe in your desktop.
Then, if you want to get the /ntplayer (requiered to make a custom players commands and more) copy the content of the floder _Extended/_Data into your PSM_Client/bin floder
Setup [Only registered and activated users can see links. Click Here To Register...]
and finally run the setup.SQL script (it will drop & create some stored procedures such as the log one, so make a backup of it)

Wich are the features?

In real-time && direct server console
Few plugins exemples
Python-based plugin system
In Game custom command system
Admin Console Input
Console colour editable
Python based plugin system

Python Plugin System:

All you have to do, is to create a .py file, in the Extended/py floder.
Current supported events are:
[Only registered and activated users can see links. Click Here To Register...]
Current API allow you to use these methods in your python plugins:

PHP Code:


			
SSE_GetSQLIP()
SSE_GetSQLUser()
SSE_GetSQLPass()
SSE_GetServerName()
SSE_GetServerName()
SSE_GetInstallMode()
SSE_GetIsInstalled()
SSE_GetKeepUpdating()
SSE_GetInputcmdprefix()
SSE_GetPlayercmdprefix()
SSE_GetIsDisplayDiscon()
SSE_GetIsDisplayPlayerCmd()
SSE_GetIsDisplayerAdmCmd()
SSE_GetIsDisplayWelcomeMsg()
SSE_GetIsDisplayPvPKill()
SSE_GetIsDisplayPvPDeath()           
SSE_GetIsDisplayUnknowEvents()                    
SSE_GetPyConnString()

#Convert CharID to CharName (& vice-versa)
GetPlayer(player)

#Convert UserUID to UserID (& vice-versa)
GetUser(user)

#Send a notice to a player (you can use CharID or CharName)
AlertPlayer(message, player)

#Send a global server notice
AlertServer(message):

#Will kick all players
KickAll()

#Will stop the server    
StopServer()

#Set the max online characters that the server will support
SetMaxUser(amount)

#Kick user (you can use UserUID or UserID)
KickUser(user)

#Kick a character (you can use CharID or CharName)
KickChar(player)

#Self explicit
NProtectOn()

#Self explicit
NProtectOff()

#Will apply the given exp boost to the server
ExpBoost(amount)

#Disable it the exp boost
ExpBoostOff()

#Send an item to the user bank
SendItemToUserBank(item, user, count):

About SQL Plugin System:
(no longer supported since the V1.1.3 release)

Spoiler

Few screenshoots:

the console:

Spoiler

welcome message plugin:

Spoiler

msg player plugin:

Spoiler

enhanced sell AP card plugin:

Spoiler

commands plugin:

Spoiler

Knowed Issues:
- V1.0 & 1.1 : Console Input might cause problem while a Console.Write()
fixed in 2.0

-V1.0 & 1.1 : Having multiple .py files called SSE_*.py in the Py/ dir can cause problem
the solution is to split your code in multiple .py files, without a name that start with " SSE_".

Changelog:

V1.0.1
+ first epvp release
V1.0.1b
+ adding ChatHandler
v1.0.1c
+ security patch
v1.1.0
+ fix major crash issues, adding python support
v1.1.3
- SQL-based plugins was removed, only python is now supported.
+ Added console colour of python output using return
+ Fix: MaxTableRows is now supported in the config.xml
+ Fix: isnumeric() replaced by isinstance(var,type) in python functions
+ Easier setup steps
v1.1.4
+ Updated API functions
+ Fix: No more issue with the file called "Config" in server files.

v2.0 - GUI, Plugin manager, packets events, memory injection, adding support of [Only registered and activated users can see links. Click Here To Register...]

Downloads:

SSE _*.rar are Shaiya Server Extended releases
SRC_*.rar are source codes
Virus total of SExtended.dll is [Only registered and activated users can see links. Click Here To Register...]

08/08/2016 11:28 Trayne01#2

The "PHP Api" made for our SExtended.dll is here.

You have to install [Only registered and activated users can see links. Click Here To Register...] and the _Data floder of the lastest C# Shaiya Server Extended console release (the console itself is not needed)

Only support ODBC for now.

But the goal of this php release is to help you to call the new SExtended commands as easy as possible with PHP. So if I add command in it, then I will upload a new version of this tiny php release.

I will later try to add more useful functions to manage items and so on.

How to call it?

Replace the

PHP Code:


			
public $DbConn = odbc_connect("Driver={SQL Server Native Client 11.0};Server=127.0.0.1;Database=PS_GameDefs;", "Shaiya", "Shaiya123");

in the shapi_config.php by your wished db string.

Now, all you have to do is to call the API, so lets include the SExtended.php from the ShAPI floder.
so add the below include: (your current config file shall be included before if your connexion string is assigned in it)

PHP Code:


			
include('ShAPI/SExtended.php');

Now the api is installed, and we can start writing some lines.

Lets check if the API is connected to our database:

PHP Code:


			
$shapi->status();

If you can see a green icon, then evrything is fine.

Now, lets see the current functions:

Send In Game message to a player (player have to be logged in game)

PHP Code:


			
$shapi->player_send(int charid or string charname, string message);

Send a global In Game notice

PHP Code:


			
$shapi->notice_send(string message);

Get active charname or charid by useruid or username (a player of the account userid or username have to be logged in game)

PHP Code:


			
$shapi->get_char_byusr(int useruid or string username, string 'SHAPI::CharID' or string 'SHAPI::CharName');

Get charid by charname, or charname by charid

PHP Code:


			
$shapi->get_char(int charid or string charname)

Get useruid by username, or username by useruid

PHP Code:


			
$shapi->get_user(int useruid or string username)

PS_Game cmd send

PHP Code:


			
$shapi->cmd_send(string command)

Download: (PHP ShAPI)

08/08/2016 12:51 Psycnosis#3

wow nice job, cant wait till I have time to play around with it hehe

08/08/2016 14:01 Pave99#4

Quote:

Originally Posted by [GM]Setzhflozer

[Only registered and activated users can see links. Click Here To Register...]

someone could share how to fix visual name bug?
hp mp dp bug

Msg 207, Level 16, State 1, Procedure usp_Create_Char_R, Line 125
Invalid column name 'GS'.
Msg 207, Level 16, State 1, Procedure usp_Create_Char_R, Line 131
Invalid column name 'GS'.
Msg 207, Level 16, State 1, Procedure usp_Create_Char_R, Line 136
Invalid column name 'GS'.

Can you even read? It says "Invalid column name 'GS'".
You are apparently missing a column named GS. And because the error is from usp_Create_Char_R I'm quite sure u have to add it to the dbo.Chars.

You also could have been more specific with your "visual name bug". Maybe a screenshot or two.

08/08/2016 14:57 Trayne01#5

Dephisio already replied to you [Only registered and activated users can see links. Click Here To Register...] IN THE RIGHT THREAD ...
Wich kind of bot from the hell are you?

08/08/2016 23:03 Trayne01#6

Here is a plugin exemple.

uc.SEcmd

usage:
(in game)

Code:

!uc

screen:

[Only registered and activated users can see links. Click Here To Register...]

Now lets see how to setup it..

The file ext is SEcmd.. cmd means for in game command.

So if you want everyone to be able to use it, simply move the file in _Extended/_PlayerCMD floder... else move it in the _Extended/_AdmCMD so only GMs (status greater than 15) will be able to use it.

Server or Consle restart isn't needed. Only have to place the file and it will be ready-to-use.

This is simple, no ?

EDIT: SQL Plugins are no longger supported, use python instead.

08/09/2016 14:25 delux153#7

[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
please help me.
All accompanying requests fulfilled.

08/09/2016 15:58 Trayne01#8

Hello delux153,

Try to run this query:

PHP Code:


			
ALTER TABLE [PS_UserData].[dbo].[Users_Master]
ADD 
    [IsNew] bit NULL --Adding Is New collum on dbo.Users_Master
GO
ALTER TABLE [PS_UserData].[dbo].[Users_Master] ADD  CONSTRAINT [DF_Users_Master_IsNew]  DEFAULT ((1)) FOR [IsNew]
GO

This column is used by the Welcome Msg plugin.

This is my fault, I forgot to add this in the main .sql query, I will add it in the next Shaiya Server Extended version.

08/09/2016 17:39 delux153#9

mmmm.....

Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.Users_Master" because it does not exist or you do not have permissions.

ALTER TABLE [dbo].[Users_Master] ADD CONSTRAINT [DF_Users_Master_IsNew] DEFAULT ((1)) FOR [IsNew]

08/09/2016 18:10 Trayne01#10

Quote:

Originally Posted by Trayne01

Hello delux153,

Try to run this query:

PHP Code:

ALTER TABLE [PS_UserData].[dbo].[Users_Master] ADD [IsNew] bit NULL --Adding Is New collum on dbo.Users_Master GO ALTER TABLE [PS_UserData].[dbo].[Users_Master] ADD CONSTRAINT [DF_Users_Master_IsNew] DEFAULT ((1)) FOR [IsNew] GO

This column is used by the Welcome Msg plugin.

This is my fault, I forgot to add this in the main .sql query, I will add it in the next Shaiya Server Extended version.

^
|
|
Try again I updated it

08/09/2016 19:22 delux153#11

[Only registered and activated users can see links. Click Here To Register...]
request is successful but a new problem arose.

08/11/2016 19:51 Trayne01#12

Hello E*PvP.
With the help of Cups, Lube and other members from our nice [Only registered and activated users can see links. Click Here To Register...]. I'm (we're) gonna to release soon the v1.2 version of this tool.
The v 1.0.2c is removed. v 1.2 will have to be used instead of the old one.

Changelog:

+ Adding UI with console
+ Adding a tool to write & release your plugins
+ Fixed a lot of bugs
+ Ready-to-use for public server
+ Fixed automatic setup
+ Python Plugin System (Old SQL Plugins will be still working)
+ Packet Events
+ In-Direct memory injection support
+ Packet sending via our Plugin System

The first released version is... more then outdated, it was a stone in the ocean of the upcoming release.

You can thanks all the donators and everyone here, your support messages are making me string enough to finish this project.

08/16/2016 17:13 Scratch-Cat#13

How is it going?

08/17/2016 13:33 Trayne01#14

I plan to release the v1.1b version this week end, it will be the first version ready to use for public servers.

Spoiler

Here is a short screenshoot of the v1.1, as you can see it manages almost each in-game actions. Writing a plugin will be easier. Also, you'll now be able to use Value1 up to Value10 columns. I fixed each reported issues, and the console will no longer crash at each SQL error.

The next version, the v1.2, is still under progress, I still don't know when it be available, managing packets and memory is a pain, and i'm gonna to include a pseudo-cheatengine in it. With everything callable from Python.

08/17/2016 18:48 momocruz#15

Comment tu te casse la t�te,

sympa comme nouveau gadget

Bon boulot !!

Page 1 of 6

Last »

Plugin-Type	Floder Path	File Ext	Usable Input Vars	Usable Output Vars(SELECT .. AS)	Plugin Name File
Player Command	_Extended/_PlayerCMD	.SEcmd	@ CharName (command caster char name), @ params (all the input without the command prefix and the command name)	Output (text), ConsoleColour (int 1 - 16 included)	string: main command without the prefix ("!")
Player Command	_Extended/_AdmCMD	.SEcmd	@ CharName (command caster char name), @ params (all the input without the command prefix and the command name)	Output (text), ConsoleColour (int 1 - 16 included)	string: main command without the prefix ("!")
In Game Events	_Extended/_InGameEvents	.SEevt	@ CharName @ UserUID @ Status @ Country@ ChariD @ Arg1 @ Arg2 @ Arg3 @ Arg4 @ optn @[Only registered and activated users can see links. Click Here To Register...]X @ PosY @ PosZ @ MapID	Output (text), ConsoleColour (int 1 - 16 included)	int: EType id (Action Type)
Console Input	_Extended/_ConsoleCMD	.SEinp	@Input (all the input without the command prefix and the command name)	Output (text), ConsoleColour (int 1 - 16 included)	string: main command without the prefix ("!")