No creo y si alguien lo tiene no te lo dará gratis.
otra pregunta sabes que esta webshop trabaja con una especie de crediso que no es wcoin ya que ella tiene una querry o tabla diferente al Wcoin..
como hago para que cuando los usario compren se los descuente de su wcoin.
CREATE PROCEDURE [dbo].[Add_Credits]
@username VARCHAR(10),
@credits int,
@column int,
@type int
AS
BEGIN
IF (@column = 1)
BEGIN
IF (@type = 1)
BEGIN
IF ((SELECT COUNT(*) FROM [DmN_Shop_Credits] WHERE [memb___id] = @username)!=1)
INSERT INTO [DmN_Shop_Credits] (memb___id) VALUES (@username);
UPDATE [DmN_Shop_Credits] SET [credits]=[credits]+@credits WHERE [memb___id]=@username;
END
IF (@type = 2)
BEGIN
IF ((SELECT COUNT(*) FROM [DmN_Shop_Credits] WHERE [memb___id] = @username)!=1)
INSERT INTO [DmN_Shop_Credits] (memb___id) VALUES (@username);
UPDATE [DmN_Shop_Credits] SET [credits]=[credits]-@credits WHERE [memb___id]=@username;
END
END
IF (@column = 2)
BEGIN
IF (@type = 1)
BEGIN
IF ((SELECT COUNT(*) FROM [DmN_Shop_Credits] WHERE [memb___id] = @username)!=1)
INSERT INTO [DmN_Shop_Credits] (memb___id) VALUES (@username);
UPDATE [DmN_Shop_Credits] SET [credits2]=[credits2]+@credits WHERE [memb___id]=@username;
END
IF (@type = 2)
BEGIN
IF ((SELECT COUNT(*) FROM [DmN_Shop_Credits] WHERE [memb___id] = @username)!=1)
INSERT INTO [DmN_Shop_Credits] (memb___id) VALUES (@username);
UPDATE [DmN_Shop_Credits] SET [credits2]=[credits2]-@credits WHERE [memb___id]=@username;
END
END
IF (@column = 3)
BEGIN
IF (@type = 1)
BEGIN
IF ((SELECT COUNT(*) FROM [DmN_Shop_Credits] WHERE [memb___id] = @username)!=1)
INSERT INTO [DmN_Shop_Credits] (memb___id) VALUES (@username);
UPDATE [DmN_Shop_Credits] SET [credits3]=[credits3]+@credits WHERE [memb___id]=@username;
END
IF (@type = 2)
BEGIN
IF ((SELECT COUNT(*) FROM [DmN_Shop_Credits] WHERE [memb___id] = @username)!=1)
INSERT INTO [DmN_Shop_Credits] (memb___id) VALUES (@username);
UPDATE [DmN_Shop_Credits] SET [credits3]=[credits3]-@credits WHERE [memb___id]=@username;
END
END
END
CREATE TABLE [dbo].[DmN_Shop_Credits](
[memb___id] [varchar](10) NOT NULL PRIMARY KEY,
[credits] [bigint] NOT NULL DEFAULT 0,
[credits2] [bigint] NOT NULL DEFAULT 0,
[credits3] [bigint] NOT NULL DEFAULT 0
) ON [PRIMARY]