Skip to content

Instantly share code, notes, and snippets.

View vielhuber's full-sized avatar
🍐
❹❷

David Vielhuber vielhuber

🍐
❹❷
42 followers · 3 following
View GitHub Profile
@vielhuber
vielhuber / index.php
Last active September 22, 2017 23:12
DB Update #joomla
$fields = array(
$db->quoteName('name').' = '.($db->quote($_POST["name"])),
$db->quoteName('content').' = '.($db->quote($_POST["content"])),
$db->quoteName('subtitle').' = '.(($_POST["subtitle"] != "")?($db->quote($_POST["subtitle"])):("NULL")),
$db->quoteName('content').' = '.(($_POST["content"] != "")?($db->quote($_POST["content"])):("NULL"))
);
$db->setQuery($db->getQuery(true)->update($db->quoteName('#__js_table'))->set($fields)->where($db->quoteName('ID').' = '.$db->quote($_GET["ID"])))->execute();
@vielhuber
vielhuber / index.php
Last active September 22, 2017 23:12
get user ID #joomla
$user_id = JFactory::getUser()->id;
if( !$user_id ) { die('error'); }
@vielhuber
vielhuber / index.php
Last active September 22, 2017 23:12
DB Insert #joomla
$db->setQuery($db->getQuery(true)->insert($db->quoteName('#__js_table'))
->columns($db->quoteName(array('created','name','subtitle','pos','content','parent_id')))
->values(implode(',', array(
$db->quote(date('Y-m-d H:i:s',strtotime('now'))),
$db->quote($name),
"NULL",
$pos,
"NULL",
(($parent_id != "")?($parent_id):("NULL"))
))))->execute();
@vielhuber
vielhuber / index.php
Last active September 22, 2017 23:12
delete row #joomla
$db->setQuery($db->getQuery(true)->delete($db->quoteName('#__js_table'))->where($db->quoteName('ID').' = '.$id))->execute();
@vielhuber
vielhuber / index.html
Last active September 22, 2017 23:12
textarea Maxlength crossbrowser #js
<span class="counter">150</span>
<textarea data-maxlength="150"></textarea>
@vielhuber
vielhuber / style.css
Last active September 22, 2017 23:12
truncate too long word with ... (dot dot dot) at the end #css
overflow:hidden;
text-overflow: ellipsis;
white-space: nowrap;
@vielhuber
vielhuber / README.MD
Last active August 15, 2025 23:09
ffmpeg: Video convert m2ts to mp4, mp4 to webm, mp4 to ogv, mp3 wav hz, extract frames #tools

video convert m2ts to mp4, mp4 to webm, mp4 to ogv

mp4 to mp4 (medium)

ffmpeg -i input.mp4 -b 1000000 output.mp4

m2ts to mp4

ffmpeg -i input.m2ts -vcodec libx264 -crf 20 -acodec ac3 -vf "yadif" output.mp4
@vielhuber
vielhuber / functions.php
Last active September 22, 2017 23:12
remove header from login page #wordpress
function custom_login() {
echo '<style type="text/css">'.
'#login h1, #login #nav, #login #backtoblog { display:none; }'.
'</style>';
}
add_action( 'login_enqueue_scripts', 'custom_login' );
@vielhuber
vielhuber / script.js
Last active September 22, 2017 23:12
ajaxize complete page with pushState #js
See github
@vielhuber
vielhuber / script.js
Last active September 22, 2017 23:12
when both animation and post/load are finished, execute function #js
$.when(
$('.box').animate({ opacity: 0 }, 1000, 'linear'),
$.post( $(this).closest('form').attr('action'), $(this).closest('form').serialize() )
).then(function () {
alert('both finished');
});