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
$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;
}
}