Search This Blog

Thursday, December 14, 2023

[RO] Samsung Watch 6 (classic) - a real story and review

I will not post it in English, please use translate as needed.

Sunt multe articole legate de aceste device uri, cele mai multe sunt aiurea si nu reflecta realitatea sau nu acopera toate punctele de vedere care pentru unii sunt importante. Singurul loc din care mai puteti intelege sau puteti face ceva cu informatia respectiva e forumul XDA, multi il cunosc deja de decenii.
Deci, am foat nevoit oarecum sa renunt la cel mai bun ceas (inca este) facut pana acum din toate punctele de vedere (software, integrare, hardware, usability, fumctionalitati etc, absolut tot), Gear S3 Frontier. Am gasit o versiune F (Singapore) cu LTE, senzor O2 si automat Samsung Pay (legat de plati am alt articol). Dupa aproape 6 ani in care bateria inca ma tine 1,5 zile (uz normal, notificari multe, 2-3 apeluri scurte, fara browsing sau ascultat muzica, toate conexiunile si senzorii active inclusiv locatia), am ramas fara posibilitatea de a mai apasa pe butoane dupa ce am intrat in apa, nu diving, inot de suprafata fara balaceala. Problema ca fiind prea vechi zonele de imbinare s au cam copt, cauciucul care era pe butoane pur si simplu s a transformat in nisip. Nu i nimic, o sa l duc la reparat sper sa nu coste cat unul nou, nu vreau sa renunt la el inca.
Sa revenim, deci ce fac, ce optiuni am?
Dupa 2 zile de cautari am decis sa merg pe aceeasi varianta Samsung. As scrie aici un roman daca ar fi sa va povestesc despre criteriile mele de alegere, in orice caz suntem in 2023, vroiam ceva matur si complet. Grea decizie, inca nu s a inventat asa ceva.
Ok, l am primit si i am dat drumul :)
Deci, sa trecem la niste chestii pe care nu le gasesti asa usor pe net.
(Btw nu mai sunt adeptul root de mult timp, genereaza mai multe probleme decat ai nevoie)

1. Vrei Samsung Pay? Am scris un alt articol legat de asta dar, pentru a l folosi, cel mai bine de la inceput setezi regiunea pe o tara ce accepta acest lucru (de ex. Elvetia), nu ai nevoie de ADB, firmware sau alte prostii. Limba puteti sa o puneti ce vreti (romana, engleza etc). O decizie deloc usoara daca nu pui alt firmware fiindca trebuie sa te gandesti ce alte functionalitati mai doresti si sunt acceptate in tara respectiva. Btw, in UE mie mi se pare o discriminare acest lucru si o bataie de joc la adresa consumatorilor, nu mai vorbesc de waste of money din partea companiilor, dar e parerea mea si nu vreau sa intru in polemici.
De ce SPay si nu raman la GPay? Fiindca imi place sa am backup, in GPay am avut issueuri legate de labels, stergere sau adaugare carduri. Am trecut prin toate si cu multi nervi lucrurile durand luni de zile.

2. Pierzi f mult timp cu initializarea, din 10 incercari marea majoritate se opresc la 86% si poti sa astepti si 3 zile ca nu stii ce se intampla, in background e de fapt un mesaj de eroare generic care nu se vede, cu try again, si o iei de la inceput.
Nu faceti niciodata unpair, fiindca o luati de la inceput pentru poate cateva ore. Asta in conditiile in care, cel mai important lucru, momentan NU se poate face backup la setari si aplicatii pentru GW6 din Wear Manager. Multe chestii duc cu gandul ca a fost lansat in graba si nu au fost terminate.

3. Noroc ca mai exista baieti skilled pe XDA, puteti pune 2 aplicatii utile (must have!) pentru ADB debugging dupa ce ati activat developer options:



4. O schimbare care te pune in incurcatura fata de cum eram obisnuit si era natural pentru dreptaci, butoanele Home si Back sunt acum inversate iar PowerOn e long press Home. Nu stiu de la ce versiune a aparut aceasta schimbare dar pe mine nu ma incanta, mai ales la Back.

5. Chiar daca ceasul este mai mare si pare mai bine finisat, cine a folosit S3 nu o sa fie incantat de bezel, acea rotita de pe marginea ecranului, aceasta se misca foarte greu si miscarile iti dau o inertie imprecisa a pozitiei in care se afla.

6. Am incercat pe doua telefoane diferite AutoSwitch care functioneaza corect in functie de ce ceas folosesti numai ca dupa un switch se cam blocheaza Managerul care arata ca e conectat dar ceasul nu. Dupa restart bluetooth fiind oprit wifi isi revine. Nu prea poti sa te bazezi pe acest "switch".

7. Destul de enervant la GPay, la cateva plati (nu m am prins de regula) da deny si trebuie sa introduc din nou paternul. Am pus pattern si nu pin tocmai din aceasta cauza, ca e mai usor de repetat mai des, chiar daca este mai "vizibil" (shoulderspy). Interesant este ca SPay nu face asta si are acea vibratie care iti spune ca e activ. Si din aceasta cauza am vrut sa ambele optiuni de plata.

8. Hey Bixby de ce nu stii unde ma aflu? Cautand pe web se pare ca e o problema veche pe Watch >= 4 (network services unavailable). Pe Tizen S3 merge perfect.
Hey Google dar tu stii? Nope, nu stie decat Home location...

9. Ah am uitat de cradle-ul de incarcare, acea pastila mica pe care de abia o nimeresti cand vrei sa ti pui ceasul la incarcat. Cel de S3, efectiv puteai sa ti arunci ceasul spre el, fiind ceva mai greu decat GW6, se pozitiona imediat, imaginea se rotea 90gr si se transforma intr un frumos ceas de masa. Nu, nu se potriveste cel de S3, incepe sa se incarce dar se opreste dupa cateva secunde. Am cautat, dar nu am gasit ceva similar de util.

10. Revin la UI, punctul de notificari este foarte mic in comparatie cu dimensiunea ecranului si nu mai este vizibil daca ai deja una din notificari vizibila pe ecran (de obicei ultima, in urma ridicarii mainii). In mod normal trebuie sa stii ca mai ai necitite, nu?
De bine ce ai ridicat mana sa citesti mesajul, ramai fara face AOD pentru 20s, 2m, sau 1h in functie de setarea de Show last app / Display, fiind afisat doar un ceas mic in partea de sus.

11. O chestie foarte ciudata cand folosesc GPay, avand selectat un card (e mare pe ecran :)) ajung sa platesc cu altul (cel default)! Deci mare atentie!
Pe SPay/S3 nu mi s a intamplat asa ceva asta deoarece nu exista notiunea de default card, cel vizibil este cel cu care platesti, pe GW6 nu am decat unul inregistrat momentan in SPay.

12. Quick shortcut (acel gesture facut scurt de doua ori cu pumnul in jos): nu functioneaza, merge deatul de greu in demo testing, in realitate ma doare mana de la cat am exersat, so completly unreliable.
By the way, stau sa ma gandesc de cate ori trebuie sa cazi pana se activeaza emergency call? Freaky thoughts...

13. Nicio aplicatie nu poate face play pe ceas, yt spoty etc.! Singura care a inteles utilitatea si sa ma lase sa ma gandesc eu la baterie este SoundCloud dar la asta nu platesc licenta...

14. Extrem de enervanta plata cu GPay, asa cum ajungi sa platesti cu alt card, foarte des te pune sa introduci pinul sau patternul chiar daca nu ai dat ceasul de la mana jos! Vad ca este un issue bine stiut :/

15. Nu stiu de ce nu am scris pana acum, iconita de wifi nu stii daca este pe auto sau nu, unii spun ca nu mai conteaza, dar mi ar fi placut sa fiu mai in control pentru acest lucru. Fata de S3 in schimb ai in drop down o iconita de bluetooth (pentru LTE chiar ai nevoie sa stii cand e activ).

16. O alta mare problema Samsung, nu pot folosi cardul inrolat in SPay cu doua ceasuri!
La autoswitch se sterg datele de pe celalalt ceas si iar trebuie sa adaug cardul, jeez...

Deja la cate probleme intampin personal, ma gandesc serios sa fac retur si sa mi repar S3 dar pentru care suport software nu o sa mai existe mult timp :/...

17. Problema cu backupul este foarte serioasa, m a dat inapoi cu 3 luni dupa ce telefonul a luat o eroare si nu se mai putea sincroniza. Nu am gasit solutie de restore. Nu se poate recupera nimic din setari, mi se pare o bataie de joc imensa la adresa consumatorului care nu se izbeste din prima zi de toate problemele. Overall cred ca a foat o greseala enorma in a l achizitiona.
UPDATE: backupul functioneaza acum dar atentie, doar in teorie, nu se restaureaza nici setarile, nici faces nici aplicatiile ! Incredibil cat timp poti sa pierzi cu un produs scos in bataie de joc.

18. Dupa cateva luni de folosire bateria nu mai tine mai mult de o zi fara sa fac nimic deoaebit pe el. Estimarea data de 3 zile la 100% se micsoreaza cu fiecare minut.
Nici dupa 2 update uri mai nimic de ux nu s a rezolvat din ce am scris mai sus.
Inca ceva, daca vrei "watch only" nu il gasesti asa usor prin meniu. Pe S3 era pe meniul drop down si mai mult, mergea repede.

Concluzia o trageti voi....

Nota bene, cam toate aceste observatii pe care le am mentionat mai sus nu exista pe S3 Tizen, experienta pe acest ceas a fost din punctul meu de vedere impecabila. Si nu e vorba de obisnuinta, ci de naturaletea folosirii lui.

Ok gook luck then, pentru orice alte detalii la eventualele intrebari si nelamuriri o sa updatez acest post.

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 !



    Poate nu este chiar asa de tarziu, dar am considerat ca este necesar sa achizitionez un device (TDS metru model JQ-006) de masurare a calitatii apei ce o bem zi de zi. Masuratorile sunt aproximative dar iti dau oarecum o idee de ce sa faci mai departe.


 

                                            pH        TDS        EC        ORP                                    
Apa robinet                                    7.3        110        215       +170
Apa robinet prin filtru Samsung     7.3        100       210       +170
Aqua Carpatica 5L                         7.3        120       240       +160

pH:        acida < 7.0 < ok < 8.5 < alcalina

TDS (ppm - particles per milion) (Total Dissolved Solids): suma solidelor dizolvate in lichid (saruri, minerale, metale) si este masurata prin conductivitatea lichidului, a numarului de particule de ioni din nr total de milioane de particule (ppm). O valoare aproape de 0 inseamna ca este o apa pura (prea pura totusi, fiindca avem nevoie si de minerale si saruri)

EC (µS - micro siemens): practic masoara acelasi lucru ca si TDS, difera doar formulele de calcul

ORP (mV - mili volt) (Oxidation Reduction Potential): intre +150 si +550 apa este buna de baut

Aici doar le-am sumarizat un pic cu ce am testat, fiindca gasiti o tona de informatii la o simpla cautare pe internet.


Sunday, July 11, 2021

Curve card anti-embarrassment option


In this post I only want to share my experience that i had lately (few times this year already) using the "Embarrassment" option from Curve card product that i talked about a while ago (i not sponsored in any way nor affiliated, i just liked the experience for a long time).

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-

If you liked the article and you don't have Curve yet you can try it and register by using my referral here and clicking this phrase!

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.


So the solution is by changing the EnableLUA to 0:
Run > Regedit: Set the key: HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows \ CurrentVersion \ Policies \ System \ EnableLUA to 0

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!

Nu am mai postat de foarte mult timp deoarece Google+ a iesit din cursa si eram obisnuit cu el. M-am gandit ca acest post ajuta pe careva dintre noi...

Din pacate nici la ora actuala Samsung Pay nu se poate folosi direct cu vreun card al unei banci din Romania.
Vestea buna este ca de cateva luni de la momentul postarii Curve are carduri acceptate de catre Samsung. Iar aplicatia Curve este disponibila si pentru utilizatorii din tara noastra! Varianta free accepta orice card de la noi deci nu ramane decat sa-l downloadati din Google Play, sa va inregistrati, asteptati cardul astfel generat undeva intre 3 zile si 3 saptamani (aprox). Nu cred ca mai au treaba cu Wirecard dar oricum e bine de utilizat sume mici ;). Inregistrati cardul astfel primit in Samsung Pay and you are good to go!

UPDATE 2022-08-05: Din pacate pentru a putea tine mai mult de 2 carduri in portofoliu Curve au introdus de curand subscriptions (X, Black si Metal), deci daca aveti intre 3 si 5 carduri pentru planul X trebuie sa scoateti din buzunar 1,99 GPB ~ 11.63 RON.
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

How to disable SSLv3 in Firefox > 25 from within about:config page:
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

The Double Dip - hummus and eggplant

Delicious ribs, fries with garlic and parmezan, pork hamburger and schnitzel 
 
Taste:    ****

Location: ****
Service:  ****
Price:    ****

Monday, February 03, 2014

Why NOT share GPS coordinates location with others?!...

I remember this feature was part of either latitude or google map. Yesterday when I looked it up on Android and tried to use it, it was nowhere to be found, was removed in 2012. Latitude got replaced with Maps. But I should be able to do it from Google Maps. Select where you are, click the bubble that pops up & there should be a "Send location to others" option. Hehe, not anymore! With latest updates the coordinates are replaced with just a tiny url. I really recommend people that use plain and they are not phone geeks, to further use iPhone, you will be located more easily :P, hmm or maybe not, get an ancient compass... Anyway, thanks google!

Friday, January 22, 2010

Shrink your Quest Performance v6.x database

Did you ever wanted to shrink your Quest Performance v6.x Database from a SQL 2000? Uninstalling the agent don't always get rid you of the data for a specified instance, so here is a script that do this...

-- 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

Did you ever wanted to completly rebuild, repair, index, compute statistics a SQL 2000 database?
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

Oldies but goldies... There are plenty of saved game editors for the version 2 of the Heroes of Might and Magic II game if you search on the net, but mine is more "visual". It is so old that I forgot about it, lol.
It can be founded HERE. Enjoy...


Other basic editor can be found HERE as the original link don't work anymore.

Thursday, November 19, 2009

Clue, Enigma (ro) strategy game solution finder / helper

My first post ever, glad to meet you!

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

I searched a lot and seems that on my Tytn II with latest WM6.1 stock rom from HTC it is not possible to use initialization commands through a dial-up (to *99#) from my pc.
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

Symptoms: internet explorer gets a blank page or "page cannot be found" when opened a site. No proxy set, Opera browser working or any other tcp program works fine.
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

Every time that I reboot my Tytn II the rSAP from my car is not working even if the settings are correct on bluetooth config panel (allow access).
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.