• 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!

warning fix ( sql )

Sort by date Sort by votes
a example.
I have a ban removed.
( wrong ban )
but..
warning continue.

I need Remove warnings.
( if dont have in ban list )
 
Upvote 0 Downvote
Code: 
UPDATE `accounts` SET `accounts`.`warnings` = 0 WHERE `accounts`.`id` NOT IN (SELECT `bans`.`value` FROM `bans` WHERE `bans`.`value` = `accounts`.`id`)
 
Upvote 0 Downvote

Similar threads

J
  • Question
Error mysql in my console
Replies
1
Views
747
lursky
L
darkangel1
  • Question
TFS 1.X+ Warning - Items::ParseItemNode
Replies
1
Views
261
Unknown Soldier
Unknown Soldier
darkangel1
  • Question
TFS 1.X+ [Warning - Monsters::loadMonster] Non-unique loot item
Replies
1
Views
311
Fjorda
F
Kownikuzyt
  • Question
CreatureEvent::configureEvent | TFS 0.4 | 8.6
Replies
2
Views
225
Kownikuzyt
Kownikuzyt
J
  • Solved
Problem with query Ticket System
Replies
3
Views
398
Mateus Robeerto
Mateus Robeerto
WikiArk21
  • Question
Error MySql
Replies
0
Views
239
WikiArk21
WikiArk21
samuel157
  • Question
TFS 0.X [SQLite] -=[TFS]=- 0.4 8.60 HOW TO CREATE TABLE
Replies
1
Views
303
Addams
Addams
A
  • Question
House dont saved when purchased
Replies
0
Views
186
Azerty
A
ShadowProwl
  • Question
TFS 1.X+ MySQL errors
Replies
6
Views
414
Codinablack
Codinablack
excool
  • Question
TFS 1.5 Downgrade 8.6 by Nekiro Problems while creating the server!
Replies
0
Views
311
excool
excool
Back
Top