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 20:45

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


[RELEASE]Call PSMagent Commands via sql

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Sep 2009
Posts: 33
Received Thanks: 50
[RELEASE]Call PSMagent Commands via sql

Hello guys this tutorial is from call this commands via sql code


1-Put the PSMagent inside
Code:
C:\ShaiyaServer\SERVER\PSM_Client\PSMagent.dll
2-
Code:
--You need to set up your environment to handle the CLR:
--allow you to use it run this:
ALTER DATABASE OMG_GameWEB SET TRUSTWORTHY ON;
3-
Code:
--turn clr on run this:
sp_configure 'clr enabled', 1
GO
reconfigure
GO
4-
Code:
--OMG_GameWEB->Programmability->Assemblies->New Assembly..
--AUTHORIZATION dbo
--PERMISSION_SET = EXTERNAL_ACCESS
--browse the PSMagent.dll

--OR run this:
USE [OMG_GameWEB]
GO

CREATE ASSEMBLY [PSMagent]
AUTHORIZATION dbo
FROM 'C:\ShaiyaServer\SERVER\PSM_Client\PSMagent.dll'
WITH PERMISSION_SET = EXTERNAL_ACCESS;
5-
Code:
USE [OMG_GameWEB]
GO
--lets create the procedure, run this:
CREATE PROCEDURE [dbo].[Command]
@serviceName NVARCHAR (4000), @cmmd NVARCHAR (4000)
AS EXTERNAL NAME [PSMagent].[StoredProcedures].[Command]
6- run it!
Code:
USE [OMG_GameWEB]
GO

DECLARE	@return_value int

EXEC	@return_value = [dbo].[Command]
		@serviceName = N'ps_game',
		@cmmd = N'/hello'

SELECT	'Return Value' = @return_value

GO
7-chek it| go here and open PS_GAME__system.log
Code:
C:\ShaiyaServer\SERVER\PSM_Client\Bin\Log
note: get this error?:
The database owner SID recorded in the master database differs from the database owner SID recorded in database 'OMG_GameWEB'. You should correct this situation by resetting the owner of database 'OMG_GameWEB' using the ALTER AUTHORIZATION statement.

--run this with ur pc user, see here: Databases->Security->Logins
Code:
exec sp_changedbowner [vmi24230\Administrator]
ps: the source code is inside the .zip (visual studio 2013, c#)
Attached Files
File Type: zip Database1.zip (384.2 KB, 643 views)
File Type: zip PSMagent_3.5net.zip (2.1 KB, 542 views)



betalfa is offline  
Thanks
22 Users
Old 02/07/2015, 13:27   #2
 
elite*gold: 0
Join Date: Oct 2005
Posts: 184
Received Thanks: 81
this seems very interesting but can anyone confirm this is legit?

also 0/56


Psycnosis is offline  
Old 02/24/2015, 12:42   #3
 
elite*gold: 0
Join Date: May 2010
Posts: 340
Received Thanks: 84
Hello,

Is it Safe File or if it exist a possible hack via this modification ?

Someone use it ?

Because What its interesting, to give the possibility to use custom command + to send a kick of the Toon in question... For that i see that its interesting by this way instead to created an Error to kick the player as Abrasive was propose.

Regards and thanks
_Diavolino_ is offline  
Old 02/25/2015, 12:34   #4
 
elite*gold: 0
Join Date: May 2010
Posts: 340
Received Thanks: 84
In same time its not an answer to my question ^^
Its nice release !
But
Quote:
Is it Safe File or if it exist a possible hack via this modification ?

Someone use it ?

Because What its interesting, to give the possibility to use custom command + to send a kick of the Toon in question... For that i see that its interesting by this way instead to created an Error to kick the player as Abrasive was propose.
Thank You


_Diavolino_ is offline  
Old 02/27/2015, 18:50   #5
 
elite*gold: 0
Join Date: May 2010
Posts: 340
Received Thanks: 84
#Up
Any answer ?

Thank You
_Diavolino_ is offline  
Old 02/28/2015, 20:51   #6
 
elite*gold: 0
Join Date: Sep 2009
Posts: 33
Received Thanks: 50
Quote:
Originally Posted by _Diavolino_ View Post
#Up
Any answer ?

Thank You
U can check de code... and no hackers bc u call it inside ur server. the connect i use is tcp to 127.0.0.1.
betalfa is offline  
Thanks
1 User
Old 03/01/2015, 07:45   #7
 
elite*gold: 0
Join Date: Oct 2012
Posts: 157
Received Thanks: 24
@betalfa: Thank you for your sharing. I have converted it into an exe only, not use db and dll, and it Vollarrrrr Many thanks to you, it solved my long long long time trouble Cant imagine that such this easy


Edit: I can exploit many interesting things from this. Thank you in advance.
nick4ever is offline  
Old 03/01/2015, 16:18   #8
 
elite*gold: 0
Join Date: May 2010
Posts: 340
Received Thanks: 84
In more Nick, could you details a little more the usage of these function.
Quote:
Edit: I can exploit many interesting things from this. Thank you in advance.
And if someone get too already On, to understand well the principe and to get some exemple of How to use it.

Thanks again
_Diavolino_ is offline  
Old 03/01/2015, 17:47   #9
 
elite*gold: 0
Join Date: Oct 2012
Posts: 157
Received Thanks: 24
@Diavolino: The code of beltafa is using sql and dll to interact ps_game I read his code then tried to convert everything into an exe and it worked, same theory. It must has been his long time monitoring and working on that

And the way it works just like you use PS_Management, right click to Game => Command => /kickcn charname
nick4ever is offline  
Thanks
1 User
Old 03/01/2015, 18:15   #10
 
elite*gold: 0
Join Date: May 2010
Posts: 340
Received Thanks: 84
Quote:
I read his code then tried to convert everything into an exe and it worked, same theory.
And the way to convert to an exe is to make it accessible by a clic just ? or its because you customize it to make more action ?

and as you told, in that case we just need to call the procedure to make make it effective ?
This could replace in case of Ban in game to execute the procedure to kick the toon without to passed by the /kick Name, right?
Are you using it actually ? do you have exemple of usage ?

Regards
_Diavolino_ is offline  
Old 03/28/2015, 01:50   #11
 
elite*gold: 0
Join Date: May 2010
Posts: 340
Received Thanks: 84
#UP
In more, in what to do with the database OMG_GameWEB...

SOrry i try to understand how to use it clearly...

Thank You for the feeedBack
_Diavolino_ is offline  
Old 03/30/2015, 00:45   #12
 
elite*gold: 0
Join Date: Jun 2012
Posts: 82
Received Thanks: 133
Hello! Nice work, but you could not make support for Russian language if I use the Russian language, I get it.

2015-03-29 23:25:49 <Console input> /nt ??????

2015-03-29 23:25:49 <Console output> cmd send notice ok
Призрак урана is offline  
Thanks
1 User
Old 04/05/2015, 03:58   #13
 
elite*gold: 0
Join Date: Sep 2009
Posts: 33
Received Thanks: 50
Quote:
Originally Posted by Призрак урана View Post
Hello! Nice work, but you could not make support for Russian language if I use the Russian language, I get it.

2015-03-29 23:25:49 <Console input> /nt ??????

2015-03-29 23:25:49 <Console output> cmd send notice ok
hi, when u do "PS_Management, right click to Game => Command => "put something" " what u got inside the log file?
betalfa is offline  
Old 04/05/2015, 11:02   #14
 
elite*gold: 0
Join Date: Jun 2012
Posts: 82
Received Thanks: 133
If the use of Game => Command is all right

2015-04-05 11:57:15 <Console input> /nt Привет

2015-04-05 11:57:15 <Console output> cmd send notice ok
Призрак урана is offline  
Old 05/29/2015, 17:38   #15
 
elite*gold: 0
Join Date: May 2014
Posts: 16
Received Thanks: 3
Thumbs up

Quote:
Originally Posted by betalfa View Post
U can check de code... and no hackers bc u call it inside ur server. the connect i use is tcp to 127.0.0.1.
Good release!!
But this not supported russian language.....you can change language? may be multi language script?....
thank you...


GGordon is offline  
Reply



« Custom stuff | [Release] New wings »

Similar Threads
[Release]GM Commands
01/21/2013 - Metin2 PServer Guides & Strategies - 6 Replies
Hello, a list with all gm commands with the gm level and the pointer to the function of command: command: who, command_pointer: 0x080CD080, gm_level: 5 command: warp, command_pointer: 0x080D4990, gm_level: 1 command: user, command_pointer: 0x080CCFA0, gm_level: 3 command: notice, command_pointer: 0x080CCCF0, gm_level: 3 command: notice_map, command_pointer: 0x080CC8F0, gm_level: 1 command: big_notice, command_pointer: 0x080CA600, gm_level: 3
[Release] My Commands
02/17/2010 - CO2 PServer Guides & Releases - 2 Replies
#request close
[Release] hp/mp commands
06/01/2009 - CO2 PServer Guides & Releases - 1 Replies
I found it useful to have some command that will let you pot 1kk hp in one line :) Btw. Revive only works in Talk or Team (couldnt figure out how to make it work in other chats :() place this code into chat.cs among the cases #region hp/mp related case "hp": //Refill HP { if (CSocket.Client.isPM || CSocket.Client.isGM) { if...
[RELEASE] A FEW COMMANDS
02/13/2009 - CO2 PServer Guides & Releases - 14 Replies
hi im pete, before flaming me please read all the way at the bottom =] /restart command , to make this command you have to just do /restart and add General.ServerRestart(); if (Splitter == "/restart") // restarts the server from ingame (exa. /restart ) { World.SendMsgToAll("Server Restarting!", "SYSTEM", 2011);



All times are GMT +1. The time now is 20:45.


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

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