Stuff

Todo--- Detailed info's globally- Restricted weapon classes & armour classes per race/class- Size modifiers for races- Can you just write out other class/race specific modifiers that should be included, im not sure how to implement them yet- A few armour itemsDROP TABLE IF EXISTS `characters`;DROP TABLE IF EXISTS `class`;DROP TABLE IF EXISTS `race`;DROP TABLE IF EXISTS `area`;DROP TABLE IF EXISTS `spellbook`;DROP TABLE IF EXISTS `route`;DROP TABLE IF EXISTS `itemseeds`;DROP TABLE IF EXISTS `items`;DROP TABLE IF EXISTS `info`;DROP TABLE IF EXISTS `alignment`;DROP TABLE IF EXISTS `feats`;CREATE TABLE `characters` (	`id` INTEGER PRIMARY KEY,	`name` VARCHAR,	`pass` VARCHAR,		`race` INTEGER,	`class` INTEGER,	`gender` VARCHAR,	`alignment` INTEGER,	`weight` INTEGER,	`height` INTEGER,	`age` INTEGER,		`INT` INTEGER,	`CON` INTEGER,	`STR` INTEGER,	`DEX` INTEGER,	`WIS` INTEGER,	`CHA` INTEGER		`location` INTEGER,		`exp` INTEGER,	`lvl` INTEGER,	`skillpnts` INTEGER,);CREATE TABLE `class` (	`id` INTEGER PRIMARY KEY,	`name` VARCHAR,	`spells` VARCHAR,	`casts` VARCHAR,	`attrs` VARCHAR);CREATE TABLE `race` (	`id` INTEGER PRIMARY KEY,	`name` VARCHAR,	`attrs` VARCHAR);CREATE TABLE `area` (	`id` INTEGER PRIMARY KEY,	`name` VARCHAR,		`type` VARCHAR,	`attrs` VARCHAR);CREATE TABLE `feats` (	`id` INTEGER PRIMARY KEY,	`name` VARCHAR,        `requirements` VARCHAR,		`attrs` VARCHAR,);CREATE TABLE `info` (	`id` INTEGER PRIMARY KEY,	`name` VARCHAR,	`info` VARCHAR);CREATE TABLE `route` (	`id` INTEGER PRIMARY KEY,	`from` VARCHAR,	`to` VARCHAR);CREATE TABLE `spellbook` (	`id` INTEGER PRIMARY KEY,	`spell` INTEGER,	`user` INTEGER);CREATE TABLE `alignment` (	`id` INTEGER PRIMARY KEY,	`name` VARCHAR);CREATE TABLE `itemseeds` (	`id` INTEGER PRIMARY KEY,	`name` VARCHAR,	`type` VARCHAR,	`class` VARCHAR,	`weight` INTEGER,	`value` INTEGER,	`drop` INTEGER,	`attrs` VARCHAR);INSERT INTO `class` (`name`,`spells`,`casts`,`attrs`) VALUES (	"Wizard",	"minlevel=1,min=4,max=20",	"min=5,max=16",	"hpstart=4,hpgrow=1d4");INSERT INTO `info` (`name`,`info`) VALUES ("wizard","Wizards are like mages.");INSERT INTO `class` (`name`,`spells`,`casts`,`attrs`) VALUES (	"Fighter",	"minlevel=0",	"min=0,max=0",	"hpstart=10,hpgrow=1d4");INSERT INTO `info` (`name`,`info`) VALUES ("fighter","Fighters attack things");INSERT INTO `class` (`name`,`spells`,`casts`,`attrs`) VALUES (	"Barbarian",	"minlevel=0",	"min=0,max=0",	"hpstart=12,hpgrow=1d4");	INSERT INTO `info` (`name`,`info`) VALUES ("barbarian","Barbarian attack things");INSERT INTO `class` (`name`,`spells`,`casts`,`attrs`) VALUES (	"Bard",	"minlevel=1,min=2,max=12",	"min=2,max=10",	"hpstart=6,hpgrow=1d4");	INSERT INTO `info` (`name`,`info`) VALUES ("bard","Bards attack things.");INSERT INTO `class` (`name`,`spells`,`casts`,`attrs`) VALUES (	"Ranger",	"minlevel=4,min=1,max=8",	"min=2,max=8",	"hpstart=8,hpgrow=1d4");	INSERT INTO `info` (`name`,`info`) VALUES ("ranger","Ranger's attack things [n] Normal rangers cannot cast spells until they reach level 4.");INSERT INTO `class` (`name`,`spells`,`casts`,`attrs`) VALUES (	"Paladin",	"minlevel=4,min=1,max=7",	"min=2,max=7",	"hpstart=10,hpgrow=1d4");	INSERT INTO `info` (`name`,`info`) VALUES ("paladin","Paladins attack things");INSERT INTO `class` (`name`,`spells`,`casts`,`attrs`) VALUES (	"Sorcerer",	"minlevel=1,min=3,max=15",	"min=6,max=25",	"hpstart=4,hpgrow=1d4");	INSERT INTO `info` (`name`,`info`) VALUES ("sorcerer","Sorcerer's use spells");INSERT INTO `class` (`name`,`spells`,`casts`,`attrs`) VALUES (	"Monk",	"minlevel=0,min=0,max=0",	"min=0,max=0",	"hpstart=8,hpgrow=1d4");INSERT INTO `info` (`name`,`info`) VALUES ("monk","Monks do things.");INSERT INTO `class` (`name`,`spells`,`casts`,`attrs`) VALUES (	"Cleric",	"minlevel=1,min=4,max=20",	"min=5,max=16",	"hpstart=8,hpgrow=1d4,invalid alignments=lawful good|lawful evil");INSERT INTO `info` (`name`,`info`) VALUES ("cleric","Clerics cast spells.");INSERT INTO `class` (`name`,`spells`,`casts`,`attrs`) VALUES (	"Rogue",	"minlevel=0,min=0,max=0",	"min=0,max=0",	"hpstart=6,hpgrow=1d4");INSERT INTO `info` (`name`,`info`) VALUES ("rogue","Rogues do it from behind.");INSERT INTO `race` (`name`,`attrs`) VALUES (	"Humans",	"skillpnts=1,age=16-100,weight=50-140,height=150-230");INSERT INTO `info` (`name`,`info`) VALUES ("humans","Humans are liek us.");INSERT INTO `race` (`name`,`attrs`) VALUES (	"Elves",	"dex=2,con=-2,age=80-360,weight=40-75,height=180-250");INSERT INTO `info` (`name`,`info`) VALUES ("elves","Elves are tall and make fine spellcasters.");INSERT INTO `race` (`name`,`attrs`) VALUES (	"Dwarves",	"con=2,cha=-2,age=50-160,weight=100-200,height=100-140");INSERT INTO `info` (`name`,`info`) VALUES ("dwarves","Dwarves are short, stumpy, and disliked.");INSERT INTO `race` (`name`,`attrs`) VALUES (	"Half-Elves",	"age=40-120,weight=40-90,height=160-230");INSERT INTO `info` (`name`,`info`) VALUES ("half-elves","Half Elves are bastards made from Elves and Humans.");INSERT INTO `race` (`name`,`attrs`) VALUES (	"Half-Orcs",	"str=2,int=-2,cha=-2,age=20-70,weight=90-180,height=170-260");INSERT INTO `info` (`name`,`info`) VALUES ("half-orcs","Half Human, Half Orc, all man(even the women).");INSERT INTO `race` (`name`,`attrs`) VALUES (	"Halflings",	"dex=2,str=-2,age=18-90,weight=45-90,height=90-140");INSERT INTO `info` (`name`,`info`) VALUES ("halflings","Halflings are short and enjoy carrying things like rings.");INSERT INTO `race` (`name`,`attrs`) VALUES (	"Gnomes",	"con=2,str=-2,age=50-140,weight=35-80,height=80-120");INSERT INTO `info` (`name`,`info`) VALUES ("gnomes","Gnomes are short and potato-shaped.");INSERT INTO `alignment` (`name`) VALUES ("Lawful good");INSERT INTO `alignment` (`name`) VALUES ("Neutral good");INSERT INTO `alignment` (`name`) VALUES ("Chaotic good");INSERT INTO `alignment` (`name`) VALUES ("Lawful neutral");INSERT INTO `alignment` (`name`) VALUES ("True Neutral");INSERT INTO `alignment` (`name`) VALUES ("Chaotic Neutral");INSERT INTO `alignment` (`name`) VALUES ("Lawful evil");INSERT INTO `alignment` (`name`) VALUES ("Neutral evil");INSERT INTO `alignment` (`name`) VALUES ("Chaotic evil");INSERT INTO `info` (`name`,`info`) VALUES ("Lawful good","Lawful good");INSERT INTO `info` (`name`,`info`) VALUES ("Neutral good","Neussdf");INSERT INTO `info` (`name`,`info`) VALUES ("Chaotic good","sfdfsdf");INSERT INTO `info` (`name`,`info`) VALUES ("Lawful neutral","sdfsdf");INSERT INTO `info` (`name`,`info`) VALUES ("True Neutral","sdfsdf");INSERT INTO `info` (`name`,`info`) VALUES ("Chaotic Neutral","sdfsdf");INSERT INTO `info` (`name`,`info`) VALUES ("Lawful evil","sdfsdf");INSERT INTO `info` (`name`,`info`) VALUES ("Neutral evil","sdfsdf");INSERT INTO `info` (`name`,`info`) VALUES ("Chaotic evil","sdfsdfds");INSERT INTO `itemseeds` (`name`,`type`,`class`,`weight`,`value`,`drop`,`attrs`) VALUES (	"Dagger",	"weapon",	"dagger",	2,	3,	850,	"roll=1d4,dropmod=25");INSERT INTO `info` (`name`,`info`) VALUES ("dagger","A simple Dagger. Good for rogues.");INSERT INTO `itemseeds` (`name`,`type`,`class`,`weight`,`value`,`drop`,`attrs`) VALUES (	"Short Sword",	"weapon",	"Sword",	2,	3,	850,	"roll=1d8,dropmod=25");INSERT INTO `info` (`name`,`info`) VALUES ("short sword","Basic Short Sword.");INSERT INTO `itemseeds` (`name`,`type`,`class`,`weight`,`value`,`drop`,`attrs`) VALUES (	"Long Sword",	"weapon",	"Sword",	2,	3,	850,	"roll=1d10,dropmod=25");INSERT INTO `info` (`name`,`info`) VALUES ("long sword","Longer than the short sword.");INSERT INTO `itemseeds` (`name`,`type`,`class`,`weight`,`value`,`drop`,`attrs`) VALUES (	"Great Sword",	"weapon",	"Sword",	2,	3,	850,	"roll=2d6,dropmod=25");INSERT INTO `info` (`name`,`info`) VALUES ("great sword","Mightier than the pen.");INSERT INTO `itemseeds` (`name`,`type`,`class`,`weight`,`value`,`drop`,`attrs`) VALUES (	"Hand Axe",	"weapon",	"Axe",	2,	3,	850,	"roll=1d6,dropmod=25");INSERT INTO `info` (`name`,`info`) VALUES ("hand axe","An axe which can be comfortably weilded in one hand.");INSERT INTO `itemseeds` (`name`,`type`,`class`,`weight`,`value`,`drop`,`attrs`) VALUES (	"War Axe",	"weapon",	"Axe",	2,	3,	850,	"roll=3d4,2h,dropmod=25");INSERT INTO `info` (`name`,`info`) VALUES ("war axe","A great axe, usefull for beheading.");INSERT INTO `itemseeds` (`name`,`type`,`class`,`weight`,`value`,`drop`,`attrs`) VALUES (	"Kama",	"weapon",	"Scythe",	2,	3,	850,	"roll=1d4,dropmod=25");INSERT INTO `info` (`name`,`info`) VALUES ("kama","Hand-scythes.");INSERT INTO `itemseeds` (`name`,`type`,`class`,`weight`,`value`,`drop`,`attrs`) VALUES (	"Heavy Crossbow",	"weapon",	"Ranged",	2,	3,	850,	"roll=1d12,2h,dropmod=25");INSERT INTO `info` (`name`,`info`) VALUES ("heavy crossbow","A large crossbow, very heavy to hold.");INSERT INTO `itemseeds` (`name`,`type`,`class`,`weight`,`value`,`drop`,`attrs`) VALUES (	"Longbow",	"weapon",	"ranged",	2,	3,	850,	"roll=1d10,2h,dropmod=25");INSERT INTO `info` (`name`,`info`) VALUES ("longbow","A large and chunky bow.");INSERT INTO `itemseeds` (`name`,`type`,`class`,`weight`,`value`,`drop`,`attrs`) VALUES (	"Shortbow",	"weapon",	"ranged",	2,	3,	850,	"roll=1d8,2h,dropmod=25");INSERT INTO `info` (`name`,`info`) VALUES ("shortbow","A small bow");INSERT INTO `itemseeds` (`name`,`type`,`class`,`weight`,`value`,`drop`,`attrs`) VALUES (	"Staff",	"weapon",	"Staff",	2,	3,	850,	"roll=1d10,2h,dropmod=25");INSERT INTO `info` (`name`,`info`) VALUES ("staff","A generic wooden staff.");INSERT INTO `info` (`name`,`info`) VALUES ("startingArea","This is the starting area for gnomes and humans");INSERT INTO `area` (`name`,`type`,`attrs`) VALUES (		"Agatheron",	"town",	"spawn=Human|Gnome|Elves|Halflings|Half Orcs|Half Elves|Dwarves,pvp=1");INSERT INTO `info` (`name`,`info`) VALUES ("agatheron","Agatheron is a generic town with generic stores, generic leaders and generic NPC's.");INSERT INTO `area` (`name`,`type`,`attrs`) VALUES (	"Gothgar",	"town",	"pvp=2,min=0,max=0");INSERT INTO `info` (`name`,`info`) VALUES ("gothgar","A depressing town with many black houses. There is a strong odor of hungry, hungry hypocricy as people walk past in their white makeup and non-conformist black gowns.");INSERT INTO `route` (`from`,`to`) VALUES ("Grassy Grasslands","Gothgar");INSERT INTO `area` (`name`,`type`,`attrs`) VALUES (		"Grassy Grasslands",	"plains",	"pvp=1,min=1,max=2");INSERT INTO `info` (`name`,`info`) VALUES ("grassy grasslands","Very grassy plains. In the horizon you see grass. You frequently run into confrontations with grass. Grass everywhere.");INSERT INTO `route` (`from`,`to`) VALUES ("Agatheron","Grassy Grasslands");INSERT INTO `area` (`name`,`type`,`attrs`) VALUES (		"Scary Cave",	"dungeon",	"pvp=3,min=2,max=3");INSERT INTO `info` (`name`,`info`) VALUES ("scary cave","Very spooky, dank, dark and smelly.");INSERT INTO `route` (`from`,`to`) VALUES ("Caladen","Scary Cave");INSERT INTO `area` (`name`,`type`,`attrs`) VALUES (		"Bugger Forest",	"forest",	"pvp=2,min=1,max=3");INSERT INTO `info` (`name`,`info`) VALUES ("bugger forest","A forest inhabited by mainly bugs. As you walk by, random small bugs shoot strings of white goo at you, which you can only hope is some kind of webbing.");INSERT INTO `route` (`from`,`to`) VALUES ("Gothgar","Bugger Forest");INSERT INTO `area` (`name`,`type`,`attrs`) VALUES (		"Caladen",	"town",	"pvp=3,min=0,max=0");INSERT INTO `info` (`name`,`info`) VALUES ("bugger forest","A forest inhabited by mainly bugs. As you walk by, random small bugs shoot strings of white goo at you, which you can only hope is some kind of webbing.");INSERT INTO `route` (`from`,`to`) VALUES ("Bugger Forest","Caladen");