|
|
 #2 (permalink) Thu Mar 26, 2009 15:45 pm Why some of my posts do not have my signature attached? |
|
|
Hello Milanya,
A special script controls the status of the signature. Execution of this program follows every 10 minutes automatically. In the period of 10 minutes your signature can be unavailable for views.
Best regards
Slava |
|
Slava
Programmer and Co-founder
Joined: 27 Sep 2003
Posts: 294
Location: EU
|
|
| #3 (permalink) Thu Mar 26, 2009 16:00 pm Why some of my posts do not have my signature attached? |
|
|
I cannot say that I understand the answer. It is too technical. Do you have a lay explanation (для тех, кто в танке)?
_________________
con·text - The part of a text or statement that surrounds a particular word or passage and determines its meaning. |
|
 Milanya
I'm here quite often ;-)
Joined: 29 Dec 2008
Posts: 841
Location: Texas, USA (at present)
|
 |
| #4 (permalink) Thu Mar 26, 2009 16:28 pm Why some of my posts do not have my signature attached? |
|
|
Ok. If you don't see the signature immediately after you post your message -- don't worry. Maximum in 10 minutes it must appear on the page under your posting.
(Нужно немножко подождать и Ваша подпись обязательно появится  ) |
|
Slava
Programmer and Co-founder
Joined: 27 Sep 2003
Posts: 294
Location: EU
|
|
| #5 (permalink) Thu Mar 26, 2009 19:07 pm Why some of my posts do not have my signature attached? |
|
|
Thank you for so understandable an explanation. (что сделает - появится, мягкий знак не нужен, что сделать — появиться, мягкий знак нужен).
_________________
con·text - The part of a text or statement that surrounds a particular word or passage and determines its meaning. |
|
Milanya
I'm here quite often ;-)
Joined: 29 Dec 2008
Posts: 841
Location: Texas, USA (at present)
|
|
| #6 (permalink) Fri Mar 27, 2009 2:43 am Why some of my posts do not have my signature attached? |
|
|
You use "cron" to add signatures!? This seems like it would yield a high CPU load, especially when you could simply perform the step once, just when a comment is posted.
Now I am curious! 
-- David Beroff
FREE English Videos, Private Lessons, and more at http://EnglishWithDavid.com !! |
|
English With David
You can meet me at english-test.net
Joined: 09 Mar 2009
Posts: 99
Location: Bethlehem, PA, USA
|
|
| #7 (permalink) Fri Mar 27, 2009 9:45 am Why some of my posts do not have my signature attached? |
|
|
2 Milanya: Now we need a subforum for Russian language. Sorry for this mistake "появится".
2 David:
You are correct (cronjob every 10 min.). Before I have tested my PHP script and MySql queries: Execution time is short (good for a server).
Best regards
Slava |
|
Slava
Programmer and Co-founder
Joined: 27 Sep 2003
Posts: 294
Location: EU
|
|
|
English With David
You can meet me at english-test.net
Joined: 09 Mar 2009
Posts: 99
Location: Bethlehem, PA, USA
|
|
| #9 (permalink) Fri Mar 27, 2009 10:32 am Why some of my posts do not have my signature attached? |
|
|
| Code: |
$query = "SELECT user_id FROM usr_web1_2.phpbb_users WHERE user_sig!='' AND user_attachsig>0";
$result = @mysql_query($query);
$treff = @mysql_num_rows($result);
for($k=0; $k<$treff; $k++){
$DS = @mysql_fetch_assoc($result);
$query2 = "UPDATE usr_web1_2.phpbb_posts SET enable_sig=1 WHERE poster_id=".$DS['user_id']." AND enable_sig=0";
@mysql_query($query2) or die($query2);
} |
|
|
Slava
Programmer and Co-founder
Joined: 27 Sep 2003
Posts: 294
Location: EU
|
|
| #10 (permalink) Fri Mar 27, 2009 11:31 am Why some of my posts do not have my signature attached? |
|
|
| Slava wrote: |
| Code: |
$query = "SELECT user_id FROM usr_web1_2.phpbb_users WHERE user_sig!='' AND user_attachsig>0";
$result = @mysql_query($query);
$treff = @mysql_num_rows($result);
for($k=0; $k<$treff; $k++){
$DS = @mysql_fetch_assoc($result);
$query2 = "UPDATE usr_web1_2.phpbb_posts SET enable_sig=1 WHERE poster_id=".$DS['user_id']." AND enable_sig=0";
@mysql_query($query2) or die($query2);
} |
|
An interesting approach, Slava; thank you!
1. This means that the day I make my 100'th post, all of my prior posts will now suddenly have two signatures (including the one that I have been adding manually). 
2. The enable_sig bit is actually not necessary. You could actually test user_attachsig/user_sig on-the-fly, as you are displaying the post. There would be no additional computational cost, since you are already fetching the user row for things like the user's location and photograph, and it would eliminate this cron.
-- David Beroff
FREE English Videos, Private Lessons, and more at http://EnglishWithDavid.com !! |
|
English With David
You can meet me at english-test.net
Joined: 09 Mar 2009
Posts: 99
Location: Bethlehem, PA, USA
|
|
| #11 (permalink) Fri Mar 27, 2009 12:10 pm Why some of my posts do not have my signature attached? |
|
|
Many thanks David for your suggestion. What do you think about necessity of signature in a user profile at all?
According to point 1. become we doubling of signatures.
I have an idea to delete this feature (signature) for our users. Am I correct with this? |
|
Slava
Programmer and Co-founder
Joined: 27 Sep 2003
Posts: 294
Location: EU
|
|
| #12 (permalink) Fri Mar 27, 2009 13:33 pm Why some of my posts do not have my signature attached? |
|
|
| Slava wrote: |
Many thanks David for your suggestion. What do you think about necessity of signature in a user profile at all?
According to point 1. become we doubling of signatures.
I have an idea to delete this feature (signature) for our users. Am I correct with this? |
Oh, no, Slava; please don't remove this! I make money every time I sign a post, which is why I take the extra time to put the code in manually on every post!
It would be far better to simply enable this feature for all members, from their very first post, instead of waiting for 100 posts. I'm not entirely sure why the delay was incorporated in the first place.
Thank you!
-- David Beroff
FREE English Videos, Private Lessons, and more at http://EnglishWithDavid.com !! |
|
English With David
You can meet me at english-test.net
Joined: 09 Mar 2009
Posts: 99
Location: Bethlehem, PA, USA
|
|
| #13 (permalink) Fri Mar 27, 2009 14:43 pm Why some of my posts do not have my signature attached? |
|
|
| Slava wrote: |
| 2 Milanya: Now we need a subforum for Russian language. |
I am sorry, I will try to avoid using Russian. There are plenty of forums for Russian students of English that I know of. I am not sure one more is needed. But it is up to you to decide.
_________________
con·text - The part of a text or statement that surrounds a particular word or passage and determines its meaning. |
|
Milanya
I'm here quite often ;-)
Joined: 29 Dec 2008
Posts: 841
Location: Texas, USA (at present)
|
|
| #14 (permalink) Fri Mar 27, 2009 15:16 pm Why some of my posts do not have my signature attached? |
|
|
| Milanya wrote: |
| Slava wrote: |
| 2 Milanya: Now we need a subforum for Russian language. |
I am sorry, I will try to avoid using Russian. There are plenty of forums for Russian students of English that I know of. I am not sure one more is needed. But it is up to you to decide. |
I think he was joking, Milanya.
-- David Beroff
FREE English Videos, Private Lessons, and more at http://EnglishWithDavid.com !! |
|
English With David
You can meet me at english-test.net
Joined: 09 Mar 2009
Posts: 99
Location: Bethlehem, PA, USA
|
|
| #15 (permalink) Fri Mar 27, 2009 15:25 pm Why some of my posts do not have my signature attached? |
|
|
Dear Milanya,
It was joke (невинная шутка! прошу искренне простить меня) |
|
Slava
Programmer and Co-founder
Joined: 27 Sep 2003
Posts: 294
Location: EU
|
|
|
| Congrats! | Another suggestion, General Chat category |
