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: #21
RE: [UPDATED]Paperdoll & Web
PHP Code:
db.query insert into 
myrunuo_characters
(char_idchar_namechar_strchar_dexchar_intchar_femalechar_countschar_guildchar_guildtitlechar_nototitlechar_bodyhuechar_public
VALUES 
('<eval <uid>>''<addslashes <name>>''<str>''<dex>''<int>''<sex>'null'<guild>'null'<title>''<eval <color>>'null

This is the only part you need to change. As you see there '<title>', change it like '<name>,<title>'. Or add a string like $char_name = raw['char_name'] and get it from database in PHP. I mean as there is query from database , take char_name too if missing.After that echo it like
PHP Code:
echo " '.$char_name.' "


Also i'm not the one who made this php script and it is not my duty to correct it. If you want to use it, just keep working on it. So you are programmer and you can fix it and share with us. But you are not acting like you know those stuffs. Sorry but It is not my type to directly write stuffs here. I will always be helpful by telling you the way that you can follow. I will not write here the way directly. It would be becase of your english. Maybe you got it wrong. Is there any guys understand this mysql stuff and volunteer to explain to him in his language, guys please Big Grin

In addition, First topic is reorganized.
(This post was last modified: 12-29-2013 12:08 AM by Avatar.)
12-24-2013 09:36 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Extreme
Grandmaster Poster
***

Posts: 1,140
Likes Given: 217
Likes Received: 89 in 76 posts
Joined: May 2012
Reputation: 20

SphereCommunity

Post: #22
RE: [UPDATED]Paperdoll & Web
Awesome!!! Congratulations Avatar and thanks for sharing.

STEPS BEFORE CREATE A THREAD
- Check the revisions log;
- Use the search button and use the keywords of your problem;
- Check the WIKI;
- Create a thread.
12-26-2013 12:27 AM
Find all posts by this user Like Post Quote this message in a reply
Avatar
Journeyman
*

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

The North Shield

Post: #23
RE: [UPDATED]Paperdoll & Web
You're welcome, no big deal.
12-26-2013 10:23 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
horadryn
Apprentice
*

Posts: 8
Likes Given: 2
Likes Received: 0 in 0 posts
Joined: Nov 2012
Reputation: 0



Post: #24
RE: [UPDATED]Paperdoll & Web
Hi! very nice job Smile
Do you think is compatible with this new myrunuo version?

http://www.runuo.com/community/threads/m...rt.534132/
12-31-2013 11:28 PM
Find all posts by this user Like Post Quote this message in a reply
Avatar
Journeyman
*

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

The North Shield

Post: #25
RE: [UPDATED]Paperdoll & Web
Well, sure. You can use this anywhere you like in case that if you know php very well. I can help you in my free time. You can ask me anything regarding this. I will look at link that you share and think on it.

Yep, the one who share worldpress stuff in Run UO platform mentioned about " html5 and advanced tables". If so, i would like to say yehaa Big Grin We will adjust it as we wish. It does not matter how it is complicated. Indeed, it is not.

Actually, we should define what support is ? It is really something compatible with anything ? In fact, there is no wording like supporting. If you know how to code something, then you shape your web site as you wish. So worldpress is a good open source blog web page which is really nice to operate with PHP. So you can add mysql tables and related parts to your php and html web pages incase you know how to do of course. As I said before, If you try on it and then if you stuck at anywhere, ask me a question. Otherwise, i will not really try to do completely worldpress stuff for SphereServer. There is indeed not much difference between RunUo and SphereServer. The analogy is the same and the working principle. I like to do this completely but these days, i donot really have much time as the finals about to come in my university Smile

Also, in link you share, as far as i've looked, there is really nice introduction how to set related tables and php codes to Worldpress. Only thing that you need to do is nothing but sending data to mysql. The rest are the same. Look at the function that i created to send data to mysql. Add incomplete part or change it, as i said shape it for the requirements. You can do that.
(This post was last modified: 01-01-2014 07:05 AM by Avatar.)
01-01-2014 01:18 AM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Extreme
Grandmaster Poster
***

Posts: 1,140
Likes Given: 217
Likes Received: 89 in 76 posts
Joined: May 2012
Reputation: 20

SphereCommunity

Post: #26
RE: [UPDATED]Paperdoll & Web
Avatar, could you help me?

I set everything... webserver, phpmyadmin, mysql etc...
Created a folder name Player_Database, put all files (.php) inside, and the folder 'uofiles' with the game files.

Used f_set_mysphere_web on my char (uid 01), the database is updated.

When I open my browser to try see the paperdoll using
localhost:8080/Player_Database/paperdoll.php?id=1
It frozen my webserver, then I need to restart it :/

When you come online, could you setup it for me? Using teamviewer ?
Thanks!!

Okay, got it to work.
Just changed back the port to 80 and set empty on .inc file.

The problem now is it don't show the paperdoll and skills.
It's like this:
http://solutionslab.it/ultima/screen.png

Any idea?

STEPS BEFORE CREATE A THREAD
- Check the revisions log;
- Use the search button and use the keywords of your problem;
- Check the WIKI;
- Create a thread.
(This post was last modified: 01-05-2014 04:59 AM by Extreme.)
01-05-2014 03:59 AM
Find all posts by this user Like Post Quote this message in a reply
Extreme
Grandmaster Poster
***

Posts: 1,140
Likes Given: 217
Likes Received: 89 in 76 posts
Joined: May 2012
Reputation: 20

SphereCommunity

Post: #27
RE: [UPDATED]Paperdoll & Web
Ok, was paperdoll.png missing at 'images' folder.
The skills still don't working, I can't find the pictures to put inside 'skills' folder.

I tried to fix the paperdoll but something is wrong here.
Hair is in front of helmet and robe is not in the right position...

Any idea?? Big Grin
   

STEPS BEFORE CREATE A THREAD
- Check the revisions log;
- Use the search button and use the keywords of your problem;
- Check the WIKI;
- Create a thread.
(This post was last modified: 01-05-2014 06:21 AM by Extreme.)
01-05-2014 05:41 AM
Find all posts by this user Like Post Quote this message in a reply
Extreme
Grandmaster Poster
***

Posts: 1,140
Likes Given: 217
Likes Received: 89 in 76 posts
Joined: May 2012
Reputation: 20

SphereCommunity

Post: #28
RE: [UPDATED]Paperdoll & Web
Okay, I just don't add chest and arms if I'm using robe.

On myrunuo.inc.php
Changed the old $skillnames to:

Code:
$skillnames = array("Alchemy","Anatomy","AnimalLore","Taming","Archery","ArmsLore","Begging","Blacksmithing","Bowcraft","Camping","Carpentry","Cartography","Cooking","DetectingHidden","Enticement","EvaluatingIntel","Fencing","Fishing","Forensics","Healing","Herding","Hiding","Inscription","ItemId","Lockpicking","Lumberjacking","MaceFighting","Magery","Meditation","Mining","Musicianship","Parrying","Peacemaking","Poisoning","Provocation","RemoveTrap","MagicResistance","Snooping","SpiritSpeak","Stealing","Stealth","Swordsmanship","Tactics","Tailoring","TasteId","Tinkering","Tracking","Veterinary","Wrestling ","Necromancy","Focus","Chivalry","Bushido","Ninjitsu","Spellweaving","Mysticism","Imbuing","Throwing");

Now all skills can be listed and are in sequence like in Sphere.

STEPS BEFORE CREATE A THREAD
- Check the revisions log;
- Use the search button and use the keywords of your problem;
- Check the WIKI;
- Create a thread.
(This post was last modified: 01-05-2014 11:08 AM by Mordaunt.)
01-05-2014 08:20 AM
Find all posts by this user Like Post Quote this message in a reply
Avatar
Journeyman
*

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

The North Shield

Post: #29
RE: [UPDATED]Paperdoll & Web
Ups, sorry bro. I was too busy. Therefore, couldn't look at it Smile Seems you are okay right now. For the position, you should adjust it by trying, like changing its position from php files. As a said before, the function i shared is not totally working function. In fact, it is totally working to generate paperdoll but for other stuffs, there are missing part. You can just add or change as you want it. You can check for position by sphere scripting like which item is prior to what or so and so forth. I mean which item is supposed to be inside of the character and outside. In order not to have conflict between you can just check by sphere server or php. As you wish.

Also, I uploaded skills images to my web site, i'm sharing the link below. You can download it from there.

http://www.tns.gen.tr/Player_Database/Pl...tabase.rar
(This post was last modified: 01-06-2014 04:53 AM by Avatar.)
01-06-2014 04:47 AM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
admin phoenix
Master
**

Posts: 354
Likes Given: 1
Likes Received: 23 in 13 posts
Joined: Mar 2012
Reputation: 3



Post: #30
RE: [UPDATED]Paperdoll & Web
it will be nice to use this one for joomla Smile
01-07-2014 12:08 AM
Find all posts by this user Like Post Quote this message in a reply
Post Reply 


Forum Jump:


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