edit MaNGOS\v9862\sql\characters_auctionhousebot.sql
find (2,'Alliance',0,0,8,24
change to (2,'Alliance',9999,9999,8,24
This sets min and maximum values repeat for
(6,'Horde',0,0,8,24 - change to (6,'Horde',9999,9999,8,24
(7,'Neutral',0,0,8,24 - change to (7,'Neutral',9999,9999,8,24
save then re apply MaNGOS\v9862\sql\characters_auctionhousebot.sql
using SQLyog into the character & character2 database.
Ok, I changed the stuff to 9999,9999, but I don't understand how to apply MaNGOS\v9862\sql\characters_auctionhousebot.sqlOriginally Posted by pmiller863
using SQLyog into the character & character2 database.
I am sorry if this sounds as a stupid question, but I am not really into this programming thingy. Please, give this noob a helping hand by being a bit more detailed. :(
The thing that crosses my mind is to try do it manually by finding the character and character 2 databeses folder and changing the stuff there to 9999 too, but I am not sure if it can be done that way.
The problem is that in the v.9862 the character sql files have this written:
-- 9767_03_characters_characters.sql
ALTER TABLE character_db_version CHANGE COLUMN required_9751_01_characters required_9767_03_characters_characters bit;
ALTER TABLE `characters`
ADD COLUMN `deleteInfos_Account` int(11) UNSIGNED default NULL AFTER actionBars,
ADD COLUMN `deleteInfos_Name` varchar(12) default NULL AFTER deleteInfos_Account,
ADD COLUMN `deleteDate` bigint(20) default NULL AFTER deleteInfos_Name;
-- 9849_01_characters_saved_variables.sql
ALTER TABLE character_db_version CHANGE COLUMN required_9767_03_characters_characters required_9849_01_characters_saved_variables bit;
ALTER TABLE saved_variables ADD cleaning_flags int(11) unsigned NOT NULL default '0' AFTER NextWeeklyQuestResetTime;
UPDATE saved_variables SET cleaning_flags = 0xF;
So this probably means I need to change the characters files in v.9763??
I m just guessing so please help me out here a bit, if you can.
Anyway thanks for reply.
--------------------------
Tried changing the character files in db in v.9763, didn't work. Still the AH is empty. :S
Last edited by Mareus; 21-06-10 at 12:33 PM.
start \Mangos\ambergui.exe
start mini server MySQL in ambergui
start \Mangos\sqlyog (in links in ambergui or manually)
create a new connection amber
user name = root
password = amber
port = 3308
connect to database
click [+] character database
click [+] tables
right click auctionhousebot
open table or press F11
find the entries on the right hand side
edit min & max to 9999 9999
click the diskette above it to save
exit sqlyog
retry
UDB 0.12.0 - Acid fuck! YTDB cool:)
Wow! It worked perfectly!
Thank you so much! I don't know what kind of a genius you have to be to know all this stuff, but god damn, you deserve praise
GUys look my error .... It appears when i try to put mangos.sql
Code:Query: (1,40,40,611,2.72532,610,2.27452), (2,10,10,769,3.14159,770,3.14159), (3,15,15,890,3.40156,889,0.263892), (4,5,5,929,0,936,3.14159), (5,5,5,939,0,940,3.14159), (6,5,5,0,0,0,0), (7,15,15,1103,3.40156,1104,0.263892), (8,5,5,1258,0,1259,3.14159), (9,15,15,1367,0,1368,0), (10,5,5,1362,0,1363,0), (11,5,5,1364,0,1365,0), (30,40,40,1485,0,1486,0), (32,5,40,0,0,0,0) Error occured at:2010-06-24 09:57:02 Line no.:466 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1,40,40,611,2.72532,610,2.27452), (2,10,10,769,3.14159,770,3.14159), (3,15,15,89' at line 1 Query: (1,40,40,611,2.72532,610,2.27452), (2,10,10,769,3.14159,770,3.14159), (3,15,15,890,3.40156,889,0.263892), (4,5,5,929,0,936,3.14159), (5,5,5,939,0,940,3.14159), (6,5,5,0,0,0,0), (7,15,15,1103,3.40156,1104,0.263892), (8,5,5,1258,0,1259,3.14159), (9,15,15,1367,0,1368,0), (10,5,5,1362,0,1363,0), (11,5,5,1364,0,1365,0), (30,40,40,1485,0,1486,0), (32,5,40,0,0,0,0) Error occured at:2010-06-24 09:57:22 Line no.:466 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1,40,40,611,2.72532,610,2.27452), (2,10,10,769,3.14159,770,3.14159), (3,15,15,89' at line 1 Query: CREATE DATABASE `scriptdev2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci Error occured at:2010-06-24 10:32:35 Line no.:1 Error Code: 1007 - Can't create database 'scriptdev2'; database exists Query: DELETE FROM sd2_db_version Error occured at:2010-06-24 10:32:56 Line no.:5 Error Code: 1146 - Table 'scriptdev2.sd2_db_version' doesn't exist Query: (1,40,40,611,2.72532,610,2.27452), (2,10,10,769,3.14159,770,3.14159), (3,15,15,890,3.40156,889,0.263892), (4,5,5,929,0,936,3.14159), (5,5,5,939,0,940,3.14159), (6,5,5,0,0,0,0), (7,15,15,1103,3.40156,1104,0.263892), (8,5,5,1258,0,1259,3.14159), (9,15,15,1367,0,1368,0), (10,5,5,1362,0,1363,0), (11,5,5,1364,0,1365,0), (30,40,40,1485,0,1486,0), (32,5,40,0,0,0,0) Error occured at:2010-06-24 10:35:56 Line no.:466 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1,40,40,611,2.72532,610,2.27452), (2,10,10,769,3.14159,770,3.14159), (3,15,15,89' at line 1 Query: (1,40,40,611,2.72532,610,2.27452), (2,10,10,769,3.14159,770,3.14159), (3,15,15,890,3.40156,889,0.263892), (4,5,5,929,0,936,3.14159), (5,5,5,939,0,940,3.14159), (6,5,5,0,0,0,0), (7,15,15,1103,3.40156,1104,0.263892), (8,5,5,1258,0,1259,3.14159), (9,15,15,1367,0,1368,0), (10,5,5,1362,0,1363,0), (11,5,5,1364,0,1365,0), (30,40,40,1485,0,1486,0), (32,5,40,0,0,0,0) Error occured at:2010-06-24 11:23:21 Line no.:466 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1,40,40,611,2.72532,610,2.27452), (2,10,10,769,3.14159,770,3.14159), (3,15,15,89' at line 1 Query: (1,40,40,611,2.72532,610,2.27452), (2,10,10,769,3.14159,770,3.14159), (3,15,15,890,3.40156,889,0.263892), (4,5,5,929,0,936,3.14159), (5,5,5,939,0,940,3.14159), (6,5,5,0,0,0,0), (7,15,15,1103,3.40156,1104,0.263892), (8,5,5,1258,0,1259,3.14159), (9,15,15,1367,0,1368,0), (10,5,5,1362,0,1363,0), (11,5,5,1364,0,1365,0), (30,40,40,1485,0,1486,0), (32,5,40,0,0,0,0) Error occured at:2010-06-24 11:24:00 Line no.:466 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1,40,40,611,2.72532,610,2.27452), (2,10,10,769,3.14159,770,3.14159), (3,15,15,89' at line 1
You need to first drop (delete) then create the databases
before you import your new sql files.
1. Run a backup of your database to save it
start \Mangos\ambergui.exe
start mini server MySQL in ambergui
run backup to save your databases
2. start \Mangos\ambergui.exe
start mini server MySQL in ambergui
start \Mangos\sqlyog (in links in ambergui or manually)
create a new connection amber
user name = root
password = amber
port = 3308
connect to database
Right click and delete database
mangos
characters
scriptdev2
realm
right click and create database
mangos
characters
scriptdev2
realm
then import your databases
I think everyone's is like that now, it seems to be a bug in the GUI software where the x/y is messed up or something, maybe it will be fixed in the next version.
---------- Post added at 09:18 PM ---------- Previous post was at 09:15 PM ----------
I am still looking for the answer to a couple things:
1). I still cannot find where to turn off the afk/idle kick in the game, I want players to hang out as long as they want since this is only for a few family and friends and not public.
2). I am still looking for the place to edit the How to Play page, I cannot find the actual text in any files. (Hey shiva, any chance on mangosweb enhanced by default coming soon?)
Last edited by zothecula; 01-07-10 at 03:27 AM.
Sorry for the bother, but yet another problem I couldn't seem to find a fix for.
Although i have the latest version of .NET Framework (version 4.0), I get an error:
"Unable to find a version of runtime to run this application"
running the AmberGUI.exe...and it pops up as soon as installation is done for the installer.
I've even tried running a repair on the .net framework. Should I downgrade to 3.5 or is there something else I can try?
Thanks
When I try to open a Db in Mysql it get an error stating that Mysql cannot connect on localhost. Any help would be great.
Last edited by killerboesch; 03-07-10 at 05:04 AM.
Heya, i've got the 3.3.3 version. And works fine ^^ I can log into it with NAvicat ^^ but when i am in there, i can't see the ser5ver database, where all the items are in. Does anyone know how to get that database back?
Hi folks, been away on business and playing catch up with other work. Will have a look at the various issues and see whats going on...
Don't bother with my last post, just downgraded from .net framwork 4.0 to 3.5. Thanks!
ii can start the server log in to the server but where you selck the realm you want to play on is as far as i get it just will not go into a realm?
Hope for a new vers soon data base had a update ;)
I don't know if mangos supports 3.3.5 yet but would be nice ;)
