Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Ascent [Help] PlayerTools, Vote Reward System ETC

Junior Spellweaver
Joined
Nov 14, 2007
Messages
136
Reaction score
0


They Have PlayerTools and a Vote Reward System. Is Anyone able to tell me where they got it from, or how they did it.

If anyone could help me with this is would be greatly apprecitated !
 
Skilled Illusionist
Joined
Apr 6, 2008
Messages
389
Reaction score
1
And now that I have 2 minutes to spare, I'll tell you the simplest way.

First, make a points category in your database by executing the following query:

Code:
alter table accounts add column sitePoints int(3) not null default 0

That will add a whole column where we're going to store the data.

Next, on your website, you're going to have to make sure you have the ability to login and make sure the page recognizes the accounts. If that's not done, you need to code that (probably PHP or HTML depending on how yours is setup).

Once the login page is created, you'll need to basically make a PHP SQL query to be performed when the user performs a certain action (IE. clicks a voting link). I'm not going to go in detail on how to do that, as there's no time and I really shouldn't have to.

You basically need to have that file connect to the database, grab the amount of points the LOGGED IN account has, and then update that amount with however many points you want to award per-action. So basically, you want these queries executed (with modification to accommodate your PHP files, of course):

Code:
select sitePoints from accounts where username = '______';

You'll have to store that into a variable, which would basically be like:

Code:
$oldpoints = 'select sitePoints from accounts where username = '".POST[$username]."';';

That's assuming the command for the file is "POST" and the variable for $username is what your username is stored into.

After that's done, you'll need to basically update the value:

Code:
$newpoints = $oldpoints + x

Where 'x' is however many points you're giving for it.

Now to actually update the values:

Code:
update table accounts set sitePoints = ."$newpoints". where username = ."POST[$username]".;

Of course, I didn't add how to actually query it via PHP, so you'll have to do that yourself. I'm just trying to give you a little guide on what you have to do.

And please, correct the PHP if it's incorrect syntax, because it's really late and I'm rushing like hell to finish typing this. Got work in 5 hours and I have slept in about 54 hours, so I'm a little bugged-out right now.
 
Back
Top