• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Mysql (uniserver) change value on all

haxborn

haxborn

server dominando, cry is free
Joined
Dec 1, 2011
Messages
126
Reaction score
7
Location
Sweden
Hi, when i changed my AAC site to Gesior new tabs were added to players.
One is called last_comment or something like that and all old characters created
with my old site got no value (NULL), therefore giving an error if you try to Edit your character.

Is there any way to fix all the values at once from NULL to 0?
Will take a long time to change them 1 by 1..

Regards Haxborn
 
Sort by date Sort by votes
Execute it in PhpMyAdmin:
UPDATE players SET last_comment = 0 WHERE last_comment IS NULL

I got no idea what is in 'last_comment' as in my versions of acc. Maker there weren't that column.
 
Upvote 0 Downvote
Really? It was something about comment on the character page. I can't see right now because I'm @work but I'll look when I get home. Thanks alot. REPPED+
 
Upvote 0 Downvote
Back
Top