iseeyou94056 Posted November 2, 2007 Share Posted November 2, 2007 Re: [Mccode][Free] House Pictures sry you made little mistake with the ; its actually ; simple error Quote Link to comment Share on other sites More sharing options...
HITMAN 17 Posted November 4, 2007 Share Posted November 4, 2007 Re: [Mccode][Free] House Pictures can someone type the v1 out so ppl actually understand it as it is everywhere Quote Link to comment Share on other sites More sharing options...
HITMAN 17 Posted November 20, 2007 Share Posted November 20, 2007 Re: [Mccode][Free] House Pictures whats sql for that Quote Link to comment Share on other sites More sharing options...
-Matt- Posted February 9, 2008 Share Posted February 9, 2008 Re: [Mccode][Free] House Pictures So wich is the one what will work for v1? Quote Link to comment Share on other sites More sharing options...
HITMAN 17 Posted February 9, 2008 Share Posted February 9, 2008 Re: [Mccode][Free] House Pictures sql is wrong here seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem ERROR: Unclosed quote @ 111 STR: ' SQL: ALTER TABLE `houses` ADD `hPIC` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT ' MySQL said: Documentation #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 ''[/img]' at line 1 Quote Link to comment Share on other sites More sharing options...
Klikoka Posted February 9, 2008 Share Posted February 9, 2008 Re: [Mccode][Free] House Pictures it means you need you to change <img scr="e.g test.jpg" width="150" height="150"> the `e.g test.jpg` you need to change that to the default house pic Quote Link to comment Share on other sites More sharing options...
-Matt- Posted February 9, 2008 Share Posted February 9, 2008 Re: [Mccode][Free] House Pictures Someone just post a full post that works. Quote Link to comment Share on other sites More sharing options...
Klikoka Posted February 9, 2008 Share Posted February 9, 2008 Re: [Mccode][Free] House Pictures You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. For Image Add A Default House Pic Quote Link to comment Share on other sites More sharing options...
-Matt- Posted February 9, 2008 Share Posted February 9, 2008 Re: [Mccode][Free] House Pictures Confused.com Quote Link to comment Share on other sites More sharing options...
HITMAN 17 Posted February 9, 2008 Share Posted February 9, 2008 Re: [Mccode][Free] House Pictures it means you need you to change <img scr="e.g test.jpg" width="150" height="150"> the `e.g test.jpg` you need to change that to the default house pic is there a sql to do that Quote Link to comment Share on other sites More sharing options...
03laceys Posted February 11, 2008 Share Posted February 11, 2008 Re: [Mccode][Free] House Pictures this sql is worng: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. this is correct: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Hope this helps Quote Link to comment Share on other sites More sharing options...
HITMAN 17 Posted February 11, 2008 Share Posted February 11, 2008 Re: [Mccode][Free] House Pictures ok thnx 03lacey i just need this in v2 plz and then it shud work This is just a easy modification to your game because I am a noobie and just started to learn PHP. This modification is for House Pictures. I have put it so the house picture is the same size as your display picture...You will have to add seperate pictures on eahc house. Lets Start: Add this SQL: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Then open index.php: Find: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Then add underneath: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Then hopefully it should work 8-) If you have any problem PM me please. I am hoping to give out more little free modifications. Thanks Toxication Quote Link to comment Share on other sites More sharing options...
03laceys Posted February 11, 2008 Share Posted February 11, 2008 Re: [Mccode][Free] House Pictures that isnt hard to do open index.php and insert You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. under the notepad or somthing. ok thnx 03lacey i just need this in v2 plz and then it shud work This is just a easy modification to your game because I am a noobie and just started to learn PHP. This modification is for House Pictures. I have put it so the house picture is the same size as your display picture...You will have to add seperate pictures on eahc house. Lets Start: Add this SQL: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Then open index.php: Find: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Then add underneath: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Then hopefully it should work 8-) If you have any problem PM me please. I am hoping to give out more little free modifications. Thanks Toxication Quote Link to comment Share on other sites More sharing options...
HITMAN 17 Posted February 11, 2008 Share Posted February 11, 2008 Re: [Mccode][Free] House Pictures Parse error: syntax error, unexpected '<' in /home/a5069509/public_html/index.php on line 39 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...
03laceys Posted February 11, 2008 Share Posted February 11, 2008 Re: [Mccode][Free] House Pictures 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...
HITMAN 17 Posted February 11, 2008 Share Posted February 11, 2008 Re: [Mccode][Free] House Pictures works perfect thnx mate ya the best Quote Link to comment Share on other sites More sharing options...
shrek1609 Posted February 26, 2008 Share Posted February 26, 2008 Re: [Mccode][Free] House Pictures I've added this and got the images working just fine :-D But got a bit of a problem now trying to add new houses... I get this mysql error... QUERY ERROR: Column count doesn't match value count at row 1 Query was INSERT INTO houses VALUES(NULL, 'tent', '50000', '200') any help would be appreciated :) Quote Link to comment Share on other sites More sharing options...
shrek1609 Posted February 26, 2008 Share Posted February 26, 2008 Re: [Mccode][Free] House Pictures I think i've fixed the problem :) in staff_houses.php i've changed $db->query("INSERT INTO houses VALUES(NULL, '$name', '$price', '$will' )"); to $db->query("INSERT INTO houses VALUES(NULL, '$name', '$price', '$will', 'change')"); and seems to work fine now... Quote Link to comment Share on other sites More sharing options...
Ishy Posted February 27, 2008 Author Share Posted February 27, 2008 Re: [Mccode][Free] House Pictures Hope you all liked it :-D Quote Link to comment Share on other sites More sharing options...
03laceys Posted February 27, 2008 Share Posted February 27, 2008 Re: [Mccode][Free] House Pictures yes toxi we can see the all like it but i think you should update first post to my updated query to save members reading every comment finding the correct one Quote Link to comment Share on other sites More sharing options...
XCU53S Posted July 21, 2008 Share Posted July 21, 2008 Re: [Mccode][Free] House Pictures anyone post a working version in one post there are so many bit in here and so disorganised cant seem to figure out what is right Quote Link to comment Share on other sites More sharing options...
Mark F Posted July 21, 2008 Share Posted July 21, 2008 Re: [Mccode][Free] House Pictures anyone post a working version in one post there are so many bit in here and so disorganised cant seem to figure out what is right Why don't you just try the first post? I have used it in the past, and it does work. Quote Link to comment Share on other sites More sharing options...
XCU53S Posted July 21, 2008 Share Posted July 21, 2008 Re: [Mccode][Free] House Pictures ive tried but they dont work im on v2 btw so anyone can help me? Quote Link to comment Share on other sites More sharing options...
Paddy Posted July 21, 2008 Share Posted July 21, 2008 Re: [Mccode][Free] House Pictures ive tried but they dont work im on v2 btw so anyone can help me? correct me if im wrong! but this is how i did it and it worked for me upload pics! RUN SQL You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. then go to houses tables browse/hpic and for each house put in picture You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. change Defaulthouse to the name of the pic/house now if you want your pics in estate.php find {$mp['hNAME']} and next to it or create a new <table> add {$mp['hPIC']} hope this helps maybe not the perfect idea but it worked for me Quote Link to comment Share on other sites More sharing options...
Magictallguy Posted July 22, 2008 Share Posted July 22, 2008 Re: [Mccode][Free] House Pictures Using the post before mine, and the first post works fine. Why are argue when you can call it from the database? That's what it's there for.. 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.