Advanced Web links

Quote

NAME:
----------
Weblinks Mod.

For PHPFusion v7.01.xx and v7.02.xx


DESCRIPTION:
--------------------
Allows 4 extra fields for weblinks:

- Fax
- Phone
- Address
- E-mail


INSTALLATION:
----------------------
1. Copy the following code into a new empty Custom Page. Give the Page any title - enter your admin password and press "View" - DO NOT press "Save Page". This will add the extra needed fields in the database.

Code Download source

<?php
$result = dbquery("
ALTER TABLE ".DB_WEBLINKS." 
ADD weblink_fax VARCHAR(100) NOT NULL AFTER weblink_count,
ADD weblink_phone VARCHAR(100) NOT NULL AFTER weblink_fax,
ADD weblink_address VARCHAR(100) NOT NULL AFTER weblink_phone,
ADD weblink_mail VARCHAR(100) NOT NULL AFTER weblink_address
");
echo "<div style='text-align:center;'>Extra fields added to the database!</div>n";
?>

2. Upload the content of the map "files" to the root of the server.

3. Done! - You can now fill out the extra fields from the administration of weblinks.


UNINSTALLATION:
--------------------------
1. Upload the following 8 original files from the PHPFusion download package:

/submit.php
/weblinks.php
/administration/submissions.php
/administration/weblinks.php
/locale/English/submit.php
/locale/English/weblinks.php
/locale/English/admin/submissions.php
/locale/English/admin/weblinks.php


2. Delete the extra added fields from the database table YOURPREFIX_weblinks:

- weblink_fax
- weblink_phone
- weblink_address
- weblink_mail


VERSION:
-------------
1.0


CHANGELOG:
-------------------
v1.0 - First release.


AUTHOR:
-------------
Robert Holm AKA Smokeman

http://www.phpfusion-tips.dk/

Quote

Unknown column 'weblink_mail' in 'fusion1dffa_expat12_weblinks'

Quote

Unknown column 'weblink_fax' in 'field list'Unknown column 'weblink_fax' in 'field list'

Quote

<?php
$result = dbquery("ALTER TABLE ".DB_PREFIX."weblinks
ADD weblink_fax varchar(100) NOT NULL;");
if ($result) {
echo "db tables added";}
else { echo "ERROR"; }
?>