11
mjoel
Re: Random links
  • 2007/12/8 3:43

  • mjoel

  • Quite a regular

  • Posts: 325

  • Since: 2006/12/9


topic bump..i got this working...!!

in macdonald previous post ...update the mylinks_top.php
with this

<?php
// $Id: mylinks_top.php,v 1.11 2004/12/26 19:11:56 Onokazu Exp $
//  ------------------------------------------------------------------------ //
//                XOOPS - PHP Content Management System                      //
//                    Copyright (c) 2000 XOOPS.org                           //
//                       <https://xoops.org/>  &nbs ... nbsp;   //
//  ------------------------------------------------------------------------ //
//  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, or        //
//  (at your option) any later version.                                      //
//                                                                           //
//  You may not change or alter any portion of this comment or credits       //
//  of supporting developers from this source code or any supporting         //
//  source code which is considered copyrighted (c) material of the          //
//  original comment or credit authors.                                      //
//                                                                           //
//  This program is distributed in the hope that it will be useful,          //
//  but WITHOUT ANY WARRANTY; without even the implied warranty of           //
//  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the            //
//  GNU General Public License for more details.                             //
//                                                                           //
//  You should have received a copy of the GNU General Public License        //
//  along with this program; if not, write to the Free Software              //
//  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307 USA //
//  ------------------------------------------------------------------------ //
/******************************************************************************
 * Function: b_mylinks_top_show
 * Input   : $options[0] = date for the most recent links
 *                    hits for the most popular links
 *           $block['content'] = The optional above content
 *           $options[1]   = How many reviews are displayes
 * Output  : Returns the desired most recent or most popular links
 ******************************************************************************/
function b_mylinks_top_show($options) {
    global 
$xoopsDB;
    
$block = array();
    
$myts =& MyTextSanitizer::getInstance();
    
$result $xoopsDB->query("SELECT lid, cid, title, date, hits FROM ".$xoopsDB->prefix('mylinks_links')." WHERE status>0 ORDER BY ".$options[0]." DESC",$options[1],0);
    while(
$myrow $xoopsDB->fetchArray($result)){
        
$link = array();
        
$title $myts->makeTboxData4Show($myrow["title"]);
        if ( !
XOOPS_USE_MULTIBYTES ) {
            if (
strlen($myrow['title']) >= $options[2]) {
                
$title $myts->makeTboxData4Show(substr($myrow['title'],0,($options[2] -1)))."...";
            }
        }
        
$link['id'] = $myrow['lid'];
        
$link['cid'] = $myrow['cid'];
        
$link['title'] = $title;
        if(
$options[0] == "date"){
            
$link['date'] = formatTimestamp($myrow['date'],'s');
        }elseif(
$options[0] == "hits"){
            
$link['hits'] = $myrow['hits'];
        }
        
$block['links'][] = $link;
    }
    return 
$block;
}

function 
b_mylinks_random$options )
{
         global 
$xoopsDB;
     
$block = array();
     
$myts =& MyTextSanitizer::getInstance();
     
$result $xoopsDB -> query("SELECT lid, cid, title, url, logourl, date FROM " $xoopsDB -> prefix('mylinks_links') . " WHERE status>0 ORDER BY RAND()");
     while(
$myrow $xoopsDB->fetchArray($result)){
                
$link = array();
        
$title $myts->makeTboxData4Show($myrow["title"]);
        if ( !
XOOPS_USE_MULTIBYTES ) {
            if (
strlen($myrow['title']) >= $options[2]) {
                
$title $myts->makeTboxData4Show(substr($myrow['title'],0,($options[2] -1)))."...";
            }
        }
        
$link['id'] = $myrow['lid'];
        
$link['cid'] = $myrow['cid'];
        
$link['title'] = $title;
        
$link['url'] = $myrow['url'];
        
$link['logourl'] = $myrow['logourl'];
        
$link['date'] = formatTimestamp($myrow['date'],'s');
        
$block['links'][] = $link;
    }
    return 
$block;
}

function 
b_mylinks_top_edit($options) {
    
$form ""._MB_MYLINKS_DISP."&nbsp;";
    
$form .= "<input type='hidden' name='options[]' value='";
    if(
$options[0] == "date"){
        
$form .= "date'";
    }else {
        
$form .= "hits'";
    }
    
$form .= " />";
    
$form .= "<input type='text' name='options[]' value='".$options[1]."' />&nbsp;"._MB_MYLINKS_LINKS."";
    
$form .= "&nbsp;<br>"._MB_MYLINKS_CHARS."&nbsp;<input type='text' name='options[]' value='".$options[2]."' />&nbsp;"._MB_MYLINKS_LENGTH."";

    return 
$form;
}

function 
b_mylinks_random_edit$options )
{
    
$form =  "" _MB_MYLINKS_DISP "&nbsp;";
    
$form .= "<input type='hidden' name='options[]' value='";
    
$form .= "random'";
    
$form .= " />";
    
$form .= "<input type='text' name='options[]' value='" $options[1] . "' />&nbsp;" _MB_MYLINKS_LINKS "";
    
$form .= "&nbsp;<br />" _MB_MYLINKS_CHARS "&nbsp;<input type='text' name='options[]' value='" $options[2] . "' />&nbsp;" _MB_MYLINKS_LENGTH "";
    return 
$form;
}
?>

Login

Who's Online

64 user(s) are online (37 user(s) are browsing Support Forums)


Members: 0


Guests: 64


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Jul 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits