Messages posted by: yelbuke

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)

<?
/*--------------------------------------------+
| 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."<br>";
	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."<br>";
			}
		}
		if ($panel_type == "php" && $panel_content == "") $error['2'] = LAN_472."<br>";
		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 "<center><br>\n";
		if (isset($error)) {
			echo LAN_481."<br><br>\n".$error['0'].$error['1'].$error['2']."<br>\n";
		} else {
			echo LAN_482."<br><br>\n";
		}
		echo "<a href='panels.php'>".LAN_486."</a><br><br>
<a href='index.php'>".LAN_487."</a><br><br>
</center>\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."<br>";
			}
		}
		if ($panel_type == "php" && $panel_content == "") $error['2'] = LAN_472."<br>";
		if ($panel_type == "file" && $panel_filename == "none") $error['3'] = LAN_473."<br>";
		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 "<center><br>\n";
		if ($error != "") {
			echo LAN_484."<br><br>
".$error['0'].$error['1'].$error['2']."<br>\n";
		} else {
			echo LAN_485."<br><br>\n";
		}
		echo "<a href='panels.php'>".LAN_486."</a><br><br>
<a href='index.php'>".LAN_487."</a><br><br>
</center>\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 .= "<option value='".$user_group['0']."'$sel>".$user_group['1']."</option>\n";
	}
	echo "<form name='editform' method='post' action='$action'>
<table align='center' cellspacing='0' cellpadding='0' class='tbl'>
<tr>
<td>".LAN_452."</td>
<td><input type='text' name='panel_name' value='$panel_name' class='textbox' style='width:200px;'></td>
</tr>\n";
	if (isset($panel_id)) {
		if ($panel_type == "file") {
			echo "<tr>
<td>".LAN_453."</td>
<td><select name='panel_filename' class='textbox' style='width:200px;'>\n";
			for ($i=0;$panel_list[$i]!="";$i++) {
				echo "<option".($panel_filename == $panel_list[$i] ? " selected" : "").">$panel_list[$i]</option>\n";
			}
			echo "</select>&nbsp;&nbsp;<span class='small2'>".LAN_454."</span></td>\n</tr>\n";
		}
	} else {
		echo "<tr>
<td>".LAN_453."</td>
<td><select name='panel_filename' class='textbox' style='width:200px;'>\n";
		for ($i=0;$panel_list[$i]!="";$i++) {
			echo "<option".($panel_filename == $panel_list[$i] ? " selected" : "").">$panel_list[$i]</option>\n";
		}
		echo "</select>&nbsp;&nbsp;<span class='small2'>".LAN_454."</span></td>\n</tr>\n";
	}
	if (isset($panel_id)) {
		if ($panel_type == "php") {
			echo "<tr>
<td valign='top'>".LAN_455."</td>
<td><textarea name='panel_content' cols='95' rows='15' class='textbox' onselect='updatePos(this);' onkeyup='updatePos(this);' onclick='updatePos(this);' ondblclick='updatePos(this);'>$panel_content</textarea></td>
</tr>\n";
		}
	} else {
		echo "<tr>
<td valign='top'>".LAN_455."</td>
<td><textarea name='panel_content' cols='95' rows='15' class='textbox' onselect='updatePos(this);' onkeyup='updatePos(this);' onclick='updatePos(this);' ondblclick='updatePos(this);'>$panel_content</textarea></td>
</tr>\n";
	}
	if (!isset($panel_id)) {
		echo "<tr>
<td>".LAN_456."</td>
<td><select name='panel_side' class='textbox' style='width:150px;'>
<option value='1'".($panel_side == "1" ? " selected" : "").">".LAN_420."</option>
<option value='2'".($panel_side == "2" ? " selected" : "").">".LAN_421."</option>
<option value='3'".($panel_side == "3" ? " selected" : "").">".LAN_422."</option>
</select></td>
</tr>\n";
	}
echo "<tr>
<td>".LAN_457."</td>
<td><select name='panel_access' class='textbox' style='width:150px;'>
$access_opts</select></td>
</tr>
<tr>
<td align='center' colspan='2'><br>\n";
	if (isset($panel_id)) {
		if ($panel_type == "php") echo "<input type='hidden' name='panel_filename' value='none'>\n";
		echo "<input type='hidden' name='panel_side' value='$panel_side'>\n";
	}
	echo "<input type='submit' name='preview' value='".LAN_458."' class='button'>
<input type='submit' name='save' value='".LAN_459."' class='button'></td>
</tr>
</table>
</form>\n";
	closetable();
	echo "<script language='JavaScript'>
var editBody = document.editform.panel_content;
function insertText(theText) {
	if (editBody.createTextRange && editBody.curPos) {
		editBody.curPos.text = theText;
	} else {
		editBody.value += theText;
	}
editBody.focus();
}
function AddText(wrap,unwrap) {
	if (editBody.curPos) {
		insertText(wrap + editBody.curPos.text + unwrap);
	} else {
		insertText(wrap + unwrap);
	}
}
function updatePos(obj) {
	if (obj.createTextRange) {
		obj.curPos = document.selection.createRange().duplicate();
	}
}
</script>\n";
}

echo "</td>\n";
require_once FUSION_BASE."footer.php";
?>

And inow i'm pasting the important file news.php

<?
/*--------------------------------------------+
| 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 = "<a name='".$data['news_id']."'></a>".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 "<div align='center' style='margin-top:5px;'>\n".makePageNav($rowstart,10,$rows,3)."\n</div>\n";
	} else {
		opentable(LAN_46);
		echo "<center><br>\n".LAN_47."<br><br>\n</center>\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";
?>

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

Thanks a lot...

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

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

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,