peterisgb

i dont quite get what you mean there illusions, still an amature at the moment, still learning as of yet

well in the attack php, a sql update is sent to the users, lastwon and last lost in profile it displays like this Last Win: {$r['lastwon']} <br /> Last Lost: {$r['lastlost']} <br /> What is inserted into the database is the id of the user. which is working good.

well it didnt display anything

use the sqls????

ok, well this didnt work, :(

i'm not saying that this mod dont work, yet it doeswork but when a user clicks on the username it dont work

this is still an issue can anyone help?

is there a copy of this mod around still?

but i have done this now this is abit harder for me as i forgot to mention that the stats are not in header on my game, but in an iframe on its own but i did this $exp_needed=(($ir['level']+1.5)*($ir['level']+1.5)*($ir['level']+1)*2.7);   $enperc=(int) ($ir['energy']/$ir['maxenergy']*100); $wiperc=(int) ($ir['will']/$ir['maxwill']*100); $experc=number_format(($ir['exp']/$exp_needed*100), 2); $brperc=(int) ($ir['brave']/$ir['maxbrave']*100); $hpperc=(int) ($ir['hp']/$ir['maxhp']*100); which now works thanks for the help

its in the global_func.php function check_level() { global $db; global $ir,$c,$userid; $ir['exp_needed']= (($ir['level']+1.5)*($ir['level']+1.5)*($ir['level']+1)*2.7); if($ir['exp'] >= $ir['exp_needed']) { $expu=$ir['exp']-$ir['exp_needed']; $ir['level']+=1; $ir['exp']=$expu; $ir['energy']+=2; $ir['brave']+=2; $ir['maxenergy']+=4; $ir['maxbrave']+=4; $ir['hp']+=50; $ir['maxhp']+=50; $ir['levelpoints']+=1; $ir['money']+=500000; $ir['crystals']+=100; $ir['exp_needed']=(int) (($ir['level']+1)*($ir['level']+1)*($ir['level']+1)*2.2); $db->query("UPDATE users SET level=level+1,exp=$expu,energy=energy+2,brave=brave+4,maxenergy=maxenergy+2,maxbrave=maxbrave+4, hp=hp+50,maxhp=maxhp+50,money=money+500000,crystals=crystals+100,levelpoints=levelpoints+1 where userid=$userid"); } }

Warning: Division by zero in /home/ividenco/public_html/playerbars.php on line 81

hello, on the stats bars it show the exp as a 2 digit figure, aka 24% how would i go about changing this to a decimal display eg. 24.56% and pointes in the right direction would be good

well i've tried securing in the past and failed at it due to my lack of knowlegde, i have learnt php quiet wel now but i just cant seem to grasp the aspect of remembering it as its to hard for my brain lol, if you want i can send you a link to the game and give me a estimate.?

How much would some-one charge to completly secure a game as much as it can be?

illisions has a mod on here which allows your game to intrgrate with smf forums, this is a good mod

well its the noise i get from placing my mouse over the menu, its starts ok but then gets to loud and noisey for my liking

yes i'm on mccodes, i went thro trying to fix all the little errors and it just keeps chucking error after error.

thanks but i tried that one, just wouldnt work, mayby my codes differ abit to much for it to work

cant find any

idea, this workd but now doing this affects the links, What shall i do about that. When placing mouse over the username it shows up the correct userid in the viewuser link but when you click this error comes up QUERY ERROR: Unknown column 'N' in 'where clause' Query was SELECT `username` FROM `users` WHERE (`userid` = N/A); how would i go about solving this new problem.

i've updated this abit   $win= "{$r['lastwin']}"; $lost= "{$r['lastlost']}";   Last Win: ID <a href='viewuser.php?u={$r['lastwin']}'><font color='green'><b>$win</b></font><br /></a> Last Lost: ID <a href='viewuser.php?u={$r['lastlost']}'><font color='red'><b>$lost</b></font><br /></a> so anyhelp on displaying username?

to much noise ahhh

hello, I got this problem. i've added in a little mod i made which shows the user id last win and last lost. It displays the users ID but idealy i want it to show the players username instead, how do i go about doing this, Here is what i have to this might help put me in the right direction. Last Win: ID <a href='viewuser.php?u={$r['lastwin']}'><font color='green'>{$r['lastwin']}</font><br /></a> Last Lost: ID <a href='viewuser.php?u={$r['lastlost']}'><font color='red'>{$r['lastlost']}</font><br /></a>

all of these dont work, can anyone help.

ok, i've done fixing the proper copy, but i ask has anyone got the correct images for this mod. the ones i have been given are all wrong. well heres the corrected version.   <?php include "globals.php"; global $db,$ir,$r,$c,$userid,$h; $db->query("UPDATE users SET lastpage='Mailbox' WHERE userid=$userid"); if($ir['mailban']) { die("<font color=red><h3>! ERROR</h3> You have been mail banned for {$ir['mailban']} days. <b>Reason: {$ir['mb_reason']}</font></b>"); } $_GET['ID'] = abs((int) $_GET['ID']); print "<table width=100% class='table' cellspacing='1'> <tr> <td align=center><a href='mailbox.php?action=inbox'><img src='images/indox.gif'></a></td> <td align=center><a href='mailbox.php?action=outbox'><img src='images/sent.gif'></a></td> <td align=center><a href='mailbox.php?action=compose'><img src='images/compose.gif'></a></td> <td align=center><a href='mailbox.php?action=delall'><img src='images/deleteall.gif'></a></td> <td align=center><a href='mailbox.php?action=archive'><img src='images/archiveall.gif'></a></td> <td align=center><a href='contactlist.php'><img src='images/contacts.gif'></a></td> </tr> </table> "; switch($_GET['action']) { case 'inbox': mail_inbox(); break; case 'outbox': mail_outbox(); break; case 'compose': mail_compose(); break; case 'delete': mail_delete(); break; case 'send': mail_send(); break; case 'delall': mail_delall(); break; case 'delall2': mail_delall2(); break; case 'archive': mail_archive(); break; case 'read': mail_view(); break; case 'del': mail_massdel(); break; default: mail_inbox(); break; } function mail_inbox() { global $db,$ir,$c,$userid,$h; print<<<END <SCRIPT><!-- HIDE function setCheckboxes(the_form, do_check) { var elts = (typeof(document.forms[the_form].elements['ID[]']) != 'undefined') ? document.forms[the_form].elements['ID[]'] : (typeof(document.forms[the_form].elements['ID[]']) != 'undefined') ? document.forms[the_form].elements['ID[]'] : document.forms[the_form].elements['ID[]']; var elts_cnt = (typeof(elts.length) != 'undefined') ? elts.length : 0; if (elts_cnt) { for (var i = 0; i < elts_cnt; i++) { elts[i].checked = do_check; } // end for } else { elts.checked = do_check; } // end if... else return true; } // STOP HIDING --></SCRIPT> END; print <<<OUT Only the last 25 messages sent to you are visible. <table width=100% class=table cellspacing="1" border="1"> <tr> <td class="h" align=center>From</td> <td class="h" align=center>Subject</td> <td class="h" align=center>Status</td> <td class="h" align=center>Read</td> <td class="h" align=center>Delete</td> </tr> <form name='masssell' method=post action=mailbox.php?action=del> OUT; $q=$db->query("SELECT m.*,u.* FROM mail m LEFT JOIN users u ON m.mail_from=u.userid WHERE m.mail_to=$userid ORDER BY mail_time DESC LIMIT 25"); $i=0; while($r=$db->fetch_row($q)) { print "<tr class=\"d".($i & 1)."\"><td align=center>"; $i++; if($r['userid']) { print "<a href='viewuser.php?u={$r['userid']}'>{$r['username']}</a> [{$r['userid']}]"; } else { print "SYSTEM"; } $fm=$r['mail_subject']; if($r['mail_read'] == 0) { $status="<font color=red>Unread</font>"; } else { $status="<font color=green>Read</font>"; } print " </td> <td align=center> $fm </td> <td align=center> $status </td> <td align=center> <a href='mailbox.php?action=read&ID={$r['mail_id']}'>Open</a> </td> <td align=center> <a href='mailbox.php?action=delete&ID={$r['mail_id']}'> <img src=images/trash.gif height=20 width=20 > </a> <input type='checkbox' name='del$i' value='yes'> <input type='hidden' name='id$i' value='{$r['mail_id']}'> </td></tr>"; } print<<<END <tr> <td colspan=5 align=center><input name=sellmass type=submit id=sellmass value='Delete selected'><a href=# onClick="setCheckboxes('masssell',true); return false;'> Check All</A> | <a href='#'>Uncheck All</a> </form> </td> </tr> </table> Mail count mixed up? Click <a href='fix.php?fix=1'>Here</a> to fix END; } /* These are off function mail_inbox() { global $db,$ir,$c,$userid,$h; print <<<OUT Only the last 25 messages sent to you are visible. <table width=100% class="table" border="1" cellspacing="1"> <tr> <td class="h" width="30%">From</td> <td class="h" width="70%">Subject/Message</td> </tr> OUT; $q=$db->query("SELECT m.*,u.* FROM mail m LEFT JOIN users u ON m.mail_from=u.userid WHERE m.mail_to=$userid ORDER BY mail_time DESC LIMIT 25"); while($r=$db->fetch_row($q)) { $sent=date('F j, Y, g:i:s a',$r['mail_time']); print "<tr><td>"; if($r['userid']) { print "<a href='viewuser.php?u={$r['userid']}'>{$r['username']}</a> [{$r['userid']}]"; } else { print "SYSTEM"; } $fm=urlencode($r['mail_text']); print <<<EOF </td> <td>{$r['mail_subject']}</td> </tr> <tr> <td>Sent at: {$sent} <br /> <a href='mailbox.php?action=compose&ID={$r['userid']}'>Reply</a> <br /><br /> <a href='mailbox.php?action=delete&ID={$r['mail_id']}'>Delete</a><br /><br /> <a href='preport.php?ID={$r['userid']}'>Report</a><br /><br /> </td> <td>{$r['mail_text']}</td> </tr> EOF; } if($ir['new_mail'] > 0) { $db->query("UPDATE mail SET mail_read=1 WHERE mail_to=$userid"); $db->query("UPDATE users SET new_mail=0 WHERE userid=$userid"); } echo '</table> Mail count mixed up? Click <a href='fix.php?fix=1'>Here</a> to fix'; } OFF */ function mail_outbox() { global $db,$ir,$c,$userid,$h; print "Only the last 25 messages you have sent are visible. <table width=100% cellspacing=1 class='table' border='1'><tr style='background:gray'><th>To</th><th>Subject/Message</th></tr>"; $q=$db->query("SELECT m.*,u.* FROM mail m LEFT JOIN users u ON m.mail_to=u.userid WHERE m.mail_from=$userid ORDER BY mail_time DESC LIMIT 25"); while($r=$db->fetch_row($q)) { $sent=date('F j, Y, g:i:s a',$r['mail_time']); print "<tr><td><a href='viewuser.php?u={$r['userid']}'>{$r['username']}</a> [{$r['userid']}]</td><td>{$r['mail_subject']}</td></tr><tr><td>Sent at: $sent </td><td>{$r['mail_text']}</td></tr>"; } print "</table>"; } function mail_compose() { global $db,$ir,$c,$userid,$h; print "<form action='mailbox.php?action=send' method='post'> <table width=100% cellspacing=1 class='table' border='1'> <tr> <td>Contact to send to:</td> <td>"; $q=$db->query("SELECT c.*, u.username FROM contactlist c LEFT JOIN users u ON c.cl_ADDED=u.userid WHERE c.cl_ADDER={$userid} ORDER BY u.username ASC"); if($db->num_rows($q) == 0) { print "You have no contacts!"; } else { print "<select name='user1' type='dropdown'><option value=''><select a contact...></option>"; while($r=$db->fetch_row($q)) { print "<option value='{$r['username']}'>{$r['username']}</option>"; } print "</select>"; } if($_GET['ID']) { $users=$db->fetch_single($db->query("SELECT username FROM users WHERE userid={$_GET['ID']}")); } print "</td></tr><tr> <td><b>OR</b> Enter a username to send to:</td><td><input class='textbox' type='text' name='user2' value='{$users}' /></td></tr><tr> <td>Subject:</td> <td><input class='textbox' type='text' name='subject' /></td></tr><tr> <td>Message:</td> <td> <textarea class='textbox' rows=5 cols=40 name='message'></textarea> <table class=textbox border=0 cellspacing=0 width=100%> <td><b> :] </b> <td><img src='smilies/happy.gif'> <td><b> :)</b> <td><img src='smilies/biggrin.gif'> <td><b> :cool </b> <td><img src='smilies/cool.gif'> <td><b> O.o </b> <td><img src='smilies/blink.gif'> <td><b> :/ </b> <td><img src='smilies/dry.gif'> </table> <table class=textbox border=0 cellspacing=0 width=100%> <td><b> ;) </b> <td><img src='smilies/wink.gif'> <td><b> :?: </b> <td><img src='smilies/huh.gif'> <td><b> :lol: </b> <td><img src='smilies/laugh.gif'> <td><b> :-: </b> <td><img src='smilies/mellow.gif'> <td><b> :angry: </b> <td><img src='smilies/angry.gif'> </table> <table class=textbox border=0 cellspacing=0 width=100%> <td><b> :( </b> <td><img src='smilies/sad.gif'> <td><b> O.O </b> <td><img src='smilies/ph34r.gif'> <td><b> :roll: </b> <td><img src='smilies/rolleyes.gif'> <td><b> :zzz: </b> <td><img src='smilies/sleep.gif'> <td><b> :)) </b> <td><img src='smilies/smile.gif'> </table> <table class=textbox border=0 cellspacing=0 width=100%> <td><b> :P </b> <td><img src='smilies/tongue.gif'> <td><b> :S </b> <td><img src='smilies/unsure.gif'> <td><b> :nut: </b> <td><img src='smilies/wacko.gif'> <td><b> :O </b> <td><img src='smilies/ohmy.gif'> <td><b> :heart: </b> <td><img src='smilies/wub.gif'> </table> </td></tr><tr> <td colspan=2><input type='submit' class='textbox' value='Send' /></td></tr></table></form>"; if($_GET['ID']) { print " <table width=75% border=1><tr><td colspan=2><b>Your last 5 mails to/from this person:</b></td></tr>"; $q=$db->query("SELECT m.*,u1.username as sender from mail m left join users u1 on m.mail_from=u1.userid WHERE (m.mail_from=$userid AND m.mail_to={$_GET['ID']}) OR (m.mail_to=$userid AND m.mail_from={$_GET['ID']}) ORDER BY m.mail_time DESC LIMIT 5",$c); while($r=$db->fetch_row($q)) { $sent=date('F j, Y, g:i:s a',$r['mail_time']); print "<tr><td>$sent</td> <td><b>{$r['sender']} wrote:</b> {$r['mail_text']}</td></tr>"; } print "</table>"; } } function mail_send() { global $db,$ir,$c,$userid,$h; $subj=str_replace(array("\n"),array(" "),strip_tags($_POST['subject'])); $msg=str_replace(array("\n"),array(" "),strip_tags($_POST['message'])); if($_POST['user1'] && $_POST['user2']) { die("Please do not select a contact AND enter a username, only do one. <a href='mailbox.php'>> Back</a>"); } if(!$_POST['user1'] && !$_POST['user2']) { die("You must select a contact or enter a username. <a href='mailbox.php'>> Back</a>"); } $codes = array( ':]', ':)', 'o:', 'O.o', ':/', ':angry:', ':?:', ':lol:', ':-:', ':O', ':(', 'O.O', ':roll:', ':zzz:', ':))', ':P', ':S', ':nut:', ';)', ':heart:', 'XD', ); $images = array( '<img src=smilies/happy.gif>', '<img src=smilies/biggrin.gif>', '<img src=smilies/cool.gif>', '<img src=smilies/blink.gif>', '<img src=smilies/dry.gif>', '<img src=smilies/angry.gif>', '<img src=smilies/huh.gif>', '<img src=smilies/laugh.gif>', '<img src=smilies/mellow.gif>', '<img src=smilies/ohmy.gif>', '<img src=smilies/sad.gif[>', '<img src=smilies/ph34r.gif>', '<img src=smilies/rolleyes.gif>', '<img src=smilies/sleep.gif>', '<img src=smilies/smile.gif>', '<img src=smilies/tongue.gif>', '<img src=smilies/unsure.gif>', '<img src=smilies/wacko.gif>', '<img src=smilies/wink.gif>', '<img src=smilies/wub.gif>', '<img src=]smilies/XD.gif>]', ); $newmsg = str_replace($codes, $images, $msg); $to=($_POST['user1']) ? $_POST['user1'] : $_POST['user2']; $q=$db->query("SELECT userid FROM users WHERE username='{$to}'"); if($db->num_rows($q)==0) { die("You cannot send mail to nonexistant users. <a href='mailbox.php'>> Back</a>"); } $to=$db->fetch_single($q); $db->query("INSERT INTO mail VALUES ('',0,$userid,$to,unix_timestamp(),'$subj','$msg')"); $db->query("UPDATE users SET new_mail=new_mail+1 WHERE userid={$to}"); print "Message sent. <a href='mailbox.php'>> Back</a>"; } function mail_delete() { global $db,$ir,$c,$userid,$h; $db->query("DELETE FROM mail WHERE mail_id={$_GET['ID']} AND mail_to=$userid"); print "Message deleted. <a href='mailbox.php'>> Back</a>"; } function mail_delall() { global $ir,$c,$userid,$h; print "This will delete all the messages in your inbox. There is <b>NO</b> undo, so be sure. <a href='mailbox.php?action=delall2'>> Yes, delete all messages</a> <a href='mailbox.php'>> No, go back</a>"; } function mail_delall2() { global $db,$ir,$c,$userid,$h; $db->query("DELETE FROM mail WHERE mail_to=$userid"); print "All ".$db->affected_rows()." mails in your inbox were deleted. <a href='mailbox.php'>> Back</a>"; } function mail_archive() { global $ir,$c,$userid,$h; print "This tool will download an archive of all your messages. <a href='dlarchive.php?a=inbox'>> Download Inbox</a> <a href='dlarchive.php?a=outbox'>> Download Outbox</a>"; } function mail_view() { global $db,$ir,$c,$userid,$h; print <<<OUT <table width=100% class="table" border="1" cellspacing="1"> <tr> <td class="h" width=25%>From</td> <td class="h" width=75%>Subject/Message</td> </tr> OUT; $id= abs((int) $_GET['ID']); $q=$db->query("SELECT m.*,u.* FROM mail m LEFT JOIN users u ON m.mail_from=u.userid WHERE m.mail_id=$id LIMIT 1"); $r=$db->fetch_row($q); $sent=date('F j, Y, g:i:s a',$r['mail_time']); print "<tr><td>"; if($r['userid']) { print "<a href='viewuser.php?u={$r['userid']}'>{$r['username']}</a> [{$r['userid']}]"; } else { print "SYSTEM"; } $fm=urlencode($r['mail_text']); print "</td>\n<td>{$r['mail_subject']}</td></tr><tr><td>Sent at: $sent<br /> "; if($ir['mailban'] == 0) { print "<a href='mailbox.php?action=compose&ID={$r['userid']}'>Reply</a><br /> "; } print "<a href='mailbox.php?action=delete&ID={$r['mail_id']}'>Delete</a><br /> <a href='preport.php?ID={$r['userid']}'>Report</a></td><td>{$r['mail_text']}</td></tr>"; if($r['mail_read'] == 0) { $db->query("UPDATE mail SET mail_read=1 WHERE mail_to=$userid AND mail_id=$id LIMIT 1"); $db->query("UPDATE users SET new_mail=new_mail-1 WHERE userid=$userid"); } print "</table>"; } function mail_massdel() { global $db,$ir,$c,$userid,$h; $counter = 1; $deleted=0; while ($counter < 25) { $dodel = "del" . $counter; if ($_POST[$dodel] == "yes") { $delid = "id" . $counter; $db->query("DELETE FROM mail WHERE mail_to=$userid AND mail_id={$_POST[$delid]}") or die(mysql_error()); $deleted++; } $counter++; } print "<center> $deleted messages deleted. <a href=mailbox.php>> Back</a>"; } print " Mail count mixed up? Click <a href='fix.php?fix=1'>Here</a> to fix"; $h->endpage(); ?>