How do I make it Snow?(Constantly) In certain Areas? menu

User Tag List

Results 1 to 4 of 4
  1. #1
    Xcynic's Avatar Contributor
    Reputation
    252
    Join Date
    Jul 2007
    Posts
    359
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How do I make it Snow?(Constantly) In certain Areas?

    So, I've used the search function to find this, And I could find a few posts saying change high and low chance etc in weather to, 7 and/or 8. But that didn't work, unfortunelly, So Im wondering if anyone knows how to make it snow constantly in a certain area.

    Thanks

    How do I make it Snow?(Constantly) In certain Areas?
  2. #2
    miros1's Avatar Member
    Reputation
    1
    Join Date
    Oct 2007
    Posts
    147
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    just tupe .debug weather 8 1.0



    Sunny = 0, Fog = 1, Light_Rain = 2, Rain = 4, Snow = 8, SandStorm = 16

  3. #3
    Xcynic's Avatar Contributor
    Reputation
    252
    Join Date
    Jul 2007
    Posts
    359
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Debugg doesent last forever does it?

  4. #4
    beileroord's Avatar Member
    Reputation
    10
    Join Date
    Nov 2007
    Posts
    55
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I got two queries out of some christmas repack...

    REMOVES OLD VALUES

    Code:
    /*REMOVE WEATHER*/
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '1';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '3';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '4';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '8';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '10';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '11';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '12';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '14';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '15';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '16';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '17';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '28';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '33';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '36';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '38';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '40';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '41';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '44';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '45';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '46';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '47';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '51';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '85';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '130';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '139';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '141';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '148';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '215';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '267';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '331';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '357';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '361';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '400';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '405';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '406';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '440';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '490';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '618';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '1377';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '1519';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '1637';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '1638';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '1657';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '3430';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '3433';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '3518';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '3521';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '3524';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '3525';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '3557';
    DELETE    FROM    `weather`    WHERE    `zoneid`    =    '3703';
    Puts In new Values
    Code:
    /* IMPORT WEATHER */
    
    INSERT INTO `weather` VALUES ('1', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('3', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('4', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('8', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('10', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('11', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('12', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('14', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('15', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('16', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('17', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('28', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('33', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('36', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('38', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('40', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('41', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('44', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('45', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('46', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('47', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('51', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('85', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('130', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('139', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('141', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('148', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('215', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('267', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('331', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('357', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('361', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('400', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('405', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('406', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('440', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('490', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('618', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('1377', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('1519', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('1637', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('1638', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('1657', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('3430', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('3433', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('3518', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('3521', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('3524', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('3525', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('3557', '70', '1', '40', '8', '0', '0');
    INSERT INTO `weather` VALUES ('3703', '70', '1', '40', '8', '0', '0');
    And to get it normal again :

    Code:
    /* IMPORT DEFAULT WEATHER */
    
    INSERT INTO `weather` VALUES ('1', '80', '8', '5', '1', '1', '2');
    INSERT INTO `weather` VALUES ('3', '20', '16', '2', '2', '0', '0');
    INSERT INTO `weather` VALUES ('4', '10', '1', '0', '0', '0', '0');
    INSERT INTO `weather` VALUES ('8', '65', '1', '55', '2', '0', '0');
    INSERT INTO `weather` VALUES ('10', '50', '2', '5', '1', '0', '0');
    INSERT INTO `weather` VALUES ('11', '70', '2', '60', '4', '5', '1');
    INSERT INTO `weather` VALUES ('12', '20', '2', '10', '4', '0', '0');
    INSERT INTO `weather` VALUES ('14', '2', '2', '0', '0', '0', '0');
    INSERT INTO `weather` VALUES ('15', '40', '2', '35', '1', '0', '0');
    INSERT INTO `weather` VALUES ('16', '25', '2', '5', '1', '0', '0');
    INSERT INTO `weather` VALUES ('17', '1', '2', '0', '0', '0', '0');
    INSERT INTO `weather` VALUES ('28', '5', '2', '2', '1', '0', '0');
    INSERT INTO `weather` VALUES ('33', '80', '2', '40', '4', '20', '1');
    INSERT INTO `weather` VALUES ('36', '80', '8', '10', '1', '0', '0');
    INSERT INTO `weather` VALUES ('38', '40', '2', '10', '4', '2', '1');
    INSERT INTO `weather` VALUES ('40', '5', '2', '0', '0', '0', '0');
    INSERT INTO `weather` VALUES ('41', '10', '1', '0', '0', '0', '0');
    INSERT INTO `weather` VALUES ('44', '20', '2', '5', '1', '0', '0');
    INSERT INTO `weather` VALUES ('45', '20', '2', '5', '1', '0', '0');
    INSERT INTO `weather` VALUES ('46', '5', '1', '0', '0', '0', '0');
    INSERT INTO `weather` VALUES ('47', '30', '2', '10', '4', '5', '1');
    INSERT INTO `weather` VALUES ('51', '5', '2', '0', '0', '0', '0');
    INSERT INTO `weather` VALUES ('85', '10', '2', '0', '0', '0', '0');
    INSERT INTO `weather` VALUES ('130', '20', '2', '5', '4', '0', '0');
    INSERT INTO `weather` VALUES ('139', '5', '2', '0', '0', '0', '0');
    INSERT INTO `weather` VALUES ('141', '40', '2', '20', '4', '0', '0');
    INSERT INTO `weather` VALUES ('148', '40', '2', '20', '4', '5', '1');
    INSERT INTO `weather` VALUES ('215', '40', '2', '20', '4', '5', '1');
    INSERT INTO `weather` VALUES ('267', '40', '2', '20', '4', '5', '1');
    INSERT INTO `weather` VALUES ('331', '40', '2', '20', '4', '5', '1');
    INSERT INTO `weather` VALUES ('357', '40', '2', '20', '4', '5', '1');
    INSERT INTO `weather` VALUES ('361', '40', '2', '20', '4', '5', '1');
    INSERT INTO `weather` VALUES ('400', '25', '16', '0', '0', '0', '0');
    INSERT INTO `weather` VALUES ('405', '5', '2', '1', '16', '0', '0');
    INSERT INTO `weather` VALUES ('406', '40', '2', '20', '4', '0', '0');
    INSERT INTO `weather` VALUES ('440', '25', '16', '0', '0', '0', '0');
    INSERT INTO `weather` VALUES ('490', '40', '2', '20', '4', '5', '1');
    INSERT INTO `weather` VALUES ('618', '40', '2', '20', '4', '5', '1');
    INSERT INTO `weather` VALUES ('1377', '25', '16', '0', '0', '0', '0');
    INSERT INTO `weather` VALUES ('1519', '40', '2', '20', '4', '5', '1');
    INSERT INTO `weather` VALUES ('1637', '5', '2', '0', '0', '0', '0');
    INSERT INTO `weather` VALUES ('1638', '40', '2', '20', '4', '5', '1');
    INSERT INTO `weather` VALUES ('1657', '40', '2', '20', '4', '5', '1');
    INSERT INTO `weather` VALUES ('3430', '5', '2', '0', '0', '0', '0');
    INSERT INTO `weather` VALUES ('3433', '40', '2', '20', '4', '0', '0');
    INSERT INTO `weather` VALUES ('3518', '40', '2', '20', '4', '5', '1');
    INSERT INTO `weather` VALUES ('3521', '40', '2', '20', '4', '0', '0');
    INSERT INTO `weather` VALUES ('3524', '40', '2', '20', '4', '0', '0');
    INSERT INTO `weather` VALUES ('3525', '40', '2', '20', '4', '0', '0');
    INSERT INTO `weather` VALUES ('3557', '40', '2', '20', '4', '5', '1');
    INSERT INTO `weather` VALUES ('3703', '40', '2', '0', '0', '0', '0');

Similar Threads

  1. How can i make an edit fully textured
    By Airisus in forum WoW ME Questions and Requests
    Replies: 3
    Last Post: 01-20-2007, 07:48 AM
  2. How do u make spells???
    By Oaju in forum World of Warcraft General
    Replies: 2
    Last Post: 01-06-2007, 06:40 PM
  3. How do u make wow movies?
    By frigget in forum World of Warcraft General
    Replies: 2
    Last Post: 10-25-2006, 02:59 PM
  4. How do i make WOW screenshots i can it game into jpegs or something i can send?
    By Kaiserdog8390 in forum World of Warcraft General
    Replies: 4
    Last Post: 09-20-2006, 04:45 PM
  5. How do i make weapons for my server......
    By sk8erevan in forum WoW ME Questions and Requests
    Replies: 0
    Last Post: 09-08-2006, 04:24 PM
All times are GMT -5. The time now is 11:05 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search