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

[Anders R. <ma...@us...>]

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

Modified Files:
	items.sql 
Log Message:
- Updated the inventory window def file to define the correct set
  of equipment slots. Created a new callback to handle this and
  send move commands to the server. This equipment slots are now
  defined: Back, Head, Neck, Arms, Gloves, LeftHand, Boots, Legs,
  Belt, RightHand, Bracers, Torso.
- Fixed the EquipItem code in the server to verify that item can
  be equiped in selected position. If equip fails a forced update
  of the inventory window is sent to the client.
- The slot field in the database was extended to 100 chars to
  allow multiple wield positions : Lefthand,RightHand.


Index: items.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/items.sql,v
retrieving revision 1.17
retrieving revision 1.18
diff -C2 -d -r1.17 -r1.18
*** items.sql	10 Feb 2003 07:40:41 -0000	1.17
--- items.sql	10 Feb 2003 21:03:34 -0000	1.18
***************
*** 24,28 ****
    ideal_level_skill_id smallint(5) unsigned DEFAULT '0' ,
    stackable char(1) DEFAULT '0' ,
!   slot varchar(5) DEFAULT '0' ,
    stats varchar(100) DEFAULT '0' ,
    item_description varchar(255) DEFAULT '0' ,
--- 24,28 ----
    ideal_level_skill_id smallint(5) unsigned DEFAULT '0' ,
    stackable char(1) DEFAULT '0' ,
!   slot varchar(100) DEFAULT '0' ,
    stats varchar(100) DEFAULT '0' ,
    item_description varchar(255) DEFAULT '0' ,
***************
*** 44,48 ****
  INSERT INTO items VALUES("7","Hair 3","3.png","hair","0","0","0","0","0","","","0","0","0","N","hair","","");
  INSERT INTO items VALUES("8","Chest","","","1","0","0","0","0","/this/art/things/chest","/this/art/gui/chest.png","0","0","0","N","Bulk","","Wooden chest");
! INSERT INTO items VALUES("9","Cleaver","","","1","0","100","10","1","/this/art/things/weapons/cleaver","/this/art/gui/cleaver.png","0","0","0","N","RightHand","","Butcher's knife having a large sharp square blade");
  INSERT INTO items VALUES("10","Long Sword","","","1","0","100","10","1","/this/art/things/weapons/long02c","/this/art/gui/longsd.png","0","0","0","N","RightHand","","This sharp double edged weapon will be your friend in hostal environments");
  INSERT INTO items VALUES("1000","Ruby Crystal","","","0","0","0","0","0","/this/art/things/rubycrystal","/this/art/gui/rubycr.png","0","0","0","Y","","","");
--- 44,48 ----
  INSERT INTO items VALUES("7","Hair 3","3.png","hair","0","0","0","0","0","","","0","0","0","N","hair","","");
  INSERT INTO items VALUES("8","Chest","","","1","0","0","0","0","/this/art/things/chest","/this/art/gui/chest.png","0","0","0","N","Bulk","","Wooden chest");
! INSERT INTO items VALUES("9","Cleaver","","","1","0","100","10","1","/this/art/things/weapons/cleaver","/this/art/gui/cleaver.png","0","0","0","N","RightHand,LeftHand","","Butcher's knife having a large sharp square blade");
  INSERT INTO items VALUES("10","Long Sword","","","1","0","100","10","1","/this/art/things/weapons/long02c","/this/art/gui/longsd.png","0","0","0","N","RightHand","","This sharp double edged weapon will be your friend in hostal environments");
  INSERT INTO items VALUES("1000","Ruby Crystal","","","0","0","0","0","0","/this/art/things/rubycrystal","/this/art/gui/rubycr.png","0","0","0","Y","","","");