Код: Выделить всё
##############################################################
## MOD Title: Users Reputations System v.1.0.0
## MOD Author: antongranik < anton@granik.com > (Anton Granik) http://granik.com
## MOD Description: Allows users to give reputation points to each others, earn it by posts and by "living" on forum, see the history of givings. Admin can edit users' reputations in admin cp. The whole system can be a text or a graphic version (5 different medals) and simple or advanced version (with choosing of how much reputation to give). You can get help on the system in the guide/ folder.
## MOD Version: 1.0.0
##
## Installation Level: (Intermediate)
## Installation Time: 30 Minutes
## Files To Edit (15):
## Included Files (21):
##
## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2
##############################################################
## For security purposes, please check: http://www.phpbb.com/mods/
## for the latest version of this MOD. Although MODs are checked
## before being allowed in the MODs Database there is no guarantee
## that there are no security problems within the MOD. No support
## will be given for MODs not found within the MODs Database which
## can be found at http://www.phpbb.com/mods/
##############################################################
## Author Notes:
## 1. For the latest release always go to http://granik.com/forum/viewtopic.php?t=16
## 2. Official support forum is http://granik.com/forum/viewforum.php?f=3 If you download this mod from other sides then the mentioned sites above, it might cause malicious code to enter into your phpBB Forum.
## 3. Russian translation is included in folder lang_russian/
## 4. In folder different medals/buckets/ there are different medals. The medals are buckets with paint. :) Just copy these files to your forum_root_directory/images/
## 5. Special thanks to my wife and daughter for leaving me untouched while writing this mod :) , rockboyteek, Raul Duke, cherokee red, Patrick Simmons, aboyd, Infamy and all those I have forgotten for testing and helping...
## 6. Tested on phpbb 2.0.19, 2.0.20.
##############################################################Проблема заключается в следующем (причем, что странно, на локалхосте никакой проблемы нет):
При написании сообщения в любой теме выскакивает ошибка
Код: Выделить всё
Error in updating the reputations
DEBUG MODE
UPDATE phpbb_users SET user_reputation = user_reputation + 0,02, user_rep_last_time = 1186165477 WHERE user_id = 2
Line : 176
File : functions_reputation.php В настройках включен набор репутации по одному очку за каждые 50 сообщений, оставленные не форме. Несмотря на ошибку, сообщение оставляется, что логично, но репутация, естественно, не набирается.
Вот эти строки из файла functions_reputation.php:
Код: Выделить всё
if ($mode != 'poll_delete')
{
$sql = "UPDATE " . USERS_TABLE . "
SET user_reputation = user_reputation $sign_rep, user_rep_last_time = $last_time
WHERE user_id = $user_id";
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Error in updating the reputations', '', __LINE__, __FILE__, $sql);
}
}
При удалении этого сообщения также выскакивает ошибка:
Код: Выделить всё
Error in updating the reputations
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 '02, user_rep_last_time = 1186165477 WHERE user_id = 2' at line 2
UPDATE phpbb_users SET user_reputation = user_reputation - 0,02, user_rep_last_time = 1186165477 WHERE user_id = 2
Line : 176
File : functions_reputation.phpОчень надеюсь на вашу помощь.
