uitooltip text from sql

[Krzychu20 3]

Hey, is it possible add to description of item information from sql database? I have new table with `itemid` and `specialvalue` columns, so I store different `specialvalue` for every items but i don't know exactly how can i print it in item description.

[Krzychu20 3]

REFRESH

[Python27 5]

La 30.09.2018 la 10:17, Krzychu20 a spus:

Hey, is it possible add to description of item information from sql database? I have new table with `itemid` and `specialvalue` columns, so I store different `specialvalue` for every items but i don't know exactly how can i print it in item description.

Yes it is possible where the tooltip is sent that argument "desclist" you declare something else like test1 = player.getdbinfo and u have to make into the source binary that function who read tables from db

[Krzychu20 3]

Sry for my dumb question but actually I not know what every file do so I'm not sure where can i start looking for. I tried find "desclist" but it isn't used anywhere so i guess u used it as example.
Anyway can u help me a bit more and say where can i start research?

[Krzychu20 3]

can someone explain a bit more?

[Krzychu20 3]

ok in theory i made it on my own way, but i have to do last step. Bons are showing but only when type of item in client is set to weapon/armor etc. How can i add it to type 18 or add specific vnum range

@SOLVED
i had to edit a bit uitooltip still ^^

[WeedHex 661]

DONT DO WHAT TITLE SAY..........

 

TOO DANGEROUS 

[iBeast 152]

If somebody unpacks your client and there will be database command with your login, you can say "Bye Bye".

[tierrilopes 507]

Add a new "specialvalue" column to your item_proto, matching the values you got on db and then use it.

[Krzychu20 3]

actually i had another special database where i store my values, anyway i make it on my own way, in server game i added if statement with item value range and if value is in range, then i do select query and set attr, like for weapon etc so all working on server side, and people can't do anything with that on client side

[r00t 154]

14 hours ago, Krzychu20 said:

actually i had another special database where i store my values, anyway i make it on my own way, in server game i added if statement with item value range and if value is in range, then i do select query and set attr, like for weapon etc so all working on server side, and people can't do anything with that on client side

Query? For tooltip? It's db killer...if i move mouse in-out the slot 20times for second...db do 20query! 10player do this and you have 200query...

 

Edit:better solution is to read new attr direct on boot (so you need to change sql select on db and add new values in items structure in client/server)...now you can read all informations from cache

[Krzychu20 3]

can u type how exactly i can read information exactly on boot and is it not problem how can i update it only when i type command ingame? xD

OK i load bonuses in char_item now i have to find rest xD
PS is it normal that after active item, my bonuses disapear?