iBugg - Just a blog. My blog.
Search This Blog
Thursday, December 14, 2023
[RO] Samsung Watch 6 (classic) - a real story and review
Sunday, October 16, 2022
How can you get started with the Lightning Network?
If you want to make transactions using the Lightning Network, you’ll need to send some BTC (for instance from your exchange account or another DeFi wallet) to a Lightning-compatible wallet. There are dozens to choose from. Popular options include both “custodial” and “non-custodial” wallets. Here’s the difference:
- Custodial wallets: Options include Strike, Blue Wallet (my favourite), or Wallet of Satoshi (find merchands and ATM). These tend to be good for beginners, because they simplify the sending and receiving crypto by managing your private keys. If, for instance, you lose your password, you’ll be able to reset it.
- Non-custodial wallets: Options include Muun, Breez (my favourite, designed for easy accept POS type payments, backup on google account), Phoenix, or Zap. These wallets are user-controlled and popular with more experienced traders — nobody but you has your private keys (on local device). If you lose or damage your wallet or forget your password, you could lose access to your funds. So make sure you learn first how to back up or restore whichever wallet you choose.
Friday, August 05, 2022
[RO] Am testat un TDS Meter Digital !
Sunday, July 11, 2021
Curve card anti-embarrassment option
This opportunity was absolute necessary as since 1 January you need to authorize the card transactions with 3DSecure, some sort of SCA (Strong Customer Authentication). So practically AutoTopUps like the ones from Revolut are somewhat "illegal":
https://www.reddit.com/r/Revolut/comments/kvn31m/auto_topup_is_no_longer_working_since_3d_secure/
So how this functionality it is helping you? Simple, you can define the fallback cards that can be used instead the ones that have no money in it because you didn't autotopup on time. More details here (experience is a must);
https://www.curve.com/features/anti-embarrassment-mode/
https://www.facebook.com/curvebg/videos/856447988499980/
https://support.imaginecurve.com/hc/en-gb/articles/360016571938-How-do-I-set-my-backup-cards-up-
Tuesday, June 22, 2021
Having a Program from Startup folder (current user or all) start AGAIN - Windows 10 issue
Has not been a while at all since Windows 10 surprized everybody with bugs all over again... I was pissed off fr two days of looking for an answer why some programs do not want to start automatically when droped off on Startup folder (for current user or for All users, doesn't matter). Lot of stupid answers from people from microsoft that recommend to do a sfc scan. Luckily, most of us are not so stupid to screw up other things trying to fix simple ones.
Most of us using UAC to never notify previously in the upgraded windows version but in my case was a clean install as after some updates period promrams on startup ceased to work.
Wednesday, September 16, 2020
Back in time... looking for queen's gambit...
Digging into my dusted desk found a blue (paper!) notebook with yellow pages....
Suddently a thumbeling memory came over my eyes and remembered a chess play in my youth competitions where at the opponent black move 24...Tfe8 , I exclaimed in a silenced room: "Mate in 5 or 6 moves...!". ...One of a lifetime maybe...
I found it interesting that at 28 depth analysis chess.com (Stockfish) didn't find the forced checkmate :o
Monday, September 07, 2020
[RO] Samsung Pay in Romania - inca nu curand, dar exista o solutie!
O veste buna este ca accepta mai multe tipuri de carduri de la diferiti provideri/banci/fintechs.
Saturday, March 07, 2015
How to disable SSLv3 in Firefox
security.tls.version.max = 3 (default is 3)
security.tls.version.min = 2 (default is 0)
min/max=0: SSLv3
min/max=1: TLSv1.0
min/max=2: TLSv1.1
min/max=3: TLSv1.2
Tuesday, July 08, 2014
The Republic Pub - Old City Center
Monday, February 03, 2014
Why NOT share GPS coordinates location with others?!...
Friday, January 22, 2010
Shrink your Quest Performance v6.x database
-- v1.3
USE master
DECLARE @vINSTANCE varchar(255), @vDATABASE sysname
DECLARE @vKILL_TIME int, @vKILLCONNECTIONS int, @vSINGLEMODE int, @vREINDEX int, @vUPDATESTATISTICS int, @vSHRINK int
DECLARE @vPROC varchar(255), @var4 varchar(255), @var5 int, @var6 int, @st datetime, @sti int, @var7 varchar(255), @name sysname, @txt_db NVARCHAR(255)
-- Compulsory variables
SET @vINSTANCE='SERVER\INSTANCE'
SET @vDATABASE='Quest_Perf_Analysis'
-- Options variables
SET @vKILL_TIME=0
SET @vKILLCONNECTIONS=1
SET @vSINGLEMODE=1
SET @vREINDEX=1
SET @vUPDATESTATISTICS=1
SET @vSHRINK=1
-- Initialize variables
set @vPROC=0
set @var5=0
set @var6=0
if @vSINGLEMODE=1
BEGIN
print '.'
print 'Set multiuser database ['+@vDATABASE+']...'
EXEC sp_dboption @vDATABASE, 'single user', 'false'
END -- @vSINGLEMODE
if @vKILLCONNECTIONS=1
BEGIN
print '.'
print 'Kill processes for database ['+@vDATABASE+']...'
WHILE EXISTS (select * FROM master.dbo.sysprocesses WHERE db_name(dbid)=@vDATABASE and login_time
BEGIN
SELECT TOP 1 @vPROC =spid from master.dbo.sysprocesses where db_name(dbid)=@vDATABASE and login_time
EXEC ('kill '+ @vPROC)
PRINT ('Kiled... ' + @vPROC)
WAITFOR DELAY '000:00:01'
END
-- Show not sleeping!
select db_name(dbid),* from master.dbo.sysprocesses where db_name(dbid)=@vDATABASE order by login_time
END -- @vKILLCONNECTIONS
if @vSINGLEMODE=1
BEGIN
print '.'
print 'Set singleuser database ['+@vDATABASE+']...'
EXEC sp_dboption @vDATABASE, 'single user', 'true'
END -- @vSINGLEMODE
-- BEGIN PURGE
select @txt_db = 'declare c1 cursor for (select name from '+@vDATABASE+'.dbo.sysobjects where xtype=''U'' and name<>''QUEST_INSTANCE_DIM'')'
exec(@txt_db)
IF EXISTS (SELECT name FROM [tempdb].dbo.sysobjects
WHERE name = '##_ExecOutput' AND type = 'U')
DROP TABLE ##_ExecOutput
select @txt_db = 'select INSTANCE_KEY into ##_ExecOutput from '+@vDATABASE+'.dbo.QUEST_INSTANCE_DIM where '''+@vINSTANCE+'''=HOST'
exec(@txt_db)
select @var4 = INSTANCE_KEY from ##_ExecOutput -- INSTANCE_KEY from ##_ExecOutput
DROP TABLE ##_ExecOutput
print '.'
print '. Instance no. for '+@vINSTANCE+' is '+@var4
print '.'
open c1
fetch next from c1 into @name
WHILE @@FETCH_STATUS = 0
BEGIN
set @var5=@var5+1
fetch next from c1 into @name
END
close c1
open c1
fetch next from c1 into @name
WHILE @@FETCH_STATUS = 0
BEGIN
set @st = getdate()
set @var6=@var6+1
print '. '+CAST(@var6 AS char(4))+' / '+CAST(@var5 AS char(4))
print 'Deleting instance references from... "'+@vDATABASE+'.dbo.'+@name+'"'
SELECT @txt_db='DELETE '+@vDATABASE+'.dbo.'+@name+' WHERE '+@var4+'=INSTANCE_KEY'
print 'Executing: '+@txt_db
EXEC(@txt_db)
if @vREINDEX=1
BEGIN
print 'Reindexing... "'+@vDATABASE+'.dbo.'+@name+'"'
SELECT @txt_db='DBCC DBREINDEX ('''+@vDATABASE+'.dbo.'+@name+''')'
print '[SQL]: '+@txt_db
EXEC(@txt_db)
END -- @vUPDATESTATISTICS
if @vUPDATESTATISTICS=1
BEGIN
print 'Update statistics... "'+@vDATABASE+'.dbo.'+@name+'"'
SELECT @txt_db='UPDATE STATISTICS '+@vDATABASE+'.dbo.'+@name+' with FULLSCAN, ALL'
print '[SQL]: '+@txt_db
EXEC(@txt_db)
END -- @vUPDATESTATISTICS
set @sti=cast(datediff(ss,@st,getdate()) as int)
print 'Batch completed in: ' + rtrim(CONVERT(varchar(6), @sti/3600)+ 'h:' + RIGHT('0' + CONVERT(varchar(2), (@sti % 3600) / 60), 2)+ 'm:' + RIGHT('0' + CONVERT(varchar(2), @sti % 60)+'s', 2)) + ' !'
print '.'
fetch next from c1 into @name
END
close c1
deallocate c1
-- END PURGE
if @vSHRINK=1
BEGIN
print '.'
print 'Shrinking database ['+@vDATABASE+']...'
backup log @vDATABASE with no_log
DBCC SHRINKDATABASE (@vDATABASE, 0)
END -- @vSHRINK
if @vSINGLEMODE=1
BEGIN
print '.'
print 'Set multiuser database ['+@vDATABASE+']...'
EXEC sp_dboption @vDATABASE, 'single user', 'false'
END -- @vSINGLEMODE
print '*** If all ok delete manually from QUEST_INSTANCE_DIM the row with HOST='+@vINSTANCE+' ! ***'
-- Observations
/* ALTER TABLE [dbo].[QUEST_TIME_DIM] ADD
CONSTRAINT [QUEST_TIME_DIM_FK1] FOREIGN KEY
(
[PYRAMID_LEVEL]
) REFERENCES [dbo].[QUEST_CTRL_PYRAMID_LEVELS] (
[LEVEL_ID]
) ON DELETE CASCADE
GO */
SQL 2000 - Full reindex, repair script
Here you go one, you are free to adapt it to newest SQL versions!
-- v2.5
USE master
DECLARE @vDATABASE sysname
DECLARE @vKILL_TIME int, @vKILLCONNECTIONS int, @vSINGLEMODE int, @vREPAIR_CATALOG int, @vREPAIR int, @vREPAIR_TYPE varchar(255), @vREINDEX int, @vUPDATESTATISTICS int, @vSHRINK int
DECLARE @st datetime, @sti int, @vPROC varchar(255), @vOWNER varchar(255), @vUID nvarchar(255), @var5 int, @var6 int, @vTEMP varchar(255), @name sysname, @txt_db NVARCHAR(255)
-- Compulsory variables
SET @vDATABASE='YOUR_DATABASE_NAME_HERE'
-- Options variables
SET @vKILL_TIME=0
SET @vKILLCONNECTIONS=1
SET @vSINGLEMODE=1
SET @vREPAIR_CATALOG=1
SET @vREPAIR=1
SET @vREPAIR_TYPE='REPAIR_ALLOW_DATA_LOSS'
SET @vREPAIR_TYPE='REPAIR_FAST'
SET @vREPAIR_TYPE='REPAIR_REBUILD'
SET @vREINDEX=1
SET @vUPDATESTATISTICS=1
SET @vSHRINK=1
--SET @vOWNER='dbo'
-- Initialize variables
set @vPROC=0
set @var5=0
set @var6=0
if @vSINGLEMODE=1
BEGIN
print '.'
print 'Set multiuser database ['+@vDATABASE+']...'
EXEC sp_dboption @vDATABASE, 'single user', 'false'
END -- @vSINGLEMODE
if @vKILLCONNECTIONS=1
BEGIN
print '.'
print 'Kill processes for database ['+@vDATABASE+']...'
print '.'
WHILE EXISTS (select * FROM master.dbo.sysprocesses WHERE db_name(dbid)=@vDATABASE and login_time
BEGIN
SELECT TOP 1 @vPROC =spid from master.dbo.sysprocesses where db_name(dbid)=@vDATABASE and login_time
EXEC ('kill '+ @vPROC)
PRINT ('Killed process number: ' + @vPROC)
WAITFOR DELAY '000:00:01'
END
-- Show not sleeping!
select db_name(dbid),* from master.dbo.sysprocesses where db_name(dbid)=@vDATABASE order by login_time
END -- @vKILLCONNECTIONS
if @vSINGLEMODE=1
BEGIN
print '.'
print 'Set singleuser database ['+@vDATABASE+']...'
EXEC sp_dboption @vDATABASE, 'single user', 'true'
END -- @vSINGLEMODE
if @vREPAIR_CATALOG=1
BEGIN
print '.'
print 'Repair database ['+@vDATABASE+'] catalog...'
dbcc checkcatalog (@vDATABASE,@vREPAIR_TYPE) WITH ALL_ERRORMSGS
END
if @vREPAIR=1
BEGIN
print '.'
print 'Repair database ['+@vDATABASE+'] with '+@vREPAIR_TYPE+' option...'
dbcc checkdb (@vDATABASE,@vREPAIR_TYPE) WITH ALL_ERRORMSGS
END
if @vREINDEX=1
BEGIN
select @txt_db = 'declare c1 cursor for (select name from '+@vDATABASE+'.dbo.sysobjects where xtype=''U'''
-- try to introduce OWNER
-- select top 1 @vUID=uid from @vDATABASE.dbo.sysusers where name like @vOWNER
-- if (@vOWNER<>'') and (@vUID>0)
-- BEGIN
-- set @txt_db = @txt_db+' and uid='+@vUID
-- END
set @txt_db =@txt_db+')'
exec(@txt_db)
open c1
fetch next from c1 into @name
WHILE @@FETCH_STATUS = 0
BEGIN
set @var5=@var5+1
fetch next from c1 into @name
END
close c1
open c1
fetch next from c1 into @name
WHILE @@FETCH_STATUS = 0
BEGIN
set @st = getdate()
set @var6=@var6+1
print '. '+CAST(@var6 AS char(4))+' / '+CAST(@var5 AS char(4))
print 'Reindexing... "'+@vDATABASE+'.dbo.'+@name+'"'
SELECT @txt_db='DBCC DBREINDEX ('''+@vDATABASE+'.dbo.'+@name+''')'
print '[SQL]: '+@txt_db
EXEC(@txt_db)
print 'Update statistics... "'+@vDATABASE+'.dbo.'+@name+'"'
SELECT @txt_db='UPDATE STATISTICS '+@vDATABASE+'.dbo.['+@name+'] with FULLSCAN, ALL'
print '[SQL]: '+@txt_db
EXEC(@txt_db)
set @sti=cast(datediff(ss,@st,getdate()) as int)
print 'Batch completed in: ' + rtrim(CONVERT(varchar(6), @sti/3600)+ 'h:' + RIGHT('0' + CONVERT(varchar(2), (@sti % 3600) / 60), 2)+ 'm:' + RIGHT('0' + CONVERT(varchar(2), @sti % 60)+'s', 2)) + ' !'
print '.'
fetch next from c1 into @name
END
close c1
deallocate c1
END -- vREINDEX
if @vSHRINK=1
BEGIN
print '.'
print 'Shrinking database ['+@vDATABASE+']...'
backup log @vDATABASE with no_log
DBCC SHRINKDATABASE (@vDATABASE, 0)
END -- vSHRINK
if @vSINGLEMODE=1
BEGIN
print '.'
print 'Set multiuser database ['+@vDATABASE+']...'
EXEC sp_dboption @vDATABASE, 'single user', 'false'
END -- @vSINGLEMODE
print '.'
select 'Finished! Check messages tab!'
Thursday, November 26, 2009
Heroes Of Might And Magic 2 - Saved Game Editor
It can be founded HERE. Enjoy...
Thursday, November 19, 2009
Clue, Enigma (ro) strategy game solution finder / helper
Some time ago, playing with my friends the Romanian strategy game variant of the well known Clue(do), wondered if there any possibility finding the solution more efficient (excluding luck of course). Searching through the net I only founded mathematical essays about this. Nah, too complicated. So I started tracking of inputs (answers) in Excel... Hmm, is not enough... I need more... and look at me playing with VBA help and sheets cells. Wow... some little arrangements, some lost days and I got an Enigma little helper. I didn't use some complicated AI algorithm, elimination criterias were just enough to beat my friends in minimal moves.
You can find it HERE in Romanian language.
If you like it just drop a word... or two ;)
Friday, September 11, 2009
Using CSD with phone modem - error 678
So in phone registry here
HKEY_LOCAL_MACHINE\DRIVERS\Unimodem\Init
The key 1 value changed from
AT<>
to
AT+CGDCONT =1,"IP","AP_name_from_provider"
It was not working for me, so I must set the initialization on every computer I use with my phone on the "Bluetooth Modem" device.
Tuesday, September 01, 2009
PPC Internet explorer - blank page - possible solution
Hardware: Tytn II, WM61 or WM60
Before ANY other workarounds from the web check first for a folder named "ConnMgr" in the root which holds a binary file "CMMapG" and a text one "CMMapP" which contain
the following lines:
ftp://*/*
wsp://*/*
wsps://*/*
*://*.*/*
*://*/*
If not, try to restore at least the binary one from a backup :)...
WindowsMobile 6.1 rSAP not working on boot
The connection is working ONLY AFTER going to bluetooth panel, rsap and just click OK (lol).
I found some interesting settings:
[HKEY_LOCAL_MACHINE\Software\Impulsesoft\Bluetooth\ SAP]
"Running"=dword:00000001
"SAPServerCmd"=dword:00000002
"Version"="3.1"
"ConnDevName"="VW UHV PREM"
Just changed "SAPServerCmd" to 1 and i am going outside to test it...
Values
"Running"=dword:00000000
"SAPServerCmd"=dword:00000003
are for disabling it
...
Got it finally, i found that the program "SAPSettings.exe" must be run at startup! Just put a shortcut in Windows\StartUp folder. Of course, it will use the first registry settings above.