Need help to ADD DEV TAG & Admin Commands ! (DNC Source)

hey guys need help to add DEV TAG & Admin Commands ! i am using dnc source :)

add isdev = 1
accounts
userdata

Okey thanks :) Can you describe it a little bit better because i am really new in this :s

I mean where i exactly find it & and have to change it. would be very thankful to you :/:

Quote:

---

Originally Posted by kaijux

Okey thanks :) Can you describe it a little bit better because i am really new in this :s

I mean where i exactly find it & and have to change it. would be very thankful to you :/:

---

Navicat.

Okey thanks i asked google :D

sql script

Code:

---

-- Add Dev

USE WarZ
GO

DECLARE @CustomerID VARCHAR(100);
DECLARE @USER_cID VARCHAR(50);
DECLARE @Developer VARCHAR(10);

SET @USER_cID = 'youremail'
SET @Developer = 'Yes'; // your are admin

IF @Developer = 'Yes'
BEGIN;
SET @Developer = '1'
END;

IF @Developer = 'No'
BEGIN;
SET @Developer = '0'
END;

SET @CustomerID = (SELECT CustomerID FROM dbo.Accounts WHERE email=@USER_cID)
UPDATE dbo.Accounts SET IsDeveloper=@Developer WHERE email=@USER_cID
UPDATE dbo.UsersData SET IsDeveloper=@Developer WHERE CustomerID=@CustomerID
GO

---

Thank you very much bro ! :lol:<3

and it will work for dnc source ??? :)

I have tried now and it is working very fine thank you :)