sniko

  #ItIsAPublicService.

/Reiterating

Cat Macaulay. Dave Cataulay. Dave Macat. (My personal fav) Thanks for the mention [MENTION=69670]Script47[/MENTION]

I see. It was more of a general question, as I am for his permaban.

How can they prove themselves if they're banned?

CREATE TABLE users ( userid INT(11) NOT NULL auto_increment, raffle_tickets SMALLINT(3) NOT NULL DEFAULT 0, PRIMARY KEY (userid) ); INSERT INTO `users` (userid,raffle_tickets) VALUES (1,1), (2,5), (3,17);   SELECT SUM(`raffle_tickets`) AS total_raffle_tickets FROM `users`   SQLFiddle   $query = $db->query("SELECT SUM(`raffle_tickets`) AS total_raffle_tickets FROM `users`"); $amount = $query->fetch_row(); //Is this correct for the mcc db class? $payment_one = money_formatter($set['payment-one_raffle']*$amount['total_raffle_tickets']);

But the ending season spoiled/ruined the experience for me. They should have ended it differently, IMO.

This is going to be fun.

Okay, assume the set-up is as follows;   CREATE TABLE users ( userid int(11) not null auto_increment, username varchar(50) not null, userlevel smallint(1) not null default 1, level int(11) not null default 1, clans int(11) not null default 0, laston int(11) not null comment 'This should be datetime?', PRIMARY KEY(userid) ); CREATE TABLE clans( clanid int(11) not null auto_increment, clanname varchar(50) not null, PRIMARY KEY(clanid) ); INSERT INTO users (username, clans, laston, level) VALUES ('account1', 1, 1400418911, 2), ('account2', 2, 1400417911, 1), ('account3', 1, 1400418811, 4); INSERT INTO clans (clanname) VALUES ('clan1'), ('clan2');   Then just run this SELECT query; SELECT u.username, u.level, u.laston, c.clanname FROM `users` u INNER JOIN `clans` c ON u.clans = c.clanid ORDER BY u.level DESC LIMIT 5;   Or, if you want to convert the timestamp with the SELECT statement, run; # http://sqlfiddle.com/#!2/c8910/5 SELECT u.username, u.level, FROM_UNIXTIME(u.laston), c.clanname FROM `users` u INNER JOIN `clans` c ON u.clans = c.clanid ORDER BY u.level DESC LIMIT 5;   Or, an even friendlier date conversion; # http://sqlfiddle.com/#!2/c8910/10 SELECT u.username, u.level, CONCAT(FROM_UNIXTIME(u.laston, '%h:%i:%s'), ' hours ago') AS laston, c.clanname FROM `users` u INNER JOIN `clans` c ON u.clans = c.clanid ORDER BY u.level DESC LIMIT 5; SQLFiddle

What is it displaying like at the moment?

Just from a UX perspective - I hate the fact it directs you to a new page to tell you your password/username are incorrect without a backlink. Apart form that, nice design :)

I think a better question would be; What are the fundamentals of a game? - and this isn't limited to browser-based games.   Quests/Storyline "Villains" and "heroes" Player interaction Trading items Messaging "Collaborative/group" attacks? Friends/enemies [*]Mini-games Time-killers Possibly increase player interaction with multiplayer mini games [*]Leader boards Who doesn't like to show off their alpha-ness? [*]Some type of hierarchy of items Super-Rare items Rare items Common items .... Reinforces trading (player interaction)   [*]Of course, much much more. Cosmetics (via micro-transactions?)     So when it all comes down to it, I think interwinding each feature/system into eachother in a way which increases enjoyment, and time-a-player-plays.

Who can't afford $5.00 a month for an awesome VPS setup?

Great design codespot!

Thanks :) Added to the Q&A "design".

You're welcome!   Please can you give more detail? What part isn't working? - please don't be vague and say "all of it" - tell me what system function

NetBeans has a great UI for this, but I personally prefer doing it through the console. If you're running Windows, you can install git bash Basic commands you'll need; git add <filename/wildcard> #Add files to staging area git commit -m <msg> # Add commit message to files git branch -b <branch> # Create new branch based on the branch you're on git checkout <branch> # Checkout into an existing branch git status # See the status of git

I've hired Peter before. His turnaround speed was pretty quick (which didn't reduce the quality of the design either). I recommend him.

Try Ghost. I'm running it on my blog at the moment! It's pretty awesome. You can also deploy a droplet from DigitalOcean with 0.4.2 already installed & configured for you :)

Wait....really?! Yeah, GoDaddy sell them, and Namecheap sell some too. (They're the only two registrars I use, so others may too)

"Instead, it was the purchase of VacationRentals.com in 2007 for a cool $35m" You're a little out thinking £4k/£7k is a lot for a domain :p

Then lock the thread. By locking the thread, you cannot reply before you do lock the thread telling them that the thread is locked, because it's covered in this reply.

What do you mean by we don't have to pay any cash until 2015? Will you transfer the domain to us, and expect the $40 on Feb 15th 2015?

Looks like youve just signed up

But the game is called "last person to post game". That's like saying stuck in the mud is colour naming ;)