AutoHotkey Community

...well, not "built-in" but (are you using MySQL with this forum &) do you have phpMyAdmin? OR do you have telnet/ssh access to whoever hosts this site? (...& access to the mysql command on the unix command line?)

If so, open phpMyAdmin (& select the option to directly enter queries) or get to the mysql> command prompt &...

Guest topic_id: 1427
Guest post_id: 8439
ChrisM's user_id: 296
phpbb_ = the prefix you chose when setting up phpbb, default is phpbb_ (with the underscore)

To check all the current values before you change them...type/paste...

select * from phpbb_topics where topic_id = 1427;
select * from phpbb_posts where post_id = 8439;

Check necessary columns only (less clutter) (...on the command line...clutter might not matter in phpMyAdmin)...

select topic_id, topic_poster from phpbb_topics where topic_id = 1427;
select post_id, poster_id, post_username from phpbb_posts where post_id = 8439;

Update...

update phpbb_topics set topic_poster = 296 where topic_id = 1427;
update phpbb_posts set poster_id = 296 where post_id = 8439;

Non-guest posts don't have a post_username in the db (it gets the name from the phpbb_users table), it will work either way (if you leave it or not) but to sync everything up...

update phpbb_posts set post_username = '' where post_id = 8439;

_________________
AutoHotkey-Hotstring.ahk - Helping the world spell "AutoHotkey" correctly! (btw, it's a lowercase k!)

Thanks for the tips. However, due to concern about harming the relational integrity of the database, I'll probably avoid doing it. By "relational integrity" I mean that if I assign a guest post to a user, what if phpBB also maintains a post-count for each user? That count would then be wrong (unless I updated it too), which in turn might cause side-effects in any php code that relies on the post-count being correct.

In my extensive work with databases, I've seen some nightmare scenarios arise from seemingly innocuous changes to the data.

Yes, do that please. Thanks

_________________
ChrisM

Great Idea that script!

I'm using W2000, latest AHK and latest script version. Locale is Germany. My script path therefore has spaces within:


If I add some quotes ...


... it works a little bit, but Links won't be saved either. After giving the short name I only see the two standard menues below the thin line. Am I wrong? You all helped me always with all my silly questions. So I'm hoping again...

Peter

That should be fine, you don't need quotes.
Here's mine for example:This directory must exist first. The next version, which hopefully will be ready tonight, will create the directory for first time users. But for now you have to do it yourself.

_________________
ChrisM

The directory still exists already!

To make it clear: at the above mentioned config it won't work without quotes, with quotes it worked until the mentioned step.

Also within W98 it works not very well. I never see the results, despite the script tells, that the favourite has been saved. Default Dir is c:\ to be sure not to mix up failures.

Hope it helps


Peter

A new version of my script has been loaded on the first post of this thread!
It now supports submenus and all shortcut types - folders, files, executables and web pages. At least these are all the shortcut types I could think of.



Sorry, I only have WinXP so I can't test if it works with the other verisions of Windows. Try the new version of this script. Maybe that will fix it.

_________________
ChrisM

Thank you, ChrisM! This script is one of the most useful things running on my computer.

Hi ChrisM,

your nightmare again: It's me, Peter

Again:
f_shortcuts_folder = "c:\Eigene Dateien"
works.

f_shortcuts_folder = c:\Eigene Dateien
don't work at all (no response from the script).

A new Message after adding the quotes:
"The name xxx is not a legal filename. Try again."
What ever "xxx" might be.

Peter

Why paying about 150 bucks for a operating-system if you have a DOS with a graphical interface (XP vs. W98)

I get the same message as th post above. Ichanged my save folder to c:\favs and the script works well. I tested the original path with quotes and it works as well.

Usinh WinXP SP2 and 1.0.38.04

Ok, I found one bug which caused the base folder not to be made. This line:
was not at the end of the autoexecute section as it should have been.

I've updated the first post. Try it and report back if it solves your problems.

Thanks for pointing it out to me.

_________________
ChrisM

Hi Everyone:
A new version of the script is in the first post of this thread. I recommend you update if your using the one from Sept 20 or 22 /05.

Here's the changes:
Sept 24/05
- made static hotkey into dynamic hotkey
- made seperate option to show menu for unsupported windows ( not linked to ~ )
- fixed bug that caused long paths in the favorites folder to crash script
- fixed bug(s) that caused paths to be found for windows without focus sometimes

_________________
ChrisM

About the String2Hex/Hex2String thing. Ummm.. I don't really remember. It may have had to do with storing the folder paths in the submenu names. I'm sure I had some reason for it, but if it works for you without it then I guess there may be no need for it. I've never had the wrong-folder problem you described but then again I don't have that many things on my menu.

EDIT:

And all those thanking me for the idea, I can't really take credit for it. KDE has a universal-ish bookmarks menu that was the inspiration for this.

_________________
<enormous animated gif>

I've added the following few lines to f_Open (just after the `if' block testing the ConsoleWindowClass):



This then sends the appropriate `cd' command when running a unix-style shell in a cygwin Rxvt window (I use zsh, but the update should also work for bash). I also send an `ls' but this may not be to everyone's taste.

Thanks for the great script!

John.

Now, this is great. Thanks to all.

Probably a small bug, in my cpu, sometimes when attemtpting to switch within to a subfolder's shortctu item, I am redirected to the favorites folder, instead. Not a biggie, but worth reporting/double checking, i gather.

EDIT: now, this seems to occur when a shortcut's name is repeated in two or more places, the position of these shrotcuts within the folder strucutre notwithstanding.