Vinh v9n

🛫

forward email at mailwip.com

v9n / Readd files into svn

Created July 29, 2010 17:27

svn status | grep "^\?" | awk '{print $2}' | xargs svn add

v9n / remove all .svn folder

Created July 29, 2010 17:29

find . -name ".svn" -exec rm -Rf ./{} \;

v9n / get most recent comments with the post

Created August 23, 2010 10:03

	function axcoto_get_lastest_comments() {
	global $wpdb;
	$sql = "
	SELECT c.comment_ID, c.comment_author, c.user_id, c.comment_content,
	p.post_title, p.ID
	FROM $wpdb->comments as c
	LEFT JOIN $wpdb->posts as p ON p.ID=c.comment_post_ID
	WHERE c.comment_approved=1
	ORDER BY c.comment_date DESC
	LIMIT 5

v9n / wordpress-useradd.php

Created August 24, 2010 09:08

	function userAdd($username, $password, $email) {
	if (get_user_by_email($email)) {
	return array('error' => 1, 'msg' => '<span>This email has already taken</span>');
	}
	if (get_user_by('login', $username) \|\| get_user_by('slug', $username)) {
	return array('error' => 2, 'msg' => '<span>This username has already taken</span>');
	}
	if (wp_create_user($username, $password, $email)) {
	return array('error' => 0);
	};

v9n / gist:549958

Created August 25, 2010 17:48

	//RAW SQL
	SELECT u.ID, u.user_nicename
	FROM wp_users AS u
	LEFT JOIN wp_usermeta AS m ON m.user_id=u.ID AND m.meta_key='wp_capabilities'
	WHERE m.meta_value LIKE '%contributor%'

	//PHP
	$sql = "
	SELECT u.ID, u.user_nicename
	FROM $wpdb->users AS u

v9n / create transparent image with gd.php

Created September 3, 2010 09:07

	<?php
	$textImages[$index] = imagecreatetruecolor($textBox['width'], $textBox['height']);
	imagealphablending($textImages[$index], true);
	imagesavealpha($textImages[$index], true);

	$overlayColor = imagecolorallocatealpha($textImages[$index], 0, 0, 0, 127);
	imagefill($textImages[$index], 0 , 0, $overlayColor);
	?>

v9n / Multi Jquery.html

Created September 7, 2010 16:34

	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

	<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
	<head>

	<script src="http://jqueryjs.googlecode.com/files/jquery-1.3.2.min.js" type="text/javascript"></script>
	<script>
	$j1 = jQuery.noConflict();
	(function ($) {

v9n / get_post_today.sql

Created November 14, 2010 07:26

Simple method to get post in current date

	SELECT COUNT(*)
	FROM rico_bb_topics
	WHERE TO_DAYS(topic_start_time)=TO_DAYS(CURDATE());

v9n / load_external_css.jquery.js

Created November 16, 2010 10:39

dynamic load external css

v9n / get_est_time.php

Created December 20, 2010 07:51

Get EST TIME

	<?php
	//EST is 3 hours foward of LA time
	date_default_timezone_set('America/Los_Angeles');
	$date = date("Y-m-d", time() + 3600 * 3);