ALTER PROCEDURE [dbo].[ap_GetServers]
AS
SET nocount ON

SELECT * FROM server

GO

ALTER PROCEDURE [dbo].[ap_SetServerStatus] (
    @sid INT,
    @STATUS INT
)

AS

--check if servers are registered into worldstatus table
IF((SELECT COUNT(1) FROM server)!=(SELECT COUNT(1) FROM worldstatus))
BEGIN
    DECLARE @serverId INT
    DECLARE @serverName nvarchar(50)
    DECLARE srvcnt CURSOR FOR
    SELECT id, [name] FROM server

    OPEN srvcnt
    FETCH NEXT FROM srvcnt INTO @serverId, @serverName

    WHILE @@FETCH_STATUS = 0
    BEGIN
          INSERT INTO worldstatus(idx, [server], [STATUS])
          VALUES(@serverId, @serverName, 0)

          FETCH NEXT FROM srvcnt INTO @serverId, @serverName
    END
    CLOSE srvcnt
    DEALLOCATE srvcnt
END
--if servers are registered OR NO SERVER IS REGISTERED IN SERVER TABLE
IF(@sid=0)
BEGIN
    UPDATE worldstatus
    SET STATUS=0
END
ELSE
BEGIN
    UPDATE worldstatus
    SET STATUS=@STATUS
    WHERE idx=@sid
END