[REQUEST] Help with AutoUpdate Clan Status SoD2

[xhackx]

Could someon point me in the right direction on how to get SoD to automatically update the clan and personal stats and SoD owners? At the moment it is done manually. What am I forgetting to setup/do/etc. ?

 

[SiK]

You mean those scripts from the old rpt files?

 

[xhackx]

Yeah ^^ can you please point me in the right direction for the new stuff so I don't have to go through this hastle? lol

 

[shagpub]

like this ?

thanks Sandurr for writing this system

 

[macruz10]

like this ?

thanks Sandurr for writing this system

very good friend exactly you can share its modified archives all its database and its archives of clan with the community please friend this is my dream to have everything thus complete can help?

 

[xhackx]

Now, how can I get my server files to auto update without using scripts and setting up a system like that?

 

[shagpub]

the program save data to the database at specific tables you dont need to run the script

 

[xhackx]

I am still trying to figure out the flow of this server. I've noticed its not completely DB driven, which is really odd. I am an experienced programmer trying to figure this server and the way it works and how it saves its data. I really want to help this community in the best way I can, but first I need to learn everything about it, and that is what I am trying to do. So sorry if I sound like a complete nub. ^^

 

[glennx]

the program save data to the database at specific tables you dont need to run the script

it is possible to record personal sod score & update level list?

Clan list problem :

 

[xhackx]

Clan list problem :

Make sure you have the DB setup correctly, its telling you that the table column its trying to access does not exist. If it does exists try copying it exactly how it looks in the table design view into line 25 of clans.asp

 

[glennx]

hmm anyone have sandur clandb.sql? maybe because i'm using quantum clan...

 

[glennx]

nvm, look like the scripts are still missing some files that suppose to record sod score & update level list...

 

[glennx]

Make sure you have the DB setup correctly, its telling you that the table column its trying to access does not exist. If it does exists try copying it exactly how it looks in the table design view into line 25 of clans.asp

clans.asp

24	OpenConnection(dbname2)
25	RS.Open QUERY, objConn, 3, 1

database.asp

	dbname1 = "AccountDB"
	dbname2 = "ClanDB"
	dbname3 = "SoD2Db"

Did everything correctly...

 

[xhackx]

clans.asp

24    OpenConnection(dbname2)
25    RS.Open QUERY, objConn, 3, 1

Did everything correctly...

Show me what the QUERY var is. (QUERY = something)...it should show what database and table it is expecting.

 

[macruz10]

the program save data to the database at specific tables you dont need to run the script

you he is a great expert as you have the archives all in you have them but we do not obtain to decide the problems I know that work in looking for had much and to unmask the errors and that is hard to give the archives thus knows that you help very in progre

 

[luistorres]

please shagpub help comunity post clansystem scripts of tables =D

 

[xhackx]

Do XPT Server Files have this issue with the old style of using scripts? If not can someone link to XPT Server files?

 

[nguyenbason]

to update level ranking . Use multimanager.exe in rptserver . This will update all account lv to table levellist in database rptdb via sql.bizhostnet.com . updater.exe update to this database too

Change table levellist from accountdb to rptdb . Level ranking will work

 

[shagpub]

Do XPT Server Files have this issue with the old style of using scripts? If not can someone link to XPT Server files?

nope, just stand alone server files
@luistorres: I use all files from Dr.Green link so there is no point in uploading them here.

@to everyone who didnt get clan working
(if you are using Sandurr's SQL Script)
Error 9: Create column MIconCnt in table UL

 

[luistorres]

shagpub error 9 my tables arent no organized please read my pm!