A Community editable/searchable loot list on the site

Any ideas or suggestions you have for the kin.
Post Reply
User avatar
Balthelion
The Almighty
The Almighty
Posts: 4831
Joined: Tue Apr 13, 2010 5:45 pm

A Community editable/searchable loot list on the site

Post by Balthelion » Sun Jun 17, 2012 12:04 pm

OK, so this is something i've been thinking about for a long while (and then going :? at the effort it will take to implement)

Basically, we all love our loot lists in the kin when new content comes out. So does the community, as they tend to flood the site with traffic in order to reach them when new content comes out (It actually resulted in a few days of website downtime with Rise of Isengard as we exceeded our traffic limit - The RoI loot list has had 50,000 visits!!!)

As you can imagine, it takes quite a bit of effort on my part to compile all the submission data, get it in a spreadsheet and format it all etc. So i had the though of making an automated system on the site for it.

ANYONE who is registered on the site can submit the stats of a new item. This will include all the usual info, such as stats, instance, boss, tier etc. Submited items will then be held in a pool of "unapproved" (or "unpublished") items waiting to be edited/confirmed by me (or perhaps officers). Or deleted, in the case of duplicates.

Once approved, the items are then published in the database. Items can then be searched using an extensive search tool, where you can specify any or all of the following search terms
  • Instance
  • Item Level
  • Specific Item Name (or part thereof)
  • Item type (eg: "Armour: Heavy Helm" or "Jewellery: Wrist
  • Stat 1 (Greater than, equal to, or less then a specified number)
  • Stat 2 (Greater than, equal to, or less then a specified number)
  • Stat 3 (Greater than, equal to, or less then a specified number)

For those who would list to ninja the data and play around with it in excel or something, i will provide a way to grab all the info in a CSV (Comma Separated Values) format dump, which anyone with moderate excel skills can use to almost instantly have a formatted sppreadsheet up and running, without me needing to constantly update one myself for others to download.

Thoughts / Comments / Questions on anything that's unclear?
Image
GW2: Taikken ~ Vasuuki ~ Artuura
EVE: Marcus Rushe
SW:TOR: Tannik ~ Celandra ~ Korrun
League | Steam | Minecraft: LeoxStryker

Grim
Captain General
Captain General
Posts: 1079
Joined: Sun Feb 20, 2011 6:05 pm
Location: Liverpool/Sutton

Re: A Community editable/searchable loot list on the site

Post by Grim » Sun Jun 17, 2012 12:35 pm

Sounds awesome and would definitely reinforce our image as the place to go for loot lists! Sounds like a lot of work though, let me know if theres anything I can do to help
Grimhelmd - 75 Guardian
Turrion - 75 Captain
Tergon - 75 Loremaster
Terrann - 20 Warden
Grimthryd - 20 Champion
Grimharl - 9 Minstrel
Grimfoil - 1 Burglar

Durgaren
Guardsman
Guardsman
Posts: 89
Joined: Sun Feb 19, 2012 5:22 pm

Re: A Community editable/searchable loot list on the site

Post by Durgaren » Sun Jun 17, 2012 3:20 pm

Am willing to help :)
Durgaren - Hunter 75
Yrdur - Guardian 75
Thupo - Minstrel 75

User avatar
Hal
RIVEN!!!
RIVEN!!!
Posts: 1340
Joined: Mon Sep 26, 2011 12:05 pm

Re: A Community editable/searchable loot list on the site

Post by Hal » Sun Jun 17, 2012 3:36 pm

Sounds like a plan, let me know if you need me

User avatar
Bullett
Master Guardsman
Master Guardsman
Posts: 266
Joined: Sun Jul 24, 2011 4:05 pm

Re: A Community editable/searchable loot list on the site

Post by Bullett » Sun Jun 17, 2012 3:54 pm

goes for me to. any help i can give just ask

User avatar
Netham
First Marshall
First Marshall
Posts: 926
Joined: Mon Apr 18, 2011 9:01 pm
Location: Finland

Re: A Community editable/searchable loot list on the site

Post by Netham » Sun Jun 17, 2012 5:35 pm

Sounds great man. I hope everyone contributes to it to keep it up-to-date all the time with future stuff. :)
All the Neth chars in kin except Nethoss :)

andrac
Danger Mouse
Danger Mouse
Posts: 1484
Joined: Fri Feb 04, 2011 10:29 am
Location: Neamt, Romania

Re: A Community editable/searchable loot list on the site

Post by andrac » Sun Jun 17, 2012 5:48 pm

yes. yes ;)
Andracy - Mins 100 (tailor) | Andrady - RK 100 (scholar) | Andracya - Burg 100 (weaponsmith) | Andrac - Hunt 100 (woodworker) | Gabytza LM 100 (jeweller) | Anduta - Warden 100 (jeweller)

Image
Image

User avatar
Balthelion
The Almighty
The Almighty
Posts: 4831
Joined: Tue Apr 13, 2010 5:45 pm

Re: A Community editable/searchable loot list on the site

Post by Balthelion » Sun Jun 17, 2012 10:29 pm

Looks like this will be the lynchpin of the website's "Rohan Expansion" :mrgreen:
Assuming I can motivate myself to do it...

Will need to finalise the new web design before i set about doing the technical coding though...
Image
GW2: Taikken ~ Vasuuki ~ Artuura
EVE: Marcus Rushe
SW:TOR: Tannik ~ Celandra ~ Korrun
League | Steam | Minecraft: LeoxStryker

Post Reply