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

---