Posts filed in ‘Computer’
SVN External with different username
Today I had to add and SVN external project to my wordpress based project, nothing strange but the fact that the external project (NextGen Gallery) is hosted on Google Code and the authentication is different from my main repository.
After a bit of search I've found that you can specify the user for external resource by adding it before the domain with a @ so, for me the sintax was:
nextgen-gallery https://simone.fumagalli@nextgen-gallery.googlecode.com/svn/trunk/
Once you set up the SVN property give an update to the working folder and Eclipse will ask for the password.
SVN External with a different username in Eclipse
Custom thumbnails for NGG galleries
[NB] This feature will be available in NGG 1.2 You can already test it by checking out the trunck version from here
This is a small extension for NextGen Gallery, it allow you to specify which area NGG must use to generate the the thumbnail.
Quite often the thumbnails generated by NGG do not show the "right" part of the picture, this happen especially when you have a gallery with people, where you want to show in the thumb the face and not the belly.
Demo
Have a look here where you can see two galleries (same pictures) the first with the standard and the second with custom thumbnails.
Installation
First unpack the archive to the NGG root directory, then open manage-images.php and modify line 338 from
<img class="thumb" src="<?php echo $picture->thumbURL; ?>" <?php echo $thumbsize ?> />
to
<img class="thumb" id="thumb<?php echo $pid ?>" src="<?php echo $picture->thumbURL; ?>" <?php echo $thumbsize ?> />
and add this line at the end of nggallery.php
include_once (dirname (__FILE__)."/admin/custom_thumbnails.php");
Download
Here the package for the version 0.2 it ONLY works with WP 2.7 and NGG 1.0
Screenshots
List with "Edit thumbnail" action
Popup for area selection
Get back Insert media button in WPMU
This is a really simple plugin I always add to my default installation of WPMU. Nowadays embedded media are really commons in blog's post and all my customers were asking for it.
I found the plugin "Allow Embedded Videos" (http://wpmudev.org/project/Allow-Embedded-Videos) but still the button in the editor didn't show up.
CSV export from MySQL
If you have access on the machine with MySQL and you need to export all tables in a database you can use:
hpatoio@namazu:~$ mysqldump -uroot -p DATABASE_NAME -T '/home/simone/export_csv' --fields-terminated-by "," --fields-enclosed-by '"' --lines-terminated-by "\n"
the script will create a files for each table of the DB and will place it in export_csv.
If you need to export a custom resultset or you need to export data from a remote MySQL server on your machine you can use this command :
hpatoio@namazu:~$ mysql -uroot -h HOSTNAME -p DATABASE_NAME -B -e "select field1,field2 ... fieldX from \`TABLE_NAME\`;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > my_export.csv
Finally ! What you see is what you mean
I was looking for a good and clean editor for one of my customers, and I end up to WYMeditor !
That's the way I like, that's the way I meant !
Add days to a date in javascript
shiftDay = 10
var myDate = new Date();
myDate.setDate(myDate.getUTCDate() + shiftDay)
day = myDate.getUTCDate()
month = myDate.getUTCMonth()*1 + 1
year = myDate.getUTCFullYear()
This code is quite easy:
- shiftDay hold the number of days you want to add, if you need to go backwards you can set it to a negative value.
- myDate is set to the current date
- At the end we will have the data we need in day, month and year.
- getUTCMonth return the current month shifted back by one (January is 0, February is 1 and so on) that's why we add 1. We multiply the value returned by getUTCMonth by one to cast it to integer.