Welcome to AC Web.
Results 1 to 12 of 12
  1. #1


    Join Date
    Nov 2010
    Location
    Sweden, Gothenburg.
    Posts
    176

    Thumbs up Starting Zone Changer .sql! [Stupid & NOOB release]


    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    Basically, I am seeing lots of posts on "how do I make a custom starting zone / are etc etc" and I thought I could share this little stupid but super basic .sql file to change that. I know I know, this has been released a HUNDRED if not thousands of times before.

    But as we all know, some people can't or are unaware to use/or even know about the "Search"-Function on the forums.

    Basically all you need to do is this (3 easy steps, can't be failed):
    1. Open a text editor and edit the text below with the information you get from step 2.
    2. Go in-game, go to the spot you want the players to spawn and write ".gps" then you will get the info you need and then you just need to edit:

    MapID - Area - Orientation - X - Y - Z - O <- Change all that and save as a .sql file with the info from .gps

    Code:
    SET
    @MAP := x,
    @ZONE := x,
    @X := x,
    @Y := x,
    @Z := x,
    @O := x;
    
    UPDATE playercreateinfo SET [email protected], [email protected], [email protected], [email protected], [email protected], [email protected] WHERE race IN(1, 3, 4, 7, 11,2, 5, 6, 8, 10);
    Voila, you are done now just save and run that into your database. Restart server, and be happy ever after.

    Now before anyone decides to just bash or whatever, just putting this out here for an easy way to edit the startingzone for people new to the whole thing.

    NO DOWNLOAD - SAVE THE EDITED TEXT INTO A .SQL FILE!
    Last edited by KnaPPen; 10-01-2014 at 09:16 PM.

  2. #2
    zafirehd.deviantart.com

    Join Date
    Aug 2008
    Location
    http://zafirehd.deviantart.com
    Posts
    5,434
    I don't see the need of downloading a SQL file for doing something as simple as this.

  3. #3


    Join Date
    Nov 2010
    Location
    Sweden, Gothenburg.
    Posts
    176
    Actually, you are right. Removing the download link. People should be able to save to a .sql format text file. People do have brains for a reason.
    Last edited by KnaPPen; 10-01-2014 at 09:17 PM.

  4. #4
    Nice Share .
    - Here's one for Cataclysm: Pastebin.

  5. #5


    Join Date
    Nov 2010
    Location
    Sweden, Gothenburg.
    Posts
    176
    Right back at you, thanks.

  6. #6
    Did this some time ago:
    http://www.ac-web.org/forums/showthr...ce!&highlight=

    And it's not far under this thread you know.
    Last edited by Agetheria; 10-02-2014 at 06:08 AM.

  7. #7


    Join Date
    Nov 2010
    Location
    Sweden, Gothenburg.
    Posts
    176
    Quote Originally Posted by Agetheria View Post
    Did this some time ago:
    http://www.ac-web.org/forums/showthr...ce!&highlight=

    And it's not far under this thread you know.

    Well, this is awkward. Did actually not see that.
    Very well, putting myself in the moron-category.

  8. #8
    Quote Originally Posted by KnaPPen View Post
    Well, this is awkward. Did actually not see that.
    Very well, putting myself in the moron-category.
    Hehe
    Thanks for contributing anyways!

  9. #9


    Join Date
    Nov 2010
    Location
    Sweden, Gothenburg.
    Posts
    176
    Quote Originally Posted by Agetheria View Post
    Hehe
    Thanks for contributing anyways!
    Thanks and thank you as well!

  10. #10
    Web/SQL Dev & 3D Artist

    Join Date
    Oct 2010
    Location
    somewhere between <?php and ?>
    Posts
    3,277
    You dont't even need to save it as a .sql file lol... Just copy/paste it in the query tab in HeidiSQL

  11. #11


    Join Date
    Nov 2010
    Location
    Sweden, Gothenburg.
    Posts
    176
    Quote Originally Posted by Tok124 View Post
    You dont't even need to save it as a .sql file lol... Just copy/paste it in the query tab in HeidiSQL
    True. ^^

  12. #12

    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    simple but its my help thank you

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •