profs, rep, scripts and npc a bit of everything

[locksoft]

Hi all, this is my first post so please forgive all my noob questions. I tried to use the forums search functions but still have some questions unsolved. so far I tried 3 ascend packs and the one that seemed better for me uses mysql installation and 2.4.2.

in this version trainers are working (they didn't in 2.4.1) but I've a problem with professions. I trained Enchanting but I can't learn formulas. if my skill is below the min level I correctly get "I still can't learn that) but if my level is correct nothing happens when I right click it. I don't know if this problem is there for other professions too. how can I solve it?

i found that reputations are in a field in the char table in db but I can't figure out the order and the values. I'd like to duplicate my real wow char and not put everything to max, is there any utility that can help me to set values?

i see that most bosses are not scripted, is there a place where to find these scritps? and then how to use them? just put in the script folder?

in real wow server there was the summer fest, I don't really need the whole event but I'd like to be able to spawn Ahune (the frost lord) with it's loot table but it seems there's not in database. is there any way to add it?

same for new quel'danas island. if I port there (no way to go there elsewhere) there are no npc and can't access to instances. maybe I still don't know how Ascent works: to have an instance you need to have it's data in mysql? is there a way to add those values?

.modify damage x y only seems to work for melee damage, not for spells. only way to alter it is to change spell values in the db?

I'm a shaman and I got all spells and all totems but the "Wrath of Air" one. do you know if it's possible to insert it someway?

I played a bit with .learnskill and I was able to quip guns and bows (they don't seem to work but who cares), but I'd like to learn the "main hand" one, to use 1h swords and so. how can I do?

well, I think enough quests for now, sorry for long post and thanks if you can help me to better understand this new (for me) wonderful world. :]
sunwell

[TheSpidey]

[quote=locksoft;941552]in this version trainers are working (they didn't in 2.4.1) but I've a problem with professions. I trained Enchanting but I can't learn formulas. if my skill is below the min level I correctly get "I still can't learn that) but if my level is correct nothing happens when I right click it. I don't know if this problem is there for other professions too. how can I solve it?[quote]This is a known issue, most large DBs have this fixed already

i found that reputations are in a field in the char table in db but I can't figure out the order and the values. I'd like to duplicate my real wow char and not put everything to max, is there any utility that can help me to set values?

Don't know of any utility (though quite easy to make), but it should be in the format of faction,value;faction,value; etc.

i see that most bosses are not scripted, is there a place where to find these scritps? and then how to use them? just put in the script folder?

The two main teams that make blizzlike scripts are Moon++ (C++) and Lua++ (Lua).
For C++ you'll have to compile the source files and put the DLLs in your scripts_bin folder; Lua only need to be saved as .lua and be put in your scripts folder.

in real wow server there was the summer fest, I don't really need the whole event but I'd like to be able to spawn Ahune (the frost lord) with it's loot table but it seems there's not in database. is there any way to add it?

Either find a DB that has him, or try to make him yourself :P

same for new quel'danas island. if I port there (no way to go there elsewhere) there are no npc and can't access to instances. maybe I still don't know how Ascent works: to have an instance you need to have it's data in mysql? is there a way to add those values?

DB issue. You need the worldmap_info table to have the proper values for the new instances. NPCs are also part of the DB, you'll need to find one that has them spawned.

.modify damage x y only seems to work for melee damage, not for spells. only way to alter it is to change spell values in the db?

No, you can't mod your spell damage using .modify. You can, however, create an item that will add the desired amount of spell damage to you.

I'm a shaman and I got all spells and all totems but the "Wrath of Air" one. do you know if it's possible to insert it someway?

Go to playercreateinfo_spells and add the spell there

I played a bit with .learnskill and I was able to quip guns and bows (they don't seem to work but who cares), but I'd like to learn the "main hand" one, to use 1h swords and so. how can I do?

Guns and bows also need the "Shoot" or "Auto Shot" spells. There's no skill for 'main hand', there are different skills for each weapon type. You can find the values in the DBC

[locksoft]

many thanks for all answers! +Rep