Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @Echo Off
- SetLocal EnableDelayedExpansion
- ::===Settings=======
- Set $MySQL=E:\gameservers\env\mysql\bin
- Set $Host=localhost
- Set $Database=emurt_gracia_epilogue
- Set $Username=root
- Set $Pass=p455W0rd
- Set $CharID_RegForDusk=268493803
- ::==================
- :: Добавляем бинарники в path
- Set Path=%$MySQL%;%Path%
- :: и создаём команду для быстрого обращения
- Set MySQL=mysql -u%$Username% -p%$Pass% -h%$Host% %$Database% --skip-column-names
- :: Пишем массив со всеми игроками кроме выбранного к реге за Dusk
- Echo Retrieving character info from DB
- Set Characters=0
- Set "$RegForDawn[]="
- For /F "delims= tokens=*" %%A In ('^
- Echo SELECT obj_id FROM characters^|^
- %MySQL%^|^
- Find /V "%$CharID_RegForDusk%"^
- ') Do (
- Set /A Characters+=1
- Set "$RegForDawn[]=!$RegForDawn[]! %%A"
- )
- :: Очищаем таблицу
- Echo TRUNCATE seven_signs|%MySQL%
- :: Вносим данные по каждому из игроков (не донатя камни, игрок сделает это самостоятельно!)
- Set n=0
- Set i=0
- For %%A In (%$RegForDawn[]%) Do (
- If !n!==3 Set n=0
- Set /A n+=1
- Echo INSERT INTO `seven_signs` ^(^
- `char_obj_id`,^
- `cabal`,^
- `seal`,^
- `dawn_red_stones`,^
- `dawn_green_stones`,^
- `dawn_blue_stones`,^
- `dawn_ancient_adena_amount`,^
- `dawn_contribution_score`,^
- `dusk_red_stones`,^
- `dusk_green_stones`,^
- `dusk_blue_stones`,^
- `dusk_ancient_adena_amount`,^
- `dusk_contribution_score`^
- ^)^
- VALUES ^(%%A, 'dawn', !n!, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0^);|%MySQL%
- Set /A i+=1
- Echo Processing !i! from %Characters% records...
- )
- :: Регистрируем игрока за Dusk с фиксированной суммой камней, которую легко перебить
- Echo INSERT INTO `seven_signs` ^(^
- `char_obj_id`,^
- `cabal`,^
- `seal`,^
- `dawn_red_stones`,^
- `dawn_green_stones`,^
- `dawn_blue_stones`,^
- `dawn_ancient_adena_amount`,^
- `dawn_contribution_score`,^
- `dusk_red_stones`,^
- `dusk_green_stones`,^
- `dusk_blue_stones`,^
- `dusk_ancient_adena_amount`,^
- `dusk_contribution_score`^
- ^)^
- VALUES ^(%$CharID_RegForDusk%, 'dusk', 3, 0, 0, 0, 0, 0, 0, 0, 100000, 300000, 300000^);|%MySQL%
- Echo All done.
- Pause&Exit
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement