Age | Commit message (Collapse) | Author | Files | Lines |
|
User ranks are easy... but the language names are used everywhere!
|
|
There are a few things left hardcoded, though: The 'expand' link is also
in Javascript, that will probably need some mechanism for TL as well.
The format of the items on the homepage might need to change depending
on the language, I can imagine that not every language uses the 'title
by name' construct. Especially the age() function needs a localized
version.
|
|
I just can't believe using the English text as keys actually works,
English is useless without context.
|
|
Things are looking good so far.
|
|
|
|
You can ignore the entries in lang.txt, those are simply for testing
purposes.
|
|
|
|
|
|
|
|
To make sure we can still see a troll if he marks his list as hidden.
Only admins have this usermod privilege, and admins are assumed to have
raw SQL access anyway.
|
|
|
|
It's still not perfect, though:
- New version is table-based - meh.
- Uses negative margins more than once - meh!
- Only works if any of the columns has enough content to wrap. If all
content fits in the columns without wrapping, the total table width
falls back to the "min-width: 100%" statement - which, with the
negative margins, isn't really 100%. MEH!
Still... it looks better than the previous solution.
So far tested on FF3.5, Opera 9.something, and some semi-recent version
of webkit. Reported to work fine on IE7 as well.
|
|
This is how I should have done it in the first place. Don't use stupid
hacks if you know it's likely going to result in strange behaviour...
|
|
No need to, this will be cached in the DB, anyway.
|
|
|
|
timestamptz data types have sub-second precision, but we use time() with
second precision for comparing, resulting in false positives. Using
Time::HiRes::time should give the same precision as PostgreSQL's NOW(),
so things should be working fine now.
It's still a bad idea to use Multi's time instead of a PostgreSQL value
for comparing... should really think of a clean way of fixing this.
|
|
There's no need to disallow someone to edit their post within 30 seconds
after posting...
|
|
Everyone had access to the commands with the |8 flag enabled. Oops!
|
|
Requires the new PoCo-Pg
|
|
|
|
That was the last one. I hope I haven't forgotten to update anything.
|
|
Ideally, all tag relations should be removed when hiding a VN, but that
would make hiding a destructive action, while currently it can still be
reverted easilily.
|
|
|
|
Just a few more to go...
|
|
|
|
Everything still seems to be working fine so far.
|
|
I like how the rlists.added column isn't used anywhere in the code,
makes the conversion a lot easier. :-)
|
|
Anything fetched from the DB to Perl should be converted to a UNIX
timestamp, and everything that goes from Perl to the DB should be
converted from a UNIX timestamp to a timestamptz data type.
Also, when creating a session, don't rely on the fact that the
expiration default happens to be the same as the cookie expiration time
calculated in Perl. It's cleaner to calculate the date at one place and
then use that everywhere else.
|
|
Ideally, that shouldn't be necessary, but I can't think of a way to keep
the tags_vn_bayesian table up-to-date without a huge performance
penalty.
|
|
|
|
+ ChangeLog update
|
|
|
|
|
|
|
|
-- Removed unneeded export of previously deleted subroutine dbPostCheckDouble
|
|
-- Removed dbPostCheckDouble
-- Added more filters to dbPostGet to serve similar purpose
|
|
|
|
|
|
Everything has now finally been converted to use the PgSQL LISTEN/NOTIFY
feature. This commit removes the last Tie::ShareLite dependency.
|
|
|
|
'idle' is currently defined as 60+rand(300) minutes, so it'll only
occur in *very* idle channels... might be an idea to lower these numbers
later on.
|
|
|
|
|
|
Works as it did before. But maybe it's time to add a small throttle to
prevent misuse?
|
|
Tiny bug introduced in a recent commit.
|
|
And force this for some commands. Calling !die in a channel with
multiple bots isn't a good idea, after all...
|
|
|
|
Nothing beats seeing a:
<Multi> [t2.7] Reply to Alias: added Japanese title Posted in db,
u:retardsrox, u:nacchi, v:Natsu, Semi, Shoujo, v:Dal-eu Jajang-ga
By applehq @ http://beta.vndb.org/t2.7
|
|
Most of the functionality of the old IRC bot should be present again,
with notifications and the !vn command being the only exceptions. I'll
reimplement those later.
The configuration has changed a little:
- 'user' variable renamed to 'nick'
- 'channel' renamed to 'channels' (it's an arrayref, after all)
- the 'masters' variable now uses IRC masks rather than nicks
This new version also has three user levels rather than two: regular
users, OPs in the first channel, and 'masters'. This way #vndb OPs can
get control over some useful functions as well. The 'master' functions
are far too powerful and as such should only be used by the person
operating the bot.
|
|
-- Created a subroutine to check for any recent posts made by a user
-- Added double-post checking and error messages to the form
handler & html generator
|