Creating Columns

[69giaptushka]

Having just reread everything I am still confused about whether a column is something that is first set up in the mission editor and then imported as a group file for naming and manipulation, or is it something that we are now planning on setting up from scratch in the db?

[69giapmyata]

I am not yet sure on how to build the form for this. If you have ideas please share them with me. Maybe we should store the information in a working table and let the user commint (save) them to the final table once everything looks as he wants? that could be realized pretty easily and every change would be displayed instantly if we outsource the code to update the working table into an include.

[69giapstenka]

This is the most complex sequence

We create a column in Boswar with a form where we input

Reg 1 Plat 1, 2x, Leyland at supply point 1.

We then send these to the template where one symbolic vehicle represents the column. This >group is only used once, in the template setup.

A planner will move these symbols to the starting position at the begining of the campaign.

We send back group containing vehicles to boswar.

At that point we are at "Mission 0" which means the template is ready

Next we prepare for mission 1

Copy colveh_10 to colveh_10_M01 table

From colveh_10 to colveh10 M01 we will send a group to planner Central and another to planner Allies

This time we have one vehicle symbolic of the column plus an attached waypoint.

The planner looks at them in the editor and decides which ones he wants to move.

If he wants to move a column he drags the waypoint to a destination.

When ready he groups all his columns and sends them back to BOSWAR

BOSWAR updates the destination XZ for each column

We know know if each column will be moving or not and where to.

Boswar then generates a group containing all vehicles in each column, links and waypoints for moving columns complex triggers for static columns.

This group file is read into mission 1 and we fly it.

[69giapmyata]

BUG:

Notice: Undefined index: pointID in C:\Abyss Web Server\htdocs\BosWar\CampaignMgmtRecordColumn.php on line 40 CampaignMgmtRecordColumn query error INSERT INTO columns (columnID, Name, Model, moving_becomes, description, ckey, CoalID, Supplypoint, quantity, col_speed ) VALUES ('111', 'Bat 1 Co 1 Pl 1', 'QuadA', 'quada', '4 Jeffery Quad Portee ambulance', '105', '1', '', '4', '10' ); Data truncated for column 'Supplypoint' at row 1

Happens if Supply Point is empty.

But then:

CampaignMgmtRecordColumn query error INSERT INTO columns (columnID, Name, Model, moving_becomes, description, ckey, CoalID, Supplypoint, quantity, col_speed ) VALUES ('112', 'Abt 1 Ko 1 Zug 2', 'MK4MGER', 'mk4mger', '1 Mk IV Male tank', '501', '2', '4', '1', '4' ); Data truncated for column 'Supplypoint' at row 1

[69giapmyata]

Is a column only consisting of one type of vehicle?

[69giapstenka]

Yes a column is all the same type of vehicle

We will not be doing mixed columns in this version and when we do them it will be a new object. However, Statics are mixed

[69giapstenka]

Supply point table MUST not be empty we must have at minimum Supply Point 1 for coalition 1 and Supply point 1 for coalition 2. In the creation of key points table we should add them automaticaly - in fact we might as well create a default Supply point 1 2 and 3 for both sides on table creation at X 0 Z 0.

[69giaptushka]

That message usually means you neglected to select a supply point. '$pointID' is defined in includes/getSupplyPoints.php and selected by pressing a button. If you see no buttons then you defined no supply points. I'll add a message to the effect of: you must define at least one supply point before you can create a column.

On Tue, Nov 19, 2013 at 3:04 AM, =69.GIAP=MYATA notifications@github.comwrote:

BUG:

Notice: Undefined index: pointID in C:\Abyss Web Server\htdocs\BosWar\CampaignMgmtRecordColumn.php on line 40 CampaignMgmtRecordColumn query error INSERT INTO columns (columnID, Name, Model, moving_becomes, description, ckey, CoalID, Supplypoint, quantity, col_speed ) VALUES ('111', 'Bat 1 Co 1 Pl 1', 'QuadA', 'quada', '4 Jeffery Quad Portee ambulance', '105', '1', '', '4', '10' ); Data truncated for column 'Supplypoint' at row 1

— Reply to this email directly or view it on GitHubhttps://github.com/69GIAP/69GIAPBosWar/issues/80#issuecomment-28772099 .

[69giapmyata]

Still BUG: After I tried inserting a column to the second supply point I got the following:

CampaignMgmtRecordColumn query error INSERT INTO columns (columnID, Name, Model, moving_becomes, description, ckey, CoalID, Supplypoint, quantity, col_speed ) VALUES ('112', 'Bat 1 Co 1 Pl 2', 'QuadA', 'quada', '10x Jeffery Quad Portee ambulance', '105', '1', '5', '10', '10' ); Data truncated for column 'Supplypoint' at row 1

Reason: Table definition: I have a supply point higher than 3 namely 5. The table definition only allows ENUM('1','2','3').

Why?

[69giapmyata]

Additional it would be very nice to see a list of what columns have already been created and make them editable (or at least deletable) in case admin/commander screwed up. Maybe something similar to the airfield resupply interface could do the trick. What do you think?

[69giaptushka]

Reason: Table definition: I have a supply point higher than 3 namely 5. The table definition only allows ENUM('1','2','3').

Why?

=-=-=-=-=

Just a hold-over from Stenka's table that I forgot to fix. I'll fix it now.

On Thu, Nov 21, 2013 at 4:55 AM, =69.GIAP=MYATA notifications@github.comwrote:

Still BUG: After I tried inserting a column to the second supply point I got the following:

CampaignMgmtRecordColumn query error INSERT INTO columns (columnID, Name, Model, moving_becomes, description, ckey, CoalID, Supplypoint, quantity, col_speed ) VALUES ('112', 'Bat 1 Co 1 Pl 2', 'QuadA', 'quada', '10x Jeffery Quad Portee ambulance', '105', '1', '5', '10', '10' ); Data truncated for column 'Supplypoint' at row 1

Reason: Table definition: I have a supply point higher than 3 namely 5. The table definition only allows ENUM('1','2','3').

Why?

— Reply to this email directly or view it on GitHubhttps://github.com/69GIAP/69GIAPBosWar/issues/80#issuecomment-28970873 .

[69giaptushka]

I'm working on displaying a list of columns before downloading them, though I hadn't planned on making it editable... but we will need such a list for updating columns and it might be useful here also. I'll put it on my to-do list. :)

On Thu, Nov 21, 2013 at 5:02 AM, =69.GIAP=MYATA notifications@github.comwrote:

Additional it would be very nice to see a list of what columns have already been created and make them editable (or at least deletable) in case admin/commander screwed up. Maybe something similar to the airfield resupply interface could do the trick. What do you think?

— Reply to this email directly or view it on GitHubhttps://github.com/69GIAP/69GIAPBosWar/issues/80#issuecomment-28971281 .

[69giapstenka]

Yes I originaly planned for there to be 3 supply points for each side. Since then it has moved from 1 to N supply points.

Now we check for the railway station block and create them automaticaly.

Tushka, the standard map may have dozens of railway station blocks. The way to differentiate between our Supply points is that they will be enabled and allocated to a country.

[69giaptushka]

Ahh... the disadvantage of changing to one import for all... I didn't have conflicting rwstations my original way. OK, I'll add a check for a nationality other than 0.

When I import the columns I've just downloaded into mission editor I get an unspecific error report. I looked at the output and compared it with groups exported by the Mission Editor and they look nearly the same. However If I try to do anything with them the Editor crashes. Please cast your experienced eye on them and locate the problem.

[69giaptushka]

The dozens of rwstations will now be ignored because they have not been assigned non-neutral counties.

On Fri, Nov 22, 2013 at 4:53 AM, 69giapstenka notifications@github.comwrote:

Yes I originaly planned for there to be 3 supply points for each side. Since then it has moved from 1 to N supply points.

Now we check for the railway station block and create them automaticaly.

Tushka, the standard map may have dozens of railway station blocks. The way to differentiate between our Supply points is that they will be enabled and allocated to a country.

— Reply to this email directly or view it on GitHubhttps://github.com/69GIAP/69GIAPBosWar/issues/80#issuecomment-29061071 .

[69giapstenka]

I have been creating columns and importing them without crash so far. I presume it's normal that we only have the quad ambulance. I will retest

[69giaptushka]

If you choose a country other than France or Germany the only vehicles you will see are Neutral, and by default the only Neutral vehicle is the quad Ambulance.

On Sat, Nov 23, 2013 at 7:47 AM, 69giapstenka notifications@github.comwrote:

I have been creating columns and importing them without crash so far. I presume it's normal that we only have the quad ambulance. I will retest

— Reply to this email directly or view it on GitHubhttps://github.com/69GIAP/69GIAPBosWar/issues/80#issuecomment-29131757 .

[69giaptushka]

Unless of course you define some vehicles to be, for example, British or Austro-Hungarian.

On Sat, Nov 23, 2013 at 10:44 AM, Tushka 69.GIAP 69giaptushka@gmail.comwrote:

If you choose a country other than France or Germany the only vehicles you will see are Neutral, and by default the only Neutral vehicle is the quad Ambulance.

On Sat, Nov 23, 2013 at 7:47 AM, 69giapstenka notifications@github.comwrote:

I have been creating columns and importing them without crash so far. I presume it's normal that we only have the quad ambulance. I will retest

— Reply to this email directly or view it on GitHubhttps://github.com/69GIAP/69GIAPBosWar/issues/80#issuecomment-29131757 .

[69giaptushka]

You are now offered all vehicles belonging to the same alliance as the country you selected, plus, of course, neutral vehicles.