Скрипты

[the-searcher]

_________________________________
ПОИСК КАРТ

select*
from gk.ACCOUNTS
Where card = xxx
Where CARD >= xxx and CARD <= xxx

select*
from gk.ACCOUNTS
where level=xxx and isactive=xxx

Select*
From gk.CARDS
Where card = xxx
Where CARD >= xxx and CARD <= xxx

_________________________________
БЛОКИРОВАНИЕ КАРТ

Update gk.ACCOUNTS
set isactive=0
WHERE CARD = xxx
or CARD = xxx
or CARD = xxx

Where CARD >= xxx and CARD <= xxx

_________________________________
БЛОКИРОВАНИЕ КАРТЫ ПО УРОВНЮ

Update gk.ACCOUNTS
set isactive=0
Where level=xxx

__________________________________
УСТАНОВКА НОВОГО УРОВНЯ ДЛЯ КАРТЫ

Update gk.ACCOUNTS
set level=xxx
Where card= xxx
Where CARD >= xxx and CARD <= xxx

__________________________________
УДАЛЕНИЕ КАРТ

Delete
From gk.CARDS
Where CARD >= xxxxxxxxx and CARD <= xxxxxxxx



Update gk.CARDS
set ENABLED=0


Delete
From gk.ACCOUNTS
Where CARD=

Where CARD >= xxx and CARD <= xxx

Update gk.CARDS
Set ACCOUNT=NULL
Where CARD=

Where CARD >= xxx and CARD <= xxx

_________________
Delete
From gk.ACCOUNTS
Where CARD >= xxx and CARD <= xxx

Delete
From gk.CARDS
Where CARD >= xxx and CARD <= xxx

Where CARD=
_________________
ЗАМЕНА НОМЕРА УРОВНЯ


use gkArcade
GO
Update gk.ACCOUNTS
set level=xxx
Where level=xxx


use gkHeadOffice
GO
Update gk.ACCOUNTS
set level=xxx
Where level=xxx


___________________________________

!!!!!!!!!!!!!!!!!!!!!!!!!!!!
ПРЕДОПЛАЧЕННЫЕ КАРТЫ
- НОМИНАЛЫ


Update gk.ACCOUNTS
Set POINTS=xxx, MONEY=xxx, MONEYTORETURN=xxx, CARDPRICE=xxx, LEVEL=xxx
Where CARD >= xxx and CARD <= xxx

В некоторых базах Moneytoreturn заменяем на money1



_______________________________________
Удаление временного тарифа

Update gk.ACCOUNTS
set level2 = Null, level2expdate=null
Where level2=xxx

_______________________________________
Удаление даты последней игры

Use gkArcade
GO
Update gk.MACHINES Set LASTGAMESTART=Null
GO

[count]

В большинстве случаев после таких запросов отчеты будут кривые, а к админу будет много вопросов.