ok. this is all i need to do. grab the motd from the lua file and display it in text form... not as an image, as it does when you to to the roster index page...

and i want the text to be displayed on another page, out of the roster root folder.how can i do this

edit: oh yeah i also need to do this for the guild info...put it on another page..but it is not rendered as an image, it is rendered as text...but still how can i move it to another page

Include settings.php then read it from the $guild_info array

PleegWat wrote:Include settings.php then read it from the $guild_info array

could you please show me how to do this? i dont code php

i appreciate the help!

umm also 1 more thing. in the main roster view, is it possible to make all of the tables have the same width %?? i dont like it how it is now, each section is all blocked up..you see
http://www.derangedtaco.com/groster/
just, tell me where the table gets rendered, then i can change the width and go from there

kthx

edit: 2 more questions. 1) in this row

Code: Select all

Name     Class     Level     Announcements     Last Zone     Last Online

i want to switch"announcements" to "Rank", which makes more sense..where is this located

and....where is the top block located.. ? the navigation block that has the title, all of the addons, etc. because im only going to use this for the roster feature, that's all. thanks

sorry one more edit: i want to un-link my name in the roster, because i will not expect my members to get all of the mods n stuff, so i dont wanna be the only one with armor stats, etc..so how can i get rid of the url? you get my drift prolly...sorry not explaining self well..very sleepy..

rofl. 1 more. i want the notes not to show up in a tooltip when you mouseover a member, but to have it show up in the row..

any help pls? i sure can use some

edit another issue has come up for me: i try to upload my characterprofile.lua file to derangedtaco.com/groster/admin, and it says in the log 404 not found. does this file need to exist? i dont know how this works... i can manually upload the characterprofile.lua file, and it works, but i can't get uniuploader to get the job done.

You are in violation of our license agreement
Comply with it and you will be eligible for support

zanix wrote:You are in violation of our license agreement
Comply with it and you will be eligible for support

ugh sorry. i didnt mean to do that. i just see all of this crap down by the footer, think its ugly and remove all of the stuff in the footer file. i'm sorry. i didnt notice

how is it now?

The full credits are required
Blizzard requires them on every WoW related page

You also have to promise to not remove the credits after I help you

zanix wrote:The full credits are required
Blizzard requires them on every WoW related page

You also have to promise to not remove the credits after I help you

ok its up

and i give you my word

My advice is to just re-extract the original roster_footer.php from the zip package.

I see that you are trying to put the proper credits back so I'll help you out
We, and I'm sure blizz, appreciates this.

I would suggest finding some quick tutorials for php on the net, it will give you a good start and will give you some good fundamentals.

---

Upload data with UniUploader
The url you use to upload data to Roster is

Code: Select all

http://www.derangedtaco.com/groster/update.php

Not

Code: Select all

http://www.derangedtaco.com/groster/admin

---

Table width problem
Someone has already figured that out
http://www.wowroster.net/Forums/viewtopic/t=1819.html
and
http://wowroster.net/Forums/viewtopic/p=5748.html#5748

---

Announcements problem
I believe this is due to a localization error with the Announcements addon overriding a value in Roster's localization

Look at that addon's localization.php file and change that word
If it changes on the main page, then you know it is that addon's fault

If so, I would report this as a bug in that forum

---

The Roster Menu (top block)
The code is located at lib/menu.php
Menu management will get better in version 1.8, it will be more customizable
When editing this, all I ask is to leave the button/link to the credits page

---

No Character Details
Best way to achieve this is to clear (empty) all Roster tables except the following
This will clear all character specific data

• roster_config
• roster_guild
• roster_memberlog
• roster_members

Then open update.php in a text editor

Find this section

Code: Select all

if( is_array($uploadData['myProfile']) )
{
    $updateMessages = processMyProfile($uploadData['myProfile']);
}

if( is_array($uploadData['PvpLogData']) )
{
    $updatePvPMessages = processPvP($uploadData['PvpLogData']);
} 

And change to this

Code: Select all

/*
if( is_array($uploadData['myProfile']) )
{
    $updateMessages = processMyProfile($uploadData['myProfile']);
}

if( is_array($uploadData['PvpLogData']) )
{
    $updatePvPMessages = processPvP($uploadData['PvpLogData']);
}
*/ 

This edit will disable uploading of character data from CharacterProfiler.lua and PvPLog.lua

Then go into Roster Config and disable PvPLog uploading
It's in the "Main Settings" labeled "Allow upload of PvPLog Data"
This edit removes the pvplog.lua upload box on update.php

---

Notes in tooltips
Open memberslist.php
Find this

Code: Select all

function name_value ( $row ) 

This function controls the name column, which has to tooltip

Change this line

Code: Select all

$tooltip .= ($row['nisnull'] ? '' : "\n".$wordings[$roster_conf['roster_lang']]['note'].': '.$row['note']); 

To this

Code: Select all

//$tooltip .= ($row['nisnull'] ? '' : "\n".$wordings[$roster_conf['roster_lang']]['note'].': '.$row['note']); 

Next, go to Roster Config under "Display Config" labeled "Note Display Mode"
Change this to text

---

This may work for grabbing the motd

Edit and save anywhere on your web server

Code: Select all

<?php

// Set your guild name
$guild_name = 'GUILDNAME';

// Config this for your server settings
$mysql_db = 'roster';
$mysql_server = 'localhost';
$mysql_user = 'dbuser';
$mysql_pass = 'dbpass';




/***
  DO NOT EDIT BELOW
***/


// Connect to mysql database
$link = mysql_connect($mysql_server,$mysql_user,$mysql_pass);
if (!$link)
{
   die('Could not connect: ' . mysql_error());
}

// Select what database we will use
$db_selected = mysql_select_db($mysql_db,$link);
if (!$db_selected)
{
   die ('Could not select database: ' . mysql_error());
}

// Formulate Query
$query = sprintf("SELECT `guild_motd` FROM `roster_guild` WHERE `guild_name` = '%s';",
  mysql_real_escape_string($guild_name));

// Perform Query
$result = mysql_query($query);

// Check result
// This shows the actual query sent to MySQL, and the error. Useful for debugging.
if (!$result)
{
   $message  = 'Invalid query: ' . mysql_error() . "\n";
   $message .= 'Whole query: ' . $query;
   die($message);
}

// Use result
$row = mysql_fetch_assoc($result);

echo $row['guild_motd'];

// Free the resources associated with the result set
mysql_free_result($result);

?>

holy crap!!! thank you so much!!!
still, however, some problems..

-with the table width problem, it helped a lot, but still, the tables are a bit off...you see. at least in FF they are
- the no character details worked for the purpose i wanted it too, but it...created another problem. i need bank/bag data for a character of mine to be uploaded, for my guild bank...so is there just anyway to take out the link for each name? manually like that? i dont know how to explain this..help lol
- about the motd... yes that works perfectly! but i have a problem. with my cms, joomla, i cant put in php code. i also cant use iframes. but i can use javascript. is there any way to show the motd using javascript? i'm trying to think of how i could do this...ugh...LOL

thank you again

Cool, every time I try to "align" the tables, they screw up

Yeah, I said that edit will disable uploading of data
Unfortunately, there are a lot of places in Roster you would have to edit to remove the link
memberlist.php the main, honor, and stats page uses this code to render the tables
As for the other pages, it's kinda scattered

There is no way that I know of to access a mysql database with javascript

zanix wrote:Cool, every time I try to "align" the tables, they screw up

Yeah, I said that edit will disable uploading of data
Unfortunately, there are a lot of places in Roster you would have to edit to remove the link
memberlist.php the main, honor, and stats page uses this code to render the tables
As for the other pages, it's kinda scattered

There is no way that I know of to access a mysql database with javascript

i emailed Ramsbams from this topic c http://www.wowroster.net/Forums/viewtopic/t=1819.html because he made it work apparently

well....gosh..that sux... isnt there a single place where it does <a href="<php stuff that i dont know here? because that'd be really handy...

derangedtaco wrote:well....gosh..that sux... isnt there a single place where it does <a href="<php stuff that i dont know here? because that'd be really handy...

Nope, there is not

zanix wrote:

derangedtaco wrote:well....gosh..that sux... isnt there a single place where it does <a href="<php stuff that i dont know here? because that'd be really handy...

Nope, there is not

i made my own fix..sorta crappy but it works
check it out if you want

now if that guy'll help me with my tables problem...

edit: okay, all done