[QUEST-RELEASE] Auction House

[xxxHUN95]

Hello everybody!

I've written a quest for Auction House. I've tested it with 34k and vanilla core gamefiles. For me, it works fine.

The quest uses mysql, select3 and item2_pc2_lib, so if you want to use it, you have to have them. Oh, iMer's item2_pc2_lib needed only for 34k, if you use it with vanilla core, you have to change the following things:

item2.sett_attr -> item.set_value
local t, v = item2.get_attr(i) -> local t, v = item.get_attr_type(i), item.get_attr_value(i)

Well, its function is that players can sell, buy items, or can make offers for them.
If somebody buys an item, the item will immediately move to the one's Received Items. The owner of the item will get the money, of course, in the Received Money.
If a player makes an offer for an item, and another player makes a bigger offer, the previous one will get the money back.

So, as I mentioned, the quest uses mysql_query function, you have to create the tables. You'll find the SQL-Code for the them in attachment.

Well, you'll find the quest in attachment.
Sorry for half English-half Hungarian bonus table, but I don't know the exact English name of the bonuses.

Finally, I have to give a thank to:

 Spoiler

- DonNodus, Nzio and Morpheus for the help with the quest
- iMer for the item2_pc2_lib
- Mijago for select3 and mysql_query function

Video:

Hope you'll like it.

Best regards,
xxxHUN™

[RoxaLyssa]

Thanks for your work, but at least you could translate all the rows to English or German before publishing. By the way, using an auction house is better from the game file, because this version can overload the server with many players, but of course, it's better and easier for the little servers.

[xxxHUN95]

Thanks for your comment.
I have to agree with you.

Using the game file's auction system is way better, than my solution. As you mentioned, using this version is... Well, I can't say that it's better, but, of course, it's way easier for little servers.

[Sheini]

Danke, hat Jemand einen Screen wie das Ingame aussieht?

mfg

[.Kibito]

Originally Posted by Sheini

Danke, hat Jemand einen Screen wie das Ingame aussieht?

mfg

Es ist einfach nur eine Quest was denkst du denn wie es aussieht?

[xxxHUN95]

Danke, hat Jemand einen Screen wie das Ingame aussieht?

mfg

Sheini, I uploaded a video, hope that's ok

Es ist einfach nur eine Quest was denkst du denn wie es aussieht?

.Kibito, I think, he just wants to check, whether it works or not

[Benhero]

Hier für alle die Deutsche übersetzung:

#Sollten Probleme auftreten einfach hier schreiben oder mir eine Privat Nachricht schicken!

Mfg. Benhero

[matizz9811]

Hi I have problem I add quest and mysql

[Benhero]

you must change "--e=" to "-e" remove one "-" and "=" in your questlib.lua.

[thespeedyy]

was soll ich da jetzt ändern?

local t, v = item2.get_attr(i) -> local t, v = item.get_attr_type(i), item.get_attr_value(i)

[xxxHUN95]

Originally Posted by thespeedyy

was soll ich da jetzt ändern?

local t, v = item2.get_attr(i) -> local t, v = item.get_attr_type(i), item.get_attr_value(i)

in the quest, you find "local t, v = item2.get_attr(i)"
but, if you want to use this quest with vanilla core, you have to replace that row with "local t, v = item.get_attr_type(i), item.get_attr_value(i)"

[Mt2KreKs]

[AmerigoMendosa]

Originally Posted by Mt2KreKs

Enter your quest_functions

item2.get_attr
item2.set_attr
select3