Hey there,

I'm trying to troubleshoot an issue with forwarding people from my forum install (Presstopia) to their User ID page (which accepts a connection via ?id=XX URL string). From Presstopia, I can easily output http://...?username=admin ; is there anything in DNN that can accept that connection, and translate into a userid, e.g., take the incoming ?username=admin and forward into ?id=1 ? 

Thanks for any & all suggestions!

--Dave

 
Hi, Dave-
You can do this with the free SQLView module from DNNStuff.  It is a SQL module that supports querystring parameters.  To get a user's ID you'd define a query in the module's configuration options similar to "select userid from users where username = '<querystring token>' ".  The module's config page has simple instructions for using tokens in your query.

Regarding forwarding the user to a URL, modify the query to return inline JavaScript to forward the window to the URL (including the querystring userid value).
 
I have a recent post on using a similar module, Advanced Datagrid, to create a means to forward users based on user roles:

   Create a "Login Redirection" module in a few easy steps with the (free) Advanced Datagrid module 
   http://www.eguanasolutions.com/DNN_Blog/EntryID/29.aspx
 
That example includes an example of inline Javascript from a query to forward users to a new page.
 
 
Cheers!
-mamlin

---

esmamlin atxgeek.me

 I haven't used it, or played with it at all - and this is basing it off of your SQL example (which may have been simplified from how it's actually done) - Do you have SQL Injection prevention inplace to make sure the <querystring token> isn't malicious, or can't behave maliciously?