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 ... 461 »


21
ghia
Re: INNER JOIN

  • 2011/2/4 9:14

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Quote:
What makes the join is the second to last line: "AND x.intronum=y.intronum", which joins the tables together.
Altough basicly equivalent, I prefer the join syntax, because you see immediate that x.intronum=y.intronum is used for the join, while in the previous WHERE list you have to search for it.

// Look for and list intros for each mount point.
$query2 = "SELECT x.sequence as sequence, x.intronum as intronum, y.filename as filename ";
$query2 .= " FROM ".$xoopsDB->prefix("uhqiceauth_intromap")." x";
$query2 .= " LEFT JOIN ".$xoopsDB->prefix("uhqiceauth_intros")." y ON x.intronum=y.intronum";
$query2 .= " WHERE x.server='".$row['server']."'";
$query2 .= " AND x.port='".$row['port']."'";
$query2 .= " AND x.mount='".$row['mount']."'";
$query2 .= " ORDER BY sequence";
Topic | Forum


22
ghia
Re: Users - Automatic Email

  • 2011/2/3 11:02

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Yes, this has nothing to do with the first hack, but is standard by XOOPS.
The second hack is to send the password with this mail.
Topic | Forum


23
ghia
Re: Minimum keyword length for profile search fields ?!

  • 2011/2/2 11:51

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


No, because then you should have to fill in all fields something, which is not desiireable.
Topic | Forum


24
ghia
Re: Users - Automatic Email

  • 2011/2/2 11:48

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


No, see this hack (in French).
Topic | Forum


25
ghia
Re: blank page on "Dates" module

  • 2011/1/28 17:54

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Did you create a writable /uploads/dates/folder?
Does your server supports URL rewriting?
If not try by removing .htaccess files.
Topic | Forum


26
ghia
Re: New Users Display Block Persistence

  • 2011/1/28 17:46

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


In the edit of the block, there is an option for how many.
The block shows always the last x users.
If you want a time, then you have to add an additional criteria (and eventually option) in /modules/system/blocks/system_blocks.php
Topic | Forum


27
ghia
Re: blank page on "Dates" module

  • 2011/1/28 13:15

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


XOOPS, module, PHP, MySQL version?
Topic | Forum


28
ghia
Re: XoopsObject & XoopsObjectHandler some guidelines?

  • 2011/1/27 1:01

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


1)
The name is the modulename, as in gethandler the indentifier is implicit the module name of the calling one.
4)
$pm->setVar("subject", $_POST['subject']);
        $pm->setVar("msg_text", $_POST['message']);
        $pm->setVar("to_userid", $_POST['to_userid']);

As example it is OK, but values need to be sanitized, before put in the database, to avoid XSS and other nasty exploits.
Topic | Forum


29
ghia
Re: My site shows only header and footer

  • 2011/1/27 0:48

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Did you try to repair the tables (also a function of phpMyadmin)?
Topic | Forum


30
ghia
Re: How to link a php script to a main menu item ?

  • 2011/1/26 18:58

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


See this.
Topic | Forum



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



[Advanced Search]

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

107 user(s) are online (82 user(s) are browsing Support Forums)

Members: 0

Guests: 107

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