|
Post by FunkySwerve on Sept 7, 2007 1:20:46 GMT
The script provided does work, unless you changed it or didn't compile after changing. Can you post the db creation script please? Want to see what you did exactly. Funky
|
|
|
Post by baaleos on Sept 7, 2007 1:28:53 GMT
// Name : Demo create table // Purpose : Create a table for persistent data // Authors : Ingmar Stieger // Modified : February 02, 2005
// This file is licensed under the terms of the // GNU GENERAL PUBLIC LICENSE (GPL) Version 2 // #include "aps_include"
void main() { SQLExecDirect("DROP TABLE pwdata"); SendMessageToPC(GetLastUsedBy(), "Table 'pwdata' deleted.");
// For SQLite /* SendMessageToPC(GetLastUsedBy(), "Creating Table 'pwdata' for SQLite..."); SQLExecDirect("CREATE TABLE pwdata (" + "player varchar(64) NOT NULL default '~'," + "tag varchar(64) NOT NULL default '~'," + "name varchar(64) NOT NULL default '~'," + "val text," + "expire int(11) default NULL," + "last timestamp NOT NULL default current_timestamp," + "PRIMARY KEY (player,tag,name)" + ")"); */ //For MySQL
SendMessageToPC(GetLastUsedBy(), "Creating Table 'pwdata' for MySQL..."); SQLExecDirect("CREATE TABLE pwdata (" + "player varchar(64) NOT NULL default '~'," + "tag varchar(64) NOT NULL default '~'," + "name varchar(64) NOT NULL default '~'," + "val text," + "expire int(11) default NULL," + "last timestamp NOT NULL default CURRENT_TIMESTAMP," + "PRIMARY KEY (player,tag,name)" + ") ENGINE=MyISAM DEFAULT CHARSET=latin1;");
// For Access /* SendMessageToPC(GetLastUsedBy(), "Creating Table 'pwdata' for Access..."); SQLExecDirect("CREATE TABLE pwdata (" + "player text(64)," + "tag text(64)," + "name text(64)," + "val memo," + "expire text(4)," + "last date)"); */
SendMessageToPC(GetLastUsedBy(), "Table 'pwdata' created."); }
I know its more a case of my nwnx doesnt want to connect to the database on my webserver.
I have put all the details in correctly.
Also, when i run nwnx on my local machine, it doesnt create any ... ANY log files resembling the normal ones. (eg it doesnt create any odbc)
Im having to get my friend over msn to test all this for me, while i alter the sql database.
azmodann_nwn 0.07 MB azmodann_Baaleos Above is the details of my Database and username
74.220.204.131 this is the ip address.... I dont need to use a port number do I?
|
|
|
Post by FunkySwerve on Sept 7, 2007 1:37:03 GMT
No, you don't need a port. At this point this is entirely about database connectivity, not SIMTools, so I have to point you to the nwnx forums, as I know next to nothing about such issues. Funky
|
|
|
Post by baaleos on Sept 20, 2007 10:16:23 GMT
Hi Funkster!! Me again...
I have simtools working, however, im getting strange errors when I use the command targeter, ive always had these errors, basically the command targeter makes 3 message appear when the command is initiated.
eg !playerinfo please select target use on myself or somone else "Command Targeter Error" "Command Targeter Error" <Insert Playerinfo here>
So, it does 2 errors, then it retrieves the requested information.
Im just wondering if you know what might be causing this?
Also, the !delete and other leto commands dont seem to be working. I have the leto dll installed, which came with the package, when I use the !delete command, it asks me to target somthing, or someone, I target myself, then it says "Invalid Command" I try it via tell /tp "Baaleos" !delete invalid command /tp "Baaleos" !delete qulvtukd Invalid Command
Is there any special things I need to do to enable the leto? i have set the servervault folder, and leto functions of shayan's subrace engine arnt used, so they cant be conflicting.
Im thinking that its possible that the same issue with the command targeter that im having might be the cause.
PS - I gave up on getting mysql working with the mod - seems bit backward to add an extra server reliance on the mod (especially when my webserver seems to be going down for 20 minutes each day...), why worry about 2 server's being up, when i can just have 1 server reliance, the one the mod is hosted on.
|
|
|
Post by FunkySwerve on Sept 20, 2007 22:58:28 GMT
What version of SIMTools are you using? The most recent addressed a number of bugs like the ones you describe. Funky
|
|
|
Post by baaleos on Oct 1, 2007 16:42:21 GMT
Hi funky, Sorry for delay, yeah, im using 3.1 simtools, I thought I might have been using 3.0 so, I downloaded, and installed 3.1 (or rather, the 3.0 to 3.1 patch) But it seems to make no difference.
Everything else is working, except for the leto functions, eg !delete and the commands to alter stats.
They just return with invalid command.
It should be noted, that all commands, even the ones that do work, eg !playerinfo gives 2 messages of invalid command, and then the 3rd message is the requested information.
Any idea's what could be causing this? I am using simtools in a "A world of Rhun" mod, which also has leto functions in it, however, these functions are disabled in shayans subrace engine, would this be causing it?
Thx
ps - this is the path to my servervault that i have put into the code. (the server company e-mailed me the details) D:\Jrollestnwn\servervault\
Am I meant to take the proceeding slash off? eg D:\Jrollestnwn\servervault
Im unsure what version I placed into the code, I am currently state-side, and have no access to my home pc to work on my mod. - Anyhelp would be greatly appreciated.
|
|
|
Post by FunkySwerve on Oct 1, 2007 17:25:41 GMT
Have you recompiled without errors since you reinstalled? Without that the scripts will run with their old compiles, showing no vault path and resulting in invalid commands and (I think) the targeter error you are seeing, which is a remnant of a bug in 3.0. Funky
|
|
|
Post by baaleos on Oct 1, 2007 18:20:23 GMT
I guess I will try that next time i get a chance, I will have to do it on my work's laptop, which is quite "low end" which means that a re-build of the scripts will take a long time.
(the module is about 120mb in size too)
I will see if i can do it, and if not, it means I will have to wait till i get back home in 2 weeks time.
|
|
|
Post by FunkySwerve on Oct 1, 2007 22:01:49 GMT
Rebuilding the scripts should not be time-consuming at all, IF your laptop can compile them without choking. Should only take a few minutes, if you select ONLY scripts (that's all you need for this) from the build menu. If the toolset crashes, you will need to get the PRC compiler, a much more effective and versatile compiler based on the Bioware one. Funky
|
|
|
Post by baaleos on Oct 9, 2007 3:46:54 GMT
Hi Funky. I managed to rebuild, and even got the database created at last. Thanks to the fact I have a second server now on a dedicated machine i can remote into.
I managed to get the Leto to work, sorta.... It boots me, but it doesnt make any alterations to my characters, and delete doesnt delete either. All the leto commands boot, but dont actually do anythin else, can u remind me the format of the directory string?
Also, in terms of the command targetter error, 2x error message, + requested command completed, apparently only myself has been able to see those errors. (I am an admin) Normal players have never seen those errors.
Ive done a rebuild of all scripts, no errors. Thanks, Im definitly getting closer to getting it working. ;oP
|
|
|
Post by FunkySwerve on Oct 9, 2007 4:33:20 GMT
Post your config script please. Funky
|
|
|
Post by baaleos on Oct 9, 2007 22:23:24 GMT
ive sent u a pm with as much of the config i could fit in.
Also, i might have got it wrong, its not invalid command that appears x2, its "command targetter error" that appears x2.
Im sure i have version 3.1 of simtools, in the config script, it mentions the 3.1 changes.
|
|
|
Post by FunkySwerve on Oct 9, 2007 23:05:37 GMT
Please post your fky_chat_target script. Funky
|
|
|
Post by baaleos on Oct 10, 2007 5:07:40 GMT
I dont remember making any alterations to this script, but here ya go.
Yes, safe delete was on, I prefer the idea of keeping players characters backed up in case they need them back.
The targeter error occurs on nearly all commands, !playerinfo , !delete, dm_rez, anything really that requires a target i guess.
However, commands that dont give the error seem to be dm_portthere, dm_porthere and so on.
Listing langauges, and switching between them does it too... However, from what my friend says, it only does it for me as an admin, because he doesnt see the errors himself. Could it be that myself as an admin can see errors he does not?
//::////////////////////////////////////////////////////////////////////////::// //:: SIMTools V3.0 Speech Integration & Management Tools Version 3.0 ::// //:: Created By: FunkySwerve ::// //:: Created On: April 4 2006 ::// //:: Last Updated: March 27 2007 ::// //:: With Thanks To: ::// //:: Dumbo - for his amazing plugin ::// //:: Virusman - for Linux versions, and for the reset plugin, and for ::// //:: his excellent events plugin, without which this update would not ::// //:: be possible ::// //:: Dazzle - for his script samples ::// //:: Butch - for the emote wand scripts ::// //:: The DMFI project - for the languages conversions and many of the emotes::// //:: Lanessar and the players of the Myth Drannor PW - for the new languages::// //:: The players and DMs of Higher Ground for their input and playtesting ::// //::////////////////////////////////////////////////////////////////////////::// #include "x2_inc_switches" #include "fky_chat_inc" void main() { if (GetUserDefinedItemEventNumber() == X2_ITEM_EVENT_ACTIVATE) { object oPC = GetItemActivator(); object oItem = GetItemActivated(); object oTarget = GetItemActivatedTarget(); location lTarget = GetItemActivatedTargetLocation(); // SetLocalString(oCPC, "FKY_CHAT_COMMAND", OBJECT_TARGET+COMMAND_SYMBOL + sNormalCase); string sCommand = GetLocalString(oPC, "FKY_CHAT_COMMAND"); string sReturnType = GetStringLeft(sCommand, 1); sCommand = GetStringRight(sCommand, GetStringLength(sCommand) - 1); if (sReturnType == AREA_TARGET_OK)//command requires an object input, but allows area objects and will default to the area if no object selected { DeleteLocalString(oPC, "FKY_CHAT_COMMAND"); if (GetIsObjectValid(oTarget)) { SetLocalObject(oPC, "FKY_CHAT_TARGET", oTarget); AssignCommand(oPC, SpeakString(sCommand)); } else { oTarget = GetArea(oPC); if (GetIsObjectValid(oTarget)) { SetLocalObject(oPC, "FKY_CHAT_TARGET", oTarget); AssignCommand(oPC, SpeakString(sCommand)); } else FloatingTextStringOnCreature(COLOR_RED+TARGETER_ERROR+COLOR_END, oPC, FALSE); //should never fire, debug } } else if (sReturnType == OBJECT_TARGET)//command requires an object input { DeleteLocalString(oPC, "FKY_CHAT_COMMAND"); if (GetIsObjectValid(oTarget)) { SetLocalObject(oPC, "FKY_CHAT_TARGET", oTarget); AssignCommand(oPC, SpeakString(sCommand)); } else FloatingTextStringOnCreature(COLOR_RED+TARGETER_ERROR2+COLOR_END, oPC, FALSE); } else if (sReturnType == LOCATION_TARGET)//command requires a location input { if (GetIsObjectValid(GetAreaFromLocation(lTarget))) { SetLocalLocation(oPC, "FKY_CHAT_LOCATION", lTarget); DeleteLocalString(oPC, "FKY_CHAT_COMMAND");//here we only delete if they selected a valid location - otherwise propmpt for retry AssignCommand(oPC, SpeakString(sCommand)); } else FloatingTextStringOnCreature(COLOR_RED+TARGETER_ERROR3+COLOR_END, oPC, FALSE); } else if (sReturnType == ITEM_TARGET)//command requires a location input { DeleteLocalString(oPC, "FKY_CHAT_COMMAND"); if (GetObjectType(oTarget) == OBJECT_TYPE_ITEM) { SetLocalObject(oPC, "FKY_CHAT_TARGET", oTarget); AssignCommand(oPC, SpeakString(sCommand)); } else { FloatingTextStringOnCreature(COLOR_RED+TARGETER_ERROR4+COLOR_END, oPC, FALSE); } } else { DeleteLocalString(oPC, "FKY_CHAT_COMMAND"); FloatingTextStringOnCreature(COLOR_RED+TARGETER_ERROR+COLOR_END, oPC, FALSE); //should never fire, debug } } SetExecutedScriptReturnValue(X2_EXECUTE_SCRIPT_END); }
|
|
|
Post by baaleos on Oct 10, 2007 5:09:54 GMT
Looking at the script above... could those errors i am seeing be debug messages? used for admins to debug the errors?
I see there are areas in the code to produce said errors, but supposedly they are never to fire?
|
|