Page 1 of 1
[DONE] out of range value for column . . .
Posted: Fri Jun 28, 2013 4:38 pm
by puredemonsss
L2J Revision :6086
L2JDP Revision :9839
problem that is not confortablr pls help i realy need 85000 id to write , thanx 
Re: sql problem, value to high
Posted: Fri Jun 28, 2013 4:52 pm
by jurchiks
Just increase the range of that column's value... Not l2j problem.
Re: sql problem, value to high
Posted: Fri Jun 28, 2013 5:18 pm
by puredemonsss
jurchiks wrote:Just increase the range of that column's value... Not l2j problem.
I'm curently searching how to do it coz i'm noob at those clicks XD
thanx for help
Re: sql problem, value to high
Posted: Fri Jun 28, 2013 5:36 pm
by jurchiks
w8 a sec, at your revisions buylists are already in XML format (game/data/buylists), not database.
Re: sql problem, value to high
Posted: Fri Jun 28, 2013 5:54 pm
by puredemonsss
jurchiks wrote:w8 a sec, at your revisions buylists are already in XML format (game/data/buylists), not database.
so is something like this ? wach for the green ones !
item id
85001
price
25000 adena
<?xml version="1.0" encoding="UTF-8"?>
<list xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="
../../xsd/multisell.xsd">
<item>
<!-- Adena -->
<ingredient count="
25000" id="57" />
<!-- Enchanted Mana Potion -->
<ingredient count="1" id="
85001" />
</item>
Re: sql problem, value to high
Posted: Fri Jun 28, 2013 6:02 pm
by jurchiks
you're missing the closing list tag, and if you want to SELL 1x85001 for 25000 adena then it should be like this:
Code: Select all
<item> <!-- Adena --> <ingredient id="57" count="25000" /> <!-- Enchanted Mana Potion --> <production id="85001" count="1" /></item>
Re: sql problem, value to high
Posted: Fri Jun 28, 2013 6:07 pm
by puredemonsss
thanx so much for help , i'm learning