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.
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).
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
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.
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).
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.
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.
0/5
1
2
3
4
5
Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.
Comments on VERY complicated toplist
Forum Regular
Usergroup: Customer
Joined: Nov 27, 2006
Total Topics: 187
Total Comments: 465
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.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
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).
Forum Regular
Usergroup: Customer
Joined: Nov 27, 2006
Total Topics: 187
Total Comments: 465
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
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
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.
Forum Regular
Usergroup: Customer
Joined: Nov 27, 2006
Total Topics: 187
Total Comments: 465
Thats right, could it work cross script?
How much would it cost?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
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).
Forum Regular
Usergroup: Customer
Joined: Nov 27, 2006
Total Topics: 187
Total Comments: 465
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
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
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.
Forum Regular
Usergroup: Customer
Joined: Nov 27, 2006
Total Topics: 187
Total Comments: 465
I want them all sorted together, not in seperate columns.
I want to use WSN scripts only, no third party scripts.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
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.