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?

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

rinkrat: try runnin this query

repair table user

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.

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 ;)

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

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

What is wrong?

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

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

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.

all fixed thx ;)

Not a problem :) Glad I could help.

You either changed uCS's point field to something else than 'uttpoints', or you did not install uCS. :)

You mean seeing as theres no file called 'fpg.php'? :p
If you did a typo and you get this error at 'rpg.php', then your server is misconfigured in some way :)

Heres some pics of that background bug, seems to be a problem with the right side where the Race,Class and Element is listed.
It only does it when there is a class with 2 words and only on the right side.
Hope this helps.

How do I install UCS it should have already installed itself right?

This helps immensely, I will expand the width of this template part and post a hotfix as soon as I find it! :D

No it shouldnt.
Go download uCash/uShop from their own thread :)


EDIT: I finally fixed the alignment stuff for good :D
Redownload the rpg_hotfix_battlescene.txt from the Hotfixes post :)

nice job
it all works just fine
good idea to include a manual

one problem though, in my admincp I got twice the lottery option

Is it possible to make all the stats and everything in the postbit_legacy in a drop down menu? because this really annoys me, it exdents the size of my templates

I guess I should rename the "User Select RPG Postbit" to something a little more descriptive eh... ;)
(Btw in case you didnt get it, this is what you need to install.
Ill make it a bundled feature in v3)


:ermm: okay just remove one of them then lol :p

I placed in the Postbit an Scrollable div Tag. But the Problem is, that only the IE can display it. So i am looking for a good Option to Display it more efficient an smaller.

a question about the future v3, are you doing it Revan ? how is the progress ? I'm almost free now since I stop making new things for my board, so if you need help on HTML template, just drop me a pm.

I do hope this hack grow more public.

If you can, please make changes to the item shop as I said before if you remember.....this is just an idea ;P

Yes I am doing the v3.
The progress is great, just yesterday I fixed 1 major security flaw, and one medium one.
What they are is best remained secret until the new upgrade, seeing as only one reported them and its best that the general public doesnt know so we will get whiners wanting the update right now cos their battles are being pwned ;)
They regard the battle arena and the healing center.

Ill see about those itemshop changes, although I cant remember what they are so itd be good if you could remind me :p

Hi, I just wanted to say that this hack looks great, I hope my users will like it. :)

I've got a problem, though. I've installed it and don't get any error messages--this is good. ;) But I was reading (yes, actually reading!) the manual and got to this spot:

Go back to your forum homepage and make a post in one of the forums. Once this is done, go to the user cp. Click on modify profile. At the bottom, you should see a place to change your class, race, alignment etc. Change each of these to something other than "Unknown". Before clicking the submit changes button, you should make sure that you check the checkbox that says "Update Stats". After this is checked, you can submit the changes. If everything went well, you will see the message "Stats Updated" in the upper left breifly before you are redirected to the user control panel.

The problem is, is that my profile modification ends with "RPG Name", and that's the only RPG related thing in my edit profile area. I've checked the User Profile Field Manager in the Admin panel, double checked the profile.php file and compared it with the installer readme and it's all there.

I'm running vBulletin v3.0.3, and have the Arcade hack installed. Also, sorry if this has been covered, but I couldn't find anything helpful when I searched this thread relating to my topic.

The manuals in this hack were not written by me, and they are hopelessly outdated for now.
I fixed them on my localhost, and they will be updated for the next version :)

Your saying that rpg names dont update properly?

When ever someone tryes to register at my forums since i had this installed i get the following mysql error

Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO vb3_rpg_items_user (userid) VALUES ()
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

any ideas or has anyone else got this and managed to fix it?

As you can see, it has no value to insert.
Make sure you did all the register.php edits correctly, because you are the first to recieve this error (afaik)

The names update properly, however when I try to go to do a test battle, it says:

You are ineligible for battle at this time. Please try updating your stats in the User Control Panel.



My problem is that I have nowhere to update my stats in the User CP. The only thing I can change in relation to the RPG hack in the entire User CP is my RPG Name.

You didnt edit the USERCP_SHELL template then.
Because the 'Update RPG Info' link should appear there.

D'Oh! How embarassing. :nervous: That did it. :)

Is there a way to change the name of the currency from Gil to something else?

Not unless you change everywhere its hardcoded into something else
I might add a $vboptions for it in v3 tho :D

Nice a new RPG hack to use... I may be using this.

I love the hack, it looks awesome!

Unfortunately im getting some blank page errors.

It happens when i go to view a battle, enter a battle.

Same thing occurs through the PM enter link, or if i go to battles.php and type in battle number and password

Also when i go to edit RPG profile in the user cp, i get a database timeout error.

The backend in admin works flawlessly, and much of the rest of it seems to, just these couple issues.

Here are a few screenies attached.

Im not sure if this has been covered elsewhere but i gave up after page 10 lol...this thread is huge..

thanks for the news

let me say it again:

the itemshop should let users to buy multi items for their inventory ( limited in ACP), and they can equip whatever items they want, items should be group to: armor, arm, hamlet, accessories....like items in RPG games

It has been covered. You probs did not import the templates, because they are all there ;)

And the timeout was concluded as an error as a result of how PHP is compiled on the server :)



Inventory and an Auction system is planned :)
Im unsure about the limiting tho, its easy but the point of an inventory would be to let users have alot of items, and sell and equip when they want... :)

yeah, that's it, but please let the admin limit their max items they can have in inventory.
and it's best to mention you that you should make the UCS integration clearer, like if you change the UCS points field the RPG should understand that too because I think there would be many hack uses UCS and not all of them use the default UCS points field

Ye I can let it move around inside the user table, but I dont want to move it out of the user table, as this would add a fookload of queries all over the hack ;)

Only thing I can suggest mate is making the Attacking more random, for example the base hit for a level 1 char is 5, how about figuring out a way to randomise it from 1-5.

I love the rest.

Ive imported them twice and 90% of them work, i cant figure out why i cant seem to view or enter battles

Thats the main battle template, which should display it all...but alas..

or possibly battle arena template

Then I got no idea whatsoever
the only thing I can think about would be this:
Open up the rpg_templates.xml and check that you got all the templates inserted and add those that are lacking if any.

I am having a major meltdown with regards to the itemshop.

Adding items is ok, as is creating new categories and editing categories as well.

However, in the main list of items, where it dispalys all the items and thier buffs, costs etc.. you can then click "update items". When I do, it completely shuts down the whole site.

I can't load any pages, I cannot ftp into the site, and everything dies for an extended period of time. Usually at least 20 minutes.