Problem installing 'Search in Profiles' mod

[vegematarian]

nothing happened when I clicked that link

http://www.oxpus.de/load.php?id=25

[oxpus]

Then use the attached file.

[oxpus]

Then use the attached file.

[vegematarian]

Hi again,

Actually I already have custom profiles installed:

http://www.phpbbhacks.com/viewhack.php?id=2121

Will I still need to install your mod?

What I need is to be able to search certain profile fields for certain members.

P.S. Do you have AIM or ICQ or Yahoo messanger?

[oxpus]

You named mod will be better than just add hardcoded a new field to the profile.
You must not install both mods.
And messanger yes icq, but support and questions only here, please.

[vegematarian]

I don't understand your last post

Should I use your add on mod or stick with the one that I just listed?

[oxpus]

Only use the mod you haved posted. Forget the other one.
Sorry for the missunderstanding.

[vegematarian]

OK, so now what would I have to do to be able to allow certain members to eligible for a search.

Just to make it clear here is what I need again:

Say I have 50 members on my forums.
25 of them have 100 posts/points or more.

I have made a new category called "gender (M/F)"

I want people to be able to search for "M or F" but I want them to only be able to search for the people who have 100+ posts/points.

Is this possible?

[oxpus]

Not easy, because the search must be able to decide between male and female user (Integrated switch on search form and script).

To search for user with more than 100 posts you can use the following:

Code: Alles auswählen

#
#-----[ OPEN ]-----
#
search.php // and/or search2.php for you

#
#-----[ FIND ]-----
#
		$template->set_filenames(array(
			'body' => 'search_results_profiles.tpl')
		);

		$sql = "SELECT user_id, username FROM ".USERS_TABLE."
			WHERE user_active = 1

#
#-----[ AFTER, ADD ]-----
#
			AND user_posts >= 100

#
#-----[ SAVE/CLOSE ALL FILES ]-----
#
# EoM

Replace "user_posts" with "user_points" if you want to search these users.

Add after

Code: Alles auswählen

AND user_posts >= 100

Code: Alles auswählen

AND user_points >= 100

if you want to search only in profiles which user have 100 posts and points.

Replace

Code: Alles auswählen

AND user_posts >= 100

with

Code: Alles auswählen

AND ( user_posts >= 100 OR user_points >= 100 )

if the search should found users with 100 posts or points.

[vegematarian]

thank you!

[oxpus]

No problem.

[vegematarian]

By the way, is it possible to search posts that were made in certain forums instead of overall forums on the board?

i.e. If my board has 4 forums, is it possible to search members who have 100+ posts in forums A & B and not in C & D?

[oxpus]

Heavy. To do that you must count the posts for each user and forum. The search will run very long. Better not.

[vegematarian]

Hi again,

I was trying to setup a new search page where I can search individual profile options.

i.e. have one box to search for sex (M/F), one to search states (U.S.) - where I would already setup a drop box in profiles where people choose their states.

Can you help me out with this?

thank you!

[oxpus]

A search like multifield aganist the profile?
Why not.
Link and files and I will take a look.

[vegematarian]

http://www.sickkittens.com/forums/profi ... ue&ruid=-1

I want to be able to have people search for people for the following categories:

Gender, Age, State, Country, Sexuality

I want this to be on a search2.php

[oxpus]

To do this, post the fields in your user table to use the right ones. Then I'll create this search form.

[vegematarian]

I'm not sure what you mean. How do I do that? I wish we could chat on ICQ because this is goign to take a long time going back and forth (not complaining at you though)

[oxpus]

Make a backup from your users-table without data (only structur) and attach this here. When I'll get the required fields for your search...

[vegematarian]

I'm not sure how to do that

[oxpus]

If you have installed phpmyadmin you can backup your database:
- Choose your database
- Click on "Export"
- Choose only the table phpbb_users
- Unmark the field "Data" and klick on "OK"

The file will now download the structur ob this table and this file I need to find the field names you wants to search for.
If you'd not install phpmyadmin (or your hoster haven't installed this for you), download the package and install it. This is a very usefull database management tool (and not a mod for phpbb!).

[vegematarian]

I don't see the field names that I have recently added (Gender, Age, State, Country, Sexuality ) You can find them listed here:

http://www.sickkittens.com/forums/profi ... ue&ruid=-1

# phpMyAdmin MySQL-Dump
# version 2.3.2
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: May 27, 2004 at 12:00 AM
# Server version: 3.23.51
# PHP Version: 4.3.2
# Database : `sickkittens_com`
# --------------------------------------------------------

#
# Table structure for table `phpbb_users`
#

CREATE TABLE phpbb_users (
user_id mediumint(8) NOT NULL default '0',
user_active tinyint(1) default '1',
username varchar(25) NOT NULL default '',
user_password varchar(32) NOT NULL default '',
user_session_time int(11) NOT NULL default '0',
user_session_page smallint(5) NOT NULL default '0',
user_lastvisit int(11) NOT NULL default '0',
user_regdate int(11) NOT NULL default '0',
user_level tinyint(4) default '0',
user_posts mediumint(8) unsigned NOT NULL default '0',
user_timezone decimal(5,2) NOT NULL default '0.00',
user_style tinyint(4) default NULL,
user_lang varchar(255) default NULL,
user_dateformat varchar(14) NOT NULL default 'd M Y H:i',
user_new_privmsg smallint(5) unsigned NOT NULL default '0',
user_unread_privmsg smallint(5) unsigned NOT NULL default '0',
user_last_privmsg int(11) NOT NULL default '0',
user_emailtime int(11) default NULL,
user_viewemail tinyint(1) default NULL,
user_attachsig tinyint(1) default NULL,
user_allowhtml tinyint(1) default '1',
user_allowbbcode tinyint(1) default '1',
user_allowsmile tinyint(1) default '1',
user_allowavatar tinyint(1) NOT NULL default '1',
user_allow_pm tinyint(1) NOT NULL default '1',
user_allow_viewonline tinyint(1) NOT NULL default '1',
user_notify tinyint(1) NOT NULL default '1',
user_notify_pm tinyint(1) NOT NULL default '0',
user_popup_pm tinyint(1) NOT NULL default '0',
user_rank int(11) default '0',
user_avatar varchar(100) default NULL,
user_avatar_type tinyint(4) NOT NULL default '0',
user_email varchar(255) default NULL,
user_icq varchar(15) default NULL,
user_website varchar(100) default NULL,
user_from varchar(100) default NULL,
user_sig text,
user_sig_bbcode_uid varchar(10) default NULL,
user_aim varchar(255) default NULL,
user_yim varchar(255) default NULL,
user_msnm varchar(255) default NULL,
user_occ varchar(100) default NULL,
user_interests varchar(255) default NULL,
user_actkey varchar(32) default NULL,
user_newpasswd varchar(32) default NULL,
user_points mediumint(8) unsigned NOT NULL default '0',
user_photo varchar(100) default NULL,
user_photo_type tinyint(4) NOT NULL default '0',
user_effects varchar(255) default NULL,
user_privs varchar(255) default NULL,
user_custitle text,
user_specmsg text,
user_items text,
user_trade text,
PRIMARY KEY (user_id),
KEY user_session_time (user_session_time)
) TYPE=MyISAM;

[oxpus]

Thx, this is the list I need. Now I can code the search form.

[vegematarian]

thanks

[vegematarian]

When do you think you could have that so that I could test it out? Just curious. No rush