ItemType

06/15/2012 22:24 |xabi|#1
Hey, i need itemtype.sql For Albertos With the Last Version

Thanks
06/15/2012 23:17 pro4never#2
... make one?

The itemtype is part of the client. Decrypt it, parse it and execute to sql. That's how we made the original itemtype database. Don't be lazy.
06/16/2012 00:48 |xabi|#3
Thanks Dude,
but how to parse it :)
06/16/2012 01:06 pro4never#4
Write a program to do it...

Personally I'd just write a tool as part of albetros that when run will load up a decrypted itemtype, parse it and submit the sql queries all at once to simply update the existing table any time you wish.

shouldn't take more than about 10 minutes.
06/16/2012 01:09 |xabi|#5
just small example for it even if a program isn't complete
Thanks again!!
06/16/2012 01:26 pro4never#6
StreamReader sr = new StreamReader(File.Open(fileName));
string[] lines = sr.ReadtoEnd().Replace("&&", "&").Split('\r');

Now use Split('&') and you have individual components for each itemtype entry.

Build into an sql query and run it.
06/16/2012 01:40 |xabi|#7
it helped me so much thanks :)