renekreijveld

#!/bin/sh

# findlargefiles - Find all image files with a resolution wider then a given width.
# Supports Joomla versions 1.0 - 3.3
#
# Copyright 2014 Rene Kreijveld - email@renekreijveld.nl
#
# This program is free software; you may redistribute it and/or modify it.

# Define general variables

renekreijveld

@echo off

for /f "tokens=1-8 delims=.:/-, " %%i in ('echo exit^|cmd /q /k"prompt $D $T"') do (
	for /f "tokens=2-4 delims=/-,() skip=1" %%a in ('echo.^|date') do (
		set dow=%%i
		set mm=%%j
		set dd=%%k
		set yy=%%l
		set hh=%%m
		set min=%%n

renekreijveld

@ECHO OFF

REM Sitenaam ophalen
FOR /F "tokens=4" %%G IN ('FINDSTR /C:"$sitename =" configuration.php') DO (
	FOR /F "tokens=1 delims='" %%A IN ('echo %%G') DO (
		SET jsitename=%%A
	)
)

REM Host ophalen

renekreijveld

@ECHO OFF

REM Joomla info ophalen
call "jinfo.cmd" > nul

REM Output data
ECHO Sitename = %jsitename%
ECHO Host     = %jhost%
ECHO Database = %jdb%
ECHO User     = %juser%

renekreijveld

#!/bin/sh

# jdbsession -- Repair the session table of a Joomla database table.
#
# This scripts supports Joomla versions 1.0 - 3.3
#
# Copyright 2014 Rene Kreijveld - email@renekreijveld.nl
#
# This program is free software; you may redistribute it and/or modify it.
#

renekreijveld

#!/bin/sh

# jdbrepair -- Repair all tables of a joomla database.
#
# This scripts supports Joomla versions 1.0 - 3.3
#
# Copyright 2014 Rene Kreijveld - email@renekreijveld.nl
#
# This program is free software; you may redistribute it and/or modify it.
#

renekreijveld

-- Upgrade Joomla 2.5.7 database to Joomla 3.3.6 database
-- Written by: Rene Kreijveld
--
-- This script is provided "as is", without any accompanying services or warranties from Rene Kreijveld.
--
-- Please read these instructions carefully!
-- Before you de ANY update, migration or modification, make sure you have a working backup of your website(s)!
--
-- To use this script do the following:
--

renekreijveld

<?php
// Template by DSD business internet // www.gakijken.nl //
defined('_JEXEC') or die;

// Connect with Joomla
$app            = JFactory::getApplication();
$doc            = JFactory::getDocument();
$session        = JFactory::getSession();

// Get variables

renekreijveld

$zoekadres = $l_adres." ".$l_postcode." ".$l_plaats." ".$l_land;
$zoekadres = urlencode($zoekadres);
$url = "http://maps.google.com/maps/api/geocode/json?sensor=false&address={$zoekadres}";
$resp_json = file_get_contents($url);
$resp = json_decode($resp_json, true);
if($resp['status']=='OK') { 
	$lat = $resp['results'][0]['geometry']['location']['lat'];
	$lng = $resp['results'][0]['geometry']['location']['lng'];
} else {
	$lat = "";

renekreijveld

<?php
// Select record, all fields
$query = $db->getQuery(true)
	->select('*')
	->from($db->quoteName('#__table'))
	->where($db->quoteName('id') . ' = '. (int) $searchId);
$db->setQuery($query);
$results = $db->loadObjectlist();

// Select record, specific fields