phpBB.de

Code: Alles auswählen

$table_prefix = 'phpbb_';

Code: Alles auswählen

if ($request->variable('resetdl', 0) === 1)
				{
					$sql = 'TRUNCATE ' . RA_DOWNLOADS_TABLE;
					$db->sql_query($sql);
				}

Code: Alles auswählen

public function update_schema()
	{
		return array(
			'add_tables' => array(
				$this->table_prefix . 'ra_gamestat_periods' => array(
					'COLUMNS'			=> array(
						'id'			=> array('UINT', null, 'auto_increment'),
						'PERIOD'		=> array('VCHAR', ''),
						'CLASSEMENT'	=> array('VCHAR', ''),
						'PLAYER'		=> array('VCHAR', ''),
						'AVATAR'		=> array('VCHAR', ''),
						'UID'			=> array('VCHAR', ''),
						'TOTALPOINTS'	=> array('VCHAR', ''),
						'GAMEID'		=> array('VCHAR', ''),
						'GAMENAME'		=> array('VCHAR', ''),
						'DATE'			=> array('VCHAR', ''),
						'GAMEIMG'		=> array('VCHAR', ''),
					),
					'PRIMARY_KEY'	=> array('id'),
				)
			)
		);

	}
	
}

Code: Alles auswählen

if ($request->variable('ra_periods', 0))
{
	// Clear table
	switch ($db->get_sql_layer())
	{
		case 'sqlite3':
			$db->sql_query('DELETE FROM ' . 'phpbb_ra_gamestat_periods');
		break;

		default:
			$db->sql_query('TRUNCATE TABLE ' . 'phpbb_ra_gamestat_periods');
		break;
	}
}