Hello, and first sorry for my bad english
I try to create a table in the database of Multisite with the name Rank, with 2 rows, yesterday rank, and today rank. The yesterday rank have the order of the sites by the visits of yesterday, and the today rank have the order of the sites by the visits of today. This table we gonna refresh every hour with a cronjob or in the same script that refresh the visits count(better if is posible). For example the table in the mysql is something like this:
Site ID YesterdayRank TodayRank
123 2 1
156 1 2
Or i thing that is posible to do this using the visits data. When order the websites by visits to add a descendent number for websites. For example for the first website with bigger visits add the rank 1 in Multisite page, for the second rank 2, etc…
And the yesterday ranking show the same, but using the yesterday visits data.
And the next problem is to add the variable in MultiSite
like that:
Y. Rank T. Rank WebSite Visits Page Visits
2 1 mywebsite1 600 1000
1 2 mywebsite2 450 700
If someone can help me i give ∞ Thanks.