Can you mix AND and OR conditions in the WHERE?

EDIT - NEVERMIND! I just had a typo. I got it to work.

Thanks,

JMass

Hi Jason

I?m done.

What I did:

1.The folder "portuguese"

2. The "data_sql.sql" with the portuguese deffaults (BTW> nice way of translating things, i love it)
Question> Any issue on sql sintax regarding special charecters like " ?? ^ ~ " ???
( I?m asking that due our language, you know?)

3. Updated the "readme.txt" including some instructions in brazilian portuguese showig how to use the specific sql file for languges deffaults.


==========================================================================

One or two points:

I could not find the way out to translate the wellcome message at the top of admin?s page so , i?m thinking....... while you guys don?t provide the constant (define) to this phrase may we here in Brasil update the "admin/main.php" around line 42 and translate this wellcome mensage ?? I already did It for my personal test

On XOOPS admin?s area, in the left colunm when you rollOver the mod?s icon , on the popup, I couldn?t find the _MD_CREDITYPEDIT and _MD_EDITCRED constants to translate.

==========================================================
First wish:

How difficult would be to implement a nice dhtml ( or.........) scroll for the mod?s page?
I know that some people just hate those kind of effects but thinking on a "show side of the module" could be cool, i think

===========================================
Brief review:

The install proces was easy like a breeze........no erros or warnings of any type
I can fully manage all the mod?s functions.

XOOPS 207
Easyphp 1.6

Welldone Jason & Dan

Regards,
Wilson

Thanks Ackbarr!

I appreciate this sooo much! I was wondering how I would do this reporting stuff, and this is just the ticket.

PS - Thanks to you too Mith, for bringing this to my attention in the first place.

JMass

Is there a way to get rid of the child posting format? I would like it to just be like the forums here. Straight down instead of having to click a link to get to the next post... How would I do that?

1. WHERE clauses using 'OR'
The CriteriaCompo::add() function has a second, optional parameter.
Quote:
this would make $WHERE = 'WHERE (email LIKE '%xoops.org') OR (posts = 0)'

2. adding ORDER to Query
the renderWhere function does not do anything with the ORDER BY (or GROUP BY) clause. The XOOPS core uses the CriteriaElement objects like this (taken from XoopsUserHandler::getObjects())

I have been testing this out, but have a couple of questions.

1> The Where statement is all ANDs. Can you make it output ORs?

2> The WHERE statement does not include the ORDER. How do you generate this?

Thanks,

JMass

Most of the fields in the xoops_users field I would probably never use (IMs, etc.). I would like to just have things like... First Name, Last Name, Address, City, Phone, etc. for sign-up. Is there a clean way to add this and remove fields I would probably not use?

Right now I am screwing with changing the actual xoops_users table and changing the names of the fields that I wouldn't use and adding others. I figure this is a bad way and I need to make my own login module or something.

Does another login module exist already? One that is possibly customizeable? If not, should I go ahead and create my own mod. What's the best way?

bluwu

Quote:

Close. It should be:

It is great to see that someone is working on a new weather module. I have tried out the module, but there are a few issues.

3 problems
1 I have installed the module, but there is no module showing up in the admin page.

2 When opening the snx weather menu, you get a map of Europe with weather report of mont pelier.

3 The search weather in another city does not work

It would be great if this module could be improved, since there is no weather module that can supply the weather around the world.
(MS-Weather no longer works, due to copyright issues with Yahoo)

Looking forward to improvements...

true true... i think i should read up more on Smarty...

Thanks man... now i can finish jacking up my XOOPS...