DVD Collectors Online

General => Invelos Software Related => Topic started by: FredLooks on June 11, 2010, 03:39:18 PM

Title: phpdvdprofiler
Post by: FredLooks on June 11, 2010, 03:39:18 PM
I've dropped a new phpdvdprofiler release (3.6.1.2) here (http://dvdaholic.me.uk/forums/index.php?topic=714.0)
fixes some bugs, updates the statistics, makes the actor popups more like the windows program ...

enjoy.
Title: Re: phpdvdprofiler
Post by: DJ Doena on June 11, 2010, 03:48:24 PM
Thx :)

I still have to upgrade, I'm still running 3.5.1.1.
Title: Re: phpdvdprofiler
Post by: Antares on June 11, 2010, 03:48:50 PM
I have never been able to get properly set up with this.  :weep:

I have no idea why, but I just can't get it to work for me. I should also state, that I'm not very computer speak literate.  :whistle:
Title: Re: phpdvdprofiler
Post by: FredLooks on June 11, 2010, 03:52:50 PM
If you have access to a server with a web-server, PHP and MySQL on which to install it, I'd be happy to help you get it going ...
Title: Re: phpdvdprofiler
Post by: Antares on June 11, 2010, 03:54:47 PM
If you have access to a server with a web-server, PHP and MySQL on which to install it, I'd be happy to help you get it going ...

Thanks, I'll probably take you up on it. I can't right now, but I'll PM you when I can.  :thanks:
Title: Re: phpdvdprofiler
Post by: FredLooks on June 11, 2010, 04:00:08 PM
No problem. I have to travel to Japan next week, but I'll try to be monitoring the boards anyway ...
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 12, 2010, 12:01:14 AM
I'd like to get this to work for me too..but I don't have a server.
Title: Re: phpdvdprofiler
Post by: RossRoy on June 13, 2010, 04:06:06 AM
Just installed the new version! Went without a hitch - as always! Thanks Fred!
Title: Re: phpdvdprofiler
Post by: EdwinK on June 13, 2010, 05:54:34 PM
Will take a look at it later. At the moment I'm using phpmyprofiler

Will your version support Custom collections?
Title: Re: phpdvdprofiler
Post by: FredLooks on June 13, 2010, 06:47:27 PM
Yes, and custom mediatypes as well, although some of the information about both of those cannot be extracted from the XML file and must be manually entered (notably whether the custom collections should show as part of the owned collection). there is support for custom icons for custom mediatypes, but I haven't used it (I'd have to look at the code to remember how it works :hmmmm:)

None of that code is terribly well exercised yet, so if anyone is using it extensively I'd be interested in hearing about it ...
Title: Re: phpdvdprofiler
Post by: EdwinK on June 13, 2010, 07:12:24 PM
I just downloaded and installed your script, and it seems everything is working well. Just not really liking the navigation menu.  Like that it can use custom collections, something that phymyprofiler can't. But overall I like that script better. For now going to work with both to see how it will stand in 6 months. :)
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 20, 2010, 02:57:22 AM
I found a host or server or whatever you call it to try.  I'm currently in the process of trying to get this to work now.  I had a minor set back where I screwed up a line of code in that local file.  But I fixed it.  So it is working so far ..nothing there yet, but I've made progress.
Title: Re: phpdvdprofiler
Post by: Achim on June 20, 2010, 07:01:39 AM
Marie, if you need help, I am sure fred will help you here or you can go the related forum (http://dvdaholic.me.uk/forums/index.php). Fred is very helpful and always responds very quickly :thumbsup:
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 20, 2010, 07:06:47 AM
I'm slowing getting it.

I was having an issue with the file size being too big for the host I'm using..but I found a way around that.  I have a list of movies. :)  
I'm uploading images now.

Then I have to figure out how to do the banner thingy for a sig.  Are there directions for that on that forum somewhere?

Will I just be able to add the new titles and images or will I have to reupload everything every time?

Title: Re: phpdvdprofiler
Post by: Jimmy on June 20, 2010, 07:08:24 AM
I was very lucky to have Eric to assist me when I set mine.
Title: Re: phpdvdprofiler
Post by: Jimmy on June 20, 2010, 07:11:28 AM
Then I have to figure out how to do the banner thingy for a sig.  Are there directions for that on that forum somewhere?
We talk about this here (http://www.dvdcollectorsonline.com/index.php/topic,776.msg71523.html#msg71523)
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 20, 2010, 07:18:52 AM
Thanks.  I'm looking to see if I can find that in the local file thing.
Title: Re: phpdvdprofiler
Post by: Achim on June 20, 2010, 07:26:06 AM
Thanks.  I'm looking to see if I can find that in the local file thing.
Actually, IIRC it's not in there.

You need to add a section like this:
Code: [Select]
$profiles = array(
"Achim" => array(
"nick" => "ya_shin",
"first" => "Achim",
"last" => "",
"type" => "watched",
"filter" => "",
"width" => 65,
"height" => 90,
"num" => 10,
"rows" => 2,
"bgcol" => "F8CC75",
"font" => "comic.ttf",
"fontcol" => "000000",
"fontsize" => 10,
"hborder" => 3,
"wborder" => 5,
"padding" => 4,
"topmsg" => "What #NAME# has watched recently:",
// "botmsg" => "#MOTD_RAND# as of #DATE#",
"botmsg" => "as of #DATE#",
"topalign" => "l",
"botalign" => "r",
"quality" => 80)
,
"Achim_new" => array(
"nick" => "ya_shin",
"first" => "Achim",
"last" => "",
"type" => "new",
"filter" => "AND boxparent = ''",
"width" => 65,
"height" => 90,
"num" => 10,
"rows" => 2,
"bgcol" => "F8CC75",
"font" => "arial.ttf",
"fontcol" => "000000",
"fontsize" => 10,
"hborder" => 3,
"wborder" => 5,
"padding" => 4,
"topmsg" => "What #NAME# has purchased recently:",
// "botmsg" => "#MOTD_RAND# as of #DATE#",
"botmsg" => "as of #DATE#",
"topalign" => "l",
"botalign" => "r",
"quality" => 80)
);
Each segment creates a separate signature, so you can have different ones for different forums/sites. The above are just two of mine (I think I have totally six). Just copy that and play around with the settings, most of it should be self explanatory. The nick is just that, I believe, the name should match the name used in DVD Profiler. I forgot how #MOTD_RAND# works, but I think Fred or Karsten can help with that.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 20, 2010, 07:27:56 AM
Ahh...ok.

Can I just add it at the end of local file or is there a specific place to put it?
Title: Re: phpdvdprofiler
Post by: Achim on June 20, 2010, 07:34:10 AM

Adding it at the end will work fine. Just above the last "?>".
Title: Re: phpdvdprofiler
Post by: Jimmy on June 20, 2010, 07:34:56 AM
BTW don't forget to back-up and don't use Word or Open office writer to do this. You must use notepad to work with this file.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 20, 2010, 08:57:08 AM
I've backed up more than once while trying to get this to work.
Title: Re: phpdvdprofiler
Post by: FredLooks on June 20, 2010, 09:36:25 PM
Sorry, I just got back from Japan, where the internet in my room didn't work.

If you need any help, just let me know ...
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 20, 2010, 09:43:34 PM
I got the images uploaded and the webpage is working.

I'll try to figure out the signature thing later.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 12:45:11 AM
I tried and did something wrong...when I tried to go back to the site for my collection after I added stuff for the signature, all I got was a blank page.  So I screwed up somewhere.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 05:06:39 AM
Ok...how do I get the banner to show up?
Title: Re: phpdvdprofiler
Post by: Jimmy on June 21, 2010, 06:01:43 AM
If your info are set on your website, you do something like this

http://aesppres.com/phpdvdprofiler/
http://aesppres.com/phpdvdprofiler/ws.php?me=jimmy

The first part is the adress of where is your collection
The second part is where you place the name you have choose (me=yourname)

to have the image just do it the same way it is below (just do reply to see the html format)
(http://aesppres.com/phpdvdprofiler/ws.php?me=jimmy) (http://aesppres.com/phpdvdprofiler/)
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 06:12:11 AM
Is that something I need to put in the local config file thing?

I've just gotten myself really confused trying to figure this out.
Title: Re: phpdvdprofiler
Post by: Jimmy on June 21, 2010, 06:16:22 AM
No you just had to place it here as your sig. Just try to post it here to see if it works, we will try to find the reason if it doesn't
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 06:19:40 AM
Oh.  Ok.  

As you can probably see..I know nothing about this stuff.  It is a miracle I've figured out as much as I have.

(http://dragonfire88.byethost2.com/phpdvdprofiler/ws.php?me=tiger_lil6) (http://dragonfire88.byethost2.com/phpdvdprofiler/)

OMG.  It worked. 

Woooohoooo.   :yahoo:

Thank you so much for the help.
Title: Re: phpdvdprofiler
Post by: Jimmy on June 21, 2010, 06:24:22 AM
(http://dragonfire88.byethost2.com/phpdvdprofiler/ws.php?me=marie)[url]
 (http://dragonfire88.byethost2.com/phpdvdprofiler/)
Change the me=marie for me=tiger_lil6 and it will work perfectly ;D

(http://dragonfire88.byethost2.com/phpdvdprofiler/ws.php?me=tiger_lil6)[url] (http://dragonfire88.byethost2.com/phpdvdprofiler/)
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 06:29:29 AM
I found it...after I was thinking for a minute I tried changing that. :)

Again..thanks so much for the help. :)
Title: Re: phpdvdprofiler
Post by: Jimmy on June 21, 2010, 06:30:37 AM
No problem, that's why we are here ;D
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 06:38:34 AM
I might later try to change how it looks.  I thought it had it so the date thing would show up.

I'll deal with that later.  I'm just happy it is showing up. :)
Title: Re: phpdvdprofiler
Post by: Achim on June 21, 2010, 07:02:15 AM
If you mean the text at the top and bottom, that's what these are for:

Code: [Select]
"topmsg" => "What #NAME# has watched recently:",
"botmsg" => "as of #DATE#",
The former is for the top row, obviously, the latter is for the one at the bottom. the above example should create what you see in my signature. Did you delete those lines...? It should show up if they are still there... :headscratch:
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 07:04:32 AM
I thought they were still there.  I'll have to look again.
Title: Re: phpdvdprofiler
Post by: DJ Doena on June 21, 2010, 07:09:17 AM
Make sure that

Code: [Select]
"bgcol" => "F8CC75",
"fontcol" => "000000"

are not the same. Black on black is hard to read. ;)
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 07:16:30 AM
Hmm...not sure what is wrong. 

The code is a little different there - when I was trying again earlier, I found another example I tried..I couldn't get the other to work last night.
When I adjusted those lines, something got all messed up.  The page for my collection was just blank, like it was last night.

So I've put the code back to what was working before.

//Profile
$profiles = array(
"tiger_lil6" => array(
"nick" => "tiger_lil6",
"first" => "Marie",
"last" => "",
"width" => 71,
"height" => 95,
"num" => 10,
"bgcol" => "d3d3d3",
"font" => "arial.ttf",
"fontcol" => "000000",
"fontsize" => 10,
"hborder" => 2,
"wborder" => 3,
"padding" => 3,
"topmsg" => "What #NAME#'s watched recently as of #DATE#...",
"botmsg" => "",
"botalign" => "c",
"topalign" => "c",
"quality" => 100
)
);
Title: Re: phpdvdprofiler
Post by: Jimmy on June 21, 2010, 07:36:24 AM
//Profile
$profiles = array(
"tiger_lil6" => array(
"nick" => "tiger_lil6",
"first" => "Marie",
"last" => "",
"width" => 71,
"height" => 95,
"num" => 10,
"bgcol" => "d3d3d3",
"font" => "arial.ttf",
"fontcol" => "000000",
"fontsize" => 10,
"hborder" => 2,
"wborder" => 3,
"padding" => 3,
"topmsg" => "What #NAME#'s watched recently as of #DATE#...",
"botmsg" => "",
"botalign" => "c",
"topalign" => "c",
"quality" => 100
)
);

Mine is like that
$profiles = array(
   "jimmy" => array(
      "nick" => "Jimmy",
      "first" => "Jimmy",
      "last" => "Simard",
      "width" => 61,
      "height" => 85,
      "num" => 10,
      "bgcol" => "deb887",
      "font" => "arial.ttf",
      "fontcol" => "FFFFFF",
      "fontsize" => 10,
      "hborder" => 3,
      "wborder" => 5,
      "padding" => 5,
      "topmsg" => "What #NAME#'s watched recently.",
      "botmsg" => "As of #DATE#",
      "topalign" => "l",
      "botalign" => "l",
      "quality" => 80
   ),

Tried to replace the part in bold, since they are the only difference between you and me,
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 07:55:26 AM
Ok...just tried that.  So far, so good.  The page isn't blank anyway..
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 08:12:51 AM
Well I managed to get the background color changed.  That's something.   :laugh:

I'm still trying changes to see if I can get the name and date stuff to show. 
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 08:17:42 AM
Well I've changed all I can think of and it still isn't showing up.

Here's what I've got now.

//Profile
$profiles = array(
"tiger_lil6" => array(
"nick" => "tiger_lil6",
"first" => "Marie",
"last" => "",
"width" => 61,
"height" => 85,
"num" => 10,
"bgcol" => "7F38EC",
"font" => "arial.ttf",
"fontcol" => "000000",
"fontsize" => 10,
"hborder" => 3,
"wborder" => 5,
"padding" => 5,
"topmsg" => "What #NAME#'s watched recently",
"botmsg" => "As of #DATE#",
"botalign" => "l",
"topalign" => "l",
"quality" => 80
)
);
Title: Re: phpdvdprofiler
Post by: Achim on June 21, 2010, 08:18:49 AM
Actually, there sholdn't be a reason why you can not have a topmsg only. I think the problem is simply the dimensions...? The text is technically there, it's just outside the image, if that makes sense.

I am no expert in this, but height and width are the image dimensions. So play around with hborder, wborder and padding to see what they do.

Also, you might want to change quality. It's JPG images and 100% really isn't needed. 90 or 85 should work fine. Jimmy has 80 and you can still read most of the text. EDIT: I see you did that while I was typing.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 08:26:33 AM
Yup..I figured I might as well try changing those too.  Still no luck.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 08:42:21 AM
Well I've tried changing a few more things.  I'm out of ideas for now. 

Is there something else in the localconfig file that should have been changed?

Here's what I have after the last change.

//Profile
$profiles = array(
"tiger_lil6" => array(
"nick" => "tiger_lil6",
"first" => "Marie",
"last" => "",
"width" => 71,
"height" => 95,
"num" => 10,
"bgcol" => "7F38EC",
"font" => "arial.ttf",
"fontcol" => "000000",
"fontsize" => 10,
"hborder" => 6,
"wborder" => 3,
"padding" => 6,
"topmsg" => "What #NAME#'s watched recently",
"botmsg" => "As of #DATE#",
"botalign" => "l",
"topalign" => "l",
"quality" => 80
)
);
Title: Re: phpdvdprofiler
Post by: DJ Doena on June 21, 2010, 08:48:14 AM
Just for testing purposes: Could you change width and height to 61 / 85?
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 08:51:32 AM
Ok..done.

//Profile
$profiles = array(
"tiger_lil6" => array(
"nick" => "tiger_lil6",
"first" => "Marie",
"last" => "",
"width" => 61,
"height" => 85,
"num" => 10,
"bgcol" => "7F38EC",
"font" => "arial.ttf",
"fontcol" => "000000",
"fontsize" => 10,
"hborder" => 6,
"wborder" => 3,
"padding" => 6,
"topmsg" => "What #NAME#'s watched recently",
"botmsg" => "As of #DATE#",
"botalign" => "l",
"topalign" => "l",
"quality" => 80
)
);
Title: Re: phpdvdprofiler
Post by: DJ Doena on June 21, 2010, 09:13:51 AM
OK, last idea: have you checked that in the directory

phpdvdprofiler/jpgraph/fonts/truetype/

the file arial.ttf exists?

And what's the value of your jpgraph variables in localsiteconfig.php?

$usejpgraph = true;
$jpgraphlocation = 'jpgraph/';
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 09:23:46 AM
OK, last idea: have you checked that in the directory

phpdvdprofiler/jpgraph/fonts/truetype/

the file arial.ttf exists?

And what's the value of your jpgraph variables in localsiteconfig.php?

$usejpgraph = true;
$jpgraphlocation = 'jpgraph/';

I can't find the phpdvdprofiler/jpgraph/fonts/truetype/ directory at all.

I have XLM, gfx, headshots, imagecache, images, lb, and skins as directories in phpdvdprofiler.

The jpgraph was set to false, so I fixed that.
Title: Re: phpdvdprofiler
Post by: DJ Doena on June 21, 2010, 09:38:31 AM
OK,

then you need to download jpgraph and upload it.

You can find it here: http://jpgraph.net/download/
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 09:40:21 AM
OK..just put it in the phpdvdprofiler directory on my server?
Title: Re: phpdvdprofiler
Post by: Achim on June 21, 2010, 09:42:45 AM
Great find Karsten!

Could have sen it myself, since the graphs on the Site Statistics page are not there either. :bag: I had assumed, however, that jpgraph is needed for the signature image to begin with, which is what threw me off.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 09:46:47 AM
Now I have a new problem...the file is too big.  I can't upload. :(
Title: Re: phpdvdprofiler
Post by: DJ Doena on June 21, 2010, 09:49:53 AM
Now I have a new problem...the file is too big.  I can't upload. :(

You have to unpack it before you upload it. It contains a directory called jpgraph which you upload into your phpdvdprofiler directory.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 09:57:55 AM
Well I feel like an idiot now.  oops.

Trying to get it unpacked...I don't have a program that will do that type of file..though trying a trail version of something.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 10:32:48 AM
Well I have screwed something up again.  Banner and page are gone.

Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 10:47:05 AM
I'm thoroughly frustrated now.  I should have left well enough alone since I have no freaking clue what I'm doing.

I don't know what else to change in the localconfig to get the page to load again.  all I have is a blank page.  I removed the jpgrah stuff I uploaded..it was working before I did that..not nothing.

Title: Re: phpdvdprofiler
Post by: DJ Doena on June 21, 2010, 10:54:26 AM
try to set the usejpgraph variable back to false.
Title: Re: phpdvdprofiler
Post by: DJ Doena on June 21, 2010, 10:55:11 AM
Well I feel like an idiot now.  oops.

Trying to get it unpacked...I don't have a program that will do that type of file..though trying a trail version of something.

You can use WinZIP or WinRAR if you have it. Or try to rename it to .zip then Windows should be able to open it.

PS: You can send me your localsiteconfig.php to karsten @ yajirobi.de. Simply remove your database login at the top of the file before you do it.
Title: Re: phpdvdprofiler
Post by: Achim on June 21, 2010, 10:58:24 AM
Well I feel like an idiot now.  oops.

Trying to get it unpacked...I don't have a program that will do that type of file..though trying a trail version of something.

You can use WinZIP or WinRAR if you have it. Or try to rename it to .zip then Windows should be able to open it.
If they don't have trial versions, 7-zip (http://www.7-zip.org/) is free.
Title: Re: phpdvdprofiler
Post by: DJ Doena on June 21, 2010, 11:17:50 AM
I see your website and banner again.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 11:18:06 AM
I got it back.  I had a bad copy of my localconfig file - I don't know why I still had it.  Anyway, I uploaded the wrong one.  
I still had a good copy that worked..but it took me a little while to find it.  And to realize what I'd done.

I unpacked that jgraph thing, but I didn't see anything that looked like a directory called jgraph in it.

Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 11:23:34 AM
I wanted to say that I do appreciate you both trying to help me with this.

When it comes to computer programing and code and all that, I have no idea what I'm doing.  It took me ages to figure out how to put links in my reviews at Epinions...and when the way we post reviews changed a bit and that changed..it took me days to get it straight again.

I hope you didn't think my frustration was with you.  It wasn't.  It was just with me screwing something up again after it had taken me so long to get the banner to show in the first place.
Title: Re: phpdvdprofiler
Post by: DJ Doena on June 21, 2010, 11:24:40 AM
OK, another question: Do you know what PHP version your provider has? PHP 4 or PHP 5?

if not, you can find it out this way. Create a new file with notepad that contains:

Code: [Select]
<?php phpinfo(); ?>
Save it as phpinfo.php and upload it.

When you call it, it'll show your setting.

Then you need to download the correct version of JPGraph from here: http://jpgraph.net/download/

When you have unzipped it, you need to upload the content of the "src" directory into your online "jpgraph" directory.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 11:27:21 AM
The php is 5.2.13

I saw the src directory in there.

I just don't have an online jpgraph directory.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 11:54:12 AM
I made a jgraph folder or directory or whatever and uploaded the contents of the src file into that.

$usejpgraph      = true;
$jpgraphlocation   = '/jpgraph';

I have that in the localconfig file.


I think I'm done trying to figure this out now.  I'll probably screw something up again if I keep trying.

I do really appreciate the help from everyone who has tried to help me with this.

Title: Re: phpdvdprofiler
Post by: DJ Doena on June 21, 2010, 12:24:52 PM
I see your config says now COMIC.ttf.

Did you want to take Comic Sans MS?

Please try the following

Online: Open the jpgraph directory. Create one called "fonts". Open it. Create one called "truetype".

Then download this file, unzip it and upload its content in the truetype directory: http://home.arcor.de/djdoena/upload/fonts.zip

Then modify your localsiteconfig.php to the exact spelling of the file (lower/upper case), in this case comic.ttf
Title: Re: phpdvdprofiler
Post by: Kathy on June 21, 2010, 01:36:03 PM
Well I feel like an idiot now. 


 :hysterical:

This entire thread, and ones like it, always make me feel like an idiot. I have no idea what any of you are talking about. It's exactly like reading a foreign language to me. I don't understand what all that data you are flinging about means or where it goes! :stars:

And for those of you who would try and help me, you would have to come to Buffalo and show me. I learn by doing, not reading.
Title: Re: phpdvdprofiler
Post by: FredLooks on June 21, 2010, 05:15:56 PM
OK, a few comments.

The problem that you are having is that the php system on your host does not know where to find the fonts. You have installed jpgraph, but the installation package does not appear to have the fonts directory either.

You will need to find the font that you wish to use (the default is arial.ttf and I think that you had wanted to use comic.ttf) on your windows machine -- it should be in the windows\fonts directory.
You need to put it onto your webserver into a directory named fonts/truetype under your jpgraph directory. You will have to create these directories on the webserver.

So you would have phpdvdprofiler/jpgraph/fonts/truetype/arial.ttf

Note that your provider is a Unix machine, and that filenames are case-sensitive (so COMIC.ttf would be a different file than comic.ttf)

In your localsiteconfig.php file you would need to set $jpgraphlocation = "jpgraph/"; which specifies a path relative to your phpdvdprofiler directory. A leading "/" in that variable would turn it into an absolute path and you don't know what the absolute path should be, although certainly not "/jpgraph". This variable needs to end with a trailing slash as a separator indicated.

This should allow the text to be shown on your image, although jpgraph will still not work, as it needs to be configured on your machine (I think, anyway).

Sorry you're having trouble with this - the fonts bit is definitely one of the things that is hard to get just right ...
Title: Re: phpdvdprofiler
Post by: Jimmy on June 21, 2010, 05:21:06 PM
I can understand you Kathy, Eric did most of the works with me when I set mine and I was lucky since we speak the same language (technical terms aren't always easy to translate). Setting phpdvdprofiler on a server isn't the hardest part, setting rsync for the update is...

Karsten maybe I'm wrong but I think that sometimes jpgraph doesn't work and a special thing had to be done to made it work. I know that Eric did something with mine because the graphic wasn't showing also in my stats (sorry if it's really vague, but I've no clue about what he did) :shrug:
Title: Re: phpdvdprofiler
Post by: Kathy on June 21, 2010, 05:37:12 PM
"rsync" - is that a new boy band? :laugh:
Title: Re: phpdvdprofiler
Post by: DJ Doena on June 21, 2010, 09:02:19 PM
Karsten maybe I'm wrong but I think that sometimes jpgraph doesn't work and a special thing had to be done to made it work. I know that Eric did something with mine because the graphic wasn't showing also in my stats (sorry if it's really vague, but I've no clue about what he did) :shrug:

I only installed it once until it worked. I don't have much experience with jpgraph either, sorry.
Title: Re: phpdvdprofiler
Post by: kahless on June 21, 2010, 09:25:24 PM
"rsync" - is that a new boy band? :laugh:

Maybe the successors of nsync!  :hysterical:
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 09:29:56 PM
I just thought I would try changing the font just to see to see if that would work.

I'll try that with the adding the font directory.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 09:58:15 PM
It works it works it works!!!!   :yahoo: :yahoo: :yahoo: :yahoo: :yahoo: :yahoo:  :dance: :dance: :dance: :dance: :dance: :dance:

Thank you so much. 

Woohooo

 :yahoo: :dance: :yahoo: :dance: :yahoo: :dance:  :yahoo: :dance: :yahoo: :dance:
Title: Re: phpdvdprofiler
Post by: Antares on June 21, 2010, 10:08:12 PM
What are you using for a webhost, if I may ask?
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 10:13:02 PM
It is a free one.  Though they do offer paid for hosting too.

Since I just wanted the banner thingy and the page for my collection, I figured I would try the free one since I had no clue if I could get it to work.

www.bytehost.com
Title: Re: phpdvdprofiler
Post by: Jimmy on June 21, 2010, 11:19:03 PM
Marie the purple color is sure ugly, not that it is any of my bussiness anyway :yucky:
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 11:33:22 PM
Purple is my favorite color.
Title: Re: phpdvdprofiler
Post by: Antares on June 21, 2010, 11:43:27 PM
Purple is my favorite color.

You'd like my setup for Profiler. I use a soft lavender for the background with lilac lettering, on the Obsidian theme. Looks really nice.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2010, 11:52:17 PM
That does sound nice.
Title: Re: phpdvdprofiler
Post by: Jimmy on June 21, 2010, 11:55:28 PM
Purple is my favorite color.
No problemo:thumbup:
Title: Re: phpdvdprofiler
Post by: Antares on June 22, 2010, 12:07:18 AM
That does sound nice.

Here's what it looks like...


(click to show/hide)


The reason the Overview looks out of place is because it scrolls from the bottom to the top.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 22, 2010, 12:16:01 AM
Ooo..Nice.
Title: Re: phpdvdprofiler
Post by: Antares on June 22, 2010, 12:21:43 AM
I just swapped out the image with a new one that also shows the tagline. Now look at it.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 22, 2010, 12:24:22 AM
Oooo...I really like that.

I haven't done much with the colors in mine.  I'll probably mess around with that sometime.
Title: Re: phpdvdprofiler
Post by: Antares on June 22, 2010, 12:26:45 AM
Do you have the Tagline code?
Title: Re: phpdvdprofiler
Post by: FredLooks on June 22, 2010, 12:32:23 AM
If you look at your statistics page, you are still missing some fonts; specifically the Courier font and the Ariel font (now that you have jpgraph configured it can whine more clearly :))

IO'm also a little confused about your audio formats ... there may be a bug in my statistics code ...

Glad it's working for you now  :thumbup:
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 22, 2010, 12:33:53 AM
Do you have the Tagline code?

I don't think I do.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 22, 2010, 12:40:17 AM
If you look at your statistics page, you are still missing some fonts; specifically the Courier font and the Ariel font (now that you have jpgraph configured it can whine more clearly :))

IO'm also a little confused about your audio formats ... there may be a bug in my statistics code ...

Glad it's working for you now  :thumbup:

Ahh..ok.  I'll try to find them and add them later.

I didn't do anything with the audio formats.
Title: Re: phpdvdprofiler
Post by: FredLooks on June 22, 2010, 02:31:26 PM
OK, I figured it out ...

You have installed a really old version of the software ... from March of 2008, actually. I'm actually pleased to see it working as well as it is :)

You might want to install the latest version (it has had quite a number of changes since then). You can find the current version here (http://www.bws.com/phpdvdprofiler.zip). You should be able to simply drop the files from the zip over top of the files you have and run an update. It will remember all of your settings ....
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 22, 2010, 09:26:58 PM
Ahh. Ok.

I had tried to get it working before and couldn't...couldn't get the host stuff figured out at that point. 
When I decided to try again I just use the file I still had somewhere.

I'll try to get the update installed.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 23, 2010, 04:10:48 AM
I got the files uploaded and stuff updated...it was taking several tries to get the collection stuff updated - it did that to me before too..and I read that others had that problem.  So I just kept restarting it.  But I wasn't expecting to have to do it several times and I had to leave with it only partly done.
Anyway, I got that finished after I got home.  

It is working good from my end..though I don't know what audio stuff you said didn't look right before.

I just looked at the statistics stuff...I have graphs now.  There is an error about a few fonts - I'll try to get those uploaded later - but there are graphs now.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 23, 2010, 05:59:00 AM
I uploaded those fonts and I still have the errors for them.
Title: Re: phpdvdprofiler
Post by: DJ Doena on June 23, 2010, 06:17:26 AM
I uploaded those fonts and I still have the errors for them.

The error message says "cannot find /usr/share/fonts/truetype/arial.ttf". There's definitively a "jpgraph" missing in that path, since the file is to be found under http://dragonfire88.byethost2.com/phpdvdprofiler/jpgraph/fonts/truetype/arial.ttf

Check the file jpg-config.inc in the jpgraph directory (simply open it with a text editor like Notepad) and look for an entry like this:

Code: [Select]
DEFINE("TTF_DIR","./jpgraph/fonts/truetype/");
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 23, 2010, 06:21:35 AM
I found this....

#
//------------------------------------------------------------------------
#
// define('CACHE_DIR','/tmp/jpgraph_cache/');
#
// define('TTF_DIR','/usr/share/fonts/truetype/');
#
// define('MBTTF_DIR','/usr/share/fonts/truetype/');
#
 
#
//---------------------------------------------------------------------
Title: Re: phpdvdprofiler
Post by: DJ Doena on June 23, 2010, 06:22:51 AM
OK, then take my code snippet and add it just under these lines and try it again.
Title: Re: phpdvdprofiler
Post by: KinkyCyborg on June 23, 2010, 06:23:51 AM
OK, I figured it out ...

You have installed a really old version of the software ... from March of 2008, actually. I'm actually pleased to see it working as well as it is :)

You might want to install the latest version (it has had quite a number of changes since then). You can find the current version here (http://www.bws.com/phpdvdprofiler.zip). You should be able to simply drop the files from the zip over top of the files you have and run an update. It will remember all of your settings ....

Is it really that easy to upgrade from an older version? To just overwrite all the files from the zip folder into my install folder on the host? I have been reluctant to try and upgrade as I remember so little from my initial installation a few years ago that I was afraid of buggering up my existing version which still works fine for me.   :fingerchew:
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 23, 2010, 06:26:05 AM
OK, then take my code snippet and add it just under these lines and try it again.

Ok...trying that now.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 23, 2010, 06:29:01 AM
Same error.

Here's what is in the file now.

// define('CACHE_DIR','/tmp/jpgraph_cache/');
// define('TTF_DIR','/usr/share/fonts/truetype/');
// define('MBTTF_DIR','/usr/share/fonts/truetype/');
// define("TTF_DIR","./jpgraph/fonts/truetype/");
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 23, 2010, 06:30:23 AM
OK, I figured it out ...

You have installed a really old version of the software ... from March of 2008, actually. I'm actually pleased to see it working as well as it is :)

You might want to install the latest version (it has had quite a number of changes since then). You can find the current version here (http://www.bws.com/phpdvdprofiler.zip). You should be able to simply drop the files from the zip over top of the files you have and run an update. It will remember all of your settings ....

Is it really that easy to upgrade from an older version? To just overwrite all the files from the zip folder into my install folder on the host? I have been reluctant to try and upgrade as I remember so little from my initial installation a few years ago that I was afraid of buggering up my existing version which still works fine for me.   :fingerchew:

I copied over the files into the different directories on my server and it worked for me.
Title: Re: phpdvdprofiler
Post by: DJ Doena on June 23, 2010, 06:36:08 AM
Same error.

Here's what is in the file now.

// define('CACHE_DIR','/tmp/jpgraph_cache/');
// define('TTF_DIR','/usr/share/fonts/truetype/');
// define('MBTTF_DIR','/usr/share/fonts/truetype/');
// define("TTF_DIR","./jpgraph/fonts/truetype/");

My line without the // please, otherwise it won't work. ;)
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 23, 2010, 06:47:04 AM
ok..thought since the others had that, it needed it too.

Title: Re: phpdvdprofiler
Post by: Dragonfire on June 23, 2010, 06:49:32 AM
 :dance: :dance:

It works. :)

Thank you so much again.

Hopefully I can stop bugging you all about this stuff now.
Title: Re: phpdvdprofiler
Post by: Achim on June 23, 2010, 06:59:40 AM
So you watched one disc around the time jesus was born (can't see what it was though) and then some at the end of 1899 :hmmmm: Then you started regualr watching in 2001. Does that sound about right? :devil:

In short, unless clearly done on purpose (actual watch date unknown) you might want to check out and correct those.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 23, 2010, 07:02:31 AM
I didn't know I could correct them...I've never seen a way to take out a messed up watch date.  I thought once they were put in, they stuck there.
Title: Re: phpdvdprofiler
Post by: Jimmy on June 23, 2010, 07:22:41 AM
You just had to correct the dvd history by left clicking on it in DVDP.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 23, 2010, 07:34:26 AM
I never knew that was there.  Cool.  I'll try to fix the others that are screwed up...probably have to go with a best guess on some of them, but it has to be closer than 1899   :laugh:

It could be fun to find the 0000 one though...can't see that title.
Title: Re: phpdvdprofiler
Post by: Jimmy on June 23, 2010, 08:23:17 AM
Check in Tools / Edit users / History, since all your watching history is there you will find what is the movie you watched with Jesus.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 23, 2010, 08:38:46 AM
Thank you.   :D

I'm learning all sorts of stuff here lately.
 
I found it...Night Court: The Complete First Season...wonder how that happened when it wasn't made till 1984.   :hysterical:   :headscratch:

Fixing it now.  Would have had the others fixed, but I had to do a database repair...couldn't get the info up for the Hellboy animated titles.
Title: Re: phpdvdprofiler
Post by: Jimmy on June 23, 2010, 08:51:51 AM
I found it...Night Court: The Complete First Season...wonder how that happened when it wasn't made till 1984.  
Jesus did miracle and it was probably easier for him to watch a TV show that will be made 1984 years later than metamorphosed water in wine :whistle:

I'm learning all sorts of stuff here lately.
DVDP don't came with a manual so we always find something we have no idea was possible ;D

OK Jimmy time to go to sleep... it's almost 3 o'clock in the morning and it's tuesday night not friday night :yawn:
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 23, 2010, 09:04:46 AM
Thanks again.  :)

Night
Title: Re: phpdvdprofiler
Post by: FredLooks on June 23, 2010, 02:07:42 PM
Is it really that easy to upgrade from an older version? To just overwrite all the files from the zip folder into my install folder on the host? I have been reluctant to try and upgrade as I remember so little from my initial installation a few years ago that I was afraid of buggering up my existing version which still works fine for me.   :fingerchew:
Yup, it's that simple. Take a tilt at it and don't forget that there are trained professionals here to make fun of you back you up  ;)

no, it should be really simple.
Title: Re: phpdvdprofiler
Post by: Kathy on June 23, 2010, 02:19:13 PM
Just for the heck of it I downloaded this. Me try and figure this out?  :hysterical: I can barely cut and paste!
Title: Re: phpdvdprofiler
Post by: FredLooks on June 23, 2010, 03:38:56 PM
It's looking good, Marie.

I use the statistics page to help locate profiles with "problems". For example, I see that you have 1 title with an aspect ration of 2.4:1 and 72 with an aspect ratio of 2.40:1. My OCD would make me change that lone title :hysterical:

-fred
Title: Re: phpdvdprofiler
Post by: Achim on June 23, 2010, 04:19:03 PM
DVDP don't came with a manual so we always find something we have no idea was possible ;D
Actually, it does. It's called "Help" :P

(click to show/hide)


Manuals are one of the least read form of written documents out there.They wouldn't say RTFM if people would read them first, would they.
Title: Re: phpdvdprofiler
Post by: Jimmy on June 23, 2010, 05:49:57 PM
But help files aren't fun or easy to read :whistle:
I prefer to have them in a pdf file or a good old txt file ;D
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 23, 2010, 09:48:01 PM
Just for the heck of it I downloaded this. Me try and figure this out?  :hysterical: I can barely cut and paste!

Honestly Kathy, if I could figure this out, you could too.  It did take me a little while, but I got it.  And I have no clue about coding or anything....as it probably very clear from all my posts trying to get it all working.   :laugh:
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 23, 2010, 09:49:31 PM
It's looking good, Marie.

I use the statistics page to help locate profiles with "problems". For example, I see that you have 1 title with an aspect ration of 2.4:1 and 72 with an aspect ratio of 2.40:1. My OCD would make me change that lone title :hysterical:

-fred

I do? 

I really don't know much about aspect ratios.  Are those legitimate ratios, or is something really messed up in some profiles?
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 23, 2010, 09:50:51 PM
But help files aren't fun or easy to read :whistle:
I prefer to have them in a pdf file or a good old txt file ;D

Half the time, help ends up getting me more confused.  I tried to look up something in help for Paint Shop Pro like a week ago.  I sort of found what I wanted...only not directions on how to do it.  Frustrating.
Title: Re: phpdvdprofiler
Post by: FredLooks on June 23, 2010, 10:27:24 PM
It's looking good, Marie.

I use the statistics page to help locate profiles with "problems". For example, I see that you have 1 title with an aspect ration of 2.4:1 and 72 with an aspect ratio of 2.40:1. My OCD would make me change that lone title :hysterical:

-fred

I do? 

I really don't know much about aspect ratios.  Are those legitimate ratios, or is something really messed up in some profiles?

Those are identical aspect ratios. They're just being written differently, which is what makes my OCD twitch :)
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 23, 2010, 10:57:00 PM
Ahh. Ok.  I've learned something else.

I'll try to fix that...if I can find the one in question.
Title: Re: phpdvdprofiler
Post by: Achim on June 24, 2010, 08:09:36 AM
Honestly Kathy, if I could figure this out, you could too.  It did take me a little while, but I got it.  And I have no clue about coding or anything....as it probably very clear from all my posts trying to get it all working.   :laugh:
I never would have guessed. I thought you handled it impressively well (unless there was communication going on beyond this thread).

Well, some people just have bad luck sometimes and then sometimes (like for you here) things just fall into place.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 24, 2010, 08:42:35 AM
Really?  I sort of thought I was looking like an idiot about some of that.

I do feel a bit more comfortable with it now.  But if I hadn't found step by step directions for setting stuff up to begin with, I would still be trying to get it to work..or I would have just given up in frustration.

It took me..hmm..well not sure how long now, but hours to get the page working..then I got all confused with the banner for a while....even before the font goof up.  

I'm glad I got it working though.  I like how the DVDs are listed there better..like the box set stuff shows like a box set.  And I like my banner...even if Jimmy doesn't like the purple. ;)
Title: Re: phpdvdprofiler
Post by: KinkyCyborg on June 28, 2010, 05:14:03 AM
Ok so I decided to take the plunge and install the update as was suggested by just copying over the contents from the two install folders to my existing phpdvdprofiler folder on my host. After I was done and attempted to connect to my list I get this message...

The database schema is out-of-date and is incompatible with this code.
The database needs to be updated using the schema that came with this code.

The database schema will be automatically updated the next time an update is performed.

Database schema version = 2.4
Code schema version = 2.5


I expected something like that so I enter my login/password info and click the Complete Update will be performed box, click the Login button and... nothing. The screen goes blank white and firefox says the page is done... HELP!   :help: My list is gone!

KC
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 28, 2010, 05:17:58 AM
Oh no...:(

I got the message about the schemia being out of date...but it did the updating and list was back.  I had to run the update several times to get the whole list.

is your xml file still there?
Title: Re: phpdvdprofiler
Post by: KinkyCyborg on June 28, 2010, 05:21:14 AM
Yep, all files that were there in my original folder but not in the new install folders are still there like collection.xml, localsiteconfig.php, all my images. Panicking here!  :fingerchew:
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 28, 2010, 05:27:37 AM
Eek.  I would panic too.  :(

I'm sorry this happened...I don't know what else to suggest...  I wish I had another idea..
I clicked on your link and it loads up the page asking for you to log in.  Did you try doing that again?  Maybe see if the updating starts then?
Title: Re: phpdvdprofiler
Post by: KinkyCyborg on June 28, 2010, 05:31:22 AM
I've tried to login in repeatedly and I get nothing. If it told me my login info was incorrect or something I wouldn't be so concerned but just a plain white blank screen....  ?  gulp!
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 28, 2010, 05:34:15 AM
Just had another thought.

Maybe upload another copy of your localconfig file...in case it got replaced when you uploaded the new version.
Title: Re: phpdvdprofiler
Post by: RossRoy on June 28, 2010, 05:37:17 AM
Since you mention that you localsiteconfig.php file is still intact, I'm guessing the username for the database doesn't have all the necessary access rights to drop the tables and load the new schema.

Looks like you might have to update the database schema manually...

Can't help you much there, maybe Fred will be around soon to give you better indications.
Title: Re: phpdvdprofiler
Post by: KinkyCyborg on June 28, 2010, 05:38:25 AM
Did that already. Downloaded the localsiteconfig.php file to my computer from my host, renamed it to siteconfig.php and re-upped it back to the site. So the siteconfig and localsiteconfig are both the same now with all the correct host/login info and still nothing... both before and after I tried that the result is the same... a blank screen.
Title: Re: phpdvdprofiler
Post by: KinkyCyborg on June 28, 2010, 05:39:42 AM
Since you mention that you localsiteconfig.php file is still intact, I'm guessing the username for the database doesn't have all the necessary access rights to drop the tables and load the new schema.

Looks like you might have to update the database schema manually...

Can't help you much there, maybe Fred will be around soon to give you better indications.

I've pretty much resigned myself to the fact that I will likely have to wait for Fred. No worries... I'm sure it will get straightened out. Thanks for the help guys!   :thanks:
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 28, 2010, 05:41:23 AM
I can't think of anything else to suggest either.  And after my own issues, I'm not the best person to try to help.

Maybe send Fred a PM here to let him know you need some help.  I get an email when I get a PM.
Title: Re: phpdvdprofiler
Post by: RossRoy on June 28, 2010, 05:52:24 AM
that's what I mean by the db user possibly not having the required access rights. That would be changed at the hosting account level - not in the phpdvdprofiler config files.

The fact it knows your schema is out of date means your site is configured correctly - it did access the database. It just can't update it.

I have no idea how it'd work for you - but on my end, I have access to something called "phpMyAdmin" which allows me to directly control the installed databases on my site.

If you read here: http://www.johnd.com.au/installingphpdvdprofilerV3/index.htm
Supposing that's the tutorial you followed to install phpdvdprofiler, when you look in the section "Creating the MySQL User" - it tells you to create the user with somewhat limited rights. Thing is, for the database schema update to work, you'd definitely need at least the CREATE and DROP rights as a minimum on top of those it already has.

You could set it to have all priviledges, run the update, then if successful restore the original rights as they were.

-------

Alternatively, you could manually update the database schema.

Theoretically, you could follow the steps "Creating the MySQL Database" and "Creating the MySQL User" as explained on this site: http://www.johnd.com.au/installingphpdvdprofilerV3/index.htm
Just make sure to use the same names as they are currently set in your localsiteconfig.php ($dbuser - $dbpasswd - $dbname - etc.)

But be careful - you might end up causing more damage than it is actually.. You might be better off waiting for Fred - hoping he's back soon..

Sorry about your troubles - that's the best advice i can give for now (and I have to go to bed)..

Hope you find a solution!

Title: Re: phpdvdprofiler
Post by: KinkyCyborg on June 28, 2010, 05:54:42 AM
Found this link on how to update the schema in mySQL database... did it and it is now allowing me to run the update. over 6800 profiles so it's going to take awhile but I should know shortly if it worked. Fingers crossed people!  :thumbup:
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 28, 2010, 05:55:54 AM
Oh good. :)  I'm glad it is working for you now.

I just checked..your page is loading up for me.  I don't know if all your titles are there now, but it is up.
Title: Re: phpdvdprofiler
Post by: RossRoy on June 28, 2010, 05:58:47 AM
Found this link on how to update the schema in mySQL database... did it and it is now allowing me to run the update. over 6800 profiles so it's going to take awhile but I should know shortly if it worked. Fingers crossed people!  :thumbup:

Oh goody! That means I typed that previous post for nothing!   :voodoo:   :hysterical:


Glad to see you're on the way to fixing it!  :thumbup:
Title: Re: phpdvdprofiler
Post by: KinkyCyborg on June 28, 2010, 06:02:51 AM
So my site is back and everything looks fine. Whew!  :yahoo: I confess however to not having read the release notes on the latest version so I'm not sure what I should be seeing different from before. To me everything looks exactly as it was with no new features of differences in appearance. All the options in the pull out menu seem to be the same too? Did I do something wrong during the installation or are all the changes in the mechanics of the program?

Found this link on how to update the schema in mySQL database... did it and it is now allowing me to run the update. over 6800 profiles so it's going to take awhile but I should know shortly if it worked. Fingers crossed people!  :thumbup:

Oh goody! That means I typed that previous post for nothing!   :voodoo:   :hysterical:



Glad to see you're on the way to fixing it!  :thumbup:

Sorry for the wasted effort Ross.  :-[ I'll be sure to return the favor sometime be typing up an equally long post that is equally unnecessary.  :D  I guess I should have attempted to troubleshoot a bit more before I come crying for help.
Title: Re: phpdvdprofiler
Post by: KinkyCyborg on June 28, 2010, 06:05:23 AM
Oh good. :)  I'm glad it is working for you now.

I just checked..your page is loading up for me.  I don't know if all your titles are there now, but it is up.

They appear to all be there.... all in the first update too! Thanks again Marie and Ross for the advice and help.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 28, 2010, 06:07:10 AM
I'm glad you got it working again.
Title: Re: phpdvdprofiler
Post by: RossRoy on June 28, 2010, 06:08:49 AM
So my site is back and everything looks fine. Whew!  :yahoo: I confess however to not having read the release notes on the latest version so I'm not sure what I should be seeing different from before. To me everything looks exactly as it was with no new features of differences in appearance. All the options in the pull out menu seem to be the same too? Did I do something wrong during the installation or are all the changes in the mechanics of the program?
Most of the work was probably behind the scenes to make it compatible with the new features of Profiler 3.6.1 and the changes to the XML file

Sorry for the wasted effort Ross.  :-[ I'll be sure to return the favor sometime be typing up an equally long post that is equally unnecessary.  :D  I guess I should have attempted to troubleshoot a bit more before I come crying for help.

Don't worry about it! I just commented about it for kicks! I'm just glad you are back up and running - that's all that matters!

but I'm still not in bed! Which is not good! I'm going to work at 6am tomorrow later today!  :yawn:
Title: Re: phpdvdprofiler
Post by: FredLooks on June 28, 2010, 02:44:20 PM
*yawn*  *scratch* *stretch*

So, did anything happen while I had a nap?   :devil:

Glad to see you've sorted it out. What appears to have happened is that the username that phpdvdprofiler uses to access your database had insufficient privilege to create tables, which is what the schema update does.

Sorry it bit you this way; I'll try to put some error checking around that to make it more clear what has happened.

Most of the changes in the last little while have been to support group dividers, the new format for the actor popups, custom mediatypes, custom collections, fix image displays, etc.  If you haven't been exporing the new features of the Windows program you may not see all that much ...
Title: Re: phpdvdprofiler
Post by: KinkyCyborg on June 28, 2010, 09:46:07 PM
I was toying with the idea of custom collections but decided against it, so you are right in assuming I haven't done much with DVD Profiler. I would be interested to know how the BorrowADVD function works and how to set it up.  ;)
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 28, 2010, 10:57:07 PM
I haven't done a lot with all the options either.

I'm just happy that I managed to change the colors in my signature a bit without screwing up everything again...and I've been able to add stuff to it as I've watched things..and added my new DVD/Blu-rays to my site.  So I'm happy that I can do that stuff without screwing up.
Title: Re: phpdvdprofiler
Post by: FredLooks on June 29, 2010, 12:10:35 AM
Let me just grab the code [glasses down nose]

Ummm, yup. OK. So the idea is that we want to let certain people borrow DVDs (or at least tell us that they'd like to do that). I originally just let anyone tell me that, and I got a rather startling number of requests from very distant places :)  At the moment, phpdvdprofiler doesn't really have the idea of logging-in, or identifying people, so the only thing that we can reasonably do is identify IP addresses (places) where people are browsing from. In my case, my place of business has a visible, well-known IP address and I don't mind getting requests from people who are using that IP address, so I list that address as a borrower. Then people will get a link to click on any profile that isn't already loaned, which will take them to a page where they can identify themselves (so I can figure out who to take the DVD to) and it will email me with the title name, location and slot#, and their info.

Details:
To add a borrower IP address, add a line (or more than one) to localsiteconfig.php which indicates the IP address or block of addresses that you want to allow. Some examples would be
$borrowers[ ] = '192.75.152.1/32';
$borrowers[ ] = '24.106.160.0/24';


These statements are adding elements to an array of addresses. The first one adds the single address 192.75.152.1, and the second adds the block of addresses 24.106.160.xxx (the notation used here is called CIDR notation and is used to specify network blocks; ask if you want more info).

In addition, you need to set
$MY_EMAIL_ADDRESS = 'kinkycyborg@your.email';
or whatever the email address where you want to receive these missives might be ...

Did that help?
Title: Re: phpdvdprofiler
Post by: Critter on June 29, 2010, 02:24:56 AM
Sorry, I just have to say, I don't know who you are Fred or what the hell this thread is about but is fantastic to see another Invader Zim fan around here.
 :thumbup:
Title: Re: phpdvdprofiler
Post by: KinkyCyborg on June 29, 2010, 02:28:41 AM
Thanks for the help Fred. I've only begun to tinker with it in the small snippets of time that my 4 year old daughter will allow me.  :baffled: Once she's cashed in her chips for the evening I'll give it a go. Thanks again!
Title: Re: phpdvdprofiler
Post by: Achim on June 29, 2010, 07:31:38 AM
If you haven't been exporing the new features of the Windows program you may not see all that much ...
Since you are here often now, I don't have to venture to the other fourm for this quick question:

Are you also making use of the "Count As" feature in the personalization window, e.g. in regards to the statistics? You know, the one where we can tell DVD Profiler as how many discs to count a certain profile (e.g.: I have been setting all parent profiles which are blank otherwise to "0").
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 29, 2010, 10:43:06 AM
That borrow dvd stuff confused me ...though it doesn't take much to do that.   :laugh:

I do use the count as feature in profiler.  And I made a custom collection for the DVDs that my mom and stepdad have since I watch some of theirs every so often.  I only uploaded information for a few of their movies to my phpdvdprofiler site so far.  I'll add others when I watch them...or I may just add them all sometime.  I haven't decided yet.  Though if I add them, it will really make the statistics look wacky since I don't know the purchase dates to enter for most of them.
Title: Re: phpdvdprofiler
Post by: FredLooks on June 29, 2010, 02:29:08 PM
@Critter: "do do do-de-do-do what'zat?"

@KinkyCyborg: a 4-year-old? sleep? good luck with that ... :laugh:

@Achim: CountAs is stored in the primary table, and is used for the counts at the bottom of the upper-left frame (Owned, Wishlist, etc.) If you have ideas on where else I should be using the CountAs instead of just enumerating profiles, please share (for example I'm undecided in the statistics - it might lead to trouble with counts of zero)  Did you notice that you can enter negative CountAs?  :-X

@Dragonfire: missing purchase dates can be handled by adding a few extra variables in the config file (basically telling the stats engine to ignore profiles whose purchase date is before xxxx) If you add a collection like you describe for your mom, you might want to add the collection name to the $CollectionsNotInOwned list so that the counts and statistics won't be applied to them also. This is equivalent to having the Windows program not count the collection in your owned list. That variable is documented in the siteconfig.php file (or you can ask if it gives you any trouble)
Title: Re: phpdvdprofiler
Post by: Critter on June 29, 2010, 03:33:03 PM
@Critter: "do do do-de-do-do what'zat?"

 :hysterical:

Ah the infamous doom song.

"Why is there bacon in the soap!?!"

"I made it myself!"

I will never get sick of that show.  :laugh:
Title: Re: phpdvdprofiler
Post by: Achim on June 29, 2010, 03:38:19 PM
@Achim: CountAs is stored in the primary table, and is used for the counts at the bottom of the upper-left frame (Owned, Wishlist, etc.) If you have ideas on where else I should be using the CountAs instead of just enumerating profiles, please share (for example I'm undecided in the statistics - it might lead to trouble with counts of zero)  Did you notice that you can enter negative CountAs?  :-X
(http://www.ya-shin.com/images/smileys/eek.gif)

Negative? I didn't know. Now that could get ugly real quick in stats, I believe you that. I thought it my replace my current dealings with the graphs, where I use the exceptions/rules to filter out unwanted stuff from certain graphs; I can just stick with that.

Thanks, Fred :)
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 29, 2010, 09:57:42 PM

@Dragonfire: missing purchase dates can be handled by adding a few extra variables in the config file (basically telling the stats engine to ignore profiles whose purchase date is before xxxx) If you add a collection like you describe for your mom, you might want to add the collection name to the $CollectionsNotInOwned list so that the counts and statistics won't be applied to them also. This is equivalent to having the Windows program not count the collection in your owned list. That variable is documented in the siteconfig.php file (or you can ask if it gives you any trouble)

Ok...I'll probably try to find where to get it to ignore some purchase dates..and add in the collection thing as not owned like you mentioned.  I didn't know those things were options. 
Title: Re: phpdvdprofiler
Post by: FredLooks on June 29, 2010, 11:48:33 PM
Well, if you don't set the purchasedate in the windows program, then it looks like 01/01/1970, so you could set $monthspecialcondition = "AND purchasedate > ".my_mktime(0,0,0,1,1,2000); which should ignore profiles without a purchasedate (it only includes dates after 2000).
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 30, 2010, 01:12:14 AM
Ok...I'll try that later this evening.
Title: Re: phpdvdprofiler
Post by: wewonit5times on August 22, 2010, 10:59:30 PM
I see that there are a few people using this but the forum over there is like a ghost town so the questions I've asked remain unanswered.

For the most part I have it set up like I'd like (it's a lovely little program tbh) but for the life of me I can't figure out how to do a "recently purchased" banner (whilst also keeping the recently watched banner) and make it clickable. One or the other I can do but not both at the same time. Can someone that has both working explain to me how to do this?

Thanks in advance.
Title: Re: phpdvdprofiler
Post by: Tom on August 22, 2010, 11:08:30 PM
I don't use phpdvdprofiler myself, but this post (http://www.dvdcollectorsonline.com/index.php/topic,776.msg71525.html#msg71525) looks like it has the solution for what you are looking for.
Title: Re: phpdvdprofiler
Post by: wewonit5times on August 23, 2010, 03:56:14 PM
Cheers Tom. I have it sorted.

All I need now is to know how to make it clickable so that it brings people directly to my phpDVDProfiler page.
Title: Re: phpdvdprofiler
Post by: DJ Doena on August 23, 2010, 04:42:24 PM
Cheers Tom. I have it sorted.

All I need now is to know how to make it clickable so that it brings people directly to my phpDVDProfiler page.

You use the same code you would use in a forum post:

Code: [Select]
[url=http://www.wewonit5times.byethost3.com/][img]http://www.wewonit5times.byethost3.com/ws.php?me=Stephen[/img][/url]
(http://www.wewonit5times.byethost3.com/ws.php?me=Stephen) (http://www.wewonit5times.byethost3.com/)
Title: Re: phpdvdprofiler
Post by: wewonit5times on August 23, 2010, 04:48:24 PM
Cheers DJ. You're a star.
Title: Re: phpdvdprofiler
Post by: wewonit5times on August 23, 2010, 05:04:15 PM
DJ, on graphs, is there a way of getting phpdvdProfiler to ignore any profile that I have set the count as '0'?

My top 10 runtime DVD's excluding TV shows has my Star Trek movies added together. I want to get it to avoid movie parents and TV child profiles (i.e. Things I have set the count as to '0').

Any help would be much appreciated.
Title: Re: phpdvdprofiler
Post by: DJ Doena on August 23, 2010, 05:54:14 PM
There are some exclude filters in the localsiteconfig.php but for this you better ask Fred directly on his board (http://dvdaholic.me.uk/forums/index.php#3).
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 03, 2011, 05:19:59 AM
I've been trying to update stuff for my sig..I run the update thing and it doesn't finish.  I've tried several times, last night and again tonight.  It keeps stopping after the same number and it won't go any further.  I don't have any idea what might be wrong.  :(  I don't like that I can't get my sig or the DVD info updated for the banner sig thing.
Title: Re: phpdvdprofiler
Post by: Achim on June 03, 2011, 06:25:45 AM
Maybe a damaged profile? Is there anything unusual in the number counts above in the title list in DVD Profiler?

When you update, what settings do you use on the update page? Maybe it switched from "accumulative" to "always start from top"? Because if it just times out it should at least finish the second try. Hence my first guess at a broken profile.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 03, 2011, 08:14:00 AM
The title list in DVD Profiler?  Or what comes up on the screen when I try to do the update for my sig?  It does say that a profile must not be empty...but it has been doing that and still finishing the update..sometimes I've had to restart it a few times, but it would finish.  Now it just keeps stopping.

I did try loading the profile for the one it says is empty..still get the same thing and it still stops after so many.

I have no idea what the update settings are.  I haven't tried to change any of that stuff.  Hmm...where would I look for that stuff?
Title: Re: phpdvdprofiler
Post by: Achim on June 03, 2011, 08:31:38 AM
The title list in DVD Profiler?  Or what comes up on the screen when I try to do the update for my sig?  It does say that a profile must not be empty...but it has been doing that and still finishing the update..sometimes I've had to restart it a few times, but it would finish.  Now it just keeps stopping.
I meant in DVD profiler, the Invelos program. I think you would always see a difference between "filters" and "all", even right after clicking Clear All Filters. The numbers should be the same.

Quote
I did try loading the profile for the one it says is empty..still get the same thing and it still stops after so many.
Load where? Does it give you a name which one is empty? Or you can't actually load it?


BTW, if you do indeed have one of thos empty damaged profiles, the cure is:
Create backup. Restore the backup but when asked what to restore choose "selected profiles" use that to "select all" and then unselect the one without a name showing (should be on top). I had this problem twice in the past...

Quote
I have no idea what the update settings are.  I haven't tried to change any of that stuff.  Hmm...where would I look for that stuff?
There is two checkboxes on the page where you manually start the update, next to the username and password fields.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 03, 2011, 05:56:49 PM
I just looked in the program, the numbers are the same there.

I meant I tired to upload it to the site where I have stuff for the banner.  It tells me the number of the profile that is empty.  I just exported it again and tried to upload it again. 

Hmm...ok.  I'll have to try that later.

Just tried it again...it's stopped sooner.  Sheesh.  I think I'm cursed.
Title: Re: phpdvdprofiler
Post by: FredLooks on June 03, 2011, 07:04:02 PM
It is likely best to correct the empty profile problem in the windows program - that appears to be an error that a database repair doesn't fix.

If the update process just stops without completing it usually means that  a time limit has been reached on the host. In that case, you should run the update again, this time ensuring that the "Complete Update will be performed" checkbox is not checked. if the checkbox is checked, the update deletes the entire database and starts from scratch. If the checkbox is not checked, then the update compares database entries against XML file pieces to try to only update profiles that have changed since the last update. In the case of recovering from a time limit error, that should effectively "skip" the entries already processed.

The message about profile ID's not being blank is only a warning, and was put in to help people fix the windows database - phpdvdprofiler won't try to import the record, and just skips to the next record.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 03, 2011, 07:28:04 PM
Ok.  I've had it not finish at once before..but it keeps stopping after the same number.

Fix it in Profiler?  I'm not sure what to do for it because the profile is there.  I looked.
Title: Re: phpdvdprofiler
Post by: FredLooks on June 03, 2011, 08:34:55 PM
By "fix it in profiler" I meant to use Achim's instructions for removing the blank profile. It is characterized by having no information, specifically no ID, so the directions that he gave are the only known way of removing the profile. Since the ID (which includes the locality) is the primary key for the entire windows database, having a record without one may well do unknown likely bad things to the windows program. It will not affect phpdvdprofiler, as we ignore it.

What is the number at which it stops? There should be a difference in the number where it stops between the CompleteUpdate and a regular (not Complete) update that follows a CompleteUpdate. If there is not, then there may be another issue...
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 04, 2011, 05:31:00 AM
Ahh..ok.  I'll try that later..or tomorrow.

It was stopping at 1800..then when I tried again earlier today it stopped earlier..like 500...now it is stopping at 1900.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 09, 2011, 05:18:25 AM
I tried doing what Achim said to fix the bad profile or empty one or whatever.  There weren't any with no names showing.  I went all through the list twice and all had names.

It still won't finish the update.  :(
Title: Re: phpdvdprofiler
Post by: DJ Doena on June 09, 2011, 06:48:44 AM
If you want you can zip & email me your collection and I'll take a look

karsten (at) yajirobi.de
Title: Re: phpdvdprofiler
Post by: Achim on June 09, 2011, 08:19:41 AM
I tried doing what Achim said to fix the bad profile or empty one or whatever.  There weren't any with no names showing.  I went all through the list twice and all had names.

It still won't finish the update.  :(
Sorry to hear that, but at least is rules out now. I hope Karsten can help.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 10, 2011, 05:28:33 AM
If you want you can zip & email me your collection and I'll take a look

karsten (at) yajirobi.de

From the backup?  the export of xml files?

I'll have to see if I have something on the computer that I can zip stuff with.
Title: Re: phpdvdprofiler
Post by: Achim on June 10, 2011, 06:50:07 AM
From the backup?  the export of xml files?
I am pretty sure he means the XML for now.

Quote
I'll have to see if I have something on the computer that I can zip stuff with.
7zip is free. (http://www.7-zip.org/) :D
Title: Re: phpdvdprofiler
Post by: DJ Doena on June 10, 2011, 10:27:29 AM
From the backup?  the export of xml files?

I'll have to see if I have something on the computer that I can zip stuff with.

Yes. And If you have Windows XP or higher you just have to select the file, right-click and choose Send To -> Compressed Folder
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 14, 2011, 07:16:31 AM
Even zipped, I'm getting errors about the file being too big.
Title: Re: phpdvdprofiler
Post by: Jimmy on June 14, 2011, 07:49:10 AM
In those case Marie you can always upload your file on a file server like Megaupload (http://www.megaupload.com/) and give the link to Karsten.
Title: Re: phpdvdprofiler
Post by: Achim on June 14, 2011, 10:34:38 AM
Even zipped, I'm getting errors about the file being too big.
Which file are you trying to send? Karsten said YES, but I still think he means the XML. If you are trying to send a backup, did you include the cover images; if yes, try without, he won't need them ;)
Title: Re: phpdvdprofiler
Post by: DJ Doena on June 14, 2011, 03:55:49 PM
Achim is right. If you're going to send me a backup file (File->Backup Database) then select "Custom Backup" and uncheck everything except "Include profiles".

But you can also send me the Export XML (File->Export Profile Database).
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 15, 2011, 01:09:47 AM
Ahh..ok.  I was trying the backup.  I'll try the xml thing.

Title: Re: phpdvdprofiler
Post by: FredLooks on June 15, 2011, 06:01:10 PM
Hey Marie,

  I have a suspicion that you have both an xmldir defined ($xmldir = 'SomeDirectory'; in localsiteconfig.php) and an xmlfile defined ($xmlfile = 'SomeXMLFile'; or no $xmlfile entry in localsiteconfig.php). Unless the entries in those are completely disjoint, that scenario would result in a lot of extra processing since the program would try to process both things, and the xmldir entries would sometimes override the xmlfile entries in an entirely non-intuitive manner. (As an aside, the xmldir option tends to be resource intensive since the program needs to open many files, and opening files is "expensive" in terms of resources.)

If you decided to switch to an xmldir option in the past, you should set $xmlfile = ''; in localsiteconfig.php, since the default values leave a value of 'collection.xml' which isn't quite desirable. Alternatively, you could just delete the file collection.xml and then the system would just use the files in xmldir.

I think that the current behaviour of trying to do both things is likely problematic - I don't generally like code taking away options from users, but I can't really think of a reason that a user would want both of these options present simultaneously ...

HTH
Title: Re: phpdvdprofiler
Post by: DJ Doena on June 15, 2011, 08:05:17 PM
I ran a complete update on my machine and even though it took a while it went through:

Code: [Select]
Schnelleres, speicherintensiveres Update: Aus
Komplettes Update:
Aktualisiere Datenbank aus XML-Datei:
Importing from XML file: collection.xml
Importing 0 files from directory xmls
File being processed: collection.xml

*******************************************************************************
collection.xml, the current collection file, is missing some components. When exporting from DVDProfiler
it is important to select ALL of the sections to be exported. There will be no data stored
for the following missing sections: Locks Crew Notes Tags Easter Eggs
*******************************************************************************
DVDs verarbeitet: 25
DVDs verarbeitet: 50
DVDs verarbeitet: 75
DVDs verarbeitet: 100
DVDs verarbeitet: 125
DVDs verarbeitet: 150
DVDs verarbeitet: 175
DVDs verarbeitet: 200
DVDs verarbeitet: 225
DVDs verarbeitet: 250
DVDs verarbeitet: 275
DVDs verarbeitet: 300
DVDs verarbeitet: 325
DVDs verarbeitet: 350
DVDs verarbeitet: 375
DVDs verarbeitet: 400
DVDs verarbeitet: 425
DVDs verarbeitet: 450
DVDs verarbeitet: 475
DVDs verarbeitet: 500
DVDs verarbeitet: 525
DVDs verarbeitet: 550
DVDs verarbeitet: 575
DVDs verarbeitet: 600
DVDs verarbeitet: 625
DVDs verarbeitet: 650
DVDs verarbeitet: 675
DVDs verarbeitet: 700
DVDs verarbeitet: 725
DVDs verarbeitet: 750
DVDs verarbeitet: 775
DVDs verarbeitet: 800
DVDs verarbeitet: 825
DVDs verarbeitet: 850
DVDs verarbeitet: 875
DVDs verarbeitet: 900
DVDs verarbeitet: 925
DVDs verarbeitet: 950
DVDs verarbeitet: 975
DVDs verarbeitet: 1000
DVDs verarbeitet: 1025
DVDs verarbeitet: 1050
DVDs verarbeitet: 1075
DVDs verarbeitet: 1100
DVDs verarbeitet: 1125
DVDs verarbeitet: 1150
DVDs verarbeitet: 1175
DVDs verarbeitet: 1200
DVDs verarbeitet: 1225
DVDs verarbeitet: 1250
DVDs verarbeitet: 1275
DVDs verarbeitet: 1300
DVDs verarbeitet: 1325
DVDs verarbeitet: 1350
DVDs verarbeitet: 1375
DVDs verarbeitet: 1400
DVDs verarbeitet: 1425
DVDs verarbeitet: 1450
DVDs verarbeitet: 1475
DVDs verarbeitet: 1500
DVDs verarbeitet: 1525
DVDs verarbeitet: 1550
DVDs verarbeitet: 1575
DVDs verarbeitet: 1600
DVDs verarbeitet: 1625
DVDs verarbeitet: 1650
DVDs verarbeitet: 1675
DVDs verarbeitet: 1700
DVDs verarbeitet: 1725
DVDs verarbeitet: 1750
DVDs verarbeitet: 1775
DVDs verarbeitet: 1800
DVDs verarbeitet: 1825
DVDs verarbeitet: 1850
DVDs verarbeitet: 1875
DVDs verarbeitet: 1900
DVDs verarbeitet: 1925
DVDs verarbeitet: 1950
DVDs verarbeitet: 1975
DVDs verarbeitet: 2000
DVDs verarbeitet: 2025
DVDs verarbeitet: 2050
DVDs verarbeitet: 2075
DVDs verarbeitet: 2100
DVDs verarbeitet: 2125
DVDs verarbeitet: 2150
DVDs verarbeitet: 2175
DVDs verarbeitet: 2200
DVDs verarbeitet: 2225
DVDs verarbeitet: 2250
DVDs verarbeitet: 2275
DVDs verarbeitet: 2300
DVDs verarbeitet: 2325
DVDs verarbeitet: 2350
DVDs verarbeitet: 2375
DVDs verarbeitet: 2400
DVDs verarbeitet: 2425
DVDs verarbeitet: 2450
DVDs verarbeitet: 2475
DVDs verarbeitet: 2500
DVDs verarbeitet: 2525
DVDs verarbeitet: 2550
DVDs verarbeitet: 2575
DVDs verarbeitet: 2600
DVDs verarbeitet: 2625
DVDs verarbeitet: 2650
DVDs verarbeitet: 2675
DVDs verarbeitet: 2700
DVDs verarbeitet: 2725
DVDs verarbeitet: 2744
Updating Custom Media Types and Custom Collections ...
Aktualisiere DVD-Boxen ...
Aktualisiere Statistik-Tabelle ...
Summe der verarbeiteten DVDs: 2744
Profile hinzugefügt: 2744
Profile bearbeitet: 0 (including Collection Number only: 0)
Profile gelöscht: 0
Kauforte entfernt: 0
Arbeitszeit (Sekunden): 3.900,095 (3.868,515 + 31,581)
Cleaning signature cache directory: Done
collectionurl is valid
Verifiziere Imageupdate-Version....Ok
Bestimme das Datum des letzten Updates.......(00000000)
Adult ist nicht auf 0 gesetzt. Es werden Erotikfilme berücksichtigt
Ermittle Bild-Informationen. Bitte warten......
Image for Profiles Processed :25
Image for Profiles Processed :50
Image for Profiles Processed :75
Image for Profiles Processed :100
Image for Profiles Processed :125
Image for Profiles Processed :150
Image for Profiles Processed :175
Image for Profiles Processed :200
Image for Profiles Processed :225
Image for Profiles Processed :250
Image for Profiles Processed :275
Image for Profiles Processed :300
Image for Profiles Processed :325
Image for Profiles Processed :350
Image for Profiles Processed :375
Image for Profiles Processed :400
Image for Profiles Processed :425
Image for Profiles Processed :450
Image for Profiles Processed :475
Image for Profiles Processed :500
Image for Profiles Processed :525
Image for Profiles Processed :550
Image for Profiles Processed :575
Image for Profiles Processed :600
Image for Profiles Processed :625
Image for Profiles Processed :650
Image for Profiles Processed :675
Image for Profiles Processed :700
Image for Profiles Processed :725
Image for Profiles Processed :750
Image for Profiles Processed :775
Image for Profiles Processed :800
Image for Profiles Processed :825
Image for Profiles Processed :850
Image for Profiles Processed :875
Image for Profiles Processed :900
Image for Profiles Processed :925
Image for Profiles Processed :950
Image for Profiles Processed :975
Image for Profiles Processed :1000
Image for Profiles Processed :1025
Image for Profiles Processed :1050
Image for Profiles Processed :1075
Image for Profiles Processed :1100
Image for Profiles Processed :1125
Image for Profiles Processed :1150
Image for Profiles Processed :1175
Image for Profiles Processed :1200
Image for Profiles Processed :1225
Image for Profiles Processed :1250
Image for Profiles Processed :1275
Image for Profiles Processed :1300
Image for Profiles Processed :1325
Image for Profiles Processed :1350
Image for Profiles Processed :1375
Image for Profiles Processed :1400
Image for Profiles Processed :1425
Image for Profiles Processed :1450
Image for Profiles Processed :1475
Image for Profiles Processed :1500
Image for Profiles Processed :1525
Image for Profiles Processed :1550
Image for Profiles Processed :1575
Image for Profiles Processed :1600
Image for Profiles Processed :1625
Image for Profiles Processed :1650
Image for Profiles Processed :1675
Image for Profiles Processed :1700
Image for Profiles Processed :1725
Image for Profiles Processed :1750
Image for Profiles Processed :1775
Image for Profiles Processed :1800
Image for Profiles Processed :1825
Image for Profiles Processed :1850
Image for Profiles Processed :1875
Image for Profiles Processed :1900
Image for Profiles Processed :1925
Image for Profiles Processed :1950
Image for Profiles Processed :1975
Image for Profiles Processed :2000
Image for Profiles Processed :2025
Image for Profiles Processed :2050
Image for Profiles Processed :2075
Image for Profiles Processed :2100
Image for Profiles Processed :2125
Image for Profiles Processed :2150
Image for Profiles Processed :2175
Image for Profiles Processed :2200
Image for Profiles Processed :2225
Image for Profiles Processed :2250
Image for Profiles Processed :2275
Image for Profiles Processed :2300
Image for Profiles Processed :2325
Image for Profiles Processed :2350
Image for Profiles Processed :2375
Image for Profiles Processed :2400
Image for Profiles Processed :2425
Image for Profiles Processed :2450
Image for Profiles Processed :2475
Image for Profiles Processed :2500
Image for Profiles Processed :2503
Upload OK
Adding/Updating data for (DJ Doena)
Updating existing user
Added/Updated 2503 dvd's

Erledigt ... Benötigte Zeit 22.99 Sekunden


Zur Startseite.

So I can only assume it's a timeout problem or something similar.
Title: Re: phpdvdprofiler
Post by: FredLooks on June 15, 2011, 08:48:55 PM
well, with a collection.xml containing 2700 profiles and an XML directory also containing 2700 profiles, it would take at least twice as long as expected ...
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 15, 2011, 09:52:05 PM
Hmmm..ok.

I'll try changing the xmlfile thing.  I think when I set it up I had to change it because the one xml file was too large for the host.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 15, 2011, 09:59:17 PM
I tried taking out the xmlfile thing and it still stops at 2000.
Title: Re: phpdvdprofiler
Post by: FredLooks on June 16, 2011, 03:33:14 PM
Could you try downloading and unzipping the new incupdate.php file from here (http://www.bws.com/phpdvdprofiler/incupdate.php.zip) and try a CompleteUpdate? I added some timing code to help debug the problem ...
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 17, 2011, 05:07:06 AM
I'm trying that now.

Title: Re: phpdvdprofiler
Post by: Dragonfire on June 17, 2011, 05:17:16 AM
That didn't work either.  It stopped at 600.  I tried 3 or 4 times and it kept stopping at 600.

I went back and unchecked the Complete Update...now it has at least gotten past 600.  well..it just stopped at 1000.
 :-\

Sorry to be such a pain with this.  I just really like having the banner thingy and the page..just would like it to work again.


Just to double check...where should I put the new file I downloaded and unzipped?  I'm not good with a lot of this code stuff.

Trying the update again...now up to 1300.... 
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 17, 2011, 05:23:01 AM
Just me again...

I ran the update a few more times and now it is back to stopping at 2000 again.


Could it be a problem with the host I'm using?
I've thought about trying to find another one...but I kind of didn't want to go through the setup again...it took me so long to get it to work to begin with.
Title: Re: phpdvdprofiler
Post by: Achim on June 17, 2011, 05:59:36 AM
Just to double check...where should I put the new file I downloaded and unzipped?  I'm not good with a lot of this code stuff.
No need to do coding here, Fred already prepared it for you. :)

On your website should be a file of the same name "incupdate.php". Rename that one and then copy Fred's file to the same location. Once you do this, you should see additional information during the update, which is what fred will want to know.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 17, 2011, 06:34:58 AM
I didn't see a incupdate.php already there.  I just uploaded it into the phpprofiler file.
Title: Re: phpdvdprofiler
Post by: Achim on June 17, 2011, 10:52:35 AM
I didn't see a incupdate.php already there.
:o

In the same folder where index.php and localsiteconfig.php are?
Title: Re: phpdvdprofiler
Post by: FredLooks on June 17, 2011, 03:25:17 PM
The difference should be that the messages about how many profiles have been processed should have a time at the front of each line. I'm hoping that those times will indicate whether we're hitting a time limit of some sort.

Incidentally, the theory of operation ( :o ) of updates is this:

Ordinarily, one would leave the Complete Update checkbox unchecked. This will cause the program to skip profiles that haven't changed since the last update. If for some reason one thinks that there is a problem with the database or for some other reason, the Complete Update checkbox can be checked. When it is checked, the update process completely removes all of the data in the database before starting, resulting in all profiles looking "new".

Now, if one is having a problem such as yours, the idea is to do a Complete Update to start from a known state. After it stops, then run regular updates until the process actually finishes. Each consecutive update should get farther, as it skips more of the collection.

I would be interested in how this expected behaviour compares with your observations (I'm not entirely certain which of the updates you are doing are Complete Updates, which "reset the clock" so to speak...)
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 18, 2011, 03:14:28 AM
Here's what shows up when I try to do an update..not the complete one.

Faster, more memory-intensive updates: On
Importing to database b2_5841265_phpdvdprofiler
Importing 2748 files from directory XML
1.932: DVD profiles processed: 100
2.785: DVD profiles processed: 200
3.829: DVD profiles processed: 300
XML/.xml: Profile IDs must not be blank. Profile #325
4.715: DVD profiles processed: 400
5.855: DVD profiles processed: 500
6.616: DVD profiles processed: 600
7.315: DVD profiles processed: 700
7.852: DVD profiles processed: 800
8.401: DVD profiles processed: 900
9.022: DVD profiles processed: 1000
9.928: DVD profiles processed: 1100
10.783: DVD profiles processed: 1200
11.594: DVD profiles processed: 1300
12.416: DVD profiles processed: 1400
13.224: DVD profiles processed: 1500
13.633: DVD profiles processed: 1600
14.336: DVD profiles processed: 1700
15.209: DVD profiles processed: 1800
16.065: DVD profiles processed: 1900
16.735: DVD profiles processed: 2000


Here's what comes up when I try the complete one.

Faster, more memory-intensive updates: On
Complete Update will be performed
Importing to database b2_5841265_phpdvdprofiler
Importing 2748 files from directory XML

*******************************************************************************
XML/043396503892.xml, the current collection file, is missing some components. When exporting from DVDProfiler
it is important to select ALL of the sections to be exported. There will be no data stored
for the following missing sections: Locks Crew Tags Easter Eggs
*******************************************************************************
14.601: DVD profiles processed: 100
22.830: DVD profiles processed: 200
31.309: DVD profiles processed: 300
XML/.xml: Profile IDs must not be blank. Profile #325
38.829: DVD profiles processed: 400
46.907: DVD profiles processed: 500
55.183: DVD profiles processed: 600

It has stopped at 600...I'll try again.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 18, 2011, 03:40:58 AM
Ok...Here's what is coming up while I keep trying to get the update to finish.  This is without having the option for complete update checked.

Faster, more memory-intensive updates: On
Importing to database b2_5841265_phpdvdprofiler
Importing 2748 files from directory XML
0.319: DVD profiles processed: 100
0.464: DVD profiles processed: 200
0.615: DVD profiles processed: 300
XML/.xml: Profile IDs must not be blank. Profile #325
0.766: DVD profiles processed: 400
0.921: DVD profiles processed: 500
1.087: DVD profiles processed: 600
8.662: DVD profiles processed: 700
26.896: DVD profiles processed: 800
43.925: DVD profiles processed: 900
62.327: DVD profiles processed: 1000


Faster, more memory-intensive updates: On
Importing to database b2_5841265_phpdvdprofiler
Importing 2748 files from directory XML
0.404: DVD profiles processed: 100
0.578: DVD profiles processed: 200
0.734: DVD profiles processed: 300
XML/.xml: Profile IDs must not be blank. Profile #325
0.873: DVD profiles processed: 400
1.009: DVD profiles processed: 500
1.147: DVD profiles processed: 600
1.246: DVD profiles processed: 700
1.365: DVD profiles processed: 800
1.516: DVD profiles processed: 900
1.694: DVD profiles processed: 1000
11.079: DVD profiles processed: 1100
30.055: DVD profiles processed: 1200
52.799: DVD profiles processed: 1300
72.322: DVD profiles processed: 1400
91.781: DVD profiles processed: 1500


Faster, more memory-intensive updates: On
Importing to database b2_5841265_phpdvdprofiler
Importing 2748 files from directory XML
0.290: DVD profiles processed: 100
0.441: DVD profiles processed: 200
0.574: DVD profiles processed: 300
XML/.xml: Profile IDs must not be blank. Profile #325
0.707: DVD profiles processed: 400
0.899: DVD profiles processed: 500
1.150: DVD profiles processed: 600
1.271: DVD profiles processed: 700
1.383: DVD profiles processed: 800
1.510: DVD profiles processed: 900
1.688: DVD profiles processed: 1000
1.840: DVD profiles processed: 1100
1.973: DVD profiles processed: 1200
2.093: DVD profiles processed: 1300
2.338: DVD profiles processed: 1400
2.547: DVD profiles processed: 1500
5.235: DVD profiles processed: 1600
24.640: DVD profiles processed: 1700

Title: Re: phpdvdprofiler
Post by: Dragonfire on June 18, 2011, 03:45:51 AM
More attempts...

Faster, more memory-intensive updates: On
Importing to database b2_5841265_phpdvdprofiler
Importing 2748 files from directory XML
0.441: DVD profiles processed: 100
0.647: DVD profiles processed: 200
0.861: DVD profiles processed: 300
XML/.xml: Profile IDs must not be blank. Profile #325
1.016: DVD profiles processed: 400
1.154: DVD profiles processed: 500
1.269: DVD profiles processed: 600
1.392: DVD profiles processed: 700
1.521: DVD profiles processed: 800
1.652: DVD profiles processed: 900
1.810: DVD profiles processed: 1000
1.982: DVD profiles processed: 1100
2.141: DVD profiles processed: 1200
2.338: DVD profiles processed: 1300
2.508: DVD profiles processed: 1400
2.705: DVD profiles processed: 1500
2.898: DVD profiles processed: 1600
3.061: DVD profiles processed: 1700
22.566: DVD profiles processed: 1800
41.213: DVD profiles processed: 1900


Faster, more memory-intensive updates: On
Importing to database b2_5841265_phpdvdprofiler
Importing 2748 files from directory XML
0.263: DVD profiles processed: 100
0.348: DVD profiles processed: 200
0.451: DVD profiles processed: 300
XML/.xml: Profile IDs must not be blank. Profile #325
0.587: DVD profiles processed: 400
0.679: DVD profiles processed: 500
0.797: DVD profiles processed: 600
0.942: DVD profiles processed: 700
1.062: DVD profiles processed: 800
1.146: DVD profiles processed: 900
1.247: DVD profiles processed: 1000
1.340: DVD profiles processed: 1100
1.435: DVD profiles processed: 1200
1.683: DVD profiles processed: 1300
1.944: DVD profiles processed: 1400
2.134: DVD profiles processed: 1500
2.350: DVD profiles processed: 1600
2.560: DVD profiles processed: 1700
2.740: DVD profiles processed: 1800
2.920: DVD profiles processed: 1900
22.488: DVD profiles processed: 2000


Faster, more memory-intensive updates: On
Importing to database b2_5841265_phpdvdprofiler
Importing 2748 files from directory XML
0.340: DVD profiles processed: 100
0.473: DVD profiles processed: 200
0.583: DVD profiles processed: 300
XML/.xml: Profile IDs must not be blank. Profile #325
0.676: DVD profiles processed: 400
0.773: DVD profiles processed: 500
0.877: DVD profiles processed: 600
0.976: DVD profiles processed: 700
1.065: DVD profiles processed: 800
1.215: DVD profiles processed: 900
1.397: DVD profiles processed: 1000
1.599: DVD profiles processed: 1100
1.759: DVD profiles processed: 1200
1.891: DVD profiles processed: 1300
2.020: DVD profiles processed: 1400
2.183: DVD profiles processed: 1500
2.321: DVD profiles processed: 1600
2.443: DVD profiles processed: 1700
2.568: DVD profiles processed: 1800
2.690: DVD profiles processed: 1900
2.826: DVD profiles processed: 2000


Faster, more memory-intensive updates: On
Importing to database b2_5841265_phpdvdprofiler
Importing 2748 files from directory XML
0.262: DVD profiles processed: 100
0.348: DVD profiles processed: 200
0.462: DVD profiles processed: 300
XML/.xml: Profile IDs must not be blank. Profile #325
0.553: DVD profiles processed: 400
0.645: DVD profiles processed: 500
0.760: DVD profiles processed: 600
0.895: DVD profiles processed: 700
1.021: DVD profiles processed: 800
1.154: DVD profiles processed: 900
1.316: DVD profiles processed: 1000
1.471: DVD profiles processed: 1100
1.594: DVD profiles processed: 1200
1.710: DVD profiles processed: 1300
1.832: DVD profiles processed: 1400
1.983: DVD profiles processed: 1500
2.112: DVD profiles processed: 1600
2.240: DVD profiles processed: 1700
2.411: DVD profiles processed: 1800
2.606: DVD profiles processed: 1900
2.789: DVD profiles processed: 2000

Faster, more memory-intensive updates: On
Importing to database b2_5841265_phpdvdprofiler
Importing 2748 files from directory XML
0.415: DVD profiles processed: 100
0.602: DVD profiles processed: 200
0.731: DVD profiles processed: 300
XML/.xml: Profile IDs must not be blank. Profile #325
0.863: DVD profiles processed: 400
0.978: DVD profiles processed: 500
1.105: DVD profiles processed: 600
1.248: DVD profiles processed: 700
1.358: DVD profiles processed: 800
1.476: DVD profiles processed: 900
1.628: DVD profiles processed: 1000
1.803: DVD profiles processed: 1100
1.922: DVD profiles processed: 1200
2.097: DVD profiles processed: 1300
2.285: DVD profiles processed: 1400
2.514: DVD profiles processed: 1500
2.718: DVD profiles processed: 1600
2.901: DVD profiles processed: 1700
3.113: DVD profiles processed: 1800
3.328: DVD profiles processed: 1900
3.517: DVD profiles processed: 2000
Title: Re: phpdvdprofiler
Post by: Achim on June 18, 2011, 07:31:15 AM
XML/.xml: Profile IDs must not be blank. Profile #325
This looks like it would be one of those empty profile profiles we discussed earlier. But then, it's not coming to a grinding hold right there or even shortly after. :shrug: again, this would be something within the PC program already, not directly phpDVDProfiler related. (I offer to have a look; I would need a program backup file, basic profiles only, no cover images.)


I remember one kind of problem I had one, where the error would not cause an immediate stop, but it would take a while to mess up the import. But I think that came from using a plugin (not sure that even saw public release) to export single XMLs each time I changed a profile.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 18, 2011, 08:35:54 AM
It was saying another profile must not be empty for a while...I could also do the update.  After a while it just stopped giving that message..then this one started up.  This might be about the 3rd or 4th different one it has said that about.
Title: Re: phpdvdprofiler
Post by: FredLooks on June 18, 2011, 02:47:27 PM
Nice.

First about the blank profile - when using the many-files-in-directory approach rather than the single-XML-file approach, profile deletions (including blanks) must be done by hand rather than automatically by the windows program. Bottom line is that you have a file named .xml in your XML directory and if you delete it then the problem will disappear. Since that file name starts with a period, it may be invisible so if you have trouble finding it to delete it, a one-liner php script can do it for you (specifically, <?php unlink("XML/.xml"); ?> ). It isn't hurting anything, only cluttering up the output a little.

Back to the more interesting problem of the update not finishing. We can see some telling details.

If you look at the sequence of updates starting at the CompleteUpdate, you can see that the CompleteUpdate terminates after 600-ish profiles. The next update quickly (looking at the times in the first column of output) gets to 600-ish profiles and then starts slogging on, terminating after about 1000. The next goes quickly to 1000 and then stops after around 1500. This is all consistent with there being enough resources (provisional guess: time) to process about 600 or so profiles. Good, then it should take about 5 updates to complete the <3000 profiles.

But. Notice that after it hits 2000 profiles it doesn't advance. And from the times in the first column we can see that it is taking very little time to get to where it should continue the processing. So my best guess is that the first few runs are being stopped by a time limit of some sort (if I had to guess I'd say that your provider has imposed a 60-sec. time limit on accounts). The final few runs would seem to indicate that there is some other additional resource constraint that you're exceeding.

Can you try setting $ReportOnMemory = true; in your localsiteconfig.php.  Note that this may not work, since it relies on the precise format of the output of some system routines on your provider. If it fails we should be able to debug it ...

It may be worthwhile opening a support ticket with your provider, who can likely tell from inspection of her system logs what the issue may be, and if there is a mechanism to work around it ...
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 18, 2011, 09:01:33 PM
I'll try changing the one thing in the localconfig file later this evening.  I'm going out to run some errands soon.

Also, the update thing was working fine until about 2 or 3 weeks ago.  Sometimes I would have to run the process a couple of times to get it to finish, but it would finish.
Title: Re: phpdvdprofiler
Post by: FredLooks on June 18, 2011, 09:57:34 PM
That would seem to indicate that your provider made some changes 2 or 3 weeks ago (since you hadn't changed the code prior to the problem, it's your provider or a profile that changed then and since you were double-processing the data before without incident, my money is on the provider). That might help them pinpoint the issue ...
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 19, 2011, 05:26:33 AM
I can't find $ReportOnMemory = true; in the locasitelconfig.php

I went through it 3 times and can't see it...  is it near the top?  bottom?
Title: Re: phpdvdprofiler
Post by: FredLooks on June 19, 2011, 06:03:01 AM
Sorry, I was unclear ... just add a line anywhere in localsiteconfig.php that says: $ReportOnMemory = true;
There won't be one there already.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 19, 2011, 06:25:35 AM
Ok...I'll try that now.
Least I know I wasn't losing my mind and not being able to find it. lol

Title: Re: phpdvdprofiler
Post by: Dragonfire on June 19, 2011, 06:33:45 AM
Ok..I did that. 
Here's the result stuff.

Faster, more memory-intensive updates: On
Importing to database b2_5841265_phpdvdprofiler
Importing 2748 files from directory XML
0.185: Before Processing: Resident Set Size is 0.0MB (% of real memory) currently using 5.9MB
0.333: DVD profiles processed: 100: Resident Set Size is 0.0MB (% of real memory) currently using 5.8MB
0.466: DVD profiles processed: 200: Resident Set Size is 0.0MB (% of real memory) currently using 5.7MB
0.593: DVD profiles processed: 300: Resident Set Size is 0.0MB (% of real memory) currently using 5.6MB
XML/.xml: Profile IDs must not be blank. Profile #325
0.732: DVD profiles processed: 400: Resident Set Size is 0.0MB (% of real memory) currently using 5.5MB
0.829: DVD profiles processed: 500: Resident Set Size is 0.0MB (% of real memory) currently using 5.4MB
0.932: DVD profiles processed: 600: Resident Set Size is 0.0MB (% of real memory) currently using 5.3MB
1.087: DVD profiles processed: 700: Resident Set Size is 0.0MB (% of real memory) currently using 5.3MB
1.195: DVD profiles processed: 800: Resident Set Size is 0.0MB (% of real memory) currently using 5.2MB
1.331: DVD profiles processed: 900: Resident Set Size is 0.0MB (% of real memory) currently using 5.1MB
1.547: DVD profiles processed: 1000: Resident Set Size is 0.0MB (% of real memory) currently using 5.0MB
1.799: DVD profiles processed: 1100: Resident Set Size is 0.0MB (% of real memory) currently using 4.9MB
2.031: DVD profiles processed: 1200: Resident Set Size is 0.0MB (% of real memory) currently using 4.8MB
2.189: DVD profiles processed: 1300: Resident Set Size is 0.0MB (% of real memory) currently using 4.7MB
2.313: DVD profiles processed: 1400: Resident Set Size is 0.0MB (% of real memory) currently using 4.6MB
2.447: DVD profiles processed: 1500: Resident Set Size is 0.0MB (% of real memory) currently using 4.5MB
2.585: DVD profiles processed: 1600: Resident Set Size is 0.0MB (% of real memory) currently using 4.4MB
2.686: DVD profiles processed: 1700: Resident Set Size is 0.0MB (% of real memory) currently using 4.3MB
2.922: DVD profiles processed: 1800: Resident Set Size is 0.0MB (% of real memory) currently using 4.2MB
3.155: DVD profiles processed: 1900: Resident Set Size is 0.0MB (% of real memory) currently using 4.1MB
3.370: DVD profiles processed: 2000: Resident Set Size is 0.0MB (% of real memory) currently using 4.0MB


Faster, more memory-intensive updates: On
Importing to database b2_5841265_phpdvdprofiler
Importing 2748 files from directory XML
0.214: Before Processing: Resident Set Size is 0.0MB (% of real memory) currently using 5.9MB
0.356: DVD profiles processed: 100: Resident Set Size is 0.0MB (% of real memory) currently using 5.8MB
0.494: DVD profiles processed: 200: Resident Set Size is 0.0MB (% of real memory) currently using 5.7MB
0.641: DVD profiles processed: 300: Resident Set Size is 0.0MB (% of real memory) currently using 5.6MB
XML/.xml: Profile IDs must not be blank. Profile #325
0.784: DVD profiles processed: 400: Resident Set Size is 0.0MB (% of real memory) currently using 5.5MB
0.950: DVD profiles processed: 500: Resident Set Size is 0.0MB (% of real memory) currently using 5.4MB
1.074: DVD profiles processed: 600: Resident Set Size is 0.0MB (% of real memory) currently using 5.3MB
1.247: DVD profiles processed: 700: Resident Set Size is 0.0MB (% of real memory) currently using 5.3MB
1.329: DVD profiles processed: 800: Resident Set Size is 0.0MB (% of real memory) currently using 5.2MB
1.468: DVD profiles processed: 900: Resident Set Size is 0.0MB (% of real memory) currently using 5.1MB
1.647: DVD profiles processed: 1000: Resident Set Size is 0.0MB (% of real memory) currently using 5.0MB
1.822: DVD profiles processed: 1100: Resident Set Size is 0.0MB (% of real memory) currently using 4.9MB
1.976: DVD profiles processed: 1200: Resident Set Size is 0.0MB (% of real memory) currently using 4.8MB
2.125: DVD profiles processed: 1300: Resident Set Size is 0.0MB (% of real memory) currently using 4.7MB
2.295: DVD profiles processed: 1400: Resident Set Size is 0.0MB (% of real memory) currently using 4.6MB
2.485: DVD profiles processed: 1500: Resident Set Size is 0.0MB (% of real memory) currently using 4.5MB
2.711: DVD profiles processed: 1600: Resident Set Size is 0.0MB (% of real memory) currently using 4.4MB
2.894: DVD profiles processed: 1700: Resident Set Size is 0.0MB (% of real memory) currently using 4.3MB
3.107: DVD profiles processed: 1800: Resident Set Size is 0.0MB (% of real memory) currently using 4.2MB
3.273: DVD profiles processed: 1900: Resident Set Size is 0.0MB (% of real memory) currently using 4.1MB
3.438: DVD profiles processed: 2000: Resident Set Size is 0.0MB (% of real memory) currently using 4.0MB
Title: Re: phpdvdprofiler
Post by: FredLooks on June 19, 2011, 07:59:30 PM
Hmmm ... it looks like there is no problem with memory. I would be inclined to ask your ISP if they can tell you why the process is failing to complete - the code is instrumented to squawk if it detects any errors, and generally speaking, only dies silently when it has been terminated with prejudice and can't say anything. If there were an SQL error (limits can be put on the number of DB operations performed over a period of time, and an update does rather a lot of them) then the code should be saying something, but sometimes those errors are muted or logged and processes stopped.

I'm happy to help if I can with such a conversation ...
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 20, 2011, 04:18:36 AM
The host for where my collection site is?
Title: Re: phpdvdprofiler
Post by: Jimmy on June 20, 2011, 05:04:44 AM
Marie I'm sure you know it already, but you don't have to upload a full xml file every time you need to update your online. I only upload the new profiles and the modified one when I update mine (I just upload a full collection.xml file when I remove a profile)... maybe that would prevent the problem with your host :shrug:
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 20, 2011, 08:06:39 AM
When I set up stuff there for the program, it said the xml file was too big when it had all the profiles in it.  So I switched to one per profile.  I just upload the ones that I've watched or the new ones when I upload, not all of them.
Title: Re: phpdvdprofiler
Post by: FredLooks on June 20, 2011, 01:22:37 PM
Yes, your host provider seems to be bytehost.com

Their webpage suggests that they provide some statistics and stuff, and have free support, so looking at the stats and logs might be a good idea.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 21, 2011, 05:05:49 AM
What would I be looking for in the stats and logs?
Title: Re: phpdvdprofiler
Post by: FredLooks on June 21, 2011, 05:26:32 PM
well, in the logs you'd be looking for some text involving your username, dragonfire88, and indicating some problem or another. As for stats, I would be inclined to look for times that are all the same (+/- .01 sec) as well as any other limits that are all suspiciously similar (memory usage, etc.) The more difficult thing to see would be if the provider has put a limit of xxx SQL queries per (min./hour/day) since the stats likely won't capture that information in a way that would be easy to spot without post-processing the data (when the unit of time is greater than a single run, then one would have to take the numbers and compile them into statistics for that unit of time)

Generally, the easiest place to start would be to simply tell your provider that you have a script which seems to be dying abnormally in a way that suggests it is being stopped by some sort of resource-limiting agency and could they suggest a way of figuring out if it is an administrative function stopping it. Perhaps they have some system logs (to which it would be unlikely for you to have access) which indicate things like "process yyy of user xxx exceeded time-limit - terminated" which might shed some light on things.

HTH
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 25, 2011, 05:49:38 AM
Ok...thanks.  I'll try that tomorrow.  I would have tried it by now, but I haven't had time to post here last few days.
Title: Re: phpdvdprofiler
Post by: Dragonfire on July 05, 2011, 10:18:47 PM
My host no longer does script/code/html support for free accounts..which is what I have.

I probably need to find a different host, but I really don't have the extra money for a paid one right now...and I dread the thought of setting everything again...it was difficult for me to get it to work the first time.
Title: Re: phpdvdprofiler
Post by: Dragonfire on July 08, 2011, 06:27:55 AM
Thanks to Sebastien, I have a new host and no more issues with the update thing stopping instead of completely finishing.   :D

Thanks again Sebastien. :)
Title: Re: phpdvdprofiler
Post by: Jimmy on July 08, 2011, 06:53:04 AM
He sure is a great host and fast when we need help, but his name is Sebastien not Sebastian :P
Title: Re: phpdvdprofiler
Post by: Dragonfire on July 08, 2011, 08:13:29 AM
Ack.
Ok..I fixed that. 
Sorry about that Sebastien.  I do know who you are.  I even doubled checked to make sure I spelled your name right..then I still managed to goof...  I must have had a blonde moment.  :laugh:

And you're right Jimmy..he was really fast getting stuff set up for me to start uploading.  He even changed what needed to be changed in the localconfig file for me too.   :D
Title: Re: phpdvdprofiler
Post by: RossRoy on July 08, 2011, 01:50:56 PM
Ok ok enough with the flowers because the pot will hurt that much more when it comes!  :whistle:

Oh and Sebastien / Sebastian .. same difference .. even all my work paper says Sebastian .. I keep trying to get my employer to fix it, but I just learned to live with it instead.
Title: Re: phpdvdprofiler
Post by: Kathy on July 08, 2011, 03:50:22 PM
Ok ok enough with the flowers because the pot will hurt that much more when it comes!  :whistle:

Oh and Sebastien / Sebastian .. same difference .. even all my work paper says Sebastian .. I keep trying to get my employer to fix it, but I just learned to live with it instead.

I always copy your name listed above your list of movies you just watched. I figure you know how to spell your own name!  :laugh:
Title: Re: phpdvdprofiler
Post by: RossRoy on July 08, 2011, 05:06:33 PM
I figure you know how to spell your own name!  :laugh:

You'd be surprised!  :bag:   :laugh:
Title: Re: phpdvdprofiler
Post by: Dragonfire on July 09, 2011, 05:02:29 AM
Ok ok enough with the flowers because the pot will hurt that much more when it comes!  :whistle:

Oh and Sebastien / Sebastian .. same difference .. even all my work paper says Sebastian .. I keep trying to get my employer to fix it, but I just learned to live with it instead.

I always copy your name listed above your list of movies you just watched. I figure you know how to spell your own name!  :laugh:

I looked at it above the watched banner too...but I still managed to goof.  But at least I was close.
Title: Re: phpdvdprofiler
Post by: RossRoy on July 25, 2011, 08:45:31 PM
Fred, little request for you, if at all possible.

We just had a minor issue with Marie's site where a thumbnail file was the wrong one, it still showed a copy of the front image. My guess is that it was uploaded with the front image for both front and back, and the thumbnails were generate that way. Then she uploaded the correct back, but not the thumbnail.

But because I can't give her rsync access, what she does is upload only new or modified images and let phpdvdp do the thumbnailing. That's all fine, except in this case, because the thumnbail already existed, it didn't regenerate it.

Would it be possible to add something that would basically tell phpdvdp "this thumbnail is showing the wrong image - recreate it from the image file". Either as a whole process (going through each image and regenerating those that need it) - or on a profile by profile basis with a button, link or something.
Title: Re: phpdvdprofiler
Post by: FredLooks on July 25, 2011, 09:48:25 PM
Ah. I see the problem.

I think I really need to rethink images.

Originally, there were two sets of images, mirroring the windows files: the main images and the thumbnails. Thumbs were used for the main profile images, and full-size were for when the thumbs were clicked.

With the advent of the gallery and the watched lists, there wound up being lots of differently-sized images, most of which were generated dynamically, though cached in the imagecache directory. Worse, the windows profiler decision to not store HD banners meant that weird things had to be done to show the images as one would want. Currently most times that is done by compositing the banner and the image when resizing.

Bottom line is that it may make more sense to just do away with the thumbnails and generate them as required, although I have to wander around the code a little to see how troubling that would be ... now that I think of it, it may be that the main profile thumbs are not directly from the thumbnail files ... I have to look at it ...

I'll get back to you on this one ...
Title: Re: phpdvdprofiler
Post by: DJ Doena on February 17, 2012, 07:09:47 AM
Fred has released a new version: http://dvdaholic.me.uk/forums/index.php?topic=788.0;topicseen
Title: Re: phpdvdprofiler
Post by: FredLooks on June 10, 2012, 11:27:05 PM
I have released a new version: http://dvdaholic.me.uk/forums/index.php?topic=803.0 (http://dvdaholic.me.uk/forums/index.php?topic=803.0)

It supports Ken's 3.8.0, but is a little rushed so that I can prepare to work on the 3.8.1 ...

As always, This (http://www.bws.com/phpdvdprofiler.zip) gets the full zip also ...
Title: Re: phpdvdprofiler
Post by: Achim on June 12, 2012, 05:28:49 AM
Thanks, Fred! :bow:
Title: Re: phpdvdprofiler
Post by: RossRoy on June 12, 2012, 06:57:10 PM
Sorry if I'm simply late to the party but .. love the new update code! I really like that it retries by itself until it's complete!  :thumbup:
Title: Re: phpdvdprofiler
Post by: Kathy on June 12, 2012, 07:05:59 PM
I'm sure I would like the updates if I could have ever figured out to install it in the first place.  :laugh:
Title: Re: phpdvdprofiler
Post by: Jimmy on June 12, 2012, 07:35:31 PM
I really like that it retries by itself until it's complete!  :thumbup:
At first I tought I had a problem, not used to see it restart after 300 or so profiles. But of course I haven't read the release info, so it's kind of my fault :laugh:

I'm sure I would like the updates if I could have ever figured out to install it in the first place.  :laugh:
I can't say it's easy to set it. A chance Eric helped me a lot when I did it the first time and Sebastien too who is always there when I have a problem. The fact we talk the same language help a lot for the technical thing ;D
Title: Re: phpdvdprofiler
Post by: FredLooks on June 13, 2012, 06:06:45 PM
Sorry if I'm simply late to the party but .. love the new update code! I really like that it retries by itself until it's complete!  :thumbup:
Glad you find it useful. It was ... interesting getting it to work properly (or even acceptably  :) )
Title: Re: phpdvdprofiler
Post by: EdwinK on June 13, 2012, 10:55:29 PM
Your phpdvdprofiler is something I do miss.
Title: Re: phpdvdprofiler
Post by: Kathy on June 14, 2012, 12:24:27 AM
Your phpdvdprofiler is something I do miss.

What program do you use for your DVD collection?
Title: Re: phpdvdprofiler
Post by: EdwinK on June 14, 2012, 11:09:48 AM
I now use Moviecollectorz and am trying with My Movies (both on Mac)
Title: Re: phpdvdprofiler
Post by: Achim on June 15, 2012, 06:26:11 AM
I now use Moviecollectorz and am trying with My Movies (both on Mac)
I think it was the lack of a watched event tracking at the time that stopped me from switching to My Movies. I contacted one of the developers and he said they will add it, but I haven't checked since then (some time last year). They do many things simpler than in DVD Profiler, but I figured that that would actually be sufficient for me.
Title: Re: phpdvdprofiler
Post by: DSig on June 15, 2012, 07:12:31 AM
I now use Moviecollectorz and am trying with My Movies (both on Mac)
I recently looked at Movie Collectorz as I was looking for a Library collection sw routine.  But their movie version seemed like a rehashed version of their book sw.  My Movies looks interesting.

Let us know how it goes

DSig
Title: Re: phpdvdprofiler
Post by: RossRoy on June 15, 2012, 01:53:40 PM
Fred, I'm having an odd problem.

I use Site5 as a host. Using the older version, the update and movie listing goes through without a problem. With the newer version? It craps out all the time. It takes multiple updates to get through the whole XML file (20+) and when I go to the main site for the listing, the script will just die and not show the listing on the left.

I managed to fix it somewhat for myself by doing a full update of the database, but it still dies here and there.

Then, there's Marie's collection. I host it on my account as a subdomain. Hers just won't list the movie on the main at all. I've tried complete update, recreating the database, nothing. The update eventually goes through (again, 15-20+ incremental updates needed) and once done, we can't get the listing or the little javascript menu on the left.

I contacted my host, and they said the php script "killer" must be too stringent, and that I could use a custom php.ini file to set different limits to allow the script to run smoothly. Well, I've tried setting Max Execution time at 5 minutes and Max memory at 192MiB.. still craps out.

I was wondering if we could work together and try to find out what's going on. Whether it's a bug in phpdvdprofiler, or something I can fix on my end with a custom php.ini, or get the hosting company to change whatever needs to be changed for it to work (they are usually quite receptive for that kind of thing).

Let me know!

Edit: Oh yeah! I also tried limiting the number of profiles listed to 250 items, and it still craps out of Marie's collection. Maybe it's a corrupt XML file?
Title: Re: phpdvdprofiler
Post by: FredLooks on June 16, 2012, 06:10:08 AM
Well, that's annoying. That update change was designed specifically to help in that situation.

I definitely want to make that work for you and Marie. Why don't you drop me a note at fred@bws.com with some of the details of your host, and we can start testing...
Title: Re: phpdvdprofiler
Post by: Jimmy on June 16, 2012, 06:16:53 AM
Weird that you have trouble with Marie's collection and everything went fine with mine as I am hosted by you too :hmmmm:

Did she does something different than me with he xml files? Maybe she have one file by profile and this is the problem :shrug:
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 16, 2012, 06:25:45 AM
I do have one file for each profile.  I started doing that when I was using a free host that limited the size of a file...one file was too big.  I never thought about changing that. 

For some of the ones that have multiple discs - like the Blu-rays that have DVD copies as well - like Sherlock Holmes -, I only upload the Blu-ray profile.  Do I need to add the DVD profiles for those titles too?

When I update stuff, it does say that a profile can't be empty..I can't remember the number now.  Could that be causing a problem?
Title: Re: phpdvdprofiler
Post by: Jimmy on June 16, 2012, 06:33:39 AM
I'm not the expert on this... But you don't have to worry about the size of the main file Marie. Everytime I upload mine it's just with the ones I have flagged and not my complete collection.

By exemple if I change a profile (watched or do an edit) I flag it, do a flag only export and upload the small xml file on the server. Same thing if I add a new dvd to my collection.

You just have to make sure to uncheck "Update database to remove profiles that are not in xml collection" when you update.

The only time I have to upload the complete xml is when I delete a DVD from my collection.

For some of the ones that have multiple discs - like the Blu-rays that have DVD copies as well - like Sherlock Holmes -, I only upload the Blu-ray profile.  Do I need to add the DVD profiles for those titles too?
Personally I add them, but I don't think it's the cause of the problem as they are child profile.
Title: Re: phpdvdprofiler
Post by: DJ Doena on June 16, 2012, 07:46:20 AM
But Jimmy just as a reminder: When you change cast names you should export all profiles with that cast or else you break your online database.
Title: Re: phpdvdprofiler
Post by: Jimmy on June 16, 2012, 08:09:47 AM
Never tought at that... but when I change a credited name this is to attach the name to the one use by my other movies (I never change the primary name when my choice is done).
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 16, 2012, 06:51:13 PM
Hmmm....ok.
I guess I was thinking that I'd have to upload them all in the one giant file every time or I'd end up replacing everything with just the one profile or something.

I know when I first got it set up, that was one of the problems I had.  The host I was using at that time limited the max file size..probably because it was free.
Title: Re: phpdvdprofiler
Post by: FredLooks on June 16, 2012, 11:08:45 PM
You can, of course, upload one big XML file every time (I do that, but it is my server and on a local lan).

You can also upload the collection as a bunch of one-profile-per-xml-file files (then you only have to upload the changed files, and you have to manually delete any files corresponding to deleted profiles - or profiles whose UPC has been manually changed)

RossRoy is uploading a single XML file containing only the changed files, and telling the update not to delete. I am uncertain if this will always work with the re-starting changes I made in the last couple of releases. Now it recalls how far up the file it has gotten, and if the file changes out from under it there could be fireworks. You can alleviate that by issuing a http: //your.site/phpdvdprofiler/index.php?action=HealthCheck request from your browser - that resets things.

If you set $UpdateDebug = true; in your localsiteconfig.php, it will add an extra button to the update UI (named, appropriately, "Debug"). Pressing this button will open a window with much arcana about the current update session (it's basically a log of what's happened so far, specifically giving times and data of network requests to the server). The output is likely only interesting to me, but it will likely be quite interesting to me, so if you could enable that it would likely prepare for any debugging sessions ...
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 17, 2012, 02:31:53 AM
I've always done one profile per xml file..then just updated the new movies or the ones I've watched.

I'll see if I can find that debug line in the file.  Or do I have to actually add it in there?
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 17, 2012, 02:39:26 AM
I just looked through the file and don't see that line..though I could have missed it. 
I saw one line that had $debug = true and that was it.

I'll wait to change anything until I find out if the line is there somewhere or if I have to add it in somewhere.
Title: Re: phpdvdprofiler
Post by: FredLooks on June 17, 2012, 02:58:43 AM
No, it won't be there - go ahead and just add it...
Title: Re: phpdvdprofiler
Post by: Jimmy on June 17, 2012, 03:56:55 AM
I am uncertain if this will always work with the re-starting changes I made in the last couple of releases.
I use the partial xml file and it always work me without problems.
Title: Re: phpdvdprofiler
Post by: FredLooks on June 17, 2012, 04:28:27 AM
The recovery strategy will fail if an update times out, and you put in a new XML file before it can continue and complete ... I think I can code around that (admittedly rare) case...
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 17, 2012, 07:39:39 AM
I tried adding that...as far as I can tell, there is no new button.

Maybe Sebestian has to do it since he's doing the hosting.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 17, 2012, 07:49:45 AM
Ok...when I looked closer, it looked like the update hadn't completely finished, so I did it again...and got this error message whatever the heck it means.

Fatal error: SQL ERROR [ mysql ]

MySQL server has gone away

CALLING PAGE

/phpdvdprofiler/index.php&

SQL

UPDATE DVDPROFILER_dvd SET collectiontype=realcollectiontype WHERE realcollectiontype!='Wish List' AND realcollectiontype!='ordered'
in /home/dvdalist/public_html/dragonfire.dvdalistic.com/phpdvdprofiler/mysql.php on line 455
Title: Re: phpdvdprofiler
Post by: FredLooks on June 17, 2012, 08:58:55 AM
That error would happen if there was a connectivity issue between your program and the SQL server.

there is definitely something odd going on ... Some queries (like the regular display-the-ui ones) work just fine. Some of the others (like the debug ones such as action=UpdateStatus) seem to time-out.

I'll try to look again in the (my) morning ... I'm finding debugging to be challenging on the iPad :)
Title: Re: phpdvdprofiler
Post by: RossRoy on June 19, 2012, 05:05:02 PM
For the record I always have the complete up to date XML in a single file on the server - I use Rsync to update my online data (XML and images).

I just looked through the sites - I'm running 3.8.0.0, Jimmy is running 3.8.0.0, but Marie's is running 3.7.2.0 because otherwise, her collection doesn't show.

Title: Re: phpdvdprofiler
Post by: FredLooks on June 19, 2012, 07:35:05 PM
Right. I initially mis-read the version number of Marie's collection as 3.7.2.2, rather than 3.7.2.0.  That explains why a bunch of the tests I had been trying didn't work; that version didn't have those changes. Which is why Marie didn't see the Debug button on the UI - it isn't in her version. Fine.

Just FYI, the software has had the ability to give limited diagnostics for quite a long time: the software does different things with different action= parameters and two of them are action=info which gives a one-liner about the versions of things (software,MySQL db, php, and the date of the XML file) and action=phpinfo which just launches the phpinfo() builtin. For those cases where the user can't create a phpinfo script for me :)

I'd like to attack these problems sequentially rather than in parallel - I'm very likely to confuse myself if I try to do them all at once ...

I think Jimmy said his installation is working correctly/ In which case we can use it as a reference site for your machine.

I'll send you an email outlining how I'd like to proceed...
Title: Re: phpdvdprofiler
Post by: FredLooks on June 21, 2012, 07:00:19 PM
Ok, I think that we have RossRoy and Marie up-to-date and working properly now. Just post if there are any more issues...
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 22, 2012, 05:56:30 AM
The list isn't showing up for me again.  I tried a full update and that didn't seem to fix it.
Title: Re: phpdvdprofiler
Post by: Jimmy on June 22, 2012, 06:21:14 AM
Are you sure Marie? I just watched and everything looked normal to me as you can see in the image.

Did you tried to clean your web browser cache? Sometimes it's the problem (same thing happen to me not so long ago with the DVDP online database)
Title: Re: phpdvdprofiler
Post by: RossRoy on June 22, 2012, 02:11:48 PM
It happened to me too. I refreshed a few times from Firefox, and the list wouldn't show. I switched to Internet Explorer and everything was fine again. Switched back to Firefox and lo and behold it was working.

SOmething fishy is going on, but it's probably at the host's level. Something kills the process, but what does? I don't know..
Title: Re: phpdvdprofiler
Post by: Tom on June 22, 2012, 05:42:14 PM
I had a similar problem when Firefox 12 was released. The HTML collection exported by my CCViewer also had a disappearing list.
This helpful hint (http://www.invelos.com/Forums.aspx?task=viewtopic&topicID=16649&PageNum=12&messageID=1743235#M1743235) fixed it for me. Maybe something similar is the case here.
Title: Re: phpdvdprofiler
Post by: FredLooks on June 22, 2012, 07:11:58 PM
It happened to me too. I refreshed a few times from Firefox, and the list wouldn't show. I switched to Internet Explorer and everything was fine again. Switched back to Firefox and lo and behold it was working.

SOmething fishy is going on, but it's probably at the host's level. Something kills the process, but what does? I don't know..

I've been trying with FF13, but I'm not seeing the issue - there could be something related to network latency, I guess, but ...

When you get the problem, can you grab a screen shot? I want to make sure that I'm thinking of the problem correctly ...

I notice that the javascript console is whining about the frameset stuff ... let me eplore that a little ...
Title: Re: phpdvdprofiler
Post by: RossRoy on June 22, 2012, 09:35:06 PM
That didn't take long  ;)

TitlesPerPage is currently set at 100 for the below screenshot.

Edit:

If I set the TitlesPerPage once at 1 (using the "for" debug link) it shows a single movie on the left. Set it back to default? Everything works as expected.
Title: Re: phpdvdprofiler
Post by: FredLooks on June 22, 2012, 10:34:30 PM
Hmmm. There is some bad HTML in there ...

Would you mind trying the following:
change around line 1419 of index.php
Code: [Select]
       echo <<<EOT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN">
<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=windows-1252">
  <title>$CurrentSiteTitle</title>
  $rssfeed
  <script type="text/javascript" src="top.js"></script>
<script type="text/javascript">
<!--
        if (screen.width <= 800)
                document.write('<frameset id="thecols" cols="$widthle800,*" $nomove><frameset id="therows" rows="112,*" border=0 frameborder=0 framespacing=0>');
        else
                document.write('<frameset id="thecols" cols="$widthgt800,*" $nomove><frameset id="therows" rows="*,1" border=0 frameborder=0 framespacing=0>');
//-->
</script>
</head>

    <frame src="$PHP_SELF?sort=$sort&amp;order=$order&amp;collection=$collection&amp;searchby=$searchby&amp;searchtext=$searchurl&amp;action=nav" name="nav" scrolling=no framespacing=0 marginheight=2 marginwidth=2>
    <frame src="$PHP_SELF?sort=$sort&amp;order=$order&amp;collection=$collection&amp;searchby=$searchby&amp;searchtext=$searchurl&amp;action=menu" name="menu" scrolling=yes framespacing=0 marginheight=0 marginwidth=0>
  </frameset>
  <frame src="$mobilepage?mediaid=$lastmedia&amp;action=show" framespacing=0 marginheight=0 marginwidth=0 name="entry">
</frameset>
</html>

EOT;

to
Code: [Select]
       echo <<<EOT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN">
<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=windows-1252">
  <title>$CurrentSiteTitle</title>
  $rssfeed
  <script type="text/javascript" src="top.js"></script>
</head>
<frameset id="thecols" cols="$widthgt800,*" $nomove>
  <frameset id="therows" rows="*,1" border=0 frameborder=0 framespacing=0>
    <frame src="$PHP_SELF?sort=$sort&amp;order=$order&amp;collection=$collection&amp;searchby=$searchby&amp;searchtext=$searchurl&amp;action=nav" name="nav" scrolling=no framespacing=0 marginheight=2 marginwidth=2>
    <frame src="$PHP_SELF?sort=$sort&amp;order=$order&amp;collection=$collection&amp;searchby=$searchby&amp;searchtext=$searchurl&amp;action=menu" name="menu" scrolling=yes framespacing=0 marginheight=0 marginwidth=0>
  </frameset>
  <frame src="$mobilepage?mediaid=$lastmedia&amp;action=show" framespacing=0 marginheight=0 marginwidth=0 name="entry">
</frameset>
</html>

EOT;

That fixes some bad HTML and removes a problem that FireFox has with trying to optimize the page. It coincidentally removes the code which distinguishes between clients having screens smaller than 800 pixels in width. I suspect that code is superfluous, but I can always stuff it back in if it's needed. It would be nice if it resolved the situation, though ...

And when you get the problem, do you see any errors in the console (Ctrl-Shift-K)?
Title: Re: phpdvdprofiler
Post by: DSig on June 22, 2012, 11:56:04 PM
FredLooks,

I 'assume' that phpDvdProfiler is your baby and that the site 'http://dvdaholic.me.uk/forums/' is yours.  If this is the case, I tried to sign up for your site 17th of june and got an email that it had to be approved.  As of this post it hasn't been approved.  Do you know how long this process normally takes.  I would like to get more information on phpDvdProfiler and wanted to post to the forum but of course I can't.

Thanks
DSig
Title: Re: phpdvdprofiler
Post by: FredLooks on June 23, 2012, 01:03:32 AM
Well, assumption #1 is correct, but #2 is not. Dvdaholic is Andy's site, and he's been missing in action for a while. I think it'll be ok with Karsten if you ask questions in this thread, though... Or you can always email me - fred@bws.com
Title: Re: phpdvdprofiler
Post by: Achim on June 23, 2012, 03:04:49 AM
Ok, I think that we have RossRoy and Marie up-to-date and working properly now. Just post if there are any more issues...
Having seen this thread I held back updating; I also use Site5.. Well, also because you said a follow up release might come shortly. My question is, will there be another update soon incl. any modifications you have one or this? And if the next update is not soon-ish, what would I need (to know) before updating my site?

Let me say thank you one more time for all your great work on this project.
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 23, 2012, 03:40:43 AM
It isn't loading right for me in Firefox.  I tried in Exploer, and it works there.  I tried Firefox again, and it still isn't right.

I'll go try some other stuff...

I tried to get a screencap of what it looks like here. 

(http://i96.photobucket.com/albums/l186/dragonfire88a/Miscellaneous/screencap.jpg)
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 23, 2012, 04:06:58 AM
I'm back...
It looks like normal now.  I got rid of some cookies and cleared the cache..once I found it again....I forgot where Firefox had that option at ...  :laugh: :laugh:  Anyway, I did that and it is looking right again.

Thanks for all the help...Sorry for the trouble.
Title: Re: phpdvdprofiler
Post by: RossRoy on June 23, 2012, 04:14:23 AM
Actually I just did the change proposed by Fred on both your site and mine - and yes, it seems to have fixed it for now.  ;D
Title: Re: phpdvdprofiler
Post by: Dragonfire on June 23, 2012, 04:23:17 AM
Ahh..ok.  Well it is working now.  So that's good.

I did just go to upload a file that I've been holding off on for a few days...got this error message at first..

JavaScript Error: Error loading script at line number 1. Please post this info on dvdaholic.me.uk/forums/

I still did the update, and I think it ran fine.
Title: Re: phpdvdprofiler
Post by: DSig on June 23, 2012, 05:15:09 AM
Well, assumption #1 is correct, but #2 is not. Dvdaholic is Andy's site, and he's been missing in action for a while. I think it'll be ok with Karsten if you ask questions in this thread, though... Or you can always email me - fred@bws.com
1) Where is there documentation dealing with requirements for this plugin (php level, db ..  any other considerations)
2) Where are there install instructions
3) documentation dealing with any options/switches (there are always options and switches :)
4) Where is the link for the newest download.  It cant be the first page as it goes to a page dated 2010.

Thanks
Dsig
Title: Re: phpdvdprofiler
Post by: Achim on June 23, 2012, 06:06:18 AM
1) Where is there documentation dealing with requirements for this plugin (php level, db ..  any other considerations)
2) Where are there install instructions
3) documentation dealing with any options/switches (there are always options and switches :)
4) Where is the link for the newest download.  It cant be the first page as it goes to a page dated 2010.
1) + 2) There is no actual documentation, but the forum you found (that Andy is unavailable to approve you for) will give you plenty information and Fred is always helpful. For installation user johnd prepared this, although it might not be 100% up to date:
http://www.johnd.com.au/installingphpdvdprofilerV3/index.htm (http://www.johnd.com.au/installingphpdvdprofilerV3/index.htm)
3) Most settings are done in a file called localsiteconfig.php and are explained with a few comments. Last time I looked there was a few unexplained, but often even their name is self explanatory. If there are still questions, just ask here.
4) The download is only available in the other forum when logged in. But on page 16 Fred posted a direct link as well, which I repeat for your convenience: Here. (http://www.bws.com/phpdvdprofiler.zip)
Title: Re: phpdvdprofiler
Post by: DSig on June 23, 2012, 06:32:43 AM
Thanks for the quick reply.  1 and 2 are the most important <G> so i hope that fred will pop in with some quick info

Thanks again
DSig
Title: Re: phpdvdprofiler
Post by: FredLooks on June 23, 2012, 07:40:02 PM
Actually I just did the change proposed by Fred on both your site and mine - and yes, it seems to have fixed it for now.  ;D

Well, it seemed to be a little sporadic, so keep me posted if it repeats ...
Title: Re: phpdvdprofiler
Post by: FredLooks on June 23, 2012, 07:47:35 PM
Ahh..ok.  Well it is working now.  So that's good.
Good to hear. Please let me know of any other repeats

Quote
I did just go to upload a file that I've been holding off on for a few days...got this error message at first..

JavaScript Error: Error loading script at line number 1. Please post this info on dvdaholic.me.uk/forums/

I still did the update, and I think it ran fine.

That's the most annoying error. It is basically the browser's way of saying "I had a problem, but I don't think I should give you any information about it". It says that there was some unspecified error loading some unspecified script. One would expect that it is the main updater script, but that appears to then work with the update. If it told us a little more about the problem it had it would be possible to investigate.

If you get this again and are keen to try to debug :) , it would be interesting to see what the Javascript Console says. Pressing Ctrl-Shift-K should bring up the Console, where you can see what it thinks the errors are.
Title: Re: phpdvdprofiler
Post by: FredLooks on June 23, 2012, 08:05:26 PM
Basically, what Achim said. Additional comments:
1) Where is there documentation dealing with requirements for this plugin (php level, db ..  any other considerations)
Inside the zip file, phpdvdprofiler-install.txt. Basically it requires PHP (>4.0.3), MySQL (any version), a webserver that will process PHP, and which has sufficient storage for the XML file produced by the Windows program and the image files which you want to display. The image files are not strictly required.
Quote
2) Where are there install instructions
Inside the zip file, phpdvdprofiler-install.txt. These are, uhhh, terse, yes, terse instructions, and the website Achim mentioned is a much more detailed assist. And I'm generally available to help, as are others.
Quote
3) documentation dealing with any options/switches (there are always options and switches :)
I would like to think that they are documented in the siteconfig.php file. Sadly, they are only mostly (ok, partially) documented there. There are a large number of switches affecting the behaviour of the program. In most cases the defaults are good. I'm pretty certain that the switches that I have not gotten around to documenting are mostly for helping people who had specific issues. (For those who want to see the true gore, globalinits.php has the complete set of switches, with the defaults)
Quote
4) Where is the link for the newest download.  It cant be the first page as it goes to a page dated 2010.
As Achim noted: this is always the current version (http://www.bws.com/phpdvdprofiler.zip)
Title: Re: phpdvdprofiler
Post by: DSig on June 23, 2012, 09:07:42 PM
Thanks again.  This is the info i needed

DSig
Title: Re: phpdvdprofiler
Post by: FredLooks on June 27, 2012, 07:38:08 PM
OK, for those who are experiencing the so-called "Loading" problem, could you try to clear your cache (on FireFox, that is accessible from the menu item FireFox->Options->Advanced and there is a button to clear your content cache)

This has sorted things out for others, so I'm just trolling to see if there are any problems remaining once this has been done ...

Thanks in advance
Title: Re: phpdvdprofiler
Post by: BigTim on June 28, 2012, 10:15:40 AM
Thanks for your TIRELESS EFFORT! FredLooks! I was one of those experiencing the "LOADING" Problem.  I uninstalled, reinstalled, used different versions... Firefox kept calling on that BAD CACHE.  Do as he recommends.  Took 5 seconds and straightened me out!  Amazing troubleshooting!  BOO YAH!!!!!!!!!

Big Tim
Title: Re: phpdvdprofiler
Post by: FredLooks on July 02, 2012, 10:14:37 PM
OK, I've released a new version which is compatible with 3.8.1 ... it's in the usual place on dvdaholic (http://dvdaholic.me.uk/forums/index.php?topic=807.0), and the bws (http://www.bws.com/phpdvdprofiler.zip) download is also active. The fixes discussed here have been incorporated, and there is no schema change required (I saw where Ken was headed with color, and made that part of the schema compatible)
Title: Re: phpdvdprofiler
Post by: Jimmy on September 06, 2012, 09:47:14 PM
I have an error message (http://www.aesppres.com/phpdvdprofiler/index.php?mediaid=654930314395&action=show) on my online collection display and from what I understand the country is responsible for this.

Is there a solution or I must wait for an update?
Title: Re: phpdvdprofiler
Post by: Achim on September 07, 2012, 06:12:38 AM
Serbia is not defined in phpDVDProfiler. Is it available in DVD Profiler...?

While it would be possible to make some amendments to fix the issue temporarily in teh end fred must add Serbia to the list of countrie sto make this go away.

The CIA have an image of the the Serbian flag on their website. (https://www.cia.gov/library/publications/the-world-factbook/docs/flagsoftheworld.html)
Title: Re: phpdvdprofiler
Post by: Jimmy on September 07, 2012, 02:31:40 PM
Serbia is not defined in phpDVDProfiler. Is it available in DVD Profiler...?
Yes it is. Even The Vatican is now there... but do they really do movies :shrug:
Title: Re: phpdvdprofiler
Post by: FredLooks on September 08, 2012, 05:52:12 PM
Yeah, ken went to a different format, distinguishing between locales and countries. I added support for that in the last release. Unless you have customized the code on your site, you should just be able to overwrite your existing code with the latest release... The latest is 3.8.1.0, and you are 1 release back at 3.8.0.0...
Title: Re: phpdvdprofiler
Post by: Jimmy on September 08, 2012, 06:03:09 PM
Thanks. I was sure I was up to date, I'll get the last version.

Edit : Update done and everything is fine ;D
Title: Re: phpdvdprofiler
Post by: FredLooks on September 08, 2012, 11:15:17 PM
excellent!
Title: Re: phpdvdprofiler
Post by: DSig on October 15, 2012, 06:37:28 AM
Fred, I finally got the time to install this and I have to say I am very impressed .. it looks very nice.  I am very sad that it looks like there wont be much for me to hack :)

Environment:  windows 7, Apache 2.2.22, PHP 5.3.13, MySql 5.5.24

I have a couple of questions

Import:
During the import I got several of the following .. (about 50-60 of these).  Where does the "ID" come from?

collection.xml: Profile IDs must not be blank. Profile #1971

I also got the following .. In all cases (41) the boxsets did have children

Bad Boxsets: profiles saying they contain children when the children are absent from the collection
Bad Boxset: The Virginian: The Complete First Season (011301649454)
...
...
Total number of incorrect Box Set entries removed: 50
Number of incorrect Box Set profiles modified: 41


Site Statistics
Lots of great information, but under a lot of the headings, for example table with Last 12 Months etc, there appears to be "button" locations.  But there is no image and unable to 'click'

Also, the 'years' appear to be hyper links but when i click on them nothing happens.

Watched Statistics
When this page (on the right) comes up I get 4 sections with

Warning: include(../jpgraph/srcjpgraph.php) [<a href='function.include'>function.include[/url]]: failed to open stream: No such file or directory in C:\wamp\www\phpdvdprofiler\ws.php on line 217

My guess is that this is something to do with my install of jpgraph but i am not able 'yet' to see what it is.  I am still looking and probably just overlooking it.

Ideas on these would be greatly appreciated .. sure it is my oversite

Once again .. great hack
Title: Re: phpdvdprofiler
Post by: DJ Doena on October 15, 2012, 07:40:31 AM
Dsig, it looks like you should do a database repair in DVDP and then export the XML again.

If the errors persist, we should take a closer look at them.
Title: Re: phpdvdprofiler
Post by: DSig on October 15, 2012, 04:37:56 PM
:) ... the first step in anything dvdprofiler .. fix the database :)  okay .. will do
Title: Re: phpdvdprofiler
Post by: DSig on October 15, 2012, 05:11:45 PM
Yep .. i should have remembered .. if in doubt it's DvdProfiler  :hysterical:

Fixed the database, ran the update and didn't get any messages .. not sure that it did anything as it only took 7 seconds this time but like i said.  There were no import errors.

Now for the other problems .. .

Thanks for the reminder
Title: Re: phpdvdprofiler
Post by: DSig on October 15, 2012, 09:05:50 PM
Fred .. i should have included.

With the error messages of the INCLUDE.  I have tried several settings for $jpgraphlocation, but the default one, and the one I am using is

$jpgraphlocation   = '../jpgraph/scr/';

I am using WAMP and the location of jpgraph and phpDVDProfiler is

\wamp\www\jpgraph
\wamp\www\phpDVDProfiler

The current error is

( ! ) Warning: include(../jpgraph/scr/jpgraph.php) [<a href='function.include'>function.include[/url]]: failed to open stream: No such file or directory in C:\wamp\www\phpdvdprofiler\ws.php on line 217

Just as if jpgraph wasn't at the same level as phpDVDProfiler.

This has to be something simple that I am over looking but not finding it.

Ideas welcomed ..
Title: Re: phpdvdprofiler
Post by: FredLooks on October 15, 2012, 10:27:26 PM
Fred, I finally got the time to install this and I have to say I am very impressed .. it looks very nice.  I am very sad that it looks like there wont be much for me to hack :)
Oh, I expect you'll find something :)
Quote
Import:
During the import I got several of the following .. (about 50-60 of these).  Where does the "ID" come from?

collection.xml: Profile IDs must not be blank. Profile #1971
The ID is the ordinal of the profile in the XML file. By that I mean that the first one is #1, second #2, etc. For the most part, Profiles are stored in ID order in the XML file.

Quote
I also got the following .. In all cases (41) the boxsets did have children

Bad Boxsets: profiles saying they contain children when the children are absent from the collection
Bad Boxset: The Virginian: The Complete First Season (011301649454)
...
...
Total number of incorrect Box Set entries removed: 50
Number of incorrect Box Set profiles modified: 41
Sometimes the Box-children fields and the profiles don't match up. Generally a db issue, as you discovered. If it persists, it means that the named profiles have a number of child profiles listed, and the child profiles aren't in the XML collection. Simply going into the boxset menu in the windows program for the afflicted profile generally solves it ...
Quote
Site Statistics
Lots of great information, but under a lot of the headings, for example table with Last 12 Months etc, there appears to be "button" locations.  But there is no image and unable to 'click'

Also, the 'years' appear to be hyper links but when i click on them nothing happens.
This will all make sense when the jpgraph stuff works :)  If you look at my site, you can see that the clickable links make new graphs appear....
Quote
Watched Statistics
When this page (on the right) comes up I get 4 sections with

Warning: include(../jpgraph/srcjpgraph.php) [<a href='function.include'>function.include[/url]]: failed to open stream: No such file or directory in C:\wamp\www\phpdvdprofiler\ws.php on line 217

My guess is that this is something to do with my install of jpgraph but i am not able 'yet' to see what it is.  I am still looking and probably just overlooking it.

Yup, you need a trailing '/' (as you discovered yourself) and the path is relative to the phpdvdprofiler directory. So if you put jpgraph "into" the phpdvdprofiler directory, then $jpgraphlocation = "jpgraph/src/"; should work. It should point to the directory containing jpgraph.php

Keep me posted
Title: Re: phpdvdprofiler
Post by: DSig on October 15, 2012, 11:56:34 PM
You must not of had a chance to read my last reply before answering but

The directories are on the same level.  So they are

\wamp\www\jpgraph
\wamp\www\phpDVDProfiler

And the assignment of $jpgraphlocation as

$jpgraphlocation   = '../jpgraph/scr/';

should work.

Not sure why you say "So if you put jpgraph "into" the phpdvdprofiler directory, then $jpgraphlocation = "jpgraph/src/"; should work. It should point to the directory containing jpgraph.php" but I will move it into that directory and try that.

Thanks
Title: Re: phpdvdprofiler
Post by: DSig on October 16, 2012, 12:12:56 AM
Okay .. i have moved the jpgraph folder under phpdvdprofiler folder so it is like ..

(http://imageshack.us/a/img835/6035/phpdvdprofilerdirectori.jpg)

and changed the assignment as ..


$jpgraphlocation   = 'jpgraph/scr/';


Errors received are basically the same .. entire list ..


( ! ) SCREAM: Error suppression ignored for
( ! ) Warning: include(jpgraph/scr/jpgraph.php) [<a href='function.include'>function.include[/url]]: failed to open stream: No such file or directory in C:\wamp\www\phpdvdprofiler\ws.php on line 217
Call Stack
#   Time   Memory   Function   Location
1   0.0050   1515224   {main}( )   ..\ws.php:0

( ! ) SCREAM: Error suppression ignored for
( ! ) Warning: include() [<a href='function.include'>function.include[/url]]: Failed opening 'jpgraph/scr/jpgraph.php' for inclusion (include_path='.;C:\php\pear') in C:\wamp\www\phpdvdprofiler\ws.php on line 217
Call Stack
#   Time   Memory   Function   Location
1   0.0050   1515224   {main}( )   ..\ws.php:0

( ! ) SCREAM: Error suppression ignored for
( ! ) Warning: include(jpgraph/scr/jpgraph_bar.php) [<a href='function.include'>function.include[/url]]: failed to open stream: No such file or directory in C:\wamp\www\phpdvdprofiler\ws.php on line 218
Call Stack
#   Time   Memory   Function   Location
1   0.0050   1515224   {main}( )   ..\ws.php:0

( ! ) SCREAM: Error suppression ignored for
( ! ) Warning: include() [<a href='function.include'>function.include[/url]]: Failed opening 'jpgraph/scr/jpgraph_bar.php' for inclusion (include_path='.;C:\php\pear') in C:\wamp\www\phpdvdprofiler\ws.php on line 218
Call Stack
#   Time   Memory   Function   Location
1   0.0050   1515224   {main}( )   ..\ws.php:0


As you can see changing that and making the assignment didn't work.  Hmm .. i still know this is something simple as PHP is so literal.
Title: Re: phpdvdprofiler
Post by: Dragonfire on October 16, 2012, 02:05:14 AM
I seem to remember having trouble with that jpgraph thing when I was getting the program set up too.  I can't remember exactly what had to be done to fix it, but I eventually got it after lots of help here. :)

Sorry I can't offer a specific idea.
Title: Re: phpdvdprofiler
Post by: DSig on October 16, 2012, 02:23:42 AM
Thanks for that .. i am sure that there will be some help.

What environment are you using?  windows? xamp/wamp?
Title: Re: phpdvdprofiler
Post by: Dragonfire on October 16, 2012, 05:39:16 AM
I have Windows 7 on this computer.  I had Windows xp on the computer I started using this program on. 

I don't know about about this stuff..Like I said, I need a lot of help.  Now Sebastian is hosting for me - I started having issues with the one I was using..so I pretty much just upload when I get new stuff or to update what I watched.  I can do that much without screwing it up.  Usually.   :hysterical:  I had to redo the images once...I somehow managed to delete them.  Still not sure how I did that.
Title: Re: phpdvdprofiler
Post by: DSig on October 16, 2012, 05:45:48 AM
While i try to figure out the problem I am having .. with the jpgraphic bits .. i have one question.

1) Is there the ability to 'page' the collection listing.  Would be much faster especially when dealing remotely or even by cell phone.

Thanks a lot ..
Title: Re: phpdvdprofiler
Post by: DSig on October 16, 2012, 05:48:36 AM
Okay .. i knew it would be something simple .. it was some kind of cache.  I am not sure what combination as i have restarted the services and the browser .. even rebooted once ..

but it appears to be working .. as it should.

So i just have the 1 question mentioned above for now ..

It is fun sw to play with
Title: Re: phpdvdprofiler
Post by: Achim on October 16, 2012, 06:31:45 AM
I seem to remember having trouble with that jpgraph thing when I was getting the program set up too.
Everybody does :laugh:
Title: Re: phpdvdprofiler
Post by: Jimmy on October 16, 2012, 07:04:50 AM
I didn't :P

But it's because Eric did it all for me :laugh:
Title: Re: phpdvdprofiler
Post by: DJ Doena on October 16, 2012, 07:13:39 AM
1) Is there the ability to 'page' the collection listing.  Would be much faster especially when dealing remotely or even by cell phone.

You mean having only a limited number of movies on the laft hand side? Like mine http://doena-soft.de/phpdvdprofiler_en/ ?

If so, check the localsiteconfig.php for the $TitlesPerPage parameter.
Title: Re: phpdvdprofiler
Post by: FredLooks on October 16, 2012, 02:19:15 PM
1) Is there the ability to 'page' the collection listing.  Would be much faster especially when dealing remotely or even by cell phone.

You mean having only a limited number of movies on the laft hand side? Like mine http://doena-soft.de/phpdvdprofiler_en/ ?

If so, check the localsiteconfig.php for the $TitlesPerPage parameter.

This can also be changed dynamically by clicking on the word "for" in the upper-left frame, between the two combo-boxes...
Title: Re: phpdvdprofiler
Post by: DSig on October 16, 2012, 04:12:54 PM
1) Is there the ability to 'page' the collection listing.  Would be much faster especially when dealing remotely or even by cell phone.

You mean having only a limited number of movies on the laft hand side? Like mine http://doena-soft.de/phpdvdprofiler_en/ ?

If so, check the localsiteconfig.php for the $TitlesPerPage parameter.
Thanks for that .. i would have bet it was in there somewhere
Title: Re: phpdvdprofiler
Post by: DSig on October 16, 2012, 08:35:40 PM
MOD: How-to define number of Titles displayed determined on device type
Edited 16oct12 15:48 PT using suggestions from FredLooks

First .. disclaimer .. I really like phpDVDProfiler.  It is a great hack and so far it appears to be very well supported by community and by FredLooks.  This is just an extension that I wanted and thought I would share.  But please .. this requires a change to your phpDVDProfiler's localsiteconfig.php file.  Be sure to back it up before proceeding.  If you have problems I will be happy to try and help.  Also if you have any suggestions please let me know.  Although I have done a lot of php programming .. it has been several years/releases ago .. but my ego isn't fragile  ;D

The Opportunity
I didn't like just setting the $TitlesPerPage to a specific number because I might access the site from my phone or tablet or computer (desktop and laptop).

So to speed up the retrieval times for phone and tablet I wanted this value to be set according to device type.

I found a class called "Mobil-Detect" and it's home page is located here (https://github.com/serbanghita/Mobile-Detect).  Installation is pretty simple and there is a demo program available also.  I would suggest that you install the demo program so you can be sure that it all working before making any change to phpDVDProfiler.

My Installation Steps for Mobile-Detect:

Installation Steps for Mobile-Detect's Demo program
Code: [Select]
require_once '/MobileDetect/Mobile_Detect.php';
If you are playing with the demo (and you should!) you should be able to simply enter "localhost/test-mobile-detect.php" into your browsers address bar.  If you are not working on the webserver then replace "localhost" with the address of your server.

Okay .. Changes required to phpDVDProfiler to make this all work

If you have an existing localsiteconfig.php in the phpDVDProfiler directory.  If you don't have this file .. the easiest thing to do is so simply copy the siteconfig.php file to the localsiteconfig.php file in the phpdvdprofiler folder.

FredLooks has suggested that any setup/configuration information should be made to the localsiteconfig.php and not to the siteconfig.php file, as the siteconfig.php file maybe/will be overwritten by updates to phpDVDProfiler.  For this reason all 'local site specific' information should reside in the localsiteconfig.php.  This is also where we will be putting our code for the Mobile-Detect mod.

Once you have the localsiteconfig.php file you will need to add the following code at the end of the file, before the line with  "?>".
Code: [Select]
<?php
// 16Oct12 - dsig  - added Mobile Detect function so can tell size to display
require_once("../MobileDetect/Mobile_Detect.php");
$detect = new Mobile_Detect;
$deviceType = ($detect->isMobile() ? ($detect->isTablet() ? 'tablet' 'phone') : 'computer');

// set according to 'type'
switch ($deviceType) {
case "tablet":
// this is the number of titles to load/display if a tablet device
$TitlesPerPage 60;
break;
case "phone":
// this is the number of titles to load/display if a phone device
$TitlesPerPage 40;
break;
case "computer":
// this is the number of titles to load/display if a computer device
$TitlesPerPage 0;
break;
}

?>


NOTE: Be sure to get all the code.  Sometimes the 'code window' will have a slider ..

Does it work?
If the demo worked .. and if you pasted this code in correctly .. you should now be able to access phpDVDProfiler from any of the devices and have only that number of titles appear.

IMPORTANT: These instructions expect that the folder structure is as defined.  So for any system, the 'htdocs' folder (folder where all the web pages go (including subfolders) is the 'root' folder.  In this folder you should see phpdvdprofiler.  This is the directory where you create the new folder MobileDetect.

If you have any problems or suggestions please let me know.

Title: Re: phpdvdprofiler
Post by: FredLooks on October 16, 2012, 10:50:31 PM
well, rather than changing siteconfig.php (which is over-written on every release), you could simply put that code you suggested (require_once and all) into localsiteconfig.php, which is the file that is guaranteed not to be over-written. [global.php includes siteconfig.php and then includes localsiteconfig.php to override the defaults]

[not directed at you, Dsig, but to others wanting to "play"):
If localsiteconfig.php doesn't exist, it should, so create one (with <?php at the first line and ?> as the last line) and stick this code in there. In particular, the values for your database name and username and password, as well as any configuration values that differ from siteconfig.php should be in there. That will make installation of a new release easy-peasy, assuming you haven't hacked on the rest of the code.

If you have, then you likely don't need me telling you how to go about your business :laugh:
Title: Re: phpdvdprofiler
Post by: DSig on October 17, 2012, 12:08:04 AM
Cool .. I will make the change and update my post to use the suggested file.

Could you update the dvdprofiler_on_windoze.txt file to make this recommendation.  dvdprofiler_on_windoze.txt is the file i used to set it up .. since i am on .. windoze.  It has a lot of detail setup information and not a mention of creating a copy of siteconfig.php.

Thanks for the info ..
Title: Re: phpdvdprofiler
Post by: DSig on October 17, 2012, 04:54:42 PM
To see how this works you can access my collection here (http://71.237.230.29/phpdvdprofiler)

Try it with your phone or tablet

Dsig
Title: Re: phpdvdprofiler
Post by: DSig on October 17, 2012, 08:08:25 PM
FredLooks, or anyone else who knows.

There is a Misc. section on the right that includes IMDb.

Is it possible to add a Wikipeida link.  I very much enjoy the large amount of information that wikipedia has and the numerous segways to other information.

For example, if i was looking at the move "I Am Legend" by "Will Smith" the link would be
Code: [Select]
http://en.wikipedia.org/wiki/I_Am_Legend

If you don't want to deal with this could you point me in the right direction ..

Thanks
Title: Re: phpdvdprofiler
Post by: FredLooks on October 17, 2012, 10:11:16 PM
FredLooks, or anyone else who knows.

There is a Misc. section on the right that includes IMDb.

Is it possible to add a Wikipeida link.  I very much enjoy the large amount of information that wikipedia has and the numerous segways to other information.

For example, if i was looking at the move "I Am Legend" by "Will Smith" the link would be
Code: [Select]
http://en.wikipedia.org/wiki/I_Am_Legend

If you don't want to deal with this could you point me in the right direction ..

Thanks

Actually, the windows program allows you to specify links in a number of subject areas relating to each Movie. These links are exported to the XML, and I put them into that area of the profile. You can see this on, for example, this Return of the Jedi profile (http://www.bws.com/phpdvdprofiler/?lastmedia=IF45A5749D9DC71C7). That's a rather extreme case, other profiles have far fewer links ... so you could put wikipedia entries into the windows program and they would be reflected in the phpdvdprofiler display.
Title: Re: phpdvdprofiler
Post by: Dragonfire on October 21, 2012, 07:05:56 AM
Well my signature seems to be messed up..all I did was upload a few new profiles.  There was an error message on that - I'll paste it  - and then I looked and the signature seems to be gone. 

Help.

Warning: imagettfbbox() [function.imagettfbbox]: Could not find/open font in /home/dvdalist/public_html/dragonfire.dvdalistic.com/phpdvdprofiler/ws.php on line 1631

Warning: imagettfbbox() [function.imagettfbbox]: Could not find/open font in /home/dvdalist/public_html/dragonfire.dvdalistic.com/phpdvdprofiler/ws.php on line 1648

Warning: imagettftext() [function.imagettftext]: Could not find/open font in /home/dvdalist/public_html/dragonfire.dvdalistic.com/phpdvdprofiler/ws.php on line 1699

Warning: imagettftext() [function.imagettftext]: Could not find/open font in /home/dvdalist/public_html/dragonfire.dvdalistic.com/phpdvdprofiler/ws.php on line 1712
Title: Re: phpdvdprofiler
Post by: DJ Doena on October 21, 2012, 07:11:20 AM
Well my signature seems to be messed up..all I did was upload a few new profiles.  There was an error message on that - I'll paste it  - and then I looked and the signature seems to be gone. 

Help.

Warning: imagettfbbox() [function.imagettfbbox]: Could not find/open font in /home/dvdalist/public_html/dragonfire.dvdalistic.com/phpdvdprofiler/ws.php on line 1631

Warning: imagettfbbox() [function.imagettfbbox]: Could not find/open font in /home/dvdalist/public_html/dragonfire.dvdalistic.com/phpdvdprofiler/ws.php on line 1648

Warning: imagettftext() [function.imagettftext]: Could not find/open font in /home/dvdalist/public_html/dragonfire.dvdalistic.com/phpdvdprofiler/ws.php on line 1699

Warning: imagettftext() [function.imagettftext]: Could not find/open font in /home/dvdalist/public_html/dragonfire.dvdalistic.com/phpdvdprofiler/ws.php on line 1712


For some reason one of the font files seems to be missing (e.g. Tahoma, Arial).

First check your localsiteconfig.ph at the very end where you have defined your banners what kind of font your have assigned (it's one of the parameters of your banner).

Then you have to check the location of your jpgraph folder, which is defined in the same file as
Code: [Select]
$usejpgraph = true;
$jpgraphlocation = ...

And then you have to go to that jpgraph folder in your FTP if your font is actually in the folder jpgraph/fonts/truetype
Title: Re: phpdvdprofiler
Post by: Dragonfire on October 21, 2012, 10:36:48 AM
Here's what I have for font.

"font" => "comic.ttf"


Here's what I found for that jpgraph thing.... is this what you mean?

//$usejpgraph      = true;
$usejpgraph      = true;
$jpgraphlocation   = 'jpgraph/';
$GDFontPathOverride = 'jpgraph/fonts/truetype';
$localemin      ='0.05';


Where is the jpgraph folder supposed to be?  In the phpdvdprofiler? 
The FTP...is that the program I use to upload profiles? 
I can't find the jpgraph in the directory thing there.  Or anything for fonts.  Unless I'm looking in the wrong place.

Is this something that has to be done at the host?  Do I need to send Sebastien a message for him to check something since he's hosting this stuff for me?

Sorry for all the questions.  This stuff just gets me confused..  I have no idea how I managed to screw it up this time.  :(
Title: Re: phpdvdprofiler
Post by: Jimmy on October 21, 2012, 12:05:57 PM
Where is the jpgraph folder supposed to be?  In the phpdvdprofiler? 
phpdvdprofiler/jpgraph/fonts/truetype
 
The last two bolded are where your fonts are

The FTP...is that the program I use to upload profiles? 
No this is the server where your files are, in your case it's your space on Sebastien's website (dragonfire.dvdalistic.com)
 
Do I need to send Sebastien a message for him to check something since he's hosting this stuff for me?
Personally I would let him know as he corrects the problem very fast when we have one.

I have no idea how I managed to screw it up this time.  :(
It's even stranger as we never go in those parts usually, at least I don't as I only put files on the main folder (phpdvdprofiler) and the images sub-folder.

BTW your watched banner works if we check your collection online, but it seems to be a problem with your ws.php file (lines 217 and 218).
Title: Re: phpdvdprofiler
Post by: DJ Doena on October 21, 2012, 12:14:30 PM

The FTP...is that the program I use to upload profiles?
No this is the server where your files are, in your case it's your space on Sebastien's website (dragonfire.dvdalistic.com)


[IT Nerd]

Neither. ;)

FTP = File Transfer Protocol

[/IT Nerd]

What I meant was you have to open the program with which you upload the file and then browse on your remote location for your jpgraph folder. It's either in the phpdvdprofiler folder or on the same level as phpdvdprofiler. In there has to be a fonts folder and in there a truetype folder.
Title: Re: phpdvdprofiler
Post by: FredLooks on October 21, 2012, 01:45:04 PM
Hi Marie,

The problem is that your jpgraph directory has gone missing.

Your localsiteconfig.php contains the $GDFontPathOverride variable, which means that we had once done testing to find fonts for you. The directory it specifies indicates that you had jpgraph installed inside your main phpdvdprofiler directory (which is fine, of course).

Sadly, that directory is no longer there (or more precisely, the webserver can see no such directory there - it could be there with no permissions for the webserver to read it)

Perhaps Sébastien has been cleaning up and removed a perceived duplicate directory? I don't see it up a level ("beside" the phpdvdprofiler directory) either, so likely asking Sébastien is the way to go here.

Sorry I couldn't be more help ...
Title: Re: phpdvdprofiler
Post by: Dragonfire on October 21, 2012, 10:56:40 PM
There were problems with the jpgraph when I first got this set up. 

Ok..I'll try sending him a message and see if he can check.

I was looking last night and didn't see a jpgraph folder anywhere..but I wasn't sure I was looking in the right spot.
Title: Re: phpdvdprofiler
Post by: Dragonfire on October 22, 2012, 12:59:10 AM
I fixed it!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Woohoo.  I found a jpgraph folder on my computer and decided to try to upload it.  And it worked.   :yahoo:

Thank you Karsten and Fred...I wouldn't have known what to try if you two hadn't explained the error to me. 

Title: Re: phpdvdprofiler
Post by: FredLooks on October 22, 2012, 03:43:32 AM
Good show. Glad it's working  :clap:
Title: Re: phpdvdprofiler
Post by: Lord Of The Sith on January 16, 2013, 10:16:41 PM
How come when I reach the download page it tells me I need to log in and then why I try to it says my user name doesn't exist?
Title: Re: phpdvdprofiler
Post by: DJ Doena on January 16, 2013, 11:43:31 PM
The phpDVDProfiler forum is a totally different forum, independent of this one. You need your own user account over there.
Title: Re: phpdvdprofiler
Post by: Lord Of The Sith on January 17, 2013, 05:32:12 AM
I need help registering.  Please.

I have a question.  I attempted to register and it is telling me I am answering the region questions incorrectly.  I even went and searched to make sure I was entering the correct info and it still tells me I am wrong can someone help me?

Thanks.
Title: Re: phpdvdprofiler
Post by: DJ Doena on January 17, 2013, 10:17:47 AM
China is region 6 (http://en.wikipedia.org/wiki/DVD_region_code).

Europe is region B (http://en.wikipedia.org/wiki/Blu-ray_region_code#Region_codes), but the registration form apparantly looks for the answer "2" (it's probably a number field or something like that).
Title: Re: phpdvdprofiler
Post by: Lord Of The Sith on January 17, 2013, 11:01:22 PM
I gave those answers and it told me they were incorrect  :weep:
Title: Re: phpdvdprofiler
Post by: DJ Doena on January 17, 2013, 11:16:43 PM
Today I registered a test account with 6 and 2 and it passed just fine. :shrug:
Title: Re: phpdvdprofiler
Post by: Achim on January 18, 2013, 05:49:39 AM
Isn't it still set that Andy needs to approve new users? In which case, that could still be the second hurdle...?

EDIT:

Go to this post (http://www.dvdcollectorsonline.com/index.php/topic,6403.msg115896.html#msg115896) on page 7 of this thread and you will find a link to the download on a different server. IIRC Fred always has the latest version there.
Title: Re: phpdvdprofiler
Post by: FredLooks on January 18, 2013, 03:12:38 PM
Yes, the most recent version of the software is here (http://www.bws.com/phpdvdprofiler.zip). I know that Andy isn't as quite as responsive to registration requests these days, but I'm more than happy to assist here in the interim, if Karsten doesn't mind ...
Title: Re: phpdvdprofiler
Post by: DJ Doena on January 18, 2013, 04:54:05 PM
I don't mind because it has been eaten by a zombie.  :tease:
Title: Re: phpdvdprofiler
Post by: FredLooks on January 18, 2013, 11:16:39 PM
bet that left a mark  :laugh:
Title: New Version 3.8.2.0
Post by: FredLooks on January 26, 2013, 09:16:42 PM
I've done a release rolling up a small number of changes (including an attempt at DJ's image issue :) )

Available on the other site Here (http://dvdaholic.me.uk/forums/index.php?topic=824.0)

Also available Here (http://www.bws.com/phpdvdprofiler.zip), as always, for those who have difficulty getting to the other forum.
Title: Re: phpdvdprofiler
Post by: DSig on July 23, 2013, 04:14:01 AM
Is there any way to get the Actor images?
Title: Re: phpdvdprofiler
Post by: Jimmy on July 23, 2013, 04:44:23 AM
You mean in your online collection? If so yes there is a way, but it's complicated (I think you have to do it image by image). I've never tried it, but maybe someone at the phpDVDProfiler forum (http://dvdaholic.me.uk/forums/index.php) will be able to tell you exactly how to do it. 
Title: Re: phpdvdprofiler
Post by: DSig on July 23, 2013, 05:11:40 PM
You mean in your online collection? If so yes there is a way, but it's complicated (I think you have to do it image by image). I've never tried it, but maybe someone at the phpDVDProfiler forum (http://dvdaholic.me.uk/forums/index.php) will be able to tell you exactly how to do it. 
I was kind of afraid that it would be " ... image by image ...".  I will post over there too.  Thanks
Title: Re: phpdvdprofiler
Post by: Jimmy on July 27, 2014, 07:39:57 AM
Any idea what could be the problem?

Everytime I go to make an update I got an error message, but I can do my update anyway clicking the update grey button...

I got this last week (when I've added my latest purchase tuesday everything was fine). Like I said I can update but I'm sure there is a way to fix this.
Title: Re: phpdvdprofiler
Post by: Jimmy on September 07, 2014, 07:38:03 AM
The problem is now corrected ;D

I suppose you did it Sebastien so a big thank you since it was a little bit annoying :thumbup:
Title: Re: phpdvdprofiler
Post by: RossRoy on September 07, 2014, 03:03:26 PM
Hmmm as far as I know, I didn't do anything :)
But I'm happy it fixed itself!
Probably some sort of glitch on the provider's end.
Title: Where can I get the program and its documentation ?
Post by: surfeur51 on September 24, 2016, 08:13:30 AM
Hello,

I would like to install phpdvdprofiler, but I am unable to find the program and its documentation. I have found several links on this forum and on another site, but none worked... :(

Thanks in advance to give me a working link. :)
Title: Re: Where can I get the program and its documentation ?
Post by: DJ Doena on September 24, 2016, 08:20:47 AM
Hello,

I would like to install phpdvdprofiler, but I am unable to find the program and its documentation. I have found several links on this forum and on another site, but none worked... :(

Thanks in advance to give me a working link. :)

http://www.dvdcollectorsonline.com/index.php/topic,8345.0.html
Title: Re: phpdvdprofiler
Post by: surfeur51 on September 24, 2016, 10:08:49 AM
:thanks:

Now, I have to understand how it works, since I have quite no knowledge in programmation  :-[
Title: Re: phpdvdprofiler
Post by: DJ Doena on September 24, 2016, 11:26:57 AM
Now, I have to understand how it works, since I have quite no knowledge in programmation  :-[

You don't really have to. You only need a webspace that offers PHP and MySQL, then you upload the files from the package and off you go.

If you have Skype I can help you set it up.
Title: Re: phpdvdprofiler
Post by: surfeur51 on September 24, 2016, 03:52:22 PM
You don't really have to. You only need a webspace that offers PHP and MySQL, then you upload the files from the package and off you go.
Yes, I understood that. I prepared my site with DVDAll.xml file and images. I created a site using Hostinger, but I have problems to connect to this site with ftp program. Perhaps free part of the host is very crowded...  :(

Title: Re: phpdvdprofiler
Post by: surfeur51 on September 24, 2016, 06:39:36 PM
Well, I uploaded all my data, but it doesn't work. I get this message :
The connection to database phpdvdprofiler on localhost failed  — Code 1045 —> Access denied for user 'admin'@'10.2.1.25' (using password: YES)
Title: Re: phpdvdprofiler
Post by: DJ Doena on September 25, 2016, 01:04:15 AM
Did you copy the siteconfig.php to localsiteconfig.php and properly adapt username and URL of your database? You should have gotten this from your host provider.

It's these two settings:

$dbhost         = '...';
$dbuser         = '...';
Title: Re: phpdvdprofiler
Post by: surfeur51 on September 25, 2016, 08:02:11 AM
Made your changes, but now I get
The connection to database phpdvdprofiler on ... failed  — Code 2005 —> Unknown MySQL server host '...' (-2)
Title: Re: phpdvdprofiler
Post by: DJ Doena on September 25, 2016, 09:22:58 AM
You weren't supposed to enter ... ;)

You're supposed to enter the host name of your database (your host provider has given you this information in one way or another) and the user name you need to access your own database.
Title: Re: phpdvdprofiler
Post by: surfeur51 on September 25, 2016, 10:39:16 AM
You weren't supposed to enter ... ;)
:-[ :-[ I knew I'm very limited on this...

Well, I can' find the host name of my database. I tried mysql.hostinger.fr , server35.hostinger.fr but it doesn't work. Has this information a specific form ?
Title: Re: phpdvdprofiler
Post by: DJ Doena on September 25, 2016, 05:51:02 PM
When you rent a websapce you usually get a configuration page (online) when you can look up this stuff.

Contact me at karsten [at] yajirobi.de and we'll look over it
Title: Re: phpdvdprofiler
Post by: surfeur51 on September 25, 2016, 11:09:29 PM
Contact me at karsten [at] yajirobi.de and we'll look over it
Thank you very much Karsten for your help.  :thanks:

Now my site is online, http://surfeur51.esy.es/phpdvdprofiler/
 (http://surfeur51.esy.es/phpdvdprofiler/)
But I still have problems. I sent a new collection.xml file, and made an update, but this didn't work well. I got only 35 profiles (should be 2130), with this message:

/phpdvdprofiler/index.php&

SQL

SELECT sid FROM DVDPROFILER_dvd_supplier WHERE suppliername='Magasin spécialisé'
in /home/u407805850/public_html/phpdvdprofiler/mysql.php on line 455
Turning Faster, more memory-intensive updates: off
Posting an update request
Response received for update request ... Handled by Connection Id 85768975
XML file specified is 'collection.xml'
'collection.xml' appears to be a file of type 'DVD Profiler XML'
Faster, more memory-intensive updates: Off
A previous update failed to complete. Missing profile removal turned off.
To remove profiles from the database which are not in the XML file(s),
run a normal (not Complete) update once any update has completed successfully.
Contents of xml collection will be added to database; profiles will be updated but NOT removed.
Importing into database u407805850_dvdp
Resuming an incomplete update — starting 36 profiles (548,200 bytes) into file collection.xml
Current file being processed: collection.xml

Warning: set_time_limit() has been disabled for security reasons in /home/u407805850/public_html/phpdvdprofiler/incupdate.php on line 1019

Fatal error: SQL ERROR [ mysql ]

CALLING PAGE

/phpdvdprofiler/index.php&

SQL

SELECT sid FROM DVDPROFILER_dvd_supplier WHERE suppliername='Magasin spécialisé'
in /home/u407805850/public_html/phpdvdprofiler/mysql.php on line 455


I do not understand why there is a selection about suppliername='Magasin spécialisé'. And I also noticed that accented characters as é or ç are replaced by ? (that is not really a problem for my purpose.

Perhaps FredLooks can help me on this ??

Yves
Title: Re: phpdvdprofiler
Post by: surfeur51 on September 26, 2016, 09:22:54 AM
Well, I removed the accents from supplier Magasin spécialisé> Magasin specialise, and it worked  :clap:

I have now all my titles ;D, but with an incredible number of "?" instead of accented characters everywhere in the profiles. But it's ok from my purpose (consulting my collection on my phone in stores or flea markets)

Thank you for developers and helpers  ;D
Title: Re: phpdvdprofiler
Post by: FredLooks on September 26, 2016, 04:53:03 PM
Hi Yves, welcome to the party  :)

That ls a little ... discomfiting. I'll have to review how the program stores data; for at least some fields it automatically translates "special" characters into their equivalent HTML characters to try to prevent this sort of thing.

Would it be possible for you to make your XML file available to me for testing (un-edited, please) to see if I can reproduce the problem?

Cheers!

-fred
Title: Re: phpdvdprofiler
Post by: Jimmy on September 26, 2016, 05:25:29 PM
There is certainly a way to prevent this since the french accents show up perfectly fine in mine.

Profile exemple (http://www.dvdalistic.com/aesppres.com/phpdvdprofiler/index.php?mediaid=065935806059.19&action=show)
Title: Re: phpdvdprofiler
Post by: FredLooks on September 26, 2016, 09:24:10 PM
Hmmm ... The only thing that stands out is that they are running MariaDB rather than MySQL ...  http://surfeur51.esy.es/phpdvdprofiler/index.php?action=info

I haven't any experience with that ... the webpages seem to indicate that it is drop-in compatible ...

I'll explore some more ...

-fred
Title: Re: phpdvdprofiler
Post by: surfeur51 on September 29, 2016, 05:22:31 PM
Clearly the problems came from an inadequacy between phprofiler and the host server. I changed from hostinger to 000webhost, and now everything seems to work without problem.

http://surfeur51.comxa.com/phpdvdprofiler/