Newbie Spellweaver
- Joined
- Apr 22, 2009
- Messages
- 44
- Reaction score
- 20
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
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
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
Code:
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
Last edited: