PHP/MYSQL

Posted by Mastor Cmp on April 23, 2007, 10:45 p.m.

Well I just stopped in to ask if anyone here could help me on a bit of a project….when on the main board php/mysql came to.

I thought WOW thats exactly what I need someone with a GREAT KNOWLADGE of PHP and Mysql.

I have been working on an MMORPG called legendz online. I programmed it in a VB source code with a source base from eclipse, heavily modifed of course.

But I want to create a ranking system of the top 50 People….i have a mysql database and i have a broad idea of how it would work…..

HOWEVER- I have a large problem, the account data that is stored in the server is saved as a .ini i was wondering if someone could make a php program that takes the level = "" data of the ini and ranks it by the top 50 people with the highest. I would be willing to part with a paypal account with 12 dollars in it if anyone could build it lOL

Comments

DesertFox 18 years, 10 months ago

There is a wonderful GML PHP/MYSQL example RIGHT on the frontpage.

Mastor Cmp 18 years, 10 months ago

yes but i need someone with enough knowladge to help me with the .ini problem i know a little bit about php but not enough for this, the most ive ever done is about enough logic programming for the gambit system of ff12 lol

KaBob799 18 years, 10 months ago

Ill look into php ini functions, g2g for tonight though =/

Mastor Cmp 18 years, 10 months ago

thanks keep in contact

FireflyX 18 years, 10 months ago

i could have helped you with the PHP/MySQL but i'm busy working on a site. Sorry :(

firestormx 18 years, 10 months ago

What you're going to have to do is use fread and stuff to read the ini file, store the level/mysql row id in a two-dimensional array, sort the array by level, then use the corrisponding row id to pull the information from the mysql database.

It's going to get pretty intensive on your server though, so I HIGHLY recomend you use mysql for this. I say mysql rather than putting it all in .ini files, because mysql processes and sorts faster than php opens files and sorts arrays.

If you absolutely MUST use .ini files, I can take a quick look at creating a basic function to do the sorting. (I won't be able to test it or anything, but you'll get the basic idea of what needs done, and fix/adjust it accordingly)

I'm going to need to see an example of the .ini file though, so that I'll know what row to search for for the level.

KaBob799 18 years, 10 months ago

Yeah, I need to see an example of the ini too.

poultry 18 years, 10 months ago

convert it from INI to MySQL.

KaBob799 18 years, 10 months ago

I could help you convert you from INI to MySQL too.

Mastor Cmp 18 years, 10 months ago

the problem is, when my server stores an accounts data, and also tries to read the account data…it is automaticly saved stored and read as an .ini