[DEV] Warhammer Online Character List

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Anti-Spam Guide
Locked
User avatar
drumgirl67
Registered User
Posts: 145
Joined: Fri Sep 22, 2006 8:08 pm
Location: Dallas, TX
Contact:

[DEV] Warhammer Online Character List

Post by drumgirl67 » Fri Aug 29, 2008 1:31 am

Modification Name: Warhammer: Age of Reckoning Character List
Author:drumgirl67

Modification Description:: This mod will allow users to add Warhammer Online characters to their forum account, displaying both as a list page and by their forum avatar on posts.
Modification Version:: 0.1.1

A World of Warcraft version can be found here: http://www.phpbb.com/community/viewtopi ... 0&t=985675
An Age of Conan version can be found here: http://www.phpbb.com/community/viewtopi ... &t=1031855

Features: (hopefully) :mrgreen:
  • List page containing necessary character info done
  • Links from list page to forum profiles done
  • Ability for users to manually add characters done
  • Ability to differentiate between main and alt characters done
  • Main character information displayed near forum avatars done
Features that I will eventually get around to (no promises):
  • Data pulling from the realm war site
  • Main character information shown in user profile
Demo URL: http://www.5thhorizon.com/char_test
Demo Username: test
Demo Password: test123

Modification Download: http://phpbbwarroster.googlecode.com/fi ... er_011.zip
(NOTE: don't forget to refresh both your template and theme after installing)

Note: This mod is based off of one a WoW one I found for phpbb2 for my guild's forums. The mod was not listed here on this site, and I am not sure who the author was, but I would be more than willing to give credit where it's due if anyone happens to know.

Change log:
8/28/2008 initial beta version released
8/29/2008 small bug fixes
Last edited by drumgirl67 on Fri Aug 29, 2008 1:14 pm, edited 2 times in total.

User avatar
drumgirl67
Registered User
Posts: 145
Joined: Fri Sep 22, 2006 8:08 pm
Location: Dallas, TX
Contact:

Re: [DEV] Warhammer Online Character List

Post by drumgirl67 » Fri Aug 29, 2008 1:40 am

I am in the process of getting better "mini avatar" images as we speak, FYI.

Erm nevermind the servers down put a damper on that.





WAAAGH!

Heklyps
Registered User
Posts: 8
Joined: Tue Aug 12, 2008 5:47 pm
Location: FR
Contact:

Re: [DEV] Warhammer Online Character List

Post by Heklyps » Fri Aug 29, 2008 9:43 am

first troubles :

1) As I add my DK to the list I have an error (class length I guess)
SQL ERROR [ mysql4 ]

Data too long for column 'clss' at row 1 [1406]

SQL

INSERT INTO phpbb_war_characters (userid, name, lvl, clss, race, gender, tree1, tree2, tree3, main, realm) VALUES ( '53', 'Tir', '1', 'Disciple of Khaine', 'Dark Elf', 'F', '9', '9', '0', '1', 'unknown')

BACKTRACE


FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: war_characters.php
LINE: 374
CALL: dbal_mysql->sql_query()
2) Also don't you think that "Realm" entry should be replace with "Server (name)" ?

3) I don't know but there is maybe a mistake regarding war_char_icon.gif and icon_war_char.gif

User avatar
drumgirl67
Registered User
Posts: 145
Joined: Fri Sep 22, 2006 8:08 pm
Location: Dallas, TX
Contact:

Re: [DEV] Warhammer Online Character List

Post by drumgirl67 » Fri Aug 29, 2008 1:09 pm

Heklyps wrote:first troubles :

1) As I add my DK to the list I have an error (class length I guess)
SQL ERROR [ mysql4 ]

Data too long for column 'clss' at row 1 [1406]

SQL

INSERT INTO phpbb_war_characters (userid, name, lvl, clss, race, gender, tree1, tree2, tree3, main, realm) VALUES ( '53', 'Tir', '1', 'Disciple of Khaine', 'Dark Elf', 'F', '9', '9', '0', '1', 'unknown')

BACKTRACE


FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: war_characters.php
LINE: 374
CALL: dbal_mysql->sql_query()
2) Also don't you think that "Realm" entry should be replace with "Server (name)" ?

3) I don't know but there is maybe a mistake regarding war_char_icon.gif and icon_war_char.gif
For #1 run this SQL:

Code: Select all

ALTER TABLE phpbb_war_characters
 MODIFY clss   varchar(25);
For #2 the semantics for the mod I'm still working out, I will change that.

For #3 rename the icon as you suggested.
Last edited by drumgirl67 on Fri Aug 29, 2008 1:17 pm, edited 1 time in total.

User avatar
drumgirl67
Registered User
Posts: 145
Joined: Fri Sep 22, 2006 8:08 pm
Location: Dallas, TX
Contact:

Re: [DEV] Warhammer Online Character List

Post by drumgirl67 » Fri Aug 29, 2008 1:15 pm

I fixed the above bugs and updated the mod to 0.1.1.

Heklyps
Registered User
Posts: 8
Joined: Tue Aug 12, 2008 5:47 pm
Location: FR
Contact:

Re: [DEV] Warhammer Online Character List

Post by Heklyps » Sat Sep 13, 2008 6:33 pm

Hello

could you add the PVP rank (RR -00 to 80) to the roster ?

It would be great to have it displayed in the war_char and onto the post/profil.

Is it also possible to have class only selection and no race selection during the add character process? Or any link between them ?

ps : still sorry for my poor english :?

thx

Ashane
Registered User
Posts: 1
Joined: Sun Sep 14, 2008 5:50 am

Re: [DEV] Warhammer Online Character List

Post by Ashane » Sun Sep 14, 2008 5:53 am

Great mod....

I'd echo the PvP ranks and normal ranks.

Would be great if you could just swipe all the herald data and put it on there via a clickable link or something that opens up.

A+ :)

Fireslide
Registered User
Posts: 1
Joined: Tue Sep 16, 2008 10:43 am

Re: [DEV] Warhammer Online Character List

Post by Fireslide » Tue Sep 16, 2008 11:54 am

I like this :)

It has errors when you dont' put anything into one of the mastery fields, if you put a 0 it works fine. I've subscribed to this thread, I don't know much about php, but if I can help out in anyway other than just using it and reporting back bugs, let me know :)

Cheers and Thanks very much,

Sam

User avatar
Jaga
Registered User
Posts: 140
Joined: Mon Jun 23, 2008 5:10 am

Re: [DEV] Warhammer Online Character List

Post by Jaga » Sun Sep 21, 2008 10:25 pm

Fireslide wrote:I like this :)

It has errors when you dont' put anything into one of the mastery fields, if you put a 0 it works fine. I've subscribed to this thread, I don't know much about php, but if I can help out in anyway other than just using it and reporting back bugs, let me know :)

Cheers and Thanks very much,

Sam
Getting the same error. Altering the mySQL database so that those fields have defaults of '0' does not alleviate the problem. Other than this, seems to work well.

It would be nice to have a setting (even embedded in the php file), that tells the mod how many alts to display under the main. Right now I don't think it displays any, and I don't see a way to have it do so with a number change.

Edit: I was able to come up with the correct mySQL query changes to allow displaying alts underneath the main, and it will allow a specific total number of characters to be displayed (as far as data retrieval goes) with the following:

Code: Select all

			// WAR Character Mod Start
			$userid = $row['user_id'];
			$rofl = "SELECT name, lvl, clss, race, gender
				FROM phpbb_war_characters
				WHERE userid = $userid
				ORDER BY main DESC
				LIMIT 2";
			$lollerskates = $db->sql_query($rofl);
I went and figured out the while loop code changes myself, and now have it functioning just fine on my site. If you'd like the code, simply PM me and I'll make it available for you to use. Cheers.

Frode789
Registered User
Posts: 119
Joined: Sun Jan 06, 2008 7:57 pm
Location: Norway

Re: [DEV] Warhammer Online Character List

Post by Frode789 » Sat Oct 04, 2008 2:53 pm

Is this mod still alive?

Looks interesting.

User avatar
cozmicshredder
Registered User
Posts: 7
Joined: Sun Feb 08, 2004 4:57 am
Location: MI, USA.
Contact:

Re: [DEV] Warhammer Online Character List

Post by cozmicshredder » Wed Oct 08, 2008 3:35 am

Frode789 wrote:Is this mod still alive?

Looks interesting.
I think she pooped out already! :)

Well seeing all the feeds that WarDB is giving if she gets back to this maybe she can add feeds from their services to make this mod a lot better...

I already made a request for someone to make a mod for the Guild Feed and I am sure she could add them together... http://www.phpbb.com/community/viewtopi ... &t=1229525

Anyways lets hope Warhammer gets as much love as WOW does...
Image

User avatar
drumgirl67
Registered User
Posts: 145
Joined: Fri Sep 22, 2006 8:08 pm
Location: Dallas, TX
Contact:

Re: [DEV] Warhammer Online Character List

Post by drumgirl67 » Thu Apr 09, 2009 11:17 pm

Is there anyone still interested in this mod? I'm done with school so I have a bit more free time but I no longer use the mod myself so I'm not going to change anything or help anyone unless someone has a pressing need for it :P

Largo84
Registered User
Posts: 36
Joined: Tue Jun 24, 2008 1:31 pm

Re: [DEV] Warhammer Online Character List

Post by Largo84 » Tue Apr 14, 2009 10:55 am

I just used this mod and edited it to make a LOTRO version.
One thing I had to code in myself which is missing from all of your roster mods is the ability to set permissions for who can add characters.
I wanted it as a Guild Roster, but as it was, anyone who registered could add a character. So I just made it so that adding characters was not available to anyone who can't read the Guild Chat forum section. It's simple, but it might nto work in other peoples case as they will need to specify which forum section, so a Group Permission would definatly benifit.

Locked

Return to “[3.0.x] MODs in Development”