/*UPDATEREVISION*/
INSERT INTO site (`setting`, `value`, `updateddate` ) VALUES ('dbversion', '$Rev: 3212 $', now()) ON DUPLICATE KEY UPDATE `value` = VALUES(`value`), updateddate=now();

/*PATCHHERE*/
ALTER TABLE users ADD COLUMN nzbgeturl VARCHAR(255) NULL DEFAULT NULL;
ALTER TABLE users ADD COLUMN nzbgetusername VARCHAR(255) NULL DEFAULT NULL;
ALTER TABLE users ADD COLUMN nzbgetpassword VARCHAR(255) NULL DEFAULT NULL;

INSERT IGNORE INTO `site` (`ID` , `setting` , `value` , `updateddate` )
  VALUES ( NULL ,  'nzbgeturl',  '', NOW( ));

INSERT IGNORE INTO `site` (`ID` , `setting` , `value` , `updateddate` )
  VALUES ( NULL ,  'nzbgetusername',  '', NOW( ));

INSERT IGNORE INTO `site` (`ID` , `setting` , `value` , `updateddate` )
  VALUES ( NULL ,  'nzbgetpassword',  '', NOW( ));

update menu set tooltip = 'View Your Download Queue', menueval = '{if (($userdata.saburl|count_characters+$userdata.nzbgeturl|count_characters == 0) && $site->sabintegrationtype==2) || $site->sabintegrationtype==0}-1{/if}'
where menueval = '{if ($userdata.saburl == '''' && $site->sabintegrationtype==2) || $site->sabintegrationtype==0}-1{/if}';
