Remove Ad, Sign Up
Register to Remove Ad
Register to Remove Ad
Remove Ad, Sign Up
Register to Remove Ad
Register to Remove Ad
Register
Signup for Free!
-More Features-
-Far Less Ads-
☷ Vizzed.com Play Retro Games Vizzed Board Video Games Game Music Market Minecraft Radio Widgets Virtual Bible
☷ Register   Login  
All Threads New Posts Contribution Points Your Threads News and Updates User Ranks Active Users
About   Users   Help
Users & Guests Online
On Page: 1
Directory: 128
Entire Site: 4 & 930
04-18-24 09:25 PM

Forum Links

Related Threads
Coming Soon

Thread Information

Views
3,213
Replies
10
Rating
0
Status
CLOSED
Thread
Creator
Davideo7
10-26-07 03:56 PM
Last
Post
Davideo7
10-29-07 09:24 AM
Additional Thread Details
Views: 238
Today: 0
Users: 0 unique

Thread Actions

Order
 

Referencing to level and stats

 

10-26-07 03:56 PM
Davideo7 is Online
Link
| ID: 57520 | 151 Words

Davideo7
Level: 351


POSTS: 5118/45320
POST EXP: 3474068
LVL EXP: 811401669
CP: 191261.6
VIZ: 121500323

Likes: 0  Dislikes: 0
Well the big obstacle I currently see is that we need to be able to reference to the stats directly without having to reference to the level first because the level is what a portion of the stats are based on. This may not make sense but me and Bigbob talked about this before.

In order to reference to the stats, we have to go thru a bunch of equations, the actual stats aren't actually in the database, we need a way to make this better.

Also, maybe we should have an entire table dedicated to linking users with items that they own. This would be nice because it would allow users to be able to own more than 1 item per a category, and users would be able to choose from a drop down menu which item to equip as their held item. This would be nice for accessories also.
Well the big obstacle I currently see is that we need to be able to reference to the stats directly without having to reference to the level first because the level is what a portion of the stats are based on. This may not make sense but me and Bigbob talked about this before.

In order to reference to the stats, we have to go thru a bunch of equations, the actual stats aren't actually in the database, we need a way to make this better.

Also, maybe we should have an entire table dedicated to linking users with items that they own. This would be nice because it would allow users to be able to own more than 1 item per a category, and users would be able to choose from a drop down menu which item to equip as their held item. This would be nice for accessories also.
The Owner
Owner, Developer, Advertiser, etc
Founder, Mod, Investor


Affected by 'Carpal Tunnel Syndrome'

Registered: 12-06-04
Location: Wisconsin
Last Post: 10 hours
Last Active: 51 sec.

10-26-07 10:37 PM
BigBob85 is Offline
Link
| ID: 57524 | 27 Words

BigBob85
Level: 151

POSTS: 4308/6381
POST EXP: 217397
LVL EXP: 42859405
CP: 170.6
VIZ: 49768

Likes: 0  Dislikes: 0
Just on the battle creation (the first one) do the equations and get the stats, then store that as numbers, so we just reference to them numbers.

Just on the battle creation (the first one) do the equations and get the stats, then store that as numbers, so we just reference to them numbers.

Vizzed Elite
Member Of The Year 07


Affected by 'Laziness Syndrome'

Registered: 12-09-04
Location: Melbourne, Australia
Last Post: 1597 days
Last Active: 1231 days

10-27-07 01:18 AM
Davideo7 is Online
Link
| ID: 57528 | 27 Words

Davideo7
Level: 351


POSTS: 5120/45320
POST EXP: 3474068
LVL EXP: 811401669
CP: 191261.6
VIZ: 121500323

Likes: 0  Dislikes: 0
Ok that would make sense than. Also, what do you think of my idea of having the linking between users and items to have it's own field?
Ok that would make sense than. Also, what do you think of my idea of having the linking between users and items to have it's own field?
The Owner
Owner, Developer, Advertiser, etc
Founder, Mod, Investor


Affected by 'Carpal Tunnel Syndrome'

Registered: 12-06-04
Location: Wisconsin
Last Post: 10 hours
Last Active: 51 sec.

10-28-07 12:24 AM
BigBob85 is Offline
Link
| ID: 57541 | 31 Words

BigBob85
Level: 151

POSTS: 4311/6381
POST EXP: 217397
LVL EXP: 42859405
CP: 170.6
VIZ: 49768

Likes: 0  Dislikes: 0
Do you mean you can own heaps of items, weapons, armour and such, its all just in a tool chest or something. Then when you goto battle, you setup your character?
Do you mean you can own heaps of items, weapons, armour and such, its all just in a tool chest or something. Then when you goto battle, you setup your character?
Vizzed Elite
Member Of The Year 07


Affected by 'Laziness Syndrome'

Registered: 12-09-04
Location: Melbourne, Australia
Last Post: 1597 days
Last Active: 1231 days

10-28-07 01:07 AM
Davideo7 is Online
Link
| ID: 57545 | 45 Words

Davideo7
Level: 351


POSTS: 5126/45320
POST EXP: 3474068
LVL EXP: 811401669
CP: 191261.6
VIZ: 121500323

Likes: 0  Dislikes: 0
Sort of yeah. Rather, you just go to the itemshop and choose which items you want to have be equiped but can own multiple swords, shields, etc. I think it's just more rewarding to be able to own more than 1 item per a category.
Sort of yeah. Rather, you just go to the itemshop and choose which items you want to have be equiped but can own multiple swords, shields, etc. I think it's just more rewarding to be able to own more than 1 item per a category.
The Owner
Owner, Developer, Advertiser, etc
Founder, Mod, Investor


Affected by 'Carpal Tunnel Syndrome'

Registered: 12-06-04
Location: Wisconsin
Last Post: 10 hours
Last Active: 51 sec.

10-28-07 04:14 AM
BigBob85 is Offline
Link
| ID: 57549 | 19 Words

BigBob85
Level: 151

POSTS: 4315/6381
POST EXP: 217397
LVL EXP: 42859405
CP: 170.6
VIZ: 49768

Likes: 0  Dislikes: 0
Its more realistic to have multiple items. But only equip one set at once. Is that what you mean/want?
Its more realistic to have multiple items. But only equip one set at once. Is that what you mean/want?
Vizzed Elite
Member Of The Year 07


Affected by 'Laziness Syndrome'

Registered: 12-09-04
Location: Melbourne, Australia
Last Post: 1597 days
Last Active: 1231 days

10-28-07 12:54 PM
Davideo7 is Online
Link
| ID: 57552 | 5 Words

Davideo7
Level: 351


POSTS: 5128/45320
POST EXP: 3474068
LVL EXP: 811401669
CP: 191261.6
VIZ: 121500323

Likes: 0  Dislikes: 0
That's exactly what I mean.
That's exactly what I mean.
The Owner
Owner, Developer, Advertiser, etc
Founder, Mod, Investor


Affected by 'Carpal Tunnel Syndrome'

Registered: 12-06-04
Location: Wisconsin
Last Post: 10 hours
Last Active: 51 sec.

10-28-07 10:03 PM
BigBob85 is Offline
Link
| ID: 57558 | 53 Words

BigBob85
Level: 151

POSTS: 4317/6381
POST EXP: 217397
LVL EXP: 42859405
CP: 170.6
VIZ: 49768

Likes: 0  Dislikes: 0
We should somehow set that up then. Maybe a field called user_items, and its got the same number of colums as items, and same rows as it does user.

User___Item1___Item2___Item3___Item4
1______1_______0_______3_______0
45_____0_______2_______4_______0

So David, you have 1 item 1, and 3 item 3's. I have 2 Item2's and 4 Item4's. That make sence?
We should somehow set that up then. Maybe a field called user_items, and its got the same number of colums as items, and same rows as it does user.

User___Item1___Item2___Item3___Item4
1______1_______0_______3_______0
45_____0_______2_______4_______0

So David, you have 1 item 1, and 3 item 3's. I have 2 Item2's and 4 Item4's. That make sence?
Vizzed Elite
Member Of The Year 07


Affected by 'Laziness Syndrome'

Registered: 12-09-04
Location: Melbourne, Australia
Last Post: 1597 days
Last Active: 1231 days

(edited by BigBob85 on 10-28-07 10:06 PM)    

10-28-07 11:07 PM
Davideo7 is Online
Link
| ID: 57567 | 47 Words

Davideo7
Level: 351


POSTS: 5131/45320
POST EXP: 3474068
LVL EXP: 811401669
CP: 191261.6
VIZ: 121500323

Likes: 0  Dislikes: 0
I think I know what you mean. Wouldn't it be a hassle though making a field for every single item? If it was somehow possible so that it'd automatically make a field when I entered new items into the itemshop than maybe it'd be a good idea.
I think I know what you mean. Wouldn't it be a hassle though making a field for every single item? If it was somehow possible so that it'd automatically make a field when I entered new items into the itemshop than maybe it'd be a good idea.
The Owner
Owner, Developer, Advertiser, etc
Founder, Mod, Investor


Affected by 'Carpal Tunnel Syndrome'

Registered: 12-06-04
Location: Wisconsin
Last Post: 10 hours
Last Active: 51 sec.

10-28-07 11:41 PM
BigBob85 is Offline
Link
| ID: 57570 | 25 Words

BigBob85
Level: 151

POSTS: 4320/6381
POST EXP: 217397
LVL EXP: 42859405
CP: 170.6
VIZ: 49768

Likes: 0  Dislikes: 0
Yeah, it'd all have to be automated updating stuff. Would be awesome .
When I get time (after exams) Ill take a look at it.
Yeah, it'd all have to be automated updating stuff. Would be awesome .
When I get time (after exams) Ill take a look at it.
Vizzed Elite
Member Of The Year 07


Affected by 'Laziness Syndrome'

Registered: 12-09-04
Location: Melbourne, Australia
Last Post: 1597 days
Last Active: 1231 days

10-29-07 09:24 AM
Davideo7 is Online
Link
| ID: 57578 | 27 Words

Davideo7
Level: 351


POSTS: 5136/45320
POST EXP: 3474068
LVL EXP: 811401669
CP: 191261.6
VIZ: 121500323

Likes: 0  Dislikes: 0
Yeah if it were automated that'd be better. Is there any strain at all or any problems if a table has like 50+ fields? Or 100+ fields?
Yeah if it were automated that'd be better. Is there any strain at all or any problems if a table has like 50+ fields? Or 100+ fields?
The Owner
Owner, Developer, Advertiser, etc
Founder, Mod, Investor


Affected by 'Carpal Tunnel Syndrome'

Registered: 12-06-04
Location: Wisconsin
Last Post: 10 hours
Last Active: 51 sec.

Links

Page Comments


This page has no comments

Adblocker detected!

Vizzed.com is very expensive to keep alive! The Ads pay for the servers.

Vizzed has 3 TB worth of games and 1 TB worth of music.  This site is free to use but the ads barely pay for the monthly server fees.  If too many more people use ad block, the site cannot survive.

We prioritize the community over the site profits.  This is why we avoid using annoying (but high paying) ads like most other sites which include popups, obnoxious sounds and animations, malware, and other forms of intrusiveness.  We'll do our part to never resort to these types of ads, please do your part by helping support this site by adding Vizzed.com to your ad blocking whitelist.

×