Problems
scriptor |
|
---|---|
Is there any ne User control panel Plugin vor Cotonti?
I load the old from Neocrome and it works for the half! I can set buddys bookmarks and so, but when i want to go at the plugin side with plug.php?e=options i see that Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /mnt/web5/40/71/52039171/htdocs/system/database.mysql.php on line 209 Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /mnt/web5/40/71/52039171/htdocs/system/database.mysql.php on line 97 Freak-Forum 2009-02-28 18:48 Fatal error : SQL error : [url=http://www.freak-forum.de]Freak-Forum.de[/url] - The Freakstyle Community<br />
[url=http://www.adelmann-solutions.com]adelmann-solutions, webdesign Freiburg[/url] |
esclkm |
|
---|---|
upload plug here please - I will see what the trouble
littledev.ru - мой маленький зарождающийся блог о котонти.
снижение стоимости программирования и снижение стоимости производства разные вещи. Первое можно скорее сравнить с раздачей работникам дешевых инструментов, чем со снижением зарплаты |
littledude |
|
---|---|
It has not been tested for Cotonti and I have no time to convert it. However, Lombi and the gang have on the list to do something better than this plug that I put together.
|
scriptor |
|
---|---|
littledude youre so nice...
here is the Options.php. i think the error must be in it... <?PHP
/* ====================
Seditio - Website engine
Copyright Neocrome
http://www.neocrome.net
[BEGIN_SED]
File=plugins/options/options.php
Version=103
Updated=20-june-2006
Type=Plugin
Author=Community Work
Description=This plugin gives your site a control panel with the ability for users to pick the content they want
[END_SED]
[BEGIN_SED_EXTPLUGIN]
Code=options
Part=main
File=options
Hooks=standalone
Tags=
Minlevel=0
Order=10
[END_SED_EXTPLUGIN]
==================== */
if (!defined('SED_CODE')) { sed_diefatal('Hacking attempt.'); }
if ($usr['id']>0)
{
$query = "SELECT cp_userid FROM ".$cfg['plugin']['options']['dbprefix']."_controlpanel LEFT JOIN ".$cfg['plugin']['options']['dbprefix']."_users ON ".$cfg['plugin']['options']['dbprefix']."_controlpanel.cp_userid=".$cfg['plugin']['options']['dbprefix']."_users.user_id WHERE user_id='".$usr['id']."'";
$sql = sed_sql_query($query);
$new = sed_sql_numrows($sql);
if ($new==0)
{
$sql = sed_sql_query("INSERT INTO ".$cfg['plugin']['options']['dbprefix']."_controlpanel (cp_userid) VALUES ('".$usr['id']."')");
$sql = sed_sql_query("UPDATE ".$cfg['plugin']['options']['dbprefix']."_controlpanel SET box1=0, box2=0, box3=0, box4=0, box5=0, box6=0, box7=0, box8=0, box9=0, box10=0, box11=0, box12=0 WHERE cp_userid='".$usr['id']."'");
}
if ($a=='settings' && $id=$usr['id'])
{
$box1 = sed_import('box1','P','INT');
$box2 = sed_import('box2','P','INT');
$box3 = sed_import('box3','P','INT');
$box4 = sed_import('box4','P','INT');
$box5 = sed_import('box5','P','INT');
$box6 = sed_import('box6','P','INT');
$box7 = sed_import('box7','P','INT');
$box8 = sed_import('box8','P','INT');
$box9 = sed_import('box9','P','INT');
$box10 = sed_import('box10','P','INT');
$box11 = sed_import('box11','P','INT');
$box12 = sed_import('box12','P','INT');
$sql = sed_sql_query("UPDATE ".$cfg['plugin']['options']['dbprefix']."_controlpanel SET box1='$box1', box2='$box2', box3='$box3', box4='$box4', box5='$box5', box6='$box6', box7='$box7', box8='$box8', box9='$box9', box10='$box10', box11='$box11', box12='$box12' WHERE cp_userid='".$usr['id']."'");
header("Location: plug.php?e=options");
exit;
}
}
$a = sed_import('a','G','ALP');
$id = sed_import('id','G','INT');
$userid = sed_import('userid','P','INT');
$u = sed_import('u','G','INT');
if ($u>0)
{ $userid = $u; }
if ($a=='add' && $userid!='' && $userid!=$usr['id'])
{
$sql = sed_sql_query("SELECT * FROM ".$cfg['plugin']['options']['dbprefix']."_buddies WHERE buddies_ownerid='".$usr['id']."' AND buddies_buddyid='$userid'", "Plugin/buddies");
if (sed_sql_numrows($sql)==0)
{
$sql = sed_sql_query("SELECT * FROM ".$cfg['plugin']['options']['dbprefix']."_users WHERE user_id='$userid' LIMIT 1", "Plugin/buddies");
$row = sed_sql_fetcharray($sql);
$buddyname = stripslashes($row["user_name"]);
$sql = sed_sql_query("INSERT into ".$cfg['plugin']['options']['dbprefix']."_buddies (buddies_ownerid, buddies_buddyid, buddies_buddyname) values ('".$usr['id']."', '$userid', '$buddyname')", "Plugin/buddies");
header("Location: plug.php?e=options");
exit;
}
}
$buddyid = sed_import('buddyid','G','INT');
if ($a=='addme' && $buddyid!='' && $buddyid!=$usr['id'])
{
$sql = sed_sql_query("SELECT * FROM ".$cfg['plugin']['options']['dbprefix']."_buddies WHERE buddies_ownerid='".$usr['id']."' AND buddies_buddyid='$buddyid'", "Plugin/buddies");
if (sed_sql_numrows($sql)==0)
{
$sql = sed_sql_query("SELECT * FROM ".$cfg['plugin']['options']['dbprefix']."_users WHERE user_id='$buddyid' LIMIT 1", "Plugin/buddies");
$row = sed_sql_fetcharray($sql);
$buddyname = stripslashes($row["user_name"]);
$sql = sed_sql_query("INSERT into ".$cfg['plugin']['options']['dbprefix']."_buddies (buddies_ownerid, buddies_buddyid, buddies_buddyname) values ('".$usr['id']."', '$buddyid', '$buddyname')", "Plugin/buddies");
header("Location: plug.php?e=options");
exit;
}
}
elseif ($a=='delete' && $id!='')
{
$sql = sed_sql_query("DELETE FROM ".$cfg['plugin']['options']['dbprefix']."_buddies WHERE buddies_ownerid='".$usr['id']."' AND buddies_buddyid='$id'", "Plugin/buddies");
header("Location: plug.php?e=options");
exit;
}
$query = "SELECT * FROM ".$cfg['plugin']['options']['dbprefix']."_buddies LEFT JOIN ".$cfg['plugin']['options']['dbprefix']."_users ON ".$cfg['plugin']['options']['dbprefix']."_buddies.buddies_buddyid=".$cfg['plugin']['options']['dbprefix']."_users.user_id LEFT JOIN
".$cfg['plugin']['options']['dbprefix']."_online ON ".$cfg['plugin']['options']['dbprefix']."_online.online_userid=".$cfg['plugin']['options']['dbprefix']."_buddies.buddies_buddyid WHERE buddies_ownerid = '".$usr['id']."' ORDER BY
online_name DESC, buddies_buddyname ASC";
$sql = sed_sql_query($query, "Plugin/buddies");
$numbuddies = sed_sql_numrows($sql);
$buddies_online = 0;
if ($numbuddies==0)
{
$buddies .= "<b>".$L['buddiesfriendheader']."</b><br /><br />".$L['nofriends']."";
}
else
{
$buddies .= "<b>".$L['currentfriends']."</b><br />";
while ($row = sed_sql_fetcharray($sql))
{
if($row['online_id'])$buddies_online++;
$buddies .= "<br /><img src=\"skins/".$skin."/img/online".($row['online_id']?"1":"0").".gif\">";
$buddies .= " ".sed_build_pm($row["buddies_buddyid"]);
$buddies .= " ".sed_build_user($row["buddies_buddyid"], stripslashes($row["buddies_buddyname"]));
$buddies .= " [<a href=\"plug.php?e=options&a=delete&id=".$row["buddies_buddyid"]."\">x</a>]";
}
}
$buddies .= "<br /><br /><b>".$L['addbuddy'].":</b><br /><br /><form action=\"plug.php?e=options&a=add\" method=\"post\" name=\"addbuddy\">";
$buddies .= sed_selectbox_users($suserid);
$buddies .= " <input type=\"submit\" class=\"submit\" value=\"".$L['Addb']."\" /></form>";
/* To-Do-List plugin */
$r = sed_import('r','G','ALP');
$g = array ('a');
foreach($g as $x) $$x = $HTTP_GET_VARS[$x];
if ($a=="addlist")
{
sed_shield_protect();
$g = array ('nnotebook_id','nnotebook_userid', 'nnotebook_message');
foreach($g as $x) $$x = $HTTP_POST_VARS[$x];
$sql = sed_sql_query("INSERT INTO ".$cfg['plugin']['options']['dbprefix']."_notebook (notebook_id, notebook_userid, notebook_message) VALUES ('$nnotebook_id', '".$usr['id']."', '$nnotebook_message') ");
header("Location: plug.php?e=options");
}
if ($a=="deletelist")
{
$sql = sed_sql_query("DELETE FROM ".$cfg['plugin']['options']['dbprefix']."_notebook WHERE notebook_userid = '".$usr['id']."' AND notebook_id = '$id' ");
header("Location: plug.php?e=options");
}
if ($a=="updatelist")
{
$sql = sed_sql_query("DELETE FROM ".$cfg['plugin']['options']['dbprefix']."_notebook WHERE notebook_userid = '".$usr['id']."' AND notebook_id = '$id' ");
$g = array ('nnotebook_id','nnotebook_userid', 'nnotebook_message');
foreach($g as $x) $$x = $HTTP_POST_VARS[$x];
$sql = sed_sql_query("INSERT INTO ".$cfg['plugin']['options']['dbprefix']."_notebook (notebook_id, notebook_userid, notebook_message) VALUES ('$nnotebook_id', '".$usr['id']."', '$nnotebook_message') ");
header("Location: plug.php?e=options");
}
$notes .= "<p> ".$L['currenttodo']." <ul>";
$query= sed_sql_query("SELECT * FROM ".$cfg['plugin']['options']['dbprefix']."_notebook WHERE notebook_userid = '".$usr['id']."' ORDER by notebook_id DESC");
$notenum = sed_sql_numrows($query);
if ($notenum==0)
{
$notes .="".$L['nonotes']."";
}
while ($sql = sed_sql_fetcharray($query))
{
$notes .= "<li>" .sed_parse(sed_cc($sql['notebook_message']));
$notes .= " <a href=plug.php?e=options&a=deletelist&id=".$sql['notebook_id'];
$notes .= ">[".$L['xdelete']."]</a> ";
$notes .= " <a href=plug.php?e=options&r=updatelist&id=".$sql['notebook_id'];
$notes .= ">[".$L['edit']."]</a></li>";
}
$notes .= "</ul>";
$query = sed_sql_query("SELECT notebook_message FROM ".$cfg['plugin']['options']['dbprefix']."_notebook WHERE notebook_userid = '".$usr['id']."' AND notebook_id = '$id'");
$sql = sed_sql_fetcharray($query);
if ($r=="updatelist")
{
$notes .= "<p>".$L['updatetodo']."";
$notes .= "<form name=\"addentry\" action=\"plug.php?e=options&a=updatelist&id=$id\" method=\"post\">";
$notes .= "<br /><textarea name=\"nnotebook_message\" rows=\"2\" cols=\"30\">".$sql['notebook_message'];
$notes .= "</textarea><br />" .sed_build_bbcodes("addentry","nnotebook_message",$L['BBcodes']);
$notes .= " ".$cfg['separator']." <a href=\"plug.php?e=options\">Add New Note</a><br /><br /><input type=\"submit\" value=\"".$L['updatetodo']."\"></form></p>";
}
else
{
$notes .= "<p>".$L['addtodo']."";
$notes .= "<form name=\"addentry\" action=\"plug.php?e=options&a=addlist\" method=\"post\">";
$notes .= "<br /><textarea name=\"nnotebook_message\" rows=\"2\" cols=\"30\"></textarea>";
$notes .= "<br />" .sed_build_bbcodes("addentry","nnotebook_message",$L['BBcodes']);
$notes .= "<br /><br /><input type=\"submit\" value=\"".$L['addtodo']."\"></form></p>";
}
// Newest User
$sqlnewuser = sed_sql_query("SELECT user_name,user_id FROM $db_users ORDER by user_regdate DESC LIMIT 1");
$myrow = sed_sql_fetcharray($sqlnewuser);
$newest_user = "<a href=\"users.php?m=details&id=".$myrow["user_id"]."\">". $myrow["user_name"]."</a>";
//Displays The Avatar
$avatar = sed_sql_query("SELECT user_avatar FROM $db_users WHERE user_id='".$usr['id']."'");
$avatar = sed_sql_fetcharray($avatar);
$avatardisplay = stripslashes($avatar["user_avatar"]);
//Displays The User Photo
$photo = sed_sql_query("SELECT user_photo FROM $db_users WHERE user_id='".$usr['id']."'");
$photo = sed_sql_fetcharray($photo);
$photodisplay = stripslashes($photo["user_photo"]);
// Configures User Picture To Show Nothing if no picture is selected in profile
if ($photodisplay == "")
{
$userphoto = "";
}
else
{
$userphoto = "<br /><br /><b>".$L['currentpic']."</b>:<br /><img src=\"$photodisplay\">";
}
/* ============ MASKS FOR THE HTML OUTPUTS =========== */
$cfg['plu_mask_pages'] = "%1\$s"." ".$cfg['separator']." "."%2\$s"." (%3\$s)<br />";
// %1\$s = Link to the category
// %2\$s = Link to the page
// %3\$s = Date
$cfg['plu_mask_events'] = "%1\$s"." ".$cfg['separator']." "."%2\$s"." (%3\$s)<br />";
// %1\$s = Link to the category
// %2\$s = Link to the page
// %3\$s = Date
$cfg['plu_mask_topics'] = "%1\$s"." "."%2\$s"." "."%3\$s"." ".$cfg['separator']." "."%4\$s"." ("."%5\$s".")<br />";
// %1\$s = "Follow" image
// %2\$s = Date
// %3\$s = Section
// %4\$s = Topic title
// %5\$s = Number of replies
$plu_empty = $L['None']."<br />";
/* ================== FUNCTIONS ================== */
function sed_get_latestpages($limit, $mask)
{
global $L, $db_pages, $usr, $cfg, $sed_cat, $plu_empty;
$sql = sed_sql_query("SELECT page_id, page_alias, page_cat, page_title, page_date FROM $db_pages WHERE page_state=0 AND page_cat NOT LIKE 'system' AND page_cat NOT LIKE 'events' ORDER by page_date DESC LIMIT $limit");
while ($row = sed_sql_fetcharray($sql))
{
if (sed_auth('page', $row['page_cat'], 'R'))
{
$row['page_pageurl'] = (empty($row['page_alias'])) ? "page.php?id=".$row['page_id'] : "page.php?al=".$row['page_alias'];
$res .= sprintf($mask,
"<a href=\"list.php?c=".$row['page_cat']."\">".$sed_cat[$row['page_cat']]['title']."</a>",
"<a href=\"".$row['page_pageurl']."\">".sed_cc(sed_cutstring(stripslashes($row['page_title']), 36))."</a>",
date($cfg['formatyearmonthday'], $row['page_date'] + $usr['timezone'] * 3600)
);
}
}
$res = (empty($res)) ? $plu_empty : $res;
return($res);
}
/* ------------------ */
function sed_get_latestevents($limit, $mask)
{
global $L, $db_pages, $usr, $cfg, $sed_cat, $plu_empty;
$sql = sed_sql_query("SELECT page_id, page_alias, page_cat, page_title, page_date FROM $db_pages WHERE page_state=0 AND page_cat LIKE 'events' ORDER by page_date DESC LIMIT $limit");
while ($row = sed_sql_fetcharray($sql))
{
if (sed_auth('page', $row['page_cat'], 'R'))
{
$row['page_pageurl'] = (empty($row['page_alias'])) ? "page.php?id=".$row['page_id'] : "page.php?al=".$row['page_alias'];
$res .= sprintf($mask,
"<a href=\"list.php?c=".$row['page_cat']."\">".$sed_cat[$row['page_cat']]['title']."</a>",
"<a href=\"".$row['page_pageurl']."\">".sed_cc(sed_cutstring(stripslashes($row['page_title']), 36))."</a>",
date($cfg['formatyearmonthday'], $row['page_date'] + $usr['timezone'] * 3600)
);
}
}
$res = (empty($res)) ? $plu_empty : $res;
return($res);
}
/* ------------------ */
function sed_get_latesttopics($limit, $mask)
{
global $L, $db_forum_topics, $db_forum_sections, $usr, $cfg, $skin, $plu_empty;
$sql = sed_sql_query("SELECT t.ft_id, t.ft_sectionid, t.ft_title, t.ft_updated, t.ft_postcount, s.fs_id, s.fs_title, s.fs_category
FROM $db_forum_topics t,$db_forum_sections s
WHERE t.ft_sectionid=s.fs_id
AND t.ft_movedto=0 AND t.ft_mode=0
ORDER by t.ft_updated DESC LIMIT $limit");
while ($row = sed_sql_fetcharray($sql))
{
if (sed_auth('forums', $row['fs_id'], 'R'))
{
$img = ($usr['id']>0 && $row['ft_updated']>$usr['lastvisit']) ? "<a href=\"forums.php?m=posts&q=".$row['ft_id']."&n=unread#unread\"><img src=\"skins/$skin/img/system/arrow-unread.gif\" alt=\"\" /></a>" : "<a href=\"forums.php?m=posts&q=".$row['ft_id']."&n=last#bottom\"><img src=\"skins/$skin/img/system/arrow-follow.gif\" alt=\"\" /></a> ";
$res .= sprintf($mask,
$img,
date($cfg['formatmonthdayhourmin'], $row['ft_updated'] + $usr['timezone'] * 3600),
sed_build_forums($row['fs_id'], sed_cutstring($row['fs_title'],24), sed_cutstring($row['fs_category'],16)),
"<a href=\"forums.php?m=posts&q=".$row['ft_id']."&n=last#bottom\">".sed_cc(sed_cutstring(stripslashes($row['ft_title']),25))."</a>",
$row['ft_postcount']-1
);
}
}
$res = (empty($res)) ? $plu_empty : $res;
return($res);
}
/* ------------------ */
function sed_get_latestpolls()
{
global $L, $db_polls, $db_polls_voters, $db_polls_options, $usr, $plu_empty;
$sql = sed_sql_query("SELECT poll_id, poll_text FROM $db_polls WHERE 1 AND poll_state=0 AND poll_type=0 ORDER by poll_creationdate DESC LIMIT 1");
if ($row = sed_sql_fetcharray($sql))
{
$poll_id = $row['poll_id'];
if ($usr['id']>0)
{ $sql2 = sed_sql_query("SELECT pv_id FROM $db_polls_voters WHERE pv_pollid='$poll_id' AND (pv_userid='".$usr['id']."' OR pv_userip='".$usr['ip']."') LIMIT 1"); }
else
{ $sql2 = sed_sql_query("SELECT pv_id FROM $db_polls_voters WHERE pv_pollid='$poll_id' AND pv_userip='".$usr['ip']."' LIMIT 1"); }
if (sed_sql_numrows($sql2)>0)
{
$alreadyvoted =1;
$sql2 = sed_sql_query("SELECT SUM(po_count) FROM $db_polls_options WHERE po_pollid='$poll_id'");
$totalvotes = sed_sql_result($sql2,0,"SUM(po_count)");
}
else
{ $alreadyvoted =0; }
$res .= stripslashes($row['poll_text'])."<p>";
$sql = sed_sql_query("SELECT po_id, po_text, po_count FROM $db_polls_options WHERE po_pollid='$poll_id' ORDER by po_id ASC");
while ($row = sed_sql_fetcharray($sql))
{
if ($alreadyvoted)
{
$percentbar = floor(($row['po_count'] / $totalvotes) * 100);
$res .= $row['po_text']." : $percentbar%<div style=\"width:95%;\"><div class=\"bar_back\"><div class=\"bar_front\" style=\"width:".$percentbar."%;\"></div></div></div>";
}
else
{
$res .= "<a href=\"javascript:pollvote('".$poll_id."','".$row['po_id']."')\">";
$res .= stripslashes($row['po_text'])."</a><br />";
}
}
$res .= "</p><p style=\"text-align:center;\"><a href=\"javascript:polls('".$poll_id."')\">".$L['polls_viewresults']."</a> ";
$res .= "<a href=\"javascript:polls('viewall')\">".$L['polls_viewarchives']."</a></p>";
}
else
{ $res = $plu_empty; }
return($res);
}
/* ============= */
$latestpages = sed_get_latestpages(3, $cfg['plu_mask_pages']);
$latestevents = sed_get_latestevents(3, $cfg['plu_mask_events']);
$latesttopics = sed_get_latesttopics(3, $cfg['plu_mask_topics']);
$latestpoll = sed_get_latestpolls();
// Pm System
// Counts new private messages from user
$newpm = sed_sql_query("SELECT COUNT(*) FROM $db_pm WHERE pm_touserid='".$usr['id']."' AND pm_state=0");
$newpmmessages = mysql_result($newpm,0,"COUNT(*)");
// Counts sent private messages from user
$sentpm = sed_sql_query("SELECT COUNT(*) FROM $db_pm WHERE pm_fromuserid='".$usr['id']."' AND pm_state=0");
$sentpmmessages = mysql_result($sentpm,0,"COUNT(*)");
// Count old private messages from user
$oldpm = sed_sql_query("SELECT COUNT(*) FROM $db_pm WHERE pm_touserid='".$usr['id']."' AND pm_state=1");
$oldpmmessages = mysql_result($oldpm,0,"COUNT(*)");
// Counts archived private messages from user
$archivedpm = sed_sql_query("SELECT COUNT(*) FROM $db_pm WHERE pm_touserid='".$usr['id']."' AND pm_state=2");
$archivedmessages = mysql_result($archivedpm,0,"COUNT(*)");
$sql = sed_sql_query("SELECT * FROM $db_pm WHERE pm_touserid='".$usr['id']."' AND pm_state=0 ORDER BY pm_date DESC LIMIT
3");
if (mysql_result($newpm,0,"COUNT(*)")>0)
{
$pmsystem = "".$L['youhave']."" .mysql_result($newpm,0,"COUNT(*)");
$pmsystem .= " ".$L['unreadmsg']." ";
}
if (mysql_result($newpm,0,"COUNT(*)")==0)
{
$pmsystem .= "".$L['nomsgs']."";
}
else
if (mysql_result($newpm,0,"COUNT(*)")==1)
{
$pmsystem .= "".$L['msgbelow1']."<br /><br />";
}
else if (mysql_result($newpm,0,"COUNT(*)")<3)
{
$pmsystem .= "".$L['msgbelow2']."<br /><br />";
}
else if (mysql_result($newpm,0,"COUNT(*)")>3)
{
$pmsystem .= "".$L['msgbelow3']."<br /><br />";
}
while ($row = sed_sql_fetcharray($sql))
{
$pmsystem .= "<b>".$L['pmfrom']."</b> <a href=users.php?m=details&id=".sed_cc($row['pm_fromuserid']);
$pmsystem .= ">".sed_cc($row['pm_fromuser']);
$pmsystem .= "</a> <b>".$L['pmsubject']."</b> <a href=pm.php?id=".sed_cc($row['pm_id']);
$pmsystem .= "> ".sed_cc($row['pm_title']);
$pmsystem .= "</a><br />";
}
if (mysql_result($newpm,0,"COUNT(*)")>3)
{
$pmsystem .= "".$L['over3msg']."";
}
$whoisonline = $out['whosonline'];
$whoisonline .= "<br />".$out['whosonline_reg_list'];
if ($avatardisplay == "")
{
$useravatar = "<img src=\"skins/$skin/img/noavatar.gif\">";
}
else
{
$useravatar= "<img src=\"$avatardisplay\">";
}
$a=sed_import("a","G","STX");
$id=sed_import("id","G","INT");
if ($a=="addbookmark")
{
$r=sed_sql_query("select page_id, user_id from ".$cfg['plugin']['options']['dbprefix']."_bookmarks where user_id='".$usr['id']."' AND page_id=".$id);
$r=sed_sql_numrows($r);
if ($r==0)
{
if ($id>0 && $usr['id']>0)
{
$s=sed_sql_query("insert into ".$cfg['plugin']['options']['dbprefix']."_bookmarks (page_id, user_id) values ('".$id."','".$usr['id']."')");
header("Location: plug.php?e=options");
}
}
else
{
header("Location: plug.php?e=options");
}
}
if ($a=="deletebookmark")
{
if ($id>0 && $usr['id']>0)
{
$r=sed_sql_query("delete from ".$cfg['plugin']['options']['dbprefix']."_bookmarks where user_id= '".$usr['id']."' AND page_id=$id");
header("Location: plug.php?e=options");
}
}
$sql = sed_sql_query("SELECT * FROM ".$cfg['plugin']['options']['dbprefix']."_pages LEFT JOIN ".$cfg['plugin']['options']['dbprefix']."_bookmarks ON ".$cfg['plugin']['options']['dbprefix']."_pages.page_id=".$cfg['plugin']['options']['dbprefix']."_bookmarks.page_id
WHERE user_id = '".$usr['id']."' ORDER by page_title");
$booknum = sed_sql_numrows($sql);
if ($booknum==0)
{
$bookmarks .="".$L['nobookmarks']."";
}
else
while ($row = sed_sql_fetcharray($sql))
{
$bookmarks .= "<b>".$L['BOOKTITLE']."</b> <a href=page.php?id=".$row['page_id'];
$bookmarks .= ">".$row['page_title'];
$bookmarks .= "</a><br /><b>".$L['BOOKDESCRIPTION']."</b> ".$row['page_desc'];
$bookmarks .= " <a href=plug.php?e=options&a=deletebookmark&id=".$row['page_id'];
$bookmarks .= "> [x] </a><br />";
}
if ($usr['id']>0 && !$a=="cpsettings" && $cfg['plugin']['options']['useroptions'] == "Yes")
{
$set = sed_sql_query("SELECT * FROM ".$cfg['plugin']['options']['dbprefix']."_controlpanel WHERE cp_userid='".$usr['id']."'");
$usersettings = sed_sql_fetcharray($set);
$t-> assign(array(
"USER_USERINFO_NAME" => $usr['name'],
"USER_USERINFO_LEVEL" => sed_build_group($usr['maingrp']),
"USER_USERINFO_ID" => $usr['id'],
"USER_USERINFO_IP" => $usr['ip'],
"USER_USERINFO_SKIN" => $usr['skin'],
"USER_USERINFO_LANG" => $usr['lang'],
"CP_LATESTPAGES" => $latestpages,
"CP_LATESTEVENTS" => $latestevents,
"CP_LATESTTOPICS" => $latesttopics,
"CP_LATESTPOLL" => $latestpoll,
"CP_USERINFO" => $userinfo,
"CP_USERNAME" => $usr['name'],
"CP_USERID" => $usr['id'],
"CP_USERPHOTO" => $userphoto,
"CP_AVATAR" => $useravatar,
"CP_NEWPM" => $newpmmessages,
"CP_OLDPM" => $oldpmmessages,
"CP_SENTPM" => $sentpmmessages,
"CP_ARCHIVEDPM" => $archivedmessages,
"CP_BUDDIES" => $buddies,
"CP_NEWUSER" => $newest_user,
"CP_NOTES" => $notes,
"CP_WHOSONLINE" => $whoisonline,
"CP_ADMIN" => $out['adminpanel'],
"CP_IP" => $usr['ip'],
"CP_PMSYSTEM" => $pmsystem,
"CP_MYPOST" => $useracts,
"CP_BOOKMARKS" => $bookmarks,
"CP_ADMIN" => $out['adminpanel'],
));
$t->parse("MAIN.HEADER");
$t->parse("MAIN.USERCHOICE");
$t->parse("MAIN.MIDDLE");
$t->parse("MAIN.FOOTER");
if ($cfg['plugin']['options']['box1'] == "Yes" && $usersettings['box1'] == "0")
{
$t->parse("MAIN.USERINFO");
}
if ($cfg['plugin']['options']['box2'] == "Yes" && $usersettings['box2'] == "0")
{
$t->parse("MAIN.PMSYSTEM");
}
if ($cfg['plugin']['options']['box3']== "Yes" && $usersettings['box3'] == "0")
{
$t->parse("MAIN.PAGES");
}
if ($cfg['plugin']['options']['box4']== "Yes" && $usersettings['box4'] == "0")
{
$t->parse("MAIN.RECENTFORUMS");
}
if ($cfg['plugin']['options']['box5']== "Yes" && $usersettings['box5'] == "0")
{
$t->parse("MAIN.RECENTEVENTS");
}
if ($cfg['plugin']['options']['box6']== "Yes" && $usersettings['box6'] == "0")
{
$t->parse("MAIN.RECENTPOLLS");
}
if ($cfg['plugin']['options']['box7'] == "Yes" && $usersettings['box7'] == "0")
{
$t->parse("MAIN.NEWUSER");
}
if ($cfg['plugin']['options']['box8'] == "Yes" && $usersettings['box8'] == "0")
{
$t->parse("MAIN.PROFILE");
}
if ($cfg['plugin']['options']['box9'] == "Yes" && $usersettings['box9'] == "0")
{
$t->parse("MAIN.BUDDIES");
}
if ($cfg['plugin']['options']['box10'] == "Yes" && $usersettings['box10'] == "0")
{
$t->parse("MAIN.LIST");
}
if ($cfg['plugin']['options']['box11'] == "Yes" && $usersettings['box11'] == "0")
{
$t->parse("MAIN.ONLINE");
}
if ($cfg['plugin']['options']['box12'] == "Yes" && $usersettings['box12'] == "0")
{
$t->parse("MAIN.BOOKMARKS");
}
}
else if ($usr['id']>0 && !$a=="cpsettings" && $cfg['plugin']['options']['useroptions'] == "No")
{
$t-> assign(array(
"USER_USERINFO_NAME" => $usr['name'],
"USER_USERINFO_LEVEL" => sed_build_group($usr['maingrp']),
"USER_USERINFO_ID" => $usr['id'],
"USER_USERINFO_IP" => $usr['ip'],
"USER_USERINFO_SKIN" => $usr['skin'],
"USER_USERINFO_LANG" => $usr['lang'],
"CP_LATESTPAGES" => $latestpages,
"CP_LATESTEVENTS" => $latestevents,
"CP_LATESTTOPICS" => $latesttopics,
"CP_LATESTPOLL" => $latestpoll,
"CP_USERINFO" => $userinfo,
"CP_USERNAME" => $usr['name'],
"CP_USERID" => $usr['id'],
"CP_USERPHOTO" => $userphoto,
"CP_AVATAR" => $useravatar,
"CP_NEWPM" => $newpmmessages,
"CP_OLDPM" => $oldpmmessages,
"CP_SENTPM" => $sentpmmessages,
"CP_ARCHIVEDPM" => $archivedmessages,
"CP_BUDDIES" => $buddies,
"CP_NEWUSER" => $newest_user,
"CP_NOTES" => $notes,
"CP_WHOSONLINE" => $whoisonline,
"CP_ADMIN" => $out['adminpanel'],
"CP_IP" => $usr['ip'],
"CP_PMSYSTEM" => $pmsystem,
"CP_MYPOST" => $useracts,
"CP_BOOKMARKS" => $bookmarks,
"CP_ADMIN" => $out['adminpanel'],
));
$t->parse("MAIN.HEADER");
$t->parse("MAIN.MIDDLE");
$t->parse("MAIN.FOOTER");
if ($cfg['plugin']['options']['box1'] == "Yes")
{
$t->parse("MAIN.USERINFO");
}
if ($cfg['plugin']['options']['box2'] == "Yes")
{
$t->parse("MAIN.PMSYSTEM");
}
if ($cfg['plugin']['options']['box3']== "Yes")
{
$t->parse("MAIN.PAGES");
}
if ($cfg['plugin']['options']['box4']== "Yes")
{
$t->parse("MAIN.RECENTFORUMS");
}
if ($cfg['plugin']['options']['box5']== "Yes")
{
$t->parse("MAIN.RECENTEVENTS");
}
if ($cfg['plugin']['options']['box6']== "Yes")
{
$t->parse("MAIN.RECENTPOLLS");
}
if ($cfg['plugin']['options']['box7'] == "Yes")
{
$t->parse("MAIN.NEWUSER");
}
if ($cfg['plugin']['options']['box8'] == "Yes")
{
$t->parse("MAIN.PROFILE");
}
if ($cfg['plugin']['options']['box9'] == "Yes")
{
$t->parse("MAIN.BUDDIES");
}
if ($cfg['plugin']['options']['box10'] == "Yes")
{
$t->parse("MAIN.LIST");
}
if ($cfg['plugin']['options']['box11'] == "Yes")
{
$t->parse("MAIN.ONLINE");
}
if ($cfg['plugin']['options']['box12'] == "Yes")
{
$t->parse("MAIN.BOOKMARKS");
}
}
if ($usr['isadmin'])
{
$t->parse("MAIN.ADMINPANEL");
}
if ($usr['id']==0)
{
$t->parse("MAIN.GUEST");
}
if ($usr['id']>0 && $a=="cpsettings" && $cfg['plugin']['options']['useroptions'] == "Yes")
{
$t->parse("MAIN.USERSETTINGS");
}
else
{
}
?>
[url=http://www.freak-forum.de]Freak-Forum.de[/url] - The Freakstyle Community<br />
[url=http://www.adelmann-solutions.com]adelmann-solutions, webdesign Freiburg[/url] |
esclkm |
|
---|---|
Change all sed_sql_query("any","anycode2") to sed_sql_query("any")
and try again littledev.ru - мой маленький зарождающийся блог о котонти.
снижение стоимости программирования и снижение стоимости производства разные вещи. Первое можно скорее сравнить с раздачей работникам дешевых инструментов, чем со снижением зарплаты |
scriptor |
|
---|---|
Hm okay, i try it, but perhaps im too silly...
The complete Link of the Plugin where it can be downloaded is: Options Plugin Or you have a look on the Neocrome page Neocrome Download [url=http://www.freak-forum.de]Freak-Forum.de[/url] - The Freakstyle Community<br />
[url=http://www.adelmann-solutions.com]adelmann-solutions, webdesign Freiburg[/url] |
|
This post was edited by scriptor (2009-03-03 22:27, 15 years ago) |
esclkm |
|
---|---|
plug does not work after modification?
littledev.ru - мой маленький зарождающийся блог о котонти.
снижение стоимости программирования и снижение стоимости производства разные вещи. Первое можно скорее сравнить с раздачей работникам дешевых инструментов, чем со снижением зарплаты |
scriptor |
|
---|---|
i trie to modifie it, but perhaps im not good enough in these...
[url=http://www.freak-forum.de]Freak-Forum.de[/url] - The Freakstyle Community<br />
[url=http://www.adelmann-solutions.com]adelmann-solutions, webdesign Freiburg[/url] |
tensh |
|
---|---|
Here you go: options_253.zip
It's kinda "workable", but not tested. I might post soon reworked version with better template and whatsoever. |
|
This post was edited by tensh (2010-02-15 16:12, 14 years ago) |
pieter |
|
---|---|
Nice,
Pls add it to downloads. ... can we help you ...
|
tensh |
|
---|---|
I'll add it as soon as I check it, in a few days.
I'll also work on the Gallery 3.0 and Weblogs rewrite to Cotonti. I'm currently in the process of moving my site from Seditio to Cotonti so it's a work-by. |
pieter |
|
---|---|
# tensh : Gallery 3.0 and Weblogs rewrite to Cotonti. Great, because a good gallery is missing. If you do the rewrite, will it be with TPL's? It is easier to implement. ... can we help you ...
|
scriptor |
|
---|---|
The User Control Panel have some Bugs...
The My To-Do-List and Events don´t work... Added 39 seconds later: if anyone edit it, is it possible to add a section for the own comments displayed? [url=http://www.freak-forum.de]Freak-Forum.de[/url] - The Freakstyle Community<br />
[url=http://www.adelmann-solutions.com]adelmann-solutions, webdesign Freiburg[/url] |
tensh |
|
---|---|
Own comments? You mean from user's wall (provided by the plugin) or comments created by the user? Yes, I think it's possible.
Please be patient, I'm still working on it and gallery. Gallery 3.0 is actually pretty functional with some small exceptions. |
scriptor |
|
---|---|
that sounds good. the comments of the user on the whole page i mean
![]() ![]() [url=http://www.freak-forum.de]Freak-Forum.de[/url] - The Freakstyle Community<br />
[url=http://www.adelmann-solutions.com]adelmann-solutions, webdesign Freiburg[/url] |