Need to sort newest games by date added

woochoochinchilla · 01-11-2008, 06:20 PM

I have a script that makes an inactive game active every day but the newest games section on my site doesn't sort it right.

Is there a way to make the date added something like "YYYY/MM/DD"? I think that would do it, but I am not great with PHP functions so I don't know how to do it.

ArcadeSiteBuilder · 01-11-2008, 09:51 PM

Woochoochinchilla,

What script?

If it is phpas it defaults to gameid, you just need to change it to dateadded.

But the dateadded field field must be populated.

I have a complete mod for phpas that does it all including generating a new sitemap, and then autopinging google. if you would be interested. It is awesome and so complete...

woochoochinchilla · 01-11-2008, 10:31 PM

Yes it is phpAS.

Is your MOD free? Because I just spend all my money sponsoring games. Also I don't really want to pay. I think all I need is to know the PHP way of making the date show like this "YYYY/MM/DD".

ArcadeSiteBuilder · 01-11-2008, 10:49 PM

My mod is $15.00

I went to phpas and found this tutorial thread from Scott for you on displaying dates.

Login

Hope it helps

brendgard · 01-12-2008, 01:51 AM

I believe curdate() will return a format close to what you are looking for(yyyy-mm-dd). However, I personaly would rather have time() as it returns the time down to a second. If you update 4 on the same day, time() would return a little more precise value(assuming they are done spaced at least 1 second apart), where as curdate() returns the same value for them all.

woochoochinchilla · 01-12-2008, 02:28 AM

The script that I have that adds them is made in perl/cgi. I for some reason when I add localtime(time) to the MySQL update it come out as "0". But when I print it it is fine. I am going to try gmtime() as soon as my sites are back up.

brendgard · 01-12-2008, 02:42 AM

Oops. You're on your own then as I have no knowlege of PERL. I was assuming PHP was the language of choice in this case. Sorry bout that, I really should learn it one of these decades.

woochoochinchilla · 01-12-2008, 04:16 AM

Problem solved.

I couldn't figure out how to get the date to work so I converted my script into PHP. I just added a new game and will be adding some more to make the 10 listed actually new.

01-11-2008, 06:20 PM	#1 (permalink)
woochoochinchilla Senior Member Join Date: Oct 2006 Posts: 836	Need to sort newest games by date added I have a script that makes an inactive game active every day but the newest games section on my site doesn't sort it right. Is there a way to make the date added something like "YYYY/MM/DD"? I think that would do it, but I am not great with PHP functions so I don't know how to do it. __________________

01-11-2008, 09:51 PM	#2 (permalink)
ArcadeSiteBuilder Senior Member Join Date: Oct 2007 Posts: 214	Woochoochinchilla, What script? If it is phpas it defaults to gameid, you just need to change it to dateadded. But the dateadded field field must be populated. I have a complete mod for phpas that does it all including generating a new sitemap, and then autopinging google. if you would be interested. It is awesome and so complete... __________________

01-11-2008, 10:31 PM	#3 (permalink)
woochoochinchilla Senior Member Join Date: Oct 2006 Posts: 836	Yes it is phpAS. Is your MOD free? Because I just spend all my money sponsoring games. Also I don't really want to pay. I think all I need is to know the PHP way of making the date show like this "YYYY/MM/DD". __________________

01-11-2008, 10:49 PM	#4 (permalink)
ArcadeSiteBuilder Senior Member Join Date: Oct 2007 Posts: 214	My mod is $15.00 I went to phpas and found this tutorial thread from Scott for you on displaying dates. Login Hope it helps __________________

01-12-2008, 01:51 AM	#5 (permalink)
brendgard Gamer FX Staff Senior Member Join Date: Oct 2006 Posts: 680	I believe curdate() will return a format close to what you are looking for(yyyy-mm-dd). However, I personaly would rather have time() as it returns the time down to a second. If you update 4 on the same day, time() would return a little more precise value(assuming they are done spaced at least 1 second apart), where as curdate() returns the same value for them all. __________________ http://gamersgo.com A list of arcade related sites, add yours. http://auntiefondy.com Lists, add your site. http://kbsplace.com

01-12-2008, 02:28 AM	#6 (permalink)
woochoochinchilla Senior Member Join Date: Oct 2006 Posts: 836	The script that I have that adds them is made in perl/cgi. I for some reason when I add localtime(time) to the MySQL update it come out as "0". But when I print it it is fine. I am going to try gmtime() as soon as my sites are back up. __________________

01-12-2008, 02:42 AM	#7 (permalink)
brendgard Gamer FX Staff Senior Member Join Date: Oct 2006 Posts: 680	Oops. You're on your own then as I have no knowlege of PERL. I was assuming PHP was the language of choice in this case. Sorry bout that, I really should learn it one of these decades. __________________ http://gamersgo.com A list of arcade related sites, add yours. http://auntiefondy.com Lists, add your site. http://kbsplace.com

01-12-2008, 04:16 AM	#8 (permalink)
woochoochinchilla Senior Member Join Date: Oct 2006 Posts: 836	Problem solved. I couldn't figure out how to get the date to work so I converted my script into PHP. I just added a new game and will be adding some more to make the 10 listed actually new. __________________

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Arcade Script Reviews	arcadillo	Scripts & Software	6	08-08-2008 02:35 AM
PR5 Arcade Site 5,000 UV	Doug	Link Exchanges	9	04-10-2008 02:51 PM
ArcadeScript.com - where Social Networking meets High Score Flash Games	Varchar	Scripts & Software	9	12-01-2007 05:45 AM
Places to submit games	webbom	Marketing	1	07-25-2007 06:16 AM
Have an Arcade? Need Games? 2229 Games Inside!!!	admin	Game Packs	3	09-15-2006 10:30 AM