XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module usage questions 
  4.  / Pull random quotes from RM Myfolder
Register
1
bassyard
Pull random quotes from RM Myfolder

  • 2007/2/7 23:18

  • bassyard

  • Not too shy to talk

  • Posts: 157

  • Since: 2003/10/5


Hi there,

I'm using RM soft's MyFolder for my portofolio.
It has a build in field for a comment from the Client about the work.
These comments can be displayed in a block but it isn't random, it takes the last x comments.

Is there an easy way to get it to pull a random quote instead of the last ones?

I think this is the php code from the block:

le="color: #000000"><?php function rmmf_bk_comments($options){ $db =& Database::getInstance(); $myts =& MyTextSanitizer::getInstance(); $result = $db->query("SELECT * FROM ".$db->prefix("rmmf_works")." ORDER BY id_w DESC LIMIT 0,$options[0]"); $block = array(); while ($row = $db->fetchArray($result)){ $rtn = array(); $rtn['id'] = $row['id_w']; $rtn['titulo'] = $row['titulo']; $rtn['texto'] = $myts->makeTareaData4Show($row['comentario']); $rtn['cliente'] = $row['cliente']; $block['works'][] = $rtn; } return $block; } function rmmf_bk_comments_edit($options){ $form = _BK_RMMF_NUMCOMMS."<br /><input type='text' size='5' name='options[]' value='$options[0]' />"; return $form; }


And this is the block template:

le="color: #000000"><?php <{foreach item=work from=$block.works}> <div style="font-size: 10px; text-align: right;"> <span style="font-style: italic;">"<{$work.texto}>"</span><br /> <a href="<{$xoops_url}>/modules/rmmf/view.php?id=<{$work.id}>"><{$work.cliente}></a> </div><br /> <{/foreach}>


I think it's an easy one if your good with php/mysql, which I'm not
. . . : : : | | | PressureLab.com | | | : : : . . .
2
zyspec
Re: Pull random quotes from RM Myfolder

  • 2007/2/8 2:35

  • zyspec

  • Module Developer

  • Posts: 1095

  • Since: 2004/9/21


bassyard,

I think the following code will do what you want if you replace the functions in the block with these.

NOTE: Make a backup of your current file BEFORE you try this. I have not tried this code since I don't have the module loaded.

le="color: #000000"><?php function rmmf_bk_comments($options){ $db =& Database::getInstance(); $myts =& MyTextSanitizer::getInstance(); $result = $db->query("SELECT * FROM ".$db->prefix("rmmf_works")." ORDER BY id_w DESC"); $block = array(); $tmparray = array(); while ($row = $db->fetchArray($result)){ $tmparray[] = $row; } $limit = (count($tmparray) < $options[0]) ? count($tmparray) : $options[0] ; $randarray = array_rand($tmparray,$limit) for ($i=0:$i<$limit:$i++) { $rtn = array(); $rtn['id'] = $tmparray[$randarray[$i]]['id_w']; $rtn['titulo'] = $tmparray[$randarray[$i]]['titulo']; $rtn['texto'] = $myts->makeTareaData4Show($tmparray[$randarray[$i]]['comentario']); $rtn['cliente'] = $tmparray[$randarray[$i]]['cliente']; $block['works'][] = $rtn; } return $block; } function rmmf_bk_comments_edit($options){ $form = _BK_RMMF_NUMCOMMS."<br /><input type='text' size='5' name='options[]' value='$options[0]' />"; return $form; }
3
bassyard
Re: Pull random quotes from RM Myfolder

  • 2007/2/8 10:17

  • bassyard

  • Not too shy to talk

  • Posts: 157

  • Since: 2003/10/5


Thx Zyspec! But when I try it I get a blank screen

Any other thoughts?
. . . : : : | | | PressureLab.com | | | : : : . . .
4
zyspec
Re: Pull random quotes from RM Myfolder

  • 2007/2/8 13:29

  • zyspec

  • Module Developer

  • Posts: 1095

  • Since: 2004/9/21


2 things...

1st... My DUMB mistake - should have read through the code before I sent it!

Change line 12 of the code I posted from:
le="color: #000000"><?php for ($i=0:$i<$limit:$i++) {


to:
le="color: #000000"><?php for ($i=0;$i<$limit;$i++) {


Note you're changing the ':' (colon) to a ';' (semicolon)

2nd... Turn on PHP debug in Admin=>Preferences and report back with any errors.
5
bassyard
Re: Pull random quotes from RM Myfolder

  • 2007/2/8 15:20

  • bassyard

  • Not too shy to talk

  • Posts: 157

  • Since: 2003/10/5


I'm getting this error now:

le="color: #000000"><?php Parse error: syntax error, unexpected T_FOR in cms/modules/rmmf/blocks/rmmf_recent.php on line 85 All errors (0) queries (14) blocks (4) extra (0) timers (4) Errors


That's this line:

le="color: #000000"><?php for ($i=0;$i<$limit;$i++) {


Thx for your time! Really appreciated!!
. . . : : : | | | PressureLab.com | | | : : : . . .
6
zyspec
Re: Pull random quotes from RM Myfolder

  • 2007/2/8 16:54

  • zyspec

  • Module Developer

  • Posts: 1095

  • Since: 2004/9/21


Aaarrrgggghhhh - another DUMB mistake.

Please add a ';' to the end of line 84 - which should look like:

le="color: #000000"><?php $randarray = array_rand($tmparray,$limit)[b][color=FF0000];[/color][/b]
7
bassyard
Re: Pull random quotes from RM Myfolder

  • 2007/2/8 19:19

  • bassyard

  • Not too shy to talk

  • Posts: 157

  • Since: 2003/10/5


heheh now the block shows but without any content
and the follow error appears:

le="color: #000000"><?php Notice: Undefined index: in file /modules/rmmf/blocks/rmmf_recent.php line 87 Notice: Undefined index: in file /modules/rmmf/blocks/rmmf_recent.php line 88 Notice: Undefined index: cliente in file /modules/rmmf/blocks/rmmf_recent.php line 90


If you can't find the problem: don't worry, I'll get a seperate quote module and enter the quotes there too so they appear in a block...
. . . : : : | | | PressureLab.com | | | : : : . . .
8
zyspec
Re: Pull random quotes from RM Myfolder

  • 2007/2/8 21:11

  • zyspec

  • Module Developer

  • Posts: 1095

  • Since: 2004/9/21


Hmmmm....

If I get time in the next couple of days I'll load the module on a test server and see if I can get it working.

In the mean time maybe one of the PHP gurus here can see the problem in the code - it's probably something obvious that I've overlooked but without loading it and debugging it I just don't see it off the top of my head. That's why they don't let the same people that code a module test it!

You did set the number of quotes to show in the block configuration, right?
9
bassyard
Re: Pull random quotes from RM Myfolder

  • 2007/2/9 7:48

  • bassyard

  • Not too shy to talk

  • Posts: 157

  • Since: 2003/10/5


Quote:

zyspec wrote:
You did set the number of quotes to show in the block configuration, right?


I forgot to check this, it was set to display 1 quote, but when I changed it to 2 quotes, they show without errors, and at random!!
When I changed it back to 1 quote, the quote dissappears again, and the errors are back...

I hope this helps with a sollution, if not: I thank you VERY much for your effort! I can use it with 2 qoutes meanwhile, so it's all good!!
. . . : : : | | | PressureLab.com | | | : : : . . .
10
zyspec
Re: Pull random quotes from RM Myfolder

  • 2007/2/11 22:56

  • zyspec

  • Module Developer

  • Posts: 1095

  • Since: 2004/9/21


bassyard,

I tried the code above (with the 2 sets of errors corrected) and the block displays random events correctly. I made one additional change in the code (although the original code worked fine) to remove sorting the customer comments in the SQL statement since they're randomized anyway and to only show Works with customer reviews in the block (eg. where customer review is not empty).

Please cut-and-paste the code below to replace your rmmf_bk_comments function and then let me know what happens.

le="color: #000000"><?php function rmmf_bk_comments($options){ $db =& Database::getInstance(); $myts =& MyTextSanitizer::getInstance(); $result = $db->query("SELECT * FROM ".$db->prefix("rmmf_works")." WHERE comentario != """); $block = array(); $tmparray = array(); while ($row = $db->fetchArray($result)){ $tmparray[] = $row; } $limit = (count($tmparray) < $options[0]) ? count($tmparray) : $options[0] ; $randarray = array_rand($tmparray,$limit); for ($i=0;$i<$limit;$i++) { $rtn = array(); $rtn['id'] = $tmparray[$randarray[$i]]['id_w']; $rtn['titulo'] = $tmparray[$randarray[$i]]['titulo']; $rtn['texto'] = $myts->makeTareaData4Show($tmparray[$randarray[$i]]['comentario']); $rtn['cliente'] = $tmparray[$randarray[$i]]['cliente']; $block['works'][] = $rtn; } return $block; }


Note: This modified code will display all Customer comments if the "Number of Comments" (set in block preferences) is larger than the number of Works that actually contain customer comments.
(1) 2 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Donat-O-Meter

Stats
Goal: $15.00
Due Date: Jul 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $15.00
Make donations with PayPal!

Latest GitHub Commits