Printable View
Hello...
i have vshare 2.6 with some video, in the main server www.sitewithvshareinstalled.com/flvideo some other, the most new, in a secondary external server.
So... i want to change in the mysql database the url of first group of video ,the one who load from www.sitewithvshareinstalled.com/flvideo i want this videos will load from "www.otherdomainexsample.com/dir"
How i can proceed in phpmyadmin to do this? :oops: :shock:
You like to do this to prevent the hotlinking i think because i had the same problem. You can not do that from phpmyadmin is inside the script and the script is encrypted. Just install lighttpd mod_secdownload flv server to prevent hotlinking. :wink:
No, i don't do about hotlink, for that i have htaccess and anyway i guess i dont have hotlink problem...Quote:
Originally Posted by RAMMSTEIN
I have problem in my current hosting, so i have to move to a better one... and in the better one i have fix bandwith...
And because my site generate "good traffic" and i dont have money to invest for a 20-30mb included i have to optimize...
So i want to use the old and bad one, for part of the videos at least.
i take a look in phpmyadmin, i guesss like i asked is not possible to do, but is possible to set up different servers and then change the server id for "N" videos... :mrgreen:
Have to work like this, i guess.
Like this i will set up some servers in my share admin panel, using cip hosting/old space i don't use anymore... and changing the server id in phpmyadmin i will let vshare load the older videos from this servers... :oops:
Anyway i'm able to do this manually 1 videos at time... anyone can suggest how in phpmyadmin edit the video "server id" for a large amount of video all togheter?
thank you.
I think is necessary to run a query in phpmyadmin:
But i dont know at all how to do this...Code:SELECT * FROM `video``server_id`
I meas "select" only from first video uploaded to N number of video uploaded, and then make change only the "server_id" and set for all for exsample "1" any help please? :oops:
If you want to change the server id for your video you can do it with>>>>
update `video` set server_id=THE SERVER THAT YOU WANT THEM TO BE where server_id=THE SERVER THAT ARE NOW
example
Code:update `video` set server_id=1 where server_id=0
Thank you, your suggestion about phpmyadimn, work fine.Quote:
Originally Posted by RAMMSTEIN
About this...
What is ?
i guess the server have to be installed the lighttpd and not apache, right?
It is easy to install and make work? and protect much better then apache+htaccess?
best regards.
Quote:
Originally Posted by cmedia
You can have them both in a server and run the lighthttpd from an other port.
About the apache+htaccess hotlink protection is not the best way to protect your videos they can bypass that protection. Take a test and you will see it yourself.
Interesting.Quote:
Originally Posted by RAMMSTEIN
And what about bandwith limitation?
for lighthttpd exsist also mod for this wo work good?
I mean limit the video directory to consume not more then certain amount of bandwidth/second...
For apache i have make some searches and the only mod i found is only, last update on 2007
http://www.cohprog.com/v3/bandwidth/download-en.html
so not seems a very good solution... anyway seems this mod do exactly what i ask for.