How grab one post ?

[roxxx]

How can I grab one post and display in other site ?

What is question to Mysql to do it ?

[Dismounted]

SELECT *
FROM `INSERTTABLEPREFIXpost`
WHERE `postid` = INSERTID
Make sure you replace the capitalised words.

[roxxx]

thanks,

I want to connect to database and I use include("config.php") but what's next ?,
which function to co-operate with it ?

[Eikinskjaldi]

thanks,

I want to connect to database and I use include("config.php") but what's next ?,
which function to co-operate with it ?

You dont want to include config.php, you want to include globals.php


then $vbulletin->db is ready to go.

[roxxx]

ok,

so I have:

<?
require("global.php");
$res = mysql_query("SELECT * FROM post WHERE postid='1111'");
$row= (mysql_fetch_row($res));
echo ($row[7]);
?>

:)

and it's display this post in other site, but when I want to add new plugin file .php with this code,
forum display error:

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 311296 bytes) in ............. global.php on line 472
I have limit memory in php.ini 16M.

Is it problem this code or limit ?

[Eikinskjaldi]

No where near enough information to answer your question, I am afraid.

the php memory limit is settable in php.ini. You wil have to restart apache once you change it.

[Paul M]

You shoud be using vb's query functions, not the mysql functions. :)

[roxxx]

ok, I should using vb's query functions:


require("global.php");

$getposts = $db->query_read("
SELECT post.postid AS postid, post.pagetext AS pagetext
FROM " . TABLE_PREFIX . "post AS post
WHERE postid='1111';");
//while($post = $db->fetch_array($getposts))
$post = $db->fetch_array($getposts);

echo "<b>".$post['postid']."</b> - ".$post['pagetext']."<br /><br />";

but is the same error,
is it possible that only choose one post, take that isn't enough memory ?

[Dismounted]

<?php
$curdir = getcwd();
chdir('./PATH/TO/FORUMS');
require_once('./global.php');
chdir($curdir);

$post = $vbulletin->db->query_first("
SELECT *
FROM `post`
WHERE `postid` = 1111
LIMIT 1
");

echo $post['message'];
?>