vWar info block problem

Newbie Joined: Sep 06, 2005 Posts: 4 Location: UK - Wales

Hi,

I've got your block working on the Damage Inc website, however I'm getting the following problem with it:

Code:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/totalda/public_html/EU/blocks/block-vwar-infoblock.php on line 217

For some reason the war countdown is also not working, can you help?

---
PHP-Nuke Platinum
PHP version: 4.3.11
MySQL version: 4.0.23-standard
vWar version: 1.5 R9

Posted: Wed Sep 07, 2005 5:34 pm

for the sql error: edit the file block-vwar-infoblock.php
on row: 217 look for:

Code:

$rowvw = mysql_fetch_assoc($resultvw);

replace with

Code:

//$rowvw = mysql_fetch_assoc($resultvw);
$rowvw = $db->sql_fetchrow($resultvw);

As for the countdown:
http://www.tdi-hq.com/modules.php?name=Forums&file=viewtopic&t=668

Newbie Joined: Sep 06, 2005 Posts: 4 Location: UK - Wales

Excellent, that seems to have fixed the sql errors, many thanks! However the countdown still doesn't work for some reason.

I'll figure it out if it kills me. Sad

Newbie Joined: Sep 06, 2005 Posts: 4 Location: UK - Wales

By the way, I've edited the code to show more than one matchplanner in our block. I don't know if this helps you out chap, but here it is.

In block-vwar-infoblock.php
replace

Code:

//Who are your matchplanners? It is currently set to 1, will be more in next release
//put the planner's vwar id between the "";
$plannera = 1;

with

Code:

//Enter the access group id for your match planners here, if you don't know
//this, leave this setting as 3
$mpaccessid = 3;
//alternative access group id if there is another, otherwise leave this at 0
$altmpaccessid = 1;
//limit the number of match planners displayed in the block to this number
$maxmp = 2;

replace

Code:

$result26 = $db->sql_query("SELECT * FROM vwar".$n."_member WHERE memberid=$plannera");
$result27 = $db->sql_query("SELECT * FROM vwar".$n."_member WHERE memberid=$plannerb");

$num_rows1 = $db->sql_numrows($result26);
$num_rows2 = $db->sql_numrows($result27);
$num_rows = $num_rows1 +$num_rows2;
$contentmp .="<center>";
$contentmp .="Matchplanners: $num_rows ";
 while($row26=$db->sql_fetchrow($result26)) {
 $mcor=$row26[name];
 $ismember=$row26[ismember];
 $mcorid=$row26[memberid];
 $msn =$row26[msn];

$contentmp .= "$mcor: 
<IMG SRC='$indicator/msn/$msn'
border='0' ALT='MSN Online Status Indicator'> ";
$contentmp.= " <a href='modules.php?name=$vwar_modulename&file=member&action=mail&memberid=$mcorid'><img src='modules/$vwar_modulename/images/emailsend.gif' border='0'></a>

with

Code:

if ($altmpaccessid == 0) {
$result32 = $db->sql_query("SELECT * FROM vwar".$n."_member WHERE accessgroupid=$mpaccessid");
} else {
$result32 = $db->sql_query("SELECT * FROM vwar".$n."_member WHERE accessgroupid=$mpaccessid OR accessgroupid=$altmpaccessid");
}
$num_rows = $db->sql_numrows($result32);
if ($maxmp < $num_rows) { $numrows = $maxmp; }

$mprowctr = 0;
$contentmp .="<center>";
$contentmp .="Matchplanners: $num_rows ";
while($row32=$db->sql_fetchrow($result32) AND $mprowctr < $maxmp) {
$mcor=$row32[name];
$ismember=$row32[ismember];
$mcorid=$row32[memberid];
$msn =$row32[msn];
$contentmp .= "$mcor: <IMG height='22' width='22' SRC='$indicator/msn/$msn' border='0' ALT='MSN Online Status Indicator'>";
$contentmp.= " <a href='modules.php?name=$vwar_modulename&file=member&action=mail&memberid=$mcorid'><img src='modules/$vwar_modulename/images/emailsend.gif' border='0'></a> ";
$mprowctr++;
}

Hope this is useful.

Posted: Thu Sep 08, 2005 10:42 am

Hey,

With all the work on vwar Blackbox V2 and support, I hardly get to upgrade the block.

Newbie Joined: Sep 06, 2005 Posts: 4 Location: UK - Wales

Hey, no worries, you may also want to replace the OSI URL:
replace

Code:

http://osi.hshh.org:8088

with

Code:

http://www.funnyweb.dk:8080

hshh seems a bit slow, funnyweb is a lot quicker for some reason.

Still cant get the blasted countdown to work though, lol.

Newbie Joined: Oct 26, 2005 Posts: 35

Hi there how did you get these images to show in you version of the info block ?

I changed mine to your suggested

Quote:

http://www.funnyweb.dk:8080

But that didnt change them ?

Thanks in advance Ped

Newbie Joined: Jul 11, 2005 Posts: 2 Location: Salisbury

Not sure how he did it but here is how I did it on our site.

1st Create your own icons if you want and put them on your site and modify your code below to reflect where your icons are located.

Replace

Code:

$contentmp .= "$mcor: <IMG height='22' width='22' SRC='$indicator/msn/$msn' border='0' ALT='MSN Online Status Indicator'>";

with

Code:

$contentmp .= " $mcor: <A HREF=$indicator/message/msn/$msn><IMG height='24' width='75' SRC= '$indicator/msn/$msn/onurl=www.di-squad.org/US/images/msn_on.gif/offurl=www.di-squad.org/US/images/msn_off.gif/unknownurl=www.di-squad.org/US/images/msn_off.gif' border='0' ALT='MSN Online Status Indicator'>";

Newbie Joined: Nov 11, 2005 Posts: 3

Did't get the stuff with several matchplaners to work :S when i replaced the code, and uplodade the "block" again... the block just won't show up!

Newbie Joined: Jul 11, 2005 Posts: 2 Location: Salisbury

Hit me up on MSN and I can try and help you out.

Posted: Sat Nov 12, 2005 1:55 am

Newbie Joined: Nov 02, 2005 Posts: 3

I got the same problem as xGSTQ that no game icons show up on the info block only red dots ?

Shocked