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

    Arrow SQL - Adding a value.


    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    Hi there, I want to change all the GUID column numbers in the creature DB, so ... they are added 1000000, to Guid.
    -------------------------------------------------------------------------------------------------
    GUID - ID - MAP - ZONE - AREA - SPAWNMASK - PHASEMASK - MODELID - ETC
    30311- 100 - 0 - 0 - 1 - 1 - 1 - 0 - 0
    30314- 100 - 0 - 0 - 1 - 1 - 1 - 0 - 0
    50316- 100 - 0 - 0 - 1 - 1 - 1 - 0 - 0


    I want it to look like this (GUID HAS added 1000000, TO ALL ITS VALUES)
    -------------------------------------------------------------------------------------------------
    GUID - ID - MAP - ZONE - AREA - SPAWNMASK - PHASEMASK - MODELID - ETC
    1030311- 100 - 0 - 0 - 1 - 1 - 1 - 0 - 0
    1030314- 100 - 0 - 0 - 1 - 1 - 1 - 0 - 0
    1050316- 100 - 0 - 0 - 1 - 1 - 1 - 0 - 0


    What would the sql, for this be?

    Thanks!

  2. #2
    http://armor-creator.cf

    Join Date
    Feb 2014
    Location
    http://armor-creator.cf
    Posts
    1,689
    update creature set guid = guid + 1000000;

  3. #3
    well thank you,that was easy.

  4. #4
    probably not the best idea to run that, you will have many problems, creature_addon not updated, waypoints probably not updated, etc

  5. #5
    http://armor-creator.cf

    Join Date
    Feb 2014
    Location
    http://armor-creator.cf
    Posts
    1,689

    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    Quote Originally Posted by piccolodmq View Post
    well thank you,that was easy.
    Well no problem but i would agree with Andy if you updated creature Guid than you must update other tables i don't think it's that hard, probably the same way.. anyways good luck.

 

 

Posting Permissions

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