updated rev to 4110 from 3850 and now NONE of the quests work...

[MisterEMU]

updated rev to 4110 from 3850 and now NONE of the quests work... can someone help me fix this

[2dgreengiant]

try updating your database

[MisterEMU]

try updating your database

what do you mean? I copied all the files from your 4110 into my ascent folder what else do I have to do?

[Stabatha]

I had the same problem when I decided to upgrade from a repack to building my own funserver... Realised I didn't run 4042_world_quests.sql

alter table quests add column RequiredTradeskillValue int(5) unsigned default 0 not null after RequiredTradeskill;

[MisterEMU]

I had the same problem when I decided to upgrade from a repack to building my own funserver... Realised I didn't run 4042_world_quests.sql

alter table quests add column RequiredTradeskillValue int(5) unsigned default 0 not null after RequiredTradeskill;

where can I get the SQL code for rev 4110?

[metehan]

Mister emu, just run that SQL. It will fix it.

[Stabatha]

where can I get the SQL code for rev 4110?

inside of ascent\sql\world_updates

[metehan]

inside of ascentsqlworld_updates

Actually that SQL code is supposed to ran on all revisions above 4040 thats what it stands for. I ran that code on my 4269 Trunk Revision.

[MisterEMU]

inside of ascentsqlworld_updates

is the the 4042_world_quests.sql ?

[MisterEMU]

Actually that SQL code is supposed to ran on all revisions above 4040 thats what it stands for. I ran that code on my 4269 Trunk Revision.

did you get rev 4296 to work? I had some problems

[metehan]

did you get rev 4296 to work? I had some problems

Yup
"Metehan's Funserver Compile" is proof of that.

[Stabatha]

4042_ stands for the revision number it came out for, anything higher then your current database number when you checked out should be run to update new tables for adds and bug fixes.

But since your revision that is the only new one, so simply just run the sql line I gave you and restart world.exe and clear your cache before you log in and quests will more then likely work

here's the sql line to run again

alter table quests add column RequiredTradeskillValue int(5) unsigned default 0 not null after RequiredTradeskill;

[MisterEMU]

Yup
"Metehan's Funserver Compile" is proof of that.

Can you help me install rev 4296? which SQL do I need to install?

4042_ stands for the revision number it came out for, anything higher then your current database number when you checked out should be run to update new tables for adds and bug fixes.

But since your revision that is the only new one, so simply just run the sql line I gave you and restart world.exe and clear your cache before you log in and quests will more then likely work

here's the sql line to run again

alter table quests add column RequiredTradeskillValue int(5) unsigned default 0 not null after RequiredTradeskill;

thanks a lot I'll try and if it works +Rep

[MisterEMU]

erm is there a way to reverse the
alter table quests add column RequiredTradeskillValue int(5) unsigned default 0 not null after RequiredTradeskill;

?

because 4110 is REALLY buggy - stats are at like 4 million and stuff very very buggy...

[kaothic]

Use 4299 with NCDB milestone3.x and update the DB with latests fixes(playercooldowns,disenchants,alter table from quests,etc..) works fine o(^.^)o

Only bug that I see is the npc city tracker, when any talk with city guardian for know where is a npc(weapon master for ex)that in minimap no indicates the npc with a flag.