Register for your free account! | Forgot your password?


Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server
You last visited: Today at 16:05

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

Advertisement



Make automatic notice!

Discussion on Make automatic notice! within the Shaiya Private Server forum part of the Shaiya category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Apr 2018
Posts: 19
Received Thanks: 2
done

done
[gm]noob is offline  
Old 05/03/2018, 17:00   #2

 
elite*gold: 0
Join Date: Mar 2013
Posts: 848
Received Thanks: 400
Hi,
idk why you shuld use this kind of notice on an shaiya server because of spamming. But If you want to install it okay.

1. Work with the ActionLog Procedure or (better) an GameLog.dbo.ActionLog Trigger.

You need to know the ActionType from an Player PvP Kill.
You need this =>

With a bit of sql knowledge it should be no Problem to solve this kind of notice.

If you don´t able to install feel free to contact me.

Sorry for my bad English.

Regards

.:Skrillex:.
{Skrillex} is offline  
Thanks
2 Users
Old 05/03/2018, 23:58   #3
 
elite*gold: 150
Join Date: Apr 2007
Posts: 2,320
Received Thanks: 6,529
maybe this helps you ? =)
wurstbrot123 is offline  
Thanks
1 User
Old 05/04/2018, 00:28   #4

 
elite*gold: 74
Join Date: Dec 2017
Posts: 1,303
Received Thanks: 223
That's a bad idea mate, all those spams is gonna be annoying.
AnimuNazi is offline  
Thanks
1 User
Old 05/05/2018, 01:12   #5
 
elite*gold: 0
Join Date: Jan 2013
Posts: 147
Received Thanks: 172
First apply skrillex text and make this steps,

Code:
USE [PS_GameLog]
GO

--Object: Table [dbo].[Boss_Death_Log] Script Date: 6/18/2016 12:17:17 PM 
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Boss_Death_Log](
[RowID] [int] IDENTITY(1,1) NOT NULL,
[MobID] [int] NOT NULL,
[MobName] [varchar](30) NOT NULL,
[UserUID] [int] NOT NULL,
[CharName] [nvarchar](50) NOT NULL,
[MapID] [tinyint] NOT NULL,
[PosX] [real] NOT NULL,
[PosY] [real] NOT NULL,
[PosZ] [real] NOT NULL,
[ActionTime] [datetime] NOT NULL DEFAULT (getdate()),
CONSTRAINT [PK_Boss_Death_Log] PRIMARY KEY CLUSTERED 
(
[RowID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO
if you do not using trigger put this codes below "AS"

I give your basicly tactic, for stamp map names in notice please use brain.exe
Credits goes to [DEV]Arkham and betalfa for this amazing system.
[GM]SkyLine.™ is offline  
Thanks
2 Users
Reply


Similar Threads Similar Threads
how to make other Gm write Notice
07/23/2011 - Rappelz - 7 Replies
i need to know how to make other Gms write Notice . J'ai besoin de savoir comment faire Gms d'autres écrivent Notice. ابي اعرفغ كي اخلي ناس الأخرى تكتب ملاحظات
*Notice*Warning Password stealing site*Notice*
12/28/2009 - World of Warcraft - 0 Replies
Notice is as follows, do not enter this site, if you get a notice in your email like this for gawd sakes dont give anyone your password Subject:World of Warcraft Account Trade Dispute Notice When we carry out a routine check when the account, we have evidence to show that your account has been involved in the disputed transactions. So we have to inform you visit our website(worldofwarcraft*com]fill out some information to facilitate our investigation. If you can not tie in with our soon...



All times are GMT +2. The time now is 16:05.


Powered by vBulletin®
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2021 elitepvpers All Rights Reserved.