[Solved] SQL errors when visualising priests sorts ...

by **Elunarya** » Fri Aug 18, 2006 1:08 pm

The WoWroster version used is the 1.7.0 with french translation. It works perfectly, but visualising priests sorts (book of sorts) causing theses SQL warnings :

Examples : http://lesloupsargentes.be/WowRoster/ch ... =spellbook

Code: Select all: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home.2/l/e/s/lesloups/www/WowRoster/lib/wowdb.php on line 153 Warning: Invalid argument supplied for foreach() in /home.2/l/e/s/lesloups/www/WowRoster/lib/char.php on line 649

This priest has "priest of healing rank 5 and renew rank 10. It dosen't appear on the roster. And, shadow sorts can't visualised.

Another example : http://lesloupsargentes.be/WowRoster/ch ... =spellbook
The SQL warning and PHP errors are same as above. Can you help us to fix the problem ?

The problem sudently appear when our priest aqquier new rank sorts on AQ20 instance ...

by **lesablier** » Fri Aug 18, 2006 11:08 pm

Hello.

Same Problem with a french roster and Priest
http://guilde.les.sabliers.free.fr/rost ... =spellbook

Code: Select all: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/135/sdb/4/2/guilde.les.sabliers/roster/lib/wowdb.php on line 153 Warning: Invalid argument supplied for foreach() in /mnt/135/sdb/4/2/guilde.les.sabliers/roster/lib/char.php on line 649

This is a fresh installation of wowroster.

by **lesablier** » Sun Aug 20, 2006 2:02 pm

Bump.

The skills in shadow link are empty and the description whith the mouse on
icon skull is missing, in french it's :

Code: Select all: Magie de l'ombre

http://guilde.les.sabliers.free.fr/rost ... =spellbook

Here an example

by **zanix** » Sun Aug 20, 2006 5:09 pm

I honestly don't know what causing this...
Any chance that I can get a copy of the priest's CP.lua file?

by **lesablier** » Mon Aug 21, 2006 3:39 am

Link in your PM

by **zanix** » Mon Aug 21, 2006 3:57 am

I didn't get a PM

by **Exerladan** » Mon Aug 21, 2006 6:10 pm

Hi,

It's a little quote problem.

Use the file below instead.

by **zanix** » Tue Aug 22, 2006 6:20 am

Really, is that it?
Found the line and changed it

Can we get a confirmation if this works from the others with this problem?

by **Exerladan** » Tue Aug 22, 2006 1:00 pm

Really it works

=> http://exerladan.free.fr/roster/

by **Moodj** » Tue Aug 22, 2006 2:22 pm

Thaznks a lot, I'll try to apply it at noon !

Exerladan, you have a PM about a bug on instance key on your roster

by **lesablier** » Wed Aug 23, 2006 3:28 am

It's work

Thanks Exerladen.

However here is stil a little litte little bug:
When you pass the mouse over the Skil name

General =>Général (in french) ok

For Shadow it must be : Magie de l'ombre " but no display when you
pass the mousse.

Any idee ?

by **zanix** » Wed Aug 23, 2006 5:39 am

lib/char.php
Find

Code: Select all: <img class="spell_skill_tab_icon" src="'.$roster_conf['interface_url'].$tree['icon'].'.'.$roster_conf['img_suffix'].'" onmouseover="overlib(\''.$tree['name'].'\',WRAP,RIGHT);" onmouseout="return nd();" alt="" onclick="showSpellTree(\'spelltree_'.$tree['id'].'\');" />

Replace with

Code: Select all: <img class="spell_skill_tab_icon" src="'.$roster_conf['interface_url'].$tree['icon'].'.'.$roster_conf['img_suffix'].'" onmouseover="overlib(\''.addslashes($tree['name']).'\',WRAP,RIGHT);" onmouseout="return nd();" alt="" onclick="showSpellTree(\'spelltree_'.$tree['id'].'\');" />

by **Exerladan** » Wed Aug 23, 2006 2:03 pm

As Zanix wrote it, an other quote problem

by **lesablier** » Wed Aug 23, 2006 10:35 pm

ok it works.

Thank you every one !!!!

Ps: Elunarya could change the topic subjetc to [Solved]

by **Elunarya** » Thu Aug 24, 2006 2:43 pm

I'll do that thanks

.

[Solved] SQL errors when visualising priests sorts ...

[Solved] SQL errors when visualising priests sorts ...

Re: SQL errors when visualising priests sorts ...

Re: SQL errors when visualising priests sorts ...

SQL errors when visualising priests sorts ...

Re: SQL errors when visualising priests sorts ...

SQL errors when visualising priests sorts ...

Re: SQL errors when visualising priests sorts ...

SQL errors when visualising priests sorts ...

Re: SQL errors when visualising priests sorts ...

SQL errors when visualising priests sorts ...

Re: SQL errors when visualising priests sorts ...

SQL errors when visualising priests sorts ...

Re: SQL errors when visualising priests sorts ...

Re: SQL errors when visualising priests sorts ...

SQL errors when visualising priests sorts ...

Who is online