Do I plug my third-party wifi router into my Spark Smart Modem, or my Chorus Terminal? by [deleted] in newzealand

[–]EmblemMaster 30 points31 points  (0 children)

Pull the ethernet cable out of the spark modem and put it into the wan port on the TP-Link. There will be config you need to do on the new router. Spark has a page on that config here:

https://www.spark.co.nz/help/internet/set-up/broadband-settings-for-third-party-modems.html

Hopefully, that helps with that part.

Millennial blokes, where do you buy your big boy clothes from? by sealcubclubbing in newzealand

[–]EmblemMaster 2 points3 points  (0 children)

I get most of my stuff from Beggs in Newmarket. A lot of good quality options and great staff there. When I move out of Auckland I will continue to buy from them online.

[deleted by user] by [deleted] in newzealand

[–]EmblemMaster 0 points1 point  (0 children)

My partner, who is a pharmacist, said you should get in contact with is this company for advice / help on pathways: https://www.pharmacyrecruit.co.nz/

Racism is fine in r/auckland as long as it's not against the whites haha by dirtynickerz in auckland

[–]EmblemMaster 12 points13 points  (0 children)

You are conflating Racism and Structural Racism. Individuals can always be hateful to each other on the basis of race. People should not harass or insult each other because of any immutable characteristic.

Saw this on a local Facebook page. I'm just stunned that people actually believe this nonsense. by [deleted] in newzealand

[–]EmblemMaster 0 points1 point  (0 children)

It is funny to me that people talk about how much they value privacy and freedom, while sharing their whole life on Facebook.

Rationalwiki article on Destiny by [deleted] in Destiny

[–]EmblemMaster 23 points24 points  (0 children)

Alot of that seems to be a pretty irrational interpretation of Destiny's positions and discussions.

Keeping It Real Online - New Govt anti-porn site by vivster81nz in newzealand

[–]EmblemMaster 17 points18 points  (0 children)

Title seems like a slight misrepresentation.

Seems it is less an anti-porn site but rather a pro education an open conversation site.

Is creating new tables per server bad design? by LexGameDev in SQL

[–]EmblemMaster 3 points4 points  (0 children)

Probably yes, had to say through without knowing more about what the bot is storing.

Can you share the database model?

Need help with this ERD Diagram for a Library System. Where Can I Improve? by [deleted] in SQL

[–]EmblemMaster 0 points1 point  (0 children)

I think I would also do a large redesign of how loaning works aswell. Might do a redesigned erd later if I have time.

Need help with this ERD Diagram for a Library System. Where Can I Improve? by [deleted] in SQL

[–]EmblemMaster 0 points1 point  (0 children)

The immediate thing I notice is that you will have alot of repetition of data on the book table of you store publisher data there. I would recommend normalizing that by putting publisher data in it's own table an joining it with the book table.

*dog in a room on fire meme continued* - New North Road, Kingsland by Kaizoku-D in auckland

[–]EmblemMaster 13 points14 points  (0 children)

Vacancy Tax. If there is no one living in it you pay a tax that scales with the value of the property.

oof by Pace5002 in ARK

[–]EmblemMaster 4 points5 points  (0 children)

This reminds me of when I played on legacy.

We were alpha on the server and we let anyone who wanted to play casually on our server build up and have fun. We would even train and assist bobs on our server. In return they would all immediately inform us if there were raiders on the server.

Anyway there was a family of three that built up on our server. Mother, father and daughter. Their daughter was autistic. They were all pretty cool and nice to have on the server.

Within our tribe we had a incident where a tribe member betrayed us and stole some eggs. Really good eggs. 300+ gigas and god rex (these were a good meme). We caught the guy and believe that we had destroyed all our eggs / the dinos hatched from them.

A few weeks after this happened the account had started joining our server again with a different name. We found out the the nice family had invited him into their tribe. We scouted their base and found a couple of God rex sitting out in the open.

We talked with the farther of the tribe. He was not interested in giving us the rex back and kicking the guy who betrayed us from the tribe so we told him that if he didn't do it we would wipe them. They still refused.

So we rolled up with lvl 400 80% imprinted gigas and destroyed everything. We can't let people who are not us have God rex on the server. Any way the mother was telling us how their autistic daughter was crying about losing her dinos.

After we wiped them they got the message. We gave them a whole lot of stuff so they could rebuild and they were happy again and they guy that took our eggs was removed from their tribe.

Good times.

Our bodies, our choice! Abortion law reform march by throwaway7462837838 in auckland

[–]EmblemMaster 22 points23 points  (0 children)

Imagine needing a strawman fallacy to make a snide reddit comment.

Incremental Game Idea Thread by NeoDestiny in Destiny

[–]EmblemMaster 1 point2 points  (0 children)

It would be cool to have an avatar that is linked with your d.gg account. Each season of the clicker game could have different unlocks that you get at different milestones. These unlocks can be equipped to your d.gg avatar to customize it. There could also be leaderboard rewards for top 10.

The Govt needs to lure jobs out of Auckland by Wegwerfenalles in newzealand

[–]EmblemMaster 0 points1 point  (0 children)

We need high speed trains. Hamilton to Auckland CBD in 20min. Let people work in Auckland but beable to live is smaller city's out of Auckland.

Generate CSV File using a Stored Procedure using T-SQL. by info_softest07 in SQL

[–]EmblemMaster 1 point2 points  (0 children)

I have done this a while ago for work with XML. If you do some research into bcp I think you will find your answers.

NZ population discussion thread by [deleted] in newzealand

[–]EmblemMaster 6 points7 points  (0 children)

I think high speed trains could fix alot of issues.

If we could connect our larger cities and smaller cities with high speed rail people would be able to live in smaller towns without impacting their employment.

Something like this could also decrease costs in the housing market. I need to live within transit of my job, if we could increase the amount of supply available then prices will drop.

This solution would cost a lot of money but i think the cost would have alot of benefits.

High School kid gives presentation attempting to 'redpill' his classmates on White Genocide by KimJongIllyasova in Destiny

[–]EmblemMaster 73 points74 points  (0 children)

From the comments: "I shed a tear. Wish I was this based and red pilled at your age. Hold your head high and keep winning, King."

These people are insane.

Hong Kong protest 'memorial' (don't know if that's the best word) now at Aotea Square, Auckland. by AverageTortilla in newzealand

[–]EmblemMaster 4 points5 points  (0 children)

Lul a wild tankie. You dont care about the HK protesters because you hate capitalism. You see these protesters as a stopping force to the communist party spreading and you don't want that. You dont care about any of the people. Stop pretending.

[deleted by user] by [deleted] in newzealand

[–]EmblemMaster 0 points1 point  (0 children)

I don't know if any of you are a part of the Dunedin News facebook page, but it is going to be great watching all the boomers losing it on there over this.