 |
AutoHotkey Community
Let's help each other out
|
| View previous topic :: View next topic |
| Author |
Message |
JSLover
Joined: 20 Dec 2004
Posts: 542
Location: LooseChange911.com... the WTC attacks were done by the US Gov't... the official story is a lie...
|
 Posted: Sun Sep 18, 2005 9:19 am Post subject: |
 |
|
| Chris wrote: | | I don't think there's any built-in way to assign a guest post to a user |
...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;
_________________
Home • Click image! • Blog |
|
| Back to top |
|
 |
Chris
Site Admin
Joined: 02 Mar 2004
Posts: 10467
|
| Posted: Sun Sep 18, 2005 12:50 pm Post subject: |
|
|
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.  |
|
| Back to top |
|
|
ChrisM
Joined: 28 Nov 2004
Posts: 58
|
| Posted: Mon Sep 19, 2005 3:29 am Post subject: |
|
|
| Chris wrote: | | If you want, I can edit it to simply say "see below for latest version of script"; then you can edit your non-guest post that appears a little ways below it. |
Yes, do that please. Thanks
_________________
ChrisM |
|
| Back to top |
|
|
kapege.de
Joined: 07 Feb 2005
Posts: 186
Location: Munich, Germany
|
| Posted: Tue Sep 20, 2005 10:38 am Post subject: |
|
|
Great Idea that script!
I'm using W2000, latest AHK and latest script version. Locale is Germany. My script path therefore has spaces within:
| Code: | | f_shortcuts_folder = C:\Dokumente und Einstellungen\kapege\Eigene Dateien |
If I add some quotes ...
| Code: | | f_shortcuts_folder = "C:\Dokumente und Einstellungen\kapege\Eigene Dateien" |
... 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 |
|
| Back to top |
|
|
ChrisM
Joined: 28 Nov 2004
Posts: 58
|
| Posted: Tue Sep 20, 2005 2:30 pm Post subject: |
|
|
| kapege.de wrote: | My script path therefore has spaces within:
| Code: | | f_shortcuts_folder = C:\Dokumente und Einstellungen\kapege\Eigene Dateien |
|
That should be fine, you don't need quotes.
Here's mine for example: | Code: | f_shortcuts_folder = %USERPROFILE%\My Documents\Favorites
|
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 |
|
| Back to top |
|
|
kapege.de
Joined: 07 Feb 2005
Posts: 186
Location: Munich, Germany
|
| Posted: Tue Sep 20, 2005 2:38 pm Post subject: |
|
|
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 |
|
| Back to top |
|
|
ChrisM
Joined: 28 Nov 2004
Posts: 58
|
| Posted: Wed Sep 21, 2005 4:52 am Post subject: |
|
|
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.
| kapege.de wrote: | 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. |
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 |
|
| Back to top |
|
|
ML
Guest
|
| Posted: Wed Sep 21, 2005 4:03 pm Post subject: |
|
|
| Thank you, ChrisM! This script is one of the most useful things running on my computer. |
|
| Back to top |
|
|
kapege.de
Joined: 07 Feb 2005
Posts: 186
Location: Munich, Germany
|
| Posted: Wed Sep 21, 2005 9:30 pm Post subject: |
|
|
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) |
|
| Back to top |
|
|
aarondellis
Joined: 15 Aug 2005
Posts: 57
|
| Posted: Thu Sep 22, 2005 12:05 pm Post subject: |
|
|
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 |
|
| Back to top |
|
|
ChrisM
Joined: 28 Nov 2004
Posts: 58
|
| Posted: Thu Sep 22, 2005 4:03 pm Post subject: |
|
|
Ok, I found one bug which caused the base folder not to be made. This line:
| Code: |
;Also define a keyboard shortcut to the menu
^+f::GoSub, f_DisplayMenu
|
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 |
|
| Back to top |
|
|
ChrisM
Joined: 28 Nov 2004
Posts: 58
|
| Posted: Sat Sep 24, 2005 2:41 pm Post subject: |
|
|
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 |
|
| Back to top |
|
|
savage
Joined: 02 Jul 2004
Posts: 206
|
| Posted: Sat Sep 24, 2005 4:40 pm Post subject: |
|
|
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> |
|
| Back to top |
|
|
catweazle
Guest
|
| Posted: Sun Sep 25, 2005 8:07 pm Post subject: Extra support for rxvt windows |
|
|
I've added the following few lines to f_Open (just after the `if' block testing the ConsoleWindowClass):
| Code: | Else IfInString, f_class, Rxvt
{
WinActivate, ahk_id %f_window_id% ; Because sometimes the mClick deactivates it.
SetKeyDelay, 1 ; This will be in effect only for the duration of this Thread.
Send, cd `'%target%`'{Enter}
Send, ls{Enter}
Return
} |
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. |
|
| Back to top |
|
|
dmiranda
Joined: 02 May 2005
Posts: 12
|
| Posted: Tue Oct 11, 2005 9:38 am Post subject: |
|
|
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. |
|
| Back to top |
|
|
|
|
You can post new topics in this forum
You can reply to topics in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
