? Sparks ?

Re: Need Items sql I went and tried to run this   CREATE TABLE `items` ( `itmid` int( 11 ) NOT NULL AUTO_INCREMENT , `itmtype` int( 11 ) NOT NULL default '0', `itmname` varchar( 255 ) NOT NULL default '', `itmdesc` text NOT NULL , `itmbuyprice` int( 11 ) NOT NULL default '0', `itmsellprice` int( 11 ) NOT NULL default '0', `itmbuyable` int( 11 ) NOT NULL default '0', `effect1_on` tinyint( 4 ) NOT NULL default '0', `effect1` text NOT NULL , `effect2_on` tinyint( 4 ) NOT NULL default '0', `effect2` text NOT NULL , `effect3_on` tinyint( 4 ) NOT NULL default '0', `effect3` text NOT NULL , `helmet` int( 11 ) NOT NULL default '0', `weapon` int( 11 ) NOT NULL default '0', `armor` int( 11 ) NOT NULL default '0', `boots` int( 11 ) NOT NULL default '0', `amulet` int( 11 ) NOT NULL default '0', `bracelet` int( 11 ) NOT NULL default '0', `ring` int( 11 ) NOT NULL default '0', `special` int( 11 ) NOT NULL default '0', PRIMARY KEY ( `itmid` ) ) ENGINE = MYISAM   But It says MySQL said: Documentation #1050 - Table 'items' already exists But when I go to create an Item It says QUERY ERROR: Column count doesn't match value count at row 1 Query was INSERT INTO items VALUES('',7,'Stick (+50)','Deadly weapon that you can rip off a tree',25000,12500,1, '0', 'a:4:{s:4:\"stat\";s:6:\"energy\";s:3:\"dir\";s:3:\"pos\";s:8:\"inc_type\";s:6:\"figure\";s:10:\"inc_amount\";i:0;}', '0', 'a:4:{s:4:\"stat\";s:6:\"energy\";s:3:\"dir\";s:3:\"pos\";s:8:\"inc_type\";s:6:\"figure\";s:10:\"inc_amount\";i:0;}', '0', 'a:4:{s:4:\"stat\";s:6:\"energy\";s:3:\"dir\";s:3:\"pos\";s:8:\"inc_type\";s:6:\"figure\";s:10:\"inc_amount\";i:0;}', 50, 0, 0, 0, 0, 0, 0, 0)

I need a new code to run, I can't edit, create , use, or send my Items, and You cant sell them :S

I just started coding, I didn't fix up my last site someone else did. I have login, register, header,index, and authenticate but nothing seems to work,

Can someone give me a full gangs page with working armory?

Re: Help with Jailing Got It, Busted had to be taken out

Re: Help with Jailing Nope QUERY ERROR: Unknown column 'busted' in 'field list' Query was UPDATE users SET busted=busted+1 WHERE userid=6

Re: Help with Jailing Everything you guy's said Isn't working :|

Re: Help with Jailing Parse error: syntax error, unexpected '>' in /home/strats/public_html/docrime.php on line 54

Re: Help with Jailing Its all messed up can someone just fix that code for me?

Re: Help with Jailing   <?php $macropage="docrime.php?c={$_GET['c']}"; include "globals.php"; print "<div id='content'>"; if($ir['jail'] or $ir['hospital']) { die(" <prb>This page cannot be accessed while in jail or hospital.</prb> [url='index.php']> Home[/url]"); } $_GET['c']=abs((int) $_GET['c']); if(!$_GET['c']) { print " <prb>ERROR! - Invalid crime</prb> [url='index.php']> Home[/url]"; } else { $q=mysql_query("SELECT * FROM crimes WHERE crimeID={$_GET['c']}",$c); $r=mysql_fetch_array($q); if($ir['brave'] < $r['crimeBRAVE']) { print " <prb>You do not have enough Brave to perform this crime.</prb> [url='index.php']> Home[/url]"; } else { $ec="\$sucrate=".str_replace(array("LEVEL","CRIMEXP","EXP","WILL","IQ"), array($ir['level'], $ir['crimexp'], $ir['exp'], $ir['will'], $ir['IQ']),$r['crimePERCFORM']).";"; eval($ec); print "<h1>".$r['crimeNAME']."</h1><hr width='90%' align='left' /> ".$r['crimeITEXT']."</p> "; $ir['brave']-=$r['crimeBRAVE']; mysql_query("UPDATE users SET brave={$ir['brave']} WHERE userid=$userid",$c); if(rand(1,100) <= $sucrate) { print " ".str_replace("{money}",$r['crimeSUCCESSMUNY'],$r['crimeSTEXT'])."</p>"; $ir['money']+=$r['crimeSUCCESSMUNY']; $ir['crystals']+=$r['crimeSUCCESSCRYS']; $ir['exp']+=(int) ($r['crimeSUCCESSMUNY']/8); mysql_query("UPDATE users SET money={$ir['money']}, crystals={$ir['crystals']}, exp={$ir['exp']},crimexp=crimexp+{$r['crimeXP']} WHERE userid=$userid",$c); if($r['crimeSUCCESSITEM']) { item_add($userid, $r['crimeSUCCESSITEM'], 1); } } else { if(rand(1, 2) == 1) { print "<p class='crimefail'>".$r['crimeFTEXT']."</p>"; } else { print "<p class='crimejail'>".$r['crimeJTEXT']."</p>"; $db->query("UPDATE users SET jailed=jailed+1 WHERE userid=$userid"); $db->query("UPDATE users SET busted=busted+1 WHERE userid=$userid"); $db->query("UPDATE `users` SET `jailed` = '$r[crimeJAILTIME]', `jail_reason` = '$r[crimeJREASON]' WHERE `userid` = '$userid'"); $h->endpage(); exit; } } print " [url='docrime.php?c={$_GET[']> Try Again[/url]</p> [url='criminal.php']> Back to Crimes[/url]</p>"; } } $h->endpage(); ?>   There Is the code, I switched it to jailed and nothing! Or do I go to a different file, This one Is docrime.php

Ok So My crimes are up and running! but when you get caught for the crime and It says you go to jail you don't QUERY ERROR: Unknown column 'jailed' in 'field list' Query was UPDATE users SET jailed=jailed+1 WHERE userid=6

Re: [mccode v2] Improved Security on Attack System Great mod +1

Re: [mc code V2]Updated Lottery Nice One +1

Re: I need help Please read asap   <?php require_once (DIRNAME(__FILE__) . '/globals.php'); $AnnouceCount = $ir['new_announcements']; $Order = sprintf( "SELECT * FROM " . "`mod_announcements` " . "ORDER BY `annouce_ID` DESC" ); $Selected = $db->query ($Order); ?> <h3>Annoucements</h3> <table width='75%' cellspacing='0' border='1' class='table'> <tr> <th width='30%'> Staff Posted/Topic/Urgency </th> <th width='70%'> Announcement </th> </tr> <?php while($Info = $db->fetch_row($Selected)) { if($AnnouceCount > 0) { $AnnouceCount--; $NewInfo="?-?<font color='#FF000'>[b]New![/b]</font>"; } else { $NewInfo=""; } echo " <tr> <th colspan='2'> {$Info['annouce_NAME']}?-?".date('F j Y, g:i:s a', $Info['annouce_TIME']).$NewInfo." </th> </tr> <td> Topic: {$Info['annouce_TOPIC']} Urgency: {$Info['annouce_URGENCY']} Posted By: {$Info['annouce_POSTED']} </td> <td valign=top> ".nl2br($Info['annouce_TEXT'])." </td> </tr>"; } ?> </table> <?php if($ir['new_announcements']) { $NoAnnoucements = sprintf( "UPDATE `users` SET `new_announcements` = '0' WHERE (`userid` = %u) " , $userid); $db->query($NoAnnoucements); } $h->endpage(); ?>

Re: I need help Please read asap Those are

Re: I need help Please read asap www.hell-on-earth.tyreus.com

Re: I need help Please read asap Just basic stuff like forums, Blackjack, stuff like that It all ends up in the left hand corner lol, I could use some help

Ok so everything I add to my site messes up, It works and everything but it is always in the top right hand corner. What code would I use to fix that?

Re: [mccode] gang levels Nice Job you messed my page up :x

Re: [mccode v2] Annoucements Upgrade! +1

Re: My jailescape Perfection

Re: [V2] Mug feature with Stats! Works great thanks

Re: [mccode v2] Lottery Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/strats/public_html/lottery.php on line 26

Yeah so I got my crimes all up and running, But when you fail the crime and It says you were sent to jail you don't end up In jail, For Example You decide enough is enough. You grab up your homies, roll downtown and start a riot...' The cops confront you and after refusing to leave, they arrest you. QUERY ERROR: Unknown column 'jailed' in 'field list' Query was UPDATE users SET jailed=jailed+1 WHERE userid=6   Any Ideas On what Is going wrong?