Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server > Shaiya PServer Guides & Releases
You last visited: Today at 09:01

  • Please register to post and access all features, it's quick, easy and FREE!

 

[COMMUNITY RELEASE] Shaiya Server Extended

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Feb 2015
Posts: 452
Received Thanks: 818
[COMMUNITY RELEASE] Shaiya Server Extended

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:

Donators who made this project possible:

Sebastien Huard (Shaiya Legacy II player)
Amburn Amburn (Shaiya Legacy II player)
[GM]Sodawa (Shaiya Etherblade owner)
Scratch-Cat (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 betalfa's release in your PS_GameDefs database (not the OMG_GameWeb one)
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:
You must register and activate your account in order to view images.
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(messageplayer)

#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(itemusercount): 
About SQL Plugin System:
(no longer supported since the V1.1.3 release)

Few screenshoots:

the console:

welcome message plugin:

msg player plugin:

enhanced sell AP card plugin:

commands plugin:

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 Shaiya Client Extended (presented here)

Downloads:

SSE _*.rar are Shaiya Server Extended releases
SRC_*.rar are source codes
Virus total of SExtended.dll is
Attached Files
File Type: rar SSE_R1.1.rar (3.36 MB, 232 views)
File Type: rar SRC_.1.0.2c.rar (178.3 KB, 82 views)
File Type: rar SRC_1.1.rar (193.7 KB, 78 views)
File Type: rar SRC_1.1.3.rar (253.0 KB, 146 views)
File Type: rar SSE_1.1.3.rar (3.35 MB, 161 views)
File Type: rar SSE_R1.1.4.rar (3.42 MB, 492 views)



Trayne01 is offline  
Thanks
31 Users
Old   #2
 
elite*gold: 0
Join Date: Feb 2015
Posts: 452
Received Thanks: 818
The "PHP Api" made for our SExtended.dll is here.

You have to install this 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 charnamestring 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 usernamestring '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)
Attached Files
File Type: rar shapi_odbc2.rar (1.1 KB, 67 views)


Trayne01 is offline  
Old   #3
 
elite*gold: 0
Join Date: Oct 2005
Posts: 184
Received Thanks: 78
wow nice job, cant wait till I have time to play around with it hehe
Psycnosis is offline  
Old   #4
 
elite*gold: 0
Join Date: Jun 2014
Posts: 110
Received Thanks: 30
Quote:
Originally Posted by [GM]Setzhflozer View Post
[WIP] Shaiya Wings Slot (and trade faction tag)

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.


Pave99 is offline  
Thanks
1 User
Old   #5
 
elite*gold: 0
Join Date: Feb 2015
Posts: 452
Received Thanks: 818
Dephisio already replied to you here IN THE RIGHT THREAD ...
Wich kind of bot from the hell are you?
Trayne01 is offline  
Thanks
3 Users
Old   #6
 
elite*gold: 0
Join Date: Feb 2015
Posts: 452
Received Thanks: 818
Here is a plugin exemple.

uc.SEcmd


usage:
(in game)
Code:
!uc
screen:

You must register and activate your account in order to view images.

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.
Attached Files
File Type: rar uc.rar (461 Bytes, 132 views)
Trayne01 is offline  
Thanks
5 Users
Old   #7
 
elite*gold: 0
Join Date: Apr 2013
Posts: 56
Received Thanks: 3
You must register and activate your account in order to view images.
You must register and activate your account in order to view images.
please help me.
All accompanying requests fulfilled.
delux153 is offline  
Old   #8
 
elite*gold: 0
Join Date: Feb 2015
Posts: 452
Received Thanks: 818
Hello delux153,

Try to run this query:
PHP Code:
ALTER TABLE [PS_UserData].[dbo].[Users_Master]
ADD 
    
[IsNewbit NULL --Adding Is New collum on dbo.Users_Master
GO
ALTER TABLE 
[PS_UserData].[dbo].[Users_MasterADD  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.
Trayne01 is offline  
Thanks
1 User
Old   #9
 
elite*gold: 0
Join Date: Apr 2013
Posts: 56
Received Thanks: 3
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]
delux153 is offline  
Old   #10
 
elite*gold: 0
Join Date: Feb 2015
Posts: 452
Received Thanks: 818
Quote:
Originally Posted by Trayne01 View Post
Hello delux153,

Try to run this query:
PHP Code:
ALTER TABLE [PS_UserData].[dbo].[Users_Master]
ADD 
    
[IsNewbit NULL --Adding Is New collum on dbo.Users_Master
GO
ALTER TABLE 
[PS_UserData].[dbo].[Users_MasterADD  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
Trayne01 is offline  
Old   #11
 
elite*gold: 0
Join Date: Apr 2013
Posts: 56
Received Thanks: 3
You must register and activate your account in order to view images.
request is successful but a new problem arose.
delux153 is offline  
Old   #12
 
elite*gold: 0
Join Date: Feb 2015
Posts: 452
Received Thanks: 818
Hello E*PvP.
With the help of Cups, Lube and other members from our nice Dev Group. 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.
Trayne01 is offline  
Thanks
9 Users
Old   #13
 
elite*gold: 0
Join Date: Jul 2016
Posts: 21
Received Thanks: 10
How is it going?
Scratch-Cat is offline  
Thanks
2 Users
Old   #14
 
elite*gold: 0
Join Date: Feb 2015
Posts: 452
Received Thanks: 818
I plan to release the v1.1b version this week end, it will be the first version ready to use for public servers.
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.
Trayne01 is offline  
Thanks
4 Users
Old   #15
 
elite*gold: 0
Join Date: Sep 2011
Posts: 288
Received Thanks: 263
Comment tu te casse la tÍte,

sympa comme nouveau gadget

Bon boulot !!


momocruz is offline  
Thanks
2 Users
Reply



« Previous Thread | Next Thread »

Similar Threads
[COMMUNITY] Next-gen shaiya servers are here! Help us to build the future of Shaiya
Hello! I'm the dev of Shaiya Legacy II (not yet released server) & dev team. In fact we need you to improve the server, and all the shaiya...
17 Replies - Shaiya Private Server



All times are GMT +1. The time now is 09:01.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.