We are getting rid if bi_scadj_desc and probably won't need this page.
EDIT COMPLETED
bike
2001 RM 125
This redirect is for the original editDimensSh2.php, and puts the created string in the original bi_cadj_desc column. Keep this as it will be used if we ever access the original editDimensSh2.php page.
With the new bi_sca table, we are going to manually insert the cadj string.
valvestacks_id
1
bikeinfo_id =
44
The
cadj desc, cadj descb
and
shock desc, shock descb
are not manually entered in the database. They are created from values from the fields shown below and automatically updated from this redirect page.
This is the original cadj desc
This is a short version of the cadj desc originally designed for Shock Components
current
cadj desc
in database =
238402746L
[bi_scadj_desc]
current
cadj descb
in database =
232746L
[bi_scadj_descb]
First, we re-create and update
cadj desc and cadj descb
. Each description is comprised of parts shown below, and are overwritten each time this page is reached.
cadj pist dia
23
part 1 = [bi_scadj_pistdesc]
cadj pist dia
23
part 1 = [bi_scadj_pistdesc]
nu pist hole + nBit
8 - #40
part 1a = [bi_sdim_qq]
(cadj descb is the short version)
housing thread od
27
part 2 = [bi_sdim_ii]
housing thread od
27
part 2 = [bi_sdim_ii]
comp hole dia
#46
part 3 = [bi_sdim_bba]
comp hole dia
#46
part 3 = [bi_sdim_bba]
low speed, yes or no
yes
part 4 = [bi_sdim_pp]
low speed, yes or no
yes
part 4 = [bi_sdim_pp]
newly created
cadj desc
=
238402746L
current
bi_scadj_desc
will be replaced with this
newly created
cadj desc
=
232746L
current
bi_scadj_descb
will be replaced with this
This is the original long version of the shock desc
This is a short version of the shock desc
current
shock desc
in dbase =
SHOWA_50_23_16
[bi_shock_pist_cadj_shaft]
current
shock descb
in dbase =
SHOWA_s50oval_232746L_16
[bi_shock_pist_cadj_shaftb]
Next we re-create and update the
shock desc and shock descb
with the
cadj desc and cadj descb
from above and the three fields below. This is done each time this page is reached.
smfg
SHOWA
field 1 = [bi_sfmg]
smfg
SHOWA
field 1 = [bi_sfmg]
pist desc
s50oval
field 2 = [bi_smv_pistdesc]
pist desc
s50oval
field 2 = [bi_smv_pistdesc]
newly created cAdj number
238402746L
from above
newly created cAdj number
232746L
short version from above
shaft dia
16
field 3 = [bi_sshaftdia]
shaft dia
16
field 3 = [bi_sshaftdia]
newly created
shock desc
=
SHOWA_s50oval_238402746L_16
bi_shock_pist_cadj_shaft
will be replaced with this
newly created
shock descb
=
SHOWA_s50oval_232746L_16
bi_shock_pist_cadj_shaft
will be replaced with this
[redirect goes to editDimensSh2_redirect_02.php]