include php in template URL REWRITE

[justoverclock]

hi, i've created a new plugin for a php include (wordpress news into vbulletin)

all works fine (thx to lynne)

but now how can i make this url SEO FRIENDLY?

fetch_seo_url is the function? how can i do this step by step?

[Retal]

What URL are you talking about?

[justoverclock]

i've made a plugin to include the wordpress news in vbulletin

but this url are not rewrited.... (now you can't see the plugin because is disabled)

[Lynne]

Have you checked out the function either in the files or in the API (link in Quick Links)?

[justoverclock]

i don't understand lynne, i'm italian and i'm not a coder

[Lynne]

Go to the API here - http://members.vbulletin.com/api/ and click on functions and find fetch_seo_url . That should help you understand how the function works.

[justoverclock]

ok i read this

Converts raw link information into an appropriate URL Verifies that the requested linktype can be handled

void fetch_seo_url (string $link, array $linkinfo, [array $pageinfo = null], [string $primaryid = null], [string $primarytitle = null])
string $link: Type of link, 'thread', etc
array $linkinfo: Specific information relevant to the page being linked to, $threadinfo, etc
array $pageinfo: Other information relevant to the page being linked to
string $primaryid: Override the default $linkinfo[userid] with $linkinfo[$primaryid]
string $primarytitle: Override the default $linkinfo[title] with $linkinfo[$primarytitle]

now the question is?.this code should go in the plugin? in the template? in my file.php?

[Lynne]

It's a function you call with php. If the function were called "myfunction" and it accepted two inputs, you would call it like:

$newname = myfunction($var1, $var2);

Do a search through the vbulletin files for other calls to the function ("fetch_seo_url") and you'll get 294 hits. That's 294 good examples of how to use that function.

[justoverclock]

not work for me, this is an example from a coder of vbseo.com but i get a fatal error:

"you have to do something like this" in your file.php

PHP Code:

 include_once 'includes/functions_vbseo.php'; 

//the rest of your query stuff here
while($records){
$threadurl = vbseo_thread_url_row($records[threadID], 1);
} 


i try but i have an error, this is my clean file.php (without this mod) anyone know where i put the code?

it's so difficult for me twice because i'm not english...

PHP Code:

<? 

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> 
            <?     
        } 
        ?> 
            </table> 
        </td> 
        <td style="padding-left:5px" "width:<?=$wCol3?>" valign="top" > 
        <a href="http://www.justoverclock.com/recensioni/modding" title="Modding" target="_blank">Modding</a><br> 
      <a href="http://www.justoverclock.com/overclock-cpu-e-hardware" title="overclock" target="_blank">Overclock</a><br> 
      <a href="http://www.justoverclock.com/liquid-cooling-raffreddamento-a-liquido" title="liquid cooling" target="_blank">Liquid Cooling</a><br> 
      <a href="http://www.justoverclock.com/telefonia-e-tablet-pc" title="telefonia e tablet pc" target="_blank">Telefonia e Tablet PC</a><br> 
      <a href="http://www.justoverclock.com/recensioni" title="Recensioni e test" target="_blank">Recensioni e test</a><br> 
      <a href="http://www.justoverclock.com/schede-video-ati-nvidia-zotac-sapphire-xfx" title="Schede video" target="_blank">Schede Video</a><br> 
      <a href="http://www.justoverclock.com/cpu-ram" title="cpu e ram" target="_blank">Cpu e Ram</a><br> 
      <a href="http://www.justoverclock.com/generale" title="hardware generale">Generale</a><br> 
      <a href="http://www.justoverclock.com/storage-e-periferiche" target="_blank">Periferiche</a><br> 
      <a href="http://www.justoverclock.com/news-videogiochi" target="_blank">Videogiochi</a> 

        </td> 
    </tr> 
</table>

[Lynne]

That is a vbseo function, so you will have to ask them for help as I know nothing about that function.