How do i make [postusername] show [field1]?

[native son]

Hi, i'm helping run a private clan board and we're trying to get the "Thread Starter" and "Last Post" areas on the threads display and forums display lists to show who posted by rank instead of the username.

we've assigned ranks through custom profile field 1 (we replaced the Bio part with it) and made it so that the members can't change it. Now we're just trying to insert that [field1] into the "Thread Starter" and "Last Post" areas. i looked at the code and i think i'm replacing [postusername] but just replacing it with [field1] doesnt work

any ideas?

thanks in advance!

[Xenon]

hmm, i think theres a hack out, which allows something like that, for customizable usernames in profilefields (account != username then )

don't know how it was called, but give it a try and search

[native son]

ya i tried, i think it was Firefly's method of changing the username into a profilefield, but thats not exactly what i wanted =\ i didnt want to change all usernames into rank....just show the rank on the thread starter and last post areas.

thanks for the look tho

[native son]

^

[native son]

anyone?

[g-force2k2]

open newthread.php

find:

PHP Code:

      $DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($subject))."','".addslashes($postusername)."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','$allowsmilie','$signature','$ipaddress','$iconid','1')"); 


replace with:

PHP Code:

      $DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($subject))."','".addslashes($bbuserinfo[field1])."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','$allowsmilie','$signature','$ipaddress','$iconid','1')"); 


open newreply.php

find:

PHP Code:

          $DB_site->query("UPDATE thread SET lastpost='".time()."',replycount='$replies[replies]',lastposter='".addslashes($postusername)."' WHERE threadid='$threadid'");
        } else {
          $DB_site->query("UPDATE thread SET lastpost='".time()."',replycount=replycount+1,lastposter='".addslashes($bbuserinfo[field1])."' WHERE threadid='$threadid'");
        }
      } 


replace with:

PHP Code:

          $DB_site->query("UPDATE thread SET lastpost='".time()."',replycount='$replies[replies]',lastposter='".addslashes($bbuserinfo[field1])."' WHERE threadid='$threadid'");
        } else {
          $DB_site->query("UPDATE thread SET lastpost='".time()."',replycount=replycount+1,lastposter='".addslashes($postusername)."' WHERE threadid='$threadid'");
        }
      } 


you can try this code... but im not sure if it will effect editing posts because what this code change automatically does is insert the field1 code instead of the username... hope that helps... didn't test it though...regards...

g-force2k2

[Xenon]

g-force: nice idea, but effect will be gone if he update counters....
but it's a good and easy method...

edit: i found out a method to work correct for lastposter and one method to work correct for thread starter, but these are not combinable (at least not with my mysql skills)

[g-force2k2]

regards Xenon always a step ahead of me with thinking but you can always just add a new query to the thread and post tables then and store the field1 data there and then make the following changes in the forumdisplay and forumhome templates or what ever else is necessary that way it'll avoid the update counters

g-force2k2

[Xenon]

yes, that'll do the trick

or you can modify the update-counter file to show fiel1 data there, too

Also a JOIN QUERY in forumdisplay i'd say would be better, but as said, just works for one of the two