Thread: A SQL code to run to add additional options in 'attrs' field.
View Single Post
vodka00
Veteran Member
vodka00's Avatar
Join Date: Jun 2012
Location: Los Angeles
Old 04-24-2013 , 13:54   Re: A SQL code to run to add additional options in 'attrs' field.
Reply With Quote #6
Quote:
Originally Posted by alongub View Post
Code:
UPDATE store_items SET store_items.attrs = LEFT(atrs, LENGTH(attrs) - 1) + ', "lifetime": 0.5, "width": 15, "endwidth": 3, "fadelength": 5 }' WHERE store_items.type = 'equipment'
This set all attrs fields that were in equipment to 0.
__________________
cw main:

cw speedruns:
Last edited by vodka00; 04-24-2013 at 14:00.
vodka00 is offline