-
Alpha Member
just edit the template.htm
-
Apprentice
Ok John, thx. I'm a noob sry.
Next question, when I goto the Ranking portion I get the thumbs up again with this error.
Sql_Error
SELECT top 50 [Character].Money, [Character].Name, [Character].cLevel, [Character].Class, [Character].CtlCode , isnull(Resets,0) as Resets, MEMB_STAT.ConnectStat, [Character].Strength, [Character].Dexterity, [Character].Energy, [Character].Vitality, AccountCharacter.GameIDC, GuildMember.G_Name, [Character].pkcount, [Character].Mana, [Character].Life, Character.accountid, Character.mu_id, Memb_info.bloc_code, Memb_info.memb__pwd, memb_info.modi_days, Character.MapNumber, [memb_info].addr_info, [memb_info].addr_deta , memb_info.post_code,memb_info.mail_chek, Character.LevelUpPoint, Memb_stat.* FROM Character LEFT OUTER JOIN MEMB_STAT ON Character.AccountID COLLATE Chinese_PRC_CS_AS = MEMB_STAT.memb___id LEFT OUTER JOIN AccountCharacter ON Character.AccountID COLLATE Chinese_PRC_CI_AS = AccountCharacter.Id LEFT OUTER JOIN Memb_info ON Character.AccountID COLLATE Chinese_PRC_CI_AS = memb_info.memb___id LEFT OUTER JOIN GuildMember ON Character.Name COLLATE Chinese_PRC_CI_AS = GuildMember.Name ORDER BY [Character].Resets DESC,[Character].cLevel DESC [nativecode=S0022 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Resets
Any thoughts?
-
Alpha Member
u should try read the install guide at my site..
dont try to be a pro.. by installing on ur own.
-
Apprentice
Yes Sir! lol
lol, It helps to do all the steps. Sry for all the mess.
Ok, when I edit the php.ini file to enable the dll's and changed the extension_dir to point to the right place. I restart IIS, then go to my site IIS give an error, that the dll could not be found.
I make the line "extension_dir = ./extensions
My php_mssql.dll and php_gd2.dll are in C:\php\extensions.
Did I miss something?
Error is "Unknown(): Unable to load dynamic library './extensions/php_gd2.dll' - The specific module could not be found."
Then get the same error for php_mssql.dll
Last edited by Aragus; 09-07-05 at 04:04 PM.
-
---
To Aragus :
extension_dir = "C:\php\extensions"
-
Apprentice
-
Enthusiast
Sql_Error
SELECT top 50 [Character].Money, [Character].Name, [Character].cLevel, [Character].Class, [Character].CtlCode , isnull(Resets,0) as Resets, MEMB_STAT.ConnectStat, [Character].Strength, [Character].Dexterity, [Character].Energy, [Character].Vitality, AccountCharacter.GameIDC, GuildMember.G_Name, [Character].pkcount, [Character].Mana, [Character].Life, Character.accountid, Character.mu_id, Memb_info.bloc_code, Memb_info.memb__pwd, memb_info.modi_days, Character.MapNumber, [memb_info].addr_info, [memb_info].addr_deta , memb_info.post_code,memb_info.mail_chek, Character.LevelUpPoint, Memb_stat.* FROM Character LEFT OUTER JOIN MEMB_STAT ON Character.AccountID COLLATE Chinese_PRC_CS_AS = MEMB_STAT.memb___id LEFT OUTER JOIN AccountCharacter ON Character.AccountID COLLATE Chinese_PRC_CI_AS = AccountCharacter.Id LEFT OUTER JOIN Memb_info ON Character.AccountID COLLATE Chinese_PRC_CI_AS = memb_info.memb___id LEFT OUTER JOIN GuildMember ON Character.Name COLLATE Chinese_PRC_CI_AS = GuildMember.Name ORDER BY [Character].Resets DESC,[Character].cLevel DESC [nativecode=S0022 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Resets
Help me
-
Apprentice
turk, i had that prob when i went to my ranking page
if u look in the instructions above it has some lines you have to inject into your MuOnline database. You do that in SQL's Query Analyzer.
Once I did that everything worked great.
See:
"DATABASE CHANGES and SQL QUeries to make ur Mutoolz work ok!
Use Muonline;
alter table Character add Resets int;
alter table Character add mu_id int identity;
go
run this on ur query analyser and u should be ok!"
-
Alpha Member
it really doesnt hurt to just read the instructions :)
-
Enthusiast
Thank you Aragus WorkSSS!!!! :)
-
Enthusiast
Account is Hybernating Mode! <<< What ?
-
Enthusiast
Array ( [auth_user] => turkmu [auth_pass] => 0+l8FvsGOI9KAXRi7FMoTwLvQz30ZkHnj4i0gyhoFo4= [SmartyPaginate] => Array ( [default] => Array ( [item_limit] => 20 [item_total] => 2 [current_item] => 1 [urlvar] => next [url] => index.php?name=l2&op=ranking&mode=&race= [prev_text] => Prev [next_text] => Next ) ) ) Array ( [PHPSESSID] => 03bd323d606d6f7b82ef98acb5cb250a ) Array ( [mu_id] => [mu_account] => turkmu [mu_char] => -=X=- [control] => Stats_Adder [submit] => Go Bebe )
:((
-
Alpha Member
hybernation is a protection feature .. when the account is not going to be used for a while
tukemo.. those are ddebug info.. turn $debug=1 in config.php into $debug = 0
-
Enthusiast
-
Apprentice
Jon or anyone, how to make sig.php show in forums?