spellbyte ®

Re: mailbox with smilies nice one, i'll give it a go in the morning

Re: Tables... Only returning one entry? can you post the code that your having trouble with

Re: function error that code i posted above is just the functions that needs to go into global_func.php the form is a totally different and much larger piece of script

Re: Tables... Only returning one entry? when printing a table to display DB data you dont finish off the table tag I.E. this is from my estate page   <tr><td>[url='estate.php?property={$r[']{$r['hNAME']}[/url] </td><td>$$t".money_formatter($r['hPRICE'],'')."$et </td><td>{$r['hWILL']}</td></tr>";   I hope this helps u out some

Re: mailbox with smilies I have updated the function to include any capitalisation or letters :o :O

Re: mailbox with smilies glad it works out for you all

Re: function error Gangs   function gang_dropdown($connection,$ddname="gangs",$selected=-1) { $ret="<select name='$ddname' type='dropdown'>"; $q=mysql_query("SELECT * FROM gangs ORDER BY gangNAME ASC",$connection); if($selected == -1) { $first=0; } else { $first=1; } while($r=mysql_fetch_array($q)) { $ret.="\n<option value='{$r['gangID']}'"; if ($selected == $r['gangID'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.= ">{$r['gangNAME']}</option>"; } $ret.="\n</select>"; return $ret; }   Cars   function cars_dropdown($connection,$ddname="cars",$selected=-1) { $ret="<select name='$ddname' type='dropdown'>"; $q=mysql_query("SELECT * FROM cars_types ORDER BY carNAME ASC",$connection); if($selected == -1) { $first=0; } else { $first=1; } while($r=mysql_fetch_array($q)) { $ret.="\n<option value='{$r['carID']}'"; if ($selected == $r['carID'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.= ">{$r['carNAME']}</option>"; } $ret.="\n</select>"; return $ret; }   they both depend on the structure of your db though

Re: mailbox with smilies my mistake, i forgot to change the mailbox2 to mailbox, try it now

OPEN MAILBOX.PHP FIND   function mail_send()   replace that whole function with   function mail_send() { global $ir,$c,$userid,$h; $subj=str_replace(array("\n"),array(" "),strip_tags($_POST['subject'])); $msg=str_replace(array("\n"),array(" "),strip_tags($_POST['message'])); $codes = array(":)", ";)", ":o",":O", ":d",":D", ":s", ":S", ":(", ":red", ":clown", ":bashful", ":x", ":green", ":|", ";(", ":]", ":horny", ":cool"); $images = array("", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""); $newmsg = str_replace($codes, $images, $msg); $to= (int) $_POST['userid']; mysql_query("INSERT INTO mail VALUES ('',0,$userid,$to,unix_timestamp(),'$subj','$newmsg')",$c) or die(mysql_error()); print "Message sent. [url='mailbox.php']> Back[/url]"; }   then upload the smilies that are provided in the following archive http://alphacrime.com/smilies.rar

Re: function error you need to define the crimegroup dropdown in the global_func.php

Re: Quick question NP's glad someone appreciates the help :)

Re: Quick question it's all stored in the users table, the type of house is defined by the amount of maxwill the user has

Re: About game players i'm with deception on this one, mine isn't on my donate page either :P great mod deception lol works gr8 by the way

Re: i need some help well it would appear that you are missing the userid field from your table, post the entire table here and i'll tell u if ur missing anything else

Re: i need some help i think what we have here is yet another person who knows absolutely jack about programming or how to setup a DB, either that or he has got some bum mods without the SQL queries, or BOTH

Re: I need a bit of help!!! ALL OWNERS AND CODERS!!! i'll put a few links about on alphacrime too m8

Re: i need some help did the mods not come with instructions on how to install them

Re: i need some help can you be more specific as per your needs

Re: [email protected] -- anyone know? unfortunately this falls in to the realms of a verbal contract, "not worth the paper it's printed on" just gotta play it more careful next time. you never know, he might surprise you and re-appear in a day or so

Re: Cron Configuration - Worked before what exactly is the problem with it, any errors at all, or are they just not running

Re: Inserting 1000 records...easier way? either your battletent is gonna be huge or u want your game to look more active than it actually is

Re: Max Stats yes that procedure will work on most thing that involve money, I.E. house prices crystals gang money/crystals shop prices, oh u get it :P

Re: Max Stats yes it is possible, and the how to is explained a couple of posts up

Re: Simple MySQL Insert error. $myfirm=mysql_query("SELECT * FROM firms WHERE fID={$_GET['ID']}",$c); $mf=mysql_fetch_array($myfirm); $warfirm=mysql_query("SELECT * FROM firms WHERE fID={$_GET['WID']}",$c); $wf=mysql_fetch_array($warfirm); mysql_query("INSERT INTO firmwars VALUES('', '{$mf['fID']}', '{$mf['fNAME']}', '{$wf['fID']}', '{$wf['fNAME']}', '0')",$c);

Re: Urgent -- Sign Up Bug... i've noticed that your still having a problem with your site 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 'AND evREAD=0' at line 1   if you post the events code in here from your mainmenu.php and lets see if we can fix it for you