ArcEmu: Wintergrasp Worldstates - ArcEmu

Jump to content

Toggle shoutbox Lastest Announcements

dfighter  : (07 December 2014 - 12:06 PM) Arcemu is in hibernation mode, please read http://arcemu.org/fo...showtopic=26903
dfighter  : (01 January 2013 - 05:56 PM) Arcemu wishes you all a happy new year!
Hasbro  : (12 September 2012 - 10:01 AM) Please excuse our outage from the web! Our web host had a major malfunction!
dfighter  : (01 September 2012 - 04:05 PM) Since the spam bots just don't want to stop, I've enabled admin verification when registering.
dfighter  : (23 January 2012 - 09:56 PM) Please note that from now on you will need to confirm your email on the wiki in order to edit it!
Hasbro  : (31 December 2011 - 12:50 PM) Happy New Years all!
Navid  : (26 December 2011 - 04:09 AM) Merry Christmas !!!!!! Happy holidays all :)
WAmadeus  : (24 December 2011 - 03:54 PM) Merry Christmas to all!
dfighter  : (24 December 2011 - 11:05 AM) The Arcemu team wishes y'all a Merry Christmukkah!
Hasbro  : (05 October 2011 - 12:53 PM) Looking for web designers for upcoming web related project. If you're interested in designing user interfaces contact me
dfighter  : (02 September 2011 - 03:47 PM) So who here wants vehicles in Arcemu? :P http://arcemu.org/fo...showtopic=25440
Hasbro  : (14 August 2011 - 03:25 PM) Join us on irc, grab an irc client and connect to irc.freenode.net join channel #arcemu /server irc.freenode.net:6667 /join #arcemu
jackpoz  : (03 August 2011 - 05:33 AM) to all Lua Engine (old one) users: please check http://arcemu.org/fo...showtopic=25274
Hasbro  : (20 May 2011 - 05:27 PM) Looking for people experienced with CMake configuration and setup! Contact me asap
Hasbro  : (15 May 2011 - 05:03 PM) ArcEmu is recruiting C++ programmers, contact Hasbro if interested.
paroxysm  : (03 May 2011 - 06:26 PM) Updated luabridge gossip example to describe the whole gossip creation process rather than just how to create menu. Gossip tutorial
paroxysm  : (23 April 2011 - 11:35 AM) Lua writers can refer to the Luabridge Tutorials section in the Wiki to learn how to write gossip code correctly.
Hasbro  : (20 April 2011 - 05:22 PM) Thank you for your continuous contribution of bug reports, we are working on them.
Hasbro  : (17 April 2011 - 03:20 AM) Please consider donating to support our bills. Donations can be sent using PayPal to donations@arcemu.org - Thank you for your support.
paroxysm  : (10 April 2011 - 12:43 AM) Refer to the Luabridge Tutorials section in the Wiki to learn the new syntax of luabridge.
Resize Shouts Area

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Wintergrasp Worldstates

#1 User is offline   dobri88 

  • Member
  • Pip
  • Group: Members
  • Posts: 27
  • Joined: 27-November 10
  • Gender:Male
  • Server OS:Windows

Posted 04 October 2011 - 09:35 AM

Hi there. I am working on the worlstate_templates that should be added for the lake wintergrasp zone. I never played in blizzard and i have no idea if this is blizzlike. Tell me if i missed something.
DELETE FROM `worldstate_templates` WHERE `map` = '571' AND `zone` = '4197';
INSERT INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES
	('571','4197','3710','1'),
	('571','4197','3803','0'),
	('571','4197','3802','0'),
	('571','4197','3801','0'),
	('571','4197','3711','1'),
	('571','4197','3712','1'),
	('571','4197','3713','1'),
	('571','4197','3714','1'),
	('571','4197','3723','0'),
	('571','4197','3724','0'),
	('571','4197','3725','0'),
	('571','4197','3726','0'),
	('571','4197','3727','0'),
	('571','4197','3728','0'),
	('571','4197','3729','0'),
	('571','4197','3730','0'),
	('571','4197','3731','0'),
	('571','4197','3737','0'),
	('571','4197','3738','0'),
	('571','4197','3739','0'),
	('571','4197','3741','0'),
	('571','4197','3742','0'),
	('571','4197','3743','0'),
	('571','4197','3744','0'),
	('571','4197','3745','0'),
	('571','4197','3746','0'),
	('571','4197','3747','0'),
	('571','4197','3748','0'),
	('571','4197','3749','1'),
	('571','4197','3750','1'),
	('571','4197','3751','1'),
	('571','4197','3752','1'),
	('571','4197','3753','1'),
	('571','4197','3754','1'),
	('571','4197','3755','1'),
	('571','4197','3756','1'),
	('571','4197','3757','1'),
	('571','4197','3758','1'),
	('571','4197','3759','1'),
	('571','4197','3760','1'),
	('571','4197','3761','1'),
	('571','4197','3762','1'),
	('571','4197','3763','1'),
	('571','4197','3764','1'),
	('571','4197','3765','1'),
	('571','4197','3766','1'),
	('571','4197','3767','1'),
	('571','4197','3768','1'),
	('571','4197','3769','1'),
	('571','4197','3770','1'),
	('571','4197','3771','1'),
	('571','4197','3772','1'),
	('571','4197','3773','1'),
	('571','4197','3774','0'),
	('571','4197','3775','0'),
	('571','4197','3776','0'),
	('571','4197','3777','0'),
	('571','4197','3778','0'),
	('571','4197','3779','0'),
	('571','4197','3788','0'),
	('571','4197','3790','0'),
	('571','4197','3791','0'),
	('571','4197','3792','0'),
	('571','4197','3793','0'),
	('571','4197','3794','0'),
	('571','4197','3795','0'),
	('571','4197','3796','0'),
	('571','4197','3797','0'),
	('571','4197','3798','0'),
	('571','4197','3799','0'),
	('571','4197','3698','1'),
	('571','4197','3804','0'),
	('571','4197','3805','0'),
	('571','4197','3699','1'),
	('571','4197','3700','1'),
	('571','4197','3701','1'),
	('571','4197','3702','1'),
	('571','4197','3703','1'),
	('571','4197','3704','1'),
	('571','4197','3705','1'),
	('571','4197','3706','1'),
	('571','4197','3806','0'),
	('571','4197','3807','0'),
	('571','4197','3808','0'),
	('571','4197','3809','0'),
	('571','4197','3810','0'),
	('571','4197','3811','0'),
	('571','4197','3812','0'),
	('571','4197','3813','0');

0

#2 User is offline   dfighter 

  • Titles are overrated
  • PipPipPipPipPipPipPipPipPipPip
  • Group: Administrator
  • Posts: 5,189
  • Joined: 14-June 08
  • IRC:dfighter
  • Gender:Male
  • Server OS:Linux

Posted 04 October 2011 - 10:29 AM

I only have a few worldstates rows for Wintergrasp, where did you get these?
"The demand for free goods is infinite."
0

#3 User is offline   dobri88 

  • Member
  • Pip
  • Group: Members
  • Posts: 27
  • Joined: 27-November 10
  • Gender:Male
  • Server OS:Windows

Posted 04 October 2011 - 12:08 PM

I also had fiew, but i tested with gm command .gm updateworldstate and i set the values to 1. I did this for about 250 values, that where close to the ones, found in the dbc files. For some reason most of the worldstates in wintergrasp are not in the dbc files. These are all found by gm command and that is the reason i asked for someone to check it out :(
0

#4 User is offline   dfighter 

  • Titles are overrated
  • PipPipPipPipPipPipPipPipPipPip
  • Group: Administrator
  • Posts: 5,189
  • Joined: 14-June 08
  • IRC:dfighter
  • Gender:Male
  • Server OS:Linux

Posted 04 October 2011 - 06:17 PM

Ah ok, I only had these so far:

--WG
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3490','0'); -- current horde vehicles
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3491','0'); -- max horde vehicles
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3680','0'); -- current alliance vehicles
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3681','0'); -- max alliance vehicles
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3710','0'); -- shows battle timer, and vehicle counters
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3801','0'); -- shows timer until next battle
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3802','0'); -- horde control
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3803','0'); -- alliance control


Trying to figure out atm how to control the timers, and the timer on the BG UI.

NOTE: This doesn't mean I want to implement Wintergrasp at this time. I am just doing some research, for later use.

Found one of them already

Posted Image

REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','4354','0'); -- unixtime of next battle ( shows it as time left in the UI )


Also found the other :(

Posted Image

REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3781','0'); -- unixtime of the end of battle ( shows it as time left in the UI )


Full list of what I could find with comments:
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3490','0'); -- current horde vehicles
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3491','0'); -- max horde vehicles
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3680','0'); -- current alliance vehicles
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3681','0'); -- max alliance vehicles
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3698','1'); -- Fortress (W) vehicle workshop  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3699','1'); -- Fortress (E) vehicle workshop  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3700','1'); -- Broken Temple (W) vehicle workshop  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3701','1'); -- Sunken Ring (E) vehicle workshop  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3702','1'); -- WestSpark (SW) vehicle workshop  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3703','1'); -- EastSpark (SE) vehicle workshop  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3704','1'); -- ShadowSight (SW) tower  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3705','1'); -- Winter's Edge (S) tower  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3706','1'); -- FlameWatch (SE) tower  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3710','0'); -- shows battle timer, and vehicle counters
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3711','1'); -- NW Fortress tower  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3712','1'); -- NE Fortress tower  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3713','1'); -- SW Fortress tower  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3714','1'); -- SE Fortress tower  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3749','1'); -- Wintergrasp Fortress wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3750','1'); -- Wintergrasp Fortress wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3751','1'); -- Wintergrasp Fortress wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3752','1'); -- Wintergrasp Fortress wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3753','1'); -- Wintergrasp Fortress wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3754','1'); -- Wintergrasp Fortress wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3755','1'); -- Wintergrasp Fortress wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3756','1'); -- Wintergrasp Fortress wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3757','1'); -- Wintergrasp Fortress wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3758','1'); -- Wintergrasp Fortress wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3759','1'); -- Wintergrasp Fortress wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3760','1'); -- Wintergrasp Fortress wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3761','1'); -- Wintergrasp Fortress wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3762','1'); -- Wintergrasp Fortress wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3763','1'); -- Wintergrasp Fortress main gate  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3763','1'); -- Wintergrasp Fortress inner wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3764','1'); -- Wintergrasp Fortress inner wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3765','1'); -- Wintergrasp Fortress inner wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3766','1'); -- Wintergrasp Fortress inner wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3767','1'); -- Wintergrasp Fortress inner wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3768','1'); -- Wintergrasp Fortress inner wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3769','1'); -- Wintergrasp Fortress inner wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3770','1'); -- Wintergrasp Fortress inner wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3771','1'); -- Wintergrasp Fortress inner wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3772','1'); -- Wintergrasp Fortress inner wall  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3773','1'); -- Wintergrasp Fortress inner gate and graveyard  0 - don't show, 1,2,3 Neutral ( intact, damaged, destroyed ), 4,5,6 ( Horde ), 7,8,9 ( Ally )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3774','0'); -- pvp activity detected at main gate
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3775','0'); -- pvp activity detected SW
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3776','0'); -- pvp activity detected SE
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3777','0'); -- pvp activity detected NE
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3778','0'); -- pvp activity detected N
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3779','0'); -- pvp activity detected NW
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3781','0'); -- unixtime of the end of battle ( shows it as time left in the UI )
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3788','0'); -- pvp activity detected near Broken Temple vehicle shop
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3790','0'); -- pvp activity detected near Sunken Ring vehicle shop
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3791','0'); -- pvp activity detected near EastSpark vehicle shop
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3792','0'); -- pvp activity detected near WestSpark vehicle shop
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3793','0'); -- pvp activity detected near ShadowSight tower
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3794','0'); -- pvp activity detected near Flamewatch tower
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3795','0'); -- pvp activity detected near Winter's Edge tower
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3796','0'); -- pvp activity detected near Forest of Shadows
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3797','0'); -- pvp activity detected near Glacial Falls
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3798','0'); -- pvp activity detected near Cauldron of Flames
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3799','0'); -- pvp activity detected near Steppe of Life
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3801','0'); -- timer until next battle
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3802','0'); -- horde control
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','3803','0'); -- alliance control
REPLACE INTO `worldstate_templates`(`map`,`zone`,`field`,`value`) VALUES ( '571','4197','4354','0'); -- unixtime of next battle ( shows it as time left in the UI )

"The demand for free goods is infinite."
0

#5 User is offline   dobri88 

  • Member
  • Pip
  • Group: Members
  • Posts: 27
  • Joined: 27-November 10
  • Gender:Male
  • Server OS:Windows

Posted 05 October 2011 - 02:16 AM

Some more pvp activity values with comments.
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3723','0'); --pvp activity detected Crossroad In front of the fortress gates
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3724','0'); --pvp activity detected In front of winter's edge tower
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3725','0'); --pvp activity detected central bridge to fortress
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3726','0'); --pvp activity detected fortress to Sunken ring
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3727','0'); --pvp activity detected North of East bridge
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3728','0'); --pvp activity detected South of East Bridge
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3729','0'); --pvp activity detected East on the road from Broken temple
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3730','0'); --pvp activity detected North of West bridge
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3731','0'); --pvp activity detected South of West bridge
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3737','0'); --pvp activity detected South of Glacial falls
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3738','0'); --pvp activity detected West on the road from Flamewatch Tower
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3739','0'); --pvp activity detected West from the fortress gate on the road for sunken ring vehicle workshop
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3740','0'); --pvp activity detected Southwest from Sunken ring vehicle workshop
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3741','0'); --pvp activity detected West from Eastspark Workshop on the road to Winter's ege tower
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3742','0'); --pvp activity detected East of Westspark Workshop on the road for Winter's Edge Tower
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3743','0'); --pvp activity detected Southeast of Broken Temple Vehicle Workshop
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3744','0'); --pvp activity detected West from the fortress on the road to Broken Temple Vehicle Workshop
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3745','0'); --pvp activity detected Northwest from Westspark Workshop on the road to Shadowsight Tower
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3746','0'); --pvp activity detected East from Shaowsight Tower on the raod to West brige
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3747','0'); --pvp activity detected Broken Temple southwest lake
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES ('571','4197','3748','0'); --pvp activity detected The chilled quagmire right next to Broken Temple Graveyard

I found the worldstate templetes for Isle Of Conquest and Strands Of The Ancients in the battleground scripts from Trinity core. Big thanks for that.

This is the SQL with comments(for SOTA nad IOC). I don't completely understand sone of the meanings that where in the scripts due to my generaly bad scripting skills, but all of the worldstates are here. :P
--Strands Of The Ancients
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES
	('607','4384','3559','1'), --TIMER_MINS
	('607','4384','3560','1'), --TIMER_SEC_TENS
	('607','4384','3561','1'), --TIMER_SEC_DECS
	('607','4384','4352','0'), --ALLY_ATTACKS //if alliance attack
	('607','4384','4353','0'), --HORDE_ATTACKS //If horde attacks
	('607','4384','3614','1'), --PURPLE_GATEWS
	('607','4384','3617','1'), --RED_GATEWS
	('607','4384','3620','1'), --BLUE_GATEWS
	('607','4384','3623','1'), --GREEN_GATEWS
	('607','4384','3638','1'), --YELLOW_GATEWS
	('607','4384','3849','1'), --ANCIENT_GATEWS
	('607','4384','3635','0'), --LEFT_GY_ALLIANCE //Left alliance graveyard
	('607','4384','3636','0'), --RIGHT_GY_ALLIANCE //Right alliance graveyar
	('607','4384','3637','0'), --CENTER_GY_ALLIANCE //Crnter alliance graveyard
	('607','4384','3627','1'), --RIGHT_ATT_TOKEN_ALL //Left ship landing alliance
	('607','4384','3626','1'), --LEFT_ATT_TOKEN_ALL //Right ship laning alliance
	('607','4384','3629','0'), --LEFT_ATT_TOKEN_HRD //Right ship laning horde
	('607','4384','3628','0'), --RIGHT_ATT_TOKEN_HRD //Right ship laning hore
	('607','4384','3631','0'), --HORDE_DEFENCE_TOKEN
	('607','4384','3630','0'), --ALLIANCE_DEFENCE_TOKEN
	('607','4384','3632','0'), --RIGHT_GY_HORDE //Right graveyard horde
	('607','4384','3633','0'), --LEFT_GY_HORDE //Left graveyard horde
	('607','4384','3634','0'), --CENTER_GY_HORDE //Center graveyard horde
	('607','4384','3564','0'); --ENABLE_TIMER
	--BG_SA_BONUS_TIMER = 0xdf3, ???

--Isle Of Conquest
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES
	('628','4710','4221','300'), -- ALLIANCE_RENFORT_SET
	('628','4710','4222','300'), -- HORDE_RENFORT_SET
	('628','4710','4226','300'), -- ALLIANCE_RENFORT
	('628','4710','4227','300'), -- HORDE_RENFORT
	('628','4710','4317','1'), -- GATE_FRONT_H_WS_CLOSED
	('628','4710','4318','1'), -- GATE_WEST_H_WS_CLOSED
	('628','4710','4319','1'), -- GATE_EAST_H_WS_CLOSED
	('628','4710','4328','1'), -- GATE_FRONT_A_WS_CLOSED
	('628','4710','4327','1'), -- GATE_WEST_A_WS_CLOSED   Every gate can have only one state. Made them all closed as default because this is how the BG starts
	('628','4710','4326','1'), -- GATE_EAST_A_WS_CLOSED
	('628','4710','4322','0'), -- GATE_FRONT_H_WS_OPEN
	('628','4710','4321','0'), -- GATE_WEST_H_WS_OPEN
	('628','4710','4320','0'), -- GATE_EAST_H_WS_OPEN
	('628','4710','4323','0'), -- GATE_FRONT_A_WS_OPEN
	('628','4710','4324','0'), -- GATE_WEST_A_WS_OPEN
	('628','4710','4325','0'), -- GATE_EAST_A_WS_OPEN
	
	('628','4710','4301','1'), -- DOCKS_UNCONTROLLED
	('628','4710','4305','0'), -- DOCKS_CONFLICT_A
	('628','4710','4302','0'), -- DOCKS_CONFLICT_H          Only one of these should be 1 at any time!
	('628','4710','4304','0'), -- DOCKS_CONTROLLED_A
	('628','4710','4303','0'), -- DOCKS_CONTROLLED_H
	
	('628','4710','4296','1'), -- HANGAR_UNCONTROLLED
	('628','4710','4300','0'), -- HANGAR_CONFLICT_A
	('628','4710','4297','0'), -- HANGAR_CONFLICT_H          Only one of these should be 1 at any time!
	('628','4710','4299','0'), -- HANGAR_CONTROLLED_A
	('628','4710','4298','0'), -- HANGAR_CONTROLLED_H
	
	('628','4710','4306','1'), -- QUARRY_UNCONTROLLED
	('628','4710','4310','0'), -- QUARRY_CONFLICT_A
	('628','4710','4307','0'), -- QUARRY_CONFLICT_H          Only one of these should be 1 at any time!
	('628','4710','4309','0'), -- QUARRY_CONTROLLED_A
	('628','4710','4308','0'), -- QUARRY_CONTROLLED_H
	
	('628','4710','4311','1'), -- REFINERY_UNCONTROLLE
	('628','4710','4315','0'), -- REFINERY_CONFLICT_A
	('628','4710','4312','0'), -- REFINERY_CONFLICT_H          Only one of these should be 1 at any time!
	('628','4710','4314','0'), -- REFINERY_CONTROLLED_A
	('628','4710','4313','0'), -- REFINERY_CONTROLLED_H
	
	('628','4710','4294','1'), -- WORKSHOP_UNCONTROLLED
	('628','4710','4228','0'), -- WORKSHOP_CONFLICT_A
	('628','4710','4293','0'), -- WORKSHOP_CONFLICT_H          Only one of these should be 1 at any time!
	('628','4710','4229','0'), -- WORKSHOP_CONTROLLED_A
	('628','4710','4230','0'), -- WORKSHOP_CONTROLLED_H
	
	('628','4710','4341','0'), -- ALLIANCE_KEEP_UNCONTROLLED
	('628','4710','4342','0'), -- ALLIANCE_KEEP_CONFLICT_A
	('628','4710','4343','0'), -- ALLIANCE_KEEP_CONFLICT_H          Only one of these should be 1 at any time!
	('628','4710','4339','1'), -- ALLIANCE_KEEP_CONTROLLED_A
	('628','4710','4340','0'), -- ALLIANCE_KEEP_CONTROLLED_H
	
	('628','4710','4346','0'), -- HORDE_KEEP_UNCONTROLLED
	('628','4710','4347','0'), -- HORDE_KEEP_CONFLICT_A
	('628','4710','4348','0'), -- HORDE_KEEP_CONFLICT_H          Only one of these should be 1 at any time!
	('628','4710','4344','0'), -- HORDE_KEEP_CONTROLLED_A
	('628','4710','4345','1'); -- HORDE_KEEP_CONTROLLED_H

0

#6 User is offline   dfighter 

  • Titles are overrated
  • PipPipPipPipPipPipPipPipPipPip
  • Group: Administrator
  • Posts: 5,189
  • Joined: 14-June 08
  • IRC:dfighter
  • Gender:Male
  • Server OS:Linux

Posted 05 October 2011 - 10:41 AM

wow Wintergrasp really sucks with all those PvP activity crap.
I don't see those detection crap added to Arcemu, ever :P
"The demand for free goods is infinite."
0

#7 User is offline   dobri88 

  • Member
  • Pip
  • Group: Members
  • Posts: 27
  • Joined: 27-November 10
  • Gender:Male
  • Server OS:Windows

Posted 06 October 2011 - 03:37 AM

just like i thought yesterday looking at wintergrasp with all of the values in map 571 set to 1. :P For each seperate pvp detection point there is a invisible npc - Wintergrasp Detection Unit (27869) This thing does the detection and sets the value of every worldstate and when pvp stops it maybe uses a timer to remove the worldstate in a while, but i agree this is just too much. There is a damn pvp point at every millimeter. Anyway there are 41 spawns of this npc and we currently have 38 pvp points... I will check this out a bit better.

Btw, the Zangarmarsh worldstates are missing from DB. I found them, but i am not sure only about worldstate 2653.
REPLACE INTO `worldstate_templates` (`map`, `zone`, `field`, `value`) VALUES

--West tower capture bar stuff
	('530','3521','2527','0'), --West tower capture bar display
	('530','3521','2528','50'), --West tower capture bar position (0 - 100)
	('530','3521','2529','70'), --West tower capture bar: lenght of neutral controlled area of the slider. (not 100% sure about the value)
	
--East tower capture bar stuff
	('530','3521','2533','0'), --East tower capture bar display
	('530','3521','2534','50'), --East tower capture bar position (0 - 100)
	('530','3521','2535','70'), --East tower capture bar: lenght of neutral controlled area of the slider. (not 100% sure about the value)
	
--West tower state display
	('530','3521','2555','0'), --West Beacon - Alliance controlled
	('530','3521','2556','0'), --West Beacon - Horde controlled
	('530','3521','2557','1'), --West Beacon - Neutral
	
--East tower state display
	('530','3521','2558','0'), --East Beacon - Alliance controlled
	('530','3521','2559','0'), --East Beacon - Horde controlled
	('530','3521','2560','1'), --East Beacon - Neutral
	
--West tower map display
	('530','3521','2644','0'), --West Beacon - Alliance controlled
	('530','3521','2645','0'), --West Beacon - Horde controlled
	('530','3521','2646','1'), --West Beacon - Neutral
	
--Graveyard
	('530','3521','2647','1'), --Graveyard - Neutral
	('530','3521','2648','0'), --Graveyard - Alliance
	('530','3521','2649','0'), --Graveyard - Horde
	
--East tower map display
	('530','3521','2650','0'), --East Beacon - Alliance controlled
	('530','3521','2651','0'), --East Beacon - Horde controlled
	('530','3521','2652','1'), --East Beacon - Neutral
	
--???? unknonw
	('530','3521','2653','0'), --Unknown state. No idea what it's used for. It may be wrong.
	
--Flag status
	('530','3521','2655','0'), --Alliance flag is ready
	('530','3521','2656','1'), --Alliance flag is not ready
	('530','3521','2657','1'), --Horde flag is not ready
	('530','3521','2658','0'); --Horde flag is ready
	
	
	

0

#8 User is offline   dfighter 

  • Titles are overrated
  • PipPipPipPipPipPipPipPipPipPip
  • Group: Administrator
  • Posts: 5,189
  • Joined: 14-June 08
  • IRC:dfighter
  • Gender:Male
  • Server OS:Linux

Posted 06 October 2011 - 10:20 AM

Well since it's a new table on my branch, we don't have data for any of them officially yet xD

Anyhow here is my full table that I gathered so far:
http://pastebin.com/MdrkSS3h

It has most worldstates for the BGs ( except IOC ), the Outland outdoor PvP stuff, and some of the Eastern Plagueland, and Silithus outdoor PvP stuff.
"The demand for free goods is infinite."
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users