[Pytanie]Jak dodac bonusy poczatkowe w navi (np. 3reka)

[Vandetar]

Chodzi mi o to jak dodac na start kazdemu graczu np 3reka powiekszony magazyn i tp w navi pomocy

[Glinka.]

http://www.mpcforum.pl/topic/264790-tut-wszystkie-bony-poczatkowe-przez-navicat/

 

 

 

 

1. Odpalasz serwer

2.Wchodzisz w Navicat zakładkę acount

3.Wchodzimy w Query i otwieramy NewQuery

4. Wpisujemy :

 

 

$gold_expire='czas bonusu np : 27.01.2012 21:56'

$silver_expire='czas bonusu np : 27.01.2012 21:56';

$safebox_expire='czas bonusu np : 27.01.2012 21:56';

$autoloot_expire='czas bonusu np : 27.01.2012 21:56';

$fish_mind_expire='czas bonusu np : 27.01.2012 21:56';

$marriage_fast_expire='czas bonusu np : 27.01.2012 21:56';

$money_drop_rate_expire='czas bonusu np : 27.01.2012 21:56';

 

ALTER TABLE `account`

MODIFY COLUMN `safebox_expire` datetime NOT NULL DEFAULT '2012-01-01 19:00:00' AFTER `silver_expire`,

MODIFY COLUMN `autoloot_expire` datetime NOT NULL DEFAULT '2012-01-01 19:00:00' AFTER `safebox_expire`,

MODIFY COLUMN `marriage_fast_expire` datetime NOT NULL DEFAULT '2012-01-01 19:00:00' AFTER `fish_mind_expire`,

MODIFY COLUMN `gold_expire` datetime NOT NULL DEFAULT '2012-01-01 19:00:00' AFTER `cash`,

MODIFY COLUMN `fish_mind_expire` datetime NOT NULL DEFAULT '2012-01-01 19:00:00' AFTER `autoloot_expire`,

MODIFY COLUMN `silver_expire` datetime NOT NULL DEFAULT '2012-01-01 19:00:00' AFTER `gold_expire`,

MODIFY COLUMN `money_drop_rate_expire` datetime NOT NULL DEFAULT '2012-01-01 19:00:00' AFTER `marriage_fast_expire`;

 

5. Kilkamy "Run" i zamykamy i znowu kilkamy NewQuery wpisujemy :

 

UPDATE account SET safebox_expire = '2018-01-01 18:00:00' WHERE safebox_expire = '0000-00-00 00:00:00' ;

UPDATE account SET autoloot_expire = '2018-01-01 18:00:00' WHERE autoloot_expire = '0000-00-00 00:00:00' ;

UPDATE account SET silver_expire = '2018-01-01 18:00:00' WHERE silver_expire = '0000-00-00 00:00:00' ;

UPDATE account SET gold_expire = '2018-01-01 18:00:00' WHERE gold_expire = '0000-00-00 00:00:00' ;

UPDATE account SET fish_mind_expire = '2018-01-01 18:00:00' WHERE fish_mind_expire = '0000-00-00 00:00:00' ;

UPDATE account SET marriage_fast_expire = '2018-01-01 18:00:00' WHERE marriage_fast_expire = '0000-00-00 00:00:00' ;

UPDATE account SET money_drop_rate_expire = '2018-01-01 18:00:00' WHERE money_drop_rate_expire = '0000-00-00 00:00:00' ;

 

6.Reboot

 

Kopiowanie zawartości tutków to jest dla Ciebie pomoc?

Już lepiej daj link do tutka niż beszczelnie kradniesz czyjąś prace

[NeverDead]

1. Odpalasz serwer

2.Wchodzisz w Navicat zakładkę acount

3.Wchodzimy w Query i otwieramy NewQuery

4. Wpisujemy :

 

 

$gold_expire='czas bonusu np : 27.01.2012 21:56'

$silver_expire='czas bonusu np : 27.01.2012 21:56';

$safebox_expire='czas bonusu np : 27.01.2012 21:56';

$autoloot_expire='czas bonusu np : 27.01.2012 21:56';

$fish_mind_expire='czas bonusu np : 27.01.2012 21:56';

$marriage_fast_expire='czas bonusu np : 27.01.2012 21:56';

$money_drop_rate_expire='czas bonusu np : 27.01.2012 21:56';

 

ALTER TABLE `account`

MODIFY COLUMN `safebox_expire` datetime NOT NULL DEFAULT '2012-01-01 19:00:00' AFTER `silver_expire`,

MODIFY COLUMN `autoloot_expire` datetime NOT NULL DEFAULT '2012-01-01 19:00:00' AFTER `safebox_expire`,

MODIFY COLUMN `marriage_fast_expire` datetime NOT NULL DEFAULT '2012-01-01 19:00:00' AFTER `fish_mind_expire`,

MODIFY COLUMN `gold_expire` datetime NOT NULL DEFAULT '2012-01-01 19:00:00' AFTER `cash`,

MODIFY COLUMN `fish_mind_expire` datetime NOT NULL DEFAULT '2012-01-01 19:00:00' AFTER `autoloot_expire`,

MODIFY COLUMN `silver_expire` datetime NOT NULL DEFAULT '2012-01-01 19:00:00' AFTER `gold_expire`,

MODIFY COLUMN `money_drop_rate_expire` datetime NOT NULL DEFAULT '2012-01-01 19:00:00' AFTER `marriage_fast_expire`;

 

5. Kilkamy "Run" i zamykamy i znowu kilkamy NewQuery wpisujemy :

 

UPDATE account SET safebox_expire = '2018-01-01 18:00:00' WHERE safebox_expire = '0000-00-00 00:00:00' ;

UPDATE account SET autoloot_expire = '2018-01-01 18:00:00' WHERE autoloot_expire = '0000-00-00 00:00:00' ;

UPDATE account SET silver_expire = '2018-01-01 18:00:00' WHERE silver_expire = '0000-00-00 00:00:00' ;

UPDATE account SET gold_expire = '2018-01-01 18:00:00' WHERE gold_expire = '0000-00-00 00:00:00' ;

UPDATE account SET fish_mind_expire = '2018-01-01 18:00:00' WHERE fish_mind_expire = '0000-00-00 00:00:00' ;

UPDATE account SET marriage_fast_expire = '2018-01-01 18:00:00' WHERE marriage_fast_expire = '0000-00-00 00:00:00' ;

UPDATE account SET money_drop_rate_expire = '2018-01-01 18:00:00' WHERE money_drop_rate_expire = '0000-00-00 00:00:00' ;

 

6.Reboot