Register for your free account! | Forgot your password?

You last visited: Today at 22:34

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

Db fixen für Dummi

Discussion on Db fixen für Dummi within the WoW Private Server forum part of the World of Warcraft category.

Reply
 
Old   #1
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: May 2010
Posts: 2
Received Thanks: 0
Db fixen für Dummi

Hallo zusammen,

wollte meinen eigenen kleinen Server erstellen. Habe mir hierzu Mangos Repack Version 6.33 (3.3.3a), Navicat, Mysql, und Hamachi besorgt. Server läuft soweit, Connecten über Hamachi ist auch kein Ding.
Die Db ist aber verbuggt.
Hab schon versucht einige Scripte zu adden, aber irgendwie will das Ding nicht so wie es soll. Manche scripte funzen, andere lassen sich über Navicat nicht adden.

So zum Beispiel dieses:

/* ScriptData
SDName: Instance_Trial_Of_the_Champion
SD%Complete: 100
SDComment:
SDCategory: Trial Of the Champion
EndScriptData */

#include "precompiled.h"
#include "trial_of_the_champion.h"

struct MANGOS_DLL_DECL instance_trial_of_the_champion : public ScriptedInstance
{
instance_trial_of_the_champion(Map* pMap) : ScriptedInstance(pMap) { Initialize(); }

uint32 m_auiEncounter[MAX_ENCOUNTER];
std::string m_strInstData;

uint64 m_uiJacobGUID;
uint64 m_uiAmbroseGUID;
uint64 m_uiColososGUID;
uint64 m_uiJaelyneGUID;
uint64 m_uiLanaGUID;
uint64 m_uiMokraGUID;
uint64 m_uiEresseaGUID;
uint64 m_uiRunokGUID;
uint64 m_uiZultoreGUID;
uint64 m_uiVisceriGUID;
uint64 m_uiChampionsLootGUID;
uint64 m_uiEadricGUID;
uint64 m_uiEadricLootGUID;
uint64 m_uiPaletressGUID;
uint64 m_uiPaletressLootGUID;
uint64 m_uiBlackKnightGUID;
uint64 m_uiJaerenGUID;
uint64 m_uiArelasGUID;
uint64 m_uiAnnouncerGUID;
uint32 m_uiChampionId1;
uint32 m_uiChampionId2;
uint32 m_uiChampionId3;
uint64 m_uiChampion1;
uint64 m_uiChampion2;
uint64 m_uiChampion3;
uint64 m_uiBlackKnightMinionGUID;
uint64 m_uiArgentChallenger;
uint64 m_uiArgentChallengerID;
uint64 m_uiMemoryGUID;

void Initialize()
{
m_uiJacobGUID = 0;
m_uiAmbroseGUID = 0;
m_uiColososGUID = 0;
m_uiJaelyneGUID = 0;
m_uiLanaGUID = 0;
m_uiMokraGUID = 0;
m_uiEresseaGUID = 0;
m_uiRunokGUID = 0;
m_uiZultoreGUID = 0;
m_uiVisceriGUID = 0;
m_uiChampionsLootGUID = 0;
m_uiEadricGUID = 0;
m_uiEadricLootGUID = 0;
m_uiPaletressGUID = 0;
m_uiPaletressLootGUID = 0;
m_uiBlackKnightGUID = 0;
m_uiJaerenGUID = 0;
m_uiArelasGUID = 0;
m_uiAnnouncerGUID = 0;
m_uiBlackKnightMinionGUID = 0;
m_uiChampionId1 = 0;
m_uiChampionId2 = 0;
m_uiChampionId3 = 0;
m_uiChampion1 = 0;
m_uiChampion2 = 0;
m_uiChampion3 = 0;
m_uiArgentChallenger = 0;
m_uiMemoryGUID = 0;
m_uiArgentChallengerID = 0;

memset(&m_auiEncounter, 0, sizeof(m_auiEncounter));
}

bool IsEncounterInProgress() const
{
for(uint8 i = 0; i < MAX_ENCOUNTER; ++i)
{
if (m_auiEncounter[i] == IN_PROGRESS)
return true;
}

return false;
}

void OnCreatureCreate(Creature* pCreature)
{
switch(pCreature->GetEntry())
{
// Champions of the Alliance
case NPC_JACOB:
m_uiJacobGUID = pCreature->GetGUID();
if (m_uiChampion1 == 0)
m_uiChampion1 = pCreature->GetGUID();
else
if (m_uiChampion2 == 0)
m_uiChampion2 = pCreature->GetGUID();
else
if (m_uiChampion3 == 0)
m_uiChampion3 = pCreature->GetGUID();
break;
case NPC_AMBROSE:
m_uiAmbroseGUID = pCreature->GetGUID();
if (m_uiChampion1 == 0)
m_uiChampion1 = pCreature->GetGUID();
else
if (m_uiChampion2 == 0)
m_uiChampion2 = pCreature->GetGUID();
else
if (m_uiChampion3 == 0)
m_uiChampion3 = pCreature->GetGUID();
break;
case NPC_COLOSOS:
m_uiColososGUID = pCreature->GetGUID();
if (m_uiChampion1 == 0)
m_uiChampion1 = pCreature->GetGUID();
else
if (m_uiChampion2 == 0)
m_uiChampion2 = pCreature->GetGUID();
else
if (m_uiChampion3 == 0)
m_uiChampion3 = pCreature->GetGUID();
break;
case NPC_JAELYNE:
m_uiJaelyneGUID = pCreature->GetGUID();
if (m_uiChampion1 == 0)
m_uiChampion1 = pCreature->GetGUID();
else
if (m_uiChampion2 == 0)
m_uiChampion2 = pCreature->GetGUID();
else
if (m_uiChampion3 == 0)
m_uiChampion3 = pCreature->GetGUID();
break;
case NPC_LANA:
m_uiLanaGUID = pCreature->GetGUID();
if (m_uiChampion1 == 0)
m_uiChampion1 = pCreature->GetGUID();
else
if (m_uiChampion2 == 0)
m_uiChampion2 = pCreature->GetGUID();
else
if (m_uiChampion3 == 0)
m_uiChampion3 = pCreature->GetGUID();
break;

// Champions of the Horde
case NPC_MOKRA:
m_uiMokraGUID = pCreature->GetGUID();
if (m_uiChampion1 == 0)
m_uiChampion1 = pCreature->GetGUID();
else
if (m_uiChampion2 == 0)
m_uiChampion2 = pCreature->GetGUID();
else
if (m_uiChampion3 == 0)
m_uiChampion3 = pCreature->GetGUID();
break;
case NPC_ERESSEA:
m_uiEresseaGUID = pCreature->GetGUID();
if (m_uiChampion1 == 0)
m_uiChampion1 = pCreature->GetGUID();
else
if (m_uiChampion2 == 0)
m_uiChampion2 = pCreature->GetGUID();
else
if (m_uiChampion3 == 0)
m_uiChampion3 = pCreature->GetGUID();
break;
case NPC_RUNOK:
m_uiRunokGUID = pCreature->GetGUID();
if (m_uiChampion1 == 0)
m_uiChampion1 = pCreature->GetGUID();
else
if (m_uiChampion2 == 0)
m_uiChampion2 = pCreature->GetGUID();
else
if (m_uiChampion3 == 0)
m_uiChampion3 = pCreature->GetGUID();
break;
case NPC_ZULTORE:
m_uiZultoreGUID = pCreature->GetGUID();
if (m_uiChampion1 == 0)
m_uiChampion1 = pCreature->GetGUID();
else
if (m_uiChampion2 == 0)
m_uiChampion2 = pCreature->GetGUID();
else
if (m_uiChampion3 == 0)
m_uiChampion3 = pCreature->GetGUID();
break;
case NPC_VISCERI:
m_uiVisceriGUID = pCreature->GetGUID();
if (m_uiChampion1 == 0)
m_uiChampion1 = pCreature->GetGUID();
else
if (m_uiChampion2 == 0)
m_uiChampion2 = pCreature->GetGUID();
else
if (m_uiChampion3 == 0)
m_uiChampion3 = pCreature->GetGUID();
break;

// Argent Challenge
case NPC_EADRIC:
m_uiEadricGUID = pCreature->GetGUID();
m_uiArgentChallenger = pCreature->GetGUID();
break;
case NPC_PALETRESS:
m_uiPaletressGUID = pCreature->GetGUID();
m_uiArgentChallenger = pCreature->GetGUID();
break;

// Black Knight
case NPC_BLACK_KNIGHT:
m_uiBlackKnightGUID = pCreature->GetGUID();
break;
case NPC_RISEN_JAEREN:
m_uiBlackKnightMinionGUID = pCreature->GetGUID();
break;
case NPC_RISEN_ARELAS:
m_uiBlackKnightMinionGUID = pCreature->GetGUID();
break;

// Coliseum Announcers
case NPC_JAEREN:
m_uiJaerenGUID = pCreature->GetGUID();
break;
case NPC_ARELAS:
m_uiArelasGUID = pCreature->GetGUID();
break;

// memories
case MEMORY_ALGALON:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_ARCHIMONDE:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_CHROMAGGUS:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_CYANIGOSA:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_DELRISSA:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_ECK:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_ENTROPIUS:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_GRUUL:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_HAKKAR:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_HEIGAN:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_HEROD:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_HOGGER:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_IGNIS:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_ILLIDAN:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_INGVAR:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_KALITHRESH:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_LUCIFRON:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_MALCHEZAAR:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_MUTANUS:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_ONYXIA:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_THUNDERAAN:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_VANCLEEF:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_VASHJ:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_VEKNILASH:
m_uiMemoryGUID = pCreature->GetGUID();
break;
case MEMORY_VEZAX:
m_uiMemoryGUID = pCreature->GetGUID();
break;
}
}

void OnObjectCreate(GameObject *pGo)
{
switch(pGo->GetEntry())
{
case GO_CHAMPIONS_LOOT:
m_uiChampionsLootGUID = pGo->GetGUID();
break;
case GO_EADRIC_LOOT:
m_uiEadricLootGUID = pGo->GetGUID();
break;
case GO_PALETRESS_LOOT:
m_uiPaletressLootGUID = pGo->GetGUID();
break;
case GO_CHAMPIONS_LOOT_H:
m_uiChampionsLootGUID = pGo->GetGUID();
break;
case GO_EADRIC_LOOT_H:
m_uiEadricLootGUID = pGo->GetGUID();
break;
case GO_PALETRESS_LOOT_H:
m_uiPaletressLootGUID = pGo->GetGUID();
break;
}
}

void SetData(uint32 uiType, uint32 uiData)
{
switch(uiType)
{
case DATA_TOC5_ANNOUNCER:
m_uiAnnouncerGUID = uiData;
break;
case DATA_CHAMPIONID_1:
m_uiChampionId1 = uiData;
break;
case DATA_CHAMPIONID_2:
m_uiChampionId2 = uiData;
break;
case DATA_CHAMPIONID_3:
m_uiChampionId3 = uiData;
break;
case DATA_ARGENT_CHALLENGER:
m_uiArgentChallengerID = uiData;
break;
case DATA_BLACK_KNIGHT_MINION:
m_uiBlackKnightMinionGUID = uiData;
break;
case TYPE_GRAND_CHAMPIONS:
m_auiEncounter[0] = uiData;
if (uiData == DONE)
{
if (GameObject* pChest = instance->GetGameObject(m_uiChampionsLootGUID))
if (pChest && !pChest->isSpawned())
pChest->SetRespawnTime(350000000);
}
break;
case TYPE_ARGENT_CHALLENGE:
m_auiEncounter[1] = uiData;
if (uiData == DONE)
{
if (m_uiArgentChallenger == m_uiEadricGUID)
if (GameObject* pChest = instance->GetGameObject(m_uiEadricLootGUID))
if (pChest && !pChest->isSpawned())
pChest->SetRespawnTime(350000000);
if (m_uiArgentChallenger == m_uiPaletressGUID)
if (GameObject* pChest = instance->GetGameObject(m_uiPaletressLootGUID))
if (pChest && !pChest->isSpawned())
pChest->SetRespawnTime(350000000);
}
break;
case TYPE_BLACK_KNIGHT:
m_auiEncounter[2] = uiData;
break;
}

if (uiData == DONE)
{
OUT_SAVE_INST_DATA;

std:stringstream saveStream;

for(uint8 i = 0; i < MAX_ENCOUNTER; ++i)
saveStream << m_auiEncounter[i] << " ";

m_strInstData = saveStream.str();

SaveToDB();
OUT_SAVE_INST_DATA_COMPLETE;
}
}

uint64 GetData64(uint32 uiData)
{
switch(uiData)
{
case DATA_CHAMPION_1:
return m_uiChampion1;
case DATA_CHAMPION_2:
return m_uiChampion2;
case DATA_CHAMPION_3:
return m_uiChampion3;
case DATA_MEMORY:
return m_uiMemoryGUID;
case DATA_BLACK_KNIGHT:
return m_uiBlackKnightGUID;
}

return 0;
}

uint32 GetData(uint32 uiType)
{
switch(uiType)
{
case DATA_CHAMPIONID_1:
return m_uiChampionId1;
case DATA_CHAMPIONID_2:
return m_uiChampionId2;
case DATA_CHAMPIONID_3:
return m_uiChampionId3;
case DATA_ARGENT_CHALLENGER:
return m_uiArgentChallengerID;
case DATA_BLACK_KNIGHT_MINION:
return m_uiBlackKnightMinionGUID;
case DATA_TOC5_ANNOUNCER:
return m_uiAnnouncerGUID;
case DATA_JAEREN:
return m_uiJaerenGUID;
case DATA_ARELAS:
return m_uiArelasGUID;
case TYPE_GRAND_CHAMPIONS:
case TYPE_ARGENT_CHALLENGE:
case TYPE_BLACK_KNIGHT:
return m_auiEncounter[uiType];
}

return 0;
}

const char* Save()
{
return m_strInstData.c_str();
}

void Load(const char* strIn)
{
if (!strIn)
{
OUT_LOAD_INST_DATA_FAIL;
return;
}

OUT_LOAD_INST_DATA(strIn);

std::istringstream loadStream(strIn);

for(uint8 i = 0; i < MAX_ENCOUNTER; ++i)
{
loadStream >> m_auiEncounter[i];

if (m_auiEncounter[i] == IN_PROGRESS)
m_auiEncounter[i] = NOT_STARTED;
}

OUT_LOAD_INST_DATA_COMPLETE;
}
};

InstanceData* GetInstanceData_instance_trial_of_the_champion(Map * pMap)
{
return new instance_trial_of_the_champion(pMap);
}

void AddSC_instance_trial_of_the_champion()
{
Script *newscript;
newscript = new Script;
newscript->Name = "instance_trial_of_the_champion";
newscript->GetInstanceData = &GetInstanceData_instance_trial_of_the_champion ;
newscript->RegisterSelf();
}


Was muss ich machen damit das Script korrekt in die DB gebatcht werden kann?
Bitte helft mir hier weiter, häng an dem Mist schon seit Tagen fest.

Danke vorab.
addi271978 is offline  
Old 05/16/2010, 10:09   #2
 
elite*gold: LOCKED
The Black Market: 3/0/0
Join Date: Apr 2009
Posts: 278
Received Thanks: 36
schonmal was von c++ gehört ?
wieso sollte navicat c++ scripte adden ?
salivaa is offline  
Old 05/16/2010, 22:35   #3
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: May 2010
Posts: 2
Received Thanks: 0
Ja sowas hab ich mir schon gedacht hat vielleicht jemand nen link für mich wie man das machen kann ich suche in der zeit schon mal forum und google ab nach scripts einbinden mit c++

DANKE
addi271978 is offline  
Reply

« 2.4.3 Server ? | Problem mit Char umbenennen.... »

Similar Threads Similar Threads
[HOW-TO]Itemshop-Bug fixen
09/29/2010 - Metin2 PServer Guides & Strategies - 8 Replies
Soooo, ich melde mich jetz auch mal wieder zu Wort. In diesem Tut zeige ich euch wie Ihr den weitverbreiteten Itemshopbug verhindern könnt. Als erstes erkläre ich euch die Funktionsweise des Itemshops also wie die Coins gespeichert werden: Die Coinsanzahl wird in einer sogenannten Session gespeichert, wie auch der Accountname und noch andere Sachen (insofern diese für die Homepage relevant sind also eingebaut wurden). Wie das Wort "Sessions" schon sagt ist es eine Sitzung. Eine...
Puzzle Event.Frage Vom Dummi:D
07/15/2010 - WarRock - 8 Replies
Hey Mal Ne Frage Welche Waffe bekommt man bei Puzzle Event? Ich Hab Gehört Dragunov, Dual Scorpiens, M134 Minigun, Clamory. Gibt es noch mehr und Wenn man Das Event 2 Mal Macht und die Gleich Waffe bekommt Hat sie dann 2Tage Oder 2mal?
loginserver fixen?
04/17/2010 - Metin2 Private Server - 3 Replies
SO, sufu spuckt nix aus, google nur ungültige themen, ich weis nicht wer den thread gemacht hat,... Naja suchen einen Thread in dem erklärt wird, wie ich loginserver einstelle das er automatisch startet wenn er eingeht. thx garantier =D
fixen vom cooldown
11/24/2007 - Kal Online - 10 Replies
theoretisch könnte man doch cooldown mit der engine so fixen :Man ändert den cooldown bei der engine von den attacken z.b. von 600000 auf 599999 oder so das macht ja eig. nix aus und das wird wohl keiner testen sagt was dazu :D mfg



All times are GMT +2. The time now is 22:34.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.