Changerace Menu doesn't appear at start

AttilA*64 · Post by **AttilA*64** » Sun Aug 19, 2007 7:48 am

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

amxx modules :

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

meta list :

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

AttilA*64 · Post by **AttilA*64** » Mon Aug 20, 2007 8:59 am

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 !

AttilA*64 · Post by **AttilA*64** » Tue Aug 21, 2007 6:46 am

Nobody can help me ?

Post by **YamiKaitou** » Tue Aug 21, 2007 7:23 am

I don't even see War3FT being loaded based on your plugins list

AttilA*64 · Post by **AttilA*64** » Tue Aug 21, 2007 8:33 am

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

AttilA*64 · Post by **AttilA*64** » Tue Aug 21, 2007 9:19 am

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...
...

This is my war3ft.cfg file :

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

Post by **YamiKaitou** » Tue Aug 21, 2007 9:59 am

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

AttilA*64 · Post by **AttilA*64** » Tue Aug 21, 2007 10:10 am

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 ...

AttilA*64 · Post by **AttilA*64** » Wed Aug 22, 2007 3:33 am

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

AttilA*64 · Post by **AttilA*64** » Wed Aug 22, 2007 10:09 am

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 ?

HaNz_BrIx · Post by **HaNz_BrIx** » Wed Aug 22, 2007 10:16 am

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

Post by **YamiKaitou** » Wed Aug 22, 2007 11:04 am

If it can't connect, then the user/pass combo is wrong OR the host is wrong

AttilA*64 · Post by **AttilA*64** » Thu Aug 23, 2007 1:56 am

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 ...