This step adds the required fields to the database. In this tutorial we assume that we provide 3 contextual deep links. As a result we will need to divide the paragraph that will contain the deep links into 4 parts.

The fields can be added using one of the following methods:
Method 1:
1. Open include/tables.php
FIND:

'RECPR_EXPIRED' => 'L NOTNULL DEFAULT 0'

REPLACE BY:

'RECPR_EXPIRED' => 'L NOTNULL DEFAULT 0' ,
'TITLE1' => 'C(255) NULL' ,
'URL1' => 'C(255) NULL' ,
'TITLE2' => 'C(255) NULL' ,
'URL2' => 'C(255) NULL' ,
'TITLE3' => 'C(255) NULL' ,
'URL3' => 'C(255) NULL' ,
'DESCRIPTION1'        => 'X2 NULL'  ,
'DESCRIPTION2'        => 'X2 NULL'  ,
'DESCRIPTION3'        => 'X2 NULL'  ,
'DESCRIPTION4'        => 'X2 NULL'

2. Rerun the installer by pointing to install/index.php. You will have to put that file back in the server since you most probably have deleted it or renamed it. You will also have to set writing permissions to include/config.php temporarily. this installer will update the table structure and add the new fields.

3. Remove the file install/index.php and the writing permissions on config.php

Method 2:
You can import the additional fields to the database in phpMyadmin. Create a text file fields.sql with the following content:

ALTER TABLE `PLD_LINK` ADD `TITLE1` TEXT NULL ;
ALTER TABLE `PLD_LINK` ADD `TITLE2` TEXT NULL ;
ALTER TABLE `PLD_LINK` ADD `TITLE3` TEXT NULL ;
ALTER TABLE `PLD_LINK` ADD `URL1` TEXT NULL ;
ALTER TABLE `PLD_LINK` ADD `URL2` TEXT NULL ;
ALTER TABLE `PLD_LINK` ADD `URL3` TEXT NULL ;
ALTER TABLE `PLD_LINK` ADD `DESCRIPTION1` LONGTEXT NULL ;
ALTER TABLE `PLD_LINK` ADD `DESCRIPTION2` LONGTEXT NULL ;
ALTER TABLE `PLD_LINK` ADD `DESCRIPTION3` LONGTEXT NULL ;
ALTER TABLE `PLD_LINK` ADD `DESCRIPTION4` LONGTEXT NULL ;

And import it in phpMyadmin.

Please continue to step 2.

If you liked this MOD, and want to show your appreciation, you can link back to
rakCha : http://www.rakcha.com
or
enQuira : http://www.enquira.com