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.


$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'.

$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

$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]

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.

----

$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.

[Marco van Herwaarden]

And what still doesn't work now? On first sight it looks ok.

[Pandemikk]

All users are getting you must post before voting error messages even if they have posted before.

[killa seven]

$pollida = $pollinfo['pollid'];


$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'));
}
}

on line 4 you don't have $pollida equal to anything i fixed it

[Pandemikk]

I have $pollida = $pollinfo['pollid']; earlier in my code.

[Pandemikk]

Bump

[Pandemikk]

bump