vb.org Archive - Inserting SQL in PHP Problem

Thanks for the help, unfortunately every time I get one thing done something else is wrong. :(

Now it's telling me that the function name must be a string (on line 245).

I researched that error code and found this...

Quote:

Well, I found the problem. It seems that I had a pair of parens ()' around the index of an array element instead of brackets []'s. Hence it was looking at a variable as a function. I.e.
Wrong: $arName('myindex')
Right: $arName['myindex']

http://www.webdeveloper.com/forum/sh...ad.php?t=81233

I figured maybe a variable in the array I was calling was being looked at as if it were a function like above, so I looked through the code and changed the parenthesis() around "SELECT * FROM " . TABLE_PREFIX . "formresults WHERE userid = '$bbuserinfo[userid]' , AND title = 'Resume' " to brackets[] but then I got this error.

Fatal error: Cannot use object of type vB_Database as array in /home/righscom/public_html/addons/projectfanboy/vb/member.php(463) : eval()'d code on line 245

But now that I look at it, I think that the parenthesis were right because even though it's part of the variable $db, it's still a sql query, right?

I think it's saying that I can't use the variable $db and I have to use a string instead for that part?

Anyway, I changed it back to parenthesis() and now I'm back to:

Fatal error: Function name must be a string in /home/righscom/public_html/addons/projectfanboy/vb/member.php(463) : eval()'d code on line 245

I'll keep researching. :(

--------------- Added [DATE]1262213487[/DATE] at [TIME]1262213487[/TIME] ---------------

Ok, I was re-reading your post and I think I was misunderstanding something before and it helps me to talk it out on "paper" so to speak.

Arrays look similar to variables.
Arrays are basically variables that hold multiple other variables (aka an array of other variables).

So, $db("SELECT * FROM " . TABLE_PREFIX . "formresults WHERE userid = '$bbuserinfo[userid]' , AND title = 'Resume' ") is not a variable but actually an array that uses a SQL query to generate its results.

But this is also an array, right?

Code:

array(

        'class' => 'resume',

        'title' => 'Resume',

        'hook_location' => 'profile_left_last'

    )

I think I may be starting to see the light.... (I'll probably edit this 15 more times while I look at it and think. :p)

--------------- Added [DATE]1262215159[/DATE] at [TIME]1262215159[/TIME] ---------------

Hmmm, I also found this...

Quote:

There's also another problem that will cause the same type of response (function must be a string) and that's inadvertently including a $ in front of a predefined/language defined function.

So I tried removing the $ from in front of the "predefined function" $db but that gave me a different error so I changed it back. Still looking! :D

--------------- Added [DATE]1262215901[/DATE] at [TIME]1262215901[/TIME] ---------------

Ok, to see if this would work (it didn't but I'm trying to think outside the box :p)

I globalised $db and defined $resume as the sql query earlier in the code and then I defined $this->block_data['resume'] as $resume so the code looked like this.

Code:

{

        global $db;

        $resume = $db("SELECT * FROM " . TABLE_PREFIX . "formresults WHERE userid = '$bbuserinfo[userid]' , AND title = 'Resume' ");

}



$blocklist = array_merge($blocklist, array(

    'resume' => array(

        'class' => 'resume',

        'title' => 'Resume',

        'hook_location' => 'profile_left_last'

    )

));



class vB_ProfileBlock_resume extends vB_ProfileBlock

{

  var $template_name = 'memberinfo_block_resume';

  function confirm_empty_wrap()

  {

    return false;

  }

  function confirm_display()

  {

    return ($this->block_data['resume'] != '');

  }

  function prepare_output($id = '', $options = array())

  {



    $this->block_data['resume'] = $resume;

  }

}

Like I said, it didn't work and I got the exact same error on a different line, but I get the feeling I may be on the right track?

--------------- Added [DATE]1262224021[/DATE] at [TIME]1262224021[/TIME] ---------------

Okay, here is the latest and greatest code for my plugin which seems to be working other than the fact that I don't think $bbuserinfo[userid] is parsing and so nothing shows up. But on a good note, I don't seem to be getting any errors anymore. :D

Code:

{

        global $db;

        $resume = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "formresults WHERE userid = '$bbuserinfo[userid]' AND title = 'Resume' ");

}  



$blocklist = array_merge($blocklist, array(

    'resume' => array(

        'class' => 'resume',

        'title' => 'Resume',

        'hook_location' => 'profile_left_last'

    )

));



class vB_ProfileBlock_resume extends vB_ProfileBlock

{

  var $template_name = 'memberinfo_block_resume';

  function confirm_empty_wrap()

  {

    return false;

  }

  function confirm_display()

  {

    return ($this->block_data['resume'] != '');

  }

  function prepare_output($id = '', $options = array())

  {



    $this->block_data['resume'] = $resume;

  }

}

--------------- Added [DATE]1262224314[/DATE] at [TIME]1262224314[/TIME] ---------------

Well son of a mazza frazzer.... Just to test it out, I changed out $bbuserinfo[userid] for '162' (my userid) and nothing still showed up. :confused:

I really thought that would work....

--------------- Added [DATE]1262298398[/DATE] at [TIME]1262298398[/TIME] ---------------

Kind of at a point where I'm a bit stumped. :(

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01070 seconds Memory Usage 1,740KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: