Auto Auction

[WhiteEagle]

Hey guys,

I tried now some days to add a custom auto-auction adding Npc, but

nothing will work.

I need a script like:

Example:

OnClock1200:
OnClock1205:
OnClock1210:
OnClock1800:
OnClock1805:
OnClock1810:

set $aucitem1, rand(4001,4534); // Card IDs
set $aucitem2, rand(1101,1749); // Weapon IDs
set $aucitem3, rand(2201,2299); // Headgear IDs
or
set array[0],ItemID1,ItemID2,etc...

query_sql "SELECT auction_id,`seller_id`,`seller_name`,`price`,`buynow`,`hours`,`nameid`,`item_name`,`type` FROM `auction` = .@sellid,.@sellname,.@price,.@buy,.@hour,.@itemid,.@itemname,.@type 

So.. I asking now here: "Knows anyone how can I script this?"

Thanks in advance.

[Sere]

No one answered yet?

The idea sounds nice, if you got any solution, please share it with me.

Want to add it too.

[Ryokem]

for Auction, you mean a place where people put some items to sell and buyers bet to the highest prize?

If I am not wrong, there was a sort of released-auction somewhere in the official emulated client...

[WhiteEagle]

@Ryokem:

Yes, I mean this function what you can use with "@auction".

But I ask/need for a script, what include some random items automatically in the auction.

My problem is here, the adding works, but it will not displayed ingame....

[GmOcean]

I'm assuming you're adding it straight to the sql correct? Well, if I'm not mistaken doesn't the auction NPC use player ids to display the listed items? If this IS the case then, make a dummy account and try readding them. It could be just a simple unable to find information thing. I'd double check but I'm at work... I'm taking my 'smoke' break... Yet I don't smoke lol.

[WhiteEagle]

@GmOcean:

Yes, you're right. I work with sql and I added for testing my GM Name and CharID to display it in the auction.

But it don't work. The item will complete not displayed.

That you've no smoking at this time is bad for me, good for your health. xDDD

Thank you GmOcean.^^

[GmOcean]

Well, I go to lunch in an hour, ill let you know what I find then.

Well, I came across the same issue as you. And I've come to the conclusion that this may because the server probably only loads the sql information at the start. Then it only ever updates the information when someone adds an item through the NPC or Buys one.

I did notice that upon restarting the server, after adding through SQL, it does show up. However, it will not show up, if i add through SQL, then add an item ingame to update the display. So, unless a dev or someone who can understan the src better than I can explains how the auction system works src and client wise, I'm gonna say this isn't possible.

[WhiteEagle]

Ok, then it is correct what I'm think too.

But many thanks that you test it too.

Dear,

WhiteEagle