BeatsByDr.Dre 8 Report post Posted November 24, 2016 Hello Everyone, Just wanted to ask something. how to wipe a database? is there a query code to wipe database without touching the column names? Quote Share this post Link to post Share on other sites
Billy 164 Report post Posted November 24, 2016 Truncate table [table name]; 1 Quote Share this post Link to post Share on other sites
BeatsByDr.Dre 8 Report post Posted November 24, 2016 (edited) 1 hour ago, Billy said: Truncate table [table name]; Thanks!! Edited November 24, 2016 by BeatsByDr.Dre Quote Share this post Link to post Share on other sites
V3ct0r 2,117 Report post Posted November 24, 2016 Hello @BeatsByDr.Dre! Why not take clean database? Quote Some useful links / Полезные ссылки Tips for making a topic in 'Questions & Help' / Рекомендации по созданию тем в разделе "Помощь" Server Advertising Section Rules / Правила раздела "Реклама серверов" Available e-mail domains for registration / Допустимые e-mail домены для регистрации User groups / Группы пользователей User ranks / Звания пользователей "Broken" pictures on the forum / "Битые" изображения на форуме Beware of scammers! / Осторожно, мошенники! My developments / Мои разработки Mods for client and server / Моды для клиента и сервера PKOdev.NET website for Tales of Pirates Server / PKOdev.NET веб-обвязка для сервера Пиратии I do not provide any help in private messages and outside the forum. Use 'Questions & Help' section please. Thank you for understanding! Я не оказываю какую-либо помощь в личных сообщениях и вне форума. Пожалуйста, используйте раздел "Пиратия: Помощь". Благодарю за понимание! Share this post Link to post Share on other sites
BeatsByDr.Dre 8 Report post Posted November 24, 2016 7 minutes ago, V3ct0r said: Hello @BeatsByDr.Dre! Why not take clean database? i had a custom database with accounts and characters in it. i forgot where i put my custom database clean. so i cant. i really need to wipe and take a clean backup with it Quote Share this post Link to post Share on other sites
Vasil 71 Report post Posted November 24, 2016 Hello,since you guys talking about that, may you share a script that doesn't make the database jump after wiping from ID 1 to 11005 for example? Quote Share this post Link to post Share on other sites
Billy 164 Report post Posted November 24, 2016 https://msdn.microsoft.com/en-us/library/ms176057.aspx seriously, does no one know you can google questions? 1 Quote Share this post Link to post Share on other sites
Vasil 71 Report post Posted November 24, 2016 2 minutes ago, Billy said: https://msdn.microsoft.com/en-us/library/ms176057.aspx seriously, does no one know you can google questions? thanks blue sheep token Quote Share this post Link to post Share on other sites
V3ct0r 2,117 Report post Posted November 26, 2016 @BeatsByDr.Dre You also have to restore guild table (GameDB.dbo.guild). You can't just truncate it. You need to set all values of every guild to default ones. Quote Some useful links / Полезные ссылки Tips for making a topic in 'Questions & Help' / Рекомендации по созданию тем в разделе "Помощь" Server Advertising Section Rules / Правила раздела "Реклама серверов" Available e-mail domains for registration / Допустимые e-mail домены для регистрации User groups / Группы пользователей User ranks / Звания пользователей "Broken" pictures on the forum / "Битые" изображения на форуме Beware of scammers! / Осторожно, мошенники! My developments / Мои разработки Mods for client and server / Моды для клиента и сервера PKOdev.NET website for Tales of Pirates Server / PKOdev.NET веб-обвязка для сервера Пиратии I do not provide any help in private messages and outside the forum. Use 'Questions & Help' section please. Thank you for understanding! Я не оказываю какую-либо помощь в личных сообщениях и вне форума. Пожалуйста, используйте раздел "Пиратия: Помощь". Благодарю за понимание! Share this post Link to post Share on other sites
BeatsByDr.Dre 8 Report post Posted November 26, 2016 6 hours ago, V3ct0r said: @BeatsByDr.Dre You also have to restore guild table (GameDB.dbo.guild). You can't just truncate it. You need to set all values of every guild to default ones. what is the best way to wipe a customized database? Quote Share this post Link to post Share on other sites
Shako 97 Report post Posted November 26, 2016 (edited) 8 hours ago, BeatsByDr.Dre said: what is the best way to wipe a customized database? Create an identical copy by sql query Edited November 26, 2016 by Shako Quote Sunny Go! Online pko.host Share this post Link to post Share on other sites
BeatsByDr.Dre 8 Report post Posted November 26, 2016 1 hour ago, Shako said: Create an identical copy by sql query by doing that all columns will be in query right? and i will just ok ok got it. thank you! Quote Share this post Link to post Share on other sites
wolfenx 106 Report post Posted November 27, 2016 USAR ESTA QUERY USE GameDB update character set guild_id = 0,guild_stat = 0,guild_permission = 0 delete guild insert into guild (guild_id,guild_name,type) values(0,'Navy HQ3',0) insert into guild (guild_id,guild_name,type) values(1,'Navy Division 1',0) insert into guild (guild_id,guild_name,type) values(2,'Navy Division 2',0) insert into guild (guild_id,guild_name,type) values(3,'Navy Division 3',0) insert into guild (guild_id,guild_name,type) values(4,'Navy Division 4',0) insert into guild (guild_id,guild_name,type) values(5,'Navy Division 5',0) insert into guild (guild_id,guild_name,type) values(6,'Navy Division 6',0) insert into guild (guild_id,guild_name,type) values(7,'Navy Division 7',0) insert into guild (guild_id,guild_name,type) values(8,'Navy Division 8',0) insert into guild (guild_id,guild_name,type) values(9,'Navy Division 9',0) insert into guild (guild_id,guild_name,type) values(10,'Navy Division 10',0) declare @id int select @id = 11 while @id < 100 begin insert into guild (guild_id,guild_name,type) values(@id,'Navy Division '+convert(varchar(2),@id),0) select @id =@id +1 end insert into guild (guild_id,guild_name,type) values(101,'Pirate Guild 1',1) insert into guild (guild_id,guild_name,type) values(102,'Pirate Guild 2',1) insert into guild (guild_id,guild_name,type) values(103,'Pirate Guild 3',1) insert into guild (guild_id,guild_name,type) values(104,'Pirate Guild 4',1) insert into guild (guild_id,guild_name,type) values(105,'Pirate Guild 5',1) insert into guild (guild_id,guild_name,type) values(106,'Pirate Guild 6',1) insert into guild (guild_id,guild_name,type) values(107,'Pirate Guild 7',1) insert into guild (guild_id,guild_name,type) values(108,'Pirate Guild 8',1) insert into guild (guild_id,guild_name,type) values(109,'Pirate Guild 9',1) insert into guild (guild_id,guild_name,type) values(110,'Pirate Guild 10',1) select @id =111 while @id <200 begin insert into guild (guild_id,guild_name,type) values(@id,'Pirate Guild '+convert(varchar(2),@id-100),1) select @id =@id +1 end 1 Quote Discord:Wolfen#1498 https://www.patreon.com/ReTop Share this post Link to post Share on other sites