sacredcz517
New Member
- Joined
- Oct 2, 2011
- Messages
- 17
- Reaction score
- 0
CREATE PROCEDURE WZ_CONNECT_MEMB
@uid varchar(20),
@server varchar(20),
@uip varchar(20)
AS
Begin
BEGIN TRANSACTION
SET NOCOUNT ON
IF EXISTS ( SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED)
WHERE memb___id = @uid )
Begin
UPDATE MEMB_STAT
SET ip = @uip , connectstat = 1 , servername = @server , ConnectTM = (getdate())
WHERE memb___id = @uid
End
ELSE
Begin
INSERT INTO MEMB_STAT ( memb___id,ip,connectstat,servername) valueS (
@uid,
@uip,
1,
@server
)
End
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
SET NOCOUNT OFF
End
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO
CREATE TABLE [dbo].[MEMB_STAT] (
[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ConnectStat] [tinyint] NULL ,
[ServerName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[IP] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[ConnectTM] [smalldatetime] NULL ,
[DisConnectTM] [smalldatetime] NULL
) ON [PRIMARY]
GO
Server: Msg 2714, Level 16, State 5, Procedure WZ_CONNECT_MEMB, Line 37
There is already an object named 'WZ_CONNECT_MEMB' in the database.
Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'MEMB_STAT'. (severity 16) in C:\xampp\htdocs\1\status.php on line 61
Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\1\status.php on line 61
Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\xampp\htdocs\1\status.php on line 62
Работи.Дарко 10/10 филес е страхотен,на мен ми тръгна без грешка!Сега ще го тествам дали фрийзват.Дарко само 3rd quest не работи но нали може да се сложи в сайта
Can't run gameserver. I start the Auto MuServerStartup. It starts every process succesfully and stops at gameserver. Tried opening gameserver manually. Didnt work.
+ I can run GameserverCS. Still can't run gameserver
1. Its still not working on Windows server 2003
2. I configured this server on my laptop - windows xp. It worked but when i am lunching the game - select server doesnt appear.
In cs.exe i have:
DarksTeamMu TIME OUT Server Delete 10079
DarksTeamCS TIME OUT Server Delete 10609
I have checked ip's in connectserver folder -> i have changed all 127.0.0.1 to my ip.
+ Both gameservers are completely white but running
UPDATE Nr.1:
Tried installing all framework versions + Visual C++ Redistributable. Didnt work.
Still having the problem
Change the ip in main.UPDATE Nr.2
Gameserver has been fixed ! I turned server on manually - without MuStartup.
Select server still doesnot appear