Looking for PHP Coder

[xmathewx75]

Hello, I'm clearly starting a bran new community. Its gonna be called MultiGaming!

I'm clearly looking for a PHP coder that knows well coding with lua, mysql, and PHP.

[B]Why would I be asking for a PHP coder?[/B] Well I need some stuff done.

Add me m_a_t_h_e_w (xmathewx75).

[B]Will need you to make: [/B]

I'm gonna be running a assmod admin menu. And you see I need some kinda donation setter.

So I'm gonna be using SMF forums, and I wanna be able to have my ranks such as VIP, Gold, Admin, Superadmin, Dev, Owner ranks connected with my assmod.

So I want to be able to have people to link there SteamID so there rank works in-game. Clearly gonna try to find out is have VIP and GOld member buyable with SMF payment rank (VIP/Gold). Then there benefits get automatic set from Database and rank.

[bbang]

wait, php and lau does not come together in anyway?

[SCopE5000]

I'm pretty sure you can interface the two.

[faceguydb]

[QUOTE=zzlawlzz;33530295]wait, php and lau does not come together in anyway?[/QUOTE]

Lua <-> MySQL <-> PHP

I am willing to [u]help[/u] you, but I lack time to do it for you.

[kragmars102]

I'll easily be able to do the php, however lua is another story.

[God Of War]

For a long time, I've been thinking about doing a generic stats system, and I may start working on it now. I'll let you know when I finish.

[xmathewx75]

[QUOTE=kragmars102;33532650]I'll easily be able to do the php, however lua is another story.[/QUOTE]

OK, well add me steam. I'm not sure will be a big thing. [url=http://steamcommunity.com/id/m_a_t_h_e_w/]xmathewx75 <-steam[/url]

[QUOTE=God Of War;33533914]For a long time, I've been thinking about doing a generic stats system, and I may start working on it now. I'll let you know when I finish.[/QUOTE]

Sounds very great, please post it here when its done. Please!

[bbang]

[QUOTE=faceguydb;33532641]Lua <-> MySQL <-> PHP[/QUOTE]

that doesn't prove anything but the fact it uses mysql

[jrj996]

[QUOTE=zzlawlzz;33541218]that doesn't prove anything but the fact it uses mysql[/QUOTE]

...
MySQL sends the info needed to display by PHP.

[xomaxhox]

So to clear a few things up as some people seem a little confused, here are the general ways in which the two objectives are completed:

Rank setting between gmod and SMF:

When a player joins the server, a function/functions are ran, usually through the PlayerInitialSpawn hook which then query the smf_users (maybe?) table which has been edited to store the SteamID of each of the forum users in their forum record, by searching for the players SteamID, then selects the SMF rank data from that and pulls it back into lua
This SMF rank is then interpreted, compared with the assmod ranks in a certain way and the player is then assigned that user group

If a rank is changed via assmod in-game, this rank is then converted to the appropriate SMF user rank, lua once again queries the smf_users table via the changed player's SteamID and if found will set the rank of that player to the SMF rank decided by the lua script previously

The stats page requires all lua, MySQL and PHP:

Lua will collect the data from the players individually and input this into a MySQL table (or you can just use the standard DarkRP MySQL support database which inputs money into a users table of some kind)
PHP then is used to access this MySQL table, do calculations to work out which amount is the greatest, select the top 3 users and their amounts then order them in descending order, before writing this data into the tables created in either HTML or (generally) using a for loop on the data and creating a new row in the table for each of the records

Unfortunately I can't help you with this sorry, so much to do, so little time unfortunately, but I have a basic understadning of how it works, so reply if you have a question and I'll hopefully be able to assist :)

[xmathewx75]

[QUOTE=xomaxhox;33541715]So to clear a few things up as some people seem a little confused, here are the general ways in which the two objectives are completed:

Rank setting between gmod and SMF:

[B]When a player joins the server, a function/functions are ran, usually through the PlayerInitialSpawn hook which then query the smf_users (maybe?) table which has been edited to store the SteamID of each of the forum users in their forum record, by searching for the players SteamID, then selects the SMF rank data from that and pulls it back into lua
This SMF rank is then interpreted, compared with the assmod ranks in a certain way and the player is then assigned that user group

If a rank is changed via assmod in-game, this rank is then converted to the appropriate SMF user rank, lua once again queries the smf_users table via the changed player's SteamID and if found will set the rank of that player to the SMF rank decided by the lua script previously
[/B]

The stats page requires all lua, MySQL and PHP:

Lua will collect the data from the players individually and input this into a MySQL table (or you can just use the standard DarkRP MySQL support database which inputs money into a users table of some kind)
PHP then is used to access this MySQL table, do calculations to work out which amount is the greatest, select the top 3 users and their amounts then order them in descending order, before writing this data into the tables created in either HTML or (generally) using a for loop on the data and creating a new row in the table for each of the records

Unfortunately I can't help you with this sorry, so much to do, so little time unfortunately, but I have a basic understadning of how it works, so reply if you have a question and I'll hopefully be able to assist :)[/QUOTE]

Ok what I just bolded is kinda what I mean. But in PERP, theirs a DB that controls money, playtime, geneics, etc.. And I have two donations groups which are called VIP and Gold Member. Now I'm trying to use SMF subscription system where they can buy there rank and it automatically set there rank on forum and game. And then it gives them there money, geneics, etc.. anything benefits they should be given. Now I still want a way for SMF ranks to connect too assmod ranks. Because I don't want like Set Rank on assmod. So trying to figure a way to do this, which I know requires PHP, MySQL, and some Lua. Now the main thing is, I want this to automatically work. For setting a rank like for admin, superadmin, owner, dev, etc... will be set from SMF group management. But like for VIP groups is something I want set automatically so I don't get a bunch of steam emails each day of a donation I need to set. Now For the stats thing, thats what I want like he just said above But like for Top Players Money would be the top 10 then for Top Player Times would be top 20. I'm willing to pay as well (Not big money $10-20). Do please add me on steam, if willing too help me on this.

So I need to have like there SteamID linked into the forums for it too work. So maybe like make a linking system? Where they can press F1 (PERP Help Menu) and make tab called "Account" and they can enter the login and it links there account. Then it shows there current rank, name, etc..

[bbang]

what i mean is that you don't need a knowledge of lua to get data from MySQL.

[xomaxhox]

[QUOTE=zzlawlzz;33547577]what i mean is that you don't need a knowledge of lua to get data from MySQL.[/QUOTE]

Well yes and no to this,

Obviously web based, you do not need to know lua in order to use PHP to access the MySQL database

However, you do need a slight amount of the basis of lua in order to obtain data from a remote MySQL table:
You will need to install a module such as tmysql or MySQL-OO in order for lua to be able to access and query the database
Once installed you would make a lua script to connect to the database, find the SMF ranks etc and set the players to those ranks accordingly
(Etc etc, different scripts to do different things with the database)

So depending on what you want to do, no, you won't need lua if per say, gmod was not involved obviously, although what he wants to do includes the use of gmod via rank settings and privileges and therefore someone will require knowledge of lua to find the MySQL data and use it accordingly

[QUOTE=xmathewx75;33542649]Ok what I just bolded is kinda what I mean. But in PERP, theirs a DB that controls money, playtime, geneics, etc.. And I have two donations groups which are called VIP and Gold Member. Now I'm trying to use SMF subscription system where they can buy there rank and it automatically set there rank on forum and game. And then it gives them there money, geneics, etc.. anything benefits they should be given. Now I still want a way for SMF ranks to connect too assmod ranks. Because I don't want like Set Rank on assmod. So trying to figure a way to do this, which I know requires PHP, MySQL, and some Lua. Now the main thing is, I want this to automatically work. For setting a rank like for admin, superadmin, owner, dev, etc... will be set from SMF group management. But like for VIP groups is something I want set automatically so I don't get a bunch of steam emails each day of a donation I need to set. Now For the stats thing, thats what I want like he just said above But like for Top Players Money would be the top 10 then for Top Player Times would be top 20. I'm willing to pay as well (Not big money $10-20). Do please add me on steam, if willing too help me on this.

So I need to have like there SteamID linked into the forums for it too work. So maybe like make a linking system? Where they can press F1 (PERP Help Menu) and make tab called "Account" and they can enter the login and it links there account. Then it shows there current rank, name, etc..[/QUOTE]

Your best option (and the way many servers such as PERP and OCRP do this), is to, when a player joins your server, run their SteamID through your forum user table (that has user SteamID's in - I'll get to that), and if there is no match, present them with a frame enabling them to create a forum user account. Some checks will be ran to make sure the information is fine etc etc, password hashing/crypting to make sure their password is secure and the same as if they had registered through the forums, then when their account is created, you also put their SteamID in with that user record
If the users SteamID is present in the users table, then the player will recieve their rank data from the forum users table, and all of their PERP information from the PERP database of money etc

When a player purchases a subscription and their rank is changed on the forum, you will tell them that they are required to rejoin the server for the PlayerInitialSpawn to be ran and checked again
A few ways of automatically giving the player their donation benefits would be to either run a check on them each time their rank is set as to whether a file has been created, or they have a certain PlayerData set that shows if they have recieved their benefits or not for that SteamID, if they have then cancel the function and they carry on as usual, if they have not yet got the benefits the file or PData will be set and they will get whatever benefits you want to give them through another lua script

[KmartSqrl]

clearly