- MaNGOS ~Amber~ Releases 3.x.x

Page 113 of 140 FirstFirst ... 1363103105106107108109110111112113114115116117118119120121123 ... LastLast
Results 1,681 to 1,695 of 2095
  1. #1681
    Account Upgraded | Title Enabled! pmiller863 is offline
    MemberRank
    Apr 2008 Join Date
    283Posts

    Re: - MaNGOS ~Amber~ Releases 3.x.x

    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.

  2. #1682
    Apprentice Mareus is offline
    MemberRank
    Jun 2010 Join Date
    6Posts

    Re: - MaNGOS ~Amber~ Releases 3.x.x

    Quote Originally Posted by pmiller863 View Post
    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.sql
    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.

  3. #1683
    Account Upgraded | Title Enabled! pmiller863 is offline
    MemberRank
    Apr 2008 Join Date
    283Posts

    Re: - MaNGOS ~Amber~ Releases 3.x.x

    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

  4. #1684
    Apprentice Olivka is offline
    MemberRank
    Jan 2010 Join Date
    20Posts

    Re: - MaNGOS ~Amber~ Releases 3.x.x

    UDB 0.12.0 - Acid fuck! YTDB cool:)

  5. #1685
    Apprentice Mareus is offline
    MemberRank
    Jun 2010 Join Date
    6Posts

    Re: - MaNGOS ~Amber~ Releases 3.x.x

    Quote Originally Posted by pmiller863 View Post
    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
    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

  6. #1686
    Novice nevermoreftw is offline
    MemberRank
    Jun 2010 Join Date
    2Posts

    Re: - MaNGOS ~Amber~ Releases 3.x.x

    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

  7. #1687
    Account Upgraded | Title Enabled! pmiller863 is offline
    MemberRank
    Apr 2008 Join Date
    283Posts

    Re: - MaNGOS ~Amber~ Releases 3.x.x

    Quote Originally Posted by nevermoreftw View Post
    GUys look my error .... It appears when i try to put mangos.sql


    Code:
    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
    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

  8. #1688
    Member zothecula is offline
    MemberRank
    Oct 2008 Join Date
    USALocation
    87Posts

    Re: - MaNGOS ~Amber~ Releases 3.x.x

    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.

  9. #1689
    Enthusiast kolodude is offline
    MemberRank
    Aug 2007 Join Date
    44Posts

    Re: - MaNGOS ~Amber~ Releases 3.x.x

    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

  10. #1690
    Apprentice killerboesch is offline
    MemberRank
    Jun 2007 Join Date
    7Posts

    Re: - MaNGOS ~Amber~ Releases 3.x.x

    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.

  11. #1691
    Novice tweetix is offline
    MemberRank
    May 2007 Join Date
    2Posts

    Re: - MaNGOS ~Amber~ Releases 3.x.x

    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?

  12. #1692
    Account Upgraded | Title Enabled! shivajiva101 is offline
    MemberRank
    Oct 2006 Join Date
    DarkSide of the MoonLocation
    345Posts

    Re: - MaNGOS ~Amber~ Releases 3.x.x

    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...

  13. #1693
    Enthusiast kolodude is offline
    MemberRank
    Aug 2007 Join Date
    44Posts

    Re: - MaNGOS ~Amber~ Releases 3.x.x

    Don't bother with my last post, just downgraded from .net framwork 4.0 to 3.5. Thanks!

  14. #1694
    Novice jacquesc1 is offline
    MemberRank
    Dec 2009 Join Date
    1Posts

    Re: - MaNGOS ~Amber~ Releases 3.x.x

    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?

  15. #1695

    Re: - MaNGOS ~Amber~ Releases 3.x.x

    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 ;)



Advertisement