[DEVELOPMENT] 7.3 Gameserver + Current Databases + Debug Info

[BattleChan]

Originally Posted by lilnani

i want to be best than other

I hope this quote is related to your exams, else..

[fouad1979]

lol what job exactly , ?? i tell you what he got those files from the source that we got the files from and the files that he got are included with pyrok fixs ??

[Pyrok]

Originally Posted by fouad1979

lol what job exactly , ?? i tell you what he got those files from the source that we got the files from and the files that he got are included with pyrok fixs ??

Let's not jump to conclusions. Besides, skills work in my files. I'm guessing his mobs are moving in slow motion too

[demonlordace]

sry for what i said just kinda got ****** pyrok cuz ive spent most of my day trying to get this one proc to work

well im trying pyrok but apparently the way im doing it is completely worng i mean altho it seems like it is rite

USE [Telecaster]
GO
/****** Object: StoredProcedure [dbo].[smp_read_guild_member_list] Script Date: 03/13/2012 15:25:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- start of smp_read_guild_member_list
ALTER PROCEDURE [dbo].[smp_read_guild_member_list]
@Player_ID NVARCHAR(31)
AS

SELECT Account_ID FROM Character WITH (NOLOCK) WHERE Guild_id = @Player_ID
-- end of smp_read_guild_member_list?????

[lilnani]

Originally Posted by Pyrok

Let's not jump to conclusions. Besides, skills work in my files. I'm guessing his mobs are moving in slow motion too

No they move normally ^^

[Pyrok]

Originally Posted by demonlordace

sry for what i said just kinda got pissed pyrok cuz ive spent most of my day trying to get this one proc to work

well im trying pyrok but apparently the way im doing it is completely worng i mean altho it seems like it is rite

USE [Telecaster]
GO
/****** Object: StoredProcedure [dbo].[smp_read_guild_member_list] Script Date: 03/13/2012 15:25:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- start of smp_read_guild_member_list
ALTER PROCEDURE [dbo].[smp_read_guild_member_list]
@Player_ID NVARCHAR(31)
AS

SELECT Account_ID FROM Character WITH (NOLOCK) WHERE Guild_id = @Player_ID
-- end of smp_read_guild_member_list?????

It's ok. Since you're being nice, I'll be nice too.

-- start of smp_read_guild_member_list
ALTER PROCEDURE [dbo].[smp_read_guild_member_list]
AS
SET NOCOUNT ON

SELECT M.player_id, M.guild_id, M.permission, M.memo, C.name, C.lv, C.job FROM dbo.Character C WITH (NOLOCK) INNER JOIN dbo.GuildMember M WITH (NOLOCK) ON C.sid = M.player_id AND M.guild_id > 0 AND C.name NOT LIKE N'@%%' ORDER BY M.guild_id, M.permission desc, M.player_id


-- end of smp_read_guild_member_list

Sometimes it helps to walk away or work on something else when you're stuck. I spent 4 hours trying to figure out something on Vulcanus and it took me a couple of minutes to see the issue once I walked away for a while.

[demonlordace]

Originally Posted by Pyrok

It's ok. Since you're being nice, I'll be nice too.

-- start of smp_read_guild_member_list
ALTER PROCEDURE [dbo].[smp_read_guild_member_list]
AS
SET NOCOUNT ON

SELECT M.player_id, M.guild_id, M.permission, M.memo, C.name, C.lv, C.job FROM dbo.Character C WITH (NOLOCK) INNER JOIN dbo.GuildMember M WITH (NOLOCK) ON C.sid = M.player_id AND M.guild_id > 0 AND C.name NOT LIKE N'@%%' ORDER BY M.guild_id, M.permission desc, M.player_id


-- end of smp_read_guild_member_list

Sometimes it helps to walk away or work on something else when you're stuck. I spent 4 hours trying to figure out something on Vulcanus and it took me a couple of minutes to see the issue once I walked away for a while.

wow i was way off i guess **** it was hope i was closer than that gonna be a long nite i guess
ok now i tried that now im guessing i need to create a tbl called GuildMember rite and ofc it would contain the above info

[kaderebak]

If somebody get ahead please share datas !!!

[Pyrok]

Originally Posted by lilnani

No they move normally ^^

Ok, now I know which package you bought. Good thing it wasn't a recent one where everything works

edit: sorry to everyone else, I'm not a big fan of people selling stuff like this.

[TheOnlyOneRaskim]

Originally Posted by kaderebak

If somebody get ahead please share datas !!!

Why don´t you share something?

Simple, you have nothing and wait for other.


And Lilnani, Congrats on buying corrupted Files.

[kaderebak]

Originally Posted by TheOnlyOneRaskim

Why don´t you share something?

Simple, you have nothing and wait for other.


And Lilnani, Congrats on buying corrupted Files.

there is nobody wants something from you ! vain person ! Save your files for yourself don't give anybody. you should try to full security bank. maybe you need in the future. maybe one day if you have own server you can use there. and beside we open new section for you special section. please make us picture show usually ..)

[rappelz4fun]

Originally Posted by kaderebak

there is nobody wants something from you ! vain person ! Save your files for yourself don't give anybody. you should try to full security bank. maybe you need in the future. maybe one day if you have own server you can use there. and beside we open new section for you special section. please make us picture show usually ..)

if sorce of that file's told him to not to share,why you guy's can't repect that,yes my english sucks i know but atleast i am not asskissing other to get something

[demonlordace]

so got it loading up to secret dungeon info complete is last thing its loading added in whole lot of stuff to db concerning editing tbls and such and 1 know what it loads next

[ismokedrow]

Some of us are actually busting our rumps and making very nice progress, we've broken through two major road blocks with the help of pyrok on one admittedly. Thanks for the assist Pyrok -Back to SQL Traces and Hex Searching woot ^_^-

[kaderebak]

Originally Posted by rappelz4fun

if sorce of that file's told him to not to share,why you guy's can't repect that,yes my english sucks i know but atleast i am not asskissing other to get something

My age is 34. I am not asskissing . and I didn't want anything from anybody ! File shared and we are talking about this. who did share file ??? answer is "ismokedrow" and who is collocutor for my question ? this thread. !!! don't make dirty this thread and don't unsettle of people !