Trade and warehouse problems

[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

[takhs7]

u can see if the item(s) are tradable, dropable, destoyable etc in database ...

[yumy]

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 ?

[takhs7]

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..

[yumy]

there is null at all ;/ should i put True ?

[Hax0r]

I would recommend you to install the database again, or you can just do it manually by adding the lines by yourself...

[takhs7]

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..

[yumy]

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;