You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 408 guest(s) and 22 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - Block Menu [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
Divvy
Lieutenant
Lieutenant


Joined: Jul 25, 2004
Posts: 218


PostPosted: Wed Dec 19, 2007 1:49 pm Reply with quoteBack to top

Please, can someone help me?
I have a block to show the users that are online in my site. But I want to show show them per username order. for example:

users online:
aradsa
badasda
dasaea
rsdasa
etc...

Can someone help me? Heres my block code:
http://casinosonline.com.sapo.pt/block.txt

Smile
Find all posts by DivvyView user's profileSend private message
jammyme
Nuke Soldier
Nuke Soldier


Joined: Jan 29, 2007
Posts: 22

Location: South Yorkshire, UK

PostPosted: Fri Dec 21, 2007 2:18 am Reply with quoteBack to top

Hi Divvy,

This should be fairly easy to achieve, it should just mean re-sorting the values the script fetches from the database by username.

I can't access the code you have linked, but if you're using the standard User Info block that comes with RavenNuke 7.6, the line you wish to edit should be around line #38:
Code:
$result = $db->sql_query("SELECT uname, guest FROM $prefix"._session." WHERE guest='0'");


You just want to add a "Order By" statement to change the order these are listed:

Code:
$result = $db->sql_query("SELECT uname, guest FROM $prefix"._session." WHERE guest='0' ORDER BY uname");


If you don't have a suitable editor, you can either use a simple text editor (like notepad.exe) or download a great free one like HAPedit (http://hapedit.free.fr).

Hope this helps, Very Happy
Find all posts by jammymeView user's profileSend private messageVisit poster's website
Divvy
Lieutenant
Lieutenant


Joined: Jul 25, 2004
Posts: 218


PostPosted: Fri Dec 21, 2007 3:16 am Reply with quoteBack to top

Hi mate,
Thank you for your reply Smile

But Im not using the standard User Info block.
Im using USER MENU v2.0 for PHP-Nuke 6.5+ © 2003 by Pitcher@Home

I have uploaded the file to another host, please take a look:
http://www.celebridadesdespidas.com/block.txt

Thanks for helping me
Find all posts by DivvyView user's profileSend private message
jammyme
Nuke Soldier
Nuke Soldier


Joined: Jan 29, 2007
Posts: 22

Location: South Yorkshire, UK

PostPosted: Fri Dec 21, 2007 4:05 am Reply with quoteBack to top

Hey Divvy,

Edit the file you have (Save a Backup First) and change the following line:

Code:
$memres = $db->sql_query("SELECT uname, guest FROM $prefix"._session." WHERE guest=0");


so that it reads:

Code:
$memres = $db->sql_query("SELECT uname, guest FROM $prefix"._session." WHERE guest=0 ORDER BY uname");


Hopefully that should work for you (taking a very quick look) Very Happy

_________________
Phil
Project Developer

Image
Find all posts by jammymeView user's profileSend private messageVisit poster's website
Divvy
Lieutenant
Lieutenant


Joined: Jul 25, 2004
Posts: 218


PostPosted: Fri Dec 21, 2007 6:18 am Reply with quoteBack to top

It works !!!! Thank you mate Very Happy

_________________
Sexo - Thongs - Legendas Divx
Find all posts by DivvyView user's profileSend private message
jammyme
Nuke Soldier
Nuke Soldier


Joined: Jan 29, 2007
Posts: 22

Location: South Yorkshire, UK

PostPosted: Fri Dec 21, 2007 6:39 am Reply with quoteBack to top

No worries dude, happy to help.

Making more mods now you've mentioned it, just to tidy my own user info block. Cheers!

_________________
Phil
Project Developer

Image
Find all posts by jammymeView user's profileSend private messageVisit poster's website
Divvy
Lieutenant
Lieutenant


Joined: Jul 25, 2004
Posts: 218


PostPosted: Thu Dec 27, 2007 4:12 pm Reply with quoteBack to top

Btw, I have a long list with members online. And I notice that after they leave the site, their nicks keep appearing in the list.
How can I reduce that time? For example, appear only based on users active over the past 15 minutes.

Heres my block code:
http://casinosonline.com.sapo.pt/block.txt
Find all posts by DivvyView user's profileSend private message
Divvy
Lieutenant
Lieutenant


Joined: Jul 25, 2004
Posts: 218


PostPosted: Sat Dec 29, 2007 10:23 am Reply with quoteBack to top

BUMP Smile

_________________
Sexo - Thongs - Legendas Divx
Find all posts by DivvyView user's profileSend private message
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.048 Seconds - 548 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::