rumpilstilskin

Thank you Kreegoth for these info. Not satisfied with items that show ? as an image. Could you give me references, eventualy a link for the addon you mentionned?

OK, Thanks

Well the idea is to creat new items with unexpected action... trying to creat a little surprise in the game... so I do need free entry/displayid for consumable items and spellid for transportation^^

Hello everybody, Wondering if you know some liste of free entry/displayid for consumables. I have a list of free entery for weapons and armors, but nothing for consumables. Latly I created a serie of quest where players meet a npc that offers a mushroom to tast... named "eat me" for example^^... they are then transformed or transported in a specific place... to creat this items I have to search for existing items that are of little use, like mushrooms sold at Sporeggar, modifie the items and delete them from the list of the npc so they exist only in my quest... I would rather not modify existing items and take free entry/displayid of consumables if such a list exists... Also I wonder if you guys know about spellid for transportation. Found the spellid for transportation at Goldshire (31), Westfall (33) and on a montain at the Ice Crown (67836) ... are they other? Thanks !

Thanks for your answers, Looks like I won't visit developer's island... seems a bit complicated... too bad.

Hello everybody, Well I thought I saw everything in this enchanting world... from the peacfull white montains of Winterspring to the fascinating forest of Darkshore... well it seems some places stayed secret to me like an Island of programmers Now the question is how to get there ! ... found a guide how pointed a certain ".prog" for transportation but it failled ! Anyone knows a good taxi that could take me there for a visit? Wouldn't argue for the price ! Thanks !

Ok, Thank you for these info Patman.

Hello everybody, Wondering if you could give me a few tips regarding Quice. There are those two Flag options for example... number of option are mysteries... I manage with checking on configuration of existing items and creatures, but I would very much appreciate understanding more about this ! For example what does all the UNK_XX stand for? We find this also in item templates unk0, often set at -1. What does it stands for? Also I would like to modifie spellid. For example there is the spellid 48776 that gives you a 10% bonus velocity on mounting. I would like to acces this spellid and make some modifications. Do anybody knows where to acces the SQL Script of these spellid ? Thanks ! ... might have posted in the wrong place... sorry about that.

... found a lovely little bunny... wasn't in chocolat... but tasted fine !^^

Happy easter to you

Thank you Earthwalker, Think I saw this post concerning AHbot. Not for our server, it's a linux patch, we are on Windows. Anyway, AHbot was fun, but in my opinion has the big default of authorising any absurde price for any sort of items... freinds where puting junk at hundred po's... I prefer to stop this and work on creating quests with rewards a small group can't find otherwise.

Thanks! It works. Forgot to check on the settings of the new scripdev2.conf ^^

Thank you Cartman87, Could you please explain me where to modifie this acces right? Checked on mangosd.conf, didn't see anything relating to SD2 DB.

Hello everybody! Finaly upgradet to UDB 401. I hade loads of error messages with all the "corepath-mangos" and "corepath_characters" from 394 to 400 and no error messages in the "updatepack" files... Hope my database is not to messy ! Anyway we needed this upgrade, especialy for the Wotlk quests how needed lots of work on our 393 version^^ Strangely, the patches I have created are still in place. I have created a daily quest with five npc for example and it is still there... thought it would be erased with the update... Also the mining and herbs spot I have included in Elwynn forest are still there... Checked on the quest in Valgard, also Utgard instance that weren't working to well on 393, there is lots of improvements ! I have a problem with ScriptDev2. My configuration is : UDB 0.12.1 (401) MaNGOS 11376 SD2 SQL 2036 ScriptDev2 (for MaNGOS 11167+) Have the following info on the logserver : 2011-04-22 12:18:12 MMM MMM MM 2011-04-22 12:18:12 M MM M M M M 2011-04-22 12:18:12 MM M M M 2011-04-22 12:18:12 MMM M M M 2011-04-22 12:18:12 MM M M MMMM 2011-04-22 12:18:12 MM M M M 2011-04-22 12:18:12 MMM MMM http://www.scriptdev2.com 2011-04-22 12:18:12 2011-04-22 12:18:12 SD2: Using configuration file scriptdev2.conf 2011-04-22 12:18:12 2011-04-22 12:18:12 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'mangos'@'localhost' (using password: YES) 2011-04-22 12:18:12 ERROR:SD2: Unable to connect to Database. Load database aborted. 2011-04-22 12:18:12 SD2: Loading C++ scripts Would appreciate a feedback! Thanks!

Thank you, Working much better^^ Very interesting this CachVersion reset option in mangosd.conf ! What should the value be? By default it's at 0. I don't understand the option. ClientCacheVersion # Client cache version for client cache data reset. Use any different from DB value and not recently used for triggering reset. # Default: 0 (use DB value from world DB db_version.cache_id field) Thanks !

Hello everybody, Something I don't understand about sql patches. Certain patches I creat apply immediatly in game - after a new log of course - other take one or even a few days to appear in game. Could it be a bug in my install? Is there a commande order that I should use to immedialtly apply my patches? Thanks !

Thanks ! Guess I will upgrade soon to 400... waiting a will that freinds can enjoy AHBot before doing that^^

Hi everybody! Working on updating Karazhan for my 393 version and I would like to try my improvements without waiting days for Karazhan to be up. Searched in mangosd.conf but didn't find an option to modifie raid timmer. Guess it could be modified by an sql patch but i'm just starting with sql. Would appreciate an idea^^ Thanks!

Ok, thank you ! I can throw them then !

Hello everybody! Starting playing with creating patchs in SQL. It's fun. Tryed today to creat my first quest... managed to creat my npc, but still work to be done for the quest. Anyway, was back in my bin folder and saw this growing list of "logSQL.sql"... I didnt mind about these, but there is maybe ten of these now... opened the last one, goes like this : DELETE FROM creature WHERE guid=151044; INSERT INTO creature VALUES (151044,77001,571,1,1,0,0,5836.4,649.724,647.512,5.7742,25,5,0,0,0,0,0); 77001 is the entry of the npc I created today... So I wonder, are these "logSQL.sql" automatic creations of sql patches too correct errors? If so I assume I should run them. Thanks for your help!

I can partially answer your question. I run AHBot with a 3.3.5a client. But my UDB is 393 for mangos 10545 SD2 rev. 1833 ACID 3.08. I tryed to update to UDB 399 and had the same problem that you have... that doesn't mean AHBot cant run with 399... I am new at this, it's possible I updated wrong...

I am sorry MCP if my contribution here gave the impression that I minor the purpose of this project. My aim was only to try to clarify things here. Right to education seems - to me - not precise enough to define the mangos project. It's a little bit vague. What education project ant towards what population could be legitimat questions. And as explained very clearly by Unkle, I do thing that we have legal bases - in certain limits - tu continue peacefully this nice project^^

My mistake. Patman clearlly mentionned that Auction House patch must be re installed. I tryed over again... failed in re installing AHBot. Every thing whent with no error up too checking : git apply --check gitAddon/AHBot/ahbot.patch file ahbot.patch wasn't found. Strangely the patch was in the folder... mysteries of computers^^... more likelly made an error^^... can't see what error, tryed again from the beginnig, had the same failor erro. Got some more work to be on the level!

Ok, I tried to update from core 393 to core 399. Wasn't a great succes. Hopefully I had a backup like you advised me and we are back on 393^^ Would appreciate your advise on how to have it right. Followed Patman's guide. 1/ Updated Mangos - Right click on C:\\Mangos launched GIT GUI and merged with succes. 2/ Updated ScriptDev2 - Right click on « C:\\Mangos\\src\\bindings\\ScriptDev2 » folder and "SVN Update" 3/ Re-compiled Mangos - C:\\Mangos\\Win - Opened my sln file mangosdVC90 for C++ 2008 « Build » with no error message. 4\\ Re-compiled ScriptDev2 - Opened my sln file: scriptVC90.slnForC++2008 « Build » with no error message. 5/ Installing Mangos. This I didn't understand and I skiped. It is indicated to re install Mangos. But my « mangosd.conf.dist.in », « realmd.conf.dest.in » and « scriptdev2.conf.dist.in » files seemed not changed. They still had the same date - weeks ago - than for my first install. I didn't see way copy them to replace my actual « mangosd.conf », realmd.conf » and « scriptdev2.conf » if they were the same. It is indicated in the guide to check if Mangos version had changed at this point and if so to delete folders « Maps, DBC, Vmaps and Buildings. My Mangos version didn't change so I continued. 6/ Downloaded patches from UDB 394 to 399. 7/ Extracted patches through SQLyog. Had some error messages when extracting the corepatches_mangos but no error messages on extracting the updatepacks_mangos. Example : Error code: 1054 - Unknown colum required - 11117_01_mangos_world_template in db_version This an sql I extracted for my first install… Should I have tried to re install it? I ignored these error messages and continued my install. At the end my configuration was 399 with mangos and scripted upgraded. 8\\ Opened SQLyog, mangos, pasted « scriptdev2_script_full.sql » and launched the query. 9\\ Re-configuration of Mangos. Seems to be the same step than in 5... Did nothing. With the different errors messages I skiped and part of the updating I didn't understand, I thought mangosd.exe wouldn't run… In fact it did^^ Connected to the game. But nothing seemed to have changed. For example I have problems with pools of minerals and herbes; almost non existing in Elwynn forest and Westfall. After talking over this mater on UDB forum, I thought it might be related to the 393 version. When connected with 399 version it was the same. Travelled throw Westfall without seeing one pool. Also the AHbot seemed not to be launched when running mangosd.exe. My questions are : 1/ did I miss a step in updating? 2/ error messages like reported at updating are they acceptable? 3/should I re-install AHbot if I want to have it running on a new version? Ultimatly would it be a problem if I installed two different version of server on my pc and could I update on a new version the « characters » database of a previous version to play with the caracters created on the first version of my server? Thanks!

I dont know that this right to share your knowledege is denied^^