[DONE] out of range value for column . . .

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
puredemonsss
Posts: 56
Joined: Sat Dec 29, 2012 3:28 am

[DONE] out of range value for column . . .

Post by puredemonsss »

L2J Revision :6086
L2JDP Revision :9839

problem that is not confortablr pls help i realy need 85000 id to write , thanx :)

Image
Last edited by puredemonsss on Fri Jun 28, 2013 6:09 pm, edited 1 time in total.
Top
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: sql problem, value to high

Post by jurchiks »

Just increase the range of that column's value... Not l2j problem.
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
Top
puredemonsss
Posts: 56
Joined: Sat Dec 29, 2012 3:28 am

Re: sql problem, value to high

Post 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
Top
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: sql problem, value to high

Post by jurchiks »

w8 a sec, at your revisions buylists are already in XML format (game/data/buylists), not database.
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
Top
puredemonsss
Posts: 56
Joined: Sat Dec 29, 2012 3:28 am

Re: sql problem, value to high

Post 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>
Top
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: sql problem, value to high

Post 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> 
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
Top
puredemonsss
Posts: 56
Joined: Sat Dec 29, 2012 3:28 am

Re: sql problem, value to high

Post by puredemonsss »

thanx so much for help , i'm learning :)
Top
Post Reply

Return to “High Five Support”