Jump to content
  • 0

H>Rebirth System Debug,Error

chromus28

Asked by chromus28,

 Share

Question

chromus28 Poring

chromus28

Posted
  • Group:  Members
  • Topic Count:  91
  • Topics Per Day:  0.02
  • Content Count:  263
  • Reputation:   1
  • Joined:  04/25/13
  • Last Seen:  
Posted

guys what is the problem if im having this problem??

 

[Debug]: Source (NPC): Rebirth System at prontera (185,145)
: DB error - Table 'ragnarok.rebirth_system' doesn't exist
[Debug]: at script.c:15152 - insert into `rebirth_system` values ( 2000001, 'sdfgnsgn', '8', '114.17.201.213' ) on duplicate key update `num_rebirth` = `num_rebirth` +1
[Debug]: Source (NPC): Rebirth System at prontera (185,145)
[sql]: DB error - Table 'ragnarok.rebirth_system' doesn't exist
[Debug]: at script.c:15152 - insert into `rebirth_system` values ( 2000001, 'sdfgnsgn', '9', '114.17.201.213' ) on duplicate key update `num_rebirth` = `num_rebirth` +1
[Debug]: Source (NPC): Rebirth System at prontera (185,145)
 
here is my script
 

/*
CREATE TABLE IF NOT EXISTS `rebirth_system` (
`account_id` int(11) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL DEFAULT 'NULL',
`num_rebirth` int(11) unsigned NOT NULL default '0',
`last_ip` varchar(100) NOT NULL default '',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM;
*/

prontera,185,145,4	script	Rebirth System	403,{
function checkItem;            // check if player have all item required
function colorItemrequired;    // color the text. Red : not enough item, green otherwise
function deleteItem;        // delete all items required
function displayItemneed;    // display all items need at start
function getItemReward;        // give the items reward
function weightreq;            // check if your current weight is highter than weight high novice


    .@eac = eaclass();
    if ( num_rebirth == .reset_max ) {
        mes "You can only rebirth x"+ .reset_max +".";
        emotion e_gasp;
        close;
    }
    else if( NextJobExp || NextBaseExp || !( .@eac&EAJL_2 ) || !Upper ) {
        mes "You must be rebirth max level/max job level.";
        close;
    }

    mes "Items need :";
    displayItemneed();
    next;

    switch( select( "^777777~ Rebirth", "~ Informations", "~ Good bye^000000" ) ) {
        case 1:
            weightreq();
            checkItem();
            deleteItem();
            break;
        case 2:
            mes "You can only rebirth ^ff0000x"+ .reset_max +"^000000. You already rebirth ^ff0000x"+ num_rebirth +"^000000.";
            mes "Each rebirth you get ^ff0000"+ .num_status +"^000000 status points and after ^ff0000"+ .change_reward +"^000000 rebirth, you get only some items.";
            close;
        case 3:
            mes "Bye.";
            close;
    }
    num_rebirth += 1;
    if ( Upper ) {    // just in case the user change the setting...
        lastJob = roclass( .@eac&EAJ_UPPERMASK );
        jobchange Job_Novice_High;
    }
    else
        jobchange Job_Novice;
    resetlvl 1;
    if ( num_rebirth < .change_reward )
        StatusPoint = StatusPoint + .num_status * num_rebirth;
    else
        getItemReward();
    query_sql "insert into `rebirth_system` values ( "+ getcharid(3) +", '"+ escape_sql( strcharinfo(0) ) +"', '"+ num_rebirth +"', '"+ getcharip() +"' ) on duplicate key update `num_rebirth` = `num_rebirth` +1";
    announce "[ Rebirth system ] : "+ strcharinfo(0) +" rebirth for the "+ num_rebirth +" time !", 0;
    close;



function checkItem {
    for ( ; .@i < .size_item; .@i += 2 )
        if ( countitem( .item_req[.@i] ) < .item_req[ .@i+1 ] + num_rebirth ) {
            mes "You don't have enought "+ getitemname( .item_req[.@i] ) +". ^ff0000["+ countitem( .item_req[.@i] ) +"/"+ ( .item_req[ .@i+1 ] + num_rebirth ) +"]^000000";
            close;
        }
    if ( num_rebirth >= .change_reward )
        if ( .add_item_req[1] + num_rebirth - .change_reward > countitem( .add_item_req[0] ) ) {
            mes "You don't have enought "+ getitemname( .add_item_req[0] ) +". ^ff0000["+ countitem( .add_item_req[0] ) +"/"+ ( .add_item_req[1] + num_rebirth - .change_reward ) +"]^000000";
            close;
        }
    return;
}

function colorItemrequired {
    if ( countitem( .item_req[ getarg(0) ] ) < .item_req[ getarg(0)+1 ] + num_rebirth ) return "^ff0000";
    return "^00ff00";
}

function deleteItem {
    for ( ; .@i < .size_item; .@i += 2 )
        delitem .item_req[.@i], ( .item_req[ .@i+1 ] + num_rebirth );
    if ( num_rebirth >= .change_reward )
        delitem .add_item_req[0], ( .add_item_req[1] + num_rebirth - .change_reward );
    return;
}

function displayItemneed {
    for ( ; .@i < .size_item; .@i += 2 )
        mes colorItemrequired( .@i ) +" - x"+ ( .item_req[ .@i+1 ] + num_rebirth ) +" "+ getitemname( .item_req[.@i] );
    if ( num_rebirth >= .change_reward ) {
        if ( .add_item_req[1] + num_rebirth - .change_reward > countitem( .add_item_req[0] ) )
            .@color$ = "^ff0000";
        else
            .@color$ = "^00ff00";
        mes .@color$ +"- x"+ ( .add_item_req[1] + ( num_rebirth - .change_reward ) ) +" "+ getitemname( .add_item_req[0] );
    }
    return;
}

function getItemReward {
    for ( ; .@i < .size_reward; .@i += 2 )
        getitem .reward[.@i], .reward[ .@i+1 ];
    return;
}

function weightreq {
    if ( Weight > 20000 ) {
        mes "You have too much items on you. Your weight will be too high after rebirth.";
        close;
    }
    return;
}

OnInit:
    .reset_max = 9;        // how much reset max
    .change_reward = 10;    // after 30 rebirth, change reward
    .num_status = 100;        // + X number of status points

// item required <item ID>, <number>
    setarray .item_req, 501, 5,
                        502, 2,
                        503, 3;
    .size_item = getarraysize( .item_req );

// additionnal items after rebirth >> .change_reward
// <item ID>, <number>
    setarray .add_item_req, 601, 1;

// rewards <item ID>, <number>
    setarray .reward, 504, 1;
    .size_reward = getarraysize( .reward );
    end;
}

 

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

Brynner Metaling

Brynner

Posted
  • Group:  Members
  • Topic Count:  118
  • Topics Per Day:  0.03
  • Content Count:  1942
  • Reputation:   197
  • Joined:  01/08/12
  • Last Seen:  
Posted

 

guys what is the problem if im having this problem??

 

[Debug]: Source (NPC): Rebirth System at prontera (185,145)
: DB error - Table 'ragnarok.rebirth_system' doesn't exist
[Debug]: at script.c:15152 - insert into `rebirth_system` values ( 2000001, 'sdfgnsgn', '8', '114.17.201.213' ) on duplicate key update `num_rebirth` = `num_rebirth` +1
[Debug]: Source (NPC): Rebirth System at prontera (185,145)
[sql]: DB error - Table 'ragnarok.rebirth_system' doesn't exist
[Debug]: at script.c:15152 - insert into `rebirth_system` values ( 2000001, 'sdfgnsgn', '9', '114.17.201.213' ) on duplicate key update `num_rebirth` = `num_rebirth` +1
[Debug]: Source (NPC): Rebirth System at prontera (185,145)
 
here is my script
 

/*
CREATE TABLE IF NOT EXISTS `rebirth_system` (
`account_id` int(11) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL DEFAULT 'NULL',
`num_rebirth` int(11) unsigned NOT NULL default '0',
`last_ip` varchar(100) NOT NULL default '',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM;
*/

prontera,185,145,4	script	Rebirth System	403,{
function checkItem;            // check if player have all item required
function colorItemrequired;    // color the text. Red : not enough item, green otherwise
function deleteItem;        // delete all items required
function displayItemneed;    // display all items need at start
function getItemReward;        // give the items reward
function weightreq;            // check if your current weight is highter than weight high novice


    .@eac = eaclass();
    if ( num_rebirth == .reset_max ) {
        mes "You can only rebirth x"+ .reset_max +".";
        emotion e_gasp;
        close;
    }
    else if( NextJobExp || NextBaseExp || !( .@eac&EAJL_2 ) || !Upper ) {
        mes "You must be rebirth max level/max job level.";
        close;
    }

    mes "Items need :";
    displayItemneed();
    next;

    switch( select( "^777777~ Rebirth", "~ Informations", "~ Good bye^000000" ) ) {
        case 1:
            weightreq();
            checkItem();
            deleteItem();
            break;
        case 2:
            mes "You can only rebirth ^ff0000x"+ .reset_max +"^000000. You already rebirth ^ff0000x"+ num_rebirth +"^000000.";
            mes "Each rebirth you get ^ff0000"+ .num_status +"^000000 status points and after ^ff0000"+ .change_reward +"^000000 rebirth, you get only some items.";
            close;
        case 3:
            mes "Bye.";
            close;
    }
    num_rebirth += 1;
    if ( Upper ) {    // just in case the user change the setting...
        lastJob = roclass( .@eac&EAJ_UPPERMASK );
        jobchange Job_Novice_High;
    }
    else
        jobchange Job_Novice;
    resetlvl 1;
    if ( num_rebirth < .change_reward )
        StatusPoint = StatusPoint + .num_status * num_rebirth;
    else
        getItemReward();
    query_sql "insert into `rebirth_system` values ( "+ getcharid(3) +", '"+ escape_sql( strcharinfo(0) ) +"', '"+ num_rebirth +"', '"+ getcharip() +"' ) on duplicate key update `num_rebirth` = `num_rebirth` +1";
    announce "[ Rebirth system ] : "+ strcharinfo(0) +" rebirth for the "+ num_rebirth +" time !", 0;
    close;



function checkItem {
    for ( ; .@i < .size_item; .@i += 2 )
        if ( countitem( .item_req[.@i] ) < .item_req[ .@i+1 ] + num_rebirth ) {
            mes "You don't have enought "+ getitemname( .item_req[.@i] ) +". ^ff0000["+ countitem( .item_req[.@i] ) +"/"+ ( .item_req[ .@i+1 ] + num_rebirth ) +"]^000000";
            close;
        }
    if ( num_rebirth >= .change_reward )
        if ( .add_item_req[1] + num_rebirth - .change_reward > countitem( .add_item_req[0] ) ) {
            mes "You don't have enought "+ getitemname( .add_item_req[0] ) +". ^ff0000["+ countitem( .add_item_req[0] ) +"/"+ ( .add_item_req[1] + num_rebirth - .change_reward ) +"]^000000";
            close;
        }
    return;
}

function colorItemrequired {
    if ( countitem( .item_req[ getarg(0) ] ) < .item_req[ getarg(0)+1 ] + num_rebirth ) return "^ff0000";
    return "^00ff00";
}

function deleteItem {
    for ( ; .@i < .size_item; .@i += 2 )
        delitem .item_req[.@i], ( .item_req[ .@i+1 ] + num_rebirth );
    if ( num_rebirth >= .change_reward )
        delitem .add_item_req[0], ( .add_item_req[1] + num_rebirth - .change_reward );
    return;
}

function displayItemneed {
    for ( ; .@i < .size_item; .@i += 2 )
        mes colorItemrequired( .@i ) +" - x"+ ( .item_req[ .@i+1 ] + num_rebirth ) +" "+ getitemname( .item_req[.@i] );
    if ( num_rebirth >= .change_reward ) {
        if ( .add_item_req[1] + num_rebirth - .change_reward > countitem( .add_item_req[0] ) )
            .@color$ = "^ff0000";
        else
            .@color$ = "^00ff00";
        mes .@color$ +"- x"+ ( .add_item_req[1] + ( num_rebirth - .change_reward ) ) +" "+ getitemname( .add_item_req[0] );
    }
    return;
}

function getItemReward {
    for ( ; .@i < .size_reward; .@i += 2 )
        getitem .reward[.@i], .reward[ .@i+1 ];
    return;
}

function weightreq {
    if ( Weight > 20000 ) {
        mes "You have too much items on you. Your weight will be too high after rebirth.";
        close;
    }
    return;
}

OnInit:
    .reset_max = 9;        // how much reset max
    .change_reward = 10;    // after 30 rebirth, change reward
    .num_status = 100;        // + X number of status points

// item required <item ID>, <number>
    setarray .item_req, 501, 5,
                        502, 2,
                        503, 3;
    .size_item = getarraysize( .item_req );

// additionnal items after rebirth >> .change_reward
// <item ID>, <number>
    setarray .add_item_req, 601, 1;

// rewards <item ID>, <number>
    setarray .reward, 504, 1;
    .size_reward = getarraysize( .reward );
    end;
}

 

the error is the missing ragnarok.rebirth_system on your sql.

 

try to run this on your sql query.

CREATE TABLE IF NOT EXISTS `rebirth_system` (
`account_id` int(11) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL DEFAULT 'NULL',
`num_rebirth` int(11) unsigned NOT NULL default '0',
`last_ip` varchar(100) NOT NULL default '',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM;
Link to comment
Share on other sites
chromus28 Poring

chromus28

Posted
  • Group:  Members
  • Topic Count:  91
  • Topics Per Day:  0.02
  • Content Count:  263
  • Reputation:   1
  • Joined:  04/25/13
  • Last Seen:  
  • Author
Posted

guys what is the problem if im having this problem??

[Debug]: Source (NPC): Rebirth System at prontera (185,145)

: DB error - Table 'ragnarok.rebirth_system' doesn't exist

[Debug]: at script.c:15152 - insert into `rebirth_system` values ( 2000001, 'sdfgnsgn', '8', '114.17.201.213' ) on duplicate key update `num_rebirth` = `num_rebirth` +1

[Debug]: Source (NPC): Rebirth System at prontera (185,145)

[sql]: DB error - Table 'ragnarok.rebirth_system' doesn't exist

[Debug]: at script.c:15152 - insert into `rebirth_system` values ( 2000001, 'sdfgnsgn', '9', '114.17.201.213' ) on duplicate key update `num_rebirth` = `num_rebirth` +1

[Debug]: Source (NPC): Rebirth System at prontera (185,145)

here is my script


/*
CREATE TABLE IF NOT EXISTS `rebirth_system` (
`account_id` int(11) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL DEFAULT 'NULL',
`num_rebirth` int(11) unsigned NOT NULL default '0',
`last_ip` varchar(100) NOT NULL default '',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM;
*/

prontera,185,145,4	script	Rebirth System	403,{
function checkItem;            // check if player have all item required
function colorItemrequired;    // color the text. Red : not enough item, green otherwise
function deleteItem;        // delete all items required
function displayItemneed;    // display all items need at start
function getItemReward;        // give the items reward
function weightreq;            // check if your current weight is highter than weight high novice


    .@eac = eaclass();
    if ( num_rebirth == .reset_max ) {
        mes "You can only rebirth x"+ .reset_max +".";
        emotion e_gasp;
        close;
    }
    else if( NextJobExp || NextBaseExp || !( .@eac&EAJL_2 ) || !Upper ) {
        mes "You must be rebirth max level/max job level.";
        close;
    }

    mes "Items need :";
    displayItemneed();
    next;

    switch( select( "^777777~ Rebirth", "~ Informations", "~ Good bye^000000" ) ) {
        case 1:
            weightreq();
            checkItem();
            deleteItem();
            break;
        case 2:
            mes "You can only rebirth ^ff0000x"+ .reset_max +"^000000. You already rebirth ^ff0000x"+ num_rebirth +"^000000.";
            mes "Each rebirth you get ^ff0000"+ .num_status +"^000000 status points and after ^ff0000"+ .change_reward +"^000000 rebirth, you get only some items.";
            close;
        case 3:
            mes "Bye.";
            close;
    }
    num_rebirth += 1;
    if ( Upper ) {    // just in case the user change the setting...
        lastJob = roclass( .@eac&EAJ_UPPERMASK );
        jobchange Job_Novice_High;
    }
    else
        jobchange Job_Novice;
    resetlvl 1;
    if ( num_rebirth < .change_reward )
        StatusPoint = StatusPoint + .num_status * num_rebirth;
    else
        getItemReward();
    query_sql "insert into `rebirth_system` values ( "+ getcharid(3) +", '"+ escape_sql( strcharinfo(0) ) +"', '"+ num_rebirth +"', '"+ getcharip() +"' ) on duplicate key update `num_rebirth` = `num_rebirth` +1";
    announce "[ Rebirth system ] : "+ strcharinfo(0) +" rebirth for the "+ num_rebirth +" time !", 0;
    close;



function checkItem {
    for ( ; .@i < .size_item; .@i += 2 )
        if ( countitem( .item_req[.@i] ) < .item_req[ .@i+1 ] + num_rebirth ) {
            mes "You don't have enought "+ getitemname( .item_req[.@i] ) +". ^ff0000["+ countitem( .item_req[.@i] ) +"/"+ ( .item_req[ .@i+1 ] + num_rebirth ) +"]^000000";
            close;
        }
    if ( num_rebirth >= .change_reward )
        if ( .add_item_req[1] + num_rebirth - .change_reward > countitem( .add_item_req[0] ) ) {
            mes "You don't have enought "+ getitemname( .add_item_req[0] ) +". ^ff0000["+ countitem( .add_item_req[0] ) +"/"+ ( .add_item_req[1] + num_rebirth - .change_reward ) +"]^000000";
            close;
        }
    return;
}

function colorItemrequired {
    if ( countitem( .item_req[ getarg(0) ] ) < .item_req[ getarg(0)+1 ] + num_rebirth ) return "^ff0000";
    return "^00ff00";
}

function deleteItem {
    for ( ; .@i < .size_item; .@i += 2 )
        delitem .item_req[.@i], ( .item_req[ .@i+1 ] + num_rebirth );
    if ( num_rebirth >= .change_reward )
        delitem .add_item_req[0], ( .add_item_req[1] + num_rebirth - .change_reward );
    return;
}

function displayItemneed {
    for ( ; .@i < .size_item; .@i += 2 )
        mes colorItemrequired( .@i ) +" - x"+ ( .item_req[ .@i+1 ] + num_rebirth ) +" "+ getitemname( .item_req[.@i] );
    if ( num_rebirth >= .change_reward ) {
        if ( .add_item_req[1] + num_rebirth - .change_reward > countitem( .add_item_req[0] ) )
            .@color$ = "^ff0000";
        else
            .@color$ = "^00ff00";
        mes .@color$ +"- x"+ ( .add_item_req[1] + ( num_rebirth - .change_reward ) ) +" "+ getitemname( .add_item_req[0] );
    }
    return;
}

function getItemReward {
    for ( ; .@i < .size_reward; .@i += 2 )
        getitem .reward[.@i], .reward[ .@i+1 ];
    return;
}

function weightreq {
    if ( Weight > 20000 ) {
        mes "You have too much items on you. Your weight will be too high after rebirth.";
        close;
    }
    return;
}

OnInit:
    .reset_max = 9;        // how much reset max
    .change_reward = 10;    // after 30 rebirth, change reward
    .num_status = 100;        // + X number of status points

// item required <item ID>, <number>
    setarray .item_req, 501, 5,
                        502, 2,
                        503, 3;
    .size_item = getarraysize( .item_req );

// additionnal items after rebirth >> .change_reward
// <item ID>, <number>
    setarray .add_item_req, 601, 1;

// rewards <item ID>, <number>
    setarray .reward, 504, 1;
    .size_reward = getarraysize( .reward );
    end;
}
the error is the missing ragnarok.rebirth_system on your sql.

try to run this on your sql query.

CREATE TABLE IF NOT EXISTS `rebirth_system` (
`account_id` int(11) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL DEFAULT 'NULL',
`num_rebirth` int(11) unsigned NOT NULL default '0',
`last_ip` varchar(100) NOT NULL default '',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM;

sorry guide pls? noob here :(

Link to comment
Share on other sites
Emistry Deviling

Emistry

Posted
  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10015
  • Reputation:   2348
  • Joined:  10/28/11
  • Last Seen:  
Posted

Link to comment
Share on other sites
chromus28 Poring

chromus28

Posted
  • Group:  Members
  • Topic Count:  91
  • Topics Per Day:  0.02
  • Content Count:  263
  • Reputation:   1
  • Joined:  04/25/13
  • Last Seen:  
  • Author
Posted

So i just need to run that in Sql then its fine already?

Link to comment
Share on other sites
Patskie Santa Poring

Patskie

Posted
  • Group:  Members
  • Topic Count:  50
  • Topics Per Day:  0.01
  • Content Count:  1702
  • Reputation:   238
  • Joined:  09/05/12
  • Last Seen:  
Posted

Go try instead of asking others if it will get fine or not. Make sure you made a backup so you won't blame us if you mistakenly did it.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to question listing
×
×
  • Create New...