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 Development / 
  3. XOOPS Core Hacks 
  4.  / Need help in kernel/member.php
Register
1
lunaticalm
Need help in kernel/member.php

  • 2009/4/21 20:40

  • lunaticalm

  • Just popping in

  • Posts: 14

  • Since: 2005/1/4 1


Hi I want to add to function activateUser() a notification from one of the modules to be default checked for the registered users.
so I have added this to the activateUser() function, but i can't make this to insert value into xoopsnotifications table,

Please help me thanks.

le="color: #000000"><?php function activateUser(&$user) { if ($user->getVar('level') != 0) { return true; } $user->setVar('level', 1); //notification mod start //module id =9 $query = "INSERT INTO ".$xoopsDB->prefix("xoopsnotifications")." (not_modid, not_itemid, not_category, not_event, not_uid, not_mode) VALUES (9,".$user->getVar('uid').",'scrap','new_scrap',".$user->getVar('uid').",0)"; $res=$xoopsDB->query($query); if(!$res) { echo "error: $query"; } //notification mod end return $this->_uHandler->insert($user, true); }
2
ghia
Re: Need help in kernel/member.php

  • 2009/4/21 21:02

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Do you see the error?
Must you not use $this->_uHandler->db->prefix(" in stead of $xoopsDB->prefix(" ?
3
lunaticalm
Re: Need help in kernel/member.php

  • 2009/4/21 21:45

  • lunaticalm

  • Just popping in

  • Posts: 14

  • Since: 2005/1/4 1


Becouse the page is refrshing after activation, Yes i see the error if i ad exit() after echo "error: $query";

$xoopsDB->prefix is ok becouse that is pointing at my db prefix in databse, i can see that on the error , but can't understand what is causing the error.
4
ghia
Re: Need help in kernel/member.php

  • 2009/4/21 21:51

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


With the exit, copy the query and put it in the SQL window of phpMyAdmin and press go. It would give a clear error message if the query itself is not acceptable.
5
lunaticalm
Re: Need help in kernel/member.php

  • 2009/4/21 22:07

  • lunaticalm

  • Just popping in

  • Posts: 14

  • Since: 2005/1/4 1


I added and global $xoopsDB; at the code and
at error msg i have
le="color: #000000"><?php error: INSERT INTO myprefix_xoopsnotifications (not_modid, not_itemid, not_category, not_event, not_uid, not_mode) VALUES (9,867,'scrap','new_scrap',867,0)


When i run that query with phpmyadmin the query is executed with no errors , and new record is inserted into the table
6
ghia
Re: Need help in kernel/member.php

  • 2009/4/22 0:31

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Try once:
le="color: #000000"><?php echo "error: $xoopsDB->error()";
7
phppp
Re: Need help in kernel/member.php

  • 2009/4/22 1:26

  • phppp

  • XOOPS Contributor

  • Posts: 2857

  • Since: 2004/1/25


update queries are forbidden under a GET request.

Try
le="color: #000000"><?php $res = $xoopsDB->queryF($query);
8
lunaticalm
Re: Need help in kernel/member.php

  • 2009/4/22 5:03

  • lunaticalm

  • Just popping in

  • Posts: 14

  • Since: 2005/1/4 1


Thank you very much ghia, phppp.

Quote:
$res = $xoopsDB->queryF($query);

This solved the code to work.
Many time i wondered what is the diference between query and queryF, now i know :).

Post Reply

      
4 + 5 = ?  
Input the result from the expression
Maximum attempts you can try: 10
* = Required

Search

Advanced Search

Recent Posts

Who's Online

241 user(s) are online (168 user(s) are browsing Support Forums)

Members: 0

Guests: 241

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