How to set start dates of Item Broker NPCs (Auction)

Discussion in 'Help' started by Netrocker, Aug 23, 2012.

  1. Netrocker

    Netrocker AdvExt64 Customers (GF/GE/HF)

    Hi, guys!

    I have a question about Item Broker NPCs (Auction) which sell different items on Mondays, Wednesdays and Fridays. ID's of NPCs are listed below in code.
    When I started my server, logs showed me this message:

    Code:
    08/20/2012 13:49:39.687, [.\DBPacketEx.cpp][2284] AuctionNPC[32322] set last start time[1970-1-1 6:0:0]
    08/20/2012 13:49:39.687, [.\DBPacketEx.cpp][2284] AuctionNPC[32320] set last start time[1970-1-1 6:0:0]
    08/20/2012 13:49:39.687, [.\DBPacketEx.cpp][2284] AuctionNPC[32321] set last start time[1970-1-1 6:0:0]
    Where I can set this "last start time"? I got that 1970-1-1 6:0:0 should be changed to proper dates, but where? What file or maybe table in db? Thanks in advance!
    P.S.: if possible, write with some example so that it would be easy to understand.
     
  2. Netrocker

    Netrocker AdvExt64 Customers (GF/GE/HF)

    Nobody can help?
     
  3. moonchild21

    moonchild21 AdvExt64 Customers (IL)

    auctiondata.txt
     
  4. Netrocker

    Netrocker AdvExt64 Customers (GF/GE/HF)

    I've checked it earlier and haven't found anything useful. Only this:

    Code:
    auction_begin									
    	npc_id=32320								// giran
    	auction_doing=1					//   (0: , 1: )			
    	auction_week_day={5}
    	auction_start_time=1700					// €  			
    	auction_duration=300							//  ( )	
    	item_count=30	
    But where is here year, month and day? I mean to start the 1st cycle of the Auction NPC, for example, 27/08/2012.
     
  5. moonchild21

    moonchild21 AdvExt64 Customers (IL)

    auction_start_time=1200

    It means that the auction will start at 12:00 (morning)....If you need 16:00 it should be 1600 (test it )

    auction_duration=800

    Auction duration in minutes


    auction_week_day={5}

    The day of the week...Probably 5 means friday but im not sure

    0 - sun / 1 - mon / 2 - tue / 3 - wed / 4 - thu / 5 - fri / 6 - sat

    You must test them

    The auction is starting every week so you dont need to setup month or year
     
  6. Netrocker

    Netrocker AdvExt64 Customers (GF/GE/HF)

    As you can see, the auctiondata.txt script is set by default like on official, but still it's not working.
    When I click on "View auction times" in HTML dialogue, it shows me the real date of the next auction.
    Here is the screen from Giran:
    [​IMG] [​IMG]

    31.08.2012 at 17:00 - but it will not start as I think because last auction in Aden (20.08) has not started. HTML showed 20.08 at that moment, but nothing happened. No system messages have been displayed about Auction start etc.
    Tomorrow the Auction in Aden should start and I want to solve this problem with your help. Thx. =\
     
  7. moonchild21

    moonchild21 AdvExt64 Customers (IL)

    check database table

    item_auction

    Maybe there is something there?

    After changing auctiondata did you restart server ?
     
  8. Netrocker

    Netrocker AdvExt64 Customers (GF/GE/HF)

    I haven't changed anything in auctiondata.txt, because there are default settings.
    I'll check db table, thx.
     
  9. moonchild21

    moonchild21 AdvExt64 Customers (IL)

    I cant understand.If you want to change the time, just change auctiondata and restart server
     
  10. Fr3DBr

    Fr3DBr Guest

    The server must be up a full week, without restarting in order to the auction starts properly (as far i know).
     
  11. Netrocker

    Netrocker AdvExt64 Customers (GF/GE/HF)

    I've checked item_auction table and found that all dates there are in GMT +0 time.
    Start date in Rune: 1345633200 - Wed, 22 Aug 2012 11:00:00 GMT
    End date in Rune: 1345651200 - Wed, 22 Aug 2012 16:00:00 GMT

    It means that in the auctiondata.txt script should be GMT +0? My server is in GMT +6 time zone.
    I will try to change time in auctiondata.txt to 1100 (as in DB in GMT +0).
    auction_start_time=1100
     
  12. moonchild21

    moonchild21 AdvExt64 Customers (IL)

    auction_start_time=1100 will be 11.00 server time
     
  13. Netrocker

    Netrocker AdvExt64 Customers (GF/GE/HF)

    Fred was right. Auction started by itself. Thx for replies!