&C.+LISTXP CommandObj=$+listxp:@pemit %#=[u(f.xp_header,%#)];@pemit %#=[u(f.xp_full_display,%#,10)];@pemit %#=[tail()]

&C.+LISTXP/ARG CommandObj=$+listxp/*:@pemit %#=[u(f.xp_header,%#)];@pemit %#=[u(f.xp_full_display,%#,%0)];@pemit %#=[tail()]

&C.+LISTXP/PLAYER CommandObj=$+listxp *:think [setq(0,pmatch(%0))];@assert or(isalt(%#,%q0),isstaff(%#))={@pemit %#=[game()] You are not  able to view that player's XP.};@assert isdbref(%q0)={@pemit %#=[game()] %0 is not a valid player.};@pemit %#=[u(f.xp_header,%q0)];;@pemit %#=[u(f.xp_full_display,%q0,10)];@pemit %#=[tail()]

&C.+LISTXP/PLAYER/ARG CommandObj=$+listxp */*:think [setq(0,pmatch(%0))];@assert or(isalt(%#,%q0),isstaff(%#))={@pemit %#=[game()] You are not able to view that player's XP.};@assert isdbref(%q0)={@pemit %#=[game()] %0 is not a valid player.};@pemit %#=[u(f.xp_header,%q0,%1)];;@pemit  %#=[u(f.xp_full_display,%q0,10)];@pemit %#=[tail()]

&R.C.+LISTXP/PLAYER CommandObj=%q0: Player DBREF of matched requirement.


&F.XP_SINGLE_DISPLAY FUNCTION: Global Commands (IMM)=[rjust(%0.,4)] [sql(u(q.mushdate,updated_on,xp_tracking,id=%0))][rjust(c1(%[[sql(u(q.single_xp_track,%0,amount))]%]),15,.)][rjust(c2(<[sql(u(q.single_xp_track,%0,total))]>),15,.)][rjust(c3(name(sql(u(q.single_xp_track,%0,changer)))),25,.)]%r[space(5)][wrap(sql(u(q.single_xp_track,%0,reason)),45,left,,,5)]

&F.XP_FULL_DISPLAY FUNCTION: Global Commands (IMM)=[list(revwords(sql(u(q.last#,%0,ifelse(strlen(%1),%1,10)))),u(f.xp_single_display,##))]

&F.XP_HEADER FUNCTION: Global Commands (IMM)=[header(+listxp for [name(%0)])]

&Q.SINGLE_XP_TRACK FUNCTION: Global Commands (IMM)=SELECT `%1` FROM xp_tracking WHERE id=%0

&Q.XP_LAST# FUNCTION: Global Commands (IMM)=SELECT id FROM xp_tracking WHERE dbref="%0" ORDER BY id DESC LIMIT %1

&F.ADDXP FUNCTION: Global Commands (IMM)=sql(u(q.add_xp,%0,%1,%2,add(%2,u(f.curr_xp,%0)),%3))

&R.F.ADDXP FUNCTION: Global Commands (IMM)=%0: DBREF, %1: Changer DBREF, %2: Amount, %4: Reason. Total is from last id's "total" in the db.

&Q.ADD_XP FUNCTION: Global Commands (IMM)=INSERT INTO xp_tracking (dbref , changer , amount , total , reason ) VALUES ( "%0", "%1", %2, %3, "%4")

&F.CURR_XP FUNCTION: Global Commands (IMM)=[sql(u(q.curr_xp,sql(u(q.last#,%0,1))))]

&Q.CURR_XP FUNCTION: Global Commands (IMM)=SELECT `total` FROM xp_tracking WHERE id=%0


Table:

xp_tracking CREATE TABLE `xp_tracking` (
  `id` int(5) unsigned NOT NULL auto_increment,
  `dbref` varchar(255) default NULL,
  `changer` varchar(255) default NULL,
  `amount` int(11) default NULL,
  `total` int(11) default NULL,
  `reason` text,
  `updated_on` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8