[Sharing] Working Sandurr's Clan System Version 2.0

Who knows to decide the problem of the entrance tax? In my server 500k is not charged

Hi, can anyone help me with this, on my high level list, when i click on it on website i get this error(s):

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E37)
Invalid object name 'LevelList'.
/functions/ranks.asp, line 38


Thanks in advance

Problem solved.....

hi i have a question while my fren and me trying setup the clan systems.

the lis2 cannot work, cannot access index asp. can anyone can help out on this?

simple, you dont have levellist table in sql ...
to fix, well.. i dont have here the script but u find here in forum ,,,, search it.. is in clandb

Removed.................

Problem resolved.. the culprit was the sql scripts that created the SQL Tables, make sure your Levellist table columns are listed as:

CharName \ varchar 50, CharLevel \ int, CharClass \ varchar 50, ID \ int

The script that came with my repack gave me some problems, be sure you download the Sandurr Clan 2.0 pack and use the SQL scripts in there, you will have to create the rPTDB manually and use the above table & columns...

got all my stuff in my server working 100% and stable now, I want to thank Ragezone, Sandurr, Quantumfusion, soonb offline priston tale and all the people that have took the time out to write guides to help us get our servers up and running.

^^

http://img504.imageshack.us/img504/6464/72292135.th.jpg

Quote:

---

Originally Posted by bbchamps2000

yes. but its error 11, not 58

---

Error 11 fix:
open command prompt and paste this in & hit enter:

Code:

---

cd  C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

---

now paste this in & hit enter:

Code:

---

aspnet_regiis /i

---

This will install ASP.net <2.0.50727>.

I made a batch file for it (called Error 11 Fix.bat) with these lines in it:

Code:

---

cd  C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
aspnet_regiis /i

---

So you can open it any time when Error 11 occurs.

Quote:

---

Originally Posted by microamazing

for peoples, use the 2000 SQL, don't need edit for conect using the tcp/ip!
and for peoples, use the 2005 SQL server, i make a mini tutorial, for use this!
see:
1) for the SQL Server 2005, conect the Host 127....... you need configure this! see the images...:
http://img182.imageshack.us/img182/6018/sqlzc0.jpg
2)and go to SQL Server "Configuration Manager", and make this:
http://img182.imageshack.us/img182/6...urationmu4.jpg
3)and go to "SQL Server Surface Area Configuration", and make this:
http://img413.imageshack.us/img413/9...ver2005yq3.jpg
ok... now your SQL 2005 are configured for hosts...
4)and you need configure the SQL.DLL! see:
you, pressures in your keyboard "CTRL+F",with the hexadecimal open! and you edit for your SQL name, see:
http://img142.imageshack.us/img142/8968/sqldll1wo7.jpg
5) now, you need edit the host, the dbID and DBPass see:
http://img142.imageshack.us/img142/6164/sqldll2ac8.jpg
!~!~!~!~!~!~!~!~!~!~!~ =D !~!~!~!~!~!~!~!~!~!~!~!~!
For sod ranks Work:
1)open your server...
2)and open "ClanSoDManager.exe" , and configure this:
http://img142.imageshack.us/img142/2456/sodsb7.jpg

3) making DB and configuring the .ASP Files!
3a) making DB, see:
http://img413.imageshack.us/img413/2209/db1tw7.jpg
3b)and,rigth click buton mause in Sod2Db> new Query ! ... and writhe the "SOD2RecBySandurr" Db, and, click in EXECUTE, and you see:
http://img355.imageshack.us/img355/8528/db2wz1.jpg
ok you SOD DB is creat!

3C) configuring the .ASP files!
see the images:
configure this file:
C:\Inetpub\wwwroot\ServerMain "SODsettings.asp" and "settings.asp"
C:\Inetpub\wwwroot\Clan "clanInsert.aspx"
C:\Inetpub\wwwroot\functions "database.asp"
see the image:
http://img100.imageshack.us/img100/7808/aspsg3.jpg
...
...
...

!~!~!~! now... go play =D !~!~!~!~!
Tnks Sandurr,shagpub, and Quantunfusion and... RPT, and the all people of Ragezone forum =D!
http://img100.imageshack.us/img100/5143/pagetz4.jpg

---

Does anyone have archives of these images? Plz upload them about how to setup SQL2005

Quote:

---

Originally Posted by stereostereo

Does anyone have archives of these images? Plz upload them about how to setup SQL2005

---

I believe these are it,

http://img35.imageshack.us/img35/841...lansyst.th.jpg
http://img34.imageshack.us/img34/841...lansyst.th.jpg
http://img196.imageshack.us/img196/8...lansyst.th.jpg
http://img35.imageshack.us/img35/677...ansysts.th.jpg
http://img7.imageshack.us/img7/8416/...lansyst.th.jpg
http://img196.imageshack.us/img196/8...ansystn.th.jpg
http://img190.imageshack.us/img190/8...lansyst.th.jpg
http://img34.imageshack.us/img34/561...ansysto.th.jpg
http://img33.imageshack.us/img33/841...lansyst.th.jpg

justosomebody Thank you so much! I'll try later.

Yes... only 1 image is missing, and it's the same image in each post... http://img413.imageshack.us/img413/9...ver2005yq3.jpg illustrating SQL surface area configuration... which IMHO is one of the most difficult parts to get right.

There are well paid people who do nothing but configure server surface area. ^_^ I dare say you could just open it for everything, but that's going to have a very hacked clan system pretty quick I suspect. :s

Finally my clan system is working maybe 100%!!
As bobsobol says, theres nothing to do with SQL configuration.
I just removed "ticket lines" as faHhH says,then error 9,12,19,24,37,52 passed!
Only one thing we have to do more than what faHhH wrote is removing ticket and CheckTicket lines in clanInsert.aspx too.

Quote:

---

Originally Posted by faHhH

I post that

LoL... Some errors to scripts are same...
Just find "TICKET" in files into folder "Server Main"
And remove it..

Remove ticket..
And
Checkticket xxxXxx

=D
Error(9)
Error(24)
Error(52)
And others 2 errors i forget... Into add members to clan and remove your self to clan..
But is same thing..
TICKET AND CHECKTICKET XXXX
^^

Just find this two lines
TICKET AND CHECKTICKET
And remove all =D

---

But.. top level players and Sod rankings dont work. I might mistake in making LevelList table. I need to add each column of CharName,CharLevel,CharClass and ID in LevelList talbes, right? and It seems that the program dosent write anything in Levellist and SOD2RecBySandurr,Im activating Clan SOD manager though.

Hi all !!!
can you help me error when install web site clan . use clansystem 2.0 files

error here
when i open IE >>>
http://i304.photobucket.com/albums/n...115/IMAGE1.jpg

I had editted file database.asp here

http://i304.photobucket.com/albums/n...5/IMAGE1-1.jpg

I play game clan ok !!! but I can't install web site
please help me !!!


Can you share for me file database.asp good ???
thanks !!!!

Erm... the error message in the first image suggests that the database.asp would work if your database was set up correctly.

Could it be that there is username / password hardcoded into database.asp which is different for your database?

Quote:

---

Originally Posted by bobsobol

Erm... the error message in the first image suggests that the database.asp would work if your database was set up correctly.

Could it be that there is username / password hardcoded into database.asp which is different for your database?

---

thanks bobsolbol very much !!!
I need file clan system full script and file.asp no error !
can you share for me ??
Thanks
full Files my clan system 2.0 no error had delete all
share for me clansystem 2.0 thanks much