RPG Tools

[Ninja Kitten]

Is anyone familiar with this mod? I have a few questions and one error.

-My current test forum with the mod installed is located at http://eternalterra.com/phpBB3/.
-I'm running phpbb 3.0.7-PL1 as recommended per the mod.
-I'm using the mod version RPG Tools 2.0.7, downloaded from the Oxpus site (http://phpbb3.oxpus.net/downloads.php?cat=1)

I've modified the files, uploaded the included ones, and ran the install.php file fine - plus refreshed the template and cleared caches.

I'm having an error with the viewtopic.php code insert.
When I attempt to view a topic it says:

SQL ERROR [ mysql4 ]

Unknown table 'r' in field list [1109]

Also, the Battlemod forums feature doesn't seem to be working properly.
I have my character set up with an item and such, and I post a topic and set it for Battlemode via the RPG Tools tab when posting - Then I created a second test account and set up that character to reply to the topic so I again select Battlemode via the RPG tools and reply, but neither characters' stats become modified.
I also notice stats aren't being modified when I post in the forum which I've set up the weather properties for.

Also Im wondering why I just have blank columns on my RPG Items page:


I havn't been able to find any other forums with this mod installed (except the Oxpus demo board which is giving me an error when I try to register) so Im not exactly sure what to expect, but any help would be appreciated! Thank you.

[Danni]

I'm having an error with the viewtopic.php code insert.
I've narrowed it down to this line:
The mod says to insert:

Code: Select all

, r.name AS rpg_charname

In-line after:

Code: Select all

'SELECT'	=> 'u.*, z.friend, z.foe, p.*'

Leaving the final line as so:

Code: Select all

'SELECT'	=> 'u.*, z.friend, z.foe, p.*', r.name AS rpg_charname,

I'm having a LOT of issues with this mod too, but I'm trying the 2.0.6 version, what is for 3.0.7 phpBB. In any ways I think you did it wrong here, the mod says to add the code in-line after

p.*

So the final result would be

'SELECT' => 'u.*, z.friend, z.foe, p.*, r.name AS rpg_charname'

You have to put it before the '. I hope it may help you.

[Ninja Kitten]

Thank you, my mistake.
Though now Im getting a new error when viewing topics lol:

SQL ERROR [ mysql4 ]

Unknown table 'r' in field list [1109]