removing blank 'links' rows: WSN Support

removing blank 'links' rows
random links Toplist question

Version:

removing blank 'links' rows

knotworking
Experienced

Usergroup: Customer
Joined: Mar 31, 2004
Total Topics: 20
Total Posts: 83

Posted 07/10/05 - 10:07 AM:	#1
I've been tweaking my own toplist and, it all seems to be working swell. I am using the links table to generate random images from user albums. Here's the one issue I'm having: There are certain rows that do not link to an image. I'm assuming that this is because the user deleted the image but, the row remains in the table. The problem with this is these rows still get chosen in my toplist, here's the code: <CONFIG>links,rand(),2,ascending,,,,1,0,1,0</C ONFIG> Is there a way I can either: a) structure the code to only display rows with image links? b) run a scheduled maintainance on the table to remove rows without links? Oh, one more question to avoid multiple posts. I want to call random images (ala a toplist) on other pages within my site BUT outside of the gallery. Is there a way to do this? These other pages are .php pages (just created long before the gallery was implemented). Thanks, Paul!

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 56
Total Posts: 5844

Posted 07/10/05 - 06:08 PM:	#2
What version is this? Deleted items could remain in the table in 2.2, but not before, and in 2.2 they shouldn't show up in toplists. To use toplists outside the script see the javascript export, or you can adapt the 'custom template anywhere' hack into your php file if you can handle it.
_____________________ "Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

knotworking
Experienced

Usergroup: Customer
Joined: Mar 31, 2004
Total Topics: 20
Total Posts: 83

Posted 07/11/05 - 09:43 AM:	#3
I'm using 2.15. It's strange, I wonder if they could be failed uploads or something. I deleted several blank 'links' rows yesterday but, I'm thinking that might not be a good idea since the other tables might be trying to call those rows (even though they don't contain an image link). Another 2 rows just happened today. Looking them over, there's no information in the row at all, except for catid, IP, etc of the submitter. Very strange. Ever had this happen? BTW- I got the custom template hack working (I was worried reading over that one poster's difficulties). Is there a big/noticable savings on the server load time doing it this way vs. the javascript export method, in your experience? THANKS! Edited by knotworking on 07/11/05 - 04:13 PM

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 56
Total Posts: 5844

Posted 07/12/05 - 04:35 PM:	#4
The javascript export has to load two pages into a third page (it grabs the toplist page from the exporter php page in 2.15, though this is compressed to once step in 2.2) so it is noticably harder on the server than a simple php page toplist. I can't say I've ever seen blank rows. Sounds like maybe failed aliases of some sort... maybe attempts at adding an image from elsewhere in the gallery to somebody's album.
_____________________ "Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

knotworking
Experienced

Usergroup: Customer
Joined: Mar 31, 2004
Total Topics: 20
Total Posts: 83

Posted 07/12/05 - 09:53 PM:	#5
That's not good to hear; I like having common problems with answers I should already know. I noticed that they all have the correct IP for the CATID (checked the other corrosponding 'links' rows) so, it seems like the album owner was trying to submit something. Do you think it's safe to delete these rows or, will they still count against the total image number I've set for each member (and cause problems with rows that should be there and aren't)? Also, is there any way to run a quick cronjob-like check on the links tables (and delete rows with no image links)? Thanks, Paul!

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 56
Total Posts: 5844

Posted 07/13/05 - 05:57 AM:	#6
It's safe to delete them since they're not doing anything. A screenshot of your phpmyadmin might give me an idea though.
_____________________ "Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

knotworking
Experienced

Usergroup: Customer
Joined: Mar 31, 2004
Total Topics: 20
Total Posts: 83

Posted 07/13/05 - 12:49 PM:	#7
I sent some on over, can you make anything out from them?

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 56
Total Posts: 5844

Posted 07/13/05 - 09:50 PM:	#8
Where does "pirmary_email" come from? Other than that I don't see any hints in it.
_____________________ "Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

knotworking
Experienced

Usergroup: Customer
Joined: Mar 31, 2004
Total Topics: 20
Total Posts: 83

Posted 07/14/05 - 07:07 AM:	#9
That's their main email address from my prexisting database (it's in the integration file). That's not good news but, kinda what I was expecting. Can you tell me if it's possible to set up an automated cronjob-type check and removal of blank rows? I'll figure out how to do it, if it is (have to dust off the mysql book on my coffee table). I can't say that I've ever heard of wether that's possible or not.

You don't have permission to post.