PDA

View Full Version : Make newest videos display first

jordan4486
04-22-2006, 10:36 PM
Does anyone know how to make the newest videos display first on the site... Would you have to do something in the database or what? I have noticed that there isnt really any set way that the database displays the files... Is there anyway to alter this? Anything would help.. Thanks
Ryan
04-23-2006, 03:10 AM
You have to do it by the query within the file. I'll post the exact query tomorrow.
member
05-06-2006, 10:58 PM
Yeah how can we make newest video come first.Thanks
falarious
05-07-2006, 12:15 AM
Open up index.php, search.php,type.php, and catregory.php

Find this:
ORDER BY added
Replace with this:
ORDER BY added DESC
spidernet
05-22-2006, 12:26 PM
Hello i have a problem !
I have modified my script with this what you said but isnt working at my site !
The newest videos and photos are still on the last page?
Any solution ?
Than you
Staale
05-22-2006, 03:55 PM
Got the same issue, and cant get it right. Please help:)
spidernet
05-22-2006, 03:57 PM
Hello staale maybe we will get a answer :)!
If somebody know please help us :)!
boxingfan
05-22-2006, 04:25 PM
count me in, would certainly want the new videos coming up first.
boxingfan
05-22-2006, 04:44 PM
I would assume that it's a simple switch of code within the pages. I have the largest boxing related community on the net and picked up a new server just for this script, which will be a new section. I think this more than anything needs to be addressed as with old videos always coming up first, it will make a site look old.
Ryan
05-22-2006, 04:58 PM
I just tested this once again and it is working how it should work. If anyone is having issues feel free to PM me your FTP and database information along with your Admin CP information and I will personally look into this for you.
Staale
05-22-2006, 05:38 PM
I just tested this once again and it is working how it should work. If anyone is having issues feel free to PM me your FTP and database information along with your Admin CP information and I will personally look into this for you.

So, you basicly just replacing " ORDER BY added" with " ORDER BY added DESC" everywhere in the files? Let me try one more time:)
spidernet
05-22-2006, 05:40 PM
Isn`t working for me :(! I have sent to you a pm Ryan with all the info !
Staale
05-22-2006, 06:02 PM
Isn`t working for me :(! I have sent to you a pm Ryan with all the info !

Me either, please make a better guide:P
spidernet
05-22-2006, 06:34 PM
Nobody can help us ? I am loosing visitors ! They come and they leave bealiving that i didn`t put new videos and photos ! Pls someone help me :D!Thank you
boxingfan
05-23-2006, 06:16 AM
Here is the problem and probably why there is a bit of miscommunication.

I did the code changes and they do work, but ONLY when you are adding files from the admin section.

If you are a registered user adding a file, it does NOT work. The new file ends up being dead last on your page.
Staale
05-23-2006, 07:27 AM
Here is the problem and probably why there is a bit of miscommunication.

I did the code changes and they do work, but ONLY when you are adding files from the admin section.

If you are a registered user adding a file, it does NOT work. The new file ends up being dead last on your page.

Hmm, i still dont get it to work. So, lets see, ewe only change the parts where its says "order by added" and not where it says "ORder by added limit" etc?

Boxingfan, can you please let us know wich files, and where exactly you changed the files?

On the side: Hoping to see a new version soon;)
falarious
05-23-2006, 08:49 AM
Yeah I am hoping to see a new version too
spidernet
05-23-2006, 10:13 AM
Inst working neither from admin section ! :(
boxingfan
05-23-2006, 02:12 PM
Change ORDER BY added with ORDER BY added DESC in the necessary files like index.php, category.php, search.php. There will be two instances where the changes have to be made in index.php and I believe category.php if I'm not mistaken.

Again, this only works when adding a file through admin, it does NOT work when a user is adding a file.
Staale
05-23-2006, 02:23 PM
Ok, it does work, but ONLY to the files that you add AFTER you have made the changes.
spidernet
05-23-2006, 03:03 PM
At my neither that :)! What is happening?
Ryan
05-23-2006, 07:59 PM
boxingfan, Thanks for all your help.

It should not matter if added through admin or user area it should still be added to the top. I'll look into this and you guys can still expect a new release soon.
Ryan
05-23-2006, 08:57 PM
Stale's great explaination can be found here:
http://www.humorsoftware.com/forums/showthread.php?t=115