About XML and sqlite.

16 views
Skip to first unread message

Poornima Powar

unread,
Feb 29, 2012, 5:32:55 AM2/29/12
to iPhone-BitCode, 05bh...@gmail.com
Hello,
I have to develop the crossword game. In this need to parse the XML
file and create the dynamic grid of 15X15. Once the grid is done ,
when user solves some of the questions and cum back the entered answer
should bo saved somewhere.
And thats not all it needs to compare the users answers with the
original answers and perform some action.

So what do you suggest me to use and how.

Thank you.

Bharat Jagtap

unread,
Mar 1, 2012, 7:24:30 AM3/1/12
to iPhone-BitCode
You can create the grid dynamically . You can divide the view
depending upon the number of elements you want to lay out
horrizontally and vertically ...
To explain more about saving the answer , comparing the answer and
actually layouting it in a grid view , if you could paste some sample
xml that you are getting . At this time I ll suggest create a
customView for every cell in a grid add properties to that class like

NSString * actuallValue
NSString * userValue;
int row_num;
int column_num;

etc ... so each view will hold the info needed ...........

Poornima Powar

unread,
Mar 1, 2012, 8:24:27 AM3/1/12
to iPhone-BitCode
Thanks for your suggestion Sir.
this is the sample XML file

<crossword>
<grid width="15" height="15">
<grid-look numbering-scheme="none" clue-square-divider-width="0.7">
<numbered-sides top="A,B,C,D,E,F,G,H,I,J,K,L,M,N,O"
left="1,2,3,4,5,6,7,8,9,10,11,12,13,14,15"/>
</grid-look>
<cell x="1" y="1" solution="P"/>
<cell x="1" y="2" solution="O"/>
<cell x="1" y="3" solution="S"/>
<cell x="1" y="4" solution="T"/>
<cell x="1" y="5" type="block"/>
<cell x="1" y="6" solution="L"/>
<cell x="1" y="7" solution="U"/>
<cell x="1" y="8" solution="P"/>
<cell x="1" y="9" solution="A"/>
<cell x="1" y="10" type="block"/>
<cell x="1" y="11" solution="S"/>
<cell x="1" y="12" solution="K"/>
<cell x="1" y="13" solution="A"/>
<cell x="1" y="14" solution="L"/>
<cell x="1" y="15" solution="P"/>
<cell x="2" y="1" solution="R"/>
<cell x="2" y="2" type="block"/>
<cell x="2" y="3" solution="Z"/>
<cell x="2" y="4" solution="U"/>
<cell x="2" y="5" solution="P"/>
<cell x="2" y="6" solution="A"/>
<cell x="2" y="7" type="block"/>
<cell x="2" y="8" solution="I"/>
<cell x="2" y="9" solution="K"/>
<cell x="2" y="10" solution="R"/>
<cell x="2" y="11" solution="Z"/>
<cell x="2" y="12" solution="A"/>
<cell x="2" y="13" solution="K"/>
<cell x="2" y="14" type="block"/>
<cell x="2" y="15" solution="R"/>
<cell x="3" y="1" solution="Z"/>
<cell x="3" y="2" solution="N"/>
<cell x="3" y="3" solution="A"/>
<cell x="3" y="4" solution="K"/>
<cell x="3" y="5" type="block"/>
<cell x="3" y="6" solution="G"/>
<cell x="3" y="7" solution="E"/>
<cell x="3" y="8" solution="S"/>
<cell x="3" y="9" solution="T"/>
<cell x="3" y="10" type="block"/>
<cell x="3" y="11" solution="O"/>
<cell x="3" y="12" solution="L"/>
<cell x="3" y="13" solution="C"/>
<cell x="3" y="14" solution="H"/>
<cell x="3" y="15" solution="A"/>
<cell x="4" y="1" solution="Y"/>
<cell x="4" y="2" type="block"/>
<cell x="4" y="3" solution="R"/>
<cell x="4" y="4" type="block"/>
<cell x="4" y="5" solution="J"/>
<cell x="4" y="6" solution="U"/>
<cell x="4" y="7" solution="R"/>
<cell x="4" y="8" solution="K"/>
<cell x="4" y="9" solution="O"/>
<cell x="4" y="10" type="block"/>
<cell x="4" y="11" solution="F"/>
<cell x="4" y="12" solution="I"/>
<cell x="4" y="13" solution="J"/>
<cell x="4" y="14" solution="A"/>
<cell x="4" y="15" solution="S"/>
<cell x="5" y="1" solution="P"/>
<cell x="5" y="2" type="block"/>
<cell x="5" y="3" solution="A"/>
<cell x="5" y="4" solution="T"/>
<cell x="5" y="5" solution="E"/>
<cell x="5" y="6" solution="N"/>
<cell x="5" y="7" solution="Y"/>
<cell x="5" y="8" type="block"/>
<cell x="5" y="9" solution="R"/>
<cell x="5" y="10" solution="W"/>
<cell x="5" y="11" solution="E"/>
<cell x="5" y="12" type="block"/>
<cell x="5" y="13" solution="A"/>
<cell x="5" y="14" solution="J"/>
<cell x="5" y="15" solution="A"/>
<cell x="6" y="1" solution="A"/>
<cell x="6" y="2" solution="S"/>
<cell x="6" y="3" solution="C"/>
<cell x="6" y="4" solution="O"/>
<cell x="6" y="5" solution="N"/>
<cell x="6" y="6" solution="A"/>
<cell x="6" y="7" type="block"/>
<cell x="6" y="8" solution="C"/>
<cell x="6" y="9" solution="Z"/>
<cell x="6" y="10" solution="E"/>
<cell x="6" y="11" solution="R"/>
<cell x="6" y="12" solution="W"/>
<cell x="6" y="13" type="block"/>
<cell x="6" y="14" solution="N"/>
<cell x="6" y="15" type="block"/>
<cell x="7" y="1" solution="D"/>
<cell x="7" y="2" solution="Y"/>
<cell x="7" y="3" solution="Z"/>
<cell x="7" y="4" solution="M"/>
<cell x="7" y="5" solution="A"/>
<cell x="7" y="6" type="block"/>
<cell x="7" y="7" solution="B"/>
<cell x="7" y="8" solution="Z"/>
<cell x="7" y="9" solution="Y"/>
<cell x="7" y="10" solution="K"/>
<cell x="7" y="11" type="block"/>
<cell x="7" y="12" solution="O"/>
<cell x="7" y="13" solution="B"/>
<cell x="7" y="14" solution="Ó"/>
<cell x="7" y="15" solution="J"/>
<cell x="8" y="1" solution="E"/>
<cell x="8" y="2" solution="N"/>
<cell x="8" y="3" solution="E"/>
<cell x="8" y="4" solution="A"/>
<cell x="8" y="5" type="block"/>
<cell x="8" y="6" solution="S"/>
<cell x="8" y="7" solution="I"/>
<cell x="8" y="8" solution="A"/>
<cell x="8" y="9" solution="N"/>
<cell x="8" y="10" solution="A"/>
<cell x="8" y="11" type="block"/>
<cell x="8" y="12" solution="L"/>
<cell x="8" y="13" solution="E"/>
<cell x="8" y="14" solution="W"/>
<cell x="8" y="15" solution="A"/>
<cell x="9" y="1" solution="K"/>
<cell x="9" y="2" solution="E"/>
<cell x="9" y="3" solution="K"/>
<cell x="9" y="4" solution="S"/>
<cell x="9" y="5" type="block"/>
<cell x="9" y="6" solution="K"/>
<cell x="9" y="7" solution="A"/>
<cell x="9" y="8" solution="P"/>
<cell x="9" y="9" solution="A"/>
<cell x="9" y="10" type="block"/>
<cell x="9" y="11" solution="M"/>
<cell x="9" y="12" solution="A"/>
<cell x="9" y="13" solution="R"/>
<cell x="9" y="14" solution="K"/>
<cell x="9" y="15" solution="S"/>
<cell x="10" y="1" type="block"/>
<cell x="10" y="2" solution="C"/>
<cell x="10" y="3" type="block"/>
<cell x="10" y="4" solution="Z"/>
<cell x="10" y="5" solution="W"/>
<cell x="10" y="6" solution="A"/>
<cell x="10" y="7" solution="Ł"/>
<cell x="10" y="8" solution="Y"/>
<cell x="10" y="9" type="block"/>
<cell x="10" y="10" solution="M"/>
<cell x="10" y="11" solution="A"/>
<cell x="10" y="12" solution="N"/>
<cell x="10" y="13" solution="G"/>
<cell x="10" y="14" solution="A"/>
<cell x="10" y="15" solution="N"/>
<cell x="11" y="1" solution="P"/>
<cell x="11" y="2" solution="Z"/>
<cell x="11" y="3" solution="U"/>
<cell x="11" y="4" type="block"/>
<cell x="11" y="5" solution="Ł"/>
<cell x="11" y="6" solution="Z"/>
<cell x="11" y="7" solution="A"/>
<cell x="11" y="8" type="block"/>
<cell x="11" y="9" solution="J"/>
<cell x="11" y="10" solution="A"/>
<cell x="11" y="11" solution="Ł"/>
<cell x="11" y="12" solution="T"/>
<cell x="11" y="13" solution="A"/>
<cell x="11" y="14" type="block"/>
<cell x="11" y="15" solution="O"/>
<cell x="12" y="1" solution="L"/>
<cell x="12" y="2" solution="E"/>
<cell x="12" y="3" solution="R"/>
<cell x="12" y="4" solution="K"/>
<cell x="12" y="5" solution="A"/>
<cell x="12" y="6" type="block"/>
<cell x="12" y="7" solution="C"/>
<cell x="12" y="8" solution="H"/>
<cell x="12" y="9" solution="O"/>
<cell x="12" y="10" solution="D"/>
<cell x="12" y="11" solution="Y"/>
<cell x="12" y="12" type="block"/>
<cell x="12" y="13" solution="M"/>
<cell x="12" y="14" type="block"/>
<cell x="12" y="15" solution="W"/>
<cell x="13" y="1" solution="A"/>
<cell x="13" y="2" solution="K"/>
<cell x="13" y="3" solution="O"/>
<cell x="13" y="4" solution="R"/>
<cell x="13" y="5" solution="D"/>
<cell x="13" y="6" type="block"/>
<cell x="13" y="7" solution="Z"/>
<cell x="13" y="8" solution="O"/>
<cell x="13" y="9" solution="L"/>
<cell x="13" y="10" solution="E"/>
<cell x="13" y="11" type="block"/>
<cell x="13" y="12" solution="F"/>
<cell x="13" y="13" solution="O"/>
<cell x="13" y="14" solution="K"/>
<cell x="13" y="15" solution="I"/>
<cell x="14" y="1" solution="S"/>
<cell x="14" y="2" type="block"/>
<cell x="14" y="3" solution="D"/>
<cell x="14" y="4" solution="E"/>
<cell x="14" y="5" solution="C"/>
<cell x="14" y="6" solution="Z"/>
<cell x="14" y="7" solution="K"/>
<cell x="14" y="8" solution="O"/>
<cell x="14" y="9" type="block"/>
<cell x="14" y="10" solution="R"/>
<cell x="14" y="11" solution="A"/>
<cell x="14" y="12" solution="U"/>
<cell x="14" y="13" solution="T"/>
<cell x="14" y="14" type="block"/>
<cell x="14" y="15" solution="D"/>
<cell x="15" y="1" solution="K"/>
<cell x="15" y="2" solution="R"/>
<cell x="15" y="3" solution="A"/>
<cell x="15" y="4" solution="S"/>
<cell x="15" y="5" solution="A"/>
<cell x="15" y="6" type="block"/>
<cell x="15" y="7" solution="A"/>
<cell x="15" y="8" solution="K"/>
<cell x="15" y="9" solution="R"/>
<cell x="15" y="10" solution="A"/>
<cell x="15" y="11" type="block"/>
<cell x="15" y="12" solution="J"/>
<cell x="15" y="13" solution="A"/>
<cell x="15" y="14" solution="Z"/>
<cell x="15" y="15" solution="Z"/>
</grid>
<word id="1" x="1-9" y="1"/>
<word id="2" x="11-15" y="1"/>
<word id="3" x="6-13" y="2"/>
<word id="4" x="1-9" y="3"/>
<word id="5" x="11-15" y="3"/>
<word id="6" x="1-3" y="4"/>
<word id="7" x="5-10" y="4"/>
<word id="8" x="12-15" y="4"/>
<word id="9" x="4-7" y="5"/>
<word id="10" x="10-15" y="5"/>
<word id="11" x="1-6" y="6"/>
<word id="12" x="8-11" y="6"/>
<word id="13" x="3-5" y="7"/>
<word id="14" x="7-15" y="7"/>
<word id="15" x="1-4" y="8"/>
<word id="16" x="6-10" y="8"/>
<word id="17" x="12-15" y="8"/>
<word id="18" x="1-9" y="9"/>
<word id="19" x="11-13" y="9"/>
<word id="20" x="5-8" y="10"/>
<word id="21" x="10-15" y="10"/>
<word id="22" x="1-6" y="11"/>
<word id="23" x="9-12" y="11"/>
<word id="24" x="1-4" y="12"/>
<word id="25" x="6-11" y="12"/>
<word id="26" x="13-15" y="12"/>
<word id="27" x="1-5" y="13"/>
<word id="28" x="7-15" y="13"/>
<word id="29" x="3-10" y="14"/>
<word id="30" x="1-5" y="15"/>
<word id="31" x="7-15" y="15"/>
<word id="32" x="1" y="1-4"/>
<word id="33" x="3" y="1-4"/>
<word id="34" x="6" y="1-6"/>
<word id="35" x="7" y="1-5"/>
<word id="36" x="8" y="1-4"/>
<word id="37" x="9" y="1-4"/>
<word id="38" x="11" y="1-3"/>
<word id="39" x="12" y="1-5"/>
<word id="40" x="13" y="1-5"/>
<word id="41" x="15" y="1-5"/>
<word id="42" x="2" y="3-6"/>
<word id="43" x="5" y="3-7"/>
<word id="44" x="14" y="3-8"/>
<word id="45" x="10" y="4-8"/>
<word id="46" x="4" y="5-9"/>
<word id="47" x="11" y="5-7"/>
<word id="48" x="1" y="6-9"/>
<word id="49" x="3" y="6-9"/>
<word id="50" x="8" y="6-10"/>
<word id="51" x="9" y="6-9"/>
<word id="52" x="7" y="7-10"/>
<word id="53" x="12" y="7-11"/>
<word id="54" x="13" y="7-10"/>
<word id="55" x="15" y="7-10"/>
<word id="56" x="2" y="8-13"/>
<word id="57" x="6" y="8-12"/>
<word id="58" x="5" y="9-11"/>
<word id="59" x="11" y="9-13"/>
<word id="60" x="10" y="10-15"/>
<word id="61" x="14" y="10-13"/>
<word id="62" x="1" y="11-15"/>
<word id="63" x="3" y="11-15"/>
<word id="64" x="4" y="11-15"/>
<word id="65" x="9" y="11-15"/>
<word id="66" x="7" y="12-15"/>
<word id="67" x="8" y="12-15"/>
<word id="68" x="13" y="12-15"/>
<word id="69" x="15" y="12-15"/>
<word id="70" x="5" y="13-15"/>
<clues ordering="by-position">
<title>
<b>Poziomo:</b>
</title>
<clue word="1" number="1" format="9">Jeden z tych, które chodz¹ po
ludziach.</clue>
<clue word="2" number="" format="5">Odg³os st¹pania bos¹ nog¹.</clue>
<clue word="3" number="2" format="8">Ukochany mamy.</clue>
<clue word="4" number="3" format="9">Ubogi szlachcic zaœciankowy.</
clue>
<clue word="5" number="" format="5">As atutowy bia³og³owy.</clue>
<clue word="6" number="4" format="3">Szpik w koœciach wo³owych.</clue>
<clue word="7" number="" format="6">Jeden by³ niewierny.</clue>
<clue word="8" number="" format="4">Zawsze nadchodzi.</clue>
<clue word="9" number="5" format="4">Optyczne miasto w Niemczech.</
clue>
<clue word="10" number="" format="6">Na tronie w koronie.</clue>
<clue word="11" number="6" format="6">W "Pi³karskim pokerze" za mecz
nie bierze.</clue>
<clue word="12" number="" format="4">
Typ narracji w formie bezpoœredniego, potocznego monologu.
</clue>
<clue word="13" number="7" format="3">Azoik i eozoik.</clue>
<clue word="14" number="" format="9">Choroba uk³adu krwiotwórczego,
leukemia.</clue>
<clue word="15" number="8" format="4">Czêsto siê go s³yszy u zawiasów
i myszy.</clue>
<clue word="16" number="" format="5">Zak³adane przez koszykarzy.</
clue>
<clue word="17" number="" format="4">W re¿yserskim dorobku
Spielberga.</clue>
<clue word="18" number="9" format="9">O miernym "komediancie".</clue>
<clue word="19" number="" format="3">¯aglowiec dwumasztowy.</clue>
<clue word="20" number="10" format="4">Barowa bu³ka zwana te¿ bu³ka
parysk¹.</clue>
<clue word="21" number="" format="6">Pó³wytrawne wino portugalskie jak
wyspa.</clue>
<clue word="22" number="11" format="6">Kierowca jaœniepana.</clue>
<clue word="23" number="" format="4">"… Budda", film Bertolucciego.</
clue>
<clue word="24" number="12" format="4">Luby powieœciowej Mei.</clue>
<clue word="25" number="" format="6">Ko³o sterowe p³atowca.</clue>
<clue word="26" number="" format="3">Potocznie: wyra¿enie
dezaprobaty.</clue>
<clue word="27" number="13" format="5">Szeroko zakrojona.</clue>
<clue word="28" number="" format="9">Odmiana gruszy jesiennej.</clue>
<clue word="29" number="14" format="8">Miasto w woj. podlaskim nad
Leœn¹.</clue>
<clue word="30" number="15" format="5">Przegl¹dana z rana.</clue>
<clue word="31" number="" format="9">By³ nim Nostradamus.</clue>
</clues>
<clues ordering="by-position">
<title>
<b>Pionowo:</b>
</title>
<clue word="32" number="A" format="4">Dieta dla wiernych.</clue>
<clue word="48" number="" format="4">Powiêksza maczek.</clue>
<clue word="62" number="" format="5">Indiañskie trofeum wojenne.</
clue>
<clue word="42" number="B" format="4">"Kacza …", film z braæmi Marx.</
clue>
<clue word="56" number="" format="6">Ryba gotowa do godów.</clue>
<clue word="33" number="C" format="4">Diakrytyczny lub jakoœci.</clue>
<clue word="49" number="" format="4">Czasem zastêpuje s³owo.</clue>
<clue word="63" number="" format="5">Drzewo lub krzew z brzozowatych.</
clue>
<clue word="46" number="D" format="5">
Bohun, Kozak z "Ogniem i mieczem" Henryka Sienkiewicza.
</clue>
<clue word="64" number="" format="5">Piotr, trenowa³ Ma³ysza.</clue>
<clue word="43" number="E" format="5">
Europejska stolica z Teatrem Dionizosa i Wie¿¹ Wiatrów.
</clue>
<clue word="58" number="" format="3">Radio Wolna Europa.</clue>
<clue word="70" number="" format="3">Fragment œwiêtej ksiêgi
muzu³manów.</clue>
<clue word="34" number="F" format="6">Znany model Opla.</clue>
<clue word="57" number="" format="5">Stadium rozwojowe pszczo³y.</
clue>
<clue word="35" number="G" format="5">Karierowicz, którego stworzy³
Do³êga-Mostowicz.</clue>
<clue word="52" number="" format="4">DŸwiêk lec¹cego komara.</clue>
<clue word="66" number="" format="4">Gra na nim Wojnowicz.</clue>
<clue word="36" number="H" format="4">Dystrybutor energii
elektrycznej.</clue>
<clue word="50" number="" format="5">S¹ zbierane z ³¹k.</clue>
<clue word="67" number="" format="4">Bitka, ale nie bójka.</clue>
<clue word="37" number="I" format="4">Mami bakaliami.</clue>
<clue word="51" number="" format="4">Na ³ó¿ku bywa, choæ nie
odpoczywa.</clue>
<clue word="65" number="" format="5">Karol, niemiecki dzia³acz
rewolucyjny.</clue>
<clue word="45" number="J" format="5">Masa œniegu lub gruzu.</clue>
<clue word="60" number="" format="6">Metal o czerwonawym po³ysku, Mn.</
clue>
<clue word="38" number="K" format="3">Polska firma ubezpieczeniowa.</
clue>
<clue word="47" number="" format="3">Roniona przez krokodyla.</clue>
<clue word="59" number="" format="5">Kurort na Krymie, z muzeum
Czechowa.</clue>
<clue word="39" number="L" format="5">Ptak z rodziny skowronków.</
clue>
<clue word="53" number="" format="5">Ma je szybki i wp³ywowy.</clue>
<clue word="40" number="M" format="5">Muzyczny system p³acy.</clue>
<clue word="54" number="" format="4">
Roztwory koloidowe, w których faz¹ rozpraszaj¹c¹ jest ciecz.
</clue>
<clue word="68" number="" format="4">"Komando …", film z Charlie
Sheenem.</clue>
<clue word="44" number="N" format="6">Krzta, drobina.</clue>
<clue word="61" number="" format="4">Proszony u konsula.</clue>
<clue word="41" number="O" format="5">NadobnoϾ, uroda.</clue>
<clue word="55" number="" format="4">Stolica Ghany, afrykañskiego
kraju.</clue>
<clue word="69" number="" format="4">Dziedzina Ptaszyna.</clue>
</clues>
</crossword>




its big but this is the XML

Thank you
Reply all
Reply to author
Forward
0 new messages