skusa93 Wrote:Been struggling with this for hours now and about to give up, hopefully someone can figure it out.

In Config.php I've set the IP to 192.168.1.193, port to 8080 and my MAC is set correctly.

I believe I have XAMPP Lite installed and working properly, 192.168.1.193 returns a workable XAMPP page.

Testing this with my laptop on my local network before trying going outside my LAN, and "192.168.1.193/interface/" returns an index page, with one folder inside "XBMC". Opening the folder XBMC returns a blank white page titled "XBMC HTTP-R".

Going to 192.168.1.193/interface/XBMC/indexing.php returns a page that says "Can't Index: HTPC, is offline!"

Not sure what's going wrong?'

Edit:
Been messing with it again, and although I've no idea what I did, I got it to sort of work.

now 192.168.1.193/interface/xbmc returns the HTTP-R remote, but it says "XBMC is offline" and "This machine is not responding" with an option to "Turn on". If I click the turn on option, it will just sit unresponsive until I close the page.

Suggestions?

tamago_quin Wrote:I'd like to change a few things in HTTP-R for my own personal needs but I'm having a difficult time with sqlite and php syntax. I would like to create a string similar to this: "E:\Movies\filename-fanart.jpg"
here is what I think should be done, but I can't write it correctly

Code:

SELECT strPath FROM path WHERE (strContent = 'movies'), LEFT(strFilename)-4 FROM files, || '-fanart.jpg' WHERE idFile.file=idfile.movie

I don't know if I should use LEFT or Right to remove the filename suffix(.mkv .avi etc). this is confusing maybe but some help would be great!

transcender Wrote:I dont really know sql or what your refrencing but couldnt strip the extension before the SQL query like: stfilename =left(strfilename)-4 cause i think LEFT is a sql command.

Quote:public function get_thumb()
{
global $MODULE;
$MODULE->load("image");

list($thumb) = $this->parent->db->sql_fetchrow($this->parent->db->sql_query("SELECT c08 FROM movie WHERE idMovie = '".$this->id."'"));
preg_match_all("|<thumb.*>(.*)</thumb>|U", str_replace("<thumbs>", "", $thumb), $matches);

return image::get("movie", $matches[1][0]);
}

Quote:public function get_thumb()
{
global $MODULE;
$MODULE->load("image");

list($thumb) = $this->parent->db->sql_fetchrow($this->parent->db->sql_query("select path.strPath || replace(replace(files.strFilename, '.mkv',''),'.avi','') || '-fanart.jpg' from path, files where path.strContent='movies' and files.idPath='1' and movie.idFile=files.idFile and movie.idMovie = '".$this->id."'"));

return image;

}