Author Topic: Ragial Discussion v2  (Read 55567 times)

Offline Dishonru

  • what
  • Hero Member
  • *****
  • Posts: 2266
    • View Profile
    • http://ragial.com
Ragial Discussion v2
« on: March 17, 2011, 11:15:57 PM »
What is Ragial?
Ragial is an iRO market site that contains live vending information and market history.

What is this thread for?
  • Bug reports
  • Complaints
  • Discussion
  • Questions
  • Suggestions


Ragial now supports all iRO servers and non-iRO servers
If you would like your official server included on the ragial site send me a pm or post here.  I might even be able to have the item database/site layout be in the server's native language.

FAQ
--

[Q] How does the site get its information?
[A] A bot goes through town and submits information to the site.  The site then parses the information and takes appropriate action.  

[Q] Has the bot ever been banned?
[A] The bot only walks through prontera for a brief period of time.  It never kills any monsters, loots items, or interacts with the player base in any noticeable way.  

[Q] How come my vend isn't listed?
[A] The bot does not browse all of Prontera.  It only browses around the fountain, down the main path, and by the park benches.  Occasionally the site misses a vend or two.  There is also a delay of up to twenty minutes between when you put up a vend and when the site sees it.

[Q] How come the new site took so long?
[A] Ragial is quite a bit more complicated than most people realize.  Ragial currently has ~12 tables per server, ~6 tables for other things, and over 1.4gb of data tracking ~3 years of valkyrie's market and Ymir since its creation.  The size of the new site's back-end code is 108kb when compressed, and that doesn't count the plugins for the bot or other scripts I have written by hand.

Rewriting everything from scratch was a daunting task.  There are scripts to extract information from the client, scripts to convert images from the client to proper format, and scripts to handle a lot of the database maintenance.  The update script on the server alone is ~600 lines of code.  On top of all this, the SQL queries required to perform all of this efficiently take considerable planning as well as testing.  A single poorly indexed (or non-indexed) query on the item tables for a given server, with over 1.4million entries in some of the tables used, will murder the site's performance.

 I did go months at a time without working on it, but even if I treated the site as a full time job it would have taken over a month of development effort. I'm also lazy

--

Old Thread


KNOWN BUGS
-None at this time
« Last Edit: February 18, 2012, 02:24:06 PM by Dishonru »

Offline Abby

  • bread dog Friday
  • Hero Member
  • *****
  • Posts: 1557
    • View Profile
Re: Ragial Discussion v2
« Reply #1 on: March 17, 2011, 11:52:03 PM »
Maybe you should ask some questions about people's opinions on the new site.



Offline Dishonru

  • what
  • Hero Member
  • *****
  • Posts: 2266
    • View Profile
    • http://ragial.com
Re: Ragial Discussion v2
« Reply #2 on: March 17, 2011, 11:52:22 PM »
old
« Last Edit: September 17, 2012, 07:07:53 AM by Dishonru »

Offline Kalashnikov

  • Sr. Member
  • ****
  • Posts: 445
    • View Profile
Re: Ragial Discussion v2
« Reply #3 on: March 17, 2011, 11:57:28 PM »
1) Please, YES!

2) I don't understand this. Which colors? On the price?
iRO Ymir: MetaI Gear [Retired]



Offline Rutana

  • Sr. Member
  • ****
  • Posts: 439
    • View Profile
    • http://rutana.deviantart.com
Re: Ragial Discussion v2
« Reply #4 on: March 18, 2011, 12:01:25 AM »
I would say "yes!" to the first, and "no" to the second.
The % always were a nice help, exspecially if you're unsure about the price.
The second one, I guess, is that you regist buying-shop's now?
I would definatly indicate them with another color, maybe even an extra section, so that you don't mix them up...

Knight-Chibis made by Wakaba ~ Marshmallow made by Belijaal

Offline Dishonru

  • what
  • Hero Member
  • *****
  • Posts: 2266
    • View Profile
    • http://ragial.com
Re: Ragial Discussion v2
« Reply #5 on: March 18, 2011, 12:03:53 AM »
Quote from: Rutana;1050370
I would say "yes!" to the first, and "no" to the second.
The % always were a nice help, exspecially if you're unsure about the price.
The second one, I guess, is that you regist buying-shop's now?
I would definatly indicate them with another color, maybe even an extra section, so that you don't mix them up...
Look at the site for the buy thing. They are very separate.

What I mean by #2 is currently on vends green=cheap, red=expensive

On buys red="buying low" and green="buying high" (the opposite)

The basic idea behind the current scheme is green=good, red=bad.
« Last Edit: March 18, 2011, 12:12:08 AM by Dishonru »

Offline Kalashnikov

  • Sr. Member
  • ****
  • Posts: 445
    • View Profile
Re: Ragial Discussion v2
« Reply #6 on: March 18, 2011, 12:22:49 AM »
Oh now i get it.
I loved the %, it was more useful.
iRO Ymir: MetaI Gear [Retired]



Offline Dishonru

  • what
  • Hero Member
  • *****
  • Posts: 2266
    • View Profile
    • http://ragial.com
Re: Ragial Discussion v2
« Reply #7 on: March 18, 2011, 12:52:25 AM »
Quote from: Kalashnikov;1050381
Oh now i get it.
I loved the %, it was more useful.
I'll probably add it in tomorrow.  Other people I have asked have been neutral or want it back.

It's still in the database. It just isn't showing. :)
« Last Edit: March 18, 2011, 01:20:42 AM by Dishonru »

Offline Sarune

  • Hero Member
  • *****
  • Posts: 1307
    • View Profile
Re: Ragial Discussion v2
« Reply #8 on: March 18, 2011, 01:57:22 AM »
It seems you can no longer look up numbers. I was able to look up +7 items and such.

Offline Dishonru

  • what
  • Hero Member
  • *****
  • Posts: 2266
    • View Profile
    • http://ragial.com
Re: Ragial Discussion v2
« Reply #9 on: March 18, 2011, 02:26:05 AM »
Quote from: Sarune;1050412
It seems you can no longer look up numbers. I was able to look up +7 items and such.
I just changed it so you can search for only +x or [1]or whatever now.

Before this change you had to do +7 and a 3 letter or more word.
« Last Edit: March 18, 2011, 02:32:07 AM by Dishonru »

Offline Sarune

  • Hero Member
  • *****
  • Posts: 1307
    • View Profile
Re: Ragial Discussion v2
« Reply #10 on: March 18, 2011, 02:30:57 AM »
It works now. Thanks. :)

Offline Golden Fingers

  • Hero Member
  • *****
  • Posts: 4363
    • View Profile
Re: Ragial Discussion v2
« Reply #11 on: March 18, 2011, 05:14:15 AM »
I'm glad the vendors have been removed from the 'recently viewed' list, I always ended up with a "last 10" vendors list rather than items heh.
 
It would be neat if there was a X box or something you could click to remove an item from recently viewed but yeah really liking the new layout
IGN: Hrothmund, Priest\'o\'Matic

Offline Soudou

  • Sr. Member
  • ****
  • Posts: 478
    • View Profile
Re: Ragial Discussion v2
« Reply #12 on: March 18, 2011, 07:42:01 AM »
1) % would be good to have back.

2) I think if they are buying for less than average sale price then Red and if buying at average sale price or above then Green. Though so far I only ever see people using Buy shops to buy way under the average sale price so I guess they'll always be Red... When %s are back at least we can more easily see how far under average sale price they are. Could do orange for only slightly under if red vs green is too stark.
Level 114/36 Battle Archbishop :gawi:
Level 8x Experimental Battle Priest :?:
Level 9x Falconer Hunter  :ho:

Offline Wylnir

  • Jr. Member
  • **
  • Posts: 85
    • View Profile
Re: Ragial Discussion v2
« Reply #13 on: March 18, 2011, 08:34:16 AM »
It's possible to list all the items in vend? Before the update, Ragial listed all the items when I search " " (space) in the search bar and I would like it to be back.
- Renewal - Valkyrie:
Sophii - Sura 150/50
Sopi - Warlock 150/50
Sopii - Sorcerer 150/50
Kyslia - Rune Knight 150/50
Yraisu - FS Female Arch Bishop 14x/4x

Offline Dishonru

  • what
  • Hero Member
  • *****
  • Posts: 2266
    • View Profile
    • http://ragial.com
Re: Ragial Discussion v2
« Reply #14 on: March 18, 2011, 12:11:34 PM »
There's a shops page if anyone cares. I personally think it is useless, even if I made it paged.

There's also a buying history if you swap "/item/" in an item history url with "/btem", example.  I couldn't come up with anything useful to use buy history for besides showing it on the item average page for appropriate items.
Quote from: Wylnir;1050512
It's possible to list all the items in vend? Before the update, Ragial listed all the items when I search " " (space) in the search bar and I would like it to be back.
You can browse through cheap or buying to see all the items on vend and buy respectively.

I'll add a page that lists vended items in a better browsing order.

Edit: vending is up now.  You can see it linked just above the main area "Buying - Cheap - Vending"
« Last Edit: March 18, 2011, 01:38:25 PM by Dishonru »