Psychostats Reference?

[Wilson [29th ID]]

Does anyone know any reference links for psychostats? Or how they are stored in the database? I'm looking to find out how to retrieve the "identities" from the database for each player via a plugin.

Just wondering if anyone knows off the top of your head.

[Zor]

Should be easy...let me look, I think its easy! hwehehe

[Zor]

Ok so here are the tables your looking for:

#
# Table structure for table `pstats_plrids`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 27, 2004 at 12:13 PM
#

CREATE TABLE `pstats_plrids` (
`plrid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(64) NOT NULL default '',
`worldid` varchar(32) NOT NULL default '',
`ipaddr` int(10) unsigned NOT NULL default '0',
`totaluses` mediumint(8) unsigned NOT NULL default '1',
`gametype` smallint(5) unsigned NOT NULL default '0',
`modtype` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`plrid`),
KEY `name` (`name`),
KEY `worldid` (`worldid`),
KEY `ipaddr` (`ipaddr`)
) TYPE=MyISAM COMMENT='Unique player ID''s' ;

#
# Table structure for table `pstats_plr`
#
# Creation: Apr 29, 2004 at 10:40 AM
# Last update: May 06, 2004 at 11:16 AM
# Last check: May 06, 2004 at 11:16 AM
#

CREATE TABLE `pstats_plr` (
`plrid` int(10) unsigned NOT NULL default '0',
`srvid` smallint(5) unsigned NOT NULL default '0',
`clanid` int(10) unsigned NOT NULL default '0',
`plrlastdate` date NOT NULL default '0000-00-00',
`rank` mediumint(8) unsigned NOT NULL default '0',
`oldrank` mediumint(8) unsigned NOT NULL default '0',
`skill` float(8,2) NOT NULL default '0.00',
`prevskill` float(8,2) NOT NULL default '0.00',
`name` varchar(64) NOT NULL default '',
`worldid` varchar(32) NOT NULL default '',
`ipaddr` int(10) unsigned NOT NULL default '0',
`allowrank` tinyint(1) unsigned NOT NULL default '1',
`gametype` smallint(5) unsigned NOT NULL default '0',
`modtype` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`plrid`),
KEY `gametype` (`gametype`,`modtype`),
KEY `clanid` (`clanid`),
KEY `skill` (`skill`),
KEY `worldid` (`worldid`),
KEY `name` (`name`)
) TYPE=MyISAM COMMENT='Registered players';
# --------------------------------------------------------

#
# Table structure for table `pstats_plr_profile`
#

CREATE TABLE `pstats_plr_profile` (
`plrprofileid` int(10) unsigned NOT NULL auto_increment,
`worldid` varchar(32) NOT NULL default '',
`name` varchar(64) NOT NULL default '',
`ipaddr` int(10) unsigned NOT NULL default '0',
`plremail` varchar(128) NOT NULL default '',
`plraim` varchar(64) NOT NULL default '',
`plricq` varchar(16) NOT NULL default '',
`plrmsn` varchar(128) NOT NULL default '',
`plrwebsite` varchar(128) NOT NULL default '',
`plricon` varchar(64) NOT NULL default '',
`plrlogo` text NOT NULL,
`username` varchar(64) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`accesslevel` tinyint(2) unsigned NOT NULL default '1',
`plrnamelocked` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`plrprofileid`),
KEY `username` (`username`),
KEY `worldid` (`worldid`),
KEY `name` (`name`),
KEY `ipaddr` (`ipaddr`)
) TYPE=MyISAM;
# --------------------------------------------------------


#
# Table structure for table `pstats_plrdata`
#
# Creation: Apr 29, 2004 at 10:35 AM
# Last update: Apr 29, 2004 at 10:35 AM
# Last check: Apr 29, 2004 at 11:22 PM
#

CREATE TABLE `pstats_plrdata` (
`plrdataid` int(10) unsigned NOT NULL auto_increment,
`plrid` int(10) unsigned NOT NULL default '0',
`statdate` date NOT NULL default '0000-00-00',
`oldskill` float(8,2) NOT NULL default '0.00',
`kills` smallint(5) unsigned NOT NULL default '0',
`deaths` smallint(5) unsigned NOT NULL default '0',
`headshots` smallint(5) unsigned NOT NULL default '0',
`ffkills` smallint(5) unsigned NOT NULL default '0',
`ffdeaths` smallint(5) unsigned NOT NULL default '0',
`killstreak` smallint(5) unsigned NOT NULL default '0',
`deathstreak` smallint(5) unsigned NOT NULL default '0',
`damage` int(10) unsigned NOT NULL default '0',
`damagetaken` int(10) unsigned NOT NULL default '0',
`shots` smallint(5) unsigned NOT NULL default '0',
`hits` smallint(5) unsigned NOT NULL default '0',
`suicides` smallint(5) unsigned NOT NULL default '0',
`games` smallint(5) unsigned NOT NULL default '0',
`rounds` smallint(5) unsigned NOT NULL default '0',
`kicked` smallint(5) unsigned NOT NULL default '0',
`banned` smallint(5) unsigned NOT NULL default '0',
`cheated` smallint(5) unsigned NOT NULL default '0',
`killskillsum` mediumint(9) NOT NULL default '0',
`deathskillsum` mediumint(9) NOT NULL default '0',
`killbonussum` smallint(6) NOT NULL default '0',
`deathbonussum` smallint(6) NOT NULL default '0',
`awardbonus` smallint(6) NOT NULL default '0',
`plrconnects` smallint(5) unsigned NOT NULL default '0',
`onlinetime` int(10) unsigned NOT NULL default '0',
`lasttime` int(10) unsigned NOT NULL default '0',
`gametype` smallint(5) unsigned NOT NULL default '0',
`modtype` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`plrdataid`),
KEY `gametype` (`gametype`,`modtype`),
KEY `plrid` (`plrid`)
) TYPE=MyISAM COMMENT='Player data (basic)' ;

#
# Table structure for table `pstats_plrdata_dod`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 23, 2004 at 02:13 AM
#

CREATE TABLE `pstats_plrdata_dod` (
`plrdataid` int(10) unsigned NOT NULL default '0',
`allieskills` smallint(5) unsigned NOT NULL default '0',
`axiskills` smallint(5) unsigned NOT NULL default '0',
`alliesdeaths` smallint(5) unsigned NOT NULL default '0',
`axisdeaths` smallint(5) unsigned NOT NULL default '0',
`joinedallies` smallint(5) unsigned NOT NULL default '0',
`joinedaxis` smallint(5) unsigned NOT NULL default '0',
`allieswon` smallint(5) unsigned NOT NULL default '0',
`axiswon` smallint(5) unsigned NOT NULL default '0',
`allieslost` smallint(5) unsigned NOT NULL default '0',
`axislost` smallint(5) unsigned NOT NULL default '0',
`tnt` smallint(5) unsigned NOT NULL default '0',
`tntused` smallint(5) unsigned NOT NULL default '0',
`alliesflagscaptured` smallint(5) unsigned NOT NULL default '0',
`alliesareascaptured` smallint(5) unsigned NOT NULL default '0',
`axisflagscaptured` smallint(5) unsigned NOT NULL default '0',
`axisareascaptured` smallint(5) unsigned NOT NULL default '0',
`flagscaptured` smallint(5) unsigned NOT NULL default '0',
`areascaptured` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`plrdataid`)
) TYPE=MyISAM COMMENT='Player data (dod)';



From these you should be able to gleen what you need!
Cheers!

[Wilson [29th ID]]

Magnificent. Cheers back.

[TooLz]

oo, let me know when you do that lol.. I was thinkin about doing something very similar aswell

Cya

[Wilson [29th ID]]

Actually I found this instead.
http://forums.alliedmods.net/showthread.php?t=40708&highlight=playerinfo