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

[Rotana]

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.

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.

[MentaL]

[maxteam]

thank you

[Axium]

Thanks Rotana :)

[Phoenix]

Thanks man!! You rock!

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

[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. ===

[Linear88]

Thanks a lot!

[Rotana]

Updated Main post.

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

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.

[Gosu[ru]]

Dont work

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. ===

[Linear88]

It isn't showing for me:

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. ===

[Phoenix]

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





My server log:

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.

[maxteam]

there seems to be some problem with your [spGetGambleItemList]

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

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

[Linear88]

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





My server log:

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.

[Touchwise]

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

[Rotana]

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

[maxteam]

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

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