any one help me for this problem !

Need help here plss
im doing ep7 server now
im using URO client
im using 2 pc usser/server
when i start the sesion/login/field/agentserver/ its all success
but when i enter the game "character data failed to be process"

i see some information in ep7 you need to add "Sp Log" on your DB
but i dont realy know how to do that.:(:

its that the wrong?:/:

because when character data failed to be process I see this eror on my "Agent Server"

Quote:

---

=======================================================
Server Start OK
=======================================================
(Client ID:100) (5.134.141.184:1620)
DB:Exec sp_UserAttendLog 1
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'sp_UserAttendLog'.
ERROR:Read Attend list failed
ERROR:100 Invalid Gaea ID
ERROR:CNetUser::CloseClient client already closed 0

---

need help plss ! !

try to user ran ip interceptor

what will i ido to Ran interceptor ?

Quote:

---

Originally Posted by royaljourney

try to user ran ip interceptor

---

you wrong buddy :) . try to execute this on RanGame1

USE [RanGame1]
GO
/****** Object: StoredProcedure [dbo].[sp_UserAttendLog ] Script Date: 07/17/2011 07:41:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[sp_UserAttendLog ]
@nUserNum int

AS
DECLARE
@error_var int,
@rowcount_var int

SET NOCOUNT ON
Select (MSum-MS) As M, (FSum-FS) As F
From
(
Select isnull(Sum(M),0) As MSum, isnull(Sum(F),0) As FSum, isnull(Sum(MS),0) As MS, isnull(Sum(FS),0) As FS
From
(
Select ChaClass
,
Case ChaClass
When 1 Then 1
When 2 Then 1
When 256 Then 1
When 512 Then 1
Else 0
End As M
,
Case ChaClass
When 4 Then 1
When 8 Then 1
When 64 Then 1
When 128 Then 1
Else 0
End As F
,
Case ChaClass
When 16 Then
Case ChaDeleted
When 4 Then 0
Else 1
End
Else 0
End As MS
,
Case ChaClass
When 32 Then
Case ChaDeleted
When 4 Then 0
Else 1
End
Else 0
End As FS
From ChaInfo
) As t
) As tt
GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

Hey guys, I had this same problem, and the real problem is i dont know where to execute this script.. any help..?

I run the script and get this

Msg 208, Level 16, State 6, Procedure sp_UserAttendLog , Line 11
Invalid object name 'dbo.sp_UserAttendLog '.

any ideas

maybe add me at fb see at may signature .

Quote:

---

Originally Posted by FreedomRecords

maybe add me at fb see at may signature .

---

Sir, I was trying to send you a private message regarding this reply but unfortunately I could not send it though. My post count is below 15. So instead of sending it as a private message, I'll just ask you here.

After executing the query, it came up with this error:
Msg 208, Level 16, State 6, Procedure sp_UserAttendLog , Line 11
Invalid object name 'dbo.sp_UserAttendLog '.

as your reply says "maybe add me at fb see at may signature." I'm wondering how can you help me. and oh I already looked this up google Google but as can you see it only shows two results.

Thank you in advance and I hope I'm not bothering you.

Maybe this is similar to your problem - http://forum.ragezone.com/f248/inval...ndance-797632/

Quote:

---

Originally Posted by Vision

Maybe this is similar to your problem - http://forum.ragezone.com/f248/inval...ndance-797632/

---

It went good. I executed it successfully, but how about this problem?

1 Worker Thread
1 st Worker Thread Create OK
[Gaea Server] Start
PK MODE : 1
DB:SELECT GuNum, ChaNum, GuDeputy, ChaName, GuName, GuRank, GuMoney, GuIncomeMoney, GuMarkVer, GuBattleWin, GuBattleDraw, GuBattleLose, GuBattleLastTime, GuAllianceBattleWin, GuAllianceBattleDraw, GuAllianceBattleLose, GuMakeTime, GuExpireTime, GuAuthorityTime, GuAllianceSec, GuAllianceDis, GuNotice FROM viewGuildInfo
DB:42S22, NativeError:207, [Microsoft][SQL Native Client][SQL Server]Invalid column name 'GuAuthorityTime'.
[Gaea Server] Start Succeeded
[Gaea Server] ---------------
Server Update Thread Create OK
WSASocket OK
Bind OK
5.156.169.232:5502
Server Accept Thread Create OK
(Client ID:99) (5.156.169.232:5003)
============================
Session Server Connection OK
============================
SessionSndSvrInfo 5.156.169.232 CH:1
(Client ID:0) (5.156.169.232:5113)
INFO:Field Server CH(0) FIELD(0) ID(0) Connection OK
NET_MSG_BASE 1019
=======================================================
Server Start OK