[CS:GO] Lights plugin sqlite > mysql conversion

**sneaK** · **Author**

Hey guys, I'm using an edit of the Christmasification plugin (attached) for CS:GO.

Currently, it only supports sqlite, mysql doesn't work properly. Also, when using this plugin I noticed at some point it simply stopped displaying lights, perhaps because my database was so big? It saves each individual light coordinate, for ~10-15 maps I used it on, there's over 5000 rows.

Could someone modify this so it works properly with mysql, and doesn't have issues with not displaying lights anymore? Thanks!

Totenfluch · 10-31-2016 , 20:30 Re: [CS:GO] Lights plugin sqlite > mysql conversion

1. Why would you use Stacks? ArrayLists are much more comfortable.
2. use Floats instead of REALs in your MySQL table
3. New Syntax.. please..
4. Save the reference to the sprite not the sprite

The last Point could be the Reason for your Bug

**sneaK** · *Last edited by sneaK; 10-31-2016 at 20:35.*

I didn't code any of this, this plugin is from 2012, merely updated by Franc1sco to work with CS:GO.

I do agree however, this plugin could definitely use some updating/optimizations overall.

xines · 10-31-2016 , 20:35 Re: [CS:GO] Lights plugin sqlite > mysql conversion

Quote:

Originally Posted by Totenfluch

1. Why would you use Stacks? ArrayLists are much more comfortable.
2. use Floats instead of REALs in your MySQL table
3. New Syntax.. please..
4. Save the reference to the sprite not the sprite

The last Point could be the Reason for your Bug

Did you see blackhawk74 as the author of the script, because i didn't