How is count generated for Video category?

I have a 3rd party developer asking me how the count is generated for video category in Dolphin 7.1?

Is there anyone who can help sharing some light on the count?

Thank you!

i will take a guess and probably say it is an sql statement that counts categories in sys_categories where type = to bx_videos. But thats just a guess.

Thanks ProfessorSr I tried that and got the reply that  "We need how video count inside category is being generated and shown." Please contact Dolphin support.

The only support I know off is here in the Forum by helpful people like you.

I will take another shot at it - RayVideoFiles where Category = whatever category

 But could you please explain a little more what it is you are trying to do. I am a lil new and slow, but want to do all i can to help you out.

I would start with the BxVideosSearch.php page under the videos module classes folder

Hi!

They've looked through the files but couldn't find anything.

So numbers are dynamically generated but how and where are they stored?

http://postimage.org/image/7vgxb0q61/

Trying to upload a batch of videos but then the Video category don't update the number of videos in the Video category.

ih - if you are trying to add a batch of videos, there may be more to it then. Cause after you upload a video - under normal circumstances, the system (ffmpeg.exe) will convert the video files into 2 formats (maybe 3). Each converted video name is changed to a number - which is then stored in the database.

So, I am not sure if doing a batch upload is going to work, but i could be totally wrong. I know I messed up and deleted my whole site one night, and had to spend the next 2 days reuploading all 300+ videos we had. Now - doing a batch upload would have been great, but I did not know what numbers were assigned to which videos.

"Sir ask them where is the code for the sidebar

http://postimage.org/image/7vgxb0q61/

We have yet to receive a technical reply with actual file / source pointers. Telling us it is a video count from which table , we already know that . We need from where those numbers are coming from and how are they generated , Query , Database entry or source path would actually help. "

I appreciate the kindness from the Support Forum in helping out on getting the technical details.

For example, for the video with ID=54 from user with ID=35 tobe shown in category "Music clips", execute the following query:

INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`, `Date`) VALUES
('Music clips', 54, 'bx_videos', 35, 'active', NOW);