and one last little question

hotcut — Sat, 13 Jan 2001 10:07:24 +0000

How do I find out the servers date/time? I will need to put that into the database too...
I think that it should be an easy server variable, so it shoudln't be hard to do.

Thanks in advance

~Casper

Secrets Of War:
http://www.secretsofwar.vze.com
if server down:
www15.brinkster.com/secretsofwar

hotcut — Sat, 13 Jan 2001 10:02:24 +0000

I works!

Thanks a lot!

No, I don't program C#, I only program in ASP, and script in javascript...

The game is a game a little like Cashwars, just WAY more advanced, and more fun ;=)
When the game gets up and runnning, you will be abel to win money, and steal them from other people playing the game! (without risk offcourse) I think that its gonna be cool!

~Casper

Yea, the guy next to me is dead... real messy though, I wouldn't like to clean him off my boots...

Mark Hensler — Fri, 12 Jan 2001 18:47:44 +0000

Whatever version of C (C, C++, C#)....

What kind of game is it? I couldn't find any info on the site.

Well, I'm sure about anything right now, because I have no access to a NT server right now. But I'll take a stab at it.

the problem I see is the 'Dim' statement. I don't think that ASP is seeing infoArray as a multi-dimension array [array(1)(2)].
Solutions:
'Dim' it larger than necessary. Like infoArray(100)( [or ideally: infoArray(num_players)(num_stats_per_semicolon)]
OR
Find another way to store the info when we pull it out of the DB
OR
Re-design the DB (messy, but I could reduce size... let me know if you wanna do that)

Let's try the first one. I'm not sure how ASP will handle vars like this in a 'dim' statement, but lets try anyway...

Num_Stats = 8  'numerb of stats per semi-colon
Num_Players = rsRecordSet.RecordCount

dim infoArray(Num_Players)(Num_Stats)
dim i, totalinfoArray

totalinfoArray = split(rsRecordSet("attacklog"), ";") 
for i=0 to UBound(totalinfoArray)
  infoArray(i) = split(totalinfoArray(i), ",")
next

for i=0 to UBound(totalinfoArray)
  'I am writing out the code here.
next

Did you strangle the guy next to you?

hotcut — Fri, 12 Jan 2001 16:00:34 +0000

I can't get it to work!

When I try to run the code, it says that the types mismath!

Here is the code I am using:

dim infoArray, i, totalinfoArray

totalinfoArray = split(rsRecordSet("attacklog"), ";") 
for i=0 to UBound(totalinfoArray)
  infoArray(i) = split(totalinfoArray(i), ",") 'it is in this line it tells me that there is an error
next


for i=0 to UBound(totalinfoArray)

'I am writing out the code here.

next

Do you see any problem with this? The contents of the cell I am getting the data from is:

factory,0,0,0,29,9,lost,hotcut;

Thats it...

I really hope that you can help me with this!

Regards
~Casper

hotcut — Fri, 12 Jan 2001 13:36:20 +0000

I think that you have helped me out again Max! Thanks for that!

To ansver some of YOUR questions:

are you a C programmer??
Do you mean if I program C++?

in the next question you ask me why I only have 1 cell per user. I have more than 12 by now, but this one will be having some special data, which will be of very different size per user.
I am programming an online game ( http://www.secretsofwar.vze.com )so I need to store all information regarding attacks in a database cell. Due to that it is different how much attack info there is on each person, I will need to store the info on a single cell, in order to make it work - I THINK

And... I don't want to make too many cells... Right now there is only 47 players, and the databse allready have a size of more than 5 megabyte...

Back to subj.

I think that you have given me the information I need for now, but I might need some more help later... Keep an eye on this thread

Kind regards

~Casper Bang

Mark Hensler — Thu, 11 Jan 2001 22:24:23 +0000

are you a C programmer??
don't ask why I asked, just popped into my mind when I read your post..

another question, why have you used one cell per user?
and why have you put soo much info in that cell?
(it's just asking for a headache)

moving on.....
you did get the Split() syntax correct
as for the number of elements in an array, use UBound(array_name)

you may want something like this:

totalinfoArray = split(DBcon("informa"), ";") 
count = 0
for i=0 to UBound(totalinfoArray)
  infoArray(i) = split(totalinfoArray(i), ",")
next

'
your info would look like this in the arrays:

given in DB:
text1,text2,text3;text4,text5,text6;text7,text8,text9;text10,text11,text12;

in arrays:
+-----------+--------+--------+--------+
| infoArray | (x)(0) | (x)(1) | (x)(2) |
|    (0)(x) |  text1 |  text2 |  text3 |
|    (1)(x) |  text4 |  text5 |  text6 |
|    (2)(x) |  text7 |  text8 |  text9 |
|    (3)(x) | text10 | text11 | text12 |
+-----------+--------+--------+--------+

'
so...
infoArray(0)(0) = "text1"
infoArray(0)(1) = "text2"
infoArray(2)(2) = "text9"
(just read it like that grid in algebra and geometry, cartesan plain or however its spelled)

(for the table above, UBound(infoArray) will return 3, LBound(infoArray) will return 0)

If I didn't get your question right, just strangle the guy next to you then ask again. Good Luck,