February 10, 2012, 16:14:13 *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Add your links to our directory. Click here to add your links.
 
  Home   Forum   Help Search Directory Calendar Login Register    RSS 2.0 feedAtom feed


News
Add your links to our directory. Click here to add your links.
Pages: [1]
  Print  
Author Topic:

Problem with Tiny Portal

 (Read 1043 times)
0 Members and 1 Guest are viewing this topic.
Galaad31
Jr. Member
**

Points: 0
Offline Offline

Posts: 9


« on: April 12, 2009, 09:07:59 »

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

Code:
$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 :

Code:
$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.

Logged


Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC
TinyPortal v0.9.7 © Bloc
Valid XHTML 1.0! Valid CSS!