View Item Information

[Faz`]

I got sick and tired of constantly going into the database to look up Item Information, the ID's, The Name etc. so I decided to make this, I just made this to save time and make it more accesssible.

1. Make a file called itemid.php

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

2. Add this to mainmenu.php or wherever you want:

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

Thanks and I hope you enjoy this, took about two minutes to do, just wanted to see if I could actually execute SQL properly, I kinda suck at it, but hey, I'm getting better, thanks for reading this topic and I hope this "mod" (if you can call it that) is some use to you.

[Ghostriders-oldnick]

Re: View Item Information

looks nice +1 saves alot of hastle

[Strats]

Re: View Item Information

This is nice I will defo add this to my game.

Thank you

[Feky]

Re: View Item Information

Parse error: syntax error, unexpected '&' in /home/feky/public_html/itemid.php on line 7

[Haunted Dawg]

Re: View Item Information

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

[jds137]

Re: View Item Information

great stuff

[Faz`]

Re: View Item Information

It always seems to come out wrong when I copy and paste it on here.

I'll update now.

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

There you go, much better.

Alright, its still playing up, I don't know what to do, sorry about this :(

[Faz`]

Re: View Item Information

I don't know what to do, all I can say is remove the annoying   or whatever it says, if not send me your email and I'll email you the file. Thanks.

[Haunted Dawg]

Re: View Item Information

Or just grab mine.. Faz, don't use the quick editor that is what screw's it up.

[Faz`]

Re: View Item Information

Alright, I'll try post up a proper one now.

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

[Haunted Dawg]

Re: View Item Information

Just a tip, i don't know if it is true.. but your query is pulling the thing's twice.

$sql = $db->query(

"SELECT i.*, i.itmid, i.itmname, i.itmdesc, i.itmbuyprice, i.itmsellprice " .

"FROM items i ");

Your pulling everything at i.* then again with the rest.

[Faz`]

Re: View Item Information

Hmm, what would I do then?

$db->query("SELECT itmid, itmname, itmbuyprice, itmsellprice FROM items");

Would that be better?

[Snake]

View Item Information

good job Optimus Prime great mod for looking at items added to the game so far....added just like you said works great....thanks for this will be greatly used,and abused by me....lol :thumbsup: :thumbsup:

[bladewolf2010]

anyway to make it so that you can edit the items.

like

ID Name Desc Price Sell Price Edit item

1 test test 1 1 Edit Item

[rulerofzu]

Use the staff items -> edit and if that doesnt cover everything you need code it so it does.

ffs do you actually understand anything posted blade?