Помощь по созданию Online серверов

Информация о пользователе

Привет, Гость! Войдите или зарегистрируйтесь.

Авторесет

Страница:   1 2

Сообщений 31 страница 33 из 33

31

  • Автор: BaRoNs
  • Ковбой
  • BaRoNs
  • Зарегистрирован: 2006-10-31
  • Приглашений: 0
  • Сообщений: 1419
  • Уважение: [+0/-0]
  • Позитив: [+0/-0]
  • Провел на форуме:
    Не определено
  • Последний визит:
    2015-04-23 02:07:30

Вобщем вот:

Код:
UPDATE Character SET clevel= 1, Experience= 0, Money= Money-100000000, Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, MagicList = NULL, INVENTORY=Null, MapNumber= 0, MapPosX=125, MapPosY= 123, PkLevel= 3, Resets = Resets+1, LevelUpPoint = (350 * (Resets + 1)) 
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI 
WHERE ((class = 0) OR (class = 1)) and (clevel>399) and (Money > (99999999)) AND (pklevel < 4) and (ConnectStat = 0)

UPDATE Character SET clevel= 1,Experience= 0, Money=Money-100000000, Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, MagicList = NULL, INVENTORY=Null, MapNumber= 0, MapPosX= 125, MapPosY= 123, PkLevel= 3, Resets = Resets+1, LevelUpPoint = (350 * (Resets + 1)) 
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI 
WHERE ((class = 16) OR (class = 17)) and (clevel>399) and (Money > (99999999)) AND (pklevel < 4) and (ConnectStat = 0)

UPDATE Character SET clevel= 1, Experience= 0, Money=Money-100000000, Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, MagicList = NULL, INVENTORY=Null, MapNumber= 0, MapPosX= 125, MapPosY= 123, PkLevel= 3, Resets=Resets+1, LevelUpPoint = (350 * (Resets + 1)) 
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI 
WHERE ((class = 32) OR (class = 33)) and (clevel>399) and (Money > (99999999)) AND (pklevel < 4) and (ConnectStat = 0)

UPDATE Character SET clevel= 1, Experience= 0, Money=Money-100000000, Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, MapNumber=0, MagicList = NULL, INVENTORY=Null, MapPosX= 125, MapPosY= 123, PkLevel= 3, LevelUpPoint= (400* (Resets + 1)) 
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI 
WHERE (class = 48 ) and (clevel>400) and (Money > (99999999)) AND (pklevel < 4) and (ConnectStat = 0)

UPDATE Character SET clevel= 1, Experience= 0, Money= Money-100000000, Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, MagicList = NULL, INVENTORY=Null, MapNumber= 0, MapPosX= 125, MapPosY= 123, PkLevel= 3, Resets = Resets+1, LevelUpPoint = (400 * (Resets + 1)) 
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI 
WHERE (class = 64) and (clevel>399) and (Money > (99999999)) AND (pklevel < 4) and (ConnectStat = 0)

В полне рабочий скрипт сам его юзал)
1.Создаеш колонку не Reset а Resets
2.Все получают статы 350, МГ и ДЛ 400
3.Ресет с 400 лвл но можеш сменить  (clevel>399) вот тут..
4.На рес нуно 100кк

Отредактировано BaRoNs (2007-05-12 05:01:39)

0

32

  • Автор: MakC
  • Юзер
  • Зарегистрирован: 2007-05-01
  • Приглашений: 0
  • Сообщений: 1
  • Уважение: [+0/-0]
  • Позитив: [+0/-0]
  • Провел на форуме:
    Не определено
  • Последний визит:
    2007-07-09 17:19:34
Код:
UPDATE Character
SET clevel = 1, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 0) OR (class = 1)) AND (clevel >= 350) AND (Money >= (0)) AND (ConnectStat = 0);

UPDATE Character
SET clevel = 1, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 16) OR (class = 17)) AND (clevel >= 350) AND (Money >= (0)) AND (ConnectStat = 0);

UPDATE Character
SET clevel = 1, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 32) OR (class = 33)) AND (clevel >= 350) AND (Money >= (0)) AND (ConnectStat = 0);

UPDATE Character
SET clevel = 1, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 48) OR (class = 64)) AND (clevel >= 350) AND (Money >= (0)) AND (ConnectStat = 0);

1.Переделал с скрипта Травика.
2.Тоже создайте не Ресет а Ресетс(в таблице)
3.Обнуляетса тока левел и на сайте рес показывает!=)

0

33

  • Автор: gavnaed
  • Юзер
  • Зарегистрирован: 2007-07-02
  • Приглашений: 0
  • Сообщений: 1
  • Уважение: [+0/-0]
  • Позитив: [+0/-0]
  • Провел на форуме:
    Не определено
  • Последний визит:
    2007-07-27 19:23:36

Vsem privet!!! 9 postavil svoi server, sdelal novie spoti, vse kak bi rabotaet, no est' odno no... 9 ne mogy ystanovit' avto reset, delay vse tak kak vi opisali... No vse ravno pishet not running and Failed... pomogite plz... Sdelaite kto-nebyt' takoi skrip 4tobi ni4ego ne is4ezalo... vse ostavalo' ... zaranie blagodaren...

0

Страница:   1 2