SQL question/problem

Read log files for errors! If this fails, come here for help

Moderator: Forum Moderator

Overkill
Peon
Posts: 28
Joined: Thu Jul 13, 2006 1:18 pm

SQL question/problem

Postby 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
That's my two cents. I'd write more but I'm not getting paid by the hour.

Overkill
Peon
Posts: 28
Joined: Thu Jul 13, 2006 1:18 pm

Postby 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
That's my two cents. I'd write more but I'm not getting paid by the hour.

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Postby 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"
Image

No support via PM or Email

Overkill
Peon
Posts: 28
Joined: Thu Jul 13, 2006 1:18 pm

Postby 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 
That's my two cents. I'd write more but I'm not getting paid by the hour.

User avatar
mattypee
Footman
Posts: 101
Joined: Sun Sep 10, 2006 4:06 pm
Location: Wisconsin

Postby 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
Peon
Posts: 28
Joined: Thu Jul 13, 2006 1:18 pm

Postby 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
That's my two cents. I'd write more but I'm not getting paid by the hour.

User avatar
mattypee
Footman
Posts: 101
Joined: Sun Sep 10, 2006 4:06 pm
Location: Wisconsin

Postby 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
Militia
Posts: 73
Joined: Wed Aug 03, 2005 6:34 am
Location: Germany / UK
Contact:

Postby erik2k3 » Wed Oct 18, 2006 7:43 pm

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

terry123
Peon
Posts: 15
Joined: Thu Apr 24, 2014 1:53 am
Contact:

Re: SQL question/problem

Postby terry123 » Fri Aug 22, 2014 8:14 pm

I have uncommented the 3 MySQL lines in the modules.
www.rush4rs.com


Return to “Help/Support”

Who is online

Users browsing this forum: No registered users and 1 guest