plexWatch/Web - A web front-end for plexWatch

Dev Community Dev/API Corner
141

Thank you for your FAST response! (you and @ljunkie are amazing)

When i delete config.php and refresh it reprompts me for the settings - see attached. After that I get the same results as before on the various pages.

I don't recall if sqlite3 was part of the install - I was following these steps. I will look into that and install sqlite3 if it wasn't part of that.

Thanks again!

(I am learning! B))

Dan

I don't see any mention of a sqlite3 extension in your PHP details. During the first run of plexWatch/Web you should have seen a welcome modal. What version of SQLite did it say you had? If you don't remember, delete your current config.php file in /config/ and refresh plexWatch/Web.

142

Thank you for your FAST response! (you and ljunkie are amazing)

When i delete config.php and refresh it reprompts me for the settings - see attached. After that I get the same results as before on the various pages.

I don't recall if sqlite3 was part of the install - I was following these steps. I will look into that and install sqlite3 if it wasn't part of that.

Thanks again!

(I am learning! B))

Dan

Before the settings appear there is a modal window that should appear that welcomes you to plexWatch/Web. It also displays your web server info including your php-sqlite version (if available). Anyway you should be able to install the SQLite PHP extension with this command

sudo apt-get install sqlite php5-sqlite

Be sure to restart your webserver after installing this extension.

143

+1 Superb addition. Fills a large gap in the current PMS  and PlexWeb apps. 

As far as I can tell, its working fine for me on OSX 10.8.5, latest PMS and standard MAMP stack. Once again very nice job.

Do you have any instructions on how to get this working on OSX... I am having some troubles and didn't see a step by step but might of missed it. Thank you. 

144

oh WOW!

Boom! Done!

Thank you so very much! This is coooool!

BTW - I did get that modal screen this time. Works great now.

Let me play with it and I will send a donation your way - very much appreciate not only the app, but your "customer service".

Awesome!

Dan

Before the settings appear there is a modal window that should appear that welcomes you to plexWatch/Web. It also displays your web server info including your php-sqlite version (if available). Anyway you should be able to install the SQLite PHP extension with this command

sudo apt-get install sqlite php5-sqlite

Be sure to restart your webserver after installing this extension.

145

oh WOW!

Boom! Done!

Thank you so very much! This is coooool!

BTW - I did get that modal screen this time. Works great now.

Let me play with it and I will send a donation your way - very much appreciate not only the app, but your "customer service".

Awesome!
Dan


Thank you! I'm happy to hear it was a simple fix. Enjoy and let us know if you have any other questions.
146

Do you have any instructions on how to get this working on OSX... I am having some troubles and didn't see a step by step but might of missed it. Thank you. 

Hopefully DrZeuss or some other OSX users can chime in on their experiences. I don't have an OSX VM available ATM to test but I would think it should be relatively straight forward to get up and running. Give XAMPP a try following their installation steps....

http://www.apachefriends.org/en/xampp-macosx.html

Let us know how you make out.

147

Hi eleese, thank you for this great web app.  Is there a way to change the chart to top shows of the week instead of all time?  Thanks.

148

Hi eleese, thank you for this great web app.  Is there a way to change the chart to top shows of the week instead of all time?  Thanks.

Hopefully in a future release the charts page will get re-written to allow you to choose between (today, this week, this month, all time). If you would like, you can use a text editor and change the following lines in charts.php to create the view you're after.

Line 205:  
echo "
Top 10 TV Shows (All Time)
";

Line 211:

$queryTop10Shows = $db->query(“SELECT title,time,user,orig_title,orig_title_ep,episode,season,xml,datetime(time, ‘unixepoch’) AS time, COUNT(orig_title) AS play_count FROM “.$plexWatchDbTable.” GROUP BY orig_title HAVING play_count > 0 ORDER BY play_count DESC,time DESC”);

to

Line 205: 
echo "
Top 10 TV Shows (This Week)
";

Line 211:

$queryTop10Shows = $db->query(“SELECT title,time,user,orig_title,orig_title_ep,episode,season,xml,datetime(time, ‘unixepoch’) AS time, COUNT(orig_title) AS play_count FROM “.$plexWatchDbTable.” WHERE datetime(time, ‘unixepoch’) >= datetime(‘now’, ‘-7 days’, ‘localtime’) GROUP BY orig_title HAVING play_count > 0 ORDER BY play_count DESC,time DESC”);

149

Works great. thank you!

150

Hopefully DrZeuss or some other OSX users can chime in on their experiences. I don't have an OSX VM available ATM to test but I would think it should be relatively straight forward to get up and running. Give XAMPP a try following their installation steps....

http://www.apachefriends.org/en/xampp-macosx.html

Let us know how you make out.


Thanks for the reply... I have is OS X webserver setup... But I'm still not doing something right. I've got Plexwatch up and runnin like a charm. Hope someone with osx server can help. :)
151

Thanks for the reply... I have is OS X webserver setup... But I'm still not doing something right. I've got Plexwatch up and runnin like a charm. Hope someone with osx server can help. :)

Oh I thought you weren't sure how to install a web server. What specific problems are you experiencing?

152

Noticed a strange occurrence on the users page with Firefox.  One of the user accounts has no visible (and thus no clickable) default icon.  If I view it in Chrome, however, I do get a small icon denoting that the image is broken.  When I look at the linked image URL, it goes to a Gravatar link with a 404 at the end. 

pbna2nZ.png

Tried temporarily moving the plexWatch DB (as I assume Gravatar links would be saved within there), but that particular user continues to exhibit this problem.  Any suggestions for how to remedy this?  Thanks!

153

Thanks for the reply... I have is OS X webserver setup... But I'm still not doing something right. I've got Plexwatch up and runnin like a charm. Hope someone with osx server can help. :)

Oh I thought you weren't sure how to install a web server. What specific problems are you experiencing?

And are you talking about OS X Server with apache enabled or did you enable the default apache without the server app installed? Or perhaps no Apache at all even but some other flavour?

154

I should’ve been more descriptive I’m sorry.

Basically I have 10.9 setup with actual server running. I am not 100% sure where to put these files for plexwatchweb. I visit the ip of the server and get a page full of code at http://192.168.1.2 for Plex watch.

I guess I’m just a little confused with the basic first couple of steps.

155

Noticed a strange occurrence on the users page with Firefox.  One of the user accounts has no visible (and thus no clickable) default icon.  If I view it in Chrome, however, I do get a small icon denoting that the image is broken.  When I look at the linked image URL, it goes to a Gravatar link with a 404 at the end. 

pbna2nZ.png

Tried temporarily moving the plexWatch DB (as I assume Gravatar links would be saved within there), but that particular user continues to exhibit this problem.  Any suggestions for how to remedy this?  Thanks!

What is the image URL link for that user's avatar? I committed a possible fix for this issue the other day but am not sure it's working. Check the version of plexWatch/Web you are running by going to settings. If it's not v1.4.0.8 dev, download the newest and try again.

156

I should've been more descriptive I'm sorry.

Basically I have 10.9 setup with actual server running. I am not 100% sure where to put these files for plexwatchweb. I visit the ip of the server and get a page full of code at http://192.168.1.2 for Plex watch.

I guess I'm just a little confused with the basic first couple of steps.

Did you enable PHP Web Applications within the Services -> Websites?

157

Yes I did. But where do I physically put the web files at?

158

What is the image URL link for that user's avatar? I committed a possible fix for this issue the other day but am not sure it's working. Check the version of plexWatch/Web you are running by going to settings. If it's not v1.4.0.8 dev, download the newest and try again.

I am running 1.4.0.8 dev.  The image URL is:

http://www.gravatar.com/avatar/2eba3d16e0cf966be867994e6c0c5d63?d=404
159

I am running 1.4.0.8 dev.  The image URL is:

http://www.gravatar.com/avatar/2eba3d16e0cf966be867994e6c0c5d63?d=404

Thanks. I pushed another possible fix. Would you mind testing it and letting me know your results.

160

Yes I did. But where do I physically put the web files at?

The standard website location for OS X Server is: /Library/Server/Web/Data/Sites/Default

Please be aware that deleting the original site or files from the original site isn't recommended while that could cause some major issues ;)