31
tjnemez
Re: Amazon, Hot or Not, phpNuke and Xoops
  • 2003/12/26 20:05

  • tjnemez

  • Home away from home

  • Posts: 1594

  • Since: 2003/9/21


cool, i will try it out again. as for the nusoap.php, which file has to be downloaded fromhttp://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/nusoap/lib/

by the way, thanks for link to quizz

cheers,
www.mindhealth.ca

32
Parody
Re: Amazon, Hot or Not, phpNuke and Xoops
  • 2003/12/26 20:07

  • Parody

  • Just popping in

  • Posts: 17

  • Since: 2003/12/25


No file has to be downloaded. Nusoap is already included in the Zip file.

33
BradM
Re: Amazon, Hot or Not, phpNuke and Xoops
  • 2003/12/26 20:33

  • BradM

  • Just popping in

  • Posts: 78

  • Since: 2003/8/14


As for the prefix issue, I believe all you have to do is edit your mysql.sql file, and remove the "xoops_" part from the two tables that are created (at least, that's what I did, and it worked). I believe that XOOPS automatically adds "xoops_" to the table names.

I too am coming up with a blank admin page... I don't know much about module coding, but I'm willing to help out as much as I can. I've been looking for an Amazon-type module for a while now!


Brad

34
Parody
Re: Amazon, Hot or Not, phpNuke and Xoops
  • 2003/12/26 20:40

  • Parody

  • Just popping in

  • Posts: 17

  • Since: 2003/12/25


Yeah, I know XOOPS adds it, but how do I, in the code itself, get the default prefix?

For example, if the users default prefix is cms_ instead of xoops_, then how do you, when you need to withdraw something from the database, know what to query?

here is an example query from my code:

$query = "SELECT * FROM xoops_books_items WHERE valid='1' ORDER BY RAND() LIMIT 1";

It wont work if the default prefix isnt xoops...how do I change it so it gets the default prefix?

35
BradM
Re: Amazon, Hot or Not, phpNuke and Xoops
  • 2003/12/26 20:51

  • BradM

  • Just popping in

  • Posts: 78

  • Since: 2003/8/14


Regarding the blank admin section, I made this modification to admin_header.php, which has fixed it:

Change:
$xoopsModule = XoopsModule::getByDirname("photovote");

To:
$xoopsModule = XoopsModule::getByDirname("books");

As for the default prefix, I checked out a couple other modules, and the standard format seems to be this:

$query = $xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix("books_items")." valid='1' ORDER BY RAND() LIMIT 1"));

The above might need tweaking, as I mentioned, I'm not too familiar with sql... also, you might have to grab the globals, like:

global $xoopsConfig, $xoopsDB, $xoopsUser;


Brad

36
BradM
Re: Amazon, Hot or Not, phpNuke and Xoops
  • 2003/12/26 21:00

  • BradM

  • Just popping in

  • Posts: 78

  • Since: 2003/8/14


One other thing, I wasn't able to get the script to display details about a 'recommended' book (one which I added via the admin/search). I added the following code to the module's index.php file, which helped:
if (isset($HTTP_POST_VARS)) {
    foreach (
$HTTP_POST_VARS as $k => $v) {
        ${
$k} = $v;
    }
}
if (isset(
$HTTP_GET_VARS['bid'])) {
    
$bid $HTTP_GET_VARS['bid'];
}



Brad

37
CBlue
Re: Amazon, Hot or Not, phpNuke and Xoops

Thanks Brad and Parody! I'll try reinstalling with all the fixes listed.

38
tjnemez
Re: Amazon, Hot or Not, phpNuke and Xoops
  • 2003/12/27 4:14

  • tjnemez

  • Home away from home

  • Posts: 1594

  • Since: 2003/9/21


hey cblue,

i reinstalled and have not had time to fully test, but check out the review submit. i get a blank page on that one.

39
CBlue
Re: Amazon, Hot or Not, phpNuke and Xoops

I haven't had time to check it out myself yet, tjnemez. Hopefully I will have the time to tomorrow to do it. I'll let you know if I experience the same problem or not.

40
Parody
Re: Amazon, Hot or Not, phpNuke and Xoops
  • 2003/12/28 5:02

  • Parody

  • Just popping in

  • Posts: 17

  • Since: 2003/12/25


Try finding these lines in comment.php:

$page "comment.php";
$page append_sid($page);


and replacing it with:

$page "comment.php";


it's around line 52.

You're going to have to do a lot of editing to this file, i just realized, because I have this file intregrated with the phpbb forum that I have installed on my website.

Login

Who's Online

282 user(s) are online (166 user(s) are browsing Support Forums)


Members: 0


Guests: 282


more...

Donat-O-Meter

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

Latest GitHub Commits