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

Skilled Illusionist
Joined
Jan 7, 2009
Messages
339
Reaction score
3
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]
 
Joined
Mar 12, 2009
Messages
6,531
Reaction score
1,814
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.
Rotana - How to let you buy Gamble Items for the Shop for Bounty - RaGEZONE Forums


I'm not able to open/equip it.
Rotana - How to let you buy Gamble Items for the Shop for Bounty - RaGEZONE Forums


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?
 
Last edited:
Legendary Battlemage
Joined
Jan 28, 2008
Messages
695
Reaction score
53
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. ===
 
The beer?? Its here !!!
Loyal Member
Joined
Jan 9, 2007
Messages
1,621
Reaction score
104
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.
Rotana - How to let you buy Gamble Items for the Shop for Bounty - RaGEZONE Forums


I'm not able to open/equip it.
Rotana - How to let you buy Gamble Items for the Shop for Bounty - RaGEZONE Forums


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.
 
Joined
Mar 12, 2009
Messages
6,531
Reaction score
1,814
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---------------------------

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


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)?
 
Last edited:
The beer?? Its here !!!
Loyal Member
Joined
Jan 9, 2007
Messages
1,621
Reaction score
104
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%
 
Elite Diviner
Joined
Aug 27, 2007
Messages
410
Reaction score
118
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
 
Sharing is caring
Developer
Joined
Feb 1, 2007
Messages
2,086
Reaction score
729
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 duck what I said, I don't care anymore, it's Christmas so you are forgiven.
Good job Herman.
 
Back
Top