Additional Custom Fields Additional Custom Fields
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

Additional Custom Fields

Started by Doggy, August 22, 2006, 09:39:58 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1 2
User actions

Doggy

August 22, 2006, 09:39:58 PM Last Edit: August 23, 2006, 05:37:48 AM by GauGau
You can add 16 Custom Fields with this modification:

Author :  Doggy

1. The file to modify.


  • db_input.php
  • displayimage.php
  • editOnePic.php
  • editpics.php
  • lang/english.php
  • lang/french.php
  • image_processor.php
  • include/picmgmt.inc.php
  • include/search.inc.php
  • thumbnails.php
  • upload.php
  • xp_publish.php

Download this files and make a Backup before the moditications !

Make this next modifications (the file will replaced in the ftp at the last moment !!).

Open: db_input.php
Find:
Code Select
        $user1 = addslashes($_POST['user1']);
        $user2 = addslashes($_POST['user2']);
        $user3 = addslashes($_POST['user3']);
        $user4 = addslashes($_POST['user4']);

Add below:
Code Select
$user5 = addslashes($_POST['user5']);
$user6 = addslashes($_POST['user6']);
$user7 = addslashes($_POST['user7']);
$user8 = addslashes($_POST['user8']);
$user9 = addslashes($_POST['user9']);
$user10 = addslashes($_POST['user10']);
$user11 = addslashes($_POST['user11']);
        $user12 = addslashes($_POST['user12']);
        $user13 = addslashes($_POST['user13']);
        $user14 = addslashes($_POST['user14']);
$user15 = addslashes($_POST['user15']);
$user16 = addslashes($_POST['user16']);
$user17 = addslashes($_POST['user17']);
$user18 = addslashes($_POST['user18']);
$user19 = addslashes($_POST['user19']);
$user20 = addslashes($_POST['user20']);


Find:
Code Select
$user1, $user2, $user3, $user4,

Add below:
Code Select
$user5, $user6, $user7, $user8, $user9, $user10, $user11, $user12, $user13, $user14, $user15, $user16, $user17, $user18, $user19, $user20,

Save & Close : db_input.php


Open: displayimage.php
Find:
Code Select
for ($i = 1; $i <= 4; $i++)

Replace 4 by 20:
Code Select
for ($i = 1; $i <= 20; $i++)

Save & Close : displayimage.php


Open: editOnePic.php
Find:
Code Select
    $user1        = $_POST['user1'];
    $user2        = $_POST['user2'];
    $user3        = $_POST['user3'];
    $user4        = $_POST['user4'];

Add below :
Code Select
$user5        = $_POST['user5'];
$user6        = $_POST['user6'];
$user7        = $_POST['user7'];
$user8        = $_POST['user8'];
$user9        = $_POST['user9'];
$user10        = $_POST['user10'];
    $user11        = $_POST['user11'];
    $user12        = $_POST['user12'];
    $user13        = $_POST['user13'];
    $user14        = $_POST['user14'];
$user15        = $_POST['user15'];
$user16        = $_POST['user16'];
$user17        = $_POST['user17'];
$user18        = $_POST['user18'];
$user19        = $_POST['user19'];
$user20        = $_POST['user20'];


Find:
Code Select
    $update .= ", user1 = '".addslashes($user1)."'";
    $update .= ", user2 = '".addslashes($user2)."'";
    $update .= ", user3 = '".addslashes($user3)."'";
    $update .= ", user4 = '".addslashes($user4)."'";

Add below :
Code Select
$update .= ", user5 = '".addslashes($user5)."'";
$update .= ", user6 = '".addslashes($user6)."'";
$update .= ", user7 = '".addslashes($user7)."'";
$update .= ", user8 = '".addslashes($user8)."'";
$update .= ", user9 = '".addslashes($user9)."'";
$update .= ", user10 = '".addslashes($user10)."'";
    $update .= ", user11 = '".addslashes($user11)."'";
    $update .= ", user12 = '".addslashes($user12)."'";
    $update .= ", user13 = '".addslashes($user13)."'";
    $update .= ", user14 = '".addslashes($user14)."'";
$update .= ", user15 = '".addslashes($user15)."'";
$update .= ", user16 = '".addslashes($user16)."'";
$update .= ", user17 = '".addslashes($user17)."'";
$update .= ", user18 = '".addslashes($user18)."'";
$update .= ", user19 = '".addslashes($user19)."'";
$update .= ", user20 = '".addslashes($user20)."'";


Find:
Code Select
EOT;
if ($CONFIG['user_field1_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field1_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                                <input type="text" style="width: 100%" name="user1" maxlength="255" value="{$CURRENT_PIC['user1']}" class="textinput" />
                        </td>
        </tr>
EOT;
}
if ($CONFIG['user_field2_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field2_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                <input type="text" style="width: 100%" name="user2" maxlength="255" value="{$CURRENT_PIC['user2']}" class="textinput" />
                        </td>
        </tr>
EOT;
}if ($CONFIG['user_field3_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field3_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                <input type="text" style="width: 100%" name="user3" maxlength="255" value="{$CURRENT_PIC['user3']}" class="textinput" />
                        </td>
        </tr>
EOT;
}if ($CONFIG['user_field4_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field4_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                <input type="text" style="width: 100%" name="user4" maxlength="255" value="{$CURRENT_PIC['user4']}" class="textinput" />
                        </td>
        </tr>
EOT;
}

Add below :
Code Select
if ($CONFIG['user_field5_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field5_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                <input type="text" style="width: 100%" name="user5" maxlength="255" value="{$CURRENT_PIC['user5']}" class="textinput" />
                        </td>
        </tr>
EOT;
}if ($CONFIG['user_field6_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field6_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                <input type="text" style="width: 100%" name="user6" maxlength="255" value="{$CURRENT_PIC['user6']}" class="textinput" />
                        </td>
        </tr>
EOT;
}if ($CONFIG['user_field7_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field7_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                <input type="text" style="width: 100%" name="user7" maxlength="255" value="{$CURRENT_PIC['user7']}" class="textinput" />
                        </td>
        </tr>
EOT;
}if ($CONFIG['user_field8_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field8_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                <input type="text" style="width: 100%" name="user8" maxlength="255" value="{$CURRENT_PIC['user8']}" class="textinput" />
                        </td>
        </tr>
EOT;
}if ($CONFIG['user_field9_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field9_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                <input type="text" style="width: 100%" name="user9" maxlength="255" value="{$CURRENT_PIC['user9']}" class="textinput" />
                        </td>
        </tr>
EOT;
}if ($CONFIG['user_field10_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field10_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                <input type="text" style="width: 100%" name="user10" maxlength="255" value="{$CURRENT_PIC['user10']}" class="textinput" />
                        </td>
        </tr>
EOT;
}if ($CONFIG['user_field11_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field11_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                                <input type="text" style="width: 100%" name="user11" maxlength="255" value="{$CURRENT_PIC['user11']}" class="textinput" />
                        </td>
        </tr>
EOT;
}
if ($CONFIG['user_field12_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field12_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                <input type="text" style="width: 100%" name="user12" maxlength="255" value="{$CURRENT_PIC['user12']}" class="textinput" />
                        </td>
        </tr>
EOT;
}if ($CONFIG['user_field13_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field13_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                <input type="text" style="width: 100%" name="user13" maxlength="255" value="{$CURRENT_PIC['user13']}" class="textinput" />
                        </td>
        </tr>
EOT;
}if ($CONFIG['user_field14_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field14_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                <input type="text" style="width: 100%" name="user14" maxlength="255" value="{$CURRENT_PIC['user14']}" class="textinput" />
                        </td>
        </tr>
EOT;
}if ($CONFIG['user_field15_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field15_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                <input type="text" style="width: 100%" name="user15" maxlength="255" value="{$CURRENT_PIC['user15']}" class="textinput" />
                        </td>
        </tr>
EOT;
}if ($CONFIG['user_field16_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field16_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                <input type="text" style="width: 100%" name="user16" maxlength="255" value="{$CURRENT_PIC['user16']}" class="textinput" />
                        </td>
        </tr>
EOT;
}if ($CONFIG['user_field17_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field17_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                <input type="text" style="width: 100%" name="user17" maxlength="255" value="{$CURRENT_PIC['user17']}" class="textinput" />
                        </td>
        </tr>
EOT;
}if ($CONFIG['user_field18_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field18_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                <input type="text" style="width: 100%" name="user18" maxlength="255" value="{$CURRENT_PIC['user18']}" class="textinput" />
                        </td>
        </tr>
EOT;
}if ($CONFIG['user_field19_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field19_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                <input type="text" style="width: 100%" name="user19" maxlength="255" value="{$CURRENT_PIC['user19']}" class="textinput" />
                        </td>
        </tr>

EOT;
}if ($CONFIG['user_field20_name'] != ''){
echo <<<EOT
        <tr>
            <td class="tableb" style="white-space: nowrap;">
                {$CONFIG['user_field20_name']}
                </td>
                <td width="100%" class="tableb" valign="top">
                <input type="text" style="width: 100%" name="user20" maxlength="255" value="{$CURRENT_PIC['user20']}" class="textinput" />
                        </td>
        </tr>
EOT;
}

Find:
Code Select
if ($CONFIG['user_field1_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field2_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field3_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field4_name'] != '') $THUMB_ROWSPAN++;

Add below :
Code Select
if ($CONFIG['user_field6_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field7_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field8_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field9_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field10_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field11_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field12_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field13_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field14_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field15_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field16_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field17_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field18_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field19_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field20_name'] != '') $THUMB_ROWSPAN++;


Save & Close : editOnePic.php

Doggy

#1
August 22, 2006, 09:42:28 PM
Open: editpics.php
Find:
Code Select
        array($CONFIG['user_field1_name'], 'user1', 0, 255),
        array($CONFIG['user_field2_name'], 'user2', 0, 255),
        array($CONFIG['user_field3_name'], 'user3', 0, 255),
        array($CONFIG['user_field4_name'], 'user4', 0, 255),

Add below:
Code Select
array($CONFIG['user_field5_name'], 'user5', 0, 255),
array($CONFIG['user_field6_name'], 'user6', 0, 255),
array($CONFIG['user_field7_name'], 'user7', 0, 255),
array($CONFIG['user_field8_name'], 'user8', 0, 255),
array($CONFIG['user_field9_name'], 'user9', 0, 255),
array($CONFIG['user_field10_name'], 'user10', 0, 255),
    array($CONFIG['user_field11_name'], 'user11', 0, 255),
        array($CONFIG['user_field12_name'], 'user12', 0, 255),
        array($CONFIG['user_field13_name'], 'user13', 0, 255),
        array($CONFIG['user_field14_name'], 'user14', 0, 255),
array($CONFIG['user_field15_name'], 'user15', 0, 255),
array($CONFIG['user_field16_name'], 'user16', 0, 255),
array($CONFIG['user_field17_name'], 'user17', 0, 255),
array($CONFIG['user_field18_name'], 'user18', 0, 255),
array($CONFIG['user_field19_name'], 'user19', 0, 255),
array($CONFIG['user_field20_name'], 'user20', 0, 255),

Find:
Code Select
                $user1       = get_post_var('user1', $pid);
                $user2       = get_post_var('user2', $pid);
                $user3       = get_post_var('user3', $pid);
                $user4       = get_post_var('user4', $pid);

Add below:
Code Select
$user5       = get_post_var('user5', $pid);
$user6       = get_post_var('user6', $pid);
$user7       = get_post_var('user7', $pid);
$user8       = get_post_var('user8', $pid);
$user9       = get_post_var('user9', $pid);
$user10       = get_post_var('user10', $pid);
            $user11       = get_post_var('user11', $pid);
                $user12       = get_post_var('user12', $pid);
                $user13       = get_post_var('user13', $pid);
                $user14       = get_post_var('user14', $pid);
$user15       = get_post_var('user15', $pid);
$user16       = get_post_var('user16', $pid);
$user17       = get_post_var('user17', $pid);
$user18       = get_post_var('user18', $pid);
$user19       = get_post_var('user19', $pid);
$user20       = get_post_var('user20', $pid);

Find:
Code Select
                $update .= ", user1 = '".addslashes($user1)."'";
                $update .= ", user2 = '".addslashes($user2)."'";
                $update .= ", user3 = '".addslashes($user3)."'";
                $update .= ", user4 = '".addslashes($user4)."'";

Add below:
Code Select
$update .= ", user5 = '".addslashes($user5)."'";
$update .= ", user6 = '".addslashes($user6)."'";
$update .= ", user7 = '".addslashes($user7)."'";
$update .= ", user8 = '".addslashes($user8)."'";
$update .= ", user9 = '".addslashes($user9)."'";
$update .= ", user10 = '".addslashes($user10)."'";
                $update .= ", user11 = '".addslashes($user11)."'";
                $update .= ", user12 = '".addslashes($user12)."'";
                $update .= ", user13 = '".addslashes($user13)."'";
                $update .= ", user14 = '".addslashes($user14)."'";
$update .= ", user15 = '".addslashes($user15)."'";
$update .= ", user16 = '".addslashes($user16)."'";
$update .= ", user17 = '".addslashes($user17)."'";
$update .= ", user18 = '".addslashes($user18)."'";
$update .= ", user19 = '".addslashes($user19)."'";
$update .= ", user20 = '".addslashes($user20)."'";

Find:
Code Select
if ($CONFIG['user_field1_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field2_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field3_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field4_name'] != '') $THUMB_ROWSPAN++;

Add below:
Code Select
if ($CONFIG['user_field5_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field6_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field7_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field8_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field9_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field10_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field11_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field12_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field13_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field14_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field15_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field16_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field17_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field18_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field19_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field20_name'] != '') $THUMB_ROWSPAN++;

Save & Close : editpics.php


Open: lang/english.php
Find:
Code Select
  array('Field 1 name', 'user_field1_name', 0, 'f=index.htm&amp;as=admin_custom_image&amp;ae=admin_custom_image_end'), //cpg1.4
  array('Field 2 name', 'user_field2_name', 0),
  array('Field 3 name', 'user_field3_name', 0),
  array('Field 4 name', 'user_field4_name', 0),

Add below:
Code Select
  array('Field 5 name', 'user_field5_name', 0),
  array('Field 6 name', 'user_field6_name', 0),
  array('Field 7 name', 'user_field7_name', 0),
  array('Field 8 name', 'user_field8_name', 0),
  array('Field 9 name', 'user_field9_name', 0),
  array('Field 10 name', 'user_field10_name', 0),
  array('Field 11 name', 'user_field11_name', 0),
  array('Field 12 name', 'user_field12_name', 0),
  array('Field 13 name', 'user_field13_name', 0),
  array('Field 14 name', 'user_field14_name', 0),
  array('Field 15 name', 'user_field15_name', 0),
  array('Field 16 name', 'user_field16_name', 0),
  array('Field 17 name', 'user_field17_name', 0),
  array('Field 18 name', 'user_field18_name', 0),
  array('Field 19 name', 'user_field19_name', 0),
  array('Field 20 name', 'user_field20_name', 0),

Save & Close : lang/english.php


Open: lang/french.php
Find:
Code Select
  array('Nom du champ 1', 'user_field1_name', 0, 'f=index.htm&amp;as=admin_custom_image&amp;ae=admin_custom_image_end'), //cpg1.4
  array('Nom du champ 2', 'user_field2_name', 0),
  array('Nom du champ 3', 'user_field3_name', 0),
  array('Nom du champ 4', 'user_field4_name', 0),

Add below:
Code Select
  array('Nom du champ 5', 'user_field5_name', 0),
  array('Nom du champ 6', 'user_field6_name', 0),
  array('Nom du champ 7', 'user_field7_name', 0),
  array('Nom du champ 8', 'user_field8_name', 0),
  array('Nom du champ 9', 'user_field9_name', 0),
  array('Nom du champ 10', 'user_field10_name', 0),
  array('Nom du champ 11', 'user_field11_name', 0),
  array('Nom du champ 12', 'user_field12_name', 0),
  array('Nom du champ 13', 'user_field13_name', 0),
  array('Nom du champ 14', 'user_field14_name', 0),
  array('Nom du champ 15', 'user_field15_name', 0),
  array('Nom du champ 16', 'user_field16_name', 0),
  array('Nom du champ 17', 'user_field17_name', 0),
  array('Nom du champ 18', 'user_field18_name', 0),
  array('Nom du champ 19', 'user_field19_name', 0),
  array('Nom du champ 20', 'user_field20_name', 0),

Save & Close : lang/french.php

Doggy

#2
August 22, 2006, 09:44:36 PM
Open: image_processor.php
Find:
Code Select
global $user1;
global $user2;
global $user3;
global $user4;

Add below:
Code Select
global $user5;
global $user6;
global $user7;
global $user8;
global $user9;
global $user10;
global $user11;
global $user12;
global $user13;
global $user14;
global $user15;
global $user16;
global $user17;
global $user18;
global $user19;
global $user20;

Find:
Code Select
print "<input type=\"hidden\" name=\"user1\" value=\"$user1\" />";
print "<input type=\"hidden\" name=\"user2\" value=\"$user2\" />";
print "<input type=\"hidden\" name=\"user3\" value=\"$user3\" />";
print "<input type=\"hidden\" name=\"user4\" value=\"$user4\" />";

Add below:
Code Select
print "<input type=\"hidden\" name=\"user5\" value=\"$user5\" />";
print "<input type=\"hidden\" name=\"user6\" value=\"$user6\" />";
print "<input type=\"hidden\" name=\"user7\" value=\"$user7\" />";
print "<input type=\"hidden\" name=\"user8\" value=\"$user8\" />";
print "<input type=\"hidden\" name=\"user9\" value=\"$user9\" />";
print "<input type=\"hidden\" name=\"user10\" value=\"$user10\" />";
print "<input type=\"hidden\" name=\"user11\" value=\"$user11\" />";
print "<input type=\"hidden\" name=\"user12\" value=\"$user12\" />";
print "<input type=\"hidden\" name=\"user13\" value=\"$user13\" />";
print "<input type=\"hidden\" name=\"user14\" value=\"$user14\" />";
print "<input type=\"hidden\" name=\"user15\" value=\"$user15\" />";
print "<input type=\"hidden\" name=\"user16\" value=\"$user16\" />";
print "<input type=\"hidden\" name=\"user17\" value=\"$user17\" />";
print "<input type=\"hidden\" name=\"user18\" value=\"$user18\" />";
print "<input type=\"hidden\" name=\"user19\" value=\"$user19\" />";
print "<input type=\"hidden\" name=\"user20\" value=\"$user20\" />";

Find:
Code Select
        $user1    = $_POST['user1'];
        $user2    = $_POST['user2'];
        $user3    = $_POST['user3'];
        $user4    = $_POST['user4'];

Add below:
Code Select
$user5    = $_POST['user5'];
$user6    = $_POST['user6'];
$user7    = $_POST['user7'];
$user8    = $_POST['user8'];
$user9    = $_POST['user9'];
$user10    = $_POST['user10'];
        $user11    = $_POST['user11'];
        $user12    = $_POST['user12'];
        $user13    = $_POST['user13'];
        $user14    = $_POST['user14'];
$user15    = $_POST['user15'];
$user16    = $_POST['user16'];
$user17    = $_POST['user17'];
$user18    = $_POST['user18'];
$user19    = $_POST['user19'];
$user20    = $_POST['user20'];

Find:
Code Select
        $user1    = $_POST['user1'];
        $user2    = $_POST['user2'];
        $user3    = $_POST['user3'];
        $user4    = $_POST['user4'];

Add below:
Code Select
$user5    = $_POST['user5'];
$user6    = $_POST['user6'];
$user7    = $_POST['user7'];
$user8    = $_POST['user8'];
$user9    = $_POST['user9'];
$user10    = $_POST['user10'];
        $user11    = $_POST['user11'];
        $user12    = $_POST['user12'];
        $user13    = $_POST['user13'];
        $user14    = $_POST['user14'];
$user15    = $_POST['user15'];
$user16    = $_POST['user16'];
$user17    = $_POST['user17'];
$user18    = $_POST['user18'];
$user19    = $_POST['user19'];
$user20    = $_POST['user20'];

Find:
Code Select
                print "<input type=\"hidden\" name=\"user1\" value=\"$user1\" />";
                print "<input type=\"hidden\" name=\"user2\" value=\"$user2\" />";
                print "<input type=\"hidden\" name=\"user3\" value=\"$user3\" />";
                print "<input type=\"hidden\" name=\"user4\" value=\"$user4\" />";

Add below:
Code Select
print "<input type=\"hidden\" name=\"user5\" value=\"$user5\" />";
print "<input type=\"hidden\" name=\"user6\" value=\"$user6\" />";
print "<input type=\"hidden\" name=\"user7\" value=\"$user7\" />";
print "<input type=\"hidden\" name=\"user8\" value=\"$user8\" />";
print "<input type=\"hidden\" name=\"user9\" value=\"$user9\" />";
print "<input type=\"hidden\" name=\"user10\" value=\"$user10\" />";
print "<input type=\"hidden\" name=\"user11\" value=\"$user11\" />";
                print "<input type=\"hidden\" name=\"user12\" value=\"$user12\" />";
                print "<input type=\"hidden\" name=\"user13\" value=\"$user13\" />";
                print "<input type=\"hidden\" name=\"user14\" value=\"$user14\" />";
print "<input type=\"hidden\" name=\"user15\" value=\"$user15\" />";
print "<input type=\"hidden\" name=\"user16\" value=\"$user16\" />";
print "<input type=\"hidden\" name=\"user17\" value=\"$user17\" />";
print "<input type=\"hidden\" name=\"user18\" value=\"$user18\" />";
print "<input type=\"hidden\" name=\"user19\" value=\"$user19\" />";
print "<input type=\"hidden\" name=\"user20\" value=\"$user20\" />";

Save & Close : image_processor.php


Open: include/picmgmt.inc.php
Find:
Code Select
$user1 = '', $user2 = '', $user3 = '', $user4 = '',

Add below:
Code Select
$user5 = '', $user6 = '', $user7 = '', $user8 = '', $user9 = '', $user10 = '', $user11 = '', $user12 = '', $user13 = '', $user14 = '', $user15 = '', $user16 = '', $user17 = '', $user18 = '', $user19 = '', $user20 = '',

Find:
Code Select
    $CURRENT_PIC_DATA['user1'] = $user1;
    $CURRENT_PIC_DATA['user2'] = $user2;
    $CURRENT_PIC_DATA['user3'] = $user3;
    $CURRENT_PIC_DATA['user4'] = $user4;

Add below:
Code Select
$CURRENT_PIC_DATA['user5'] = $user5;
$CURRENT_PIC_DATA['user6'] = $user6;
$CURRENT_PIC_DATA['user7'] = $user7;
$CURRENT_PIC_DATA['user8'] = $user8;
$CURRENT_PIC_DATA['user9'] = $user9;
$CURRENT_PIC_DATA['user10'] = $user10;
    $CURRENT_PIC_DATA['user11'] = $user11;
    $CURRENT_PIC_DATA['user12'] = $user12;
    $CURRENT_PIC_DATA['user13'] = $user13;
    $CURRENT_PIC_DATA['user14'] = $user14;
$CURRENT_PIC_DATA['user15'] = $user15;
$CURRENT_PIC_DATA['user16'] = $user16;
$CURRENT_PIC_DATA['user17'] = $user17;
$CURRENT_PIC_DATA['user18'] = $user18;
$CURRENT_PIC_DATA['user19'] = $user19;
$CURRENT_PIC_DATA['user20'] = $user20;

Save & Close : include/picmgmt.inc.php


Open: include/search.inc.php
Find:
Code Select
'user1', 'user2', 'user3', 'user4'

Add below:
Code Select
, 'user5', 'user6', 'user7', 'user8', 'user9', 'user10', 'user11', 'user12', 'user13', 'user14', 'user15', 'user16', 'user17', 'user18', 'user19', 'user20'

Save & Close : include/search.inc.php

Doggy

#3
August 22, 2006, 09:47:46 PM
Open: thumbnails.php
Find:
Code Select
'user1', 'user2', 'user3', 'user4'

Add below:
Code Select
, 'user5', 'user6', 'user7', 'user8', 'user9', 'user10', 'user11', 'user12', 'user13', 'user14', 'user15', 'user16', 'user17', 'user18', 'user19', 'user20'

Save & Close : thumbnails.php


Open: upload.php
Find:
Code Select
        if(!empty($CONFIG['user_field1_name'])) {
            $form_array[] = array($CONFIG['user_field1_name'], 'user1', 0, 255, 1);
        }

        if(!empty($CONFIG['user_field2_name'])) {
            $form_array[] = array($CONFIG['user_field2_name'], 'user2', 0, 255, 1);
        }

        if(!empty($CONFIG['user_field3_name'])) {
            $form_array[] = array($CONFIG['user_field3_name'], 'user3', 0, 255, 1);
        }

        if(!empty($CONFIG['user_field4_name'])) {
            $form_array[] = array($CONFIG['user_field4_name'], 'user4', 0, 255, 1);
        }

Add below:
Code Select

        if(!empty($CONFIG['user_field5_name'])) {
            $form_array[] = array($CONFIG['user_field5_name'], 'user5', 0, 255, 1);
        }
       
if(!empty($CONFIG['user_field6_name'])) {
            $form_array[] = array($CONFIG['user_field6_name'], 'user6', 0, 255, 1);
        }
       
if(!empty($CONFIG['user_field7_name'])) {
            $form_array[] = array($CONFIG['user_field7_name'], 'user7', 0, 255, 1);
        }

        if(!empty($CONFIG['user_field8_name'])) {
            $form_array[] = array($CONFIG['user_field8_name'], 'user8', 0, 255, 1);
        }

        if(!empty($CONFIG['user_field9_name'])) {
            $form_array[] = array($CONFIG['user_field9_name'], 'user9', 0, 255, 1);
        }

        if(!empty($CONFIG['user_field10_name'])) {
            $form_array[] = array($CONFIG['user_field10_name'], 'user10', 0, 255, 1);
        }

        if(!empty($CONFIG['user_field11_name'])) {
            $form_array[] = array($CONFIG['user_field11_name'], 'user11', 0, 255, 1);
        }

        if(!empty($CONFIG['user_field12_name'])) {
            $form_array[] = array($CONFIG['user_field12_name'], 'user12', 0, 255, 1);
        }

        if(!empty($CONFIG['user_field13_name'])) {
            $form_array[] = array($CONFIG['user_field13_name'], 'user13', 0, 255, 1);
        }

        if(!empty($CONFIG['user_field14_name'])) {
            $form_array[] = array($CONFIG['user_field14_name'], 'user14', 0, 255, 1);
        }

        if(!empty($CONFIG['user_field15_name'])) {
            $form_array[] = array($CONFIG['user_field15_name'], 'user15', 0, 255, 1);
        }
       
if(!empty($CONFIG['user_field16_name'])) {
            $form_array[] = array($CONFIG['user_field16_name'], 'user16', 0, 255, 1);
        }
       
if(!empty($CONFIG['user_field17_name'])) {
            $form_array[] = array($CONFIG['user_field17_name'], 'user17', 0, 255, 1);
        }

        if(!empty($CONFIG['user_field18_name'])) {
            $form_array[] = array($CONFIG['user_field18_name'], 'user18', 0, 255, 1);
        }

        if(!empty($CONFIG['user_field19_name'])) {
            $form_array[] = array($CONFIG['user_field19_name'], 'user19', 0, 255, 1);
        }

        if(!empty($CONFIG['user_field20_name'])) {
            $form_array[] = array($CONFIG['user_field20_name'], 'user20', 0, 255, 1);
        }

Find:
Code Select
    if(!empty($CONFIG['user_field1_name'])) {
        $form_array[] = array($CONFIG['user_field1_name'], 'user1', 0, 255, 1);
    }

    if(!empty($CONFIG['user_field2_name'])) {
        $form_array[] = array($CONFIG['user_field2_name'], 'user2', 0, 255, 1);
    }

    if(!empty($CONFIG['user_field3_name'])) {
        $form_array[] = array($CONFIG['user_field3_name'], 'user3', 0, 255, 1);
    }

    if(!empty($CONFIG['user_field4_name'])) {
        $form_array[] = array($CONFIG['user_field4_name'], 'user4', 0, 255, 1);
    }

Add below:
Code Select

    if(!empty($CONFIG['user_field5_name'])) {
        $form_array[] = array($CONFIG['user_field5_name'], 'user5', 0, 255, 1);
    }

    if(!empty($CONFIG['user_field6_name'])) {
        $form_array[] = array($CONFIG['user_field6_name'], 'user6', 0, 255, 1);
    }

    if(!empty($CONFIG['user_field7_name'])) {
        $form_array[] = array($CONFIG['user_field7_name'], 'user7', 0, 255, 1);
    }

    if(!empty($CONFIG['user_field8_name'])) {
        $form_array[] = array($CONFIG['user_field8_name'], 'user8', 0, 255, 1);
    }

    if(!empty($CONFIG['user_field9_name'])) {
        $form_array[] = array($CONFIG['user_field9_name'], 'user9', 0, 255, 1);
    }

    if(!empty($CONFIG['user_field10_name'])) {
        $form_array[] = array($CONFIG['user_field10_name'], 'user10', 0, 255, 1);
    }

    if(!empty($CONFIG['user_field11_name'])) {
        $form_array[] = array($CONFIG['user_field11_name'], 'user11', 0, 255, 1);
    }

    if(!empty($CONFIG['user_field12_name'])) {
        $form_array[] = array($CONFIG['user_field12_name'], 'user12', 0, 255, 1);
    }

    if(!empty($CONFIG['user_field13_name'])) {
        $form_array[] = array($CONFIG['user_field13_name'], 'user13', 0, 255, 1);
    }

    if(!empty($CONFIG['user_field14_name'])) {
        $form_array[] = array($CONFIG['user_field14_name'], 'user14', 0, 255, 1);
    }

    if(!empty($CONFIG['user_field15_name'])) {
        $form_array[] = array($CONFIG['user_field15_name'], 'user15', 0, 255, 1);
    }

    if(!empty($CONFIG['user_field16_name'])) {
        $form_array[] = array($CONFIG['user_field16_name'], 'user16', 0, 255, 1);
    }

    if(!empty($CONFIG['user_field17_name'])) {
        $form_array[] = array($CONFIG['user_field17_name'], 'user17', 0, 255, 1);
    }

    if(!empty($CONFIG['user_field18_name'])) {
        $form_array[] = array($CONFIG['user_field18_name'], 'user18', 0, 255, 1);
    }

    if(!empty($CONFIG['user_field19_name'])) {
        $form_array[] = array($CONFIG['user_field19_name'], 'user19', 0, 255, 1);
    }

    if(!empty($CONFIG['user_field20_name'])) {
        $form_array[] = array($CONFIG['user_field20_name'], 'user20', 0, 255, 1);
    }

Find:
Code Select
        $user1 = addslashes($_POST['user1']);
        $user2 = addslashes($_POST['user2']);
        $user3 = addslashes($_POST['user3']);
        $user4 = addslashes($_POST['user4']);

Add below:
Code Select
$user5 = addslashes($_POST['user5']);
$user6 = addslashes($_POST['user6']);
$user7 = addslashes($_POST['user7']);
$user8 = addslashes($_POST['user8']);
$user9 = addslashes($_POST['user9']);
$user10 = addslashes($_POST['user10']);
        $user11 = addslashes($_POST['user11']);
        $user12 = addslashes($_POST['user12']);
        $user13 = addslashes($_POST['user13']);
        $user14 = addslashes($_POST['user14']);
$user15 = addslashes($_POST['user15']);
$user16 = addslashes($_POST['user16']);
$user17 = addslashes($_POST['user17']);
$user18 = addslashes($_POST['user18']);
$user19 = addslashes($_POST['user19']);
$user20 = addslashes($_POST['user20']);

Find:
Code Select
$user1, $user2, $user3, $user4,

Add below:
Code Select
$user5, $user6, $user7, $user8, $user9, $user10, $user11, $user12, $user13, $user14, $user15, $user16, $user17, $user18, $user19, $user20,

Save & Close : upload.php


Open: xp_publish.php
Find:
Code Select
    $user1 = '';
    $user2 = '';
    $user3 = '';
    $user4 = '';

Add below:
Code Select
$user5 = '';
$user6 = '';
$user7 = '';
$user8 = '';
$user9 = '';
    $user10 = '';
    $user11 = '';
    $user12 = '';
    $user13 = '';
    $user14 = '';
$user15 = '';
$user16 = '';
$user17 = '';
$user18 = '';
$user19 = '';
    $user20 = '';

Find:
Code Select
$user1, $user2, $user3, $user4,

Add below:
Code Select
$user5, $user6, $user7, $user8, $user9, $user10, $user11, $user12, $user13, $user14, $user15, $user16, $user17, $user18, $user19, $user20,

Save & Close : xp_publish.php

Doggy

#4
August 22, 2006, 09:57:44 PM
2. The data base to modify.

Save your data base and make a Backup before the modifications !

Go to the config page of Coppermine, empty all the fields.

Make another safeguard of your data base and make the next modifications on this one, then import the data base.

(Change "table Prefix" to the prefix that you use for your tables.)

Find in "table Prefix"_pictures:
Code Select
  `user1` varchar(255) collate latin1_german2_ci NOT NULL default '',
  `user2` varchar(255) collate latin1_german2_ci NOT NULL default '',
  `user3` varchar(255) collate latin1_german2_ci NOT NULL default '',
  `user4` varchar(255) collate latin1_german2_ci NOT NULL default '',

Add below:
Code Select
  `user5` varchar(255) collate latin1_german2_ci NOT NULL default '',
  `user6` varchar(255) collate latin1_german2_ci NOT NULL default '',
  `user7` varchar(255) collate latin1_german2_ci NOT NULL default '',
  `user8` varchar(255) collate latin1_german2_ci NOT NULL default '',
  `user9` varchar(255) collate latin1_german2_ci NOT NULL default '',
  `user10` varchar(255) collate latin1_german2_ci NOT NULL default '',
  `user11` varchar(255) collate latin1_german2_ci NOT NULL default '',
  `user12` varchar(255) collate latin1_german2_ci NOT NULL default '',
  `user13` varchar(255) collate latin1_german2_ci NOT NULL default '',
  `user14` varchar(255) collate latin1_german2_ci NOT NULL default '',
  `user15` varchar(255) collate latin1_german2_ci NOT NULL default '',
  `user16` varchar(255) collate latin1_german2_ci NOT NULL default '',
  `user17` varchar(255) collate latin1_german2_ci NOT NULL default '',
  `user18` varchar(255) collate latin1_german2_ci NOT NULL default '',
  `user19` varchar(255) collate latin1_german2_ci NOT NULL default '',
  `user20` varchar(255) collate latin1_german2_ci NOT NULL default '',

Find in "table Prefix"_config:
Code Select
INSERT INTO `cpg148_config` VALUES ('user_field1_name', '');
INSERT INTO `cpg148_config` VALUES ('user_field2_name', '');
INSERT INTO `cpg148_config` VALUES ('user_field3_name', '');
INSERT INTO `cpg148_config` VALUES ('user_field4_name', '');

Add below:
Code Select
INSERT INTO `cpg148_config` VALUES ('user_field5_name', '');
INSERT INTO `cpg148_config` VALUES ('user_field6_name', '');
INSERT INTO `cpg148_config` VALUES ('user_field7_name', '');
INSERT INTO `cpg148_config` VALUES ('user_field8_name', '');
INSERT INTO `cpg148_config` VALUES ('user_field9_name', '');
INSERT INTO `cpg148_config` VALUES ('user_field10_name', '');
INSERT INTO `cpg148_config` VALUES ('user_field11_name', '');
INSERT INTO `cpg148_config` VALUES ('user_field12_name', '');
INSERT INTO `cpg148_config` VALUES ('user_field13_name', '');
INSERT INTO `cpg148_config` VALUES ('user_field14_name', '');
INSERT INTO `cpg148_config` VALUES ('user_field15_name', '');
INSERT INTO `cpg148_config` VALUES ('user_field16_name', '');
INSERT INTO `cpg148_config` VALUES ('user_field17_name', '');
INSERT INTO `cpg148_config` VALUES ('user_field18_name', '');
INSERT INTO `cpg148_config` VALUES ('user_field19_name', '');
INSERT INTO `cpg148_config` VALUES ('user_field20_name', '');


Upload ALL THE MODIFIED FILES  and that will be good.

Sorry for my english, I'm French and I have still much to learn ;).

Pascal YAP

#5
August 23, 2006, 09:04:02 AM
Oki Doggy  ;D

Nice job !
For those who want this MOD, but in french : HERE

PYAP

emaluzer

#6
September 17, 2006, 12:51:12 AM Last Edit: September 17, 2006, 02:07:47 PM by GauGau
I tried all the steps outlined,  now I cant upload a file, or edit a file.  When I want to upload it gives me this error:

QuoteThere was an error while processing a database query.
While executing query "INSERT INTO cpg_pictures (aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title, caption, keywords, approved, user1, user2, user3, user4, user5, user6, pic_raw_ip, pic_hdr_ip, position) VALUES ('14', 'userpics/10001/', 'darkwing~6.jpg', '49408', '71641', '640', '480', '1158446518', '1', 'emaluzer','dw', '', '', 'YES', '', '', '', '', '', '', '65.43.167.8', '65.43.167.8', '0')" on 0

mySQL error: Unknown column 'user5' in 'field list'
[Edit GauGau]Removed debug_output from posting. Only post it if a supporters asks you to do so[/edit]


As you can see there is a user7 in the edit, and a user5 in the upload.  After having problems with user5 I changed 5 to 7 in all the files, but for some reason it still appears in the upload error.  I believe that means I missed it somewhere.

I also added the neccessary user7 to my database as well as user_field7_name. 

I see this posted alot but no fix so sorry if I missed the fix or if it is on another post
emaluzer

emaluzer

#7
September 17, 2006, 05:34:26 AM
never mind I found a reload of coppermine actually fixed the problem

Thanks anyway

buuben

#8
September 21, 2006, 03:34:25 AM
 :) nice mod, thanks doggy

But just one question or hack request, if you like:

I'd like to add a one custom field which contains a drop-down list ( <select>...). I would like that my members could take the easiest way and choose their country from a drop down list. Is there any way to do this in Coppermine?

Joachim Müller

#9
September 22, 2006, 10:25:52 PM
Question not related to this mod. Please re-post your question on the regular support board.

hozyali

#10
December 07, 2006, 08:30:27 AM
Hello,

The mod works fine. Having one problem.

I have allowed an album to have uploads by guests too on admin approval.
Once guest uploads a pic, its uploaded fine.
in Admin, it shows the pic as pending approval, when I view that pic it does not show the field values from 5 and so on. however it shows 4 custom fields values fine. also if I enter information in the next custom fields, then it shows the values...

also when I approve the file, it shows an error on the next page...
No image to display

File: /home/.hasbro/stangor/bookstocollect.com/gallery/editpics.php - Line: 566
----------------------

can anyone help please ?

HozyAli


jianzhan

#11
March 31, 2007, 02:58:30 AM
picmgmt.inc.php in include folder should be also change the following code: then it works.

$query = "INSERT INTO {$CONFIG['TABLE_PICTURES']} (aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title, caption, keywords, approved, user1, user2, user3, user4, user5, user6, user7, user8, user9, user10, user11, user12, user13, user14, user15, user16, user17, user18, user19, user20, pic_raw_ip, pic_hdr_ip, position) VALUES ('{$CURRENT_PIC_DATA['aid']}', '" . addslashes($CURRENT_PIC_DATA['filepath']) . "', '" . addslashes($CURRENT_PIC_DATA['filename']) . "', '{$CURRENT_PIC_DATA['filesize']}', '{$CURRENT_PIC_DATA['total_filesize']}', '{$CURRENT_PIC_DATA['pwidth']}', '{$CURRENT_PIC_DATA['pheight']}', '" . time() . "', '{$CURRENT_PIC_DATA['owner_id']}', '{$CURRENT_PIC_DATA['owner_name']}','{$CURRENT_PIC_DATA['title']}', '{$CURRENT_PIC_DATA['caption']}', '{$CURRENT_PIC_DATA['keywords']}', '{$CURRENT_PIC_DATA['approved']}', '{$CURRENT_PIC_DATA['user1']}', '{$CURRENT_PIC_DATA['user2']}', '{$CURRENT_PIC_DATA['user3']}', '{$CURRENT_PIC_DATA['user4']}','{$CURRENT_PIC_DATA['user5']}', '{$CURRENT_PIC_DATA['user6']}', '{$CURRENT_PIC_DATA['user7']}','{$CURRENT_PIC_DATA['user8']}','{$CURRENT_PIC_DATA['user9']}','{$CURRENT_PIC_DATA['user10']}','{$CURRENT_PIC_DATA['user11']}', '{$CURRENT_PIC_DATA['user12']}', '{$CURRENT_PIC_DATA['user13']}', '{$CURRENT_PIC_DATA['user14']}','{$CURRENT_PIC_DATA['user15']}', '{$CURRENT_PIC_DATA['user16']}', '{$CURRENT_PIC_DATA['user17']}','{$CURRENT_PIC_DATA['user18']}','{$CURRENT_PIC_DATA['user19']}','{$CURRENT_PIC_DATA['user20']}','{$CURRENT_PIC_DATA['pic_raw_ip']}', '{$CURRENT_PIC_DATA['pic_hdr_ip']}', '{$CURRENT_PIC_DATA['position']}')";

Jian

jianzhan

#12
March 31, 2007, 03:00:11 AM
incldue folder's file: picmgmt.inc.php should be also changed the following codes and it works fine:

$query = "INSERT INTO {$CONFIG['TABLE_PICTURES']} (aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title, caption, keywords, approved, user1, user2, user3, user4, user5, user6, user7, user8, user9, user10, user11, user12, user13, user14, user15, user16, user17, user18, user19, user20, pic_raw_ip, pic_hdr_ip, position) VALUES ('{$CURRENT_PIC_DATA['aid']}', '" . addslashes($CURRENT_PIC_DATA['filepath']) . "', '" . addslashes($CURRENT_PIC_DATA['filename']) . "', '{$CURRENT_PIC_DATA['filesize']}', '{$CURRENT_PIC_DATA['total_filesize']}', '{$CURRENT_PIC_DATA['pwidth']}', '{$CURRENT_PIC_DATA['pheight']}', '" . time() . "', '{$CURRENT_PIC_DATA['owner_id']}', '{$CURRENT_PIC_DATA['owner_name']}','{$CURRENT_PIC_DATA['title']}', '{$CURRENT_PIC_DATA['caption']}', '{$CURRENT_PIC_DATA['keywords']}', '{$CURRENT_PIC_DATA['approved']}', '{$CURRENT_PIC_DATA['user1']}', '{$CURRENT_PIC_DATA['user2']}', '{$CURRENT_PIC_DATA['user3']}', '{$CURRENT_PIC_DATA['user4']}','{$CURRENT_PIC_DATA['user5']}', '{$CURRENT_PIC_DATA['user6']}', '{$CURRENT_PIC_DATA['user7']}','{$CURRENT_PIC_DATA['user8']}','{$CURRENT_PIC_DATA['user9']}','{$CURRENT_PIC_DATA['user10']}','{$CURRENT_PIC_DATA['user11']}', '{$CURRENT_PIC_DATA['user12']}', '{$CURRENT_PIC_DATA['user13']}', '{$CURRENT_PIC_DATA['user14']}','{$CURRENT_PIC_DATA['user15']}', '{$CURRENT_PIC_DATA['user16']}', '{$CURRENT_PIC_DATA['user17']}','{$CURRENT_PIC_DATA['user18']}','{$CURRENT_PIC_DATA['user19']}','{$CURRENT_PIC_DATA['user20']}','{$CURRENT_PIC_DATA['pic_raw_ip']}', '{$CURRENT_PIC_DATA['pic_hdr_ip']}', '{$CURRENT_PIC_DATA['position']}')";

Jian Zhan

masksmaster

#13
March 09, 2008, 01:05:19 AM
Thanks SO MUCH!
I completely didn't notice "table Prefix"_config: changes and couldn't figure out what went wrong. Your list of changes helped me figure it out!

masksmaster

#14
March 09, 2008, 03:12:08 AM
It seems like I followed all the steps. I got fields to display and be populated in DB. The only thing I have trouble with is the fact that new user fields are not searchable. Would anybody happen to know what could be wrong? I added this to include\search.inc.php
Code Select
$allowed = array('title', 'caption', 'keywords', 'owner_name', 'filename', 'pic_raw_ip', 'pic_hrd_ip', 'user1', 'user2', 'user3', 'user4', 'user5', 'user6', 'user7', 'user8', 'user9', 'user10', 'user11', 'user12');

Is there anything else I need to change there to make the search locate info from those fields?

Thanks in advance!!!

Jittery Jim

#15
November 06, 2008, 05:52:50 AM
Quote from: Doggy on August 22, 2006, 09:57:44 PM
2. The data base to modify.

Save your data base and make a Backup before the modifications !

Go to the config page of Coppermine, empty all the fields.

Make another safeguard of your data base and make the next modifications on this one, then import the data base.

(Change "table Prefix" to the prefix that you use for your tables.)

Find in "table Prefix"_pictures:

* snip *

Looking for assistance with this step - I'm not quite sure where or how I make these modifications. Any assistance is greatly appreciated.

Stevo

#16
May 11, 2009, 09:46:31 AM
Many thanks Doggy, it's working fine for me.

Have only 1 problem. If I use my searchbox he only search in the 4 original fields.
Code Select
<form method="get" action="thumbnails.php" name="searchcpg">
                    <input type="hidden" name="album" value="search">

                  <input type="hidden" name="type" value="full">
            <td bgcolor="#DFDEDE" align="center" height="60"><input type="input" style="width: 90%" name="search" maxlength="180" value="" class="textinput"></td>
                        <script language="javascript" type="text/javascript">
                        <!--
                        document.searchcpg.search.focus();
                        -->
                        </script>
            </tr>
            <tr><td bgcolor="#DFDEDE" colspan="8" align="center"><input type="submit" value="Search Gallery" class="button"></td>
                    </form>


I'm still using searchbox from cpg133.

Joachim Müller

#17
May 11, 2009, 09:50:21 PM
Then stop using it, as cpg1.3.x and everything related to it goes unsupported.

Stevo

#18
May 12, 2009, 11:26:05 AM
Quote from: Joachim Müller on May 11, 2009, 09:50:21 PM
Then stop using it, as cpg1.3.x and everything related to it goes unsupported.
Hey Joachim,
I understand that everything related to cpg 1.3.x is unsupportered, but maybe you can help me with this question
http://forum.coppermine-gallery.net/index.php/topic,59379.0.html

Joachim Müller

#19
May 13, 2009, 01:07:00 PM
Stop double-posting / cross posting. I have read that other thread and decided not to reply.
Print
Go Up Pages1 2
User actions