I have developed a simple PHP class to connect to the online version of Microsoft Dynamics 2011.
It uses SOAP and logs in via Windows Live.
$dynamicsClient = new dynamicsClient('you@org.com','password','org.crm4.dynamics.com',1);
$request = 'XML HERE'
echo $dynamicsClient->sendQuery($request);A client had installed WordPress inside a subfolder but then had bought a domain she wished to use. However WordPress links were hardcoded to the old subfolder? Here’s the SQL queries that migrated it to the new domain.
UPDATE wp_posts SET guid = replace(guid,"oldsite.com/subfolder","newsite.com") UPDATE wp_posts SET post_content = replace(post_content,"oldsite.com/subfolder","newsite.com") UPDATE wp_options SET option_value = replace(option_value,"oldsite.com/subfolder","newsite.com")
Recently I was working on a Facebook app and I needed to grab a history of a users status updates. I found the Facebook API quite badly documented. This is the FQL code I used. You need to define $facebook with your app key and make sure your app has permissions to access users status updates.
$sql = "SELECT message,time FROM status WHERE uid = ".$uid; $param = array( 'method' => 'fql.query', 'query' => $sql, 'callback' => '' ); $fqlResult = $facebook->api($param);
I am currently working on a PHP script that will pass a large number of queries to the tvrage.com API and format the data in a jQuery sortable table. I will hopefully have a beta up soon. Its refreshing when such a large database of information has such an easy to use API.
I needed to extract some screenshots from a video file on Debian. I knew I could do this with FFmpeg but I wanted to take four every 20 mins so I wrote a quick script in bash.
The usage is ./sc.sh [filename] [number of screenshots to produce]
#!/bin/bash file=$1 times=$2 x=1 while [ $x -le $times ]; do ffmpeg -ss $(echo "$x * 1200" | bc -l) -i "$file" -an -vframes 1 -f image2 images$(echo "$x").png; x=$(( $x + 1 )) done
I fixed this a long time ago but its my first official advisory (Thanks s3rv3r_hack3r) so I am quite proud. Also my first lesson in input sanitization. Here’s the advisory in 2006 and here’s how I fixed it.
if (!get_magic_quotes_gpc()) {
$file = addslashes($file);
}
#!/bin/bash file=$1 times=$2 x=1 while [ $x -le $times ]; do ffmpeg -ss $(echo "$x * 1200" | bc -l) -i "$file" -an -vframes 1 -f image2 images$(echo "$x").png; x=$(( $x + 1 )) done
package require http
bind pubm -|- "*" dller
proc dller {nick uhost hand chan text} {
# Set your download dir here
set watchdir "/home/path/to/download/dir"
# Put your regex patterns here
set patterns(1) {^(Something|Else)\.*\.dll}
set patterns(2) {^(Test)\.*\.exe}
# Do not edit below here
set line [stripcodes bcruag $text]
foreach pattern [array names patterns] {
if { [regexp $patterns($pattern) line] } {
set token [::http::geturl $dll]
set outfile [open $watchdir/$line w]
fconfigure $outfile -translation binary
puts -nonewline $outfile [::http::data $token]
close $outfile
}
}
}
putlog "Regex downloader by Ben Speakman loaded..."
