Compiling Modify an C++ function

[Dankoo]

:s crap

 

[Bogart]

search for "auto loot script" you could use it as base.

 

[Dankoo]

Bogart, by searching this I found another thing that might be useful to me, I'll edit the topics name to suit it's new purposes, and edit first topic, to avoid spamming... Thanks.

 

[Dankoo]

OK, updating topic

It worked fine (with it's limitation of non-serial numbers)

But I'm trying this SQL query:

SELECT `player_id`,`pid`,`sid`,`itemtype`,CONVERT( `attributes` USING latin1 ) FROM `player_items` WHERE CONVERT( `attributes` USING latin1 ) LIKE '%trackid%';

And I receive like:

Gotcha?

 

[Cykotitan]

i already said before that you can't read the numbers directly with convert, so don't convert just select. then write a php script to select all the items and read their attributes using mazen's class

 

[Dankoo]

i already said before that you can't read the numbers directly with convert, so don't convert just select. then write a php script to select all the items and read their attributes using mazen's class

I don't speak marcian :s

now serious, there's no way to get trackid number with SQL queries?

 

[Dankoo]

Seriously now Cyk, I'm not retarded and I'm not lazy.

But I can't understand this mazen's class you passed me... Seriously, wtf?

Should I put this code he mentioned inside a <?

 ?> ('cause it's a php class, dtk)

To get that 100 character number from the example, where should I go? Couldn't find any number like this in player_items or something

Would be glad if could give a support on this matter lol

 

[Cykotitan]

because it's stored as binary data. you have to use some language to read it like php not sure if i can help you much here, but it seems you have to convert it to "numbers" first

 

[Dankoo]

If you can't help on something then the end of the world is near

I'm too tired to try it today though, let's see what happens... But I didn't understand a fucking thing of that lol

If sum1 with php knowledge knows where that script suppose to go and how to get an attribute number from it, and is willing to share, I thank.

Good night.

 

[Cykotitan]

i do PHP, but i'm not into classes really, i avoid using them

it should ideally be inside a second file and be named ItemAttributes.class.php
and then, of course, included using include() or require() function

 

[Dankoo]

Ok, I've managed the script to work.. Kind of

Still don't know where to get that 100 characters number to check my own items

Plus, how would I do an automatic system that deletes items with same trackid? serious, It's complicated to even get this number, wtf..

At fist I was thinking on doing like..

An globalevent that runs every hour an query to check for same trackid and delete them... crap =p