Post: #4

Hi Avatar,
i have a problem with your script. My paperdoll.scp:

[function f_set_mysphere_web] // You can put it on login or operate it with timer on item , whatever you like.

serv.MySqlDatabase=sphere // I prefer to use my data seperately since sometimes is diffucult to maintain all of them in same database.Yet, you can neglect this part or change accordingly.

db.connect
db.execute delete from myrunuo_characters where char_id='<eval <uid>>' // Each time players want to see their paperdoll, data belong to player should be removed and replaced by the new one.

db.query insert into myrunuo_characters (char_id, char_name, char_str, char_dex, char_int, char_female, char_counts, char_guild, char_guildtitle, char_nototitle, char_bodyhue, char_public) VALUES ('<eval <uid>>', '<addslashes <name>>', '<str>', '<dex>', '<int>', '<sex>', null, '<guild>', null, '<title>', '<eval <color>>', null) // Character Informations, you can adjust if there is missing part.


db.execute delete from myrunuo_characters_layers where char_id='<eval <uid>>' // Removing layers to replace again in order not to duplicate.

// Inserting data of layers from <src>
for x 1 24
if <findlayer.<dlocal.x>>
ref1 = <findlayer.<dlocal.x>.uid>
db.query insert into myrunuo_characters_layers (char_id, layer_id, item_id, item_hue) VALUES ('<eval <ref1.cont.uid>>','<dlocal.x>','<eval <ref1.id>>','<eval <ref1.color>>') //
endif
endfor
// Character skills
for x 1 49
db.query insert into myrunuo_characters_skills (char_id, skill_id, skill_value) VALUES ('<eval <uid>>','<dlocal.x>','<<def.player_skill_<dlocal.x>>')
endfor

db.close
serv.MySqlDatabase=sphere // Changing default mysql database set in sphere.ini in order not to cause any problems.

//// DEFNAME //
[defname player_skilldown]
player_skill_1 Alchemy
player_skill_2 Anatomy
player_skill_3 AnimalLore
player_skill_4 Taming
player_skill_5 Archery
player_skill_6 ArmsLore
player_skill_7 Begging
player_skill_8 Blacksmithing
player_skill_9 Bowcraft
player_skill_10 Camping
player_skill_11 Carpentry
player_skill_12 Cartography
player_skill_13 Cooking
player_skill_14 DetectingHidden
player_skill_15 Enticement
player_skill_16 EvaluatingIntel
player_skill_17 Fencing
player_skill_18 Fishing
player_skill_19 Forensics
player_skill_20 Healing
player_skill_21 Herding
player_skill_22 Hiding
player_skill_23 Inscription
player_skill_24 ItemId
player_skill_25 Lockpicking
player_skill_26 Lumberjacking
player_skill_27 MaceFighting
player_skill_28 Magery
player_skill_29 Meditation
player_skill_30 Mining
player_skill_31 Musicianship
player_skill_32 Parrying
player_skill_33 Peacemaking
player_skill_34 Poisoning
player_skill_35 Provocation
player_skill_36 RemoveTrap
player_skill_37 MagicResistance
player_skill_38 Snooping
player_skill_39 SpiritSpeak
player_skill_40 Stealing
player_skill_41 Stealth
player_skill_42 Swordsmanship
player_skill_43 Tactics
player_skill_44 Tailoring
player_skill_45 TasteId
player_skill_46 Tinkering
player_skill_47 Tracking
player_skill_48 Veterinary
player_skill_49 Wrestling

And in the sphere console error:

19:13:ERROR:(paperdoll.scp,6)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,8)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,8)Can't resolve <addslashes AoA>
19:13:ERROR:(paperdoll.scp,8)Can't resolve <str>
19:13:ERROR:(paperdoll.scp,8)Can't resolve <dex>
19:13:ERROR:(paperdoll.scp,8)Can't resolve <int>
19:13:ERROR:(paperdoll.scp,8)Can't resolve <sex>
19:13:ERROR:(paperdoll.scp,8)Can't resolve <guild>
19:13:ERROR:(paperdoll.scp,8)Can't resolve <color>
19:13:ERROR:(paperdoll.scp,11)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.1>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.2>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.3>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.4>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.5>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.6>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.7>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.8>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.9>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.10>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.11>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.12>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.13>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.14>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.15>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.16>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.17>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.18>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.19>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.20>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.21>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.22>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.23>
19:13:ERROR:(paperdoll.scp,15)Can't resolve <findlayer.24>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>
19:13:ERROR:(paperdoll.scp,22)Can't resolve <uid>

Why does functionally ?

Tnx for the reply...