24.11.2013, 11:02
Like I said before - you do not need everything from your enum. You're not supposed to save things that are not even needed and are just for in-game things.
For example, do you need to save the Duty? That's something related to in-game only and I assume many more indexes.
Don't worry about the query size, it's normal to use large queries for such as things. Anyways, you can even use Zeex's compiler patch that let the line be 4095 characters so you can be able to call strcat not so many times.
If you're interested: https://sampforum.blast.hk/showthread.php?tid=473595
But.. I'd recommend you to create the table manually from a SQLite Browser so you don't have to execute a query all the time about an already existed table!
For example, do you need to save the Duty? That's something related to in-game only and I assume many more indexes.
Don't worry about the query size, it's normal to use large queries for such as things. Anyways, you can even use Zeex's compiler patch that let the line be 4095 characters so you can be able to call strcat not so many times.
If you're interested: https://sampforum.blast.hk/showthread.php?tid=473595
But.. I'd recommend you to create the table manually from a SQLite Browser so you don't have to execute a query all the time about an already existed table!