[Release] Rebirth of the Akropolis

[Exacute]

Looks sweat
Here, have an cookie
Btw cant load the video, if possible you would post an link to it

[Reflection]

Here's the link; [yt]9qtEqeBFtV4[/yt]

[Succy]

Thanks for all comments guys

Thanks Reflection for the video fix, I fixed it in the main thread too

The first update will probably be released this weekand!

[jerrkan]

Like always IMBA work Succy <3333
+rep x2 ofc

[MetaBob]

This sounds awesome, great work.

Although I cant run the Sql in my database.

This is the error I get:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minh' at line 5


To me, it looks correct. Any ideas?

[Succy]

Looks right, but you can try removing the whole "(`entry`, `minlevel`, `maxlevel`, `faction`, `minh' ...etc" and go so it is directly "'INSERT INTO `creature_proto`VALUES" Try that and then come back to me

[MetaBob]

Ok I done what you said, and it worked.

Untill I got to this entry:

INSERT INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) VALUES
	('940320','74','76','35','208902','208903','58750','1.2','2','1200',0,'5','6','0','0','0','0','36000','4589','0','0','2','0','0','0','1.2','0.5',' ','1',1558,'0','0','2.5','8','14',0,0,0,0,0,0,'0'),
	('920320','79','80','17','50700','50700','28800','1.5','0','1658',0,'2000','3250','0','0','0','0','36000','250','0','25','0','0','0','25','1.6','0.2','','1',25560,'0','0','2.5','8.1','14',0,0,0,0,0,0,'0');

So I decided to delete it out and see if it was only that one, but seems to be every entry from that one right down to the bottom.

[Reflection]

It seems to work perfectly for me.. However, this might fix it;

Open the query with notepad, press Ctrl+H to go to replace and in the find what box type

0,0,0,0,0,0,

and in the replace with box type

'0', '0', '0', '0', '0', '0',

Save, exit and then try to execute.

[MetaBob]

Ok I ran every entry seperatly and they all worked fine apart from

REPLACE INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) VALUES
	('940320','Agent Quicksand','The Saviors','Quest','0','7','0','0','0','0',23,0,0,0,'1','1',NULL,0),
	('920320','Jamahn the Great','King',' ','0','7','0','0','0','0',3351,3351,0,0,'1','1',NULL,0),

REPLACE INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) VALUES
	('940320','74','76','35','208902','208903','58750','1.2','2','1200',0,'5','6','0','0','0','0','36000','4589','0','0','2','0','0','0','1.2','0.5',' ','1',1558,'0','0','2.5','8','14','0', '0', '0', '0', '0', '0','0'),
	('920320','79','80','17','50700','50700','28800','1.5','0','1658',0,'2000','3250','0','0','0','0','36000','250','0','25','0','0','0','25','1.6','0.2','','1',25560,'0','0','2.5','8.1','14','0', '0', '0', '0', '0', '0','0');

REPLACE INTO `creature_quest_finisher` (`id`, `quest`) VALUES
	('940320','940320');

REPLACE INTO `creature_quest_starter` (`id`, `quest`) VALUES
	('940320','940320');

So I ran them in seperatly and deleted the , and ; of the values. All ran fine then.

Also did what Reflection said

EDIT: Hmm all the GO's seem to be in the wrong spots and halfway through walls etc. Is this for ArcEmu? :P

[Reflection]

REPLACE INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) VALUES
	('940320','Agent Quicksand','The Saviors','Quest','0','7','0','0','0','0', '23', '0', '0', '0', '1','1',NULL,0);
	('920320','Jamahn the Great','King',' ','0','7','0','0','0','0', '3351', '3351' , '0', '0', '1','1', 'NULL',0);

REPLACE INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) VALUES
	('940320','74','76','35','208902','208903','58750','1.2','2','1200',0,'5','6','0','0','0','0','36000','4589','0','0','2','0','0','0','1.2','0.5',' ','1',1558,'0','0','2.5','8','14','0', '0', '0', '0', '0', '0','0');
	('920320','79','80','17','50700','50700','28800','1.5','0','1658',0,'2000','3250','0','0','0','0','36000','250','0','25','0','0','0','25','1.6','0.2','','1',25560,'0','0','2.5','8.1','14','0', '0', '0', '0', '0', '0','0');

REPLACE INTO `creature_quest_finisher` (`id`, `quest`) VALUES
	('940320','940320');

REPLACE INTO `creature_quest_starter` (`id`, `quest`) VALUES
	('940320','940320');

Try that.

[Link_S]

Definitely +Rep.

[bishamo]

Awesome release. +Rep

Unfortunately I'm getting allot of dupe entries. Can we get an sql for that?

[Vindicated]

Looks nice mate It's S7! We never did our album! Oh well....

Anyways how did you get your graphics so fine and nice for WoW? +Rape btw

[chaoticd35]

This looks sweet!! Nice job!! +2 rep

[freehunternl123]

Wow looks cool nigh graphics