Staffonline php

[erickreq]

Staffonline









thank costs nothing
please do not criticize because I am human and I'm not perfect.

[Credits]
elitepvpers
Community shaiya

[thetruestarr1337]

Good to see, that the Shaiya Community is involving
Keep it up

[st.jimmy998]

Wow, nice jobb!

[erickreq]

if you know thank looked perhaps continue to share my stuff because they share everything meresen elitepvpers and thanks to others who share without them we are nothing xD

[admineternity]

Thanks much! I will use too

[accuface35]

thx, but when i logged in and look at the script, the status is empty not on, and i have made the one by the chars.



what should I do so on the status is displayed?

[accuface35]

anyone can help?

[erickreq]

for reasons not much English I find it hard to help sorry

[st.jimmy998]

Che, me podes sacar una duda?

Teniendo IIS como servicio web me funcionaba perfecto, ahora estoy usando XAMPP, hago todo,pero entro en la pagina, y da en blanco.. Alguna idea?

[erickreq]

por que esta en ssql y tienes que ir a php.ini y habilitar la linea de ssql pero no se si la nuevas versiones mas recientes de xampp trabajen ssql

[DemiGod ツ™]

Hello to everyone, i`ve been tested this script and it seems like i have some error the point of it should be this one:

• LoginStatus Error ( i`m wonder how can i fix LoginStatus on my server cuz already Players Online still dosent work for me and it should be the same problem for this script also.

 Spoiler

If anyone has any answer and fix for this please leave an reply here thank you.

[AxelMac]

Originally Posted by DemiGod ツ™

Hello to everyone, i`ve been tested this script and it seems like i have some error the point of it should be this one:

• LoginStatus Error ( i`m wonder how can i fix LoginStatus on my server cuz already Players Online still dosent work for me and it should be the same problem for this script also.

 Spoiler

If anyone has any answer and fix for this please leave an reply here thank you.

Use this query

 Spoiler

BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.Chars ADD
LoginStatus tinyint NOT NULL CONSTRAINT DF_Chars_LoginStatus DEFAULT 0
GO
COMMIT

 Spoiler

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO


ALTER Proc [dbo].[usp_Read_Chars_Detail2_R]

@CharID int

AS

SET NOCOUNT ON

DECLARE @UserUID int
DECLARE @Money bigint
DECLARE @GuildID int
DECLARE @GuildLevel tinyint
DECLARE @UID varchar (18)

-- 2005-12-30 스탯,스킬 이벤트관련...
DECLARE @Event1 tinyint
DECLARE @Event2 tinyint
--

SET @Money = 0
SET @UserUID = (SELECT UserUID FROM Chars WHERE CharID = @CharID)
SET @GuildID = (SELECT GuildID FROM GuildChars WHERE CharID = @CharID AND Del = 0)

IF(@UserUID IS NOT NULL)
BEGIN
SET @Money = (SELECT ISNULL([Money], 0) FROM UserStoredMoney WHERE UserUID = @UserUID)
END
ELSE
BEGIN
SET @Money = 0
END

IF(@GuildID IS NOT NULL)
BEGIN
SET @GuildLevel = (SELECT GuildLevel FROM GuildChars WHERE CharID = @CharID AND Del = 0)
END
ELSE
BEGIN
SET @GuildID = 0
SET @GuildLevel = 0
END

-- 2005-12-30 스탯,스킬 이벤트관련...
SELECT @Event1=Event1, @Event2=Event2 FROM CharEvents WHERE CharID=@CharID
--

SELECT UserUID, CharID, CharName, Slot, Family, Grow, Hair, Face, [Size], Job, Sex, [Level],
StatPoint AS DistPoint, SkillPoint, [Str], Dex, Rec, [Int], Luc, Wis, HP, MP, SP, Map, Dir, [Exp], [Money],
PosX, PosY, PosZ, Hg, Vg, Cg, Og, Ig, Del, K1, K2, K3, K4, @Money AS StoredMoney, @GuildID AS GuildID, @GuildLevel AS GuildLevel,

-- 전투공로관 보상레벨
KillLevel, DeadLevel,
--

-- 스탯,스킬 이벤트관련...
@Event1, @Event2,
--

DATEPART(yyyy, LeaveDate) AS LeaveDate_YYYY,
DATEPART(mm, LeaveDate) AS LeaveDate_MM,
DATEPART(dd, LeaveDate) AS LeaveDate_DD,
DATEPART(hh, LeaveDate) AS LeaveDate_HH,
DATEPART(mi, LeaveDate) AS LeaveDate_MI,
DATEPART(ss, LeaveDate) AS LeaveDate_SS

--

FROM Chars WHERE CharID = @CharID

-- 접속시간 기록
UPDATE Chars SET JoinDate=GETDATE(), LoginStatus = 1 WHERE CharID=@CharID
SELECT @UID=UserID FROM CHARS WHERE CharID=@CharID
UPDATE Chars SET LoginStatus = 0 WHERE (CharID<>@CharID) AND (UserID=@UID)
--

SET NOCOUNT OFF
SET QUOTED_IDENTIFIER OFF
SET ANSI_NULLS OFF

 Spoiler

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO


ALTER Proc [dbo].[usp_Save_Char_LeaveDate_R]

@CharID int

AS

SET NOCOUNT ON

-- 종료시간 기록
UPDATE Chars SET LeaveDate=GETDATE(), LoginStatus=0 WHERE CharID=@CharID

SET NOCOUNT OFF

SET QUOTED_IDENTIFIER OFF

SET ANSI_NULLS OFF

[accuface35]

for me it is not displayed online, so that the png file, although I'm Online

[DemiGod ツ™]

Alright all fixed already:

• Players Online fixed and work perfectly
• LoginStatus Fixed (i had to update my table`s)
• And Staff Online Script has been fixed and work

Thank you for the help everyone and for this great script release you are awesome

[accuface35]

can you pls upload your files here?