near "UPDATE": syntax error.

Posted: Monday 14 January 2013

SQLite is a powerful language, however it's different to SQL by a large degree.
They are similar, but overall, immensely different..
If you do get the 'near "UPDATE":' syntax error. Just restructure your SQL code to work with SQLite.

This code:
UPDATE ZPERSISTENTMEMBER
SET ZCAREERLEVEL=4
UPDATE ZPERSISTENTCLOTHING
SET ZQUANTITY=1

Should be changed so that it looks something like this:

BEGIN;
UPDATE ZPERSISTENTMEMBER SET ZCAREERLEVEL=4;
END;
BEGIN;
UPDATE ZPERSISTENTCLOTHING SET ZQUANTITY=1;
END;

Notice the added semi-colons, and the added END/BEGIN statements?

And breaking away from the topic, I am indeed working on a hack for a greedy ios freemium game called, Campus life. To be honest, it was too easy to defeat.. Actually, the code required to "hack" it is given above.. That's really all you need...
Campus Life/Library/Application Support/campus.sqlite is the file you want to modify, if you know how to..