Yep, that's correct. There was no sql update for the scriptdev2 just a core update.
Printable View
Yep, that's correct. There was no sql update for the scriptdev2 just a core update.
@CT:
ok thank you very much thought maybe my old mind missed something ty great work bud
What I can do is edit the version tables each time I update... that's not a problem; it'll probably make it easier to distinguish if an update has been applied.
For mangos and empty DBs:
For scriptdev2 DB:Code:UPDATE db_version SET version='TRM CU 0014 YTDB 340 Acid 35 MaNGOS 10410 ScriptDev2 1809';
Update Available:Code:UPDATE sd2_db_version SET VERSION='TRM CU 0014 ScriptDev2 1809';
CU_0015.zip (10.69 MB)Code:MaNGOS updated to 10412 (required_10411_01_mangos_spell_proc_event)
Appreciate your quick response. Is there anyway i can apply this command automagically for anyone starting a death knight without making everyone a GM? Or will everyone have to msg me and ask me to autocomplete the quest for them so they can continue?Quote:
Originally Posted by skiik
It's a bug we'll have to deal with until I can code a fix (or find one), so for the time being I guess you'll have to complete it for them or give them the ability to use the .quest complete command.
Update Available:
CU_0016.zip (10.69 MB)Code:MaNGOS updated to 10415
ScriptDev2 updated to 1812
Ok thanks for your help and all the hard work you have and continue doingQuote:
Originally Posted by CthulhuFtagn
I thought id make a list fo bugs ive found so far from my travels in azeroth. Not sure what is fixable and whats not but ill list them anyway and update them as i find more
- Shaman EarthBind totem does not slow mobs when running away and dropping one as you run(i think the issue is around when it procs. On blizz wow server it procs on drop so you get to run away and avoid death)
- Death Knight quest "Death Comes From On High" cannot be completed as you cannot control the eye
- Armor Vellums cannot be used for enchanting.(More info here https://mangos.lighthouseapp.com/pro...g-enchantments)
Ill add to the list as i find more
Cheers
Thanks, I'll add those to the list-o'-bugs.
Update Available:
CU_0017.zip (10.69 MB)Code:MaNGOS Updated to 10417 (required_10416_01_mangos_spell_proc_event)
ScriptDev2 updated to 1815
thank you very much
@CT:
all 3 of the last updates, 0015, 0016, and 0017 went in sucessfully with no problems and everything runs great keep up the great work you're awesome ty
Thanks Granpa, hope your grandkids are enjoying it.
@CT:
yup they are my one son, who has 4 children said its hard to get them off the their pc and into bed at nite. they do miss the auctionhouse tho but we pretty much give them what they ask for. lol keep up the great work CT
Awwww such a sweet story. My oldest is about 2. Hmm wonder if thats too young to start...
Quote:
Originally Posted by GrandpaJohn
This release is for the coolest granpa in West Palm Beach, Florida: GranpaJohn.
Update Available:
CU_0018.zip (10.77 MB)Code:MaNGOS updated to 10418
AHBOT added with Readme file
Characters DB updates for AHBOT
Updated mangosd.conf with AHBOT information
http://img841.imageshack.us/img841/2327/ahbot.jpg
Wicard, you're the man...
Quote:
Originally Posted by CthulhuFtagn
Fixing some errors with the Armory... will update tomorrow morning.
Optional MaNGOS Blizzlike Armory:
UPLOADING (128 MB)
How to install the MaNGOS Blizzlike Armory:
Delete all files inside the C:\Server\htdocs folder
Extract the Optional_Armory.zip file to anywhere
Stop the MySQL Service by either:
1. Closing the mysql.bat file
or, if you have installed mysql as a service
2. Click Start > Run (or Windows Key + R) and type services.msc
Look for the MySQL service, double-click it and click Stop
Copy the extracted Server folder and overwrite the current C:\Server folder
Restart the mysql service
Start the apache service (if it's not already started)
Note: If you have teamviewer running, it will interfere with apache.
1. Double-click the Apache.bat file
or
2. Double-click C:\Server\apache\apache_installservice.bat to start it as a service
Now open a browser and go to http://127.0.0.1 (or, if you are using a no-ip.org etc address through port 80, go there) and voila!
http://img547.imageshack.us/img547/6523/armory.jpg
To edit the configuration go to C:\Server\htdocs\configuration\ and you can edit the mysql.php and settings.php files using your favorite text editor.
how to create my own realmist??
Send me a message to [[email protected]]
@CT:
it went sucessfully, server running great and the auctionhouse works perfect thank you so much, now they can buy their own stuff and say look what i bought, even tho most of it will be less valuable than what my son and i gave them. LOL just because they accquired it on their own. you're amazing keep up the great work we all love ya
Right on! Accomplishments are accomplishments; so long as they feel, at least, that they've done something epic it's great. Love you guys too.
Sorry I'm having problems following the last step to make the AHBOT work. Step 5.) Tune the configuration options in the configuration file and the Database. Where can I find the configuration file and the Database? Thank You
Make sure you create a toon for the AHBot first, and log in atleast once with that toon.
The new mangosd.conf file contains the new information to be edited, here's my configuration:
You'll have to go into your database to assign one of your toons as the AHBot, here's how to find the AuctionHouseBot.Account and AuctionHouseBot.GUID numbers.Code:AuctionHouseBot.EnableSeller = 1
AuctionHouseBot.EnableBuyer = 1
AuctionHouseBot.Account = 6
AuctionHouseBot.GUID = 2
AuctionHouseBot.VendorItems = 1
AuctionHouseBot.LootItems = 1
AuctionHouseBot.OtherItems = 1
AuctionHouseBot.No_Bind = 1
AuctionHouseBot.Bind_When_Picked_Up = 0
AuctionHouseBot.Bind_When_Equipped = 1
AuctionHouseBot.Bind_When_Use = 1
AuctionHouseBot.Bind_Quest_Item = 0
AuctionHouseBot.ItemsPerCycle = 200
AuctionHouseBot.UseBuyPriceForSeller = 0
AuctionHouseBot.UseBuyPriceForBuyer = 0
1. Make sure MySQL is running
2. Download and install SQLYog from http://code.google.com/p/sqlyog/downloads/list
3. Open SQLYog and make sure the connection looks like below
Click New, name the connection MaNGOS
http://img840.imageshack.us/img840/8781/accountaj.jpg
username is root password is mangos
Now click Connect
Click the + next to the characters database on the left, then right-click on the characters table and click Open Table
Click to enlarge:
http://img833.imageshack.us/img833/1162/charactersc.jpg
Look for the toon you created and note the guid and account numbers, as you can see from my AHBot config I used Loktar as my bot.
AND, since people can't bother to READ the ReadmeAHBOT.txt file I included, make sure to set your min and max items for your auctions.
Here's my settings:
I put the Readme files there for a reason.Code:UPDATE auctionhousebot SET minitems = "100" WHERE name = "Alliance";
UPDATE auctionhousebot SET maxitems = "500" WHERE name = "Alliance";
UPDATE auctionhousebot SET minitems = "100" WHERE name = "Horde";
UPDATE auctionhousebot SET maxitems = "500" WHERE name = "Horde";
UPDATE auctionhousebot SET minitems = "100" WHERE name = "Neutral";
UPDATE auctionhousebot SET maxitems = "500" WHERE name = "Neutral";
You should get something like this when you click Search:
http://img641.imageshack.us/img641/6894/auctionsm.jpg
Now your Auction House should be populated when you start up the server.
Awesome TRM. Updates worked flawlessly and I love the AH :). Thanks.
And as for that issue I was having earlier where skills/talents weren't saving - I reinstalled and only executed the essential character sql files and it's fine now, so I am guessing it was a corrupted sql file somewhere.
Well, I'm glad you got that issue worked out. Hopefully I can keep the updates rolling without hiccups.
Update Available:
CU_0019.zip (12.96 MB)Code:MaNGOS updated to 10422 (required_10422_01_mangos_spell_proc_event)
Added correct vmap extractor to the tools folder
Added an updated Quice DB Editor (1.2.53)
http://img291.imageshack.us/img291/7662/quice1.jpg
username: root
password: mangos
http://img828.imageshack.us/img828/3222/quice2.jpg
When using Quice, make sure to set your DBC path (where you placed your dbc folder).
Click Settings > Set DBC Path...
Make sure it looks like below (I'm using the 64-bit version)
http://img411.imageshack.us/img411/4963/quice3.jpg
@CT:
all updated everything is working great havent tried the armory yet dont know if i want to sounds complicated what is it basically for ? anything important ? if noyt think i'll just let it be. your updates are the greatest they go in so easy
Thanks, the armory is giving me some problems so I took down the link until I can work them out... it's nothing important unless you want a fancy-schmancy wow-like armory for the website.
@CT:
oh naa not really i dont even use the web site so i dont reckon i need that
It's gonna be a lot of work to get it updated and working well with 3.3.5a so I'll keep you informed, but I wouldn't worry about it at all. Looks like it's a slow day for updates, hasn't been one in MaNGOS, ScriptDev2, or YTDB in atleast 8 hours... gives me more time to work on other things.
EDIT: Had a break thru... looks like the Armory is working great now! w00t!
http://img37.imageshack.us/img37/8055/armorysm.jpg
Looks great man, awesome work as always:)
It took a lot of prodding and poking in .php files and configs but I finally got it going... going to do a few more tests with character information, but I think it'll be in the next release.
EDIT: Oh, yeah! A few 'little' bugs, like it's only showing the main hand on my rogue, but it works well enough.
http://img39.imageshack.us/img39/8055/armorysm.jpg
Hi TRM just wanted to say thanks a million for putting in the AHbot. That was the one thing I was hanging out for as I play solo!!! Makes it feel like the real servers now. Thanks again.
Thanks for AHBOT.
Great job.
Thanks
Thanks for everything will make donation this week.
Hi Cthulhu Ftagn,
First of all i want to be apolagyzed about my bad english :eek:
The repack it's awsome... i'm already runed him... +rep
I've got all updates without problem...
Already i'm install the ahbot and if you can give me some commands i can't run him... :) (bow)
I saw a few posts back, something about the website with armory ... and have a some questons about it:
1.Can i use it with MangosWeb Enhancement?
2.Do u have a website with the armory which run on deck?
and if you could send me a link and a small installation guide for it I would be very grateful ... and if all goes well for you to donate for the good work.
Thanks in advance.
Hello Cthulhu Ftagn I once asked a couple of you could perhaps ICC, Ulduar
and (Trial of the Crusader) was a great scripts mega nice of you!
The server wow Titans is fully scripted what you can perhaps steal or something
Greetings Ellenya
Sorry for my english I'm German xD
Anyone know if battlegrounds works? I tried going into warsong gulch with my lvl 18 char and the instance entrence is red and i cant enter...
Also is there a list of instances that are and are not working properly at lvl 80 so i can post it on my motd to manage expectations.
Thanks in advance
You're very welcome.Quote:
Originally Posted by jimmy6666
It's not a playerbot, it's an auction house bot that populates the auction house; you don't "run" it. But my tutorial is at this post ClickQuote:
Originally Posted by Stefan30
1. The armory isn't uploaded yet, and I have never used MangosWeb Enhancement.
2. What is "deck"? The installation/configuration guide for the current website is already on the first page.
Well, I'm not going to "steal" anything. Plus you can't steal scripts.Quote:
Originally Posted by ellenya
There is not a list of working/non-working instances; but you can do this for certain "events".Quote:
Originally Posted by skiik
This one was a PM, but I'll post the answer here so that it might help others who are using the server on their LANS:Code:.lookup event NAME
.event start ID
1. Press Start > Run OR Windows Key + R this will bring up the Run boxQuote:
Originally Posted by Narcoleptic
2. Type cmd and press OK
http://img204.imageshack.us/img204/7267/run1p.jpg
3. Type ipconfig /all at the command prompt press Enter
http://img245.imageshack.us/img245/2758/ipconfig.jpg
4. Now find your internal IP address (it should start with 192.168.#.#), as you can see mine is 192.168.1.15
http://img291.imageshack.us/img291/8376/ipv4a.jpg
How to edit your database:
Install SQLYog: SQLyog
Make sure you have C:\MySQL.bat running (or MySQL running as a service), then load it up and click Continue, then make sure your connection looks like below:
(Click New to make a connection)
http://img821.imageshack.us/img821/1239/pass.jpg
Username is root
Password is mangos
Now click Connect
1. Click next to the + of the realmd database.
2. Right-click on the realmlist table and click Open Table.
3. Now edit the address portion by double-clicking where it reads 127.0.0.1 and change it to your internal IP address.
4. Click the little blue disk next to the red trash can, and your done.
http://img526.imageshack.us/img526/698/realmlistj.jpg
Now on each machine that will be logging into the server on your LAN change the realmlist.wtf file to: (use your internal IP)
If you will be logging into the server from the host machine as well, make sure your realmlist.wtf file looks like below:Code:set realmlist 192.168.1.15
set patchlist 192.168.1.15
set realmlistbn ""
set portal us
That should do it for the LAN. Now as far as installing the updates goes, go to my post here: TutorialCode:set realmlist 127.0.0.1
set patchlist 127.0.0.1
set realmlistbn ""
set portal us
Then replace the current x64 and Win32 folders with the ones that are in the Cumulative Update packs.
EDIT:
There were a few updates last night and early this morning.
So.. here we go.Code:[10426] Remove not needed checks from IsNoStackAuraDueToAura
[10425] Add comment in Aura::CanProcFrom
[10424] Fix 50334 additional targets part
[10423] Load most spell chains data from SkillLineAbility.dbc
Just a heads up. The armory required edits to the core and the files needed to run it were in excess of 400 MB ZIPPED! and 1.27 GB extracted, this is because it has a 3D viewer and needed all the textures from the toons/items to be included, so I will not be releasing it. Sorry.
It is my belief that a repack should be atleast portable on a thumb drive with your other software, so... maybe I'll find a less hard drive gobbling one later on.
Update Compiling:
Code:MaNGOS updated to 10426 (required_10423_01_mangos_spell_chain)
Sry again but my english is bad ...Quote:
Originally Posted by CthulhuFtagn
I didn't understand what you mean... let me know if i understood you correctly:
You mean that i must to create the ahbot from the database - not from the game? - Cuz when i tried for first time i was logged in game account -> create a character with name: Ahbot -> and i logged in with him in game -> and then i configurated my mangosd.conf the following lines which you gave me? Does it correctly?
I really really sorry :(
Yep, that's correct. You just create a character normally, then configure, just don't use this toon for playing after you logged in with it. It should be used strictly to populate the auction house.
Thank you So Much!!!! Problem solved... :D