Pointshop MySQL

So… I’ve been trying to import files from sv.db to mysql for pointshop and that worked just fine but for some reason since i did it, clients are crashing to desktop.

This is what happends when they crash:


Precache of trails/greensvamp ambigious (no extension specified)
Setting CSprite to non-sprite model trails/greensvamp
Dropped FMxDeMoNzZ from server (FMxDeMoNzZ timed out)

I don’t know what it could be because it’s working just fine while using pdata. Does anyone why is this happening?
This is caused by greensvamp trail as you can see but i don’t know why… It wasn’t crashing anyone like that while i was using pdata.

I created an exporter… sv.db ( and pointshop ) uses PData which stores data in this format: <uniqueid>[<column_name>], <data> which is terrible in my opinion.

If you want to export that to MySQL you need to weed out all of the other trash… Here was one example: https://dl.dropboxusercontent.com/u/26074909/tutoring/database/converting_sv_db_to_mysql.lua.html

And the one for pointshop: https://dl.dropboxusercontent.com/u/26074909/tutoring/database/converting_sv_db_pointshop_to_mysql.lua.html ( remove .html to view .lua )