VKontakte.DJ
forum traveling
Welcome, Guest
Please Login or Register.    Lost Password?
Re:What do we want the website to do? (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: Re:What do we want the website to do?
#11778
Re:What do we want the website to do? 5 Years, 4 Months ago Karma: 26  
mickjones wrote:
Hi,

For some while now I've been working on a web based battleboard which is now coming along nicely, although not particularly speedily (as part time projects often do).

One lengthy part of it has been to load all the skill, spell and invocation lists into a database so they are more manageable. I kind of image that down the line this could be exposed by a web service (to be consumed on the main site) with a central point of admin.


The skills and spells/invocations are already loaded into the database on this website, these webpages on the site are generated from the data in the database.

SQL query: SELECT skills_id, skill_name, href_tag, costs, status, prerequisites, description FROM `hq_skills` LIMIT 1

1
Additional Dexterity
_additional_dexterity
One Status, Character points for rank of dexterity
1
16 Points of <A HREF="#_unarmoured_dexterity">Unarmoured Dexterity</A> <I>or</I> 8 Points of <A HREF="#_armoured_dexterity">Armoured Dexterity</A>
This skill allows the character to purchase <U>one</U> additional point of dexterity beyond the normal maximum (16 points of unarmoured dexterity, 8 points of armoured dexterity). This additional point of dexterity must be paid for with character points as normal. Thus a character with this skill could have a maximum of 17 points of unarmoured dexterity or 9 points of armoured dexterity.

SELECT casting_id, spell_name, href_tag, range, duration, extendable, description, spell_type, sphere, specialist FROM `hq_casting` LIMIT 0, 1 ;

190
Affinity to Darkness 9 - 10
affinitydarkness
Self Only
Special N/A
The caster binds their Darkness into themselves su...
M
NA
0

SELECT guild_id, guild_name, guild_leader, asst_leader, administrator, guild_type FROM `hq_guild` LIMIT 0, 2 ;

1
Black School of Magic
Eremor Shaderiver
Malrin Thornblade
Rakor Sunveil
Magic
2
Red School of Magic
Lightfoot Flame
Gilrain Hardwicke
Dabuler Torch
Magic

SQL query: SELECT guild_cast_id, guild_id, casting_id FROM `hq_guild_casting` LIMIT 0, 2 ;


1, 1, 190
2, 1, 191
(these are foreign ids linking guild table to casting table)

Not much scripting would be needed to extract the skills table into something a little better. There are other relevant tables too, but I have not bothered to copy these in here.

There is also a character database, keyed off character_id. I can send you the schema if you like, or sounds like it would be better if you simply had access to the database management section of the website.
sarahb (Admin)
null
Moderator
Posts: 1758
graph
User Offline Click here to see the profile of this user
null null null null null null Location: null
Logged Logged  
 
Last Edit: 2012/08/06 07:44 By sarahb.
 
The administrator has disabled public write access.  
      Topics Author Date
 
What do we want the website to do?
petesutton 2012/07/23 20:12
 
thread linkthread link Re:What do we want the website to do?
faybe 2012/07/24 11:41
 
thread linkthread link Re:What do we want the website to do?
mbt 2012/07/25 09:32
 
thread linkthread linkthread link Re:What do we want the website to do?
petesutton 2012/07/25 10:29
 
thread linkthread link Re:What do we want the website to do?
mbt 2012/07/25 11:32
 
thread linkthread link Re:What do we want the website to do?
faybe 2012/07/25 15:32
 
thread linkthread link Re:What do we want the website to do?
faybe 2012/07/26 22:43
 
thread linkthread link Re:What do we want the website to do?
mickjones 2012/08/05 20:49
 
thread linkthread linkthread link Re:What do we want the website to do?
mickjones 2012/08/05 20:50
 
thread linkthread linkthread link Re:What do we want the website to do?
sarahb 2012/08/06 07:41
Go to top

Have you noticed a problem with this website? If so, please e-mail one of our web team, who will fix it
admin@heroquest-larp.co.uk

© Copyright 2009-2014, All Rights Reserved