[xmoto-dev] recent coding

[Nicolas Adenis-Lamarre <nadenislamarre@xxxxxxx>]

== xmoto for mac intel and ppc ==
xmoto for mac intel and ppc (universal binary)
is just out.
Build by vasy (added today in this list)

== sqlite ==
i have integrated sqlite.
I probably commited a lot of bugs on the svn.
However, i tested a maximum before commiting.
It allows to not have to load several files at startup.
And faster (not more all these lists) and easier coding

Exemple:

* list of the levels to update :
 v_result = i_db->readDB("SELECT a.name FROM weblevels AS a "
             "LEFT OUTER JOIN levels AS b ON a.id_level=b.id_level "
             "WHERE b.id_level IS NULL OR a.checkSum <> b.checkSum;",
             nrow);

* add a new pack example
 /* scripted levels */
 v_pack = new LevelsPack(std::string(VPACKAGENAME_SCRIPTED),
             "SELECT id_level, name FROM levels WHERE isScripted=1 
ORDER BY name");
 m_levelsPacks.push_back(v_pack);
 v_pack->setGroup(GAMETEXT_PACK_SPECIAL);

 /* nicest levels */
 v_pack = new LevelsPack(std::string(VPACKAGENAME_NICEST_LEVELS),
             "SELECT a.id_level AS id_level, a.name AS name "
             "FROM levels AS a INNER JOIN weblevels AS b ON 
a.id_level=b.id_level "
             "WHERE b.quality >= 4.5 ORDER BY b.quality DESC LIMIT 50");
 m_levelsPacks.push_back(v_pack);
 v_pack->setGroup(GAMETEXT_PACK_WEBVOTES);

...


Nicolas