https://www.icyphoenix.com/viewtopic.php?f=35&t=517 ----------------------------------- hpl Wed 25 Oct, 2006 03:08 [Solved] BlogMod For XS2 problem ----------------------------------- hi, I try to install TheBlogMod on XS...but doen't work when I post in blog... see a test: http://www.ilsitodellagiungla.it/forum_test/weblog.php?w=1 I see that BlogMod in Difus's site is ok...any suggestion?? greetings hpl ----------------------------------- difus Wed 25 Oct, 2006 07:28 Re: BlogMod For XS2 ----------------------------------- never had this problem maybe you are missing something ----------------------------------- nickjack Wed 25 Oct, 2006 10:00 Re: BlogMod For XS2 ----------------------------------- [quote user="hpl" post="4095"]hi, I try to install TheBlogMod on XS...but doen't work when I post in blog... see a test: http://www.ilsitodellagiungla.it/forum_test/weblog.php?w=1 I see that BlogMod in Difus's site is ok...any suggestion?? greetings hpl[/quote] please send the link of the original mod, if you have 1 problem, please put the link for original mod, and if have erros, please put pictues. Thanks ----------------------------------- difus Wed 25 Oct, 2006 10:30 Re: BlogMod For XS2 ----------------------------------- [quote user="hpl" post="4095"]hi, I try to install TheBlogMod on XS...but doen't work when I post in blog... see a test: http://www.ilsitodellagiungla.it/forum_test/weblog.php?w=1 I see that BlogMod in Difus's site is ok...any suggestion?? greetings hpl[/quote] try download my release, extract includes/bbcode.php replace bbcode.php [overwrite] with yours if nothing I'll prepare for you weblog install.txt then you can compare with your's installation :wink: ----------------------------------- nickjack Wed 25 Oct, 2006 10:36 Re: BlogMod For XS2 ----------------------------------- [quote user="difus" post="4101"] try download my release, extract includes/bbcode.php replace bbcode.php [overwrite] with yours if nothing I'll prepare for you weblog install.txt then you can compare with your's installation :wink:[/quote] where is your release ? ----------------------------------- difus Wed 25 Oct, 2006 10:37 Re: BlogMod For XS2 ----------------------------------- :mrgreen: :mrorange: :mryellow: at the bottom ----------------------------------- nickjack Wed 25 Oct, 2006 10:40 Re: BlogMod For XS2 ----------------------------------- [quote user="difus" post="4103"]:mrgreen: :mrorange: :mryellow: at the bottom[/quote] sorry :( where is the bottom???? :? :?: :!: :?: ----------------------------------- hpl Wed 25 Oct, 2006 13:47 Re: BlogMod For XS2 ----------------------------------- [quote user="difus" post="4101"][quote user="hpl" post="4095"]hi, I try to install TheBlogMod on XS...but doen't work when I post in blog... see a test: http://www.ilsitodellagiungla.it/forum_test/weblog.php?w=1 I see that BlogMod in Difus's site is ok...any suggestion?? greetings hpl[/quote] try download my release, extract includes/bbcode.php replace bbcode.php [overwrite] with yours if nothing I'll prepare for you weblog install.txt then you can compare with your's installation :wink:[/quote] GREAT!!! The problem is BBCode, is true.. Now BlogMod is OK THANKS!!! :mrgreen: :mrblue: :mrorange: :mrviolet: ----------------------------------- difus Wed 25 Oct, 2006 15:10 Re: BlogMod For XS2 ----------------------------------- [quote user="nickjack" post="4104"][quote user="difus" post="4103"]:mrgreen: :mrorange: :mryellow: at the bottom[/quote] sorry :( where is the bottom???? :? :?: :!: :?:[/quote] at the bottom of my post you can see [color=#ff0033]phpBBXS_058a_difus2.9[en] [/color] ----------------------------------- hpl Wed 25 Oct, 2006 17:42 Re: BlogMod For XS2 ----------------------------------- another bug: the blog doen't work if there is in post this simbol:[b] '[/b] [quote]Could not insert entry into database DEBUG MODE SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'è', 'a8a53d84df', -1, -1, '', 1161790918, 1, 1, 0, 0, 0, 2, 2, '')' at line 2 INSERT INTO phpbb_weblog_entries (entry_id, weblog_id, entry_access, entry_subject, entry_text, bbcode_uid, entry_mood, entry_currently, currently_text, entry_time, enable_bbcode, enable_smilies, enable_html, memorable, no_replies, entry_last_post_userid, entry_poster_id, category) VALUES (5, 1, 0, 'test', 'all'è', 'a8a53d84df', -1, -1, '', 1161790918, 1, 1, 0, 0, 0, 2, 2, '') Line : 598 File : /var/www/vhosts/ilsitodellagiungla.it/httpdocs/forum_test/weblog_posting.php[/quote] ----------------------------------- difus Wed 25 Oct, 2006 19:10 Re: BlogMod For XS2 ----------------------------------- is it in my site too? :? can you post [b][color=#ff0026]'[/color][/b] on your fourum? can you insert the picture using img tags ? ----------------------------------- hpl Wed 25 Oct, 2006 20:41 Re: BlogMod For XS2 ----------------------------------- in your site is ok (see my test with ' ), the bbcode is all ok in your and my site (img tags work) --> http://www.ilsitodellagiungla.it/forum_test/weblog.php?w=1 but in my site I can't use ' ----------------------------------- difus Wed 25 Oct, 2006 21:33 Re: BlogMod For XS2 ----------------------------------- in site or in weblog or both ? what is your mysql charset code? mine Unicode (utf8) ci ----------------------------------- hpl Wed 25 Oct, 2006 22:42 Re: BlogMod For XS2 ----------------------------------- charset is utf8, in forum I can use ' , but in webblog I can't.... :cry: :cry: ----------------------------------- difus Wed 25 Oct, 2006 23:10 Re: BlogMod For XS2 ----------------------------------- where do you get this mod? can I take alook? ----------------------------------- hpl Wed 25 Oct, 2006 23:20 Re: BlogMod For XS2 ----------------------------------- I get the WeblogMod from your website......... :oops: ----------------------------------- difus Wed 25 Oct, 2006 23:23 Re: BlogMod For XS2 ----------------------------------- if you are not sleeping :mrgreen: try to change these files ----------------------------------- difus Wed 25 Oct, 2006 23:30 Re: BlogMod For XS2 ----------------------------------- or best of all you can bring all weblog files [only weblog mod files, not changed files like forum.php or viewtopic.php] from my release and replace it isn't so hard :? and one moment did you know when installing that index.php , in our case realy it is forum.php waiting for results :mrblue: ----------------------------------- difus Wed 25 Oct, 2006 23:36 Re: BlogMod For XS2 ----------------------------------- [quote user="hpl" post="4126"]I get the WeblogMod from your website......... :oops:[/quote] yes it is original mod ----------------------------------- hpl Wed 25 Oct, 2006 23:40 Re: BlogMod For XS2 ----------------------------------- I try your file and I try to use all files of your relase.... ..doesn't work :shock: :shock: :shock: :shock: :shock: ----------------------------------- hpl Wed 25 Oct, 2006 23:43 Re: BlogMod For XS2 ----------------------------------- NEWS!! I try to up forum.php of your relase....the forum doesn't work BUT the weblog mod now work with ' .... I think that the solution is in forum.php..... ----------------------------------- difus Wed 25 Oct, 2006 23:45 Re: BlogMod For XS2 ----------------------------------- now you know what to do congratulations! :mryellow: ----------------------------------- difus Wed 25 Oct, 2006 23:58 Re: BlogMod For XS2 ----------------------------------- take look to forum.php changes for XS open [b]forum.php[/b] [code linenumbers=false]# #-----[ FIND ]------------------------------------------ # // // Start output of page // # #-----[ BEFORE, ADD ]------------------------------------------ # // // Begin - "The Blog Mod" changes // include($phpbb_root_path . 'includes/weblogs_common.'.$phpEx); include($phpbb_root_path . 'includes/functions_weblog.'.$phpEx); // // Get Weblog Data // $weblog_data = fetch_visible_weblogs (); for ($i = 0; $i < count($weblog_data) && $i < 10; $i++) { if ( !empty($recent_weblogs) ) { $recent_weblogs .= ', '; } else if ( $weblog_data[$i]['user_level'] == MOD ) { $recent_weblogs .= ' style="color:#' . $theme['fontcolor2'] . '">'; } else { $recent_weblogs .= '>'; } if ( $weblog_config['index_list_by_username'] ) { $recent_weblogs .= $weblog_data[$i]['username'] . ''; } else { $recent_weblogs .= $weblog_data[$i]['weblog_name'] . ''; } } // // End - "The Blog Mod" changes // # #-----[ FIND ]------------------------------------------ # 'NEWEST_USER' => sprintf($lang['Newest_user'], '', $newest_user, ''), # #-----[ AFTER, ADD ]------------------------------------------ # // The Blog Entry by support [at] TheBlogMod.com 'MOST_RECENT_WEBLOGS' => sprintf( (( $weblog_config['index_list_by_username'] ) ? $lang['Most_recent_weblogs_user'] : $lang['Most_recent_weblogs']) , $recent_weblogs),[/code] ----------------------------------- hpl Thu 26 Oct, 2006 00:02 Re: BlogMod For XS2 ----------------------------------- I'm scared.... ....the ' work only 1 times... why????? :shock: :shock: :shock: :shock: ---> dasdas'gsdfg (the only ' of my blog) ---> see on http://www.ilsitodellagiungla.it/forum_test/weblog_entry.php?e=8 ----------------------------------- difus Thu 26 Oct, 2006 00:06 Re: BlogMod For XS2 ----------------------------------- try to clear cache folder ----------------------------------- difus Thu 26 Oct, 2006 00:08 Re: BlogMod For XS2 ----------------------------------- I posted reply and for me it works ! or comment I don't know your language :mrblue: ----------------------------------- difus Thu 26 Oct, 2006 00:14 Re: BlogMod For XS2 ----------------------------------- It seems you returned your old bbcode.php ----------------------------------- hpl Thu 26 Oct, 2006 00:17 Re: BlogMod For XS2 ----------------------------------- [quote user="difus" post="4136"]try to clear cache folder[/quote] nothing.... [quote user="difus" post="4137"]I posted reply and for me it works ![/quote] in your website work...in my not... If you want, try: http://www.ilsitodellagiungla.it/forum_test/forum.php ----------------------------------- difus Thu 26 Oct, 2006 00:23 Re: BlogMod For XS2 ----------------------------------- answer SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'm stupid man', '409ffcf60b')' at line 2 ----------------------------------- difus Thu 26 Oct, 2006 00:26 Re: BlogMod For XS2 ----------------------------------- can you do in portal to change languages ACP>configuration>XS and default - english ----------------------------------- hpl Thu 26 Oct, 2006 00:32 Re: BlogMod For XS2 ----------------------------------- [quote user="difus" post="4141"]can you do in portal to change languages ACP>configuration>XS[/quote] ok ----------------------------------- difus Thu 26 Oct, 2006 00:34 Re: BlogMod For XS2 ----------------------------------- I'm getting SQL error ----------------------------------- hpl Thu 26 Oct, 2006 02:49 Re: BlogMod For XS2 ----------------------------------- I found this solution: http://www.theblogmod.com/community/viewtopic.php?t=542&start=0&postdays=0&postorder=asc&highlight=insert+entry+database but I must to do this: [quote][b]1/ Change all str_replace in SQL queries[/b] In order to do that, I added a function in functions_weblog.php : [code] // Quote variable to make safe function quote_smart($value) { $value = "'" . mysql_real_escape_string($value) . "'"; return $value; } [/code] each time a str_replace is called in a SQL query INSERT or UPDATE, the str_replace has to be replaced with quote_smart($value). Example : [code] post_username = '" . str_replace("'", "''", $username) . "' [/code] becomes [code] post_username = " . quote_smart($username) . " [/code] NOTE that the "quotes" before and after the str_replace have been removed. That is because quote_smart already adds the quotes. [b]2/ remove all call to "stripslashes"[/b] EXCEPT in [code] $preview_message = stripslashes(prepare_message(addslashes(unprepare_message($message)), $html_on, $bbcode_on, $smilies_on, $bbcode_uid)); [/code] (in weblog_posting.php)[/quote] I thy to change the function "str_replace" to "quote_smart" and the BlogMoD work with ' ... why doesn't work with function "str_replace"? ----------------------------------- difus Thu 26 Oct, 2006 07:53 Re: BlogMod For XS2 ----------------------------------- I think it is not a good solution, but it must work it is depending of server configuration [magic quotes enabled] ----------------------------------- difus Thu 26 Oct, 2006 08:20 Re: BlogMod For XS2 ----------------------------------- for right work and security,if you are not tired , do backup of your root and try to replace these files ----------------------------------- hpl Thu 26 Oct, 2006 14:54 Re: BlogMod For XS2 ----------------------------------- [quote user="difus" post="4147"]for right work and security,if you are not tired , do backup of your root and try to replace these files[/quote] [quote]Could not insert entry into database DEBUG MODE SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5d66167146', -1, -1, '', 1161867198, 1, 1, 0, 0, 0, 2, 2, '')' at line 2 INSERT INTO phpbb_weblog_entries (entry_id, weblog_id, entry_access, entry_subject, entry_text, bbcode_uid, entry_mood, entry_currently, currently_text, entry_time, enable_bbcode, enable_smilies, enable_html, memorable, no_replies, entry_last_post_userid, entry_poster_id, category) VALUES (19, 1, 0, 'hfg', 'hrty'', '5d66167146', -1, -1, '', 1161867198, 1, 1, 0, 0, 0, 2, 2, '') Line : 598 File : /var/www/vhosts/ilsitodellagiungla.it/httpdocs/forum_test/weblog_posting.php[/quote] :cry: :cry: :cry: :cry: ----------------------------------- difus Thu 26 Oct, 2006 15:32 Re: BlogMod For XS2 ----------------------------------- no ideas :? create one more test forum and install my release if it goes down , then I'll be sure that problem is your hosting ----------------------------------- hpl Thu 26 Oct, 2006 16:57 Re: BlogMod For XS2 ----------------------------------- LOL I try your relase ---> http://www.ilsitodellagiungla.it/forum_difus/forum.php and the ' doesn't work in Blog [i]and doesn't work in forum[/i]...for example if I try to post: [quote]Could not obtain post/user information. DEBUG MODE SQL Error : 1054 Unknown column 'u.user_trophies' in 'field list' SELECT u.user_trophies, u.ina_char_name, u.username, u.user_id, u.user_posts, u.user_from, u.user_weblog, u.user_from_flag, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_skype, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_rank2, u.user_rank3, u.user_rank4, u.user_rank5, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.ct_miserable_user, u.user_allow_viewonline, u.user_session_time, u.user_warnings, u.user_level, u.user_birthday, u.user_next_birthday_greeting, u.user_gender, u.user_personal_pics_count, u.user_style, u.user_lang, p.*, pt.post_text, pt.post_text_compiled, pt.post_subject, pt.bbcode_uid, u.karma_plus, u.karma_minus, pt.edit_notes, t.topic_poster, t.title_compl_infos FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt, phpbb_topics t WHERE p.topic_id = 3 AND t.topic_id = p.topic_id AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15 Line : 759 File : viewtopic.php[/quote] but in my forum the ' work...where is the bug? ----------------------------------- difus Thu 26 Oct, 2006 17:08 Re: BlogMod For XS2 ----------------------------------- :mrgreen: go to ACP >amod+ admin>db adjustments click fresh install ----------------------------------- hpl Thu 26 Oct, 2006 17:18 Re: BlogMod For XS2 ----------------------------------- ok now ' work in forum...but doesn't work in blog.... :mrgreen: :mrblue: :mrorange: :mrviolet: ----------------------------------- difus Thu 26 Oct, 2006 17:31 Re: BlogMod For XS2 ----------------------------------- why I can't see the blog ? ----------------------------------- hpl Thu 26 Oct, 2006 17:44 Re: BlogMod For XS2 ----------------------------------- NEWS 1) see this: http://www.ilsitodellagiungla.it/forum_difus/weblog_entry.php?e=4 -------> [b]I'm hpl[/b] work...but I writed -->[b] I''m hpl[/b] (with 2 ' ) If you write two ' , the blog work with one ' .... 2) the ' work on shoutbox of weblog.... ----------------------------------- hpl Thu 26 Oct, 2006 19:07 Re: BlogMod For XS2 ----------------------------------- GOOD we have found the problem: the blogmod work only if magic_quotes_gpc is [b]ON[/b] in php :mrgreen: :mrblue: :mrorange: :mrviolet: thank difus for support... ----------------------------------- Mighty Gorgon Sun 29 Oct, 2006 11:47 Re: [Solved] BlogMod For XS2 problem ----------------------------------- Another DIFUS great job. Thanks my friend. :wink: