Code: Selecteer alles
<?php
/**
*
* @package Moods
* @copyright (c) 2016 Theriddler - (http://www.peppersrus-forum.nl)
* @copyright (c) 2015 Rmcgirr83
* @Code lent from nationalflags extension by Rmcgirr83
* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2
*
*/
namespace theriddler\moods\migrations;
class m2_initial_data extends \phpbb\db\migration\migration
{
public function effectively_installed()
{
return isset($this->config['moods_version']) && version_compare($this->config['moods_version'], '1.0.0', '>=');
}
static public function depends_on()
{
return array('\theriddler\moods\migrations\m1_initial_schema');
}
public function update_data()
{
return array(
array('config.add', array('moods_version', '1.0.0')),
array('config.add', array('allow_moods', false)),
array('module.add', array('acp', 'ACP_CAT_DOT_MODS', 'ACP_CAT_MOODS')),
array('module.add', array(
'acp', 'ACP_CAT_MOODS', array(
'module_basename' => '\theriddler\moods\acp\moods_module',
'modes' => array('config', 'manage'),
),
)),
array('custom', array(
array(&$this, 'mood_install_images')
)),
);
}
public function mood_install_images()
{
if ($this->db_tools->sql_table_exists($this->table_prefix . 'moods'))
{
$sql_ary = array(
array(
'mood_name' => 'Aggressive',
'mood_image' => 'm1.gif',
),
array(
'mood_name' => 'Amazed',
'mood_image' => 'm2.gif',
),
array(
'mood_name' => 'Amused',
'mood_image' => 'm3.gif',
),
array(
'mood_name' => 'Angelic',
'mood_image' => 'm4.gif',
),
array(
'mood_name' => 'Angry',
'mood_image' => 'm5.gif',
),
array(
'mood_name' => 'Apprehensive',
'mood_image' => 'm6.gif',
),
array(
'mood_name' => 'Approved',
'mood_image' => 'm7.gif',
),
array(
'mood_name' => 'Asleep',
'mood_image' => 'm8.gif',
),
array(
'mood_name' => 'Bahahaha',
'mood_image' => 'm9.gif',
),
array(
'mood_name' => 'Bashful',
'mood_image' => 'm10.gif',
),
array(
'mood_name' => 'Bitched',
'mood_image' => 'm11.gif',
),
array(
'mood_name' => 'Bitchy',
'mood_image' => 'm12.gif',
),
array(
'mood_name' => 'Blah',
'mood_image' => 'm13.gif',
),
array(
'mood_name' => 'Bookworm',
'mood_image' => 'm14.gif',
),
array(
'mood_name' => 'Bored',
'mood_image' => 'm15.gif',
),
array(
'mood_name' => 'Breezy',
'mood_image' => 'm16.gif',
),
array(
'mood_name' => 'Brooding',
'mood_image' => 'm17.gif',
),
array(
'mood_name' => 'Busy',
'mood_image' => 'm18.gif',
),
array(
'mood_name' => 'Buzzed',
'mood_image' => 'm19.gif',
),
array(
'mood_name' => 'Chatty',
'mood_image' => 'm20.gif',
),
array(
'mood_name' => 'Cheeky',
'mood_image' => 'm21.gif',
),
array(
'mood_name' => 'Cheerful',
'mood_image' => 'm22.gif',
),
array(
'mood_name' => 'Cloud_9',
'mood_image' => 'm23.gif',
),
array(
'mood_name' => 'Cold',
'mood_image' => 'm24.gif',
),
array(
'mood_name' => 'Confused',
'mood_image' => 'm25.gif',
),
array(
'mood_name' => 'Crappy',
'mood_image' => 'm26.gif',
),
array(
'mood_name' => 'Curmudgeon',
'mood_image' => 'm27.gif',
),
array(
'mood_name' => 'Cynical',
'mood_image' => 'm28.gif',
),
array(
'mood_name' => 'Dead',
'mood_image' => 'm29.gif',
),
array(
'mood_name' => 'Depressed',
'mood_image' => 'm30.gif',
),
array(
'mood_name' => 'Devilish',
'mood_image' => 'm31.gif',
),
array(
'mood_name' => 'Disapprove',
'mood_image' => 'm32.gif',
),
array(
'mood_name' => 'Doh',
'mood_image' => 'm33.gif',
),
array(
'mood_name' => 'Doubtful',
'mood_image' => 'm34.gif',
),
array(
'mood_name' => 'Drunk',
'mood_image' => 'm35.gif',
),
array(
'mood_name' => 'Dunce',
'mood_image' => 'm36.gif',
),
array(
'mood_name' => 'Festive',
'mood_image' => 'm37.gif',
),
array(
'mood_name' => 'Fine',
'mood_image' => 'm38.gif',
),
array(
'mood_name' => 'Flirty',
'mood_image' => 'm39.gif',
),
array(
'mood_name' => 'FootMouth',
'mood_image' => 'm40.gif',
),
array(
'mood_name' => 'Gay',
'mood_image' => 'm41.gif',
),
array(
'mood_name' => 'Goofy',
'mood_image' => 'm42.gif',
),
array(
'mood_name' => 'Grumpy',
'mood_image' => 'm43.gif',
),
array(
'mood_name' => 'Hacker',
'mood_image' => 'm44.gif',
),
array(
'mood_name' => 'HaHa',
'mood_image' => 'm45.gif',
),
array(
'mood_name' => 'Happy',
'mood_image' => 'm46.gif',
),
array(
'mood_name' => 'Hot',
'mood_image' => 'm47.gif',
),
array(
'mood_name' => 'Hotflash',
'mood_image' => 'm48.gif',
),
array(
'mood_name' => 'Hungover',
'mood_image' => 'm49.gif',
),
array(
'mood_name' => 'Inlove',
'mood_image' => 'm50.gif',
),
array(
'mood_name' => 'Innocent',
'mood_image' => 'm51.gif',
),
array(
'mood_name' => 'Inpain',
'mood_image' => 'm52.gif',
),
array(
'mood_name' => 'Inspired',
'mood_image' => 'm53.gif',
),
array(
'mood_name' => 'Lonely',
'mood_image' => 'm54.gif',
),
array(
'mood_name' => 'Lurking',
'mood_image' => 'm55.gif',
),
array(
'mood_name' => 'Mad',
'mood_image' => 'm56.gif',
),
array(
'mood_name' => 'Mellow',
'mood_image' => 'm57.gif',
),
array(
'mood_name' => 'Nerdy',
'mood_image' => 'm58.gif',
),
array(
'mood_name' => 'Ornery',
'mood_image' => 'm59.gif',
),
array(
'mood_name' => 'Paranoid',
'mood_image' => 'm60.gif',
),
array(
'mood_name' => 'Pensive',
'mood_image' => 'm61.gif',
),
array(
'mood_name' => 'Persnickety',
'mood_image' => 'm62.gif',
),
array(
'mood_name' => 'Pissedoff',
'mood_image' => 'm63.gif',
),
array(
'mood_name' => 'Psychadelic',
'mood_image' => 'm64.gif',
),
array(
'mood_name' => 'Question',
'mood_image' => 'm65.gif',
),
array(
'mood_name' => 'Redtemp',
'mood_image' => 'm66.gif',
),
array(
'mood_name' => 'Relaxed',
'mood_image' => 'm67.gif',
),
array(
'mood_name' => 'Roflol',
'mood_image' => 'm68.gif',
),
array(
'mood_name' => 'Sad',
'mood_image' => 'm69.gif',
),
array(
'mood_name' => 'Sassy',
'mood_image' => 'm70.gif',
),
array(
'mood_name' => 'Scared',
'mood_image' => 'm71.gif',
),
array(
'mood_name' => 'Shh',
'mood_image' => 'm72.gif',
),
array(
'mood_name' => 'Shocked',
'mood_image' => 'm73.gif',
),
array(
'mood_name' => 'Sick',
'mood_image' => 'm74.gif',
),
array(
'mood_name' => 'Sleepy',
'mood_image' => 'm75.gif',
),
array(
'mood_name' => 'Sneaky',
'mood_image' => 'm76.gif',
),
array(
'mood_name' => 'Starving',
'mood_image' => 'm77.gif',
),
array(
'mood_name' => 'Stressed',
'mood_image' => 'm78.gif',
),
array(
'mood_name' => 'Stuck',
'mood_image' => 'm79.gif',
),
array(
'mood_name' => 'Studly',
'mood_image' => 'm80.gif',
),
array(
'mood_name' => 'sunshine',
'mood_image' => 'm81.gif',
),
array(
'mood_name' => 'Suspicious',
'mood_image' => 'm82.gif',
),
array(
'mood_name' => 'Talkative',
'mood_image' => 'm83.gif',
),
array(
'mood_name' => 'Tell',
'mood_image' => 'm84.gif',
),
array(
'mood_name' => 'Tolerant',
'mood_image' => 'm85.gif',
),
array(
'mood_name' => 'Torn',
'mood_image' => 'm86.gif',
),
array(
'mood_name' => 'Twisted',
'mood_image' => 'm87.gif',
),
array(
'mood_name' => 'Volatile',
'mood_image' => 'm88.gif',
),
array(
'mood_name' => 'Wasted',
'mood_image' => 'm89.gif',
),
array(
'mood_name' => 'Where',
'mood_image' => 'm90.gif',
),
array(
'mood_name' => 'Wicked',
'mood_image' => 'm91.gif',
),
array(
'mood_name' => 'Woot',
'mood_image' => 'm92.gif',
),
array(
'mood_name' => 'Worried',
'mood_image' => 'm93.gif',
),
array(
'mood_name' => 'Yeehaw',
'mood_image' => 'm94.gif',
),
array(
'mood_name' => 'No Mood',
'mood_image' => 'M103.gif',
),
);
$this->db->sql_multi_insert($this->table_prefix . 'moods', $sql_ary);
}
}
}
Bovenstaande data structuur heb ik eveneens toegevoegd.