grimsybaby Posted February 25, 2009 Posted February 25, 2009 heres a few revamps i have done, hope you like them :) Index.php (this uses House Images [V2] and Advanced Marriage Mod [V2]) You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Inventory.php (iamwicked helped slighty) (this uses Item Pic mod [V2]) You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Viewuser.php (this uses Profile Signatures [V2] and Personal Details [V2]) You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote
Dave Posted February 25, 2009 Posted February 25, 2009 Re: 3 Revamps [V2] iamwicked helped slighty Slightly! i fixed the whole itempic pic xD which is the only change :-) Quote
p_T_s Posted February 26, 2009 Posted February 26, 2009 Re: 3 Revamps [V2] How would i get a users equipped items to show up in their profiles (viewuser.php) I have tried added along the lines of the Inventory.php above, but it just shows my equipped items in everyones profiles. thx in advance to anyone who can help. Quote
bob324 Posted February 26, 2009 Posted February 26, 2009 Re: 3 Revamps [V2] How would i get a users equipped items to show up in their profiles (viewuser.php) I have tried added along the lines of the Inventory.php above, but it just shows my equipped items in everyones profiles. thx in advance to anyone who can help. It will be because you have used eg- $ir[itempic] instead of $r[itempic] Quote
MossY Posted February 27, 2009 Posted February 27, 2009 Re: 3 Revamps [V2] Panda.... ---------------------- 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 'AND us.userid != 3 AND u.user_level != 0' at line 1 Query was SELECT count(*) FROM userstats us LEFT JOIN users u ON us.userid=u.userid WHERE us.accuracy > AND us.userid != 3 AND u.user_level != 0 -------------------- in index.php.... Quote
POG1 Posted February 27, 2009 Posted February 27, 2009 Re: 3 Revamps [V2] How would i get a users equipped items to show up in their profiles (viewuser.php) I have tried added along the lines of the Inventory.php above, but it just shows my equipped items in everyones profiles. thx in advance to anyone who can help. why would you want to show their items? that would ruin attacking. Quote
grimsybaby Posted February 28, 2009 Author Posted February 28, 2009 Re: 3 Revamps [V2] Panda.... ---------------------- 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 'AND us.userid != 3 AND u.user_level != 0' at line 1 Query was SELECT count(*) FROM userstats us LEFT JOIN users u ON us.userid=u.userid WHERE us.accuracy > AND us.userid != 3 AND u.user_level != 0 -------------------- in index.php.... Mossy m8 find these and take them out, it should work. You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote
MossY Posted February 28, 2009 Posted February 28, 2009 Re: 3 Revamps [V2] nope :p Just chopped all this out.... $ir['strank']=get_rank($ir['strength'],'strength'); $ir['agirank']=get_rank($ir['agility'],'agility'); $ir['guarank']=get_rank($ir['guard'],'guard'); $ir['accrank']=get_rank($ir['accuracy'],'accuracy'); $ir['labrank']=get_rank($ir['labour'],'labour'); $ir['endrank']=get_rank($ir['endurance'],'endurance'); $ir['IQrank']=get_rank($ir['IQ'],'IQ'); $tsrank=get_rank($ts,'strength+agility+guard+accuracy'); $ts2rank=get_rank($ts2,'labour+endurance+IQ'); Working now :) Quote
vampireduff Posted March 13, 2009 Posted March 13, 2009 Re: 3 Revamps [V2] where do you add the pictures for the images? do you just upload them to the image folder in the cpanel? Quote
Magictallguy Posted March 14, 2009 Posted March 14, 2009 Re: 3 Revamps [V2] where do you add the pictures for the images? do you just upload them to the image folder in the cpanel? Create a directory called "itmpics" and upload into there! Quote
vampireduff Posted March 14, 2009 Posted March 14, 2009 Re: 3 Revamps [V2] ok done that, but still can't get the pics to be displayed. is there supposed to be a file called 'displayadd.php'? coz I don't have one Quote
Zero-Affect Posted March 14, 2009 Posted March 14, 2009 Re: 3 Revamps [V2] no offense but what exactly did you change? Quote
grimsybaby Posted March 14, 2009 Author Posted March 14, 2009 Re: 3 Revamps [V2] no offense but what exactly did you change? they arnt remakes, just revamps make the layout's look nicer :) Quote
TheBigChief Posted March 14, 2009 Posted March 14, 2009 Re: 3 Revamps [V2] Got all working except the index.php and houses mods :-( Quote
vampireduff Posted March 14, 2009 Posted March 14, 2009 Re: 3 Revamps [V2] I'm have only used the Inventory.php, but can't get the pics to work, do I have to use all three? Quote
grimsybaby Posted March 15, 2009 Author Posted March 15, 2009 Re: 3 Revamps [V2] no you dont need all 3 to work but for most of them to work u'll need the other mods i posted links to above the code :) that will get them to work if not contact me, "[email protected]" <-- add me on msn and ill see what i can do :) Quote
ReaSonZ Posted April 19, 2009 Posted April 19, 2009 Re: 3 Revamps [V2] 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 '' at line 1 Query was SELECT * FROM users WHERE userid= view user Quote
Phantom Posted June 4, 2009 Posted June 4, 2009 Re: 3 Revamps [V2] seems great ... but what is Display ??? displayadd.php Quote
Danny696 Posted July 29, 2009 Posted July 29, 2009 Re: 3 Revamps [V2] i know this is old but what is displayadd.php? Quote
kaine- Posted December 22, 2009 Posted December 22, 2009 says this on view user 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 '' at line 1 Query was SELECT * FROM users WHERE userid= how can i sort it? Quote
Jordan Palmer Posted December 22, 2009 Posted December 22, 2009 Open up the file and check the Query -.- and please make sure you're trying to view a Valid user on ur game Quote
iR00T Posted December 22, 2009 Posted December 22, 2009 I am going to add these three revamps when I get back on my computer, I can't ever seem to get that item house pic to work, It would be cool if there was national cleanup day on here were people would take allthe broken files and update them correctly in the original post. It saves time to having looking threw all the posts for the "Correct" or the "Fix way of it. Either way, I like the revamps man good job. Quote
Jordan Palmer Posted December 23, 2009 Posted December 23, 2009 I am going to add these three revamps when I get back on my computer, I can't ever seem to get that item house pic to work, It would be cool if there was national cleanup day on here were people would take allthe broken files and update them correctly in the original post. It saves time to having looking threw all the posts for the "Correct" or the "Fix way of it. Either way, I like the revamps man good job. Not hard to fix. I'll add it to my 'to do' list Quote
Shakeynath Posted December 23, 2009 Posted December 23, 2009 Could you post a advanced marriage mod please need it desperately lol ^^ Or does anyone know were i can find this mod that will help loads thankyouu 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.