12
I'm not an specialist and didn't do it myself, but I would do it like this
in the mainfile.php , you should change
define('XOOPS_DB_TYPE', 'mysql');
change it to : define('XOOPS_DB_TYPE', 'pgsql');
in the classes/database/databasefactory.php
you can see the getDatabase function, this will include
XOOPS_ROOT_PATH.'/classes/database/'.XOOPS_DB_TYPE.'database.php'; (don't change)
so the only thing you have to do, is to make a copy of the
mysqldatabase.php class, name it ie pgsqldatabase.php, and put it in the '/classes/database/ directory ,
make sure the prefix in your mainfile, corresponds with the filename of your pg class
so now you can start to re-implement the methods with the pg functions instead of mysql
good luck, and don't forget to post your sollution on the forum.
in the mainfile.php , you should change
define('XOOPS_DB_TYPE', 'mysql');
change it to : define('XOOPS_DB_TYPE', 'pgsql');
in the classes/database/databasefactory.php
you can see the getDatabase function, this will include
XOOPS_ROOT_PATH.'/classes/database/'.XOOPS_DB_TYPE.'database.php'; (don't change)
so the only thing you have to do, is to make a copy of the
mysqldatabase.php class, name it ie pgsqldatabase.php, and put it in the '/classes/database/ directory ,
make sure the prefix in your mainfile, corresponds with the filename of your pg class
so now you can start to re-implement the methods with the pg functions instead of mysql
good luck, and don't forget to post your sollution on the forum.
13
ok that's seems what I want to see, I will dive in the code tomorrow, and make a clickable url
a quick look in the DB revealed the links are saved completely, so it's not the protector module
a quick look in the DB revealed the links are saved completely, so it's not the protector module
14
i have noticed the referers originating from google are not fully displayed in the "show all referers"- page (refererdetail.php) , i've configured the block to show full url, without result
when i take a look at the google links , I can only see
www.google.com/search
the search parameters seems to be cut off.
I also have the protector module running , so i was thinking the protector modules prevents the stats module to display links with GET parameters.
i would like to see this :http://www.google.be/search?hl=nl&q=dasdan.be&btnG=Zoeken&meta=
How can i solve this problem.
By the way, the stats module on my site is not public
using : xoop-stats 0.45
when i take a look at the google links , I can only see
www.google.com/search
the search parameters seems to be cut off.
I also have the protector module running , so i was thinking the protector modules prevents the stats module to display links with GET parameters.
i would like to see this :http://www.google.be/search?hl=nl&q=dasdan.be&btnG=Zoeken&meta=
How can i solve this problem.
By the way, the stats module on my site is not public
using : xoop-stats 0.45
15
Quote:
why don't you switch on the SQL Debug mode instead of php debug?
does your insert query work when you execute him ie from your PHPmyadmin cp?
and you should use () after the xoopsDB-methods
$xoopsDB->error(), $xoopsDB->errno(),
https://xoops.org/misc/api/kernel/database/XoopsMySQLDatabase.html#sec-methods
Hope this helps
I turn the PHP debug mode in preferences
why don't you switch on the SQL Debug mode instead of php debug?
does your insert query work when you execute him ie from your PHPmyadmin cp?
and you should use () after the xoopsDB-methods
$xoopsDB->error(), $xoopsDB->errno(),
$result = $xoopsDB->query($sql);
if (!$result){
$error = array('msg' => $xoopsDB->error(), 'data' => $sql, 'errno' => $xoopsDB->errno());
return $error;
}else{
return $result;
}
https://xoops.org/misc/api/kernel/database/XoopsMySQLDatabase.html#sec-methods
Hope this helps
16
Quote:
they need to login , with their old email and old pass.
you are mixing two problems
logging in with only the email would be stupid don't you think?
So or they change email, or they have forgotten their password , not both of them
this hack would allow users to login using their old email address, change it to their new email address and then use the Forgot Password link?
they need to login , with their old email and old pass.
you are mixing two problems
logging in with only the email would be stupid don't you think?
So or they change email, or they have forgotten their password , not both of them
17
a little storm in my brain 
thought 1: I was thinking you could use the hacked version of the gijoe auto-login hack
This will enable the users to login with their old email en pass (but this doesn't solve your pass problem
)
https://xoops.org/modules/newbb/viewtopic.php?viewmode=flat&topic_id=29338&forum=14
http://xoops.biz/dist/my_autologin_for_xoops-2.0.9.x.zip
thought 2: how do other sites do it ... big companies like hotmail use mostly a secret question field in the registration form..."What's the name of your pet" (of course this does not solve your problem for the old users)
thought 3: extend the user.php file, allowing the user to fill up the old email, username, new email adress, and other info entered when initially registered, IE location, age, ... You should use this information to match the profile,
-problem1: the registration process of XOOPS is a two pass process, and filling up the additional userinfo is not mandatory, there are some documents explaining how to achieve this behaviour)
-problem2: still a big security risk, the additional info (birthday, location, ...) is sometimes easy to find on other sites ...
conclusion: users should not forget their password and use the hacked autologin hack, or should not change email addresses like changing underwear
thought 1: I was thinking you could use the hacked version of the gijoe auto-login hack
This will enable the users to login with their old email en pass (but this doesn't solve your pass problem
)https://xoops.org/modules/newbb/viewtopic.php?viewmode=flat&topic_id=29338&forum=14
http://xoops.biz/dist/my_autologin_for_xoops-2.0.9.x.zip
thought 2: how do other sites do it ... big companies like hotmail use mostly a secret question field in the registration form..."What's the name of your pet" (of course this does not solve your problem for the old users)
thought 3: extend the user.php file, allowing the user to fill up the old email, username, new email adress, and other info entered when initially registered, IE location, age, ... You should use this information to match the profile,
-problem1: the registration process of XOOPS is a two pass process, and filling up the additional userinfo is not mandatory, there are some documents explaining how to achieve this behaviour)
-problem2: still a big security risk, the additional info (birthday, location, ...) is sometimes easy to find on other sites ...
conclusion: users should not forget their password and use the hacked autologin hack, or should not change email addresses like changing underwear
18
ok, mayby I underestimated your problem 
but i would recomend building in , some filtering , only normal users should be able to use that way to change their email. (not admins)
but i would recomend building in , some filtering , only normal users should be able to use that way to change their email. (not admins)
19
Quote:
this problem sound familiar to me,
my cheapest solution is to press ctrl+c before sumitting a post/comment
but ...
I think you should choose,
or you use realy long sessions, (this causes problems with online-users, and stats modules, they will not show you an up-to-date state)
or you use cookies (they are invented for that purpose)
Not all of us feel like cookie-ing or are in appropriate situations to
this problem sound familiar to me,
my cheapest solution is to press ctrl+c before sumitting a post/comment
but ...
I think you should choose,
or you use realy long sessions, (this causes problems with online-users, and stats modules, they will not show you an up-to-date state)
or you use cookies (they are invented for that purpose)
20
Quote:
I think this is a real big security hole you will open in your site. E-mail addresses are easy to find out. IP adresses change continue.
the user will have to register again, or contact the administrator to delete the account(will delete messages???) or change the pass and email by hand, but how do you now the user is not just someone else, who wants to get access to the personal messages of the original user?
... look up their username and old email address and then change the email address. This would then send out a verification email that the user would need to click a link in to verify.
I think this is a real big security hole you will open in your site. E-mail addresses are easy to find out. IP adresses change continue.
the user will have to register again, or contact the administrator to delete the account(will delete messages???) or change the pass and email by hand, but how do you now the user is not just someone else, who wants to get access to the personal messages of the original user?
Login
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $100.00 |
| Due Date: | May 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $100.00 |
 |
|