how to make myself become a developer ? i dont have admintool.

[gunzanaa05]

see where is my admin tool? helps me please.

[MentaL]

[ATIDOT3]

it's a troll topic ?

No really because the scearch function when i tape on it return me a lot of topic where it's explain how turn account as dev.

for admintools you have to compile it.

[gunzanaa05]

please tell me how to go to compile.
and tell me how to change my value from user to dev.

[Dragonbooss]

--------------------------------------
----- Query feita por EllyssonMiike --------
----------------------------------------­---------
USE warz; ----------------------------------------­------------------------------
GO ----------------------------------------­-------------------------------------
DECLARE @CustomerID VARCHAR(100); ----------------------------------------­------
DECLARE @USER_cID VARCHAR(50); ----------------------------------------­---------
DECLARE @Developer VARCHAR(10); ----------------------------------------­--------
----------------------------------------­----------------------------------------
----------------------------------------­----------------------------------------
-- Colocar o e-mail do usuário no qual deseja tornar ou retirar o Developer. ---
SET @USER_cID = 'dev_email@hotmail.com' -- Insira o e-mail do usuário ------
SET @Developer = 'Sim'; -- Digite Sim para tornar Developer e Não para retirar -
----------------------------------------­----------------------------------------
-- NÃO MEXA AQUI NESTA PARTE ----------------------------------------­-----------
-- PODERÁ RESULTAR NO NÃO FUNCIONAMENTO DA QUERY -------------------------------
----------------------------------------­----------------------------------------
IF @Developer = 'Sim' ----------------------------------------­------------------
BEGIN; ----------------------------------------­---------------------------------
SET @Developer = '1' ----------------------------------------­-------------------
END; ----------------------------------------­-----------------------------------
IF @Developer = 'Não' ----------------------------------------­------------------
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 ---
----------------------------------------­----------------------------------------

[gunzanaa05]

--------------------------------------
----- Query feita por EllyssonMiike --------
----------------------------------------­---------
USE warz; ----------------------------------------­------------------------------
GO ----------------------------------------­-------------------------------------
DECLARE @CustomerID VARCHAR(100); ----------------------------------------­------
DECLARE @USER_cID VARCHAR(50); ----------------------------------------­---------
DECLARE @Developer VARCHAR(10); ----------------------------------------­--------
----------------------------------------­----------------------------------------
----------------------------------------­----------------------------------------
-- Colocar o e-mail do usuário no qual deseja tornar ou retirar o Developer. ---
SET @USER_cID = 'dev_email@hotmail.com' -- Insira o e-mail do usuário ------
SET @Developer = 'Sim'; -- Digite Sim para tornar Developer e Não para retirar -
----------------------------------------­----------------------------------------
-- NÃO MEXA AQUI NESTA PARTE ----------------------------------------­-----------
-- PODERÁ RESULTAR NO NÃO FUNCIONAMENTO DA QUERY -------------------------------
----------------------------------------­----------------------------------------
IF @Developer = 'Sim' ----------------------------------------­------------------
BEGIN; ----------------------------------------­---------------------------------
SET @Developer = '1' ----------------------------------------­-------------------
END; ----------------------------------------­-----------------------------------
IF @Developer = 'Não' ----------------------------------------­------------------
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 ---
----------------------------------------­----------------------------------------

how i can go to edit it ? where ?

[Dragonbooss]

Edit: SET @USER_cID = 'dev_email@hotmail.com' -- Insira o e-mail do usuário ------

Where dev_email is email of ur developer... and put this in SQL Server (New Query) and will run...

[gunzanaa05]

can u capture that place to me please :) thanks

[Dragonbooss]

--------------------------------------
----- Query feita por EllyssonMiike --------
----------------------------------------­---------
USE warz; ----------------------------------------­------------------------------
GO ----------------------------------------­-------------------------------------
DECLARE @CustomerID VARCHAR(100); ----------------------------------------­------
DECLARE @USER_cID VARCHAR(50); ----------------------------------------­---------
DECLARE @Developer VARCHAR(10); ----------------------------------------­--------
----------------------------------------­----------------------------------------
----------------------------------------­----------------------------------------
-- Colocar o e-mail do usuário no qual deseja tornar ou retirar o Developer. ---
SET @USER_cID = 'dev_email@hotmail.com' -- Insira o e-mail do usuário ------
SET @Developer = 'Sim'; -- Digite Sim para tornar Developer e Não para retirar -
----------------------------------------­----------------------------------------
-- NÃO MEXA AQUI NESTA PARTE ----------------------------------------­-----------
-- PODERÁ RESULTAR NO NÃO FUNCIONAMENTO DA QUERY -------------------------------
----------------------------------------­----------------------------------------
IF @Developer = 'Sim' ----------------------------------------­------------------
BEGIN; ----------------------------------------­---------------------------------
SET @Developer = '1' ----------------------------------------­-------------------
END; ----------------------------------------­-----------------------------------
IF @Developer = 'Não' ----------------------------------------­------------------
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 ---
----------------------------------------­----------------------------------------

[gunzanaa05]

what folder that i can edit it ? :'(

[Dragonbooss]

SQL Server Management Studio > New Query

[gunzanaa05]

Thanks :D