Point/Cash + Attribute mod

topthisfact

topthisfact

Paragon
Joined
Dec 14, 2009
Messages
2,244
Reaction score
0
FP$
636
Hello,
I was wondering where forumpromotion get the point/cash system mod at?

Also i was also wondering the same thing on the mod "Attribute"
 
REP+ up Dotdavid

Thanks so much
Well i've installed that cash system & it seems to be not it.
I think forumpromotion coded the point system.
 
No, FP's cash system was abandoned for a while. This site is old, the MOD for the cash is not avalible anymore but anyother point mod still works as the same 🙂
 
As Santa said, the cash mod here is a very old mod which has since been abandoned and no longer available for download.

Maybe instead of posting here asking everytime what mod FP uses, why not try a search on phpBB.com?
 
Hey about the attribute mod
i've installed it

when i go to posting tab & click on "attribute icon" it says

"SQL
Code:Select All
CREATE TABLE phpbb_topics_attr (
attr_id INT(11) AUTO_INCREMENT NOT NULL,
attr_type TINYINT(1) DEFAULT '0' NOT NULL,
attr_name VARCHAR(255) COLLATE utf8_bin NOT NULL,
left_id MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
right_id MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
attr_img VARCHAR(255) COLLATE utf8_bin NOT NULL,
attr_date VARCHAR(25) COLLATE utf8_bin DEFAULT NULL,
attr_colour VARCHAR(6) COLLATE utf8_bin NOT NULL,
attr_user_colour TINYINT(1) default '0' NOT NULL,
PRIMARY KEY (attr_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

ALTER TABLE phpbb_forums ADD attributes_selected text collate utf8_bin NOT NULL;
ALTER TABLE phpbb_topics ADD topic_attribute VARCHAR(25);
"


on the install guide page i remember something about a SQL code but i wasnt sure if i was suppose to add it so i didnt, but even if i should where do i add it at. Other then that i did everything.
 
Nathan said:
Do the SQL in phpmyadmin.
Click to expand...

Hello,
Ok i've just done that.
It seems to fix alot of things.
The attribute button is showing in the topic & in the forum boards & admin control panel area.

But the problem is that :

When i edit/add a forum board & scroll down to access which "attribute" do i put in the forum & who can access it. It shows 2 copys of them

Like "Topic attributes list:
Select the topic attribute, which you wish select from that forum. You can too define the permissions, according to the users levels." twice with the same information



I mean i can edit a forum i already have
But when i tried to add a new forum it won't let me & it will say

Code: 
General Error
SQL ERROR [ mysqli ]

Field 'attributes_selected' doesn't have a default value [1364]

SQL

INSERT INTO phpbb_forums (parent_id, forum_type, forum_status, forum_parents, forum_name, forum_link, forum_desc, forum_desc_uid, forum_desc_options, forum_desc_bitfield, forum_rules, forum_rules_uid, forum_rules_options, forum_rules_bitfield, forum_rules_link, forum_image, forum_style, display_subforum_list, display_on_index, forum_topics_per_page, enable_indexing, enable_icons, enable_prune, prune_days, prune_viewed, prune_freq, forum_options, forum_flags, left_id, right_id) VALUES (0, 1, 0, '', 'fnnnnnn', '', 'nn', '', 7, '', '', '', 7, '', '', '', 0, 1, 0, 0, 1, 0, 0, 7, 7, 1, 0, 48, 51, 52)

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/acp/acp_forums.php
LINE: 1043
CALL: dbal_mysqli->sql_query()

FILE: includes/acp/acp_forums.php
LINE: 201
CALL: acp_forums->update_forum_data()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_forums->main()

FILE: adm/index.php
LINE: 77
CALL: p_master->load_active()
 
Already over check my full edities.
None of them have duplicate codes.

What you mean by the pre-rc3 fixes?
 
Ok check that

I think i notice whats my problem, it has something to do with SQL probably.

Ok I've added the sql code that was in the install file & into a text file & saved it as "phpbb_topisc_attr" then import it into the phpmyadmin .

Thats all, is that the right way to do it? because i checked the release thread for the pre-rc3 fixes & seems to be perfectly no mistakes.
 
have you added attributes and selected which attributes you want for each forum?

I think that is the problem you are having, you haven't selected any attributes and that is why you are getting an error
 
Hmm
Nathan but i really did I wont lie to you

I edited all these files

"posting.php
viewtopic.php
adm/style/acp_forums.html
includes/acp/acp_styles.php
includes/mcp/mcp_forum.php"

Also Btw, I found out why my Attributes are showing duplication, i did duplicate on a code. Although i deleted it but still did your rc3 fixes.



But this forum error problems still stay alive. I can't add a forum/board because it showing this error. Or wait, i edited all the files in rc3 fixes but the SQL information. I dont get what it means, do i have to edit the above information?

"#-----[ SQL ]------------------------------------------
#
# change 'phpbb_' by your table prefix if necessary
#
ALTER TABLE phpbb_forums CHANGE attributes_selected attributes_selected TEXT CHARACTER SET utf8 COLLATE utf8_bin NULL;





Also btw the error preventing me to add a forum is



General Error
SQL ERROR [ mysqli ]

Field 'attributes_selected' doesn't have a default value [1364]

SQL

INSERT INTO phpbb_forums (parent_id, forum_type, forum_status, forum_parents, forum_name, forum_link, forum_desc, forum_desc_uid, forum_desc_options, forum_desc_bitfield, forum_rules, forum_rules_uid, forum_rules_options, forum_rules_bitfield, forum_rules_link, forum_image, forum_style, display_subforum_list, display_on_index, forum_topics_per_page, enable_indexing, enable_icons, enable_prune, prune_days, prune_viewed, prune_freq, forum_options, forum_flags, left_id, right_id) VALUES (0, 1, 0, '', 'asdsa', '', 'dfdfd', '', 7, '', '', '', 7, '', '', '', 0, 1, 0, 0, 1, 0, 0, 7, 7, 1, 0, 48, 51, 52)

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/acp/acp_forums.php
LINE: 1043
CALL: dbal_mysqli->sql_query()

FILE: includes/acp/acp_forums.php
LINE: 201
CALL: acp_forums->update_forum_data()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_forums->main()

FILE: adm/index.php
LINE: 77
CALL: p_master->load_active()
 
For the 10th time you need to do the SQL which is:

Code: 
ALTER TABLE phpbb_forums CHANGE attributes_selected attributes_selected TEXT CHARACTER SET utf8 COLLATE utf8_bin NULL;
 
Yeah im really trying to understand or do the SQL but i really don't know what to do that you are trying to

Ok, first i went to phpmyadmin
I went to phpbb_forums

I search for "attributes_selected "
And below is it's information

Field: attributes_selected Type:text Collation: utf8_bin Attributes: (blank) Null:No Default: (blank) Extra: (Blank)
 
Aw thanks Nathan.
That guide yeah, because i really dont want to waste your time Nathan, I just really want to know what to do so i can do it you know.

That link gave me the guide on fixing the attri mod.





Btw, i was wondering for the mood mod i have at
http://www.easypromotion.co.cc/viewtopi ... p=295#p295

How do i make it shown under the rep mod, also i want the word "mood:" deleted & show the images.
 
You must log in or register to reply here.

About Us

Since 2007, Forum Promotion has specialized in providing advertising solutions to webmasters looking to promote their communities. We pride ourselves in being the bridge that connects forum administrators, bloggers, and more.

Sponsors

Affiliates

    Universal Gaming The Coffee House

Stay Connected

Back
Top Bottom