TP and phpraider block

[purrfektphlaw]

Below is the code I copied off of this site with only the minor modifications to the url and switched raid_leader/start_time.  I have just enough knowledge of php to make minor modifications, but that is really all, if you can point me in the right direction it would be much appreciated.

I am using:
TP 0.9.8
SMF 1.1.3
phpRaider 1.0.2
Linux server
MySQL 5.0

I have scoured the phpRaider forums, but they only appear to have the MKPortal code.  As of yet I have not been able to get this code to work properly.  I have also reviewed all the information in this board and did not seem to find anything that would help me to correct the problem I am having.

I recieve the message "Sorry !! You cannot access this file directly."

My phpraider_ is located in the same database as my smf_.

Code Select Expand


$rootlink = "http://www.vae-victis-guild.com/phpraider/index.php?option=com_view&id";

function newDate( $format, $timestamp, $tz ) {
$offset = (60 * 60) * ($tz / 100); // Seconds from GMT
    $timestamp = $timestamp + $offset;
    return gmdate( $format, $timestamp );
}

if (!defined("IN_MKP")) {
    die ("Sorry !! You cannot access this file directly.");
}
$content = "";
$pConfig_timezone = -500;
$offset = (60 * 60) * ($pConfig_timezone/100);
$time_buffer = (60 * 60) * 2; 
$rightnow = time() + $offset;
$future = $rightnow - $time_buffer;

global $db_prefix,$scripturl,$txt,$settings,$modSettings, $sourcedir;


$DB->query("SELECT raid_id, location, raid_leader, start_time FROM phpraider_raid WHERE start_time > ".$future." ORDER BY start_time ASC ", __FILE__, __LINE__);

$sep = ",";
$totalraids = $DB->get_num_rows();


while ($raids = $DB->fetch_row()) {
$year = newDate( "Y", $raids['start_time'], $pConfig_timezone);
$month = newDate( "m", $raids['start_time'], $pConfig_timezone );
$day = newDate( "d", $raids['start_time'], $pConfig_timezone );
$today_month = newDate( "m", time(), $pConfig_timezone );
$today_day = newDate( "d", time(), $pConfig_timezone );
$today = "";
$timedone = $raids['start_time'] + $time_buffer;
$hour = gmdate( "H", $raids['start_time'] );
$suffix="";
if($hour > 12){
$hour = $hour - 12;
$suffix = "pm";
}else {
$suffix = "am";
}
$mins = gmdate( "i", $raids['start_time'] );
$hour2 = gmdate( "H:i", $rightnow );
$hour3 = gmdate( "H:i", $timedone );
//echo "{$hour} {$hour2} {$hour3} -";
if( $today_month == $month && $today_day == $day &&
    $raids['start_time'] < $rightnow && $rightnow < $timedone) {
$today = "<span style='color:blue'><blink>(IN PROGRESS)</blink></span>";
} elseif( $today_month == $month && $today_day == $day ) {
$today = "<span style='color:green'><blink>(TODAY)</blink></span>";
}
$link ="<span style='color:yellow'> {$month}/{$day} - <a class=\"sg\" href=\"$rootlink={$raids['raid_id']}\">{$hour}:{$mins}{$suffix}(CST): {$raids['location']}</a>{$today}</span><br>";

    $activeu .= $link." ";
}
if ( $totalraids ==  0){
$activeu = "No upcoming raids.";
}
$activeu = substr($activeu, 0, (strlen($activeu) -2));
$content = "
<tr>
  <td width=\"100%\">
    <table border=\"0\" width=\"100%\" cellpadding=\"1\" cellspacing=\"1\">
      <tr>
<td class=\"tdblock\">
<span class=\"mktxtcontr\">$totalraids</span> <b>Raid(s)</b>
</td>
      </tr>
      <tr>
<td class=\"tdglobal\">
$activeu
</td>
      </tr>
    </table>
  </td>
</tr>
<tr>
  <td class=\"tdblock\">
  <a class=\"uno\" href=\"http://www.vae-victis-guild.com/phpraider/index.php\">Raid Calendar</a>
  </td>
</tr>           
      ";


unset($totalraids);
unset($rootlink);
unset($rightnow);


[Thurnok]

Try changing this:

Code Select Expand


if (!defined("IN_MKP")) {
    die ("Sorry !! You cannot access this file directly.");
}


to this:

Code Select Expand


if (!defined("SMF")) {
    die ("Sorry !! You cannot access this file directly.");
}


[Omniverse]

Ok, I am trying this as well.

I put the code exampled here into a php block, I can't get it to work however.

I get the following error:

Fatal error: Call to a member function query() on a non-object

Code used, any ideas?

Code Select Expand



$rootlink = "http://ksguild.org/phpraider/wow/index.php?option=com_view&id";

function newDate( $format, $timestamp, $tz ) {
$offset = (60 * 60) * ($tz / 100); // Seconds from GMT
    $timestamp = $timestamp + $offset;
    return gmdate( $format, $timestamp );
}

if (!defined("SMF")) {
    die ("Sorry !! You cannot access this file directly.");
}
$content = "";
$pConfig_timezone = -500;
$offset = (60 * 60) * ($pConfig_timezone/100);
$time_buffer = (60 * 60) * 2; 
$rightnow = time() + $offset;
$future = $rightnow - $time_buffer;

global $db_prefix, $scripturl, $txt,$settings,$modSettings, $sourcedir;


$DB->query("SELECT raid_id, location, start_time, raid_leader FROM Wphpraider_raid WHERE start_time > ".$future." ORDER BY start_time ASC ", __FILE__, __LINE__);

$sep = ",";
$totalraids = $DB->get_num_rows();


while ($raids = $DB->fetch_row()) {
$year = newDate( "Y", $raids['start_time'], $pConfig_timezone);
$month = newDate( "m", $raids['start_time'], $pConfig_timezone );
$day = newDate( "d", $raids['start_time'], $pConfig_timezone );
$today_month = newDate( "m", time(), $pConfig_timezone );
$today_day = newDate( "d", time(), $pConfig_timezone );
$today = "";
$timedone = $raids['start_time'] + $time_buffer;
$hour = gmdate( "H", $raids['start_time'] );
$suffix="";
if($hour > 12){
$hour = $hour - 12;
$suffix = "pm";
}else {
$suffix = "am";
}
$mins = gmdate( "i", $raids['start_time'] );
$hour2 = gmdate( "H:i", $rightnow );
$hour3 = gmdate( "H:i", $timedone );
//echo "{$hour} {$hour2} {$hour3} -";
if( $today_month == $month && $today_day == $day &&
    $raids['start_time'] < $rightnow && $rightnow < $timedone) {
$today = "     <span style='color:blue'><blink>(IN PROGRESS)</blink></span>";
} elseif( $today_month == $month && $today_day == $day ) {
$today = "     <span style='color:green'><blink>(TODAY)</blink></span>";
}
$link ="<span style='color:yellow'> {$month}/{$day} - <a class=\"sg\" href=\"$rootlink={$raids['raid_id']}\">{$hour}:{$mins}{$suffix}(CST): {$raids['location']}</a>{$today}</span><br>";

    $activeu .= $link." ";
}
if ( $totalraids ==  0){
$activeu = "No upcoming raids.   ";
}
$activeu = substr($activeu, 0, (strlen($activeu) -2));
$content = "
<tr>
  <td width=\"100%\">
    <table border=\"0\" width=\"100%\" cellpadding=\"1\" cellspacing=\"1\">
      <tr>
<td class=\"tdblock\">
<span class=\"mktxtcontr\">$totalraids</span> <b>Raid(s)</b>
</td>
      </tr>
      <tr>
<td class=\"tdglobal\">
$activeu
</td>
      </tr>
    </table>
  </td>
</tr>
<tr>
  <td class=\"tdblock\">
  <img src=\"$this->images/atb_chat.gif\" style=\"vertical-align: middle;\" alt=\"\" />&nbsp;<a class=\"uno\" href=\"http://ksguild.org/phpraider/wow/index.php\">Raid Calendar</a>
  </td>
</tr>           
      ";


unset($totalraids);
unset($rootlink);
unset($rightnow);




Found this bit.. got it to work kinda... has issues with being centered in the block, also has an issue with the database.

Code Select Expand



$rootlink = "http://ksguild.org/phpraider/wow/index.php?option=com_view&id";

function raidernewDate( $format, $timestamp, $tz ) {
$offset = (60 * 60) * ($tz / 100); // Seconds from GMT
    $timestamp = $timestamp + $offset;
    return gmdate( $format, $timestamp );
}

$content = "";
$pConfig_timezone = -400;
$offset = (60 * 60) * ($pConfig_timezone/100);
$time_buffer = (60 * 60) * 2; 
$rightnow = time() + $offset;
$future = $rightnow - $time_buffer;

global $db_prefix, $scripturl, $txt,$settings,$modSettings, $sourcedir;


$query = db_query("SELECT raid_id, location, start_time, raid_leader FROM Wphpraider_raid WHERE start_time > ".$future." ORDER BY start_time ASC",  __FILE__, __LINE__);

$sep = ",";
$totalraids = 0;


while ($raids = mysql_fetch_assoc($query)) {
$year = raidernewDate( "Y", $raids['start_time'], $pConfig_timezone);
$month = raidernewDate( "m", $raids['start_time'], $pConfig_timezone );
$day = raidernewDate( "d", $raids['start_time'], $pConfig_timezone );
$today_month = raidernewDate( "m", time(), $pConfig_timezone );
$today_day = raidernewDate( "d", time(), $pConfig_timezone );
$today = "";
$timedone = $raids['start_time'] + $time_buffer;
$hour = gmdate( "H", $raids['start_time'] );
$suffix="";
if($hour > 12){
$hour = $hour - 12;
$suffix = "pm";
}else {
$suffix = "am";
}
$mins = gmdate( "i", $raids['start_time'] );
$hour2 = gmdate( "H:i", $rightnow );
$hour3 = gmdate( "H:i", $timedone );
//echo "{$hour} {$hour2} {$hour3} -";
if( $today_month == $month && $today_day == $day &&
    $raids['start_time'] < $rightnow && $rightnow < $timedone) {
$today = "     <span style='color:blue'><blink>(IN PROGRESS)</blink></span>";
} elseif( $today_month == $month && $today_day == $day ) {
$today = "     <span style='color:green'><blink>(TODAY)</blink></span>";
}
$link ="<span style='color:yellow; font-size: 12px;'> {$month}/{$day} - <a class=\"sg\" href=\"$rootlink={$raids['raid_id']}\">{$hour}:{$mins}{$suffix}(EST): {$raids['location']}</a>{$today}</span><br>
";

    $activeu .= $link." ";
$totalraids = $totalraids + 1;
}
if ( $totalraids ==  0){
$activeu = "No upcoming raids.   ";
}
$activeu = substr($activeu, 0, (strlen($activeu) -2));
$myhtml = "<table border=\"0\" width=\"100%\" cellpadding=\"1\" cellspacing=\"1\">
<tr>
  <td width=\"100%\">
    <table border=\"0\" width=\"100%\" cellpadding=\"1\" cellspacing=\"1\">
      <tr>
<td class=\"tdblock\">

</td>
      </tr>
      <tr>
<td class=\"tdglobal\">
$activeu
</td>
      </tr>
    </table>
  </td>
</tr>
<tr>
  <td class=\"tdblock\">

  </td>
</tr>
</table>
      ";

echo itemstats_parse($myhtml);
unset($totalraids);
unset($rootlink);
unset($rightnow);



This line here causes an error for a duplicarte entry... sometimes. If I remove it, it stops working though.

Code Select Expand


echo itemstats_parse($myhtml);


[purrfektphlaw]

Try changing this:

Code Select Expand


if (!defined("IN_MKP")) {
    die ("Sorry !! You cannot access this file directly.");
}


to this:

Code Select Expand


if (!defined("SMF")) {
    die ("Sorry !! You cannot access this file directly.");
}


I tried that and still recieved the same error message.  I also tried this code:

Code Select Expand


$rootlink = "http://vae-victis-guild.com/phpraider/index.php?option=com_view&id";

function raidernewDate( $format, $timestamp, $tz ) {
$offset = (60 * 60) * ($tz / 100); // Seconds from GMT
    $timestamp = $timestamp + $offset;
    return gmdate( $format, $timestamp );
}

$content = "";
$pConfig_timezone = -400;
$offset = (60 * 60) * ($pConfig_timezone/100);
$time_buffer = (60 * 60) * 2; 
$rightnow = time() + $offset;
$future = $rightnow - $time_buffer;

global $db_prefix, $scripturl, $txt,$settings,$modSettings, $sourcedir;


$query = db_query("SELECT raid_id, location, start_time, raid_leader FROM Wphpraider_raid WHERE start_time > ".$future." ORDER BY start_time ASC",  __FILE__, __LINE__);

$sep = ",";
$totalraids = 0;


while ($raids = mysql_fetch_assoc($query)) {
$year = raidernewDate( "Y", $raids['start_time'], $pConfig_timezone);
$month = raidernewDate( "m", $raids['start_time'], $pConfig_timezone );
$day = raidernewDate( "d", $raids['start_time'], $pConfig_timezone );
$today_month = raidernewDate( "m", time(), $pConfig_timezone );
$today_day = raidernewDate( "d", time(), $pConfig_timezone );
$today = "";
$timedone = $raids['start_time'] + $time_buffer;
$hour = gmdate( "H", $raids['start_time'] );
$suffix="";
if($hour > 12){
$hour = $hour - 12;
$suffix = "pm";
}else {
$suffix = "am";
}
$mins = gmdate( "i", $raids['start_time'] );
$hour2 = gmdate( "H:i", $rightnow );
$hour3 = gmdate( "H:i", $timedone );
//echo "{$hour} {$hour2} {$hour3} -";
if( $today_month == $month && $today_day == $day &&
    $raids['start_time'] < $rightnow && $rightnow < $timedone) {
$today = "     <span style='color:blue'><blink>(IN PROGRESS)</blink></span>";
} elseif( $today_month == $month && $today_day == $day ) {
$today = "     <span style='color:green'><blink>(TODAY)</blink></span>";
}
$link ="<span style='color:yellow; font-size: 12px;'> {$month}/{$day} - <a class=\"sg\" href=\"$rootlink={$raids['raid_id']}\">{$hour}:{$mins}{$suffix}(EST): {$raids['location']}</a>{$today}</span><br>
";

    $activeu .= $link." ";
$totalraids = $totalraids + 1;
}
if ( $totalraids ==  0){
$activeu = "No upcoming raids.   ";
}
$activeu = substr($activeu, 0, (strlen($activeu) -2));
$myhtml = "<table border=\"0\" width=\"100%\" cellpadding=\"1\" cellspacing=\"1\">
<tr>
  <td width=\"100%\">
    <table border=\"0\" width=\"100%\" cellpadding=\"1\" cellspacing=\"1\">
      <tr>
<td class=\"tdblock\">

</td>
      </tr>
      <tr>
<td class=\"tdglobal\">
$activeu
</td>
      </tr>
    </table>
  </td>
</tr>
<tr>
  <td class=\"tdblock\">

  </td>
</tr>
</table>
      ";

echo itemstats_parse($myhtml);
unset($totalraids);
unset($rootlink);
unset($rightnow);


but I recieve this message:

Fatal error: Cannot redeclare raidernewdate() (previously declared in /home/content/n/v/a/nvanwyck/html/Sources/Load.php(1735) : eval()'d code(35) : eval()'d code:3) in /home/content/n/v/a/nvanwyck/html/Sources/Load.php(1735) : eval()'d code(35) : eval()'d code on line 3


not to sure where else to go, the phpraider site has pretty much the same coding and i've used all the info I could from there.

Thanks!

[Omniverse]

For the code I posted, ya need to change one other bit.

Code Select Expand



$query = db_query("SELECT raid_id, location, start_time, raid_leader FROM Wphpraider_raid WHERE start_time > ".$future." ORDER BY start_time ASC",  __FILE__, __LINE__);



In there ya need to change the Wphpraider_raid to your mysql prefix, prolly just without the W. I use multiple ones for different games, so I change the prefix.

[Phinhead54]

Try changing this:

Code Select Expand


if (!defined("IN_MKP")) {
    die ("Sorry !! You cannot access this file directly.");
}


to this:

Code Select Expand


if (!defined("SMF")) {
    die ("Sorry !! You cannot access this file directly.");
}


I tried that and still recieved the same error message.  I also tried this code:

Code Select Expand


$rootlink = "http://vae-victis-guild.com/phpraider/index.php?option=com_view&id";

function raidernewDate( $format, $timestamp, $tz ) {
$offset = (60 * 60) * ($tz / 100); // Seconds from GMT
    $timestamp = $timestamp + $offset;
    return gmdate( $format, $timestamp );
}

$content = "";
$pConfig_timezone = -400;
$offset = (60 * 60) * ($pConfig_timezone/100);
$time_buffer = (60 * 60) * 2; 
$rightnow = time() + $offset;
$future = $rightnow - $time_buffer;

global $db_prefix, $scripturl, $txt,$settings,$modSettings, $sourcedir;


$query = db_query("SELECT raid_id, location, start_time, raid_leader FROM Wphpraider_raid WHERE start_time > ".$future." ORDER BY start_time ASC",  __FILE__, __LINE__);

$sep = ",";
$totalraids = 0;


while ($raids = mysql_fetch_assoc($query)) {
$year = raidernewDate( "Y", $raids['start_time'], $pConfig_timezone);
$month = raidernewDate( "m", $raids['start_time'], $pConfig_timezone );
$day = raidernewDate( "d", $raids['start_time'], $pConfig_timezone );
$today_month = raidernewDate( "m", time(), $pConfig_timezone );
$today_day = raidernewDate( "d", time(), $pConfig_timezone );
$today = "";
$timedone = $raids['start_time'] + $time_buffer;
$hour = gmdate( "H", $raids['start_time'] );
$suffix="";
if($hour > 12){
$hour = $hour - 12;
$suffix = "pm";
}else {
$suffix = "am";
}
$mins = gmdate( "i", $raids['start_time'] );
$hour2 = gmdate( "H:i", $rightnow );
$hour3 = gmdate( "H:i", $timedone );
//echo "{$hour} {$hour2} {$hour3} -";
if( $today_month == $month && $today_day == $day &&
    $raids['start_time'] < $rightnow && $rightnow < $timedone) {
$today = "     <span style='color:blue'><blink>(IN PROGRESS)</blink></span>";
} elseif( $today_month == $month && $today_day == $day ) {
$today = "     <span style='color:green'><blink>(TODAY)</blink></span>";
}
$link ="<span style='color:yellow; font-size: 12px;'> {$month}/{$day} - <a class=\"sg\" href=\"$rootlink={$raids['raid_id']}\">{$hour}:{$mins}{$suffix}(EST): {$raids['location']}</a>{$today}</span><br>
";

   $activeu .= $link." ";
$totalraids = $totalraids + 1;
}
if ( $totalraids ==  0){
$activeu = "No upcoming raids.   ";
}
$activeu = substr($activeu, 0, (strlen($activeu) -2));
$myhtml = "<table border=\"0\" width=\"100%\" cellpadding=\"1\" cellspacing=\"1\">
<tr>
  <td width=\"100%\">
    <table border=\"0\" width=\"100%\" cellpadding=\"1\" cellspacing=\"1\">
      <tr>
<td class=\"tdblock\">

</td>
      </tr>
      <tr>
<td class=\"tdglobal\">
$activeu
</td>
      </tr>
    </table>
  </td>
</tr>
<tr>
  <td class=\"tdblock\">

  </td>
</tr>
</table>
     ";

echo itemstats_parse($myhtml);
unset($totalraids);
unset($rootlink);
unset($rightnow);


but I recieve this message:

Fatal error: Cannot redeclare raidernewdate() (previously declared in /home/content/n/v/a/nvanwyck/html/Sources/Load.php(1735) : eval()'d code(35) : eval()'d code:3) in /home/content/n/v/a/nvanwyck/html/Sources/Load.php(1735) : eval()'d code(35) : eval()'d code on line 3


not to sure where else to go, the phpraider site has pretty much the same coding and i've used all the info I could from there.

Thanks!

I'm getting the same error here, can't for the life of me figure it out.  I'd love to get this working though.

[Omniverse]

Ok, here is one I got working, found from spiffy's site.

Code Select Expand



$rootlink = "your link to phpraider/index.php?option=com_view&id";

function raidernewDate( $format, $timestamp, $tz ) {
$offset = (60 * 60) * ($tz / 100); // Seconds from GMT
    $timestamp = $timestamp + $offset;
    return gmdate( $format, $timestamp );
}

$maxraids = 5;
$content = "";
$pConfig_timezone = -800;
$offset = (60 * 60) * ($pConfig_timezone/100);
$time_buffer = (60 * 60) * 2;
$rightnow = time() + $offset;
$future = $rightnow - $time_buffer;

global $db_prefix, $scripturl, $txt,$settings,$modSettings, $sourcedir;

        $result = mysql_query("SELECT raid_id, location, start_time, raid_leader  FROM phpraider_raid WHERE start_time > ".$future." ORDER BY start_time ASC");
$sep = ",";
$totalraids = 0;


while ($raids = mysql_fetch_assoc($result)) {

$year = raidernewDate( "Y", $raids['start_time'], $pConfig_timezone);
$month = raidernewDate( "m", $raids['start_time'], $pConfig_timezone );
$day = raidernewDate( "d", $raids['start_time'], $pConfig_timezone );
$today_month = raidernewDate( "m", time(), $pConfig_timezone );
$today_day = raidernewDate( "d", time(), $pConfig_timezone );

if($totalraids >= $maxraids) continue;
$today = "";
$timedone = $raids['start_time'] + $time_buffer;
$hour = gmdate( "H", $raids['start_time'] );
$suffix="";
if($hour > 12){
$hour = $hour - 12;
$suffix = "pm";
}else {
$suffix = "am";
}
$mins = gmdate( "i", $raids['start_time'] );
$hour2 = gmdate( "H:i", $rightnow );
$hour3 = gmdate( "H:i", $timedone );
//echo "{$hour} {$hour2} {$hour3} -";
if( $today_month == $month && $today_day == $day &&
    $raids['start_time'] < $rightnow && $rightnow < $timedone) {
$today = "     <span style='color:blue'>(IN PROGRESS)</span>";
} elseif( $today_month == $month && $today_day == $day ) {
$today = "     <span style='color:green'><blink>(TODAY)</blink></span>";
}
$link ="<span style='color:red'> {$month}/{$day} - <a href=\"$rootlink={$raids['raid_id']}\">{$hour}:{$mins}{$suffix}(PST): {$raids['location']}</a>{$today}</span><br>";

    $activeu .= $link." ";
$totalraids = $totalraids + 1;
}
if ( $totalraids ==  0){
$activeu = "No upcoming events.   ";
}
$activeu = substr($activeu, 0, (strlen($activeu) -2));
$myhtml = "<table border=\"0\" width=\"100%\" cellpadding=\"1\" cellspacing=\"1\">
<tr>
  <td width=\"100%\">
    <table border=\"0\" width=\"100%\" cellpadding=\"1\" cellspacing=\"1\">
      <tr>
<td class=\"tdblock\">
<span class=\"mktxtcontr\">$totalraids</span> <b>Event(s)</b>
</td>
      </tr>
      <tr>
<td class=\"tdglobal\">
$activeu
</td>
      </tr>
    </table>
  </td>
</tr>
<tr>
  <td class=\"tdblock\">
  <img src=\"http://your link to phpraider/templates/default/images/icons/icon_signed_up.png\" style=\"vertical-align: middle;\" alt=\"\" /> <a class=\"uno\" href=\"your link to phpraider\">Event Calendar</a>
  </td>
</tr>
</table>
      ";

echo $myhtml;
unset($totalraids);
unset($rootlink);
unset($rightnow);





Remember to edit the URL's.

[Phinhead54]

Looks great, the code doesn't error, I'm just trying to get it to pull the info from a database different then the smf database ... any ideas?  I've done it before, just trying to remember how to do it again

[Hakker]

Looks great, the code doesn't error, I'm just trying to get it to pull the info from a database different then the smf database ... any ideas?  I've done it before, just trying to remember how to do it again

I got the same problem I have phpraider stored in a different database so it doesn't really work then

[microbone]

Some of you guys know how to make it look like the one on this site:
here (right panel)

it simply looks nice