How to let you buy Gamble Items for the Shop for Bounty

Hi all,

Maybe you people already know this. But i wanna share this knowledge with you people.

Make the GIID in the Database above 1,000,000.
Example
GIID = 1000001
Name = " Choice an name"
Desc = " Choice something you like"
Price = the price you want
RegDat = An date in the past
StartDat = an date in the past.
LifeTimeHour = The time how long an item will be in the shop, in hours << i think
IsCash = 0 for bounty 1 for premium
Opened = 1 Else i wont work.





ect,ect,ect....

Use the Bought Gamble items you need an small change in your DB.

Code:

---

GO
/****** Object:  StoredProcedure [dbo].[spChangeGambleItemToRewardItem]    Script Date: 12/26/2009 14:49:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROC [dbo].[spChangeGambleItemToRewardItem]
 @CID int
, @CIID int
, @GIID int
, @RewardItemID int
AS
BEGIN
 SET NOCOUNT ON

 DECLARE @RentHourPeriod smallint

 SELECT @RentHourPeriod = RentHourPeriod
 FROM GambleRewardItem
 WHERE GIID = @GIID AND (ItemIDMale = @RewardItemID OR ItemIDFemale = @RewardItemID)

 IF @RentHourPeriod IS NULL BEGIN
  SELECT -1 as 'Ret'
  RETURN
 END

 BEGIN TRAN
  UPDATE CharacterItem
  SET ItemID = @RewardItemID, RentHourPeriod = @RentHourPeriod
  , RentDate = GETDATE()
  WHERE CID = @CID AND CIID = @CIID AND ItemID = @GIID
  IF (0 <> @@ERROR) OR (0 = @@ROWCOUNT) BEGIN
  ROLLBACK TRAN
  SELECT -2 AS 'Ret'
  RETURN
  END


 COMMIT TRAN

 SELECT 1 AS 'Ret'
END

---

Execute this in your DB and it shall work all fine,

Please take an look to the ScreenShot your DB Should be something like this. It works.

50% of the credits Are for Maxteam.
50% of the credits Are for ME.

Press Thanks if i helped you people.

thank you

Thanks Rotana :)

Thanks man!! You rock!

Also, wish you a very Happy B'day in advance.

how to add in shop?

10
Inited client file list (1)
Start GambleItem Init.
GIID : 1000001
GRIID : m(506005), f(506005).
End GambleItem Init.

Start shop GItem list log.
GambleItemCount : 0.
End shop GItem list log.


=== Dump GambleItem Info. ===
Gamble item list.
Gamble item. ID(1000001), Name(Test), IsTimeover(1).

Send shop gamble item list.
Shop gamble item count : 0
=== Completed Dump GambleItem Info. ===

Thanks a lot!

Updated Main post.

---------- Post added at 03:01 PM ---------- Previous post was at 02:57 PM ----------

Quote:

---

Originally Posted by Gosu[ru]

how to add in shop?

10
Inited client file list (1)
Start GambleItem Init.
GIID : 1000001
GRIID : m(506005), f(506005).
End GambleItem Init.

Start shop GItem list log.
GambleItemCount : 0.
End shop GItem list log.


=== Dump GambleItem Info. ===
Gamble item list.
Gamble item. ID(1000001), Name(Test), IsTimeover(1).

Send shop gamble item list.
Shop gamble item count : 0
=== Completed Dump GambleItem Info. ===

---

Your probelly have the IsCash on 1 It must be 0

See Main post.

Dont work

Code:

---

Inited client file list (1)
Start GambleItem Init.
GIID : 1000001
  GRIID : m(506005), f(506005).
End GambleItem Init.

Start shop GItem list log.
GambleItemCount : 0.
End shop GItem list log.


=== Dump GambleItem Info. ===
Gamble item list.
Gamble item. ID(1000001), Name(Test), IsTimeover(1).

Send shop gamble item list.
Shop gamble item count : 0
=== Completed Dump GambleItem Info. ===

---

http://img191.imageshack.us/img191/2408/84039102.gif

It isn't showing for me:

Code:

---

Inited client file list (1)
Start GambleItem Init.
GIID : 1000001
  GRIID : m(523501), f(523501).
End GambleItem Init.

Start shop GItem list log.
GambleItemCount : 1.
Shop GItem : 1000001
End shop GItem list log.


=== Dump GambleItem Info. ===
Gamble item list.
Gamble item. ID(1000001), Name(Box), IsTimeover(0).

Send shop gamble item list.
Shop gamble item count : 1
Shop gamble item. ID(1000001), Name(Box).
=== Completed Dump GambleItem Info. ===

---

The boxes still don't show up in the shop.

http://i47.tinypic.com/2gsjzo7.jpg

http://i47.tinypic.com/1zm370o.jpg

My server log:

Code:

---

Load XML from memory : strings.xml(0x0037) - SUCCESS
Load XML from memory : cserror.xml(0x0037) - SUCCESS
[12/26/09 19:43:02] DBMS connected

[12/26/09 19:43:02] Command registeration completed

Inited client file list (1)
Start GambleItem Init.
GIID : 10000002
End GambleItem Init.

Start shop GItem list log.
GambleItemCount : 0.
End shop GItem list log.


=== Dump GambleItem Info. ===
Gamble item list.
Gamble item. ID(10000002), Name(Cakram), IsTimeover(1).

Send shop gamble item list.
Shop gamble item count : 0
=== Completed Dump GambleItem Info. ===

success init security.

---

there seems to be some problem with your [spGetGambleItemList]

maybe use this Script, but i use the default ones.

Code:

---

USE [GunzDB]
GO
/****** Object:  StoredProcedure [dbo].[spGetGambleItemList]    Script Date: 12/26/2009 02:19:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROC [dbo].[spGetGambleItemList]
AS
BEGIN
 SET NOCOUNT ON
 
 SELECT GIID, Name, Description, Price
 , DATEDIFF(mi, GETDATE(), StartDate) AS 'StartDate'
 , LifeTimeHour * 60 as 'LifeTimeHour', Opened, IsCash
 FROM GambleItem(NOLOCK)
END

---

update if it worked or not

Quote:

---

Originally Posted by phoenix_147

The boxes still don't show up in the shop.

http://i47.tinypic.com/2gsjzo7.jpg

http://i47.tinypic.com/1zm370o.jpg

My server log:

Code:

---

Load XML from memory : strings.xml(0x0037) - SUCCESS
Load XML from memory : cserror.xml(0x0037) - SUCCESS
[12/26/09 19:43:02] DBMS connected

[12/26/09 19:43:02] Command registeration completed

Inited client file list (1)
Start GambleItem Init.
GIID : 10000002
End GambleItem Init.

Start shop GItem list log.
GambleItemCount : 0.
End shop GItem list log.


=== Dump GambleItem Info. ===
Gamble item list.
Gamble item. ID(10000002), Name(Cakram), IsTimeover(1).

Send shop gamble item list.
Shop gamble item count : 0
=== Completed Dump GambleItem Info. ===

success init security.

---

---

Your RegDate and StartDate must be a recent one.

Good job rotana not that hard to do but good job since much people don't know how to do it

The problem can be
1> The StartDate is to old. Try make it yesterdays date and the LifeTimeHour 1000
2> Opened should be 1 and IsCash 0

if my old script dint work try this
this must be the proper

Code:

---

USE [GunzDB]
GO
/****** Object:  StoredProcedure [dbo].[spGetGambleItemList]    Script Date: 12/26/2009 02:19:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROC [dbo].[spGetGambleItemList]
AS
BEGIN
 SET NOCOUNT ON
 
 SELECT GIID, Name, Description, Price, RegDate, StartDate, LifeTimeHour, Opened, IsCash
 FROM GambleItem(NOLOCK)
END

---

Quote:

---

Originally Posted by Linear88

Your RegDate and StartDate must be a recent one.

---

I don't see any RegDate or Start Date Column.

@Rotana: Opened is 1 but Cash Items don't work with these boxes?

Quote:

---

Originally Posted by phoenix_147

I don't see any RegDate or Start Date Column.

@Rotana: Opened is 1 but Cash Items don't work with these boxes?

---

Use the official database.

Quote:

---

Originally Posted by Linear88

Use the official Database.

---

I am. I executed Phail's Stored procs => Executed the official database => Executed Rotana's Stored procs above.

Thanks, will test soon.

@ Pheonix Delete the gambleitem table, gamblerewarditem, spgetgambleitemlist
spgetrewarditemlist and spchangegambletoreward item and reexecute the original DB

your DB seems to be using phails stored procedures

You need to use a clean db to get it all perfectly working

I'll try to do what maxteam said.
@Touchwise: I can't delete my current DB as it has all the Item codes of the Ijji zitem in it lol. Someone's not gonna automatically generate and add it again :P.

1)done

Code:

---

Inited client file list (1)
Start GambleItem Init.
GIID : 1000001
  GRIID : m(506005), f(506005).
End GambleItem Init.

Start shop GItem list log.
GambleItemCount : 1.
Shop GItem : 1000001
End shop GItem list log.


=== Dump GambleItem Info. ===
Gamble item list.
Gamble item. ID(1000001), Name(Gold Box), IsTimeover(0).

Send shop gamble item list.
Shop gamble item count : 1
Shop gamble item. ID(1000001), Name(Gold Box).
=== Completed Dump GambleItem Info. ===

---

2)Error, cant open in game

Code:

---

success to update CustomIP
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.dbo.ConnLog'.

Gamble() failed! [ItemID : 1000001]
Gamble() failed! [ItemID : 1000001]
Gamble() failed! [ItemID : 1000001]
Gamble() failed! [ItemID : 1000001]
Gamble() failed! [ItemID : 1000001]
Gamble() failed! [ItemID : 1000001]
Gamble() failed! [ItemID : 1000001]
Gamble() failed! [ItemID : 1000001]
Gamble() failed! [ItemID : 1000001]
Gamble() failed! [ItemID : 1000001]
Gamble() failed! [ItemID : 1000001]
MMatchDBMgr::GetGambleItemList - Invalid object name 'LogDB..GambleLog'.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1.

Gamble() failed! [ItemID : 1000001]
Gamble() failed! [ItemID : 1000001]
Gamble() failed! [ItemID : 1000001]
Gamble() failed! [ItemID : 1000001]
Gamble() failed! [ItemID : 1000001]
Gamble() failed! [ItemID : 1000001]
Gamble() failed! [ItemID : 1000001]
Gamble() failed! [ItemID : 1000001]
Gamble() failed! [ItemID : 1000001]
Gamble() failed! [ItemID : 1000001]

---

Execute the SQL Query i have posted in the main post.

Quote:

---

Originally Posted by phoenix_147

I'll try to do what maxteam said.
@Touchwise: I can't delete my current DB as it has all the Item codes of the Ijji zitem in it lol. Someone's not gonna automatically generate and add it again :P.

---

You should have created a separate DB from the start.

Code:

---

Inited client file list (1)
Start GambleItem Init.
GIID : 10000001
End GambleItem Init.

Start shop GItem list log.
GambleItemCount : 1.
Shop GItem : 10000001
End shop GItem list log.


=== Dump GambleItem Info. ===
Gamble item list.
Gamble item. ID(10000001), Name(Icecream), IsTimeover(0).

Send shop gamble item list.
Shop gamble item count : 1
Shop gamble item. ID(10000001), Name(Icecream).
=== Completed Dump GambleItem Info. ===

---

I'm able to view it and buy it. I thought the item name was required.
http://i50.tinypic.com/etxjy0.jpg

I'm not able to open/equip it.
http://i46.tinypic.com/w8pyf8.jpg

In GambleItem.dbo it's Icecream (GIID=10000001) with the item code, Price, Startdate (12/24/2009),RegDate(12/25/2009), IsCash=0, Opened = 1.

In GambleRewardItem.dbo it's the BugBuster coat with GIID=10000002, Male item code, female item code, rent hour period = 48 and Rate per thousand = 1000 (Since there's only 1 item as of yet).

Whats wrong?

Oh, Thanks, works nice.

Code:

---

Inited client file list (1)
Start GambleItem Init.
GIID : 1000001
End GambleItem Init.

Start shop GItem list log.
GambleItemCount : 1.
Shop GItem : 1000001
End shop GItem list log.


=== Dump GambleItem Info. ===
Gamble item list.
Gamble item. ID(1000001), Name(Teste), IsTimeover(0).

Send shop gamble item list.
Shop gamble item count : 1
Shop gamble item. ID(1000001), Name(Teste).
=== Completed Dump GambleItem Info. ===

---

Quote:

---

Originally Posted by phoenix_147

Code:

---

Inited client file list (1)
Start GambleItem Init.
GIID : 10000001
End GambleItem Init.

Start shop GItem list log.
GambleItemCount : 1.
Shop GItem : 10000001
End shop GItem list log.


=== Dump GambleItem Info. ===
Gamble item list.
Gamble item. ID(10000001), Name(Icecream), IsTimeover(0).

Send shop gamble item list.
Shop gamble item count : 1
Shop gamble item. ID(10000001), Name(Icecream).
=== Completed Dump GambleItem Info. ===

---

I'm able to view it and buy it. I thought the item name was required.
http://i50.tinypic.com/etxjy0.jpg

I'm not able to open/equip it.
http://i46.tinypic.com/w8pyf8.jpg

In GambleItem.dbo it's Icecream (GIID=10000001) with the item code, Price, Startdate (12/24/2009),RegDate(12/25/2009), IsCash=0, Opened = 1.

In GambleRewardItem.dbo it's the BugBuster coat with GIID=10000002, Male item code, female item code, rent hour period = 48 and Rate per thousand = 1000 (Since there's only 1 item as of yet).

Whats wrong?

---

I think its the DB, Check the server log.

If there is an error about LogDB Something . Execute the sql i posted in the main post.

O_O gawd thanks!!!

I deleted all the stored procs and tables that were included in Phail's script as maxteam said and then executed the original Database. I then got the Original columns that are supposed to be there in the Database. That part is solved.

Next, I executed your code which is posted above.

Next, You can see what the out come was (In the screenshots)

Now, when I provided a part of my server log above, I over looked the rest of it. Here's the complete log:

Code:

---

Load XML from memory : strings.xml(0x0037) - SUCCESS
Load XML from memory : cserror.xml(0x0037) - SUCCESS
[12/26/09 20:08:22] DBMS connected

[12/26/09 20:08:22] Command registeration completed

Inited client file list (1)
Start GambleItem Init.
GIID : 10000001
End GambleItem Init.

Start shop GItem list log.
GambleItemCount : 1.
Shop GItem : 10000001
End shop GItem list log.


=== Dump GambleItem Info. ===
Gamble item list.
Gamble item. ID(10000001), Name(Icecream), IsTimeover(0).

Send shop gamble item list.
Shop gamble item count : 1
Shop gamble item. ID(10000001), Name(Icecream).
=== Completed Dump GambleItem Info. ===

success init security.
FILE PATH : D:\ex...
MD5 Hash Value => 80 a0 4e 04 0a 8d 1c fb f8 f5 af c2 65 3d b3 7e

================================== Server configure info ==================================
[12/26/09 20:08:22] Release Date : Jul 21 2008
[12/26/09 20:08:22] X-Trap Off
[12/26/09 20:08:22] MD5 Check Off
[12/26/09 20:08:22] Loop Log Save Off
[12/26/09 20:08:22] Server Country : BRAZIL
[12/26/09 20:08:22] Command version : (57)
[12/26/09 20:08:22] Event usable state : (false)
[12/26/09 20:08:22] Load event size : (1)
[12/26/09 20:08:22] FileCRCCheckSum usable state : (false)
[12/26/09 20:08:22] FileCRC size : (1)
[12/26/09 20:08:22] Country Code Filter usalbe state : (false)
[12/26/09 20:08:22] Accept Invalied IP state : (true)
[12/26/09 20:08:22] Keeper IP : (******)
[12/26/09 20:08:22] Monitor IP : (127.0.0.1)
[12/26/09 20:08:22] Ticket use : 0

===========================================================================================

[12/26/09 20:08:22] Match Server Created (Port:****)

success to update CustomIP
Gamble() failed! [ItemID : 10000001]
Gamble() failed! [ItemID : 10000001]
[12/26/09 20:13:22] GARBAGE SESSION CLEANING : ClientCount=1, SessionCount=1, AgentCount=0, CommandPool=5, objHistoryCount=3

Gamble() failed! [ItemID : 10000001]
Gamble() failed! [ItemID : 10000001]
[12/26/09 20:18:22] GARBAGE SESSION CLEANING : ClientCount=1, SessionCount=1, AgentCount=0, CommandPool=5, objHistoryCount=3

Gamble() failed! [ItemID : 10000001]
Gamble() failed! [ItemID : 10000001]
Gamble() failed! [ItemID : 10000001]
Gamble() failed! [ItemID : 10000001]
Gamble() failed! [ItemID : 10000001]
Gamble() failed! [ItemID : 10000001]
Gamble() failed! [ItemID : 10000001]
Gamble() failed! [ItemID : 10000001]
Gamble() failed! [ItemID : 10000001]
Gamble() failed! [ItemID : 10000001]
Gamble() failed! [ItemID : 10000001]
Gamble() failed! [ItemID : 10000001]
Gamble() failed! [ItemID : 10000001]
[12/26/09 20:23:22] GARBAGE SESSION CLEANING : ClientCount=1, SessionCount=1, AgentCount=0, CommandPool=5, objHistoryCount=1

Gamble() failed! [ItemID : 10000001]
Gamble() failed! [ItemID : 10000001]
Gamble() failed! [ItemID : 10000001]
[12/26/09 20:28:22] GARBAGE SESSION CLEANING : ClientCount=1, SessionCount=1, AgentCount=0, CommandPool=7, objHistoryCount=2

[12/26/09 20:33:22] GARBAGE SESSION CLEANING : ClientCount=1, SessionCount=1, AgentCount=0, CommandPool=7, objHistoryCount=2

---

-----------------------EDIT---------------------------

http://i48.tinypic.com/ei4gud.jpg

Lol, I was being plain dumb. I entered different information in the 2 tables. It works for me. Thanks Rotana!



But, How can I have Gold and Green boxes in the shop and each giving Multiple items (Eg. The gold box gives random shotguns,swords,etc)?

See the screenshot at the main post, on how to make multiply reward's for 1 item.

---------- Post added at 04:39 PM ---------- Previous post was at 04:36 PM ----------

Look at the table of screenshot thats on the bottom.

The reward. And look good voor the ID's i used in there.

---------- Post added at 04:40 PM ---------- Previous post was at 04:39 PM ----------

RatePerThousand is sort of change of getting that reward.

250 means 250 out of 1000 change of getting that 25%
500 means 500 out of 1000 change of getting that 50%

Yeah thanks. I tried the same thing before but the Rate for the first item was 1000 itself. So, it didn't let me set another item for the same GIID. Thanks a lot man.

1 Question: Do Cash Items work with these boxes?

It still doesn't work for me.

Tell me what you have done so far?

Quote:

---

Originally Posted by Linear88

It still doesn't work for me.

---

for those who have this error on MS

Code:

---

Gamble() failed! [ItemID : 1000001]

---

The new database has some stuff on Getitemchar or w/e bugged
u might wanna have a look at 07 databse for fix
or try this method
Use 07 DB -> Execute New DB -> this gamble SQL fix

i am not going to spend my time searching on the FIX as i am using the abv and got a huge DB

This post might help you solve the issue by yourself

Cool. I hate Gamble items, so prob. not using it in my server... hahha

You used my files to make this right, if so nice.
Using custom solutions aren't really recommended since the 2008 files aren't really stable.
Ooh yeah fuck what I said, I don't care anymore, it's Christmas so you are forgiven.
Good job Herman.

lol @ KillerStefan :)

Thanks anyways :P

Very nice so this works. I shall do it myself ^.^ thanks Rotana and Max

Quote:

---

Originally Posted by number12

Very nice so this works. I shall do it myself ^.^ thanks Rotana and Max

---

Only problem with this is I haven't been able to purchase the Gamble Item

Why so? Show me a screenshot of your GambleItem.dbo and GambleRewardItem.dbo. I'll help you out. It works perfectly for me.

Quote:

---

Originally Posted by phoenix_147

Why so? Show me a screenshot of your GambleItem.dbo and GambleRewardItem.dbo. I'll help you out. It works perfectly for me.

---

NVM, found the problem, it thinks there is 4 items when there is only two, I didn't set the rate correctly :laugh:

Ok so I tried, yet nothing. I did everything correct im sure.
http://i34.photobucket.com/albums/d1...sw/rewards.png

Mlog:

Code:

---

Shop Gamble item count : 1
shop gitem : 1000001, Test
MLogoutListener !

---

Server log:

Code:

---

Inited client file list (1)
Start GambleItem Init.
GIID : 1000001
  GRIID : m(72), f(1).
  GRIID : m(73), f(2).
End GambleItem Init.

Start shop GItem list log.
GambleItemCount : 1.
Shop GItem : 1000001
End shop GItem list log.


=== Dump GambleItem Info. ===
Gamble item list.
Gamble item. ID(1000001), Name(Test), IsTimeover(0).

Send shop gamble item list.
Shop gamble item count : 1
Shop gamble item. ID(1000001), Name(Test).
=== Completed Dump GambleItem Info. ===

success init security.

---

Number12, enter 12/25/2009 for RegDate and 12/26/2009 for StartDate. It's supposed to have a date in the past so this is good enough.

The rest of it is correct. It should work.

@phoenix 147 - thanks for replying. I tried that and did not work also. I dont know so eh =/ Thanks though.

Oh I know the problem. Your GIID has to be above 10000001 not 1000001. Change your GIID to 10000001 and so on.

Quote:

---

Originally Posted by phoenix_147

Oh I know the problem. Your GIID has to be above 10000001 not 1000001. Change your GIID to 10000001 and so on.

---

Really?! Ok I am going to try and hope for the best when I get home ^^ Thanks

------------------

Edit:

Just got home and tried it and yet didnt work. =/ eh I give up for now lol.