Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

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

The beer?? Its here !!!
Loyal Member
Joined
Jan 9, 2007
Messages
1,621
Reaction score
104
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.
 

Attachments

You must be registered for see attachments list
Last edited:
Skilled Illusionist
Joined
Jan 7, 2009
Messages
339
Reaction score
3
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. ===
 
The beer?? Its here !!!
Loyal Member
Joined
Jan 9, 2007
Messages
1,621
Reaction score
104
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.
 
Skilled Illusionist
Joined
Jan 7, 2009
Messages
339
Reaction score
3
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. ===

Rotana - How to let you buy Gamble Items for the Shop for Bounty - RaGEZONE Forums
 
Joined
Jan 4, 2007
Messages
1,600
Reaction score
217
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. ===
 
Joined
Mar 12, 2009
Messages
6,531
Reaction score
1,814
The boxes still don't show up in the shop.

Rotana - How to let you buy Gamble Items for the Shop for Bounty - RaGEZONE Forums


Rotana - How to let you buy Gamble Items for the Shop for Bounty - RaGEZONE Forums


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.
 
Elite Diviner
Joined
Aug 27, 2007
Messages
410
Reaction score
118
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
 
Last edited:
Joined
Jan 4, 2007
Messages
1,600
Reaction score
217
The boxes still don't show up in the shop.

Rotana - How to let you buy Gamble Items for the Shop for Bounty - RaGEZONE Forums


Rotana - How to let you buy Gamble Items for the Shop for Bounty - RaGEZONE Forums


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.
 
The beer?? Its here !!!
Loyal Member
Joined
Jan 9, 2007
Messages
1,621
Reaction score
104
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
 
Elite Diviner
Joined
Aug 27, 2007
Messages
410
Reaction score
118
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
 
Last edited:
Elite Diviner
Joined
Aug 27, 2007
Messages
410
Reaction score
118
@ 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
 
Back
Top