Remove the IP check for GMs

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

Code:

---

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

---

Voila, no more IP checks for GMs.

I wouldn't run this on a live server. Simply because of corrupt GM's who give their guildies the account to farm dungeons.

Well I restrain my GMs. They're reset to level 1 with no stats at all every hour. So if they want to play, they'll have to use a normal character.

this is bad idea... its nothing personal mate ;)

Quote:

---

Originally Posted by Alphakilo23

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

Code:

---

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

---

Voila, no more IP checks for GMs.

---

Where did u get this? I think from TriEdge....if so then give him the credits....
Original: http://forum.ragezone.com/f451/ep8-g...4/#post7463300

Quote:

---

Originally Posted by Alphakilo23

Well I restrain my GMs. They're reset to level 1 with no stats at all every hour. So if they want to play, they'll have to use a normal character.

---

May I know how to do this?

Quote:

---

Originally Posted by Alphakilo23

Well I restrain my GMs. They're reset to level 1 with no stats at all every hour. So if they want to play, they'll have to use a normal character.

---

I Think It's A Trigger In SQL...

Coz' He Mentioned Everyhour?!...:):

Quote:

---

Originally Posted by JemCanoy

Where did u get this? I think from TriEdge....[...]

---

Nope, I found it on my own while digging in the database, then posted it here.

Quote:

---

Originally Posted by jaguar666

May I know how to do this?

---

Sure thing. You need to create a trigger or an SQL job, I make my DB backups hourly, that's why it's executed hourly.
It's pretty easy, if you're using the Express version you could realise it by using a batch script, using sqlcmd.exe to execute T-SQL scripts. Do you wish me to do an tutorial on that?

Quote:

---

Originally Posted by 4pLay

I Think It's A Trigger In SQL...

---

It's possible to accomplish that via triggers, SELECT triggers possibly, but I don't like triggers for various reasons.

Quote:

---

Originally Posted by Alphakilo23

Well I restrain my GMs. They're reset to level 1 with no stats at all every hour. So if they want to play, they'll have to use a normal character.

---

Ahh I see. That makes sense. Why did I not think of this before D:

Quote:

---

Originally Posted by Alphakilo23

Nope, I found it on my own while digging in the database, then posted it here.


Sure thing. You need to create a trigger or an SQL job, I make my DB backups hourly, that's why it's executed hourly.
It's pretty easy, if you're using the Express version you could realise it by using a batch script, using sqlcmd.exe to execute T-SQL scripts. Do you wish me to do an tutorial on that?


It's possible to accomplish that via triggers, SELECT triggers possibly, but I don't like triggers for various reasons.

---

For The Red Sentence...

LoL!... Who Does Not Want That?!... EVERYBODY! :):

if you cant trust your GMs then why the hell do you even recruit them?

Quote:

---

Originally Posted by TriEdge

if you cant trust your GMs then why the hell do you even recruit them?

---

http://i.imagebanana.com/img/l7au14n...cb039d93bl.jpg

Well then you got obviously no friends at all... no trust = no friend for me.

and there are more ways to abuse the GM position.. guess you would need to take all the commands from them wich leads that they are normal players then.

Give them Power and you will see if you made a right decision with choosing them as a GM :)

Quote:

---

Originally Posted by TriEdge

Well then you got obviously no friends at all... no trust = no friend for me.

and there are more ways to abuse the GM position.. guess you would need to take all the commands from them wich leads that they are normal players then.

Give them Power and you will see if you made a right decision with choosing them as a GM :)

---

I can't wait to see how many abuse their power on serenity. It happened at least 3 times on Elite and 3-4 times on IPU. It's just what happens when you give players excessive power with little reward.

Quote:

---

Originally Posted by Alphakilo23
Here's a quickie. Run this on your Account-DB:


Code:
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
ENDVoila, no more IP checks for GMs.

---

lol after do it query all skill cant used and id my creator gm invisible how to give default back before my creator gm can used everthing

Type /_invisible twice once in game

its fully working ,,.


my problem is now FIX !!


yehey .. :thumbup1: