observe wrote:the $username variable will prolly be set in your login script (maybe with a cookie or a SESSION)
Hell no.
Moderators: osRose dev team, ospRose dev team, osiRose dev team, Moderators
observe wrote:the $username variable will prolly be set in your login script (maybe with a cookie or a SESSION)
Calder wrote:Just outta curiosity why is that script querying by username instead of an id?
xadet3 wrote:observe wrote:the $username variable will prolly be set in your login script (maybe with a cookie or a SESSION)
Hell no.
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
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?
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
Return to PHP / Web Guides, Scripts and tools.
Users browsing this forum: No registered users and 8 guests