Category Archives: Uncategorized

Role Based Access controll

Courtesy:: http://phpmaster.com/role-based-access-control-in-php/

CREATE TABLE roles (
  role_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  role_name VARCHAR(50) NOT NULL,

  PRIMARY KEY (role_id)
);

CREATE TABLE permissions (
  perm_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  perm_desc VARCHAR(50) NOT NULL,

  PRIMARY KEY (perm_id)
);

CREATE TABLE role_perm (
  role_id INTEGER UNSIGNED NOT NULL,
  perm_id INTEGER UNSIGNED NOT NULL,

  FOREIGN KEY (role_id) REFERENCES roles(role_id),
  FOREIGN KEY (perm_id) REFERENCES permissions(perm_id)
);

CREATE TABLE user_role (
  user_id INTEGER UNSIGNED NOT NULL,
  role_id INTEGER UNSIGNED NOT NULL,

  FOREIGN KEY (user_id) REFERENCES users(user_id),
  FOREIGN KEY (role_id) REFERENCES roles(role_id)
);

Scroller in javascript

// <![CDATA[
Beginning of JavaScript –

// CREDITS:
// Simple flying pop-up-window by Urs Dudli and Peter Gehrig
// Copyright (c) 2000 Peter Gehrig and Urs Dudli. All rights reserved.
// Permission given to use the script provided that this notice remains as is.
// Additional scripts can be found at http://www.24fun.ch.
// info@24fun.ch
// 2/8/2000

// IMPORTANT:
// If you add this script to a script-library or script-archive
// you have to add a link to http://www.24fun.ch on the webpage
// where this script Script will be running.

// **********************************************************************************
// **********************************************************************************
// INSTRUCTIONS:
// Configure the variables below

// The name of the pop-up-window. Do not change it
var popwindow

// The height of the pop-up-window (pixels)
var popwindowwidth=200

// The width of the pop-up-window (pixels)
var popwindowheight=150

// Distance to the top margin of the big window
var popwindowtop=20

// The URL of the HTML-file that contains the content of the pop-up-window
var popwindowURL="popupcontent.html"

// Standstill-time (seconds)
var waitingtime=4

// Configure ths speed of the pop-up-window
var pause=20
var step=40

// Do not change this variable
var popwindowleft=-popwindowwidth-50

// Do not change this variable
var marginright

// Do not change this variable
var pagecenter

// Do not change this variable
var timer

waitingtime= waitingtime*1000

function showWindow() {
popwindow = window.open(popwindowURL, "popwindow", "toolbar=no,width="+popwindowwidth+",height="+popwindowheight+",top="+popwindowtop+",left="+(-popwindowwidth)+"");
if (document.all) {
marginright = screen.width+50
}
if (document.layers) {
marginright = screen.width+50
}
pagecenter=Math.floor(marginright/2)-Math.floor(popwindowwidth/2)
movewindow()
}

function movewindow() {
if (popwindowleft<=pagecenter) {
popwindow.moveTo(popwindowleft,popwindowtop)
popwindowleft+=step
timer= setTimeout("movewindow()",pause)
}
else {
clearTimeout(timer)
timer= setTimeout("movewindow2()",waitingtime)
}
}

function movewindow2() {
if (popwindowleft