Пожалуйста, очень нужна помощь с MySQL

[PROGRAMMATOR]

Интересно вы подключаетесь, может все же так:

PHP код:

<?php

    $dbconnect = mysql_connect($mysql_connect["host"].':'.$mysql_connect["port"], $mysql_connect["login"], $mysql_connect["password"]); 

    mysql_select_db($mysql_connect['db'], $dbconnect) or die (mysql_error()); 

?>

[KitKat]

Теперь кроме Can't connect to mysql on ............ добавилась еще

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in

[PROGRAMMATOR]

Ну это потому, что не подключилось к mysql серверу. Не знаю, конфиг хоть покажите что-ли.

[KitKat]

PHP код:

<?php



//-------------------------------Настройки MySQL базы сервера-------------------------------



$mysql_connect["host"]="xxx.xx.xxx.xx";   //IP адрес MySQL-сервера

$mysql_connect["port"]="3306";        //Порт

$mysql_connect["db"]="l2rt";         //Имя игровой базы

$mysql_connect["login"]="baka";       //Логин

$mysql_connect["password"]="666666";    //Пароль



//-----------------------------Настройки адресов сервера------------------------------------



$servergame="xxx.xx.xxx.xx";   //ip адрес сервера                   

$portgame="7777";          //порт игрового сервера 

[PROGRAMMATOR]

Видимо доступ сейчас ограничили, но подключается и сервер отдает ответ:

Access denied for user 'baka'@'%' to database 'l2rt'

[KitKat]

А вот и нет, все осталось, как и было. Вы ведь в тот раз не к l2rt коннектились, вот и получилось....

[PROGRAMMATOR]

Жесть. Я же говорил, привилегии проверяйте, к серверу подключается, вы пишете что не подключается. Базы не видит ваш юзверь. Смотрите вкладку привилегий.

[KitKat]

Все привелегии вам дал. Пробуйте.

[PROGRAMMATOR]

Все окей, дали привилегии и я прочитал таблицы.

Код:

Array
(
    [0] => Array
        (
            [Tables_in_l2rt] => access_levels
        )

    [1] => Array
        (
            [Tables_in_l2rt] => account_data
        )

    [2] => Array
        (
            [Tables_in_l2rt] => accounts
        )

    [3] => Array
        (
            [Tables_in_l2rt] => admin_command_access_rights
        )

    [4] => Array
        (
            [Tables_in_l2rt] => armor
        )

    [5] => Array
        (
            [Tables_in_l2rt] => armorsets
        )

    [6] => Array
        (
            [Tables_in_l2rt] => auction
        )

    [7] => Array
        (
            [Tables_in_l2rt] => auction_bid
        )

    [8] => Array
        (
            [Tables_in_l2rt] => auction_watch
        )

    [9] => Array
        (
            [Tables_in_l2rt] => auto_announcements
        )

    [10] => Array
        (
            [Tables_in_l2rt] => auto_chat
        )

    [11] => Array
        (
            [Tables_in_l2rt] => auto_chat_text
        )

    [12] => Array
        (
            [Tables_in_l2rt] => castle
        )

    [13] => Array
        (
            [Tables_in_l2rt] => castle_door
        )

    [14] => Array
        (
            [Tables_in_l2rt] => castle_doorupgrade
        )

    [15] => Array
        (
            [Tables_in_l2rt] => castle_functions
        )

    [16] => Array
        (
            [Tables_in_l2rt] => castle_manor_procure
        )

    [17] => Array
        (
            [Tables_in_l2rt] => castle_manor_production
        )

    [18] => Array
        (
            [Tables_in_l2rt] => castle_siege_guards
        )

    [19] => Array
        (
            [Tables_in_l2rt] => char_creation_items
        )

    [20] => Array
        (
            [Tables_in_l2rt] => char_templates
        )

    [21] => Array
        (
            [Tables_in_l2rt] => character_friends
        )

    [22] => Array
        (
            [Tables_in_l2rt] => character_hennas
        )

    [23] => Array
        (
            [Tables_in_l2rt] => character_macroses
        )

    [24] => Array
        (
            [Tables_in_l2rt] => character_quest_global_data
        )

    [25] => Array
        (
            [Tables_in_l2rt] => character_quests
        )

    [26] => Array
        (
            [Tables_in_l2rt] => character_raid_points
        )

    [27] => Array
        (
            [Tables_in_l2rt] => character_recipebook
        )

    [28] => Array
        (
            [Tables_in_l2rt] => character_recommends
        )

    [29] => Array
        (
            [Tables_in_l2rt] => character_shortcuts
        )

    [30] => Array
        (
            [Tables_in_l2rt] => character_skills
        )

    [31] => Array
        (
            [Tables_in_l2rt] => character_skills_save
        )

    [32] => Array
        (
            [Tables_in_l2rt] => character_subclasses
        )

    [33] => Array
        (
            [Tables_in_l2rt] => character_tpbookmark
        )

    [34] => Array
        (
            [Tables_in_l2rt] => characters
        )

    [35] => Array
        (
            [Tables_in_l2rt] => clan_data
        )

    [36] => Array
        (
            [Tables_in_l2rt] => clan_notices
        )

    [37] => Array
        (
            [Tables_in_l2rt] => clan_privs
        )

    [38] => Array
        (
            [Tables_in_l2rt] => clan_skills
        )

    [39] => Array
        (
            [Tables_in_l2rt] => clan_subpledges
        )

    [40] => Array
        (
            [Tables_in_l2rt] => clan_wars
        )

    [41] => Array
        (
            [Tables_in_l2rt] => clanhall
        )

    [42] => Array
        (
            [Tables_in_l2rt] => clanhall_functions
        )

    [43] => Array
        (
            [Tables_in_l2rt] => class_list
        )

    [44] => Array
        (
            [Tables_in_l2rt] => connection_test_table
        )

    [45] => Array
        (
            [Tables_in_l2rt] => cursed_weapons
        )

    [46] => Array
        (
            [Tables_in_l2rt] => custom_armor
        )

    [47] => Array
        (
            [Tables_in_l2rt] => custom_armorsets
        )

    [48] => Array
        (
            [Tables_in_l2rt] => custom_droplist
        )

    [49] => Array
        (
            [Tables_in_l2rt] => custom_etcitem
        )

    [50] => Array
        (
            [Tables_in_l2rt] => custom_merchant_buylists
        )

    [51] => Array
        (
            [Tables_in_l2rt] => custom_merchant_shopids
        )

    [52] => Array
        (
            [Tables_in_l2rt] => custom_notspawned
        )

    [53] => Array
        (
            [Tables_in_l2rt] => custom_npc
        )

    [54] => Array
        (
            [Tables_in_l2rt] => custom_spawnlist
        )

    [55] => Array
        (
            [Tables_in_l2rt] => custom_teleport
        )

    [56] => Array
        (
            [Tables_in_l2rt] => custom_weapon
        )

    [57] => Array
        (
            [Tables_in_l2rt] => dimensional_rift
        )

    [58] => Array
        (
            [Tables_in_l2rt] => droplist
        )

    [59] => Array
        (
            [Tables_in_l2rt] => enchant_skill_trees
        )

    [60] => Array
        (
            [Tables_in_l2rt] => etcitem
        )

    [61] => Array
        (
            [Tables_in_l2rt] => fish
        )

    [62] => Array
        (
            [Tables_in_l2rt] => fishing_skill_trees
        )

    [63] => Array
        (
            [Tables_in_l2rt] => fort
        )

    [64] => Array
        (
            [Tables_in_l2rt] => fort_doorupgrade
        )

    [65] => Array
        (
            [Tables_in_l2rt] => fort_functions
        )

    [66] => Array
        (
            [Tables_in_l2rt] => fort_siege_guards
        )

    [67] => Array
        (
            [Tables_in_l2rt] => fort_spawnlist
        )

    [68] => Array
        (
            [Tables_in_l2rt] => fort_staticobjects
        )

    [69] => Array
        (
            [Tables_in_l2rt] => fortsiege_clans
        )

    [70] => Array
        (
            [Tables_in_l2rt] => forums
        )

    [71] => Array
        (
            [Tables_in_l2rt] => four_sepulchers_spawnlist
        )

    [72] => Array
        (
            [Tables_in_l2rt] => games
        )

    [73] => Array
        (
            [Tables_in_l2rt] => gameservers
        )

    [74] => Array
        (
            [Tables_in_l2rt] => global_tasks
        )

    [75] => Array
        (
            [Tables_in_l2rt] => grandboss_data
        )

    [76] => Array
        (
            [Tables_in_l2rt] => grandboss_list
        )

    [77] => Array
        (
            [Tables_in_l2rt] => helper_buff_list
        )

    [78] => Array
        (
            [Tables_in_l2rt] => henna
        )

    [79] => Array
        (
            [Tables_in_l2rt] => henna_trees
        )

    [80] => Array
        (
            [Tables_in_l2rt] => heroes
        )

    [81] => Array
        (
            [Tables_in_l2rt] => item_attributes
        )

    [82] => Array
        (
            [Tables_in_l2rt] => items
        )

    [83] => Array
        (
            [Tables_in_l2rt] => itemsonground
        )

    [84] => Array
        (
            [Tables_in_l2rt] => locations
        )

    [85] => Array
        (
            [Tables_in_l2rt] => lvlupgain
        )

    [86] => Array
        (
            [Tables_in_l2rt] => mapregion
        )

    [87] => Array
        (
            [Tables_in_l2rt] => merchant_areas_list
        )

    [88] => Array
        (
            [Tables_in_l2rt] => merchant_buylists
        )

    [89] => Array
        (
            [Tables_in_l2rt] => merchant_lease
        )

    [90] => Array
        (
            [Tables_in_l2rt] => merchant_shopids
        )

    [91] => Array
        (
            [Tables_in_l2rt] => merchants
        )

    [92] => Array
        (
            [Tables_in_l2rt] => minions
        )

    [93] => Array
        (
            [Tables_in_l2rt] => mods_wedding
        )

    [94] => Array
        (
            [Tables_in_l2rt] => npc
        )

    [95] => Array
        (
            [Tables_in_l2rt] => npc_buffer
        )

    [96] => Array
        (
            [Tables_in_l2rt] => npcskills
        )

    [97] => Array
        (
            [Tables_in_l2rt] => olympiad_data
        )

    [98] => Array
        (
            [Tables_in_l2rt] => olympiad_nobles
        )

    [99] => Array
        (
            [Tables_in_l2rt] => olympiad_nobles_eom
        )

    [100] => Array
        (
            [Tables_in_l2rt] => pets
        )

    [101] => Array
        (
            [Tables_in_l2rt] => pets_skills
        )

    [102] => Array
        (
            [Tables_in_l2rt] => pets_stats
        )

    [103] => Array
        (
            [Tables_in_l2rt] => pledge_skill_trees
        )

    [104] => Array
        (
            [Tables_in_l2rt] => posts
        )

    [105] => Array
        (
            [Tables_in_l2rt] => quest_global_data
        )

    [106] => Array
        (
            [Tables_in_l2rt] => raidboss_spawnlist
        )

    [107] => Array
        (
            [Tables_in_l2rt] => random_spawn
        )

    [108] => Array
        (
            [Tables_in_l2rt] => random_spawn_loc
        )

    [109] => Array
        (
            [Tables_in_l2rt] => record
        )

    [110] => Array
        (
            [Tables_in_l2rt] => seven_signs
        )

    [111] => Array
        (
            [Tables_in_l2rt] => seven_signs_festival
        )

    [112] => Array
        (
            [Tables_in_l2rt] => seven_signs_status
        )

    [113] => Array
        (
            [Tables_in_l2rt] => siege_clans
        )

    [114] => Array
        (
            [Tables_in_l2rt] => skill_learn
        )

    [115] => Array
        (
            [Tables_in_l2rt] => skill_residential
        )

    [116] => Array
        (
            [Tables_in_l2rt] => skill_spellbooks
        )

    [117] => Array
        (
            [Tables_in_l2rt] => skill_trees
        )

    [118] => Array
        (
            [Tables_in_l2rt] => spawnlist
        )

    [119] => Array
        (
            [Tables_in_l2rt] => special_skill_trees
        )

    [120] => Array
        (
            [Tables_in_l2rt] => teleport
        )

    [121] => Array
        (
            [Tables_in_l2rt] => temporaryobjecttable
        )

    [122] => Array
        (
            [Tables_in_l2rt] => topic
        )

    [123] => Array
        (
            [Tables_in_l2rt] => transform_skill_trees
        )

    [124] => Array
        (
            [Tables_in_l2rt] => walker_routes
        )

    [125] => Array
        (
            [Tables_in_l2rt] => weapon
        )

    [126] => Array
        (
            [Tables_in_l2rt] => zone_vertices
        )

)

[KitKat]

хм..... *ударился об клавиатуру* и как так может быть?.........

вы через

PHP код:

<?php

    $dbconnect = mysql_connect($mysql_connect["host"].':'.$mysql_connect["port"], $mysql_connect["login"], $mysql_connect["password"]); 

    mysql_select_db($mysql_connect['db'], $dbconnect) or die (mysql_error()); 

?>