ADE DB Editor Quest Error Will Rep

[Strupantwn]

I got this error when I click on Update/Insert. Any ideas? Because I don't want to make quest from DB, so annoying.

[Hasbro]

Oh sorry! RequiredMoney isn't a field anymore.
This is an old program I'm guessing, or has not been updated. ><

[Strupantwn]

Uh.. You don't see that big picture screen?

[mager1794]

give me a min i eidtted the 1.0.5 version so the quests will work except the Choose Quest Button
lemme set up the DL just place it in the same folder as your normal ADE

Here is the DL

Filebeam - Free Fast File Hosting

[Strupantwn]

Jesus, Mager1794, you always got my back I will try this right now, I will give you back result.

+ Rep btw

EDIT::



Is this a Problem?

I am using the NCDB Scythe provided me, not the 3.0


EDIT ::

Now it have this error

Then there was more errors saying my DB someomthing same as above except I have the Red X circle icon now

[latruwski]

try using the one with your first error and then export or gen SQL... then the query will be generated in a text file and you can remove the Requiredmoney column manually

[Strupantwn]

Good idea but except I don't know where the required money column will be at in the SQL
But can't I just add a column in my DB quest table the requried money column?

[Fan Boi]

Use the arc emu to aspire converter, just the first line of the sql, then they work perfect.

[Strupantwn]

Uhh what is a Arc Emu to Aspire Converter? Mind giving me a download link for that program or whatever that is and giving me a instruction on how to use it?

[Fan Boi]

ALTER TABLE `quests` change column `RewardMoneyAtMaxLevel` `RequiredMoney` int(10) unsigned not null default 0;


If that doesn't work, then reverse it.

[Strupantwn]

Huh? what am i suppose to do wit that?

mind giving me a TuT

[Strupantwn]

Alright I ran that Query in my Quest table but it still didn't work, how should I rearrange it?

EDIT::

I Rearranged it like this

ALTER TABLE `quests` change column `RequiredMoney` `RewardMoneyAtMaxLevel` int(10) unsigned not null default 0;

Still did not work..

[latruwski]

If you do generate sql query you will have something like:
insert into quests(a,b,c,d,e, requiredmoney, f,g,h,i,j) values(x,x,x,x,x,x,x,x,x,x)

The red X is the requiredmoney column....if requiredmoney is the 6th column between brackets then the 6th value is the requiredmoney value...

grtz

[whquint09]

Nice edited version. Works alot better than the original

[Strupantwn]

Lat, mind giving me a tut on how to upgrade my DB to the new blizzlike DB scythe made 3.0 to my ld DB without losing anything?