XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk


« 1 ... 23 24 25 (26) 27 28 29 30 »


251
christian
Re: SQL query help.

  • 2005/5/21 16:33

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


Quote:
Does it save which user votes which answers for a particular poll?


SELECT log.user_id, u.name, u.email, o.option_text
FROM (xoops_xoopspoll_log log LEFT JOIN xoops_xoopspoll_option  o ON (log.poll_id = o.poll_id) 
AND (log.option_id = o.option_id)) 
LEFT JOIN xoops_users u ON log.user_id = u.uid
WHERE log.poll_id=2;


Best regards
Topic | Forum


252
christian
Re: Creating users in mass

  • 2005/5/4 18:56

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


Hi Simon,

this script run so :

file : user2.csv
it contains user, name and email (optional)
the fields are separate with a semicolon

file : phpfile_users.php
you must personnalize the informations for connect your database (line 5 to 8)

line 40 : change email@domain.tld
if in the users'file email not exist, the script create automatically a email address

line 46 : password equal to user

file : bd_test.sql
use for test this script

Give me a description of your file , and I can analyze for import in your site.
Topic | Forum


253
christian
Re: User registration problems

  • 2005/5/2 11:26

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


Hi,

The migration script phpBB2_XoopsBB_converter.sql is uncomplete because the users are not add in users registered group.

You must execute this query :
insert into xoops_groups_users_link select 2,uid from xoops_users where uid not in (select uid from xoops_groups_users_link where groupid=2);


For activate the users inactives you can execute this query :

update xoops_users set level=1 where level=0;


Best regards
Topic | Forum


254
christian
Re: How to install 2 xcgal without conflict?

  • 2005/4/29 20:17

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


Hi,

you can look this FAQ (How do I clone a module? )

Best regards
Topic | Forum


255
christian
Re: Creating users in mass

  • 2005/4/28 11:24

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


Hi

I made a package whith a flat file, where the users file contains only : user, name, email.

If not email in file, this is created automatically with your domains.

You can download here

Best regards
Topic | Forum


256
christian
Re: Migration and Import of users

  • 2005/4/26 15:00

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


Hi

I made a script for import from a flat file. Look my answer 2005/3/16 14:38 with link for download the script.

I work for this project and if you send a file sample with description I can realize a other script.

Best regards

(sorry for my poor english)
Topic | Forum


257
christian
Re: XOOPS mascot

  • 2005/4/26 11:48

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


I agree with Kainaij , bravo
Topic | Forum


258
christian
Re: Rent module

  • 2005/4/21 12:01

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


Hi,

You can look the resmanager module.

Best regard
Topic | Forum


259
christian
Re: aligning center an image on news module

  • 2005/4/12 13:43

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


Quote:


<div style="text-align:center">
[img ]http://file_image.jpg[/img ]
</div>



Delete space between img and ] , this sample is not ok here without space
Topic | Forum


260
christian
Re: Dynamic Theme

  • 2005/4/5 13:32

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


Hi

Have you look this FAQ and this sample with http://www.myxoops.org/ ?

Best regards
Topic | Forum



TopTop
« 1 ... 23 24 25 (26) 27 28 29 30 »



[Advanced Search]

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

198 user(s) are online (119 user(s) are browsing Support Forums)

Members: 0

Guests: 198

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits