Page 1 of 1

Cannot get MySQL saving to work for 2.2.6

Posted: Mon Oct 10, 2005 3:48 pm
by Krazy
I am trying to get my server to save XP on my MySQL datebase on my webserver. I set up the datebase and i converted my vault.ini with http://wc3mods.net/war3ft/vault.php and it created it successfully. I am using the same information that worked for converting my vault.ini to MySQL but it will not connect. I am running MySQL 4.1.13-standard. I set up the war3 stats on my site to test it and it works http://www.djpsych.com/brothersofkhaos/war3stats/ so i think my datebase is working right. I also set up my datebase to allow any IP to connect to it. Can not figure out what i did wrong.

My Error:
L 10/11/2005 - 04:49:42: [MYSQL] Invalid database handle 0
L 10/11/2005 - 04:49:42: [AMXX] Displaying debug trace (plugin "warcraft3FT.amxx")
L 10/11/2005 - 04:49:42: [AMXX] Run time error 10: native error (native "dbi_error")
L 10/11/2005 - 04:49:42: [AMXX] [0] XP.inl::XP_Set_DBI (line 652)
L 10/11/2005 - 04:49:42: [AMXX] [1] XP.inl::XP_Retreive (line 345)
L 10/11/2005 - 04:49:42: [AMXX] [2] war3ft.inl::WAR3_chooserace (line 206)
L 10/11/2005 - 04:49:42: [AMXX] [3] other.inl::getuserinput (line 151)

modules.ini:
; ------------------------------
; Fun - provides extra functions
; ------------------------------
fun_amxx_i386.so
fun_amxx.dll
fun_amxx_amd64.so

; ----------------------------------------------------
; Engine - provides engine functions core to Half-Life
; ----------------------------------------------------
engine_amxx_i386.so
engine_amxx.dll
engine_amxx_amd64.so

; ----------------------------------------------------------
; Fakemeta - provides a massive interface into the HL engine
; ----------------------------------------------------------
;fakemeta_amxx_i386.so
;fakemeta_amxx.dll
;fakemeta_amxx_amd64.so

; -------------------------------------------
; Database Access - only enable one of these
; -------------------------------------------
; MySQL
mysql_amxx_i386.so
mysql_amxx.dll
mysql_amxx_amd64.so
; PostgreSQL
;pgsql_amxx_i386.so
;pgsql_amxx.dll
; Microsoft SQL
;mssql_amxx.dll
; SQLite
;sqlite_amxx.dll
;sqlite_amxx_i386.so
;sqlite_amxx_amd64.so

; ---------------------------------------------
; GeoIP - determines the country of ip adresses
; ---------------------------------------------
;geoip_amxx_i386.so
;geoip_amxx.dll
;geoip_amxx_amd64.so

; --------------------------------
; Sockets - network socket support
; --------------------------------
;sockets_amxx_i386.so
;sockets_amxx.dll
;sockets_amxx_amd64.so

; --------------------------
; Regular Expression support
; --------------------------
;regex_amxx_i386.so
;regex_amxx.dll
;regex_amxx_amd64.so

; --------------------
; Binary Vault support
; --------------------
;nvault_amxx_i386.so
;nvault_amxx.dll
;nvault_amxx_amd64.so

; ----------------------------------------------------------
; Counter-Strike - adds functions specific to Counter-Strike
; ----------------------------------------------------------
cstrike_amxx_i386.so
cstrike_amxx.dll
cstrike_amxx_amd64.so

; -----------------------------------------------------
; CSX - adds functionality for CS statistics and events
; -----------------------------------------------------
csx_amxx_i386.so
csx_amxx.dll
csx_amxx_amd64.so

; --------------------------------------------------------------
; WAR3FT - adds functions used by war3ft - By Geesu (Pimp Daddy)
; --------------------------------------------------------------
war3ft_amxx_i386.so
war3ft_amxx.dll
war3ft_amxx_amd64.so

plugins.ini:
; Admin Base - Always one has to be activated
admin.amxx ; admin base (required for any admin-related)
;admin_sql.amxx ; admin base - SQL version (comment admin.amxx)

; Basic
admincmd.amxx ; basic admin console commands
adminhelp.amxx ; help command for admin console commands
;adminslots.amxx ; slot reservation
multilingual.amxx ; Multi-Lingual management

; Menus
menufront.amxx ; front-end for admin menus
cmdmenu.amxx ; command menu (speech, settings)
plmenu.amxx ; players menu (kick, ban, client cmds.)
telemenu.amxx ; teleport menu (Fun Module required!)
mapsmenu.amxx ; maps menu (vote, changelevel)

; Chat / Messages
adminchat.amxx ; console chat commands
antiflood.amxx ; prevent clients from chat-flooding the server
scrollmsg.amxx ; displays a scrolling message
imessage.amxx ; displays information messages
adminvote.amxx ; vote commands

; Map related
nextmap.amxx ; displays next map in mapcycle
;mapchooser.amxx ; allows to vote for next map
timeleft.amxx ; displays time left on map

; Configuration
pausecfg.amxx ; allows to pause and unpause some plugins
statscfg.amxx ; allows to manage stats plugins via menu and commands

; Counter-Strike
restmenu.amxx ; restrict weapons menu
statsx.amxx ; stats on death or round end (CSX Module required!)
miscstats.amxx ; bunch of events announcement for Counter-Strike
stats_logging.amxx ; weapons stats logging (CSX Module required!)


; Custom - Add 3rd party plugins here
warcraft3FT.amxx debug
deagsmapmanage227d.amxx
amx_transfer.amxx
say_commands.amxx
map_cvars.amxx
admin_gag.amxx
knifes_only.amxx
weapon_restrict.amxx
admin_force_fire.amxx
amx_ejl_nukem.amxx
amx_exec.amxx
clan_tag_checker.amxx
team_balancer.amxx
slots_reservation.amxx
amx_flush.amxx
voicecomm_ban.amxx
ac_spinhackdetector.amxx
fullupdate_blocker.amxx
afkkicker.amxx

war3FT.cfg:
mp_savexp 1 // Enables saving of experience (uses a vault, default is 0)
sv_mysql 1 // this will save w/MySQL (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 (works for vault and mysql, default is 0)

// MySQL configuration
FT_mysql_host "(PM me if you need it)" // Host Name
FT_mysql_user "djpsych_war3" // User Name
FT_mysql_pass "(PM me if you need it)" // Password
FT_mysql_db "djpsych_war3" // Database Name
sv_mysql_auto_pruning 0 // Automatically prunes the database of old users at a mapchange occuring between 5:36 to 5:59 AM (default is 0, doesn't work for vault)
sv_daysbeforedelete 15 // However many days before deleting XP or pruning from MySQL database (default is 31)
sv_mysqltablename "war3users" // Table Name, no need to change (default is war3users)
sv_mysql_save_end_round 0 // Save Users at the end of each round (causes slight lag, default is 0)
FT_disable_savexp 1 // Set this to 1 to disable users typing /savexp (default is 0)

// 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 1 // 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 1 // 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_control 0 // Enable Time Activation Controler (default is 0)
FT_start 23 // Hour to Activate WC3 (time is in military time, default is 23)
FT_stop 07 // Hour to Deactivate WC3 (default is 07)
FT_message 0 // Show Message Monitor (near radar) (default is 0)
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 1 // Show teammate and enemy information in the center of the screen when they are on target? (not for DOD, 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 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 35.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 1 // What type of diziness? (1 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 30 // 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 0 // When using gloves, should orcs be given the critical dmg? (Default is 0)
FT_no_orcnades 1 // 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 275.0 // Speed given for purchasing boots of speed (different for dod, see dod section, default is 275)
FT_health_bonus 15 // 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.2 // Percentage of like gained back by mask of death (default is 0.3)
FT_cloak 150 // 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)

Posted: Mon Oct 10, 2005 4:07 pm
by Geesu
Krazy I thought you've had this set up before? Hit me up on AIM.

Posted: Tue Oct 11, 2005 2:43 pm
by Krazy
I figured out what i was trying to do will not work. And i could not get SQLite to work or i was doing something wrong so i guess i will just stay with vault saving. You can lock this.