Page 1 of 1

Custom Weapon doesnt exist ?

Posted: Sat Dec 26, 2009 12:44 pm
by rigid
Hai,

I have weapon donation
this weapon donation can't be trade, drop and destroy
so im copy from table "weapon"
and insert to "custom_weapon"

Code: Select all

INSERT INTO `custom_weapon` (`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `time`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `depositable`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`, `change_weaponId`, `skill`) VALUES(960688, 'Vesper Buster - Acumen', 'rhand', 'true', 1520, 1, 1, 'fine_steel', 's84', 317, 10, 'sword', 8, 0.00000, 0, 0, 0, 379, 0, 234, -1, -1, 146873000, 7050, 'false', 'false', 'false', 'false', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, '3047-3;');
but, im create item 960688 error message show " item doesn't exist "
how to make copy item ?

Re: Custom Weapon doesnt exist ?

Posted: Sat Dec 26, 2009 1:00 pm
by JIV
did you enabled load these tables in config?

Re: Custom Weapon doesnt exist ?

Posted: Sat Dec 26, 2009 1:04 pm
by janiii
enable custom weapon table in config.

General.properties -> CustomItemTables -> True

Re: Custom Weapon doesnt exist ?

Posted: Sat Dec 26, 2009 1:08 pm
by rigid
janiii wrote:enable custom weapon table in config.

General.properties -> CustomItemTables -> True

Code: Select all

# Default: FalseCustomItemTables = true
still doesn't work
any idea ? or have conflict with other mods :lol:

Re: Custom Weapon doesnt exist ?

Posted: Sat Dec 26, 2009 1:11 pm
by janiii
probably the custom_weapon table is not what you expect it to be.. it is for changed values, not for new weapon id, because client doesn't know such new id.

Re: Custom Weapon doesnt exist ?

Posted: Sat Dec 26, 2009 1:15 pm
by rigid
janiii wrote:probably the custom_weapon table is not what you expect it to be.. it is for changed values, not for new weapon id, because client doesn't know such new id.

ah you right :)
u have idea howt to force WEAPON/ARMOR Donation can't be trade to other char ?

Re: Custom Weapon doesnt exist ?

Posted: Sat Dec 26, 2009 1:27 pm
by Probe
on weapons.sql you have several columns to define just that - there are columns called 'droppable' 'tradeable'
you need to set those to 'true'

Re: Custom Weapon doesnt exist ?

Posted: Sat Dec 26, 2009 1:45 pm
by rigid
Probe wrote:on weapons.sql you have several columns to define just that - there are columns called 'droppable' 'tradeable'
you need to set those to 'true'
i just wanna make non tradeable for Armor/Weapon Donation
just spesific armor and weapon, not on all weapon

i.e : Vesper Buster Acumen > normaly on GMShop > yes this is can be trade, destroy, and drop
Vesper Buster Acumen+10 > from GM give for Reward of Donation > can't be trade, destroy and drop

i just wanna like this :D
any idea ?

Re: Custom Weapon doesnt exist ?

Posted: Sat Dec 26, 2009 6:22 pm
by Probe
you can't make ONE weapon not tradable\droppable
you can make ONE TYPE of weapon that way by setting 'false' on it's weapons.sql entry in the corresponding columns..
what's not clear about that? :x

Re: Custom Weapon doesnt exist ?

Posted: Tue Feb 01, 2011 2:02 pm
by guildertool
how about now?is it possible to add my custom armors/weaps/items to L2jserver Freya?
if yes,can u tell me where i must add info now:D
in old ver. SQL+stats
now server has no sql armors/weapons/etcitems,how to add custom now?

Re: Custom Weapon doesnt exist ?

Posted: Tue Feb 01, 2011 2:44 pm
by SolidSnake
2 years old topic..

Re: Custom Weapon doesnt exist ?

Posted: Wed Feb 02, 2011 12:42 am
by Ralm
Every new/custom item, with new IDs needs Client modifications and that are not suported/allowed here!!
Simple!!