samdark

Resetting OpenCFP

If you've used OpenCFP for a conference and want to use it next year you have to reset all talks. It is a good idea to keep users though.

That's how to do it:

1. Backup your current database.
2. Adjust dates in config/production.yml.
3. Clean up database:

samdark

<?php
function cidr_match($ip, $ranges)
{
    $ranges = (array)$ranges;
    foreach($ranges as $range) {
        list($subnet, $mask) = explode('/', $range);
        if((ip2long($ip) & ~((1 << (32 - $mask)) - 1)) == ip2long($subnet)) {
            return true;
        }
    }

samdark

{
    "_readme": [
        "This file locks the dependencies of your project to a known state",
        "Read more about it at https://getcomposer.org/doc/01-basic-usage.md#installing-dependencies",
        "This file is @generated automatically"
    ],
    "content-hash": "3c5ebbee4c63d262290c75bc24c2e892",
    "packages": [
        {
            "name": "cebe/markdown",

samdark

-- Cleans up IPB 3 database before importing it into another forum engine
-- tbl_* are project specific, could be removed

-- Remove banned members and members with no posts
delete m
from ipb_members m
left join tbl_user u on u.id = m.member_id
where
    (
        member_banned = 1

samdark

<?php
$db = new PDO('mysql:host=localhost;dbname=rmc2', 'root');
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
function benchmark($callback){
  $start = microtime(true);
	for ($i = 0; $i < 100; $i++)
		$callback();
	return microtime(true) - $start;
}

samdark

<?php
/**
 * Escapes values
 *
 * @param array $values array of values to escape
 * @return string string ready to be included into SQL statement
 * @throws CException if one of the values isn't a scalar
 */
function escape($values)
{

samdark

<?php
/**
 * Object class file.
 *
 * @link http://www.yiiframework.com/
 * @copyright Copyright &copy; 2008-2012 Yii Software LLC
 * @license http://www.yiiframework.com/license/
 */

namespace yii\base;

samdark

public static function assertArrayStructure($keys, $array)
    {
        $arrayKeys = array_keys($array);

        $missing = array_diff($keys, $arrayKeys);
        $unexpected = array_diff($arrayKeys, $keys);

        $message = 'Keys are wrong.';
        if ($missing !== []) {
            $message .= ' Missing: ' . implode(', ', $missing) . '.';

samdark

<scheme name="Sam Dark" version="142" parent_scheme="Default">
  <option name="LINE_SPACING" value="1.05" />
  <option name="EDITOR_FONT_SIZE" value="15" />
  <option name="EDITOR_LIGATURES" value="true" />
  <option name="CONSOLE_FONT_NAME" value="Monospaced" />
  <option name="CONSOLE_FONT_SIZE" value="13" />
  <option name="EDITOR_FONT_NAME" value="Fira Code" />
  <colors>
    <option name="WHITESPACES" value="f2f2f2" />
  </colors>

samdark

<?php
/**
 * Yii, simple HMVC
 */
class HmvcController extends Controller
{
	public function actionIndex()
	{
		echo $this->execute('/hmvc/do/id/123');
	}