block-Advanced_Links

ibonic · New Member Joined: Aug 12, 2009 Posts: 2

This is a scrolling block that shows the weblinks, it works great in Php-nuke, but when I tried to install it in RavenNuke it doesnt work, I was hoping someone would know how to convert this to work in RavenNuke.

Code:

<?php

/************************************************************************/
/* Advanced Links Block */
/* =========================== */
/* */
/* This is basically just an edit of the original block by Francisco. */
/* Even though this is heavly edited, I think he deserves credit, so: */
/* */
/* Copyright (c) 2002 by Francisco Burzi */
/* http://phpnuke.org */
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/************************************************************************/
/* */
/* Copyright © 2002 by Michael Bacoz */
/* http://www.fatal-instinct.com */
/* */
/************************************************************************/

/************************/
/* Variables */
/************************/

$downloadstoshow = 5;
$usemarquee = 1;
$scrolldirection = "Up";

$most = "Most Hits";
$latest = "Latest Links";
$totalfiles = "Total Links";
$totalcategories = "Total Categories";
$totaldownloads = "Total Hits";
$hitstext = "Hits";

/************************/
/* End Variables */
/************************/

// Make sure people don't try and access it directly
if (eregi("block-Advanced_Links.php",$PHP_SELF)) {
Header("Location: index.php");
die();
}

global $prefix, $dbi;

// Total Files
$result = sql_query("select * from ".$prefix."_links_links", $dbi);
$files = sql_num_rows($result, $dbi);

// Total Categories
$result = sql_query("select * from ".$prefix."_links_categories", $dbi);
$cats = sql_num_rows($result, $dbi);

// Total Downloads
$result = sql_query("select hits from ".$prefix."_links_links", $dbi);

$a = 1;
while(list($hits) = sql_fetch_row($result, $dbi)) {
 $total_hits = $total_hits + $hits;
 $a++;
}

$content .= "$totalfiles: $files $totalcategories: $cats $totaldownloads: $total_hits ";

if ($usemarquee == 1) {
$content .= "<Marquee Behavior=\"Scroll\" Direction=\"$scrolldirection\" Height=\"140\" ScrollAmount=\"2\" ScrollDelay=\"100\" onMouseOver=\"this.stop()\" onMouseOut=\"this.start()\"> ";
}

// Latest added
$content .= $latest." ";
$a = 1;
$result = sql_query("select lid, title, hits from ".$prefix."_links_links order by date DESC limit 0,$downloadstoshow", $dbi);

while(list($lid, $title, $hits) = sql_fetch_row($result, $dbi)) {
 $title2 = ereg_replace("_", " ", $title);

 $content .= "<big>·</big> $a: <a href=\"viewlink-.html$lid\">$title2</a> [$hitstext: $hits] ";
 $a++;
}

// Most downloaded
$content .= " ".$most." ";
$a = 1;
$result = sql_query("select lid, title, hits from ".$prefix."_links_links order by hits DESC limit 0,$downloadstoshow", $dbi);

while(list($lid, $title, $hits) = sql_fetch_row($result, $dbi)) {
$title2 = ereg_replace("_", " ", $title);
$content .= "<big>·</big> $a: <a href=\"viewlink-.html$lid\">$title2</a> [$hitstext: $hits] ";
$a++;
}

?>

Thank you

*** Edited by Palbin to put code in code tags.

Palbin · Posted: Mon Nov 16, 2009 9:08 am

Read this topic and see if you can get the block to work. If you still need help after reading let us know.

Only registered users can see links on this board!
Get registered or login to the forums!

unicornio · Involved Joined: Aug 13, 2009 Posts: 432

Here it is my convertion. I didnt test it yet but you can do it and let me know

Code:

<?php

/************************************************************************/
/* Advanced Links Block */
/* =========================== */
/* */
/* This is basically just an edit of the original block by Francisco. */
/* Even though this is heavly edited, I think he deserves credit, so: */
/* */
/* Copyright (c) 2002 by Francisco Burzi */
/* http://phpnuke.org */
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/************************************************************************/
/* */
/* Copyright © 2002 by Michael Bacoz */
/* http://www.fatal-instinct.com */
/* */
/************************************************************************/

/************************/
/* Variables */
/************************/

$downloadstoshow = 5;
$usemarquee = 1;
$scrolldirection = "Up";

$most = "Most Hits";
$latest = "Latest Links";
$totalfiles = "Total Links";
$totalcategories = "Total Categories";
$totaldownloads = "Total Hits";
$hitstext = "Hits";

/************************/
/* End Variables */
/************************/

// Make sure people don't try and access it directly
if ( !defined('BLOCK_FILE') ) {
Header('Location: ../index.php');
die();
}

global $prefix, $db;

// Total Files
$result = $db->sql_query("select * from ".$prefix."_links_links");
$files = $db->sql_numrows($result);

// Total Categories
$result = $db->sql_query("select * from ".$prefix."_links_categories");
$cats = $db->sql_numrows($result);

// Total Downloads
$result = $db->sql_query("select hits from ".$prefix."_links_links");

$a = 1;
while(list($hits) = $db->sql_fetchrow($result)) {
$total_hits = $total_hits + $hits;
$a++;
}

$content .= "$totalfiles: $files $totalcategories: $cats $totaldownloads: $total_hits ";

if ($usemarquee == 1) {
$content .= "<Marquee Behavior=\"Scroll\" Direction=\"$scrolldirection\" Height=\"140\" ScrollAmount=\"2\" ScrollDelay=\"100\" onMouseOver=\"this.stop()\" onMouseOut=\"this.start()\"> ";
}

// Latest added
$content .= $latest." ";
$a = 1;
$result = $db->sql_query("select lid, title, hits from ".$prefix."_links_links order by date DESC limit 0,$downloadstoshow");

while(list($lid, $title, $hits) = $db->sql_fetchrow($result)) {
$title2 = ereg_replace("_", " ", $title);

$content .= "<big>·</big> $a: <a href=\"viewlink-.html$lid\">$title2</a> [$hitstext: $hits] ";
$a++;
}

// Most downloaded
$content .= " ".$most." ";
$a = 1;
$result = $db->sql_query("select lid, title, hits from ".$prefix."_links_links order by hits DESC limit 0,$downloadstoshow");

while(list($lid, $title, $hits) = $db->sql_fetchrow($result)) {
$title2 = ereg_replace("_", " ", $title);
$content .= "<big>·</big> $a: <a href=\"viewlink-.html$lid\">$title2</a> [$hitstext: $hits] ";
$a++;
}

?>

ibonic · New Member Joined: Aug 12, 2009 Posts: 2

Hi unicornio, I tried it, changed one thing and now its works heres the complete working code, thank you very much for your help:

Code:

<?php

/************************************************************************/
/* Advanced Links Block */
/* =========================== */
/* */
/* This is basically just an edit of the original block by Francisco. */
/* Even though this is heavly edited, I think he deserves credit, so: */
/* */
/* Copyright (c) 2002 by Francisco Burzi */
/* http://phpnuke.org */
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/************************************************************************/
/* */
/* Copyright © 2002 by Michael Bacoz */
/* http://www.fatal-instinct.com */
/* */
/************************************************************************/

/************************/
/* Variables */
/************************/

$downloadstoshow = 5;
$usemarquee = 1;
$scrolldirection = "Up";

$most = "Most Hits";
$latest = "Latest Links";
$totalfiles = "Total Links";
$totalcategories = "Total Categories";
$totaldownloads = "Total Hits";
$hitstext = "Hits";

/************************/
/* End Variables */
/************************/

// Make sure people don't try and access it directly
if ( !defined('BLOCK_FILE') ) {
Header('Location: ../index.php');
die();
}

global $prefix, $db;

// Total Files
$result = $db->sql_query("select * from ".$prefix."_links_links");
$files = $db->sql_numrows($result);

// Total Categories
$result = $db->sql_query("select * from ".$prefix."_links_categories");
$cats = $db->sql_numrows($result);

// Total Downloads
$result = $db->sql_query("select hits from ".$prefix."_links_links");

$a = 1;
while(list($hits) = $db->sql_fetchrow($result)) {
$total_hits = $total_hits + $hits;
$a++;
}

$content .= "$totalfiles: $files $totalcategories: $cats $totaldownloads: $total_hits ";

if ($usemarquee == 1) {
$content .= "<Marquee Behavior=\"Scroll\" Direction=\"$scrolldirection\" Height=\"140\" ScrollAmount=\"2\" ScrollDelay=\"100\" onMouseOver=\"this.stop()\" onMouseOut=\"this.start()\"> ";
}

// Latest added
$content .= $latest." ";
$a = 1;
$result = $db->sql_query("select lid, title, hits from ".$prefix."_links_links order by date DESC limit 0,$downloadstoshow");

while(list($lid, $title, $hits) = $db->sql_fetchrow($result)) {
$title2 = ereg_replace("_", " ", $title);

$content .= "<big>·</big> $a: <a href=\"viewlink-.html$lid\">$title2</a> [$hitstext: $hits] ";
$a++;
}

// Most downloaded
$content .= " ".$most." ";
$a = 1;
$result = $db->sql_query("select lid, title, hits from ".$prefix."_links_links order by hits DESC limit 0,$downloadstoshow");

while(list($lid, $title, $hits) = $db->sql_fetchrow($result)) {
$title2 = ereg_replace("_", " ", $title);
$content .= "<big>·</big> $a: <a href=\"viewlink-.html$lid\">$title2</a> [$hitstext: $hits] ";
$a++;
}

?>

unicornio · Involved Joined: Aug 13, 2009 Posts: 432

I happy you solve your problem. What did u change? Can u specify what u modified. Thanks in advance