advanced poll 2.03 problem...

yelbuke — GMT

hi all,
i have a question, and i must say that i dont know php.
i have a CMS on my site. and i installed Advanced Poll in the same database. i didnt create a new database for the Advanced Poll.
As you know advanced poll can log the voter's IP. But i want advanced poll to log the user_name of the user. So a user can vote only for once. But i have trouble, because dont know coding php.
i modified class_poll.php and changed the meaning of $this->ip, as below:
$this->ip="a try";
This was succeed, "a try" is written in the database.
I think to log the user_names, i need to declare my CMS's user information as global. Can you show me the way, or can you give me some suggestions?

Thanks a lot,

Auron — GMT

Doesn't your CMS have a builtin poll system?

And no I have no idea how to do it, what CMS are you using?

yelbuke — GMT

i use php-fusion. there is a poll system in the CMS but it isnt as i want.
www.php-fusion.co.uk

Auron — GMT

You could add some stuff to the poll files to add the user' username to the poll db. It wouldn't be that bad really. I would just need to get the username into a variable that I can then use to pass to the poll script which then writes it to the db. Maybe I can work on it next week when i'm back home for you.

Auron

yelbuke — GMT

if you can help, i would be glad. because i dont know php, i couldnt manage to solve the problem.
Is it necessary to paste some code here from the CMS, so you can see the usage of the user data in CMS? Or do you prefer to get the CMS code from php-fusions.co.uk?

thanks

Auron — GMT

Could you post some code?

Like the code from the page that includes the poll?
I need the page with all the PHP code not the outputted HTML code.

yelbuke — GMT

ok, i'm pasting panel_editor.php. You can add small panels to the web page, and you can use php code in these panels. I created a panel, and in the panel i used the poll code. here is the panel_editor.php (I'm pasting it. And if you want i can mail it to you)
[code]
/*--------------------------------------------+
| PHP-Fusion 5 - Content Management System |
|---------------------------------------------|
| author: Nick Jones (Digitanium) © 2002-2005 |
| web: http://www.php-fusion.co.uk |
| email: nick@php-fusion.co.uk |
|---------------------------------------------|
| Released under the terms and conditions of |
| the GNU General Public License (Version 2) |
+--------------------------------------------*/
@require_once "../fusion_config.php";
require_once "../fusion_core.php";
require_once FUSION_BASE."subheader.php";
include FUSION_LANGUAGES.FUSION_LAN."admin/admin_panels.php";
include FUSION_ADMIN."navigation.php";

if (!checkrights("F")) { header("Location:../index.php"); exit; }

$handle = opendir(FUSION_INFUSIONS);
while ($folder = readdir($handle)) {
if (!in_array($folder, array(".", "..", "index.php")) && strstr($folder, "_panel")) {
if (file_exists(FUSION_INFUSIONS.$folder."/infusion.php")) {
@include FUSION_INFUSIONS.$folder."/infusion.php";
if (dbrows(dbquery("SELECT inf_name FROM ".$fusion_prefix."infusions WHERE inf_name='$inf_name' AND inf_installed='1'"))!=0) {
$panel_list[] = $folder;
}
} else {
$panel_list[] = $folder;
}
}
}
closedir($handle);
sort($panel_list);
array_unshift($panel_list, "none");

if (isset($_POST['save'])) {
$panel_name = stripinput($panel_name);
if ($panel_name == "") $error['0'] = LAN_470."
";
if ($panel_filename == "none") {
$panel_filename = "";
$panel_content = addslashes($panel_content);
$panel_type = "php";
} else {
$panel_type = "file";
$panel_content = "";
}
$panel_access = $_POST['panel_access'];
if (isset($panel_id)) {
if ($panel_name != "") {
$data = dbarray(dbquery("SELECT * FROM ".$fusion_prefix."panels WHERE panel_id='$panel_id'"));
if ($panel_name != $data['panel_name']) {
$result = dbquery("SELECT * FROM ".$fusion_prefix."panels WHERE panel_name='$panel_name'");
if (dbrows($result) != 0) $error['1'] = LAN_471."
";
}
}
if ($panel_type == "php" && $panel_content == "") $error['2'] = LAN_472."
";
if (!isset($error)) {
$result = dbquery("UPDATE ".$fusion_prefix."panels SET panel_name='$panel_name', panel_filename='$panel_filename', panel_content='$panel_content', panel_access='$panel_access' WHERE panel_id='$panel_id'");
}
opentable(LAN_480);
echo "
\n";
if (isset($error)) {
echo LAN_481."

\n".$error['0'].$error['1'].$error['2']."
\n";
} else {
echo LAN_482."

\n";
}
echo "".LAN_486."

".LAN_487."

\n";
closetable();
} else {
if ($panel_name != "") {
$data = dbarray(dbquery("SELECT * FROM ".$fusion_prefix."panels WHERE panel_id='$panel_id'"));
if ($panel_name != $data['panel_name']) {
$result = dbquery("SELECT * FROM ".$fusion_prefix."panels WHERE panel_name='$panel_name'");
if (dbrows($result) != 0) $error['1'] = LAN_471."
";
}
}
if ($panel_type == "php" && $panel_content == "") $error['2'] = LAN_472."
";
if ($panel_type == "file" && $panel_filename == "none") $error['3'] = LAN_473."
";
if ($error == "") {
$result = dbquery("SELECT * FROM ".$fusion_prefix."panels WHERE panel_side='$panel_side' ORDER BY panel_order DESC LIMIT 1");
if (dbrows($result) != 0) { $data = dbarray($result); $neworder = $data['panel_order'] + 1; } else { $neworder = 1; }
$result = dbquery("INSERT INTO ".$fusion_prefix."panels VALUES('', '$panel_name', '$panel_filename', '$panel_content', '$panel_side', '$neworder', '$panel_type', '$panel_access', '0')");
}
opentable(LAN_483);
echo "
\n";
if ($error != "") {
echo LAN_484."

".$error['0'].$error['1'].$error['2']."
\n";
} else {
echo LAN_485."

\n";
}
echo "".LAN_486."

".LAN_487."

\n";
closetable();
}
} else {
if (isset($_POST['preview'])) {
$panel_name = stripinput($_POST['panel_name']);
$panel_filename = $_POST['panel_filename'];
$panel_access = $_POST['panel_access'];
$panel_side = $_POST['panel_side'];
if (ini_get('magic_quotes_gpc')) $panel_content = stripslashes($panel_content);
opentable($panel_name);
if ($panel_filename != "none") {
@include FUSION_INFUSIONS.$panel_filename."/".$panel_filename.".php";
$panel_type = "file";
} else {
eval($panel_content);
$panel_type = "php";
}
$panel_content = stripinput(addslashes($panel_content));
closetable();
tablebreak();
}
if (isset($step) && $step == "edit") {
$result = dbquery("SELECT * FROM ".$fusion_prefix."panels WHERE panel_id='$panel_id'");
if (dbrows($result) != 0) {
$data = dbarray($result);
$panel_name = $data['panel_name'];
$panel_filename = $data['panel_filename'];
$panel_content = stripinput($data['panel_content']);
$panel_type = $data['panel_type'];
$panel_access = $data['panel_access'];
$panel_side = $data['panel_side'];
}
}
if (isset($panel_id)) {
$action = $PHP_SELF."?panel_id=$panel_id";
opentable(LAN_450);
} else {
if (!isset($_POST['preview'])) {
$panel_name = "";
$panel_filename = "";
$panel_content = "openside(\"name\");\n"." echo \"content\";\n"."closeside();";
$panel_type = "";
$panel_access = "";
$panel_side = "";
}
$action = $PHP_SELF;
opentable(LAN_451);
}
$user_groups = getusergroups(); $access_opts = "";
while(list($key, $user_group) = each($user_groups)){
$sel = ($panel_access == $user_group['0'] ? " selected" : "");
$access_opts .= "\n";
}
echo "\n";
closetable();
echo "\n";
}

echo "\n";
require_once FUSION_BASE."footer.php";
?>
[/code]
And inow i'm pasting the important file news.php
[code]
/*--------------------------------------------+
| PHP-Fusion 5 - Content Management System |
|---------------------------------------------|
| author: Nick Jones (Digitanium) © 2002-2005 |
| web: http://www.php-fusion.co.uk |
| email: nick@php-fusion.co.uk |
|---------------------------------------------|
| Released under the terms and conditions of |
| the GNU General Public License (Version 2) |
+--------------------------------------------*/
@require_once "fusion_config.php";
require_once "fusion_core.php";
require_once "subheader.php";
require_once "side_left.php";

if (!isset($readmore)) {
$rows = dbcount("(news_id)", "news", "(news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")");
if (!isset($rowstart)) $rowstart = 0;
if ($rows != 0) {
$i = 1;
$result = dbquery(
"SELECT tn.*, user_id, user_name FROM ".$fusion_prefix."news tn
LEFT JOIN ".$fusion_prefix."users tu ON tn.news_name=tu.user_id
WHERE (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")
ORDER BY news_datestamp DESC LIMIT $rowstart,10"
);
$numrows = dbrows($result);
while ($data = dbarray($result)) {
$news_subject = "".stripslashes($data['news_subject']);
$news_news = stripslashes($data['news_news']);
if ($data['news_breaks'] == "y") $news_news = nl2br($news_news);
$news_info = array(
"news_id" => $data['news_id'],
"user_id" => $data['user_id'],
"user_name" => $data['user_name'],
"news_date" => $data['news_datestamp'],
"news_ext" => $data['news_extended'] ? "y" : "n",
"news_reads" => $data['news_reads'],
"news_comments" => dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id='".$data['news_id']."'")
);
render_news($news_subject, $news_news, $news_info);
if ($i != $numrows) { tablebreak(); } $i++;
}
echo "

\n".makePageNav($rowstart,10,$rows,3)."\n

\n";
} else {
opentable(LAN_46);
echo "
\n".LAN_47."

\n\n";
closetable();
}
} else {
if (!isNum($readmore)) { header("Location:".$PHP_SELF); exit; }
include FUSION_INCLUDES."comments_include.php";
include FUSION_INCLUDES."ratings_include.php";
$result = dbquery(
"SELECT tn.*, user_id, user_name FROM ".$fusion_prefix."news tn
LEFT JOIN ".$fusion_prefix."users tu ON tn.news_name=tu.user_id
WHERE news_id='$readmore'"
);
if (dbrows($result)!=0) {
$data = dbarray($result);
$news_subject = $data['news_subject'];
$news_news = stripslashes($data['news_extended'] ? $data['news_extended'] : $data['news_news']);
if ($data['news_breaks'] == "y") { $news_news = nl2br($news_news); }
$news_info = array(
"news_id" => $data['news_id'],
"user_id" => $data['user_id'],
"user_name" => $data['user_name'],
"news_date" => $data['news_datestamp'],
"news_ext" => "n",
"news_reads" => $data['news_reads'],
"news_comments" => dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id='".$data['news_id']."'")
);
render_news($news_subject, $news_news, $news_info);
showcomments("N","news","news_id",$readmore,"$PHP_SELF?readmore=$readmore");
showratings("N",$readmore,"$PHP_SELF?readmore=$readmore");
if (!isset($_POST['post_comment']) && !isset($_POST['post_rating'])) {
$result2 = dbquery("UPDATE ".$fusion_prefix."news SET news_reads=news_reads+1 WHERE news_id='$readmore'");
}
} else {
header("Location:".$PHP_SELF);
}
}

require_once "side_right.php";
require_once "footer.php";
?>
[/code]

I hope they help you to help me to solve this problem.

Thanks a lot...

Auron — GMT

K...

So that page is the page you use in the admin area to create the panel right?

So, all the panel stuff must be stored somewhere.
I'll download it and have a look, I have a feeling it keeps it in the db.
I found some references to the username though.

What is the page called that actually contains the poll?

Anonymous — GMT

You can reach the CMS in my page at www.mud.gen.tr
At the left of the page, you can see the Advanced Poll.
thanks

Anonymous — GMT

i really dont know which page contains it. but when you add a panel, panel_editor.php assists you.

thanks

".LAN_452."
".LAN_453."	".LAN_454."
".LAN_453."	".LAN_454."
".LAN_455."	$panel_content
".LAN_455."	$panel_content
".LAN_456."
".LAN_457."
\n"; if (isset($panel_id)) { if ($panel_type == "php") echo "\n"; echo "\n"; } echo "

Latest posts for the topic "advanced poll 2.03 problem..."

advanced poll 2.03 problem...