Question :First Topic [pic] onForum + Last X [img] on Forum

Mod Support

Moderators: BNa, Sekuro, 4seven

Re: Question :First Topic [pic] onForum + Last X [img] on Fo

Postby Pitch » 04 Jul 2013, 21:37

Search.php

Code: Select all
        if ($topic_id && ($topic_id == $result_topic_id))
        {
            
$template->assign_vars(array(
                
'SEARCH_TOPIC'        => $topic_title,
                
'U_SEARCH_TOPIC'    => $view_topic_url
            
));
        }
    }
    unset(
$rowset);
         
// 4seven / First Topic [pics] on Forum Index  / 2010
     
include($phpbb_root_path 'includes/first_x_in_forum_index_config.' $phpEx);
             if (!isset(
$affected_forum_att))
        {
           
$affected_forum_att[] = 0;
        }

        if (!isset(
$affected_forum_img))   
        {
            
$affected_forum_img[] = 0;
        }
     include(
$phpbb_root_path 'includes/first_x_in_forum_search.' $phpEx);
     
     
// 4seven / First Topic [pics] on Forum Index  / 2010 



and
includes/first_x_in_forum_search.php
Code: Select all
<?php
/**
*
* @package First Topic [pic] on Forum Index  v.0.0.6
* @version $Id: first_x_in_forum_index_search.php 2356 2356 2010-11-04 03:25:05Z 4seven $
* @copyright (c) 2010 / 4seven
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
* @ignore
*/
if (!defined('IN_PHPBB'))
{
    exit;
}
        if (!isset(
$affected_forum_att))
        {
           
$affected_forum_att[] = 0;
        }

        if (!isset(
$affected_forum_img))   
        {
            
$affected_forum_img[] = 0;
        }
// First Topic [pic] on Forum Index  / 4seven / 2010
// basics
$template->assign_vars(array(
    
'ACTIVE_SEARCH'                => ($active_4_search == 'yes') ? true false,
    
'EMPTY_IMG'                    => ($no_pic_img == 'yes') ? $phpbb_root_path 'images/' 'no_img.jpg' false,
    
'PLACEHOLDER'                => (($no_pic_img == 'no') && ($no_img_placeholder == 'yes')) ? true false,
    
'BORDER_COLOR'                => (isset($border_color)) ? $border_color '',
    
'CONVERT_SIZE'                => $convert_max_size 6
    
'CONVERT_DIV_SIZE'            => $convert_max_size 64,     



New error
SQL ERROR [ mysqli ]

[0]

SQL

No values specified for SQL IN comparison

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/dbal.php
LINE: 432
CALL: dbal->sql_error()

FILE: [ROOT]/includes/first_x_in_forum_search.php
LINE: 53
CALL: dbal->sql_in_set()

FILE: [ROOT]/search.php
LINE: 1147
CALL: include('[ROOT]/includes/first_x_in_forum_search.php')
Pitch

Tiptop

Tiptop
 
Posts: 20
Joined: 27 Jun 2013, 22:19
 
Resolution: 1536x864

Re: Question :First Topic [pic] onForum + Last X [img] on Fo

Postby Pitch » 04 Jul 2013, 21:43

I attached my search.php file
if it helps to have it in full.
https://www.box.com/s/a3ghorihyrp2pukamn7s
Last edited by Pitch on 04 Jul 2013, 21:47, edited 1 time in total.
Pitch

Tiptop

Tiptop
 
Posts: 20
Joined: 27 Jun 2013, 22:19
 
Resolution: 1536x864


Re: Question :First Topic [pic] onForum + Last X [img] on Fo

Postby 4seven » 04 Jul 2013, 21:45

Dont see a file, but it seems, that the edit in search.php is wrong
viewtopic.php?p=1082#p1082

open

search.php

remove all edits from this mod you have in search.php

after that do the following:

find

Code: Select all
        if ($topic_id && ($topic_id == $result_topic_id))
        {
            $template->assign_vars(array(
                'SEARCH_TOPIC'        => $topic_title,
                'U_SEARCH_TOPIC'    => $view_topic_url
            
));
        }
    }
    unset($rowset);


before add

Code: Select all
    // First Topic [pic] on Forum Index  / 4seven / 2010
    if ((!isset($for_id_1)) || (!isset($for_id_2)))
    {
       $for_id_1 = array();
       $for_id_2 = array();
    }
    $for_id_1[] = $forum_id; //$u_forum_id;
    $for_id_2[] = $forum_id; //$u_forum_id;    
    // ----------------------------------------------------
    if ((!isset($res_top_id_1)) || (!isset($res_top_id_2)))
    {
       $res_top_id_1 = array();
       $res_top_id_2 = array();
        }
    $res_top_id_1[] = $result_topic_id;
    $res_top_id_2[] = $result_topic_id;    
    
// First Topic [pic] on Forum Index  / 4seven / 2010    


and after the named find add this

Code: Select all
     // 4seven / First Topic [pics] on Forum Index  / 2010
     include($phpbb_root_path . 'includes/first_x_in_forum_index_config.' . $phpEx);
     include($phpbb_root_path . 'includes/first_x_in_forum_search.' . $phpEx);
     // 4seven / First Topic [pics] on Forum Index  / 2010    


Note: Leave the fix in includes/first_x_in_forum_search untouched..
Current Mods | Mod Base | php(BB) programming | No help via PM
User avatar
4seven

Tiptop

Tiptop
 
Posts: 318
Joined: 20 Jun 2012, 16:55
 
Resolution: 1920x1080


Re: Question :First Topic [pic] onForum + Last X [img] on Fo

Postby Pitch » 04 Jul 2013, 21:49

I just saw for the file, I edited fl download on box.com
if it helps you to see it all.
Because I know I do not understand what I did wrong to get this error.
Pitch

Tiptop

Tiptop
 
Posts: 20
Joined: 27 Jun 2013, 22:19
 
Resolution: 1536x864


Re: Question :First Topic [pic] onForum + Last X [img] on Fo

Postby 4seven » 04 Jul 2013, 21:53

strg + f5 your browser and read my last post..
Current Mods | Mod Base | php(BB) programming | No help via PM
User avatar
4seven

Tiptop

Tiptop
 
Posts: 318
Joined: 20 Jun 2012, 16:55
 
Resolution: 1920x1080


Re: Question :First Topic [pic] onForum + Last X [img] on Fo

Postby Pitch » 04 Jul 2013, 21:55

and link to include/first_x_in_forum_search.php

https://www.box.com/s/cwudblhczgkf9aurafiq
Pitch

Tiptop

Tiptop
 
Posts: 20
Joined: 27 Jun 2013, 22:19
 
Resolution: 1536x864


Re: Question :First Topic [pic] onForum + Last X [img] on Fo

Postby 4seven » 04 Jul 2013, 21:56

your to fast. read my last post. good evening...
Current Mods | Mod Base | php(BB) programming | No help via PM
User avatar
4seven

Tiptop

Tiptop
 
Posts: 318
Joined: 20 Jun 2012, 16:55
 
Resolution: 1920x1080


Re: Question :First Topic [pic] onForum + Last X [img] on Fo

Postby Pitch » 04 Jul 2013, 22:33

When I put that

Code: Select all
'U_VIEW_POST'        => (!empty($row['post_id'])) ? append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$forum_id&amp;t=" . $row['topic_id'] . '&amp;p=' . $row['post_id'] . (($u_hilit) ? '&amp;hilit=' . $u_hilit : '')) . '#p' . $row['post_id'] : '')
            ));
        
        
}
        
        
// First Topic [pic] on Forum Index  / 4seven / 2010
        if ((!isset($for_id_1)) || (!isset($for_id_2)))
        {
           $for_id_1 = array();
           $for_id_2 = array();
        }
        $for_id_1[] = $forum_id; //$u_forum_id;
        $for_id_2[] = $forum_id; //$u_forum_id;    
        // ----------------------------------------------------
        if ((!isset($res_top_id_1)) || (!isset($res_top_id_2)))
        {
           $res_top_id_1 = array();
           $res_top_id_2 = array();
            }
        $res_top_id_1[] = $result_topic_id;
        $res_top_id_2[] = $result_topic_id;    
        
// First Topic [pic] on Forum Index  / 4seven / 2010 
           
        
        if 
($topic_id && ($topic_id == $result_topic_id))
        {
            $template->assign_vars(array(
                'SEARCH_TOPIC'        => $topic_title,
                'U_SEARCH_TOPIC'    => $view_topic_url
            
));
            
        
}
    }
    
    unset
($rowset);
             
    
// www.phpBB-SEO.com SEO TOOLKIT BEGIN - TITLE    


messages no read are like thats
mes non lus.JPG


But when i put this code
Code: Select all
    // 4seven / First Topic [pics] on Forum Index  / 2010
         include($phpbb_root_path . 'includes/first_x_in_forum_index_config.' . $phpEx);
         include($phpbb_root_path . 'includes/first_x_in_forum_search.' . $phpEx);
         // 4seven / First Topic [pics] on Forum Index  / 2010      


as you ask me

Code: Select all
    'U_VIEW_POST'        => (!empty($row['post_id'])) ? append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$forum_id&amp;t=" . $row['topic_id'] . '&amp;p=' . $row['post_id'] . (($u_hilit) ? '&amp;hilit=' . $u_hilit : '')) . '#p' . $row['post_id'] : '')
            ));
        
        
}
        
        
// First Topic [pic] on Forum Index  / 4seven / 2010
        if ((!isset($for_id_1)) || (!isset($for_id_2)))
        {
           $for_id_1 = array();
           $for_id_2 = array();
        }
        $for_id_1[] = $forum_id; //$u_forum_id;
        $for_id_2[] = $forum_id; //$u_forum_id;    
        // ----------------------------------------------------
        if ((!isset($res_top_id_1)) || (!isset($res_top_id_2)))
        {
           $res_top_id_1 = array();
           $res_top_id_2 = array();
            }
        $res_top_id_1[] = $result_topic_id;
        $res_top_id_2[] = $result_topic_id;    
        
// First Topic [pic] on Forum Index  / 4seven / 2010 
           
        
        if 
($topic_id && ($topic_id == $result_topic_id))
        {
            $template->assign_vars(array(
                'SEARCH_TOPIC'        => $topic_title,
                'U_SEARCH_TOPIC'    => $view_topic_url
            
));
            
        
}
    }
    
    unset
($rowset);
             // 4seven / First Topic [pics] on Forum Index  / 2010
     include($phpbb_root_path . 'includes/first_x_in_forum_index_config.' . $phpEx);
     include($phpbb_root_path . 'includes/first_x_in_forum_search.' . $phpEx);
     // 4seven / First Topic [pics] on Forum Index  / 2010    
    // www.phpBB-SEO.com SEO TOOLKIT BEGIN - TITLE
    $extra_title = ($start > 0) ? ' - ' . $user->lang['Page'] . ( floor( $start / $per_page ) + 1 ) : '';
    page_header( ( ($l_search_title) ? $l_search_title . (!empty($search->search_query) ? ' : ' . $search->search_query : '' ): $user->lang['SEARCH'] ) . $extra_title );
    // www.phpBB-SEO.com SEO TOOLKIT END - TITLE  


I have the error

Erreur générale
SQL ERROR [ mysqli ]

[0]

SQL

No values specified for SQL IN comparison

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/dbal.php
LINE: 432
CALL: dbal->sql_error()

FILE: [ROOT]/includes/first_x_in_forum_search.php
LINE: 53
CALL: dbal->sql_in_set()

FILE: [ROOT]/search.php
LINE: 1151
CALL: include('[ROOT]/includes/first_x_in_forum_search.php')



I do not understand, I do what you say yet.
I really thank you for your patient with me
Pitch

Tiptop

Tiptop
 
Posts: 20
Joined: 27 Jun 2013, 22:19
 
Resolution: 1536x864


Re: Question :First Topic [pic] onForum + Last X [img] on Fo

Postby 4seven » 04 Jul 2013, 22:42

Seems seo relevant, no further clue. just put an fresh 3.0.11 unmodded search.php with these mod-edits in place and watch, what happens. save your original before.
Current Mods | Mod Base | php(BB) programming | No help via PM
User avatar
4seven

Tiptop

Tiptop
 
Posts: 318
Joined: 20 Jun 2012, 16:55
 
Resolution: 1920x1080


Re: Question :First Topic [pic] onForum + Last X [img] on Fo

Postby Pitch » 04 Jul 2013, 23:22

I redownload http://www.phpbb-seo.com/fr/annonces-si ... t6656.html # p48586
  so I replaced it with my current search.php this premod and I see what's happening?
I do it tomorrow, then it's late, tomorrow work.

Good night to you.
Pitch

Tiptop

Tiptop
 
Posts: 20
Joined: 27 Jun 2013, 22:19
 
Resolution: 1536x864

PreviousNext

Return to Support Forum

Who is online

Users browsing this forum: No registered users and 3 guests

cron