Page 2 of 6

Posted: Sat May 27, 2006 9:15 am
by dcz
nice, but the demo is currently not working ;)

Posted: Sat May 27, 2006 9:29 am
by Quezza
Yes I know. It has been reported and replied to already :wink:

Shall get it up today hopefully

Posted: Sat May 27, 2006 9:31 am
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 ;)

Posted: Tue May 30, 2006 3:48 am
by kyle1745
Any ideas on when this will be a full release? Sounds and looks like a great mod.

Posted: Tue May 30, 2006 8:16 am
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.

Posted: Tue May 30, 2006 7:10 pm
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

Posted: Wed May 31, 2006 12:23 am
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. :)

Posted: Wed May 31, 2006 7:38 am
by Quezza
If it is not working post your posting_body.tpl file here and I'm happy to take a look.

Posted: Wed May 31, 2006 1:24 pm
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?

Posted: Wed May 31, 2006 3:04 pm
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

Posted: Thu Jun 01, 2006 9:05 am
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.

Help

Posted: Sat Jun 17, 2006 5:25 am
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?

Posted: Sun Jun 18, 2006 12:55 pm
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.

Posted: Sun Jun 18, 2006 5:14 pm
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!

Posted: Sun Jun 18, 2006 5:36 pm
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