? Sparks ?

QUERY ERROR: Column count doesn't match value count at row 1 Query was INSERT INTO gangs VALUES('','super ninjas','','','',0,0,100,4,4,5,0,0,'')   If you need me to post the code let me know :)

Re: Looking for a fantastic header Thanks

<?php /*----------------------------------------------------- -- A Product From [url]www.lost-warzone.net[/url] -- Made By Ishz -- E-mail: ishz-95[AT]hotmail[DOT]com -----------------------------------------------------*/ include "globals.php"; 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>[url='mailbox.php?action=inbox']Inbox[/url]</td> <td align=center>[url='mailbox.php?action=outbox']Sent Messages[/url]</td> <td align=center>[url='mailbox.php?action=compose']Compose Message[/url]</td> <td align=center>[url='mailbox.php?action=delall']Delete All Messages[/url]</td> <td align=center>[url='mailbox.php?action=archive']Archive Messages[/url]</td> <td align=center>[url='contactlist.php']My Contacts[/url]</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"> <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=mailbox2.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 "[url='viewuser.php?u={$r[']{$r['username']}[/url] [{$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> [url='mailbox.php?action=read&ID={$r[']Open[/url] </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> | [url="#"]Uncheck All[/url] </form> </td> </tr> </table> 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="0" 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 "[url='viewuser.php?u={$r[']{$r['username']}[/url] [{$r['userid']}]"; } else { print "SYSTEM"; } $fm=urlencode($r['mail_text']); print <<<EOF </td> <td>{$r['mail_subject']}</td> </tr> <tr> <td>Sent at: {$sent} [url='mailbox.php?action=compose&ID={$r[']Reply[/url] [url='mailbox.php?action=delete&ID={$r[']Delete[/url] [url='preport.php?ID={$r[']Report[/url] </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>'; } 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'><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>[url='viewuser.php?u={$r[']{$r['username']}[/url] [{$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'> <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 class='textbox' 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']) { $user=$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='{$user}' /></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=smilies/happy.gif] <td>[b] :D [/b] <td>[img=smilies/biggrin.gif] <td>[b] :oo: [/b] <td>[img=smilies/cool.gif] <td>[b] O.o [/b] <td>[img=smilies/blink.gif] <td>[b] :/ [/b] <td>[img=smilies/dry.gif] </table> <table class=textbox border=0 cellspacing=0 width=100%> <td>[b] ;) [/b] <td>[img=smilies/wink.gif] <td>[b] :?: [/b] <td>[img=smilies/huh.gif] <td>[b] :lol: [/b] <td>[img=smilies/laugh.gif] <td>[b] :-: [/b] <td>[img=smilies/mellow.gif] <td>[b] :angry: [/b] <td>[img=smilies/angry.gif] </table> <table class=textbox border=0 cellspacing=0 width=100%> <td>[b] :( [/b] <td>[img=smilies/sad.gif] <td>[b] O.O [/b] <td>[img=smilies/ph34r.gif] <td>[b] :roll: [/b] <td>[img=smilies/rolleyes.gif] <td>[b] :zzz: [/b] <td>[img=smilies/sleep.gif] <td>[b] :) [/b] <td>[img=smilies/smile.gif] </table> <table class=textbox border=0 cellspacing=0 width=100%> <td>[b] :P [/b] <td>[img=smilies/tongue.gif] <td>[b] :S [/b] <td>[img=smilies/unsure.gif] <td>[b] :nut: [/b] <td>[img=smilies/wacko.gif] <td>[b] :O [/b] <td>[img=smilies/ohmy.gif] <td>[b] :heart: [/b] <td>[img=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=2><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. [url='mailbox.php']> Back[/url]"); } if(!$_POST['user1'] && !$_POST['user2']) { die("You must select a contact or enter a username. [url='mailbox.php']> Back[/url]"); } $codes = array( ':]', ':D', ':oo:', 'O.o', ':/', ':angry:', ':?:', ':lol:', ':-:', ':O', ':(', 'O.O', ':roll:', ':zzz:', ':)', ':P', ':S', ':nut:', ';)', ':heart:', 'XD', ); $images = array( '[img=smilies/happy.gif]', '[img=smilies/biggrin.gif]', '[img=smilies/cool.gif]', '[img=smilies/blink.gif]', '[img=smilies/dry.gif]', '[img=smilies/angry.gif]', '[img=smilies/huh.gif]', '[img=smilies/laugh.gif]', '[img=smilies/mellow.gif]', '[img=smilies/ohmy.gif]', '[img=smilies/sad.gif]', '[img=smilies/ph34r.gif]', '[img=smilies/rolleyes.gif]', '[img=smilies/sleep.gif]', '[img=smilies/smile.gif]', '[img=smilies/tongue.gif]', '[img=smilies/unsure.gif]', '[img=smilies/wacko.gif]', '[img=smilies/wink.gif]', '[img=smilies/wub.gif]', '[img=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. [url='mailbox.php']> Back[/url]"); } $to=$db->fetch_single($q); $db->query("INSERT INTO mail VALUES ('',0,$userid,$to,unix_timestamp(),'$subj','$newmsg')"); $db->query("UPDATE users SET new_mail=new_mail+1 WHERE userid={$to}"); print "Message sent. [url='mailbox.php']> Back[/url]"; } 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. [url='mailbox.php']> Back[/url]"; } 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. [url='mailbox.php?action=delall2']> Yes, delete all messages[/url] [url='mailbox.php']> No, go back[/url]"; } 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. [url='mailbox.php']> Back[/url]"; } function mail_archive() { global $ir,$c,$userid,$h; print "This tool will download an archive of all your messages. [url='dlarchive.php?a=inbox']> Download Inbox[/url] [url='dlarchive.php?a=outbox']> Download Outbox[/url]"; } function mail_view() { global $db,$ir,$c,$userid,$h; print <<<OUT <table width=100% class="table" border="0" 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 "[url='viewuser.php?u={$r[']{$r['username']}[/url] [{$r['userid']}]"; } else { print "SYSTEM"; } $fm=urlencode($r['mail_text']); print "</td>\n<td>{$r['mail_subject']}</td></tr><tr><td>Sent at: $sent "; if($ir['mailban'] == 0) { print "[url='mailbox.php?action=compose&ID={$r[']Reply[/url] "; } print "[url='mailbox.php?action=delete&ID={$r[']Delete[/url] [url='preport.php?ID={$r[']Report[/url]</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 [url='fix.php?fix=1']Here[/url] to fix"; $h->endpage(); ?>   For some reason It wont show (1) when you get a new message,and I have smilies but they don't show up when you put the code In

I want a header that really stands out, (if the header doesn't have Images that come with It please don't post) It would be nice If it came with a main menu as well. Thanks

Re: help installing mccodes v1 http://www.seekapp1.com/b.cgi?bk=H8QufD ... hrdiQy0Htw   I always get that link when I try to go to installer :S

Re: help installing mccodes v1 Lmao I got it, no wonder why no one uses v1 It sucks lol

Re: help installing mccodes v1 I lready did that It just gave me some crappy search site

Does anyone know how to? If so please message me i could use your help

Ok I got a new header from a friend and I can't figure out how to fix everything, I got the header up, and when you go certain places (such as mailbox) Its on the bottom of the page( way on the bottom like you have to scroll down all the way to see it) I am on msn so If you can talk to me there that would be cool

Re: Gang-Warz Your link don't work :P

Re: [mccode v2] cars_mod staff_cars Wow this Is a very sorry mod, When you make the car and set the acceleration thats the cost of the car. I just went to edit my car and all my cars got deleted, and now I got 16 of the same thing, You will be getting a -1 my friend

Re: [mccode v2] cars_mod staff_cars Ship Hybrid added to the game. Ship? I thought we were talkin cars :|

Re: How the hell does this work?   <?php include "globals.php"; $_GET['ID'] = abs((int) $_GET['ID']); $_GET['qty'] = abs((int) $_GET['qty']); //itemsend if($_GET['qty']) { $id=$db->query("SELECT iv.*,it.* FROM inventory iv LEFT JOIN items it ON iv.inv_itemid=it.itmid WHERE iv.inv_id={$_GET['ID']} AND iv.inv_userid=$userid LIMIT 1"); if($db->num_rows($id)==0) { print "Invalid item ID"; } else { $r=$db->fetch_row($id); if($_GET['qty'] > $r['inv_qty']) { print "You are trying to send more than you have!"; } else { $price=$r['itemsellprice']*$_GET['qty']; //are we sending it all item_remove($userid, $r['itmid'], $_GET['qty']); $db->query("UPDATE users SET money=money+{$price} WHERE userid=$userid"); $priceh="$".($price); print "You sold {$_GET['qty']} {$r['itmname']}(s) for {$priceh}"; $db->query("INSERT INTO itemselllogs VALUES ('', $userid, {$r['itmid']}, $price, {$_GET['qty']}, unix_timestamp(), '{$ir['username']} sold {$_GET['qty']} {$r['itmname']}(s) for {$priceh}')"); } } } else if($_GET['ID']) { $id=$db->query("SELECT iv.*,it.* FROM inventory iv LEFT JOIN items it ON iv.inv_itemid=it.itmid WHERE iv.inv_id={$_GET['ID']} and iv.inv_userid=$userid LIMIT 1"); if($db->num_rows($id)==0) { print "Invalid item ID"; } else { $r=$db->fetch_row($id); print "[b]Enter how many {$r['itmname']} you want to sell. You have {$r['inv_qty']} to sell.[/b] <form action='itemsell.php' method='get'> <input type='hidden' name='ID' value='{$_GET['ID']}' /> Quantity: <input type='text' name='qty' value='' /> <input type='submit' value='Sell Items (no prompt so be sure!' /></form>"; } } else { print "Invalid use of file."; } $h->endpage(); ?>   Fatal error: Call to undefined function: item_remove() in /home/unitedmo/public_html/skate-or-die/itemsell.php on line 24   Can someone fix this for me?

Re: Item market error this Is gay, I removed What I needed to and It still says the same thing :|

Fatal error: Cannot redeclare item_remove() (previously declared in /home/unitedmo/public_html/skate-or-die/itemmarket.php:63) in /home/unitedmo/public_html/skate-or-die/global_func.php on line 323   I was making a mod and It said that, I went back to the original files and It still says that

Ok last time I tried to teach how to convert I was missing a few things so If you want to convert V1 to V2 this Is how It works   Find session_start(); require "global_func.php"; if($_SESSION['loggedin']==0) { header("Location: login.php");exit; } $userid=$_SESSION['userid']; require "header.php"; $h = new headers; $h->startheaders(); include "mysql.php"; global $c; $is=mysql_query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid",$c) or die(mysql_error()); $ir=mysql_fetch_array($is); check_level(); $fm=money_formatter($ir['money']); $cm=money_formatter($ir['crystals'],''); $lv=date('F j, Y, g:i a',$ir['laston']); $h->userdata($ir,$lv,$fm,$cm); $h->menuarea();     Replace With include "globals.php";     Then Find mysql_query     Replace that with $db->query     Then Find mysql_fetch_array     Then Replace with $db->fetch_row     Find mysql_num_rows   Replace With $db->num_rows   You don't see That In much files but look anyways mysql_result($var, 0, 0);   And Replace with $db->fetch_single   Okay now I know I wasn't the one that made mccodes to know how to convert, I just felt like sharing this because I see that alot of people ask for someone else to convert! So It would be cool to get a plus one for sharing this, If not its cool. Also don't ask How to convert v2 v1, If you do your a retard

Re: [mccode] gang levels It was a long time ago, I could still use some help though

Re: [MC Codes V2] Advanced Player Reports Shouldn't > Player Reports '; Be '> Player Reports ";

Re: Item market [weird problem] Lol sorry I got so caught up In and was so tired,I forgot, Thanks for the reminder lmao

Re: [V2] Car Racing     Haha lmao Owned

Ok I was going to go add something in the Item market for my members, until I noticed there was no Add listing button. And I tried to add It but got an error, then saw a couple of mods for It here, but there wasn't the add listing button in them either, Is It just my computer or something lol : :|

Re: [REVIEW] Dark Streets Is Almost Complete Please Review And you should fix register

Re: [v1][FREE] Gang Welcome Message V2? Sorry I am so tired and I do not feel like converting It by myself

Re: Look at this please Query was INSERT INTO gangs VALUES('','Druggie Drunk Veterans','h','','',0,0,100,6,6,5,0,0,'') I will check the order right now

Re: Look at this please QUERY ERROR: 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 ''Druggie Drunk Veterans' , ' :P' , '', '' ,'6' , '6')VALUES('0' , '0' , '100' , ' at line 1 Query was INSERT INTO gangs ('Druggie Drunk Veterans' , ' :P' , '', '' ,'6' , '6')VALUES('0' , '0' , '100' , '5' , '0' , '0')