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]