public function setBonusAttribute($value)
{
DB::delete('delete from t_event_bonuses where event_id = ? and player_id = ?', [$this->event->id, $this->player->id]);
if ($value && $value != 'null') {
DB::insert('insert into t_event_bonuses (event_id, player_id, bonus_id) values (?, ?, ?)', [$this->event->id, $this->player->id, $value]);
}
}
public function testRawQueries()
{
// Insert
$inserted = Capsule::insert('INSERT INTO articles (title) VALUES (:title)', ['title' => static::ARTICLE_TITLE]);
$this->assertTrue($inserted);
// Last Insert ID
$id = Capsule::connection()->getPdo()->lastInsertId();
$this->assertEquals(1, $id);
// Select
$articles = Capsule::select('SELECT * FROM articles WHERE id = ?', [$id]);
$this->assertCount(1, $articles);
$this->assertEquals($articles[0]->title, static::ARTICLE_TITLE);
// Delete
$deleted = Capsule::delete('DELETE FROM articles WHERE id = ?', [$id]);
$this->assertEquals(1, $deleted);
// Count
$count = Capsule::selectOne('SELECT COUNT(*) as nb FROM articles');
$this->assertEquals(0, $count->nb);
}
/**
* Join guild
*
* @return void
*/
public function join(Character $player, $gid)
{
Capsule::delete('DELETE FROM `guild_invites` WHERE `player_id` = ?', [$player->id]);
$rank = app('capsule')->table('guild_ranks')->where(function ($query) use($gid) {
$query->where('guild_id', $gid);
$query->where('level', 1);
})->first();
$new_member = new GuildMember();
$new_member->player_id = $player->id;
$new_member->guild_id = $gid;
$new_member->rank_id = $rank->id;
$new_member->nick = '';
$new_member->save();
}
