[COMMUNITY RELEASE] Shaiya Server Extended

[Trayne01]

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:

&& && staff

Donators who made this project possible:

Sebastien Huard ( player)
Amburn Amburn ( player)
( owner)
(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
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:

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

How to use a released plugin?
Use the below table to find out where to place your plugin. Console and server restart are not required.
How to make a plugin?

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 @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 ("!")

All you have to do, is to make a file with the extension that you want to use into the right floder, and copy into your file this template:

<configuration>
<PluginName>PluginName</PluginName>
<PluginVersion>1.0</PluginVersion>
<PluginDesc>Plugin Desc</PluginDesc>
<PluginAuthor>Plugin Author</PluginAuthor>
<SQL>
YOUR SQL CODE
</SQL>
</configuration>

As we are using the XML file type, please use this instead of your special characters

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
  

Downloads:

SSE _*.rar are Shaiya Server Extended releases
SRC_*.rar are source codes
Virus total of SExtended.dll is

[Trayne01]

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

You have to install 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)

[Psycnosis]

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

[Pave99]

Originally Posted by [GM]Setzhflozer

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.

[Trayne01]

Dephisio already replied to you IN THE RIGHT THREAD ...
Wich kind of bot from the hell are you?

[Trayne01]

Here is a plugin exemple.

uc.SEcmd


usage:
(in game)

!uc

screen:



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.

[delux153]

please help me.
All accompanying requests fulfilled.

[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.

[delux153]

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]

[Trayne01]

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

[delux153]

request is successful but a new problem arose.

[Trayne01]

Hello E*PvP.
With the help of Cups, Lube and other members from our nice . 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.

[Scratch-Cat]

How is it going?

[Trayne01]

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.

[momocruz]

Comment tu te casse la tête,

sympa comme nouveau gadget

Bon boulot !!