Event add

[Reecey12345]

Hey guys, ive been trying to eventadd to my rating modification.

This is the line im using.

event_add($r['userid'],"<a href='viewuser.php?u=$userid'>{$ir['username']}</a> rated you down.");

 

This is my error.

QUERY ERROR: 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 'UNIX_TIMESTAMP(),0,'Reece rated you down.'' at line 1

Query was INSERT INTO events VALUES('',,UNIX_TIMESTAMP(),0,'Reece rated you down.')

Some help with this will be appreciated, i've been tweaking it for the past half hour and no luck

[W3Theory || Peter]

Never mind can't really read on this phone.

Edited March 21, 2014 by W3Theory || Peter

[Reecey12345]

I use this exact line in my Weekly Rewards also? < And it works perfect there.

[Razor42]

event_add($r['userid'],"<a href='viewuser.php?u=$userid'>{$ir['username']}</a> rated you down.",$c);

 

Try that

[Reecey12345]

event_add($r['userid'],"<a href='viewuser.php?u=$userid'>{$ir['username']}</a> rated you down.",$c);

 

Try that

I tried this one earlier, no luck :(

[Blade Maker]

Reecey, can you post the function code?

[W3Theory || Peter]

There seems to be something missing, I see a blank spot right before the Unix-Timestamp.

[Newbie]

Query was INSERT INTO events VALUES('',,UNIX_TIMESTAMP(),0,'Reece rated you down.')

has 2 , should be plus as pete stated there is a blank ''

Query was INSERT INTO events VALUES('',UNIX_TIMESTAMP(),0,'Reece rated you down.')

[Reecey12345]

As i said, that exact line i posted works perfectly fine with my Weekly Rewards there isn't any " missing

[KyleMassacre]

Your userid variable hasn't been instantiated yet. Which means your adding your function before the $r = $db->fetch_row($query). Just move it down a few lines.

Sensless plug:

or buy my Ajax player rating module from the MCC market place or my blog