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


« 1 2 3 (4) 5 6 7 ... 10 »


31
zorro87
Re: Profile module date bug, request fix

  • 2009/3/31 9:08

  • zorro87

  • Just popping in

  • Posts: 92

  • Since: 2006/9/29


Quote:

ghia wrote:
Quote:
Why date are saved as INT(10)?
It is stored as seconds past a date and contains thus a date and time. Futhermore it is very efficient for searching and sorting and calculating periods.
Storing it in ascii will severely degrade this. Has to stay!

@ghia: Thank you for these precisions! I understand your point of view.
But in phpmyadmin it is not easy to know what date is -236307600 for example…

In “Find Users” (profile/search.php) filter “Is earlier than” doesn’t work…


Quote:

Monika wrote:
Hi I prefer a dropdown selection date.


@Monika: You can do it!

Just add 3 fields (field Type: select)
Profile_date_dd (add 31 selections 1 to 31)
profile_date_mm (add 12 selections 1 to 12)
profile_date_yyyy (add a period list)


Nota: In “Find Users” (profile/search.php)
There is a little bug:
If value is set as NUM, (value as integer)

The selection is OK but column is empty (does not show the content of the field)


@+
Z
Topic | Forum


32
zorro87
Re: Profile module date bug, request fix

  • 2009/3/30 7:21

  • zorro87

  • Just popping in

  • Posts: 92

  • Since: 2006/9/29


Hi trabis!

Quote:

I understand the problem, there should be check to see if date was changed or not, maybe in JS validation code.


First problem: in “Edit Field” Default date is required
Maybe an option “no default date” could help to make it mandatory to enter a date?

Second problem: Why date are saved as INT(10)?

If the dates fields were in DATE format (YYYY-MM-DD)
It could be possible to know if a date has been set (test if a date is different of zero)
=>It could be easier to have no default date and oblige users to choose a date
It could be easier to find a date with MySQL (no conversion required)

What do you thing about that?

@+
Z

Topic | Forum


33
zorro87
Re: Profile module date bug, request fix

  • 2009/3/27 9:44

  • zorro87

  • Just popping in

  • Posts: 92

  • Since: 2006/9/29


Hello again!

The date is saved (UNIX format)
Quote:

I made it required in registration form.


The default date is saved even if you don’t choose a date.
And no way to chose 0 as default date.

Do you have any idea how a date could be required?

@+
Z
Topic | Forum


34
zorro87
Re: Profile module date bug, request fix

  • 2009/3/27 9:03

  • zorro87

  • Just popping in

  • Posts: 92

  • Since: 2006/9/29


Hi Trabis!

Trabis, you are the best!

This bug is fixed!
Quote:

The problem is when someone wants to register, he choose his birthday DATE, but it is not saved during registration!!

He has to go back to his profile and edit the DATE again!! then it will be saved correctly.


Thank you Trabis!


@+
Z
Topic | Forum


35
zorro87
Re: Profile module date bug, request fix

  • 2009/3/26 11:16

  • zorro87

  • Just popping in

  • Posts: 92

  • Since: 2006/9/29


Hi!

This is a very interesting problem!

I confirm: You have to go back to the profile to change date and then, the date is saved correctly.

A clue?

Dates are saves as UNIX format
0=1970-01-01

When you first save a date, the date (field date in profile_profile) is saved as a 4 digit number corresponding to the year of the date you selected (ex.“1975” if you chose 1975-03-15 as date).

This date (1975-03-15) should be saved as: 164070000 (UNIX time)

The date was not translated as a UNIX date and
1975 is understood as 1970-01-01 and 1975 seconds (UNIX date)
It is the reason why the date appears as 1970-01-01

With this date format (0 = 1970-01-01) there is a problem:

You can't make a date as mandatory field because default date always exist!
(0 UNIX = 1970-01-01)

Can’t we have date field save in this format 1970-01-01?

It is just a suggestion…
What do you think about that?


@+
Z
Topic | Forum


36
zorro87
Profile: find e-mail from all members

  • 2009/3/16 16:45

  • zorro87

  • Just popping in

  • Posts: 92

  • Since: 2006/9/29


Module "Profile"
In modules/profile/search.php


If you are a webmaster and you want to find users by e-mail:

Yon will find only users who allow showing e-mail to others users

There is no problem when you search a user by name (you will see the e-mail even if the member doesn’t want to show e-mail to others members).

How to see all e-mails when you are looking for users by e-mails?

@+
Z
Topic | Forum


37
zorro87
Re: PiCal 0.91 (MiniCalendarEx doesn’t show the events)

  • 2009/3/12 15:37

  • zorro87

  • Just popping in

  • Posts: 92

  • Since: 2006/9/29


Hi!

That is a verry good news!

Thank you!

@+
Z
Topic | Forum


38
zorro87
Re: Latest MultiMenu (for xoops 2.3.x)

  • 2009/2/27 9:37

  • zorro87

  • Just popping in

  • Posts: 92

  • Since: 2006/9/29


Quote:

Quote:

Solo71 give to us the link to the last version of Multimenu (2.05)

.

Just to correct, the link above is for v 2.0 beta not 2.05. does 2.05 exist?

Hi!
You are right! the zip name is 2.0 beta

But if you look into xoops_version.php
You'll see v2.05


@+
Z
Topic | Forum


39
zorro87
Re: PiCal 0.91 (MiniCalendarEx doesn’t show the events)

  • 2009/2/25 13:28

  • zorro87

  • Just popping in

  • Posts: 92

  • Since: 2006/9/29


Hi!

The problem "the description being empty upon edit"
happens in differents modules since XOOPS 2.3.x

Mylinks
X_mmovie 2.51
Googlemap
And probably others modules.

For Mylinks -> There is a fix from Burning in frXoops (in french)

May be it can help you...

@+
Z








Topic | Forum


40
zorro87
Re: PiCal 0.91 (MiniCalendarEx doesn’t show the events)

  • 2009/2/24 14:21

  • zorro87

  • Just popping in

  • Posts: 92

  • Since: 2006/9/29


Hi tommyZ

The question was ask in "PEAK XOOPS" (GIJOE's site) here
There is no solution for this problem yet.

If someone find a solution, the solution will probably be in PEAK XOOPS...

@+
Z
Topic | Forum



TopTop
« 1 2 3 (4) 5 6 7 ... 10 »



[Advanced Search]

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

175 user(s) are online (138 user(s) are browsing Support Forums)

Members: 0

Guests: 175

more...

Donat-O-Meter

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

Latest GitHub Commits