Dayo

yea but our user db is pottentialy gona hit 200+ fields, were intergrating our database into vBulletins so the two work together and for example one page all it has is a list ofusers feinds so i just want to do somethinglike this $freinds=explode('-', user('`freinds`')); //then print out there name and id while in a loop $u=user('`name`, `id`'); echo $u['name'].' '.$u['id']; so if a user had 150 freinds it wont have to get 198 x 150 un-nessasary fields same with the userlist

look for money_format() in the functions and replace $ with £ or whaat ever you want. please note this wont change every one

thanks for that i think i will be using it for my project after a few other edits (like being able to update the user feild) eg user('`name`=dayo') thanks for the feedback floydian :thumbsup:

im thinking of using something like this in my next project. would it speed up a page or slow it down function user($sql, $user='-1') { global $connect; $sql=mysql_real_escape_string($sql); if ($user=='-1') {$user=$_SESSION['id'];} $user=mysql_real_escape_string($user); $qry = mysql_query("SELECT `".$sql."` FROM `users` WHERE id='".$user."'"); return mysql_fetch_array($qry); } so all you have to do is $optional_user = 2; // used if you want to look at another users details eg a profile $user=user('`name`, `id`', $optional_user); echo $user['name'].' ['.$user['id'].']'; is this an ideal way of doing things, or just stick with the normal select * ...

oh yea thanks for that ill fix that asap

you should get mission experiance even if you fail ... not rank exp thogh

you get exp for the mission otherwise you would stay at 0% and cant move on spellings will be corrected soon just post it in the bugs forum and ill change it ill change it so you stay on the mission page after missions and ill do the capcha so it shows up randomly every 1 in 5 times you load the page

Thanks redex I will solve those problems todayand yes it os a gl script based but hopefuly with the new feature I'm adding weekly it will truly be uniqe

[align=center]The Mercenary [/align]Link to The MercenaryThe Mercenary is a milatary based text based game made by myself, this is my first online game that i have launched and wopuld like your opinion on what you think. A Few features include A very diffrent gameplay to most MMORPGs Weekly Updates Soon to be on Facebook We would like your feedback on what could be improved and your thorts on the gameThanks, Dayo The Mercenary

1887's FTW :D there too powerful even after they patched them up

no problem mate, if not in those shops look in all shops where they sell greeting cards and vouchers and now i thinkm of it it may be in £50 too

soz mate, ypuld be suprised how many emails i get saying... this dont work plz help me :p Ill have a go at the phpbb one when i get sometime to do it

btw this fixes the profile picture

this is a free fix and mod for account.php and _account.php account.php <?php require("top.php"); ?> <? require("usercheck.php"); ?> <style type="text/css"> <!-- .style1 {color: #000000} #tbl { border:none;} --> </style> <div align="center">|| [url="account.php?action=pass"]Change Password[/url] || [url="account.php?action=add"]Add Freind[/url] || [url="account.php?action=block"]Block User[/url] || [url="account.php?action=quote"]Change Quote[/url] || [url="account.php?action=pic"]Change Profile Picture[/url] ||</div> <?php if (!isset($_GET['action'])) { echo ' Here you can edit your account, you can add freinds, block users from mailing you and edit your profile details like your personal quote/picture.</p>'; $_GET['action']=''; } ?> <form method="post" class="style1"> <?php require("_account.php"); ?> <?php if ($_GET['action']=='pass') { ?> <fieldset style="border: 1px solid #000000; width: 275px; text-align: left; padding: 5px;"> <legend style="font-weight: bold;">Change Password.</legend> <table width="275" border="0" cellspacing="0"> <tr> <td width="100" align="left">[b]Old Password: [/b]</td> <td width="175" align="center"><input name="Po" type="password" class="entryfield" id="Po" style='width: 95%; ' maxlength="20"/></td> </tr> <tr> <td width="100" align="left">[b]New Password: [/b]</td> <td width="175" align="center"><input name="Pn" type="password" class="entryfield" id="Pn" style='width: 95%; ' maxlength="20"/></td> </tr> <tr> <td width="100" align="left">[b]Repeat: [/b]</td> <td width="175" align="center"><input name="Pr" type="password" class="entryfield" id="Pr" style='width: 95%; ' maxlength="20"/></td> </tr> <tr> <td colspan="2" align="right"><input name="Update" type="submit" class="button" id="Update" value="Update." onFocus="if(this.blur)this.blur()"/></td> </tr> </table> </fieldset> <?php } if ($_GET['action']=='add') { ?> <fieldset style="border: 1px solid #000000; width: 450px; text-align: left; padding: 5px;"> <legend style="font-weight: bold;">Friends list.</legend> <table width="450" border="0" cellspacing="0"> <tr> <td colspan="4" align="center"><?php if(empty($friends)){ echo "You don't have any friends."; }else{ $friends_list = explode("-", $friends); foreach( $friends_list as $key => $value){ echo "<input name=\"friend\" type=\"radio\" value=\"".$value."\" onFocus=\"if(this.blur)this.blur()\"><a href=\"view_profile.php?name=". $value ."\">".$value."</a>"; } }// if no friends. ?></td> </tr> <tr> <td width="50" align="left">[b]Name:[/b]</td> <td align="center"><input name="name" type="text" class="entryfield" id="name" style='width: 95%; ' maxlength="20" /></td> <td width="100" align="right"><input name="Add_Friend" type="submit" class="button" id="Add_Friend" value="Add Friend." onfocus="if(this.blur)this.blur()" /></td> <td width="100" align="right"><input name="Remove" type="submit" class="button" id="Remove" value="Remove." onfocus="if(this.blur)this.blur()"/></td> </tr> </table> </fieldset> <?php } if ($_GET['action']=='block') { ?> <fieldset style="border: 1px solid #000000; width: 450px; text-align: left; padding: 5px;"> <legend style="font-weight: bold;">Message Filter.</legend> </textarea> <table width="450" border="0" cellspacing="0"> <tr> <td colspan="4" align="center"><?php if(empty($filter)){ echo "You don't have any people blocked."; }else{ $filter_list = explode("-", $filter); foreach( $filter_list as $key => $value){ echo "<input name=\"filter_id\" type=\"radio\" value=\"".$value."\" onFocus=\"if(this.blur)this.blur()\"><a href=\"view_profile.php?name=". $value ."\">".$value."</a>"; } }// if no friends. ?></td> </tr> <tr> <td width="50" align="left">[b]Name:[/b]</td> <td align="center"><input name="filter_name" type="text" class="entryfield" id="filter_name" style='width: 95%; ' maxlength="20" /></td> <td width="100" align="right"><input name="Filter" type="submit" class="button" id="Filter" value="Filter." onfocus="if(this.blur)this.blur()" /></td> <td width="100" align="right"><input name="Remove_filter" type="submit" class="button" id="Remove_filter" value="Remove." onfocus="if(this.blur)this.blur()"/></td> </tr> </table> </fieldset> <?php } if ($_GET['action']=='quote') { ?> <fieldset style="border: 1px solid #000000; width: 450px; text-align: left; padding: 5px;"> <legend style="font-weight: bold;">Quote.</legend> <textarea name="quote_box" cols="50" rows="10" class="textbox" id="quote_box" style='width: 450px;'/> <?php echo htmlspecialchars(stripslashes($quote)); ?></textarea> <table width="100%" border="0" cellspacing="0"> <tr> <td align="right"><input name="Quote" type="submit" class="button" id="Quote" value="Update Quote." onFocus="if(this.blur)this.blur()" /></td> </tr> </table> </fieldset> <?php } if ($_GET['action']=='pic') { ?> <fieldset style="border: 1px solid #000000; width: 450px; text-align: left; padding: 5px;"> <legend style="font-weight: bold;">Profile picture.</legend> <table width="450" border="0" cellspacing="0"> <tr> <td colspan="3" align="center"><?php if(empty($picture)){ echo "No Picture."; }else{ echo "<img src=\"http://".$picture."\" style=\" border: 1px #000000 solid;\"/>"; }// if no Picture. ?></td> </tr> <tr> <td width="50" align="left">[b]Url:[/b]</td> <td width="342" align="center"><input name="Url" type="text" class="entryfield" id="Url" style='width: 95%; ' value="http://<?php echo $picture; ?>" maxlength="255" /></td> <td width="98" align="right"><input name="Update_url" type="submit" class="button" id="Update_url" value="Update." onfocus="if(this.blur)this.blur()"/></td> </tr> </table> </fieldset> <?php } ?> </form> <?php include('information_bar.php'); ?> <?php require("bottom.php"); ?> _account.php <? $page_url = explode(".", $_SERVER['REQUEST_URI']); $_SERVER['REQUEST_URI'] = $page_url[0].".php"; if($_SERVER['REQUEST_URI'] == "/_account.php"){ exit(); } if(isset($_POST['Add_Friend'])){ $friends_list = explode("-", $friends); if(empty($_POST['name'])){ echo e("You didn't enter a name."); }else{ if (in_array($_POST['name'], $friends_list)) { echo e("This person is already in your Friends list."); }else{ $sql = "SELECT name FROM login WHERE name='".mysql_real_escape_string($_POST['name'])."'"; $query = mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_object($query); $buddy_name = htmlspecialchars($row->name); if(empty($buddy_name)){ echo $lang_no_user; }else{ if(empty($friends)){ $result = mysql_query("UPDATE login SET friends='".mysql_real_escape_string($buddy_name)."' WHERE id='" .mysql_real_escape_string($_SESSION['user_id']). "'") or die(mysql_error()); $friends = $buddy_name; }else{ $new_friend = $friends."-".$buddy_name; $result = mysql_query("UPDATE login SET friends='".mysql_real_escape_string($new_friend)."' WHERE id='" .mysql_real_escape_string($_SESSION['user_id']). "'") or die(mysql_error()); $friends = $new_friend; } echo "You added ".$buddy_name." to your friends list."; }// if empty field. }// if exist check. }// if already in check. }// if isset. if(isset($_POST['Remove'])){ $friends_list = explode("-", $friends); if(empty($_POST['friend'])){ echo e("You didn't select a friend."); }else{ if (!in_array($_POST['friend'], $friends_list)) { echo e("This person isn't in your friends list."); }else{ $new_friends = ""; foreach( $friends_list as $key => $value){ if($value != $_POST['friend']){ if(empty($new_friends)){ $new_friends = $value; }else{ $new_friends = $new_friends."-".$value; } } } $result = mysql_query("UPDATE login SET friends='".mysql_real_escape_string($new_friends)."' WHERE id='" .mysql_real_escape_string($_SESSION['user_id']). "'") or die(mysql_error()); $friends = $new_friends; echo "You removed ".$_POST['friend']." from your friends list."; }// if no friend selected. }// if not in friendslist. }// if isset. if(isset($_POST['Filter'])){ $filter_list = explode("-", $filter); if(empty($_POST['filter_name'])){ echo e("You didn't enter a name."); }else{ if (in_array($_POST['filter_name'], $filter_list)) { echo e("This person is already in your filter list."); }else{ $sql = "SELECT name FROM login WHERE name='".mysql_real_escape_string($_POST['filter_name'])."'"; $query = mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_object($query); $buddy_name = htmlspecialchars($row->name); if(empty($buddy_name)){ echo $lang_no_user; }else{ if(empty($filter)){ $result = mysql_query("UPDATE login SET filter='".mysql_real_escape_string($buddy_name)."' WHERE id='" .mysql_real_escape_string($_SESSION['user_id']). "'") or die(mysql_error()); $filter = $buddy_name; }else{ $new_filter = $filter."-".$buddy_name; $result = mysql_query("UPDATE login SET filter='".mysql_real_escape_string($new_filter)."' WHERE id='" .mysql_real_escape_string($_SESSION['user_id']). "'") or die(mysql_error()); $filter = $new_filter; } echo "You added ".$buddy_name." to your filter list."; }// if empty field. }// if exist check. }// if already in check. }// if isset. if(isset($_POST['Remove_filter'])){ $filter_list = explode("-", $filter); if(empty($_POST['filter_id'])){ echo e("You didn't select a friend."); }else{ if (!in_array($_POST['filter_id'], $filter_list)) { echo e("This person isn't in your friends list."); }else{ $new_filter = ""; foreach( $filter_list as $key => $value){ if($value != $_POST['filter_id']){ if(empty($new_filter)){ $new_filter = $value; }else{ $new_filter = $new_filter."-".$value; } } } $result = mysql_query("UPDATE login SET filter='".mysql_real_escape_string($new_filter)."' WHERE id='" .mysql_real_escape_string($_SESSION['user_id']). "'") or die(mysql_error()); $filter = $new_filter; echo "You removed ".$_POST['filter_id']." from your filter list."; }// if no friend selected. }// if not in friendslist. }// if isset. if(isset($_POST['Quote'])){ echo "Your quote has been updated."; $result = mysql_query("UPDATE login SET quote='".mysql_real_escape_string($_POST['quote_box'])."' WHERE id='" .mysql_real_escape_string($_SESSION['user_id']). "'") or die(mysql_error()); $quote = $_POST['quote_box']; }// update quote. if(isset($_POST['Update_url'])){ $_POST['Url']=str_replace("http://", '', $_POST['Url']); $image = getimagesize('http://'.$_POST['Url']); if (!$image) { echo 'tut tut tut only put images here'; } else { mysql_query("UPDATE `login` SET `side_url`='".$_POST['Url']."' WHERE `name`='".$name."'"); echo '[i]Picture Edited[/i]'; $picture = $_POST['Url']; } }// update pic. if (isset($_POST['Update'])){ $oldpass = md5($_POST['Po']); $newpass = md5($_POST['Pn']); $checkpass = md5($_POST['Pr']); if ( $oldpass != $password ) { echo e("Invalid Information."); }else { if ( $newpass != $checkpass ) { echo e("Invalid Information."); }else { if((empty($_POST['Po'])) or (empty($_POST['Pn'])) or (empty($_POST['Pr']))){ echo $lang_empty_field; } else { if ((strlen($_POST['Po']) > "20") or (strlen($_POST['Po']) < "6")){ echo e("Your Password needs to be between 6 and 20 characters."); }else{ if ((strlen($_POST['Pn']) > "20") or (strlen($_POST['Pn']) < "6")){ echo e("Your Password needs to be between 6 and 20 characters."); }else{ if ((strlen($_POST['Pr']) > "20") or (strlen($_POST['Pr']) < "6")){ echo e("Your Password needs to be between 6 and 20 characters."); }else{ /////////////////////////// update password ////////////////////////////////// $result = mysql_query("UPDATE login SET password='".mysql_real_escape_string($newpass)."' WHERE id='" .mysql_real_escape_string($_SESSION['user_id']). "'") or die(mysql_error()); echo "Your password has been changed."; } // check characters } // check characters } // check characters } // if field is empty. } // if new and repeat password don't match } // if old password is incorrect } // if post update ?> Enjoy :D

to get paypal credit you can get £15 and £25 credit vouchers look in morisons/birthdays (in the UK) you c ant talk your tring to rip TC

please note on the 1st post the encryption has since changed to this [Mccodes][V2] SMF Registration Intergration!!!!! just incase you used the old encryption

Here is a bank for your games, there ios no sql as the tables already exist. Enjoy :D to edit the percentage just cange $bperc at the top if you dont want to charge intrest make it 0 <?php include 'top.php'; // Bank Script Made By Dayo // Made for the GL scripts $bperc = 3; // set this to the ammount you want to charge to deposit money // dont forget to make a link on your menu [url='bank.php']Bank[/url] if (isset($_POST['withdraw'])) { $withdraw = abs(@intval($_POST['withdraw'])); if ($withdraw > $bank_money) { echo 'You dont have enough money in your bank to do this';} else { mysql_query("UPDATE `login` SET `money`=`money`+'".$withdraw."', `bank`=`bank`-'".$withdraw."'"); echo 'You withdrew $'.number_format($withdraw).' from your bank.';} } else if (isset($_POST['deposit'])) { $ibp = 100 - $bperc; $deposit = abs(@intval($_POST['deposit'])); $depo=round($deposit/100); $deposit2 = $depo*$ibp; if ($deposit > $money) { echo 'You dont have enough money to do this';} else { mysql_query("UPDATE `login` SET `money`=`money`-'".$deposit."', `bank`=`bank`+'".$deposit2."'"); echo mysql_error(); echo 'You deposited $'.number_format($deposit).' into your bank.';} } ?> <form name="form1" method="post" action=""> <?php if ($_GET['action']=='deposit') { echo '[[url="bank.php?action=withdraw"]Withdraw Money[/url]] [Deposit Money]'; } else if ($_GET['action'] == 'withdraw') { echo '[Withdraw Money] [[url="bank.php?action=deposit"]Deposit Money[/url]]';}?> <table width="400" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="2">[b]Bank[/b]</td> </tr> <?php if ($bperc > 0) {?> <tr> <td colspan="2">There is a charge of <?php echo $bperc; ?>% to deposit your money</td> </tr> <?php }// ends $bperc if statment?> <?php if ($_GET['action']=='withdraw') {?> <tr> <td>Withdraw</td> <td><label> <input name="withdraw" type="text" id="withdraw" value="<?php echo round($bank_money); ?>"> </label></td> </tr><?php } else if ($_GET['action']=='deposit') {?> <tr> <td>Deposit</td> <td><label> <input name="deposit" type="text" id="deposit" value="<?php echo $money; ?>"> </label></td> </tr><?php } if (!isset($_GET['action'])) { echo '<tr><td>[url="bank.php?action=withdraw"]Withdraw Money[/url]</td><td>[url="bank.php?action=deposit"]Deposit Money[/url]</td></tr>';} else {?> <tr> <td colspan="2"><label> <input type="submit" name="Submit" value="Submit"> </label></td> </tr><?php } ?> </table> </form> <?php include 'bottom.php'; ?> if you have any problems post here

If you can't get a macro to work, just make it where they can't refresh the page. thjat dont work using imacro you can auto train your character on mccodes (imacro id a FF plugin) i would use a random capcha to appear once every 1-15 clicks its a random so no macro can get around it otherwise it fails and its not something that will anoy users rather then a perminant capch

no problem mate, and you cant be to crap to play online i was no pro when i started, just get to about level 30-40 n it gets easy

i was gona make this for the xbox but u beat me to it :( any way it is a must have the online play is 5 stars

i've not been to London wouldn't know... lol so funny and true 3 people in my class at year 11 had babies

to get rid of the ,- do what i did :thumbsup:

unset($_SESSION['attacksession']); that should delet the session i think-may be a typo in the session name

a That only works for gif's. I prefer png as it gives transparency if needed, but .gif is good. Anyone want a valid Corel Paint shop pro x2 license for 30.00? Its a great program for begginers, but i got it for christmas becuz my aunt didnt know i had photoshop. its usually priced at 100.00 but im selling a legit license code for 30.00. all you have to do is look for gif and replace with png

i would advise you to remove your attack it looks like a paid mod from iamwicked (trys to remember current name) and your showing it to MWG community