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";



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.



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.



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).



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.



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



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?



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.



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)?



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.




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



Login

Username:
Password:

Lost Password? Register now!

Who's Online

89 user(s) are online (55 user(s) are browsing Support Forums)


Members: 0


Guests: 89


more...

Donat-O-Meter

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

Latest GitHub Commits