• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

Ascent warp npc

Initiate Mage
Joined
May 25, 2009
Messages
2
Reaction score
0
i am running a server with wow version 2.2.3 and i have an acent server. and every time i spawn and try to talk to a warp npc (what came with the repack the server shutsdown along wiht the command prompt window. below is the code for it
SELECT VERSION() ;
SHOW STATUS LIKE 'Uptime' ;
SHOW DATABASES ;
USE `ascent` ;
SHOW TABLES FROM `information_schema` ;
(SELECT TABLE_NAME AS `Name`, TABLE_TYPE AS `Type`, ENGINE AS `Engine`, VERSION AS `Version`, ROW_FORMAT AS `Row_format`, TABLE_ROWS AS `Rows`, AVG_ROW_LENGTH AS `Avg_row_length`, DATA_LENGTH AS `Data_length`, MAX_DATA_LENGTH AS `Max_data_length`, INDEX_LENGTH AS `Index_length`, DATA_FREE AS `Data_free`, AUTO_INCREMENT AS `Auto_increment`, CREATE_TIME AS `Create_time`, UPDATE_TIME AS `Update_time`, CHECK_TIME AS `Check_time`, TABLE_COLLATION AS `Collation`, CHECKSUM AS `Checksum`, CREATE_OPTIONS AS `Create_options`, TABLE_COMMENT AS `Comment` FROM `information_schema`.TABLES WHERE TABLE_SCHEMA = 'ascent') UNION (SELECT ROUTINE_NAME AS `Name`, ROUTINE_TYPE AS `Type`, NULL AS `Engine`, NULL AS `Version`, NULL AS `Row_format`, NULL AS `Rows`, NULL AS `Avg_row_length`, NULL AS `Data_length`, NULL AS `Max_data_length`, NULL AS `Index_length`, NULL AS `Data_free`, NULL AS `Auto_increment`, CREATED AS `Create_time`, LAST_ALTERED AS `Update_time`, NULL AS `Check_time`, NULL AS `Collation`, NULL AS `Checksum`, NULL AS `Create_options`, ROUTINE_COMMENT AS `Comment` FROM `information_schema`.ROUTINES WHERE ROUTINE_SCHEMA = 'ascent') ORDER BY `Name` ;
SHOW /*!32332 FULL */ COLUMNS FROM `creature_names` ;
SHOW KEYS FROM `creature_names` ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 0, 1000 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 1000, 1000 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 2000, 1000 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 4000, 1000 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 6000, 1000 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 7000, 1000 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 9000, 1000 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 10000, 1000 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 11000, 1000 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 12000, 1000 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 14000, 1000 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 13000, 1000 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 13000, 946 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 13000, 946 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 13000, 946 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 13000, 946 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 13000, 946 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 13000, 946 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 13000, 946 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 13000, 946 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 13000, 946 ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` LIMIT 13000, 946 ;
UPDATE `ascent`.`creature_names` SET `SpellDataID`='(NULL)' WHERE `entry`='23447' ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` WHERE `entry`='23447' ;
UPDATE `ascent`.`creature_names` SET `SpellDataID`='' WHERE `entry`='23447' ;
SELECT `entry`, LEFT(`creature_name`, 256), LEFT(`Subname`, 256), `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader` FROM `ascent`.`creature_names` WHERE `entry`='23447' ;

im using hidisql please help
 
Initiate Mage
Joined
Jan 25, 2011
Messages
1
Reaction score
0
vermont payday loan online

no fax payday loans online, , gary coleman cash advance commercial, , emergency cash advance search, , automobile accident cash advance loans, , information on cash advance payday loans, , no qualifications payday loans, , alabama cash advance payday loans software, , payday loans in michigan, , arkansas cash advance loan no fax, , florida ace cash advance, , massachusetts instant cash advance, , credit check payday cash advance, , massachusetts online cash advance loans, , fleming ny cash advance loan, , payday loan home loan mortgage, , advance advance cash company heir, , iowa cash advance utah, , cash advance payday cash loan preferredpaydayloan, , payday loan brokers, , cash advance paycheck advance personal loan,
 
Back
Top