vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   RPG Integration Hack (https://vborg.vbsupport.ru/forumdisplay.php?f=102)
-   -   Looks like I've got a new bug for you... (https://vborg.vbsupport.ru/showthread.php?t=78015)

coRtALoS 03-13-2005 01:50 AM

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 03-13-2005 09:10 AM

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 03-13-2005 12:20 PM

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.
Code:

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 03-14-2005 06:50 AM

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 03-15-2005 04:25 AM

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 03-15-2005 05:10 AM

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 03-15-2005 06:32 PM

1 Attachment(s)
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. :p

Revan 03-15-2005 07:20 PM

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... :confused:
*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 :p

coRtALoS 03-15-2005 07:50 PM

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. :p

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 03-15-2005 08:30 PM

Quote:

Originally Posted by coRtALoS
Wish I could give you an e-blowjob to thank you for the support so far. :p

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

Quote:

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

coRtALoS 03-16-2005 02:18 AM

I think this is the last error I'm going to get. Everything else is working smoothly.
Code:

Warning: Invalid argument(s) passed to pow() in /includes/functions_rpg.php on line 590

Warning: Invalid argument(s) passed to pow() in /includes/functions_rpg.php on line 590

Unable to add cookies, header already sent.
File: N/A
Line: 0

Where line 590 has
Code:

                        return pow(log10($experience), $exprate);
It prevents any threads from displaying. Something going on with showthread.php

What would happen if we just left my original file intact and didn't fix this problem? Is it just going to stop something from showing up? Or actually going to affect RPGers?

---EDIT---

Ah ++++. This affects stats from showing up on the postbit, doesn't it?

Lastly, I keep seeing these tables for 'monsters'. I assume this is something that you're still working on? :p

Revan 03-16-2005 05:29 AM

To answer the easiest question first, yes I am working on the Monster Arena.
It is currently 25% complete, with 1/3 files done.
It will also be the first part of the RPG IH that will have 100% vBised templates to work on all styles/browsers [/showoff]

As for the pow() error: Wtbf :confused:
Are you sure you didn't piss about with the query in showthread.php?
The error is derived from this line in /includes/functions_showthread.php:
PHP Code:

        $level fetch_rpg_level($post['xp'], $vboptions['rpg_exprate'], 1); 

Where $post['xp'] seems to be undefined.

coRtALoS 03-27-2005 04:02 AM

Any way to 'define' it manually? I realize remote troubleshooting can be a pain in the ass, but I've messed around with this so much trying to get it to work.

Any possible things I should try looking for to help fix this? What files specifically could be altered that would be causing this error?

Revan 03-27-2005 10:00 AM

The only thing I can say is that it appears like you don't have the "xp" column in your `user`. Because the $posts query does fetch everything from the user table.
Alternatively you can try adding this before the "user.ma AS uma": user.xp AS xp


All times are GMT. The time now is 08:20 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01115 seconds
  • Memory Usage 1,755KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (1)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (14)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete