dovinci

Two more tweaks:

(1) To allow notes to be created WITHOUT explicitly listing users on the first line of the note, I had to remove the “NOT NULL” from the target_users db column, in the install script (in plugin.php).

(2) To allow notes to be draggable in Firefox, I had to change the last like of the calculateTopFix() function, in wpst_script.js. The last “else” clause is the one that is executed for Firefox, and returning the value scrollTop() causes the sticky note to move near the top of the page, as soon as any attempt is made to move the note at all. Instead, I changed it to “return 0”, and it works great.

I think that the problem is that, without explicitly adding users to a note, the “target users” list that is sent to the query is null (empty list).

In the install portion of plugin.php, this line is included in the db table create code:
target_users varchar(200) NOT NULL

So, the db table requires non-null values for target_users, but the code uses an empty list to indicate that there are no users explicitly associated with a note.

Anyone know how to fix this? I’m a php WordPress newbie.