EineyEntertainment

Re: How often are these games customized? I'm actually crawling through it and changing the theme to Ancient Greece. That's the reason why I asked! Speaking of which I'm gonna switch Roulette to that horse racing mod. Trust me, I'm not ready to have you guys fully play. I'll post when its ready, and I have a TUN of work still to do. I just focused on the theme first. But back to the question, is what I'm doing uncommon?

How often do you visit a McCodes site, to find that the person actually put NO customization into the game? I'm doing competitive research right now on a game that is close to mine, Samurai of Legend...and I've noticed that the Admin hasn't really changed anything but the Yen symbol...which I give him props for, but there is no customization in any of his scripts. Is that common? Do most people fail to touch the wording? Just seems silly to base your game in Ancient Japan and have the 10 story building saying.

Re: Changing the SQL on items I think I figured it out. If you add the code to the equip weapon /armor that if the item is a specific item, to add a percentage value to the stat you want! I'm gonna try this tonight, and post the code if I figure it out on the free apps :)

Re: Changing the SQL on items Ty Pog :) as for the issue of +stats to the weapons. Its on use, not equip. When you use seth item you'll gain that amount of stats. I'm looking for a way to have the weapon, when equip to give you x% amount of exp until it gets taken off :)

I was wondering if anyone knew the correct way to change the user effects of items. I would like to make an item that redirects the user to a specific site, so they can use a special feature. I was also wondering if anyone knew how to change the SQL to allow bonus stats be placed on an item. Like having a bow that gives _+5% aim (agility) If someone has asked this before, I do apologize, for I did search the forum several times over, and didn't find anything. TY in advance Annie :)

I was wondering if anyone could show me how to change around my battle tent so the NPC's are displayed in order of money earned or level. Here's the code with the changes I've added so far :)   <?php include "globals.php"; print "<h3>Halls of Heros</h3> [b]Welcome to the Halls of Heros! Here you can challenge the Greek Legends for money and fame.[/b] <table width=100% cellspacing=1 class='table'><tr style='background: gray; '><th>Hero's Name</th><th>Level</th><th>Times bested</th><th>Ready To Be Challenged?</th><th>Location</th><th>Money Won</th><th>Challenge</th></tr>"; $q=$db->query("SELECT cb.*,u.*,c.npcid,cy.cityname FROM challengebots cb LEFT JOIN users u ON cb.cb_npcid=u.userid LEFT JOIN challengesbeaten c ON c.npcid=u.userid AND c.userid=$userid LEFT JOIN cities cy ON u.location=cy.cityid"); while($r=$db->fetch_row($q)) { $earn=$r['cb_money']; $v=$r['userid']; $q2=$db->query("SELECT count(*) FROM challengesbeaten WHERE npcid=$userid"); $times=$db->fetch_single($q2); print "<tr><td>{$r[username]}</td><td>{$r['level']}</td><td>$times</td><td>"; if($r['hp'] >= $r['maxhp']/2 and $r['location']==$ir['location'] and !$ir['hospital'] and !$ir['jail'] and !$r['hospital'] and !$r['jail']) { print "<font color=green>Yes</font>"; } else { print "<font color=red>No</font>"; } print "</td><td>{$r['cityname']}</td><td>$earn</td><td>"; if($r['npcid']) { print "[i]Already[/i]"; } else { print "[url='attack.php?ID={$r[']Challenge[/url]"; } print "</td></tr>"; } print "</table>"; $h->endpage(); ?>   Edit: just added the SQL Id's :) it wasn't ordering right in there. TY for looking. Good to close topic or trash if you guys want :)

Re: Exp from leaving people not working   Correct i would do $sql = sprintf("UPDATE `users` SET `exp` = `exp` + '%u' WHERE (`userid` = '%u')", $expgain, $userid); $db->query($sql); If you don't mind explaining for me, since I am new to coding, whats the difference between coding it that way, and coding it $db->query("UPDATE users SET exp=exp+$expgain WHERE userid=$userid"); ? BTW, i'm not asking to be a smartass, nor am I typically so harsh to people. I was just tired and annoyed...and really new to computer programming.

Re: Exp from leaving people not working   Learn to read...I never once asked to inject a % into the SQL. So ty for the help you tried to give...but please go away :)

Re: Exp from leaving people not working Hey smart guy, news for you... you were wrong all together exact code was: $db->query("UPDATE users SET exp=exp+$expgain WHERE userid=$userid"); not the modification that you placed in there. It was missing a SQL injection all along, like I stated originally. There was nothing wrong with the exp given per attack, and the code you programmed was wrong. So I got to experience all this headache from a guy who was wrong the whole time? Wow yeah, fail. TYVM...I know who not to hire when it comes time to buy some mods. Oh and by the way...some people like to take longer by programming things themselves, just to learn something new. So yeah, that's why I didn't hire a coder for this project.

Re: Exp from leaving people not working Ok, just to play you, your change had no effect. The information is not being injected into the SQL still. Now, can someone else please help me with this situation, because this guy seems to know less than I do.

Re: Exp from leaving people not working First, my name is Annie...I'm not a cocky Boi, but an extremely tired girl. Second of all, you pompous twit, Its 4:35 am local for me, and I've been spending several hours trying to figure this out/ Third, you NEED to understand that not everyone completely understands coding here. Some people are new to this. I myself majored in Biology in undergrad, graduate school, and doctorate. I've had limited math in the past seven years. Nor never took a computer science course. Fourth, I posted here for HELP with a situation as a newer member. When dealing with someone who is new, you must not be coy or basic. If you had explained, or sorted my question out sooner, I would not have been short with you. So thank you for taking a look at my question, but please learn some manors Lad. P.S. I never asked for you to spoon feed me with by inserting it into the code. I just wanted to know at what point I was making my mistake at, and what I could do to change that. You reposting the code does nothing for me...

Re: Exp from leaving people not working So in short, you are using my problem to raise your post count... I'm having an error that I cannot figure out, and I'm looking for help. The facts are simple, you can attack another player, but the exp is not sticking. Is there anything wrong with the code? I've received this complaint from my friends that are beta testing. You attack the player, and beat them, it say's you gain X amount experience in percentage...then when you recycle the page to lets say index....you don't gain the EXP. Now if you can please help me out by explaining what in my code I need to change, I would really appreciate it...but please don't continue to question my intelligence by just restating the main issue i'm having

Re: Exp from leaving people not working I attack someone, it states you've gained 3% exp, yet the 3% doesn't apply to the character. I understand the formula, but the values are not being placed into the SQL. I was wondering if anyone can help me code that :)

Re: Exp from leaving people not working I don't think the SQL is getting the information. Any idea how I can code that so the exp gained will be added to the value?

For some reason, when people are attacking, and leaving for exp...they're not getting any EXP. Please help :)   <?php $atkpage=1; include "globals.php"; $_GET['ID']=abs((int) $_GET['ID']); $_SESSION['attacking']=0; $ir['attacking']=0; $db->query("UPDATE users SET attacking=0 WHERE userid=$userid"); $od=$db->query("SELECT * FROM users WHERE userid={$_GET['ID']}"); if($_SESSION['attackwon'] != $_GET['ID']) { die ("Cheaters don't get anywhere."); } if($db->num_rows($od)) { $r=$db->fetch_row($od); $gq=$db->query("SELECT * FROM gangs WHERE gangID={$r['gang']}"); $ga=$db->fetch_row($gq); if($r['hp'] == 1) { print "What a cheater u are."; } else { print "You beat {$r['username']} "; $qe=$r['level']*$r['level']*$r['level']; $expgain=rand($qe/2,$qe); $expperc=(int) ($expgain/$ir['exp_needed']*100); print "and gained $expperc% EXP! You honor {$r['username']} to the gods praying for a safe passage to Hades."; $hosptime=rand(10,20); $db->query("UPDATE users SET hp=1,hospital=$hosptime,hospreason='honored by <a href=\'viewuser.php?u={$userid}\'>{$ir['username']}</a>' WHERE userid={$r['userid']}"); event_add($r['userid'],"[url='viewuser.php?u=$userid']{$ir['username']}[/url] defeated you and honored your death.",$c,'combat'); $atklog=mysql_escape_string($_SESSION['attacklog']); $db->query("INSERT INTO attacklogs VALUES('',$userid,{$_GET['ID']},'won',unix_timestamp(),-2,'$atklog');"); $_SESSION['attackwon']=0; $warq=$db->query("SELECT * FROM gangwars WHERE (warDECLARER={$ir['gang']} AND warDECLARED={$r['gang']}) OR (warDECLARED={$ir['gang']} AND warDECLARER={$r['gang']})"); if ($db->num_rows($warq) > 0) { $war=$db->fetch_row($warq); $db->query("UPDATE gangs SET gangRESPECT=gangRESPECT-1 WHERE gangID={$r['gang']}"); $ga['gangRESPECT']-=1; $db->query("UPDATE gangs SET gangRESPECT=gangRESPECT+1 WHERE gangID={$ir['gang']}"); print " You earnt 1 respect for your gang!"; } //Gang Kill if ($ga['gangRESPECT']<=0 && $r['gang']) { $db->query("UPDATE users SET gang=0 WHERE gang={$r['gang']}"); $db->query("DELETE FROM gangs WHERE gangRESPECT<='0'"); $db->query("DELETE FROM gangwars WHERE warDECLARER={$ga['gangID']} or warDECLARED={$ga['gangID']}"); } $npcs=array( ); $db->query("UPDATE users SET pleft=pleft+1 WHERE userid=$userid",$c); $db->query("UPDATE users SET awon=awon+1 WHERE userid=$userid",$c); $db->query("UPDATE users SET atotal=atotal+1 WHERE userid=$userid",$c); $db->query("UPDATE users SET tattacked=tattacked+1 WHERE userid={$r['userid']}",$c); if($r['user_level']==0) { $q=$db->query("SELECT * FROM challengebots WHERE cb_npcid={$r['userid']}"); if ($db->num_rows($q)) { $cb=$db->fetch_row($q); $qk=$db->query("SELECT * FROM challengesbeaten WHERE userid=$userid AND npcid={$r['userid']}"); if(!$db->num_rows($qk)) { $m=$cb['cb_money']; $db->query("UPDATE users SET money=money+$m WHERE userid=$userid"); print " You gained ?$m for beating the challenge bot {$r['username']}"; $db->query("INSERT INTO challengesbeaten VALUES($userid, {$r['userid']})"); } } } } } else { print "You beat Mr. non-existant!"; } $h->endpage(); ?> <center><script type="text/javascript"><!-- google_ad_client = "pub-2581558253444379"; /* Legends (Game) Add */ google_ad_slot = "5202311777"; google_ad_width = 728; google_ad_height = 90; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script></center>

I apologize in advance, if this topic has already been answered. I ran a forum search to no avail. I was wondering if anyone knew the formula for the exp needed to gain a level. Like at level 1 do you need 100 exp and at level 2 you need 200 exp. Please help, I want to see how much I should configure my crimes for :)