carpii

#!/bin/sh
USER=`whoami`
LOGFILE="/home/${USER}/1password.log"
D=`date +"%Y/%m/%d %H:%M:%S"`
echo "=======================================" >> ${LOGFILE}
echo "${D} - LAUNCHING WATCHER" >> ${LOGFILE}

inotifywait -m -e close_write,moved_to,create,delete,modify --format '%:e %f' --excludei "chromium|Network changed|sqlite" ~/.config/1Password | while read -r filename; do
  REGEXP='(Singleton[^ ]*)'
  D=`date +"%Y/%m/%d %H:%M:%S"`

carpii

#!/bin/sh

# Disables invalid memory notifications on Synology NAS (including the notifications in DiskStation itself)
# these warnings occur when you use perfectly compatible RAM, which is not Synology branded
#
# Modify `MANUFACTURER` and `DBFILE` to match your environment (DBFILE will be the filename of the .db in DBPATH)
# Use Synology Task Scheduler to run it on boot, as root user
# Finally run `sudo ~/disable_ram_warning' 

# This script is safe to run repeatedly, and will also work if Synology update DiskStation later, and make additions to the db file

carpii

	drop table temp_times;
	create table temp_times (id int, user_id int, start_time datetime, end_time datetime);
	insert into temp_times (id, user_id, start_time, end_time) values (1, 1, '2013-01-01 13:45', '2013-01-01 15:50');
	insert into temp_times (id, user_id, start_time, end_time) values  (2, 1, '2013-01-01 10:00', '2013-01-01 13:20');
	insert into temp_times (id, user_id, start_time, end_time) values  (3, 1, '2013-01-01 15:00', '2013-01-01 16:02');
	insert into temp_times (id, user_id, start_time, end_time) values  (4, 1, '2013-01-01 08:10', '2013-01-01 09:10');
	insert into temp_times (id, user_id, start_time, end_time) values  (4, 1, '2013-01-02 09:10', '2013-01-01 11:55');

	insert into temp_times (id, user_id, start_time, end_time) values (1, 2, '2013-01-01 13:45', '2013-01-01 15:50');
	insert into temp_times (id, user_id, start_time, end_time) values  (2, 2, '2013-01-01 10:00', '2013-01-01 13:20');

carpii

id          effectiveDate                                          daysSinceLastPayment type                 amount         totalPrincipal totalFees      totalPayments  totalInterest  balance        
----------- ------------------------------------------------------ -------------------- -------------------- -------------- -------------- -------------- -------------- -------------- -------------- 
1           2012-11-07 22:58:15.000                                NULL                 PRINCIPAL            .00000         .00000         .00000         .00000         .00000         .00000
2           2012-11-08 22:58:15.000                                NULL                 PRINCIPAL            150.00000      150.00000      .00000         .00000         .00000         150.00000
3           2012-11-09 22:58:15.000                                NULL                 PRINCIPAL            100.00000      250.00000      .00000         .00000         .00000         250.00000
4           2012-11-10 22:58:15.000          

carpii

SET NOCOUNT ON;

-- declare memory table 
DECLARE @totals TABLE (id int not null, effectiveDate datetime, daysSinceLastPayment int, type varchar(20), amount decimal(12,5), totalPrincipal decimal(12,5), totalFees decimal(12,5), totalPayments decimal(12,5), totalInterest decimal(12,5), balance decimal(12, 5))

insert into @totals (id, amount, type) select id, amount, type from finance

-- populate with some pretend dates 
update @totals set effectiveDate = DATEADD(DD, -100+id, DATEADD(MM, -6, GETDATE()));

carpii

CREATE TABLE [finance] (
  [id] [int] IDENTITY (1, 1) NOT NULL ,
	[amount] [decimal](10, 4) NULL ,
	[type] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO

insert into finance (amount, type) values (0.0000,'PRINCIPAL');
insert into finance (amount, type) values (150.0000,'PRINCIPAL');
insert into finance (amount, type) values (100.0000,'PRINCIPAL');