egghelp.org community Forum Index
[ egghelp.org home | forum home ]		 egghelp.org community
Discussion of eggdrop bots, shell accounts and tcl scripts.
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

yesterday/today and mysql

 
Post new topic   Reply to topic    egghelp.org community Forum Index -> Scripting Help
View previous topic :: View next topic  
Author Message
thede
Voice


Joined: 31 Mar 2007
Posts: 3
PostPosted: Sat Jun 02, 2007 9:20 am    Post subject: yesterday/today and mysql Reply with quote
hi guys,
im trying to get something working for hours now, but it just wont work.
what i want:
i got a mysql db with some player stats and the time when they entered the db, the time is available in unixtime, now i want a few commands like !yesterday / !week / !month / !year which should output this:
"XXXX new members entered the game [yesterday/this year/week]"

ok, i could add a new field, but i wont as the old ones wouldnt work then.
anybody got an idea ?
Back to top
View user's profile Send private message
rosc2112
Revered One


Joined: 19 Feb 2006
Posts: 1454
Location: Northeast Pennsylvania
PostPosted: Sat Jun 02, 2007 3:43 pm    Post subject: Reply with quote
Look at the 'clock' and 'duration' commands.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    egghelp.org community Forum Index -> Scripting Help All times are GMT - 4 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Forum hosting provided by Reverse.net

Powered by phpBB © 2001, 2005 phpBB Group
subGreen style by ktauber