newttster

Woot!! And we have a winner!! Thank you so much for that Dj ... works like a dream. sniko ... thank you for all of your time and effort on helping me with this. It is very much appreciated.

*nods* Not getting the error any more. However ... it's still executing where only one of the courses is taken ... when it should only do that when all of them are taken.

Just saw it ... testing it now. Will let you know shortly. :) Getting ... Parse error: syntax error, unexpected T_ELSEIF in /home/danteawa/public_html/index.php on line 145 ... which is line 15 in your code.

Thank you for the quick response, sniko. It does work ... but it is working in the sense that it meets the condition if only one of the courses is done. I want it so that it only executes when ALL the courses are done ... which is why I had the multitude of "Ands" . Any ideas?

I'm sure there is a much better way to do this ... but I can't find it. No matter how I write it out ... it just does not work even though all the statements are correct. What am I doing wrong?   $r2=($db->fetch_row($db->query("SELECT * FROM coursesdone WHERE userid = '{$ir['userid']}'"))); if (($r2['courseid']==1) AND ($r2['courseid']==2) AND ($r2['courseid']==3) AND ($r2['courseid']==4) AND ($r2['courseid']==5) AND ($r2['courseid']==6) AND ($r2['courseid']==7) AND ($r2['courseid']==8) AND ($r2['courseid']==9) AND ($r2['courseid']==10) AND ($r2['courseid']==11) AND ($r2['courseid']==12) AND ($r2['courseid']==13) AND ($r2['courseid']==14) AND ($r2['courseid']==15) AND ($r2['courseid']==16) AND ($r2['courseid']==17) AND ($r2['courseid']==18) AND ($r2['courseid']==19) AND ($r2['courseid']==20) AND ($r2['courseid']==21) AND ($r2['courseid']==22) AND ($r2['courseid']==23) AND ($r2['courseid']==24) AND ($r2['courseid']==25) AND ($r2['courseid']==26) AND ($r2['courseid']==27) AND ($r2['courseid']==28) AND ($r2['courseid']==29) AND ($r2['courseid']==30) AND ($r2['courseid']==31) AND ($r2['courseid']==32) AND ($r2['courseid']==33) AND ($r2['courseid']==34) AND ($r2['courseid']==35) AND ($r2['courseid']==36) AND ($r2['courseid']==37) AND ($r2['courseid']==38) AND ($r2['courseid']==39) AND ($r2['courseid']==40) AND ($r2['courseid']==41) AND ($r2['courseid']==42) AND ($r2['courseid']==43) AND ($r2['courseid']==44) AND ($r2['courseid']==45) AND ($r2['courseid']==46) AND ($r2['courseid']==47) AND ($r2['courseid']==48) AND ($r2['courseid']==49) AND ($r2['courseid']==50) AND ($r2['courseid']==51) AND ($r2['courseid']==52) AND ($r2['courseid']==53) AND ($r2['courseid']==54) AND ($r2['courseid']==55) AND ($r2['courseid']==56) AND ($r2['courseid']==57) AND ($r2['courseid']==58) AND ($r2['courseid']==59) AND ($r2['courseid']==60) AND ($r2['courseid']==61) AND ($r2['courseid']==62) AND ($r2['courseid']==63) AND ($r2['courseid']==64) AND ($r2['courseid']==65) AND ($r2['courseid']==66) AND ($r2['courseid']==67) AND ($r2['courseid']==68) AND ($r2['courseid']==69) AND ($r2['courseid']==70) AND ($r2['courseid']==71) AND ($r2['courseid']==72)) { echo"this"; } else { echo"this"; }

Or ... since version 1 is now free ... use that. No license agreement to worry about.

More often than not ... the members of this forum prefer that you post an amount that you are willing to spend. That way if they are interested in doing the work they will contact you. It also gives you and your possible employee a point to start negotiations. Be sure to ask for references of work they have done. Good luck.

It's possible that on the buyers end that they have restrictions on their card ... maybe they have reached their limit ... perhaps they have a history of chargebacks. *shrugs* I really don't know. It makes no sense to me otherwise.

Are they trying to us a card that is not Visa or Master Card? According to the paypal site it only accepts those two credit cards.

Congratz on your release, Seker. I hope that all goes well for you ... I know you put a lot of man hours into this.

My apologies for not making that clearer ... but yes ... they have to be the same type and hold the same value.

You would need to have an identifier that is the same across all tables. For example ... users.userid to userstats.userid to inventory.inv_userid. That kind of thing.

Something like this"   if ($dpitem==whatever) $given=rand(1,4); { if($given==1) { $gain=rand(10,10 item_add($userid,itemx,$gain); echo"You were just given {$gain} of itemx."; } if($given==2) { $gain=rand(1,50) item_add($userid,itembb,$gain); echo"You were just given a {$gain} of itemb."; } if($given==3) { $gain=rand(10000,50000) $db->query("UPDATE users SET money=money+$gain WHERE userid=$userid"); echo"You were just given ${$gain} money."; } if($given==4) { $gain=rand(100,200) $db->query("UPDATE users SET crystals=crystals+$gain WHERE userid=$userid"); echo"You were just given ${$gain} money."; } }

Thank you very much for that. It works perfectly now. I've bookmarked the page you referenced so that I can avoid this in future. Again ... thanks.

SELECT * FROM [TABLE] ORDER BY RAND() LIMIT 1; Or what ruler said as well.

Okay ... this is the error message that I am getting. QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'release, heal, turns) VALUES ('', '46','1','46','117','kev8','200','200','200'' at line 1 Query was INSERT INTO slaveretrieval (retrieveid, masterid, userid, slaveid, slaveuserid, slavepword, release, heal, turns) VALUES ('', '46','1','46','117','kev8','200','200','200') And here is the code: <?PHP include "globals.php"; $_GET['ID']=abs((int) $_GET['ID']); $now=($db->fetch_row($db->query("SELECT * FROM slavemarket2 WHERE masterid = '{$_GET['ID']}'"))); $t=($db->fetch_row($db->query("SELECT turns FROM `users` WHERE `userid` = '{$now['userid']}' "))); $masteruserid=($now['userid']); $turns=($t['turns']); if ($now['jobstodo']=='Slavealleyruns') { if (!$_GET['ID']) { echo"Invalid input"; } else { $db->query("INSERT INTO slaveretrieval (retrieveid, masterid, userid, slaveid, slaveuserid, slavepword, release, heal, turns) VALUES ('', '{$now['masterid']}','{$now['userid']}','{$now['slaveid']}','{$now['slaveuserid']}','{$now['slavepword']}','{$now['release']}','{$now['heal']}','{$t['turns']}')"); $db->query("UPDATE slavemarket2 SET release=release-{$now['release']}, heal=heal-{$now['heal']} WHERE masterid={$_GET['ID']}"); $db->query("UPDATE users SET turns=turns-{$t['turns']} WHERE userid={$masteruserid}"); echo"You have retrieved {$now['release']} releases, {$now['heal']} heals and {$turns} turns.<br /> <a href='slavemarket.php'>Back to the Slave Market</a><br /> <a href='explore.php'>Back to town</a>"; } } $h->endpage(); ?>   Can anyone spot what the hell it is that is wrong with this? I'm sure, that as usual it is probably something obvious, but I'll be damned if I can find it. And yes I have tried it without the quotes around the inserts as well, same error. I just don't get it ... I could see if it weren't picking up any of the values but it gets all the values that it needs to.

I can certainly appreciate what has been said by spud and Guest (formerly known as Prince ... I mean SRB). When time allows I do look at forums and blogs for the latest topics being discussed. Obviously I don't comment on all them ... one ... because I usually have no idea what you are talking about ... which leads me to try and learn about it ... and two ... I don't always have the time to do so. I have recieved some really great help and advice from the "oldtimers" here and even some of the newer folks (Seker). I try to research my errors etc as much as I can ... but not all things will have an exact match for what you are looking for ... hence the posts for help or at the very least ... a hint that points me in the right direction. We all started out as newbs at one point ... it's interesting to watch people grow with each passing week as they learn. I look back at some of the things that I had posted and shake my head, knowing what I know now about certain things ... not that that is anywhere near to what some of you know. I like to think that getting where I am going is due to by and large the assistance I have gotten from folks here. I'd hate to see that disappear.

Having SRB compliment you is one of the better accolades you could get, that's for sure. Not that it means much ... but I have to agree with him. You've certainly shown your stones in regards to taking the bull by the horns. Gratz to you. As far as helping keez ... I can see why it frustrates everyone to help him/her when he/she doesn't seem very willing to help themselves ... but look at it this way ... sooner or later he/she will either get with the program and start learning things for themselves or they will give up. In the long run ... it really doesn't hurt to answer the questions.

I have one thing to say .... GAH!

Check your get_rank function under global_func.php. Remove the space from between the u and the r in labour ... as well as in line 19 in the code from post #11.

Can you explain that further, please. I don't quite understand what you mean by closure.

The home link is your index.php file. Look in your mainmenu.php file to make sure that the < a href tag is set properly.

Open your cpanel ... click on phpMyAdmin ... go to the SQL tab and then type your queries into the text area ... then click go.

Go to your game site ... then type into the address bar the installer. I believe this is how you do it. http://www.yourgamename/nameofinstaller.php If I am wrong on this ... I'm sure someone will post the correct way to do this.

What do you mean ... a home mod? What is it that you want this mod to do?