PDA

View Full Version : Tired of sitting in EC all day? Help test this new tool :)


Vile
05-19-2014, 01:30 AM
I created a trade management tool... http://ectunnel.org

Especially for you guys on Blue, you can add items to your WTB/WTS list and get out of EC and kill some mobs instead of using your playtime to sit in EC all day ;)

You can basically add items your WTB or WTS to a list:

http://i59.tinypic.com/2e56qns.png

You can also search for Buyers/Sellers for either Red or Blue...

http://i57.tinypic.com/ogjle8.png

Auto complete item names for exact matches...

http://i60.tinypic.com/2aipxsj.jpg

Example of trade list link: http://ectunnel.org/bazaar.php?user=Vile

Some other features:

You can only message a person once per item until they reply to your first message
Items will be active for 7-15 days (I haven't decided) and then will go inactive. You can easily reactivate the items from your manage tab so it will show up in searches. This is to prevent people from adding tons of items for WTB/WTS and never updating their lists..
It's mobile optimized.. browse easily on your phone :)
If you see any weird stats, or items missing or have any suggestions / improvements please PM me.
When searching for a specific item make sure it comes up in the autocomplete suggestion.. otherwise it's not in the database and I'll need to be notified to add it in


I'll be working on adding many new features -- at this point the tool is at least useful to start and I wanted to get people on it and coming up with some ideas I could build in.

I'll update this post with the suggestions I plan to work on below.

Suggestion list:
-build a view where you can see all users for the server you specify so you can easily browse their WTB/WTS lists...
-additional column in management tab displaying # (and link) of potential buyers/sellers of items on your lists...

Vile
05-19-2014, 01:35 AM
For items/spells not listed please provide item/spell and wiki link.

I am pretty sure no spells are added yet, so I'll need some help getting these added in.

Nocsucow
05-19-2014, 01:37 AM
Vile for president.... Awesome shit man like always

rogoshen
05-19-2014, 01:37 AM
this is neat.

Vile
05-19-2014, 01:43 AM
Also.. I've noticed some confusion from people when I've mentioned this tool.

This doesn't read auction logs.. the users must keep their WTB/WTS lists up to date. After 10 days (the # of days can change in the future..), your items will show a status of inactive (Mace of Shadowed Soul):

http://i57.tinypic.com/2h4gv2s.png

Once this happens, you can simply click reactivate and the item will return in search results.

This was put in place to keep inactive items out of your searches.

Terpuntine
05-19-2014, 01:55 AM
pras Vile

Vile
05-19-2014, 01:57 AM
Cron job implemented to set items to inactive status after 10 days...

kylok
05-19-2014, 02:21 AM
would be awesome if you could search for all items being bought/sold on blue/red in addition to the item specific searches

Vile
05-19-2014, 02:28 AM
would be awesome if you could search for all items being bought/sold on blue/red in addition to the item specific searches

How do you envision it looking? like a a table paginated maybe.. with all the results?

Vile
05-19-2014, 02:31 AM
15 latest items for WTB/WTS have been added to home page

kylok
05-19-2014, 02:55 AM
How do you envision it looking? like a a table paginated maybe.. with all the results?

How the home page looks I guess, assuming the home page is displaying all the items being bought/sold.

kylok
05-19-2014, 03:06 AM
I sent you a message Vile did it work?

Vile
05-19-2014, 09:36 AM
Got your message.. fell asleep, just replied.

Gaunja
05-19-2014, 09:44 AM
This is really cool

Vile
05-19-2014, 09:46 AM
This is really cool

Just need more people using it now for it to be effective.. spread the word :cool:

Jauna
05-19-2014, 09:53 AM
Might as well open up the bazaar, shared banks and PoK the way all these apps are going.

Come here for a classic EQ experience and turns out players just want to ruin it as well. Might as well build an app that tracks mobs and lets entire guilds know when they spawn too.

Vile
05-19-2014, 10:02 AM
Come here for a classic EQ experience and turns out players just want to ruin it as well. Might as well build an app that tracks mobs and lets entire guilds know when they spawn too.

Haha.. I was waiting for a response like this!

Machida
05-19-2014, 10:13 AM
Tight work

rogoshen
05-19-2014, 10:18 AM
Might as well open up the bazaar, shared banks and PoK the way all these apps are going.

Come here for a classic EQ experience and turns out players just want to ruin it as well. Might as well build an app that tracks mobs and lets entire guilds know when they spawn too.

Classic is awesome, but spending three hours in EC just to get a 50pp bracer and having your wife yelling at you because you aren't even killing anything is a pain, Sure I get classic raid rules and stuff.. But this is just helpful! Thanks Vile :D

Vile
05-19-2014, 10:31 AM
Classic is awesome, but spending three hours in EC just to get a 50pp bracer and having your wife yelling at you because you aren't even killing anything is a pain, Sure I get classic raid rules and stuff.. But this is just helpful! Thanks Vile :D

That's the whole idea.. especially for casual players who have limited play time. Why waste it all sitting in EC?

Also the this tool can help you easily organize all your loots collecting dust and make them searchable by potential buyers!

alaiwy0503
05-19-2014, 10:39 AM
Might as well open up the bazaar, shared banks and PoK the way all these apps are going.

Come here for a classic EQ experience and turns out players just want to ruin it as well. Might as well build an app that tracks mobs and lets entire guilds know when they spawn too.

responses like this are silly. people think the internet wasn't out when eq first came out? there were forums and websites where people posted WTB/WTS in 1999. Just because you were too young/unintelligent to go find those sites doesn't mean they didn't exist. there is literally NOTHING un-classic about this.

Nirgon
05-19-2014, 11:44 AM
Fully endorsed by Forum Quest.

Glenzig
05-19-2014, 12:25 PM
This is a very good idea. My least favorite part of EQ was always EC tunnel sales and purchases.

Vile
05-19-2014, 12:36 PM
This is a very good idea. My least favorite part of EQ was always EC tunnel sales and purchases.

http://awesomeashild.files.wordpress.com/2013/10/borat-thumbs-up.jpg

Vile
05-19-2014, 01:05 PM
I think I am going to add a WTB/WTS tab for Blue and Red that will just show every item currently active so users can browse whats available on their server more easily besides just searching for specific items..

Doors
05-19-2014, 01:08 PM
pras

Vile
05-19-2014, 01:13 PM
pras

NEED MOAR PRAS :)

Tell your friends... the more people keeping their WTB/WTS lists updated the less time wasted in EC and more time to obtain precious pixels!

HawkMasterson1999
05-19-2014, 01:25 PM
As an outspoken classic purist I give this my thumbs up. It basically works like the forum but easier to manage.

Vile
05-19-2014, 01:28 PM
As an outspoken classic purist I give this my thumbs up. It basically works like the forum but easier to manage.

That's the idea as well.

Managing your WTB/WTS post or searching for deals on the forums that current/updated is a huge PITA.

With this tool I hope to remove those pains from the trading process!

r00t
05-19-2014, 01:43 PM
you're doin bigger and better things these days vile. brings a teardrop to my eye

Vile
05-19-2014, 01:44 PM
you're doin bigger and better things these days vile. brings a teardrop to my eye

<3 you taught me a lot many moons ago...

Just don't hax me bro!

tekniq
05-19-2014, 02:00 PM
this is good for people who don't want to haggle.

Garmr
05-19-2014, 02:27 PM
Fantastic, PRAS!

Get on board folks, good stuff.

thieros
05-19-2014, 03:12 PM
This is sharp man... big fan. Didn't read the rest of the thread but wanted to mention a feature request: Spells. Don't exactly know how your database populates and if it would allow for it, but spells are a big market that might be worth adding in there.

Vile
05-19-2014, 03:17 PM
Yes if you can please provide me just links to the p99 wiki of the spells I can add them very easily.

I think I only have Sunstrike currently added per another user's request.

Vile
05-19-2014, 03:19 PM
this is good for people who don't want to haggle.

You can still haggle through messages.. just because someone has X item listed for 10kpp doesn't mean you can't message them and offer 9kpp and try to make a deal :)

The whole idea of forcing users to list an offer or sales price is so people can at least know where to come in on their offers.. without playing the stupid game of "make an offer...".

thieros
05-19-2014, 03:33 PM
Yes if you can please provide me just links to the p99 wiki of the spells I can add them very easily.

I think I only have Sunstrike currently added per another user's request.

currently the ones i am looking for:

Spell: Talisman of the Brute (http://wiki.project1999.com/Talisman_of_the_Brute)
Spell: Talisman of the Rhino (http://wiki.project1999.com/Talisman_of_the_Rhino)
Spell: Talisman of the Cat (http://wiki.project1999.com/Talisman_of_the_Cat)
Spell: Talisman of the Raptor (http://wiki.project1999.com/Talisman_of_the_Raptor)

Other common ones that may be worth including:

Spell: Pox of Bertoxxulous (http://wiki.project1999.com/Pox_of_Bertoxxulous)
Spell: Torpor (http://wiki.project1999.com/Torpor)
Spell: Bane of Nife (http://wiki.project1999.com/Bane_of_Nife)
Spell: Malo (http://wiki.project1999.com/Malo)
Spell: Call of the Hero (http://wiki.project1999.com/Call_of_the_Hero)
Spell: Naltron's Mark (http://wiki.project1999.com/Naltron%27s_Mark)

Vile
05-19-2014, 03:40 PM
currently the ones i am looking for:

Spell: Talisman of the Brute (http://wiki.project1999.com/Talisman_of_the_Brute)
Spell: Talisman of the Rhino (http://wiki.project1999.com/Talisman_of_the_Rhino)
Spell: Talisman of the Cat (http://wiki.project1999.com/Talisman_of_the_Cat)
Spell: Talisman of the Raptor (http://wiki.project1999.com/Talisman_of_the_Raptor)

Other common ones that may be worth including:

Spell: Pox of Bertoxxulous (http://wiki.project1999.com/Pox_of_Bertoxxulous)
Spell: Torpor (http://wiki.project1999.com/Torpor)
Spell: Bane of Nife (http://wiki.project1999.com/Bane_of_Nife)
Spell: Malo (http://wiki.project1999.com/Malo)
Spell: Call of the Hero (http://wiki.project1999.com/Call_of_the_Hero)
Spell: Naltron's Mark (http://wiki.project1999.com/Naltron%27s_Mark)


Adding in now, will reply when complete!

thieros
05-19-2014, 03:41 PM
Another possible suggestion would be a price history/forecasting tool. Basically when you click 'remove' for an item, it asks you how much you sold it for. This can be answered, or declined, then the item is removed. Then it takes that information and plugs it into the database creating a graph, with averages historically and a projected pricepoint going into the future based on previous datapoints.

reading back into that, that might be a long shot but figured i might mention it!

Vile
05-19-2014, 03:43 PM
Adding in now, will reply when complete!

Spells added!

Vile
05-19-2014, 03:46 PM
Another possible suggestion would be a price history/forecasting tool. Basically when you click 'remove' for an item, it asks you how much you sold it for. This can be answered, or declined, then the item is removed. Then it takes that information and plugs it into the database creating a graph, with averages historically and a projected pricepoint going into the future based on previous datapoints.

reading back into that, that might be a long shot but figured i might mention it!

Awesome idea.. was discussing somethign similar on the red forums:

Yea I can easily store and create a formula based on what people are selling / offering for specific items.

I kind of see what you mean.. I could make the search show the items with stats like I mentioned above.. and below put who is actually selling/buying it..

Something like that?

Only thing is... I need MOAR people using the tool to gather MOAR data :)

So I am thinking when you search an item, right now if no one is selling/buying it, it says "No results"... but now I could show the item and some stats like I mentioned above... average offer/sell price and cool stuff like that.

Vile
05-19-2014, 03:48 PM
Also I guess some shit is bugging out on IE... please be a human and use FireFox or Chrome! I am on a Mac and can't really test it out on the shitty browser.. (nor do I want to...)

http://zerowoes.com/wp-content/uploads/2013/10/image89.png

thieros
05-19-2014, 03:49 PM
that exactly:

Search yields:
1) Stats taken form wiki (Always)
2) Historical/forecasting data with averages (Always)
3) Results of current WTB/WTS (If available)

another option would be a seperate tab:

Vile
05-19-2014, 03:58 PM
Seems like the tablesorter.js isn't too compatible with IE...

I like the ability of being able to sort the tables.. trying to look for a fix.

Shame on you if you use IE to browse though....

Vile
05-19-2014, 04:03 PM
Pulled out tablesorter for now... to not deter people who are using IE..

Vile
05-19-2014, 05:19 PM
Seems a couple of people are confused and PMing me items to add to their WTB/WTS list...

I meant for people to PM if they tried to add items to their WTB/WTS list and it wasn't in the global database to be added..

If you want to add items to your WTB/WTS list, simply create an account, click the manage tab after you log in... start typing an item's name and select the item you want.

Pick if you WTB/WTS and which server... and add the item, very easy :)

August
05-19-2014, 05:33 PM
I like it.

Some feedback:

Don't make me select WTS/WTB. Just sort it by sellers and buyers, that way i can just search an item. Chances are if I WTS/WTB something I'll be interested in seeing what people are paying and waht people are trying to get anyways.

Have Red/Blue be a preference that is set and persists.

When I want to search, I want to just type in the name of the item and press Enter. Too much selection causes the tool to become too clunky.

Sleek otherwise.

Vile
05-19-2014, 05:36 PM
Some feedback:

Don't make me select WTS/WTB. Just sort it by sellers and buyers, that way i can just search an item. Chances are if I WTS/WTB something I'll be interested in seeing what people are paying and waht people are trying to get anyways.


I like this idea... curious to what others think?


Have Red/Blue be a preference that is set and persists.

When I want to search, I want to just type in the name of the item and press Enter. Too much selection causes the tool to become too clunky.

Sleek otherwise.

Only issue here with lets say.. setting your profile to be either Red/Blue.. some people play both servers?

Jauna
05-19-2014, 05:45 PM
Soon, there will be apps that allows people to track mobs and people will say "Hey just like rangers but it skips a step!"

Soon, there will be raid mob alerts, which falls under the tracking thing said above but hey, if an entire guild gets an alert its just like batphoning, just skips a step!

Soon, there will be a LFG app, just because they removed /who all lfg shouldnt bother you all, this just skips steps on sending people tells and asking them if they want to join or not, this just skips more steps, ohohoh and add a "waiting list" feature. you can use your phone, put yourself lfg and you can be playing Skyrim touching yourself to your barbies and you can get a little ring saying "Spot available!"

Soon, there will be a <Dial a Service> app, want clarity for your group in mistmoore? theres an app for that! want rezzes for your group because derp or derp or even herp? theres an app for that!

This shit has got to stop someplace.. but the weird thing is, most of you reading my forecoming doom think its cool, but hey, youll just be playing World of Warcraft with a different skin and thats what we all came here for... right?

August
05-19-2014, 05:48 PM
Only issue here with lets say.. setting your profile to be either Red/Blue.. some people play both servers?

Typically you should design your UI for the majority of your players. I think *most* people only play red or blue (given that red has 1/5 or less the population). Adding extra steps to 80% of your users for 20% user benefit is not a net win.

I understand your intention, though. I am a developer by trade and I always think 'but it's so easy and it is more flexible/extensible!'. Then my designer comes in and tells me to 'keep it simple, stupid'.

Vile
05-19-2014, 06:04 PM
Soon, there will be apps that allows people to track mobs and people will say "Hey just like rangers but it skips a step!"

Soon, there will be raid mob alerts, which falls under the tracking thing said above but hey, if an entire guild gets an alert its just like batphoning, just skips a step!

Soon, there will be a LFG app, just because they removed /who all lfg shouldnt bother you all, this just skips steps on sending people tells and asking them if they want to join or not, this just skips more steps, ohohoh and add a "waiting list" feature. you can use your phone, put yourself lfg and you can be playing Skyrim touching yourself to your barbies and you can get a little ring saying "Spot available!"

Soon, there will be a <Dial a Service> app, want clarity for your group in mistmoore? theres an app for that! want rezzes for your group because derp or derp or even herp? theres an app for that!

This shit has got to stop someplace.. but the weird thing is, most of you reading my forecoming doom think its cool, but hey, youll just be playing World of Warcraft with a different skin and thats what we all came here for... right?

Already thought of a LFG app, but I am too lazy :)

iruinedyourday
05-19-2014, 06:05 PM
I would do anything you ask of me.... anything.

Vile
05-19-2014, 06:06 PM
I would do anything you ask of me.... anything.

For a LFG app?

iruinedyourday
05-19-2014, 06:10 PM
For a LFG app?

nope, you already have done enough for me to kill the presedent of the universe for you, should you ask. Thanks for all these awesome things!!!

loramin
05-19-2014, 06:11 PM
Stupid question (I read the whole thread but didn't see an answer): other than a nicer UI, how is this any different from the (long-existing, fairly heavily used) auction forum?

Jauna
05-19-2014, 06:14 PM
I mean really, this is how EQLive went. A few "quality of life" enhancements, a little buff here, a little buff there, skip a few steps here and before ya know it itll be Depths of Darkhallow all over again. You may think you are doing good because you put time and effort into this.. but you will hurt the server and possibly require another dev team out there wanting to re-recreate a classic everquest because of this and future projects you or others create because you cant handle classic EQ.

Vile
05-19-2014, 06:16 PM
Stupid question (I read the whole thread but didn't see an answer): other than a nicer UI, how is this any different from the (long-existing, fairly heavily used) auction forum?

The problem I see with the auction forum:


People sometimes don't list prices
It's hard to search
People's posts aren't always up to date..sometimes when searching for a specific item you find old posts and the person no longer has the item for sale...
Can only put some much info in a post title to get people to check out what you're buying/selling
etc...


EC Tunnel will allow you to keep you wares for WTB/WTS neatly organized and you can search for specific items very quickly unlike the forums here...

Plus as more and more people start using it, I'll be able to gather stats such as average for sale/offered prices, etc...

The big plus is just setting up your lists and having everything neatly organized and searchable while you play some EQ instead of sitting in EC or constantly updating/searching through forum posts..

Vile
05-19-2014, 06:19 PM
I mean really, this is how EQLive went. A few "quality of life" enhancements, a little buff here, a little buff there, skip a few steps here and before ya know it itll be Depths of Darkhallow all over again. You may think you are doing good because you put time and effort into this.. but you will hurt the server and possibly require another dev team out there wanting to re-recreate a classic everquest because of this and future projects you or others create because you cant handle classic EQ.

It's just a nicer, easier to use, trading forum... I don't see the big issue :confused:

Jauna
05-19-2014, 06:22 PM
Stupid question (I read the whole thread but didn't see an answer): other than a nicer UI, how is this any different from the (long-existing, fairly heavily used) auction forum?

Sounds like there is nothing different at all. You post a sale on this app and you are out exping, the buyer has to wait or bring thousands of plat to you. People just like making redundant things, kinda like how people buy one physical copy of a game but download it on Steam a year later because "I dont like CDs"

Splorf22
05-19-2014, 06:24 PM
I added my items. Hopefully this takes off; I am not a tunnel rat!

Suggestions:

1. Clicking on items should bring you to the item page, not the wiki page.

2. The item page should show both WTB and WTS (the spread).

iruinedyourday
05-19-2014, 06:27 PM
I work in game development, and let me tell you reading comments anywhere is always a bad idea once a product is out on the market.... Vile, you are developing software that can ONLY be released, in the comments. So for that you deserve a gold metal. I hope your constitution is as strong as your code!!!! :)

Splorf22
05-19-2014, 06:27 PM
You may think you are doing good because you put time and effort into this.. but you will hurt the server and possibly require another dev team out there wanting to re-recreate a classic everquest because of this and future projects you or others create because you cant handle classic EQ.

This is the silliest strawman I have ever seen. If his next webapp can teleport me around and camp the pained soul for me, then you might have a point.

Jauna
05-19-2014, 06:28 PM
It's just a nicer, easier to use, trading forum... I don't see the big issue :confused:

You dont see the issue because you dont look to foreseeable damage you will do. As a I said, give people an inch, they will take a mile, but instead of walking that mile they will download an app of the mile.

You may start "phasing out" EC much like the Bazaar did years ago, many people may stop haggling, many people may never use EC again and thats the problem and I go back to saying the Devs might as well allow The Bazaar into the game.

You hate selling in EC? Undersell the prices, let them go fast, use the forums here and read your private messages in the morning

iruinedyourday
05-19-2014, 06:34 PM
You dont see the issue because you dont look to foreseeable damage you will do. As a I said, give people an inch, they will take a mile, but instead of walking that mile they will download an app of the mile.

You may start "phasing out" EC much like the Bazaar did years ago, many people may stop haggling, many people may never use EC again and thats the problem and I go back to saying the Devs might as well allow The Bazaar into the game.

You hate selling in EC? Undersell the prices, let them go fast, use the forums here and read your private messages in the morning

why not just replace the forums with this nice clean app... then you'd b e happy, we're all happy (since you seem to think its ok to use the forums).

In theory (not to take away from your effor vile) but this is basically a well organized easier to use forum!

I too hope that the tunnel population doesn't dissipate, but I think its a bit of both here. You seem so dedicated to the tunnel, Juanna, that I Hope you continue to use it! I will visit! I know that others will too...

I agree, anything that damages the social world of norrath should be looked at with an eye of scrutiny but I dont know if Viles work here will necessarily destroy EC. I hope not! I hope it just helps it.

Vile
05-19-2014, 06:34 PM
You dont see the issue because you dont look to foreseeable damage you will do. As a I said, give people an inch, they will take a mile, but instead of walking that mile they will download an app of the mile.

You may start "phasing out" EC much like the Bazaar did years ago, many people may stop haggling, many people may never use EC again and thats the problem and I go back to saying the Devs might as well allow The Bazaar into the game.

You hate selling in EC? Undersell the prices, let them go fast, use the forums here and read your private messages in the morning

I am sorry my web app rustles your jimmies :(

Vile
05-19-2014, 06:35 PM
I added my items. Hopefully this takes off; I am not a tunnel rat!

Suggestions:

1. Clicking on items should bring you to the item page, not the wiki page.

2. The item page should show both WTB and WTS (the spread).

Yea I might do this... and provide wiki link from the item page?

Jauna
05-19-2014, 06:42 PM
why not just replace the forums with this nice clean app... then you'd b e happy, we're all happy (since you seem to think its ok to use the forums).

In theory (not to take away from your effor vile) but this is basically a well organized easier to use forum!

I too hope that the tunnel population doesn't dissipate, but I think its a bit of both here. You seem so dedicated to the tunnel, Juanna, that I Hope you continue to use it! I will visit! I know that others will too...

I agree, anything that damages the social world of norrath should be looked at with an eye of scrutiny but I dont know if Viles work here will necessarily destroy EC. I hope not! I hope it just helps it.

I seen the front page of this, its set up like the Bazaar, you can search for the item name you want, people list the item they want and for the price they want. Turning someone down over a phone is much easier then turning down a live person making "no haggle" situations much easier, specially when you are out exping not giving a shit.

And yes I am dedicated to the tunnel because this is CLASSIC EVERQUEST, yes yes yes you can lie to yourself by saying "Well this thing here and that thing over there is not classic, the rest should not as well", or maybe I should paint a picture for all you Futurama fans out there:

Two gay guys are riding a float screaming at someone else saying "There are parts of the Bible I like and parts I dont like!" and this and the map app reminded me of that scene. EQLive is free to play as well as P99. Stop making P99 more like EQLive just because you dont like some things. this Vile person started off with a Map App, if he kept it to himself or maybe alerted the Devs PRIVATELY and kept it to himself to use that would of been OK because I or others would be unaware of it, but the way people accepted that app just opened a floodgate to other things, like this.

Fysts
05-19-2014, 06:52 PM
I seen the front page of this, its set up like the Bazaar, you can search for the item name you want, people list the item they want and for the price they want. Turning someone down over a phone is much easier then turning down a live person making "no haggle" situations much easier, specially when you are out exping not giving a shit.

And yes I am dedicated to the tunnel because this is CLASSIC EVERQUEST, yes yes yes you can lie to yourself by saying "Well this thing here and that thing over there is not classic, the rest should not as well", or maybe I should paint a picture for all you Futurama fans out there:

Two gay guys are riding a float screaming at someone else saying "There are parts of the Bible I like and parts I dont like!" and this and the map app reminded me of that scene. EQLive is free to play as well as P99. Stop making P99 more like EQLive just because you dont like some things. this Vile person started off with a Map App, if he kept it to himself or maybe alerted the Devs PRIVATELY and kept it to himself to use that would of been OK because I or others would be unaware of it, but the way people accepted that app just opened a floodgate to other things, like this.


I played EQ before Kunark was ever out. Not all servers used EC tunnel just to point out. Some used Kelethin. I will say you must not have been in the technology boom if you honestly believe people did not do massive trading on boards/spreadsheets/websites. It may be a little cleaner app hes using, but its roots are classic as hell. I bought alot of items pre-kunark using forums and trader spreadsheets, sorry you missed the boat on that in 99.

iruinedyourday
05-19-2014, 06:54 PM
as long as Bongs is still hanging out in the tunnel, I am going to be happy.

Jauna
05-19-2014, 06:59 PM
I played EQ before Kunark was ever out. Not all servers used EC tunnel just to point out. Some used Kelethin. I will say you must not have been in the technology boom if you honestly believe people did not do massive trading on boards/spreadsheets/websites. It may be a little cleaner app hes using, but its roots are classic as hell. I bought alot of items pre-kunark using forums and trader spreadsheets, sorry you missed the boat on that in 99.

Sorry but unless you have proof that you did this just sounds like someone willing to let loose even more floodgates to other things to make P99 not P99.

And two, the screenshots on the first page dont look very forum like at all, they look like a Bazaar/auction house type of deal. type in what you are looking for and bam, its there with everything filtered out.

iruinedyourday
05-19-2014, 07:07 PM
I Just want to say, that I stand right between Juana and Vile. I appreciate Viles hard work to make things more usable, but i am thankful that there are people like Juana that are dedicated to keep p99 EQ classic.

Tameth
05-19-2014, 07:47 PM
yeah i've been playing with this, it's great, but I think that you should be able to just search the item, and the results would show wts, wtb, red, blue and have them be sortable by those variables. also no sure on the time you can stay logged in... i left the tab open, came back to it an hour or so later and had to re log in. not that huge of a deal just would be nice to stay permanently logged

Man0warr
05-19-2014, 08:19 PM
Sorry P99 will never be Classic EQ - we all have 15 years of hindsight and technology, and we aren't even using the classic client.

If you are against this app - you should also be against using widescreen LCD's, dual monitors, alt-tabbing, anything but 1024x768 resolution, etc.

Is that how you are playing P99 Jauna?

iruinedyourday
05-19-2014, 08:23 PM
Sorry P99 will never be Classic EQ - we all have 15 years of hindsight and technology, and we aren't even using the classic client.

If you are against this app - you should also be against using widescreen LCD's, dual monitors, alt-tabbing, anything but 1024x768 resolution, etc.

Is that how you are playing P99 Jauna?

hey guys lets not speak in absolutes. Juana has a fair point, the difference between apps that may reduce population of people in EC and playing the game on widescreen monitor is drastic.

The dedication that people have are what make this server great, Viles dedication to tools, jaunas and people like him that are dedicated to not ruining the ascetic of classic eq.

Lets all have a group hug and realize that both are right :)

Man0warr
05-19-2014, 08:33 PM
They are both leveraging technology that has become widespread in the last 15 years to make something easier.

I think EC could do with a population decrease as it is, I mostly use ahungry since at night with 150 people spamming its impossible to parse what's going on.

Glenzig
05-19-2014, 08:36 PM
So I'm guessing Juana doesn't use the p99 wiki. Cause that's not classic. We searched the internets far and wide back in 99-2000 and couldn't find walkthroughs for even half the content on the wiki. Also I'm sure he doesn't use a voice chat program. That's not classic and greatly eases the pain of grouping/raiding. What's next Juana? Are you going to just set up voice commands and tell your computer how to play EQ for you? Keep it classic!!!

Jauna
05-19-2014, 09:35 PM
Sorry P99 will never be Classic EQ - we all have 15 years of hindsight and technology, and we aren't even using the classic client.

If you are against this app - you should also be against using widescreen LCD's, dual monitors, alt-tabbing, anything but 1024x768 resolution, etc.

Is that how you are playing P99 Jauna?

And you are taking trivial things and hitting your keyboard making you think you have a point, but no. And to answer you: I dont have dual monitors, alt-tabbing was introduced in the Velious Era (classic) because listening to downloaded music on Winamp ('membah winamp?) anyways. Back then people used to hack their clients to be able to window out, so they allowed players to do so. also did you know about Alt+K? You got me on the Resolution and widescreen however if it makes you feel better.

And you are right, this is not classic EQ, but two things: its close enough and I would like to keep it close enough because I highly doubt this Auction House/Bazaar App will be the last of it. And if you really want all these "quality of life" things introduced via apps to P99, go check out everquest.com. Shits free as well and you probably have your old characters there. And just because "its not classic enough for me" does not mean you can do everything you can to make it worse.

Jauna
05-19-2014, 09:39 PM
So I'm guessing Juana doesn't use the p99 wiki. Cause that's not classic. We searched the internets far and wide back in 99-2000 and couldn't find walkthroughs for even half the content on the wiki. Also I'm sure he doesn't use a voice chat program. That's not classic and greatly eases the pain of grouping/raiding. What's next Juana? Are you going to just set up voice commands and tell your computer how to play EQ for you? Keep it classic!!!

I remember Allakhazam and EQAtlas always being at my fingertips back in Classic. The reason why we do not use Allas now is because some classic items got updated (kunark class armor) or added new things to old zones.

And did you forget that Roger Wilco was a thing? You could have it run in the backround even when you were unable to Window out

tristantio
05-19-2014, 09:54 PM
Looks awesome, but it'd be nice to have unanchored search results following the anchored ones.

For example, if I type "oracle", I want "Robe of the Oracle" to pop up, without having to lead with "Robe", which then has the pulldown of a ton of Robe of the Something.

Vile
05-19-2014, 10:01 PM
Looks awesome, but it'd be nice to have unanchored search results following the anchored ones.

For example, if I type "oracle", I want "Robe of the Oracle" to pop up, without having to lead with "Robe", which then has the pulldown of a ton of Robe of the Something.

Agreed.

Done -- easy fix :)

tristantio
05-19-2014, 10:03 PM
Now that's agile development! :p

Wiwi
05-19-2014, 10:04 PM
Dude. This is nice. Great job!

I sooooo hate sitting in EC.

Vile
05-19-2014, 10:07 PM
Tonight gonna work on making item pages.

Right now when you search for an item and there is no WTB/WTS nothing pops up.

Now an item page will show, with item stats, link out to wiki and below will list the WTB / WTS.

As more items are added to people's list I will be able to populate average WTB/WTS prices and maybe some other cool stats..

I am thinking of remove the toggles for WTB/WTS and server as well.

We'll see how that goes.. will keep you all posted..

Vile
05-19-2014, 10:08 PM
Also big thanks to tristantio for helping me out.. getting item stats for the tool tips and a great list of classic items to get started :)

Zuranthium
05-19-2014, 10:41 PM
This is perfectly fine because it doesn't break the RPG element of the game. It makes sense that people would post a list of their wares for sale on a town bulletin. It's much different than just turning yourself into a bazaar NPC and going to bed and it does all the work for you and you never communicate or haggle.

Rettj
05-19-2014, 11:05 PM
POWERFUL

Visual
05-20-2014, 12:17 AM
Vile doing god's work

Another Vile server while you're at it

Vile
05-20-2014, 12:54 AM
Update from Red thread...

Something like this probably ain't going to be flooded by auctions given the low population on this server. I am currently in the situation of gearing up a shaman, necro, monk, bard and a warrior. What would be really great for me if if I could make wider searches; ie. entering a partial term such as "loam" to display all loam pieces up for auction, or search for a specific slot. Knowing I need boots for my monk for example I don't want to search through each potential item, possibly forgetting several along the way.

Searching for "loam" will now display items w/ loam in the name or you can use auto complete to search for a specific item.

Right now it only shows current items for sale.. trying to decide if I'd want to display item links for all items linking to their own page...

cowjosh
05-20-2014, 01:58 AM
Having done a fair bit of software development, I truly appreciate the amount of work that has gone into this app and the motivation behind it.

I'm not sure what I think about it.

On the one hand, it isn't "real time" in game, doesn't have the "find trader" option, and does require you to interact with another person, making it far less offensive than bazaar.

On the other hand, haggling, trading, and generally interacting with people was one of my favorite parts of EQ, and one of the things I was most excited about for P99 (sadly, the NFP zone wasn't used, not quite as much nostalgia for EC =p)

I am distrusting of "improvements" that add convenience as others have mentioned, but I think that not everyone will use this (I won't, but good job), and so the net impact on EC population / the ability to trade with people in a "classic" sense won't be too drastically affected.

Here's hoping we aren't leading ourselves down the same road EQLive took.

Thulack
05-20-2014, 10:38 AM
I like it and am using it. I'll also do some promoting while i'm in EC on Bongs for ya :). Keep up the good work.

Vile
05-20-2014, 10:55 AM
Sweet -- thank you everyone.

Been a bit busy with work.. got some minor updates in yesterday.. will be working on how the search displays results when I have some free time.

no chewie dont
05-20-2014, 01:17 PM
I like the way that its helpful without crossing the line into affecting actual gameplay
Choosing to not use this doesnt put you at a disadvantage to a player that does

Vile
05-20-2014, 02:54 PM
Added a bunch of items earlier today and fixed a bug not allowing you to buy an item you were selling -- thanks to Chewie...

Please if you notice any items not in the database you can list them here or PM me.

Please provide items not found in database in this format:
Item name - wiki link
Skull-shaped Barbute - http://wiki.project1999.com/Skull-shaped_Barbute

This will make it easier for me to get the stats and add the item to the DB.

zanderklocke
05-21-2014, 03:26 AM
I'd like to see this stickied on the East Commons section of the forums.

Samhain
05-21-2014, 08:12 AM
Great Tool! I've started populating my WTS List.

Few Suggestions:
-Autopopulate the item is great. Having the newly autopopulated item then provide a link to the Wiki for price check would be awesome to prevent having to type it again in another window.
-Remove the requirement for WTS/WTB. Some may just want to see the market depth of an item.
-Email alerts for new messages?

Vile
05-21-2014, 01:24 PM
Great Tool! I've started populating my WTS List.

Few Suggestions:
-Autopopulate the item is great. Having the newly autopopulated item then provide a link to the Wiki for price check would be awesome to prevent having to type it again in another window.
-Remove the requirement for WTS/WTB. Some may just want to see the market depth of an item.
-Email alerts for new messages?


Yea I have some plans to re-do the search and make it more broad.

For example you search for "Blood Ember"

I'd like to show links for the Blood Ember armor or anything that has text like '%Blood Ember%'

You click Blood Ember Boots -- which will bring you to that item's page.
-stats of the item
-average offer price (WTB)
-average sale price (WTS)
^^^both of these from historical data from EC Tunnel users
-link to p99 wiki for more info...
-WTB/WTS listings for this item if any are availble

And then if you search for an exact item using the autocomplete and look up "Blood Ember Boots" - it will bring you right to that items page (as explained above).


You should be getting email alerts for new messages... I did on the one transaction I completed so far.. can you check your span and let me know?

Messianic
05-21-2014, 02:09 PM
Fantastic.

Vile
05-21-2014, 02:12 PM
Been extremely busy with work that pays the bills.. so some updates will have to wait until I clear up my queue :)

Adding items to the DB is still easy and quick so please PM any items you notice are missing!

Vile
05-21-2014, 10:24 PM
Bump so we don't fall to the second page!

We're up to about 80 registered members... we need more :)

Get your friends, tell your guilds! The more people, the more data.. the more stats to be displayed!

iruinedyourday
05-22-2014, 01:51 AM
buuuuuuuuuuuump stiiiiicky buuuuuuuuuuuuuump

tristantio
05-22-2014, 11:47 AM
Is the database having an issue? No items showing up and my sign in doesn't work

Vile
05-22-2014, 11:52 AM
Is the database having an issue? No items showing up and my sign in doesn't work

Yea, fixing it now :o

Vile
05-22-2014, 11:54 AM
Fixed.. sorry about that

Abrok
05-22-2014, 12:26 PM
Looking to complete my first sale through the site today. I think it'll be a great tool for us folks trying to get rid of cheaper, slower-selling items.

Thanks for the hard work!

tristantio
05-22-2014, 12:30 PM
Please make an update to allow us to search via the following:

http://www.ectunnel.org/search.php?submit=true&item_name=&wtb_wts=2&server=2

Without issue (blank item name) and paginate the results (if too many to list on a page).

It would be nice to be able to openly browse the for sale items (on either server) without specifying a certain item to buy.

For instance, I may want to buy 5 random items from red, but who knows what those 5 may be.

tristantio
05-22-2014, 12:35 PM
Also your page is XSS injectable:

http://www.ectunnel.org/search.php?submit=true&item_name=%22%3EInjectin+your+sites+%3Cimg+src=htt p://ahungry.com/img/logo.png%3E%3C/iframe%3E&wtb_wts=2&server=2

Vile
05-22-2014, 01:13 PM
Also your page is XSS injectable:

http://www.ectunnel.org/search.php?submit=true&item_name=%22%3EInjectin+your+sites+%3Cimg+src=htt p://ahungry.com/img/logo.png%3E%3C/iframe%3E&wtb_wts=2&server=2

Haha awesome... fixed another similar issue earlier this week.. will fix this shortly.

iruinedyourday
05-23-2014, 02:59 AM
Haha awesome... fixed another similar issue earlier this week.. will fix this shortly.

you gona set this bad boy up to be bale to search based on stat/slot?

http://www.nerdtopiacast.com/wp-content/uploads/2012/11/homer-drooling.png

*edit* also every time i serach or mithril I get the seller, 'this isnt classic tho' and I laugh really hard in my head.

Vile
05-23-2014, 10:06 AM
you gona set this bad boy up to be bale to search based on stat/slot?

http://www.nerdtopiacast.com/wp-content/uploads/2012/11/homer-drooling.png

*edit* also every time i serach or mithril I get the seller, 'this isnt classic tho' and I laugh really hard in my head.

Yea there is a lot I want to fix with the search still as I mentioned in some previous posts.. just been slammed with real work this week.

Searching by stat might be a little difficult since I am not storing each stat individually, but might be doable..

tristantio
05-23-2014, 04:56 PM
You can use the advanced search on my auc tracker http://ahungry.com/eqauctions/ to search by stat (if anyone didn't know), then look for the item on ectunnel.org

Vile
05-24-2014, 01:05 PM
There are now "Blue Bazaar" and "Red Bazaar" tabs where you can see all current items listed for that specific server if you want to "browse" and see whats listed..

Currently I am showing 25 items per page, let me know if you guys would want more or less..

The sorting only works on a per page basis right now... and the items are lists in order from newest->oldest.

Vile
05-24-2014, 01:14 PM
Thinking of maybe making sub tabs for specific server WTB/WTS.. will still leave the "global" one too...

citizen1080
05-24-2014, 02:46 PM
Didnt read everypost, but very cool app sir.

My one suggestion would be a similar item window/area when posting WTS.

So if say i want to sell a Fungi and i type it in it will show me what price that item is listed at by other people currently so i know how much to ask.

Olizadebe
05-26-2014, 03:47 PM
Really neat! Well done!

Vile
05-29-2014, 11:47 AM
bump..

I created some new "bazaar" views.. can see everything listed under either Blue or Red. You can also see all WTB or WTS items listed for each server.

I will hopefully be working on the search this week and creating item pages..

tristantio
05-29-2014, 12:25 PM
When someone messages (I received one this weekend) you should also include what they messaged in the email body (similar to what this forum does for notifying of subscribed threads new posts) so with a quick email scan I can see what the person said.

Also, following the link from email to the site automatically says "Login Failed", when it should probably say Please Login or something (since at that point I hadn't even attempted to sign in).

zanderklocke
05-30-2014, 05:10 PM
Moving this to the top. Need more sellers and buyers.

Vile
05-31-2014, 01:02 PM
Time to reactivate your items!

Had a mistake in my cron job and it finally ran properly today. If your items were listed more than 10 days ago you should've received an email and you will need to reactivate your items if you want them to show up in the searches.

Vile
05-31-2014, 01:03 PM
When someone messages (I received one this weekend) you should also include what they messaged in the email body (similar to what this forum does for notifying of subscribed threads new posts) so with a quick email scan I can see what the person said.

Also, following the link from email to the site automatically says "Login Failed", when it should probably say Please Login or something (since at that point I hadn't even attempted to sign in).

My thought was to make them visit the site, but I guess either way they would have to, to respond back. Should be easy to the message text to the email..

Fixing #2 :)

Vile
06-01-2014, 11:48 AM
Fixed a bug when you reactivate an item. It wasn't setting the new date to be checked..

tanknspank
06-01-2014, 08:29 PM
I would suggest changing the list to have drop-down at the top for Both/Blue/Red and All/WTS/WTB on the homepage, then making the values be stored in cookies so it'll show the same things by default the next time. For example I am largely interested in blue WTS, and sometimes WTB, but never red.

I'd also like to see the item link going to a history of the item on ectunnel (current listings + past listings w/ # of messages) and having the wiki instead on an icon after the name

Awesome app however. I'm going to start listing some things too

mipstien
06-11-2014, 09:26 AM
I like this idea we just need more people using it. Maybe somehow get it to integrate with the forum ec. Probably not possible but an idea.

Nirgon
06-11-2014, 10:00 AM
Gr8 beta so far. My favorite part is how he actually started working on it when he said he was working on it and not just starting right now.

Forumquest Chairman Vile is someone I can trust.

stakha
06-11-2014, 05:43 PM
I'd like to use it more frequently, but very few are posting wares at the moment. Great idea.

Olizadebe
06-11-2014, 07:54 PM
The REAL trick would be integrating this with ahungry somehow.

iruinedyourday
06-11-2014, 08:07 PM
The REAL trick would be integrating this with ahungry somehow.

I do like ahungry, alot.

https://dl.dropboxusercontent.com/u/25736152/EQ/ahungryalot.gif

tristantio
06-11-2014, 09:56 PM
I'm always happy to integrate/crossover with anything (on any of my projects/utils really).

If ectunnel.org could slightly update the messaging system from this current format:

http://ectunnel.org/message.php?trade=104

To something like:

http://ectunnel.org/message.php?recipient=Anakarias&item=Tasliman+of+the+Cat

It would be easy for me to modify Ahungry so you could right click on an item link (left click opens wiki right now) and pop open an URL to the ECTunnel site, which would essentially have the message box to the desired user popped up.

Then, if ECTunnel had a queue system, where users who are not currently registered could receive messages, and then as soon as they signed up, be given all the queued messages, it wouldn't matter if users did not currently have an account registered.

I have a nightly dump of the /auc logs available (given to a few people who wanted to try to integrate so far) and the URLs for items/searches are pretty API friendly as well (for live querying vs my site), so anyone is welcome to tap in/integrate.

Thoughts?

tanknspank
06-13-2014, 07:26 PM
http://wiki.project1999.com/Skull_of_Jhen%60Tra is not found when trying to sell it

Clark
06-13-2014, 07:28 PM
Gr8 beta so far. My favorite part is how he actually started working on it when he said he was working on it and not just starting right now.

Forumquest Chairman Vile is someone I can trust.

talian21
07-27-2014, 01:52 PM
I appreciate your work, but it seems that you are reinventing the wheel, I still do not see anything here that is not already being serviced equally well, by the EC tunnel forum. You make ppl sign up, you make ppl manually update their stuff, which means you provide no value that does not already exist, (and yet another user-pass to remember/another thing to sign up for). I'm sorry, but I see no value added here, best of luck.

On the flip side, ahungry is an excellent example of added value: without creating any more work for anyone, without anything to manually maintain/sign up for/etc, he has given us a near real time way to look at EC w/o having to be in EC. Your designer was correct, keep it simple stupid. You are reinventing the wheel, no offense.

zanderklocke
07-27-2014, 02:57 PM
I appreciate your work, but it seems that you are reinventing the wheel, I still do not see anything here that is not already being serviced equally well, by the EC tunnel forum. You make ppl sign up, you make ppl manually update their stuff, which means you provide no value that does not already exist, (and yet another user-pass to remember/another thing to sign up for). I'm sorry, but I see no value added here, best of luck.

On the flip side, ahungry is an excellent example of added value: without creating any more work for anyone, without anything to manually maintain/sign up for/etc, he has given us a near real time way to look at EC w/o having to be in EC. Your designer was correct, keep it simple stupid. You are reinventing the wheel, no offense.

Searching for items on the forums does not work nearly as well. You get a list of threads, and sometimes they are for PVP server or not even really related to the item you are looking for. The search functionality is what makes this nice.

The ahungry tracker works well for seeing what's been auctioned in the last few weeks or so, but that still doesn't work super well, as you can't message the person selling or buying an item if they auctioned in EC a week ago.

I think this site finds a niche in its ability to fill the gaps in all the other selling/buying places. However, unfortunately, it isn't as widely used.