How to make sql tables to record players kills and give ranks?

[FatPanda]

Hi, how would i make SQL tables so i can show player's rank on my server? And also import that into a webpage (Ik html4 and xml and php) so that people can see their rankings?

This is for a deathmatch type gamemode with 2 teams if your wondering.

Any and all help is appreciated!

[_nonSENSE]

What do you have so far?

[FatPanda]

[QUOTE=_nonSENSE;26455511]What do you have so far?[/QUOTE]

So far i basically have a base gamemode and a website i have made. I have tables setup on a webpage that i want to fill with the username, amount of kills, and kdr. Their rank will also be displayed as a small picture.

EDIT: i also have the rank pictures im going to use. I got them from here --->[url]http://www.us-army-info.com/pages/ranks.html[/url]

[_nonSENSE]

[url=http://www.facepunch.com/threads/933647-Gm_MySql-v1.0-OO-edition.]Download this and get familiar with it (examples are included in the thread).[/url]

Then think about how to rank people; based on what criteria.

[FatPanda]

Well i know how i want to rank them, by experience kinda like MW2 and the COD series. Then i want them to unlock guns basically. with create a class that saves to their steam id.

Anyways, thanks for the help!

[editline]3rd December 2010[/editline]

Ok, i added it to Gmod and how exactly do i use it? Do i use it to create SQL tables ingame or do i need to code them outside of the game?

[FatPanda]

Ok i don't even understand how to use this at all... can someone please help me? add me on steam -- allmustdie96

[Lord Ned]

You're going to need to write a function that runs at the end of the round, loops through all of the players, and writes their K/D ratio to a MySQL database using Gm_MySql.

Look through the Gm_MySql thread, there's probably an example of how to write to a database.

[blown25]

box me

[_nonSENSE]

Except that he wants to access an external database, not the SQLite one.

[blown25]

[QUOTE=_nonSENSE;26463269]Except that he wants to access an external database, not the SQLite one.[/QUOTE]

(bad reader) :(

[FatPanda]

I don't really care how it does it as long as i can show ranks and kdr's on my website. Is this possible and can someone give me an example on how to do it? maybe add me on steam?