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
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 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
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.
After having to install everything
Everything works interface, mini map 75 76
My selection has a mob error 10053
Someone can you disappointed he informed the
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.
I was just pointing out that while the thread title states it is "Full EP6 Shaiya Server Files", it is in fact not.
I'm not sure what I what I did to deserve that response, but maybe you should look at for ideas on how to stop the destruction of the Shaiya community.
Yea the files aren't entirely ep6 but as I keep telling/arguing with everyone here, these are the closest to ep6 we currently have. Sorry for being a rude. And I'll take a look at that thread, I promise.
These are great files...but as nubness and abrasive already pointed out, not COMPLETELY EP6. I'm curious...how would I go about increasing the level cap to 80 on these files?
These are great files...but as nubness and abrasive already pointed out, not COMPLETELY EP6. I'm curious...how would I go about increasing the level cap to 80 on these files?
You need to unpack the ps_game to be able to get the real offsets
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
look down in to the lower section around 72 or so and you will see the new items there.
WTT Rebirth World War Ep6 Fighter set for Haven Warrior ep6 set 12/10/2012 - Shaiya Trading - 2 Replies Rebirth World War set :
Fighter ep6 ( White version )
Full God 9 lapis
Premium Accs LLd
No Gm reroll
No Episode 6 weapons
+any item for 50k ap.
FOR :
Haven Shaiya set ep6 ( Warrior )