SQL question/problem

Overkill · Post by **Overkill** » Sun Oct 01, 2006 8:33 pm

First - I am a TOTAL noob to SQL. That said, I know my way around CPanel enough to find PHPMyAdmin, and I know how to set up an SQL database & users through CPanel.

The problem I'm having is this:
I have my XP set to save to an SQL database set up on my site. XP is saved fine in my server, nobody has complained about a loss of XP. However, when I go to PHPMyAdmin, there are no tables in the database. Should I be able to see/edit one?

Also, I want to manually add XP to users' races via the SQL database, rather than use amx_givexp in server. To gain a user base for my server, I'm giving away free xp to whoever wants it once they register on & post in the forums.

I know for a fact that the database/user info is accurite in the war3ft config, and I was told by my game host to put the static IP address of the webserver in for my host.

Any help is appreciated
-Overkill

Overkill · Post by **Overkill** » Thu Oct 05, 2006 9:32 pm

*bump*

also, I have uncommented the 3 MySQL lines in the modules.ini, and commented the SQLLite lines. since then, I have been unable to get the XP to save at all.

also, when i try to have wc3ft.com convert my vault file, it gives me an access error although i know my user info is entered correctly. the server adds the prefix "$cpanelusername_" to all of my databases and usernames, should i include or exclude that prefix when entering the info? I tried both ways and it didnt work.

thanks,
overkill

Post by **YamiKaitou** » Thu Oct 05, 2006 10:18 pm

So the contents of your war3ft.cfg file. Also, post the results of "amx_plugins", "meta list", and "amx_modules"

Overkill · Post by **Overkill** » Sun Oct 08, 2006 1:36 am

war3 config

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		"67.15.250.7"         // Host Name
FT_sql_user		"username"	     // User Name
FT_sql_pass		"password"	    // Password
FT_sql_db		"dbname"   // Database Name
FT_auto_pruning		0		  // Automatically prunes the database of old users at a mapchange (default is 0)
sv_daysbeforedelete	36500		 // 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		0		// 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	10		// XP given for getting a headshot (default is 9)
FT_xp_radius		75000		// 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		2		// 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		0		// Show Spectating information for dead players (default is 1)
FT_show_icons		0		// Shows icons on your screen when your ultimate is ready (default is 1)
FT_race_icons		0		// Allow users to type /icons to show player icons above the player (default is 1)
FT_level_icons		0		// 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	15.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	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	3		// 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	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		30		// 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 life 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		// 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)

plugins

Code: Select all

Malformed packet size (2782, 1234)
Currently loaded plugins:
name               version  author            file             status   
Admin Base         1.71     AMXX Dev Team     admin.amxx       running  
Admin Commands     1.71     AMXX Dev Team     admincmd.amxx    running  
Admin Help         1.71     AMXX Dev Team     adminhelp.amxx   running  
Multi-Lingual Sys  1.71     AMXX Dev Team     multilingual.am  running  
Menus Front-End    1.71     AMXX Dev Team     menufront.amxx   running  
Commands Menu      1.71     AMXX Dev Team     cmdmenu.amxx     running  
Players Menu       1.71     AMXX Dev Team     plmenu.amxx      running  
Teleport Menu      1.71     AMXX Dev Team     telemenu.amxx    running  
Maps Menu          1.71     AMXX Dev Team     mapsmenu.amxx    running  
Admin Chat         1.71     AMXX Dev Team     adminchat.amxx   running  
Anti Flood         1.71     AMXX Dev Team     antiflood.amxx   running  
Scrolling Message  1.71     AMXX Dev Team     scrollmsg.amxx   running  
Info. Messages     1.71     AMXX Dev Team     imessage.amxx    running  
Admin Votes        1.71     AMXX Dev Team     adminvote.amxx   running  
NextMap            1.71     AMXX Dev Team     nextmap.amxx     running  
Nextmap Chooser    1.71     AMXX Dev Team     mapchooser.amxx  running  
TimeLeft           1.71     AMXX Dev Team     timeleft.amxx    running  
Pause Plugins      1.71     AMXX Dev Team     pausecfg.amxx    running  
Stats Configurati  1.71     AMXX Dev Team     statscfg.amxx    running  
Restrict Weapons   1.71     AMXX Dev Team     restmenu.amxx    running  
StatsX             1.71     AMXX Dev Team     statsx.amxx      running  
CS Misc. Stats     1.71     AMXX Dev Team     miscstats.amxx   running  
CS Stats Logging   1.71     AMXX Dev Team     stats_logging.a  running  
Warcraft 3 Frozen  2.3.2    Geesu==(Pimp Dad  warcraft3FT.amx  debug    
AdminListen        2.3x     /dev/ urandom     adminlisten.amx  running  
AINO Commands      2.0      AMX(x) Community  admin_allinone.  running  
Admin Flash        1.0      AssKicR           admin_flash.amx  running  
AMX Llama          1.4      SniperBeamer      admin_llama.amx  running  
AFK Bomb Transfer  0.4      VEN               afkbombtransfer  running  
Unlimited Ammo     0.2      v3x               amx_ammo.amxx    running  
Knife Only on Bri  1.0      xx_sirhc_xx       amx_deagle5_kni  running  
AMX Client Exec    0.03     v3x               amx_exec.amxx    running  
Admin Fire         1.0.0    f117bomb          amx_fire.amxx    running  
Wrath of God       1.01     jsauce            amx_wog.amxx     running  
Player Disconnect  0.2      v3x               disconnect_info  running  
Drop all weapons   0.1      JGHG              dropallweapons.  running  
The Flop 10        2.1      FaNa              flop10.amxx      running  
Basic RCON/CVAR C  1.2      GHW_Chronic       ghw_basic_comma  running  
Auto Message Disp  1.0      GHW_Chronic       GHW_Chat_Text.a  running  
GHW Say Commands   1.0      GHW_Chronic       GHW_Custom_Say_  stopped  
Personal Gravity   2.2      GHW_Chronic       ghw_personal_gr  stopped  
Plant Defuse Priz  0.1      Hydralisk         hy_plantprize.a  running  
Info. Messages     1.71     AMXX Dev Team     imessage.amxx    running  
LAN Notifier       1.0      Brad Jones        lann.amxx        running  
Last man bets      0.9.3    JGHG              lastmanbets.amx  running  
Mp5 Mod            1.9      PaintLancer       mp5_mod.amxx     running  
NoBombScore        1.0      MistaGee          nobombscore.amx  running  
Run Planting       1.0      ts2do             runplanting.amx  running  
Shields for T      0.1      JGHG              shieldsfort.amx  running  
Sunglasses         1.1      Calzinger/AssKic  sunglasses.amxx  running

meta list

Code: Select all

Currently running plugins:
 [  1] AMX Mod X, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
 [  2] Fun, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
 [  3] Engine, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
 [  4] FakeMeta, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
 [  5] MySQL, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org/
 [  6] CStrike, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
 [  7] CSX, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org/

amx_modules

Code: Select all

Currently loaded modules:
name                    version  author              
Fun                     1.71     AMX Mod X Dev Team  
Engine                  1.71     AMX Mod X Dev Team  
FakeMeta                1.71     AMX Mod X Dev Team  
MySQL                   1.71     AMX Mod X Dev Team  
CStrike                 1.71     AMX Mod X Dev Team  
CSX                     1.71     AMX Mod X Dev Team  
Sqlite                  1.70     AMX Mod X Dev Team  
RegEx                   1.71     AMX Mod X Dev Team

mattypee · Post by **mattypee** » Sun Oct 08, 2006 9:33 am

i thought one of the two saving modules were suppose to be on, you have sqllite and mysql

meta list

Code:

Currently running plugins:
[ 1] AMX Mod X, v1.71, Apr 2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
[ 2] Fun, v1.71, Apr 2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
[ 3] Engine, v1.71, Apr 2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
[ 4] FakeMeta, v1.71, Apr 2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
[ 5] MySQL, v1.71, Apr 2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org/
[ 6] CStrike, v1.71, Apr 2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
[ 7] CSX, v1.71, Apr 2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org/

amx_modules

Code:
Currently loaded modules:
name version author
Fun 1.71 AMX Mod X Dev Team
Engine 1.71 AMX Mod X Dev Team
FakeMeta 1.71 AMX Mod X Dev Team
MySQL 1.71 AMX Mod X Dev Team
CStrike 1.71 AMX Mod X Dev Team
CSX 1.71 AMX Mod X Dev Team
Sqlite 1.70 AMX Mod X Dev Team
RegEx 1.71 AMX Mod X Dev Team

Overkill · Post by **Overkill** » Sun Oct 08, 2006 11:23 am

idk how that happened...stopped server and uploaded a diff config, it still doesn't save even though SQLite is off, MySQL is still on.

Code: Select all

amx_plugins:
Malformed packet size (2782, 1236)
Currently loaded plugins:
name               version  author            file             status   
Admin Base         1.71     AMXX Dev Team     admin.amxx       running  
Admin Commands     1.71     AMXX Dev Team     admincmd.amxx    running  
Admin Help         1.71     AMXX Dev Team     adminhelp.amxx   running  
Multi-Lingual Sys  1.71     AMXX Dev Team     multilingual.am  running  
Menus Front-End    1.71     AMXX Dev Team     menufront.amxx   running 
Commands Menu      1.71     AMXX Dev Team     cmdmenu.amxx     running  
Players Menu       1.71     AMXX Dev Team     plmenu.amxx      running  
Teleport Menu      1.71     AMXX Dev Team     telemenu.amxx    running  
Maps Menu          1.71     AMXX Dev Team     mapsmenu.amxx    running  
Admin Chat         1.71     AMXX Dev Team     adminchat.amxx   running  
Anti Flood         1.71     AMXX Dev Team     antiflood.amxx   running  
Scrolling Message  1.71     AMXX Dev Team     scrollmsg.amxx   running  
Info. Messages     1.71     AMXX Dev Team     imessage.amxx    running  
Admin Votes        1.71     AMXX Dev Team     adminvote.amxx   running  
NextMap            1.71     AMXX Dev Team     nextmap.amxx     running  
Nextmap Chooser    1.71     AMXX Dev Team     mapchooser.amxx  running  
TimeLeft           1.71     AMXX Dev Team     timeleft.amxx    running  
Pause Plugins      1.71     AMXX Dev Team     pausecfg.amxx    running  
Stats Configurati  1.71     AMXX Dev Team     statscfg.amxx    running  
estrict Weapons   1.71     AMXX Dev Team     restmenu.amxx    running  
StatsX             1.71     AMXX Dev Team     statsx.amxx      running  
CS Misc. Stats     1.71     AMXX Dev Team     miscstats.amxx   running  
CS Stats Logging   1.71     AMXX Dev Team     stats_logging.a  running  
Warcraft 3 Frozen  2.3.2    Geesu==(Pimp Dad  warcraft3FT.amx  debug    
AdminListen        2.3x     /dev/ urandom     adminlisten.amx  running  
AINO Commands      2.0      AMX(x) Community  admin_allinone.  running  
Amin Flash        1.0      AssKicR           admin_flash.amx  running  
AMX Llama          1.4      SniperBeamer      admin_llama.amx  running  
AFK Bomb Transfer  0.4      VEN               afkbombtransfer  running  
Unlimited Ammo     0.2      v3x               amx_ammo.amxx    running  
Knife Only on Bri  1.0      xx_sirhc_xx       amx_deagle5_kni  running  
AMX Client Exec    0.03     v3x               amx_exec.amxx    running  
Admin Fire         1.0.0    f117bomb          amx_fire.amxx    running  
Wrth of God       1.01     jsauce            amx_wog.amxx     running  
Player Disconnect  0.2      v3x               disconnect_info  running  
Drop all weapons   0.1      JGHG              dropallweapons.  running  
The Flop 10        2.1      FaNa              flop10.amxx      running  
Basic RCON/CVAR C  1.2      GHW_Chronic       ghw_basic_comma  running  
Auto Message Disp  1.0      GHW_Chronic       GHW_Chat_Text.a  running  
GHW Say Commands   1.0      GHW_Chronic       GHW_Custom_Say_  stopped  
Peronal Gravity   2.2      GHW_Chronic       ghw_personal_gr  stopped  
Plant Defuse Priz  0.1      Hydralisk         hy_plantprize.a  running  
Info. Messages     1.71     AMXX Dev Team     imessage.amxx    running  
LAN Notifier       1.0      Brad Jones        lann.amxx        running  
Last man bets      0.9.3    JGHG              lastmanbets.amx  running  
Mp5 Mod            1.9      PaintLancer       mp5_mod.amxx     running  
NoBombScore        1.0      MistaGee          nobombscore.amx  running  
Run lanting       1.0      ts2do             runplanting.amx  running  
Shields for T      0.1      JGHG              shieldsfort.amx  running  
Sunglasses         1.1      Calzinger/AssKic  sunglasses.amxx  running  
50 plugins, 47 running

amx_modules:
Currently loaded modules:
name                    version  author              
Fun                     1.71     AMX Mod X Dev Team  
Engine                  1.71     AMX Mod X Dev Team  
FakeMeta                1.71    AMX Mod X Dev Team  
MySQL                   1.71     AMX Mod X Dev Team  
CStrike                 1.71     AMX Mod X Dev Team  
CSX                     1.71     AMX Mod X Dev Team  
RegEx                   1.71     AMX Mod X Dev Team  
7 modules

meta list:
Currently running plugins:
 [  1] AMX Mod X, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
 [  2] Fun, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
 [  3] Engine, v1.71, Apr  2 2006, by AMX Mod X Dev eam, see http://www.amxmodx.org
 [  4] FakeMeta, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
 [  5] MySQL, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org/
 [  6] CStrike, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
 [  7] CSX, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org/
7 plugins

mattypee · Post by **mattypee** » Sun Oct 08, 2006 8:08 pm

Ive had the same problem with saving to mysql, its weird cuz it would save to a diffrent table when i put both sqllite on and mysql, currently using sqllite alone. Im guessing gameservers.com is the problem, dunno, never had any problems with mysql before.

erik2k3 · Post by **erik2k3** » Wed Oct 18, 2006 7:43 pm

you only need ONE sql module to be running... ONE and ONE alone !!!!