XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / Need help with a code
Register
1
deka87
Need help with a code

  • 2010/4/27 19:06

  • deka87

  • Friend of XOOPS

  • Posts: 1125

  • Since: 2007/10/5


hi guys,

i've got a notifications hack which doesn't work giving a blank page. here is the part of it:

le="color: #000000"><?php //notifications hack ... $uids = array(); $sql = "SELECT DISTINCT uid FROM ".$xoopsDB->prefix("groups_users_link")." WHERE groupid = 6"; $result = $xoopsDB->query($sql); while($row = $xoopsDB->fetchArray($result)) { $uids[] = $row['uid']; } ...


the debug says

le="color: #000000"><?php Notice: Undefined variable: xoopsDB in file /modules/catads/admin/adsmod.php line 159


the 159 line is

le="color: #000000"><?php $sql = "SELECT DISTINCT uid FROM ".$xoopsDB->prefix("groups_users_link")." WHERE groupid = 6"; $result = $xoopsDB->query($sql);


any idea how to fix this?

thanks in advance!
Mind anchors
2
zyspec
Re: Need help with a code

  • 2010/4/27 20:41

  • zyspec

  • Module Developer

  • Posts: 1095

  • Since: 2004/9/21


There's a couple of possibilities depending on where this code is being placed...

1) near the top of the file add the following line:
le="color: #000000"><?php global $xoopsDB;


OR

2) everywhere you see
le="color: #000000"><?php $xoopsDB
replace it with
le="color: #000000"><?php $GLOBALS['xoopsDB']


If neither of these work, like if you're trying this in a custom page, etc. then it could be a little more involved... but I'd try one of the above methods first.
3
deka87
Re: Need help with a code

  • 2010/4/28 7:09

  • deka87

  • Friend of XOOPS

  • Posts: 1125

  • Since: 2007/10/5


le="color: #000000"><?php global $xoopsDB;


you made my day, zyspec! notifications on my website now respect user groups thanks!
Mind anchors

Post Reply

      
7 - 1 = ?  
Input the result from the expression
Maximum attempts you can try: 10
* = Required

Search

Advanced Search

Recent Posts

Who's Online

186 user(s) are online (148 user(s) are browsing Support Forums)

Members: 0

Guests: 186

more...

Donat-O-Meter

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

Latest GitHub Commits