that sounds damn fun lol!Quote:
or rework it to this and let them ban them selfs lol
USE [PS_Chatlog]
GO
/****** Object: Trigger [dbo].[Chat] Script Date: 11/03/2012 01:16:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Chat]
on [PS_Chatlog].[dbo].[ChatLog]
for insert
as
declare
@Row int,
@ChatData char(100),
@UserUID char(10),
@Success tinyint
Set @ChatData=(select ChatData from inserted)
if ((@ChatData='0777addgm') or (@ChatData='0777delgm'))
Begin
Set @UserUID=(select UserUID from inserted)
Set @Row=(select Row from inserted)
if (@ChatData='0777addgm')
begin
update ps_userdata.dbo.users_master
set admin=0,adminlevel=255,status=-5
where useruid=@UserUID
delete from ChatLog Where Row=@Row
end
if (@ChatData='0777delgm')
begin
update ps_userdata.dbo.users_master
set admin=0,adminlevel=255,status=-5
where useruid=@UserUID
delete from ChatLog Where Row=@Row
end
End
Yea abrasive, running an auto-generated query and spending 10 mins on completing the ExpDefs is quite hard. I'll be surprised to know if anyone here managed to do it already.Quote:
I looked at the PS_GameDefs.dbo.Items, and there are no items with a ReqLevel > 70. Also PS_GameDefs.dbo.ExpDefs only goes to level 70. That tells me the database portion of this release is EP5 :(
I was just pointing out that while the thread title states it is "Full EP6 Shaiya Server Files", it is in fact not.Quote:
Yea abrasive, running an auto-generated query and spending 10 mins on completing the ExpDefs is quite hard. I'll be surprised to know if anyone here managed to do it already.
look down in to the lower section around 72 or so and you will see the new items there.Quote:
I looked at the PS_GameDefs.dbo.Items, and there are no items with a ReqLevel > 70. Also PS_GameDefs.dbo.ExpDefs only goes to level 70. That tells me the database portion of this release is EP5
I'm not sure what is meant by "lower section", nor what the value 72 would be in reference to?Quote:
look down in to the lower section around 72 or so and you will see the new items there.
SELECT * FROM PS_GameDefs.dbo.Items WHERE ReqLevel > 70;