Hello,
I use Seo4smf 0.2.9.10 and TinyPortal v1.0.6 beta2.
When I try to install the package it founds an error.
If y try to install it manually, I can't found the code listed below in Tportal.php
$request = db_query("
SELECT
m.icon, m.subject, m.body, IFNULL(mem.realName, m.posterName) AS posterName, m.posterTime,
t.numReplies, t.ID_TOPIC, m.ID_MEMBER, m.smileysEnabled, m.ID_MSG, t.locked, t.numViews,t.numReplies
FROM ({$db_prefix}topics AS t, {$db_prefix}messages AS m)
LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER = m.ID_MEMBER)
WHERE t.ID_FIRST_MSG IN (" . implode(', ', $posts) . ")
AND m.ID_MSG = t.ID_FIRST_MSG
ORDER BY t.ID_FIRST_MSG DESC
LIMIT " . count($posts), __FILE__, __LINE__);
I think the code has changed with the new version of Tiny portal and the code to be modified may be this one :
$request = db_query("SELECT art.id, IF(art.useintro>0, art.intro, art.body) AS body,
art.date, art.intro, art.useintro, art.category, art.frontpage, art.subject, art.authorID,
art.author, art.frame, art.approved, art.off, art.parse, art.comments,
art.comments_var, art.views, art.rating, art.voters, art.ID_THEME, art.shortname,
art.sticky, art.fileimport, art.topic, art.locked, art.illustration,art.type,
mem.realName, mem.avatar,
IFNULL(a.ID_ATTACH, 0) AS ID_ATTACH, a.filename, a.attachmentType
FROM ({$tp_prefix}articles AS art, {$db_prefix}members AS mem)
LEFT JOIN {$db_prefix}attachments AS a ON (a.ID_MEMBER = mem.ID_MEMBER)
WHERE art.category=$mycat
AND art.off=0
AND art.approved=1
AND art.authorID=mem.ID_MEMBER
ORDER BY art.$catsort $catsort_order
LIMIT $start,$max", __FILE__, __LINE__);
Unfortunately I don't know what to modify for using Seo4Smf and Tiny portal.
Can someone help me?
Thanks in advance and sorry for my poor english.