• User Attivo

    Funzione get_permalink per file esterno php

    Salve raga, per il mio forum vbulletin, dal database ho estrapolato le ultime X news da mettere in bella vista nel forum, ho incluso il tutto e funziona, ma gli url non sono riscritti per niente.

    Ora sò della funzione get_permalink di wordpress, ma come si utilizza e come la inserisco nel mio codice?
    [php]<?

    require("inclusion.config.php");

    $connessione=mysql_connect($dbss_server, $dbss_username, $dbss_passwd);
    $dbss = mysql_select_db($dbss_name, $connessione);
    ?>
    <link rel="stylesheet" type="text/css" href="inclusion.css">
    <table width="100%" cellpadding="0" cellspacing="0" class="inc_tbl1">
    <tr>
    <td height="30" align="center" valign="middle" class="inc_tbl1_title" style="width:40%">
    <?=$inc_title1?>
    </td>
    <td style="width:30%" valign="middle" align="center" class="inc_tbl1_title">
    <?=$inc_title2?>
    </td>
    <td style="width:30%" valign="middle" align="center" class="inc_tbl1_title">
    <?=$inc_title3?>
    </td>
    </tr>
    <tr>
    <td style="width:<?=$wCol1?>" valign="top">
    <table width="100%" cellpadding="0" cellspacing="0">
    <tr>
    <?
    unset($noId);
    $qLastArticle = mysql_query("SELECT ID, post_content, post_title, guid FROM $tbl_post_wp WHERE post_status = 'publish' AND post_parent = '0' ORDER BY post_date DESC LIMIT $n_last_article");
    while($rLastArticle = mysql_fetch_assoc($qLastArticle)){

                    $noId .= " AND id!= '$rLastArticle[ID]' "; 
    
                    $qLastArticleImg = mysql_query("SELECT guid FROM $tbl_post_wp  WHERE post_mime_type LIKE 'image/%' AND post_parent = '$rLastArticle[ID]' ORDER BY post_date ASC LIMIT 1");   
                    $rLastArticleImg = mysql_fetch_assoc($qLastArticleImg); 
                ?> 
                    <td style="padding:2px"> 
                        <a href="<?=$rLastArticle[guid]?>"><b><?=$rLastArticle[post_title]?></b></a> 
                        <div style="clear:both;height:5px"></div> 
                        <div id="LastArticle"> 
                        <? 
                        if($rLastArticleImg[guid] != ""){ 
                        ?> 
                        <div id="imgLastArticle"> 
                            <img src="<?=$base?>phpThumb/phpThumb.php?src=<?=$rLastArticleImg[guid]?>&w=<?=$img_width?>&h=<?=$img_height?>&q=100"> 
                        </div> 
                        <?                         
                        } 
                        ?>    
                     
                            <?=substr(strip_tags($rLastArticle[post_content]),0,$lengthLastArticle)?>... 
                        </div> 
                    </td> 
                <? 
                } 
                ?> 
                </tr> 
            </table> 
        </td> 
        <td style="width:<?=$wCol2?>" valign="top"> 
            <table width="100%" cellpadding="0" cellspacing="0" class="inc_tbl2"> 
        <? 
        $qTenArticle = mysql_query("SELECT ID, post_title, guid FROM $tbl_post_wp  WHERE post_status = 'publish' AND post_parent = '0' $noId ORDER BY post_date DESC LIMIT 10");   
        while($rTenArticle = mysql_fetch_assoc($qTenArticle)){ 
             
            ?> 
             
                <tr> 
                    <td><a href="<?=$rTenArticle[guid]?>"><b><?=$rTenArticle[post_title]?></b></a></td> 
                </tr> 
            <?     
        } 
        ?> 
     [/php]