[ArcEmu] Uploads Arcemu

[bong25]

Updated:
ArcEmu Core 3.0.3 Revision 1983 (purely Arcemu)
ArcEmu Core 3.0.3 Revision 1983 + Sun++ Revision 608

 

[Hunterrus]

Dear Bong25 I have got some real problem and can not understand what it is.! Hearthstone rev 732
my world Db is perfect except trainers, but it is ok! Here: I uploaded character structure from this file 516_CharacterTemplate.sql and logon files converted as well, all updates for character structure I have done and also converted with the supplied files! my server works but when I create a character it disappears and world log tells the following: SQL query failed due to [Coulumn count doesn't mutch value count at row 1] Query : Replace into characters values ( 1,1,terra.....) and so on.

Could help me to resolve this problem...

 

[bong25]

Dear Bong25 I have got some real problem and can not understand what it is.! Hearthstone rev 732
my world Db is perfect except trainers, but it is ok! Here: I uploaded character structure from this file 516_CharacterTemplate.sql and logon files converted as well, all updates for character structure I have done and also converted with the supplied files! my server works but when I create a character it disappears and world log tells the following: SQL query failed due to [Coulumn count doesn't mutch value count at row 1] Query : Replace into characters values ( 1,1,terra.....) and so on.

Could help me to resolve this problem...

Try using the arcemu logon and character dbs and convert it using HS sql converter, then apply updates.

 

[bong25]

Updated:
Hearthstone Core 3.0.3 Revision 745

 

[bong25]

I am currently working on some databases complete with world, characters and logon for cores I uploads here. It is just not easy to do it but I am trying my best.

 

[Razial7]

Cant finish world load it crashes with this error. arcemu and whydb server any ideas

 

[bong25]

Cant finish world load it crashes with this error. arcemu and whydb server any ideas

Holly cow! It does not occur in NCDB, after testing it with latest WhyDB these thing appears.

I will try to find a solution.

 

[bong25]

Replacing the fauty one.
Updated:
WhyDB Revision 260

Author: agmar
Date: 5:27:19 PM, Tuesday, January 06, 2009
Message:
Added correct items + creature_names table.
----
Added : /development/ascent_world/creature_names.sql
Added : /development/ascent_world/items.sql

Fixed last revision.
Delete both items and creature_names, going to add reverted tables from rev.255 due to a big in the current ones.
Removed character/logon tables from tool.bat GUI, can someone else do the tool.sh if needed?
Last, but by far not least -> Added loot_milling create by our very our developer Sadikum,
----
Deleted : /development/ascent_world/creature_names.sql
Modified : /development/ascent_world/creature_proto.sql
Modified : /development/ascent_world/creature_quest_finisher.sql
Modified : /development/ascent_world/creature_quest_starter.sql
Modified : /development/ascent_world/creature_spawns.sql
Modified : /development/ascent_world/gameobject_names.sql
Modified : /development/ascent_world/gameobject_spawns.sql
Deleted : /development/ascent_world/items.sql
Modified : /development/ascent_world/loot_milling.sql
Modified : /development/ascent_world/playercreateinfo.sql
Modified : /development/ascent_world/playercreateinfo_bars.sql
Modified : /development/ascent_world/playercreateinfo_items.sql
Modified : /development/ascent_world/playercreateinfo_skills.sql
Modified : /development/ascent_world/playercreateinfo_spells.sql
Modified : /development/ascent_world/recall.sql
Modified : /development/ascent_world/trainer_spells.sql
Modified : /development/ascent_world/worldmap_info.sql
Modified : /development/ascent_world/worldstring_tables.sql
Modified : /development/ascent_world/worldstring_tables_localized.sql
Modified : /tool.bat

Added a nice little (but very heavy) query for deleting double spawns.
----
Added : /development/extras/remove_double_spawns.sql

 

[darksideris]

fast updates man thx to bong

 

[bong25]

fast updates man thx to bong

Welcome.

 

[bong25]

Updated
WhyDB Revision: 263
Author: agmar
Date: 6:57:49 PM, Tuesday, January 06, 2009
Message:
Added Sadikum's loot_milling table.
----
Modified : /development/ascent_world/loot_milling.sql

Added fix to bugged creature_spawns table. It should be safe now to update your server
----
Modified : /development/ascent_world/creature_spawns.sql

For some reason someone changed the DB name in tool.bat
Thus, the extraction didn't work properly so I commited normal tables instead of the WotLK ones.
tool.bat World Database Names changed to WhyDB_world.
This should include WotLK stuff + fixed items/creature_names table.
----
Modified : /development/ascent_world/ItemPetFood.sql
Modified : /development/ascent_world/ai_agents.sql
Modified : /development/ascent_world/ai_threattospellid.sql
Modified : /development/ascent_world/areatriggers.sql
Modified : /development/ascent_world/auctionhouse.sql
Modified : /development/ascent_world/banned_pharses.sql
Modified : /development/ascent_world/clientaddons.sql
Modified : /development/ascent_world/command_overrides.sql
Modified : /development/ascent_world/creature_formations.sql
Modified : /development/ascent_world/creature_names_localized.sql
Modified : /development/ascent_world/creature_proto.sql
Modified : /development/ascent_world/creature_quest_finisher.sql
Modified : /development/ascent_world/creature_quest_starter.sql
Modified : /development/ascent_world/creature_spawns.sql
Modified : /development/ascent_world/creature_staticspawns.sql
Modified : /development/ascent_world/creature_timed_emotes.sql
Modified : /development/ascent_world/creature_waypoints.sql
Modified : /development/ascent_world/db_version.sql
Modified : /development/ascent_world/fishing.sql
Modified : /development/ascent_world/gameobject_names.sql
Modified : /development/ascent_world/gameobject_names_localized.sql
Modified : /development/ascent_world/gameobject_quest_finisher.sql
Modified : /development/ascent_world/gameobject_quest_item_binding.sql
Modified : /development/ascent_world/gameobject_quest_pickup_binding.sql
Modified : /development/ascent_world/gameobject_quest_starter.sql
Modified : /development/ascent_world/gameobject_spawns.sql
Modified : /development/ascent_world/gameobject_staticspawns.sql
Modified : /development/ascent_world/graveyards.sql
Modified : /development/ascent_world/instance_bosses.sql
Modified : /development/ascent_world/item_quest_association.sql
Modified : /development/ascent_world/item_randomprop_groups.sql
Modified : /development/ascent_world/item_randomsuffix_groups.sql
Modified : /development/ascent_world/itempages.sql
Modified : /development/ascent_world/itempages_localized.sql
Modified : /development/ascent_world/items_localized.sql
Modified : /development/ascent_world/loot_creatures.sql
Modified : /development/ascent_world/loot_disenchanting.sql
Modified : /development/ascent_world/loot_fishing.sql
Modified : /development/ascent_world/loot_gameobjects.sql
Modified : /development/ascent_world/loot_items.sql
Modified : /development/ascent_world/loot_milling.sql
Modified : /development/ascent_world/loot_pickpocketing.sql
Modified : /development/ascent_world/loot_prospecting.sql
Modified : /development/ascent_world/loot_skinning.sql
Modified : /development/ascent_world/map_checkpoint.sql
Modified : /development/ascent_world/npc_gossip_textid.sql
Modified : /development/ascent_world/npc_monstersay.sql
Modified : /development/ascent_world/npc_text.sql
Modified : /development/ascent_world/npc_text_localized.sql
Modified : /development/ascent_world/petdefaultspells.sql
Modified : /development/ascent_world/playercreateinfo.sql
Modified : /development/ascent_world/playercreateinfo_bars.sql
Modified : /development/ascent_world/playercreateinfo_items.sql
Modified : /development/ascent_world/playercreateinfo_skills.sql
Modified : /development/ascent_world/playercreateinfo_spells.sql
Modified : /development/ascent_world/professiondiscoveries.sql
Modified : /development/ascent_world/quests.sql
Modified : /development/ascent_world/quests_localized.sql
Modified : /development/ascent_world/recall.sql
Modified : /development/ascent_world/reputation_creature_onkill.sql
Modified : /development/ascent_world/reputation_faction_onkill.sql
Modified : /development/ascent_world/reputation_instance_onkill.sql
Modified : /development/ascent_world/spell_coef_override.sql
Modified : /development/ascent_world/spell_disable.sql
Modified : /development/ascent_world/spell_disable_trainers.sql
Modified : /development/ascent_world/spell_effects_override.sql
Modified : /development/ascent_world/spell_proc.sql
Modified : /development/ascent_world/spell_proc_data.sql
Modified : /development/ascent_world/spellfixes.sql
Modified : /development/ascent_world/spelloverride.sql
Modified : /development/ascent_world/teleport_coords.sql
Modified : /development/ascent_world/totemspells.sql
Modified : /development/ascent_world/trainer_defs.sql
Modified : /development/ascent_world/trainer_spells.sql
Modified : /development/ascent_world/transport_creatures.sql
Modified : /development/ascent_world/transport_data.sql
Modified : /development/ascent_world/unit_display_sizes.sql
Modified : /development/ascent_world/vendors.sql
Modified : /development/ascent_world/weather.sql
Modified : /development/ascent_world/wordfilter_character_names.sql
Modified : /development/ascent_world/wordfilter_chat.sql
Modified : /development/ascent_world/worldbroadcast.sql
Modified : /development/ascent_world/worldbroadcast_localized.sql
Modified : /development/ascent_world/worldmap_info.sql
Modified : /development/ascent_world/worldmap_info_localized.sql
Modified : /development/ascent_world/worldstring_tables.sql
Modified : /development/ascent_world/worldstring_tables_localized.sql
Modified : /development/ascent_world/zoneguards.sql
Modified : /tool.bat

 

[werewere]

Has WhyDB Revision 263 fixed the blue/white box at last

 

[Milw0rm]

Hey!
Just wondering... if i type .character learn all shouldnt i learn all spells for all classes or should i just learn my own class spells?

 

[darksideris]

only your own class

 

[Milw0rm]

Aha... thanks for answer

 

[darksideris]

when the hell the bugs that was fixed in 2.4.3 will be fixed in 303 and are there any db with spawns in northrend ???

 

[darksideris]

what everyone is dead i see

 

[bong25]

when the hell the bugs that was fixed in 2.4.3 will be fixed in 303 and are there any db with spawns in northrend ???

Frankly speaking I don't know when they will fix the bugs, NCDB has spawns in northrend.

 

[bong25]

Updated:

WhyDB Revision: 264
Author: mesox
Date: 10:23:25 PM, Thursday, January 08, 2009
Message:
* Rewrote all items
* Corrected some things on SVN (db_version.sql has only empty milling loot table and
because of db_version is inserted after original loot_milling table in tool.bat, all,
who used tool.bat for import wotlk contet have now loot_milling empty, do not apply
something from ascent_world manually, just apply changeset_60.sql)
* Re-imported db_version
* Archived old changesets 51-59 to changesets 51-59.zip
* Deleted "Import char and logon tables" from tool.bat
----
Modified : /development/ascent_world/db_version.sql
Modified : /development/ascent_world/items.sql
Added : /development/changesets/archive/changesets 51-59.zip
Deleted : /development/changesets/changeset_51.sql
Deleted : /development/changesets/changeset_52.sql
Deleted : /development/changesets/changeset_53.sql
Deleted : /development/changesets/changeset_54.sql
Deleted : /development/changesets/changeset_55.sql
Deleted : /development/changesets/changeset_56.sql
Deleted : /development/changesets/changeset_57.sql
Deleted : /development/changesets/changeset_58.sql
Deleted : /development/changesets/changeset_59.sql
Added : /development/changesets/changeset_60.sql
Modified : /tool.bat

 

[bong25]

Replacing WhyDB Revision 264 to 265

Revision: 265
Author: mesox
Date: 12:16:40 AM, Friday, January 09, 2009
Message:
* Missed something there and corrected error in changeset (with DISABLED KEYS and TIME ZONES)
----
Modified : /development/changesets/changeset_60.sql
Modified : /tool.bat