Page 23 of 33

Re: [RC3]Profile comments/ Feedback/ Karma (1.6.2)

Posted: Sat Aug 09, 2008 10:20 pm
by janmyszkier
i'm still here, i can't find a way to pass them through. that's why i'm not replying to this topic :/ tough case...

Re: [RC3]Profile comments/ Feedback/ Karma (1.6.2)

Posted: Sat Aug 09, 2008 11:04 pm
by kevinroxx
janmyszkier wrote:i'm still here, i can't find a way to pass them through. that's why i'm not replying to this topic :/ tough case...
How does phpbb allow these kind of characters?

Re: [RC3]Profile comments/ Feedback/ Karma (1.6.2)

Posted: Sat Aug 09, 2008 11:12 pm
by muggins
Isn't it UTF-8? Perhaps specifying the character encoding in the database edits? I'm too lazy to look right now... :(

Re: [RC3]Profile comments/ Feedback/ Karma (1.6.2)

Posted: Sun Aug 10, 2008 1:57 pm
by janmyszkier
Yup, thats it:

Code: Select all

ALTER TABLE `phpbb_comments` CHANGE `comment_text` `comment_text` TEXT CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL  
ALTER TABLE `phpbb_comments` CHANGE `comment_author` `comment_author` VARCHAR( 25 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL  
this should allow you to store special characters. (this code is ONLY for those who already has 1.6.2 installed, 1.6.2 package has been updated and already contains good sql schema)

Re: [RC3]Profile comments/ Feedback/ Karma (1.6.2)

Posted: Mon Aug 11, 2008 3:10 am
by kevinroxx
janmyszkier wrote:Yup, thats it:

Code: Select all

ALTER TABLE `phpbb_comments` CHANGE `comment_text` `comment_text` TEXT CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL  
ALTER TABLE `phpbb_comments` CHANGE `comment_author` `comment_author` VARCHAR( 25 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL  
this should allow you to store special characters. (this code is ONLY for those who already has 1.6.2 installed, 1.6.2 package has been updated and already contains good sql schema)
Great to hear.

Any idea about pagination though, doesn't seem to work for me.

Re: [RC3]Profile comments/ Feedback/ Karma (1.6.2)

Posted: Mon Aug 11, 2008 3:20 am
by kevinroxx
This is the error I receive while running the SQL in the installation file:

Code: Select all

#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 'TEXT CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  comment_text TEXT' at line 6 


Re: [RC3]Profile comments/ Feedback/ Karma (1.6.2)

Posted: Mon Aug 11, 2008 11:19 pm
by janmyszkier
ah crap, mysqli issue? hm will check this out, however, when you go to phpmyadmin, see your phpbb_comments and select to view structure just select proper fields and change their character encoding to utf8_bin.

as for paging, just fixed; those who ave problems with pagination, please redownload the 1.6.2 package and just overwrite styles and profile_comments.php files (also remember to recache).

kevinroxx the installation file query was indeed wrong, fixed now. thank you.

Re: [RC3]Profile comments/ Feedback/ Karma (1.6.2)

Posted: Wed Aug 13, 2008 2:58 am
by kevinroxx
Jan everything seems to be working okay now. One suggestion goes towards the images in view all comments for the next, previous, last, first, ect images. I receive a broken image when there is no comments at all to view.

Would it be possible to make an 'if' statement or something somewhere for example - If there are no comments than do not display next, previous, ect images. But if there are comments than show the images.

Thanks,
Kevin

Re: [RC3]Profile comments/ Feedback/ Karma (1.6.2)

Posted: Thu Aug 14, 2008 9:30 pm
by InternetMafia
Any way to extract just the profile comments section of this mod?

I have user rep so I am not interested in Karma

And what does feedback too exactly?

Re: [RC3]Profile comments/ Feedback/ Karma (1.6.2)

Posted: Thu Aug 14, 2008 10:10 pm
by kevinroxx
InternetMafia wrote:Any way to extract just the profile comments section of this mod?

I have user rep so I am not interested in Karma

And what does feedback too exactly?
Not quite understanding what you mean InternetMafia. What part do you only want seen?
Can you post a screen shot highlighting what you want seen or give us an example.
I'm thinking that you should be able to extract only the profile comments section of the mod just by editing the html pages. If you could just clarify what you want displayed it may help us understand a little better.

Re: [RC3]Profile comments/ Feedback/ Karma (1.6.2)

Posted: Thu Aug 14, 2008 10:24 pm
by InternetMafia
Now take a look at this picture here.
http://maxedgaming.com/Images/profile/before.jpg

I am looking for something like this. I dont need an xfire box or a mood box and I dont really want all those extra banners. But I AM very interested in how to install profile comments that would look something like this and perhaps have a YouTube video on there somewhere.

I know it would take some modding and skills I dont have, but I am wondering if it is possible to just install the profile comments so they would look similar to this. I dont really need Karma and not really sure what feedback is.

Re: [RC3]Profile comments/ Feedback/ Karma (1.6.2)

Posted: Thu Aug 14, 2008 10:55 pm
by kevinroxx
InternetMafia wrote:Now take a look at this picture here.
http://maxedgaming.com/Images/profile/before.jpg

I am looking for something like this. I dont need an xfire box or a mood box and I dont really want all those extra banners. But I AM very interested in how to install profile comments that would look something like this and perhaps have a YouTube video on there somewhere.

I know it would take some modding and skills I dont have, but I am wondering if it is possible to just install the profile comments so they would look similar to this. I dont really need Karma and not really sure what feedback is.
It is possible to do what you want. You would have to edit the following html files:
memberlist_view.html
profile_comments.html
profile_comments_viewall.html

In memberlist_view.html change the place where you would like the comments to be displayed. Than in profile_comments.html and profile_comments_viewall.html delete the content that you do not want to be dispalyed (ie. the rating images, and karma.). Than decide on how big you would like everything.

Re: [RC3]Profile comments/ Feedback/ Karma (1.6.2)

Posted: Thu Aug 14, 2008 11:29 pm
by muggins
My sense of humor would just love to take the floor... :lol:

Re: [RC3]Profile comments/ Feedback/ Karma (1.6.2)

Posted: Fri Aug 15, 2008 12:17 am
by InternetMafia
kevinroxx wrote:
InternetMafia wrote:Now take a look at this picture here.
http://maxedgaming.com/Images/profile/before.jpg

I am looking for something like this. I dont need an xfire box or a mood box and I dont really want all those extra banners. But I AM very interested in how to install profile comments that would look something like this and perhaps have a YouTube video on there somewhere.

I know it would take some modding and skills I dont have, but I am wondering if it is possible to just install the profile comments so they would look similar to this. I dont really need Karma and not really sure what feedback is.
It is possible to do what you want. You would have to edit the following html files:
memberlist_view.html
profile_comments.html
profile_comments_viewall.html

In memberlist_view.html change the place where you would like the comments to be displayed. Than in profile_comments.html and profile_comments_viewall.html delete the content that you do not want to be dispalyed (ie. the rating images, and karma.). Than decide on how big you would like everything.
Ok. Thanks man. i will look into this.

Re: [RC3]Profile comments/ Feedback/ Karma (1.6.2)

Posted: Fri Aug 15, 2008 12:19 am
by InternetMafia
muggins wrote:My sense of humor would just love to take the floor... :lol:

?????/