ignite

Re: [TGM] Referal System [TGM] :-D

Re: So , What Do I Do Now???????????????????????????????????????????? Yup

It was worth a try

Re: [mccode] [TGM] Item Sell Logs [TGM] I have v1 but it shouldn't be a problem.

Re: [mccode] [TGM] Item Sell Logs [TGM] Well i have that case and your function but it don't work .

Re: [mccode] [TGM] Item Sell Logs [TGM] Is this the right case ? case 'viewitemselllogs': view_itemsell_logs(); break; I get an unidentified function error

Re: Register Explain further....

Re: Header Problem!!! There should be a bit your menu.php saying something like if($ir['userlevel']=2) { print " <a href=admin.php>

Re: Header Problem!!! You need to see what the user level in your menu area is set at to view the staff pannel.

Re: Register Thanks so much i had a look at other querys and found out i need a closing bracket after the speach mark so it looks like this {$_POST['promo']}')",$c); But i don't need the promo bit as there isn't a promo collum. Thanks again +1 for you.

Re: Register I tied that before and i got Parse error: syntax error, unexpected T_STRING in /home/criminal/public_html/register.php on line 75

Re: Register Oh yer lol spelling error there but i still get the same error i think it maybe becuase of a " or two 'of them in the wrong place

Re: Register Ok thanks man i think were getting their i now get this 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 '' at line 1

Re: Register Ok thanks well i typed in blah for everything and got this 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 'blah','blah','blah','blah'' at line 1

Re: Register Everthing in the users table if it helps   userid username userpass level exp money crystals laston lastip job energy will maxwill brave maxbrave maxenergy hp maxhp lastrest_life lastrest_other location hospital jail fedjail user_level gender daysold signedup gang daysingang course cdays jobrank donatordays email login_name display_pic duties bankmoney cybermoney staffnotes mailban mb_reason hospreason voted honor turns cars_owned cars_won cars_lost cars_challs_sent cars_challs_accpt cars_challs_decln cars_races_won cars_races_lost cars_races_income cars_races_friendly cars_races_betted forums_avatar forums_signature posts forumban fb_reason valog valfail valid jailreason crimecount warnings wreason attackslost attackswon crimecountf signature usernotes validation valtries honored new_annoucement mine_level mine_exp mine_needed power max_power gems name age realage homelocation hobby msn occupation married

Re: Register None the user just doesn't insert into the database

Re: Register mysql_query("INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney, lastip, name, age, homelocation, hobby, msn, occupation, promo ) VALUES( '{$username}', '{$username}', md5('{$_POST['password']}'), 1, $sm, 0, 0, 1, 12, 12, 100, 100, 5, 5, 100, 100, 1, 'male', unix_timestamp(), '{$_POST['email']}', -1, '$ip','{$_POST['name']}','{$_POST['age']},'{$_POST['homeloaction']}','{$_POST['hobby']}','{$_POST['msn']}','{$_POST['occupation']}','{$_POST['promo']}'", $c);   Thats what i have at the moment

I have recntly add some new collums to my users table like msn age etc. Now my register does not work and i don't no why. Any ideas ? I have put all the information like msn and that in there.

Re: [mccode] Additional Currency ALTER users ADD gems int(11) NOT NULL default '0',   Change gems to what ever you want your currency to be called then change the currency name in your header from gems to what ever you named your currency.

Re: Itemsend Well i have been testing itemsend and i think the problem is only with medical items.

Re: install help I have installed your codes twice now.

Re: Itemsend :?

Re: Itemsend I can't see what could be wrong

Re: Itemsend Yer i tried uploading the normal file before and it still don't work.

Re: Itemsend   $rm=mysql_fetch_array($m); //are we sending it all $_GET['qty']=abs((INT) $_GET['qty']); if($_GET['qty'] == $r['inv_qty']) { //just give them possession of the item mysql_query("UPDATE inventory SET inv_userid={$_GET['user']} WHERE inv_id={$_GET['ID']} LIMIT 1",$c); } else { //create seperate mysql_query("INSERT INTO inventory VALUES ('','{$r['inv_itemid']}',{$_GET['user']},{$_GET['qty']},0);",$c); mysql_query("UPDATE inventory SET inv_qty=inv_qty-{$_GET['qty']} WHERE inv_id={$_GET['ID']} LIMIT 1;",$c); } print "You sent {$_GET['qty']} {$r['itmname']}(s) to {$rm['username']}"; event_add($_GET['user'],"You received {$_GET['qty']} {$r['itmname']}(s) from [url='viewuser.php?u=$userid']{$ir['username']}[/url]",$c,'transfer'); mysql_query("INSERT INTO itemxferlogs VALUES('',$userid,{$_GET['user']},{$r['itmid']},{$_GET['qty']},unix_timestamp(),'{$ir['lastip']}','{$rm['lastip']}')",$c); } } } } else if($_GET['ID']) { $id=mysql_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",$c); if(mysql_num_rows($id)==0) { print "Invalid item ID"; } else if ($_GET['ID']==0) { die("Nono"); } else { $r=mysql_fetch_array($id);