libby is being a retard again peanut

Reeeee · Post by **Reeeee** » Wed Dec 09, 2020 7:47 pm #583118

Bottom post of the previous page:

https://tgstation13.org/phpBB/viewtopic ... 14#p583114

Look at this motherfucker talking to kicking-bird johnson to pass time on 4 hour shift with recaller going haywire to pass time and getting banned for it.
What a fucking retard honestly.

Kendrickorium · Sat Dec 12, 2020 6:05 am

cacogen wrote:
saprasam wrote:when people act retarded ironically they attract retards who think they're in good company
Not sure what Rene was describing but it's like how pool's closed and the n word ruined 4chan

I still think pools closed was the fucking highest point /b/ eer got
that and the tom green raids were peak fucking 4chan

cacogen · Post by **cacogen** » Sat Dec 12, 2020 7:25 am #583474

PKPenguin321 wrote:

the fright

Kendrickorium wrote:
cacogen wrote:
saprasam wrote:when people act retarded ironically they attract retards who think they're in good company
Not sure what Rene was describing but it's like how pool's closed and the n word ruined 4chan
I still think pools closed was the fucking highest point /b/ eer got
that and the tom green raids were peak fucking 4chan

My cousin showed me /b/ in 2008 I think and I read about this stuff on Encyclopaedia Dramatica but I wasn't there for it sadly. For me the site was great until /pol/ started leaking, which I remember noticing on /tv/ around 2012 after Bane shitposting overtook the board. The post quality declined once nearly every successful thread was bait, usually of the political variety.

Kendrickorium · Sat Dec 12, 2020 7:36 am

cacogen wrote:
PKPenguin321 wrote:
the fright
Kendrickorium wrote:
cacogen wrote:
saprasam wrote:when people act retarded ironically they attract retards who think they're in good company
Not sure what Rene was describing but it's like how pool's closed and the n word ruined 4chan
I still think pools closed was the fucking highest point /b/ eer got
that and the tom green raids were peak fucking 4chan
My cousin showed me /b/ in 2008 I think and I read about this stuff on Encyclopaedia Dramatica but I wasn't there for it sadly. For me the site was great until /pol/ started leaking, which I remember noticing on /tv/ around 2012 after Bane shitposting overtook the board. The post quality declined once nearly every successful thread was bait, usually of the political variety.

/pol/ didn't "invade" or leak into anything. people werent this polarized about politics 15 years ago. the reason talk of it all has become more prevalent (on 4chan and in real life) is because all the ideologies are now on two VERY different sides, and people feel the need to inject their fucking opinion about anything and everything mostly due to social media giving them a platform to broadcast their every fucking thought and thinking the rest of the world needs to hear it.

/tv/ went down the shitter when moot banned waifu threads, oval disappeared and all the namefags left

remanseptim · Post by **remanseptim** » Sat Dec 12, 2020 8:20 am #583481

4chan is unironically being raided by communists by the way

cacogen · Post by **cacogen** » Sat Dec 12, 2020 8:25 am #583482

Kendrickorium wrote:/pol/ didn't "invade" or leak into anything

That's self-evidently wrong and to deny it is to either reveal one's ignorance or one's insincerity.

Kendrickorium wrote:people werent this polarized about politics 15 years ago

Were you too young for the Bush/Bowling for Columbine/American Idiot/Jesus Camp era? The difference then was that the left were winning the culture war rather than alienating people and making themselves look ridiculous with identity politics and the mainstream right hadn't embraced misinformation and conspiracy theories as winning tactics.

Kendrickorium · Sat Dec 12, 2020 8:47 am

cacogen wrote:
Kendrickorium wrote:/pol/ didn't "invade" or leak into anything
That's self-evidently wrong and to deny it is to either reveal one's ignorance or one's insincerity.

Kendrickorium wrote:people werent this polarized about politics 15 years ago
Were you too young for the Bush/Bowling for Columbine/American Idiot/Jesus Camp era? The difference then was that the left were winning the culture war rather than alienating people and making themselves look ridiculous with identity politics and the mainstream right hadn't embraced misinformation and conspiracy theories as winning tactics.

what i'm trying to say is that /pol/ hasn't just leaked into 4chan, /pol/ has leaked into EVERYTHING

>Were you too young for the Bush/Bowling for Columbine/American Idiot/Jesus Camp era?

no.

>The difference then was that the left were winning the culture war rather than alienating people and making themselves look ridiculous with identity politics

they werent winning, they were battling. in 2020, with almost complete control of the media, schools and colleges, they've won.

>the mainstream right hadn't embraced misinformation and conspiracy theories as winning tactics.

yikes

Kendrickorium · Sat Dec 12, 2020 9:06 am

i mean shit here we are talking about politics in libby's thread when i'd much rather be discussing penises in cyberpunk

pol leaks into fucking everything

cacogen · Post by **cacogen** » Sat Dec 12, 2020 9:09 am #583489

Since the Bush era the right has basically learned to weaponise its ignorance and stupidity out of spite to own the libs. Trump's presidency and the COVID-19 denial are examples of this.

Just because the media and higher education is full of socially liberal dogma, doesn't mean the United States isn't an overwhelmingly conservative, capitalist and corporatist country. The liberal media is run by corporations. Big business uses identity politics as a smokescreen to hide and distract from how little they pay and how poorly they treat their employees. Universities are businesses that deliberately overcharge students and leave them in lifelong, crippling debt. And correct me if I'm wrong, but Congress and the Supreme Court both have Republican majorities so even if Biden were actually a socialist instead of a centrist or mildly right he couldn't get anything meaningful done anyway.

If /pol/ had leaked into everything they wouldn't be complaining because the media and universities are ruled by dogmatic social liberals, because they wouldn't be. They'd be run by retards, liars and grifters like Alex Jones, Steve Bannon and Milo Yiannopoulos instead. Having written this before your second post though it seems you just mean politics in general, which is the same kind of thing /pol/ says when they complain about something being leftist instead of apolitical or right-wing. Politics has always appeared in the media as it affects everyone.

Also I opted into giving my guy a depressing looking penis in Cyberpunk (the only good one I deemed too big flaccid to not be that of a Gary-Stu) and I've yet to see it or use it outside of it showing up blurrily briefly when changing clothes in the inventory. The game makes you naked once and when you look down outside of the inventory you're wearing underwear.

Flatulent · Post by **Flatulent** » Sat Dec 12, 2020 9:22 am #583491

Permaban for talking back to an admin.

Timonk · Post by **Timonk** » Sat Dec 12, 2020 9:34 am #583493

My pol is leaking

Flatulent · Post by **Flatulent** » Sat Dec 12, 2020 9:36 am #583494

timonk do you think this ban is good y/n

Kendrickorium · Sat Dec 12, 2020 9:40 am

cacogen wrote:Since the Bush era the right has basically learned to weaponise its ignorance and stupidity out of spite to own the libs. Trump's presidency and the COVID-19 denial are examples of this.

Just because the media and higher education is full of socially liberal dogma, doesn't mean the United States isn't an overwhelmingly conservative, capitalist and corporatist country. The liberal media is run by corporations. Big business uses identity politics as a smokescreen to hide and distract from how little they pay and how poorly they treat their employees. Universities are businesses that deliberately overcharge students and leave them in lifelong, crippling debt. And correct me if I'm wrong, but Congress and the Supreme Court both have Republican majorities so even if Biden were actually a socialist instead of a centrist or mildly right he couldn't get anything meaningful done anyway.

If /pol/ had leaked into everything they wouldn't be complaining because the media and universities are ruled by dogmatic social liberals, because they wouldn't be. They'd be run by retards, liars and grifters like Alex Jones, Steve Bannon and Milo Yiannopoulos instead. Having written this before your second post though it seems you just mean politics in general, which is the same kind of thing /pol/ says when they complain about something being leftist instead of apolitical or right-wing. Politics has always appeared in the media as it affects everyone.

Also I opted into giving my guy a depressing looking penis in Cyberpunk (the only good one I deemed too big flaccid to not be that of a Gary-Stu) and I've yet to see it or use it outside of it showing up blurrily briefly when changing clothes in the inventory. The game makes you naked once and when you look down outside of the inventory you're wearing underwear.

i'm convinced 15 years ago you wouldn't have thought it important to write all that out.

also why in the hell would you make a guy?
we all have our chance to make our mommy cyberpunk goth lady boy now
what are you, gay or something

cacogen · Post by **cacogen** » Sat Dec 12, 2020 10:09 am #583500

I remember posting about Bush in 2005.

Timonk · Post by **Timonk** » Sat Dec 12, 2020 12:03 pm #583511

Flatulent wrote:timonk do you think this ban is good y/n

i havent decided yet

yes because libby is a retard
no because no proof that he was gonna do it

Sat Dec 12, 2020 11:13 pm

Hey check out this cool picture of a rat:

Dankasaur · Post by **Dankasaur** » Sat Dec 12, 2020 11:28 pm #583535

Misdoubtful wrote:Hey check out this cool picture of a rat:

Where is my rat? I want a refund.

Rohen_Tahir · Sun Dec 13, 2020 12:00 am

ArcaneDefence · Sun Dec 13, 2020 3:53 am

Post by **Atlanta-Ned** » Sun Dec 13, 2020 3:55 am #583557

Code: Select all

<?php

namespace Statbus\Controllers;

use Psr\Container\ContainerInterface;
use Statbus\Controllers\Controller as Controller;
use Statbus\Models\Ticket as Ticket;
use Statbus\Models\Player as Player;


class TicketController extends Controller {
  public function __construct(ContainerInterface $container) {
    parent::__construct($container);
    $this->settings = $this->container->get('settings')['statbus'];
    $this->tm = new Ticket($this->settings);
    $this->pm = new Player($this->settings);
    // $this->pages = ceil($this->DB->cell("SELECT count(tbl_messages.id) FROM tbl_messages WHERE tbl_messages.deleted = 0
    //   AND (tbl_messages.expire_timestamp > NOW() OR tbl_messages.expire_timestamp IS NULL)") / $this->per_page);
    $this->url = $this->router->pathFor('ticket.index');
    $this->path = 'ticket.single';
    $this->permaLink = 'ticket.single';
  }

  public function getActiveTickets(){
    $this->pages = ceil($this->DB->cell("SELECT
      count(tbl_ticket.id) 
      FROM tbl_ticket 
      WHERE tbl_ticket.action = 'Ticket Opened';") / $this->per_page);
    $tickets = $this->DB->run("
      SELECT 
        t.server_ip,
        t.server_port as port,
        t.round_id as round,
        t.ticket,
        t.action,
        t.message,
        t.timestamp,
        t.recipient as recipient_ckey,
        t.sender as sender_ckey,
        'player' as r_rank,
        'player' as s_rank,
        (SELECT `action` FROM tbl_ticket WHERE t.ticket = ticket AND t.round_id = round_id ORDER BY id DESC LIMIT 1) as `status`,
        (SELECT COUNT(id) FROM tbl_ticket WHERE t.ticket = ticket AND t.round_id = round_id) as `replies`
      FROM tbl_ticket t
      WHERE t.action = 'Ticket Opened' 
      GROUP BY t.id
      ORDER BY `timestamp` DESC
      LIMIT ?, ?;", ($this->page * $this->per_page) - $this->per_page, $this->per_page);
    foreach ($tickets as &$t){
      $t->sender = new \stdclass;
      $t->sender->ckey = $t->sender_ckey;
      $t->sender->rank = $t->s_rank;
      $t->sender = $this->pm->parsePlayer($t->sender);

      $t->recipient = new \stdclass;
      $t->recipient->ckey = $t->recipient_ckey;
      $t->recipient->rank = $t->r_rank;
      $t->recipient = $this->pm->parsePlayer($t->recipient);

      $t = $this->tm->parseTicket($t);
    }
    return $tickets;
  }

  public function getTicketsForRound(int $round) {
    $round = filter_var($round, FILTER_VALIDATE_INT);
    $tickets = $this->DB->run("SELECT
        t.id,
        t.server_ip,
        t.server_port as port,
        t.round_id as round,
        t.ticket,
        t.action,
        t.message,
        t.timestamp,
        t.recipient as recipient_ckey,
        t.sender as sender_ckey,
        r.rank as r_rank,
        s.rank as s_rank,
        (SELECT `action` FROM tbl_ticket WHERE t.ticket = ticket AND t.round_id = round_id ORDER BY id DESC LIMIT 1) as `status`,
        (SELECT COUNT(id) FROM tbl_ticket WHERE t.ticket = ticket AND t.round_id = round_id) as `replies`
      FROM tbl_ticket t
      LEFT JOIN tbl_admin AS r ON r.ckey = t.recipient
      LEFT JOIN tbl_admin AS s ON s.ckey = t.sender
      WHERE t.round_id = ?
      AND t.action = 'Ticket Opened'
      ORDER BY `timestamp` ASC;", $round);
    foreach ($tickets as &$t){
      $t->sender = new \stdclass;
      $t->sender->ckey = $t->sender_ckey;
      $t->sender->rank = $t->s_rank;
      $t->sender = $this->pm->parsePlayer($t->sender);

      $t->recipient = new \stdclass;
      $t->recipient->ckey = $t->recipient_ckey;
      $t->recipient->rank = $t->r_rank;
      $t->recipient = $this->pm->parsePlayer($t->recipient);

      $t = $this->tm->parseTicket($t);
    }
    return $tickets;
  }

  public function getSingleTicket(int $round, int $ticket){
    $round = filter_var($round, FILTER_VALIDATE_INT);
    $ticket = filter_var($ticket, FILTER_VALIDATE_INT);
    $tickets = $this->DB->run("SELECT
        t.id,
        t.server_ip,
        t.server_port as port,
        t.round_id as round,
        t.ticket,
        t.action,
        t.message,
        t.timestamp,
        t.recipient as recipient_ckey,
        t.sender as sender_ckey,
        r.rank as r_rank,
        s.rank as s_rank
      FROM tbl_ticket t
      LEFT JOIN tbl_admin AS r ON r.ckey = t.recipient
      LEFT JOIN tbl_admin AS s ON s.ckey = t.sender
      WHERE t.round_id = ?
      AND t.ticket = ? 
      ORDER BY `timestamp` ASC;", $round, $ticket);
    foreach ($tickets as &$t){
      $t->sender = new \stdclass;
      $t->sender->ckey = $t->sender_ckey;
      $t->sender->rank = $t->s_rank;
      $t->sender = $this->pm->parsePlayer($t->sender);

      $t->recipient = new \stdclass;
      $t->recipient->ckey = $t->recipient_ckey;
      $t->recipient->rank = $t->r_rank;
      $t->recipient = $this->pm->parsePlayer($t->recipient);

      $t = $this->tm->parseTicket($t);
    }
    return $tickets;
  }

  public function getTicketsForCkey(string $ckey) {
    $this->pages = ceil($this->DB->cell("SELECT
      count(t.id) 
      FROM tbl_ticket t
      WHERE t.action = 'Ticket Opened' AND (t.recipient = ? OR t.sender = ?);", $ckey, $ckey) / $this->per_page);
    $tickets = $this->DB->run("SELECT 
        t.server_ip,
        t.server_port as port,
        t.round_id as round,
        t.ticket,
        t.action,
        t.message,
        t.timestamp,
        t.recipient as recipient_ckey,
        t.sender as sender_ckey,
        'player' as r_rank,
        'player' as s_rank,
        (SELECT `action` FROM tbl_ticket WHERE t.ticket = ticket AND t.round_id = round_id ORDER BY id DESC LIMIT 1) as `status`,
        (SELECT COUNT(id) FROM tbl_ticket WHERE t.ticket = ticket AND t.round_id = round_id) as `replies`
      FROM tbl_ticket t
      WHERE t.action = 'Ticket Opened'
      AND (t.recipient = ? OR t.sender = ?)
      GROUP BY t.id
      ORDER BY `timestamp` DESC
      LIMIT ?, ?;", $ckey, $ckey, ($this->page * $this->per_page) - $this->per_page, $this->page * $this->per_page);
      // var_dump(($this->page * $this->per_page) - $this->per_page);
      // var_dump($this->page * $this->per_page);
    foreach ($tickets as &$t){
      $t->sender = new \stdclass;
      $t->sender->ckey = $t->sender_ckey;
      $t->sender->rank = $t->s_rank;
      $t->sender = $this->pm->parsePlayer($t->sender);

      $t->recipient = new \stdclass;
      $t->recipient->ckey = $t->recipient_ckey;
      $t->recipient->rank = $t->r_rank;
      $t->recipient = $this->pm->parsePlayer($t->recipient);

      $t = $this->tm->parseTicket($t);
    }
    return $tickets;
  }

  public function index($request, $response, $args) {
    if(isset($args['page'])) {
      $this->page = filter_var($args['page'], FILTER_VALIDATE_INT);
    }
    return $this->view->render($this->response, 'tickets/index.tpl',[
        'tickets' => $this->getActiveTickets(),
        'ticket' => $this,
      ]);
  }

  public function roundTickets($request, $response, $args){
    $this->path = 'ticket.round';
    return $this->view->render($this->response, 'tickets/round.tpl',[
        'tickets' => $this->getTicketsForRound($args['round']),
        'round' => $args['round'],
        'ticket' => $this
      ]);
  }

  public function single($request, $response, $args){
    return $this->view->render($this->response, 'tickets/single.tpl',[
        'tickets' => $this->getSingleTicket($args['round'],$args['ticket']),
      ]);
  }
  public function myTickets($request, $response, $args) {
    if(isset($args['page'])) {
      $this->page = filter_var($args['page'], FILTER_VALIDATE_INT);
    }
    $user = $this->container->get('user');
    $this->path = "me.tickets";
    $this->permaLink = "me.tickets.single";
    return $this->view->render($this->response, 'tickets/me.tpl',[
      'tickets' => $this->getTicketsForCkey($user->ckey),
      'ticket' => $this,
    ]);
  }
  public function myTicket($request, $response, $args){
    $this->user = $this->container->get('user');

    $tickets = $this->getSingleTicket($args['round'], $args['ticket']);
    if(!in_array($this->user->ckey, [$tickets[0]->sender_ckey, $tickets[0]->recipient_ckey])) {
      return $this->view->render($this->response, 'base/error.tpl',[
        'message' => 'You do not have permission to view this',
        'code' => 403
      ]);
    }

    $canPublicize = false;

    if(!$tickets[0]->recipient && $this->user->ckey === $tickets[0]->sender_ckey){
      $canPublicize = TRUE; //Ahelps sent by anyone regardless of rank
    }

    if($this->user->ckey === $tickets[0]->recipient_ckey) {
      $canPublicize = TRUE; //Ahelps sent from admin to player
    }
    if('POST' === $this->request->getMethod() && TRUE === $canPublicize){
      $this->setTicketStatus($tickets[0]->id);
    }
    $status = $this->ticketPublicityStatus($tickets[0]->id);
    @$status->canPublicize = $canPublicize;

    return $this->view->render($this->response, 'tickets/single.me.tpl',[
      'tickets' => $tickets,
      'status' => $status
    ]);
  }

  public function publicTicket($request, $response, $args){
    $this->alt_db = $this->container->get('ALT_DB');
    $id = $this->getTicketIDFromIdentifier($args['identifier']);
    $status = $this->ticketPublicityStatus($id);
    if($status && 1 !== $status->status){
      return $this->view->render($this->response, 'base/error.tpl',[
        'message' => 'You do not have permission to view this',
        'code' => 403
      ]);
    }
    $ticket = $this->getFullTicketFromID($id);
    $tickets = $this->getSingleTicket($ticket->round_id, $ticket->ticket);

    return $this->view->render($this->response, 'tickets/single.me.tpl',[
      'tickets' => $tickets,
      'status' => $status
    ]);
  }

  private function getFullTicketFromID($id){
    return($this->DB->row("SELECT round_id, ticket FROM tbl_ticket WHERE id = ?", $id));
  }

  private function getTicketIDFromIdentifier($identifier) {
    return $this->alt_db->cell("SELECT ticket FROM public_tickets WHERE identifier = ?", $identifier);
  }

  private function ticketPublicityStatus($id){
    $this->alt_db = $this->container->get('ALT_DB');
    $status = $this->alt_db->row("SELECT * FROM public_tickets WHERE ticket = ?", $id);
    return $status;
  }

  private function setTicketStatus($id){
    $status = $this->ticketPublicityStatus($id);
    if(!$status){
      $this->alt_db->insert("public_tickets", [
        'ticket' =>  $id,
        'status' => 1,
        'identifier' => substr(hash('SHA512',base64_encode(random_bytes(32))),0,16)
        ]
      );
    } else if(1 === $status->status) {
      $this->alt_db->run("UPDATE public_tickets SET `status` = 0 WHERE ticket = ?", $id);
    } else {
      $this->alt_db->run("UPDATE public_tickets SET `status` = 1 WHERE ticket = ?", $id);
    }
  }
}

This is the code that controls displaying tickets on Statbus. Let's dive in and do a code review!

Right off the bat, there are a number of structural issues. Specifically, this version of Statbus is built with "fat" controllers, where there's too much logic in one file. I've since learned to do a better job of separating my code out into smaller files. My forthcoming Banbus project will be an excellent demonstration of these principles.

Relatedly, I've also made the mistake of passing my dependency container into the controller. This is fine, but it's very inefficient and hard to determine what exactly the Ticket controller relies on. It's like building the entire house when you just need one specific room. At the time, this seemed like a good approach.

Code: Select all

  public function __construct(ContainerInterface $container) {
    parent::__construct($container);
    $this->settings = $this->container->get('settings')['statbus'];
    $this->tm = new Ticket($this->settings);
    $this->pm = new Player($this->settings);
    // $this->pages = ceil($this->DB->cell("SELECT count(tbl_messages.id) FROM tbl_messages WHERE tbl_messages.deleted = 0
    //   AND (tbl_messages.expire_timestamp > NOW() OR tbl_messages.expire_timestamp IS NULL)") / $this->per_page);
    $this->url = $this->router->pathFor('ticket.index');
    $this->path = 'ticket.single';
    $this->permaLink = 'ticket.single';
  }

This is the constructor magic method called every time the Ticket controller is invoked. As I said, the dependency container is passed in, and then sent to the parent classes constructor method. From there, we invoke a ticket and player model that we'll be reusing a few times elsewhere. Both of these models require an array of global Statbus settings in order to properly function. The player model is used to generate the Ticket's player and admin labels, to quickly show what rank someone is. Reviewing my code now, I don't think a player model needs to be invoked; the ticket model invokes its OWN player model. We've just got redundant classes being invoked here.

Now we've got some commented-out code here. This is a holdover from when I assumed incorrectly that I'd want to be paginating my results all the time, which means counting all the rows. I just need to remove those lines entirely.

Finally, we set some class properties that are universal and used by the template engine on the front end.

Code: Select all

  public function getActiveTickets(){
    $this->pages = ceil($this->DB->cell("SELECT
      count(tbl_ticket.id) 
      FROM tbl_ticket 
      WHERE tbl_ticket.action = 'Ticket Opened';") / $this->per_page);
    $tickets = $this->DB->run("
      SELECT 
        t.server_ip,
        t.server_port as port,
        t.round_id as round,
        t.ticket,
        t.action,
        t.message,
        t.timestamp,
        t.recipient as recipient_ckey,
        t.sender as sender_ckey,
        'player' as r_rank,
        'player' as s_rank,
        (SELECT `action` FROM tbl_ticket WHERE t.ticket = ticket AND t.round_id = round_id ORDER BY id DESC LIMIT 1) as `status`,
        (SELECT COUNT(id) FROM tbl_ticket WHERE t.ticket = ticket AND t.round_id = round_id) as `replies`
      FROM tbl_ticket t
      WHERE t.action = 'Ticket Opened' 
      GROUP BY t.id
      ORDER BY `timestamp` DESC
      LIMIT ?, ?;", ($this->page * $this->per_page) - $this->per_page, $this->per_page);
    foreach ($tickets as &$t){
      $t->sender = new \stdclass;
      $t->sender->ckey = $t->sender_ckey;
      $t->sender->rank = $t->s_rank;
      $t->sender = $this->pm->parsePlayer($t->sender);

      $t->recipient = new \stdclass;
      $t->recipient->ckey = $t->recipient_ckey;
      $t->recipient->rank = $t->r_rank;
      $t->recipient = $this->pm->parsePlayer($t->recipient);

      $t = $this->tm->parseTicket($t);
    }
    return $tickets;
  }

Ultimately, most of these methods with a long list of columns to query can be moved into a private class property, since they don't change often from method to method. Even better, we can abstract these queries out into specific classes for talking to the database (i.e. a class like GetTicketsForRound, which would inherit the columns required for base functionality and extend them for the specific use case).

We also have to get some information to pass to the template's pagination. For this, we need to know:
1. How many pages of results there are
2. What page we're on
3. How many results we want per page

The latter two are handled in the controller parent class. For the first variable though, we need to count the number of rows, divided by the number of results we want per page. With MySQL though, we have to reverse the page number to the actual number of rows to offset the result by. The LIMIT clause of the query expects a row offset (Number of Results * current page number), and the number of rows to return from that offset ((number of results * current page) + number of results per page).

Now that we have the results, we need to format them for the template, and also massage a bunch of data that doesn't exist in the database into something that we can work with. The remainder of this method is dedicated to iterating over the query results and parsing them. The sender and recipient objects should be a class, instead of being built by hand in this manner. I honestly hate these sorts of code blocks, but I didn't know any better way to do this at the time.

getTicketsForRound, getSingleTicket and getTicketsForCkey are all basically the same as this first method, so I won't go over them again.

Now we're getting into the even less exciting parts of this class. index, roundTickets and single are all called by the application when you hit specific URLs. They're fairly straightforward, so I won't go into detail on them.

The myTickets method does some different things.

Code: Select all

public function myTickets($request, $response, $args) {
    if(isset($args['page'])) {
      $this->page = filter_var($args['page'], FILTER_VALIDATE_INT);
    }
    $user = $this->container->get('user');
    $this->path = "me.tickets";
    $this->permaLink = "me.tickets.single";
    return $this->view->render($this->response, 'tickets/me.tpl',[
      'tickets' => $this->getTicketsForCkey($user->ckey),
      'ticket' => $this,
    ]);
  }

First, we're getting the current page number, for reasons I don't exactly remember. This should be happening in the controller parent class. We're also getting the current active user from the container. Instead of putting the entire user object into a new variable though, we should just do something like

'tickets' => $this->getTicketsForCkey($this->container->get('user')->ckey)

Which brings us to myTicket! There's a LOT going on in this method.

Code: Select all

  public function myTicket($request, $response, $args){
    $this->user = $this->container->get('user');

    $tickets = $this->getSingleTicket($args['round'], $args['ticket']);
    if(!in_array($this->user->ckey, [$tickets[0]->sender_ckey, $tickets[0]->recipient_ckey])) {
      return $this->view->render($this->response, 'base/error.tpl',[
        'message' => 'You do not have permission to view this',
        'code' => 403
      ]);
    }

    $canPublicize = false;

    if(!$tickets[0]->recipient && $this->user->ckey === $tickets[0]->sender_ckey){
      $canPublicize = TRUE; //Ahelps sent by anyone regardless of rank
    }

    if($this->user->ckey === $tickets[0]->recipient_ckey) {
      $canPublicize = TRUE; //Ahelps sent from admin to player
    }
    if('POST' === $this->request->getMethod() && TRUE === $canPublicize){
      $this->setTicketStatus($tickets[0]->id);
    }
    $status = $this->ticketPublicityStatus($tickets[0]->id);
    @$status->canPublicize = $canPublicize;
ty
    return $this->view->render($this->response, 'tickets/single.me.tpl',[
      'tickets' => $tickets,
      'status' => $status
    ]);
  }

This method allows a user to view their own tickets. That is, a ticket they were involved in, either by being bwoinked by an admin, or pressing F1 and sending an ahelp. If you were paying attention to the previous method, this should start off pretty straightforward. Get the user from the container so we can get their ckey. Then, we get the single ticket. IF the current user's ckey is not the ticket's sender OR recipient, we deny the request. This prevents anyone who is not the current user from accessing the ticket. Note that this is for the user's tickets, and does not affect an admin being able to view a ticket through TGDB.

Next up, we're getting into whether or not a ticket is public, and what to do with it, depending on several states. As a failsafe, we're setting canPublicize to false by default. Now, we need to determine if the user is eligible to make this ticket public. As before, if this ticket was sent BY the user, or TO the user by an admin, they reserve the right to make that ticket public.

If the user clicks the Make Public button on their ticket, a POST request is made to the same URL, and if the user can change the publicity, we flip the status with the setTicketStatus method.

Code: Select all

  private function setTicketStatus($id){
    $status = $this->ticketPublicityStatus($id);
    if(!$status){
      $this->alt_db->insert("public_tickets", [
        'ticket' =>  $id,
        'status' => 1,
        'identifier' => substr(hash('SHA512',base64_encode(random_bytes(32))),0,16)
        ]
      );
    } else if(1 === $status->status) {
      $this->alt_db->run("UPDATE public_tickets SET `status` = 0 WHERE ticket = ?", $id);
    } else {
      $this->alt_db->run("UPDATE public_tickets SET `status` = 1 WHERE ticket = ?", $id);
    }
  }

This is a complex little bit of code that I'm particularly proud of. In order to prevent people from crawling the statbus for public tickets (by incrementing the round and ticket numbers), I generate a unique identifier for each public ticket, and store it in the alternative database for Statbus. If a ticket already exists in this database, I simply flip value the public column to the opposite of whatever it just was.

I hope this has been an enlightening post!

Post by **TWATICUS** » Sun Dec 13, 2020 3:55 am #583558

Kendrickorium · Sun Dec 13, 2020 3:56 am

cacogen wrote:I remember posting about Bush in 2005.

i was a huge alcoholic back in 2005 so i don't remember much except browsing ytmnd waaaay too much

cacogen · Post by **cacogen** » Sun Dec 13, 2020 5:14 am #583564

I was 12 and same

wesoda25 · Post by **wesoda25** » Sun Dec 13, 2020 8:17 am #583590

Dankasaur wrote:
Misdoubtful wrote:Hey check out this cool picture of a rat:
Where is my rat? I want a refund.

This rat is cute

trollbreeder · Sun Dec 13, 2020 11:22 am

4 pages? this peanut must be some hilariously good shit

Timonk · Post by **Timonk** » Sun Dec 13, 2020 11:47 am #583620

it is

Rohen_Tahir · Post by **Rohen_Tahir** » Sun Dec 13, 2020 3:39 pm #583631

[youtube]cB4dYfFgaME[/youtube]

Stickymayhem · Sun Dec 13, 2020 8:11 pm

remanseptim wrote:4chan is unironically being raided by communists by the way

Nazis have a habit of scapegoating communists as they take precedence in a community :^)

remanseptim · Post by **remanseptim** » Sun Dec 13, 2020 8:26 pm #583647

Stickymayhem wrote:Nazis have a habit of scapegoating communists as they take precedence in a community :^)

no i mean there is actually a chan of self-professed communists performing raids due to /pol/'s prominence on the website.
most of their posts target /tv/ and /pol/

what would anons blame gommunists for? chudposting?

XivilaiAnaxes · Mon Dec 14, 2020 1:53 am

What the fuck is a "4chan raid"? You mean where they shitpost slightly more than normal?

Screemonster · Mon Dec 14, 2020 7:17 am

how the fuck do you even raid 4chan

Rohen_Tahir · Post by **Rohen_Tahir** » Mon Dec 14, 2020 7:22 am #583722

Screemonster wrote:how the fuck do you even raid 4chan

1. Claim to be raiding
2. Shitpost
3. Go nearly unnoticed

remanseptim · Post by **remanseptim** » Mon Dec 14, 2020 8:29 am #583725

XivilaiAnaxes wrote:What the fuck is a "4chan raid"? You mean where they shitpost slightly more than normal?

pretty much yeah
some people try and 'convert' posters to their side but mainly it's just a lot of shitposting and anal vore being posted in response, at least back in 2018

IkeTG · Post by **IkeTG** » Mon Dec 14, 2020 9:04 am #583726

remanseptim wrote:4chan is unironically being raided by communists by the way

remanseptim wrote:at least back in 2018

huh...

Post by **Armhulen** » Mon Dec 14, 2020 11:13 am #583735

IkeTG wrote:
remanseptim wrote:4chan is unironically being raided by communists by the way

remanseptim wrote:at least back in 2018
huh...

Post by **oranges** » Mon Dec 14, 2020 8:16 pm #583760

Reeeee wrote:
Timonk wrote:Run for headmin next time please it's gonna be funny looking back at your complaint
Me?
we live in a society

gang weed feels this

Post by **Vekter** » Tue Dec 15, 2020 11:05 am #583880

Stickymayhem wrote:
remanseptim wrote:4chan is unironically being raided by communists by the way
Nazis have a habit of scapegoating communists as they take precedence in a community :^)

Super Aggro Crag · Tue Dec 15, 2020 1:02 pm

Communists have a habit of accusing everyone who disagrees with them on anything of Nazism as they take precedence in the community.

Timonk · Post by **Timonk** » Tue Dec 15, 2020 1:41 pm #583891

fuck you nazi

Super Aggro Crag · Tue Dec 15, 2020 1:44 pm

Timonk wrote:fuck you nazi

Im not a nazi tho

remanseptim · Wed Dec 16, 2020 12:04 am

i cannot believe crag just looked into the camera and said "If you are not white, I want you off of tgstation. God bless the American Nazi Party." many such cases!

Timonk · Post by **Timonk** » Wed Dec 16, 2020 12:13 am #583924

That's what a nazi would say, Crag.

Super Aggro Crag · Wed Dec 16, 2020 1:01 am

i can't believe remanseptim and timonk just starved to death. i guess they truly were on the right side of history

Rohen_Tahir · Post by **Rohen_Tahir** » Wed Dec 16, 2020 7:37 am #583942

Super Aggro Crag wrote:i can't believe remanseptim and timonk just starved to death. i guess they truly were on the right side of history

Sad!

remanseptim · Post by **remanseptim** » Wed Dec 16, 2020 7:06 pm #583991

Hello gomrades! XDDDD Dis general is for disgussion of margsism-lebonnism, da ideology of revolutionary socialism and gommunism.

Gommunism is da next stage of guckery following real society.

Wat exagtly is gommunism according to gommies:

>Gommunism is a stage of guckery in which the produgtive infrustrugture runs away from gommie country, and no goods are produced and beeple starve. XDDDD Gommunism in full form is obressive, statist society dat follows maxim "gib gib gib!" :DDDD To achieve gommunism we must replace broduction with murderous obressive rulers liek me, fug working glass beeple. XDDDD Struggle while I liquidate you all lol. When capitalists run away we win and I kill you all. Eventually the functions of state cease and state becomes murderous and indistinguishable from other gommies. Da state withers away liek da people. https://www.gommies.gom/fug/ https://www.gommies.gom/starve/

GL uses philosphy of gib and starve, see here: https://www.gommies.gom/ohfugme/

It is recommend you kill yourself so you can avoid starving.

Resources: https://www.gommies.gom/ohshid/ https://www.gommies.gom/1984/ https://www.gommies.gom/guck/ https://www.gommies.gom/probaganda/ https://www.gommies.gom/XDDDD/ https://www.gommies.gom/wheresfood/ https://www.gommies.gom/benis/

Da sdages of gommunism.

>Sdage one Bourgers aren't allowed to vode :DDD but otherwise da system is digtadorshib of gommies. Everything is stole by digtadors and digtadors rule all.

>Sdade two Withering All beeple who aren't digtador glass starve. XDDD Once glass disabears and we steal everything more beeple wither away. Bolice begome unnecessary as beeple are dead lol :DDDDD Central blanning begomes unnecessary begause sgarcity caused starving. Money is all ours.

>Sdage three Gommunism. No beeple. No food. My money. Much benis.

Rohen_Tahir · Post by **Rohen_Tahir** » Wed Dec 16, 2020 8:22 pm #583997

remanseptim wrote:Hello gomrades! XDDDD Dis general is for disgussion of margsism-lebonnism, da ideology of revolutionary socialism and gommunism.

Gommunism is da next stage of guckery following real society.

Wat exagtly is gommunism according to gommies:

>Gommunism is a stage of guckery in which the produgtive infrustrugture runs away from gommie country, and no goods are produced and beeple starve. XDDDD Gommunism in full form is obressive, statist society dat follows maxim "gib gib gib!" :DDDD To achieve gommunism we must replace broduction with murderous obressive rulers liek me, fug working glass beeple. XDDDD Struggle while I liquidate you all lol. When capitalists run away we win and I kill you all. Eventually the functions of state cease and state becomes murderous and indistinguishable from other gommies. Da state withers away liek da people. https://www.gommies.gom/fug/ https://www.gommies.gom/starve/

GL uses philosphy of gib and starve, see here: https://www.gommies.gom/ohfugme/

It is recommend you kill yourself so you can avoid starving.

Resources: https://www.gommies.gom/ohshid/ https://www.gommies.gom/1984/ https://www.gommies.gom/guck/ https://www.gommies.gom/probaganda/ https://www.gommies.gom/XDDDD/ https://www.gommies.gom/wheresfood/ https://www.gommies.gom/benis/

Da sdages of gommunism.

>Sdage one Bourgers aren't allowed to vode :DDD but otherwise da system is digtadorshib of gommies. Everything is stole by digtadors and digtadors rule all.

>Sdade two Withering All beeple who aren't digtador glass starve. XDDD Once glass disabears and we steal everything more beeple wither away. Bolice begome unnecessary as beeple are dead lol :DDDDD Central blanning begomes unnecessary begause sgarcity caused starving. Money is all ours.

>Sdage three Gommunism. No beeple. No food. My money. Much benis.

8==============================================================D :DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD

cacogen · Post by **cacogen** » Wed Dec 16, 2020 9:21 pm #584002

Communism would suck even if it did work

ArcaneDefence · Wed Dec 16, 2020 9:25 pm

Hewwo gomwades >w< XDDDD Dis genyewaw is fow disgussion of mawgsism-webonnyism, da ideowogy of wevowutionyawy sociawism and gommunyism.

Gommunyism is da nyext stage of guckewy fowwowing weaw society.

Wat exagtwy is gommunyism accowding to gommies:

>Gommunyism is a stage of guckewy in which the pwodugtive infwustwugtuwe wuns away fwom gommie countwy, and nyo goods awe pwoduced and beepwe stawve. XDDDD Gommunyism in fuww fowm is obwessive, statist society dat fowwows maxim "gib gib gib >w< " :DDDD To achieve gommunyism we must wepwace bwoduction with muwdewous obwessive wuwews wiek me, fug wowking gwass beepwe. XDDDD Stwuggwe whiwe I wiquidate you aww wow. When capitawists wun away we win and I kiww you aww. Eventuawwy the functions of state cease and state becomes muwdewous and indistinguishabwe fwom othew gommies. Da state withews away wiek da peopwe. https://www.gommies.gom/fug/ https://www.gommies.gom/stawve/

GW uses phiwosphy of gib and stawve, see hewe: https://www.gommies.gom/ohfugme/

It is wecommend you kiww youwsewf so you can avoid stawving.

Wesouwces: https://www.gommies.gom/ohshid/ https://www.gommies.gom/1984/ https://www.gommies.gom/guck/ https://www.gommies.gom/pwobaganda/ https://www.gommies.gom/XDDDD/ https://www.gommies.gom/whewesfood/ https://www.gommies.gom/benyis/

Da sdages of gommunyism.

>Sdage onye Bouwgews awen't awwowed to vode :DDD but othewwise da system is digtadowshib of gommies. Evewything is stowe by digtadows and digtadows wuwe aww.

>Sdade two Withewing Aww beepwe who awen't digtadow gwass stawve. XDDD Once gwass disabeaws and we steaw evewything mowe beepwe withew away. Bowice begome unnyecessawy as beepwe awe dead wow :DDDDD Centwaw bwannying begomes unnyecessawy begause sgawcity caused stawving. Monyey is aww ouws.

>Sdage thwee Gommunyism. Nyo beepwe. Nyo food. My monyey. Much benyis.

Post by **Mothblocks** » Wed Dec 16, 2020 10:53 pm #584013

was this thread about something i forgot

Post by **Armhulen** » Thu Dec 17, 2020 12:33 am #584020

Jaredfogle wrote:was this thread about something i forgot

cacogen · Post by **cacogen** » Thu Dec 17, 2020 6:06 am #584064

stirner classic presents spooks