stored procedure!

Hi.
I want a stored procedure that returns 'online' or '1' if player is online and 'offline' or '0' if its offline..

For example..

Query: exec _CheckStatus 'Kekox'

If player 'Kekox' is online then it returns 1, and if he is offline then it returns 0.

Ye Caipi does - so you simply need to return the Status with a simple SELECT statement ;o and it's free and completely working http://forum.ragezone.com/f722/sql-a...k-hour-845896/

Turn all WEEKDAYS into NULL values and it won't add any silk to the accounts

PHP Code:

---

CREATE PROCEDURE _CheckStatus

@Charname

as

Declare @Status varchar(15) = (SELECT [Status] FROM _OnlineOffline WHERE Charname like @Charname)

IF (@Status like 'Online')
BEGIN
return 1;
END
ELSE BEGIN
return 0;
END 


---

Wud be executable through ->

PHP Code:

---

Declare @CurState int, @Charname varchar(64) = '...Charname...';
exec @CurState = _CheckStatus @Charname
print @CurState 


---

I wouldn't refuse donations anyway lol - enjoy

^^

Plz man Help me to query dc

exec _dcsp RuN0rDiE -Plzzzz