yumy Posted October 4, 2007 Share Posted October 4, 2007 I can't see weapons and shields in trade, i can't drop , destroy and also i can't put them in warehouse Can someone help me ? what should i edite in gameserver Link to comment Share on other sites More sharing options...
0 takhs7 Posted October 5, 2007 Share Posted October 5, 2007 u can see if the item(s) are tradable, dropable, destoyable etc in database ... Link to comment Share on other sites More sharing options...
0 yumy Posted October 5, 2007 Author Share Posted October 5, 2007 u can see if the item(s) are tradable, dropable, destoyable etc in database ... can u explain me a little better ? ... i'm a little noob I mean , with gm char i can drop those item(s) but i can't trade them , with normal char i can't drop , trade and destroy. Where can i replace to make the items tradable , dropable and destroyable ? Link to comment Share on other sites More sharing options...
0 takhs7 Posted October 5, 2007 Share Posted October 5, 2007 u open navicat (or if u have diskw u open phpmyadmin) go to weapons table (for weapons and shields) find the item u want.. and u can see if it is set to tradeble, dropable etc.. Link to comment Share on other sites More sharing options...
0 yumy Posted October 5, 2007 Author Share Posted October 5, 2007 there is null at all ;/ should i put True ? Link to comment Share on other sites More sharing options...
0 Hax0r Posted October 5, 2007 Share Posted October 5, 2007 I would recommend you to install the database again, or you can just do it manually by adding the lines by yourself... Link to comment Share on other sites More sharing options...
0 takhs7 Posted October 5, 2007 Share Posted October 5, 2007 there is null at all ;/ should i put True ? ofcourse... but it shouldnt be null :s.. try reinstall the db again as Hax0r said.. coz fixing it manualy could take hours.. Link to comment Share on other sites More sharing options...
0 yumy Posted October 5, 2007 Author Share Posted October 5, 2007 Ty for help. I resolved it ^_^ i needed to change in weapon.sql ALTER TABLE weapon ADD dropable varchar(5) NOT NULL default 'true'; ALTER TABLE weapon ADD tradeable varchar(5) NOT NULL default 'true'; ALTER TABLE weapon ADD destroyable varchar(5) NOT NULL default 'true'; was ALTER TABLE weapon ADD dropable varchar(5) default NULL; ALTER TABLE weapon ADD tradeable varchar(5) default NULL; ALTER TABLE weapon ADD destroyable varchar(5) default NULL; Link to comment Share on other sites More sharing options...
Question
yumy
I can't see weapons and shields in trade, i can't drop , destroy and also i can't put them in warehouse
Can someone help me ?
what should i edite in gameserver
Link to comment
Share on other sites
7 answers to this question
Recommended Posts