Best posts made by thegillion

For anyone that didnt install the app because it was not in the play store. It is now! https://play.google.com/store/apps/details?id=appinventor.ai_TheGillion.SCR

I was asking what your home IT setup is.My setup is

• my work/home computer with dual 22" screens

• Free NAS home server

• Home PBX

• XBMC server for home media.

• Ubiquiti UniFi UAP

• Ubiquiti Edgerouter Lite.

• 8 port gigabit switch.

I know some people have crazier setups then mine but it is what it is.

@coliver said:

Does anyone else find that really creepy?

yeah
http://dni.li/wp-content/pixx/2008/01/ms/08-ms.jpg

This page more then any

http://www.wimp.com/christmascard/ I want one like this!

I had a friend send me this as soon as I saw it I had to share.

http://www.engadget.com/2015/05/01/boeing-787-dreamliner-software-bug/

"The 787 Dreamliner has been plagued with battery woes since its early days, to the point where the Federal Aviation Administration kept it from flying the skies in the past. And while those technical difficulties are apparently taken care of, Boeing's flagship airliner could be on the way to more trouble soon. According to the FAA, there's a software bug in the 787 Dreamliner that can cause its electrical system to fail and, as a result, lead to "loss of control" of the plane. But why? The FAA says this is triggered by the aircraft's electrical generators, which could give out if they have been powered on continuously for over eight months. "A Model 787 airplane that has been powered continuously for 248 days can lose all alternating current electrical power due to the generator control units simultaneously going into failsafe mode," the FAA said in a statement warning of the flaw. "We are issuing this AD to prevent loss of all AC electrical power, which could result in loss of control of the airplane." Boeing, for its part, is aware of the problem and has reset the power on 787 Dreamliners currently in service. Most importantly, the company's already working on an update that will patch the software vulnerability -- though there's no word on when its jets will receive it."

Can you imagine the tech support call?

@thanksaj said:

So one thing I will say I don't like about AWS is the names for everything. A VM is an instance. Firewall rules are under security group, which to me is users and those users' permissions. They seemed to go out of their way to make all the names of standard stuff as unique to them as possible, and that is a little irritating, IMHO.

They think they are cisco lol

@thwr said in Potty Plotter:

Any plans to expand your potty plotter to Èurope?

It can take in data from anyone anywhere. If you have a potty that needs plotting just download and add it.

I have been trying to get mine to work. I am running it on a VPS from vultr and cant get my sons kindle to connect or my windows 10 minecraft. My android tablet will work. If someone wants to try the IP is 104.207.142.12

@StrongBad said in Potty Plotter:

@thegillion said in Potty Plotter:

@Dashrender yes that is correct you can only add parties from the app

That's good for security to some degree, but stops people with iPads, I assume (no GPS) and without phones or who don't have a signal at the time from adding potties. You'll limit the available information and growth.

Adding potties from the site is something I have been thinking about adding to the road map.

I would like to thank everyone on here. Also, I have added a lot more potties to the system and app updates. So if you have downloaded it please do so.

@scottalanmiller Yeah I see you on there. I am using the same build you are.

@scale Thank you.

I see some people are adding potties.

I am having some troubles with my qmail using SMTP routes via sendgrid. I have talked with their support and they do not see the server trying to sign in. I get this error

Text
delivery 11: failure: Connected_to_108.168.190.108_but_sender_was_rejected./Remote_host_said:_550_Unauthenticated_senders_not_allowed/
I used the qmail setup here

https://sendgrid.com/docs/Integrate/Mail_Servers/qmail.html

I have tried removing and reinstalling qmail and installing the patch listed here

http://notes.sagredo.eu/node/84

I also did the telnet test that was listed here

https://support.sendgrid.com/hc/en-us/articles/200182038-Testing-your-connectivity-to-Sendgrid-s-SMT...

and the test passed with the same username and password I am using.

I would love to get this working and if anyone can help I will be very thinkful.

@DustinB3403 said in Potty Plotter:

@thegillion said in Potty Plotter:

@DustinB3403 said in Potty Plotter:

Might I recommend adding a required flag for the name and review.

If the name is empty it doesn't allow the potty to be plotted.

Hrm... I know I put Dustin in.

Please remove it also.

Removed.

I need some help with an SQL query I want to run. I have 2 tables one has reviews and one has bathrooms.
I need the average from all rating rows that reviews.bathroom_ID = bathrooms.ID then to update bathrooms.ratings

What I have so far is...

UPDATE bathrooms
   SET bathrooms.Rating = (SELECT AVG(Reviews.Rating)
                   FROM Reviews AS Rating
                  WHERE Reviews.bathroom_ID = bathrooms.id)

But it doesn't work

Error:
#1054 - Unknown column 'Reviews.Rating' in 'field list'

Reviews table EX:

ID___Bathroom_ID_____Review____Rating_____Username
1_____100___________Smells bad____0__________User
2_____100___________Its okay_______1__________User
2_____100___________Its okay_______1__________User

Bathroom table EX:

ID__________Name________________Rating____________
100________Wal-mart______________0___________________

@DustinB3403 said in Potty Plotter:

Also I love being the 3rd person on the Google Play store to have downloaded an app.

What kind of details do you get from your side of things?

I can see all the database details like. Potties, Reviews, Searches that happen on the site. I can also see if a search on the site comes back with no potties. So that way I know what people want.

@scottalanmiller I know you can user AVG like this

SELECT AVG(`Rating`) FROM `Reviews` WHERE `bathroom_ID` = 100

@scottalanmiller

its in there I need to fix the crods but its there.

@scottalanmiller said in Help with SQL query:

UPDATE bathrooms
   SET bathrooms.Rating = (SELECT AVG(Reviews.Rating)
                   FROM Reviews
                  WHERE Reviews.bathroom_ID = bathrooms.id)

@scottalanmiller said in Help with SQL query:

Did that work?

Yes it did work thank you!!!

Hello everyone ! You can now submit reviews on the site!!! Let me know if you have any errors

@scottalanmiller said in Help with SQL query:

Are you going to do a scheduled batch run on this (tee hee, batch run) like at night to update the reviews?

I was going to do that or pass the ID of the bathroom then fire it on a review or bathroom submission.