Storage Script?

This is guide mostly for website tools and code, for example CMS or registration scripts.
There can also be tools.

Moderators: osRose dev team, ospRose dev team, osiRose dev team, Moderators

Re: Storage Script?

Postby Ultra on Thu Feb 23, 2012 5:37 pm

About the icons it is OK
But do someone can give us the storage script? :D
Ultra
Rackie
Rackie
 
Posts: 226
Joined: Thu Jul 22, 2010 6:31 pm
Location: Usa

Re: Storage Script?

Postby hoegarden31 on Thu Feb 23, 2012 6:21 pm

Well once we have the images, it's not's that hard to make a table, and just put all the images on it.
The trickier part will be the description too. Or even just the name...
I'm the one and only. In heaven and on earth.
Image
hoegarden31
Rackie
Rackie
 
Posts: 150
Joined: Sun Nov 13, 2011 7:13 pm

Re: Storage Script?

Postby Mark on Thu Feb 23, 2012 6:31 pm

Well we dont even need to show item descriptions or names, that would mean having a whole new database with just item names/descriptions ect.

If we kept it to the basic:

Show Storage UI,
Show Icon Image,
Show Quantity

Then we should be ok

I'll get to work on doing some icon sheets, however I think we'll have to do our own sheets due to Different items ect.
Administrator / Coder for EutopiaRose Online
Image
http://www.eutopiarose.co.uk
User avatar
Mark
Rackie
Rackie
 
Posts: 176
Joined: Tue Dec 13, 2011 8:15 am
Location: Sunny England

Re: Storage Script?

Postby xadet3 on Thu Feb 23, 2012 6:43 pm

You could use a library I've created for a project (Revise.Files) to load the STBs/STLs and dump the item data to SQL quite easily.
xadet3
Pero pero
Pero pero
 
Posts: 727
Joined: Tue Jan 08, 2008 11:51 pm
Location: Norwich, England.

Re: Storage Script?

Postby Mark on Thu Feb 23, 2012 6:57 pm

We wanna try and keep it as simple as possible,

Insert php in modules
Insert Function php
Call Sql data for Account id
Load call values into UI table
Show UI table

If we go down the route of Dumping the stb/stl => sql then everyone else will have to aswell :? aswell as then setting up a rolling dump ( yeah sounds dirty ) as the Stb's are constantly changing ( new items added ect ect )
Couldn't we convert to csv from stb then load the csv through php from a database / server?
suppose then we still have the issue of having to convert the stb to csv every time a server implements new items....

Thoughts on a postcard :D
Administrator / Coder for EutopiaRose Online
Image
http://www.eutopiarose.co.uk
User avatar
Mark
Rackie
Rackie
 
Posts: 176
Joined: Tue Dec 13, 2011 8:15 am
Location: Sunny England

Re: Storage Script?

Postby xadet3 on Thu Feb 23, 2012 7:51 pm

You're going to have to re-crop the icons any way if you add new items and converting to CSV just adds a pointless extra step.
xadet3
Pero pero
Pero pero
 
Posts: 727
Joined: Tue Jan 08, 2008 11:51 pm
Location: Norwich, England.

Re: Storage Script?

Postby hoegarden31 on Fri Feb 24, 2012 11:54 am

don't need to re-crop. We can just use css to fit all the images ton our needs.
I will see what i can do with all this information :)
I'm the one and only. In heaven and on earth.
Image
hoegarden31
Rackie
Rackie
 
Posts: 150
Joined: Sun Nov 13, 2011 7:13 pm

Re: Storage Script?

Postby xadet3 on Fri Feb 24, 2012 12:06 pm

True, you could just sprite them, but you'd still have to reupload the images every time so it isn't as if dumping the STBs would be much of an effort.
xadet3
Pero pero
Pero pero
 
Posts: 727
Joined: Tue Jan 08, 2008 11:51 pm
Location: Norwich, England.

Re: Storage Script?

Postby PurpleYouko on Fri Feb 24, 2012 3:05 pm

It's no big deal dumping the STBs to a database.
Takes me about 30 minutes to dump all STBs and icons directly to my website.
For minor updates it would be a lot quicker since you only have to change a couple of icons at most.
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

Re: Storage Script?

Postby xadet3 on Fri Feb 24, 2012 4:07 pm

PurpleYouko wrote:Takes me about 30 minutes to dump all STBs and icons directly to my website.

:shock: It should take seconds, surely? Or are you doing it manually?
xadet3
Pero pero
Pero pero
 
Posts: 727
Joined: Tue Jan 08, 2008 11:51 pm
Location: Norwich, England.

PreviousNext

Return to PHP / Web Guides, Scripts and tools.

Who is online

Users browsing this forum: No registered users and 7 guests