Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About CrimpJiggler

  • Rank
    Regular Member
  1. I read a security article a while ago that claimed it is dangerous to browse the web while you are logged into gmail, facebook, whatever because any website can get the profile ID of these accounts if you are logged into them. That sounds like bs to me, but the article seemed relatively legitimate so I'm wondering about this. Can you, with PHP or javascript get the profile ID of social media/whatever accounts a user is logged into?
  2. I just made this procedure which will do for now: DELIMITER $$ CREATE PROCEDURE rearrangeNodes(IN parentId INT) BEGIN DECLARE parentLft INTEGER; SET parentLft = (SELECT lft FROM table WHERE category_id = NEW.parentId); UPDATE `table` SET lft = CASE WHEN lft > parentLft THEN lft + 2 ELSE lft + 0 END, rght = CASE WHEN rght >= parentLft THEN rght + 2 ELSE rght + 0 END WHERE lft >= newLft; END$$
  3. I can't edit my post, I wanna ask a better question. Is there a simple way to make MySQL handle nested hierarchical database tables for you. My table has a parent_id, lft and rght value. CakePHP handles this automatically but does MySQL have built in functionality for that? If not, can anyone point me towards a simple stored procedure to do it? I know what I need to do, just find out whether the parent node is empty or not, if its empty then I expand it by 2, and shift everything to the left and right of it two. If its not empty, then I just shift everything from the start of the parent node to the right. There must be an automatic way to do it though.
  4. I'm using a CRUD system which won't automatically update the lft and rght values of my hierarchical tables when I enter a new row. I don't know what the best way to solve this is, all I can think of is adding a stored procedure to the table so that whenever a new row gets added, the procedure will make sure the lft and rght values get shifted. Is this even possible with stored procedures?
  5. I've played around with CakePHP, then XCrud (a decent CRUD application) but I gave up on both of them, XCrud was great for everything up until it came to managing complicated relational database tables. Anyhow, I'm using wordpress a lot now cuz it lets me stop reinventing the wheel so much and although I was able to integrate XCrud into WordPress as a plugin, I think the best way to go is just transfer my database tables to WordPress tables and display them as custom post types. My time is really limited right now though, is there a plugin/set of plugins I can use to automate the process? To show you what I mean, heres the XCrud list display of one of the tables: thats great because it automatically sets up the CRUD thing and lets you add and edit fields to the table, and doesn't heavily box you into their system but I have a table of plants, one for products, one for pharmacology, one for categories which are all related to each other, and some of them are structured in a tree/nested hierarchy structure so long story short, I need to do advanced searches based on these relations and handle these tree structured tables and CakePHP didn't work out, and XCrud has crappy documentation and isn't popular enough to find good info. So how would you go about transfering this system to WordPress? I'm guessing I need to make custom post types for each table but what I don't yet know is how to transfer the DB tables to WordPress format, how to handle the relationships between each table and how to handle the hierarchical tree structures.
  6. The first thing I learned after HTML and CSS is PHP. Its my primary language now, but I also use SQL and javascript and XML regularly, and since I use linux, I use bash scripting. The cool thing is they all work hand in hand. I recently learned how to use SQLite too, which is good because it can be accessed directly by javascript. Are there any other languages which would enable me to make new things and combine them with PHP scripts? I was looking into java but the security restrictions on applets make it pointless. Flash actionscript looks good. What about perl? Or ruby? Would they enable me to do things I can't easily do with PHP? I've heard about node.js recently a lot so I'm looking into that. Bash scripting is great, but the only issue is I could only use it on a server owned by myself, commercial servers won't let you execute commands like that. I'm interested in perl, python and java but I'll only learn them if they enable me to do things I can't do (easily) with PHP.
  • 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.