[TUT] How To Use Your Central Bank (Storage)

[Goldoracko]

Hey All,
Since im fixing the my gunz database i wanted to post a tut how to get central bank (storage) work.

here wee go, thats realy simple right.

<-- Yeah almost all my id are under 500000 --> and 1 of my weapond are higher than 500000 -->
Wanted To Test if im right.

REQUIREMENT : A Brain:blink:

<-- If your not using system32 database go read the botom of my post --> Text will be red soo you will found it easy.

Open Zitem.xml

1- All your donator item id must be higher than = 500000 <- if not you cant withdraw or move item in your central bank (storage) <-> sound funny because for the shop, if the item id are higher than 500000 its fail :laugh:

2- Make all your donator cash item -> iscashitem="TRUE" />

3- when your done open SQL Server Management Studio Express, go in your gunzdb -> Tables -> DBO.Item, right click -> open table

4- Add all your donator info in there, you dont know what im talking about ? Look at my screenshot.

5- Test Time -> open your admin panel -> gift you a donator item <-> than try to move it in your central bank (Storage) and withdraw it

<-- For People Not Using System32 Database -->

If your not using system32 database you will need to execute this script and be sure your dbo.accountItem are same than mine

Than Here Are The Script

USE [GunZDB]
GO
/****** Object:  StoredProcedure [dbo].[spSelectAccountItem]    Script Date: 06/16/2009 02:49:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


/* 중앙은행 아이템 보기 */
ALTER PROC [dbo].[spSelectAccountItem]
	@AID			int
AS
SET NOCOUNT ON

DECLARE @NowTime DATETIME
SELECT @NowTime = GETDATE()

SELECT AIID, ItemID, (RentHourPeriod*60) - (DateDiff(n, RentDate, @NowTime)) AS RentPeriodRemainder
FROM AccountItem(NOLOCK)
WHERE AID=@AID ORDER BY AIID

I dont know if someone already released this <-- this why i do -->
Srry for my english =P

Now you know why weapond higher than 500000 dont work in shop

 

[Tman151]

Very nice!
Thank you very much Goldoracko.
10/10.

 

[wesman2232]

wow, like not most of us already know how to give items using the DB
nice tut though

 

[Night2Dark2]

Well wes this is useful for web shops. and I've been had this done on my server a long time ago.

And thanks for releasing it to the open world. not sure that anyone will use it though as they can just insert directly into account.

 

[power12300]

wow awesome tutorial .

 

[wesman2232]

Well wes this is useful for web shops. and I've been had this done on my server a long time ago.

And thanks for releasing it to the open world. not sure that anyone will use it though as they can just insert directly into account.

yes but I went ahead and gave criticism early since almost everyone can just use the search button to find out how to do it

 

[MicroManiacs]

LOL, Can't put some item's from the inventory to the Storage !
Well, I can send a item's from my panel to the storage ( central bank ) it work fine but,
Can't withdraw it to the inventory lol's!

 

[Goldoracko]

Did you add all your item correctly in DBO.item because for me its work perfect
And your admin item are cash = true ? right

 

[JusticeDK]

This is nice... i might do it when im not lazy =]

 

[gregon13]

LOL, Can't put some item's from the inventory to the Storage !
Well, I can send a item's from my panel to the storage ( central bank ) it work fine but,
Can't withdraw it to the inventory lol's!

your items in zitem, must also be cash items if it isn't a cash item set the cash bit to 0 and it will work

 

[Creativity]

cant seem to enter the information into the SQL, gave me a nice error, anyways gona try some other ways first.

 

[Goldoracko]

There are some value u cant fill like
Ressex,Resrace,
EffectID = Useless,
Slugoutput,Blendcolor

You can only if you change some colum to varchar.
But it will work if u dont fill it too.

 

[Linear88]

LOL, Can't put some item's from the inventory to the Storage !
Well, I can send a item's from my panel to the storage ( central bank ) it work fine but,
Can't withdraw it to the inventory lol's!

Most probably the MatchServer error?

 

[Creativity]

anyone else got problems with adding it into the SQL or just me? :/

 

[Goldoracko]

Here are the screenshot of my dbo.item try to make it same.

When your done editing dont forget to generate script

 

[Creativity]

Here are the screenshot of my dbo.item try to make it same.

When your done editing dont forget to generate script

thanks, you mean this script btw?

USE [GunZDB]
GO
/****** Object: StoredProcedure [dbo].[spSelectAccountItem] Script Date: 06/16/2009 02:49:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


/* 중앙은행 아이템 보기 */
ALTER PROC [dbo].[spSelectAccountItem]
@AID int
AS
SET NOCOUNT ON

DECLARE @NowTime DATETIME
SELECT @NowTime = GETDATE()

SELECT AIID, ItemID, (RentHourPeriod*60) - (DateDiff(n, RentDate, @NowTime)) AS RentPeriodRemainder
FROM AccountItem(NOLOCK)
WHERE AID=@AID ORDER BY AIID

Wish i was better at SQL related things :/:

 

[Goldoracko]

After if you cant withdraw it execute the script.

 

[MicroManiacs]

Done, I use the panel to gift to all accounts storage, Well to withdraw into the inventory, it work now fine,
But, To put item's from inventory to central bank ( Click Put to the storage ) Well it has disappeared, ( Not in the inventory / Not in the central bank ) !
After a relog, The item's come back to the inventory !

 

[Goldoracko]

1- All your donator item id must be higher than = 500000 <- if not you cant withdraw or move item in your central bank (storage) <-> sound funny because for the shop, if the item id are higher than 500000 its fail :laugh:

 

[razi46]

im gonna try it!