[RELEASE]Call PSMagent Commands via sql

Psycnosis · 06/06/2015, 21:39

can anyone tell me how to use this with other commands like the chat commands? because this is not letting me use other variables like @charname even if I declare them. like I wanted to do @cmmd = '/kickcn ' +@charname

Velocity. · 12/22/2016, 05:28

nvm.

admin_lewis · 04/12/2017, 22:45

Quote:

Originally Posted by betalfa

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]

I get this Error:

Msg 325, Level 15, State 1, Procedure Command, Line 4
Incorrect syntax near 'EXTERNAL'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DATABASE.

Any solution?!

[Admin]Slice · 04/13/2017, 02:01

Quote:

Originally Posted by admin_lewis

I get this Error:

Msg 325, Level 15, State 1, Procedure Command, Line 4
Incorrect syntax near 'EXTERNAL'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DATABASE.

Any solution?!

you might want to use that little tool called brain.exe or if that doesn't work google is always there to help.

SkuulCandy · 05/18/2017, 14:11

Quote:

Originally Posted by admin_lewis

I get this Error:

Msg 325, Level 15, State 1, Procedure Command, Line 4
Incorrect syntax near 'EXTERNAL'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DATABASE.

Any solution?!

Execute this :

Code:

EXEC sp_dbcmptlevel 'OMG_GameWEB', 100

darknessio · 06/21/2017, 22:57

But this not supported russian language.....you can change language?

Trayne01 · 06/22/2017, 10:39

Quote:

Originally Posted by darknessio

But this not supported russian language.....you can change language?

It does... All you have to do is to use the nvarchar strings on your database. Plus you have the source of this tool if needed. Stop asking other people to do your job.

darknessio · 06/22/2017, 22:26

Both options are enabled but it writes anyway with ?????????????????????????

arjulie · 08/18/2018, 18:31

This script not working on sql 2008 r2 this will work on sql 2012 r2, tell me if i am wrong.

[GM]-RazoR-* · 08/18/2018, 19:19

Quote:

Originally Posted by arjulie

This script not working on sql 2008 r2 this will work on sql 2012 r2, tell me if i am wrong.

It took some time to run this script.
Use this

SQL Server 2008 R2 fix

Code:

USE [PS_GameDefs]
GO

/****** Object:  SqlAssembly [PSMagent]    Script Date: 08/16/2018 10:34:57 ******/
CREATE ASSEMBLY [PSMagent]
AUTHORIZATION [dbo]
FROM 'C:\ShaiyaServer\SERVER\PSM_Client\PSMagent.dll'
WITH PERMISSION_SET = SAFE

GO

arjulie · 08/18/2018, 20:08

Quote:
Originally Posted by [GM]-RazoR-*
It took some time to run this script.
Use this

SQL Server 2008 R2 fix
Code:
USE [PS_GameDefs]
GO

/****** Object:  SqlAssembly [PSMagent]    Script Date: 08/16/2018 10:34:57 ******/
CREATE ASSEMBLY [PSMagent]
AUTHORIZATION [dbo]
FROM 'C:\ShaiyaServer\SERVER\PSM_Client\PSMagent.dll'
WITH PERMISSION_SET = SAFE

GO

SQL 2008 r2 is not allow to create SQL ASSEMBLY?

i try this code

USE [PS_GameDefs]
GO

/****** Object: SqlAssembly [PSMagent] Script Date: 08/16/2018 10:34:57 ******/
CREATE ASSEMBLY [PSMagent]
AUTHORIZATION [dbo]
FROM 'C:\ShaiyaServer\PSM_Client\PSMagent.dll' ( instead C:\ShaiyaServer\SERVER\PSM_Client\PSMagent.dll )
WITH PERMISSION_SET = SAFE

GO

this command not working ( C:\ShaiyaServer\PSM_Client\PSMagent.dll )

Msg 6257, Level 16, State 1, Line 3
CREATE ASSEMBLY for assembly 'PSMagent' failed because the assembly is built for an unsupported version of the Common Language Runtime.

i check all include SQL 2008 r2 version on this PSMagent

10.50.2500.0 - this version working on this PSMagent.dll

10.50.4000.0 - this version Not working on this PSMagent.dll

10.50.6000.34 - this version Not yet try on this PSMagent.dll

[GM]-RazoR-* · 08/19/2018, 19:43

Quote:

Originally Posted by arjulie

SQL 2008 r2 is not allow to create SQL ASSEMBLY?

i try this code

USE [PS_GameDefs]
GO

/****** Object: SqlAssembly [PSMagent] Script Date: 08/16/2018 10:34:57 ******/
CREATE ASSEMBLY [PSMagent]
AUTHORIZATION [dbo]
FROM 'C:\ShaiyaServer\PSM_Client\PSMagent.dll' ( instead C:\ShaiyaServer\SERVER\PSM_Client\PSMagent.dll )
WITH PERMISSION_SET = SAFE

GO

this command not working ( C:\ShaiyaServer\PSM_Client\PSMagent.dll )

Msg 6257, Level 16, State 1, Line 3
CREATE ASSEMBLY for assembly 'PSMagent' failed because the assembly is built for an unsupported version of the Common Language Runtime.

i check all include SQL 2008 r2 version on this PSMagent

10.50.2500.0 - this version working on this PSMagent.dll

10.50.4000.0 - this version Not working on this PSMagent.dll

10.50.6000.34 - this version Not yet try on this PSMagent.dll

PSMagent.dll Download;

VirüsTotal;

Check

C:\ShaiyaServer\PSM_Client\PSMagent.dll

If you still can't do this, add me to Skype.

Skype; razor.efsane

erickreq · 08/05/2019, 20:51

Quote:

Originally Posted by admin_lewis

I get this Error:

Msg 325, Level 15, State 1, Procedure Command, Line 4
Incorrect syntax near 'EXTERNAL'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DATABASE.

Any solution?!

How to change the database compatibility level?
To view or change the compatibility level of a database
Right-click the database, and then click Properties.
In the Select a page pane, click Options. The current compatibility level is displayed in the Compatibility level list box.
To change the compatibility level,
select a different option from the list

Iniciado por arjulie Ver publicacion
Este script no funciona en sql 2008 r2, esto funcionará en sql 2012 r2, dime si estoy equivocado.

This problem can arise when a database restored from a backup and the SID of the database owner does not match the owners SID listed in the master database. Here is a solution that uses the "ALTER AUTHORIZATION" statement recommended in the error message:

127

DECLARE @

VARCHAR(MAX) = 'ALTER AUTHORIZATION ON DATABASE::[<<DatabaseName>>] TO
[<<LoginName>>]'

SELECT @

= REPLACE(REPLACE @

, '<<DatabaseName>>', SD.Name)
, '<<LoginName>>', SL.Name)
FROM master..sysdatabases SD
JOIN master..syslogins SL ON SD.SID = SL.SID
WHERE SD.Name = DB_NAME()

PRINT @

EXEC @

)

nonofeitosa · 06/06/2020, 19:42

I'm having this error when trying to create the assembly:

Msg 6257, level 16, state 1, line 2
CREATE ASSEMBLY for assembly 'PSMagent' failed because the assembly was created for an unsupported version of the Common Language Runtime.

defproject · 05/09/2021, 05:48

After executing this command on SQL Server 2017

Code:

USE [OMG_GameWEB]
GO

DECLARE [MENTION=3807069]ReTuRn_[/MENTION]value int

EXEC [MENTION=3807069]ReTuRn_[/MENTION]value = [dbo].[Command]
	 [MENTION=1485710]service[/MENTION]Name = N'ps_game',
	 [MENTION=693895]cmm[/MENTION]d = N'/hello'

SELECT	'Return Value' = [MENTION=3807069]ReTuRn_[/MENTION]value

GO

then Error is this

Code:

Msg 10314, Level 16, State 11, Line 6
An error occurred in the Microsoft .NET Framework while trying to load assembly id 65537. The server may be running out of resources, or the assembly may not be trusted. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error: 
System.IO.FileLoadException: Could not load file or assembly 'psmagent, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Exception from HRESULT: 0x80FC80F1
System.IO.FileLoadException: 
   at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
   at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
   at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection)
   at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
   at System.Reflection.Assembly.Load(String assemblyString)