Version: 5.1.39
URL:
Print VERY complicated toplist | |
|
jayweb
Forum Regular Usergroup: Customer Joined: Nov 27, 2006 Total Topics: 131 Total Posts: 384 |
 #1
Is there a way to create a toplist that will pull data from more than one table on the database. I want to create a toplist that will show latest activity on the site, and will show latest listings, latest members, latest edits, latest images in one time ordered list. Even pulling latest forum posts from another script (wsn forum) in the same database. If not possible, can you think of a way to do this? Maybe a feed. |
|
Paul
developer  Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 65 Total Posts: 7614 |
#2
I don't understand how you want to associate those different things visually in a list -- what do they have to do with each other? Which would you put next to which? You can do an html <table> with toplists for all the things you've mentioned in columns, of course (or div floats). |
|
jayweb
Forum Regular Usergroup: Customer Joined: Nov 27, 2006 Total Topics: 131 Total Posts: 384 |
#3
Example... July 10 at 08.52 - jules regisers as a memeber July 10 at 08.54 - jules submits Jules Cakes Ltd to the directory July 10 at 08.55 - robbie submits a forum post title How to save money on your wedding July 10 at 08.55 - terry comments on Jules Cakes Ltd directory listing July 10 at 08.57 - lisa registers as a member |
|
Paul
developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 65 Total Posts: 7614 |
#4
I think what you want is an action-logging system that logs when people register and submit listings or comments. Then you want to show a toplist from that where memberid > 0 ordered by time descending. There's a stats mod that I think I could incorporate that into. |
|
jayweb
Forum Regular Usergroup: Customer Joined: Nov 27, 2006 Total Topics: 131 Total Posts: 384 |
#5
Thats right, could it work cross script? How much would it cost? |
|
Paul
developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 65 Total Posts: 7614 |
#6
Not sure what you mean by working cross-script. I could fairly easily make it so you're able to display a toplist of actions from a different WSN script in the same database (price that way is $95), but having the actions from the different scripts intermingled so that they sort together would be more difficult (price $130). |
|
jayweb
Forum Regular Usergroup: Customer Joined: Nov 27, 2006 Total Topics: 131 Total Posts: 384 |
#7
Ok I'll have that please. How do I pay, please send payment details to my email. It needs to be able to work with all wsn scripts, I will be buying a WSN kb later this month, so it needs to be able to work with links, forum and kb. It needs to be able to display he following events in time order decending... registrations link submits link edits link comments forum posts forum new topics Forum poll votes searches Thanks |
|
Paul
developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 65 Total Posts: 7614 |
#8
Which one do you mean, option 1 or 2? #2 I guess, all sorted together instead of in separate columns? You've just changed the requirements to double the number of things to track, adding link edits, poll votes and searches. That changes the prices to $115 for option 1 or $150 for option 2. Edited by Paul on 07/16/10 - 3:24 AM |
|
jayweb
Forum Regular Usergroup: Customer Joined: Nov 27, 2006 Total Topics: 131 Total Posts: 384 |
#9
I want them all sorted together, not in seperate columns. I want to use WSN scripts only, no third party scripts. |
|
Paul
developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 65 Total Posts: 7614 |
#10
Okay that's $150 then. If it goes according to plan I should have it done by the end of the weekend. I'll send it to the email address in your forum profile, so make sure it's up to date. |
Sorry, you don't have permission to post. Log in, or register if you haven't yet.