Subject: "Issue with Daphedee's IMM comments in PBF" Previous topic | Next topic
Printer-friendly copy Email this topic to a friend CF Website
Top General Discussions Gameplay Topic #63665
Show all folders

SaagkriFri 27-May-16 04:51 PM
Member since 17th Jun 2014
801 posts
Click to send email to this author Click to send private message to this author Click to view this author's profile Click to add this author to your buddy list
#63665, "Issue with Daphedee's IMM comments in PBF"
Edited on Fri 27-May-16 04:51 PM

          

Looks like one page got duplicated and there are no entries after ~750 hrs., so maybe one got left out?

  

Alert | IP Printer Friendly copy | Reply | Reply with quote | Top

UmironFri 27-May-16 06:43 PM
Member since 29th May 2017
1497 posts
Click to send email to this author Click to send private message to this author Click to add this author to your buddy list
#63667, "RE: Issue with Daphedee's IMM comments in PBF"
In response to Reply #0


          

They have a "max length", essentially, and hers overflowed that. The same things happens with super deathful long-lived characters at PK wins.

  

Alert | IP Printer Friendly copy | Reply | Reply with quote | Top

    
SertiusFri 27-May-16 10:10 PM
Member since 17th Nov 2008
360 posts
Click to send email to this author Click to send private message to this author Click to view this author's profile Click to add this author to your buddy list
#63669, "Update the data model perhaps?"
In response to Reply #1


          

ALTER TABLE pbf_data MODIFY imm_comment VARCHAR(max);

Or something similar, plus the appropriate changes in code if needed.

(Please disregard if not feasible due to X, I know nothing about your code)

  

Alert | IP Printer Friendly copy | Reply | Reply with quote | Top

        
UmironFri 27-May-16 10:48 PM
Member since 29th May 2017
1497 posts
Click to send email to this author Click to send private message to this author Click to add this author to your buddy list
#63670, "RE: Update the data model perhaps?"
In response to Reply #2


          

That stuff isn't a SQL database. Very little in CF is. The limitation has more to do with the maximum number of bytes various string functions or structures can work with or store. It's been a very low priority to refactor because it's messy code that works fine (per se) with the exception of the length limitation which isn't hit 99.9% of the time.

  

Alert | IP Printer Friendly copy | Reply | Reply with quote | Top

            
KstatidaMon 30-May-16 10:02 AM
Member since 12th Feb 2015
2214 posts
Click to send private message to this author Click to add this author to your buddy list
#63708, "We should really fix that"
In response to Reply #3


          

Both with PK Wins/Deaths and imm comments. Could this perhaps be sponsored in any way? Because it's like I'm paying for PBF and don't get the whole amount of info, which well... sucks

  

Alert | IP Printer Friendly copy | Reply | Reply with quote | Top

            
SaagkriWed 01-Jun-16 01:17 AM
Member since 17th Jun 2014
801 posts
Click to send email to this author Click to send private message to this author Click to view this author's profile Click to add this author to your buddy list
#63726, "RE: Update the data model perhaps?"
In response to Reply #3


          

I understand that it's a rarity. The only problem is that the few PBFs that are hit with this limitation are the ones we want to see the most And they omit the comments from the most interesting parts of the char's life.

A fix could be to duplicate the IMM_comments code and make a IMM_comments2 to store comments after IMM_comments is full. Then publish both.

  

Alert | IP Printer Friendly copy | Reply | Reply with quote | Top

Top General Discussions Gameplay Topic #63665 Previous topic | Next topic