MySQL Problems

[Achilleus]

I'm very confused about the whole database thing with AMXX and WC3. I'd like to use a database for both AMXX Users(instead of users.ini) and for WC3 XP. I cannot get it to work, and additionally when I look to the documentation on your wiki, it is broken and half the stuff on there doesn't show up. I have 3 servers, 2 with WC3FT. All of them have AMXX.

Would somebody please give me a step by step guide with ALL the files I need to modify to get this to work? Eventually I'd like to make a AMXX SMF bridge but if I can't get AMXX to work it's a mute point. It'd be pretty nice to have everybody's admin updated according to their forum membergroup

I would also like to convert our current vault file to the database, but I can't seem to find it. What is the file called?


--- Please enter the following information for support ---
War3ft Version: 2.3.2
Amxmodx Version: 1.76D
Metamod Version: don't know
amxx list:

Code: Select all

21:17:29 Currently loaded plugins:
                name               version  author            file             status   
          [  1] Admin Base         1.71     AMXX Dev Team     admin.amxx       running  
          [  2] Admin Commands     1.71     AMXX Dev Team     admincmd.amxx    running  
          [  3] Admin Help         1.71     AMXX Dev Team     adminhelp.amxx   running  
          [  4] Slots Reservation  1.71     AMXX Dev Team     adminslots.amxx  running  
          [  5] Multi-Lingual Sys  1.71     AMXX Dev Team     multilingual.am  running  
          [  6] Menus Front-End    1.71     AMXX Dev Team     menufront.amxx   running  
          [  7] Commands Menu      1.71     AMXX Dev Team     cmdmenu.amxx     running  
          [  8] Players Menu       1.71     AMXX Dev Team     plmenu.amxx      running  
          [  9] Teleport Menu      1.71     AMXX Dev Team     telemenu.amxx    running  
          [ 10] Maps Menu          1.71     AMXX Dev Team     mapsmenu.amxx    running  
          [ 11] Admin Chat         1.71     AMXX Dev Team     adminchat.amxx   running  
          [ 12] Anti Flood         1.71     AMXX Dev Team     antiflood.amxx   running  
          [ 13] Scrolling Message  1.71     AMXX Dev Team     scrollmsg.amxx   running  
          [ 14] Info. Messages     1.71     AMXX Dev Team     imessage.amxx    running  
          [ 15] Admin Votes        1.71     AMXX Dev Team     adminvote.amxx   running  
          [ 16] NextMap            1.71     AMXX Dev Team     nextmap.amxx     running  
          [ 17] Nextmap Chooser    1.71     AMXX Dev Team     mapchooser.amxx  running  
          [ 18] TimeLeft           1.71     AMXX Dev Team     timeleft.amxx    running  
          [ 19] Pause Plugins      1.71     AMXX Dev Team     pausecfg.amxx    running  
          [ 20] Stats Configurati  1.71     AMXX Dev Team     statscfg.amxx    running  
          [ 21] Restrict Weapons   1.71     AMXX Dev Team     restmenu.amxx    running  
          [ 22] StatsX             1.71     AMXX Dev Team     statsx.amxx      running  
          [ 23] CS Misc. Stats     1.71     AMXX Dev Team     miscstats.amxx   running  
          [ 24] CS Stats Logging   1.71     AMXX Dev Team     stats_logging.a  running  
          [ 25] Warcraft 3 Frozen  2.3.2    Geesu==(Pimp Dad  warcraft3FT.amx  debug    
         25 plugins, 25 running

amxx modules:

Code: Select all

21:18:15 Currently loaded modules:
               name                    version  author               status     
          [ 1] Fun                     1.71     AMX Mod X Dev Team   running    
          [ 2] Engine                  1.71     AMX Mod X Dev Team   running    
          [ 3] FakeMeta                1.71     AMX Mod X Dev Team   running    
          [ 4] CStrike                 1.71     AMX Mod X Dev Team   running    
          [ 5] CSX                     1.71     AMX Mod X Dev Team   running    
          [ 6] Sqlite                  1.70     AMX Mod X Dev Team   running    
         6 modules, 6 correct

meta list:

Code: Select all

21:16:44 Currently loaded plugins:
               description      stat pend  file              vers      src   load  unlod
          [ 1] AMX Mod X        RUN   -    amxmodx_mm.dll    v1.71     ini   ANY   ANY  
          [ 2] Fun              RUN   -    fun_amxx.dll      v1.71     pl1   ANY   ANY  
          [ 3] Engine           RUN   -    engine_amxx.dll   v1.71     pl1   ANY   ANY  
          [ 4] FakeMeta         RUN   -    fakemeta_amxx.dl  v1.71     pl1   ANY   ANY  
          [ 5] CStrike          RUN   -    cstrike_amxx.dll  v1.71     pl1   ANY   ANY  
          [ 6] CSX              RUN   -    csx_amxx.dll      v1.71     pl1   ANY   ANY  
         6 plugins, 6 running

[Achilleus]

Anybody? I am more then willing to donate $50 or whatever if I get my issue resolved.

[YamiKaitou]

Actually, your vault file will be located in addons/amxmodx/data/vault.ini

There might be a vault.ini to MySQL conversion on war3ft.com

[Achilleus]

Aside from converting the vault to database, how would I actually use the database?

[Achilleus]

Code: Select all

// Warcraft 3 Frozen Throne Configuration File

mp_savexp		1		// Enables saving of experience (uses a vault, default is 0)
sv_sql			1		// Save using a SQL module (a module needs to be turned on, note: to use this mp_savexp must also be 1, default is 0)
FT_saveby		0		// What should I save this as?  steam id = 0, IP = 1, name = 2 (default is 0)
FT_admin_flag		"m"		// Admin flag required to give/take XP (default is m)

// SQL configuration
FT_sql_host		"mysql4.websitesource.net:3306"	// Host Name
FT_sql_user		"Achille_AGS"		// User Name
FT_sql_pass		"*removed*"		// Password
FT_sql_db		"Achille_WAR"		// Database Name
FT_auto_pruning		0		// Automatically prunes the database of old users at a mapchange (default is 0)
sv_daysbeforedelete	9999999		// However many days before deleting XP or pruning from the database (default is 31)
sv_sqltablename		"war3users"	// Table Name, no need to change (default is war3users)
sv_save_end_round	1		// Save xp at the end of each round (may cause lag, default is 1)

// Experience options
mp_xpmultiplier		1.0		// set the level required to gain a level as a multiple (default 1.0)
mp_weaponxpmodifier	1		// gives additional XP for using certain weaker weapons (default is 1)
FT_min_b4_XP		2		// Minimum amount of players needed b4 awarding XP (default is 2)
FT_objectives		1		// If enabled, will display message in chat to show XP they gain for completing certain objectives (default is 1)
FT_kill_objectives	0		// Shows how much XP you gain for killing someone (each kill, default is 0)
FT_bombplanterxp	15		// XP given for planting the bomb (default is 15)
FT_defusexp		30		// XP given for defusing the bomb (default is 30)
FT_hostagexp		25		// XP given for helping to rescue the hostages (default is 25)
FT_killrescuemanxp	25		// XP given for killing the person rescuing the hostages (default is 25)
FT_xpbonus		50		// XP given for purchasing tome of experience (default is 50)
FT_kill_bomb_carrier_bonus 25		// XP given for killing the bomb carrier (default is 25)
FT_defuser_kill_bonus	25		// XP given for killing the defuser (default is 25)
FT_VIP_kill_bonus	25		// XP given for killing the VIP (default is 25)
FT_VIP_escape_bonus	30		// XP given when the VIP escapes (default is 30)
FT_headshot_bonus	9		// XP given for getting a headshot (default is 9)
FT_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)
FT_round_win_XP		35		// Experience given to the winning team (default is 35)
FT_autoxp		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)

// Game Play Enhancements
sv_warcraft3		1		// Set this to 0 to disable warcraft (default is 1)
mp_grenadeprotection	0		// Only 1 HE grenade will be allowed for purchase per round (default is 0)
FT_position		0		// 0 is for left, 1 is for right (where to put the information for those spectating, default is 0)
FT_centerhud		1		// Automatically makes the hud be centered (message that shows xp/race/level, default is 1)
FT_items_in_hud		0		// Display items w/a HUD message (this will take up 1 of the 4 channels, default is 0)
FT_spec_info		1		// Show Spectating information for dead players (default is 1)
FT_show_icons		1		// Shows icons on your screen when your ultimate is ready (default is 1)
FT_race_icons		1		// Allow users to type /icons to show player icons above the player (default is 1)
FT_level_icons		1		// Allow users to type /icons to see player levels above the player (default is 1)
FT_CD			0		// If set to 1, it will not allow players without Cheating Death to play this mod (default is 0)
FT_buyzone		0		// Restrict purchasing shopmenu items to within the buyzone? (default is 0)
FT_buytime		0		// Restrict purchasing shopmenu items to within the buytime? (default is 0)
FT_buydead		1		// Allow users to purchase items when dead? (default is 1)
FT_show_player		0		// Show teammate and enemy information in the center of the screen when they are on target? (not for DOD, default is 1)
FT_query_client		1		// Check user's cl_minmodel cvar every second (default is 1)

// TYPE OF WARCRAFT (If race 4 or 5 is selected, messsages will say WAR3 instead
// of saying WAR3FT, also shopmenu2 will be disabled, as well as saying rings and ability)
FT_races		8		// Number of races (if races are less than 5, the second shopmenu will be disabled (4 is standard war3), default is 8)

// ****************************************************************************************************
// ABILITY ENHANCEMENTS
// ****************************************************************************************************

// Chameleon Race Configuration Options (Race 9)
//	This race allows you to either assign skills that will be permanent, or random skills will be chosen each round
FT_Race9_Random		1		// Should the 9th race have random skills each round?, if so the next 4 option are irrelevant (default is 1)
FT_Race9_Skill1		1		// What race should the first skill be taken from? (default is 1)
FT_Race9_Skill2		1		// What race should the second skill be taken from? (default is 1)
FT_Race9_Skill3		1		// What race should the third skill be taken from? (default is 1)
FT_Race9_Ultimate	1		// What race should the ultimate be taken from? (default is 1)


// Skill and Ultimate configurations
FT_ultimatedelay	10.0		// Amount of time (in seconds) to delay the ultimates at the start of each round (default is 15.0)
FT_healing_range	750		// Range for Healing Wave to jump from player to player and heal (default is 750)
FT_ultimate_cooldown	20.0		// Cooldown of all ultimates (default is 35.0)
FT_warn_suicide		1		// Tells Undead Scourges their bomb is armed when they hit ultimate key, a second key press then detonates it (default is 1)
FT_blinkenabled		1		// Use blink instead of team teleport (default is 1)
FT_blink_protection	1		// slays people who abuse blink on some maps (skywalking, map exploiting, default is 1)
FT_blink_radius		500		// Enemies who have immunity w/in this radius will cause blink to fail (default is 500)
FT_blink_dizziness	2		// What type of diziness? (1 or 0 is flashbang effect, 2 is fading blue screen, default is 1)
FT_entangle_drop	0		// Should the player's primary weapon be dropped when they are entangled? (default is 0)
FT_impale_intensity	10		// Setting this to a lower non-negative number will lower the intensity of impale (default is 10)

// Item configurations
FT_glove_timer		10		// Interval between receiving a new grenade with the Flaming Gloves of Warmth (default is 10)
FT_no_gloves_on_ka	1		// Prevents Flaming gloves of warmth on ka maps and scoutzknivez (default is 1)
FT_glove_orc_damage	1		// When using gloves, should orcs be given the critical dmg? (Default is 0)
FT_no_orcnades		0		// Prevent orc nades on ka_ maps, fy_ maps and jail_riot (default is 0)
FT_claw			6		// Damage done by Claws of Attack (default is 6)
FT_bootspeed		300.0		// Speed given for purchasing boots of speed (different for dod, see dod section, default is 275)
FT_health_bonus		40		// Health bonus given for periapt of health (default is 15)
FT_frost_speed		125.0		// Speed of victim when attacked with Orb of Frost (default is 125.0)
FT_mask_of_death	0.3		// Percentage of like gained back by mask of death (default is 0.3)
FT_cloak		160		// Invisibility given with cloak, lower is more invisible (default is 150)
FT_sock			0.5		// Gravity level for Sock of the Feather

// Bot Configuration Options
FT_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
DOD_startmoney		800		// Starting "fake" money for dod
DOD_bootspeed		45.0		// Stamina given for boots of speed in Day of Defeat (default is 45.0)

That is the same on both WC3 servers. I just now reset all the skills and tried it but it didn't work. When I use phpmyadmin to create the table, it forces me to create a field within that table. What should this field be? Would this be affecting it any? Do I need to delete that table and let the mod handle it?

[DesasterUK]

you need to run the mysql module (modules.ini)
wc3ft 2.3.2 doesn't support sqlite (afaik)

[Geesu]

it does support sqlite

[DesasterUK]

// SQL configuration
FT_sql_host "mysql4.websitesource.net:3306" // Host Name
FT_sql_user "Achille_AGS" // User Name
FT_sql_pass "*removed*" // Password
FT_sql_db "Achille_WAR" // Database Name

but he tries to save in a mysql database.
so it won't run that way.

[Gunny]

// SQL configuration
FT_sql_host "mysql4.websitesource.net:3306" // Host Name
FT_sql_user "Achille_AGS" // User Name
FT_sql_pass "*removed*" // Password
FT_sql_db "Achille_WAR" // Database Name

but he tries to save in a mysql database.
so it won't run that way.

Might try removing the port from the address

[Geesu]

Yea thats the problem - remove :3306