Public
snipts 
showing 1-20 of 4268 snipts
-
∞ using mamp in the os x terminal
export PATH=/Applications/MAMP/Library/bin/:/Applications/MAMP/bin/php5/bin/:/opt/local/bin:/opt/local/sbin:$PATH
-
∞ Getting a logger with Log4j
private static final Log LOG = LogFactory.getLog(SomeClassName.class);
-
∞ random md5
md5(uniqid(rand(), true)); -
∞ ant androidscreencast output
PS C:\androidscreencast> ant -v -f .\androidscreencast\build.xml Apache Ant version 1.8.0RC1 compiled on January 5 2010 Buildfile: C:\androidscreencast\androidscreencast\build.xml Detected Java version: 1.6 in: C:\Program Files\Java\jdk1.6.0_18\jre Detected OS: Windows XP parsing buildfile C:\androidscreencast\androidscreencast\build.xml with URI = file:/C:/androidscreencast/androidscreencast/build.xml Project base dir set to: C:\androidscreencast\androidscreencast parsing buildfile jar:file:/C:/Program%20Files/WinAnt/lib/ant.jar!/org/apache/tools/ant/antlib.xml with URI = jar:file:/C:/Program%20Files/WinAnt/lib/ant.jar!/o rg/apache/tools/ant/antlib.xml from a zip file [property] Loading C:\androidscreencast\androidscreencast.conf Build sequence for target(s) `jnlp' is [init, compile, dist, jnlp] Complete build sequence is [init, compile, dist, jnlp, clean, gc, ] init: [mkdir] Created dir: C:\androidscreencast\androidscreencast\bin compile: [javac] C:\androidscreencast\androidscreencast\build.xml:26: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false f or repeatable builds [javac] C:\androidscreencast\androidscreencast\src\MyInjectEventApp.jar skipped - don't know how to handle it [javac] net\srcz\android\screencast\Main.java added as net\srcz\android\screencast\Main.class doesn't exist. [javac] net\srcz\android\screencast\api\AndroidDevice.java added as net\srcz\android\screencast\api\AndroidDevice.class doesn't exist. [javac] net\srcz\android\screencast\api\StreamUtils.java added as net\srcz\android\screencast\api\StreamUtils.class doesn't exist. [javac] net\srcz\android\screencast\api\file\FileInfo.java added as net\srcz\android\screencast\api\file\FileInfo.class doesn't exist. [javac] net\srcz\android\screencast\api\injector\ConstEvtKey.java added as net\srcz\android\screencast\api\injector\ConstEvtKey.class doesn't exist. [javac] net\srcz\android\screencast\api\injector\ConstEvtMotion.java added as net\srcz\android\screencast\api\injector\ConstEvtMotion.class doesn't exist. [javac] net\srcz\android\screencast\api\injector\Injector.java added as net\srcz\android\screencast\api\injector\Injector.class doesn't exist. [javac] net\srcz\android\screencast\api\injector\KeyCodeConverter.java added as net\srcz\android\screencast\api\injector\KeyCodeConverter.class doesn't exis t. [javac] net\srcz\android\screencast\api\injector\NullSyncProgressMonitor.java added as net\srcz\android\screencast\api\injector\NullSyncProgressMonitor.clas s doesn't exist. [javac] net\srcz\android\screencast\api\injector\OutputStreamShellOutputReceiver.java added as net\srcz\android\screencast\api\injector\OutputStreamShellOut putReceiver.class doesn't exist. [javac] net\srcz\android\screencast\api\injector\ScreenCaptureThread.java added as net\srcz\android\screencast\api\injector\ScreenCaptureThread.class doesn' t exist. [javac] net\srcz\android\screencast\api\recording\DataAtomOutputStream.java added as net\srcz\android\screencast\api\recording\DataAtomOutputStream.class do esn't exist. [javac] net\srcz\android\screencast\api\recording\FilterImageOutputStream.java added as net\srcz\android\screencast\api\recording\FilterImageOutputStream.cl ass doesn't exist. [javac] net\srcz\android\screencast\api\recording\QuickTimeOutputStream.java added as net\srcz\android\screencast\api\recording\QuickTimeOutputStream.class doesn't exist. [javac] net\srcz\android\screencast\app\Application.java added as net\srcz\android\screencast\app\Application.class doesn't exist. [javac] net\srcz\android\screencast\app\SwingApplication.java added as net\srcz\android\screencast\app\SwingApplication.class doesn't exist. [javac] net\srcz\android\screencast\ui\JDialogDeviceList.java added as net\srcz\android\screencast\ui\JDialogDeviceList.class doesn't exist. [javac] net\srcz\android\screencast\ui\JDialogError.java added as net\srcz\android\screencast\ui\JDialogError.class doesn't exist. [javac] net\srcz\android\screencast\ui\JDialogUrl.java added as net\srcz\android\screencast\ui\JDialogUrl.class doesn't exist. [javac] net\srcz\android\screencast\ui\JFrameMain.java added as net\srcz\android\screencast\ui\JFrameMain.class doesn't exist. [javac] net\srcz\android\screencast\ui\JPanelScreen.java added as net\srcz\android\screencast\ui\JPanelScreen.class doesn't exist. [javac] net\srcz\android\screencast\ui\JSplashScreen.java added as net\srcz\android\screencast\ui\JSplashScreen.class doesn't exist. [javac] net\srcz\android\screencast\ui\MultiLineLabelUI.java added as net\srcz\android\screencast\ui\MultiLineLabelUI.class doesn't exist. [javac] net\srcz\android\screencast\ui\explorer\JFrameExplorer.java added as net\srcz\android\screencast\ui\explorer\JFrameExplorer.class doesn't exist. [javac] net\srcz\android\screencast\ui\explorer\LazyLoadingTreeNode.java added as net\srcz\android\screencast\ui\explorer\LazyLoadingTreeNode.class doesn't exist. [javac] net\srcz\android\screencast\ui\explorer\LazyMutableTreeNode.java added as net\srcz\android\screencast\ui\explorer\LazyMutableTreeNode.class doesn't exist. [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\ui\icon.png skipped - don't know how to handle it [javac] net\srcz\android\screencast\ui\pm\JFrameApps.java added as net\srcz\android\screencast\ui\pm\JFrameApps.class doesn't exist. [javac] net\srcz\android\screencast\ui\worker\AccumulativeRunnable.java added as net\srcz\android\screencast\ui\worker\AccumulativeRunnable.class doesn't ex ist. [javac] net\srcz\android\screencast\ui\worker\SwingWorker.java added as net\srcz\android\screencast\ui\worker\SwingWorker.class doesn't exist. [javac] Compiling 29 source files to C:\androidscreencast\androidscreencast\bin [javac] Using modern compiler [javac] Compilation arguments: [javac] '-nowarn' [javac] '-d' [javac] 'C:\androidscreencast\androidscreencast\bin' [javac] '-classpath' [javac] 'C:\androidscreencast\androidscreencast\bin;C:\android-sdk-windows\tools\lib\ddmlib.jar;C:\Program Files\WinAnt\lib\ant-launcher.jar;C:\Program File s\WinAnt\lib\ant-antlr.jar;C:\Program Files\WinAnt\lib\ant-apache-bcel.jar;C:\Program Files\WinAnt\lib\ant-apache-bsf.jar;C:\Program Files\WinAnt\lib\ant-apache -log4j.jar;C:\Program Files\WinAnt\lib\ant-apache-oro.jar;C:\Program Files\WinAnt\lib\ant-apache-regexp.jar;C:\Program Files\WinAnt\lib\ant-apache-resolver.jar; C:\Program Files\WinAnt\lib\ant-apache-xalan2.jar;C:\Program Files\WinAnt\lib\ant-commons-logging.jar;C:\Program Files\WinAnt\lib\ant-commons-net.jar;C:\Program Files\WinAnt\lib\ant-contrib-1.0b3.jar;C:\Program Files\WinAnt\lib\ant-jai.jar;C:\Program Files\WinAnt\lib\ant-javamail.jar;C:\Program Files\WinAnt\lib\ant-jde pend.jar;C:\Program Files\WinAnt\lib\ant-jmf.jar;C:\Program Files\WinAnt\lib\ant-jsch.jar;C:\Program Files\WinAnt\lib\ant-junit.jar;C:\Program Files\WinAnt\lib\ ant-netrexx.jar;C:\Program Files\WinAnt\lib\ant-nodeps.jar;C:\Program Files\WinAnt\lib\ant-swing.jar;C:\Program Files\WinAnt\lib\ant-testutil.jar;C:\Program Fil es\WinAnt\lib\ant-trax.jar;C:\Program Files\WinAnt\lib\ant.jar;C:\Program Files\WinAnt\lib\xercesImpl.jar;C:\Program Files\WinAnt\lib\xml-apis.jar;C:\Program Fi les\Java\jdk1.6.0_18\lib\tools.jar' [javac] '-sourcepath' [javac] 'C:\androidscreencast\androidscreencast\src' [javac] '-g:none' [javac] [javac] The ' characters around the executable and arguments are [javac] not part of the command. [javac] Files to be compiled: [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\Main.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\api\AndroidDevice.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\api\StreamUtils.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\api\file\FileInfo.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\api\injector\ConstEvtKey.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\api\injector\ConstEvtMotion.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\api\injector\Injector.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\api\injector\KeyCodeConverter.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\api\injector\NullSyncProgressMonitor.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\api\injector\OutputStreamShellOutputReceiver.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\api\injector\ScreenCaptureThread.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\api\recording\DataAtomOutputStream.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\api\recording\FilterImageOutputStream.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\api\recording\QuickTimeOutputStream.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\app\Application.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\app\SwingApplication.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\ui\JDialogDeviceList.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\ui\JDialogError.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\ui\JDialogUrl.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\ui\JFrameMain.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\ui\JPanelScreen.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\ui\JSplashScreen.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\ui\MultiLineLabelUI.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\ui\explorer\JFrameExplorer.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\ui\explorer\LazyLoadingTreeNode.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\ui\explorer\LazyMutableTreeNode.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\ui\pm\JFrameApps.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\ui\worker\AccumulativeRunnable.java [javac] C:\androidscreencast\androidscreencast\src\net\srcz\android\screencast\ui\worker\SwingWorker.java dist: [mkdir] Created dir: C:\androidscreencast\androidscreencast\dist [jar] Building jar: C:\androidscreencast\androidscreencast\dist\androidscreencast-DEV.jar [jar] adding directory META-INF/ [jar] adding entry META-INF/MANIFEST.MF [jar] adding directory net/ [jar] adding directory net/srcz/ [jar] adding directory net/srcz/android/ [jar] adding directory net/srcz/android/screencast/ [jar] adding directory net/srcz/android/screencast/api/ [jar] adding directory net/srcz/android/screencast/api/file/ [jar] adding directory net/srcz/android/screencast/api/injector/ [jar] adding directory net/srcz/android/screencast/api/recording/ [jar] adding directory net/srcz/android/screencast/app/ [jar] adding directory net/srcz/android/screencast/ui/ [jar] adding directory net/srcz/android/screencast/ui/explorer/ [jar] adding directory net/srcz/android/screencast/ui/pm/ [jar] adding directory net/srcz/android/screencast/ui/worker/ [jar] adding entry net/srcz/android/screencast/Main.class [jar] adding entry net/srcz/android/screencast/api/AndroidDevice.class [jar] adding entry net/srcz/android/screencast/api/StreamUtils.class [jar] adding entry net/srcz/android/screencast/api/file/FileInfo.class [jar] adding entry net/srcz/android/screencast/api/injector/ConstEvtKey.class [jar] adding entry net/srcz/android/screencast/api/injector/ConstEvtMotion.class [jar] adding entry net/srcz/android/screencast/api/injector/Injector$1.class [jar] adding entry net/srcz/android/screencast/api/injector/Injector$2.class [jar] adding entry net/srcz/android/screencast/api/injector/Injector.class [jar] adding entry net/srcz/android/screencast/api/injector/KeyCodeConverter.class [jar] adding entry net/srcz/android/screencast/api/injector/NullSyncProgressMonitor.class [jar] adding entry net/srcz/android/screencast/api/injector/OutputStreamShellOutputReceiver.class [jar] adding entry net/srcz/android/screencast/api/injector/ScreenCaptureThread$1.class [jar] adding entry net/srcz/android/screencast/api/injector/ScreenCaptureThread$ScreenCaptureListener.class [jar] adding entry net/srcz/android/screencast/api/injector/ScreenCaptureThread.class [jar] adding entry net/srcz/android/screencast/api/recording/DataAtomOutputStream.class [jar] adding entry net/srcz/android/screencast/api/recording/FilterImageOutputStream.class [jar] adding entry net/srcz/android/screencast/api/recording/QuickTimeOutputStream$1.class [jar] adding entry net/srcz/android/screencast/api/recording/QuickTimeOutputStream$Atom.class [jar] adding entry net/srcz/android/screencast/api/recording/QuickTimeOutputStream$CompositeAtom.class [jar] adding entry net/srcz/android/screencast/api/recording/QuickTimeOutputStream$DataAtom.class [jar] adding entry net/srcz/android/screencast/api/recording/QuickTimeOutputStream$Sample.class [jar] adding entry net/srcz/android/screencast/api/recording/QuickTimeOutputStream$States.class [jar] adding entry net/srcz/android/screencast/api/recording/QuickTimeOutputStream$VideoFormat.class [jar] adding entry net/srcz/android/screencast/api/recording/QuickTimeOutputStream$WideDataAtom.class [jar] adding entry net/srcz/android/screencast/api/recording/QuickTimeOutputStream.class [jar] adding entry net/srcz/android/screencast/app/Application$1.class [jar] adding entry net/srcz/android/screencast/app/Application$2.class [jar] adding entry net/srcz/android/screencast/app/Application.class [jar] adding entry net/srcz/android/screencast/app/SwingApplication$1.class [jar] adding entry net/srcz/android/screencast/app/SwingApplication.class [jar] adding entry net/srcz/android/screencast/ui/JDialogDeviceList$1.class [jar] adding entry net/srcz/android/screencast/ui/JDialogDeviceList.class [jar] adding entry net/srcz/android/screencast/ui/JDialogError.class [jar] adding entry net/srcz/android/screencast/ui/JDialogUrl$1.class [jar] adding entry net/srcz/android/screencast/ui/JDialogUrl.class [jar] adding entry net/srcz/android/screencast/ui/JFrameMain$1.class [jar] adding entry net/srcz/android/screencast/ui/JFrameMain$2.class [jar] adding entry net/srcz/android/screencast/ui/JFrameMain$3.class [jar] adding entry net/srcz/android/screencast/ui/JFrameMain$4.class [jar] adding entry net/srcz/android/screencast/ui/JFrameMain$5.class [jar] adding entry net/srcz/android/screencast/ui/JFrameMain$6.class [jar] adding entry net/srcz/android/screencast/ui/JFrameMain$KbActionListener.class [jar] adding entry net/srcz/android/screencast/ui/JFrameMain.class [jar] adding entry net/srcz/android/screencast/ui/JPanelScreen.class [jar] adding entry net/srcz/android/screencast/ui/JSplashScreen.class [jar] adding entry net/srcz/android/screencast/ui/MultiLineLabelUI.class [jar] adding entry net/srcz/android/screencast/ui/explorer/JFrameExplorer$1.class [jar] adding entry net/srcz/android/screencast/ui/explorer/JFrameExplorer$2.class [jar] adding entry net/srcz/android/screencast/ui/explorer/JFrameExplorer$FileTreeNode.class [jar] adding entry net/srcz/android/screencast/ui/explorer/JFrameExplorer$FolderTreeNode.class [jar] adding entry net/srcz/android/screencast/ui/explorer/JFrameExplorer.class [jar] adding entry net/srcz/android/screencast/ui/explorer/LazyLoadingTreeNode$1.class [jar] adding entry net/srcz/android/screencast/ui/explorer/LazyLoadingTreeNode$CancelWorkersAction.class [jar] adding entry net/srcz/android/screencast/ui/explorer/LazyLoadingTreeNode.class [jar] adding entry net/srcz/android/screencast/ui/explorer/LazyMutableTreeNode.class [jar] adding entry net/srcz/android/screencast/ui/pm/JFrameApps.class [jar] adding entry net/srcz/android/screencast/ui/worker/AccumulativeRunnable.class [jar] adding entry net/srcz/android/screencast/ui/worker/SwingWorker$1.class [jar] adding entry net/srcz/android/screencast/ui/worker/SwingWorker$2.class [jar] adding entry net/srcz/android/screencast/ui/worker/SwingWorker$3.class [jar] adding entry net/srcz/android/screencast/ui/worker/SwingWorker$4.class [jar] adding entry net/srcz/android/screencast/ui/worker/SwingWorker$5.class [jar] adding entry net/srcz/android/screencast/ui/worker/SwingWorker$6.class [jar] adding entry net/srcz/android/screencast/ui/worker/SwingWorker$7.class [jar] adding entry net/srcz/android/screencast/ui/worker/SwingWorker$DoSubmitAccumulativeRunnable.class [jar] adding entry net/srcz/android/screencast/ui/worker/SwingWorker$StateValue.class [jar] adding entry net/srcz/android/screencast/ui/worker/SwingWorker$SwingWorkerPropertyChangeSupport$1.class [jar] adding entry net/srcz/android/screencast/ui/worker/SwingWorker$SwingWorkerPropertyChangeSupport.class [jar] adding entry net/srcz/android/screencast/ui/worker/SwingWorker.class [jar] No Implementation-Title set.No Implementation-Version set.No Implementation-Vendor set. [jar] Location: C:\androidscreencast\androidscreencast\build.xml:34: [copy] Copying 1 file to C:\androidscreencast\androidscreencast\dist [copy] Copying C:\android-sdk-windows\tools\lib\ddmlib.jar to C:\androidscreencast\androidscreencast\dist\ddmlib-DEV.jar jnlp: [copy] Copying 1 file to C:\androidscreencast\androidscreencast\dist [copy] Copying C:\androidscreencast\androidscreencast\androidscreencast.jnlp to C:\androidscreencast\androidscreencast\dist\androidscreencast-DEV.jnlp [replace] Replacing in C:\androidscreencast\androidscreencast\dist\androidscreencast-DEV.jnlp: androidscreencast.jnlp --> androidscreencast-DEV.jnlp [replace] Replacing in C:\androidscreencast\androidscreencast\dist\androidscreencast-DEV.jnlp: androidscreencast.jar --> androidscreencast-DEV.jar [replace] Replacing in C:\androidscreencast\androidscreencast\dist\androidscreencast-DEV.jnlp: ddmlib.jar --> ddmlib-DEV.jar [replace] Replacing in C:\androidscreencast\androidscreencast\dist\androidscreencast-DEV.jnlp: version="1.0" --> version="DEV" [signjar] Signing JAR: C:\androidscreencast\androidscreencast\dist\androidscreencast-DEV.jar to C:\androidscreencast\androidscreencast\dist\androidscreencast- DEV.jar as cs.key [signjar] Current OS is Windows XP [signjar] Using input string [signjar] Executing 'C:\Program Files\Java\jdk1.6.0_18\bin\jarsigner.exe' with arguments: [signjar] '-keystore' [signjar] 'c:\Workspace\keytools\keys\cs.key' [signjar] 'C:\androidscreencast\androidscreencast\dist\androidscreencast-DEV.jar' [signjar] 'cs.key' [signjar] [signjar] The ' characters around the executable and arguments are [signjar] not part of the command. [signjar] Signing JAR: C:\androidscreencast\androidscreencast\dist\ddmlib-DEV.jar to C:\androidscreencast\androidscreencast\dist\ddmlib-DEV.jar as cs.key [signjar] Current OS is Windows XP [signjar] Using input string [signjar] Executing 'C:\Program Files\Java\jdk1.6.0_18\bin\jarsigner.exe' with arguments: [signjar] '-keystore' [signjar] 'c:\Workspace\keytools\keys\cs.key' [signjar] 'C:\androidscreencast\androidscreencast\dist\ddmlib-DEV.jar' [signjar] 'cs.key' [signjar] [signjar] The ' characters around the executable and arguments are [signjar] not part of the command. BUILD SUCCESSFUL Total time: 14 seconds PS C:\androidscreencast> -
∞ Flash as3 clickTag solution
public function handleClick(mouseEvent:MouseEvent):void { var interactiveObject:InteractiveObject = mouseEvent.target as InteractiveObject; var li:LoaderInfo = LoaderInfo(interactiveObject.root.loaderInfo); var url:String; for (var i:String in li.parameters) { if (i.toLowerCase() == "clicktag") { url = li.parameters[ i ]; } } if (url) { if (ExternalInterface.available) { ExternalInterface.call('window.open',url); }else { navigateToURL(new URLRequest(url),"_blank"); } }else { if(ExternalInterface.available) ExternalInterface.call('console.log', "ClickTAG: Couldn't find a valid clicktag variable"); } } myButton.addEventListener(MouseEvent.CLICK,handleClick);
-
∞ config.php for EE
<?php if ( ! defined('EXT')){ exit('Invalid file request'); } $conf['app_version'] = "168"; $conf['license_number'] = ""; $conf['debug'] = "1"; $conf['install_lock'] = "1"; $conf['db_hostname'] = "[mysql server]"; // Note: Must use the super admin since EE will // alter and add/remove columns. $conf['db_username'] = "xxxx"; $conf['db_password'] = "xxxx"; $conf['db_name'] = "xxx"; $conf['db_type'] = "mysql"; $conf['db_prefix'] = "exp"; $conf['db_conntype'] = "0"; $conf['system_folder'] = "[system folder name]"; $conf['cp_url'] = "http://[server]/[system]/index.php"; $conf['doc_url'] = "http://expressionengine.com/docs/"; $conf['cookie_prefix'] = ""; $conf['is_system_on'] = "y"; $conf['allow_extensions'] = "y"; $conf['multiple_sites_enabled'] = "n"; // rbanh: this is for migration: $conf['site_url'] = "http://[server]/"; $conf['tmpl_file_basepath'] = $conf['site_url'] . $conf['system_folder'] . "/templates/"; $conf['theme_folder_url'] = $conf['site_url'] . "themes/"; $conf['theme_folder_path'] = $conf['site_url'] . "themes/"; $conf['captcha_path'] = $conf['site_url'] . "images/captchas/"; $conf['captcha_url'] = $conf['site_url'] . "images/captchas/"; $conf['avatar_path'] = $conf['site_url'] . "images/members/avatars/"; $conf['avatar_url'] = $conf['site_url'] . "images/members/avatars/"; ?>
-
∞ simple report script using 4gl
########################################################################### # SIMPLE REPORT SCRIPT # PROGRAMMED BY: EMILIO VAZQUEZ @ 02-05-2010 # WEB : http://www.emiliovazquez.com # ############################################################################ # we will use this variable to store all data that we obtain from # our query results (var_orders) DEFINE var_orders RECORD LIKE orders.* DEFINE var_orderdate1 DATE, var_orderdate2 DATE MAIN DEFER INTERRUPT DEFER QUIT OPTIONS MESSAGE LINE 23, ERROR LINE LAST, PROMPT LINE LAST, HELP KEY CONTROL-W, HELP FILE "interhlp.ex", FORM LINE 3 INITIALIZE var_orders.* TO NULL #stores date for orders to be selected PROMPT " PLEASE ENTER INITIAL DATE FOR ORDERS: " FOR var_orderdate1 PROMPT " PLEASE ENTER FINAL DATE FOR ORDERS: " FOR var_orderdate2 CALL get_data() END MAIN #This function will contain the query to select our data FUNCTION get_data() DECLARE var_report CURSOR FOR SELECT * FROM orders WHERE order_date BETWEEN var_orderdate1 AND var_orderdate2 START REPORT rept #results from query above will be stored #in "var_orders",we are using an '*' since #we want multiple columns stored in a single variable #These rows will be taken from the 'var_report' cursor #declared above (DECLARE var_report CURSOR FOR ) FOREACH var_report INTO var_orders.* OUTPUT TO REPORT rept(var_orders.*) END FOREACH FINISH REPORT rept RETURN END FUNCTION #This function will receive the data #from get_data() REPORT rept(r_orders) #variables para creacion de reportes DEFINE r_orders RECORD LIKE orders.* OUTPUT LEFT MARGIN 0 TOP MARGIN 0 BOTTOM MARGIN 0 PAGE LENGTH 60 REPORT TO "report.txt" # A text file will be generated into the directory # where the program was executed FORMAT #page header will be printed once in first page PAGE HEADER #Page size is set to 80 columns and paper orientation to portrait LET col = (80 - LENGTH(xt))/2 + 1 SKIP 2 LINES PRINT COLUMN 01, today, COLUMN col, xt CLIPPED, COLUMN 77, pageno using "####" SKIP 3 LINES PRINT COLUMN 01, "SAMPLE REPORT --------------------------" SKIP 2 LINES PRINT COLUMN 01, "ORDER NUM.", COLUMN 10, "DATE", COLUMN 25, "CUST.NAME", COLUMN 35, "ITEM NUM.", COLUMN 40, "DESCRIPTION", COLUMN 60, "TOTAL" ON EVERY ROW # Each row will be printed below PRINT COLUMN 01, r_orders.order_id, COLUMN 10, r_orders.order_date, COLUMN 25, r_orders.customer_name CLIPPED,# clipped is used to cut extra spaces in cells COLUMN 35, r_orders.item_number CLIPPED, COLUMN 40, r_orders.description CLIPPED, COLUMN 60, r_orders.total USING "<<<<<.&&" ON LAST ROW #total number of rows will be printed here using count(*) PRINT COLUMN 01, "total: ", count(*) USING "<<<" END REPORT
-
∞ create DB utf8
CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;
-
∞ SSH via TOR using SOCAT
# start TOR tor # create tunnel socat TCP-LISTEN:<port> SOCKS4A:localhost:<host>:22,socksport=9050 # login through local tunnel ssh <user>@localhost -p <port>
-
∞ htaccess redirect all traffic to homepage
<IfModule mod_rewrite.c> RewriteEngine On RewriteBase / RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . http://domain.tld/index.php [L] </IfModule>
-
∞ image link
<? $img_path = "/images/arr_leggi_blu.gif"; $link_path = "node/47"; $theme_name = 'pmsth'; $img = theme('image', drupal_get_path('theme', 'pmsth'). $img_path); print l($img, $link_path, array('html' => true)); ?>
-
∞ image
<? $path = "/images/arr_leggi_blu.gif"; $theme_name = 'pmsth'; print theme('image', drupal_get_path('theme', $theme_name). $path); ?>
-
∞ link
<? $anchor = "anchor text"; $drupal_path = "node/47"; print l($anchor, $drupal_path); ?>
-
∞ detect duplicate names in fasta and give a suggestion
import sys from sets import Set from collections import defaultdict import random def get_optimal (start, length, reverse_Collision): optimal = list () counter = 0 stop = 0 for i in sorted(reverse_Collision): if stop == 1: break for j in sorted(reverse_Collision[i]): if counter >= start: optimal.append (j) #print reverse_Collision[i][j] counter = counter + 1 if (counter-start) == Length: stop = 1 break return optimal Trial = 2 Length = 7 Collision = dict() Collection = [] allNames = list() for line in sys.stdin: allNames.append (line.rstrip()) for i in range(len(line.rstrip())): if len(Collection) == i: #print "first if " + line [i] Collection.append(Set()) Collection[i].add(line[i]) Collision[i] = 0 else: #print "first else " + line [i] if line[i] in Collection[i]: Collision[i] = Collision[i] + 1 else: Collection[i].add (line[i]) reverse_Collision = defaultdict(list) for key in Collision: #print key reverse_Collision[Collision[key]].append(key) #print Collision[key] #print reverse_Collision fail = 2 start = 0 taken = Set() optimal = list() while fail != 0: optimal = get_optimal (start, Length, reverse_Collision) times = 0 if (len(taken) + 1) >= len(allNames): fail = 0 #print "len(allNames) - 1 " + str(len(allNames) - 1) if fail != 0: index = random.randint(0, len(allNames) - 1) while index in taken: index = random.randint(0, len(allNames) - 1) taken.add (index) sample = "" for i in range(len(optimal)): sample = sample + allNames[index][optimal[i]] #print sample for i in range (len(allNames)): if fail == 1: output = "" for k in range(len(optimal)): output = output + " " + str(optimal[k]) print "Positions" + output + " fail." break if i not in taken: times = times + 1 target = "" for j in range(len(optimal)): target = target + allNames[i][optimal[j]] if sample == target: print "Collision found" fail = 1 start = start + 1 break print times if times == Trial: fail = 0 print "Try " + str(times) + " times. No collision found!" output = "" if fail == 0: for k in range(len(optimal)): output = output + " " + str(optimal[k]) print "I suggest positions " + output + "." #print i #print sorted_Collision_values
-
∞ List Sql Server Sessions
select min(login_time) as logintime, loginame, hostname, program_name, db.Name as "database_name" from master.dbo.sysprocesses inner join master.dbo.sysdatabases as db on master.dbo.sysprocesses.dbid = db.dbid group by loginame, hostname, program_name,db.name order by loginame
-
∞ correct the names in ANME1Endseqs GenDB project
import sys import re from sets import Set import MySQLdb hostname = sys.argv[1] dbname = sys.argv[2] username = sys.argv[3] password = sys.argv[4] conn = MySQLdb.connect (host = hostname, user = username, passwd = password, db = dbname) cursor = conn.cursor () f = open ('/megx/home/shuang/sequences/BSMallEndseqForHanno.fas') pms = set() for line in f.readlines(): if line.startswith(">"): result = line.rstrip().split (" ") #print result for pm_result in result: pms.add(pm_result[1:]) f.close() #print pms f_match = re.compile (r'f_(\d+)([a-z]+)_(\w+)') a_match_2 = re.compile (r'a4_([0-9a-z]+)_m_([a-z0-9]+)') a_match = re.compile (r'a4_([0-9a-z]+)_([0-9a-ln-z]+)([_a-z0-9]*)') a5_match = re.compile (r'a5_([0-9a-z]+)_([a-z]+)_([a-z0-9]+)') b_match = re.compile (r'b(\d+)_([0-9a-z]+)_([rf])_(b\d+)') command1="SELECT description from Sequence" #print command1 cursor.execute (command1) resultset = cursor.fetchall () for name in resultset: output = "" #print result.group(1) f_result = f_match.match (name[0]) if f_result: PM_name = "fc1f" + f_result.group(1) + "-es_" + f_result.group(2) + "7." + f_result.group(3) PM_name_1= "fc1f" + f_result.group(1) + "-es_" + f_result.group(2) + "1328." + f_result.group(3) if PM_name in pms: output = PM_name elif PM_name_1 in pms: output = PM_name_1 else: print "no " + PM_name + "\t" + name[0] a_result_2 = a_match_2.match (name[0]) if a_result_2: PM_name = "anke4-" + a_result_2.group(1) + "_f40.m1328." + a_result_2.group(2) if PM_name in pms: output = PM_name else: print "no " + PM_name + "\t" + name[0] #print PM_name a_result = a_match.match (name[0]) if a_result: PM_name = "anke4-" + a_result.group(1) + "_f40." + a_result.group(2).replace ("_", ".") if len(a_result.groups()) == 3: PM_name = PM_name + a_result.group(3).replace ("_", ".") if PM_name in pms: output = PM_name else: print "no " + PM_name + "\t" + name[0] + " a_result.groups(): " + str(len(a_result.groups())) #print PM_name a5_result = a5_match.match (name[0]) if a5_result: PM_name = "anke5" + a5_result.group(1) + "-es_" + a5_result.group(2) + "1328." + a5_result.group(3) PM_name_1= "anke5" + a5_result.group(1) + "-es_" + a5_result.group(2) + "7." + a5_result.group(3) if PM_name in pms: output = PM_name elif PM_name_1 in pms: output = PM_name_1 else: print "no " + PM_name + "\t" + name[0] b_result = b_match.match (name[0]) if b_result: PM_name = "fcb" + b_result.group(1) + "-" + b_result.group(2) + "." + b_result.group(3) + "f40_" + b_result.group(4) + ".SCF" if PM_name in pms: output = PM_name else: print "no " + PM_name + "\t" + name[0] command2 = "Update Sequence set name = '" + output + "' where description = '" + name[0] + "';" #print command2 cursor.execute(command2) print "finished!" #print output #print output.rstrip()
-
∞ Correct the names from ANME1_Endseqs GenDB project according to original fasta file
import sys import re from sets import Set f = open ('/Users/user/Downloads/BSMallEndseqForHanno.fas') pms = set() for line in f.readlines(): if line.startswith(">"): result = line.rstrip().split (" ") #print result for pm_result in result: pms.add(pm_result[1:]) f.close() #print pms matchobj = re.compile (r'(\S+):\s+\d+\.\d+') f_match = re.compile (r'f_(\d+)([a-z]+)_(\w+)') a_match = re.compile (r'a4_([0-9a-z]+)_(\w+)') a5_match = re.compile (r'a5_([0-9a-z]+)_([a-z]+)_([a-z0-9]+)') b_match = re.compile (r'b(\d+)_([0-9a-z]+)_([rf])_(b\d+)') for line in sys.stdin: names = line.split("\t") output = "" for name in names: result = matchobj.match (name) if result: #print result.group(1) f_result = f_match.match (result.group(1)) if f_result: PM_name = "fc1f" + f_result.group(1) + "-es_" + f_result.group(2) + "7." + f_result.group(3) PM_name_1= "fc1f" + f_result.group(1) + "-es_" + f_result.group(2) + "1328." + f_result.group(3) if PM_name in pms: output = output + PM_name + " " elif PM_name_1 in pms: output = output + PM_name_1 + " " else: print "no " + PM_name + "\t" + result.group(1) a_result = a_match.match (result.group(1)) if a_result: PM_name = "anke4-" + a_result.group(1) + "_f40." + a_result.group(2).replace ("_", ".") if PM_name in pms: output = output + PM_name + " " else: print "no " + PM_name + "\t" + result.group(1) #print PM_name a5_result = a5_match.match (result.group(1)) if a5_result: PM_name = "anke5" + a5_result.group(1) + "-es_" + a5_result.group(2) + "1328." + a5_result.group(3) PM_name_1= "anke5" + a5_result.group(1) + "-es_" + a5_result.group(2) + "7." + a5_result.group(3) if PM_name in pms: output = output + PM_name + " " elif PM_name_1 in pms: output = output + PM_name_1 + " " else: print "no " + PM_name + "\t" + result.group(1) b_result = b_match.match (result.group(1)) if b_result: PM_name = "fcb" + b_result.group(1) + "-" + b_result.group(2) + "." + b_result.group(3) + "f40_" + b_result.group(4) + ".SCF" if PM_name in pms: output = output + PM_name + " " else: print "no " + PM_name + "\t" + result.group(1) print output #print output.rstrip()
-
∞ Replace the output of wp_list_pages();
<?php $page_output = wp_list_pages('echo=0&title_li=&sort_column=menu_order&depth=1&include='.$page_ids); $page_output = preg_replace('@\<li([^>]*)>\<a([^>]*)>(.*?)\<\/a>@i', '<li$1><a$2><span>$3</span></a>', $page_output); echo $page_output; ?>
-
∞ Generate picture of static in shape of sine wave (Processing Language)
void setup() { size(800,800); frameRate(30); } float divisor = 1; int frame = 1; void draw() { // Before we deal with pixels loadPixels(); // Loop through every pixel for (int i = 0; i < pixels.length; i++) { // Pick a random number, 0 to 255 float rand = random(255*sin(float(i)/(pixels.length/divisor))); // Create a grayscale color based on random number color c = color(rand); // Set pixel at that location to random color pixels[i] = c; } // When we are finished dealing with pixels updatePixels(); //if (frame > 6) { // divisor++; // frame = 0; //} else { // frame++; //} print (divisor); divisor = divisor * 1.1 ; print( "\n"); saveFrame("/Users/ben/Desktop/static_frames/static_frame_######.jpg"); }
-
∞ GPG Basics
# generate key gpg --gen-key # export public key in ASCII format gpg --export -a <username> > <filename> # import public key gpg --import <filename> # remove public key gpg --delete-key <username> # list all public keys gpg --list-keys # encrypt file gpg --encrypt --recipient <username> <filename> gpg -e -r <username> <filename> # decrypt file gpg --decrypt <filename> gpg -d <filename> # add email address gpg --edit-key <username> adduid # sign public key gpg --sign-key <username> # list signatures gpg --list-sigs [<username>] # receive keys from server using key ids gpg [--keyserver <server>] --recv-keys <keyid> # send signed key gpg [--keyserver <server>] --send-key <keyid> # update already received keys gpg [--keyserver <server>] --refresh-keys
MySQL in a Nutshell