[RELEASE-REPOSTED] WebAdmin PHP add GC/Dollar/Item Quantity

[LukasCCB]

You must reply before you can see the hidden data contained here.

​

 

[GMkidink]

how about this error with the SQL?

already I made the dbo.Donation_Log

 

[darkwiings]

Wow! Thank you!

 

[LukasCCB]

how about this error with the SQL?

already I made the dbo.Donation_Log

change word ALTER to CREATE or try this

CREATE PROCEDURE [dbo].[Add_Donation]    -- @in_CustomerID int,    @in_Email VARCHAR(128),    @in_GamePoints INT,    @in_GameDollars INT,    @in_ItemID INT,    @in_Quantity INTASBEGIN      DECLARE @in_CustomerID INT    SELECT @in_CustomerID = CustomerID FROM Accounts WHERE email = @in_Email      -- Add GC    IF(@in_GamePoints > 0) BEGIN        UPDATE UsersData SET GamePoints=(GamePoints+@in_GamePoints) WHERE CustomerID=@in_CustomerID    END      -- Add Money    IF(@in_GameDollars > 0) BEGIN        UPDATE UsersData SET GameDollars=(GameDollars+@in_GameDollars) WHERE CustomerID=@in_CustomerID    END      DECLARE [USER=162874]account[/USER]Type INT    SELECT [USER=162874]account[/USER]Type=AccountType FROM UsersData WHERE CustomerID=@in_CustomerID      -- Add Legend    IF   [USER=162874]account[/USER]Type = 2 AND @in_GamePoints >= 50000 AND @in_GameDollars >= 50000) BEGIN            UPDATE UsersData SET                   AccountType=0            WHERE CustomerID=@in_CustomerID    END      -- Add Item to global inventory    IF(@in_ItemID != 0 AND @in_Quantity != 0) BEGIN        INSERT INTO UsersInventory (CustomerID,CharID,BackpackSlot,ItemID,LeasedUntil,Quantity,Var1,Var2)        VALUES (@in_CustomerID,0,0,@in_ItemID,getdate(),@in_Quantity,-1,-1)    END      -- Insert to Donation_Log    IF(@in_GamePoints > 0 OR @in_GameDollars > 0 OR @in_ItemID != 0 AND @in_Quantity != 0) BEGIN        INSERT INTO Donation_Log (CustomerID,Email,GamePoints,GameDollars,ItemID, Quantity, TIME)        VALUES (@in_CustomerID, @in_Email, @in_GamePoints, @in_GameDollars, @in_ItemID, @in_Quantity, GETDATE())    END  END

 

[GMkidink]

change word ALTER to CREATE or try this

CREATE PROCEDURE [dbo].[Add_Donation]    -- @in_CustomerID int,    @in_Email VARCHAR(128),    @in_GamePoints INT,    @in_GameDollars INT,    @in_ItemID INT,    @in_Quantity INTASBEGIN      DECLARE @in_CustomerID INT    SELECT @in_CustomerID = CustomerID FROM Accounts WHERE email = @in_Email      -- Add GC    IF(@in_GamePoints > 0) BEGIN        UPDATE UsersData SET GamePoints=(GamePoints+@in_GamePoints) WHERE CustomerID=@in_CustomerID    END      -- Add Money    IF(@in_GameDollars > 0) BEGIN        UPDATE UsersData SET GameDollars=(GameDollars+@in_GameDollars) WHERE CustomerID=@in_CustomerID    END      DECLARE [USER=162874]account[/USER]Type INT    SELECT [USER=162874]account[/USER]Type=AccountType FROM UsersData WHERE CustomerID=@in_CustomerID      -- Add Legend    IF   [USER=162874]account[/USER]Type = 2 AND @in_GamePoints >= 50000 AND @in_GameDollars >= 50000) BEGIN            UPDATE UsersData SET                   AccountType=0            WHERE CustomerID=@in_CustomerID    END      -- Add Item to global inventory    IF(@in_ItemID != 0 AND @in_Quantity != 0) BEGIN        INSERT INTO UsersInventory (CustomerID,CharID,BackpackSlot,ItemID,LeasedUntil,Quantity,Var1,Var2)        VALUES (@in_CustomerID,0,0,@in_ItemID,getdate(),@in_Quantity,-1,-1)    END      -- Insert to Donation_Log    IF(@in_GamePoints > 0 OR @in_GameDollars > 0 OR @in_ItemID != 0 AND @in_Quantity != 0) BEGIN        INSERT INTO Donation_Log (CustomerID,Email,GamePoints,GameDollars,ItemID, Quantity, TIME)        VALUES (@in_CustomerID, @in_Email, @in_GamePoints, @in_GameDollars, @in_ItemID, @in_Quantity, GETDATE())    END  END

thats php code D:? bad way to implement in sql can share it in code tag?

 

[Symbolic.]

thats php code D:? bad way to implement in sql can share it in code tag?

No that isn't PHP code, you would execute that in the SQL server enenvironment

 

[GMkidink]

he using a php tag in sql codes, did you try to use this query? you get a lot of error coz many things are in comments because is a query unordered :s and its hard to get it work but n1 release

 

[Jack Jack]

fix ......

CREATE PROCEDURE [dbo].[Add_Donation] -- @in_CustomerID int,
@in_Email VARCHAR(128),
@in_GamePoints INT,
@in_GameDollars INT,
@in_ItemID INT,
@in_Quantity INT
AS
BEGIN

DECLARE @in_CustomerID INT
SELECT @in_CustomerID = CustomerID FROM Accounts WHERE email = @in_Email

-- Add GC
IF(@in_GamePoints > 0) BEGIN
UPDATE UsersData SET GamePoints=(GamePoints+@in_GamePoints) WHERE CustomerID=@in_CustomerID
END

-- Add Money
IF(@in_GameDollars > 0)BEGIN
UPDATE UsersData SET GameDollars=(GameDollars+@in_GameDollars) WHERE CustomerID=@in_CustomerID
END

DECLARE @accountType INT
SELECT @accountType=AccountType FROM UsersData WHERE CustomerID=@in_CustomerID

-- Add Legend
IF (@accountType = 2 AND @in_GamePoints >= 50000 AND @in_GameDollars >= 50000)BEGIN
UPDATE UsersData SET
AccountType=0
WHERE CustomerID=@in_CustomerID
END

-- Add Item to global inventory
IF(@in_ItemID != 0 AND @in_Quantity != 0) BEGIN
INSERT INTO UsersInventory (CustomerID,CharID,BackpackSlot,ItemID,LeasedUntil,Quantity,Var1,Var2)
VALUES (@in_CustomerID,0,0,@in_ItemID,getdate(),@in_Quantity,-1,-1)
END

-- Insert to Donation_Log
IF(@in_GamePoints > 0 OR @in_GameDollars > 0 OR @in_ItemID != 0 AND @in_Quantity != 0) BEGIN
INSERT INTO Donation_Log (CustomerID,Email,GamePoints,GameDollars,ItemID, Quantity, TIME)
VALUES (@in_CustomerID, @in_Email, @in_GamePoints, @in_GameDollars, @in_ItemID, @in_Quantity, GETDATE())
END
END

 

[pikachujr]

fix ......

Credits for lukasccb, no for you man

 

[LukasCCB]

Sorry, my PC is down :
This is link fixed and re-uploaded:

You must be registered to see links

From Linux Zorin.

fix ......

mine is running smoothly.
thank you for share your code.

he using a php tag in sql codes, did you try to use this query? you get a lot of error coz many things are in comments because is a query unordered :s and its hard to get it work but n1 release

do it yourself, it is useful for those who do not know, do not complain.

how about this error with the SQL?

already I made the dbo.Donation_Log

no no hahahaha, this is SQL on NaviCat>Function or execute this in SQL Server 2008

 

[desmondhume]

please re upload because link broken

 

[sezer1337]

[Hidden content]

test​

++

 

[moneiei04001]

x youEN

Unable to download, link broken.

 

[dew84210za]

link broken

 

[somerchef]

+

 

[poyrazcakirca]

[Hidden content]

​

ı do it

 

[LukeMacD]

download thanks

 

[secretslot]

thx

 

[cengizhan253403]

[Gizli İçerik]

​

Gggggggggg

 

[Lexkyle]

[Hidden content]

​

nice