[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 »

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 »

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 »

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 »

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 »

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 »

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: 3260
Joined: Wed Nov 09, 2005 2:51 pm

Post by Peter77sx »

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 »

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 »

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 »

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 »

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 »

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 »

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 »

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 »

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”