\OC_DB::executeAudited(
'DELETE FROM `*PREFIX*grauphel_notes`'
. ' WHERE `note_user` = ? AND `note_guid` = ?',
- array($username, $guid)
- );
+ array($username, $guid)
+ );
}
/**
*/
public function loadNotesOverview($username, $since = null)
{
- $result = \OC_DB::executeAudited(
+ $result = \OC_DB::executeAudited(
'SELECT `note_guid`, `note_title`, `note_last_sync_revision`'
. ' FROM `*PREFIX*grauphel_notes`'
. ' WHERE note_user = ?',
- array($username)
- );
+ array($username)
+ );
- $notes = array();
- while ($row = $result->fetchRow()) {
+ $notes = array();
+ while ($row = $result->fetchRow()) {
if ($since !== null && $row['note_last_sync_revision'] <= $since) {
continue;
}
),
'title' => $row['note_title'],
);
- }
+ }
return $notes;
}
*/
public function loadNotesFull($username, $since = null)
{
- $result = \OC_DB::executeAudited(
+ $result = \OC_DB::executeAudited(
'SELECT * FROM `*PREFIX*grauphel_notes`'
. ' WHERE note_user = ?',
- array($username)
- );
+ array($username)
+ );
- $notes = array();
- while ($row = $result->fetchRow()) {
+ $notes = array();
+ while ($row = $result->fetchRow()) {
if ($since !== null && $row['note_last_sync_revision'] <= $since) {
continue;
}
$notes[] = $this->noteFromRow($row);
- }
+ }
return $notes;
}
'note-content' => $row['note_content'],
'note-content-version' => $row['note_content_version'],
- 'open-on-startup' => $row['note_open_on_startup'],
- 'pinned' => $row['note_pinned'],
+ 'open-on-startup' => (bool) $row['note_open_on_startup'],
+ 'pinned' => (bool) $row['note_pinned'],
'tags' => json_decode($row['note_tags']),
- 'last-sync-revision' => $row['note_last_sync_revision'],
+ 'last-sync-revision' => (int) $row['note_last_sync_revision'],
);
}