SELECT password FROM accounts,mail WHERE mail.mail_name LIKE '%username%' AND accounts.id = mail.account_id
SELECT password FROM accounts,mail WHERE mail.mail_name LIKE '%username%' AND accounts.id = mail.account_id
To enable passive mode for FTP connections on your server:
1 Log in as “root” to the server shell over SSH.
2 Edit your ProFTPD configuration file.
a Issue the command vi /etc/proftpd.conf
b Add the following lines anywhere within the <Global> section:
PassivePorts 49152 65534
c Save the file
3 Log in to Parallels Plesk Panel as “admin”, go to Modules > Firewall, and
click Edit Firewall Configuration.
4 Click Add Custom Rule.
5 Specify the following:
a Rule name
b Direction: select Incoming.
c Action: select Allow.
d Ports: in the Add port input box, enter the value 49152-65534. Leave the TCP
option selected, and click Add.
PassivePorts 60000 65535
The LENGTH() function in MySQL returns the length of a string in bytes. Multi-byte characters will count as multiple bytes. The examples in this post will use the LENGTH() function but you can substitute them with the CHAR_LENGTH() function instead if you want to count the number of characters rather than bytes. Note that CHAR_LENGTH will treat a character that uses two bytes a one single character and would return 1.Read More
Mount the partition your Ubuntu Installation is on. If you are not sure which it is, launch GParted (included in the Live CD) and find out. It is usually a EXT4 Partition. Replace the XY with the drive letter, and partition number, for example: sudo mount /dev/sda1 /mnt.
sudo mount /dev/sdXY /mnt
Now bind the directories that grub needs access to to detect other operating systems, like so.
Now we jump into that using chroot.
Now install, check, and update grub.
This time you only need to add the drive letter (usually a) to replace X, for example: grub-install /dev/sda, grub-install –recheck /dev/sda.
grub-install /dev/sdX
grub-install --recheck /dev/sdX
Now grub is back, all that is left is to exit the chrooted system and unmount everything.
Shut down and turn your computer back on, and you will be met with the default Grub2 screen.
You may want to update grub or re-install burg however you like it.
Type at the command prompt
sudo apt-get install python-software-properties
sudo add-apt-repository ppa:nvidia-vdpau/ppa
sudo add-apt-repository ppa:team-xbmc
The Xorg build in Karmic seems to have the composite extension turned on by default which caused horrible tearing on my build. This can be disabled by adding the following to your xorg.conf file:
Section "Extensions"
Option "Composite" "Disable"
EndSection
This fixed the problem with xbmc but caused some ugly problems with gdm which caused the display to not refresh properly when the xsplash animations played.
How to:
http://www.springydevelopment.co.uk/2009/11/08/minimal-install-of-xbmc-on-ubuntu-karmic-koala/
http://www.webupd8.org/2009/08/how-to-install-nvidia-190xx-drivers-in.html <– Nvidia drivers