iseeyou94056 Posted November 2, 2007 Posted November 2, 2007 Re: [Mccode][Free] House Pictures sry you made little mistake with the ; its actually ; simple error Quote
HITMAN 17 Posted November 4, 2007 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
HITMAN 17 Posted November 20, 2007 Posted November 20, 2007 Re: [Mccode][Free] House Pictures whats sql for that Quote
-Matt- Posted February 9, 2008 Posted February 9, 2008 Re: [Mccode][Free] House Pictures So wich is the one what will work for v1? Quote
HITMAN 17 Posted February 9, 2008 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
Klikoka Posted February 9, 2008 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
-Matt- Posted February 9, 2008 Posted February 9, 2008 Re: [Mccode][Free] House Pictures Someone just post a full post that works. Quote
Klikoka Posted February 9, 2008 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
-Matt- Posted February 9, 2008 Posted February 9, 2008 Re: [Mccode][Free] House Pictures Confused.com Quote
HITMAN 17 Posted February 9, 2008 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
03laceys Posted February 11, 2008 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
HITMAN 17 Posted February 11, 2008 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
03laceys Posted February 11, 2008 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
HITMAN 17 Posted February 11, 2008 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
03laceys Posted February 11, 2008 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
HITMAN 17 Posted February 11, 2008 Posted February 11, 2008 Re: [Mccode][Free] House Pictures works perfect thnx mate ya the best Quote
shrek1609 Posted February 26, 2008 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
shrek1609 Posted February 26, 2008 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
Ishy Posted February 27, 2008 Author Posted February 27, 2008 Re: [Mccode][Free] House Pictures Hope you all liked it :-D Quote
03laceys Posted February 27, 2008 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
XCU53S Posted July 21, 2008 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
Mark F Posted July 21, 2008 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
XCU53S Posted July 21, 2008 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
Paddy Posted July 21, 2008 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
Magictallguy Posted July 22, 2008 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
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.