Skip to content

Instantly share code, notes, and snippets.

View jklein's full-sized avatar

Jonathan Klein jklein

View GitHub Profile
@jklein
jklein / gist:5426753
Created April 20, 2013 17:32
Export Joomla 1.5 users to XML
<?php
$m = new mysqli('localhost', 'root', '<password>', 'buda_prod');
$result = $m->query('Select * from jos2_users');
while ($row = $result->fetch_assoc()) {
$results[] = $row;
}
Create Table: CREATE TABLE `buda_users_public_bak` (
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`user_name` varchar(100) NOT NULL DEFAULT '',
`email` varchar(100) NOT NULL DEFAULT '',
`password` varchar(16) DEFAULT NULL,
`first_name` varchar(100) NOT NULL DEFAULT '',
`last_name` varchar(100) NOT NULL DEFAULT '',
`edited_date` datetime DEFAULT NULL,
`edited_by` varchar(50) DEFAULT NULL,
`modification_id` varchar(50) DEFAULT NULL,
Create Table: CREATE TABLE `buda_users_contact_info_bak` (
`object_id` int(11) NOT NULL DEFAULT '0',
`alias` varchar(100) DEFAULT NULL,
`street_address_1` varchar(100) DEFAULT NULL,
`street_address_2` varchar(100) DEFAULT NULL,
`city` varchar(50) DEFAULT NULL,
`zip` varchar(10) DEFAULT NULL,
`state` varchar(50) DEFAULT NULL,
`tel_work` varchar(50) DEFAULT NULL,
`tel_home` varchar(50) DEFAULT NULL,
(function(Etsy) {
Etsy.Monitoring = {
page_group: 'browse_subcategory',
BW: { enabled: false }
};
var iframe = document.createElement('iframe');
iframe.src="javascript:false";
(iframe.frameElement || iframe).style.cssText = "width: 0; height: 0; border: 0";
var where = document.getElementsByTagName('script')[0];
@jklein
jklein / gist:5001670
Last active December 14, 2015 00:49
CSS/HTML for Sunny
<style>
.related_video {
clear:both;
width:100%;
margin-bottom:20px;
}
.related_video img {
float:left;
margin: 0px 5px 5px 5px;