Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

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