Page 2 of 3

Re: [REQUEST] Character Status On Userpanel

PostPosted: Fri Jan 25, 2013 11:13 am
by xadet3
observe wrote:the $username variable will prolly be set in your login script (maybe with a cookie or a SESSION)

Hell no.

Re: [REQUEST] Character Status On Userpanel

PostPosted: Fri Jan 25, 2013 2:04 pm
by Calder
Just outta curiosity why is that script querying by username instead of an id?

Re: [REQUEST] Character Status On Userpanel

PostPosted: Fri Jan 25, 2013 2:34 pm
by observe
Calder wrote:Just outta curiosity why is that script querying by username instead of an id?

Both are unique si both can be used, further alit of cms system seem to use it in their login script

And the characters table (being used atm doesnt have the userID like the accounts table has)

this is just a simple script for example

Re: [REQUEST] Character Status On Userpanel

PostPosted: Fri Jan 25, 2013 2:35 pm
by observe
xadet3 wrote:
observe wrote:the $username variable will prolly be set in your login script (maybe with a cookie or a SESSION)

Hell no.


I know it's the most insecure way with that option but I've seen them xD

Re: [REQUEST] Character Status On Userpanel

PostPosted: Sun Feb 03, 2013 1:34 am
by rave
hu hu i tried but i fail anyone can code it for me?

Re: [REQUEST] Character Status On Userpanel

PostPosted: Tue Feb 05, 2013 9:48 pm
by Calder
observe wrote:
Calder wrote:Just outta curiosity why is that script querying by username instead of an id?

Both are unique si both can be used, further alit of cms system seem to use it in their login script

And the characters table (being used atm doesnt have the userID like the accounts table has)

this is just a simple script for example


Wait, wtf are we looking at here. Are you saying the character table references the account table via username rather than an id field?

Is this for the osRose db? Who needs a slapping for this db design? Is the username field at least indexed?

Re: [REQUEST] Character Status On Userpanel

PostPosted: Tue Feb 05, 2013 11:37 pm
by observe
Calder wrote:Wait, wtf are we looking at here. Are you saying the character table references the account table via username rather than an id field?

Is this for the osRose db? Who needs a slapping for this db design? Is the username field at least indexed?


yes that would be "Exactly" what im saying xD
Character has the account_name field instead of userID

Re: [REQUEST] Character Status On Userpanel

PostPosted: Wed Feb 06, 2013 2:22 pm
by rave
hu hu hu

masters please give me the exact code
for me to put
Info Of My Characters At My UserPanel

Re: [REQUEST] Character Status On Userpanel

PostPosted: Thu Feb 07, 2013 10:51 pm
by Calder
observe wrote:
Calder wrote:Wait, wtf are we looking at here. Are you saying the character table references the account table via username rather than an id field?

Is this for the osRose db? Who needs a slapping for this db design? Is the username field at least indexed?


yes that would be "Exactly" what im saying xD
Character has the account_name field instead of userID


Jesus >.<

Where is the download for this database? Really sounds like some optimization could go a long way towards performance.

Re: [REQUEST] Character Status On Userpanel

PostPosted: Fri Feb 08, 2013 1:42 am
by observe
Added a blank DB from Dev-Rev4 (its been the same all the way through)