kingdutka

http://www.scriptdev2.com/isle-masters-complete-t5188.html Uses ScriptDev2, but includes a Teleport Master. You can also get the Teleport Master itself without getting the Isle Of Masters Complete Set if you wish. Enjoy

I am VERY interested in anything that might fix the 'LEEEEROY!!!' achievement so if anyone gets this working, please post full instructions and if possible, let me know!

Just modified original post to contain full instructions. Enjoy!

The following will add stats, health, mana, and pet stats for levels that have missing information. (eg. Levels 81+ with WotLK, or ANY info in your tables that are incomplete, missing, corrupted, etc) It does this WITHOUT needing to add hundreds of lines to any of your Mangos DB tables. This is fully compatible with any custom info that may have been added to your Mangos DB tables already (such as adding lines to the 'player_xp_for_level' table) so if you've filled in ANYTHING, your info will be used. Furthermore, when new expansions are released and level limits increased and new information added to your Mangos DB tables, this code will NOT override ANY of those new additions, but rather automatically use those new additions the way it should be. Code: http://paste2.org/p/875074 Notes: Keep in mind, this will add a straight up "+2" to ALL your stats for ALL race/class combinations and your pets! If you want more variety, go ahead and add checks for each race/class combo or each pet and modify the data accordingly. It also adds a straight up 10% to health and mana for each level beyond 80 and each level will require 2% more XP than the previous. These modifications will ONLY occur when data is missing. If your tables don't have information filled in for levels beyond 80, or even if info is missing for ANY other levels, that information will be filled in automatically by this code. Furthermore, this code is COMPLETELY reversible! Decide you don't want to mod the stats? Decide to mod them differently? No problem! Make your changes, recompile, and restart the server and POOF!! All characters will be updated to your new code automatically! Remove this code completely and it's as if it never happened! PS: If you like this or find it useful in any way, you can show your appreciation by clicking "Thanks" in the bottom left corner of this post. If you're feeling extra supportive, check out my website! Links in my signature.

SD2 doesn't have included support for VS2010, but they specified on their forums that I could use the VS2010 Conversion Utility (which I and MANY other people have done). After the crash, when I run the debugger that allows me to continue playing, the debugger is specifying the errors are coming from Mangos related files , not SD2 files... The fact of the matter is, we don't have ANY output info at all to use to determine what the cause is... Since it DOES work without crashing if I use VS2010 to compile Mangos, but then use VS2008 to compile SD2, that leads me full circle to suspect the issue is with the VS2010 Conversion itself. Since my very first set of errors were related to 'linker' issues, I have to wonder if my 'fix' was only on the surface of the program, allowing it to compile but ultimately still not working correctly... "Differential diagnosis. What could cause...?" -House M.D.

I already tried a fresh clean install of MaNGOS + SD2 and it was actually WORSE... I couldn't even get it to compile at all... I do still have VS2008, but that's not the point. Don't fear change, embrace it. We need to move forward, not let ourselves get stuck in the past. My company will be switching to VS2010 EXCLUSIVELY and it would be nice to know how to use it effectively. What better chance to hone my skills than to practice on my own private projects? PS: I've been running my server since 2007.

No fix yet... I also posted this on the SD2 Forum and got replies of others also getting the crash. No replies from anyone for fix ideas...

Another bump... This thread has been around for a LONG LONG time... When is it going to be addressed?

Not sure when this started, but it was within the last month or 2. Sometimes I get invisible walls blocking me from entering areas like the basement to the inn in Kharanos. Right now I am about 80% done with the Mechanar and cannot continue... I am standing above Pathaleon the Calculator and cannot go down the tunnel leading down to him... I've had these invisible blockers stop me from entering all sorts of buildings. I am fairly certain logging out and back in doesn't fix it, but maybe restarting the server does. Lastly, it seems to be on a per character basis. I was questing with my wifey and she entered a building and I was blocked from entering. A week later, we went back to that building and I was able to enter but she couldn't. Another few days later, we were both able to enter. What is causing this and how do I fix it? This is a GAME STOPPING BUG!!! EDIT: I tried GM command '.gob tar' and it targets the elevator on the other side of the dungeon, so there isn't a game object that got spawned to block my path or anything... It almost feels like I am being blocked on purpose for some reason. Maybe I'm being flagged as a cheater somehow, even though I am playing 100% legit? Idk...

Not even a workaround for these achievements? "The Coin Master" "A Penny For Your Thoughts" "Silver in the City" "There's Gold In That There Fountain"

Ok so, I recently got Microsoft Visual Studio 2010 and used the mangosdVC100.sln to compile. It worked perfectly. I then converted my ScriptDev2 project to VS2010 using the VS2010 project conversion wizard. After that, I had a couple errors and was able to get them fixed. I'll post those next in case they are relevant to my actual issue: Error 1: 1>------ Build started: Project: ScriptDev2, Configuration: Release Win32 ------ 1> Extracting revision 1>C:\\Program Files (x86)\\MSBuild\\Microsoft.Cpp\\v4.0\\Microsoft.CppBuild.targets(990,5): warning MSB8012: TargetPath(C:\\WoW Server\\mangos\\src\\bindings\\ScriptDev2\\VC90\\..\\..\\..\\..\\bin\\Win32_Release\\ScriptDev2.dll) does not match the Linker's OutputFile property value (C:\\WoW Server\\mangos\\bin\\Win32_Release\\MaNGOSScript.dll). This may cause your project to build incorrectly. To correct this, please make sure that $(OutDir), $(TargetName) and $(TargetExt) property values match the value specified in %(Link.OutputFile). 1>C:\\Program Files (x86)\\MSBuild\\Microsoft.Cpp\\v4.0\\Microsoft.CppBuild.targets(992,5): warning MSB8012: TargetName(ScriptDev2) does not match the Linker's OutputFile property value (MaNGOSScript). This may cause your project to build incorrectly. To correct this, please make sure that $(OutDir), $(TargetName) and $(TargetExt) property values match the value specified in %(Link.OutputFile). 1> Creating library ..\\..\\..\\..\\bin\\Win32_Release\\MaNGOSScript.lib and object ..\\..\\..\\..\\bin\\Win32_Release\\MaNGOSScript.exp 1>precompiled.obj : error LNK2001: unresolved external symbol "public: virtual void __thiscall WorldObject::BuildUpdateData(class std::tr1::unordered_map<class Player *,class UpdateData,class std::hash<class Player *>,struct std::equal_to<class Player *>,class std::allocator<struct std::Pair<class Player * const,class UpdateData> > > &)" (?BuildUpdateData@WorldObject@@UAEXAAV?$unordered_map@PAVPlayer@@VUpdateData@@V?$hash@PAVPlayer@@@std@@U?$equal_to@PAVPlayer@@@4@V?$allocator@U?$pair@QAVPlayer@@VUpdateData@@@std@@@4@@tr1@std@@@Z) 1>..\\..\\..\\..\\bin\\Win32_Release\\MaNGOSScript.dll : fatal error LNK1120: 1 unresolved externals ========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ========== Fix: 1. Right-click 'ScriptDev2' in the Solution Explorer and choose 'properties'. 2. Change 'Target Name' from a variable to: MaNGOSScript 3. Expand 'Linker', click 'General. Under 'Additional Library Directories', the first directory in the list should be: ..\\..\\..\\..\\win\\VC100\\mangosd__Win32_Release 4. Click Apply and close the window. 5. Clean Solution, Then [b]RE[/b]Build Now both Mangos and SD2 are compiling successfully and I can turn the server on. However, now the server is crashing without any errors at all. The last thing in my server log: 2010-04-16 17:23:04 2010-04-16 17:23:04 >> Loaded 1453 Script Waypoint nodes. When it crashes, if I choose to Debug with VS2010, VS opens and a little window pops open with options "Break" or "Continue". If I choose continue, my mangosd.exe window stays 'grayed out', but it does actually continue to run and I can log in and actually play the game without any further troubles. My VS2010 debugger window: 'mangosd.exe': Loaded 'C:\\WoW Server\\mangosd.exe', Symbols loaded. 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\ntdll.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\kernel32.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\KernelBase.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\WoW Server\\libeay32.dll', Binary was not built with debug information. 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\ws2_32.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\msvcrt.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\rpcrt4.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\sspicli.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\cryptbase.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\sechost.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\nsi.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\gdi32.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\user32.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\advapi32.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\lpk.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\usp10.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\winsxs\\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.4974_none_50940634bcb759cb\\msvcr90.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\WoW Server\\dbghelp.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\version.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\msvcr100.dll', Symbols loaded. 'mangosd.exe': Loaded 'C:\\WoW Server\\ACE.dll', Symbols loaded. 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\mswsock.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\netapi32.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\netutils.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\srvcli.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\wkscli.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\msvcp100.dll', Symbols loaded. 'mangosd.exe': Loaded 'C:\\WoW Server\\tbbmalloc.dll', Symbols loaded. 'mangosd.exe': Loaded 'C:\\WoW Server\\libmySQL.dll', Binary was not built with debug information. 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\wsock32.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\imm32.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\msctf.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\nlaapi.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\dnsapi.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\winrnr.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\NapiNSP.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\pnrpnsp.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\wshbth.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\rasadhlp.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\WSHTCPIP.DLL', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\WoW Server\\MaNGOSScript.dll', Binary was not built with debug information. The thread 'Win32 Thread' (0x2578) has exited with code 0 (0x0). Unhandled exception at 0x7770dcbb in mangosd.exe: 0xC0000374: A heap has been corrupted. 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\IPHLPAPI.DLL', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\winnsi.dll', Cannot find or open the PDB file 'mangosd.exe': Loaded 'C:\\Windows\\SysWOW64\\FWPUCLNT.DLL', Cannot find or open the PDB file So... if I leave the VS2010 debugger open, I can keep running the server and am able to play, but it is using up extra resources and looks ugly taking up unnecessary space on my task bar... Any help at all on this would be much appreciated!

The last 'pastebin' script I posted DOES work!! Had anyone actually taken a few seconds to test it out for me, they could've confirmed it IS in fact working! So how did I figure this out? Dumb luck! For some reason, my scriptdev2.config file got overwritten with a default one and it wasn't actually accessing the DB!!! As soon as I changed the config file from: ScriptDev2DatabaseInfo = "127.0.0.1;3306;mangos;mangos;scriptdev2" To: ScriptDev2DatabaseInfo = "127.0.0.1;3306;root;mangos;scriptdev2" Voila!! Ok, so now I feel like an idiot for that, but now I can get the rest of my code done and get my new release of the mod out!

Seriously guys, I have this all down to the very utmost simplest form and it is still returning no results... Check out this code and tell me if you see ANYTHING wrong with it... http://pastebin.com/m6a686c38 I honestly can't figure out for the life of me why my creature is always whispering "Cannot access DB!"....

I figured that's what it was, but I only did so in attempt to cut down on repeat code... I can fix that no prob. Still can't figure out why the DB won't give me any results tho... I've looked at every bit of code I could find and mine is pretty much identical.. I even tried copy/pasting code from system.cpp, overwriting my query, and still no go...

The only thing I've been able to come up with so far is another glitch... With the current code above, ( Returning "Cannot connect to DB!" for my monster whisper), if I close the dialog window and re-open it, then talk to him again, he says: "Cannot connect to DB!Cannot connect to DB!" Every time I close the window and try again, another one gets added: "Cannot connect to DB!Cannot connect to DB!Cannot connect to DB!Cannot connect to DB!" So although the original problem with not being able to connect to the DB is still the most prevailant, I now need to know how to clear out the memory of that 'ss' variable: QueryResult* pResult = SD2Database.PQuery("SELECT cost FROM telenet"); if(!pResult){ ss << "Cannot access DB!"; _Creature->MonsterWhisper(ss.str().c_str(), player->GetGUID()); ss << ""; return; } This does not work... As you can see, I am definitely a C++ NOOB, but I am learning a lot here! Again let me re-iterate, I STILL cannot get "pResult" to return any values which is the single most important thing I need to do here... Once I get that, I think I can figure out the rest and quit buggin everyone PS: I updated the code at that pastebin link in my last post to include the ENTIRE cpp file. The test code starts at line 1832.

QueryResult* pResult = SD2Database.PQuery("SELECT version FROM sd2_db_version LIMIT 1"); if(!pResult){ ss << "Couldn't access DB!"; _Creature->MonsterWhisper(ss.str().c_str(), player->GetGUID()); return; } Monster says: "Couldn't access DB!" I just don't understand it... I have the include at the top of my script, it's compiling, and I was sure to copy the new compiled files to my server folder... EDIT: Does it matter if I have the code embedded in a 'case'? I stuck all my relevant code into 'pastebin'. This link is good for one month or until the issue has been resolved and I delete the post: http://pastebin.com/m18d16145

Ok, 'VERY' was an overstatement I don't wanna turn this into a debate about MaNGOS vs. SD2 cuz that would essentially be thread hijacking would it not? So, I have confirmed the issue is with my query returning nothing, but I don't understand why... I even went so far as to: QueryResult* pResult = SD2Database.PQuery("SELECT * FROM script_waypoint"); if(!pResult){ ss << "Couldn't access DB!"; _Creature->MonsterWhisper(ss.str().c_str(), player->GetGUID()); return; } And that's what my creature is saying... "Couldn't access DB!" I know my query is correct because I can run it in SQLyog and it is returning the exact field I am looking for... Oh, and I have this at the top of my script: #include "Database/DatabaseEnv.h" extern DatabaseType SD2Database;

Ok.... But that doesn't help me fix the problem at all! I am VERY new to this kind of code and am asking for help figuring out what to write... What's wrong with posting on 2 VERY DIFFERENT forums?? That's just ridiculous!

Making progress!! This code compiles but crashes MaNGOS: QueryResult* pResult = SD2Database.PQuery("SELECT Cost,Name FROM telenet WHERE ID=1"); Field* pFields = pResult->Fetch(); std::stringstream ss; ss << "You spent " << pFields[0].GetUInt32() << " on your teleport to " << pFields[1].GetString() << std::endl; _Creature->MonsterWhisper(ss.str().c_str(), player->GetGUID()); While this code compiles and does not crash but... QueryResult* pResult = SD2Database.PQuery("SELECT Cost FROM telenet WHERE ID=1"); std::stringstream ss; ss << "You spent " << pResult << " on your teleport." << std::endl; _Creature->MonsterWhisper(ss.str().c_str(), player->GetGUID()); It prints this: "You spent 000000 on your teleport."

Basically, I need to be able to read in values from a given table for use in a custom script, but I have no clue how C++ and MySQL are working together... For example, how would I make the following work (used in a custom *.cpp): std::stringstream ss; ss << "You spent " << {SELECT cost FROM telenet WHERE id=1} << " on your teleport." _Creature->MonsterWhisper(ss.str().c_str(), player->GetGUID()); I am thinking to make my own custom table added to the SD2 database. 'Telenet' would be my custom table and 'cost' and 'id' would be a couple of the columns. I have been asking for help on this in both the UDB Forums and the SD2 forums, but not getting anywhere at all on either... I even went so far as to ask on the MySQL forums and still get nothing...