Betreff: Re: FCK-Editor für XOOPS - Nachgefragt von gobodeejay am 12.10.2006 23:02:16
Great  Keine Fehlermeldung mehr! Aber: Jetzt kann ich die Modulberechtigung für z.B. News setzen, stelle im News-Modul den FCKeditor als Standard-Editor ein; wenn ich nun einen Artikel bearbeiten möchte fehlt der Teil zum bearbeiten einfach 
Die Queries sagen beim bearbeiten der Seite:
Queries
SELECT * FROM cm_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data FROM cm_session WHERE sess_id = 'ffa4f8644855500258fbc48126695bc7'
SELECT * FROM cm_users WHERE uid=1
SELECT * FROM cm_modules WHERE dirname = 'news'
SELECT * FROM cm_config WHERE (conf_modid = '2') ORDER BY conf_order ASC
SELECT COUNT(*) FROM cm_banner
SELECT * FROM cm_banner LIMIT 1, 1
UPDATE cm_banner SET impmade = impmade+1 WHERE bid = 5
SELECT * FROM cm_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT DISTINCT gperm_itemid FROM cm_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2)
SELECT b.* FROM cm_newblocks b, cm_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,2) AND b.bid IN (1,2,3,4,5,6,7,8,9,10,11,12,29,13,14,15,16,17,18,19,20,21,23,25,26,27,24,22,30,34,73,41,42,43,50,51,44,45,53,52,63,64,61,62,66,65,74) ORDER BY b.weight,b.bid
SELECT COUNT(*) FROM cm_priv_msgs WHERE (read_msg = '0' AND to_userid = '1')
SELECT f.*, s.tpl_source FROM cm_tplfile f LEFT JOIN cm_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'cosmic' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
SELECT * FROM cm_modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC, mid ASC
SELECT * FROM cm_group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2'))
SELECT COUNT(*) as cpt FROM cm_topics WHERE menu=1
SELECT * FROM cm_topics ORDER BY topic_title
SELECT gperm_itemid FROM cm_group_permission WHERE gperm_modid='' AND gperm_name='myalbum_global' AND (gperm_groupid IN (1,2))
SELECT parent_id FROM cm_info WHERE storyid=0
SELECT * FROM cm_info WHERE parent_id=0 AND homepage=1 AND submenu=1 ORDER BY blockid ASC
SELECT * FROM cm_info WHERE parent_id=7 AND homepage=1 AND submenu=1 ORDER BY blockid ASC
SELECT parent_id FROM cm_info WHERE storyid=7
SELECT catid,title FROM cm_info_cat
SELECT * FROM cm_modules WHERE dirname = 'PDlinks'
SELECT parent_id FROM cm_info_dj WHERE storyid=0
SELECT * FROM cm_info_dj WHERE parent_id=0 AND homepage=1 AND submenu=1 ORDER BY blockid ASC
SELECT * FROM cm_info_dj WHERE parent_id=1 AND homepage=1 AND submenu=1 ORDER BY blockid ASC
SELECT * FROM cm_info_dj WHERE parent_id=3 AND homepage=1 AND submenu=1 ORDER BY blockid ASC
SELECT * FROM cm_info_dj WHERE parent_id=4 AND homepage=1 AND submenu=1 ORDER BY blockid ASC
SELECT parent_id FROM cm_info_dj WHERE storyid=1
SELECT parent_id FROM cm_info_dj WHERE storyid=3
SELECT parent_id FROM cm_info_dj WHERE storyid=4
SELECT catid,title FROM cm_info_dj_cat
SELECT parent_id FROM cm_info_hist WHERE storyid=0
SELECT * FROM cm_info_hist WHERE parent_id=0 AND homepage=1 AND submenu=1 ORDER BY blockid ASC
SELECT * FROM cm_info_hist WHERE parent_id=1 AND homepage=1 AND submenu=1 ORDER BY blockid ASC
SELECT * FROM cm_info_hist WHERE parent_id=2 AND homepage=1 AND submenu=1 ORDER BY blockid ASC
SELECT * FROM cm_info_hist WHERE parent_id=3 AND homepage=1 AND submenu=1 ORDER BY blockid ASC
SELECT * FROM cm_info_hist WHERE parent_id=4 AND homepage=1 AND submenu=1 ORDER BY blockid ASC
SELECT parent_id FROM cm_info_hist WHERE storyid=1
SELECT parent_id FROM cm_info_hist WHERE storyid=2
SELECT parent_id FROM cm_info_hist WHERE storyid=3
SELECT parent_id FROM cm_info_hist WHERE storyid=4
SELECT catid,title FROM cm_info_hist_cat
SELECT parent_id FROM cm_info_shop WHERE storyid=0
SELECT * FROM cm_info_shop WHERE parent_id=0 AND homepage=1 AND submenu=1 ORDER BY blockid ASC
SELECT * FROM cm_info_shop WHERE parent_id=1 AND homepage=1 AND submenu=1 ORDER BY blockid ASC
SELECT parent_id FROM cm_info_shop WHERE storyid=1
SELECT catid,title FROM cm_info_shop_cat
SELECT * FROM cm_modules WHERE dirname = 'PDdownloads'
SELECT f.*, s.tpl_source FROM cm_tplfile f LEFT JOIN cm_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'cosmic' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid
SELECT s.*, t.* FROM cm_stories s, cm_topics t WHERE (published > 0 AND published <= 1160686574) AND (expired = 0 OR expired > 1160686574) AND (s.topicid=t.topic_id) AND topicid IN (3,5,4,2,6) ORDER BY s.published DESC LIMIT 0, 10
SELECT * FROM cm_smiles
SELECT f.*, s.tpl_source FROM cm_tplfile f LEFT JOIN cm_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'cosmic' AND tpl_file = 'news_block_top.html') ORDER BY tpl_refid
SELECT mid FROM cm_modules WHERE dirname='piCal'
SELECT conf_name,conf_value FROM cm_config WHERE conf_modid=3
SELECT * FROM cm_groups
SELECT f.*, s.tpl_source FROM cm_tplfile f LEFT JOIN cm_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'cosmic' AND tpl_file = 'pical_todays_schedule.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM cm_tplfile f LEFT JOIN cm_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'cosmic' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid
SELECT s.*, t.* FROM cm_stories s, cm_topics t WHERE (storyid=31) AND (s.topicid=t.topic_id)
SELECT s.*, t.* FROM cm_stories s, cm_topics t WHERE (storyid=31) AND (s.topicid=t.topic_id)
SELECT * FROM cm_group_permission WHERE (gperm_name = 'news_submit' AND gperm_modid = '2' AND (gperm_groupid = '1' OR gperm_groupid = '2'))
SELECT count(topic_id) as cpt FROM cm_topics WHERE topic_id IN (7,6,5,4,3,2)
SELECT * FROM cm_topics ORDER BY topic_title
SELECT COUNT(*) FROM cm_users
SELECT * FROM cm_users
SELECT * FROM cm_stories_files WHERE storyid=31
Total: 67 queries
Hilft euch das irgendwie weiter? ich versteh das jetzt nicht mehr :-/ Bis dato wars ja ein SQL-Sytax-Problem, aber nun?
Für Hilfe von Euch sehr dankbar, Markus
|