Change Question-id?

  • Hi,

    First: What a great plugin! It does exactly what I was searching for ??

    Is it possible to change the Question-ID somehow? I make puzzles and name them #1, #2 etc. So normally it would line up perfectly (question-ID=1 for puzzle #1). After a mistake I made, I deleted one question but the ID numbers goes on. Any possibility to recover it?

    Kind regards,
    Alex

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Alex Furr

    (@alexfurr)

    If you have access to the database you could manually change it in the tblQuestions database.

    Or you could try exporting all your questions to the CSV file, then deleting them frmo the live site, change the CSV file and try uploading again.

    Alex

    Thread Starter voslex

    (@voslex)

    Thanks for the reply! I think the first one would be the best/safest option?

    Should it be in this part of the code? I’m not really sure what to change:

    $table_name = $wpdb->prefix . “AI_Quiz_tblQuestions”;
    $sql = “CREATE TABLE “.$table_name.” (
    questionID int NOT NULL AUTO_INCREMENT,
    question longtext,
    qType varchar(255),
    potID int,
    incorrectFeedback longtext,
    correctFeedback longtext,
    creator varchar(255),
    createDate datetime,
    optionOrderType varchar (50),
    optionOrderType2 varchar (50),
    PRIMARY KEY (questionID)
    )”.$charSet;
    dbDelta($sql);

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Change Question-id?’ is closed to new replies.