Printable View
Ok, so yea, just like everyone, I'm using this to display the online count:
Although that isn't the problem, the problem is, that the 'isuse' column does not update when someone logs in and logs out.Code:Players Online:
<?php
$getonline = mssql_query("SELECT * FROM [ACCOUNT_DBF].[dbo].[ACCOUNT_TBL_DETAIL] WHERE isuse = 'J'");
echo mssql_num_rows($getonline);
?>
Any suggestions on how to fix this? I don't really know how:/:
wrong table
That didn't matter, it just doesn't update that row, neither in ACCOUNT_TBL...
I am not sure, because I have no knowledge of this at all, still I want to try to help, maybe you find this usefull, I stumbled on it earlier today:
http://forum.ragezone.com/f457/flyff-backend-683887/
Maybe it will help you out somehow, srry if it didn't help.
then ur table or db server are bugged. account_tbl update fine for me and it show correct online count on siteQuote:
Originally Posted by TheUndead
Yes, that is why I'm asking for a way to fix it...
---------- Post added at 08:21 PM ---------- Previous post was at 06:42 PM ----------
Thanks for the help, but that file also uses the DB, which is my problem.Quote:
Originally Posted by Hcsmurf
Make sure your query is the following:
The procedure "[dbo].[LOGINJOIN_STR]" in ACCOUNT_DBF is the following:Code:SELECT * FROM [ACCOUNT_DBF].[dbo].[ACCOUNT_TBL_DETAIL] WHERE isuse='J'
I could be wrong, but that is what updates your list, from my understanding.Code:USE [ACCOUNT_DBF]
GO
/****** Object: StoredProcedure [dbo].[LOGINJOIN_STR] Script Date: 01/18/2011 14:19:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROC [dbo].[LOGINJOIN_STR]
@iGu CHAR(2) = 'A1',
@iaccount VARCHAR(32)
/***********************************************************************************
***********************************************************************************
***********************************************************************************
***********************************************************************************
LOGINJOIN_STR ????
??? : ???
??? : 2004.01.30
??? : 2004.04.08 @iGu = 'A3' WHERE ?? ??
ex) LOGINONOFF_STR 'A1','1234'
***********************************************************************************
***********************************************************************************
***********************************************************************************
***********************************************************************************/
AS
set nocount on
IF @iGu = 'A1' -- ON
BEGIN
UPDATE ACCOUNT_TBL_DETAIL
SET isuse = 'J'
WHERE account = @iaccount
RETURN
END
ELSE
IF @iGu = 'A2' -- OFF
BEGIN
UPDATE ACCOUNT_TBL_DETAIL
SET isuse = 'O'
WHERE account = @iaccount
RETURN
END
ELSE
IF @iGu = 'A3' -- ALL OFF
BEGIN
UPDATE ACCOUNT_TBL_DETAIL
SET isuse = 'O'
WHERE isuse = 'J'
RETURN
END
set nocount off
Sadly enough that didn't fix it :|
I already had that procedure and the query.
i have the same problem. I'm not sure how to fix it, but i think i know the cause. My guess is that when people crash or close the game without properly logging out, the game doesn't have the chance to change that value in the database.
bump :)