rofl90 Posted July 6, 2008 Share Posted July 6, 2008 Hi guys i needed some help with logistics for a app i'm building basically it should monitor a social network stats interface and then do something if it hits a user specified spike eg user can pick a tree which will erupt into something like "bebo_canvas-view_male_18-25" and then they'll choose a parameter for instance a condition eg "When it goes below", when it drops, and then choose a timeframe and a value. if either are applicable. then it should save those in a database of page or what-have-you and a corn should be run every hour to check if any conditions are met, what would you suggest logic for this should be, also could you maybe give me some example sql. the database is like this tables: minute minuteArchive hour day month minutes are archived every time the day cron is run and the table on each looks like x---id--------type---------count---------date-------- |||||1|||bebo-canvas..|||6274|||07-02-08 01:01:01|| date is in that form, type is the type of stat and count is how many times its happened eg saved profile or viewed page. thanks! Link to comment https://forums.phpfreaks.com/topic/113405-spike-detection/ Share on other sites More sharing options...
rofl90 Posted July 6, 2008 Author Share Posted July 6, 2008 bump Link to comment https://forums.phpfreaks.com/topic/113405-spike-detection/#findComment-582976 Share on other sites More sharing options...
rofl90 Posted July 7, 2008 Author Share Posted July 7, 2008 bump Link to comment https://forums.phpfreaks.com/topic/113405-spike-detection/#findComment-583181 Share on other sites More sharing options...
DarkWater Posted July 7, 2008 Share Posted July 7, 2008 I have no idea what you're asking. At all. I got lost around this line: "user can pick a tree which will erupt into something" >_> And I kind of chuckled at "corn job". Try to explain it as best as you can. A tree which will erupt into something doesn't really help. Link to comment https://forums.phpfreaks.com/topic/113405-spike-detection/#findComment-583182 Share on other sites More sharing options...
rofl90 Posted July 7, 2008 Author Share Posted July 7, 2008 sorry like an ajax tree eg you pick data then bebo then canvas then view click a checkbox and that will "erupt" into "bebo_canvas-page_view_male_18-25 Link to comment https://forums.phpfreaks.com/topic/113405-spike-detection/#findComment-583264 Share on other sites More sharing options...
rofl90 Posted July 7, 2008 Author Share Posted July 7, 2008 Can you maybe give a few answers, eg should i store conditions in an array in a sql database, or just a database or even an array in a text file etc? Link to comment https://forums.phpfreaks.com/topic/113405-spike-detection/#findComment-583582 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.