This is great can you copy this to the aikifu section please? Yes I Want us to develop a google sitemap app in the Future.
[email protected] http://fabricatorz.com On Aug 24, 2011 1:33 AM, "Jakub Jankiewicz" <[email protected]> wrote: > I created Google sitemaps with all links to detail pages along with > images. Google sitemap is in > http://www.openclipart.org/sitemap.txt?page= with 1000 links per > sitemap. I also created sitemap index and submited it to Google. There > is only 237,000 images in Google. In order to create 34 links for Google > sitemap index I use a hack, because there is no for loop in AIKI. > > I post this if someone need to do similar thing > > I've create new table with indexes > > create table counter(i integer) > > and insert integers from 1 to 50 > > in SQL query I use > select ceil(count(*)/1000) as c from ocal_files where filename rlike > '.svg' > > and in content I use sql > > (sql( > (select i from counter limit ((c))|| [-[i]-]) > )sql) > > This mimic for loop > > I hope that new version of AIKI will have for loops so we wouldn't > needed such hacks. > > _______________________________________________ > Mailing list: https://launchpad.net/~aikiframework-devel > Post to : [email protected] > Unsubscribe : https://launchpad.net/~aikiframework-devel > More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~aikiframework-devel Post to : [email protected] Unsubscribe : https://launchpad.net/~aikiframework-devel More help : https://help.launchpad.net/ListHelp
