stats install

headbuster · Post by **headbuster** » Sat Jun 23, 2007 12:52 pm

--- Please enter the following information for support ---
War3ft Version: war3ft_v2.3.1
Amxmodx Version: 1.79d
Metamod Version:
amxx list:
amxx modules:
meta list:

I am installing xp statistics on an free hosting server with mysql and everything I need (can I do that)
Please tell me what I have to do because I have to be sure I am doing it right
when i enter the adress of the webstats ( http://headbusterrer.hyperphp.com/webstats/ ) It show this

Code: Select all

Query failed : Table 'hp_658030_webstats.war3users' doesn't exist

Please help me

Post by **YamiKaitou** » Sat Jun 23, 2007 12:57 pm

1) There is no 1.79d version of AmxModX

2) Are you saving your xp to MySQL?

headbuster · Post by **headbuster** » Sat Jun 23, 2007 1:02 pm

sorry 1.76d!
Sorry for the stupid question but what do you mean by saving xp to mysql

Post by **YamiKaitou** » Sat Jun 23, 2007 1:07 pm

Are you saving your xp to MySQL, SQLite, or Vault? If you are unsure, post the first 10 lines of your war3ft.cfg file

headbuster · Post by **headbuster** » Sat Jun 23, 2007 1:19 pm

mp_savexp 0 // 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 2 // What should I save this as? steam id = 0, IP = 1, name = 2 (default is 0)
------------
WILL you help me!
Please

headbuster · Post by **headbuster** » Sat Jun 23, 2007 1:54 pm

What should I do please tell me!?

Post by **YamiKaitou** » Sat Jun 23, 2007 3:12 pm

You don't even have it set to save xp. Change mp_savexp to 1. Then, make sure you have the SQL cvars configured correctly.

headbuster · Post by **headbuster** » Sun Jun 24, 2007 12:23 am

1OK about the svae xp (does this mean that the xs ois saved and every time you connect you are the highest level you reacherd)
2 What are the sql Cvas

sorry but I don't know much zbout sql

headbuster · Post by **headbuster** » Sun Jun 24, 2007 12:31 am

I don't think the problem is there! I may understand little about sql but I know english
Query failed : Table 'hp_658030_webstats.war3users' doesn't exist

DesasterUK · Post by **DesasterUK** » Sun Jun 24, 2007 3:44 am

@headbuster:
He can't use the statistics website until he is saving the XP to a mysql database.
He is running wc3ft in short term mode, so the plugin hasn't created the needed tables in the database.

Yami is on the right way to help him.

headbuster · Post by **headbuster** » Sun Jun 24, 2007 3:56 am

I just have to make the server SAVE XP? Is that all

headbuster · Post by **headbuster** » Sun Jun 24, 2007 4:20 am

I have made mp_savexp 1 and still

Code: Select all

Query failed : Table 'hp_658030_webstats.war3users' doesn't exist

please tell me where the problem could be

Post by **YamiKaitou** » Sun Jun 24, 2007 9:19 am

You need to tell the plugin to save the xp to that MySQL database. So, you need to set the cvars to the info that you are using on the stats page

headbuster · Post by **headbuster** » Sun Jun 24, 2007 9:23 am

Come again? i have set everything DB Username Passs everything but still.!
Please tell me because I am a noob SORRY

Post by **YamiKaitou** » Sun Jun 24, 2007 10:01 am

You need to set these cvars in the war3ft.cfg file before it can start saving to MySQL. Then you have to make sure that you have the mysql module enabled

FT_sql_host "127.0.0.1" // Host Name
FT_sql_user "root" // User Name
FT_sql_pass "" // Password
FT_sql_db "" // Database Name

headbuster · Post by **headbuster** » Sun Jun 24, 2007 10:23 am

I have done that and still no result

Post by **YamiKaitou** » Sun Jun 24, 2007 10:32 am

Look in the logs, see if there is any errors

headbuster · Post by **headbuster** » Sun Jun 24, 2007 12:20 pm

what should i look for there

Post by **YamiKaitou** » Sun Jun 24, 2007 12:47 pm

something dealing with warcraft3FT.amxx or failing to connect to mysql

headbuster · Post by **headbuster** » Sun Jun 24, 2007 12:57 pm

Code: Select all

L 06/24/2007 - 10:35:21: -------- Mapchange to fy_snow --------
L 06/24/2007 - 10:35:21: [AMXX] Plugin file open error (plugin "restmenu.amxx")
L 06/24/2007 - 10:35:21: [AMXX] Plugin file open error (plugin "statsx.amxx")
L 06/24/2007 - 10:35:21: [AMXX] Plugin file open error (plugin "miscstats.amxx")
L 06/24/2007 - 10:35:21: [AMXX] Plugin file open error (plugin "stats_logging.amxx")
L 06/24/2007 - 10:35:23: [warcraft3FT.amxx] Connection to SQLite database successful
L 06/24/2007 - 10:36:43: [sqlstats.amxx] [sqlStats] gets_user_stats ||A.C.A.B||Pr[]*F.3.A.R, STEAM_ID_LAN
L 06/24/2007 - 10:39:35: [sqlstats.amxx] [sqlStats] gets_user_stats -[pWneD]-, STEAM_ID_LAN
L 06/24/2007 - 10:43:00: [warcraft3FT.amxx] Error in querying database, location: 0
L 06/24/2007 - 10:43:00: [warcraft3FT.amxx] Message: unrecognized token: "')" (1)
L 06/24/2007 - 10:43:00: [warcraft3FT.amxx] Query statement: SELECT `xp`, `race` FROM `war3users` WHERE (`playerid` = '~ HaKer40o ~ |\' _ -|')

EDIT by Yami: Condensing the code to make it easier

Post by **YamiKaitou** » Sun Jun 24, 2007 1:02 pm

You are not saving the xp to MySQL. You are doing it to SQLite. With SQLite, you cannot use the stats page to display it.

And, the reason why you are unable to get xp is because in your name, you have this character '
If you want it to load/save your xp, you will have to remove it

headbuster · Post by **headbuster** » Mon Jun 25, 2007 12:31 am

That's my friends name

I don't have a problem

So to sum up:
1What do I have to do to save the stats to Mysql(i have just spotted a thing wwhich might be the problem
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; SQL Modules usually need to be enabled manually ;;
;; You can have any number on at a time. Use ;;
;; amx_sql_type in sql.cfg to specify the default ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

mysql //I have removed both ;

sqlite
)

headbuster · Post by **headbuster** » Mon Jun 25, 2007 8:26 am

This is what I have done
! used byethost.com
2created a database
3Configured the cfg

// 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 2 // What should I save this as? steam id = 0, IP = 1, name = 2 (default is 0)

// SQL configuration
FT_sql_host "sql1.hyperphp.com" // Host Name
FT_sql_user "hp_658030" // User Name
FT_sql_pass "*******" // Password
FT_sql_db "hp_658030_webstats" // Database Name
4uploaded the files configured the config.php

Could someone post the steps
thanks

headbuster · Post by **headbuster** » Mon Jun 25, 2007 12:43 pm

Thats new

L 06/25/2007 - 21:41:03: [warcraft3FT.amxx] Database connection failed, attempting to reconnect in 5 seconds
L 06/25/2007 - 21:41:03: [warcraft3FT.amxx] Error: Can't connect to MySQL server on 'sql1.hyperphp.com' (10060)

Post by **YamiKaitou** » Mon Jun 25, 2007 4:47 pm

Your server doesn't have access to connect to that sql server. Contact your provider about it