Page 1 of 1
Changerace Menu doesn't appear at start
Posted: Sun Aug 19, 2007 7:48 am
by AttilA*64
Hi
I'm french so sorry for my english
I installed war3ft 3.0 cr8 on my dod 1.3 server
Everything seems to work great except the changerace menu which doesn't appear at start
I Cannot find how to fix the problem.
War3ft Version: 3.0 cr8
Amxmodx Version: 1.76d
Metamod Version: 1.19
amxx plugins :
Code: Select all
name version author file status
Admin Base 1.76d AMXX Dev Team admin.amxx running
Admin Commands 1.76d AMXX Dev Team admincmd.amxx running
Admin Help 1.76d AMXX Dev Team adminhelp.amxx running
Multi-Lingual Sys 1.76d AMXX Dev Team multilingual.am running
Menus Front-End 1.76d AMXX Dev Team menufront.amxx running
Commands Menu 1.76d AMXX Dev Team cmdmenu.amxx running
Players Menu 1.76d AMXX Dev Team plmenu.amxx running
Teleport Menu 1.76d AMXX Dev Team telemenu.amxx running
Maps Menu 1.76d AMXX Dev Team mapsmenu.amxx running
Admin Chat 1.76d AMXX Dev Team adminchat.amxx running
Anti Flood 1.76d AMXX Dev Team antiflood.amxx running
Scrolling Message 1.76d AMXX Dev Team scrollmsg.amxx running
Info. Messages 1.76d AMXX Dev Team imessage.amxx running
Admin Votes 1.76d AMXX Dev Team adminvote.amxx running
NextMap 1.76d AMXX Dev Team nextmap.amxx running
TimeLeft 1.76d AMXX Dev Team timeleft.amxx running
Pause Plugins 1.76d AMXX Dev Team pausecfg.amxx running
Stats Configurati 1.76d AMXX Dev Team statscfg.amxx running
DoD Stats 1.76d AMXX Dev Team stats.amxx running
DoD Sounds Precac 1.76d AMXX Dev Team statssounds.amx running
Stats Logging 1.76d AMXX Dev Team stats_logging.a running
DoD ClanMatch 0.7.8 AMXX DoD Team + dod_clanmatch.a running
NextMapVote[BSL M 1.71 AMXX + [BSL]MD bsl_mapchooser. running
DoD TeamManager 1.0 AMXX DoD Team dod_teammanager running
DoD AFK Manager 0.7beta AMXX DoD Team dod_afkmanager. running
DoD TK Revenge 1.0 AMXX DoD Team dod_tkrevenge.a running
DoD HPK 1.1 AMXX DoD Team dod_hpk.amxx running
DoD Melee Bonus 0.6beta AMXX DoD Team dod_meleebonus. running
One Weapon 1.0.1 SidLuke dod_oneweaponmo running
DoD SniperFun 2.0g be AMXX DoD Team dod_sniperfun.a running
DoD CloseCombatFu 0.99bet AMXX DoD Team dod_closecombat running
DoD EvilAdmin 0.5beta AMXX DoD Team dod_eviladmin.a running
DoD Sons Serveur 1.1 AttilA*64 dod_sons_serveu running
Dod Invisibility 1.0 Wilson - Dodplug dod_invisibilit running
DoD RestartRound 0.8beta AMXX DoD Team dod_restartroun running
Autoresponder/Adv 0.5 MaximusBrood ad_manager.amxx running
DoD Anti-Hax 2.6.2 [email protected] dod_antihax.amx running
37 plugins, 37 running
Code: Select all
Currently loaded modules:
name version author
MySQL 1.76b AMX Mod X Dev Team
Fun 1.76 AMX Mod X Dev Team
Engine 1.76 AMX Mod X Dev Team
FakeMeta 1.76d AMX Mod X Dev Team
nVault 1.76c AMX Mod X Dev Team
DoD Fun 1.76b AMX Mod X Dev Team
DoDX 1.76b AMX Mod X Dev Team
SQLite 1.76b AMX Mod X Dev Team
Sockets 1.76 HLSW Dev Team
RegEx 1.76 AMX Mod X Dev Team
10 modules
Code: Select all
Currently loaded plugins:
description stat pend file vers src load unlod
[ 1] AMX Mod X RUN - amxmodx_mm_i386. v1.76d ini ANY ANY
[ 2] MySQL RUN - mysql_amxx_i386. v1.76b pl1 ANY ANY
[ 3] Fun RUN - fun_amxx_i386.so v1.76 pl1 ANY ANY
[ 4] Engine RUN - engine_amxx_i386 v1.76 pl1 ANY ANY
[ 5] FakeMeta RUN - fakemeta_amxx_i3 v1.76d pl1 ANY ANY
[ 6] DoD Fun RUN - dodfun_amxx_i386 v1.76b pl1 ANY ANY
[ 7] DoDX RUN - dodx_amxx_i386.s v1.76b pl1 ANY ANY
[ 8] SQLite RUN - sqlite_amxx_i386 v1.76b pl1 ANY ANY
8 plugins, 8 running
Posted: Mon Aug 20, 2007 8:59 am
by AttilA*64
This problem seems to be a bug in previous versions of war3ft.
My version is the last one so i don't know how to fix the problem.
Please I need your help !
Posted: Tue Aug 21, 2007 6:46 am
by AttilA*64
Nobody can help me ?
Posted: Tue Aug 21, 2007 7:23 am
by YamiKaitou
I don't even see War3FT being loaded based on your plugins list
Posted: Tue Aug 21, 2007 8:33 am
by AttilA*64
You're right !
The plugin doesn't work normally so i removed it from my plugins.ini file and that's why it isn't loaded
It's just my plugins list actually running on my server
Posted: Tue Aug 21, 2007 9:19 am
by AttilA*64
That's what i found in my server's logs :
Code: Select all
L 08/19/2007 - 16:12:51: [war3ft.amxx] [MYSQLX] Database Connection Failed: [2003] Can't connect to MySQL server on '**.***.**.**' (111)
L 08/19/2007 - 16:12:51: [admin.amxx] Login: "dbK*<55><STEAM_0:0:11028325><>" became an admin (account "STEAM_0:0:110*****") (access "abcdefghijklmnopqrstu") (address "90.**.***.**")
L 08/19/2007 - 16:13:08: [war3ft.amxx] [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 08/19/2007 - 16:13:09: [war3ft.amxx] [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 08/19/2007 - 16:13:10: [war3ft.amxx] [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 08/19/2007 - 16:13:11: [war3ft.amxx] [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 08/19/2007 - 16:13:12: [war3ft.amxx] [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 08/19/2007 - 16:13:13: [war3ft.amxx] [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 08/19/2007 - 16:13:14: [war3ft.amxx] [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 08/19/2007 - 16:13:15: [war3ft.amxx] [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 08/19/2007 - 16:13:16: [war3ft.amxx] [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 08/19/2007 - 16:13:17: [war3ft.amxx] [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 08/19/2007 - 16:13:18: [war3ft.amxx] [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 08/19/2007 - 16:13:19: [war3ft.amxx] [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 08/19/2007 - 16:13:20: [war3ft.amxx] [ERROR] Unable to retreive user's (1) Unique ID, trying again...
...
Code: Select all
// Warcraft 3 Frozen Throne Configuration File
// Saving Options
wc3_save_xp 1 // Enables saving of experience (default is 0)
wc3_save_xp_db 1 // How should we save XP? (0 = SQLite, 1 = MySQL)
wc3_save_by 0 // What should I save this as? steam id = 0, IP = 1, name = 2 (default is 0)
wc3_save_pruning 0 // Automatically prunes the database of old users at a mapchange (default is 0)
wc3_days_before_delete 90 // However many days before deleting XP or pruning from the database (default is 31)
wc3_save_end_round 1 // Save xp at the end of each round (may cause lag, default is 1)
// SQL Database Information
wc3_sql_dbhost "**.***.**.**" // Host Name
wc3_sql_dbuser "******" // User Name
wc3_sql_dbpass "******" // Password
wc3_sql_dbname "warcraft" // Database Name
// Admin Options
wc3_admin_flag "m" // Admin flag required to give/take XP (default is m)
// Experience Options
wc3_xp_multiplier 1.0 // set the level required to gain a level as a multiple (default 1.0)
wc3_xp_weap_multiplier 1 // Award XP based on the weapon used (default is 1)
wc3_min_players 2 // Minimum amount of players needed b4 awarding XP (default is 2)
wc3_ignore_bots 0 // Should you ignore bots when calculating the minimum players required to gain xp? (default is 0)
wc3_xp_auto_average 0 // With this option set to 1, the joining players will receive the average amount of XP that all of the players have (SHORT TERM XP ONLY, default is 0)
wc3_show_objectives 1 // If enabled, will display message in chat to show XP they gain for completing certain objectives (default is 1)
wc3_show_kill_obj 1 // Shows how much XP you gain for killing someone (each kill, default is 0)
wc3_xp_radius 750 // Radius to give XP to teammates near where the special objective is completed (rescued hosties, bomb planted, killed vip, vip escaped, default is 750)
// Game Play Enhancements
wc3_races 8 // Number of races (if races are less than 5, the second shopmenu will be disabled (4 is standard war3), default is 8 )
wc3_grenade_protection 0 // Only 1 HE grenade will be allowed for purchase per round (default is 0)
wc3_spec_position 0 // 0 is for left, 1 is for right (where to put the information for those spectating, default is 0)
wc3_buy_zone 0 // Restrict purchasing shopmenu items to within the buyzone? (default is 0)
wc3_buy_time 0 // Restrict purchasing shopmenu items to within the buytime? (default is 0)
wc3_buy_dead 1 // Allow users to purchause items when dead? (default is 1)
wc3_show_player 1 // Show teammate and enemy information in the center of the screen when they are on target? (not for DOD, default is 1)
wc3_query_client 1 // Check user's cl_minmodel cvar every second (default is 1)
wc3_cheats 0 // Enable cheats for wc3? (default is 0)
wc3_psychostats 0 // Print psychostats information to log files for wc3 abilities? (default is 0)
wc3_start_level 0 // What level should all players start at when joining? (default is 0)
// Icon Options (displayed above player's head)
wc3_race_icon 1 // Allow users to type /icons to show player icons above the player (default is 1)
wc3_level_icon 1 // Allow users to type /icons to see player levels above the player (default is 1)
// Chameleon Race Configuration Options - see _chameleon.txt for more information
wc3_cham_random 1 // Should the 9th race have random skills each round?, if so the next 4 option are irrelevant (default is 1)
wc3_cham_skill1 14 // What skill ID for skill 1?
wc3_cham_skill2 0 // What skill ID for skill 2?
wc3_cham_skill3 6 // What skill ID for skill 3?
wc3_cham_ultimate 7 // What skill ID for the user's ultimate?
wc3_cham_passive 20 // What skill ID for the user's passive skill?
// Skill and Ultimate configurations
wc3_ult_delay 15.0 // Amount of time (in seconds) to delay the ultimates at the start of each round (default is 15.0)
wc3_ult_cooldown 30.0 // Cooldown of all ultimates (default is 35.0)
wc3_blink_protection 1 // slays people who abuse blink on some maps (skywalking, map exploiting, default is 1)
wc3_blink_dizziness 0 // What type of diziness? (0 is flashbang effect, 1 is fading blue screen, default is 0)
wc3_entangle_drop 0 // Should the player's primary weapon be dropped when they are entangled? (default is 0)
// Item configurations
wc3_glove_timer 10 // Interval between receiving a new grenade with the Flaming Gloves of Warmth (default is 10)
wc3_glove_orc_damage 0 // When using gloves, should orcs be given the critical dmg? (Default is 0)
wc3_boots 0.10 // Percentage increase given by boots (.10 = 10%, default is 0.10)
wc3_claw 6 // Damage done by Claws of Attack (default is 6)
wc3_health 15 // Health bonus given for periapt of health (default is 15)
wc3_frost 125.0 // Speed of victim when attacked with Orb of Frost (default is 125.0)
wc3_mask 0.3 // Percentage of life gained back by mask of death (default is 0.3)
wc3_cloak 150 // Invisibility given with cloak, lower is more invisible (default is 150)
wc3_sock 0.5 // Gravity level for Sock of the Feather (default is 0.5)
wc3_tome 50 // XP given for purchasing tome of experience (default is 50)
// Bot Configuration Options
wc3_bot_buy_item 0.33 // Chance of a bot buying a shopmenu item at the beginning of the round (default is 0.33)
// DOD Options
wc3_dod_start_money 800 // Starting money for dod
Posted: Tue Aug 21, 2007 9:59 am
by YamiKaitou
Your issue is that your game server doesn't have access to the MySQL host. Contact the host if they allow incoming MySQL connections, and if they do, how to set it up
Posted: Tue Aug 21, 2007 10:10 am
by AttilA*64
The host is a friend of mine & we set it up together
I'll contact him and try to fix the problem with him.
Please don't lock my post ...
Posted: Wed Aug 22, 2007 3:33 am
by AttilA*64
I made some tests with my Host and i have some new questions :
1) about sql.cfg file
At this time plugins running on my server don't need SQL so I never edited this file. Is it necessary to configure it for a good working of War3FT using mySQL ?
If the answer is YES, I know the Hostname, DBname, Username & Password but what about amx_sql_table "???" and amx_sql_type "???"
2) about Hostname
My hostname can be a domaine name or an ip address. Is one better than the other one ?
Thx for answers ... sorry for my english if I made mistakes
Posted: Wed Aug 22, 2007 10:09 am
by AttilA*64
OK Mordekay, thanx for your answers
The bad new for me is that my problem isn't fixed
Code: Select all
L 08/19/2007 - 16:12:51: [war3ft.amxx] [MYSQLX] Database Connection Failed: [2003] Can't connect to MySQL server on '**.***.**.**' (111)
(111) seems to be a code for error
What does it mean ?
Posted: Wed Aug 22, 2007 10:16 am
by HaNz_BrIx
i got the same error and mine and if you have added your server as acess then its all about your username and password
my username was like this c477521_test5
and i assumed my password would have those same number in front but they dont so for your password you just use it regularly like testpw
Posted: Wed Aug 22, 2007 11:04 am
by YamiKaitou
If it can't connect, then the user/pass combo is wrong OR the host is wrong
Posted: Thu Aug 23, 2007 1:56 am
by AttilA*64
YamiKaitou wrote:If it can't connect, then the user/pass combo is wrong OR the host is wrong
My User/Pass combo & my Host are absolutely RIGHT !
So I'll try your solution Mordekay ...