Poll: Would you like to see a searchable vendor item database on the site? - You do not have permission to vote in this poll.
Yes.
94.59%
35
94.59%
No.
5.41%
2
5.41%
* You voted for this item. Show Results

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5

Web-Based Player Vendor Tracking and Item Finding
#19

Nasir Wrote:I built a proof of concept for this a long time ago if you're interested in talking about where I went with it. My biggest tip is DO NOT use an external database. There's no need for that and all you'll run into is syncing issues when there are server crashes and what not. Just set up a json endpoint within the RunUO server and communicate that way.

Exactly. The data is already available (in memory) so there's no need to also store it in a database that would require a db hit anytime someone hits the page (if some type of caching strategy isn't used). Not taking into account sync issues due to server crashes, but just the fact that whenever items are bought/placed/removed/modified you would need to update the database to reflect this or have a cron task that runs to do it (and then potentially having stale data).

Set up a service within the server that exposes the data in json and have some javascript on the client that pulls it and formats it into some searchable grid/list/table to view. It doesn't have to be pretty, just functional. I think displaying items and allowing searching would be a great first goal.


Messages In This Thread
Web-Based Player Vendor Tracking and Item Finding - by Eru - 02-04-2012, 07:35 AM
Web-Based Player Vendor Tracking and Item Finding - by Atlas - 02-04-2012, 11:30 AM
Web-Based Player Vendor Tracking and Item Finding - by Habibi Jones - 02-04-2012, 06:50 PM
Web-Based Player Vendor Tracking and Item Finding - by Taran - 02-04-2012, 07:23 PM
Web-Based Player Vendor Tracking and Item Finding - by Doc - 02-04-2012, 08:34 PM
Web-Based Player Vendor Tracking and Item Finding - by Althos - 02-04-2012, 11:15 PM
Web-Based Player Vendor Tracking and Item Finding - by Raziel_ - 02-07-2012, 05:09 PM
Web-Based Player Vendor Tracking and Item Finding - by Eru - 02-07-2012, 07:09 PM
Web-Based Player Vendor Tracking and Item Finding - by Taran - 02-07-2012, 09:41 PM
Web-Based Player Vendor Tracking and Item Finding - by Eru - 02-08-2012, 02:14 AM
Web-Based Player Vendor Tracking and Item Finding - by Raziel_ - 02-08-2012, 02:32 AM
Web-Based Player Vendor Tracking and Item Finding - by Taran - 02-08-2012, 07:15 AM
Web-Based Player Vendor Tracking and Item Finding - by Eru - 02-08-2012, 07:34 AM
Web-Based Player Vendor Tracking and Item Finding - by soMa - 02-08-2012, 12:30 PM
Web-Based Player Vendor Tracking and Item Finding - by soMa - 02-08-2012, 01:10 PM
Web-Based Player Vendor Tracking and Item Finding - by stonychavez - 02-08-2012, 01:33 PM
Web-Based Player Vendor Tracking and Item Finding - by Taran - 02-08-2012, 01:36 PM
Web-Based Player Vendor Tracking and Item Finding - by Nasir - 02-11-2012, 09:12 AM
Web-Based Player Vendor Tracking and Item Finding - by Rob - 02-12-2012, 05:13 PM
Web-Based Player Vendor Tracking and Item Finding - by Eru - 02-12-2012, 08:22 PM
Web-Based Player Vendor Tracking and Item Finding - by Nasir - 02-12-2012, 08:22 PM
Web-Based Player Vendor Tracking and Item Finding - by Nasir - 02-12-2012, 08:26 PM
Web-Based Player Vendor Tracking and Item Finding - by Taran - 02-12-2012, 10:14 PM
Web-Based Player Vendor Tracking and Item Finding - by Rob - 02-12-2012, 10:20 PM
Web-Based Player Vendor Tracking and Item Finding - by Taran - 02-12-2012, 10:22 PM
Web-Based Player Vendor Tracking and Item Finding - by Eru - 02-13-2012, 03:20 AM
Web-Based Player Vendor Tracking and Item Finding - by David - 02-13-2012, 04:22 PM
Web-Based Player Vendor Tracking and Item Finding - by hilbertsawhat - 02-13-2012, 11:25 PM
Web-Based Player Vendor Tracking and Item Finding - by Nasir - 02-15-2012, 02:58 AM
Web-Based Player Vendor Tracking and Item Finding - by Eru - 02-15-2012, 04:03 AM
Web-Based Player Vendor Tracking and Item Finding - by hilbertsawhat - 02-15-2012, 12:03 PM
Web-Based Player Vendor Tracking and Item Finding - by Rob - 02-15-2012, 05:17 PM
Web-Based Player Vendor Tracking and Item Finding - by Nasir - 02-15-2012, 06:27 PM
Web-Based Player Vendor Tracking and Item Finding - by Eru - 02-15-2012, 07:26 PM
Web-Based Player Vendor Tracking and Item Finding - by Nasir - 02-15-2012, 07:36 PM
Web-Based Player Vendor Tracking and Item Finding - by Raziel_ - 02-16-2012, 03:38 PM
Web-Based Player Vendor Tracking and Item Finding - by Nasir - 02-16-2012, 07:08 PM
Web-Based Player Vendor Tracking and Item Finding - by Rob - 02-16-2012, 08:53 PM
Web-Based Player Vendor Tracking and Item Finding - by Nasir - 02-16-2012, 09:05 PM
Web-Based Player Vendor Tracking and Item Finding - by Exanimus - 03-01-2012, 05:14 PM
Web-Based Player Vendor Tracking and Item Finding - by Nasir - 03-01-2012, 06:17 PM
Web-Based Player Vendor Tracking and Item Finding - by hilbertsawhat - 03-01-2012, 08:26 PM
Web-Based Player Vendor Tracking and Item Finding - by Nasir - 03-01-2012, 10:23 PM
Web-Based Player Vendor Tracking and Item Finding - by Rob - 03-02-2012, 01:37 AM
Web-Based Player Vendor Tracking and Item Finding - by Rob - 03-02-2012, 01:40 AM
Web-Based Player Vendor Tracking and Item Finding - by hilbertsawhat - 03-02-2012, 02:02 AM
Web-Based Player Vendor Tracking and Item Finding - by Nasir - 03-02-2012, 03:38 AM
Web-Based Player Vendor Tracking and Item Finding - by Ramza - 03-02-2012, 04:32 AM
Web-Based Player Vendor Tracking and Item Finding - by Exanimus - 03-02-2012, 04:56 AM
Web-Based Player Vendor Tracking and Item Finding - by Nasir - 03-02-2012, 05:22 AM
Web-Based Player Vendor Tracking and Item Finding - by Rob - 03-02-2012, 05:51 AM
Web-Based Player Vendor Tracking and Item Finding - by Rob - 03-02-2012, 09:10 PM
Web-Based Player Vendor Tracking and Item Finding - by Eru - 03-02-2012, 10:36 PM
Web-Based Player Vendor Tracking and Item Finding - by Ramza - 03-03-2012, 12:34 AM
Web-Based Player Vendor Tracking and Item Finding - by Rob - 03-03-2012, 04:55 AM

Forum Jump:


Users browsing this thread: 20 Guest(s)