From: Andrew C. <ac...@us...> - 2003-04-08 03:45:13
|
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"); + |