Jump to content

Ibshas25

Members
 View Profile  See their activity

  • Posts

    53

  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

Ibshas25's Achievements

Member

Member (2/5)

0

Reputation

  1. Ibshas25
    i get this error when trying to perform a operation. ??? help [Method not found: 'System.Data.IDataReader INVU.Data.DataAccessLayer.SqlHelper.ExecuteReader(System.String, System.Object[,], System.Data.IsolationLevel, System.Data.IDbConnection ByRef, System.Data.IDbTransaction ByRef)'. Source: INVU.Business.Proxy Target: Inner: Stack: at INVU.Business.Proxy.Proxy.HandleException(Exception ex) at INVU.Business.Proxy.Proxy.HandleException(Exception ex, MethodBase mb, Object obj, Object[] parameters) at INVU.Business.Proxy.Node.IndexNodeAndRevisions(TemplateAttributeLink[] attribs, NodeData[] nodes, Int32 infoTypeId, Int32 templateId, NodeData newParent, Int32 secureLocationId, String workflowText, Boolean indexRevisions, NodeData[]& indexedRevisions) at INVU.Services.NodeAccess.Index(TemplateAttributeLink[] attribs, NodeData[] nodes, Int32 infoTypeId, Int32 templateId, NodeData newParent, Int32 secureLocationId) at INVU.Services.SecureAccessServer.File.ConvertMultipageDocumentEx(DocumentInfo docInfoIn, HashValue hashCode, ConvertMultipageDocumentInfo info) at INVU.Services.SecureAccessServer.File.ConvertMultipageDocument(DocumentInfo docInfo, HashValue hashCode, ConvertMultipageDocumentInfo info)Further information : Assembly Version : 6.4.1065.0 *** Environment *** Current directory : C:\Program Files\INVU Services Ltd\INVU6 Machine name : SPARE_0810 OS Version : Microsoft Windows NT 5.1.2600 Service Pack 3 Processor count : 2 Current user : IHassan Current user netbios domain name : EBP User interactive mode : True CLR version : 2.0.50727.3620 /]
  2. Ibshas25
    this is what i have tried on lines 79 to 89 but does not work <div style="OVERFLOW: auto; WIDTH: 350px; HEIGHT: 100px"> <span id="prjlist"></span> <h2><span></span></h2> <ul id="sliding-navigation"> </td></tr> <tr><td colspan="2"> <?php if($_SESSION[issysadmin]=="Y") { echo "<li class="sliding-element"><h3>Projects Page</h3></li> "; echo " <li class="sliding-element"><a href="UserSearchPBT.html">User Managment</a></li>"; echo " <li class="sliding-element"><a href="RolSearchPBT.html">Roles Managment</a></li>"; echo " <li class="sliding-element"><a href="teams1.html">Teams</a></li>"; </ul> } ?> </td></tr>
  3. Ibshas25
    lines 79 to 89 is where i want to add the above for styling on the page <?php error_reporting(E_ALL ^ E_NOTICE);?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title> Project Name List Menu </title> <link rel="stylesheet" type="text/css" href="stylespb.css" /> <script type="text/javascript" src="jquery-1.4.3.js"></script> <script type="text/javascript" src="jquery.json-2.2.js"></script> <script type="text/javascript" src="prjlistmenu.js"></script> <style type="text/css"> body { color:#999 font-size:12px; font-family:Arial, Helvetica, sans-serif; } form { display:block; width:260px; } form .input{ width:100px; float:right; } form label { width:260px; clear:both; text-align:right; white-space:nowrap; } form textarea { display:block; width:260px; } form .input_1_Chr { width:10px; float:left; } </style> </head> <?php session_start(); if ($_SESSION['isloggedin']=="Y") { echo "userid=".$_SESSION[userid]." user =".$_SESSION[user]; } else { // echo "invalid user now redirect to login page here"; header("Location: login.php"); exit; } ?> <body> <div id="navigation-block"> <img src="background.jpg" id="hide" /> <h2><span></span></h2> <p><h1> Project Name List Menu</h1></p> <form id="iletisim"> <div id="formdiv"> <table><tr><td colspan="2"><span id="successfailmessage"></span></td></tr> <tr><td colspan="2"> </td></tr> <tr><td colspan="2"> <div style="OVERFLOW: auto; WIDTH: 350px; HEIGHT: 100px"> <span id="prjlist"></span> </td></tr> <tr><td colspan="2"> <?php if($_SESSION[issysadmin]=="Y") { echo " <a href='RolSearchPBT.html'> <span> Role Management</span></a>"; echo "<a href='teams1.html'> <span> Teams Management</span></a>"; echo "<a href=''> <span> Methodology Management</span></a>"; } ?> </td></tr> </table> <input type="hidden" id= "prjid" value="0" name="prjid" /> <input type="hidden" id= "prjname" value="" name="prjname" /> <input type="hidden" id= "userid" value="<?php print $_SESSION[userid]; ?>" name="userid" /> </div> </form> </body> </html>
  4. Ibshas25
    i want to portray this code within echo but cant seem to get it to work specially with "LI classes" <ul id="sliding-navigation"> <li class="sliding-element"><h3>Projects Page</h3></li> <li class="sliding-element"><a href="UserSearchPBT.html">User Managment</a></li> <li class="sliding-element"><a href="RolSearchPBT.html">Roles Managment</a></li> <li class="sliding-element"><a href="teams1.html">Teams</a></li> <li class="sliding-element"><a href="">Methodologies</a></li> </ul>
  5. Ibshas25
    cant work out this mysql syntax error "operation":"medupdate","medid":"","name":"ibo","medyear":"5","medmonth":"21","medday":"1","recuser":1,"SuccFail":"fail","SuccFailMessage":"error occured You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''WHERE med_id=' at line 2","ResultData":""} $sql="update metodology set med_description='".$req['name']."', med_year='".$req['medyear']."', med_month='".$req['medmonth']."', med_day='".$req['medday']."', med_recorddate= now(), med_recorduserid= 1'"; $sql.= " WHERE med_id=".$req['medid'];
  6. Ibshas25
    where do i add this gif for it to work. currently i added it to the actually add button but doesnt seem to work... any ideas function useradd() { alert ("user add a geliyor"); //alert ("team add a geliyor"); var username = $("#username").attr("value"); var name = $("#name").attr("value"); var surname = $("#surname").attr("value"); var passwd1 = $("#passwd1").attr("value"); var email = $("#email").attr("value"); var phone = $("#phone").attr("value"); var mobphone = $("#mobphone").attr("value"); var issysadmin = $("#issysadmin").attr("value"); var isuseractive = $("#isuseractive").attr("value"); var data = { "operation" : "useradd", "username" : username, "name" : name, "surname" : surname, "password" : passwd1, "email" : email, "phone" : phone, "mobphone" : mobphone, "issysadmin" :issysadmin, "isuseractive" :isuseractive, "recuser" :1 } var dataString = $.toJSON(data); $.post('UserSearchPBT.php', { data: dataString}, useraddResult, "text"); } function useraddResult(res) { var obj = $.evalJSON(res); $("#successfailmessage").html(obj.SuccFailMessage); if (obj.SuccFail=="success") { $("#userid").val(""); $("#username").val(""); $("#name").val(""); $("#surname").val(""); $("#passwd1").val(""); $("#passwd2").val(""); $("#email").val(""); $("#phone").val(""); $("#mobphone").val(""); $("#issysadmin").val(""); $("#isuseractive").val(""); $("#useradd").show('<img src="indicator.gif" />'); $("#userlist").html(""); } //userlistgenerate(); }
  7. Ibshas25
    the error is now solved.. there was nothing wronge with the sql as i stated before even with the error was pointing towards this. when using a unix based system dreamweaver does not provide the code line breaking for unix. once doing this it all started to work. thanks for your feedback guys.
  8. Ibshas25
    the sql q works fine
  9. Ibshas25
    <b>Warning</b>: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/export/SOI-50/students/m2009/abhr428/web/WebIbs/prjlistmenuPBT.php</b> on line <b>36</ just cant seem to get this to work.. help????? <?php include("JSON.php"); require_once("connectdb.php"); $req = json_decode(stripslashes($_POST['data']), true); $req["SuccFail"]="fail"; $req["SuccFailMessage"]="Error Occured."; $req["ResultData"]=""; //$logFile = 'logFile'; //error_log("isl=baþladý: ", 3, $logFile); if ($req['operation'] == "prjsearch") // select için veri geldi { // error_log("isl==select oluþuyor: ", 3, $logFile); $sql= "SELECT pr.prj_id, pr.prj_projectname ,pr.prj_startdate,med_description, tea_rolId, "; $sql.=" DATE_FORMAT(prj_startdate,'%d-%m-%Y') as prj_startdate, DATE_FORMAT(prj_enddate,'%d-%m-%Y') as prj_enddate , CASE prj_iscompleted WHEN 'Y' THEN 'Completed' WHEN 'N' THEN 'Not Completed' else 'Undefined' end as prj_iscompleted from teams "; $sql.=" LEFT JOIN projects as pr ON prj_id = tea_projectid "; $sql.=" LEFT JOIN metodology as med ON med.med_id = pr.prj_metodid " ; $sql.=" WHERE tea_userId =".$req["userid"]; $sql.=" GROUP by pr.prj_id, pr.prj_projectname,pr.prj_startdate order by pr.prj_startdate desc "; //error_log($sql, 3, $logFile); $result = mysql_query($sql); $reslist = "<table border='1'><tr><th>Project Id</th><th>Name</th><th>Methodology</th><th>Start Date</th><th>End date</th><th>Condition</th></tr>"; while($row = mysql_fetch_array($result)) { // error_log("user: ".$row['usr_name']." surname :".$row['usr_username'], 3, $logFile); $reslist .= "<tr><td><a href='#'onclick='javascript:PrjSearchChoose(".$row['prj_id'].", ".$row['tea_rolId'].");' >".$row['prj_id']."</a></td><td>".$row['prj_projectname']."</td><td>".$row['med_description']."</td><td> ".$row['prj_startdate']."</td><td>".$row['prj_enddate']."</td><td>".$row['prj_iscompleted']."</td> </tr>"; } // error_log($reslist, 3, $logFile); // error_log("$reslist: ".$reslist, 3, $logFile); $reslist .= "</table>"; $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully selected."; //alert($reslist); $req["ResultData"]=$reslist; mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; } else if ($req['operation'] == "setuserrights") // set user rights { $sql= "select rol_projectMng, rol_teamsMng,rol_rolesMng,rol_usersMng,rol_metodMng,rol_ranklevel from roles where rol_Id = ".$req["rolid"]; // error_log($sql, 3, $logFile); $result=mysql_query($sql); $row=mysql_fetch_array($result); //if username exists if(mysql_num_rows($result)>0) { $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="user rights come."; //$row = mysql_fetch_array($result) //select rol_projectMng, rol_teamsMng,rol_rolesMng,rol_usersMng,rol_metodMng,rol_ranklevel from roles where rol_Id = 3 $_SESSION['projectMng']=$row['rol_projectMng']; $_SESSION['teamsMng']=$row['rol_teamsMng']; $_SESSION['rolesMng']=$row['rol_rolesMng']; $_SESSION['usersMng']=$row['rol_usersMng']; $_SESSION['metodMng']=$row['rol_metodMng']; $_SESSION['rol_ranklevel']=$row['rol_ranklevel']; $req["SuccFailMessage"]=$row['rol_projectMng'].$row['rol_teamsMng'].$row['rol_rolesMng'].$row['rol_usersMng'].$row['rol_metodMng'].$row['rol_ranklevel']; mysql_close($conn); //error_log($row['rol_ranklevel'].",".$row['projectMng'] , 3, $logFile); header("Content-type: text/plain"); echo json_encode($req); return; } else { header("Content-type: text/plain"); echo json_encode($req); //error_log("invalid", 3, $logFile); return; } } ?>
  10. Ibshas25
    i understand but to give access to certain pages would i need to put this code as well in the certain page e.g roles <?php if (isset($_SESSION['loggedUser'])) { echo 'You are logged in as: '.$_SESSION['loggedUser'].' <br>'; //echo '<a href="logoutPage1.php">Log out</a><br>'; //echo '<a href="profile_page.html">Jump to the Profile page</a><br>'; ?> <br> <INPUT TYPE="BUTTON" VALUE="Jump to the Project page" ONCLICK="window.location.href='projectBookAdmin.php'"> <?php } else { if (isset($usr_username)) { //if tried and failed to log in echo 'Could not log you in.<br>'; } else { // Have not tried to log in or have logged out echo 'You are not logged in.<br>'; } ?>
  11. Ibshas25
    so how would i set these sessions into my login page??????not sure where n what code to use 1-rol_projectMng` , sessionàisprojectadmin = rol_projectMng `rol_teamsMng` , sessionàisteamsadmin = rol_teamsMng `rol_rolesMng` , sessionàisrolesadmin = rol_rolesMng `rol_usersMng` , sessionàisusersadmin = rol_usersMng `rol_workBreakDowNMng` , sessionàworkbreakdowadmin = rol_workBreakDowNMng ` rol_DashboardMng ` , sessionàdashboardadmin = rol_DashboardMng ` usr_issysadmin ` , sessionàissysadmin = rol_DashboardMng ` rol_ranklevel ` , sessionàrolranklevel =rol_ranklevel <?php session_start(); if (isset($_POST['username']) && isset($_POST['password'])) { // if the user has just tried to log in $usr_username = $_POST['username']; $usr_password = $_POST['password']; //Connect to your Database $conn = mysql_connect("vega.soi.city.ac.uk", "", "") or die("Could not connect to MySQL Server: " . mysql_error()); //Select your Database mysql_select_db("abhr428") or die("Could not select database"); //form query $query = 'SELECT * FROM users WHERE usr_username = "'.$usr_username.'" AND usr_password = "'.$usr_password.'" '; //Execute query $result = mysql_query($query); //Count results $rowNo = mysql_num_rows($result); if ($rowNo > 0) { // if in the database register the user $_SESSION['loggedUser'] = $usr_username; mysql_free_result($result); mysql_close($conn); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <link href="stylesheet1.css" rel="stylesheet" type="text/css"/> <style type = "text/css"> #container { width: 250px; margin: auto; float:none; border:width:200px;height:100px;border:1px solid blue;"> } #logo1 { width: 250 px; height: 180 px; float:left; } h1 { font-size:8pt; } h2 { font-size:7px; } </style> </head> <body> <center> <div style="width:220px;height:260pt;border:5px solid #FFFFFF;"> <div id= "logo1"><img src="images/FINALlogo.jpg" width="60" height="50" /></div> <p><h1> Welcome to Project Book</h1></p> <h2> The methodology based mobile project management tool</h2> <br><a href="ProjectSignUp.php">Register</a></br> <?php if (isset($_SESSION['loggedUser'])) { echo 'You are logged in as: '.$_SESSION['loggedUser'].' <br>'; //echo '<a href="logoutPage1.php">Log out</a><br>'; //echo '<a href="profile_page.html">Jump to the Profile page</a><br>'; ?> <br> <INPUT TYPE="BUTTON" VALUE="Jump to the Project page" ONCLICK="window.location.href='projectBookAdmin.php'"> <?php } else { if (isset($usr_username)) { //if tried and failed to log in echo 'Could not log you in.<br>'; } else { // Have not tried to log in or have logged out echo 'You are not logged in.<br>'; } ?> <form method="post" action="projectBookF.php"> <table> <tr> <label> <td>Username: </td></label> <td><input type="text" name="username"></td> </tr> <tr> <label><td>Password: </td></label> <td><input type="password" name="password"></td> </tr> <tr> <td colspan="2" align="center"> <input type="submit" value="Log in"></td> </tr> </table> </form> </div> </center> <?php } ?> </div> </body> </html>
  12. Ibshas25
    i am getting this error below and i know its something small but cant see it.. help <b>Warning</b>: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/export/SOI-50/students/m2009/abhr428/web/WebIbs/projectSearchPBT1.php</b> on line <b>30</b><br /> <?php include("JSON.php"); require_once("connectdb.php"); $req = json_decode(stripslashes($_POST['data']), true); $req["SuccFail"]="fail"; $req["SuccFailMessage"]="Error Occured."; $req["ResultData"]=""; //$logFile = 'logFile'; // error_log("isl=baþladý: ", 3, $logFile); if ($req['operation'] == "projectsearch") // select için veri geldi { // error_log("isl==select oluþuyor: ", 3, $logFile); $sql= "select prj_id,prj_projectname,prj_metodid,prj_startdate, prj__enddate ,prj_iscompleted from projects "; // $sql.=" where (rol_id is null or rol_id = ". $req['rol'][0]['rolid']." ) and "; $sql.= "where (prj_projectname is null or prj_projectname like '". $req['prj'][0]['name']."%' ) "; $sql .= " order by prj_id"; // error_log($sql, 3, $logFile); $result = mysql_query($sql); //select rol_Id,rol_name,rol_projectMng,rol_teamsMng, rol_rolesMng ,rol_usersMng,rol_metodMng,rol_ranklevel,rol_recorddate,rol_recordId from roles where (rol_name is null or rol_name like '%' ) order by rol_name $reslist = "<table border='1'><tr><th>Project Id</th><th>Name</th><th>Project methof</th><th>Start Date</th><th> End date</th><th>Is project completed</th></tr>"; while($row = mysql_fetch_array($result)) { // rolid,name ,projectMng,teamsMng,rolesMng,usersMng,metodsMng,ranklevel // error_log("user: ".$row['usr_name']." surname :".$row['usr_username'], 3, $logFile); $reslist .= "<tr><td><a href='#' onclick='javascript:ProjectSearchChoose(".$row['prj_id'].", ".chr(34).$row['prj_projectname'].chr(34).",".chr(34).$row['prj_metodid'].chr(34).", ".chr(34).$row['prj_startdate'].chr(34).",".chr(34).$row['prj_enddate'].chr(34).",".chr(34).$row['prj_iscompleted'].");' >".$row['prj_id']."</a></td><td>".$row['prj_projectname']."</td><td>".$row['prj_metodid']."</td><td> ".$row['prj_startdate']."</td><td>".$row['prj_enddate']."</td><td>".$row['prj_iscompleted']."</td></tr>"; } // error_log($reslist, 3, $logFile); // error_log("$reslist: ".$reslist, 3, $logFile); $reslist .= "</table>"; $req["SuccFail"]="success"; //operation success or fail $req["SuccFailMessage"]="successfully selected."; //alert($reslist); $req["ResultData"]=$reslist; mysql_close($conn); header("Content-type: text/plain"); echo json_encode($req); return; } ?>
  13. Ibshas25
    cheers thats a geat example
  14. Ibshas25
    could you please give a simple example like the one ive posted please, as im still abit unsure thanks in advanced
  15. Ibshas25
    is this a good way of doing a simple admin different rights e.g if secret word then go to adminpage.php session_start(); $captcha = $_POST["captcha"] ; $secretword = $_SESSION["secretword"] ; if (strcmp( $captcha, $secretword )) { // it's a bot } else { // matched -- it's a human }
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.