Icy Phoenix

difus wrote: [View Post]

can you do in portal to change languages
ACP>configuration>XS

Quote:

1/ Change all str_replace in SQL queries In order to do that, I added a function in functions_weblog.php :

Code: [Download] [Hide]

Code: [Download] [Show]

1. // Quote variable to make safe  
2. function quote_smart($value)  
3. {  
4. $value = "'" . mysql_real_escape_string($value) . "'";  
5. return $value;  
6. }  
7.  

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: [Download] [Hide]

Code: [Download] [Show]

1. post_username = '" . str_replace("'", "''", $username) . "'  
2.  

becomes

Code: [Download] [Hide]

Code: [Download] [Show]

1. post_username = " . quote_smart($username) . "  
2.  

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

Code: [Download] [Hide]

Code: [Download] [Show]

1. $preview_message = stripslashes(prepare_message(addslashes(unprepare_message($message)), $html_on, $bbcode_on, $smilies_on, $bbcode_uid));  
2.  

(in weblog_posting.php)

difus wrote: [View Post]

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

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