woot!

I'll take 2! :D

i wasted 2 days for this query. Thank You so much!

Paul M,

I just installed ur Flashchat hacks, and when I read this thread, I think I have to install this top poster hack again. I mean, what a nice idea, what a work :)

I think this hack could be an extension (extended thinking) to the TopXStats hack:
https://vborg.vbsupport.ru/showthread.php?t=93065

I ve kept my eyes on all these Ranking hacks for a very long time, several coders have released diff. types of ranking hacks for 3.5. however, I think if there is a hack that comprehensively works like a BillBoard or a Ranking Board for the vBulletin. That would be nice for an online society.

Top Posters, Most Viewed Topics, Most Replied Topics and so on, they can be displayed in one table and shown on the forumhome, and also can be detailed in a special page as what u do for the top poster...

could u be the one to think about this?

cheers mate.

hopefully this thread still gives support.. cuz i just got this error trying to install it!

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
select count(*) as newposts from post where dateline >= 03:42 AM, 09-24-2005 and visible = 1;

anyway to fix this? or if not how do i unistall so i can get my forums back! i've re-traced you steps in the instructions & altered the SQL table with what you had ... but umm yea thats what im left with!

anyone

Erm, that sql code is nowhere in this hack, are you sure you posted in the right topic .......

i think so because i only got this error, immediately after i added the links in my navbar

but now i might have a bigger problem, i just dropped the whole dateline table in pHp my admin.. do you know how i can get that back lol

i want this code... just im pretty dumb wit certain things lol....... i can't believe i dropped that table .. i'm in for a long night

Paul M heres everything.... but i'm certain it had to be this code as it was the last before the site got the DB error

ok i had just installed my 3.5 again today! & i was installing a few minor hacks nuthing big but than i got to this hack:



https://vborg.vbsupport.ru/showthrea...t=92177&page=2



i followed the steps, did the SQL execution
so i wanted to see what it looked like on my site soon as i refreshed i had

this error:





went to my technical support email & had this:



Database error in vBulletin 3.5.0 Release Candidate 3:



so i thought i was all mister SMarTGuy went into pHp My admin, had no clue what i was doing & dropped the Dateline Table completely..



no the email is saying this:



so yeaaa i really screwed up & had no back up, as i didn't think i'd do something as dumb as this!!!! is there anyway to get my forums back

or am i going to have to start all over again... please tell me theres something i can do.... ANYTHING lol im Beggin

Sorry but that sql [for newposts] is simply not this hack - I would guess it's a hack to show a member the number of new posts since they last visited. It might help if you posted the whole message - since it should show has the script that called it.

As for dateline - that's a column in a table, not a table. You could probably recreate it with

ALTER TABLE post ADD dateline INT UNSIGNED NOT NULL DEFAULT '0'

But that won't recover the data it - all you posts would have a date of Jan1st 1970, and I doubt threads would show correctly. Don't you have a BACKUP ?

Oh, I have to go to bed now so I won't see any reply for a few hours.

Has anyone been able to write code to show the top average posters (ie. posters with highest 'posts per day')?

Realise this may be a 'messy' one to try but before I do, want to check if anyone else has been able to........