Please login or register.

Login with username, password and session length
Advanced search  

News:

Latest sNews - sNews 1.7 - with its own forums - for discussion and user mods.

Pages: 1 [2] 3

Author Topic: [MOD] User login using mysql mod. sNews 1.3  (Read 35163 times)

bryn

  • Hero Member
  • *****
  • Karma: 2
  • Posts: 934
    • http://www.cssugly.com
[MOD] User login using mysql mod. sNews 1.3
« Reply #15 on: December 13, 2005, 07:23:35 pm »
nice work mate! it'll be interesting to see how this develops..I'll be watching for sure ;)
Logged
Over 1,000 posts of joy, sNews is not only brilliant, but fun too! thanks guys :D

George Antoniadis

  • Sr. Member
  • ****
  • Karma: 0
  • Posts: 479
[MOD] User login using mysql mod. sNews 1.3
« Reply #16 on: December 13, 2005, 07:44:04 pm »
http://noodles.gr/sNews/sNews_1.3_pconnect-mod+user-db/

Ok... that's more like it... :) user modes are on and working...
admin/admin is the admin
test/test is just a user...

^_^
try create a user with admin and then login with it, and change the password... :)
admins can VIEW and EDIT all users and admin accounts...

I need some help... should the admin be able to create more admins? :/// or not?
Logged
How I feel like I'm starless, I'm ready to fade now.
And how I feel like I'm starless, I'm hopeless and greyed out.

bryn

  • Hero Member
  • *****
  • Karma: 2
  • Posts: 934
    • http://www.cssugly.com
[MOD] User login using mysql mod. sNews 1.3
« Reply #17 on: December 13, 2005, 10:04:21 pm »
maybe you could distinguish between Admins and SuperAdmins..the latter would have the ability to create Admins and Users..while Admins could only create Users? :)

I don't think Admins should be able to view, edit, or delete other Admin accounts..just my opinion ;D
Logged
Over 1,000 posts of joy, sNews is not only brilliant, but fun too! thanks guys :D

George Antoniadis

  • Sr. Member
  • ****
  • Karma: 0
  • Posts: 479
[MOD] User login using mysql mod. sNews 1.3
« Reply #18 on: December 14, 2005, 12:51:24 am »
Quote from: bryn
maybe you could distinguish between Admins and SuperAdmins..the latter would have the ability to create Admins and Users..while Admins could only create Users? :)

I don't think Admins should be able to view, edit, or delete other Admin accounts..just my opinion ;D

niiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiceeeeeeee~ ^_^
Thanks I'll do that~ :>

[edit] a question... Any reasons why admins should be able to see passwords?
I want to md5 the password so admins and users can only create new ones instead of admins being able to view the user's password...
So I'm wondering if I should make an option for md5 or plain text password... :/ opinions on that?
Logged
How I feel like I'm starless, I'm ready to fade now.
And how I feel like I'm starless, I'm hopeless and greyed out.

albert

  • Sr. Member
  • ****
  • Karma: 0
  • Posts: 405
    • http://www.oswt.co.uk/
[MOD] User login using mysql mod. sNews 1.3
« Reply #19 on: December 14, 2005, 08:48:02 am »
Hi

Just like to say good job with the login script, Luka will be happy.

ref the admin.

May be with SuperAdmin/ owner of the News  only he/she can see the  passwords. text password view.
But just Admin and users will not be able to see them. so md5.

Then there is what you would like them to do as well with sNews.(Admin and users) Not SuperAdmin
add aritical Yes No
dell aritical Yes No
dell comments Yes No


Albert
Logged
Albert
http://snews.awddesign.co.uk/snews/ site: v1.3
http://snews.awddesign.co.uk/           site: v1.2 http://www.awddesign.co.uk/
“Putting together the largest collection of sNews 1.5 designs. Coming very soon :)”

George Antoniadis

  • Sr. Member
  • ****
  • Karma: 0
  • Posts: 479
[MOD] User login using mysql mod. sNews 1.3
« Reply #20 on: December 14, 2005, 05:23:58 pm »
Albert thanks for a nice reply~ :)

Quote from: albert
May be with SuperAdmin/ owner of the News  only he/she can see the  passwords. text password view.
But just Admin and users will not be able to see them. so md5.

The thing is that md5 can't be reversed so it's either plain text or hashed...
Unless I include a two way encrption with a key... but it's just strain on the script...

Quote from: albert
Then there is what you would like them to do as well with sNews.(Admin and users) Not SuperAdmin
add aritical Yes No
dell aritical Yes No
dell comments Yes No

Ok so that's the way we are going~ ^_^
One more question... Should the super admin's username/password be hardcoded in the php file? like Luka has it now? Or mysql again?

This is very simple to do in any case... I've added a $_SESSION['Mode'] which can be "Admin", "User", SuperAdmin"... so in any place we need to check who can do something we just include this...

I'll probably wait a 1-2 days for 1.4 to come out (fingers crossed~ ^_^) cause I remember something about the 15th? :/ (or am I wrong?)
So I don't have to change the whooooole thing from scratch~ :)
Logged
How I feel like I'm starless, I'm ready to fade now.
And how I feel like I'm starless, I'm hopeless and greyed out.

albert

  • Sr. Member
  • ****
  • Karma: 0
  • Posts: 405
    • http://www.oswt.co.uk/
[MOD] User login using mysql mod. sNews 1.3
« Reply #21 on: December 14, 2005, 05:31:20 pm »
Hi analyzerx

Yah wait for 1.4 is out 1st then we can see how luka has coded  sNews 1.4.

i have some more designs to add too as well, so I wll wait...

Albert
Logged
Albert
http://snews.awddesign.co.uk/snews/ site: v1.3
http://snews.awddesign.co.uk/           site: v1.2 http://www.awddesign.co.uk/
“Putting together the largest collection of sNews 1.5 designs. Coming very soon :)”

Jochum Meester

  • Sr. Member
  • ****
  • Karma: 1
  • Posts: 309
    • JochumMeester.com
[MOD] User login using mysql mod. sNews 1.3
« Reply #22 on: January 19, 2006, 12:42:07 pm »
Not sure if I should've brought this back up, but I'd like to know if 1.4/2.0 supports multiple users. Is this also the idea behind this topic? Or is this topic about one user logging in using sql?
Anyway, I'd really like the possibility of multiple users.
Logged

George Antoniadis

  • Sr. Member
  • ****
  • Karma: 0
  • Posts: 479
[MOD] User login using mysql mod. sNews 1.3
« Reply #23 on: January 19, 2006, 01:53:05 pm »
This topic is for a mod that allows snews to have multiple users stored in mysql to login...
there is nothing said for native support in 1.4 for mysql users or multiple users.... :)

this mod is paused until 1.4 is released! :P
Logged
How I feel like I'm starless, I'm ready to fade now.
And how I feel like I'm starless, I'm hopeless and greyed out.

Patric Ahlqvist

  • Nobodys perfect, but Im pretty effing close
  • ULTIMATE member
  • ******
  • Karma: 65
  • Posts: 4867
  • “I'm a self-made man and worships my creator.”
    • p-ahlqvist.com
[MOD] User login using mysql mod. sNews 1.3
« Reply #24 on: January 21, 2006, 11:49:10 am »
but a great one it is ;). Hope it'll come to be a fact. I'll have use for it for sure.
Logged
"It's only dead fish that goes with the flow... "
Updated

George Antoniadis

  • Sr. Member
  • ****
  • Karma: 0
  • Posts: 479
[MOD] User login using mysql mod. sNews 1.3
« Reply #25 on: January 26, 2006, 08:50:32 pm »
this should be ready 2-3 days after the RC release of 1.4...
I've done some work on it on storing salted cookies, session managment, password retrieval etc...
User modes (root, moderator, author, user)
~root can add/edit/del users/posts/comments, mod can edit/del/add posts/comments, author can add/edit his comments/posts.
User will be used if users have to register to post comments...
Comment access

and I'm working in reading access...

this might not be nesesery for most ppl so it will come in 3 versions with features that one can upgrade between...! ^_^
Logged
How I feel like I'm starless, I'm ready to fade now.
And how I feel like I'm starless, I'm hopeless and greyed out.

George Antoniadis

  • Sr. Member
  • ****
  • Karma: 0
  • Posts: 479
[MOD] User login using mysql mod. sNews 1.3
« Reply #26 on: January 26, 2006, 09:30:59 pm »
this mod listed here is old and crappy! :P sorry about that! ^_^
Logged
How I feel like I'm starless, I'm ready to fade now.
And how I feel like I'm starless, I'm hopeless and greyed out.

George Antoniadis

  • Sr. Member
  • ****
  • Karma: 0
  • Posts: 479
[MOD] User login using mysql mod. sNews 1.3
« Reply #27 on: February 06, 2006, 03:26:51 pm »
hopefully 1.4 will be released this week... after the release add 1-2 days! ^_^
I'll PM you once it's done ok? ;)

just enable your mail notifications for pms
Logged
How I feel like I'm starless, I'm ready to fade now.
And how I feel like I'm starless, I'm hopeless and greyed out.

bryn

  • Hero Member
  • *****
  • Karma: 2
  • Posts: 934
    • http://www.cssugly.com
[MOD] User login using mysql mod. sNews 1.3
« Reply #28 on: February 06, 2006, 07:47:02 pm »
could you let us all know here 'a' please..this is something I'd like to play with or test also..and I'm sure others also..if you don't mind ;)
Logged
Over 1,000 posts of joy, sNews is not only brilliant, but fun too! thanks guys :D

Jochum Meester

  • Sr. Member
  • ****
  • Karma: 1
  • Posts: 309
    • JochumMeester.com
[MOD] User login using mysql mod. sNews 1.3
« Reply #29 on: February 16, 2006, 12:24:51 am »
*Bump*
Logged
Pages: 1 [2] 3
« previous next »