[phpshop commit] r54 - trunk/phpshop1/WEB-INF/modules/account/html

[codesite...@google.com]

Author: ulisoft
Date: Thu Oct 30 02:03:13 2008
New Revision: 54

Added:
trunk/phpshop1/WEB-INF/modules/account/html/topic_add.ihtml
trunk/phpshop1/WEB-INF/modules/account/html/topic_edit.ihtml
trunk/phpshop1/WEB-INF/modules/account/html/topic_list.ihtml
trunk/phpshop1/WEB-INF/modules/account/html/topic_print.ihtml
trunk/phpshop1/WEB-INF/modules/account/html/topic_reply.ihtml

Log:
see http://code.google.com/p/phpshop/wiki/phpShop1_update
Updating phpShop 0.81 - adding the forum module -

Added: trunk/phpshop1/WEB-INF/modules/account/html/topic_add.ihtml
==============================================================================
--- (empty file)
+++ trunk/phpshop1/WEB-INF/modules/account/html/topic_add.ihtml Thu Oct 30
02:03:13 2008
@@ -0,0 +1,75 @@
+<?php
+// if ($data["forum"]==1) {
+ if (!$tg) {
+ $tg=$vars["tg"];
+ }
+
+ if (!$tg) {
+
+ echo "<h4> $new_topic_title </h4><b>$group_str</b><br>";
+
+ $userid=$auth["user_id"];
+
+ if ($auth["topic_group_id"]) {
+ $topic_group_id=$auth["topic_group_id"];
+ }
+
+ else {
+ $topic_group_id=1000;
+ }
+
+ $utg=$topic_group_id + 1;
+
+ $q ="SELECT * FROM topic_groups ";
+ $q .="WHERE language='$lang' AND vendor_id='$ps_vendor_id'";
+
+ if ($auth["perms"] !=="admin" && $auth["perms"] !=="storeadmin") {
+ $q .="AND topic_group_id < '$utg'";
+ }
+
+ $db->query($q);
+
+ while ($db->next_record()) {
+ $tg=$db->f("topic_group_id");
+ $tn=$db->f("topic_group_name");
+
+ $url="<a class=bLink href=";
+ $url .=$sess->url(SECUREURL . "?page=$page&tg=$tg");
+ $url .=">$tn</a>";
+ echo $url;
+ echo "<br>";
+ }
+ }
+
+ else {
+ $q ="SELECT * FROM topic_groups ";
+ $q .="WHERE language='$lang' ";
+ $q .="AND topic_group_id ='$tg'";
+ $db->query($q);
+ $db->next_record();
+
+ $tn=$db->f("topic_group_name");
+
+ echo "<h3> $new_topic_title</h3> $group_str $tn</p>";
+ ?>
+ <FORM METHOD="post" ACTION="<?php $sess->purl(SECUREURL) ?>">
+ <?php $sess->hidden_session() ?>
+ <input type=HIDDEN name=page value="account/topic_print">
+ <input type=HIDDEN name=func value="topic_add">
+ <input type=HIDDEN name=tg value="<?php echo $tg ?>">
+ <?php echo $subject_lbl ?><br>
+ <TEXTAREA NAME="topic_subject" ROWS="2" COLS="120"></TEXTAREA><BR>
+ <?php echo $text_lbl ?><BR>
+ <TEXTAREA NAME="topic_content" ROWS="20" COLS="120"></TEXTAREA>
+ <BR>
+
+ <!--
+ <INPUT TYPE="hidden" name="all_lang" value="on">
+ -->
+
+ <INPUT TYPE="submit" NAME="send" VALUE="<?php echo $save_str ?>">
+ </FORM>
+ <?php
+ }
+// }
+?>

Added: trunk/phpshop1/WEB-INF/modules/account/html/topic_edit.ihtml
==============================================================================
--- (empty file)
+++ trunk/phpshop1/WEB-INF/modules/account/html/topic_edit.ihtml Thu Oct 30
02:03:13 2008
@@ -0,0 +1,52 @@
+<?php
+// if ($data["forum"]==1) {
+$user_id=$auth["user_id"];
+
+$q="SELECT * FROM topics WHERE topic_id ='$topic_id' AND language='$lang'";
+
+if ($auth["perms"] !=="admin") {
+ $q .=" AND user_id='$user_id'";
+}
+
+$db->query($q);
+
+if ($db->next_record()) {
+ $userid=$db->f("user_id");
+ $topic_subject=$db->f("topic_subject");
+ $topic_content=str_replace("<br>", "", $db->f("topic_content"));
+ $topic_content=str_replace("<br />", "", $topic_content);
+ ?>
+
+ <FORM METHOD="post" ACTION="<?php echo SECUREURL ?>">
+ <?php $sess->hidden_session(); ?>
+ <TABLE width="100%" ALIGN="LEFT">
+ <TR><TD>
+ <?php echo "$number_lbl &nbsp $topic_id" ?>
+ <br><br>
+
+ <B><?php echo $subject_lbl ?>: &nbsp <?php echo $topic_subject ?></B><br>
+ <?php echo $subject_lbl ?><br>
+ <TEXTAREA NAME="topic_subject" ROWS="1" COLS="120"><?php echo
$topic_subject ?></TEXTAREA>
+ <br><br>
+ <?php echo $text_lbl ?><BR>
+ <TEXTAREA NAME="topic_content" ROWS="20" COLS="120"><?php echo
$topic_content ?></TEXTAREA>
+ <BR>
+ <!--
+ <?php
+ echo $all_lang_str;
+ echo "<INPUT TYPE='checkbox' name='all_lang'>";
+ ?>
+ -->
+
+ <input type=HIDDEN name=topic_id value="<?php echo $topic_id ?>">
+ <input type=HIDDEN name=func value="topic_edit">
+ <input type=HIDDEN name=page value="account/topic_print">
+ <INPUT TYPE="submit" NAME="send" VALUE="<?php echo $save_str ?>">
+
+ </TD></TR>
+ </TABLE>
+ </FORM>
+ <?php
+}
+// }
+?>

Added: trunk/phpshop1/WEB-INF/modules/account/html/topic_list.ihtml
==============================================================================
--- (empty file)
+++ trunk/phpshop1/WEB-INF/modules/account/html/topic_list.ihtml Thu Oct 30
02:03:13 2008
@@ -0,0 +1,212 @@
+<?php
+// if ($data["forum"]==1) {
+$user_id=$auth["user_id"];
+
+if ($topic_return) {
+ echo $topic_return;
+}
+
+if ($auth["topic_group_id"]) {
+ $topic_group_id=$auth["topic_group_id"];
+}
+
+else {
+ $topic_group_id=1000;
+}
+
+$utg=$topic_group_id + 1;
+$timestamp=time();
+
+echo "<center>";
+echo "<H4> $topic_list_str</H4>";
+
+$navi_db = new ps_DB;
+
+if ($auth["perms"] == "admin" || $auth["perms"] == "storeadmin") {
+ $q = "SELECT * FROM topic_groups WHERE vendor_id='$ps_vendor_id' ";
+ $q .= "AND language='$lang' ";
+}
+
+else {
+ $q = "SELECT * FROM topic_groups WHERE topic_group_id <'$utg' ";
+ $q .= "AND language='$lang' AND vendor_id='$ps_vendor_id'";
+}
+
+$navi_db->query($q);
+
+while ($navi_db->next_record()) {
+
+ if (is_numeric($navi_db->f("topic_group_id"))) {
+ echo "<A class=\"bLink\" HREF=";
+ echo $sess->url(SECUREURL . "?page=account/topic_list&show=" .
$navi_db->f("topic_group_id"));
+ echo "><B>";
+ echo $navi_db->f("topic_group_name")."</B></A> | ";
+ }
+}
+
+$user_id=$auth["user_id"];
+
+$url = SECUREURL . "?page=account/topic_list&show=";
+echo "<A class=\"bLink\" HREF=";
+echo $sess->url(SECUREURL . "?page=account/topic_list&show=my_topics");
+echo "><B>";
+echo "$my_topics_str </B></A> | ";
+
+$url = SECUREURL . "?page=account/topic_list";
+echo "<A class=\"bLink\" HREF=".$sess->url($url)."><B> $show_all_lbl
</B></A><BR>";
+
+?>
+
+</center><BR>
+
+<?php
+if (empty($offset))
+ $offset=0;
+
+if ($keyword) {
+ $list = "SELECT topic_num, topic_id, topic_status, topics.mdate,
topic_subject, topic_content, topics.topic_group_id,forum_name ";
+ $list .= "FROM topics,auth_user_md5 WHERE ";
+ $count = "SELECT count(*) as num_rows FROM topics, auth_user_md5 WHERE ";
+ $q = "(topics.topic_subject LIKE '%$keyword%' ";
+ $q .= "OR topics.topic_content LIKE '%$keyword%' ";
+ $q .= "OR auth_user_md5.forum_name LIKE '%$keyword%' ";
+ $q .= ") ";
+ $q .= "AND topics.user_id=auth_user_md5.user_id ";
+ $q .= "AND topics.vendor_id='$ps_vendor_id' ";
+ $q .= "AND topics.topic_group_id < '$utg' ";
+ $q .= "AND topics.language = '$lang' ";
+
+ if ($show) {
+
+ if ($show=="my_topics") {
+ $q .= "AND topics.user_id = '$user_id' ";
+ }
+
+ else {
+ $q .= "AND topics.topic_group_id = '$show' ";
+ }
+ }
+
+ $q .= "ORDER BY mdate DESC";
+ $list .= $q . " LIMIT $offset, " . MAX_ROWS;
+ $count .= $q;
+}
+
+else {
+ $list = "SELECT topic_num, topic_id, topic_status, topic_subject,
topics.mdate,topics.topic_group_id,forum_name ";
+ $list .= "FROM topics,auth_user_md5 WHERE ";
+ $count = "SELECT count(*) as num_rows FROM topics, auth_user_md5 WHERE ";
+ $q = "topics.user_id=auth_user_md5.user_id ";
+ $q .= "AND topics.vendor_id='$ps_vendor_id' ";
+ $q .= "AND topics.topic_group_id < '$utg' ";
+ $q .= "AND topics.language = '$lang' ";
+
+ if ($show) {
+
+ if ($show=="my_topics") {
+ $q .= "AND topics.user_id = '$user_id' ";
+ }
+
+ else {
+ $q .= "AND topics.topic_group_id = '$show' ";
+ }
+ }
+
+ $q .= "ORDER BY mdate DESC";
+ $list .= $q . " LIMIT $offset, " . MAX_ROWS;
+ $count .= $q;
+}
+
+$db->query($count);
+$db->next_record();
+$num_rows = $db->f("num_rows");
+
+if ($num_rows == 0) {
+ echo "$notopics <BR>";
+}
+
+else {
+ $db->query($list);
+ $i = 0;
+ $ii=0;
+
+ while ($db->next_record()) {
+
+ if (is_numeric($db->f("topic_group_id"))) {
+ $ii++;
+
+ if ($ii==1) {
+ search_header($topic_list_lbl, $modulename, "topic_list");
+ ?>
+
+ <table width="100%" BORDER="1" cellspacing="0" cellpadding="0"
align="center">
+ <tr>
+ <td NOWRAP class="RecordsTableHeader"><?php echo $from_str ?></td>
+ <td NOWRAP class="RecordsTableHeader"><?php echo
$topic_list_cdate ?></td>
+ <td NOWRAP class="RecordsTableHeader"><?php echo
$subject_lbl ?></td>
+ <td NOWRAP class="RecordsTableHeader"><?php echo $group_str ?></td>
+ </tr>
+ <?php
+ }
+
+ if ($i++ % 2)
+ $bgcolor=SEARCH_COLOR_1;
+ else
+ $bgcolor=SEARCH_COLOR_2;
+ ?>
+
+ <tr BGCOLOR=<?php echo $bgcolor ?>>
+ <td>
+
+ <?php
+ echo $db->f("forum_name");
+ ?>
+
+ <td NOWRAP>
+ <?php
+ echo strftime("%d-%b-%y %H:%M", $db->f("mdate"));
+ ?>
+ </td>
+
+ <td NOWRAP>
+
+ <?php
+
+ $url = SECUREURL . "?page=account/topic_print&topic_id=";
+ $url .= $db->f("topic_id");
+ echo "<A class=\"bLink\" HREF=" . $sess->url($url) . ">";
+ echo $db->f("topic_subject");
+ echo "</A><BR>";
+ ?>
+ </td>
+
+ <td NOWRAP>
+
+ <?php
+
+ $q = "SELECT topic_group_name FROM topic_groups WHERE ";
+ $q .= "topic_group_id = '" . $db->f("topic_group_id") . "'";
+
+ $dbps = new ps_DB;
+ $dbps->query($q);
+ $dbps->next_record();
+ echo $dbps->f("topic_group_name");
+ echo "<BR>";
+ ?>
+ </td>
+
+ </tr>
+ <?php
+ }
+ }
+}
+
+if ($ii > 0) {
+ echo "</table>";
+}
+
+search_footer($modulename, "topic_list", $offset, $num_rows,
$keyword . "&show=$show");
+// }
+?>
+
+

Added: trunk/phpshop1/WEB-INF/modules/account/html/topic_print.ihtml
==============================================================================
--- (empty file)
+++ trunk/phpshop1/WEB-INF/modules/account/html/topic_print.ihtml Thu Oct
30 02:03:13 2008
@@ -0,0 +1,217 @@
+<?php
+// if ($data["forum"]==1) {
+$db = new ps_DB;
+$user_id=$auth["user_id"];
+
+$q = "SELECT * FROM auth_user_md5 WHERE user_id = '$user_id'";
+$db->query($q);
+$db->next_record();
+$utg=$db->f("topic_group_id") + 1;
+
+$q = "SELECT * FROM topics WHERE topic_id='$topic_id' AND language='$lang'
AND topic_group_id < '$utg' AND vendor_id='$ps_vendor_id'";
+$db->query($q);
+
+if ($db->next_record()) {
+ $topic_user_id=$db->f("user_id");
+ $topic_status=$db->f("topic_status");
+ $topic_view=$db->f("topic_view") + 1;
+ $mdate=$db->f("mdate");
+ $topic_subject=$db->f("topic_subject");
+ $topic_content=$db->f("topic_content");
+ $topic_group_id=$db->f("topic_group_id");
+
+ $q = "SELECT * FROM topic_groups WHERE ";
+ $q .= "topic_group_id='$topic_group_id' ";
+ $q .= "AND language='$lang'";
+ $db->query($q);
+ $db->next_record();
+ $topic_group_name=$db->f("topic_group_name");
+
+ $q = "UPDATE topics SET ";
+ $q .= "topic_view= '$topic_view'";
+ $q .= " WHERE topic_id='$topic_id' AND language='$lang'";
+ $db->query($q);
+ $db->next_record();
+
+ echo "<form method=post name=subscr_form action=" . SECUREURL . ">";
+ $sess->hidden_session();
+ ?>
+ <TABLE WIDTH=100% ALIGN=CENTER BORDER=0 CELLSPACING=0 CELLPADDING=0>
+ <TR VALIGN=TOP BGCOLOR=<?php echo $leftbar_title_bgcolor?>>
+ <TD ALIGN=RIGHT>
+ <a class=bLink href=<?php
$sess->purl(SECUREURL . "?page=$modulename/topic_add");?>>
+ <?php echo $new_topic_title ?></a>
+ &nbsp &nbsp
+ <a class=bLink href=<?php
$sess->purl(SECUREURL . "?page=account/topic_reply&topic_id=$topic_id");?>>
+ <?php echo $reply_str ?></a>
+ &nbsp &nbsp
+
+ <?php
+ if ($auth["user_id"]==$topic_user_id) {
+ ?>
+ &nbsp &nbsp
+ <a class=bLink href=<?php
$sess->purl(SECUREURL . "?page=account/topic_edit&topic_id=$topic_id");?>>
+ <?php
+ echo "$ban_edit </a>";
+ ?>
+ &nbsp &nbsp <a class=bLink href=<?php
$sess->purl(SECUREURL . "?func=topic_delete&topic_id=$topic_id&topic_group_id=$topic_group_id&all_lang=on&page=account/topic_list");?>>
+ <?php
+ echo "$del_str </a>";
+ }
+
+
+ $q="SELECT * FROM topic_subscribe WHERE user_id='$user_id' AND
vendor_id='$ps_vendor_id' AND topic_id='$topic_id' AND language='$lang'";
+ $db->query($q);
+
+ if ($db->next_record()) {
+ $topic_subscribe="on";
+ }
+
+ echo "&nbsp &nbsp";
+ echo "<select name=topic_subscribe
onchange='document.subscr_form.submit();'>";
+
+ if ($topic_subscribe=="on") {
+ echo "<option value selected=on>$subscribed_str</option>";
+ echo "<option value=off>$unsubscribed_str</option>";
+ }
+
+ else {
+ echo "<option value selected=off>$unsubscribed_str</option>";
+ echo "<option value=on>$subscribed_str</option>";
+ }
+ echo "</select>";
+ echo "<input type=hidden name=func value=topic_subscribe>";
+ echo "<input type=hidden name=page value=account/topic_print>";
+ echo "<input type=hidden name=topic_id value=$topic_id>";
+ echo "<noscript>";
+ echo "<input type=submit value=$ftp_print_mnu>";
+ echo "</noscript>";
+ ?>
+
+ </TD>
+ </TR>
+ </TABLE>
+ </form>
+
+ <table width="100%" BORDER="1" cellspacing="0" cellpadding="2"
align="center" class="RecordsTable">
+ <TR BGCOLOR=#FFcc00>
+
+ <TD colspan=2><B><?php echo $info_lbl ?></B></TD>
+ </TR>
+ <TR>
+ <TD width="50%"><?php echo $group_str ?></TD>
+ <TD width="50%">
+ <a class=bLink href="<?php
$sess->purl(SECUREURL . "?page=account/topic_list&show=$topic_group_id") ?>"><?php
echo $topic_group_name ?>
+ </TD>
+ </TR>
+
+ <TR>
+ <TD><?php echo $topic_list_id ?></TD>
+ <TD><?php echo $topic_id ?></TD>
+ </TR>
+
+ <TR>
+ <TD><?php echo $date_lbl ?></TD>
+ <TD><?php echo date("d-M-Y H:i", $mdate); ?></TD>
+ </TR>
+
+ <TR>
+ <TD><?php echo $ftp_list_status ?></TD>
+ <TD>
+ <?php
+ $q = "SELECT topic_status_name FROM topic_status WHERE ";
+ $q .= "topic_status_id = '$topic_status' AND language='$lang' ";
+ $dbos = new ps_DB;
+ $dbos->query($q);
+ $dbos->next_record();
+ echo $dbos->f("topic_status_name");
+ ?>
+
+ </TD>
+ </TR>
+
+ <TR>
+ <TD><?php echo $from_str ?></TD>
+
+ <TD><?php
+ $q = "SELECT user_id FROM topics WHERE ";
+ $q .= "topic_id = '$topic_id' AND language='$lang' ";
+ $dbos = new ps_DB;
+ $dbos->query($q);
+ $dbos->next_record();
+ $uid=$dbos->f("user_id");
+
+ $q = "SELECT * FROM auth_user_md5 WHERE user_id = '$uid'";
+ $dbos = new ps_DB;
+ $dbos->query($q);
+ $dbos->next_record();
+ $un=$dbos->f("forum_name");
+ echo $un;
+ ?>
+
+ </TD>
+ </TR>
+
+ <TR>
+ <TD><?php echo $clicks_lbl ?></TD>
+ <TD><?php echo $topic_view ?></TD>
+ </TR>
+
+ <TR BGCOLOR=#FFcc00 VALIGN=top>
+ <TD colspan=2 width=100%><B><?php echo $topic_lbl ?></B></TD>
+ </TR>
+
+ <TR>
+ <TD COLSPAN=2><B><?php echo $subject_lbl ?></B>:&nbsp
+ <?php echo $topic_subject ?></TD>
+ </TR>
+
+ <TR>
+ <TD colspan=2>
+ <?php
+ $topic_content=str_replace(" ","&nbsp;",$topic_content);
+ $topic_content=str_replace("&lt;a&nbsp;href","<a href",$topic_content);
+ $topic_content=str_replace("&lt;/a&gt;","</a>",$topic_content);
+ $topic_content=str_replace("&gt;",">",$topic_content);
+ echo $topic_content;
+ ?>
+ <br>
+ </TD>
+ </TR>
+
+ <?php
+ $db = new ps_DB;
+ $q = "SELECT * FROM topic_reply WHERE ";
+ $q .= "topic_id = '$topic_id' AND language='$lang' ";
+ $db->query($q);
+
+ $i=0;
+ while ($db->next_record()) {
+ $i++;
+
+ if ($i==1) {
+ echo "<tr><td colspan=2>";
+ echo "<B>$reply_list_mnu</B><BR>";
+ }
+
+ $rs=$db->f("reply_subject");
+ $reply_id=$db->f("reply_id");
+ $url = SECUREURL . "?page=$modulename/reply_print&reply_id=";
+ $url .= $reply_id;
+ echo "<A class=\"bLink\" HREF=".$sess->url($url).">$rs</A><BR>";
+ }
+
+ if ($i > 0) {
+ echo "</td></tr>";
+ }
+ ?>
+ </table>
+ <?php
+}
+
+else {
+ echo $perm_err_str_1;
+ include("account/html/topic_list.ihtml");
+}
+// }
+?>

Added: trunk/phpshop1/WEB-INF/modules/account/html/topic_reply.ihtml
==============================================================================
--- (empty file)
+++ trunk/phpshop1/WEB-INF/modules/account/html/topic_reply.ihtml Thu Oct
30 02:03:13 2008
@@ -0,0 +1,52 @@
+<?php
+// if ($data["forum"]==1) {
+$user_id=$auth["user_id"];
+$utg=$auth["topic_group_id"] + 1;
+
+
+$q="SELECT * FROM topics WHERE topic_id ='$topic_id' AND
language='$lang' ";
+$q .="AND topic_group_id < '$utg'";
+$db->query($q);
+
+if ($db->next_record()) {
+ $userid=$db->f("user_id");
+ $reply_subject=$db->f("topic_subject");
+ $topic_group_id=$db->f("topic_group_id");
+
+ $q = "SELECT * FROM topic_groups WHERE ";
+ $q .= "topic_group_id='$topic_group_id' ";
+ $q .= "AND language='$lang'";
+
+ $db->query($q);
+ $db->next_record();
+
+ $topic_group_name=$db->f("topic_group_name");
+ ?>
+
+ <FORM METHOD="post" ACTION="<?php $sess->purl(SECUREURL) ?>">
+ <TABLE width="100%" ALIGN="LEFT">
+ <TR><TD>
+ <?php $sess->hidden_session() ?>
+ <input type=HIDDEN name=tg value="<?php echo $topic_group_id ?>">
+ <input type=HIDDEN name=topic_id value="<?php echo $topic_id ?>">
+ <input type=HIDDEN name=func value="topic_reply">
+ <input type=HIDDEN name=page value="account/topic_print">
+
+ <B><?php echo $subject_lbl ?>: &nbsp <?php echo $reply_subject ?></B>
&nbsp Group: <?php echo $topic_group_name ?><br><br>
+ <TEXTAREA NAME="reply_subject" ROWS="2" COLS="120"></TEXTAREA><br><br>
+ <?php echo $text_lbl ?><BR>
+ <TEXTAREA NAME="reply_content" ROWS="20" COLS="120"></TEXTAREA>
+ <BR>
+
+ <!--
+ <INPUT TYPE="hidden" name="all_lang" value="on">
+ -->
+
+ <INPUT TYPE="submit" NAME="send" VALUE=" <?php echo $save_str ?>">
+ </TD></TR>
+ </TABLE>
+ </FORM>
+ <?php
+}
+// }
+?>