Imagine i insert a data A into sql table and the same A is query back to html, the same can use decimal , hexadecimal to represent another data. like Emoji code have few table but only require simple A and you can choose to use Hexadecimal and the same A will be a luaghing logo. So i ask chat gpt what are the types i can use
I ask chatgpt to give me a list
And i ask chat gpt to go thru a-z and the values looks different and can be use for other data too.
since an A can run thru decimal become 97 and hexadecimal into 61 , binary 1100001 even base64 into YQ== so lets put into different use A = A query out A convert decimal become 97 and 97 can put into img tag and it will call out image 97.png A convert hexadeciaml become 61 and 61 can put into img tag and it will call out image 61.gif or animated png A convert binary become 110001 and 110001 can put into img tag and call out image 110001.png A convert octal become 141 and 141 can put into img tag call out 141.png o like simple 4 different value.Lets say in a game i chop a tree it will give me A item i can switch to decimal and insert into table 97.png if i switch into hexa and it will insert 61.png into table. if i switch into binary and it will insert 110001 .png into table. if i switch into octal and it will insert 141.png into table.if i send 'A' into table and store as A,when i query out i need to choose is it decimal or hexa or binary or octal when i query out , this way the simple A is store in minmum.if i choose store 97.png it will be large table each item will need more bytesbut if i put just A how to denote which to choose ?is it by area when character is at Magic realm all item change to decimal ?back in human realm it change to A.png ?what kind of mechanism needed to select or switch ? Area , date time ?, lucky draw ?
SO my inventory will inesrt A in the sql table.After query A = A query out if Date query from table is < 1 month A convert decimal become 97 and 97 can put into img tag and it will call out image 97.png is the tree trunk picture. if date query from table is > 1 month < 6 months A convert hexadeciaml become 61 and 61 can put into img tag and it will call out image 61.gif or animated png , brown color decay tree trunk if date query from table is > 6 months < than 12 months A convert binary become 110001 and 110001 can put into img tag and call out image 110001.png , Fugus Brown with green tree trunk if date query from table is > 12months <36months A convert octal become 141 and 141 can put into img tag call out 141.png , Rotting tree trunkso tree trunk can use, 97.pngBrown decay tree trunk also can use 61.pngFugus Brown growing tree trunk cannot use 11001.png Rotting tree trunk cannot use must throw alert user throw from inventory 141.pngso my table originally is
Now my table can be like this
And if query outWill get A and change to 97 if 1 monthsWill get 61 if 7 monthsSo my inventory out iframe will show 3 different wood. Following are the availabe non repeative img value
Lets say a folder put raw and inside i can have 43 raw items, each item can change 4 of itself like a into 97 so i can expire item, change class,
All the things are store as a -symbol 43 non repetivate, in this world even if i put tree folder there is more than 43 different types of treeraw iron and other can list out many ignot, liquid sapling also have eg. rubber, oilve oil and so on.and from raw to cooked folder i need to change folder name same a will be represented as cooked food 'a' instead of sql delete a and insert into cooked table.the old fashion way is
There is cron job run every hour i heard before or seen before where sql line is move into recycle table and hourly cronjob will delete. basically game alikea is raw rock found in river bed there is 4 conversion raw\61.png , raw\97.png , raw\141.png ,raw\1100001,png , raw\YQ== .pngi can do action wething to turn into sharp rock knife type
making 4 counts of wething each count change the rock shape and lastly wething\yq== .png is a knife like effect
a wethed rock knife like can also use 4 conversion until blunt knife maybe like use 10 count convert to 1,2,3,4 lastly wethed\YQ==.png So a metal ingot will be ingot\a.png smelted\a.png, weapon\a.png sword\a.png
The whole area has tree, plants, imagine if suddenly got snowAfter query A = A = A.png normal tree query out if Date query from table is snow effect A convert decimal become 97 and 97 can put into img tag and it will call out image 97.png is the white snow tree if date query from table is autum A convert hexadeciaml become 61 and 61 can put into img tag and it will call out image 61.gif or animated png tree dropping leaf animation if date query from table is sunny day A convert binary become 110001 and 110001 can put into img tag and call out image 110001.png , greenish tree if date query from table is Raining A convert octal become 141 and 141 can put into img tag call out 141.png , rain dropping tree effectso tree trunk can use, 97.pngBrown decay tree trunk also can use 61.pngFugus Brown growing tree trunk cannot use 11001.png Rotting tree trunk cannot use must throw alert user throw from inventory 141.png
The whole area has tree, plants, imagine if suddenly got snowwindows.time now doing a script every sec it get the time now and convert into those 4
SO my inventory will inesrt A in the sql table.After query A = A query out A convert decimal become 97 and 97 can put into img tag height px and it will be 97 px so arrange to big height decimanl has to go downif Date query from table is < 1 month A convert hexadeciaml become 61 and 61 can put into img tag heiht 61 px if date query from table is > 1 month < 6 monthsA convert decimal become 97 and 97 can put into img tag height px and it will be 97 px so if date query from table is > 6 months < than 12 months A convert octal become 141 and 141 can put into img tag height px will be 141 pxif date query from table is > 12months <36months A convert binary become 110001 and 110001 can put into img tag and call out image 110001.png too big cannot use