[TWO]Script loading

[tallah]

Howdy folks,

Hoping to receive a little help here. I don't know how often people read/reply to this thread but better to ask than to not ask.

So I have spent the past few days setting up a ManGos Two server just for kicks and giggles and to hopefully learn some stuff. Once I followed all the directions on the github wiki for MagosTwo windows generic guide I was finally able to logon to my server, create an account etc.

While looking over some commands and instructions, I noticed this command .load scripts if I understand correctly everything in WoW is done in c++ scripts, and I did follow the guide to the letter, minues one or two steps that didn't have a troubleshooting guide, or just from figuring out on my own. When I look inside my sql database I see things like creature ai scripts, creature linking, creature this and that. Also upon loading into the server, it is literally dead empty, so I am wondering how to load the spawned npcs, quest givers, monsters etc. I did a silly little thing

.loadscripts world

since I assumed the world fles would have npcs in it, and then my server started crashing. I was using my defauly administrator account to do this, so now every time I load in that character my ManGosd crashes.

Also, upon booting my server I see things like

2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName boss_doomlord_kazzak is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName boss_doomwalker is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_aeranas is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_ancestral_wolf is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_demoniac_scryer is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_wounded_blood_elf is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_fel_guard_hound is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName mob_lump is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_maghar_captive is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_creditmarker_visit_with_ancestors is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_manaforge_control_console is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_commander_dawnforge is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_bessy is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_maxx_a_million is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_zeppit is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_protectorate_demolitionist is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_captured_vanguard is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName mob_mature_netherwing_drake is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName mob_enslaved_netherwing_drake is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_dragonmaw_peon is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_wilda is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_lord_illidan_stormrage is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName mob_torloth is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_totem_of_spirits is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_spawned_oronok_tornheart is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_domesticated_felboar is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_shadowmoon_tuber_node is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_veneratus_spawn_node is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_dirty_larry is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_khadgars_servant is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_salsalabim is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName mob_unkor_the_ruthless is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName mob_netherweb_victim is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_akuno is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_hungry_nether_ray is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_letoll is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_mana_bomb_exp_trigger is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_captive_child is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_isla_starmane is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_skywing is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_cenarion_sparrowhawk is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_cooshcoosh is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName npc_kayra_longmane is not assigned in database. Script will not be used.
2014-09-08 00:27:13 <SD2 ERROR>: Script registering but ScriptName event_taxi_stormcrow is not assigned in database. Script will not be used.
2014-09-08 00:27:13 >> Loaded 179 C++ Scripts.
2014-09-08 00:27:13 Scripting library loaded.

this list is really massive so for the sake of not making a big wall of text, i just grabbed a little snippit I can how ever load the full load if needed. from my own guess I can clearly see that this has something to do with scriptdev2 but my script dev sql database was empty, so i tinkered around with some of the sql scripts in my folders that I obtained from following the guide.

Help is greatly appreciated, and many thanks goes out to all

[antz]

You need to apply a db update:

sql/scripts_sql/mangos_scriptname_full.sql

[tallah]

I did that though otherwise the server wouldnt start. I will gladly try again after lunch, thank you though

[Hikari]

Also upon loading into the server, it is literally dead empty, so I am wondering how to load the spawned npcs, quest givers, monsters etc.

Seems like you set up the world database only with the bare structure from the server repository. You can find the database with populated data at https://github.com/mangostwo/database.

[tallah]

You need to apply a db update:

sql/scripts_sql/mangos_scriptname_full.sql

I did that, after I saw your ost, and it didn't really change anything, as my serverlog still spews out serveral things missing or not being used.

Seems like you set up the world database only with the bare structure from the server repository. You can find the database with populated data at https://github.com/mangostwo/database.

I have the database already, and it should be installed in my sql dbase, as when i look in the mangos database it shows everything that is listed in the database that you linked hikari so I am still confused.

I ran the command loadscripts and added world, as i thought that was the library it was looing for, but that just kills the server, and chat will say " script library is not accesible or assigned"

So I am really curious what do I need to do to populate my world with npcs?

I followed the guide here to the letter, so i don't know what's up.

if it would be okay, and possible I cna post my server log, script dev2 log and crash logs via pastebin or something

[Hikari]

[..] i look in the mangos database it shows everything that is listed in the database that you linked hikari so I am still confused.

Sure, it shows you the tables (structures). But if you open a table (e.g. creature), are there any data inside?

[madmax]

if you like, i dont mind coming on teamviewer and doing this for you? you will need skype though. if you want todo this private message me your skype id

[tallah]

Sure, it shows you the tables (structures). But if you open a table (e.g. creature), are there any data inside?

I've never really used SQL before, so I don't know eactly but I think that has data in the creature table ? I was expecting names of creatures, instead of id's lol

I will message you in a few hours Max with skype and teamviewer stuff

[tallah]

okay so my databases have data in them, but i can not figure out what i need to do to populate my world, i thought using the load script command would work, but no dice.

scriptdev2 has only a few tables in it, with only a few entries. custom text, gossip etc.

so where or how do i load the script library

[tallah]

o,.O I don't know what I did, I just rebuilt all of my databases a few times, and now everything seems to work. woo I see npcs and such so that's a start. Thanks for everyone trying to help, and I apologize if I wasn't the most cooperative or uninformative.