Support Forums - All Posts - XOOPS Web Application System

Forum Index

Board index » All Posts (dheltzel)

« 1 ... 4 5 6 (7) 8 9 10 ... 13 »

Re: Customisation of Xoops Registration screen

2004/8/3 16:18
dheltzel
Not too shy to talk
Posts: 164
Since: 2003/1/8 1

If your needs are not too extensive, you might be able to repurpose some exiting fields that you aren't using. For example, you could change the "ICQ" field to a memberid or member number. This only requires changing the language files (language/english directory - search for ICQ).

As already mentioned, better solutions are coming, so if you can use this for now, I'd do that.

Be aware that any changes you make to the XOOPS core, whether modifying just a language file, or hacking the user object, will be overwritten if you upgrade XOOPS in the future. That means you have to keep redoing your changes with each update.

Dennis

Topic | Forum

Re: Module for each user?

2004/8/3 16:02
dheltzel
Not too shy to talk
Posts: 164
Since: 2003/1/8 1

Of course that's possible. Just store the uid in the database table and make all the selects include that as part of the where clause. You only need 1 module and one set of database tables for any number of users.

Dennis

Topic | Forum

Re: Adding a Member Log In box to site

2004/8/3 12:25
dheltzel
Not too shy to talk
Posts: 164
Since: 2003/1/8 1

All of this is already there in the default installation, unless it is explicitly turned off in the admin menus. If you log out and don't see a login box, perhaps you should try re-installing from the beginning.

Topic | Forum

Re: Children's sports clubs

2004/7/31 17:07
dheltzel
Not too shy to talk
Posts: 164
Since: 2003/1/8 1

You can get a lot of this done (albeit manually) with a simple content module like TinyContent. For example, Committee members could be done something like this:http://www.dcas.us/modules/tinycontent/index.php?id=3

The email issue is a little tougher. Have you tried the evennews module. That's a start anyway.

When do you do the registrations? I'm planning a module that might help with this, but it's really not even started yet. If you're interested in helping build that, go join the module dev forge and send me a pm with your login name there and what you'd like to do to help.

Dennis

Topic | Forum

Re: Agenda-X Image Problem

2004/7/30 19:48
dheltzel
Not too shy to talk
Posts: 164
Since: 2003/1/8 1

If you can access the DB, try inserting you image directly into the agendax_mcalurl table. The table has only 1 row.

update <prefix>_agendax_mcalurl set mc_url = 'http://www.yahoo.com/image.gif';

You'll need to change the obvious parts there.

Dennis

Topic | Forum

Re: Edit Users - Is There Any Way to Lose Most of the Fields?

2004/7/28 20:16
dheltzel
Not too shy to talk
Posts: 164
Since: 2003/1/8 1

You will need to edit the following file:

modules/system/admin/users/userform.php

About halfway in the file, you'll find lines like:

$timezone_select = new XoopsFormSelectTimezone(_US_TIMEZONE, "timezone_offset", $timezone_value);
$icq_text = new XoopsFormText(_AM_ICQ, "user_icq", 15, 15, $icq_value);
$aim_text = new XoopsFormText(_AM_AIM, "user_aim", 18, 18, $aim_value);
$yim_text = new XoopsFormText(_AM_YIM, "user_yim", 25, 25, $yim_value);
$msnm_text = new XoopsFormText(_AM_MSNM, "user_msnm", 30, 100, $msnm_value);
$location_text = new XoopsFormText(_AM_LOCATION, "user_from", 30, 100, $location_value);
$occupation_text = new XoopsFormText(_AM_OCCUPATION, "user_occ", 30, 100, $occ_value);
$interest_text = new XoopsFormText(_AM_INTEREST, "user_intrest", 30, 150, $interest_value);

Commenting out these lines will remove the corresponding lines from the form. You can also use this to reorder them if desired.

Dennis

Topic | Forum

Re: Adding Users - Importing to Database

2004/7/28 20:01
dheltzel
Not too shy to talk
Posts: 164
Since: 2003/1/8 1

Here is an Access query I wrote to pull out user info and create a SQL file to load into Xoops.

Quote:

SELECT 'INSERT INTO
xoops_users(name,uname,email,url,user_icq,user_from,pass) VALUES (''' &
[Mailmast].[FN] & ' ' & [Mailmast].[LN] & ''',''' &
LEFT([Mailmast].[FN],1) & [Mailmast].[LN] & ''',''' & [Mailmast].[Email
Address] & ''',''' & [Mailmast].[Web Page] & ''',''' & [Mailmast].[Key] &
''',''' & [Mailmast].[Addr1] & ' ' & [Mailmast].[Addr2] & ',' &
[Mailmast].[City] & ', ' & [Mailmast].[St] & ' ' & [Mailmast].[Zip] & ' '
& [Mailmast].[Prov] & ' ' & [Mailmast].[Country] & ''', md5(''' &
[Mailmast].[Password] & '''));' AS xoops_sql
FROM Mailmast;

You will need to adapt this to the table structure you are using in Access. It does handle the password encryption correctly. It does not put the new users into any groups, you will need to use the group admin to do that after the import is complete (put them into "registered" at least).

Dennis

Topic | Forum

Re: XOOPS/SQL Question

2004/7/22 15:17
dheltzel
Not too shy to talk
Posts: 164
Since: 2003/1/8 1

Try this:

$result = $xoopsDB -> queryF("SELECT * FROM thetesttable LIMIT 0, 30");

I don't think it likes quotes arounf the tablename, and I usually use " instead of ', but I'm not sure that matters.

Dennis

Topic | Forum

Re: Accessing PHP variables from template? How to?

2004/7/22 15:13
dheltzel
Not too shy to talk
Posts: 164
Since: 2003/1/8 1

Put this line in the .php file to make the variable visible to Smarty:

$xoopsTpl->assign('rate', '1');

Also, you might try using 'eq' instead of '==' like this:

<{if $rate eq '1'}>

Dennis

Topic | Forum

Re: XOOPS/SQL Question

2004/7/21 21:50
dheltzel
Not too shy to talk
Posts: 164
Since: 2003/1/8 1

Quote:

Casey wrote:
$result = $xoopsDB -> query('SELECT * FROM `thetesttable` LIMIT 0, 30');

-- Casey

Try queryF instead, like this:

$result = $xoopsDB -> queryF('SELECT * FROM `thetesttable` LIMIT 0, 30');

Dennis

Topic | Forum

Top

« 1 ... 4 5 6 (7) 8 9 10 ... 13 »

Stats
Goal:	$100.00
Due Date:	May 31
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Forum Index

Re: Customisation of Xoops Registration screen

Re: Module for each user?

Re: Adding a Member Log In box to site

Re: Children's sports clubs

Re: Agenda-X Image Problem

Re: Edit Users - Is There Any Way to Lose Most of the Fields?

Re: Adding Users - Importing to Database

Re: XOOPS/SQL Question

Re: Accessing PHP variables from template? How to?

Re: XOOPS/SQL Question

Login

Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Re: NewBB v 5.1.0 b 6

Re: NewBB v 5.1.0 b 6

NewBB v 5.1.0 b 6

Re: XOOPS 2.5.11 search user is not working

Re: oledrion

Re: oledrion

Re: oledrion

Re: oledrion

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}