RPG Integration Hack - Old Support Thread

Nice conversion there mate, lot of work has gone into it so well done and thanks for sharing it

[rinkrat]

AARGH!!! It was going beautifully just like last night then, all the sudden

Invalid SQL: select count(*) as new_posts from post where dateline > '1095576023'
mysql error: Can't open file: 'post.MYI'. (errno: 144)

mysql error number: 1016

This is the same error as last night. Any idea what it is?

[Revan]

This has absolutely NOTHING to do with the RPG
It says so in the SQL, the error is with the New Posts query.

[Vivi Ornitier]

rinkrat: try runnin this query

repair table user

[Hoffi]

Originally Posted by rinkrat

AARGH!!! It was going beautifully just like last night then, all the sudden


Invalid SQL: select count(*) as new_posts from post where dateline > '1095576023'
mysql error: Can't open file: 'post.MYI'. (errno: 144)

mysql error number: 1016



This is the same error as last night. Any idea what it is?

You're Database is dead. The File where the Data fot the Table posts is stored has Problems.
That is really a mess.

Contakt your Server Admin.

[Revan]

Originally Posted by Vivi Ornitier

rinkrat: try runnin this query

repair table user

It should be: REPAIR TABLE `post`;
But if what Hoffi say is true, I doubt SQL can repair its file. Although I have no idea, so give it a shot

[rinkrat]

Yeah that did it! thanks I'm back live and the users are loving this hack

[GamerJunk.net]

PHP Code:

Database error in vBulletin 3.0.3:

Invalid SQL: 
        SELECT
            user.userid,
            user.username,
            user.rpgclass,
            user.element,
            user.rpgrace,
            user.rpgtype AS rpgtype,
            user.alignment,
            user.rpggender,
            user.posts,
            user.maxhp,
            user.maxma,
            user.maxpp,
            user.inbattle,
            user.xp,
            user.ma AS uma,
            user.hp AS uhp,
            user.pp AS upp,
            user.ap AS uap,
            user.uttpoints AS money,
            rpg_battle_options.namefield AS namefield, 
            userfield.*,
            rpg_battle_options.exprate,
            rpg_battle_options.privacy AS battleprivacy,
            rpg_items_user.*,
            rpg_battle_stats.*,
            rpg_rpg_race.name AS rpgracename,
            rpg_rpg_race.alignment AS rpgalignmentname,
            rpg_rpg_classf.name AS fclassname,
            rpg_rpg_classf.folder AS fclassfolder,
            rpg_rpg_classm.name AS mclassname,
            rpg_rpg_classm.folder AS mclassfolder,
            rpg_rpg_element.name AS elename
        FROM rpg_battle_options
            LEFT JOIN user ON user.userid=1
            LEFT JOIN userfield ON userfield.userid=user.userid   
            LEFT JOIN rpg_items_user ON rpg_items_user.userid=user.userid
            LEFT JOIN rpg_battle_stats ON rpg_battle_stats.userid=user.userid
            LEFT JOIN rpg_rpg_classf ON rpg_rpg_classf.id=user.rpgclass
            LEFT JOIN rpg_rpg_classm ON rpg_rpg_classm.id=user.rpgclass
            LEFT JOIN rpg_rpg_element ON rpg_rpg_element.elementid=user.element
            LEFT JOIN rpg_rpg_race ON rpg_rpg_race.raceid=user.rpgrace AND rpg_rpg_race.alignmentid=user.alignment
    
mysql error: Unknown column 'user.uttpoints' in 'field list'

mysql error number: 1054 


I get that error when viewing fpg.php and rpgcp.php

What is wrong?

[Dyntheos]

Originally Posted by Revan

I assume you know what I said that about, so you do it in the SQL for the column of the user select rpg postbit

i cannot find this table, can you be more specific?

[Warlord]

What the hell does fpg.php do? I get:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, scott.alan.williams1@us.army.mil and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Apache/1.3.27 Server at www.neropolis.com Port 80

[Warlord]

Originally Posted by Dyntheos

i cannot find this table, can you be more specific?

In phpMyAdmin click on the table user, scroll down to rpgstats, follwing that row to the right and click on change. Once that screen pops up change the Default value from 1 to 0 and click on save.

All done.

This is of course assuming you have this modification hacked into your postbit. Either way, it'll still set it up so that the default is the drop down menu and not the vertical rpg stats. You may have to hack the dropdown menu into the postbit if you haven't done so already.