Isomerizer Posted June 29, 2007 Share Posted June 29, 2007 This mod will make the item BB Gun be used for shooting bb bullets at people in the back. Theres several other things, that i'll leave you to find out, Like stats of BB gun, and you cannot hosp people with bb Gun. The user must purchase a BB gun to use this special feature. Enjoy... All tested by me and it worked. :) Can be seen @ www.amazon-survival.com Create injure.php with this code: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Then open inventory.php and find You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Under add: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Open the cron file daysold.php and find: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Above add: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Run SQL query: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. and You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. (Make sure you put the BB gun in a shop, and it must be itemid 110, Unless you change the code) Quote Link to comment Share on other sites More sharing options...
oxidati0n Posted June 29, 2007 Share Posted June 29, 2007 Re: [Free] [v1] BB Gun / Shoot Someone in Back! in phpmyadmin lol Quote Link to comment Share on other sites More sharing options...
Isomerizer Posted June 29, 2007 Author Share Posted June 29, 2007 Re: [Free] [v1] BB Gun / Shoot Someone in Back! sry lol where does INSERT INTO `items` ( `itmid` , `itmtype` , `itmname` , `itmdesc` , `itmbuyprice` , `itmsellprice` , `itmbuyable` ) VALUES ( '110', '4', 'BB Gun', 'Used for shooting peope in the back', '600', '400', '1' go Run it under SQL, or add the item manually. Your choice. Quote Link to comment Share on other sites More sharing options...
iseeyou94056 Posted June 29, 2007 Share Posted June 29, 2007 Re: [Free] [v1] BB Gun / Shoot Someone in Back! lol kk o and ALTER TABLE `users` ADD `bbgun` INT( 11 ) NOT NULL DEFAULT '0'; ADD `bbdamage` INT( 11 ) NOT NULL DEFAULT '0', ADD `bbfired` INT( 11 ) NOT NULL DEFAULT '0'; dont work Quote Link to comment Share on other sites More sharing options...
Isomerizer Posted June 29, 2007 Author Share Posted June 29, 2007 Re: [Free] [v1] BB Gun / Shoot Someone in Back! lol kk o and ALTER TABLE `users` ADD `bbgun` INT( 11 ) NOT NULL DEFAULT '0'; ADD `bbdamage` INT( 11 ) NOT NULL DEFAULT '0', ADD `bbfired` INT( 11 ) NOT NULL DEFAULT '0'; dont work Worked fine for me, What SQL error you getting? Quote Link to comment Share on other sites More sharing options...
iseeyou94056 Posted June 29, 2007 Share Posted June 29, 2007 Re: [Free] [v1] BB Gun / Shoot Someone in Back! Error SQL query: ALTER TABLE `users` ADD `bbgun` INT( 11 ) NOT NULL DEFAULT '0'; MySQL said: Documentation #1060 - Duplicate column name 'bbgun' Quote Link to comment Share on other sites More sharing options...
Isomerizer Posted June 29, 2007 Author Share Posted June 29, 2007 Re: [Free] [v1] BB Gun / Shoot Someone in Back! Error SQL query: ALTER TABLE `users` ADD `bbgun` INT( 11 ) NOT NULL DEFAULT '0'; MySQL said: Documentation #1060 - Duplicate column name 'bbgun' Gah. That meens the column is already there, you musta already made the column bbgun? Try deleted it and restarting. Quote Link to comment Share on other sites More sharing options...
UCC Posted June 29, 2007 Share Posted June 29, 2007 Re: [Free] [v1] BB Gun / Shoot Someone in Back! Love the concept. I'll definately use this in some fashion. Could be fun! But as I tell everyone, adding stuff of limited importance in the User table is bad design. Make a new table for that junk. Quote Link to comment Share on other sites More sharing options...
$$ ?????? $$ Posted July 1, 2007 Share Posted July 1, 2007 Re: [Free] [v1] BB Gun / Shoot Someone in Back! nice mod Quote Link to comment Share on other sites More sharing options...
weewooz Posted May 26, 2008 Share Posted May 26, 2008 Re: [Free] [v1] BB Gun / Shoot Someone in Back! the sql dont work im using vr1 i get this #1064 - 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 'ADD `bbdamage` INT( 11 ) NOT NULL DEFAULT '0', ADD `bbfired` INT( 11 ) NOT NULL' at line 1 when trying to add the sql any ideas thanks Quote Link to comment Share on other sites More sharing options...
weewooz Posted May 26, 2008 Share Posted May 26, 2008 Re: [Free] [v1] BB Gun / Shoot Someone in Back! sql as gone in now but had to change a few things im now getting when trying to use the page injure.php is you dont own a bb gun when i do any ideas thanks Quote Link to comment Share on other sites More sharing options...
jds137 Posted July 28, 2008 Share Posted July 28, 2008 Re: [Free] [v1] BB Gun / Shoot Someone in Back! I got the same message. Please let me know what to do, t/y Quote Link to comment Share on other sites More sharing options...
Spudinski Posted July 28, 2008 Share Posted July 28, 2008 Re: [Free] [v1] BB Gun / Shoot Someone in Back! You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Becomes; You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Reference: http://dev.mysql.com/doc/refman/5.0/en/alter-table.html Quote Link to comment Share on other sites More sharing options...
jds137 Posted July 29, 2008 Share Posted July 29, 2008 Re: [Free] [v1] BB Gun / Shoot Someone in Back! Heres what I received, also I really like this mod alot, reminds me of my childhood. You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote Link to comment Share on other sites More sharing options...
Isomerizer Posted July 29, 2008 Author Share Posted July 29, 2008 Re: [Free] [v1] BB Gun / Shoot Someone in Back! $it=mysql_query("SELECT inv_id FROM `inventory` WHERE `inv_itemid`=110 AND `inv_userid`=$userid",$c); Change the 110 to the correct itemid. Should be located in the `items` table.. Quote Link to comment Share on other sites More sharing options...
jds137 Posted July 29, 2008 Share Posted July 29, 2008 Re: [Free] [v1] BB Gun / Shoot Someone in Back! It was because I had bb gun in the spot, instead of 110... lol I think Ill read more into this stuff Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.