[MOD] Dropdown options for custom database fields

[live@ct]

For the vetsion 1.7.7 how can I make to  use the dropdown for image fields and user_field, the user_country, I have both in the user and images tables, but I dont know if I can use the same array for both because when some user try to register the user_country_dropdown works, but in the member_upload_form it not show the country_dropdown

I need to make a separate array or why it not showing in the upload form

[Sun Zaza]

Hello,

I am trying to get some information from the database using the Dropdown option for custom database fields. It works almost, but because I am not a PHP programmer I need some support from you guys.

In the db_fields_definitions.php I use the following code:

Code: [Select]

$sql = "SELECT zu_players_name
             FROM ".ZU_PLAYERS_TABLE."
";
             $result = $site_db->query($sql);
while ($zu_players_row = $site_db->fetch_array($result)) {
     $zu_players_name = $zu_players_row['zu_players_name'];
         
}


And then I used $zu_players_name in this code:

Code: [Select]

$additional_zu_games_fields['zu_games__goals'] = array($lang['zu_games__goals'], "dropdown", 0, array($zu_players_name), 0, 0, 0, 0);

Almost there. The results is only the last name in the list. (Only 1 name)

I need some help to get all the names of the list.

Your help is appreciated,

Cruxy

[Rembrandt]

...
Almost there. The results is only the last name in the list. (Only 1 name)

I need some help to get all the names of the list....

test it:
$zu_players_name .= $zu_players_row['zu_players_name'];

mfg Andi

[V@nо]

actually, you need save them into an array:
$zu_players_name[] = $zu_players_row['zu_players_name'];

[Sun Zaza]

Thanks Rambrand & V@no.

The 2 solutions did not work for me. I used this one:

Code: [Select]

$zu_players_name[] = current($zu_players_row);
It works fine.

Thanks anyway for your help.
Cruxy

[Sun Zaza]

Hello,

I have a question:

This is my code to get information from the database using the dropdown box for custom db field:

Code: [Select]

$sql = "SELECT zu_games_name
             FROM ".ZU_GAMES_TABLE."
";
             $result = mysql_query($sql);
$zu_games_name = array();
while ($zu_games_row = $site_db->fetch_array($result)) {
$zu_games_name[] = current($zu_games_row);
             $additional_zu_goals_fields['zu_goals_name'] = array($lang['zu_goals_name'], "dropdown", 0, $zu_games_name, 0, 0, 0, 0);
 }

My question is:

How can I get the ------------------ in the begining of each dropdown. I tried everything, but without success. Any please?

Many thanks in advance,
Cruxy

[V@no]

 $zu_games_name = array("----------------------");

[Sun Zaza]

I did not thought about this solution. It works perfect. Thankt a lot.

[Sunny C.]

-> Google
The drop-down boxes are not stored in the "Edit Images". With each call you have to reset them. In the ACP, but the fields are saved and are on the option you have chosen as the last!

Die Dropdownfelder werden im Bereich "Edit Images" nicht gespeichert. Bei jedem Aufruf muss man diese neu setzen. Im ACP werden die Felder aber gespeichert und stehen auf der Option die man als letztes gewählt hat!

[Sunny C.]

Ich weis nicht woran es liegt!
Aber im Editmages stehen die Dropdowns nicht auf der Option die man gewählt hatte, aber im ACP ist das so!

[Jan-Lukas]

Der Code von der Version 1.6.7 ist komplett 1.7.7 tauglich, kann im ersten Posting editiert werden.

LG

[Sun Zaza]

Hi,

After trying without any progress, I want to ask you guys about this issue.

I am using this code to get the name of the users (He is working fine):

Code: [Select]

<?php $sql = "SELECT user_name
             FROM ".USERS_TABLE."
 ORDER BY user_name ASC
 ";
             $result = mysql_query($sql);
 $user_name = array("----------------------");
 while ($user_row = $site_db->fetch_array($result)) {
 $user_name = $user_name;
 $user_name[] = current($user_row);
             $additional_test_fields['test_player'] = array($lang['test_player'], "dropdown", 0, $user_name, 0, 0, 0, 0);
 }?>
The results is:

ADMIN
user1
user2
user3

Now I want to get also the user_id after the name of the user. Something like:

ADMIN (id=9)
user1 (id=1)
user2 (id=2)
user3 (id=3)


Could you help please?

Many thanks in advance,
Cruxy

[V@no]

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


I don't know what is your code that receives the value from the dropdown, but I'd suggest use multidimention array instead:

<?php
$sql = "SELECT " . get_user_table_field("", "user_name") . get_user_table_field(",", "user_id") . "
        FROM ".USERS_TABLE."
        WHERE " . get_user_table_field("", "user_level") . " > " . GUEST ."
        ORDER BY " . get_user_table_field("", "user_name") . " ASC";
$result = $site_db->query($sql);
$user_name = array("----------------------");
while ($user_row = $site_db->fetch_array($result))
{
  $user_name[$user_row[$user_table_fields['user_id']]] = $user_row[$user_table_fields['user_name']] . " (id=" . $user_row[$user_table_fields['user_id']] . ")";
}
$additional_test_fields['test_player'] = array($lang['test_player'], "dropdown", 0, $user_name, 1, 0, 0, 0);
?>


Dropdown will return user_id

[Sun Zaza]

Thanks V@no for the solution. It's works perfect, but I got another problem.

I want to show this format in the dropdown: user1 (ID= 1), but I want to save only the user_name in the database (user1).

Is that possible?

[V@no]

use my second code and then replace
  $user_name[$user_row[$user_table_fields['user_id']]] = $user_row[$user_table_fields['user_name']] . " (id=" . $user_row[$user_table_fields['user_id']] . ")";


with

  $user_name[$user_row[$user_table_fields['user_name']]] = $user_row[$user_table_fields['user_name']] . " (id=" . $user_row[$user_table_fields['user_id']] . ")";