1.12.7 i starsze - Plus-Minus by KnofeL
$kubi - 21-02-2009, 14:40
"Pochwały może wystawiać autor tematu natomiast nagany moderatorzy i administratorzy "
Nie chce tak... tylko wystawianie przez adminów i moderatorów czy jest to jakiś konfigurowalne w panelu kto może wystawiać pochwały i ostrzeżenia?
krystian1332 - 05-03-2009, 16:11
Powie mi ktos jak zrobic żeby Plus i Minus były koło siebie a nie pod soba ?? jakąś instrukcje bardzo prosze
hifire - 18-05-2009, 18:07
Ktos mi Powie co robie zle ?
| Kod: | Could not obtain post/user information.
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 'LEFT JOIN phpbb_banlist b ON u.user_id=b.ban_userid)phpbb_users u ON (u.user_id ' at line 5
SELECT p.post_id, p.post_time, p.enable_sig, p.enable_html, p.enable_smilies, p.post_edit_count, p.post_edit_time, p.post_username, p.post_approve, p.poster_delete, p.post_edit_by, p.post_plusp, p.post_minusp, p.post_parent, p.post_icon, p.post_attachment, p.post_expire, p.post_marked, u.user_sig_image, u.user_birthday, u.user_from, u.user_regdate, u.user_gender, u.user_aim, u.user_viewaim, u.special_rank, u.user_allow_helped, u.user_avatar_width, u.user_avatar_height, u.user_field_1, u.user_allow_field_1, u.user_field_2, u.user_allow_field_2, u.user_id, u.username, u.user_level, u.user_jr, u.user_allowhtml, u.user_posts, u.user_allowsig, u.user_sig, u.user_sig_bbcode_uid, u.user_allowsmile, u.user_plusp, u.user_minusp, u.user_disallowed_write, b.ban_id, u.user_avatar_type, u.user_allowavatar, u.user_avatar, u.user_rank, u.user_viewemail, u.user_website, u.user_email, u.can_custom_ranks, u.user_custom_rank, u.user_session_time, u.user_allow_viewonline, pt.post_text, pt.bbcode_uid, pt.post_subject , ph.th_post_id FROM phpbb_posts p LEFT JOIN phpbb_posts_text_history ph ON (ph.th_post_id = p.post_id) LEFT JOIN phpbb_posts_text pt ON (pt.post_id = p.post_id) LEFT JOIN ( LEFT JOIN phpbb_banlist b ON u.user_id=b.ban_userid)phpbb_users u ON (u.user_id = p.poster_id) WHERE p.topic_id = 565 GROUP by p.post_id ORDER BY p.post_order, p.post_time ASC LIMIT 0, 15
Line : 843
File : viewtopic.php |
Ktos mi wysle gotowy plik z modem ten co wysylam w zalaczniku ? 
Wydaje mi sie ze nic zle nie zrobilem. Sprawdzalem Wszystko dokladnie ale juz wysylam plik w zalaczniku i instrukcje do tego potrzebna  Bardzo Prosze o Pomoc
Instrukcja Ktora Byla Podana
| Kod: | #
#--[ OPEN ]--
#
viewtopic.php
#
#--[ FIND ]--
#
$order_sql = (!$post_id) ? '' : "GROUP BY
#
#--[ IN-LINE FIND ]--
#
t.topic_last_post_id,
#
#--[ IN-LINE AFTER, ADD ]--
#
t.topic_poster,
#
#--[ FIND ]--
#
$sql = "SELECT p.post_id, p.post_time, p.enable_sig, p.enable_html, p.enable_smilies,
#
#--[ IN-LINE FIND ]--
#
p.post_edit_by
#
#--[ IN-LINE AFTER, ADD ]--
#
, p.post_plusp, p.post_minusp
#
#--[ IN-LINE FIND ]--
#
u.user_allowsmile
#
#--[ IN-LINE AFTER, ADD ]--
#
, u.user_plusp, u.user_minusp, u.user_disallowed_write, b.ban_id
#
#--[ FIND (troche ni¿ej)]--
#
LEFT JOIN " . POSTS_TEXT_TABLE . " pt ON (pt.post_id = p.post_id)
#
#--[ FIND ]--
#
" . USERS_TABLE . " u
#
#--[ IN-LINE BEFORE, ADD ]--
#
(
#
#--[ IN-LINE AFTER, ADD ]--
#
LEFT JOIN ".BANLIST_TABLE." b ON u.user_id=b.ban_userid)
#
#--[ FIND ]--
#
'L_GOTO_PAGE' => $lang['Goto_page'],
#
#--[ AFTER, ADD ]--
#
'L_POST_PLUSP' => $lang['Plusminus_plusinfo'],
'L_POST_MINUSP' => $lang['Plusminus_minusinfo'],
#
#--[ FIND ]--
#
$user_sig_bbcode_uid = $postrow[$i]['user_sig_bbcode_uid'];
#
#--[ AFTER, ADD ]--
#
include($phpbb_root_path . 'plusminus.'.$phpEx);
#
#--[ FIND ]--
#
'DELETE' => $delpost,
#
#--[ AFTER, ADD ]--
#
'ADD_PLUS_POINT'=>$plus_point,
'ADD_MINUS_POINT'=>$minus_point,
'POINTS'=>$points,
#
#--[ FIND ]--
#
'U_POST_ID' => $postrow_post_id)
);
#
#--[ AFTER, ADD ]--
#
if ($postrow[$i]['post_plusp'])
{
$template->assign_block_vars('postrow.plusp',array());
}
if ($postrow[$i]['post_minusp'])
{
$template->assign_block_vars('postrow.minusp',array());
} |
Prosze 
PiroBoss - 20-05-2009, 13:56
hifire, a zapytania do SQL zrobiłeś?
siper - 23-07-2009, 23:13
W zapytaniu sql jest błąd:
| Kod: | --> SQL <--
CREATE TABLE `phpbb_plus_minus` (
`pm_id` int(11) NOT NULL auto_increment,
`pm_date` int(11) NOT NULL,
`pm_type` varchar(1),
`pm_post_id` int(11),
`pm_topic_id` int(11),
`pm_from_id` smallint(6) NOT NULL,
`pm_to_id` smallint(6) NOT NULL,
`pm_reason` text,
PRIMARY KEY (`pm_id`)
) TYPE=MyISAM
ALTER TABLE `phpbb_users` ADD `user_plus` smallint(6) NOT NULL AFTER `user_lang`;
ALTER TABLE `phpbb_users` ADD `user_minus` smallint(6) NOT NULL AFTER `user_plus`
###########################################
|
Powinno być:
| Kod: | --> SQL <--
CREATE TABLE `phpbb_plus_minus` (
`pm_id` int(11) NOT NULL auto_increment,
`pm_date` int(11) NOT NULL,
`pm_type` varchar(1),
`pm_post_id` int(11),
`pm_topic_id` int(11),
`pm_from_id` smallint(6) NOT NULL,
`pm_to_id` smallint(6) NOT NULL,
`pm_reason` text,
PRIMARY KEY (`pm_id`)
) TYPE=MyISAM;
ALTER TABLE `phpbb_users` ADD `user_plus` smallint(6) NOT NULL AFTER `user_lang`;
ALTER TABLE `phpbb_users` ADD `user_minus` smallint(6) NOT NULL AFTER `user_plus`
###########################################
--> Dołączone pliki: <--
plus_minus.php |
Nie dodaleś srednika ![;]](images/smiles/icon_square.gif ";]")
[ Dodano: 24-07-2009, 00:14 ]
Kurcze sory bez tego | Kod: |
--> Dołączone pliki: <--
plus_minus.php |
wolek - 30-08-2009, 12:18
Witam, podczaws wpisania zapytanie SQL wyskoczył mi komunikat :
| Kod: | Błąd
zapytanie SQL:
CREATE TABLE `phpbb_plus_minus` (
`pm_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`pm_date` int( 11 ) NOT NULL ,
`pm_type` varchar( 1 ) ,
`pm_post_id` int( 11 ) ,
`pm_topic_id` int( 11 ) ,
`pm_from_id` smallint( 6 ) NOT NULL ,
`pm_to_id` smallint( 6 ) NOT NULL ,
`pm_reason` text,
PRIMARY KEY ( `pm_id` )
) TYPE = MYISAM ALTER TABLE `quest_users` ADD `user_plus` smallint( 6 ) NOT NULL AFTER `user_lang` ;
MySQL zwrócił komunikat:
#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 'ALTER TABLE `quest_users` ADD `user_plus` smallint(6) NOT NULL AFTER `user_lang`' at line 13 |
wszystkie tabele u mnie mają przedrostek quest_ , staram się teraz znaleźć czy w plikach instalacyjnych jest gdzieś wpisane phpbb_users
Bucu - 30-08-2009, 12:24
| Kod: | CREATE TABLE `quest_plus_minus` (
`pm_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`pm_date` int( 11 ) NOT NULL ,
`pm_type` varchar( 1 ) ,
`pm_post_id` int( 11 ) ,
`pm_topic_id` int( 11 ) ,
`pm_from_id` smallint( 6 ) NOT NULL ,
`pm_to_id` smallint( 6 ) NOT NULL ,
`pm_reason` text,
PRIMARY KEY ( `pm_id` )
) TYPE = MYISAM;
ALTER TABLE `quest_users` ADD `user_plus` smallint( 6 ) NOT NULL AFTER `user_lang` ; |
[ Dodano: 30-08-2009, 13:25 ]
Matteo, dales mu z prefixem phpbb a pisal_ ze ma quest_ 
wolek - 30-08-2009, 12:39
Tak zrobięlm juz wczesniej to i zadzialało, ale mam jeszcze błędy w 2 plikach :
| Kod: | Couldn't obtain topics rates data
DEBUG MODE
SQL Error : 1146 Table 'questforum_FORUM.quest_plus_minus' doesn't exist
SELECT pm_type FROM quest_plus_minus WHERE pm_to_id = 1097
Line : 682
File : usercp_viewprofile.php |
A tu jak wygląda linia 681,2,3
| Kod: | if ( !($pm_result = $db->sql_query($pm_sql)) )
{ message_die(GENERAL_ERROR, 'Couldn\'t obtain topics rates data', '', __LINE__, __FILE__, $pm_sql); }
while ( $plus_minus_data = $db->sql_fetchrow($pm_result) ) |
Wgrywałem 2 x do czytego nie naruszonego pliku, i za każdym razem to samo
Jeszcze problem z plikiem viewtopic.php mam, ale postaram sie jeszcze raz wgrac ?
Moze chce ktos 10 zł na konto lub fona , za instalacje, bo już kiedys to instalowałem i też miałem problem (że w ogole nie zainstalowałem) a w pliku instalacyjnym pisze, ze instalacja latwa. Coś mi nie wychodzi ;/
Matteo - 30-08-2009, 12:41
| wolek napisał/a: | | SQL Error : 1146 Table 'questforum_FORUM.quest_plus_minus' doesn't exist |
To nie błąd w plikach, tylko nie utworzyłeś tabeli. Wykonaj zapytania.
Bucu - 30-08-2009, 12:41
wolek, pisz na gg
wolek - 30-08-2009, 12:50
Metto wielkie dzieki, trzeba bylo zalożyć taele z przedrostkiem quest, a nie phpbb.
[ Dodano: 30-08-2009, 14:04 ]
Teraz błąd z pliku viewtopic.php "
| Kod: | Could not obtain post/user information.
DEBUG MODE
SQL Error : 1054 Unknown column 'u.user_plus' in 'field list'
SELECT p.post_id, p.post_time, p.enable_sig, p.enable_html, p.enable_smilies, p.post_edit_count, p.post_edit_time, p.post_username, p.post_approve, p.poster_delete, p.post_edit_by, p.post_parent, p.post_icon, p.post_attachment, p.post_expire, p.reporter_id, p.post_marked, u.user_sig_image, u.user_from, u.user_gender, u.user_aim, u.user_viewaim, u.special_rank, u.user_allow_helped, u.user_field_14, u.user_allow_field_14, u.user_field_15, u.user_allow_field_15, u.user_field_16, u.user_allow_field_16, u.user_field_18, u.user_allow_field_18, u.user_field_29, u.user_allow_field_29, u.user_id, u.username, u.user_level, u.user_jr, u.user_allowhtml, u.user_posts, u.user_allowsig, u.user_sig, u.user_sig_bbcode_uid, u.user_allowsmile,u.user_plusp, u.user_minusp, u.user_disallowed_write, b.ban_id, u.user_avatar_type, u.user_allowavatar, u.user_avatar, u.user_rank, u.user_viewemail, u.user_website, u.user_email, u.can_custom_ranks, u.user_custom_rank, u.user_session_time, u.user_allow_viewonline, u.user_plus, u.user_minus, u.user_lat, u.user_long, pt.post_text, pt.bbcode_uid, pt.post_subject FROM quest_posts p LEFT JOIN quest_posts_text pt ON (pt.post_id = p.post_id) LEFT JOIN quest_users u ON (u.user_id = p.poster_id) LEFT JOIN quest_banlist b ON (u.user_id = b.ban_userid) WHERE p.topic_id = 6257 GROUP by p.post_id ORDER BY p.post_order, p.post_time ASC LIMIT 0, 15
Line : 844
File : viewtopic.php
|
Linie : pogróbiona=844
| Kod: |
if ( !($result = $db->sql_query($sql)) )
{
[b] message_die(GENERAL_ERROR, 'Could not obtain post/user information.', '', __LINE__, __FILE__, $sql);[/b]
}
$postrow = array();
$posters_id = array();
$posts_id = array();
$poster_id_sql = ''; |
[ Dodano: 30-08-2009, 14:09 ]
Bez tego [b] patrzcie , bo myślalem, ze pogrubi xD , a nie moge poprawic postu juz.
[ Dodano: 30-08-2009, 17:16 ]
Macie jakieś pomysły ? I ponownie mowię, ze mogę zapłacić.
[ Dodano: 30-08-2009, 18:06 ]
Udało mi się uporać z problemem. Ale mam jeszcze jeden ostatni. Brak ikonek + i - , a są wgrane ? za mało miejsca w panelu, czy jak ?
faco - 16-05-2010, 13:30
Mam ten sam problem w viewtopic.php
Jak się z nim poradziłeś ?
MagicalFire - 16-05-2010, 13:35
| faco napisał/a: | Mam ten sam problem w viewtopic.php
Jak się z nim poradziłeś ? |
bo nie wykonałes zapytania
| wolek napisał/a: | | Unknown column 'u.user_plus' in 'field list' |
tłumaczenie
nie znana kolumna w
STRAZAK - 16-05-2010, 14:20
Wykonuje zapytanie jak każecie ale to nic nie daje.
[ Dodano: 16-05-2010, 15:24 ]
| Kod: |
Could not obtain post/user information.
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 ' u.user_plus, u.user_minus, u.user_plus, u.user_minus, u.user_plus, u.user_minus' at line 1
SELECT p.post_id, p.post_time, p.enable_sig, p.enable_html, p.enable_smilies, p.post_edit_count, p.post_edit_time, p.post_username, p.post_approve, p.poster_delete, p.post_edit_by, p.post_parent, p.post_icon, p.user_agent, p.post_attachment, p.post_expire, u.user_sig_image, u.user_birthday, u.user_from, u.user_regdate, u.user_gender, u.user_aim, u.user_viewaim, u.user_avatar_width, u.user_avatar_height, u.user_id, u.username, u.user_level, u.user_jr, u.user_allowhtml, u.user_posts, u.user_allowsig, u.user_sig, u.user_sig_bbcode_uid, u.user_allowsmile, u.user_avatar_type, u.user_allowavatar, u.user_avatar, u.user_rank, u.user_viewemail, u.user_website, u.user_email, u.can_custom_ranks, u.user_custom_rank, u.user_session_time, u.user_allow_viewonline, u.user_plus, u.user_minus,, u.user_plus, u.user_minus, u.user_plus, u.user_minus, u.user_plus, u.user_minus, u.user_plus, u.user_minus, pt.post_text, pt.bbcode_uid, pt.post_subject , ph.th_post_id FROM phpbb_posts p LEFT JOIN phpbb_posts_text_history ph ON (ph.th_post_id = p.post_id) LEFT JOIN phpbb_posts_text pt ON (pt.post_id = p.post_id) LEFT JOIN phpbb_users u ON (u.user_id = p.poster_id) WHERE p.topic_id = 10 GROUP by p.post_id ORDER BY p.post_order, p.post_time ASC LIMIT 0, 15
Line : 843
File : viewtopic.php |
varras - 28-05-2010, 19:56
| Kod: | Błąd
Zapytanie SQL:
CREATE TABLE `phpbb_plus_minus` (
`pm_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`pm_date` int( 11 ) NOT NULL ,
`pm_type` varchar( 1 ) ,
`pm_post_id` int( 11 ) ,
`pm_topic_id` int( 11 ) ,
`pm_from_id` smallint( 6 ) NOT NULL ,
`pm_to_id` smallint( 6 ) NOT NULL ,
`pm_reason` text,
PRIMARY KEY ( `pm_id` )
) TYPE = MYISAM ALTER TABLE `phpbb_users` ADD `user_plus` smallint( 6 ) NOT NULL AFTER `user_lang` ;
MySQL zwrócił komunikat: Dokumentacja
#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 'ALTER TABLE `phpbb_users` ADD `user_plus` smallint(6) NOT NULL AFTER `user_lang`' at line 13 |
Mam oryginalne pliki v4,5..
jakieś pomysły?
|
|
|
