JahsonK JahsonKim
JahsonKim
/ how-to.css
Created
August 31, 2020 15:19
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| .header { | |
| padding-left: 10px; | |
| padding-right: 10px; | |
| text-transform: uppercase; | |
| font-weight: 800; | |
| font-size: 18px; | |
| } | |
| .step-right { | |
| padding: 2px; |
JahsonKim
/ clrProcedure.sql
Last active
October 19, 2020 09:05
How to create a CLR procedure that invokes the clrExample.cs method.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE PROCEDURE [dbo].[postData] | |
| @postData NVARCHAR(4000), | |
| @returnval NVARCHAR(2000) OUTPUT | |
| WITH EXECUTE AS CALLER | |
| AS | |
| EXTERNAL NAME [CLRAssembly].[CLRExample].[postData] | |
| --After creating the clrExample.cs class in visual studio generate a dll file that you add into your | |
| --SQL server with the name CLRAssembly. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| using Microsoft.SqlServer.Server; | |
| //------------------------------------------------------------------------------ | |
| // <copyright file="CSSqlClassFile.cs" company="Microsoft"> | |
| // Copyright (c) Microsoft Corporation. All rights reserved. | |
| // </copyright> | |
| //------------------------------------------------------------------------------ | |
| using System; | |
| using System.Collections.Generic; | |
| using System.Data.SqlTypes; | |
| using System.IO; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /* Some times you may wonder how you can automatically back up your Mysql database. | |
| This functions helps you create a back up file for your mysql databases | |
| */ | |
| define ('DATABASE_NAME','YOR DATABASE NAME'); | |
| define ('DATABASE_USER','DATABASE USERNAME'); |
JahsonKim
/ enableOleAutomation.sql
Last active
May 17, 2023 12:56
How to send http POST request from sql server stored procedure. Important! For some reason sp_OAGetProperty is returning null. Am not sure why and if anyone has an idea can update the gists. In case you need to try another option SQL CLR would help. Check here https://gist.github.com/JahsonKim/05e6af7744f2d7ef814e5ed331419db5
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --This query enables ole automation procedures. set 0 to disable | |
| exec master.dbo.sp_configure 'Ole Automation Procedures', 1 | |
| RECONFIGURE | |
| --OLE utomation disabled the following error is thrown. | |
| --SQL Server blocked access to procedure 'sys.sp_OACreate' of component | |
| --'Ole Automation Procedures' because this component is turned off as part | |
| --of the security configuration for this server. | |
| --A system administrator can enable the use of 'Ole Automation Procedures' |
JahsonKim
/ simple_html_dom.php
Created
August 10, 2016 08:51
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /** | |
| * Website: http://sourceforge.net/projects/simplehtmldom/ | |
| * Acknowledge: Jose Solorzano (https://sourceforge.net/projects/php-html/) | |
| * Contributions by: | |
| * Yousuke Kumakura (Attribute filters) | |
| * Vadim Voituk (Negative indexes supports of "find" method) | |
| * Antcs (Constructor with automatically load contents either text or file/url) | |
| * | |
| * all affected sections have comments starting with "PaperG" |
JahsonKim
/ crawler.php
Created
August 10, 2016 08:50
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| include_once('simple_html_dom.php'); | |
| $html = new simple_html_dom(); | |
| if(isset($_POST['crawl'])){ | |
| $crawl = $_POST['target']; | |
| $find = "http://"; | |
| //Change "http://" to https// if you are crawling a an https site otherwise keep it http | |
| if(strpos($crawl,$find)!==false){ | |
| $html->load_file($crawl); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <title>Simple PHP Web Crawler</title> | |
| <link type="text/css" rel="stylesheet" href="style.css" /> | |
| </head> | |
| <body> | |
| <form method="post" action="crawler.php"> | |
| <p style="text-align:center;"><input type="text" name="target" class="input" placeholder="Type site url here" /></p> | |
| <p style="text-align:center;"><input type="submit" name="Crawl Site" class="button" value="Crawl !" /></p> |
JahsonKim
/ Authorization.java
Last active
March 2, 2016 12:50
How to Load Trending Hashtags using the Twitter Fabric and REST API. Ensure you install the Twitter Fabric SDK on your app to be able to run this. The SDK is available Here.