Sqlite help?

Hi!

I have been programming on and off for a bit with Garry’s Mod lua. I am by no means an expert, but I really want to get this sorted. I would love to see this problem solved.

There was a lovely tutorial on sqlite, but since then it redirects to some adware site.

Does anyone have any advice or documentation I can see? Thanks a lot for reading!

You can try using the one on the old wiki (maurits.tv).
It’s good for learning but I wouldn’t really ‘absorb’ all the habits it emits.

As Nethous said, Mauritius would be a good start.

It’s good for learning the basics as such but my god is the code messy.

Good luck!

I don’t have any specific tuts on SQLite, but it uses SQL the language…

If you want to convert data from player_pdata in SQLite to MySQL then you’d need to break the data apart. Here’s an example on one table then outputting as SQL insert statements.
https://dl.dropboxusercontent.com/u/26074909/tutoring/database/converting_sv_db_to_mysql.lua.html

Basic queries / formats: https://dl.dropboxusercontent.com/u/26074909/tutoring/database/basic_queries_and_query_formats_used_to_check_for_existing_row.lua.html

You can use SQL in the functions, you you can just use the helper functions in SQLite provided with GMod.

Thank you! I was looking for this. The link I had was the one I described.