Author Archives: Thomie Jose San Agustin

About Thomie Jose San Agustin

He is a Microsoft Certified Professional whom develop different website using ASP .NET MVC and PHP. He can also create systems out of C#. A Magna Cum Laude of Adamson University whom started a Freelance company named i-CT Combinatorics Technology with his friend Calbin Montalban. He accepts both Website and System development and even can help now his colleagues in generating their logic and research.

PhoneGap Installation Guide – Windows

Hi,

Since we need to have a guide for our teammate I have decided that instead of teaching how to install one by one to my colleagues I will create an online user guide so that any other person online that will be also looking for guide will also have the help that they need. So lets get started.

Prerequisites

 

Installation Guide

  1. Install JDK, just proceed with standard installation process.
  2. Install Android Studio, just proceed with standard installation process. Please note that during the installation phase it will also download the Android SDK with is more than 3GB. PLEASE NOTE OF THE SDK INSTALLATION FOLDER AS THIS WILL BE USED ON LATER PROCEDURE.
  3. Install Aptana, just proceed with standard installation process. Please also note that during installation phase it will also download some prerequisite application including Node.js& Git
  4. Go to START and look for Command Prompt and run it as Administrator.
  5. Type the command below and press enter and wait for the installation process to finish. It will take a while depending on your internet connection.
    npm install -g cordova
    npm install -g proto-list
    npm install -g os-tmpdir
    npm install -g os-homedir
    npm install -g are-we-there-yet
    npm install -g gauge
    npm install -g ansi
    npm install -g is-absolute
    npm install -g asap
    npm install -g minimatch
    npm install -g path-is-absolute
    npm install -g validate-npm-package-license
    npm install -g is-builtin-module
    npm install -g concat-stream
    npm install -g json-parse-helpfulerror
    npm install -g block-stream
    npm install -g fstream-ignore
    npm install -g readdir-scoped-modules
    npm install -g debuglog
    npm install -g lodash._baseflatten
    npm install -g lodash._baseuniq
    npm install -g lodash.restparam
    npm install -g unique-slug
    npm install -g phonegap
  6. After the installation close all window.
  7. Restart your Machine.
  8. Go to your SDK folder that is indicated during the installation of the Android Studio.
  9. Run SDK Manager and install most of the needed SDK, you may install all the SDK if you want to be sure. It will take a while to install depending on your internet connection.
  10. Run AVD Manager and create a virtual device.
  11. You may now proceed with the creation of your PhoneGap app.

 

You may also want to take note the following update on the Environment Variable if it is needed on your side.

ANT_HOME=C:\path\to\ant\folder\apache-ant-1.9.4
ANDROID_HOME=C:\path\to\the\folder\of\Android\sdk
JAVA_HOME = C:\Program Files (x86)\Java\jdk1.7.0_79

PATH
Append;%ANDROID_HOME%\tools;%ANDROID_HOME%\platform-tools;%JAVA_HOME%\bin;%ANT_HOME%\bin

Disable Copy and Paste on RDP

Hi,

I have given a task to research on the web on how to disable RDP’s Copy and Paste of files due to some security issues. The following Steps should be done with Administrator rights.

  1. Open GPEdit.msc on Windows by Pressing Window Key + R
  2. A Window named Local Group Policy Editor will be shown.
  3. Navigate to Computer Configuration > Administrative Templates > Windows Components > Remote Desktop Services > Remote Desktop Session Host > Device and Resource Redirection
    step a
  4. On the Extended Tab double click Do not allow clipboard redirection
  5. A Window named Do not allow clipboard redirection will be shown.
  6. Click Enabled and Click Apply
    step b
  7. Make sure that all users will Log Off and then Login to implement this new settings.
  8. Done

Source
God Bless!

Thanks,
Thomie

GCF-East.com is live

As I am looking for an opportunity to serve our church thru a ministry, I was blessed to have it in such a way that it is align to my profession of creating website. With the team that composed of several persons I had volunteered to become the programmer. With the tools at hand I also used the same set of items and skill set in order to convert the provided design, concept, phases, and sections smoothly on http://www.gcf-east.com

It composes of several sections:

  • Home
  • About Us
  • Events and Announcements
  • Resources
  • Connect

Soon it will host several videos and audible of sermon that will blessed visitors and will know God along with it.

God Bless!
Thanks,
Thomie

Signalr – OnDisconnect(bool stopCalled)

Most of us who are using .Net as our Programming language use Signalr as our Real-Time Framework. And we implement OnDisconnect in most cases to catch clients that have been disconnected. Since then there were no parameter included as an Overload of the said method. Lately on the latest releases by the Signalr team they have included an Overload so that we can distinguish what triggers the disconnection and help us manage our Apps behavior to it.

With this said I have one experience that I want to share as this may also frustrate some people who are counting connected users and having a problem that when their app have multi workers (Web Garden) they app somehow always trigger OnDisconnect even if the user is still connect. So I want to share this findings on how to properly address it.

  1. Make sure that the App is using a Backplane to manage connection on your hub so that the connections are shared on all threads/servers. I use SQLServer.
  2. Make sure to use the Database on counting your list of connection and tagging who is who. Because in memory List even its static will not be shared on a different server (obviously).
  3. Make sure to trigger disconnection action when the OnDisconnect is called with the stopCalled is equal to true.

Let me highlight what is stopCalled is equal to true means.

  1. It returns true if the method on the connection to close is trigger
  2. It returns true if the browser is called
  3. It returns false if the timeout has been met

Hope this instructions will help you manage your site as it help me on our projects.

God Bless!

Thanks,
Thomie

RockRMS : Free Relationship Management System

RockRMS

I have been searching for an Open Source management of our church that is also created on ASP .Net. I have found RockRMS. RockRMS is created using ASP .Net Web Form that is so dynamic and Scale-able it can accommodate both external website and internal operation of a Church. There is even a dedicated hosting that will maintain your system and is hosted on Windows Azure.

Its source code is also available on GitHub so others can contribute to the pipeline. You may visit their website at https://www.rockrms.com/

Here are some of the screenshots provided on their website:

 

God Bless!

Thanks,
Thomie

Pechkin – NET Wrapper for WkHtmlToPdf

Pechkin

.NET Wrapper for WkHtmlToPdf DLL, library that uses Webkit engine to convert HTML pages to PDF. It is now available on Nuget for easy installation on your Visual Studio Solution/Projects.

How easy is it to use? Just install it via Nuget and add a reference on your code then use either one of the following:

byte[] pdfBuf = new SimplePechkin(new GlobalConfig()).Convert("<html><body><h1>Hello world!</h1></body></html>");

and

// create global configuration object
GlobalConfig gc = new GlobalConfig();

// set it up using fluent notation
gc.SetMargins(new Margins(300, 100, 150, 100))
  .SetDocumentTitle("Test document")
  .SetPaperSize(PaperKind.Letter);
//... etc

// create converter
IPechkin pechkin = new SynchronizedPechkin(gc);

// subscribe to events
pechkin.Begin += OnBegin;
pechkin.Error += OnError;
pechkin.Warning += OnWarning;
pechkin.PhaseChanged += OnPhase;
pechkin.ProgressChanged += OnProgress;
pechkin.Finished += OnFinished;

// create document configuration object
ObjectConfig oc = new ObjectConfig();

// and set it up using fluent notation too
oc.SetCreateExternalLinks(false)
  .SetFallbackEncoding(Encoding.ASCII)
  .SetLoadImages(false)
  .SetPageUri("http://google.com");
//... etc

// convert document
byte[] pdfBuf = pechkin.Convert(oc);

 

God Bless!

Thanks,
Thomie

Pixlr Editor : Online Photo Editor

pixlr-editor-startup-screen

I have been before looking for an online application to edit my images without thinking of any licensing and subscription. An online editor that you can be used even on your tablet (tried it with a mouse and keyboard) and your my desktop. With that said I have found Pixlr Editor.

Pixlr Editor has many feature that is familiar with Adobe Photoshop. I t has fill, magic wand, layering, and even a way to connect to your Picasa account. It is also wonderful to note that is a tool that is now under Autodesk. Try it now be clicking here.

 

God Bless!

Thanks,
Thomie

Google’s My Maps

Many of us give other person direction by giving them the location in Google Maps by using a Pointer. But there is a more accurate way to give directions to our peers and love ones.

Introducing Google My Maps. Google My Maps allows you to create your own map with directions, pointers, and even allow collaborations among other Google users. 

In order to start here is a simple step:

  1. Go to Google Maps
  2. Login your Google Account
  3. Create a New Map
  4. Do mapping and pointing
  5. Save, Share, Collaborate

I have use this for my referrals so that they can know the exact way they need to go when they are invited for an interview. I hope this also help you as it help me.

God Bless!

Thanks,

Thomie

How to Reformat a Cherry Mobile Alpha Play using WIMBoot

First of All Credits to: Rae Kevin Turno Monzon From Cherry mobile alpha play FB Group

How to reformat/reset to factory defaults your Cherry Mobile Alpha Play
using WIMBOOT

For more information about WIMBOOT, please refer to this link:
http://technet.microsoft.com/en-us/library/dn594399.aspx

====================
=====DISCLAIMER=======
====================

Please read the following:

I, (state your name), will be held responsible to whatever happens to my device while following this tutorial.

The creator of this tutorial will not be responsible for any damages, loss of data, loss of warranty, untoward incident or anything that might held the creator responsible for the damages.

I will be careful and knowledgeable enough to follow the instructions provided in this tutorial.

====================
=====DISCLAIMER=======
====================

What is needed/required:
-knowledge on how to install an OS to a computer
-knowledge to use command prompt
-patience (important)
-Cherry Mobile Alpha Play
-bootable Windows 8.1 media (flash drive 8GB+/hard drive/dvd drive)
-Install.wim from the recovery drive (hidden partition of CMAP)
-USB Keyboard
-USB Mouse
-USB Hub

Before we start:
-please back up all your important data
-please make sure your device is connected to the power adapter
-please connect your USB mouse and keyboard to the device
-please plug the bootable Windows 8.1 media to the device
-please remove any micro sd plugged on your device(ignore this if your bootable device is the micro sd card)
-this tutorial assumes that you have the recovery drive data on the bootable media (D:\Windows Images\Install.wim)

Instructions:

Boot into the BIOS by pressing DEL on the keyboard while turning on your device
http://goo.gl/4nhA1p

Go to “Save & Exit”
http://goo.gl/1aXqbo

Select your bootable media (UEFI: YOUR USB DRIVE) and Press Enter
http://goo.gl/Gyh77R

Wait until you see the “Windows Setup” Screen
http://goo.gl/Cp25uA

Press Next

Click on “Repair Your Computer”
http://goo.gl/z10wFx

Click on “Troubleshoot”
http://goo.gl/i9zK8T

Click on “Advanced Options”
http://goo.gl/d7O2ok

Click on “Command Prompt”
http://goo.gl/j17cHT

You will now be presented with a single command prompt screen
http://goo.gl/ar9h0Y

===Before proceeding please make sure your you said the disclaimer and read the text before the instructions===

Type the following:

DISKPART

SELECT DISK 0

CLEAN

CONVERT GPT

CREATE PARTITION EFI SIZE=100

FORMAT QUICK FS=FAT32 LABEL=”System”

CREATE PARTITION MSR SIZE=128

CREATE PARTITION PRIMARY

SHRINK MINIMUM=3700

FORMAT QUICK FS=NTFS LABEL=”Alpha Play”

ASSIGN LETTER=C

CREATE PARTITION PRIMARY

FORMAT QUICK FS=NTFS LABEL=”Recovery”

ASSIGN LETTER=M

SET ID=”de94bba4-06d1-4d40-a16a-bfd50179d6ac”

GPT ATTRIBUTES=0x8000000000000001

LIST VOLUME

EXIT

MD “M:\Windows Images\”

COPY “D:\Windows Images\Install.wim” “M:\Windows Images\Install.wim”

MD C:\Recycler\Scratch

DISM /Apply-Image /ImageFile:”M:\Windows Images\install.wim” /ApplyDir:C: /Index:1 /WIMBoot /ScratchDir:C:\Recycler\Scratch

C:\Windows\System32\bcdboot C:\Windows

EXIT

http://goo.gl/K15NZU
http://goo.gl/6nlypQ

===Whew end of Command prompt. Congratulate yourself if you successfully do this==

Remove bootable media (USB)

Click on “Turn off your PC”
http://goo.gl/qMUeMl

Power On your device
http://goo.gl/uPddEV

wait until an error shows up DO NOT CLICK
http://goo.gl/d7xsRR

OK!!!!

Press SHIFT + F10

(Hello again command prompt)
http://goo.gl/o5oClj

Type “REGEDIT” and press Enter
http://goo.gl/1oEoU2

Expand “HKEY_LOCAL_MACHINE”
http://goo.gl/EAUzqJ

Expand “SYSTEM”
http://goo.gl/AlQxm5

Expand “Setup”
http://goo.gl/BlnVEy

Expand “Status”
http://goo.gl/hg6TYU

Click “ChildCompletion”
http://goo.gl/iPsKUH

Double Click on “setup.exe”
http://goo.gl/Bm1bXF

Change Value Data from 1 to 3 then press OK
http://goo.gl/8A5vNU

Close Registry Editor

Close Command Prompt

Press OK on the Error Window
http://goo.gl/HSRIQ4

So… Congratulations and you’re done!!!
http://goo.gl/IwwPN6

Enjoy your freshly installed Windows 8.1 with Bing on your Cherry Mobile Alpha Play!

NOTE:
-please disable automatic updates on the Control Panel to avoid system bloating (loss of free space)
-images are only for reference and may not be exact as typed but please follow what is in the instructions
(dahil meron akong minodify sa system ko kaya hindi same)

Guys, paki share po ito sa lahat ng nangangailangan ng tulong sa pag reformat ng ating device.

Hindi po sa naghahanap ako ng karangalan pero mas mainam na po kung bibigyan niyo ako ng credits sa pag gawa ng tutorial na ito. Kahit simpleng “Credits to Rae Kevin Turno Monzon” lang po

Maraming salamat po at Merry Christmas!

Nga po pala!
Credits po kay Sir John Sebastian Tsukuyumi sa pag bigay ng tips kung pano makuha ang Recovery Data ng CMAP at pag bigay ng idea kung pano ireset to factory settings ang device natin!

Updated Install.wim File (separated in 5 parts para convenient ang download)
http://goo.gl/vS931r

Kung sakaling nag format ka ng hindi sinusunod ang steps pero wala kang drivers…
CHERRY MOBILE ALPHA PLAY DRIVERS (kayu na po bahala kung pano install yan hehe )
https://drive.google.com/open?id=0B6GADZuCykI5UlRKYW92T19mNUk&authuser=0

[How To] Contacts Online Sync for Reformatted and Lost Android Phone

Have you ever reformatted or lost your loving Android Mobile Phone or even upgraded to the latest model in the market then all of a sudden you’ve lost your precious Contact Number?

Then, you should do the Contacts Online Sync for Reformatted and Lost Android Phone.

  1. Hit the menu button on your phone and select “System Settings.
    Sync Google Contacts With Android Step 1.jpg
  2. Click “Accounts & Sync” in the Settings menu.
    Sync Google Contacts With Android Step 2.jpg
  3. Click on the “g” symbol for Google in the Sync screen once it appears.
    Sync Google Contacts With Android Step 3.jpg
  4. Check the box marked “sync Contacts. It will tell you the last time your contacts were synced to your phone underneath.
    Sync Google Contacts With Android Step 4.jpg
  5. Hit the menu button and click “Sync Now” to add and sync your contacts to your phone.
    Sync Google Contacts With Android Step 5.jpg

Or Follow This Video

Credits to the Steps, Images, and Video to WikiHow

Clash of Clans Unlimited Gems

Hi Co Palyers,

Before anything else this is NOT a cheat.

I have been searching for way to have an Clash of Clans Unlimited Gems. Yes there is a way but it is not on the real Clash of Clans.

coc

To see is to believe. That is most of us says. You can see that there is my name at the upper left corner of the screen. So how can that happen. Simply connect to a server using the guide below and please note that all saved data might disappear but rest assured you will still have the number of Golds and Gems during start.

So here are the steps, just follow it very carefully:

ANDROID Users (As of now for Rooted Device only)

  1. Back-up your existing Clash of Clans Game to your Google Account(I know that most of you should know this)
  2. Make sure your device is rooted, if not you may try this.
  3. Install Host Editor on your Android device
  4. Open the Host Editor and add the following
    1. host
  5. After adding that to your host open up your Clash of Clans and to See is to Believe.

iOS Users

  1. Install iFile
  2. Navigate and Open /etc/hosts
  3. Add New values containing the same as the provided on android.
  4. After adding that to your host open up your Clash of Clans and to See is to Believe.

 

Notes:

  • Gem Purchases will go to the original Clash of Clans and not saved. Please don’t purchase any gems as you will be billed by the ORIGINAL Clash of Clans.
  • You’ll have on login
    • 10,000,000 gold
    • 100,000,000 elixer
    • 10,000,000 gems
    • 300,000 dark elixer(if applicable)
  • Just Removed the added Host to go back to the original Clash of Clans.
  • Things that are not yet working:
    • Clans and Clan War
    • Player vs Player
    • Player vs Environment
    • Google+, Facebook, and Link
  • All rights remain to their corresponding owners.
  • You are doing this on your own will.
  • Again This is NOT a cheat.

Please share this page

God Bless!

 

FreePerDay – Android : Anomaly Warzone Earth

FreePerDay app is Anomaly Warzone Earth

Anomaly Warzone Earth HD - screenshot thumbnail

 

Description

PocketGamer: “”If you’re a strategy fan, you need this game”” PLATINUM AWARD!
TouchGen: “”So engaging it’s almost impossible to put down”” EDITOR’S CHOICE!
TouchArcade: “”It nails!”” 5/5 STARS! GAME OF THE YEAR RUNNER-UP AWARD!
AppSpy: “”Fantastically intriguing take on reversing the roles in a Tower Defense game”” VERDICT: GREAT!
IGN: “”A perfect challenge for any strategist”” NOMINEE FOR BEST MOBILE STRATEGY AWARD!Award winning game Anomaly Warzone Earth HD turns tower defense on its head. This time you take control of the attacking force, pitting your heavily armored squad against the destructive towers of an alien horde. Carefully lead your squad through the invaders’ defenses, shattering their towers and turrets with special weapons and power-ups in this groundbreaking new experience in tower offense.- Experience a new type of tower defense game where you’re the attacking side
– Think tactically and choose the right squad, route, special weapons, and plan to guarantee success in Tower Offense strategy
– Gather resources strategically to buy and upgrade new and more powerful units
– Play for hours on end in engaging modes of play: Story Campaign and Squad Assault modes
– Immerse yourself in the cutting-edge graphics and atmospheric soundtrack

Description Source

Download Details

Link: Download

Password: tjsa.info

*Please send this page's link to your friend when sharing the app.
*App is originally purchased by the author and are DRM-free. 
*The Link is powered by i-cttech.com and will expire after 10 days. If link has been expired please advise via the comment bellow so we can update it for you.
*For questions and inquiries please email: tjsanagustin+freeperday©gmail.com

FreePerDay – Android : Little Inferno

FreePerDay app is Little Inferno

Cover art

Little Inferno - screenshot

Description

“A beautiful masterpiece”, “inventive, moving and unrelentingly funny”, “a deft statement on games and how we play them” – Little Inferno is an unordinary game, filled with surprise and wonder, and even better the less you know before playing!

Congratulations on your new Little Inferno Entertainment Fireplace! Throw your toys into your fire, and play with them as they burn. Stay warm in there. It’s getting cold outside!

Burn flaming logs, screaming robots, credit cards, batteries, exploding fish, unstable nuclear devices, and tiny galaxies. An adventure that takes place almost entirely in front of a fireplace – about looking up up up out of the chimney, and the cold world just on the other side of the wall.

Description Source

Download Details

Link: Download

Password: tjsa.info

*Please send this page's link to your friend when sharing the app.
*App is originally purchased by the author and are DRM-free. 
*The Link is powered by i-cttech.com and will expire after 10 days. If link has been expired please advise via the comment bellow so we can update it for you.
*For questions and inquiries please email: tjsanagustin+freeperday©gmail.com

FreePerDay – Android : Kingdom Rush

FreePerDay app is Kingdom Rush

Cover art

Kingdom Rush - screenshot

Description

The acclaimed action fantasy defense game is now available on Android for Phones and Tablets! Get ready for an epic journey to defend your kingdom against hordes of orcs, trolls, evil wizards and other nasty fiends using a vast arsenal of towers and spells at your command!

Fight on forests, mountains and wastelands, customizing your defensive strategy with different tower upgrades and specializations! Rain fire upon your enemies, summon reinforcements, command your troops, recruit elven warriors and face legendary monsters on a quest to save the Kingdom from the forces of darkness!

Description Source

Download Details

Link: Download

Password: tjsa.info

*Please send this page's link to your friend when sharing the app.
*App is originally purchased by the author and are DRM-free. 
*The Link is powered by i-cttech.com and will expire after 10 days. If link has been expired please advise via the comment bellow so we can update it for you.
*For questions and inquiries please email: tjsanagustin+freeperday©gmail.com

MSSQL – Execution Plan Caching and Recompiling

Hi,

Have you every experience that you have a stored procedure(SP) that have plenty of parameters that when 1 set of parameter is executed for the very first time the said SPwas created, its fast. Then after you have a new set of parameter passed to the same SP you’ll end up a long execution process?

Then that is because of a so called Execution Plan Caching that MSSQL is doing on your query. In an overview MSSQL check if there is an existing execution plan for the SP. If there is none, it will create an optimized execution plan, compile, and then cache it on memory. So when the same SP is executed with the same number of parameter it will be reused.

So in cases that you have the same number of parameter every time you use the said stored procedure and you know that you have a logic that will change the query result then this optimization may not be on our side.

When does this caching is cleared? It is only cleared when either there are no memory allocation for MSSQL or you force MSSQL to recompile the SP.

How to Recompile your specific SP? Just add OPTION (RECOMPILE) at the end of your query, before the END statement, and you are ready to go. In some cases you may want to force all cache to be removed, you need to use another statement to do that and that is DBCC FREEPROCCACHE.

That’s it. Hope it helped you as it helped me on my project.

God Bless!
Thanks,
Thomie

MSSQL – Drop all SP and Table on a Database

Execute this with Precaution

USE YourDataBaseName
declare @procName varchar(500)
declare cur cursor
for select [name] from sys.objects where type = ‘p’
open cur
fetch next from cur into @procName
while @@fetch_status = 0
begin
exec(‘drop procedure [‘ + @procName+’]’)
fetch next from cur into @procName
end
close cur
deallocate cur
EXEC sp_MSforeachtable @command1 = “DROP TABLE [?]”

 

 

MSSQL – Count Number of Records on Each Table

Here is the script to count all the number of records on each table on a MSSQL Server:

 

SELECT sc.name +’.’+ ta.name TableName
,SUM(pa.rows) RowCnt
FROM sys.tables ta
INNER JOIN sys.partitions pa
ON pa.OBJECT_ID = ta.OBJECT_ID
INNER JOIN sys.schemas sc
ON ta.schema_id = sc.schema_id
WHERE ta.is_ms_shipped = 0 AND pa.index_id IN (1,0)
GROUP BY sc.name,ta.name
ORDER BY SUM(pa.rows) DESC

Hope it helps.

God Bless!
Thanks,
Thomie