vBSEO Functions for Extensibility

Since the \w does 0-9a-zA-Z and _ but doesn't do -, what should be used instead.

e.g. in the url:

Code:

script.php?param=user-name

What CRR should be used to extract "user-name"?

("user-name" was created by vbseo_filter_text())

You can use this:
[\w\-]

Based on your suggestion this is the CRR (left side)

Code:

'^trainingblog\.php\?username=(\w\-+)$'

This is the url

Code:

trainingblog.php?username=user-name

It's not being rewritten?

It would be:
'^trainingblog\.php\?username=([\w\-]+)$'

That's got it, thanks.

Perhaps it would be wise to put that in the CRR usage post. I doubt I'm the only one who's had issues with \w not picking up the -

I'm using this to build up the links to the lastest post in a thread, but it doesn't work correctly:

Code:

$sql = "select * from FP_thread where threadid =  ".$row["threadid"];
$row2 =  mysql_fetch_array(mysql_query($sql,$link2));
$url_seo =  "http://www.foropymes.es/foro/".vbseo_thread_url_row_spec($row2, VBSEO_URL_THREAD_LASTPOST);

It gives us this link (which doesn't lead to latest post, just the first):

AYUDAS: Planificando una nueva empresa - FORO PYMES

Inside the forum we can see this link that works:

AYUDAS: Planificando una nueva empresa - Página 2 - FORO PYMES


Any hint about how to fix it?

btw:
The first page with the documentation of this page you have 'last' (which doesn't work) instead of VBSEO_URL_THREAD_LASTPOST .

Thanks for your help!

That URL format (VBSEO_URL_THREAD_LASTPOST) corresponds to showthread.php?t=X&goto=lastpost and recent vBulletin versions do not support "goto lastpost" URLs anymore.

how can i get blog entry urls ?

http://domain/forums/blog.php?b=359
to
http://domain/forums/blogs/entrytitle


is there any vbseo_blog_url_row() ? or anything like that ???

I try this with no success :(


<?
include_once 'includes/functions_vbseo.php';
vbseo_startup();

$conex = mysql_connect("localhost","user","password");
$bd = mysql_select_db("database");
$sql = 'SELECT * FROM vbblog where state="visible" AND TO_DAYS(NOW()) - TO_DAYS(FROM_UNIXTIME(dateline)) = 1 ORDER BY dateline DESC';
$consulta = mysql_query($sql);
while ($fila = mysql_fetch_array($consulta)) {
$test = vbseo_blog_url(VBSEO_URL_BLOG_ENTRY, array('b'=>$fila['blogid']));
echo "<a href=\"$test\" target=\"_blank\">$fila[title]</a><br>";
}

?>

Originally Posted by magmf

how can i get blog entry urls ?

http://domain/forums/blog.php?b=359
to
http://domain/forums/blogs/entrytitle


is there any vbseo_blog_url_row() ? or anything like that ???

vBSEO already has built in vB Blog url support

Mert,

I know but i send everyday a newsletter to my users and i want know how can i change this code

PHP Code:

<?
include_once 'includes/functions_vbseo.php';
vbseo_startup();
 
$conex = mysql_connect("localhost","user","password");
            $bd = mysql_select_db("database");
$sql = 'SELECT * FROM vbblog where state="visible" AND TO_DAYS(NOW()) - TO_DAYS(FROM_UNIXTIME(dateline)) = 1 ORDER BY dateline DESC';
       $consulta = mysql_query($sql);
       while ($fila = mysql_fetch_array($consulta)) {
         $test = vbseo_blog_url(VBSEO_URL_BLOG_ENTRY, array('b'=>$fila['blogid']));
          echo "<a href=\"$test\" target=\"_blank\">$fila[title]</a><br>";
       }
 
?>

to get vbseo url's instead of use standart url's

Hello Marcus,

try this:

PHP Code:

       while ($fila = mysql_fetch_array($consulta)) {
$vbseo_gcache['blog'][$fila['blogid']] = $fila;
         $test = vbseo_blog_url(VBSEO_URL_BLOG_ENTRY, array('b'=>$fila['blogid']));
          echo "<a href=\"$test\" target=\"_blank\">$fila[title]</a><br>";
       } 


MAN,

WORKED 100% THANKS A LOT
uhuhhu

You are welcome!

Originally Posted by Oleg Ignatiuk

Hello Tobi,

this is an array retrieved with mysql_fetch_array() function from "thread" db table.
Here is an example:

PHP Code:

$getthreads = $db->query("
SELECT *
FROM " . TABLE_PREFIX . "thread
WHERE threadid=123
");
$threadrow = $db->fetch_array($getthreads);

$threadurl = vbseo_thread_url_row($thread_row); 


hi,

I tried this but I keep getting an error saying Call to a member function query() on a non-object. Can anybody help?