[Planeshift-cvs] CVS: planeshift/src/server/database/mysql items.sql,1.22,1.23

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Update of /cvsroot/planeshift/planeshift/src/server/database/mysql
In directory sc8-pr-cvs1:/tmp/cvs-serv22236/src/server/database/mysql

Modified Files:
	items.sql 
Log Message:
Fixed you how weapons are loaded and stored. Makes it much easier to add new ones in for the future

Index: items.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/items.sql,v
retrieving revision 1.22
retrieving revision 1.23
diff -C2 -d -r1.22 -r1.23
*** items.sql	26 Mar 2003 00:21:42 -0000	1.22
--- items.sql	8 Apr 2003 03:45:08 -0000	1.23
***************
*** 63,91 ****
  INSERT INTO items VALUES("23","Eyes 4","4.png","eyes","0","0","0","0","0","","","0","0","0","N","eyes","","");

! INSERT INTO items VALUES("24","Excalibur","","","1","0","100","10","1","/this/art/things/weapons/long02c","/this/art/gui/longsword01a_icon.png","0","0","0","N","righthand","STR +2,AGI +1","This sharp double edged weapon will be your friend in hostal environments");

! INSERT INTO items VALUES("25","doubleaxe01a","","","1","0","100","10","1","/this/art/things/weapons/doubleaxe01a","/this/art/gui/doubleaxe01a_icon.png","0","0","0","N","righthand","STR +2,AGI +1","An Axe");

! INSERT INTO items VALUES("26","doubleaxe02a","","","1","0","100","10","1","/this/art/things/weapons/doubleaxe02a","/this/art/gui/doubleaxe02a_icon.png","0","0","0","N","righthand","STR +2,AGI +1","An Axe");

! #INSERT INTO items VALUES("27","2handedaxe02a","","","1","0","100","10","1","/this/art/things/weapons/twohandedaxe02a","/this/art/gui/longsd.png","0","0","0","N","righthand","STR +2,AGI +1","A really big axe");

! INSERT INTO items VALUES("28","broadsword01a","","","1","0","100","10","1","/this/art/things/weapons/broadsword01a","/this/art/gui/broadsword01a_icon.png","0","0","0","N","righthand","STR +2,AGI +1","A big sword");

! INSERT INTO items VALUES("29","claymore01a","","","1","0","100","10","1","/this/art/things/weapons/claymore01a","/this/art/gui/claymore01a_icon.png","0","0","0","N","righthand","STR +2,AGI +1","A really big sword");

! INSERT INTO items VALUES("30","falchion01a","","","1","0","100","10","1","/this/art/things/weapons/falchion01a","/this/art/gui/falchion01a_icon.png","0","0","0","N","righthand","STR +2,AGI +1","This sharp double edged weapon will be your friend in hostal environments");

! INSERT INTO items VALUES("31","falchion01b","","","1","0","100","10","1","/this/art/things/weapons/falchion01b","/this/art/gui/falchion01b_icon.png","0","0","0","N","righthand","STR +2,AGI +1","This sharp double edged weapon will be your friend in hostal environments");

! INSERT INTO items VALUES("32","falchion01c","","","1","0","100","10","1","/this/art/things/weapons/falchion01c","/this/art/gui/falchion01c_icon.png","0","0","0","N","righthand","STR +2,AGI +1","This sharp double edged weapon will be your friend in hostal environments");

! INSERT INTO items VALUES("33","galkard01a","","","1","0","100","10","1","/this/art/things/weapons/galkard01a","/this/art/gui/galkard01a_icon.png","0","0","0","N","righthand","STR +2,AGI +1","This sharp double edged weapon will be your friend in hostal environments");

! INSERT INTO items VALUES("34","longsword01a","","","1","0","100","10","1","/this/art/things/weapons/longsword01a","/this/art/gui/longsword01a_icon.png","0","0","0","N","righthand","STR +2,AGI +1","This sharp double edged weapon will be your friend in hostal environments");

! INSERT INTO items VALUES("35","normalaxe01a","","","1","0","100","10","1","/this/art/things/weapons/normalaxe01a","/this/art/gui/normalaxe01a_icon.png","0","0","0","N","righthand","STR +2,AGI +1","A regular axe");

- INSERT INTO items VALUES("36","sabre01a","","","1","0","100","10","1","/this/art/things/weapons/sabre01a","/this/art/gui/sabre01a_icon.png","0","0","0","N","righthand","STR +2,AGI +1","This sharp double edged weapon will be your friend in hostal environments");

--- 63,94 ----
  INSERT INTO items VALUES("23","Eyes 4","4.png","eyes","0","0","0","0","0","","","0","0","0","N","eyes","","");

! INSERT INTO items VALUES("24","Excalibur","","","1","0","100","10","0","/planeshift/weapons/longsword01a","/planeshift/weapons/longsword01a_icon.png","0","0","0","N","righthand","STR +2,AGI +1","This sharp double edged weapon will be your friend in hostal environments");

! INSERT INTO items VALUES("25","doubleaxe01a","","","1","0","100","10","0","/planeshift/weapons/doubleaxe01a","/planeshift/weapons/doubleaxe01a_icon.png","0","0","0","N","righthand,lefthand","STR +2,AGI +1","An Axe");

! INSERT INTO items VALUES("26","doubleaxe02a","","","1","0","100","10","0","/planeshift/weapons/doubleaxe02a","/planeshift/weapons/doubleaxe02a_icon.png","0","0","0","N","righthand,lefthand","STR +2,AGI +1","An Axe");

! #INSERT INTO items VALUES("27","2handedaxe02a","","","1","0","100","10","0","/this/art/things/weapons/twohandedaxe02a","/this/art/gui/longsd.png","0","0","0","N","righthand,lefthand","STR +2,AGI +1","A really big axe");

! INSERT INTO items VALUES("28","broadsword01a","","","1","0","100","10","0","/planeshift/weapons/broadsword01a","/planeshift/weapons/broadsword01a_icon.png","0","0","0","N","righthand,lefthand","STR +2,AGI +1","A big sword");

! INSERT INTO items VALUES("29","claymore01a","","","1","0","100","10","0","/planeshift/weapons/claymore01a","/planeshift/weapons/claymore01a_icon.png","0","0","0","N","righthand,lefthand","STR +2,AGI +1","A really big sword");

! INSERT INTO items VALUES("30","falchion01a","","","1","0","100","10","0","/planeshift/weapons/falchion01a","/planeshift/weapons/falchion01a_icon.png","0","0","0","N","righthand,lefthand","STR +2,AGI +1","This sharp double edged weapon will be your friend in hostal environments");

! INSERT INTO items VALUES("31","falchion01b","","","1","0","100","10","0","/planeshift/weapons/falchion01b","/planeshift/weapons/falchion01b_icon.png","0","0","0","N","righthand,lefthand","STR +2,AGI +1","This sharp double edged weapon will be your friend in hostal environments");

! INSERT INTO items VALUES("32","falchion01c","","","1","0","100","10","0","/planeshift/weapons/falchion01c","/planeshift/weapons/falchion01c_icon.png","0","0","0","N","righthand,lefthand","STR +2,AGI +1","This sharp double edged weapon will be your friend in hostal environments");

! INSERT INTO items VALUES("33","galkard01a","","","1","0","100","10","0","/planeshift/weapons/galkard01a","/planeshift/weapons/galkard01a_icon.png","0","0","0","N","righthand,lefthand","STR +2,AGI +1","This sharp double edged weapon will be your friend in hostal environments");

! INSERT INTO items VALUES("34","longsword01a","","","1","0","100","10","0","/planeshift/weapons/longsword01a","/planeshift/weapons/longsword01a_icon.png","0","0","0","N","righthand,lefthand","STR +2,AGI +1","This sharp double edged weapon will be your friend in hostal environments");

! INSERT INTO items VALUES("35","normalaxe01a","","","1","0","100","10","0","/planeshift/weapons/normalaxe01a","/planeshift/weapons/normalaxe01a_icon.png","0","0","0","N","righthand,lefthand","STR +2,AGI +1","A regular axe");
! 
! INSERT INTO items VALUES("36","sabre01a","","","1","0","100","10","0","/planeshift/weapons/sabre01a","/planeshift/weapons/sabre01a_icon.png","0","0","0","N","righthand,lefthand","STR +2,AGI +1","This sharp double edged weapon will be your friend in hostal environments");
! 
! INSERT INTO items VALUES("37","Jug","","","1","0","100","10","0","/planeshift/weapons/jug01a","/planeshift/weapons/jug01a_icon.png","0","0","0","N","righthand,lefthand","STR +2,AGI +1","This sharp double edged weapon will be your friend in hostal environments");

***************
*** 198,200 ****
--- 201,204 ----
  INSERT INTO sector_info VALUES("library","0","0","0","0","0","0","0","0");
  INSERT INTO sector_info VALUES("large","25","50","25","50","500","3000","5","10");
+ 