Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Help WareHouse

┌П┐(•_•)┌П┐
Joined
Dec 22, 2009
Messages
958
Reaction score
317
really i don`t know,i now tuse sauron patch,because i create my patch,with no comands,new items,costumes,and many others,another way tu put alz in warehouse,plz tell me i need for shop,because my palyers need alz in warehouse to can buy items... on my site!!
 
Upvote 0
Joined
Mar 22, 2009
Messages
1,231
Reaction score
502
you didn't make new database
in sql make new database:CashShop
then run those:(in cashshop)
make new querry
CREATE TABLE [dbo].[Bank] (
[UserNum] [int] NOT NULL ,
[Alz] [bigint] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ShopItems] (
[Id] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Description] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ItemIdx] [int] NOT NULL ,
[DurationIdx] [int] NOT NULL ,
[ItemOpt] [int] NOT NULL ,
[Image] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Honour] [int] NULL ,
[Alz] [int] NULL ,
[Category] [int] NOT NULL ,
[Available] [int] NOT NULL
) ON [PRIMARY]
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO


CREATE PROCEDURE SetBankAlz( @UserNum int, @Alz bigint)
AS
BEGIN
BEGIN TRAN
IF NOT EXISTS( SELECT UserNum
FROM Bank
WHERE UserNum = @UserNum )
BEGIN
INSERT Bank (UserNum, Alz)
VALUES ( @UserNum, 0)
END
ELSE
BEGIN
UPDATE Bank
SET Alz = @Alz
WHERE UserNum = @UserNum
END
COMMIT TRAN
END


GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO



CREATE PROCEDURE [dbo].[GetBankAlz]( @UserNum int ) AS
BEGIN
if ( SELECT UserNum FROM Bank WHERE UserNum = @UserNum ) is Null
BEGIN
INSERT Bank ( UserNum, Alz)
VALUES( @UserNum, 0)
END
SELECT UserNum, Alz
FROM Bank
WHERE UserNum = @UserNum
END



GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
 
Upvote 0
Joined
Mar 22, 2009
Messages
1,231
Reaction score
502
In config.php:

define('ALLOW_BANK',false);

Set this to false if you don't want to let players transfer Alz to the bank.
This enables you to populate the bank in other ways such as donations.
 
Upvote 0
┌П┐(•_•)┌П┐
Joined
Dec 22, 2009
Messages
958
Reaction score
317
i forgot to say ,i have site cabaltoolz beta3,and a little question,in user panel everything work perfect but all buttons eception webshop,are invisible,why?...
 
Upvote 0
The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
I think you are each talking about different things :p

You said you wanted alz in warehouse but i'm not sure which shop you want to be spending it at.By "warehouse" do you mean in game npc warehouse or something in cabaltoolz (i don't use cabaltoolz so i don't know what it has)?
 
Upvote 0
Joined
Mar 22, 2009
Messages
1,231
Reaction score
502
I think you are each talking about different things :p

You said you wanted alz in warehouse but i'm not sure which shop you want to be spending it at.By "warehouse" do you mean in game npc warehouse or something in cabaltoolz (i don't use cabaltoolz so i don't know what it has)?

he is speaking for webshop,and what i posted it it's from ur webshop chump!
 
Upvote 0
Back
Top