// selectPath : SQLite DB 파일 백업 폴더 위치

Java.IO.File sd = new Java.IO.File(selectPath);

// 폴더가 존재하지 않으면 만든다.

if (!sd.Exists())

Java.IO.File data = Android.OS.Environment.DataDirectory;
// System.Environment.GetFolderPath(System.Environment.SpecialFolder.MyDocuments);

FileChannel source = null;
FileChannel destination = null;

//  data 가 두번 붙는거 방지 (안드로이드 버전에 따라 다르게 나오는 부분 처리)

List<string> pathList = Constant.DBPath.Split(new char[] { '/' }, StringSplitOptions.RemoveEmptyEntries).ToList();

if (pathList[0] == "data")

string path = string.Join("/", pathList);

string currentDBPath = path;

string backupDBPath = "test.db";
Java.IO.File currentDB = new Java.IO.File(data, currentDBPath);
Java.IO.File backupDB = new Java.IO.File(sd, backupDBPath);
    source = new FileInputStream(currentDB).Channel;
    destination = new FileOutputStream(backupDB).Channel;
    destination.TransferFrom(source, 0, source.Size());
    Toast.MakeText(this, "백업 완료! - " + backupDB.Path, ToastLength.Long).Show();
catch (Java.Lang.Exception ex)


private void exportDB(){
File sd = Environment.getExternalStorageDirectory();
      File data = Environment.getDataDirectory();
       FileChannel source=null;
       FileChannel destination=null;
       String currentDBPath = "/data/"+ "com.authorwjf.sqliteexport" +"/databases/"+DB_NAME;
       String backupDBPath = DB_NAME;
       File currentDB = new File(data, currentDBPath);
       File backupDB = new File(sd, backupDBPath);
       try {
            source = new FileInputStream(currentDB).getChannel();
            destination = new FileOutputStream(backupDB).getChannel();
            destination.transferFrom(source, 0, source.size());
            Toast.makeText(this, "DB Exported!", Toast.LENGTH_LONG).show();
        } catch(IOException e) {

'Andorid' 카테고리의 다른 글

Export SQLite DB  (0) 2019.02.22
Android Emulators  (0) 2018.03.02
Android 에서 각종 아이콘이 표시 결과 확인하기  (0) 2017.12.30
Google Play 게임 만들때 읽어야할 글  (0) 2017.12.24
google-play-services(libproject)  (0) 2017.12.08
FCM 과 GCM 차이? - 펌  (0) 2017.11.25

// 볼륨처리와 함께 container 구동하기 (--rm은  구동후 container 제거옵션)
docker container run -it -v d:/dock:c:/dock dockerconsoleapp test
docker container run -it --rm -v d:/dock:c:/dock dockerconsoleapp test

// image 를 tar 파일로 내보내기 / 불러오기
docker image save -o kjuntest.tar dockerconsoleapp
docker image load -i kjuntest.tar

// container 내부로 진입하기
docker ps 로 컨테이너 ID 확인
docker exec -i -t {Container Id} /bin/bash


** 기타

docker system prune


'Life' 카테고리의 다른 글

수원제천 시외버스 시간표  (0) 2019.03.13
하담이 작품^^  (0) 2019.02.16
드디어 애드센스 1000달러 돌파  (1) 2019.01.23
하담이가 만든 서있는 악어  (0) 2019.01.08
강제 환기 (제로홈) 설치 후기  (0) 2019.01.06
실력이점점 늘어가는 하담이  (0) 2019.01.01

작업관리자를 가끔 확인하는데

이상한게 하나 떠있다..;


raonk.exe .. 검색해 보니 국세청 사이트 접속하면 깔리는 거라는데

구라제거기로도 삭제가 안된다.

삭제를 시도한 블로그를 보니 삭제가 제대로 안된다고 한다.

아래 첨부파일을 실행해서 프로그램 제거를 선택하고 진행하면 깔끔하게 삭제가 된다.




'MiGong' 카테고리의 다른 글

2019.02.13 미공 데이터  (0) 2019.02.13
2019.02.01 미공 데이터  (0) 2019.02.02
2019.01.29 미공 데이터  (0) 2019.01.30
2019.01.22 미공 데이터  (0) 2019.01.23
2019.1.16 미공 데이터  (0) 2019.01.16
2019.1.14 미공 데이터  (0) 2019.01.14

개인정보 보호법 제30조, 시행령 제31조, 표준 개인정보 보호지침 제37조에 따라 「개인정보 처리방침」에 따라 아래와 같이 개인정보처리 방침을 고지합니다.

1. 개인정보에 관한 처리목적은 소비자가 원하여 진행되는 거래에 있어 꼭 필요한 정보만을 수집합니다.

2. 수집된 개인정보는 거래가 성시된후에는 소비자의 요구에 의해 즉시 삭제 또는 일시 보관할 수 있습니다.

3. 본사에서 수집된 개인정보는 어떠한 경우에도 제3자에게 제공하지 않습니다.

4. 본사가 수집하는 개인정보는 없습니다.아래와 같습니다. (없음)

5. 수집된 개인정보의 파기는 소비자의 요구에 따라 처리하기로 함

6. 개인정보에 대한 관리책임자는 SMSConvey 대표가 관리함.

7. 개인정보의 처리 방침에 대한 변경 사항이 있을시 즉시 소비자에게 통지한다.

8. 수집된 개인정보는 컴퓨터의 로컬하드에 보관하지 않고 별도 저장장치에 보관하여 안전하게 관리한다.


출처 : http://www.procedural-worlds.com/blog/best-free-unity-assets-categorised-mega-list/


  • Behavior Bricks : Behavior Bricks is a state-of-the-art engine for Behavior Trees (BTs) along with an intuitive visual editor.
  • Crystal AI : A Utility based AI for C# and Unity (can only use free version in free games).
  • Goap : Goal oriented action planning AI in Unity.
  • Panda BT Free : Panda BT is a script-based Behaviour Tree engine which allows the authoring of complex, scaleable and reusable logic for your game.
  • TopDown AI : This is an example of Top Down Shooter AI.
  • Unity Movement AI : A library of steering behaviors to help your NPCs move around your game.


  • Google Analytics Plugin : Allows game developers to easily implement Google Analytics in their Unity games on all platforms.


  • Animancer Lite : A code-driven replacement for Unity’s Mecanim AnimatorControllers based around the concept of Dependency Injection: instead of using names or hash codes to identify predefined states and parameters, you simply pass the desired AnimationClip directly into the Play or CrossFade methods.
  • Animation Baker : Converts Mecanim animations back to legacy animations.
  • Animated Horse : Animated horse.
  • Dragonbones : Animation creation tool.
  • Huge FBX Mocap Library part 1 : Conversion of the Carnegie-Mellon mocap library with 2,534 mocap animations.
  • Huge FBX Mocap Library part 2 : Conversion of the Carnegie-Mellon mocap library with 2,534 mocap animations.
  • Huge FBX Mocap Library part 3 : Conversion of the Carnegie-Mellon mocap library with 2,534 mocap animations.
  • Magic Pack : 55 awesome magic animation from mixamo.
  • Melee Axe Pack : 55 mixamo animations for axe-wielding, skull bashing, dragon slaying barbaric types.
  • Mixamo : If you have an account then these are all free!
  • TakeDown Animations : 12 takedowns animations package.


  • Audacity : Multi track recording and editing software.
  • Bfxr : Sound FX generator.
  • InAudio 2 : Add great audio to your game in seconds with the new layered music player with crossfading and gap-less transitions.
  • Reaktion : An audio reactive animation toolkit for Unity.
  • Soundation : Record, mix and share music online.

Board Games:

  • RP Tools : A cool set of tools for desktop or online board games.


  • Cinemachine : Awesome camera controller system now a free part of Unity.
  • EZ Camera Shake : A versatile implementation of procedural camera-shaking animation.
  • GhostFreeRoamCamera : Free flying ghost roaming camera, in a FPS style!
  • RTS camera : Best free camera asset on the Unity asset store.

Color / Palette Generators:

  • Colormind : AI driven palette generator with very cool image extraction capability.
  • Coolors.co : Quite nice web based palette generator.
  • Paletton : Web based palette generator.


  • Animancer Lite : A code-driven replacement for Unity’s Mecanim AnimatorControllers based around the concept of Dependency Injection: instead of using names or hash codes to identify predefined states and parameters, you simply pass the desired AnimationClip directly into the Play or CrossFade methods.
  • Base Helicopter Controller : Helicopter controller with realistic physics.
  • Helicopter Pack : Cool helicopter & physics systems
  • Super Character Controller :  Fulfills all common character controller functions such as collision detection and pushback, slope limiting and collider ignoring. New features include the ability to rotate the controller to any angle, sophisticated ground detection, ability to clamp the character to surfaces, and detailed collision response messages. All functions are fully exposed and editable. Also includes the SuperStateMachine, a finite state machine designed to interact with the controller.
  • Third Person Controller – Basic Locomotion FREE : Very high quality AAA Quality 3rd Person Controller with locomotion template.
  • 3rd Person Controller + Fly Mode : This package provides a basic setup for a 3rd person player controller. Includes scripts for the player movements, camera orbit and a Mecanim animator controller, containing basic locomotion (walk, run, sprint, aim & strafe, and also an extra fly mode).


  • DreamIO : Add a leader board and promo code system to your game right now – no php or sql required!
  • SQLite4Unity3d : SQL Lite for Unity 3d.


Development / Testing:

  • Log Viewer : Check editor console logs inside the game itself even on mobile.
  • Resource Checker : Shows how much memory textures take to reduce memory usage.
  • ShaderlabVS : Visual Studio Plugin for Unity Shaderlab programming.
  • Unity Test Tools : Test your game with unit test framework, integration test framework, assertion component, ide, batch and test mode runners.
  • VSCode : Seamless support for Microsoft Visual Studio Code in Unity.

Editor Extensions:

  • Inspector Gadgets Lite : Streamline your editor experience with this enhanced Transform Inspector.
  • Weaver Lite : Directly reference assets and layers in your code without any magic strings and generate procedural assets in the Unity Editor.




  • Entitas : The entity component framework for Unity. Entities, pools, groups, observers.
  • Facepunch.Steamworks : A wrapper for Steamworks recommended by the community.
  • SteamWorks : A C# Wrapper for Valve’s Steamworks API, it can be used either with Unity or your C# based application.
  • UniRx : A re-implementation of the .NET Reactive Extensions for Unity.
  • UnitySteer : Awesome autonomous agent steering framework for Unity.
  • Universe : A global persistent game manager that lasts across screens.
  • Weaver Lite : Directly reference assets and layers in your code without any magic strings and generate procedural assets in the Unity Editor.
  • Zenject : Awesome looking dependency injection / IOC framework.

Game Toolkit:

  • Fungus : Easy, branching story editor. Was used in a Unity presentation some time ago.

Input Management:

  • InputBinder : Makes it easy for components to respond to axis, button, and key input events.
  • Lean Touch : Multi-platform input library for gestures (both touch and mouse).
  • LeapMotion : Leap motion development page and downloads.
  • TouchKit : TouchKit aims to make touch handling in Unity more sane.
  • TouchScript : TouchScript is a multi-touch library for Unity. Makes handling complex gesture interactions on touch surfaces easier.
  • XboxCtrlrInput for Unity : A wrapper that handles Xbox 360 controller input. It’s used in the same way as Unity’s Input class.

Inspiration / Interesting:


  • Arcadia : Clojure for Unity.
  • MoonSharp : Community recommended Lua interpreter written in C# for maximum compatibility.
  • UniLua : Implementation of LUA for Unity.



Map Editors:

  • Tiled : Free and easy to use tile map editor.


Music & Sound:


  • Forge Networking Remastered : Great networking system for Unity. Whats cool about the new version is that it also operates independently of Unity!
  • Photon Unity Networking Free : Easily add multiplayer to your games and launch them globally with the included FREE Photon Cloud plan.
  • Unity HTTP : A TcpClient-based HTTP library for Unity.


  • LibNoise : A port of the LibNoise framework for Unity. Great if you are doing procedural content generation.
  • WangScape : Not unity, but very interesting anyway, wang tiles are a way of breaking up terrain tiling.

Particle Systems:



  • ObjectPool : This script reduces garbage collection and therefore jitter by pooling instances.
  • RecyclerKit – An object pooling system that is super easy to use from Prime31.

Post FX / Shaders:

  • Deferred Night Vision : AAA quality night vision effect if you’re using deferred rendering.
  • Kamakura Shaders : Very nice stylised set of features that can be used altogether to create styles such as anime, paint, water-color, sketch like and so on.
  • KinoGlitch : A collection of glitch video effects.
  • KvantSpray : GPU accelerated object instancing/particle animation system for Unity. Very cool!
  • Legacy Unity Cinematic Image Effects : Awesome Post FX. If using 5.5 and up use the Unity Post Processing Stack above instead.
  • Legacy Image Effects : This package contains the Image Effects previously shipped as part of Unity’s Standard Assets.
  • Lightning Bolt Effect for Unity : Customizable lightning asset.
  • Lux : Fantastic open source physically based shader framework for unity.
  • Melee Weapon Trail : Add “swoosh” trail effects suitable for attacks of your characters.
  • Post Processing Stack : Amazing Free and Fast Post Processing Stack from Unity. Must have for Unity 5.5 and up!
  • Shader case Study – Pokemon Battle Transitions : Video tutorial plus shaders.
  • ShaderProject : All sorts of handy shaders –
    ApplyTexture, Blending, AdditiveBlending, AlphaBlending, CombineTextures, Dissolve, DiscardingFragments, FlatColor, FlatRGBColor, GeometryShaders, GrabPass, BlackWhite, Blur, GlassStained, Pixelation, PixelShifting, Tint, Zoom, Masks, AlphaMask, ColorMask, ColorAlphaMask, NormalExtrusion, NormalMapping, PostProcessing, BlackWhite, BlendModes, BrightnessSaturationContrast, DepthTexture, Overlay, Pixelation, Tint, RotationUV, RotationVertices, Shading, Diffuse, DiffuseLighting, Phong, Phong-Blinn, Silhuette, StencilBuffer, TextureAtlas, ToonShading, VertexManipulation, Flag, Scale, VolumetricExplosion, Water, Waves
  • SMAA for Unity3D : Subpixel Morphological Antialiasing for Unity3D.
  • Temporal Reprojection Anti-Aliasing : TRAA for Unity.
  • Toon Shader Free : A free toon shader – render your 3d models in a toon style.
  • Unity 5 Effects : Temporal screen space reflections, screen space shadows, screen space boolean, rim light, water surface and caustics, light particles, procedural modelling, metaball, temporal SSAO, mosaic field.
  • UnityPCSS : Implementation of NVidia “PCSS” or “Percentage Closer Soft Shadows”.


  • EasyRoads3D Free : The free version of what is probably the best roads asset for Unity. Works well with with Gaia terrains.

Scene, Art Creation & Level Design:


  • FullSerializer : Easy to use and robust JSON serializer that just works.
  • JSON.net : Fully featured and professionally supported port of JSON.net






Textures / Tilesets:

Thread Management:

Tweening Libraries:

  • DOTween (HOTween v2) : A very nice tweening library optimised for C# and nicely integrated into Unity.
  • LeanTween : An efficient tween engine for Unity that offers a many features.

Tutorials (also a great source of free assets):

  • Adam Exterior Environment : The Exterior environment from the Adam demo.
  • Adventure – Sample Game : Explore the makings of a point-and-click adventure game, complete with simple inventory system and data persistence examples with this fully-commented complete project, as used to teach Unite 2016’s Training Day.
  • Space Shooter Tutorial : Space Shooter tutorial Project on Unity’s Tutorial area.
  • Tanks Tutorial : This 2 player 1 keyboard couch warfest sees you building a complete tank shooter from scratch.
  • The Blacksmith Environments : All environment assets from “The Blacksmith” short film.
  • Vehicle Tools : Sample project tools to rig wheeled vehicles and easily create suspension for physics-based wheel colliders.
  • 2D Platformer : Showcasing 2D features a platform shooter demo.
  • 2D Roguelike : Learn how to make a 2D Roguelike game.


Unity Technologies:


  • Autosaver : Editor extension that allows for auto-saving your work.
  • BitStrap : A bunch of handy utilities that allow you to bootstrap a new Unity project.
  • Door Manager Script : A handy script to open and close doors in game.
  • FrameCapturer : Captures frames to pictures and videos. Supports png, gif, mp4, exr.
  • Instant Screenshot : Handy screen shot taking system.
  • Klak : Noise, random numbers, interpolation, extensions, image writer, procedural motion, event wiring.
  • LINQ to Game Object for Unity : Traverse GameObject Hierarchy by LINQ.
  • More Effective Coroutines : Memory Efficient Coroutines is an improved implementation of the standard co routines that runs blazing fast and has zero per-frame memory allocations.
  • Random Duplicate : A utility to duplicate an object with random size and rotation.
  • Previously Paid : A collection of previosly commercial unity assets.
  • Secured PlayerPrefs : Encrypt/decrypt PlayerPrefs.
  • Simple Finite State Machine : State machine designed with simplicity and ease of use in mind.
  • Tiny Lab Productions Library : Awesome collection of utilities. Android utils, bitmap, promises, futures, co-routine helpers, alloc free iterators, extensions, json parser / emitter, oprion, lazy, tupe, try, unit and many more useful utilities. Well worth a look!
  • Unity Color Picker : A color picker for Unity.
  • Unity3D-ComponentAttribute : An attribute that let’s you auto-load components.
  • Unity Toolbag : A bunch of handy Unity extension utilities. Very handy.
  • Zone Controller Free : Allows you to control the properties of ANY other Unity component at runtime. Create stunning and smooth transition effects on your favorite Unity components with just a few clicks. Very powerful!

Virtual Reality:

  • Google VR SDK for Unity : Build virtual reality applications for Android and iOS using the Google VR SDK for Unity.
  • HoloToolkit-Unity : A collection of scripts and components to accelerate development of applications targeting Windows Holographic.
  • Project Tango UnitySDK Examples : the Project Tango UnitySDK examples and tutorial projects for Unity 5 and above.
  • SteamVR Plugin : The Steam VR plugin for Unity.
  • Steam VR Unity Toolkit : A collection of useful scripts and prefabs for building SteamVR titles in Unity 5.
  • The Lab Renderer : The scripts and shaders that drove rendering in The Lab for HTC Vive. Forward renderer with support for up to 18 dynamic shadowing lights in a single pass with MSAA enabled, and it included the Adaptive Quality system that dynamically adjusts rendering resolution to maintain framerate in VR.
  • Newton VR : A virtual reality interaction system for unity based on physics.
  • VRTK : Virtual reality scripting toolkit, a collection of useful scripts and prefabs for building VR titles in Unity 5.
  • VR Samples : VR Samples from Unity.

Visual Scripting:

  • Behavior Bricks : Behavior Bricks is a state-of-the-art engine for Behavior Trees (BTs) along with an intuitive visual editor.
  • Panda BT Free : Panda BT is a script-based Behaviour Tree engine which allows the authoring of complex, scaleable and reusable logic for your game.
  • uScript Personal Learning Edition : uScript is a fully featured visual scripting system developed by industry veterans of award-winning “AAA” games.


2D Assets:

2D Tools:

  • Gimp : Free and open source image editor (like Photoshop).
  • Paint.net : Image and photo editor.
  • Krita : Painting tool for concept art, texture and matte painters, illustrations.
  • Inkscape : Great tool for creating vectorized sketches.
  • Piskel : Online editor for animated sprites and pixel art.
  • TexturePacker : Great sprite sheet generation and packing tool.

3D Models:

3D Tools:

  • Blender : Pretty much the standard.
  • MagicaVoxel : A lightweight 8-bit voxel art editor and interactive path tracing renderer.
  • ProBuilder : Awesome in-editor 3D prototyping / modelling system acquired by Unity and now free.
  • Qubicle : Voxel editor.
  • TinkerCad : Free 3D modelling tool from Autodesk. Result can be imported into Unity.
  • Vectary : Online 3D modelling tool.


Xamarin.Forms 콤보박스 컨트롤인 Picker 컨트롤에는 화살표시가 없습니다.


화살표시를 나타내기 위해서는 렌더러를 이용해야합니다.

우선 화살표 이미지를 먼저 구해야합니다. (전 아래 이미지로..)


사용할 이미지를 Android 프로젝트의 Resources/drawable 폴더에, iOS 프로젝트의 Resources 폴더에 추가합니다.


먼저 .Net Standard 프로젝트에

CustomPicker.cs 를 추가합니다.

using Xamarin.Forms;

namespace Test.Cntrol
    public class CustomPicker : Picker
        public static readonly BindableProperty ImageProperty =
            BindableProperty.Create(nameof(Image), typeof(string), typeof(CustomPicker), string.Empty);

        public string Image
            get { return (string)GetValue(ImageProperty); }
            set { SetValue(ImageProperty, value); }

        public CustomPicker() : base()
            Margin = 3;


Android 프로젝트에 CustomPickerRenderer.cs 를 추가합니다.

using Android.Content;
using Android.Graphics;
using Android.Graphics.Drawables;
using Android.Support.V4.Content;
using Test.Cntrol;
using Test.Droid;
using Xamarin.Forms;
using Xamarin.Forms.Platform.Android;

[assembly: ExportRenderer(typeof(CustomPicker), typeof(CustomPickerRenderer))]
namespace Test.Droid
    public class CustomPickerRenderer : PickerRenderer
        CustomPicker element;

        public CustomPickerRenderer(Context context) : base(context)

        protected override void OnElementChanged(ElementChangedEventArgs<Picker> e)

            element = (CustomPicker)this.Element;

            if (Control != null && this.Element != null && !string.IsNullOrEmpty(element.Image))
                Control.Background = AddPickerStyles(element.Image);

        public LayerDrawable AddPickerStyles(string imagePath)
            ShapeDrawable border = new ShapeDrawable();
            border.Paint.Color = Android.Graphics.Color.Gray;
            border.SetPadding(10, 10, 10, 10);

            Drawable[] layers = { border, GetDrawable(imagePath) };
            LayerDrawable layerDrawable = new LayerDrawable(layers);
            layerDrawable.SetLayerInset(0, 0, 0, 0, 0);

            return layerDrawable;

        private BitmapDrawable GetDrawable(string imagePath)
            int resID = Resources.GetIdentifier(imagePath, "drawable", this.Context.PackageName);
            var drawable = ContextCompat.GetDrawable(this.Context, resID);
            var bitmap = ((BitmapDrawable)drawable).Bitmap;

            var result = new BitmapDrawable(Resources, Bitmap.CreateScaledBitmap(bitmap, 70, 70, true));
            result.Gravity = Android.Views.GravityFlags.Right;

            return result;


iOS 프로젝트에도 CustomPickerRenderer.cs 를 추가합니다.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using Foundation;
using Test.Cntrol;
using Test.iOS;
using UIKit;
using Xamarin.Forms;
using Xamarin.Forms.Platform.iOS;

[assembly: ExportRenderer(typeof(CustomPicker), typeof(CustomPickerRenderer))]
namespace Test.iOS
    public class CustomPickerRenderer : PickerRenderer
        protected override void OnElementChanged(ElementChangedEventArgs<Picker> e)

            var element = (CustomPicker)this.Element;

            if (this.Control != null && this.Element != null && !string.IsNullOrEmpty(element.Image))
                var downarrow = UIImage.FromBundle(element.Image);
                Control.RightViewMode = UITextFieldViewMode.Always;
                Control.RightView = new UIImageView(downarrow);


이제 화면 상에서 아래 처럼 컨트롤을 정의한후 데이터를 바인딩하면

<?xml version="1.0" encoding="utf-8" ?>
<ContentPage xmlns="http://xamarin.com/schemas/2014/forms"
    <StackLayout Spacing="5">
      <cntrol:CustomPicker x:Name="customPicker"
                           Title="Custom Picker"/>

아래처럼 화살표시가 Picker 에 표시됩니다.




언제 부턴가 인터넷을 하다보면

위와 같은 에러가 떴다..; 이상한 사이트는 접속한적이 없는데..ㅜㅜ

윈도우 Defender, v3 Lite 로 검사해봤지만 아무것도 잡히지 않았다..

컴퓨터를 포맷을 하려다 mzk 라는 바이러스 검사 프로그램을 알게되어 확인해 보니

몇가지 에러를 잡아냈다. 설치 없이 실행파일을 실행하면 된다. (mzk.bat 파일을 관리자 권한으로 실행)


카페에서만 배포를 하고 주기적으로 DB 를 업데이트 하고 있는것 같은데

아무튼 이 프로그램만 바이러스를 인식하고 잡아냈다.

앞으로 또 지켜봐야겠지만.. 몇일 지났는데 동일 에러가 발생되지 않는다.

다운로드 링크






+ Recent posts