Hall of Fame

#91

I

Help me! / Allowing PHP beside HMTL in Ne...

Last post by Icey - 25 February, 2024

Hey!

So, I see that for the newly created pages, you can only write there in html and that's it. I tried to look a bit for the way to change it to also allow PHP ( which will help me a lot ) but couldn't really find a way.

Also, I am looking for a way to .. "hardcode" a new page into the source code. For exemple there is site.com/blog , which is "hardcoded" into the script, but I also want to create a new one like site.com/search , or site.com/all-categories , etc. If you can .. point me out where exactly to do this, I will really appreciate it.

Thanks!

#92

I

Help me! / Re: Search Query

Last post by Icey - 25 February, 2024

Try this via your sql tool (phpmyadmin?):

Code Select Expand

ALTER vibe_description
ADD FULLTEXT(description);

change vibe_ to your prefix.

This worked with above code, but ..very slow. 5-7 seconds for a search query.

I changed the way the search is doing his query and now is very smooth ( almost instant ). Is not searching for the exact phrase, but is doing its job.. for now. You can check on my website if you want.

Here is the code for anyone wanting it :

Code Select Expand

// Remove URL format
$key = str_replace(array("-","+")," ",$key);
$titleKey = str_replace(" ", "_",$key);
 
// Separate the keywords
$keywords = explode(" ", $key);
 
// Query to search in both video descriptions and titles
$like_conditions = [];
foreach ($keywords as $keyword) {
    $like_conditions[] = DB_PREFIX . "description.description LIKE '%" . $keyword . "%'";
    $like_conditions[] = DB_PREFIX . "videos.title LIKE '%" . $keyword . "%'";
}
 
//The final query
$vq = "SELECT " . DB_PREFIX . "description.vid AS id, " . DB_PREFIX . "description.description, " . DB_PREFIX . "videos.title, " . DB_PREFIX . "videos.date, " . DB_PREFIX . "videos.user_id, " . DB_PREFIX . "videos.thumb, " . DB_PREFIX . "videos.views, " . DB_PREFIX . "videos.liked, " . DB_PREFIX . "videos.duration, " . DB_PREFIX . "videos.nsfw
        FROM " . DB_PREFIX . "description
        LEFT JOIN " . DB_PREFIX . "videos ON " . DB_PREFIX . "description.vid = " . DB_PREFIX . "videos.id
        WHERE " . DB_PREFIX . "videos.pub > 0 AND " . DB_PREFIX . "videos.date < NOW()
        AND (" . implode(" OR ", $like_conditions) . ")
        ORDER BY " . DB_PREFIX . "videos.title LIKE '" . $titleKey . "%' DESC,
                 " . DB_PREFIX . "videos.title LIKE '%" . $titleKey . "%' DESC,
                 " . DB_PREFIX . "videos.title ASC " . this_limit();

I'll be making a new post now regarding another "issue"

#93

T

Bug tracker / Conversion failed for:

Last post by tweky94 - 24 February, 2024

te salut marius din nou  , da aceasi problema si nu inteleg m-am lasat pagubas cum s-ar zice acum ceva timp am zis ma asta e daca nu reusesc sa il fac sa mearga... , dar parca tot nu vreau sa ma las imi place phpvibe.... deci revin cu o probblema...


am incarcat primul videoclip dupa ce am instalat phpvibe si a mers perfect si thumbnail si video incarcat bine...
iar la al 2-lea videoclip si restu dupa primu  pare sa am probleme...

incarc videoclip iar in log imi apare asa

Code Select Expand

[24/02/24 11:22:30pm]
Conversion failed for:
/home/georgik5/web/lastcs.ro/public_html/storage/rawmedia/74a2cbf7cb4b8eb1bddefc240b985581.mp4 - File not found
[24/02/24 11:22:30pm]
Conversion failed for:
/home/georgik5/web/lastcs.ro/public_html/storage/rawmedia/446a3116c041676a1c20d3e4196e6ae6.mp4 - File not found
[24/02/24 11:22:30pm]
Conversion failed for:
/home/georgik5/web/lastcs.ro/public_html/storage/rawmedia/0b323e56556247d680b9356f49abbb1b.mp4 - File not found
[24/02/24 11:22:30pm]
Conversion failed for:
/home/georgik5/web/lastcs.ro/public_html/storage/rawmedia/c934562987751dce66cb12a1a3616fd7.mp4 - File not found
[24/02/24 11:22:30pm]
Conversion failed for:
/home/georgik5/web/lastcs.ro/public_html/storage/rawmedia/b8a900a42677371f3092f66093ce8bc2.mp4 - File not found
[24/02/24 11:23:43pm]
Conversion starting for:
/home/georgik5/web/lastcs.ro/public_html/storage/media/f1ecd515c7905b81c85cf58fd753d880-0.mp4
[24/02/24 11:23:43pm]
Conversion failed for:
/home/georgik5/web/lastcs.ro/public_html/storage/media/f1ecd515c7905b81c85cf58fd753d880-0.mp4 - File not found

intru in media library videos  dau pe videoclipul incarcat ma uit in jos  la Video qualities apare unu singur

Code Select Expand

  f1ecd515c7905b81c85cf58fd753d880-.mp4

dau pe create missing qualites from 0p asa apare cand dau pe el imi spune
Failed! Source file doesn't exit.

https://ibb.co/y5NL3wp

care sa fie problema... ? el pare ca se urca pe ftp dar dupa cand incearca ffmpeg sa creeze rezolutii pare ca nu il gaseste cica... ??

am mai incarcat iar inca 3 video dar la astea  la quality video nu apare deloc nici macar un video nimic
daca intru in media library Source files (raw)  acolo apar videoclipurile incarcate.....






EDIT : Problema numarul 2 as avea cu acel clopotel din stanga sus unde apare activitatea imi apre activitate nou gen 1 2 3 activitati .. cand dau pe el ma duce pe pagina de activitati  si imi apare doar
Activity on your media
21    , doar atat pagina alba goala..



3. in viitorul apropiat este posibil sa rezolvi problema la script cu categoriile  selectate ? ca in momentul de fata este Default dar nici in ala nu se pune sa apara pe prima pagina.....


4. Daca intru la acest videoclip https://lastcs.ro/video/9/alan-feat-cheloo-perfect-dezechilibrat-i-videoclip-oficial/     intru pe edit media  dupa care ma trimite pe pagina sa editez videoclipul cand dau update video pica pagina imi apare


This page isn't working
lastcs.ro is currently unable to handle this request.

HTTP ERROR 500




te pup marius ,sper sa nu fie cu suparare aceste probleme cu care vin poate incercam sa le rezolvam impreuna (adica tu ca eu nu stiu )


@ imi place phpvibe de asta tot incerc sa rezolv sa fac sa meargaaa

[This is why the project is now free and open source.]

#94

Announcements / Re: Stable version

Last post by Marius P. - 24 February, 2024

Hi,
I don't have a release schedule since my job is no longer online and I have weeks when I'm most days far from a PC.
This is why the project is now free and open source.
I code a little every time I get the chance and I think this is visible https://github.com/PHPVibe/PHPVibe/commits/master/.

Maybe a commercial alternative would be a better choice,
but I don't know what to recommend to you, I see them all kinda frozen.
No real major updates have been rolling out anywhere for the last 2-3 years, so I'm almost sure this video-sharing niche is no longer making real money.

#95

Help me! / Re: Search Query

Last post by Marius P. - 24 February, 2024

Try this via your sql tool (phpmyadmin?):

Code Select Expand

ALTER vibe_description
ADD FULLTEXT(description);

change vibe_ to your prefix.

#96

M

Announcements / Stable version

Last post by max18121980 - 22 February, 2024

Hi Mario. Can you please give me an approximate timeframe when we can expect a stable version, as it's been a long time and I need to understand if it makes sense to wait further or look for an alternative?

#97

I

Help me! / Re: Search Query

Last post by Icey - 22 February, 2024

Made a..partial fix! The code is in _search.php and I made it to search only in description and..now seems everything is working, but as soon as I try to make it to also search in title, so "title and description", I am.. back to my first problem. Not working at all.

Code Select Expand

// Remove URL format
$key = str_replace(array("-","+")," ",$key);
$titleKey = str_replace(" ", "_",$key);
 
// Full Search - Title and Description
$vq = "SELECT ".DB_PREFIX."videos.id, ".DB_PREFIX."description.description, ".DB_PREFIX."videos.title, ".DB_PREFIX."videos.date, ".DB_PREFIX."videos.user_id, ".DB_PREFIX."videos.thumb, ".DB_PREFIX."videos.views, ".DB_PREFIX."videos.liked, ".DB_PREFIX."videos.duration, ".DB_PREFIX."videos.nsfw,
        ".DB_PREFIX."users.name AS owner, ".DB_PREFIX."users.group_id,
        ".DB_PREFIX."channels.cat_name
        FROM ".DB_PREFIX."videos
        LEFT JOIN ".DB_PREFIX."users ON ".DB_PREFIX."videos.user_id = ".DB_PREFIX."users.id
        LEFT JOIN ".DB_PREFIX."description ON ".DB_PREFIX."videos.id = ".DB_PREFIX."description.vid
        LEFT JOIN ".DB_PREFIX."channels ON ".DB_PREFIX."videos.cat_id = ".DB_PREFIX."channels.id
        WHERE ".DB_PREFIX."videos.pub > 0 AND ".DB_PREFIX."videos.date < NOW()
        AND ( ".DB_PREFIX."videos.title LIKE '%".$titleKey."%' OR ".DB_PREFIX."description.description LIKE '%".$key."%' OR ".DB_PREFIX."channels.cat_name LIKE '%".$key."%' )
        ORDER BY ".DB_PREFIX."videos.title LIKE '".$titleKey."%' DESC,
                 ".DB_PREFIX."videos.title LIKE '%".$titleKey."%' DESC,
                 ".DB_PREFIX."videos.title ASC ".this_limit();

Any .. ideas Marius?

#98

I

Help me! / Search Query

Last post by Icey - 22 February, 2024

As we already talked on Linked in, I have the almighty problem with search queries. I want to update it, but can't really seems to find where exactly the search submit from tpl_header is sending the search terms so that the query send it to the database.

Also, I will say this here too ( off topic I know ) : The player isn't working for direct .flv and .wmv files. Only .mp4 as far as I am aware.

#99

Help me! / Re: 404 Not found for non-exis...

Last post by Marius P. - 22 February, 2024

Hi,
file
https://github.com/PHPVibe/PHPVibe/blob/master/themes/main/404.php
edit this as you see fit

Code Select Expand

header("Status: 404 Not Found");

#100

G

Help me! / 404 Not found for non-existent...

Last post by Grim - 19 February, 2024

Hi!
Currently, all non-existent pages do not have a server response "404 Not found", they are all "200 OK", which is incorrect. How can I fix this?
Example - https://clipz.ru/video/qwertyuiop
PHPVibe 11.0.46