Missing documentation

[bolly]

Hey all,

Great progress so far, logged in without any issues - there's a bit of an issue on your main site though, it needs information on where to get the database/schema from. Adding this to the server admin wiki guide and a sticky here would be of great help.

I'm going keep searching till I find it so don't feel like you need to reply just a suggestion to the mods

Cheers

Bolly

[bolly]

Still no luck and it appears without them my test server won't be able to apply the updates.

---------------------------------------------
[20090922 02:50:59] Error while getting updates!
[20090922 02:50:59] Error in LoadNPCSpells query 'SELECT spell_list_id, spell_id, spell_tier from spawn_npc_spells': #1146: Table 'eq2world.spawn_npc_spells' doesn't exist
[20090922 02:50:59] Error in LoadNPCSkills query 'SELECT skill_list_id, skill_id, starting_value from spawn_npc_skills': #1146: Table 'eq2world.spawn_npc_skills' doesn't exist
[20090922 02:50:59] Error in LoadNPCEquipment query 'SELECT equipment_list_id, item_id from spawn_npc_equipment': #1146: Table 'eq2world.spawn_npc_equipment' doesn't exist
[20090922 02:50:59] Error in LoadAppearances query 'SELECT distinct `type` from npc_appearance where length(type) > 0': #1146: Table 'eq2world.npc_appearance' doesn't exist
[20090922 02:50:59] Error in LoadAppearances query 'SELECT `type`, spawn_id, signed_value, red, green, blue from npc_appearance where length(type) > 0 order by spawn_id': #1146: Table 'eq2world.npc_appearance' doesn't exist
[20090922 02:50:59] Error in LoadNPCAppearanceEquipmentData query 'SELECT spawn_id, slot_id, equip_type, red, green, blue, highlight_red, highlight_green, highlight_blue from npc_appearance_equip order by spawn_id': #1146: Table 'eq2world.npc_appearance_equip' doesn't exist
[20090922 02:50:59] Error in LoadLootTable query 'select id, name, mincoin, maxcoin, maxlootitems, lootdrop_probability, coin_probability from loottable': #1146: Table 'eq2world.loottable' doesn't exist
[20090922 02:50:59] Error in LoadLootDrop query 'select id, name, mincoin, maxcoin, maxlootitems, lootdrop_probability, coin_probability from loottable': #1146: Table 'eq2world.loottable' doesn't exist
[20090922 02:50:59] Error in LoadSpawnLootList query 'select id, name, mincoin, maxcoin, maxlootitems, lootdrop_probability, coin_probability from loottable': #1146: Table 'eq2world.loottable' doesn't exist
[20090922 02:50:59] Error in LoadNextUniqueItemID query 'SELECT max(id) from character_items': #1146: Table 'eq2world.character_items' doesn't exist
[20090922 02:50:59] Error Loading Spells, Query: select spells.`id`, `name`, `description`, `type`, `class_skill`, `mastery_skill`, `tier`, `hp_req`, `power_req`, `cast_time`, `recast`, `radius`, `max_aoe_targets`, `req_concentration`, `range`, `duration1`, `duration2`, `resistibility`, `hp_upkeep`, `power_upkeep`, `duration_until_cancel`, `target_type`, `recovery`, `power_req_percent`, `hp_req_percent`, `icon`, `icon2`, `icontype`, `success_message`, `fade_message`, `cast_type`, `lua_script`, `call_frequency`, `interruptable`, `spell_visual`, `effect_message`, `min_range`, `can_effect_raid`, `affect_only_group_members`, `hit_bonus`, `display_spell_tier`, `friendly_spell`, `group_spell`, `spell_book_type` from spells, spell_tiers where spells.id = spell_tiers.spell_id order by `tier`, Error: #1146: Table 'eq2world.spells' doesn't exist
[20090922 02:50:59] Error Loading Factions, Query: SELECT id, name, type, description, default_level, negative_change, positive_change from factions, Error: #1146: Table 'eq2world.factions' doesn't exist
[20090922 02:50:59] Error in LoadSpawnScriptData, Query: SELECT spawn_id, spawnentry_id, spawn_location_id, lua_script from spawn_scripts, Error: #1146: Table 'eq2world.spawn_scripts' doesn't exist
[20090922 02:50:59] Error in LoadZoneScriptData, Query: SELECT `id`, `lua_script` FROM `zones`, Error: #1146: Table 'eq2world.zones' doesn't exist

[bolly]

9. Open LoginServer.ini in the work directory that you created in step 5.

9.1 Replace WORLD_NAME_HERE with the World Server Name you created in step 3.1.
9.2 Replace EXTERNAL_IP_HERE with either localhost if you want to only allow yourself to login, or replace it with your external ip address. You can get this by browsing to http://www.whatismyip.com
9.3 Update account and password with the information that you created in step 3.2 and 3.3 respectively.
9.4 Make sure the [UpdateServer] section of the ini file looks like this:

[UpdateServer]
updateserveraddress=updates.eq2emulator.net
updateserverport=9103

Note: As of the 0.6.5 release, the packaged LoginServer.ini is incorrect and requires this manual adjustment. This will be fixed in the 0.7.0 release.

http://www.eq2emulator.net/phpBB3/viewt ... p?f=9&t=97

This needs to be updated on the SVN as that's where I got my loginserver.ini from