Video database insertion, Help!

Hello there,

I would like to isert a video from another file to database, give it the title, tags, uri ... etc

But i need to know queries to insert albums, i don't know how to do it can any one help me here ?

Thank you.

Could you please more specific?

What do you mean when you say "From another file"??

If you want to manually put a video into an album using the database, you should know a lot of things:

The ID of the owner

The next ID to be assigned to the video

The duration of the video

etc..

Do you know all those details?

Why don't you insert the video using the Doplhin front-end function?

Let me know if you need further assistance.

You can say it's a youtube video and i know all the detaills including owner id.

And i will shoose a default name of album like "videos".

But i would like to insert it from i php file that i create by my self but i don't know the queries to insert album.

How can i know The next ID to be assigned to the video ?

As I understand you are a php programmer, right?

So just go into your phpMyAdmin

Browse the table called RayVideoFiles, add manually a new video by inserting all the required fields, click submit, copy and paste the generated code.

That will give you the query to insert videos

To add a new album do the same on the table :

sys_albums

As to get the next ID to be assigned you can create a simple php function that will get the last ID and will add +1, it's simple.

I am assuming you are a php programmer, so you should understand what I mean.

If you are not a php programmer that will be much more difficult, because you should know how to create php functions to do this code.

Let me know if you need further assistance.

Thank you handerstoud, and what about sys_albums_objects ?

Yes you should edit that too.

Id_album is the ID of the album

id_object is the ID of the file.

id_order it's not necessary.

Let me know if you need further assistance

Thank you :=) i will give it a try.

Hello again i tried what you said but it's not working :( the added video can not be seen in the videos page or in the created album.

Any one tried this before ?

Any ideas ?

Did you clear the /cache/ (except for the .htaccess file) /cache_public/ and /tmp/ directories after editing the database?

Well my php script is not expected to do this :) i juste want to insert videos from this file knowing the required information.

Any budy know how to this ?