Jim R

I’m already using a mobile friendly theme, beyond a widget area that I’d like in a regular browser but not in a phone browser. There has to be something in the codex.

What if I have two custom data values in one of the fields? Does that work? (I can’t make heads or tails of REGEX samples I see on MySQL’s site.

Here is my whole query:

$query = ‘SELECT um1.meta_value as custom, um2.meta_value as level, um3.meta_value as c_reason, u.ID, u.user_login, u.user_email
FROM wp_usermeta um1
INNER JOIN wp_usermeta um2
INNER JOIN wp_usermeta um3
ON um1.user_id = um2.user_id
JOIN wp_users u
ON um1.user_id = u.ID
WHERE um1.meta_key = “wp_s2member_custom_fields”
AND um2.meta_value LIKE “%s2member_level%”
GROUP BY um1.user_id’;

$result = mysql_query($query);

//Process results into temp array
$regionData = array();
while($row = mysql_fetch_assoc($result))
{
//var_dump($row);

$custom = unserialize($row[‘custom’]);
$user_region = $custom[‘county’];

$level = unserialize($row[‘level’]);
$level_desc = key($level); //E.g. s2member_level3

// Trying to determine why someone is subscribing

$reason = unserialize($row[‘c_reason’]);
$user_reason = $reason[‘reason’];

It doesn’t find any values for $user_reason, even though I should have two of them. The var_dump shows all the data when it’s uncommented.

Hmmm…I’ll look at it.

Here is my data:

meta_key	                                   meta_value
wp_s2member_custom_fields	   a:2:{s:6:"reason";s:2:"ue";s:6:"county";s:1:"4";}

Initially, I just had the “county” -> “4” part, and with help was able to use it. I’ve since added “reason” ->”ue”, but I’ve not been able to get the help I need to use that.

Basically, I want to know what “reason” a person is subscribing. There are 11 options, “ue” being one of them.

From there, if their reason is “hsbball” (one of the options), I then need to know what “county” they live in.

Talk to me. LOL
Is regexp a plugin? I’m horrible with WP codex.

On my main site, I use includes and bring a great deal of content to Pages in WP. I’d love to set up something similar on my registration page. (Not that that’s what you’re talking about.)

s2member is working on a version where their custom registration fields do write to their own data table columns, instead of arrays in the user_meta data table. I’m having the same issue as dix.alex and am looking for a solution.

I think I can help dix.alex with his query if I can hook into the registration page. I just can’t seem to find where I would do that. Unless dix.alex has already found a solution. I hope so. ??

To be specific, I’m not looking for a plugin or solution that takes over the registration page or provides shortcodes. I just need to add custom fields, and I need them to be able to write to columns in a datatable. So I’m looking for the correct hook so I can add whatever content I need to.

Thanks…I will post it at the plugins and hacks board.

As for s2member, in creating custom registration fields I’m sure it’s bulky to add a column for custom field, maybe even unstable. I’m sure serialized data is an easy add for them. It’s just another row. I just don’t know how to deal with it in an efficient manner.

[mod: moved to ‘Plugins and Hacks’]

Don’t make it your static front page via a sub-directory. Just put the short code on a regular page.

If you’re using the forum as your front page, why to just use regular forum software like phpBB or SMF?

I might have had the same problem. I couldn’t start a new topic either. Then I deactivated my other forums, and it all works out well.

Never mind, I found the original set of posts helping me figure it out.

It’s been my experience this is an issue with how NextGen writes the images into the post. Test it out and look for this:

When it writes the NextGen images, it does so with just single quotes.

<a  href='https://hoosierhoopsreport.com//wp-content/gallery/carmel-vs-noblesville-11dec02/dsc05405.jpg' title=''><img src='https://hoosierhoopsreport.com//wp-content/gallery/carmel-vs-noblesville-11dec02/thumbs/thumbs_dsc05405.jpg' alt='SONY DSC' class='ngg-singlepic ngg-none' /></a>

vs. using double quotes for an image out of media library or off your hard drive.

<a href="https://hoosierhoopsreport.com/wp-content/uploads/logo.png"><img src="https://hoosierhoopsreport.com/wp-content/uploads/logo.png" alt="" title="logo" width="570" height="200" class="alignnone size-full wp-image-3168" /></a>

I used to be able to find the fix for it, but I can’t locate it now. I spent about 15 minutes trying to search for it. It’s been that way since I started using the plugin two years ago.

They have a paid/Pro version that I’ve used recently that works quite well.

I appreciate the word of warning, but I do have unlimited. I’ve tested it, and the only issue I’ve ever had is a processes issue. Then again, I don’t get so many visitors in a month that I truly need to worry about it.

Embedding it just streams it? Dang…easy.