Need help Modifying Reviews to handle Interviews instead :: Zikula Community

Start [1]
Search [2]
latest posts [3]
RSS [4]
Login [5]
Register [6]

[10]
Print topic [11]
[12]

Start [13] ::
PostNuke 0.7 Support [14] ::
Core Modules & Blocks [15] ::
Need help Modifying Reviews to handle Interviews instead

Moderated by:
Support [16]

[17]

Need help Modifying Reviews to handle Interviews instead

[18]Posted: 03.06.2004, 13:13

[19]

rank:

Freshman

registered:

February 2004

Status:

offline

last visit:

22.11.04

Posts:

15

ive finished moding the admin.php and the language files

everything works great till i try to run it from the index.

Fatal error: Call to a member function on a non-object in modules/Interviews/index.php on line 503
which correpsonds to something around here i believe

Code
$column = &$pntable['interviews_column'];
$popquery = buildSimpleQuery('interviews', array [20] ('id', 'title', 'hits'), $querylang, "$column[hits] DESC", 10);
$result_pop = $dbconn->Execute($popquery);
$x = 0;
while (!$result_pop->EOF) {
list [21]($id, $title, $hits) = $result_pop->fields;
$ida[$x] = $id;
$titlea[$x] = $title;
$hitsa[$x] = $hits;
$x++;
$result_pop->MoveNext();
}

also when i try to view interviews posted under a or b etc i get this

Error accesing to the database
Program: [webroot]/modules/Interviews/index.php - Line N.: 631
Database: ******
Error (1064) : You have an error in your SQL syntax near ' , , , FROM WHERE UPPER() LIKE 'A%' ' at line 1

any thoughts?
[22]
- notify mod [23]
[25]Posted: 05.06.2004, 10:30

[26]

rank:

Freshman

registered:

February 2004

Status:

offline

last visit:

22.11.04

Posts:

15

Bueller?? :)

I think it may be an API issuse, does that give anyone any ideas?
[27]
- notify mod [28]
[30]Posted: 05.06.2004, 10:38

[31]

rank:

Legend

registered:

December 1969

Status:

offline

last visit:

01.12.08

Posts:

6533

There was a recent news item in the mods site about an interview module,
[32]
- notify mod [33]
[35]Posted: 05.06.2004, 13:02

[36]

rank:

Freshman

registered:

February 2004

Status:

offline

last visit:

22.11.04

Posts:

15

yeah i saw that but damnit if pnRender isnt a pain to get working. i installed in and init both it and xanthia but when i go to admin the interview module i get this error
Fatal error: Cannot instantiate non-existent class: pnrender in modules/dpInterviews/pnadmin.php on line 15

so rather than screw up my site even more i thought moding out a current module would be a bit safer.
[37]
- notify mod [38]
[40]Posted: 05.06.2004, 13:43

[41]

rank:

Freshman

registered:

February 2004

Status:

offline

last visit:

22.11.04

Posts:

15

i take that back, i cant init Xanthia it gives me a fatal error on the pninit.php file. tried downloading the one linked from the PostNuke modules page about the XTE release but it still wont work.
[42]
- notify mod [43]
[45]Posted: 29.09.2004, 06:43

[46]

rank:

Freshman

registered:

April 2004

Status:

offline

last visit:

05.10.04

Posts:

17

well im finally getting a chance to work this out.

the dpInterviews module was of no help. And any support for it is in Spanish that I could tell and made no sense to me. Installing 750 is not an option.

So Im back to modifying the Reviews Module. Everything works fine until I try to look up Interviews of a certain letter or send an Interview to the DB.

it says

Error accesing to the database
Program: [webroot]/modules/Interviews/index.php - Line N.: 690
Database: mainsite
Error (1064) : You have an error in your SQL syntax near ' nuke_interviews.pn_score FROM nuke_interviews WHERE nuke_inter' at line 1

now that SQL select statement is the exact same except i changed this part of the function
$reviewstable = $pntable['reviews'];
$column = &$pntable['reviews_column'];

to

$interviewstable = $pntable['interviews'];
$column = &$pntable['interviews_column'];

and pntables.php has all the right entries and the DB was created with the same SQL just replaced nuke_reviews with nuke_interviews

so it should work. but its not. any ideas at all?
[47]
- notify mod [48]
[50]Posted: 29.09.2004, 12:04

[51]

rank:

Freshman

registered:

April 2004

Status:

offline

last visit:

05.10.04

Posts:

17

to make things even more complicated i reset this part
$interviewstable = $pntable['interviews'];
$column = &$pntable['interviews_column'];

back to

$reviewstable = $pntable['reviews'];
$column = &$pntable['reviews_column'];

and it worked fine but instead of loading the interviews it ofcourse loaded the reviews.

why the hell does changing that listing effect the syntax so that it wont connect properly? im using $interviewstable in the SQL select statement and it doesnt work. and it wont send data to the DB either. when i try to add an interview it says it went through but it never shows up in the DB.
[52]
- notify mod [53]
[55]Posted: 30.09.2004, 23:58

[56]

rank:

Freshman

registered:

April 2004

Status:

offline

last visit:

05.10.04

Posts:

17

this is what was added to pntables.php

Code
$interviews = $prefix . '_interviews';
$pntable['interviews'] = $interviews;
$pntable['interviews_column'] = array [57] ('id' => $interviews . '.pn_id',
'date' => $interviews . '.pn_date',
'title' => $interviews . '.pn_title',
'text' => $interviews . '.pn_text',
'reviewer' => $interviews . '.pn_reviewer',
'email' => $interviews . '.pn_email',
'score' => $interviews . '.pn_score',
'cover' => $interviews . '.pn_cover',
'url' => $interviews . '.pn_url',
'url_title' => $interviews . '.pn_url_title',
'hits' => $interviews . '.pn_hits',
'rlanguage' => $interviews . '.pn_language',
'language' => $interviews . '.pn_language');

$interviews_add = $prefix . '_interviews_add';
$pntable['interviews_add'] = $interviews_add;
$pntable['interviews_add_column'] = array [58] ('id' => $interviews_add . '.pn_id',
'date' => $interviews_add . '.pn_date',
'title' => $interviews_add . '.pn_title',
'text' => $interviews_add . '.pn_text',
'reviewer' => $interviews_add . '.pn_reviewer',
'email' => $interviews_add . '.pn_email',
'score' => $interviews_add . '.pn_score',
'url' => $interviews_add . '.pn_url',
'url_title' => $interviews_add . '.pn_url_title',
'rlanguage' => $interviews_add . '.pn_language',
'language' => $interviews_add . '.pn_language');

$interviews_comments = $prefix . '_interviews_comments';
$pntable['interviews_comments'] = $interviews_comments;
$pntable['interviews_comments_column'] = array [59] ('cid' => $interviews_comments . '.pn_cid',
'rid' => $interviews_comments . '.pn_rid',
'userid' => $interviews_comments . '.pn_userid',
'date' => $interviews_comments . '.pn_date',
'comments' => $interviews_comments . '.pn_comments',
'score' => $interviews_comments . '.pn_score');

$interviews_main = $prefix . '_interviews_main';
$pntable['interviews_main'] = $interviews_main;
$pntable['interviews_main_column'] = array [60] ('title' => $interviews_main . '.pn_title',
'description' => $interviews_main . '.pn_description');

this is the function causing problems currently

Code
function interviews()
{
list [61]($letter,
$field,
$order) = pnVarCleanFromInput('letter',
'field',
'order');

switch($order) {
case "DESC": break;
case "ASC": break;
default: $order=""; break;
};

list [62]($dbconn) = pnDBGetConn();
$pntable = pnDBGetTables();

$interviews = $pntable['interviews'];
$column = &$pntable['interviews_column'];

$currentlang = pnUserGetLang();

include ('header.php');
if (pnConfigGetVar('multilingual') == 1) {
$querylang = "AND ($column[language] ='$currentlang' OR $column[language] = '')";
} else {
$querylang = "";
}
$sitename = pnVarPrepForDisplay(pnConfigGetVar('sitename'));

OpenTable();
echo [63] "<center>$sitename "._INTERVIEWS." ";
if ($letter == _ALL) {
$query = "SELECT $column[id], $column[title], $column[hits], $column[interviewer], $column[score]
FROM $interviews WHERE $column[id] != '' $querylang ";
} else {
echo [64] ""._INTERVIEWSLETTER." \"".pnVarPrepForDisplay($letter)."\" ";
$query = "SELECT $column[id], $column[title], $column[hits], $column[interviewer], $column[score]
FROM $interviews
WHERE UPPER($column[title]) LIKE '".pnVarPrepForStore($letter)."%'
$querylang ";
}

switch($field) {

case "interviewer":
$query .= " ORDER by pn_interviewer $order";
break;

case "score":
$query .= " ORDER by pn_score $order";
break;

case "hits":
$query .= " ORDER by pn_hits $order";
break;

default:
$query .= " ORDER by pn_title $order";
break;
}

$result = $dbconn->Execute($query);
if ($result === false) {
error_log [65]("Error: " . $dbconn->ErrorNo() . ": " . $dbconn->ErrorMsg());
PN_DBMsgError($dbconn, __file__, __line__, "Error accesing to the database");
}
if ($result->EOF) {
echo [66] ''._NOINTERVIEWS.' \''.$letter.'\' ';
} else {
echo [67] "<TABLE BORDER=\"0\" width=\"100%\" CELLPADDING=\"2\" CELLSPACING=\"4\">
<tr>
<td width=\"50%\" bgcolor=\"$GLOBALS[bgcolor4]\">
<a class=\"pn-normal\" href=\"modules.php?op=modload&name=$GLOBALS[ModName]&file=index&req=$letter&field=title&order=ASC\"><img src=\"modules/$GLOBALS[ModName]/images/up.gif\" border=\"0\" width=\"15\" height=\"9\" Alt=\""._SORTASC."\"></a> "._PRODUCTTITLE." <a class=\"pn-normal\" href=\"modules.php?op=modload&name=$GLOBALS[ModName]&file=index&req=$letter&field=title&order=DESC\"><img src=\"modules/$GLOBALS[ModName]/images/down.gif\" border=\"0\" width=\"15\" height=\"9\" Alt=\""._SORTDESC."\"></a>
</td>
<td width=\"18%\" bgcolor=\"$GLOBALS[bgcolor4]\">
<a class=\"pn-normal\" href=\"modules.php?op=modload&name=$GLOBALS[ModName]&file=index&req=$letter&field=interviewer&order=ASC\"><img src=\"modules/$GLOBALS[ModName]/images/up.gif\" border=\"0\" width=\"15\" height=\"9\" Alt=\""._SORTASC."\"></a> "._INTERVIEWER." <a class=\"pn-normal\" href=\"modules.php?op=modload&name=$GLOBALS[ModName]&file=index&req=$letter&field=interviewer&order=desc\"><img src=\"modules/$GLOBALS[ModName]/images/down.gif\" border=\"0\" width=\"15\" height=\"9\" Alt=\""._SORTDESC."\"></a>
</td>
</tr>";
$numshown=0;
while(!$result->EOF) {
$myrow = $result->GetRowAssoc(false);
$title = $myrow['pn_title'];
$id = $myrow['pn_id'];
$interviewer = $myrow['pn_interviewer'];
if(!empty [68] ($myrow['pn_email'])){
$email = $myrow['pn_email'];
} else {
$email='';
}
$score = $myrow['pn_score'];
$hits = $myrow['pn_hits'];

if (pnSecAuthAction(0, 'Interviews::', "$title::$id", ACCESS_READ)) {
echo [69] "<tr>
<td width=\"50%\" bgcolor=\"$GLOBALS[bgcolor4]\"><a class=\"pn-normal\" href=\"modules.php?op=modload&name=$GLOBALS[ModName]&file=index&req=showcontent&id=$id\">".pnVarPrepForDisplay($title)."</a></td>
<td width=\"18%\" bgcolor=\"$GLOBALS[bgcolor4]\">";
if ($interviewer != "")
echo [70] "<center>".pnVarPrepForDisplay($interviewer)."</center>";

echo [71] "</tr>";
$numshown++;
}
$result->MoveNext();
}
echo [72] "</TABLE>";
echo [73] " $numshown "._TOTALINTERVIEWS." ";
}
echo [74] "[ <a class=\"pn-normal\"href=\"modules.php?op=modload&name=$GLOBALS[ModName]&file=index\">"._RETURN2MAIN."</a> ]</center>";
/* memory flush */
$result->Close();
CloseTable();
include ("footer.php");
}

now when i tell it to load like this by changing just the tables back to reviews, it works fine. why does changing the table name break the SQL? the tables exist and work fine in nearly every other function. and if it is a syntax error like it says it is why does it work fine when its loading the reviews? how can a table name effect the syntax of a statement?

Code
$interviews = $pntable['reviews'];
$column = &$pntable['reviews_column'];

$currentlang = pnUserGetLang();

include ('header.php');
if (pnConfigGetVar('multilingual') == 1) {
$querylang = "AND ($column[language] ='$currentlang' OR $column[language] = '')";
} else {
$querylang = "";
}
$sitename = pnVarPrepForDisplay(pnConfigGetVar('sitename'));

OpenTable();
echo [75] "<center>$sitename "._INTERVIEWS." ";
if ($letter == _ALL) {
$query = "SELECT $column[id], $column[title], $column[hits], $column[reviewer], $column[score]
FROM $interviews WHERE $column[id] != '' $querylang ";
} else {
echo [76] ""._INTERVIEWSLETTER." \"".pnVarPrepForDisplay($letter)."\" ";
$query = "SELECT $column[id], $column[title], $column[hits], $column[reviewer], $column[score]
FROM $interviews
WHERE UPPER($column[title]) LIKE '".pnVarPrepForStore($letter)."%'
$querylang ";
}

switch($field) {

case "interviewer":
$query .= " ORDER by pn_reviewer $order";
break;
[77]
- notify mod [78]
[80]Posted: 02.10.2004, 15:02

[81]

rank:

Freshman

registered:

April 2004

Status:

offline

last visit:

05.10.04

Posts:

17

93 views since june and only one response :P someone has to know whats going on
[82]
- notify mod [83]
[85]Posted: 02.10.2004, 16:01

[86]

rank:

Freshman

registered:

April 2004

Status:

offline

last visit:

05.10.04

Posts:

17

ok, i fixed it and working perfectly.
[87]
- notify mod [88]

Users online:

AllKnightAccess [90],
AmmoDump [91],
Petzi-Juist [92],
Topiatic [93],
jaenosjelantru [94],
myths [95],
nestormateo [96]

This list is based on the users active over the last 60 minutes.

Code

Code

Code

Code