[Release]Full EP6 Shaiya Server Files

11/03/2012 02:22 daniel968#91
Quote:
Originally Posted by World-of-Shaiya View Post
hmm lv 80 yea if you do it in SQL you have lv 80 but not when you do it in game
hmm i did not using SQL with level, I using /set <name> <level> 80 it work for me.. coz I did edit in PS_game.exe changed cap level...
11/03/2012 19:06 TeddyBear94#92
Quote:
Originally Posted by _-Phoenix-_ View Post
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
that sounds damn fun lol!
11/03/2012 21:55 episode6#93
New Mirror of the Server files:
[Only registered and activated users can see links. Click Here To Register...]
11/11/2012 01:29 abrasive#94
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 :(
11/11/2012 09:38 nubness#95
Quote:
Originally Posted by abrasive View Post
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.
11/11/2012 15:27 Apero#96
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
11/11/2012 21:54 abrasive#97
Quote:
Originally Posted by nubness View Post
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 [Only registered and activated users can see links. Click Here To Register...] for ideas on how to stop the destruction of the Shaiya community.
11/11/2012 22:13 nubness#98
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.
11/12/2012 04:53 diehard6#99
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?
11/12/2012 05:44 JohnHeatz#100
Quote:
Originally Posted by diehard6 View Post
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
11/13/2012 15:42 Cosmin6294#101
Hello everyone, Help me pls: how to edit game.exe with my ip? What number should I look for. Help me pls
11/13/2012 15:45 TeddyBear94#102
[Only registered and activated users can see links. Click Here To Register...]
check that <.< .. when u want to change it to ur IP use the search engine of hex editor and change the ip with hex.
11/14/2012 02:10 _-Phoenix-_#103
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
look down in to the lower section around 72 or so and you will see the new items there.
11/14/2012 17:24 abrasive#104
Quote:
Originally Posted by _-Phoenix-_ View Post
look down in to the lower section around 72 or so and you will see the new items there.
I'm not sure what is meant by "lower section", nor what the value 72 would be in reference to?

All I did was attach the database and run this query:
Code:
SELECT * FROM PS_GameDefs.dbo.Items WHERE ReqLevel > 70;
11/14/2012 18:56 olyshop#105
what Client you use for this ? US Shaiya Client?