How to store and update data table on client side (iOS MMO)

Posted by farseer2012 on Game Development See other posts from Game Development or by farseer2012
Published on 2012-10-18T04:16:46Z Indexed on 2012/10/18 5:23 UTC
Read the original article Hit count: 226

Filed under:

ios

|

mmo

|

databases

|

synchronization

Currently i'm developing an iOS MMO game with cocos2d-x, that game depends on many data tables(excel file) given by the designers. These tables contain data like how much gold/crystal will be cost when upgrade a building(barracks, laboratory etc..). We have about 10 tables, each have about 50 rows of data. My question is how to store those tables on client side and how to update them once they have been modified on server side? My opinion: use Sqlite to store data on client side, the server will parse the excel files and send the data to client with JSON format, then the client parse the JOSN string and save it to Sqlite file. Is there any better method? I find that some game stores csv files on client side, how do they update the files? Could server send a whole file directly to client?

© Game Development or respective owner

Related posts about ios

Regarding Xcode SDK IOS 4.2 installation and missing iOS 4.1

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, i have download Xcode SDK 4.2(xcode_3.2.5_and_ios_sdk_4.2_final.dmg) from Apple developer site and installed successfully . when open my old xcode project it shows baseSDk missing ,when i try to change project setting ,i have found and set base SDk as 4.2 it works fine my problem is ,in… >>> More
fatal: pathspec for removing folder in git

as seen on Super User - Search for 'Super User'
I want to remove a folder from a Git repository but I get an error. I tried several commands, and here you can see my errors: selnaz:iOS Lnaz$ ls iOS-Tidinfo mockup readme.txt selnaz:iOS Lnaz$ git rm -r -- iOS-Tidinfo/ fatal: pathspec 'tidinfo/iOS/iOS-Tidinfo/' did not match any files selnaz:iOS… >>> More
Autorotate works for iOS 6 but gives weird behavior in iOS 5

as seen on Stack Overflow - Search for 'Stack Overflow'
I seem to be having the opposite problem from this post: Autorotate in iOS 6 has strange behaviour When I submitted my paid app to Apple, XCode made me update to iOS 6 on my test devices. I used the GUI in XCode to set my app to display only in portrait mode on the iPhone and only in landscape… >>> More
App is getting run in iOS 5.1.1 but crashed in iOS 6.1.3

as seen on Stack Overflow - Search for 'Stack Overflow'
I have implemented below code but app has been crashed in iPad with iOS version 6.1.3,while running perfectly in iPad with iOS version 5.1.1. when I am scrolling table view continuously it is crashed in ios version 6.1.3. what could be the issue. The implemented delegate and data source methods for… >>> More
No provisioned iOS devices are available with a compatible iOS version

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to test my app on an iPhone 3G, however I'm getting this error: No provisioned iOS devices are available with a compatible iOS version. Connect an iOS device with a recent enough version of iOS to run your application or choose an iOS simulator as the destination. Note that: The 3G… >>> More

Related posts about mmo

Resources such as libraries, engines and frameworks to make Javacript-based MMORTS? [closed]

as seen on Game Development - Search for 'Game Development'
I am looking for resources outlined to make a MMORTS with Javascript as the client-side, probably just a simple canvas for the frontend. The guy in the video here mentions that JavaScript is one of the most misunderstood language -- and I do believe that. I think one can make quite cool games with… >>> More
Feedback on "market manipulation", a peripheral game mechanic for a satirical MMO

as seen on Game Development - Search for 'Game Development'
This question asks for feedback on a specific game-mechanic. Since there is not one right feedback on a game mechanic, I tried to provide enough context and guidelines to still make it possible for users to rate answers and to accept an answer as the best answer (following these criteria from Writer… >>> More
Polygon count target range for MMO being released in 2 years

as seen on Game Development - Search for 'Game Development'
What would a realistic poly count target range be for NPC and player models in a 3D MMO that will be released in 2 years? What about poly count target range for the entire camera view (environment, NPC and player meshes)? I read in some places that one should not aim too low if the game will come… >>> More
Node.js MMO - process and/or map division

as seen on Game Development - Search for 'Game Development'
I am in the phase of designing a mmo browser based game (certainly not massive, but all connected players are in the same universe), and I am struggling with finding a good solution to the problem of distributing players across processes. I'm using node.js with socket.io. I have read this helpful… >>> More
MMO Data Persistence Question

as seen on Game Development - Search for 'Game Development'
I wanted to ask a question regarding data persistence strategies for an MMO. I have some experience in the games industry with social synchronous games. At Zynga, we stored static proto data in XML on both the client and the server and stored instance/runtime data in membase. For clarity sake,… >>> More