[RC] QWiki (Combining the Wiki and the Bulletin Board)

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
dcz
Registered User
Posts: 787
Joined: Sun Feb 13, 2005 5:37 am
Contact:

Post by dcz » Sat May 27, 2006 9:15 am

nice, but the demo is currently not working ;)

phpBB SEO || phpBB3 SEO Premod || SEO phpBB3
GYM Sitemaps & RSS for phpBB3: GYM Sitemaps & RSS

User avatar
Quezza
Registered User
Posts: 212
Joined: Sat Oct 23, 2004 7:17 pm
Location: Hertfordshire, UK
Contact:

Post by Quezza » Sat May 27, 2006 9:29 am

Yes I know. It has been reported and replied to already :wink:

Shall get it up today hopefully

dcz
Registered User
Posts: 787
Joined: Sun Feb 13, 2005 5:37 am
Contact:

Post by dcz » Sat May 27, 2006 9:31 am

Quezza wrote: Yes I know. It has been reported and replied to already :wink:

Shall get it up today hopefully


Well sorry for that, I guess I wanted to see it working too bad ;)

phpBB SEO || phpBB3 SEO Premod || SEO phpBB3
GYM Sitemaps & RSS for phpBB3: GYM Sitemaps & RSS

kyle1745
Registered User
Posts: 173
Joined: Thu Nov 14, 2002 2:21 am

Post by kyle1745 » Tue May 30, 2006 3:48 am

Any ideas on when this will be a full release? Sounds and looks like a great mod.

User avatar
Quezza
Registered User
Posts: 212
Joined: Sat Oct 23, 2004 7:17 pm
Location: Hertfordshire, UK
Contact:

Post by Quezza » Tue May 30, 2006 8:16 am

Yea, Quite soon but I have been moving to a dedicated server over the last few days so all my time has been spent doing that.

User avatar
Quezza
Registered User
Posts: 212
Joined: Sat Oct 23, 2004 7:17 pm
Location: Hertfordshire, UK
Contact:

Post by Quezza » Tue May 30, 2006 7:10 pm

OK, Version 1.1.0 released. Updated the installer & re-submitted to MOD DB. If you have 1.0.0 installed to upgrade all you need to do to upgrade is overwrite your wiki.php & includes/functions_wiki.php files with the new ones :)

Luke

Peter77sx
Registered User
Posts: 3253
Joined: Wed Nov 09, 2005 2:51 pm

Post by Peter77sx » Wed May 31, 2006 12:23 am

Quezza wrote: You should already have the SQL. It is not that which is preventing it from showing. Make sure you have uploaded templates/subSilver/posting_body.tpl

Thanks



::edit::

Guess it's just my board that it doesn't like. thanks anyway. :)

User avatar
Quezza
Registered User
Posts: 212
Joined: Sat Oct 23, 2004 7:17 pm
Location: Hertfordshire, UK
Contact:

Post by Quezza » Wed May 31, 2006 7:38 am

If it is not working post your posting_body.tpl file here and I'm happy to take a look.

morfis
Registered User
Posts: 2
Joined: Wed May 31, 2006 1:18 pm

Post by morfis » Wed May 31, 2006 1:24 pm

Following error reported when using easymod to install v1.1:

2 Warning(s) reported by the SQL Parser

1. Column "auth_wiki" has been found using 2 different data types in 2 tables: TINYINT(1) in phpbb_auth_access; TINYINT(2) in phpbb_forums.
2. Column "auth_wiki_edit" has been found using 2 different data types in 2 tables: TINYINT(1) in phpbb_auth_access; TINYINT(2) in phpbb_forums.

and it's then repeated.

Suggestions?

User avatar
Quezza
Registered User
Posts: 212
Joined: Sat Oct 23, 2004 7:17 pm
Location: Hertfordshire, UK
Contact:

Post by Quezza » Wed May 31, 2006 3:04 pm

They should both be TINYINT(1), but it doesn't really make any difference at all and running it like that is fine. Go ahead with the install. The demo site is with the 1 and the 2. I shall change it before the next release.

Luke

morfis
Registered User
Posts: 2
Joined: Wed May 31, 2006 1:18 pm

Post by morfis » Thu Jun 01, 2006 9:05 am

Quezza wrote: They should both be TINYINT(1), but it doesn't really make any difference at all and running it like that is fine. Go ahead with the install. The demo site is with the 1 and the 2. I shall change it before the next release.

Luke


Thanks. Edited and then manually added. Seems to be working ok.

cmsinai
Registered User
Posts: 3
Joined: Sat Jun 17, 2006 5:22 am

Help

Post by cmsinai » Sat Jun 17, 2006 5:25 am

There appears to be something wrong with the syntax for search.php. This is what I get when I select only retur wiki posts -

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' phpbb_posts p WHERE w.word_text LIKE 'gina' AND m.word_id = w' at line 2

SELECT m.post_id FROM phpbb_search_wordlist w, phpbb_search_wordmatch m, , phpbb_posts p WHERE w.word_text LIKE 'gina' AND m.word_id = w.word_id AND w.word_common <> 1 AND p.post_id = m.post_id AND p.post_wiki AND post_wiki = 1

Any help?

User avatar
Quezza
Registered User
Posts: 212
Joined: Sat Oct 23, 2004 7:17 pm
Location: Hertfordshire, UK
Contact:

Post by Quezza » Sun Jun 18, 2006 12:55 pm

I haven't time too look into it right now, sorry, but it is probably to do with this:
SELECT m.post_id FROM phpbb_search_wordlist w, phpbb_search_wordmatch m, , [b/]phpbb_posts p WHERE w.word_text LIKE 'gina' AND m.word_id = w.word_id AND w.word_common <> 1 AND p.post_id = m.post_id AND p.post_wiki AND post_wiki = 1


Can you post that part of your search.php here and I'll take a look.

cmsinai
Registered User
Posts: 3
Joined: Sat Jun 17, 2006 5:22 am

Post by cmsinai » Sun Jun 18, 2006 5:14 pm

Sorry for the length of this post - wasn't sure how much around the problem area to grab. This is a portion of search.php -

default:
if ( !empty($search_terms) )
{
$current_match_type = 'and';
}
// BEGIN QWiki MOD By LoonyLuke (www.Quezza.com AND www.ForumImgs.com)
if ($return_wiki)
{
$from_sql = ", " . POSTS_TABLE . " p";
$where_sql = " AND p.post_id = m.post_id AND p.post_wiki";
}
// END QWiki MOD By LoonyLuke (www.Quezza.com AND www.ForumImgs.com)

if ( !strstr($multibyte_charset, $lang['ENCODING']) )
{
$match_word = str_replace('*', '%', $split_search[$i]);
$sql = "SELECT m.post_id
FROM " . SEARCH_WORD_TABLE . " w, " . SEARCH_MATCH_TABLE . " m, " . $from_sql . "
WHERE w.word_text LIKE '$match_word'
AND m.word_id = w.word_id
AND w.word_common <> 1
$search_msg_only $where_sql";
}
// BEGIN QWiki MOD By LoonyLuke (www.Quezza.com AND www.ForumImgs.com)
if ($return_wiki)
{
$sql .= " AND post_wiki = 1";
}
// END QWiki MOD By LoonyLuke (www.Quezza.com AND www.ForumImgs.com)
else
{
$match_word = addslashes('%' . str_replace('*', '', $split_search[$i]) . '%');
$search_msg_only = ( $search_fields ) ? "OR post_subject LIKE '$match_word'" : '';
$sql = "SELECT post_id
FROM " . POSTS_TEXT_TABLE . "
WHERE post_text LIKE '$match_word'
$search_msg_only";
}
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain matched posts list', '', __LINE__, __FILE__, $sql);
}

$row = array();
while( $temp_row = $db->sql_fetchrow($result) )
{
$row[$temp_row['post_id']] = 1;

if ( !$word_count )
{
$result_list[$temp_row['post_id']] = 1;
}
else if ( $current_match_type == 'or' )
{
$result_list[$temp_row['post_id']] = 1;
}
else if ( $current_match_type == 'not' )
{
$result_list[$temp_row['post_id']] = 0;
}
}

if ( $current_match_type == 'and' && $word_count )
{
@reset($result_list);
while( list($post_id, $match_count) = @each($result_list) )
{
if ( !$row[$post_id] )
{
$result_list[$post_id] = 0;
}
}
}

$word_count++;

$db->sql_freeresult($result);
}
}

If you look at the following line ...

FROM " . SEARCH_WORD_TABLE . " w, " . SEARCH_MATCH_TABLE . " m, " . $from_sql . "

... you can see that I had to modify your mod ( . $from_sql . ") which did not contain the preceeding parantheses or comma - not sure it needed the comma.

I invite you to take a look at my site (www.green-space.us/forum) and let me know what you think and whether it's working as expected.

Thanks!

User avatar
Quezza
Registered User
Posts: 212
Joined: Sat Oct 23, 2004 7:17 pm
Location: Hertfordshire, UK
Contact:

Post by Quezza » Sun Jun 18, 2006 5:36 pm

You are correct. Try removing the comma and then check it. If I doesn't work still, I shall have another look. Also BTW it is helpfull if you use [ code ] [/ code ] tags :wink:

Luke

Post Reply

Return to “[2.0.x] MODs in Development”