[PP] ShoutBox /time command mod

[Mr Macro]

I wrote a little command mod for the staff shout box, you type /time and it shows you the time! WOW!

Download link:

Show Hide

http://www.uploadz.co.uk/441powerpan...ox-timemod.zip

To install just upload sendshout.php to shoutbox directory.

You then need to alter the 'shoutbox' MySQL table.Go into PHPMyAdmin and run this query:

REATE TABLE `shoutbox` (
  `id` int(255) NOT NULL auto_increment,
  `username` varchar(500) collate latin1_general_ci NOT NULL,
  `message` longtext collate latin1_general_ci NOT NULL,
  `ip` varchar(500) collate latin1_general_ci NOT NULL,
  `time1` varchar(500) collate latin1_general_ci NOT NULL,
  `time2` varchar(500) collate latin1_general_ci NOT NULL,
  `time3` varchar(500) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;

I put a back up of sendshout in there too incase the mod doesn't work.

Enjoy.

[ScottDiamond]

Hey!

Well done on making your first Mod for PowerPanel. +Rep for helping people out and I'm sure it will be appreciated and hope to see more from you.

[Dentafrice,]

ill make a ppmod of this

[ScottDiamond]

ill make a ppmod of this

This is a PPMod?

[Mr Macro]

Ok, download fixed.

[Dentafrice,]

not yet ill make one

[ScottDiamond]

not yet ill make one

I'm a bit confused. This guy's made an add-on for PowerPanel, and you say it's not a PPMod? :S

[Mr Macro]

He means its not a .ppmod file to add to the auto-update system.

[ScottDiamond]

He means its not a .ppmod file to add to the auto-update system.

Ah, I get you now. Thanks.

[Drompo]

Thats the bloody long way round
In shoutbox/sendshout.php
After This

if($message == "/prune" && $_SESSION['level'] == "admin") {
## PRUNE
$del = mysql_query("TRUNCATE TABLE shoutbox");
$insert = mysql_query("INSERT INTO shoutbox (`username`, `message`, `ip`) VALUES ('$_SESSION[username]', 'Shoutbox Pruned!', '$ip')") or die('Could not insert data! '.mysql_error());
## /PRUNE
} 

Add

elseif($message == "/time") {
## Time
$time = date("H:m s");
$insert = mysql_query("INSERT INTO shoutbox (`username`, `message`, `ip`) VALUES ('$_SESSION[username]', 'The Time is $time', '$ip')") or die('Could not insert data! '.mysql_error());
## /Time
} 

That works Fine