eian00

i updated wordpress to the last version, and when i changed a new theme, the spam link does not appear, should i now rewrite the old theme code in new files under a new theme name. As the theme was custom made?

I got it,

the problem was that in magic fields for color I used a Checkbox List with the list of possible colors, so once you choose the color Red for example, wordpress stores it in the database like:

a:1:{i:0;s:4:"Red";}

so the correct form would be:

<?php
global $wpdb;
global $post;
$key1 = 'color';
$val1 = 'a:1:{i:0;s:4:"Red";}';
$key2 = 'shape';
$val2 = 'square';
$querystr = "
SELECT wposts.*
FROM $wpdb->posts wposts, $wpdb->postmeta metacolor, $wpdb->postmeta metawgt
WHERE wposts.ID = metacolor.post_id
AND wposts.ID = metawgt.post_id
AND (metacolor.meta_key = '$key1' AND metacolor.meta_value = '$val1')
AND (metawgt.meta_key = '$key2' AND metawgt.meta_value = '$val2')
AND wposts.post_type = 'post'
AND wposts.post_status = 'publish'
ORDER BY UPPER(wposts.post_title) ASC
"; 

$pageposts = $wpdb->get_results($querystr, OBJECT); ?>  <?php if ($pageposts):
?>  

<?php global $post; ?>
<?php foreach ($pageposts as $post): ?>
<?php setup_postdata($post); ?>
<div class="post" id="post-<?php the_ID(); ?>">  

<a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title(); ?>">  <?php the_title(); ?></a>

</div>
<?php endforeach; ?>
<?php endif; ?>

Nice it works,

I would need now just a more complex form;

next to the last and first name, display also the cimy field value, under the label “status”, and all together make a link to the users author.php page.

Thank you

ok, I sent you a mail

Ok, so something strange is happening.

The only way I get some results is when in the AGE field I set up a default value that will be applied automatically to all users; for example ’55’. The same for the field CITY example ‘Madrid’.

now when the code matches the values Madrid and 55 like in the code below;

<?php
global $wpdb;
global $userid;

$querystr = "SELECT wp_users.ID, user_login, display_name, cimy_age.VALUE as age, cimy_city.VALUE as city
FROM wp_users
JOIN wp_cimy_uef_fields cimy_fields1 ON cimy_fields1.NAME = 'CITY'
JOIN wp_cimy_uef_fields cimy_fields2 ON cimy_fields2.NAME = 'AGE'
JOIN wp_cimy_uef_data cimy_age ON
   (cimy_age.USER_ID = wp_users.ID AND cimy_age.FIELD_ID = cimy_fields2.ID)
JOIN wp_cimy_uef_data cimy_city ON
   (cimy_city.USER_ID = wp_users.ID AND cimy_city.FIELD_ID = cimy_fields1.ID)
WHERE cimy_fields1.VALUE = 'Madrid'
   AND cimy_fields2.VALUE = '55'";

$authorset = $wpdb->get_results($querystr, OBJECT); 

?> 

<?php if ($authorset): ?>
<?php global $wpdb; ?>
<?php
echo '<ul>';
foreach ($authorset as $userid){
  $return = '';
  $user_id       = (int) $userid->ID;
  $user_data = get_userdata($user_id);
  $return .= "\t" . "<li>$user_data->first_name $user_data->last_name  $userid->age $user_id->city</li>" . "\n";

  print($return);
}
echo '</ul>';
?>

<?php endif; ?>

I don’t get still any results.
But from the moment I go manually change in a profile page the city or age, i get displayed the users name, surname, age (no city is displayed) of the modified profiles.

There is no result in any other way

What is wrong?

No results, blank page, can you show me a simple example then, only how to show all the users having the same cimy field, let’s say HEIGHT is 190.

Just to see if it gets correctly the cimy data

i removed
<?php endforeach; ?> and there is no rerror anymore, but there is also nothing showing on the page. The cimy field names and values are correct.
Can it be maybe something wrong with the second part;

<?php if ($authorset): ?>
<?php global $wpdb; ?>
<?php foreach ($authorset as $userid){
   $user_id       = (int) $userid->ID;
   $surname  = get_cimyFieldValue($userid, 'SURNAME');
   $return .= "\t" . '<li>'. $surname .'</li>
' . "\n";

   print($return);
}
?>
<?php endif; ?>

Thank you for helping