blog mod issues with seo rewrite

[superj707]

These links fail when I have SEO rewrites turned on in the ACP

[EXreaction]

How do they fail?

[superj707]

error screen

[EXreaction]

What is the error?

[superj707]

General Error
SQL ERROR [ mysql4 ]

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 '' at line 4 [1064]

SQL

SELECT blog_style FROM phpbb_blogs_users WHERE user_id =

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: blog.php
LINE: 250
CALL: dbal_mysql->sql_query()

FILE: blog.php
LINE: 384
CALL: style_is()

FILE: blog/view/blog.php
LINE: 53
CALL: include('blog.php')

[EXreaction]

That file appears to be modified, which is probably what is causing errors.

[superj707]

why is that file not allowed to be modified in any way?

Code: Select all

function style_is($user_id)
{
      
      global $db;

      $sql = 'SELECT
            blog_style
            FROM '.phpbb_blogs_users.'
            WHERE user_id ='. $user_id;
      $result       = $db->sql_query($sql);

      $is_style      = $db->sql_fetchfield('blog_style');

      
      
      $db->sql_freeresult($result);
      return   $is_style;

}


that is the function I wrote that is causing the problem. This function along with it's template var
'BLOG_STYLE' => style_is($user_id),
allows me to hide the CSS text area box for styles that do not have a * and cannot use CSS

[EXreaction]

It's an issue with the code you wrote, not the mod.

[superj707]

well my code is working great unless in SEO mode so it's good code.