Users must post before voting

[Pandemikk]

How would I go about doing this?

I've tried the below to give me an array but it results in a fatal error.

PHP Code:

$checkpost = $vbulletin->db->query_read("
        SELECT username
        FROM " . TABLE_PREFIX . "post
        WHERE threadid = '".$threadid."'
    "); 


[killa seven]

what your array code look like

you need to fetch through the results

[Pandemikk]

I've fixed the fatal error issue. But the following isn't working. It should print out the array but it isnt'.

PHP Code:

$threadid = $vbulletin->db->query_first("
        SELECT threadid
        FROM " . TABLE_PREFIX . "thread
        WHERE pollid = '".$pollida."'
    ");

$checkpost = $vbulletin->db->query_read("
        SELECT username
        FROM " . TABLE_PREFIX . "post
        WHERE threadid = '".$threadid."'
    ");
while ($posts = $db->fetch_array($checkpost))
{
print_r($posts);
} 


[killa seven]

while($post = $vbulletin->db->fetch_array)

[Pandemikk]

That returns mysqli_result Object ( ).

[killa seven]

i had this problem on one of my plugins and thats how i fixed it

PHP Code:

$threadid = $vbulletin->db->query_first("
        SELECT threadid
        FROM " . TABLE_PREFIX . "thread
        WHERE pollid = '".$pollida."'
    ");

$checkpost = $vbulletin->db->query_read("
        SELECT username
        FROM " . TABLE_PREFIX . "post
        WHERE threadid = '".$threadid."'
    ");
while ($posts = $vbulletin->db->fetch_array($checkpost))
{
print_r($posts);
} 


try it like that

[Pandemikk]

That's what returns mysqli_result Object ( ).

[killa seven]

Originally Posted by Pandemikk

That's what returns mysqli_result Object ( ).

weird i didn't know vbulletin has mysqli methods.. could be wrong

its best practice to use $vbulletin-> if your using db->


always fixes most of my problems when i put it in

[Marco van Herwaarden]

In the following code, $threadid is an array with the contents of a single database row.

$threadid = $vbulletin->db->query_first("
       SELECT threadid
       FROM " . TABLE_PREFIX . "thread
       WHERE pollid = '".$pollida."'
   ");

So to use the threadid in the next query, you will need to use $threadid['threadid']:

$checkpost = $vbulletin->db->query_read("
       SELECT username
       FROM " . TABLE_PREFIX . "post
       WHERE threadid = ".$threadid['threadid']."

[Pandemikk]

Ahhh^

I should have known that!

Thanks Marco.

----

PHP Code:

$posthreadid = $vbulletin->db->query_first("
        SELECT threadid
        FROM " . TABLE_PREFIX . "thread
        WHERE pollid = '".$pollida."'
    ");

$checkpost = $vbulletin->db->query_read("
       SELECT username
       FROM " . TABLE_PREFIX . "post
       WHERE threadid = ".$posthreadid['threadid']."
    ");

while ($posts = $vbulletin->db->fetch_array($checkpost))
{
if ($posts['username'] != $vbulletin->userinfo['username'])
{
standard_error(fetch_error('bs_postfirst'));
}         
} 


The array is perfect. But how would I go about checking each result to $vbulletin->userinfo['username'] ?

I thought the above code would work.