Re: [RC] Thanks for post by Палыч
Posted: Fri Jun 12, 2009 8:19 am
Hmmm.. sorry for not being able to create image thumbs.
Gone...
Gone...
Perhaps, I did not work with Firebird as DabatasePaulo França Lacerda wrote:should have the column name double-quoted...
Hmmm... This field is already included...Paulo França Lacerda wrote:The PRIMARY KEY should also include the field "POST_ID"
Code: Select all
PRIMARY KEY (post_id , user_id)
Палыч wrote:I can add your language files in the archive?
For sure it's true: I do work with FB exclusively.Палыч wrote:Perhaps, I did not work with Firebird as DabatasePaulo França Lacerda wrote:should have the column name double-quoted...
Sorry for my confusion. I meant all 3 fields should go in the Primary Key, and the SQL Error stops showing up:Палыч wrote:Hmmm... This field is already included...Paulo França Lacerda wrote:The PRIMARY KEY should also include the field "POST_ID"Code: Select all
PRIMARY KEY (post_id , user_id)
Code: Select all
PRIMARY KEY (post_id , POSTER_ID, user_id)
OK. Thanks!Paulo França Lacerda wrote:Of Course! I'd be glad.
OK, correct, thanks!Paulo França Lacerda wrote:For sure it's true: I do work with FB exclusively.
Strange. The combination of fields post_id and user_id is enough for the unique identification of records (because the post_id has only one author - poster_id)Paulo França Lacerda wrote:I meant all 3 fields should go in the Primary Key
Yes, it's correct, but dunno why I was getting an SQL Error related to Primary Key violation.Палыч wrote:Strange. The combination of fields post_id and user_id is enough for the unique identification of records (because the post_id has only one author - poster_id)Paulo França Lacerda wrote:I meant all 3 fields should go in the Primary Key
Code: Select all
CREATE TABLE ATS_THANKS (
POST_ID INTEGER DEFAULT 0 NOT NULL,
POSTER_ID INTEGER DEFAULT 0 NOT NULL,
USER_ID INTEGER DEFAULT 0 NOT NULL);
ALTER TABLE ATS_THANKS
ADD CONSTRAINT CPK_THANKS PRIMARY KEY (USER_ID,POST_ID);
ALTER TABLE phpbb_users
ADD user_allow_thanks_pm SmallInt DEFAULT '0' NOT NULL;
OKPaulo França Lacerda wrote:Infact, just the 2 fields (POST_ID and USER_ID) are enough in the PK.
And as it looks at this memberlist?Paulo França Lacerda wrote:When using prosilver style (dunno about others), the thank list that appears on user's profile are wider than its parent box
Bang! Hehehe... yes, tue bug seems to lie in phpBB code, as the usual memberlist too is wider than its parent. Sorry for the false-alarm.Палыч wrote:And as it looks at this memberlist?Paulo França Lacerda wrote:When using prosilver style (dunno about others), the thank list that appears on user's profile are wider than its parent box
OK, all right.Paulo França Lacerda wrote:Sorry for the false-alarm.
Included in the archive ver 1.2.3.Paulo França Lacerda wrote:Changed translated texts used as hints for the "Do Thank" and "Remove Thank" buttons.
Included in the archive ver 1.2.3.Paulo França Lacerda wrote:) Included the image in the "subsilver2" style and its own folder
1) Well, files must be UTF8 without BOM, but I cannot save in UTF8 without BOM in Windows. Is there any tool for that?Палыч wrote:Your files in WIN-format (must be in UNIX) and have a tag BOM (this is not acceptable).
http://wiki.phpbb.com/Text_EditorsPaulo França Lacerda wrote:Is there any tool for that?
I think about it. But to use the built-in sorting can not be - for that you need to add the fields in the phpbb_users or very heavy code. While I have no solutions.Paulo França Lacerda wrote:This would be very handy when user wants to see who is "best thanked" and who is "best grateful".
Ok, found Notgepad++ (ops... I posted right before reading your advice. THanks.)Paulo França Lacerda wrote:1) Well, files must be UTF8 without BOM, but I cannot save in UTF8 without BOM in Windows. Is there any tool for that?