[arnaldo_silva]

Originally Posted by Nextra The default ps_prefix is "psy_" not "ps_". Maybe you got that wrong?

Is there any diference?

[Mordekay]

If not you wouldn't need to give the database or tables a name at all.
If you installed psychostats with the prefix "psy_" then you have to have the same prefix in your igp plugin setup. Otherwise the plugin cannot add the data to the tables as it cannot find them.
So make sure the cvar "ps_prefix" sets the correct prefix for your psychostats installation. Use phpmyadmin for example to check your current prefix.

[liryck]

spanish translation by Mile_ or liryck you can check it out

[es]
PS_JOINMSG = |->| %s (%s) ha entrado al juego con %.de skillpoints. Rank: %d
PS_DISCMSG = |<-| %s (%s) ha dejado el juego con %.de skillpoints. Rank: %d
PS_ADSHEAD = Esta servidor esta usando Psychostats %s
PS_ADSREG = Para registrarse, Escrone en consola ps_reg username password
PS_ADSCMDS = Comandos:%s %s
PS_RANKHEAD = Tu Psychostats %s ranking
PS_RANKME = Rank %d de %d jugadores con %.0f puntos - kills: %d - deaths: %d
PS_RANKALL = %s's Rank: %d de %d jugadores con %.0f puntos - kills: %d - deaths: %d
PS_TOP = TOP %d loaded.
PS_YOURRANKIS = Tu rank es %d de %d jugadores.
PS_POINTS = Puntos
PS_PREVPOINTS = Puntos Anteriores
PS_RANK = Rank
PS_PREVRANK = Rank Anterior
PS_FFKILLS = Teamkills
PS_ACCURACY = Accuracy
PS_NAME = Nombre
PS_TOTALPLAYERS = Total de Jugadores
PS_WHOISLOOKUP = Whois Lookup
PS_PLAYERDATA = Player Data
PS_MOSTUSEDNAMES = Nombre mas usado
PS_PLAYERSTATS = Estadisticas de jugador
PS_ACCESS = Acceso
PS_FIRSTCONNECT = Primera Coneccion
PS_CONNECTIONS = Total de Connecciones
PS_ONLINETIME = Tiempo Online
PS_STATME = Tu rank es %d de %d jugadores
PS_STATALL = %s's rank es %d de %d jugadores
PS_REGDISABLED = Registracion desabilitadas.
PS_REGMISSDATA = Insuficiente data! nececitas dar el usuario y contraseña.
PS_REGTOOMUCH = Demasiada data! El problema puede ser por no usar " ". Debes usarlas si quieres dejar espacios.
PS_REGINV = data invalida debido a las siguientes razones:
PS_REGUSERINV = Nickname debe tener al menos mas de 3 caracteres y menos de 32.
PS_REGPASSINV = Password debe tener al menos mas de 3 caracteres y menos de 32.
PS_REGUSERNA = El nombre de usuario ya ha sido elegido.
PS_REGPOSITIVE = Account ha sido creado. Ahora puedes logearte en %s
PS_REGALREADY = Ya estas registrado.
PS_REGNOTRANKED = No haz sido rankeado aun.
PS_REGPROCESS = Por favor espera a que termine tu registro anterior.
PS_REGNEGATIVE = Account no ha sido creado debido a una de las siguientes razones:
PS_NOPLAYER = El jugador no ha sido encontrado.
PS_INVALID = Numero invalido.
PS_FLOODING = No spamees el comando skill! Delay es: %.2f segundos.
PS_CMDDISABLED = Este comando ha sido desabilitado.
PS_DISCONNECTED = El jugador se ha desconectado.

[Nextra]

Originally Posted by arnaldo_silva Is there any diference?

Yes.

Psychostats gives you the option to install with a table prefix of your choice. That way it allows you to install multiple Psychostats installations into a single database, distinguished only by their different table prefix.

By default, Psychostats sets this prefix to "psy_". All tables then begin with that prefix (psy_plr, psy_c_plr_data, psy_plr_profile etc.). So that's where the cvar ps_prefix comes in. IGPS needs to know what prefix you specified, otherwise it can't find the tables in the database. Likely you have set up Psychostats to use the "psy_" prefix, if you now set IGPS to search for the "ps_" prefix it will say "Can not find table XY" because it searches for ps_plr instead of psy_plr, ps_c_plr_data instead of psy_c_plr_data and so on.

So try setting the prefix to "psy_" and see if errors persist. If you still can't get it to run you may have specified an entirely different prefix. If you forgot which prefix you chose you would need to use phpmyadmin (or a similar tool) to look for the correct prefix.

Hope this helped.

Originally Posted by liryck spanish translation

Thanks a lot. Added.

[arnaldo_silva]

L 05/04/2010 - 19:27:27: [ingame_psychostats.amxx] [IG-PS] Error: (1146) Table 'clan_psy.psy_c_plr_data' doesn't exist
L 05/04/2010 - 19:27:27: [ingame_psychostats.amxx] [IG-PS] Query: SELECT `a`.`skill`, `a`.`rank`, `b`.`kills`, `b`.`deaths`, ( SELECT COUNT( * ) FROM `psy_plr` WHERE `allowrank` = '1' ) AS `count` FROM `psy_plr` AS `a`, `psy_c_plr_data` AS `b` WHERE `a`.`uniqueid` = 'STEAM_0:1:13294985' AND `a`.`plrid` = `b`.`plrid`;

Still the same error :S

Im my database (mysql) i don't have a psy_c_plr_data. Only psy_plr_data.

19:29:49 "ps_prefix" is "psy_"

Maybe is there other thing that puts the 'c' there?

[Mordekay]

Then this table is missing. Try to reinstall psychostats.

EDIT
Or try this in mphmyadmin within the psystats database:

CREATE TABLE IF NOT EXISTS `psy_c_plr_data` (
  `dataid` int(10) unsigned NOT NULL default '0',
  `plrid` int(10) unsigned NOT NULL default '0',
  `firstdate` date NOT NULL default '0000-00-00',
  `lastdate` date NOT NULL default '0000-00-00',
  `accuracy` float(10,2) NOT NULL default '0.00',
  `banned` int(11) NOT NULL default '0',
  `bombdefuseattempts` int(11) NOT NULL default '0',
  `bombdefused` int(11) NOT NULL default '0',
  `bombdefusedpct` float(10,2) NOT NULL default '0.00',
  `bombexploded` int(11) NOT NULL default '0',
  `bombexplodedpct` float(10,2) NOT NULL default '0.00',
  `bombplanted` int(11) NOT NULL default '0',
  `bombplantedpct` float(10,2) NOT NULL default '0.00',
  `bombrunner` int(11) NOT NULL default '0',
  `bombrunnerpct` float(10,2) NOT NULL default '0.00',
  `bombspawned` int(11) NOT NULL default '0',
  `cheated` int(11) NOT NULL default '0',
  `connections` int(11) NOT NULL default '0',
  `ctdeaths` int(11) NOT NULL default '0',
  `ctkills` int(11) NOT NULL default '0',
  `ctlost` int(11) NOT NULL default '0',
  `ctwon` int(11) NOT NULL default '0',
  `ctwonpct` float(10,2) NOT NULL default '0.00',
  `damage` int(11) NOT NULL default '0',
  `deaths` int(11) NOT NULL default '0',
  `deaths_streak` int(11) NOT NULL default '0',
  `ffdeaths` int(11) NOT NULL default '0',
  `ffdeathspct` float(10,2) NOT NULL default '0.00',
  `ffkills` int(11) NOT NULL default '0',
  `ffkillspct` float(10,2) NOT NULL default '0.00',
  `games` int(11) NOT NULL default '0',
  `headshotkills` int(11) NOT NULL default '0',
  `headshotkillspct` float(10,2) NOT NULL default '0.00',
  `hits` int(11) NOT NULL default '0',
  `joinedct` int(11) NOT NULL default '0',
  `joinedspectator` int(11) NOT NULL default '0',
  `joinedterrorist` int(11) NOT NULL default '0',
  `kicked` int(11) NOT NULL default '0',
  `killedhostages` int(11) NOT NULL default '0',
  `kills` int(11) NOT NULL default '0',
  `kills_streak` int(11) NOT NULL default '0',
  `killsperdeath` float(10,2) NOT NULL default '0.00',
  `killsperminute` float(10,2) NOT NULL default '0.00',
  `lasttime` int(11) NOT NULL default '0',
  `onlinetime` int(11) NOT NULL default '0',
  `rescuedhostages` int(11) NOT NULL default '0',
  `rescuedhostagespct` float(10,2) NOT NULL default '0.00',
  `rounds` int(11) NOT NULL default '0',
  `shots` int(11) NOT NULL default '0',
  `shotsperkill` float(10,2) NOT NULL default '0.00',
  `suicides` int(11) NOT NULL default '0',
  `terroristdeaths` int(11) NOT NULL default '0',
  `terroristkills` int(11) NOT NULL default '0',
  `terroristlost` int(11) NOT NULL default '0',
  `terroristwon` int(11) NOT NULL default '0',
  `terroristwonpct` float(10,2) NOT NULL default '0.00',
  `totalbonus` int(11) NOT NULL default '0',
  `touchedhostages` int(11) NOT NULL default '0',
  `vip` int(11) NOT NULL default '0',
  `vipescaped` int(11) NOT NULL default '0',
  `vipkilled` int(11) NOT NULL default '0',
  PRIMARY KEY  (`dataid`),
  UNIQUE KEY `plrid` (`plrid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[liryck]

nextra did you think that is possible for you to show the things in the motd but with html, i dont know how to explain me, uhm if you type statsme display in motd the stats but like the website, i dont know if you got me

[ServO]

Gj!

[Nextra]

Originally Posted by liryck nextra did you think that is possible for you to show the things in the motd but with html, i dont know how to explain me, uhm if you type statsme display in motd the stats but like the website, i dont know if you got me

I could just (try to) display a players profile in a MOTD-window, yes. Problem is that the Psychostats pages are not designed to be displayed in an ingame MOTD. I can't provide specific data but have to display the entire profile instead. That's far too much data to show in the small ingame-MOTD window and I'm not even sure if the outdated browser of CS could display it at all.

So no, this is not a practical approach by any means at least as far as I see it. Having proper ingame-browser-friendly pages would require a lot of work on the Psychostats web files.

Originally Posted by ServO Gj!

Thanks!

[SeanArcher]

Hi Nextra,

Your plugin is great, but crash my server after 5 minutes. There is my errolog:

L 06/03/2010 - 17:38:35: Info (map "de_dust2") (file "addons/amxmodx/logs1/error_20100603.log")
L 06/03/2010 - 17:38:35: String formatted incorrectly - parameter 5 (total 4)
L 06/03/2010 - 17:38:35: [AMXX] Displaying debug trace (plugin "ingame_psychostats.amxx")
L 06/03/2010 - 17:38:35: [AMXX] Run time error 25: parameter error 
L 06/03/2010 - 17:38:35: [AMXX]    [0] ingame_psychostats.sma::ColorChat (line 1795)
L 06/03/2010 - 17:38:35: [AMXX]    [1] ingame_psychostats.sma::ColorChat (line 1839)

I'm hosting 14 counter-strike servers. There's a way to query mysql only when the user say the commands (when connect and disconnect messages are turned off)?