stajnert

## Remove \n and \r mysql
UPDATE table SET column = REPLACE(REPLACE(column, '\r', ''), '\n', '');

## duplicates.sql
Single records:

SELECT column, COUNT(*) AS c
FROM table
GROUP BY column
HAVING COUNT(c) > 1

All records:

SELECT *

## sfWidgetFormChoiceFormatter.php
    /**
     * Metoda konfiguruje formularz
     */
     public function configure()
     {
        $this->widgetSchema['cities'] = new sfWidgetFormChoice(array(
                    'expanded' => true,
                    'multiple' => true,
                    'choices' => Doctrine_Core::getTable('hall')->getListNameForOpenHall(),
                    'renderer_options' => array('formatter' => array($this, 'formatter'))

## File extension.php
function getFileExtension($file_name)
{
   return substr(strrchr($file_name, '.'), 1);
}

## even_odd.php
<?php foreach ($jobs as $i => $job): ?>
      <tr class="<?php echo fmod($i, 2) ? 'even' : 'odd' ?>">
<?php endforeach; ?>

## slugify.php
<?php
/**
 * Function creates url properly slug from $text
 *
 * @param string $text
 */
public function slugify($text)
{
    // replace non letter or digits by -
    $text = preg_replace('#[^\\pL\d]+#u', '-', $text);

## FlxZipArchive.class.php
<?php

class FlxZipArchive extends ZipArchive
{

    /**
     * Add a Dir with Files and Subdirs to the archive
     *
     * @param string $location Real Location
     * @param string $name Name in Archive

## browser.html
<html>
<body>
<script type="text/javascript">
var BrowserDetect = {
	init: function () {
		this.browser = this.searchString(this.dataBrowser) || "An unknown browser";
		this.version = this.searchVersion(navigator.userAgent)
			|| this.searchVersion(navigator.appVersion)
			|| "an unknown version";
		this.OS = this.searchString(this.dataOS) || "an unknown OS";

## integer.js
var int = $(this).attr('id').match(/\d+/);

## strongPassword.php
    <?php
    /**
     * Function generates password depend on configuration sets
     *
     * @param int $length
     * @param boolean $add_dashes
     * @param string $available_sets
     * @return string
     */
    public static function generateStrongPassword($length = 10, $add_dashes = false, $available_sets = 'luds')
	Single records:

	SELECT column, COUNT(*) AS c
	FROM table
	GROUP BY column
	HAVING COUNT(c) > 1

	All records:

	SELECT *
	/**
	* Metoda konfiguruje formularz
	*/
	public function configure()
	{
	$this->widgetSchema['cities'] = new sfWidgetFormChoice(array(
	'expanded' => true,
	'multiple' => true,
	'choices' => Doctrine_Core::getTable('hall')->getListNameForOpenHall(),
	'renderer_options' => array('formatter' => array($this, 'formatter'))
	function getFileExtension($file_name)
	{
	return substr(strrchr($file_name, '.'), 1);
	}
	<?php foreach ($jobs as $i => $job): ?>
	<tr class="<?php echo fmod($i, 2) ? 'even' : 'odd' ?>">
	<?php endforeach; ?>
	<?php
	/**
	* Function creates url properly slug from $text
	*
	* @param string $text
	*/
	public function slugify($text)
	{
	// replace non letter or digits by -
	$text = preg_replace('#[^\\pL\d]+#u', '-', $text);
	<?php

	class FlxZipArchive extends ZipArchive
	{

	/**
	* Add a Dir with Files and Subdirs to the archive
	*
	* @param string $location Real Location
	* @param string $name Name in Archive
	<html>
	<body>
	<script type="text/javascript">
	var BrowserDetect = {
	init: function () {
	this.browser = this.searchString(this.dataBrowser) \|\| "An unknown browser";
	this.version = this.searchVersion(navigator.userAgent)
	\|\| this.searchVersion(navigator.appVersion)
	\|\| "an unknown version";
	this.OS = this.searchString(this.dataOS) \|\| "an unknown OS";
	<?php
	/**
	* Function generates password depend on configuration sets
	*
	* @param int $length
	* @param boolean $add_dashes
	* @param string $available_sets
	* @return string
	*/
	public static function generateStrongPassword($length = 10, $add_dashes = false, $available_sets = 'luds')