Post Reply 
 
Thread Rating:
  • 2 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[UPDATED]Paperdoll & Web
Author Message
Avatar
Journeyman
*

Posts: 172
Likes Given: 6
Likes Received: 27 in 12 posts
Joined: Apr 2012
Reputation: 5

The North Shield

Post: #1
[UPDATED]Paperdoll & Web
Quote:MyRunUo Php Script -- Sphere Server Entegration -- Rescripted by Avatar

Link for Php Script ==> http://crowskingdom.bizhat.com/MyRunUO-PHP-1.01/
Mysql (Sql) file is on web page i linked.

Example : www.tns.gen.tr/Player_Database/player.php?id=41014

System operation analogy was taken from RunUo C# script and adjusted for SphereServer

Requirements : Mysql Server, Apache Server - Php or Remote Connection ( whatever you wish )
Fundamentals for developing the content : Php Knowledge, Mysql Knowledge

Just change the myrunuo.inc.php files according to your information such as db username, password, server or so.
Also, it is important that you should create uofiles folder and put required mul files in it like the following ;

http://tns.gen.tr/Player_Database/uofiles/

This is not a full functioning script just a simple example of how to create Paperdoll on Web Page.

You can adjust it in several ways like player's statistics, online player, events that you created , etc.

I put one of the example of paperdoll that is functioning in my shard. You can see there.

Mainly items id is operated in php script according to decimal value. Therefore you should change id value to decimal.

Like for 0x23443 , make it in script like <eval <0x23443>>. Actually there is no "X" in our sphereserver. For colors, change them decimal too. Like 0234

==> <eval <0234>>, so and so forth..
/////////////////////////////////////////////////////////////////////////////////////////////////////////////
PHP Code:
[function f_set_mysphere_web// You can put it on login or operate it with timer on item , whatever you like.

serv.MySqlDatabase=mysphere // 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.

// Instead of deleting you can also update the content belong to uid like db.query update to related char_str,dex,guild so and so forth. But i would say that it is not convenient.

db.query insert into myrunuo_characters (char_idchar_namechar_strchar_dexchar_intchar_femalechar_countschar_guildchar_guildtitlechar_nototitlechar_bodyhuechar_publicVALUES ('<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_idlayer_iditem_iditem_hueVALUES ('<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_idskill_idskill_valueVALUES ('<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. 

PHP Code:
//// 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 
Instead of defnames, As simple , You can use <SERV.SKILL.<dlocal._for>.KEY> where <dlocal._for> is the loop id. Using defnames seems not practical indeed.

/// Adding Slash to String, Not to cause any syntax problem in mysql database. This might be a little advance for those who are not familiar with MYSQL issues.

PHP Code:
[function addslashes]
local.str=<asc <args>>
local.string=s
for i 0 strlen(<local.str>)
    
local.check=<strarg <local.str>>
    
local.last=<local.check>
    if (<
local.check> == 00)
        return <
strsub 1 <eval strlen(<local.string>)-2> <local.string>>
    endif
    if (<
local.check>=<asc \>)
        
local.last=<asc \>
        
local.string <strsub 0 <eval strlen(<local.string>)-1> <local.string>>\\s
    elif 
(<local.check>=<asc '>)
        local.string <strsub 0 <eval strlen(<local.string>)-1> <local.string>>\'s
    else
        local.string <strsub 0 <eval strlen(<local.string>)-1> <local.string>><chr <local.check>>s
    endif
    local.str=<streat <local.str>>
endfor
return <strsub 1 <eval strlen(<local.string>)-2> <local.string>> 


Attached File(s)
.txt  MySphere.txt (Size: 5.38 KB / Downloads: 185)
(This post was last modified: 01-01-2014 01:42 AM by Avatar.)
12-17-2013 09:22 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
[+] 5 users Like Avatar's post
Post Reply 


Messages In This Thread
[UPDATED]Paperdoll & Web - Avatar - 12-17-2013 09:22 PM
RE: Paperdoll & Web - Crusader - 12-17-2013, 09:42 PM
RE: Paperdoll & Web - Avatar - 12-17-2013, 09:54 PM
RE: Paperdoll & Web - admin_teclis - 12-20-2013, 04:20 AM
RE: Paperdoll & Web - Avatar - 12-20-2013, 10:03 AM
RE: Paperdoll & Web - admin_teclis - 12-21-2013, 11:06 PM
RE: Paperdoll & Web - Avatar - 12-22-2013, 05:08 AM
RE: Paperdoll & Web - admin_teclis - 12-22-2013, 06:18 AM
RE: Paperdoll & Web - amonvangrell - 12-22-2013, 08:46 AM
RE: Paperdoll & Web - admin_teclis - 12-22-2013, 08:54 AM
RE: Paperdoll & Web - Avatar - 12-22-2013, 10:24 AM
RE: Paperdoll & Web - admin_teclis - 12-22-2013, 08:14 PM
RE: Paperdoll & Web - XuN - 12-22-2013, 09:22 PM
RE: Paperdoll & Web - admin_teclis - 12-22-2013, 09:24 PM
RE: Paperdoll & Web - Avatar - 12-23-2013, 05:50 AM
RE: [UPDATED]Paperdoll & Web - darksun84 - 12-23-2013, 10:11 PM
RE: [UPDATED]Paperdoll & Web - Avatar - 12-24-2013, 06:37 PM
RE: [UPDATED]Paperdoll & Web - Avatar - 12-24-2013, 09:36 PM
RE: [UPDATED]Paperdoll & Web - Extreme - 12-26-2013, 12:27 AM
RE: [UPDATED]Paperdoll & Web - Avatar - 12-26-2013, 10:23 PM
RE: [UPDATED]Paperdoll & Web - horadryn - 12-31-2013, 11:28 PM
RE: [UPDATED]Paperdoll & Web - Avatar - 01-01-2014, 01:18 AM
RE: [UPDATED]Paperdoll & Web - Extreme - 01-05-2014, 03:59 AM
RE: [UPDATED]Paperdoll & Web - Extreme - 01-05-2014, 05:41 AM
RE: [UPDATED]Paperdoll & Web - Extreme - 01-05-2014, 08:20 AM
RE: [UPDATED]Paperdoll & Web - Avatar - 01-06-2014, 04:47 AM
RE: [UPDATED]Paperdoll & Web - Extreme - 01-07-2014, 08:06 AM
RE: [UPDATED]Paperdoll & Web - Extreme - 01-08-2014, 02:16 AM
RE: [UPDATED]Paperdoll & Web - Avatar - 01-08-2014, 05:18 AM
RE: [UPDATED]Paperdoll & Web - evening - 06-05-2014, 12:26 AM
RE: [UPDATED]Paperdoll & Web - Extreme - 06-05-2014, 02:25 AM
RE: [UPDATED]Paperdoll & Web - darksun84 - 06-05-2014, 02:42 AM
RE: [UPDATED]Paperdoll & Web - evening - 06-05-2014, 02:54 AM
RE: [UPDATED]Paperdoll & Web - Extreme - 06-05-2014, 04:06 AM
RE: [UPDATED]Paperdoll & Web - Feeh - 06-05-2014, 08:45 AM
RE: [UPDATED]Paperdoll & Web - evening - 06-05-2014, 01:21 PM
RE: [UPDATED]Paperdoll & Web - Avatar - 06-07-2014, 01:29 AM
RE: [UPDATED]Paperdoll & Web - evening - 06-07-2014, 01:14 PM
RE: [UPDATED]Paperdoll & Web - horadryn - 06-15-2014, 09:14 PM
RE: [UPDATED]Paperdoll & Web - Feeh - 06-16-2014, 03:24 AM
RE: [UPDATED]Paperdoll & Web - horadryn - 06-16-2014, 03:43 AM
RE: [UPDATED]Paperdoll & Web - Extreme - 06-16-2014, 07:19 AM
RE: [UPDATED]Paperdoll & Web - horadryn - 07-05-2014, 07:01 PM
RE: [UPDATED]Paperdoll & Web - horadryn - 06-16-2014, 08:31 PM
RE: [UPDATED]Paperdoll & Web - Coruja - 06-17-2014, 10:54 AM
RE: [UPDATED]Paperdoll & Web - Feeh - 06-17-2014, 11:58 AM
RE: [UPDATED]Paperdoll & Web - Extreme - 07-06-2014, 01:02 AM
RE: [UPDATED]Paperdoll & Web - horadryn - 07-07-2014, 06:11 PM
RE: [UPDATED]Paperdoll & Web - Avatar - 07-09-2014, 06:17 AM
RE: [UPDATED]Paperdoll & Web - horadryn - 07-12-2014, 11:55 PM
RE: [UPDATED]Paperdoll & Web - Feeh - 07-13-2014, 01:36 AM
RE: [UPDATED]Paperdoll & Web - Extreme - 09-08-2014, 10:46 AM
RE: [UPDATED]Paperdoll & Web - richm - 01-15-2015, 10:14 AM
RE: [UPDATED]Paperdoll & Web - Llirik - 09-17-2015, 05:14 AM
RE: [UPDATED]Paperdoll & Web - KyleH112 - 05-06-2016, 06:12 AM
RE: [UPDATED]Paperdoll & Web - Kanibal - 05-06-2016, 08:48 AM
RE: [UPDATED]Paperdoll & Web - KyleH112 - 05-06-2016, 09:38 AM
RE: [UPDATED]Paperdoll & Web - Kanibal - 05-06-2016, 11:04 AM
RE: [UPDATED]Paperdoll & Web - KyleH112 - 05-06-2016, 03:29 PM
RE: [UPDATED]Paperdoll & Web - Kanibal - 05-07-2016, 12:28 AM
RE: [UPDATED]Paperdoll & Web - Lilly - 02-05-2017, 02:58 AM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)