/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param $guildSlug
* @param $occurrenceId
* @return \Illuminate\Http\Response
*/
public function store(Request $request, $guildSlug, $occurrenceId)
{
$occurrence = EventOccurrence::with(['event', 'event.guild', 'signups', 'signups.character', 'signups.character.user'])->whereHas('event.guild', function ($query) use($guildSlug) {
$query->where('slug', $guildSlug);
})->findOrFail($occurrenceId);
$event = $occurrence->event;
$guild = $event->guild;
$signups = $occurrence->signups;
$character = Character::whereHas('guilds', function ($query) use($guild) {
$query->where('guilds.id', $guild->id);
})->where(['user_id' => Auth::user()->id])->first();
if ($character == null) {
abort(401, 'No characters in that guild');
}
foreach ($signups as $signup) {
if ($signup->character_id == $character->id) {
return $this->update($request, $guildSlug, $occurrenceId, $signup->id);
}
}
$signup = new Signup();
$signup->character_id = $character->id;
$signup->event_occurrence_id = $occurrence->id;
$signup->status = $request->get('status');
$signup->save();
return redirect()->route('guilds.events.show', [$guildSlug, $occurrenceId]);
}
/**
* Display the specified resource.
*
* @param $guildSlug
* @param $occurrenceId
* @return \Illuminate\Http\Response
*/
public function show($guildSlug, $occurrenceId)
{
$guild = Guild::where('slug', $guildSlug)->firstOrFail();
$occurrence = EventOccurrence::with(['event', 'event.guild'])->whereHas('event.guild', function ($query) use($guild) {
$query->where('id', $guild->id);
})->findOrFail($occurrenceId);
$event = $occurrence->event;
$guild = $event->guild;
$signups = Signup::where(['event_occurrence_id' => $occurrence->id])->orderBy('created_at')->get();
$comments = Comment::where(['event_occurrence_id' => $occurrence->id])->orderBy('created_at')->get();
$character = Character::whereHas('guilds', function ($query) use($guild) {
$query->where('guilds.id', $guild->id);
})->where(['user_id' => Auth::user()->id])->firstOrFail();
$ownSignup = null;
$isSigned = false;
foreach ($signups as $signup) {
if ($signup->character_id == $character->id) {
$ownSignup = $signup;
$isSigned = true;
}
}
if ($ownSignup == null) {
$ownSignup = new Signup();
}
$statistic = new \stdClass();
foreach (['YES', 'MAYBE', 'NO'] as $status) {
$name = strtolower($status);
$statistic->{$name} = $signups->filter(function ($signup) use($status) {
return $signup->status == $status;
})->count();
}
return view('guilds.events.show', compact('occurrence', 'event', 'guild', 'signups', 'comments', 'ownSignup', 'isSigned', 'statistic'));
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('characters')->delete();
$characters = [["id" => 1, "name" => "Jack Daniels", "gender" => 'male', "xp" => 0, "level" => 1, "reputation" => 0, "money" => 100, "strength" => 5, "agility" => 5, "constitution" => 5, "intelligence" => 5, "charisma" => 1, "user_id" => 1, "location_id" => 1, "race_id" => 1], ["id" => 2, "name" => "Blood Axe", "gender" => 'male', "xp" => 0, "level" => 1, "reputation" => 0, "money" => 0, "strength" => 5, "agility" => 1, "constitution" => 9, "intelligence" => 5, "charisma" => 1, "user_id" => null, "location_id" => 1, "race_id" => 3], ["id" => 3, "name" => "Selena", "gender" => 'female', "xp" => 0, "level" => 1, "reputation" => 0, "money" => 0, "strength" => 5, "agility" => 9, "constitution" => 1, "intelligence" => 5, "charisma" => 1, "user_id" => null, "location_id" => 1, "race_id" => 2], ["id" => 4, "name" => "Ogrok", "gender" => 'female', "xp" => 0, "level" => 1, "reputation" => 0, "money" => 0, "strength" => 5, "agility" => 1, "constitution" => 9, "intelligence" => 5, "charisma" => 1, "user_id" => null, "location_id" => 1, "race_id" => 4]];
foreach ($characters as $char) {
Character::create($char);
}
}
public function testDeleteCharacter()
{
$user = User::find(1);
$campaign = Campaign::find(1);
$character_id = Character::where('name', 'Bilbo Baggins')->max('id');
$this->actingAs($user)->withSession(['campaign' => $campaign])->visit('/characters/' . $character_id . '/delete');
$this->visit('/test/characters')->dontSee('Bilbo Baggins');
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(CharacterRequest $request)
{
if ($request->ajax()) {
Character::create(['name' => $request['name'], 'birthdate' => $request['birthdate'], 'birthplace' => $request['birthplace'], 'gender' => $request['gender'], 'species' => $request['species'], 'lightsaber' => $request['lightsaber'], 'force_side' => $request['side']]);
return response()->json("exitoso");
} else {
$error = $request->errors()->all();
return response()->json($error);
}
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id, $character_id = null)
{
$user = User::findOrFail($id);
if (!$character_id) {
$character = $user->characters()->first();
} else {
$character = Character::findOrFail($character_id);
}
return view('admin.users.show')->with('user', $user)->with('character', $character);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$users = User::all();
foreach ($users as $i => $user) {
if ($i == 0) {
Character::create(['user_id' => $user->id, 'name' => 'Kehet', 'realm' => 'Darkspear', 'class' => 3, 'race' => 22, 'gender' => 'FEMALE', 'level' => 100, 'thumbnail' => 'darkspear/104/71285096-avatar.jpg']);
continue;
}
factory(Character::class, mt_rand(1, 7))->create(['user_id' => $user->id]);
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Character::findOrFail(1)->guilds()->attach(Guild::findOrFail(1));
$guilds = Guild::all();
$users = User::with('characters')->get();
foreach ($users as $i => $user) {
if ($i == 0) {
continue;
}
$user->characters->random()->guilds()->attach($guilds->random());
}
}
/**
* Store a newly created resource in storage.
*
* @param $name
* @param $realm
* @return \Illuminate\Http\Response
*/
public function store($name, $realm)
{
if (empty(Auth::user()->battlenet_characters)) {
abort(500, 'Character data not found');
}
$characters = json_decode(Auth::user()->battlenet_characters);
$found = null;
foreach ($characters as $character) {
if ($character->name == $name && $character->realm == $realm) {
$found = $character;
break;
}
}
if ($found == null) {
abort(500, 'No character named that associated to logged in user');
}
$character = new Character(array_only((array) $found, ['name', 'realm', 'class', 'race', 'level', 'thumbnail']));
$character->gender = $found->gender === 1 ? 'FEMALE' : 'MALE';
$character->user_id = Auth::user()->id;
$character->save();
Flash::success($character->name . ' added to your account!');
return redirect()->route('characters.index');
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$statistics = ['Strength' => 9, 'Constitution' => 6, 'Dexterity' => 5, 'Intelligence' => 9, 'Wisdom' => 4, 'Charisma' => 10];
Character::create(['name' => 'Virashathen Jiaral', 'birthdate' => '1976-09-22', 'race' => 'Wood Elf', 'gender' => 'Male', 'alignment' => 'Lawful Good', 'level' => 22, 'stats' => json_encode($statistics), 'image' => '/images/1/wood_elf.jpg', 'notes' => 'Virashathen Jiaral was at one point a servant of the woodland domain, but after several failed
experiments with the inquisition team, he was banished from the lands and trapped in a prison world
sandwiched between several parallel dimensions.
<br>
<br>
Years passed, and eventually he found a way to reach outside of the walls of his prison to a specific
bloodline of heroes. Those heroes were tormented via nightmares and waking dreams until finally one
agreed to his terms in order to free him from his prison']);
$statistics = ['Body' => 4, 'Mind' => 7, 'Soul' => 5];
Character::create(['name' => 'Thunderfist McGee', 'birthdate' => '1984-01-04', 'race' => 'Butler', 'gender' => 'Other', 'alignment' => 'Lawful Good', 'level' => 5, 'stats' => json_encode($statistics), 'notes' => 'Thunderfist is a mechanical butler created purely to assist Virashathen Jiaral and other
folks <br/> Beyond that, he just sits around and cleans. Has little to no combat functionality although
is completely impervious to all damage']);
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($name)
{
$character = Character::where('name', $name)->first();
$jobs = $character->jobs()->orderBy('number', 'asc')->get();
foreach ($jobs as $job) {
$skills = $job->skills()->orderBy('lvl', 'asc')->get();
$items = $job->items()->orderBY('quantity', 'asc')->get();
$job['skills'] = $skills;
$job['items'] = $items;
$jobarray[] = $job;
}
$character['jobs'] = $jobarray;
$iterations = $character->iterations()->get();
$character['iterations'] = $iterations;
//return $character;
return view('character')->with('character', $character);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param $guildSlug
* @param $occurrenceId
* @return \Illuminate\Http\Response
*/
public function store(Request $request, $guildSlug, $occurrenceId)
{
$occurrence = EventOccurrence::with(['event', 'event.guild'])->whereHas('event.guild', function ($query) use($guildSlug) {
$query->where('slug', $guildSlug);
})->findOrFail($occurrenceId);
$event = $occurrence->event;
$guild = $event->guild;
$character = Character::whereHas('guilds', function ($query) use($guild) {
$query->where('guilds.id', $guild->id);
})->where(['user_id' => Auth::user()->id])->first();
if ($character == null) {
abort(401, 'No characters in that guild');
}
$comment = new Comment($request->all());
$comment->event_occurrence_id = $occurrence->id;
$comment->character_id = $character->id;
$comment->save();
return redirect()->route('guilds.events.show', [$guildSlug, $occurrenceId]);
}
/**
* Edit character /
*/
public function editCharacter($timeline_id, $character_id, Request $request)
{
$timeline = \App\Timeline::where('id', '=', $timeline_id)->first();
$character = \App\Character::where('id', '=', $character_id)->first();
if ($character) {
if ($request->input('showForm') == 'true') {
return view('characters.editCharacter')->with('showForm', 'true')->with('character', $character)->with('timeline', $timeline);
} else {
// Validate the request data
$this->validate($request, ['name' => 'required']);
$user = \Auth::user();
$character->name = $request->input('name');
$character->race = $request->input('race');
$character->biography = $request->input('biography');
$character->last_modified_by = $user->id;
$character->save();
return view('characters.editCharacter')->with('showForm', 'false')->with('character', $character)->with('timeline', $timeline);
}
} else {
return "Update failed. Character does not exist.";
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker::create();
for ($i = 1; $i < 200; $i++) {
$name = $faker->shuffle($faker->word());
$recodeID = $faker->boolean(50) ? rand(0, $i) : NULL;
Character::create(['name' => $name, 'savename' => $name, 'class' => $faker->randomElement($array = array('A', 'B', 'C', 'D', 'S', 'SS', 'Z')), 'race' => $faker->boolean(50), 'pot' => $faker->boolean(50), 'pof' => $faker->boolean(50), 'adventurer' => $faker->boolean(50), 'recode_id' => NULL]);
for ($t = 1; $t < 4; $t++) {
Job::create(['name' => $faker->shuffle($faker->name()), 'number' => $t, 'element' => $faker->randomElement($array = array('None', 'Fire', 'Ice', 'Darkness', 'Lightning', 'Heal', 'Remedy')), 'weapon' => $faker->randomElement($array = array('Sword', 'Bow', 'Spear', 'Staff')), 'minHP' => $faker->numberBetween(0, 130), 'maxHP' => $faker->numberBetween(200, 900), 'minATK' => $faker->numberBetween(0, 130), 'maxATK' => $faker->numberBetween(200, 900), 'minDEF' => $faker->numberBetween(0, 130), 'maxDEF' => $faker->numberBetween(200, 900), 'minMATK' => $faker->numberBetween(0, 130), 'maxMATK' => $faker->numberBetween(200, 900), 'minMDEF' => $faker->numberBetween(0, 130), 'maxMDEF' => $faker->numberBetween(200, 900), 'character_id' => $i]);
for ($s = 1; $s < 5; $s++) {
$skillcount = Skill::all()->count();
$skill = Skill::where('id', rand(0, $skillcount - 1))->first();
JobSkill::create(['lvl' => rand(0, 15 * $s), 'skill_name' => $skill->name, 'affection' => $faker->word(), 'frequency' => rand(0, 101), 'job_id' => $t * $i]);
$itemcount = Item::all()->count();
$item = Item::where('id', rand(0, $itemcount - 1))->first();
JobItem::create(['quantity' => rand(0, 51), 'item_name' => $item->name, 'job_id' => $t * $i]);
}
}
for ($j = 0; $j < rand(1, 5); $j++) {
Iteration::create(['trigger' => $faker->word(), 'content' => $faker->text(), 'character_id' => $i, 'trigger_id' => NULL]);
}
}
}
public function update_status_activate(Request $request)
{
$result = Character::where('id', Input::get('character_id'))->update(['status' => Character::CHARACTER_STATUS_ENABLED_BY_USER]);
$aCharacter = Character::where('id', Input::get('character_id'))->first()->toArray();
Update::where('character_id', $aCharacter['id'])->update(['status' => Update::UPDATE_STATUS_ACTIVATED_BY_USER]);
$view = view('users.characters.partials.partials-active-list-show-characters')->with('aCharacter', $aCharacter);
if ($result) {
return response()->json(['view' => (string) $view, 'status' => true, 'message' => "Successfully activated character"]);
} else {
echo json_encode(array('status' => false, 'message' => "Something went wrong. Please try again later"));
}
die;
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$char = Character::findOrFail($id);
$char->delete();
return redirect()->route('admin.character.index')->with('message', "delete success");
}
private function createCharacter()
{
Character::create(["name" => "Positive"]);
Character::create(["name" => "Teamwork"]);
Character::create(["name" => "Open"]);
}
/**
* Display the specified resource.
*
* @param string $class
* @return Response
*/
public function show($class)
{
$characters[$class] = Character::where('class', '=', $class)->where('adventurer', '=', true)->orderBy('name', 'asc')->get();
return view('rooster', ['classes' => $characters]);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Character::truncate();
$data = [['user_id' => 3, 'server_id' => 1, 'clan_id' => 1, 'level' => 100, 'status' => 1, 'cs' => 5, 'name' => 'kyppyly'], ['user_id' => 3, 'server_id' => 1, 'clan_id' => 1, 'level' => 16, 'status' => 1, 'cs' => 5, 'name' => 'louis'], ['user_id' => 3, 'server_id' => 1, 'clan_id' => 1, 'level' => 16, 'status' => 1, 'cs' => 5, 'name' => 'louis3'], ['user_id' => 3, 'server_id' => 1, 'clan_id' => 1, 'level' => 16, 'status' => 1, 'cs' => 5, 'name' => 'louis4'], ['user_id' => 3, 'server_id' => 1, 'clan_id' => 1, 'level' => 16, 'status' => 1, 'cs' => 5, 'name' => 'louis5'], ['user_id' => 3, 'server_id' => 1, 'clan_id' => 1, 'level' => 16, 'status' => 1, 'cs' => 5, 'name' => 'louis6'], ['user_id' => 3, 'server_id' => 1, 'clan_id' => 1, 'level' => 16, 'status' => 1, 'cs' => 5, 'name' => 'louis7'], ['user_id' => 3, 'server_id' => 1, 'clan_id' => 1, 'level' => 16, 'status' => 1, 'cs' => 5, 'name' => 'louis8']];
Character::insert($data);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$character = Character::find($id);
if (Gate::denies('delete-character', $character)) {
abort(403);
}
$exec = $character->delete();
if ($exec) {
return response()->json(['status' => 'success']);
}
}
/**
* Edit Location /
*/
public function editEvent($timeline_id, $event_id, Request $request)
{
// Try to get event
$event = \App\Event::where('id', '=', $event_id)->first();
// If event exists, continue
if ($event) {
$timeline = \App\Timeline::where('id', '=', $timeline_id)->first();
$event_characters = array();
foreach ($event->characters as $character) {
$event_characters[] = $character;
}
$event_locations = array();
foreach ($event->locations as $location) {
$event_locations[] = $location;
}
$characters = \App\Character::where('timeline_id', '=', $timeline_id)->orderBy('name')->get();
$locations = \App\Location::where('timeline_id', '=', $timeline_id)->orderBy('name')->get();
// If form has not been submitted, show form
if ($request->input('showForm') == 'true') {
return view('events.editEvent')->with('showForm', 'true')->with('event', $event)->with('event_characters', $event_characters)->with('event_locations', $event_locations)->with('characters', $characters)->with('locations', $locations)->with('timeline', $timeline);
} else {
// Else submit form
// Validate the request data
$this->validate($request, ['name' => 'required', 'start_date' => 'required|date_format:Y#m#d', 'end_date' => 'required|date_format:Y#m#d']);
$user = \Auth::user();
$event->name = $request->input('name');
$event->start_date = $request->input('start_date');
$event->end_date = $request->input('end_date');
$event->description = $request->input('description');
$event->last_modified_by = $user->id;
$event->save();
// Edit existing locations
for ($l = 0; $l < count($event_locations); $l++) {
$location = \DB::table('event_location')->where('location_id', '=', $request->input('location_id' . $l))->where('event_id', '=', $event_id)->first();
if ($location) {
if ($request->input('location' . $l) == '--Delete Location--') {
\DB::table('event_location')->where('location_id', '=', $request->input('location_id' . $l))->where('event_id', '=', $event_id)->delete();
} else {
$location_name = \App\Location::where('name', '=', $request->input('location' . $l))->first();
\DB::table('event_location')->where('location_id', '=', $request->input('location_id' . $l))->where('event_id', '=', $event_id)->update(['location_id' => $location_name->id]);
}
}
}
// Add new location to database
$location_input = $request->input('location_new');
if ($location_input != 'Choose a Location') {
$location = \App\Location::where('name', 'LIKE', $location_input)->first();
$event->locations()->save($location);
}
// Edit existing characters
for ($c = 0; $c < count($event_characters); $c++) {
$character = \DB::table('character_event')->where('character_id', '=', $request->input('character_id' . $c))->where('event_id', '=', $event_id)->first();
if ($character) {
if ($request->input('character' . $c) == '--Delete Character--') {
\DB::table('character_event')->where('character_id', '=', $request->input('character_id' . $c))->where('event_id', '=', $event_id)->delete();
} else {
$character_name = \App\Character::where('name', '=', $request->input('character' . $c))->first();
\DB::table('character_event')->where('character_id', '=', $request->input('character_id' . $c))->where('event_id', '=', $event_id)->update(['character_id' => $character_name->id]);
}
}
}
// Add new character to database
$character_input = $request->input('character_new');
if ($character_input != 'Choose a Character') {
$character = \App\Character::where('name', 'LIKE', $character_input)->first();
$event->characters()->save($character);
}
// Return success message
return view('events.editEvent')->with('showForm', 'false')->with('event', $event)->with('timeline', $timeline);
}
} else {
// Else fail
return "Update failed. Event does not exist.";
}
}
function get_comments_by_photo_id()
{
$iFromType = Input::get('from_type');
$iFromID = Input::get('from_id');
$aLoggedInUser = User::where('id', Session::get('user')['id'])->first()->toArray();
switch ($iFromType) {
case Comment::COMMENT_FROM_TYPE_USER:
$aFromItem = User::where('id', $iFromID)->first()->toArray();
$oItemLikers = Like::where('like_type', Like::LIKE_TYPE_USER)->where('user_id', $aFromItem['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
$aFromItem['likers'] = is_array($oItemLikers->toArray()) && count($oItemLikers->toArray()) ? $oItemLikers->toArray() : [];
$aFromItem['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aFromItem['likers'], $aLoggedInUser['id']);
$oComments = Comment::where('user_id', $iFromID)->where('status', Comment::COMMENT_STATUS_DEFAULT)->get();
break;
case Comment::COMMENT_FROM_TYPE_CHARACTER:
$aFromItem = Character::where('id', $iFromID)->first()->toArray();
$oItemLikers = Like::where('like_type', Like::LIKE_TYPE_CHARACTER)->where('character_id', $aFromItem['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
$aFromItem['likers'] = is_array($oItemLikers->toArray()) && count($oItemLikers->toArray()) ? $oItemLikers->toArray() : [];
$aFromItem['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aFromItem['likers'], $aLoggedInUser['id']);
$oComments = Comment::where('character_id', $iFromID)->where('status', Comment::COMMENT_STATUS_DEFAULT)->get();
break;
case Comment::COMMENT_FROM_TYPE_FAMILY:
$aFromItem = Family::where('id', $iFromID)->first()->toArray();
$oItemLikers = Like::where('like_type', Like::LIKE_TYPE_FAMILY)->where('family_id', $aFromItem['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
$aFromItem['likers'] = is_array($oItemLikers->toArray()) && count($oItemLikers->toArray()) ? $oItemLikers->toArray() : [];
$aFromItem['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aFromItem['likers'], $aLoggedInUser['id']);
$oComments = Comment::where('family_id', $iFromID)->where('status', Comment::COMMENT_STATUS_DEFAULT)->get();
break;
case Comment::COMMENT_FROM_TYPE_SPECY:
$aFromItem = Specy::where('id', $iFromID)->first()->toArray();
$oItemLikers = Like::where('like_type', Like::LIKE_TYPE_SPECY)->where('specy_id', $aFromItem['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
$aFromItem['likers'] = is_array($oItemLikers->toArray()) && count($oItemLikers->toArray()) ? $oItemLikers->toArray() : [];
$aFromItem['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aFromItem['likers'], $aLoggedInUser['id']);
$oComments = Comment::where('specy_id', $iFromID)->where('status', Comment::COMMENT_STATUS_DEFAULT)->get();
break;
case Comment::COMMENT_FROM_TYPE_PHOTO:
$aFromItem = Photo::where('id', $iFromID)->first()->toArray();
$oItemLikers = Like::where('like_type', Like::LIKE_TYPE_PHOTO)->where('photo_id', $aFromItem['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
$aFromItem['likers'] = is_array($oItemLikers->toArray()) && count($oItemLikers->toArray()) ? $oItemLikers->toArray() : [];
$aFromItem['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aFromItem['likers'], $aLoggedInUser['id']);
$oComments = Comment::where('photo_id', $iFromID)->where('status', Comment::COMMENT_STATUS_DEFAULT)->get();
break;
case Comment::COMMENT_FROM_TYPE_POST:
$aFromItem = Post::where('id', $iFromID)->first()->toArray();
$oItemLikers = Like::where('like_type', Like::LIKE_TYPE_POST)->where('post_id', $aFromItem['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
$aFromItem['likers'] = is_array($oItemLikers->toArray()) && count($oItemLikers->toArray()) ? $oItemLikers->toArray() : [];
$aFromItem['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aFromItem['likers'], $aLoggedInUser['id']);
$oComments = Comment::where('post_id', $iFromID)->where('status', Comment::COMMENT_STATUS_DEFAULT)->get();
break;
case Comment::COMMENT_FROM_TYPE_MATE:
$aFromItem = Mate::where('id', $iFromID)->first()->toArray();
$oItemLikers = Like::where('like_type', Like::LIKE_TYPE_MATE)->where('mate_id', $aFromItem['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
$aFromItem['likers'] = is_array($oItemLikers->toArray()) && count($oItemLikers->toArray()) ? $oItemLikers->toArray() : [];
$aFromItem['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aFromItem['likers'], $aLoggedInUser['id']);
$oComments = Comment::where('mate_id', $iFromID)->where('status', Comment::COMMENT_STATUS_DEFAULT)->get();
break;
default:
$aFromItem = User::where('id', $iFromID)->first()->toArray();
$oItemLikers = Like::where('like_type', Like::LIKE_TYPE_USER)->where('user_id', $aFromItem['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
$aFromItem['likers'] = is_array($oItemLikers->toArray()) && count($oItemLikers->toArray()) ? $oItemLikers->toArray() : [];
$aFromItem['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aFromItem['likers'], $aLoggedInUser['id']);
$oComments = Comment::where('user_id', $iFromID)->where('status', Comment::COMMENT_STATUS_DEFAULT)->get();
break;
}
$oComments = is_array($oComments->toArray()) && count($oComments->toArray() > 0) ? $oComments->toArray() : [];
$aComments = null;
$iFromWhereID = null;
for ($i = 0; $i < count($oComments); $i++) {
$aComments[$i] = $oComments[$i];
$aComments[$i]['from_user'] = User::where('id', $oComments[$i]['from_user_id'])->first()->toArray();
if ($oComments[$i]['comment_photo_id'] > 0) {
$aComments[$i]['photo_comment'] = Photo::where('id', $oComments[$i]['comment_photo_id'])->first()->toArray();
}
$iFromType = $oComments[$i]['comment_from_type'];
switch ($iFromType) {
case Comment::COMMENT_FROM_TYPE_USER:
$iFromWhereID = "user_id";
$aComments[$i]['from'] = User::where('id', $oComments[$i][$iFromWhereID])->first()->toArray();
break;
case Comment::COMMENT_FROM_TYPE_CHARACTER:
$iFromWhereID = "character_id";
$aComments[$i]['from'] = Character::where('id', $oComments[$i][$iFromWhereID])->first()->toArray();
break;
case Comment::COMMENT_FROM_TYPE_FAMILY:
$iFromWhereID = "family_id";
$aComments[$i]['from'] = Family::where('id', $oComments[$i][$iFromWhereID])->first()->toArray();
break;
case Comment::COMMENT_FROM_TYPE_SPECY:
$iFromWhereID = "specy_id";
$aComments[$i]['from'] = Specy::where('id', $oComments[$i][$iFromWhereID])->first()->toArray();
break;
case Comment::COMMENT_FROM_TYPE_PHOTO:
$iFromWhereID = "photo_id";
$aComments[$i]['from'] = Photo::where('id', $oComments[$i][$iFromWhereID])->first()->toArray();
break;
case Comment::COMMENT_FROM_TYPE_POST:
$iFromWhereID = "post_id";
$aComments[$i]['from'] = Post::where('id', $oComments[$i][$iFromWhereID])->first()->toArray();
break;
case Comment::COMMENT_FROM_TYPE_MATE:
$iFromWhereID = "mate_id";
$aComments[$i]['from'] = Mate::where('id', $oComments[$i][$iFromWhereID])->first()->toArray();
break;
default:
$iFromWhereID = "user_id";
$aComments[$i]['from'] = User::where('id', $oComments[$i][$iFromWhereID])->first()->toArray();
break;
}
}
$view = view('users.comments.show')->with('aComments', $aComments);
$htmlFromWhatView = view('users.comments.partials.partial-comment-from-what-display')->with('aFromItem', $aFromItem)->with('iFromType', $iFromType);
if ($oComments) {
return response()->json(['view' => (string) $view, 'status' => true, 'message' => "Successfully archived character", 'what_to_display' => (string) $htmlFromWhatView]);
} else {
$htmlFromWhatView = view('users.comments.partials.partial-comment-from-what-display')->with('aFromItem', $aFromItem)->with('iFromType', $iFromType);
$view = view('users.comments.show')->with('aComments', []);
if ($htmlFromWhatView != "") {
return response()->json(['view' => (string) $view, 'status' => true, 'message' => "Successfully archived character", 'what_to_display' => (string) $htmlFromWhatView]);
} else {
echo json_encode(array('status' => false, 'message' => "Something went wrong. Please try again later"));
}
}
die;
}
public function get_details()
{
$iLimit = 10;
$iOffset = 0;
if (Input::get('iOffset')) {
$iOffset = Input::get('iOffset');
}
$htmlView = "";
$bLoggedInUser = Session::has('user');
if ($bLoggedInUser) {
$aLoggedInUser['user'] = User::where('id', Session::get('user')['id'])->first()->toArray();
$aLoggedInUser['current_character'] = Character::where('id', $aLoggedInUser['user']['current_character_id'])->first()->toArray();
}
//$aMate = Mate::query("SELECT * FROM mates WHERE ((from_user_id = 10 OR to_user_id = 10) AND (status = 8 OR status = 9))")->get()->toArray();
$aMates = DB::select(DB::raw("SELECT * FROM mates WHERE ((from_user_id = " . $aLoggedInUser['user']['id'] . " OR to_user_id = " . $aLoggedInUser['user']['id'] . ") AND (status = " . Mate::MATE_STATUS_ACCEPTED_BY_ADMIN . " OR status = " . Mate::MATE_STATUS_ACCEPTED_BY_USER . "))"));
$aUserID = [];
$sUserIDS = "";
foreach (json_decode(json_encode($aMates), true) as $aMate) {
if ($aMate['from_user_id'] != $aLoggedInUser['user']['id']) {
$aUserID[] = $aMate['from_user_id'];
$sUserIDS = $sUserIDS . $aMate['from_user_id'] . ", ";
} else {
$aUserID[] = $aMate['to_user_id'];
$sUserIDS = $sUserIDS . $aMate['to_user_id'] . ", ";
}
}
$sUserIDS = substr($sUserIDS, 0, -2);
/* $aData = DB::select(DB::raw("SELECT characters.*, comments.*, likes.*, mates.*, posts.*, users.* FROM users
LEFT JOIN characters on users.id = characters.user_id
LEFT JOIN comments on (characters.user_id = comments.from_user_id OR characters.user_id = comments.to_user_id)
LEFT JOIN likes on (comments.from_user_id = likes.from_user_id OR comments.from_user_id = likes.to_user_id OR comments.to_user_id = likes.from_user_id OR comments.to_user_id = likes.to_user_id)
LEFT JOIN mates on (likes.from_user_id = mates.from_user_id OR likes.from_user_id = mates.to_user_id OR likes.to_user_id = mates.from_user_id OR likes.to_user_id = mates.to_user_id)
LEFT JOIN posts on (likes.from_user_id = posts.from_user_id OR likes.from_user_id = posts.to_user_id OR likes.to_user_id = posts.from_user_id OR likes.to_user_id = posts.to_user_id OR likes.from_user_id = posts.user_id OR likes.to_user_id = posts.user_id)
WHERE users.id = " . $aLoggedInUser['user']['id'] . "
ORDER BY comments.date_updated, likes.date_updated, likes.date_updated, mates.date_updated, posts.date_updated ASC"));*/
$oUpdates = DB::select(DB::raw("SELECT * FROM updates WHERE\n status = " . Update::UPDATE_STATUS_ACTIVE . " OR\n status = " . Update::UPDATE_STATUS_ACTIVATED_BY_USER . " OR\n status = " . Update::UPDATE_STATUS_ACTIVATED_BY_ADMIN . " AND\n user_id IN (" . $sUserIDS . ")\n ORDER BY id DESC\n LIMIT {$iOffset}, {$iLimit}"));
$aUpdates = json_decode(json_encode($oUpdates), true);
for ($i = 0; $i < count($aUpdates); $i++) {
$aUpdates[$i]['user'] = User::where('id', $aUpdates[$i]['user_id'])->first()->toArray();
switch ($aUpdates[$i]['update_type']) {
case Update::UPDATE_TYPE_USER:
break;
case Update::UPDATE_TYPE_SPECY:
break;
case Update::UPDATE_TYPE_FAMILY:
break;
case Update::UPDATE_TYPE_CHARACTER:
$aUpdates[$i]['character'] = Character::where('id', $aUpdates[$i]['character_id'])->first()->toArray();
break;
case Update::UPDATE_TYPE_MATE:
break;
case Update::UPDATE_TYPE_COMMENT:
$aUpdates[$i]['comment'] = Comment::where('id', $aUpdates[$i]['comment_id'])->first()->toArray();
$aUpdates[$i]['comment']['from_user'] = User::where('id', $aUpdates[$i]['comment']['from_user_id'])->first()->toArray();
$aUpdates[$i]['comment']['to_user'] = User::where('id', $aUpdates[$i]['comment']['to_user_id'])->first()->toArray();
switch ($aUpdates[$i]['comment']['comment_from_type']) {
case Comment::COMMENT_FROM_TYPE_USER:
break;
case Comment::COMMENT_FROM_TYPE_CHARACTER:
break;
case Comment::COMMENT_FROM_TYPE_FAMILY:
break;
case Comment::COMMENT_FROM_TYPE_SPECY:
break;
case Comment::COMMENT_FROM_TYPE_PHOTO:
$aUpdates[$i]['comment']['photo'] = Photo::where('id', $aUpdates[$i]['comment']['photo_id'])->first()->toArray();
break;
case Comment::COMMENT_FROM_TYPE_POST:
break;
case Comment::COMMENT_FROM_TYPE_MATE:
break;
}
$htmlView = $htmlView . (string) view('users.pages.partials.comment-show')->with('aUpdate', $aUpdates[$i]);
break;
case Update::UPDATE_TYPE_PHOTO:
break;
case Update::UPDATE_TYPE_LIKE:
$aUpdates[$i]['like'] = Like::where('id', $aUpdates[$i]['like_id'])->first()->toArray();
break;
case Update::UPDATE_TYPE_POST:
$aUpdates[$i]['post'] = Post::where('id', $aUpdates[$i]['post_id'])->first()->toArray();
break;
}
}
return response()->json(['status' => true, 'message' => "Successfully submitted comment", 'view' => (string) $htmlView]);
}
/**
* Get rankings page
*
* @return JSON of top 10 characters
*/
public function getRankings()
{
$users = \App\Character::where('gm', '<', 4)->orderBy('level', 'DESC')->paginate(10);
return $users;
}
public function settings()
{
if (Session::has('user')) {
$aUser = User::where('id', Session::get('user')['id'])->first()->toArray();
//var_dump($aUser);
$aCurrentCharacter = Character::where('id', $aUser['current_character_id'])->first()->toArray();
$aUserDetails = User::where('id', $aUser['id'])->first()->toArray();
return view('users.users.settings')->with('aCurrentCharacter', $aCurrentCharacter)->with('aUserDetails', $aUserDetails);
}
}
public function getMove(Character $character, Location $location, MoveCharacterRequest $request)
{
// update character's location
$character->location()->associate($location)->save();
return redirect()->route('location.show', compact('location'));
}
public function testIndex()
{
$characters = Character::all();
return $characters;
}
public function settings()
{
if (Session::has('user')) {
$aLoggedInUser = null;
$bOwner = true;
$oMate = null;
$bLoggedInUser = Session::has('user');
if ($bLoggedInUser) {
/*if($oUser->toArray()['id'] == Session::get('user')['id']){
$bOwner = true;
}*/
$aLoggedInUser['user'] = User::where('id', Session::get('user')['id'])->first()->toArray();
$aLoggedInUser['current_character'] = Character::where('id', $aLoggedInUser['user']['current_character_id'])->first()->toArray();
}
$aUser['user'] = User::where('id', Session::get('user')['id'])->first()->toArray();
$aUser['active_characters'] = Character::where('user_id', $aUser['user']['id'])->where('status', Character::CHARACTER_STATUS_DEFAULT)->orWhere('status', Character::CHARACTER_STATUS_ENABLED_BY_USER)->orWhere('status', Character::CHARACTER_STATUS_ENABLED_BY_ADMIN)->get()->toArray();
$aUser['inactive_characters'] = Character::where('user_id', $aUser['user']['id'])->where('status', Character::CHARACTER_STATUS_DISABLED_BY_USER)->orWhere('status', Character::CHARACTER_STATUS_INACTIVE)->get()->toArray();
$aUser['current_character'] = Character::where('id', $aUser['user']['current_character_id'])->first()->toArray();
$aUser['user_settings'] = UserSetting::where('id', Session::get('user')['id'])->first()->toArray();
$aLoggedInUser['user'] = $aUser['user'];
$aLoggedInUser['current_character'] = $aUser['current_character'];
$aCountries = Country::all()->toArray();
return view('users.users.settings')->with('aUser', $aUser)->with('aLoggedInUser', $aLoggedInUser)->with('aCountries', $aCountries)->with('bLoggedInUser', $bLoggedInUser)->with('bOwner', $bOwner);
}
}
public function postChangeCharacter(Request $request)
{
$data = $request->except('_token');
if (!ServiceAccount::checkCaptcha($data)) {
dd('vao');
return redirect()->route('user.get.changeCharacter');
} elseif ($data['new_name'] != $data['re_name'] || strlen($data['new_name']) < 1 || strlen($data['new_name']) > 10) {
dd('lỗi đặt tên');
return redirect()->back()->with('message', 'name mới phải trùng nhau và ký tự >6 và <15.');
} else {
$character = new Character();
$character->setConnection($data['server_name']);
try {
$updated = $character->where('acct_id', $data['acct_id'])->where('char_id', $data['char_id'])->whereNull('Changed')->update(['nickName' => $data['new_name'], 'Changed' => 0]);
} catch (\Exception $e) {
dd($e->getMessage());
}
if ($updated) {
return redirect()->back()->with('message', 'Đổi tên thành công!');
} else {
return redirect()->back()->with('message', 'Đổi tên thất bại!');
}
}
}
