SQLite

[devilsknite1]

Originally Posted by napo_p2p

It looks like there's an error in one of your queries (you forgot the single quotes). Try this:

PHP Code:

requestsql("INSERT INTO test VALUES ('" @ p.account @ "'," @ p.id @ ")", false); 


Output:

NPC Code:

---

Accounts in database: 0

---

Although, not sure since it could have been Stefan's suggestion that broke it ;o

[Inverness]

Originally Posted by devilsknite1

Output:

NPC Code:

---

Accounts in database: 0

---

Although, not sure since it could have been Stefan's suggestion that broke it ;o

You restarted the NPC-Server already to enable the SQL right?

Also, SQLite only has a few column types: TEXT, NUMERIC, INTEGER, REAL, NONE. Other types work for compatibility but they're just aliases for one of these types, I suggest these be used for clarity.

http://www.sqlite.org/datatype3.html

[devilsknite1]

Originally Posted by Inverness

You restarted the NPC-Server already to enable the SQL right?

Yes, I've done this. Multiple times...