Invalid SQL when Creating Starter Monster

[morizuki]

Random Question

I'm getting an error when i'm creating a starter monster

Database error in vBulletin 4.0.3:

Invalid SQL:
INSERT INTO dbtech_forumon_startermonster
	(title, description, active, parts, colors, stats, speciesid, dateline)
VALUES
	('Warstone', 'A common monster stone', '1', 'a:5:{s:4:\"head\";s:20:\"golem/head/golem.png\";s:8:\"arm_left\";s:24:\"golem/arm_left/golem.png\";s:9:\"leg_right\";s:25:\"golem/leg_right/golem.png\";s:8:\"leg_left\";s:24:\"golem/leg_left/golem.png\";s:9:\"arm_right\";s:25:\"golem/arm_right/golem.png\";}', 'a:6:{s:4:\"head\";s:7:\"#000000\";s:5:\"torso\";s:7:\"#000000\";s:8:\"arm_left\";s:7:\"#000000\";s:9:\"leg_right\";s:7:\"#000000\";s:8:\"leg_left\";s:7:\"#000000\";s:9:\"arm_right\";s:7:\"#000000\";}', 'a:8:{s:2:\"hp\";s:3:\"100\";s:7:\"stamina\";s:2:\"80\";s:5:\"focus\";s:2:\"30\";s:2:\"ap\";s:2:\"30\";s:8:\"strength\";s:1:\"3\";s:12:\"intelligence\";s:1:\"5\";s:9:\"endurance\";s:1:\"4\";s:9:\"willpower\";s:1:\"2\";}', 1, 1288445745);

MySQL Error   : Unknown column 'parts' in 'field list'
Error Number  : 1054
Request Date  : Saturday, October 30th 2010 @ 05:35:45 PM
Error Date    : Saturday, October 30th 2010 @ 05:35:45 PM
Script        : http://***.com/forumonadmin.php?do=startermonster
Referrer      : http://***.com/forumonadmin.php?do=startermonster
IP Address    : ***.96.138.***
Username      : ***
Classname     : vB_Database
MySQL Version : 5.0.91-community

 

[Fillip H.]

I see what's happened, give me 2 mins and I'll have a new download that'll have a workaround

 

[Fillip H.]

Pasting what I wrote on vbulletin.org:


A bug in the installer will have prevented the modification from functioning correctly.

If you receive the following error:
---
MySQL Error : Unknown column 'parts' in 'field list'
---
when creating a new "Starter Monster", please re-download all files, re-upload them to the webserver, then run the following script:
forumonadmin.php?do=finalise&version=103

It will not produce any output, but it will finish instantly so you are safe to close the page once you see the footer of the page.


Sorry for the inconvenience,
Fillip

 

[morizuki]

Yey.. thanks.. it fixed.. but here's another problem


Warning: Division by zero in [path]/forumon.php on line 266

I got this error after I level up on my monster

 

[Fillip H.]

Is the level you reached on your monster also the Maximum Level as per the Species setting?

I have a hotfix ready, I just want to know if I'm right here...

 

[morizuki]

oh that was the problem hahaha.. thanks so much

 

[silpher]

I'm gonna KILL U!

 

[Fillip H.]

oh that was the problem hahaha.. thanks so much

That's not the solution, just the cause
You still hit a bug, thanks for letting me know

Hotfix available shortly ^^

 

[Fillip H.]

Sorted, re-download and re-upload of files will sort it

 

[morizuki]

hmm i don't know if this is another problem..

i tried editting my monster strength, and make it 5000, and the enemy monster uh 50 attack, endurance 50, but, even i attack him twice or something, the attack seems to be 2, 3 or 6 only..

 

[Fillip H.]

Check your Move damage, you may have set a low damage per strength modifier.

 

[morizuki]

oh sorry if i'm asking a dumb question hahaa.. 1st time making my own stats of enemies .. Is there any manual for Forumon RPG? like what is endurance, focus etc... ?

 

[Fillip H.]

No manual as of yet, sorry

Strength / Endurance is Phys. Attack / Phys. Defence.
Intelligence / Willpower is Mag. Attack / Mag. Defence.

 

[morizuki]

oh ok thanks ..

I tried setting the Attack move to 3-500

and I have a 150 strength

the enemy monster have a 50 Endurance

but, when I attack, the hit points is 500+.. so what's the strength for?

 

[Fillip H.]

When you configure a Move, you have an option to set that 1 point of Strength increases the damage done by <x> - <y>. That's explained in the Move Manager

 

[morizuki]

ahh.. okok i get it now.. thanks thanks

ok.. This time the Items.. how can i configure the items to buy? or to loot from the monster? I can't see the settings..

 

[Fillip H.]

You can only configure Loot Tables, do this via
Area Manager -> Edit Monster List -> Edit Loot Table.

 

[Minato]

Not sure If anyone posted this yet.

I'm having a problem when you're trying to do any action in battle scene and end turn.
It does nothing and you have to refresh to see the change, and if you try to click end turn again it will say "It's not your turn"

btw,I'm installing the lite version on my localhost.

 

[morizuki]

ahh.. that's why i can't find it.. thanks again..

What is Focus btw?how does it affect battles?

 

[Fillip H.]

It's a resource cost that's commonly used for Magical abilities, same as Stamina is for Physical.