Easily get raw URL for other PHP scripts

[ashkir]

Hello! Does anyone know of an easy way to get the raw URL (or even CDN) url for use on a php page that is not a part of Chevereto?

Basically, I'm trying to connect to the database right now via:

$sql = "SELECT image_id, image_name, image_extension, image_album_id FROM chv_images WHERE image_album_id = '146'";

 echo "image link: <a href='https://cdn.nickpic.host/images/". $row["image_name"]. "." . $row["image_extension"]."'>". $row["image_name"]. "." . $row["image_extension"]."</a> - Name: " . $row["image_id"]. " " . $row["image_album_id"]. "<br>";
    }

It works flawlessly for anything with the album 146.

However, what I want to do is to easily get the full URL for the image. Right now the only thing I can think of is by manually typing the domain. There doesn't seem to be an easy way to call the image's URL from the database? Or did I miss something?

I'm planning on adding a file server soon, so the raw image link is going to become increasingly more important, which basically renders this script useless.

 

[Rodolfo]

There is a function that does all that based only on the contents of the image row (database). The function is right here: https://github.com/Chevereto/Chevereto-Free/blob/master/app/lib/classes/class.image.php#L272

Usage examples can be found in that same file so you can either copy that function elsewhere or simply require the class.image.php file and use it all together (you will need to manually load G\ functions and stuff).