WebSite Error Help? menu

User Tag List

Results 1 to 4 of 4
  1. #1
    spookster's Avatar Member
    Reputation
    -3
    Join Date
    Mar 2007
    Posts
    54
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    WebSite Error Help?

    Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\wamp\www\armory\configuration\mysql.php on line 100
    Unable to connect to Character SQL database: No database selected
    Notice: Undefined index: Killed On Contact PvP in C:\wamp\www\armory\source\honorranking.php on line 23

    Notice: Undefined index: in C:\wamp\www\armory\configuration\mysql.php on line 97

    Notice: Undefined index: in C:\wamp\www\armory\configuration\mysql.php on line 107

    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\wamp\www\armory\source\honorranking.php on line 85
    This is my Config For Mysql

    Code:
    <?php
    /*
    --- MySQL Connection Handler ---
    */
    
    /*  --- This is an Example ---
    Multirealm Configuration 
    Array Usage:
    "Realm Name" => array( "ConnectionKey" , "DB User" , "DB Pass" , "DB Host" , "Char DB" , "World DB" ) , 
    
    For example:
    $realms = array(
    "Test Realm" => array( "TESTREALM" , "root" , "ascent" , "localhost" , "Char" , "world" ) , 
    );
    
    Note 1: "ConnectionKey" must NOT have any spaces in it, underscores are acceptable.
    Note 2: "Char DB" is the database that you use for your characters, NOT your world database.
    Note 3: Added the entry for world DB, but it's not operational yet (I.E. Not used)
        --- This is an Example ---
    */
    
    /* Set your details here */
    $realms = array( 
    "Realm name" => array( "ConnectionKey" , "root" , "Pass" , "localhost" , "Logon" , "Ascent" ),
    );
    
    /* Default Realm if not set */
    $realmName["DEFAULT_REALM"] = "Killed On Contact PvP";
    $MySQL_User["DEFAULT_REALM"] = $realms[$realmName["DEFAULT_REALM"]][1];
    $MySQL_Password["DEFAULT_REALM"] =  $realms[$realmName["DEFAULT_REALM"]][2];
    $MySQL_Host["DEFAULT_REALM"] =  $realms[$realmName["DEFAULT_REALM"]][3];
    $RealmDB["DEFAULT_REALM"] =  $realms[$realmName["DEFAULT_REALM"]][4];
    $WorldDB["DEFAULT_REALM"] =  $realms[$realmName["DEFAULT_REALM"]][5];
    
    /*
    Website Database Configuration
    -> May or may not have a seperate connection to your realmservers <-
    */
    
    /* RealmDB must be the database used for your item_cache database */
    $MySQL_User["WEBSITE"] = "root";
    $MySQL_Password["WEBSITE"] = "Hidden";
    $MySQL_Host["WEBSITE"] = "localhost";
    $RealmDB["WEBSITE"] = "Armory";
    $WorldDB["WEBSITE"] = "Ascent";
    
    /* WorldServer DB if applicable */
    $MySQL_User["WSERVER"] = $MySQL_User["DEFAULT_REALM"];
    $MySQL_Password["WSERVER"] = $MySQL_Password["DEFAULT_REALM"];
    $MySQL_Host["WSERVER"] = $MySQL_Host["DEFAULT_REALM"];
    $RealmDB["WSERVER"] = $RealmDB["DEFAULT_REALM"];
    $WorldDB["WSERVER"] = $WorldDB["DEFAULT_REALM"]; // ? I seriously can't remember what WSERVER is used for anymore (looks like it's items and playercreateinfo, might be depreceated code tho.. //
    
    /*
    Uncommenting these lines is highly unadvisable, especially the 'print_r( $MySQL_Password)' line. Use only on debug/local machines.
    print_r( $MySQL_User );
    print_r( $MySQL_Password );
    print_r( $MySQL_Host );
    print_r( $RealmDB );
    */
    
    /* Don't touch anything beyond this point. */
    foreach( $realms as $key => $val )
    {
    $realmName[$val[0]] = $key;
    $MySQL_User[$val[0]] = $val[1];
    $MySQL_Password[$val[0]] = $val[2];
    $MySQL_Host[$val[0]] = $val[3];
    $RealmDB[$val[0]] = $val[4];
    $WorldDB[$val[0]] = $val[5];
    }
    
    
    function switchDatabase( $realm , $db_type = 'character' )
    {
    global $RealmDB, $WorldDB, $current_db;
    /* This function is called instead of mysql_select_db now that multirealms are implemented */
    if( $db_type == 'character' )
    {
    if( $current_db != sha1( $RealmDB[$realm] ) )
    {
    mysql_select_db( $RealmDB[$realm] ) or print "Unable to connect to Character SQL database: " . mysql_error();
    $current_db = sha1( $RealmDB[$realm] );
    }
    }
    else
    {
    mysql_select_db( $WorldDB[$realm] ) or print "Unable to connect to World SQL database: " . mysql_error();
    $current_db = sha1( $WorldDB[$realm] );
    }
    }
    
    function switchConnection( $key , $db_type = 'character' )
    {
    global $MySQL_User, $MySQL_Password, $MySQL_Host, $RealmDB, $WorldDB, $current_connection, $current_db, $querystack;
    /* Key - The key of the array used (i.e. $MySQL_User[<key>])*/
    if( $current_connection != sha1( $MySQL_Host[$key] ) )
    {
    /* Don't need to reconnect twice to the same DB */
    mysql_connect( $MySQL_Host[$key], $MySQL_User[$key] , $MySQL_Password[$key] ) or print " " . mysql_error();
    $current_connection = sha1( $MySQL_Host[$key] );
    
    $querystack[] = array( "query" => "Connected to " . $key . "." , "time" => 0 , "line" => 0 , "function" => "switchConnection" );
    }
    if( $db_type == 'character' )
    {
    if( $current_db != sha1( $RealmDB[$key] ) )
    {
    mysql_select_db( $RealmDB[$key] ) or print "Unable to connect to Character SQL database: " . mysql_error();
    $current_db = sha1( $RealmDB[$key] );
    }
    }
    else
    {
    mysql_select_db( $WorldDB[$key] ) or print "Unable to connect to World SQL database: " . mysql_error();
    $current_db = sha1( $WorldDB[$key] );
    }
    }
    function getConnection()
    {
    global $current_connection;
    return $current_connection;
    }
    function getDatabase()
    {
    global $current_db;
    return $current_db;
    }
    
    /* Default Connection: Website DB */
    switchConnection( "WEBSITE" );
    switchDatabase( "WEBSITE" );
    
    ?>
    What Might I have to do?

    WebSite Error Help?
  2. #2
    Le Froid's Avatar Contributor
    Reputation
    172
    Join Date
    Mar 2007
    Posts
    1,327
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Unable to connect to Character SQL database: No database selected

    Read that line

  3. #3
    spookster's Avatar Member
    Reputation
    -3
    Join Date
    Mar 2007
    Posts
    54
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hmmm..... So wat Db Do i go to>?

  4. #4
    Le Froid's Avatar Contributor
    Reputation
    172
    Join Date
    Mar 2007
    Posts
    1,327
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Your character/logon database

Similar Threads

  1. [Mangos] [Website] Mangos Account Creation Page Error.. Help?
    By Hyldran0 in forum WoW EMU Questions & Requests
    Replies: 14
    Last Post: 07-22-2010, 01:25 PM
  2. [Website] final site error :( HELP PLEASE
    By beerent in forum WoW EMU Questions & Requests
    Replies: 5
    Last Post: 04-09-2010, 06:19 AM
  3. microsoft Visual Studios ERROR help PLEASE
    By Nextgenerationrepack! in forum World of Warcraft Emulator Servers
    Replies: 2
    Last Post: 10-10-2007, 04:07 PM
  4. Website Info Help please!
    By cpskater in forum World of Warcraft Emulator Servers
    Replies: 1
    Last Post: 10-01-2007, 04:59 AM
  5. WoW Error Help please!
    By Bazerke in forum World of Warcraft General
    Replies: 4
    Last Post: 06-26-2007, 07:37 PM
All times are GMT -5. The time now is 07:42 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search