[MOD] Dropdown options for custom database fields

[Sun Zaza]

Hi V@no,

Because in the first time I got this error:

Code: [Select]

Fatal error: Call to undefined function get_user_table_field() in /hsphere/local/home/******/*******/includes/db_field_definitions.php on line 423
I used this code:

Code: [Select]

<?php $sql = "SELECT user_name, user_id
        FROM ".USERS_TABLE."        
        ORDER BY user_name ASC";
$result = $site_db->query($sql);
$user_name = array("----------------------");
while ($user_row = $site_db->fetch_array($result))
{
  $user_name[] = $user_row['user_name']." (ID=" . $user_row['user_id'].")";  
}
$additional_test_fields['test_player'] = array($lang['test_player'], "dropdown", 0, $user_name, 0, 0, 0, 0);?>
Do you know why?

[MrAndrew]

Very strange. I use 1.7.7 version of my gallery. I have installed this mod for ver 1.7.6. Installed correct. But nothing to change? I have trying and trying... but {image_blablabla_dropdown} - not working and i see nothing. Please help me with this mod.

Thanks!

[Cambons]

With 1.7.8 do ihave to do 1.7.6 + 1.7.7 or just 1.7.7?

Thank you!

[V@no]

There is no code for 1.7.7, so try do the 1.7.6

[Cambons]

4images v1.7

i thought it was 1.7.7 for a moment.. sorry about that.

But still, should I do the 1.7.6 + 1.7  ( next steps? )

--

Edit nevermind dumb me, 1.7 = "1.7.0" so no point in doing that

[V@no]

no, just 1.7.6

I've added some notes regarding this on first page.

[Cambons]

Yea sorry i'm dumb it took me a while to figure out 1.7 = 1.7.0 lol

[MrAndrew]

This MOD work fine for users table! But doesn`t work for images table..

How to show dropdown from images table?

Code: [Select]

  $sql = "SELECT image_aircraft
             FROM ".IMAGES_TABLE."
             ORDER BY image_aircraft DESC
";
             $result = mysql_query($sql);
$image_aircraft = array();
while ($image_row = $site_db->fetch_array($result)) {
$image_aircraft[] = current($image_row);
$additional_image_fields['image_aircraft'] = array($lang['image_aircraft'], "dropdown", 0, $image_aircraft, 0, 0, 0, 0);
 }
Nothing to show me 

[Sun Zaza]

Hello,

How can I use the dropdown options for custom database fields in the member_editprofile?

I am using thisl line on the file but without success:

Code: [Select]

<input type="dropdown" name="user_foot"  size="30" value="{user_foot}" class="input" />
Thanks in advance,

[V@no]

did you try use {user_foot_dropdown} (without any additional <input>)

[Sun Zaza]

No, but now I did. Het is working. Thanks.

I just realize another problem, because I cannot update the database from the page member_editprofile.html.
I am talking here about everything (Not only the dropdown.

I will open a new topic.

Thank V@no

[Jan-Lukas]

1.7.10 tauglich

[Pawel_el]

If it works for version 1.7.10?

[Jan-Lukas]

1.7.10 tauglich

und mit Sicherheit auch 1.7.11

[.Infecto]

Wenn ich das so anlege
$additional_image_fields['image_filesize'] = array("Filesize", "dropdown", 0, array("n" => "---", "KB" => "KB", "MB" => "MB", "GB" => "GB"), 1, 0, 0, 0); 
und auch so
$additional_user_fields['image_filesize'] = array("Filesize", "dropdown", 0, array("n" => "---", "KB" => "KB", "MB" => "MB", "GB" => "GB"), 1, 0, 0, 0); 
wird mir das Feld nicht im ACP angezeigt...