I have a script for my forum, Linkckecher for rapidshare, megaupload and others ..
Now I want some text in color, How can I add that to that script please?
The text I want in color is the date .. ( See screenshot )
This is the date part:
',cast(now( ) + INTERVAL 7 HOUR as char), '
This is the script:
Code: Select all
<?php
define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);
$user->session_begin();
$auth->acl($user->data);
$controle = $_GET['controleparameter'];
$filter = $_GET['filter'];
$resultaat = $_GET['resultaat'];
if ($controle=="Otpy9atn") {
$current_time = time();
$sql = "update " . POSTS_TABLE . " set linkcontrole=concat('\n <b><u><i>Linken laatst gecontroleerd op:</i></u></b> ',cast(now( ) + INTERVAL 7 HOUR as char), ' <b><u><i>Presents 4 You Linkcontrole</i></u></b> [img:', " . POSTS_TABLE . ".bbcode_uid, ']http://www.presents4you.net/images/controleplaatjes/" . $resultaat . ".gif[/img:', " . POSTS_TABLE . ".bbcode_uid, ']'), bbcode_bitfield = concat('X', right(bbcode_bitfield ,length(bbcode_bitfield)-1)) where " . POSTS_TABLE . ".post_id=(select
" . TOPICS_TABLE . ".topic_first_post_id from " . TOPICS_TABLE . " where
" . TOPICS_TABLE . ".topic_id=" . $filter . ")";
$result = $db->sql_query($sql);
$db->sql_freeresult($result);
if ($resultaat == "dood") {
$sql = "INSERT INTO " . REPORTS_TABLE . " (reason_id, post_id, user_id, user_notify, report_closed, report_time , report_text)
VALUES (1, (select " . TOPICS_TABLE . ".topic_first_post_id from " . TOPICS_TABLE . " where " . TOPICS_TABLE . ".topic_id=" . $filter . "), 2, 0, 0, " . $current_time . ", 'Presents4You Automatische linkcontrole')";
$result = $db->sql_query($sql);
$db->sql_freeresult($result);
$sql = "UPDATE " . POSTS_TABLE . " set post_reported = 1 WHERE post_id = (select " . TOPICS_TABLE . ".topic_first_post_id from " . TOPICS_TABLE . " where " . TOPICS_TABLE . ".topic_id=" . $filter . ")";
$result = $db->sql_query($sql);
$db->sql_freeresult($result);
$sql = "UPDATE " . TOPICS_TABLE . " SET topic_reported = 1 WHERE (topic_id = " . $filter . ") or (topic_moved_id = " . $filter . ")";
$result = $db->sql_query($sql);
$db->sql_freeresult($result);
}
}
?>