[DEVELOPMENT] 7.3 Gameserver + Current Databases + Debug Info

[ptifou78]

- CAN'T Upgrade Belt's (Extra Slots)

for that I think you must update the enhance ressource
I have the structure of it for rdb for 7.3 file i will post enhance_ressource rdb to sql in this week
or is smyp who his missed i will work on it

[thewolf50]

Welcome guys I have a problem, and these are

And please answer

[falkenman]

this problem ...........next question.. ^^

[demonlordace]

as of rite now i am no longer helping people with **** we have more important **** to worry about THIS IS NOT USABLE RITE NOW GIVE UP......IM so SICK of the HELP MEN THIS DONT WORK OR HELP MEN FIX THIS FOR ME ***

PS

STOP asking me for the files i myself dont even have a working copy of what me and smoke have been working on still waiting for a link to download them so for the last time stop asking me for them its getting annoying

[Pyrok]

Originally Posted by demonlordace

as of rite now i am no longer helping people with **** we have more important **** to worry about THIS IS NOT USABLE RITE NOW GIVE UP......IM so SICK of the HELP MEN THIS DONT WORK OR HELP MEN FIX THIS FOR ME ***

PS

STOP asking me for the files i myself dont even have a working copy of what me and smoke have been working on still waiting for a link to download them so for the last time stop asking me for them its getting annoying

You've been experiencing this for a week, imagine dealing with it for at least 6 months. Now do you understand one of many reasons why we walked away?

[demonlordace]

Originally Posted by Pyrok

You've been experiencing this for a week, imagine dealing with it for at least 6 months. Now do you understand one of many reasons why we walked away?

oh i know how it its ive delt with it with alot of different games like rf online this is nothing new to me only reason im still working on this is cuz id like a copy of working 7.3 files but if it keeps going im just gonna give up

[ismokedrow]

:P Demon I uploaded the 7.3 Gamebin into the Teamspeak doo dad last night. I was unable to come back because my room mate usurped my monitor. >< Pyrok even though you hate me, would you mind giving me an max a direction to look in when it comes to guilds.

We have gotten the fully insert procedure and update procedures for guild running as should be.

We can:

- Create
- Join
- Invite
- Set Memo's
- Set Announcements
- Set User Ranks

etc...etc, but when we restart the physical server something goes wrong:

2012-03-19 10:54:15 Guild info with no member detected: guild_id(1592339688)

(From what I can tell -- the above is loading from dbo.Guild)

2012-03-19 10:54:15 Total 0 Guild loaded.

2012-03-19 10:54:15 Guild info does not exist: guild_id(1)

(From what I can tell -- the above is loading from dbo.GuildMember)

-- Extra Information --

 Spoiler

2012-03-19 10:54:15 Guild info with no member detected: guild_id(1592339688)

 Spoiler

This one is rather perplexing to me because if I go into dbo.GuildMember and assign my test player this guild ID the Gameserver will change the number it prints (although none of these number 20+ that is has given exist or have ever existed. The only guild id in existence is '1')

2012-03-19 13:58:14 Guild info does not exist: guild_id(1)

 Spoiler

This one I don't understand at all, because for it to even retrieve the correct guild_id from dbo.Character the smp must be working to some effect.

Our current smp_read_guild_member_list

 Spoiler

USE [Telecaster]
GO
/****** Object:  StoredProcedure [dbo].[smp_read_guild_member_list]    Script Date: 03/20/2012 07:18:52 ******/
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]
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.account_id = M.player_id AND M.guild_id = C.guild_id  AND C.name NOT LIKE N'@%%' 
ORDER BY M.guild_id, M.permission desc, M.player_id


-- end of smp_read_guild_member_list

I've tried about 14 different ways of coming at this. Now I can only hope that you or another may give us (even if nothing more than a) small hint. I would be very grateful.

[ismokedrow]

Apparently you know very little about what I have been doing, as usual. This is a Development Thread not a Discussion Thread. I'll thank you to keep that in mind.

[xxadmiralxx]

statement in the pharmacy when you call the server crashes

[ismokedrow]

Originally Posted by xxadmiralxx

I must request that you do not post screenshots unless you have the full intent of sharing your process or your corrected files. Remember this is a Development Thread not a Showcase Thread.

p.s.

Do your states actually give stats?

[xxadmiralxx]

I do not know what is prohibited screenshots

[ismokedrow]

Not prohibited my friend. Just frowned against, in this thread we are trying not to lord things over people. If you would like to speak to myself or the other developers currently contributing to this project we would be more than honored. But it is just a request from me that we keep the screenshots to a minimum.

[xxadmiralxx]

well I just wanted to show some interesting screen shots of people more than themselves Fail 7.3

[thewolf50]

what is this ???

[ismokedrow]

This is not a HELP Thread it is a Development Thread. No Support will be given at this time.