Psychostats Reference? - DoD Plugins Archive

Archive › Old Forum Threads › Help › Scripting Help › Psychostats Reference?

6 posts, 3 people · 819 views Thread Rating: ★★★★★

closedPsychostats Reference?
Started by Wilson [29th ID] on 09-04-2006, 05:37 AM

Wilson [29th ID]

started this thread

Posts: 623
Threads: 57
Joined: Oct 2005

09-04-2006, 05:37 AM #1

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.rnrnJust wondering if anyone knows off the top of your head.

Zor

posted here

Posts: 688
Threads: 75
Joined: Jun 2006

09-04-2006, 11:51 AM #2

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

Zor

posted here

Posts: 688
Threads: 75
Joined: Jun 2006

09-04-2006, 12:05 PM #3

Ok so here are the tables your looking for:nn

#n# Table structure for table `pstats_plrids`n#n# Creation: Apr 23, 2004 at 02:13 AMn# Last update: Apr 27, 2004 at 12:13 PMn#nnCREATE TABLE `pstats_plrids` (n  `plrid` int(10) unsigned NOT NULL auto_increment,n  `name` varchar(64) NOT NULL default '',n  `worldid` varchar(32) NOT NULL default '',n  `ipaddr` int(10) unsigned NOT NULL default '0',n  `totaluses` mediumint(8) unsigned NOT NULL default '1',n  `gametype` smallint(5) unsigned NOT NULL default '0',n  `modtype` smallint(5) unsigned NOT NULL default '0',n  PRIMARY KEY  (`plrid`),n  KEY `name` (`name`),n  KEY `worldid` (`worldid`),n  KEY `ipaddr` (`ipaddr`)n) TYPE=MyISAM COMMENT='Unique player ID''s' ;nn#n# Table structure for table `pstats_plr`n#n# Creation: Apr 29, 2004 at 10:40 AMn# Last update: May 06, 2004 at 11:16 AMn# Last check: May 06, 2004 at 11:16 AMn#nnCREATE TABLE `pstats_plr` (n  `plrid` int(10) unsigned NOT NULL default '0',n  `srvid` smallint(5) unsigned NOT NULL default '0',n  `clanid` int(10) unsigned NOT NULL default '0',n  `plrlastdate` date NOT NULL default '0000-00-00',n  `rank` mediumint(8) unsigned NOT NULL default '0',n  `oldrank` mediumint(8) unsigned NOT NULL default '0',n  `skill` float(8,2) NOT NULL default '0.00',n  `prevskill` float(8,2) NOT NULL default '0.00',n  `name` varchar(64) NOT NULL default '',n  `worldid` varchar(32) NOT NULL default '',n  `ipaddr` int(10) unsigned NOT NULL default '0',n  `allowrank` tinyint(1) unsigned NOT NULL default '1',n  `gametype` smallint(5) unsigned NOT NULL default '0',n  `modtype` smallint(5) unsigned NOT NULL default '0',n  PRIMARY KEY  (`plrid`),n  KEY `gametype` (`gametype`,`modtype`),n  KEY `clanid` (`clanid`),n  KEY `skill` (`skill`),n  KEY `worldid` (`worldid`),n  KEY `name` (`name`)n) TYPE=MyISAM COMMENT='Registered players';n# --------------------------------------------------------nn# n# Table structure for table `pstats_plr_profile`n# nnCREATE TABLE `pstats_plr_profile` (n  `plrprofileid` int(10) unsigned NOT NULL auto_increment,n  `worldid` varchar(32) NOT NULL default '',n  `name` varchar(64) NOT NULL default '',n  `ipaddr` int(10) unsigned NOT NULL default '0',n  `plremail` varchar(128) NOT NULL default '',n  `plraim` varchar(64) NOT NULL default '',n  `plricq` varchar(16) NOT NULL default '',n  `plrmsn` varchar(128) NOT NULL default '',n  `plrwebsite` varchar(128) NOT NULL default '',n  `plricon` varchar(64) NOT NULL default '',n  `plrlogo` text NOT NULL,n  `username` varchar(64) NOT NULL default '',n  `password` varchar(32) NOT NULL default '',n  `accesslevel` tinyint(2) unsigned NOT NULL default '1',n  `plrnamelocked` tinyint(1) unsigned NOT NULL default '0',n  PRIMARY KEY  (`plrprofileid`),n  KEY `username` (`username`),n  KEY `worldid` (`worldid`),n  KEY `name` (`name`),n  KEY `ipaddr` (`ipaddr`)n) TYPE=MyISAM;n# --------------------------------------------------------nnn#n# Table structure for table `pstats_plrdata`n#n# Creation: Apr 29, 2004 at 10:35 AMn# Last update: Apr 29, 2004 at 10:35 AMn# Last check: Apr 29, 2004 at 11:22 PMn#nnCREATE TABLE `pstats_plrdata` (n  `plrdataid` int(10) unsigned NOT NULL auto_increment,n  `plrid` int(10) unsigned NOT NULL default '0',n  `statdate` date NOT NULL default '0000-00-00',n  `oldskill` float(8,2) NOT NULL default '0.00',n  `kills` smallint(5) unsigned NOT NULL default '0',n  `deaths` smallint(5) unsigned NOT NULL default '0',n  `headshots` smallint(5) unsigned NOT NULL default '0',n  `ffkills` smallint(5) unsigned NOT NULL default '0',n  `ffdeaths` smallint(5) unsigned NOT NULL default '0',n  `killstreak` smallint(5) unsigned NOT NULL default '0',n  `deathstreak` smallint(5) unsigned NOT NULL default '0',n  `damage` int(10) unsigned NOT NULL default '0',n  `damagetaken` int(10) unsigned NOT NULL default '0',n  `shots` smallint(5) unsigned NOT NULL default '0',n  `hits` smallint(5) unsigned NOT NULL default '0',n  `suicides` smallint(5) unsigned NOT NULL default '0',n  `games` smallint(5) unsigned NOT NULL default '0',n  `rounds` smallint(5) unsigned NOT NULL default '0',n  `kicked` smallint(5) unsigned NOT NULL default '0',n  `banned` smallint(5) unsigned NOT NULL default '0',n  `cheated` smallint(5) unsigned NOT NULL default '0',n  `killskillsum` mediumint(9) NOT NULL default '0',n  `deathskillsum` mediumint(9) NOT NULL default '0',n  `killbonussum` smallint(6) NOT NULL default '0',n  `deathbonussum` smallint(6) NOT NULL default '0',n  `awardbonus` smallint(6) NOT NULL default '0',n  `plrconnects` smallint(5) unsigned NOT NULL default '0',n  `onlinetime` int(10) unsigned NOT NULL default '0',n  `lasttime` int(10) unsigned NOT NULL default '0',n  `gametype` smallint(5) unsigned NOT NULL default '0',n  `modtype` smallint(5) unsigned NOT NULL default '0',n  PRIMARY KEY  (`plrdataid`),n  KEY `gametype` (`gametype`,`modtype`),n  KEY `plrid` (`plrid`)n) TYPE=MyISAM COMMENT='Player data (basic)' ;nn#n# Table structure for table `pstats_plrdata_dod`n#n# Creation: Apr 23, 2004 at 02:13 AMn# Last update: Apr 23, 2004 at 02:13 AMn#nnCREATE TABLE `pstats_plrdata_dod` (n  `plrdataid` int(10) unsigned NOT NULL default '0',n  `allieskills` smallint(5) unsigned NOT NULL default '0',n  `axiskills` smallint(5) unsigned NOT NULL default '0',n  `alliesdeaths` smallint(5) unsigned NOT NULL default '0',n  `axisdeaths` smallint(5) unsigned NOT NULL default '0',n  `joinedallies` smallint(5) unsigned NOT NULL default '0',n  `joinedaxis` smallint(5) unsigned NOT NULL default '0',n  `allieswon` smallint(5) unsigned NOT NULL default '0',n  `axiswon` smallint(5) unsigned NOT NULL default '0',n  `allieslost` smallint(5) unsigned NOT NULL default '0',n  `axislost` smallint(5) unsigned NOT NULL default '0',n  `tnt` smallint(5) unsigned NOT NULL default '0',n  `tntused` smallint(5) unsigned NOT NULL default '0',n  `alliesflagscaptured` smallint(5) unsigned NOT NULL default '0',n  `alliesareascaptured` smallint(5) unsigned NOT NULL default '0',n  `axisflagscaptured` smallint(5) unsigned NOT NULL default '0',n  `axisareascaptured` smallint(5) unsigned NOT NULL default '0',n  `flagscaptured` smallint(5) unsigned NOT NULL default '0',n  `areascaptured` smallint(5) unsigned NOT NULL default '0',n  PRIMARY KEY  (`plrdataid`)n) TYPE=MyISAM COMMENT='Player data (dod)';nn

nnFrom these you should be able to gleen what you need!nCheers!

Wilson [29th ID]

started this thread

Posts: 623
Threads: 57
Joined: Oct 2005

09-04-2006, 03:28 PM #4

Magnificent. Cheers back.

T TooLz

posted here

Posts: 96
Threads: 11
Joined: Oct 2005

09-28-2006, 05:00 PM #5

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

Wilson [29th ID]

started this thread

Posts: 623
Threads: 57
Joined: Oct 2005

09-28-2006, 06:58 PM #6

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

Archive › Old Forum Threads › Help › Scripting Help › Psychostats Reference?