Can't create a GM character. please HELP.

[WannaBeDEV]

When i make a GM character i put my character nation into GM NATION then when i log in, after selecting the character i made GM.. its stuck on loading world.. Can't continue ingame.. but when i change the nation GM NATION to capella,procyon or neutral i can go ingame successfully.. can anyone help or tell me what to do to FIX this problem?

 

[blade99]

You forgot to add gm ip.

if you are lazy to edit on sql then use this

You must be registered to see links

.

 

[sotiomake]

go to mssql management studio, use data base account, and execute stored procedure:
dbo.addgmip
and input there you ip.

 

[WannaBeDEV]

You forgot to add gm ip.

if you are lazy to edit on sql then use this

You must be registered to see links

.

Sir blade99 what ip should i put there? gm ip?

 

[blade99]

Sir blade99 what ip should i put there? gm ip?

yes ofc

 

[WannaBeDEV]

yes ofc

I mean what ip should i put? my IP or Linux IP, or windows IP?

 

[GODSKIN]

Here's a quickie. Run this on your Account-DB:

USE [Account]
GO
/****** Object:  StoredProcedure [dbo].[cabal_sp_gm_ip_check]    Script Date: 17.02.2013 23:41:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_sp_gm_ip_check](@UserIP CHAR(16), @Registered BIT OUTPUT)
AS
BEGIN
--DECLARE @IP bigint
--set @IP = dbo.inet_addr(@UserIP);

--if exists( select fromIP from cabal_GM_ip_table with(nolock) where fromip <= @ip and toip >= @ip)
--BEGIN
    SET @Registered = 1;
--END
--ELSE
--BEGIN
--    SET @Registered = 0;
--END
END

Credit : Alphakilo23 & TriEdge

 

[WannaBeDEV]

thanks sir godskin ill try to do this.,

 

[WannaBeDEV]

Here's a quickie. Run this on your Account-DB:

USE [Account]
GO
/****** Object:  StoredProcedure [dbo].[cabal_sp_gm_ip_check]    Script Date: 17.02.2013 23:41:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_sp_gm_ip_check](@UserIP CHAR(16), @Registered BIT OUTPUT)
AS
BEGIN
--DECLARE @IP bigint
--set @IP = dbo.inet_addr(@UserIP);

--if exists( select fromIP from cabal_GM_ip_table with(nolock) where fromip <= @ip and toip >= @ip)
--BEGIN
    SET @Registered = 1;
--END
--ELSE
--BEGIN
--    SET @Registered = 0;
--END
END

Credit : Alphakilo23 & TriEdge

Sir why this problem? i put correct IP and password..

 

[GODSKIN]

Sir why this problem? i put correct IP and password..

check you brian

Easy, but you make a hard

 

[WannaBeDEV]

Sir im just newbie.. Maybe can help?

 

[b0byx]

If you don't know how to do it like that, do it directly from your db.