sgdanny

Hello
 
For this guide you will need an editor for cdb. files and good knowledge about editing! Unfortunately this guide will be hard for the novice, as it contains some high level stuff
 
Editors:
 
PCM Fast Editor : http://pcm-fast-editor.software.informer.com/2.1/
Lachi's Excel Editor : http://pcmdaily.com/infusions/pro_download_panel/download.php?did=867
Lachi's Editor : http://pcmdaily.com/forum/viewthread.php?thread_id=35616
 

Adding 2014 Equipment

Indeed it's very much possible to add equipment to PCM 14, but it's reallly complex and this is why I will telll you how All equipment in a database is shown in sta_brand and by this it's possible to add all the equipment you like to get added! But you'll need several ID's connected around the entire database for it to work and let's see how it's done

1. Open sta_brand and here's how every column works :

IDbrand the ID must not be shared by another in this table
gene_sz_name Name of the Equipment
fkIDbrandtype There is Wheels, Frames , Gear, Helmets and Glasses
fkIDbrand_link This option is used when you want to connect a frame to a wheel, just give the ID of the wheel/frame in sta_brand
value_f_pts leave at 0
fkIDcountry_main Country of the original company behind the equipment, find the ID in sta_country
fkIDcountry_secondary If there is a second nationality for the equipment designer
Cyclist Type Makes the equipment only available to a specific rider type, leave blank
The last 3 column's need 0 to be added.

2. You've now added the equipment, now it's time to link it from the folders

For this you need to open sta_equipment_template and sta_equipment_model and the template table is used for the stats and which type the equipment is for.

3. Now let's go into sta_equipment_model :

IDequipment_model ID for the model, which can't have the same ID as any other in the table
fkIDequipment_marque the ID of the equipment in sta_brand
fkIDequipment_template the ID of the template for the equipment found in sta_equipment_template and here you have to select the template, which gives the equipment the right info in the game

You can find out what the equipment is for / it's type and f.e under CONSTANT there is a template called mountain, so therefore the equipment will be fitting for the mountains, NOTE : you can't edit this table
gene_sz_name name of the series in the brand f.e
gene_sz_asset the base abbreviation for the equipment, the link to the 3D/Cyclist/Equipments files
gene_IDphoto 0
value_i_version 1
value_i_default 23
value_i_lastyear_up 2010

sta_equipment_template

(By ID)

1 = Hilly Frame
2 = Mountain Frame
3 = Sprinting/Flat Frame
4 = Cobble Frame
5 = Time Trial Flat Frame
6 = Hilly/Mountain Time Trial Frame
51 = Wheel Type 1
52 = Wheel Type 2
53 = Wheel Type 3
54 = Wheel Type 4
55 = Time Trial Wheel Disc
56 = Wheel Type 5
57 = Cobble Wheels
102 = Helmet
103 = Glasses
112 = Time Trial Helmet

Now the equipment show work, but it's best that you can compare to the other equipment already there and see how f.e the abbreviations are working  If you want help to edit some of your own equipment into the game and can't understand this guide properly, are you welcome to pm me or ask me here

http://pcmdaily.com/infusions/pro_download_panel/download.php?did=995 and http://pcmdaily.com/infusions/pro_download_panel/download.php?did=999

Yeah basically Without picking sides, pcmdaily's database team makes the most stabile and practical db's, so it's worth every GB Problem is that variants fill so much xD

Yeah both the v1 and the v2, the v1 is the big one, while v2 basically only adds Jacky Durands Sponsor Kits and some bug fixes