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

Page 2 of 4 FirstFirst 1234 LastLast
Results 16 to 30 of 47
  1. 26-12-09 #16
     Phoenix 
      Phoenix is offline
    ModeratorRank
    Mar 2009 Join Date
    6,890Posts

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

    Quote Originally Posted by Linear88 View Post
    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?
    Reply With Quote Reply With Quote
  2. 26-12-09 #17
    Linear88
    `-` Linear88 is offline
    MemberRank
    Jan 2007 Join Date
    1,746Posts

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

    Quote Originally Posted by phoenix_147 View Post
    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.
    Reply With Quote Reply With Quote
  3. 26-12-09 #18
     Phoenix 
      Phoenix is offline
    ModeratorRank
    Mar 2009 Join Date
    6,890Posts

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

    Quote Originally Posted by Linear88 View Post
    Use the official Database.
    I am. I executed Phail's Stored procs => Executed the official database => Executed Rotana's Stored procs above.
    Reply With Quote Reply With Quote
  4. 26-12-09 #19
    wtfhacker
    Account Upgraded | Title Enabled! wtfhacker is offline
    MemberRank
    Dec 2009 Join Date
    328Posts

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

    Thanks, will test soon.
    Reply With Quote Reply With Quote
  5. 26-12-09 #20
    maxteam
    Account Upgraded | Title Enabled! maxteam is offline
    MemberRank
    Aug 2007 Join Date
    IndiaLocation
    428Posts

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

    @ 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
    Reply With Quote Reply With Quote
  6. 26-12-09 #21
    Touchwise
    Freelance GunZ Developer Touchwise is offline
    MemberRank
    Aug 2009 Join Date
    The NetherlandsLocation
    754Posts

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

    You need to use a clean db to get it all perfectly working
    Reply With Quote Reply With Quote
  7. 26-12-09 #22
     Phoenix 
      Phoenix is offline
    ModeratorRank
    Mar 2009 Join Date
    6,890Posts

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

    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.
    Reply With Quote Reply With Quote
  8. 26-12-09 #23
    Gosu[ru]
    Account Upgraded | Title Enabled! Gosu[ru] is offline
    MemberRank
    Jan 2009 Join Date
    http://www.epicLocation
    359Posts

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

    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]
    Reply With Quote Reply With Quote
  9. 26-12-09 #24
    Rotana
    The beer?? Its here !!! Rotana is offline
    MemberRank
    Jan 2007 Join Date
    The NetherlandsLocation
    1,733Posts

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

    Execute the SQL Query i have posted in the main post.
    Reply With Quote Reply With Quote
  10. 26-12-09 #25
    Linear88
    `-` Linear88 is offline
    MemberRank
    Jan 2007 Join Date
    1,746Posts

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

    Quote Originally Posted by phoenix_147 View Post
    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.
    Reply With Quote Reply With Quote
  11. 26-12-09 #26
     Phoenix 
      Phoenix is offline
    ModeratorRank
    Mar 2009 Join Date
    6,890Posts

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

    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.


    I'm not able to open/equip it.


    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 by Phoenix; 26-12-09 at 03:48 PM.
    Reply With Quote Reply With Quote
  12. 26-12-09 #27
    alfredao
    Account Upgraded | Title Enabled! alfredao is offline
    MemberRank
    Jan 2008 Join Date
    Coronel FabriciLocation
    705Posts

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

    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. ===
    Reply With Quote Reply With Quote
  13. 26-12-09 #28
    Rotana
    The beer?? Its here !!! Rotana is offline
    MemberRank
    Jan 2007 Join Date
    The NetherlandsLocation
    1,733Posts

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

    Quote Originally Posted by phoenix_147 View Post
    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.


    I'm not able to open/equip it.


    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.
    Reply With Quote Reply With Quote
  14. 26-12-09 #29
    pavan33
    Account Upgraded | Title Enabled! pavan33 is offline
    MemberRank
    Oct 2008 Join Date
    RageZone xDLocation
    289Posts

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

    O_O gawd thanks!!!
    Reply With Quote Reply With Quote
  15. 26-12-09 #30
     Phoenix 
      Phoenix is offline
    ModeratorRank
    Mar 2009 Join Date
    6,890Posts

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

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



    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 by Phoenix; 26-12-09 at 04:24 PM.
    Reply With Quote Reply With Quote


Page 2 of 4 FirstFirst 1234 LastLast
« Previous Thread | Next Thread »

Advertisement