Icy Phoenix
Old Support Topics - [Solved] BlogMod For XS2 problem
hpl [ Wed 25 Oct, 2006 03:08 ]
Post subject: [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 ]
Post subject: Re: BlogMod For XS2
never had this problem
maybe you are missing something
nickjack [ Wed 25 Oct, 2006 10:00 ]
Post subject: Re: BlogMod For XS2
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
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 ]
Post subject: Re: BlogMod For XS2
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
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 ]
Post subject: Re: BlogMod For XS2
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:
where is your release ?
difus [ Wed 25 Oct, 2006 10:37 ]
Post subject: Re: BlogMod For XS2
:mrgreen: :mrorange: :mryellow:
at the bottom
nickjack [ Wed 25 Oct, 2006 10:40 ]
Post subject: Re: BlogMod For XS2
:mrgreen: :mrorange: :mryellow:
at the bottom
sorry :(
where is the bottom???? :?
:?: :!: :?:
hpl [ Wed 25 Oct, 2006 13:47 ]
Post subject: Re: BlogMod For XS2
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
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:
GREAT!!! The problem is BBCode, is true.. Now BlogMod is OK
THANKS!!! :mrgreen: :mrblue: :mrorange: :mrviolet:
difus [ Wed 25 Oct, 2006 15:10 ]
Post subject: Re: BlogMod For XS2
:mrgreen: :mrorange: :mryellow:
at the bottom
sorry :(
where is the bottom???? :?
:?: :!: :?:
at the bottom of my post you can see
phpBBXS_058a_difus2.9[en]
hpl [ Wed 25 Oct, 2006 17:42 ]
Post subject: Re: BlogMod For XS2
another bug: the blog doen't work if there is in post this simbol:
'
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
difus [ Wed 25 Oct, 2006 19:10 ]
Post subject: Re: BlogMod For XS2
is it in my site too? :?
can you post ' on your fourum?
can you insert the picture using img tags ?
difus [ Wed 25 Oct, 2006 21:33 ]
Post subject: 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 ]
Post subject: 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 ]
Post subject: Re: BlogMod For XS2
where do you get this mod?
can I take alook?
hpl [ Wed 25 Oct, 2006 23:20 ]
Post subject: Re: BlogMod For XS2
I get the WeblogMod from your website......... :oops:
difus [ Wed 25 Oct, 2006 23:23 ]
Post subject: Re: BlogMod For XS2
if you are not sleeping :mrgreen:
try to change these files
difus [ Wed 25 Oct, 2006 23:30 ]
Post subject: 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 ]
Post subject: Re: BlogMod For XS2
I get the WeblogMod from your website......... :oops:
yes it is original mod
hpl [ Wed 25 Oct, 2006 23:40 ]
Post subject: 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 ]
Post subject: 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 ]
Post subject: Re: BlogMod For XS2
now you know what to do
congratulations! :mryellow:
difus [ Wed 25 Oct, 2006 23:58 ]
Post subject: Re: BlogMod For XS2
take look to forum.php changes for XS
open
forum.php
#
#-----[ 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 .= ', <a href="' . append_sid ("weblog.$phpEx?" . POST_WEBLOG_URL . "=" . $weblog_data[$i]['weblog_id']) . '"';
}
else
{
$recent_weblogs = '<a href="' . append_sid ("weblog.$phpEx?" . POST_WEBLOG_URL . "=" . $weblog_data[$i]['weblog_id']) . '"';
}
if ( $weblog_data[$i]['user_level'] == ADMIN )
{
$recent_weblogs .= ' style="color:#' . $theme['fontcolor3'] . '">';
}
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'] . '</a>';
}
else
{
$recent_weblogs .= $weblog_data[$i]['weblog_name'] . '</a>';
}
}
//
// End - "The Blog Mod" changes
//
#
#-----[ FIND ]------------------------------------------
#
'NEWEST_USER' => sprintf($lang['Newest_user'], '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$newest_uid") . '">', $newest_user, '</a>'),
#
#-----[ 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),
difus [ Thu 26 Oct, 2006 00:06 ]
Post subject: Re: BlogMod For XS2
try to clear cache folder
difus [ Thu 26 Oct, 2006 00:08 ]
Post subject: 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 ]
Post subject: Re: BlogMod For XS2
It seems you returned your old bbcode.php
difus [ Thu 26 Oct, 2006 00:23 ]
Post subject: 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 ]
Post subject: 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 ]
Post subject: Re: BlogMod For XS2
can you do in portal to change languages
ACP>configuration>XS
ok
difus [ Thu 26 Oct, 2006 00:34 ]
Post subject: Re: BlogMod For XS2
I'm getting SQL error
hpl [ Thu 26 Oct, 2006 02:49 ]
Post subject: Re: BlogMod For XS2
I found this solution:
http://www.theblogmod.com/community...+entry+database
but I must to do this:
Quote:
1/ Change all str_replace in SQL queries In order to do that, I added a function in functions_weblog.php :
- // Quote variable to make safe
- function quote_smart($value)
- {
- $value = "'" . mysql_real_escape_string($value) . "'";
- return $value;
- }
-
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 :
- post_username = '" . str_replace("'", "''", $username) . "'
-
becomes
- post_username = " . quote_smart($username) . "
-
NOTE that the "quotes" before and after the str_replace have been removed. That is because quote_smart already adds the quotes.
2/ remove all call to "stripslashes" EXCEPT in
- $preview_message = stripslashes(prepare_message(addslashes(unprepare_message($message)), $html_on, $bbcode_on, $smilies_on, $bbcode_uid));
-
(in weblog_posting.php)
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 ]
Post subject: 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 ]
Post subject: 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 ]
Post subject: 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
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
:cry: :cry: :cry: :cry:
difus [ Thu 26 Oct, 2006 15:32 ]
Post subject: 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 ]
Post subject: Re: BlogMod For XS2
LOL
I try your relase --->
http://www.ilsitodellagiungla.it/forum_difus/forum.php
and the ' doesn't work in Blog
and doesn't work in forum...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
but in my forum the ' work...where is the bug?
difus [ Thu 26 Oct, 2006 17:08 ]
Post subject: Re: BlogMod For XS2
:mrgreen:
go to ACP >amod+ admin>db adjustments click fresh install
hpl [ Thu 26 Oct, 2006 17:18 ]
Post subject: 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 ]
Post subject: Re: BlogMod For XS2
why I can't see the blog ?
hpl [ Thu 26 Oct, 2006 17:44 ]
Post subject: Re: BlogMod For XS2
NEWS
1) see this:
http://www.ilsitodellagiungla.it/fo...g_entry.php?e=4
------->
I'm hpl work...but I writed -->
I''m hpl (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 ]
Post subject: Re: BlogMod For XS2
GOOD
we have found the problem: the blogmod work only if magic_quotes_gpc is ON in php :mrgreen: :mrblue: :mrorange: :mrviolet:
thank difus for support...
Mighty Gorgon [ Sun 29 Oct, 2006 11:47 ]
Post subject: Re: [Solved] BlogMod For XS2 problem
Another DIFUS great job.
Thanks my friend. :wink: