Changeset 35 for trunk

Show
Ignore:
Timestamp:
11/19/08 13:25:48 (17 years ago)
Author:
yumileroy
Message:

[svn] * Fixing some typos in SQL files.
* Applying proper structure to SQL updates.
* Fixing ImpConfig? compile problems.
* Moving INSTALL to INSTALL.linux to avoid autoconf collisions.

Original author: XTZGZoReX
Date: 2008-10-10 15:20:27-05:00

Location:
trunk
Files:
1 added
5 modified
3 moved

Legend:

Unmodified
Added
Removed
  • trunk/INSTALL.linux

  • trunk/sql/create_mysql.sql

    r2 r35  
    1 GRANT USAGE ON * . * TO 'mangos'@'localhost' IDENTIFIED BY 'mangos' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ; 
     1GRANT USAGE ON * . * TO 'trinity'@'localhost' IDENTIFIED BY 'trinity' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ; 
    22 
    3 CREATE DATABASE `mangos` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; 
     3CREATE DATABASE `world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; 
    44 
    55CREATE DATABASE `characters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; 
     
    77CREATE DATABASE `realmd` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; 
    88 
    9 GRANT ALL PRIVILEGES ON `mangos` . * TO 'mangos'@'localhost' WITH GRANT OPTION; 
     9GRANT ALL PRIVILEGES ON `world` . * TO 'trinity'@'localhost' WITH GRANT OPTION; 
    1010 
    11 GRANT ALL PRIVILEGES ON `characters` . * TO 'mangos'@'localhost' WITH GRANT OPTION; 
     11GRANT ALL PRIVILEGES ON `characters` . * TO 'trinity'@'localhost' WITH GRANT OPTION; 
    1212 
    13 GRANT ALL PRIVILEGES ON `realmd` . * TO 'mangos'@'localhost' WITH GRANT OPTION; 
     13GRANT ALL PRIVILEGES ON `realmd` . * TO 'trinity'@'localhost' WITH GRANT OPTION; 
    1414 
  • trunk/sql/drop_mysql.sql

    r2 r35  
    1 REVOKE ALL PRIVILEGES ON * . * FROM 'mangos'@'localhost'; 
     1REVOKE ALL PRIVILEGES ON * . * FROM 'trinity'@'localhost'; 
    22 
    3 REVOKE ALL PRIVILEGES ON `mangos` . * FROM 'mangos'@'localhost'; 
     3REVOKE ALL PRIVILEGES ON `mangos` . * FROM 'trinity'@'localhost'; 
    44 
    5 REVOKE GRANT OPTION ON `mangos` . * FROM 'mangos'@'localhost'; 
     5REVOKE GRANT OPTION ON `mangos` . * FROM 'trinity'@'localhost'; 
    66 
    7 REVOKE ALL PRIVILEGES ON `characters` . * FROM 'mangos'@'localhost'; 
     7REVOKE ALL PRIVILEGES ON `characters` . * FROM 'trinity'@'localhost'; 
    88 
    9 REVOKE GRANT OPTION ON `characters` . * FROM 'mangos'@'localhost'; 
     9REVOKE GRANT OPTION ON `characters` . * FROM 'trinity'@'localhost'; 
    1010 
    11 REVOKE ALL PRIVILEGES ON `realmd` . * FROM 'mangos'@'localhost'; 
     11REVOKE ALL PRIVILEGES ON `realmd` . * FROM 'trinity'@'localhost'; 
    1212 
    13 REVOKE GRANT OPTION ON `realmd` . * FROM 'mangos'@'localhost'; 
     13REVOKE GRANT OPTION ON `realmd` . * FROM 'trinity'@'localhost'; 
    1414 
    15 DELETE FROM `user` WHERE CONVERT( User USING utf8 ) = CONVERT( 'mangos' USING utf8 ) AND CONVERT( Host USING utf8 ) = CONVERT( 'localhost' USING utf8 ) ; 
     15DELETE FROM `user` WHERE CONVERT( User USING utf8 ) = CONVERT( 'trinity' USING utf8 ) AND CONVERT( Host USING utf8 ) = CONVERT( 'localhost' USING utf8 ) ; 
    1616 
    17 DROP DATABASE IF EXISTS `mangos` ; 
     17DROP DATABASE IF EXISTS `world` ; 
    1818 
    1919DROP DATABASE IF EXISTS `characters` ; 
  • trunk/sql/updates/10_world.sql

  • trunk/sql/updates/11_characters.sql

  • trunk/sql/world.sql

    r33 r35  
    11-- MySQL dump 10.11 
    22-- 
    3 -- Host: localhost    Database: mangos 
     3-- Host: localhost    Database: world 
    44-- ------------------------------------------------------ 
    55-- Server version       5.0.56-nt 
  • trunk/src/game/ObjectMgr.cpp

    r34 r35  
    20792079    // Load playercreate spells 
    20802080    { 
    2081         //                                                0     1      2      3 
    2082         QueryResult *result = WorldDatabase.Query("SELECT race, class, Spell, Active FROM playercreateinfo_spell"); 
    20832081 
    20842082        QueryResult *result = NULL; 
  • trunk/src/trinityrealm/AuthSocket.cpp

    r34 r35  
    373373        int MaxBuild = sConfig.GetIntDefault("MaxBuild", 8606); 
    374374 
    375         if(ch->build >= MinBuild && ch->build <= MaxBuild) 
     375        if(ch->build >= MinBuild && ch->build <= MaxBuild) { 
    376376        valid_version=true; 
    377         break; 
    378     } 
    379     else 
     377    } else { 
    380378        valid_version=false; 
     379    }; 
    381380 
    382381    /// <ul><li> if this is a valid version