seanybob

The mod has been updated! The original only supported players from the USA, but this updated version supports USA, UK, Australia, and Canada. To update, either redownload the mod from the link above, or simply replace the file below: zzz_mrwqaff.php <?php //Affiliate ID $affid=1; include "globals.php"; print " <h3>Want To Get A Boost In The Game?</h3>"; print"<table class='table' width=80%>"; print"<tr><th align=center>Offer Type</th><th align=center width=20%>Rewards</th></tr>"; $off3=$db->query("SELECT * FROM zzz_mrwqrewards WHERE offertype='quiz'"); print"<tr><td align=center> [b]Quiz[/b] <font size=1> Take a quiz on a random topic! After answering the questions, pass through several pages of offers. You can just click skip/no on all them if you'd like. Continue until you see your score. </font> If you want to do this one, click on the country you are from: <a href=http://mrwq.com/outaff.php?affuid=$affid&uid={$ir['userid']}&offertype=quiz><font color=green>USA</font></a> | <a href=http://mrwq.com/outaff.php?affuid=$affid&uid={$ir['userid']}&offertype=quiz&country=uk><font color=green>UK</font></a> | <a href=http://mrwq.com/outaff.php?affuid=$affid&uid={$ir['userid']}&offertype=quiz&country=au><font color=green>Australia</font></a> | <a href=http://mrwq.com/outaff.php?affuid=$affid&uid={$ir['userid']}&offertype=quiz&country=ca><font color=green>Canada</font></a> </td><td align=center>"; $totmoney=0; $totcrystals=0; $totitems=""; while($of3=$db->fetch_row($off3)) { $totmoney+=$of3['money']; $totcrystals+=$of3['crystals']; if($of3['itemid']>0) { $iname=$db->fetch_row($db->query("SELECT itmname FROM items WHERE itmid={$of3['itemid']}")); $totitems.="{$iname['itmname']} "; } } if($totmoney>0){$text.="\$$totmoney ";} if($totcrystals>0){$text.="$totcrystals crystals ";} if($totitems){$text.="$totitems ";} print$text; print"</td></tr>"; $text=""; $off2=$db->query("SELECT * FROM zzz_mrwqrewards WHERE offertype='game'"); print"<tr><td align=center> [b]Game[/b] <font size=1> Play a simple, random game! After answering the questions, pass through several pages of offers. You can just click skip/no on all them if you'd like. Continue until you see your score. </font> If you want to do this one, click on the country you are from: <a href=http://mrwq.com/outaff.php?affuid=$affid&uid={$ir['userid']}&offertype=game><font color=green>USA</font></a> | <a href=http://mrwq.com/outaff.php?affuid=$affid&uid={$ir['userid']}&offertype=game&country=uk><font color=green>UK</font></a> | <a href=http://mrwq.com/outaff.php?affuid=$affid&uid={$ir['userid']}&offertype=game&country=au><font color=green>Australia</font></a> | <a href=http://mrwq.com/outaff.php?affuid=$affid&uid={$ir['userid']}&offertype=game&country=ca><font color=green>Canada</font></a> </td><td align=center>"; $totmoney=0; $totcrystals=0; $totitems=""; while($of2=$db->fetch_row($off2)) { $totmoney+=$of2['money']; $totcrystals+=$of2['crystals']; if($of2['itemid']>0) { $iname=$db->fetch_row($db->query("SELECT itmname FROM items WHERE itmid={$of2['itemid']}")); $totitems.="{$iname['itmname']} "; } } if($totmoney>0){$text.="\$$totmoney ";} if($totcrystals>0){$text.="$totcrystals crystals ";} if($totitems){$text.="$totitems ";} print$text; print"</td></tr>"; $text=""; $off1=$db->query("SELECT * FROM zzz_mrwqrewards WHERE offertype='survey'"); print"<tr align=center><td> [b]Survey[/b] <font size=1> Take a survey about yourself! After completing the survey, continue through all their questions/offers (you can click skip/no as much as you want) until you reach the last steps page, where you must click at least 2 silver offers (but don't have to complete them) </font> If you want to do this one, click on the country you are from: <a href=http://mrwq.com/outaff.php?affuid=$affid&uid={$ir['userid']}&offertype=survey><font color=green>USA</font></a> | <a href=http://mrwq.com/outaff.php?affuid=$affid&uid={$ir['userid']}&offertype=survey&country=uk><font color=green>UK</font></a> | <a href=http://mrwq.com/outaff.php?affuid=$affid&uid={$ir['userid']}&offertype=survey&country=au><font color=green>Australia</font></a> | <a href=http://mrwq.com/outaff.php?affuid=$affid&uid={$ir['userid']}&offertype=survey&country=ca><font color=green>Canada</font></a> </td><td align=center>"; $totmoney=0; $totcrystals=0; $totitems=""; while($of1=$db->fetch_row($off1)) { $totmoney+=$of1['money']; $totcrystals+=$of1['crystals']; if($of1['itemid']>0) { $iname=$db->fetch_row($db->query("SELECT itmname FROM items WHERE itmid={$of1['itemid']}")); $totitems.="{$iname['itmname']} "; } } if($totmoney>0){$text.="- \$$totmoney ";} if($totcrystals>0){$text.="- $totcrystals crystals ";} if($totitems){$text.="- $totitems ";} print $text; print"</td></tr>"; print"</table>"; $h->endpage(); ?>   Be sure to update the //Affiliate ID $affid=1; at the top of the file with your own information!

if ($ir['shooting'] == 0) { die ("you have already shot today come back tommorow"); }   That should really be   if ($ir['shooting'] <= 0) { die ("you have already shot today come back tommorow"); }   I mean it may work, but it's just safer to do it this way.

  Thanks mate. Just wanted to add a quick note: Anybody is welcome to install this. It is automatically set up to keep track of your earnings. This adds a second method of making money from your game (in addition to donator packs). It's not a one-time thing either; users can complete something from each category once a day if they desire to, and keep getting the bonuses you offer them. For each time they do successfully, you will earn money.

So you asked for it, and you got it. Several weeks ago, we released the affiliate MrWQ option. With it, you could refer users to and earn money from the site. Several game owners have some decent success with this option, but they just weren't satisfied... I've been asked (by several different owners) to integrate MrWQ with McCodes, so that users never have to leave their site. Thus, that is what we did. Simply run some sql, upload 4 files, and register an account on MrWQ.com (doesn't require admin approval, takes less than a minute) and you are up and running. With this mod, users are given the option to take a quiz, take a survey, or play a quick game and earn in-game bonuses (cash, crystals, or items). For every offer they complete, you earn cash (which you can keep track of on the stats page). Everything is automated - when they complete it, a postback is sent from the advertiser to our server. In turn, we send a postback to your server to the script you uploaded, which rewards the user according to your specifications. An admin panel has been built in as well. Here, just take a look at the screenies: Admin Interface: User Interface: As you can see, it's fairly simple. Moreover, it's free to get started / install! You can see how it works here: http://seanybob.net/mccodesv2 (Just click the EARN link next to crystals) Or just simply download the mod here: http://seanybob.net/mods/download/McCodeMrWQIntegrationMod.zip and follow the instructions in the read me. You'll be set up within 5 minutes.

I've used several companies, but the most reliable (even if it is a bit more expensive) is cafepress. You can register an account there for free and make your t-shirt. If you run into some trouble (their user interface can be a bit, well... sticky) just send me the graphic and I'll pop it up on a shirt for you, no charge. You'll just have to pay the base cafepress price.

You will find the poker mod at this link.

Bertrand, once again you pull exactly what I'm looking for out of thin air. I do have an array of the item in question, so your code is pretty much exactly what I was looking for. I thank you, kind sir. *bows*

Hey all, Had a question regarding the where clause for mysql. How long can it be? Say I wanted to do something like: SELECT * FROM tablename WHERE id=1 or id=7 or id=19... and on and on for, say, 300 conditions (that are essentially random, and cannot be turned into an algorithm) So is there a limit? I imagine there has got to be. Also - can you think of a more efficient way to do this?

Change   require "mysql.php"; global $c; To   require "mysql.php"; global $c; $c=1; I'm just curious what will happen.

RE: on my game i have these errors can anyone help?   Wherever the createhouses page was linked (most like explore.php or header.php) you mis-typed the link. Check it, you'll have appended an 8 accidentally to the end of the url. On your poker page, it looks like you included your headers twice somehow. If you post the first 30 lines of your poker page, I am nearly certain your error will be easily seen to some of the coders here.

I realize Zero already rebutted this fairly effectively, but I thought I'd add my own piece... I agree that background in a c-based language would help tremendously with his understanding php. Php is a 'messy' language, and if you start with something more sophisticated like Java or C++ you'll be forced to develop better coding habits. However, it's hard to know where to start with these strongly-typed languages - if you can find a course to take in some community college or something for computer languages, you'll probably be much better off to do so than trying to learn them yourself. Once you have a c-based language under your belt, everything starts making more sense. You can see php, javascript, perl, whatever code and be able to trace fairly effectively what it does. Alternatively, if you're 12 or don't desire to study a real, strongly-typed computer language, then just search the web for 'free php scripts' and practice setting them up on your server, perhaps converting them to work with the mccode game engine. That'll get you some experience. As for the second part of you post - I had to create a programming language for a college course. That was perhaps one of the single most difficult things I've done in my life. Creating an actual, USEFUL, compiling, original programming language is a work of art. Don't bother if you don't have a dozen different languages under your belt.

RE: Ultimate Mod Package Deal   Interesting post. I was just curious about one thing... Shouldn't people's hunger go away as they eat, and slowly increase as the game progresses? o.0

Several Updates! First - We have implemented an auto-credit feature. Now, when a user completes an offer, they are instantly credited, instead of having to wait for an admin to manually credit them. Secondly - We have added many new offers for the USA. Also, we've added many offers for Canada, UK, Australia, and Norway! We've successfully partnered with several games, and have seen quite a bit of exchange of traffic. Things are looking good! For those who haven't jumped on board this offer yet, I encourage you to check it out ;)

fixed. (Untested)

Yup, he's right. The code you posted above is probably in some function or object that has it's own scope, separate from your main php script. So, at the beginning of this function/object, redeclare the $db variable. function myfunc() { global $db; code here }

$fee=ceil($_POST['deposit']*3/100); if($fee > 30) { $fee=30; } $gain=$_POST['deposit']-$fee; $ir['crystals']+=$gain; $db->query("UPDATE users SET crystals=crystals+$gain, crystals=crystals-{$_POST['deposit']} where userid=$userid"); echo "You hand over {$_POST['deposit']} crystals to be deposited, after the fee is taken ($fee crystals), $gain crystals is added to your account. [b]You now have {$ir['crystals']} in the crystal Bank.[/b] [url='crystalbank.php']> Back[/url]";   You had a couple extra slash marks in there that you didn't need (they are used to escape the $ sign for money, not crystals). However, there are several other problems with your code... I'll let you try to sort them out first and learn from it, but post here again if you have any troubles.

For the most part, most of the offers will be for the USA. I have access to offers for other countries, but they will have to be specifically requested. If you have a game that is full of players from, say, Australia, then when you send me an email for affiliate status let me know what country your gamers are from, and I'll go hunting specifically for offers from that country. However, if your country is not very *large* in the online community (say, Cuba) I might not be able to help you much.

RE: Your site.   Thank you for your generous comments.

No at all, feel free to ask any questions you wish. User's profit somewhere between $0.75 to $1.00 (average). My personal profit depends on many different factors. It's usually somewhere between 10-20% of user profit, or something to that effect. I considered many different options. I decided that this was the best one, as it allows my site to appeal to non-mccode gamers and allows game-owners to gain free advertising to other gamers and virgin users as well. I may be releasing an add-on that will make dp's autocredit when a user cashes out to them on mrwq, depending on interest. It's mine. I stripped the user login system from mccodes, but even that is barely recognizable from all the changes I made. Low enough that they aren't really worth mentioning. The money side of the site is as secure as anything can be, I wrote all the code myself according to my own standards. I use smf for the forums, and even though occassionally some new smf exploit pops up, I'm not too worried about it. If they screw up the forums, I can easily restore it, and it's disconnected from my main system. I believe that in most areas, if you earn anything under a specific amount (maybe something like $500? Can't remember) you don't have to worry about taxes. However, paying the applicable taxes is up to each user depending on where they live. The responsibility is theirs. I cannot say for certain whether they have taxes from the area they reside in that apply or not. No. They are all from 3rd party companies, sent to me by affiliate networks. I don't sell any emails, or anything of that nature.

Apologies, I should have been more specific. You don't want someone to clone mylots, but you want someone to code something very similar (nearly identical) to what mylots currently has in place. With that said, from what I've heard mylots has been pretty profitable for the owner. I'm not interested in this myself, but there could be some money behind this idea, and I wish you the best.

ob_start(); include_once($fetch_url); $page = ob_get_contents(); ob_end_clean(); use your code to get the contents of a page (from google or wherever) then post those contents into a textbox, and then copy/paste it onto this thread. I want to look at that, I bet that's where the error is coming from.

Thank Immortalthug for signing up, looking forwards to doing business with you.

so basically, you want someone to clone mylot? http://www.mylot.com/o/faq/faq6.aspx

So you want to make money on your McCode Game? We can help! We are pleased to bring you MrWQ.com. It has been launched by myself and a partner (a real-life friend of mine who goes by the name '2min'). I am the programmer/promoter, and he's taking care of all the administration. How does a McCode Game make money with MrWQ? The driving force behind McCode profit is donator packs. However, often times you have users that don't have paypal/credit cards, are uncomfortable buying things online, or just plain don't want to take money from their wallet to spend on a game. These are the people MrWQ targets. These people can hop on MrWQ, complete some surveys, take some polls, play some games, take some quizzes, etc - and for each offer they complete, they earn a set amount of cash. Users can then choose to cash out their earnings to paypal/alertpay, or cash out to a donator pack on your specific game. So what would you have to do? If you sign up as an affiliate at MrWQ.com, you will have the ability to add your 'donator pack' to MrWQ's cashout options. What this does is when a user choose to cash out their earnings on MrWQ.com they are presented a choice - to cash out to paypal ($15 minimum) or to cash out to a donator pack on one of our supported games ($5 minimum, usually). Their Donator Pack purchase will then be processed, the money it cost added to your MrWQ account, and a pending 'Grant user donator pack' notice put on your account. We are currently working on adding features to allow affiliates to get emailed for every DP purchased, and allow postback url automatic DP granting. You can cash out to paypal/alertpay from your affiliate account anytime after you have accrued a minimum of $15 in earnings. In addition to getting more donator packs sold on your game, if you use the affiliate link provided to you to link your users to our site, you will earn 25% of all their earnings. So not only will you get the money they spend on donator packs, but for every offer they complete, you get an additional 25% of what they earn. As an added bonus, your game will be visible to many new players from other similar games, as well as people who haven't gotten to heavily into the mmorpg market yet. The one bonus about ALL these people is that they will have money available to them online to spend on your game! So, what you get: -25% of all earnings of the people you refer from your game to our site -Extra users from your game buying donator packs who otherwise wouldn't through our affiliate cash out option -Lots of free exposure of your game to people with the money to spend upgrading! To summarize what you have to do to sign-up: -Register an account at MrWQ.com -send an email to [email protected] with your game name, game url, some basic stats on your game (total users, total # of players that log in daily, whatever stats you have on hand) and your MrWQ username that you signed up with. We will then check out your game, and if everything's legit, grant your account affiliate status. -Login to MrWQ after being granted affiliate status, and input your donator packs. -Add your MrWQ referral link somewhere in your game, and perhaps make an announcement with it. -Profit$$$ It costs you nothing to sign up. In this case, you really have nothing to lose, and everything to gain. I encourage you to sign up and check it out, worst case scenario it will waste 5 minutes of your time - best case, it multiplies your game earnings by a significant amount. Please note, we are only looking for active games. If you have not launched your game yet, or do not have a significant user base, we cannot (at this time) accept your as an affiliate. In the future we may accept all mccode games, but initially we are just looking for some established ones to ally with. As an added bonus for mccode v2 game owners, if you sign up for and use this service, I will give you my Blackjack, Video Poker, Slots, and Roulette mods after you sell 5 donator packs on MrWQ. (Preview these mods here) Comments/Questions? Let's hear them.

That's what my code does... If it doesn't match any ONE of the three, it throws the error inside the if control statement.