-
Posts
785 -
Joined
-
Last visited
-
Days Won
79
Content Type
Profiles
Forums
Events
Everything posted by SRB
-
I do too - I have 1 table that I use this on, that I felt was worth the change to be able to use full text, since fulltext searching is pretty much **** hot :D
-
FULLTEXT Search SQL ALTER TABLE `table` ADD FULLTEXT `ft_search` (`game_title`,`game_description`); MySQL to call data (And weight results) SELECT `game_title`, `game_description`, MATCH(`game_name`,`game_description`) AGAINST ('{$search}') AS `score` FROM `support_faq` WHERE MATCH(`game_name`, `game_description`) AGAINST ('{$search}') ORDER BY `score` DESC Using $search to contain your search $search = $_POST['search_term']; // Obviously with some type casting, data checking and whatnot. Note This does not work with the InnoDB Engine, but assuming you use the myISAM type, you'll be fine.
-
You're right. Slight oversight on my part, but alas, I do not have a problem with this, so I can afford to slip here. I LOL'd. At the last company I worked for, I had to cross reference 2 tables. One slightly exceeding 20k while the other was over 1.2 million. Yes, that's a pain in the ass!
-
Would be faster to calculate this at PHP level, than the above: $store = array(); $sql = mysql_query("SELECT * FROM `userstatistics` WHERE `draw` > 0 LIMIT 1"); if (mysql_num_rows($sql) > 0) { while ($user = mysql_fetch_assoc($sql)) { $store[] = $user['userid']; } } shuffle($store); $winner = $store[ mt_rand(0, ($store - 1)) ]; echo 'Winner is: ' . $winner;
-
Taking requests for smaller-moderate mods (Making for free)
SRB replied to Blade Maker's topic in Requests & In Production
So why not just have a 32 player lottery, since the result would be, in theory, the same? No point dressing it up, when the base format is simply a lottery. Players will notice this and stop playing, so the lifespan of this system isn't very long before players don't participate. -
From their site, right now (It will change before we look again) Total payments: $5,630,908.72 Number of purchases: 1,171,711 Average purchase: $4.81
-
Why not take the .net if you lost the .com?
-
So, seems EA have teamed up with Humble Bundle and have launched a game package for charity! If you donate a dollar or more (Yes, a single dollar!) you get the following games: Dead Space 3 - Origin for Windows Dead Space - Origin & Steam for Windows Crysis 2 Maximum Edition - Origin & Steam for Windows Burnout Paradise: The Ultimate Box - Origin & Steam for Windows Medal of Honor - Origin & Steam for Windows Mirror’s Edge - Origin & Steam for Windows Pay any price to receive: The Sims 3 Soundtrack Battlefield 3 Soundtrack But if you donate more than the average so far (Currently only $4.80 or so), you also get: The Sims 3 + Starter Pack - Origin for Windows/Mac Battlefield 3 - Origin for Windows The games are for Origin or Steam, although you decide which you get the key for. They ALL work on Origin, with only 6 or so of them being able to be played on steam, but for $5, who gives a damn if we need to download another program, right? So, without further ado, here are some links: EA Website, informing of working with HB Post about it on HotUKDeals And last but not least, Humble Bundle itself Happy gaming, folks :)
-
Actually, in this case, it does. I've just hard refreshed my page to make it happen again and you will now see 3 images. 1. Fresh page load, plain text password (I edited the field to be my actual password) 2. The error for log in 3. Same page as 2, but on the login, which is now a password field and hidden, and allows log in. [ATTACH=CONFIG]1121[/ATTACH] [ATTACH=CONFIG]1122[/ATTACH] [ATTACH=CONFIG]1123[/ATTACH]
-
Under Arms Something smells funny here...
-
I stand by my original statement:
-
I'll come monitor mail for you, if you like ;)
-
All this vouching... wish vouches got me laid :D EDIT: I didn't mean that, having a woman and all...
-
I just TeamViewed to my home computer, downloaded it and had a look over a couple files - fairly straight forward indeed. Feel free to PM me with requirements. Note To anybody curious why I used teamviewer: It's because I'm visiting family and limited to a crappy mac (Hate these things!), so use that so I can open in the software I use on my own systems. Ingenius, right?
-
I think your code examples on these forums say enough about your work, so jumping on the post of someone who can write solid, clean code, probably isn't the best method to attempting to pilfer work. There is a button up top for you to create your own thread though. It is blue and has "+ Post New Thread" on it. To save you some time, just click here I don't have any experience with GRPG, but then I am not an MCCODE programmer, so shouldn't be an issue. Sure if I can pick up a blog system and work it out, then this shouldn't be an issue. Is GRPG free or paid? Where is the code buyable/downloadable from, so I can see the underlying code? That or an index.php (Home link in game) uploaded somewhere, so I can check what variables contains the player data, what includes are done etc. Aww, how sweet *hugs* :D
-
You mean 'wrath', right? :D
-
I'm with !Angel on this one. I prefer to work alone on most projects and very few people can come in on my work, so someone that I don't know would have no chance of joining in on my work. Somebody sounds a little bitter, to be honest.
-
People were mean to you? Maybe it is because you appear to be a self-righteous, selfish mammoth of a bellend?
-
May download when I get home and have a look :)
-
Throw it in the check_level function?
-
I'll write one and add it within a couple hours. The ones here... well, LOL!
-
Wouldn't it be great to be able to stop having to do 6 calls to get 6 sets of time restraints? *cough*
-
I guess the sarcasm was missed in reference to the mis-spelling of "Captcha"