Page 1 of 1

Developing Innerclan Ladder (For Game)

Posted: Tue Oct 22, 2002 10:58 am
by Silent-Chaos
Up front, I know only a little PHP... still currently learning it :)

I'm setting out to design a small, innerclan (group) ladder for Quake 3. Really a small ladder, 20 people probably going to be the max. Should be able to Challenge other people to a match, report a loss, sign up, etc; etc; Really just basic things, but also report such information to a webpage. With that said, Im pretty lost where to start. First thing I know I need to have is a login script/account setup area for participants of the ladder. After that, Im pretty lost. Was wondering if anyone might have any suggestions on how I can get a task like this complete yet keep a majority of my sanity. Thanks to any thoughts/opinions.

Posted: Tue Oct 22, 2002 11:20 am
by DeGauss
Plan it out on paper first.

Identify what components are likely to repeat (username for example) and then work out how you would want this information to appear on screen.

If that seems too vague, i'll go a little more indepth.

suggested mysql fields:

Username
Password
Played
Wins
Losses

You can work out the rank by taking how many wins against how many losses against how many played (or something, math isn't my strong point, but logic is).

You're more thank likely going to be using mysql, so you'll need to investigate the following mysql commands:
mysql_connect (including select_db)
mysql_query
mysql_result
mysql_fetch_array

Possible PHP commands you may use would be:
print :wink:
while
for
if
else
elseif

if you're new to PHP, you can pretty much ignore most of the other stuff until you feel comfortable using the bare-bones-basics of program flow and control.

But seriously, plan it out on paper, it makes things a HELL of a lot easier.

Posted: Tue Oct 22, 2002 11:47 am
by Silent-Chaos
DeGauss,
Much appreciate your great reply, again, much appreciated. Sitting in CISCO class right now (ugh) planning this bad boy on paper, hopefully can make this idea happen.