Looks like I've got a new bug for you...

I searched these forums for it and didn't find any previous problems similar to this.

My forum has well over 100,000 members, and for some reason the modifications I had to make in the showthread.php made my members with userid over 100000 show up as guests on the postbit.

Upon uploading a backup of my original showthread.php file, it fixed the problem on it's own.

Help would be appreciated.

[Revan]

The only thing I can think of is that you can try to run the DB Fix, in case some missing userids are lurking there.
If this doesn't solve your problem, then Im afraid you have to wait until the 2nd ETA in my sig is done, because this version will not require actually modifying any code, just adding.

[coRtALoS]

Well it's something new with your recent updates. I ran one of your previous releases of the RPG system just fine (I think it was 2.9 or something).

I'd just really hate to have to wait that long without it.

----Edit----

Another problem I didn't mention earlier was rpg_install.php got this error upon running the installer.

Invalid SQL: UPDATE `rpg_class` SET `type` = '1'
mysql error: Table '(database name).rpg_class' doesn't exist

mysql error number: 1146...

I wasn't aware rpg_class was supposed to be present...

[Revan]

The table rpg_class was created during install, so if you deleted it then you just screwed yourself out of this hack working XD
Try manually readding any tables you have dropped, then uninstalling, then reinstalling.
I see no reason why members over 100,000 should show up as guests...

[coRtALoS]

While I was doing this, I never completely installed the hack either. I happened to see what had happened after doing newthread.php, newreply.php, showthread.php, and showpost.php during a short break, and tried fixing it before continuing on.

Also, could you please just copy me the list of all the fields for the rpg_class table? I copied the classes over from the rpg_classm table on my older version of the RPG, but not sure if you made any modifications to that.

[Revan]

I did, but you can just pick it out from the /install/rpg_mysql-schema.php
In v3 I merged the classm and classf tables

[coRtALoS]

I'm thinking now maybe it's something to do with this person's userid (107752)? I haven't seen this happen to anyone else now that I've had a chance to look around.

Attached are screenshots of before and after I upload the modified showthread.php doing only the modifications you call for in your .txt file. Also, here is a link to that thread if you'd like to see for yourself.
http://www.battleforums.com/showthread.php?t=90789

I've manually added, updated, and verified all of my tables... any ideas?

I suppose if this doesn't happen on a large-scale, I could always merge his posts into a new useraccount and see if it happens again.

[Revan]

You have to check if this is happening to users newer than his userID.
I have a somewhat similar problem on my live board actually, it absolutely REFUSES to fetch the RPG Name of newer members.
Actually, now that I went to check this out for myself, this problem seems to have gone away on its own...
*ahem* anyways
You could do that userid check (with a modded showthread obviously), then if it does not happen, verify this by posting some with a temp account you create, and if this still is not slammed by the problem, merge the two into the new userid.
Hassle, but stuff like this is impossible to detect and remotely fix

[coRtALoS]

Yeah, not happening to new registrations. Thanks for the help so far Revan. I'm going to try finishing this install up and see what happens. Wish I could give you an e-blowjob to thank you for the support so far.

I'll be sure to pis- let you know if I have any more problems.

Some beautiful modifications I see you've made since the last version though!

[Revan]

Originally Posted by coRtALoS

Wish I could give you an e-blowjob to thank you for the support so far.

Since I don't know if your a girl or not, I would be willing to settle for some cash via paypal j\k

Originally Posted by coRtALoS

Some beautiful modifications I see you've made since the last version though!

Thanks
I know the templates still look like something the cat killed and dragged home through the mud, but I just recently learned how to do templates the vBised way, so for the next update after Final, I will have the templates fixed up

//peace