It is currently Thu Oct 19, 2017 5:27 pm

All times are UTC [ DST ]




 Page 1 of 1 [ 8 posts ] 
Author Message
 Post subject: A Community editable/searchable loot list on the site
PostPosted: Sun Jun 17, 2012 12:04 pm 
The Almighty
The Almighty
User avatar

Joined: Tue Apr 13, 2010 5:45 pm
Posts: 4827
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
Offline
 Profile  
 
 Post subject: Re: A Community editable/searchable loot list on the site
PostPosted: Sun Jun 17, 2012 12:35 pm 
Captain General
Captain General

Joined: Sun Feb 20, 2011 6:05 pm
Posts: 1079
Location: Liverpool/Sutton
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
Offline
 Profile  
 
 Post subject: Re: A Community editable/searchable loot list on the site
PostPosted: Sun Jun 17, 2012 3:20 pm 
Guardsman
Guardsman

Joined: Sun Feb 19, 2012 5:22 pm
Posts: 89
Am willing to help :)



_________________
Durgaren - Hunter 75
Yrdur - Guardian 75
Thupo - Minstrel 75
Offline
 Profile  
 
 Post subject: Re: A Community editable/searchable loot list on the site
PostPosted: Sun Jun 17, 2012 3:36 pm 
RIVEN!!!
RIVEN!!!
User avatar

Joined: Mon Sep 26, 2011 12:05 pm
Posts: 1340
Sounds like a plan, let me know if you need me


Offline
 Profile  
 
 Post subject: Re: A Community editable/searchable loot list on the site
PostPosted: Sun Jun 17, 2012 3:54 pm 
Master Guardsman
Master Guardsman
User avatar

Joined: Sun Jul 24, 2011 4:05 pm
Posts: 266
goes for me to. any help i can give just ask


Offline
 Profile  
 
 Post subject: Re: A Community editable/searchable loot list on the site
PostPosted: Sun Jun 17, 2012 5:35 pm 
First Marshall
First Marshall
User avatar

Joined: Mon Apr 18, 2011 9:01 pm
Posts: 926
Location: Finland
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 :)
Offline
 Profile  
 
 Post subject: Re: A Community editable/searchable loot list on the site
PostPosted: Sun Jun 17, 2012 5:48 pm 
Danger Mouse
Danger Mouse

Joined: Fri Feb 04, 2011 10:29 am
Posts: 1484
Location: Neamt, Romania
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
Offline
 Profile  
 
 Post subject: Re: A Community editable/searchable loot list on the site
PostPosted: Sun Jun 17, 2012 10:29 pm 
The Almighty
The Almighty
User avatar

Joined: Tue Apr 13, 2010 5:45 pm
Posts: 4827
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
Offline
 Profile  
 
Display posts from previous:  Sort by  
 Page 1 of 1 [ 8 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: