- when i try to edit an item from the itemshop admin like the price or something... i get this error.


Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: UPDATE items_user SET item4='', points4='0', description4='', icon4='' WHERE itid4=71
mysql error: Unknown column 'itid4' in 'where clause'

mysql error number: 1054

Date: Saturday 22nd of March 2003 02:14:58 PM
Script: http://xlash.org/forums/forums/admin/itemadmin.php
Referer: http://xlash.org/forums/admin/itemadmin.php?action=edit


- for a personal item shop... there is no option to add your own icons..

- when you add categories to the itemshop. it don't show on the main itemshop page.

When this hack is bug free I have made about 50 battle scenes.
They are top of the range and I can pics if requested.
I have also tweaked the templates an aweful lot.
If anyone is interested just post, and if you like what u see bitsys then I will glady give you everything so you can add it to the hack.
I am not good at all the tech stuff but I can at least help with what I have made.

Hey man, that's great. I was just thinking that it could use more battle scenes. I'll be looking forward to the official release of this hack.

Ya post your custom stuff.

You just buy magic spells. You can't "learn" them, per se.

What is the exact error?

What does the screen look like after you buy an item?

What is the structure of your items_user table?

User's cannot upload their own pictures.

Did you go to Edit Item Types and assign the items a particular class type?

If a category doesn't have any items in it, then it won't show up.

I will post about 5 of the battle scenes I made to see what people think.
I also have about 150 different item icons.
-Post back soon

so u kind of just add them as items up to the itemshop?


mysql> show columns from items_user;
+--------------+------------------+------+-----+--------------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+--------------------------+-------+
| userid | int(10) unsigned | | PRI | 0 | |
| bankval | int(10) unsigned | | | 0 | |
| btime | int(11) | | | 0 | |
| item0 | char(250) | | | No Item | |
| points0 | int(5) | | | 0 | |
| description0 | char(250) | | | No Description Available | |
| icon0 | char(250) | | | | |
| itid0 | int(11) | | | 0 | |
| item1 | char(250) | | | No Item | |
| points1 | int(5) | | | 0 | |
| description1 | char(250) | | | No Description Available | |
| icon1 | char(250) | | | | |
| itid1 | int(11) | | | 0 | |
| item2 | char(250) | | | No Item | |
| points2 | int(5) | | | 0 | |
| description2 | char(250) | | | No Description Available | |
| icon2 | char(250) | | | | |
| itid2 | int(11) | | | 0 | |
| item3 | char(250) | | | No Item | |
| points3 | int(5) | | | 0 | |
| description3 | char(250) | | | No Description Available | |
| icon3 | char(250) | | | | |
| itid3 | int(11) | | | 0 | |
| item9 | char(250) | | | No Item | |
| points9 | int(5) | | | 0 | |
| description9 | char(250) | | | No Description Available | |
| icon9 | char(250) | | | | |
| itid9 | int(5) | | | 0 | |
+--------------+------------------+------+-----+--------------------------+-------+
28 rows in set (0.00 sec)



ah thx... it worked... now in your current status right at the top of the screen... it do not show the item u just bought from the new category

and again... thanks for replying all the questions =)

Yes.



Which userid is that information from? Is it the same userid that you took the pic with?

yes

slashboy, What are the values of all the IDs from the items_cats table? Also, do you have any presonal itemshops?

I have been able to reproduce the error artificially, so I think I know how to fix it after the error occurs. However, I still have not located the bug that causes the error.

chrisz, I'd love to see some of the items and battle scenes

Bitsys, thanks for your work with the support after... 86 pages ^_^ it must be hard

To Morphine:

Formula for fists is is in battleupdate.php toward the top and is commented. Here is my fist dmg

Been using it for 3 weeks now and seems to be more realistic. I get around the low single digits with this(2-6dmg).


Suggestion: Don't use the personal item shop feature. Its a great addition but is easily exploited and users getting tons of gil. We just turned ours off. Unfortunately no matter what u do, ppl will always find a way to exploit things.

I have some users whose mp levels dont increase and go right back to 50 or so even when i edit their character. I even had them delete their acct and sign up again and still same results.

Anybody else have this?

Otherwise I got things running pretty good. We have had a good 6,000 battles plus and is heavily used.

Anyone having problems like this(4rth item down):
https://vborg.vbsupport.ru/attachmen...&postid=371609

you need to check your item catogory Type Number, and make sure it matches the type ID of generic or what ever you made it.

Thats how i fixed mine.

I figured out how to make it so when you create ur RPG charcter you cant edit them ^^.
I will tweak the idea and double check it then post back (host troubles).
As for the battle scenes and stuff when my host fixes my FTP then I can get them.
Sorry for the delay.

ok my FTP is fixed and I will post some of the battle scenes and so on.

mysql> show columns from items_cats;
+----------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | | PRI | NULL | auto_increment |
| name | char(50) | | | | |
| description | char(250) | | | 0 | |
| catorder | int(2) | | | 0 | |
| type | tinyint(4) | | | 0 | |
| ownerid | int(11) | | | 0 | |
| sold | int(11) | | | 0 | |
| profit | int(11) | | | 0 | |
| battletype | int(10) | | | 0 | |
| itemonofforder | int(3) | | | 0 | |
+----------------+------------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)

yes i have a few personal item shops.... i think thats the problem, coz after i removed the personal itemshops.. everything seems fine..

Ok everyone I will post five of my battle scenes.

Number One:
I edited the default one here and made it a night version.
http://ffsaiyans.xeko.net/forum/imag...cene_night.gif

Number Two:
http://ffsaiyans.xeko.net/forum/images/floatingship.gif

Number Three:
http://ffsaiyans.xeko.net/forum/images/undeadtomb.gif

I have night and day versions of most of them and here is an example.

Number Four:
Day version-
http://ffsaiyans.xeko.net/forum/imag...tainplains.gif

Number Five:
Night version-
http://ffsaiyans.xeko.net/forum/imag...ains_night.gif


Ok they are 5 of about 50, comments are welcome.
And Bitsys if you like them then pm me I will be glad to give them to you as a donation toward the hack.

Wow, I'm loving them. I'll check back later in hopes of more links to your scenes. :)

lol I might post more.
I am currently working on some more. :)

Those are the column definitions. I need the value of the id column of all the rows. The query would be something like "SELECT id FROM items_cats". Do you have phpmyadmin?

yes i have...

yay!!
Bitsys pm'd me and I will be adding my scenes into the hack :D
I will about 20 for now, and maybe later some more.
Any extras I make I will use for my forum (If I gave him all of them then my forum wont be unique would it?)

Go to it. Make sure you select the correct database in the left frame. Find the table called items_user in the left frame. Click on the table name. It should show the structure of the table. Click "Browse". It should show several rows of information. Copy the values located in the 'id' column and paste them here.

Bitsys how is the next version going?
I guess it will be bug fixes and such?

nice scenes. i like it alot.

l8er
sonic

Nice work chrisz! I like what I see ;)

Ok bitsys has the maps and will be adding them.
I hope you all enjoy them :)

I know I will! I just hope the official release is soon... but I can be patient for perfection. :D

there is no such column... i got

userid bankval btime item0 points0 description0 icon0 itid0 item1 points1 description1 icon1 itid1 item2 points2 description2 icon2 itid2

this is mainly it... of course there more.. untill 20

just to make sure... i login to phpmyadmin as root, select the database i installed vbb, select the database items_users and click browse rite?

Oops, my mistake. I meant to say the items_cats table. I have been using both a lot recenlty and I usually end up typing the wrong one. Sorry!

nvm its ok....

id 1 2 3 11 12 14 13 16 17 18 19 20 22

this is it

bitsys i found new bugs when create new battle if you put negative infront money like this (-1546154854$) end of battle will give to winner milions $$$ how can i fix this

read the last 5 pages it is in there somewhere

i cant find it chrisz can you give me link

ok gimme a sec

<a href="https://vborg.vbsupport.ru/showthread.php?postid=366807#post366807" target="_blank">https://vborg.vbsupport.ru/showt...807#post366807</a>
Quote 3 and 4

thx chrisz i fixed wager problems

kool, glad to help

Ok, I am still not sure what the problem is, but another person is having the same problem. Once I fix the problem on their board, I can release an update to fix it everywhere, so hang in tight until I get it figured out.